BR0301E SQL error -942 at location db_connect-4

[Former Member]

Hi All

We are getting the next error when we try to execute the BRCONNECT tools:

Job started

Step 001 started (program RSDBAJOB, variant &0000000000294, user ID IU3269)

Execute logical command BRCONNECT On host qassap

Parameters: -u / -c -f stats -t ALL

BR0801I BRCONNECT 6.40 (32)

BR0805I Start of BRCONNECT processing: cdwnmcsr.sta 2007-11-05 13.30.37

BR0280I BRCONNECT time stamp: 2007-11-05 13.30.38

BR0301E SQL error -942 at location db_connect-4

ORA-00942: table or view does not exist

BR0310E Connect to database instance QUA failed

BR0280I BRCONNECT time stamp: 2007-11-05 13.30.38

BR0301W SQL error -942 at location brc_dblog_open-1

ORA-00942: table or view does not exist

BR0324W Insertion of database log header failed

BR0806I End of BRCONNECT processing: cdwnmcsr.sta2007-11-05 13.30.38

BR0280I BRCONNECT time stamp: 2007-11-05 13.30.38

BR0804I BRCONNECT terminated with errors

External program terminated with exit code 3

BRCONNECT returned error status E

Job finished

Best Regards

Reynaldo Rebolledo.

[Former Member · Accepted solution]

Hi,

Pl hv a look at SAP Note 662644 - Composite SAP Note: ORA-00942.

At Sl 6,8 and 9 it say the following.

6. If ORA-00942 is issued when the user logs on to the database and accesses the SAPUSER table, check the OPS$ mechanism in accordance with note 400241.

8. If ORA-00942 errors occur when you execute SAPDBA or BR*Tools, import the current version of the SAPDBA role in accordance with note 134592 and ensure that no errors are logged in the sapdba_role.log.

9. In the past, different bugs resulted in the SAPDBA and the BR*Tools resulted in ORA-00942 errors. Ensure that you are using a current version of the tools (see note 12741).

Pl hv a look it may help.

Regards

[Former Member · Accepted solution]

Hi All

We apply the note 134592 and we can solve the problem.

Best Regards.

Reynaldo Rebolledo.

[JPReyes]

Hi Reynaldo...

Seems like the table youre trying to access either do not exist or the user you are using to connect does not have access to read it...

Is that the same user you use all the time for this job?... any changes in the DB(Upgrades/patches)?..

Regards

Juan

Please reward with points if helpful

[Former Member]

Hi Juan

The actual error that we have is the next:

Job started

Step 001 started (program RSDBAJOB, variant &0000000000297, user ID IU3269)

Execute logical command BRCONNECT On host qassap

Parameters: -u / -c -f stats -t ALL

BR0801I BRCONNECT 6.40 (32)

BR0252E Function fopen() failed for '/oracle/QUA/920_64/dbs/initQUA.sap' at location BrInitSapRead-1

BR0253E errno 2: No such file or directory

BR0159E Error reading BR*Tools profile /oracle/QUA/920_64/dbs/initQUA.sap

BR0280I BRCONNECT time stamp: 2007-11-06 18.14.36

BR0301E SQL error -942 at location db_connect-4

ORA-00942: table or view does not exist

BR0310E Connect to database instance QUA failed

BR0806I End of BRCONNECT processing: cdwnrzsy.log2007-11-06 18.14.32

BR0280I BRCONNECT time stamp: 2007-11-06 18.14.36

BR0804I BRCONNECT terminated with errors

External program terminated with exit code 3

BRCONNECT returned error status E

Job finished

The last week we made a refresh of PROD to QUA, the error is when try to run the stadistics on QUA, then we get the error and we found the initPDC.sap and we rename inside of the file and the file from PDC to QUA and then we get the error that we send in the first message. Today we deleted the file initQUA.sap and get this error. Can you help us.

Best Regards

Reynaldo Rebolledo

[Former Member]

Hi

Why did you delete the file ? It shouldnt be deleted . also check the s-bit setting for br* files

thanks

Prince Jose