cancel
Showing results for 
Search instead for 
Did you mean: 

BR0301E SQL error -1031 at location BrDbdiffRead-1

Former Member
0 Kudos
1,178

I have the below error  and cancelling the job

Job started

Step 001 started (program RSDBAJOB, variant &0000000000037, user ID BASIS)

Execute logical command BRCONNECT On host cgceccqa

Parameters: -jid CHECK20130111060000 -u / -c -f check

BR0801I BRCONNECT 7.20 (28)

BR0805I Start of BRCONNECT processing: cekiotay.chk 2013-01-17 06.00.04

BR0484I BRCONNECT log file: /oracle/ECQ/sapcheck/cekiotay.chk

BR0477I Oracle pfile /oracle/ECQ/112_64/dbs/initECQ.ora created from spfile /oracle/ECQ/112_64/dbs/spfileECQ.ora

BR0280I BRCONNECT time stamp: 2013-01-17 06.00.06

BR0813I Schema owners found in database ECQ:

APPQOSSYS, DBSNMP, DIP, OPS$ECQADM, OPS$ORAECQ, OPS$SAPSERVICEECQ, ORACLE_OCM, OUTLN, SAPSR3*, SYS,

SYSTEM

BR0280I BRCONNECT time stamp: 2013-01-17 06.00.10

BR0814I Number of tables in schema of owner SAPSR3: 79066

BR0836I Number of tables treated as info cubes for owner SAPSR3: 48

BR0814I Number of tables/partitions in schema of owner SYS: 886/232

BR0814I Number of tables/partitions in schema of owner SYSTEM: 151/39

BR0280I BRCONNECT time stamp: 2013-01-17 06.00.17

BR0815I Number of indexes in schema of owner SAPSR3: 94777

BR0815I Number of indexes/partitions in schema ofowner SYS: 965/242

BR0815I Number of indexes/partitions in schema ofowner SYSTEM: 212/52

BR0280I BRCONNECT time stamp: 2013-01-17 06.00.22

BR0816I Number of segments in schema of owner DBSNMP: 8

BR0816I Number of segments in schema of owner OPS$ECQADM: 1

BR0816I Number of segments in schema of owner OUTLN: 9

BR0816I Number of segments/LOBs in schema of owner SAPSR3: 53061/2848

BR0816I Number of segments/LOBs in schema of owner SYS: 2586/144

BR0816I Number of segments/LOBs in schema of owner SYSTEM: 407/22

BR0280I BRCONNECT time stamp: 2013-01-17 06.00.22

BR0961I Number of conditions found in DBCHECKORA:118

BR0280I BRCONNECT time stamp: 2013-01-17 06.00.22

BR0301E SQL error -1031 at location BrDbdiffRead-1, SQL statement:

'PREPARE stmt_5 FROM'

'SELECT OBJNAME FROM "SAPSR3".DBDIFF WHERE DBSYS IN ('ORACLE', ' ') AND OBJTYPE = 'TABL' AND DIFFKIND IN ('02', '61', '99') ORDE

ORA-01031: insufficient privileges

BR0806I End of BRCONNECT processing: cekiotay.chk2013-01-17 06.00.22

BR0280I BRCONNECT time stamp: 2013-01-17 06.00.22

BR0804I BRCONNECT terminated with errors

External program terminated with exit code 3

BRCONNECT returned error status E

Job finished

What is the solution for this ERROR?

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

  Please login as orasid and perform the following.

1.login as orasid

2.sqlplus "/as sysdba"

3.grant SELECT on SAPSR3.DBDIFF to sapdba;

4.commit;

Try to rerun it again.

IT SHOULD FIX THE ISSUE.

Please check and provide your feedback.

Thanks and Regards,

Vimal

Former Member
0 Kudos

Hi Vimal,

Thanks for your reply,

I have follow the above step and ReRUN the job, Now I am getting the below ERROR;

Job started

Step 001 started (program RSDBAJOB, variant &0000000000005, user ID Q.FAKHRUDDIN)

Execute logical command BRCONNECT On host cgceccqa

Parameters: -jid CHECK20130117083534 -u / -c -f check

SXPG_COMMAND_EXECUTE(LONG)

<timestamp> = 20130117083534

COMMANDNAME = BRCONNECT

ADDITIONAL_PARAMETERS = -jid CHECK20130117083534 -u / -c -f check

LONG_PARAMS

OPERATINGSYSTEM = ANYOS

TARGETSYSTEM = cgceccqa

DESTINATION

SY-SUBRC =  501

SXPG_COMMAND_EXECUTE failed for BRCONNECT - Reason: no_permission: Authorization object S_LOG_COM miss

Job cancelled after system exception ERROR_MESSAGE

Now wthat is Next action?

Thanks in Advance,

Qutub

Former Member
0 Kudos

Hi

  Can you please execute SU53 transaction and attach the screenshot?

It seems to be authorization issue.

SXPG error comes for external commands, once check the Notes using this search term. For eg

Note 854060 - Authorizations for external commands

Note 1336776 - External commands: Security for calling side

Thanks and Regards,

Vimal

Former Member
0 Kudos

Hi Vimal,

I have checked Authorization and ReRun the Job, but still have the below ERROR.

BR0280I BRCONNECT time stamp: 2013-01-17 09.20.19

BR0818I Number of tables found in DBDIFF for owner SAPSR3: 2

BR0280I BRCONNECT time stamp: 2013-01-17 09.20.19

BR0301E SQL error -1031 at location BrDdartRead-1, SQL statement:

'PREPARE stmt_6 FROM'

'SELECT TABART FROM "SAPSR3".DDART ORDER BY TABART'

ORA-01031: insufficient privileges

BR0806I End of BRCONNECT processing: cekipkuj.chk 2013-01-17 09.20.19

BR0280I BRCONNECT time stamp: 2013-01-17 09.20.19

BR0804I BRCONNECT terminated with errors

Thanks & regards,

Qutub

Former Member
0 Kudos

Hi,

Please perform the below action as orasid.

1.login as orasid

2.sqlplus "/as sysdba"

3.

grant ALL on SAPSR3.SDBAH to sapdba;

grant ALL on SAPSR3.SDBAD to sapdba;

grant ALL on SAPSR3.DBAML to sapdba;

grant ALL on SAPSR3.DBARCL to sapdba;

grant ALL on SAPSR3.DBAFID to sapdba;

grant ALL on SAPSR3.DBAEXTL to sapdba;

grant ALL on SAPSR3.DBAREOL to sapdba;

grant ALL on SAPSR3.DBABARL to sapdba;

grant ALL on SAPSR3.DBADFL to sapdba;

grant ALL on SAPSR3.DBAOPTL to sapdba;

grant ALL on SAPSR3.DBASPAL to sapdba;

grant ALL on SAPSR3.DBABD to sapdba;

grant ALL on SAPSR3.DBABL to sapdba;

grant ALL on SAPSR3.DBATL to sapdba;

grant ALL on SAPSR3.DBAOBJL to sapdba;

grant ALL on SAPSR3.DBAPHAL to sapdba;

grant ALL on SAPSR3.DBAGRP to sapdba;

grant ALL on SAPSR3.DBAERR to sapdba;

grant ALL on SAPSR3.DBATRIAL to sapdba;

grant ALL on SAPSR3.DBSTATC to sapdba;

grant ALL on SAPSR3.DBSTATTORA to sapdba;

grant ALL on SAPSR3.DBSTATIORA to sapdba;

grant ALL on SAPSR3.DBSTATHORA to sapdba;

grant ALL on SAPSR3.DBSTAIHORA to sapdba;

grant ALL on SAPSR3.DBMSGORA to sapdba;

grant ALL on SAPSR3.DBCHECKORA to sapdba;

grant ALL on SAPSR3.MLICHECK to sapdba;

grant SELECT on SAPSR3.TGORA to sapdba;

grant SELECT on SAPSR3.IGORA to sapdba;

grant SELECT on SAPSR3.TSORA to sapdba;

grant SELECT on SAPSR3.TAORA to sapdba;

grant SELECT on SAPSR3.IAORA to sapdba;

grant SELECT on SAPSR3.SVERS to sapdba;

grant SELECT on SAPSR3.CVERS to sapdba;

grant SELECT on SAPSR3.DD02L to sapdba;

grant SELECT on SAPSR3.DD09L to sapdba;

grant SELECT on SAPSR3.DDNTT to sapdba;

grant SELECT on SAPSR3.DDART to sapdba;

grant SELECT on SAPSR3.DARTT to sapdba;

grant SELECT on SAPSR3.DBCHK to sapdba;

grant SELECT on SAPSR3.DBDIFF to sapdba;

grant ALL on SAPSR3.SAPLIKEY to sapdba;

grant SELECT on SAPSR3.RSNSPACE to sapdba;

grant SELECT on SAPSR3.RSPSPACE to sapdba;

I hope it helps.

Thanks and Regards,

Vimal

Former Member
0 Kudos

Hi,

is your issues resolved??

Please update the status.

Thanks and Regards,

Vimal

Former Member
0 Kudos

Dear Vimal,

After granted to ALL above permission, job was succeeded without any ERROR but still there is below Warning message.

BR0280I BRCONNECT time stamp: 2013-01-17 09.58.18

BR0980I Number of changed database profile parameters: 272

BR0280I BRCONNECT time stamp: 2013-01-17 09.58.18

BR0955I Number of signaled error/warning/exception alerts for database a

BR0956I Number of signaled error/warning/exception alerts for database o

BR0957I Number of signaled error/warning/exception alerts for database m

BR0958I Number of signaled error/warning/exception alerts for database p

BR0806I End of BRCONNECT processing: cekipodx.chk 2013-01-17 09.58.18

BR0280I BRCONNECT time stamp: 2013-01-17 09.58.18

BR0803I BRCONNECT completed successfully with warnings

Thanks for your effort and time.

Regards,

Qutub

Answers (0)