CCPulse can't connect to DataMart DB

[Timur Karimov]

Hi All!

Check all forum message and find something, but all the same not working for me. So ask again. In newly installed test lab can't setup historical reporing by CCPulse. Setup all components by step-by-step reference deployment guide. And all worked, all but not an historical report in CCPulse. When i start CCPulse it's says "can't connect to configured DB server". Can anybody help me?

[CTIgem]

You have DAP set up and connected to CCPulse?

[siddharth.taneja]

You need to add to the 'Connections Tab' of CCPulse+:

1. Reporting StatServer.
2. DataMart Database Access Point.


It should be up and running.

Siddharth.

[arunkumar]

need clarification on this thing
1. can you able to view the online status in the ccpulse.
2. on the template design can you able to associate the colum name in the histroical tab


arun

[Timur Karimov]

Hi all

fanx for advice, but as i told later - i create everything as it describe by implementation guide. of course i add reporting statserver and damart DB DAP. and yes - i can able both - view the online status int the ccpulse and associate the column name to the historical tab by cca. but then i start ccp - it's show this f%$^&*@ message - can't connect to db =(

[CTIgem]

Can you post your db log?

[Timur Karimov]

[quote author=CTIgem link=topic=3576.msg15198#msg15198 date=1227012757]
Can you post your db log?
[/quote]
log level set as "debug". and here is for last day
"
00:00:41.851 Trc 04120 Check point 2008-11-18T00:00:41
01:00:41.859 Trc 04120 Check point 2008-11-18T01:00:41
02:00:41.874 Trc 04120 Check point 2008-11-18T02:00:41
03:00:41.889 Trc 04120 Check point 2008-11-18T03:00:41
04:00:41.903 Trc 04120 Check point 2008-11-18T04:00:41
05:00:41.918 Trc 04120 Check point 2008-11-18T05:00:41
06:00:41.948 Trc 04120 Check point 2008-11-18T06:00:41
07:00:41.962 Trc 04120 Check point 2008-11-18T07:00:41
08:00:41.977 Trc 04120 Check point 2008-11-18T08:00:41
09:00:41.990 Trc 04120 Check point 2008-11-18T09:00:41
10:00:41.994 Trc 04120 Check point 2008-11-18T10:00:41
11:00:42.009 Trc 04120 Check point 2008-11-18T11:00:42
12:00:42.023 Trc 04120 Check point 2008-11-18T12:00:42
13:00:42.038 Trc 04120 Check point 2008-11-18T13:00:42
14:00:42.052 Trc 04120 Check point 2008-11-18T14:00:42
15:00:42.067 Trc 04120 Check point 2008-11-18T15:00:42
16:00:42.081 Trc 04120 Check point 2008-11-18T16:00:42
"

hmm...it's look like no connection attempted ?

[Fra]

blin, CCPulse po-russki, kruto! 

Can you ping the hostname from the box where your CCPulse is installed?

[catanirex]

Hi,

Is the DBserver used by the DAP started?
If it is started, does the user that you log into CCP have Specia Access(Read/Execute) on that DAP and DBServer?

[Timur Karimov]

[quote author=Fra link=topic=3576.msg15201#msg15201 date=1227016616]
blin, CCPulse po-russki, kruto! 

Can you ping the hostname from the box where your CCPulse is installed?
[/quote]

and GAD on russian to =)

yes, i can ping it. i can open network shared folder for templates storage. try setup another copy of CCP on server with db - same result =( maybe CCP try connect to wrong port number or samething ? but why ?!

[Timur Karimov]

[quote author=catanirex link=topic=3576.msg15204#msg15204 date=1227024204]
Hi,
Is the DBserver used by the DAP started?
[/quote]
yes, indeed !
[quote author=catanirex link=topic=3576.msg15204#msg15204 date=1227024204]
If it is started, does the user that you log into CCP have Specia Access(Read/Execute) on that DAP and DBServer?
[/quote]
member of super administrator group that have full control rights on complete solution =(

it's like as same kind of mysticism......

[cavagnaro]

Can you connect to the port of the DBServer from your PC? Do a telnet to that port and you should be able to connect, also, can you resolve by name the server? If not try adding the servers name to your hosts file and try again.

[Timur Karimov]

Hi all
well..i found what i seting up wrong/ when i creating new DAP for access to ETL DB - i choise server and choise different(free) port.  And CCpulse trying connect to this port. But, i must choise the port number equal to port number on ETL DB server. Delete DAP, create new DAP and choise port equal to DB server port. After it all work propetly - CCpulse start wit out any warning and error message and we can create historical report.

Fanx to everyone to push me in right direction.