ORA-00942 after login in CCPulse 8.1.1

[Gef Buneri]

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.

[cavagnaro]

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

[Tambo]

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

[Gef Buneri]

@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]

[cavagnaro]

Gef, that works only in newer versions of ccpulse

Enviado de meu SM-N9600 usando o Tapatalk

[Tambo]

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

[cavagnaro]

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

[Tambo]

the post says ORA-00942 after login in CCPulse 8.1.1

[cavagnaro]

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

[Gef Buneri]

@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+

[cavagnaro]

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

[Gef Buneri]

@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({
                                      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({
                                      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}}

[Tambo]

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

[Gef Buneri]

Ok, solved; cause was quite simple and error was quite accurate: view CCPulse called at startup did not existed into the db.


Thanks all.

[cavagnaro]

Hehe those are the hard ones to find.

Enviado de meu SM-N9600 usando o Tapatalk