on 2013 Jan 17 5:22 AM
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?
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.