Genesys CTI User Forum
Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: Gef Buneri on August 24, 2020, 02:00:30 PM
-
Hello all, hope everything's fine out there in this troubled times -_-
Just as in object, I obtain the error "ORA-00942 table or view does not exist" after confirming cfg and credentials @CCPulse 8.1.1 login; any clue on where I should check to solve?
Stay well,
Gef.
-
Do you have historical reports in some view? If so, the the DB Server attached to the CCPulse to access CCA reports will be a good start point
-
stick this into your CCPulse application in CME/GA and the logs will appear in your CCPulse folder in your C drive, captures quite a lot of info
[log]
all=C:\GCTI\LOG\CCP.txt <<<<<<your C drive where CCPulse is
expire=20
segment=10000
verbose=all
-
@Cav, thanks, I'll give it a try.
@Tambo, did it, but no logs shows; tried root directory too.
[img]http://web.tiscali.it/modifiche/Annotazione%202020-08-25%20165421.png[/img]
-
Gef, that works only in newer versions of ccpulse
Enviado de meu SM-N9600 usando o Tapatalk
-
Hi Cav,
we're using 8.1.0 and it works.
Gef,
all C:\Program Files (x86)\GCTI\CCP.txt
standard console, CCP.txt
and add in
CfgEventDetails full
DbEventDetails full
StatEventDetails full
-
Yes, but Gef has access to only limited versions as his customer got stuck with 7.6 if don't remember wrong
Enviado de meu SM-N9600 usando o Tapatalk
-
the post says ORA-00942 after login in CCPulse 8.1.1 ::) ;D
-
Oh! He got a new version! Lol
I know him lol so... Just didn't read that lol
Enviado de meu SM-N9600 usando o Tapatalk
-
@Cav, we're upgrading 8.1/8.5 rel. In this case CCPulse+ is 8.1.1
@Tambo in my scenario CCPulse+ and IRD installed in Program Files folder, 'cause I'm working in a 64 bit Win 10 Pro environment; CME, DMA and SCI, installed in x86 folder anyway.
Full CCPulse path is C:\Program Files\GCTI\CCPulse+
-
Finally... [emoji33] Congratulations! Hehe less old headaches and new headaches coming hahaha
But will definitely help you
Enviado de meu SM-N9600 usando o Tapatalk
-
@Cav, you can bet!! But new challenges to front xD thanks for all help.
@Tambo, ok, now is writing logs, there was a folder grant issue.
****EDIT****
2020-08-26 15:37:38.021306 [0x000003d0] DBG net[cfgsrv] Processing 1 server responses ...
2020-08-26 15:37:38.021306 [0x00000010] DBG net[cfgsrv] Event EndObjectList(8){
server:1428
eventNumber:0
requestID:72
objectType:Host(10)}
2020-08-26 15:37:38.021306 [0x000003d0] DBG net ConnLib::Wait(): Completed in 8 msecs
2020-08-26 15:37:38.021306 [0x000003d0] TRC net[cfgsrv] Response{folderID:60, objType:Host(10), filter:{dbid:103}, objCount:1}
2020-08-26 15:37:38.021306 [0x000003d0] TRC net[cfgsrv] Request{folderID:61, objType:Application(9), filter:{dbid:0}}
2020-08-26 15:37:38.021306 [0x000003d0] DBG net[cfgsrv] Waiting for configuration server response: ReadFolder
2020-08-26 15:37:38.021306 [0x000003d0] DBG net ConnLib::Wait(): Waiting for 180 secs
2020-08-26 15:37:38.021306 [0x000003d0] DBG net[cfgsrv] Processing 1 server responses ...
2020-08-26 15:37:38.030306 [0x000003d0] DBG net ConnLib::Wait(): Completed in 9 msecs
2020-08-26 15:37:38.030306 [0x00000010] DBG net[cfgsrv] Event EndObjectList(8){
server:1428
eventNumber:0
requestID:73
objectType:Application(9)}
2020-08-26 15:37:38.030306 [0x000003d0] TRC net[cfgsrv] Response{folderID:61, objType:Application(9), filter:{dbid:0}, objCount:0}
2020-08-26 15:37:38.030306 [0x000003d0] TRC net[dbsrv] Connect [[WASSERVERNAME:PORT]], clientName:CCPulse_Gef, DAP:DAP_ccp, params:XKVList{
name:'dbserver_etl'
is-server:'0'
client-type:'20'
server-type:'46'
server_dbid:'116'
protocol:'addp'
addp-timeout:'0'
addp-remote-timeout:'0'
addp-trace:'off'
host:'[[WASSERVERNAME]]'
port:'[[WASPORT]]'}
2020-08-26 15:37:38.031318 [0x00000010] DBG net[comlib] addp-trace off
2020-08-26 15:37:38.031318 [0x00000010] DBG net[comlib] (addp_xconfig) local OFF, remote OFF, trace off
2020-08-26 15:37:38.031318 [0x000003d0] DBG net[dbsrv] Waiting for DB server response: Connected
2020-08-26 15:37:38.031318 [0x000003d0] DBG net ConnLib::Wait(): Waiting for 180 secs
2020-08-26 15:37:38.038306 [0x00000010] DBG net[dbsrv] Event MSG_REGISTERED(63){
server:0
client:0
requestID:-1
status:Unknown (0)(0)
profileTime:0
record:TKVList{NULL}
record2:DBRecords{NULL}}
2020-08-26 15:37:38.038306 [0x000003d0] DBG net ConnLib::Wait(): Completed in 6 msecs
2020-08-26 15:37:38.038306 [0x000003d0] DBG net[dbsrv] Server moved to state OPEN
2020-08-26 15:37:38.038306 [0x00000010] TRC net[dbsrv] Request{
server:0
requestID:4
rowsLimit:-1
mode:SYNC
SQL:SELECT DISTINCT (CONFIG_SERVER.CONFSERVER_ID) FROM CONFIG_SERVER, SOURCE WHERE CONFIG_SERVER.CONFSERVER_ID=SOURCE.CONFSERVER_ID AND STOP_TIME IS NULL}
2020-08-26 15:37:38.038306 [0x000003d0] DBG net[dbsrv] Waiting for DB server response: Completed
2020-08-26 15:37:38.038306 [0x000003d0] DBG net ConnLib::Wait(): Waiting for 180 secs
2020-08-26 15:37:38.048307 [0x00000010] DBG net[dbsrv] Event MSG_CLIENTSTARTED(39){
server:0
client:-1
requestID:2
status:DBM_SUCCESS(1)
profileTime:0
record:TKVList{NULL}
record2:DBRecords{NULL}}
2020-08-26 15:37:38.189309 [0x00000010] DBG net[dbsrv] Event MSG_DBOPENED(27){
server:0
client:22
requestID:3
status:DBM_SUCCESS(1)
profileTime:121
record:TKVList{NULL}
record2:DBRecords{NULL}}
2020-08-26 15:37:38.194308 [0x00000010] DBG net[dbsrv] Event MSG_ERROR(2){
server:0
client:22
requestID:4
status:Unknown (14)(14)
profileTime:1
record:TKVList{
dbmerror:'ORA-00942: table or view does not exist
'}
record2:DBRecords{NULL}}
-
i would go with what Cav was saying about historical reports then, it's been a while but if memory serves me right if someone has DMA open on a table then you cant access it via ccpulse but i could be wrong
-
Ok, solved; cause was quite simple and error was quite accurate: view CCPulse called at startup did not existed into the db.
Thanks all.
-
Hehe those are the hard ones to find.
Enviado de meu SM-N9600 usando o Tapatalk