ORA-00942 after login in CCPulse 8.1.1

General Discussion
1

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.

2

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

3

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

4

@Cav, thanks, I’ll give it a try.

@Tambo, did it, but no logs shows; tried root directory too.

http://web.tiscali.it/modifiche/Annotazione%202020-08-25%20165421.png

5

Gef, that works only in newer versions of ccpulse

Enviado de meu SM-N9600 usando o Tapatalk

6

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

7

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

8

the post says ORA-00942 after login in CCPulse 8.1.1 ::slight_smile: ;D

9

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

10

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

11

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

12

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

13

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

14

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

Thanks all.

15

Hehe those are the hard ones to find.

Enviado de meu SM-N9600 usando o Tapatalk