Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: Timur Karimov on November 13, 2008, 09:43:56 AM

Title: CCPulse can't connect to DataMart DB
Post by: Timur Karimov on November 13, 2008, 09:43:56 AM
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?
Title: Re: CCPulse can't connect to DataMart DB
Post by: CTIgem on November 13, 2008, 01:32:41 PM
You have DAP set up and connected to CCPulse?
Title: Re: CCPulse can't connect to DataMart DB
Post by: siddharth.taneja on November 14, 2008, 02:09:17 PM
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.

Title: Re: CCPulse can't connect to DataMart DB
Post by: arunkumar on November 15, 2008, 08:36:09 AM
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
Title: Re: CCPulse can't connect to DataMart DB
Post by: Timur Karimov on November 18, 2008, 12:01:50 PM
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 =(
Title: Re: CCPulse can't connect to DataMart DB
Post by: CTIgem on November 18, 2008, 12:52:37 PM
Can you post your db log?
Title: Re: CCPulse can't connect to DataMart DB
Post by: Timur Karimov on November 18, 2008, 01:47:47 PM
[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 ?

Title: Re: CCPulse can't connect to DataMart DB
Post by: Fra on November 18, 2008, 01:56:56 PM
blin, CCPulse po-russki, kruto!  ;D

Can you ping the hostname from the box where your CCPulse is installed?
Title: Re: CCPulse can't connect to DataMart DB
Post by: catanirex on November 18, 2008, 04:03:24 PM
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?

Title: Re: CCPulse can't connect to DataMart DB
Post by: Timur Karimov on November 18, 2008, 05:30:28 PM
[quote author=Fra link=topic=3576.msg15201#msg15201 date=1227016616]
blin, CCPulse po-russki, kruto!  ;D

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 ?!
Title: Re: CCPulse can't connect to DataMart DB
Post by: Timur Karimov on November 18, 2008, 05:40:49 PM
[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......
Title: Re: CCPulse can't connect to DataMart DB
Post by: cavagnaro on November 18, 2008, 08:02:15 PM
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.
Title: found solution
Post by: Timur Karimov on November 19, 2008, 01:26:34 PM
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.