Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

BR0301E SQL error -942 at location db_connect-4

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
Former Member replied

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question