cancel
Showing results for 
Search instead for 
Did you mean: 

MAIN_SHDIMP/SUBMOD_SHDALIASCRE/SCEXEC_GRANT DBSL error 103 (db code 942)

Former Member
0 Kudos

Dear Experts,

I am upgrading SAP from 701/EHP4 to 740/EHP7 during  MAIN_SHDIMP/SUBMOD_SHDALIASCRE/SCEXEC_GRANT steps my use/sap partition 100% full I cut all log from /usr/sap/SUM/abap/log in move into USB drive then run SUM again but stack into this phase with following error

3 ETQ398 SQL: GRANT ALL ON          SAPSR3."CAT_SVARS~" TO SAPSR3SHD

3 ETQ398 SQL: GRANT ALL ON          SAPSR3."CC2S_CONSTRAINTS~" TO SAPSR3SHD

3 ETQ398 SQL: GRANT ALL ON          SAPSR3."CC2TEST_T005S~" TO SAPSR3SHD

1 ETQ000 ==================================================

4 ETQ010 Date & Time: 20141024162727 

1EETQ008 Error message: DBSL error 103 (db code 942):

ORA-00942: table or view does not exist

1EETQ003 exit code: "12"

4 ETQ399 Rollback.

4 EPU202XEND OF SECTION BEING ANALYZED END OF SCEXEC_GRANT =================================================

please help me to resolve this issue

Regards

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

some more error attached SALEXEGR.LOG

ERRORS and RETURN CODE in PTALGR01.LOG

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

3 ETQ398 SQL: GRANT ALL ON          SAPSR3."AIND_STR6~" TO SAPSR3SHD

3 ETQ398 SQL: GRANT ALL ON          SAPSR3."AIND_STR9~" TO SAPSR3SHD

3 ETQ398 SQL: GRANT ALL ON          SAPSR3."AKB_CI_TABCHECK~" TO SAPSR3SHD

1 ETQ000 ==================================================

4 ETQ010 Date & Time: 20141024204226 

1EETQ008 Error message: DBSL error 103 (db code 942):

ORA-00942: table or view does not exist

1EETQ003 exit code: "12"

<NO EXIT CODE FOUND - PROGRAM ABORTED?>

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

ERRORS and RETURN CODE in PTALGR02.LOG

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

3 ETQ398 SQL: GRANT ALL ON          SAPSR3."CAT_PARAMS~" TO SAPSR3SHD

3 ETQ398 SQL: GRANT ALL ON          SAPSR3."CAT_VERBS~" TO SAPSR3SHD

3 ETQ398 SQL: GRANT ALL ON          SAPSR3."CC2TEST_T005~" TO SAPSR3SHD

1 ETQ000 ==================================================

4 ETQ010 Date & Time: 20141024204233 

1EETQ008 Error message: DBSL error 103 (db code 942):

ORA-00942: table or view does not exist

1EETQ003 exit code: "12"

<NO EXIT CODE FOUND - PROGRAM ABORTED?>

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

ERRORS and RETURN CODE in PTALGR03.LOG

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

3 ETQ398 SQL: GRANT ALL ON          SAPSR3."CAT_SVARS~" TO SAPSR3SHD

3 ETQ398 SQL: GRANT ALL ON          SAPSR3."CC2S_CONSTRAINTS~" TO SAPSR3SHD

3 ETQ398 SQL: GRANT ALL ON          SAPSR3."CC2TEST_T005S~" TO SAPSR3SHD

1 ETQ000 ==================================================

4 ETQ010 Date & Time: 20141024204233 

1EETQ008 Error message: DBSL error 103 (db code 942):

ORA-00942: table or view does not exist

1EETQ003 exit code: "12"

<NO EXIT CODE FOUND - PROGRAM ABORTED?>

Regards

Reagan
Advisor
Advisor
0 Kudos

Do you have supported OS and DB for the EHP update ?

If yes then check if the object exists at the DB level.

Raise an OSS message and check with SAP and see what the support says.

Former Member
0 Kudos

Thanks Reagan,

I have upgrade my database from 10.2 to 11.2 and SUSE linux 11 .

I want to restart SUM again but issue is table space  PSAPSR3701x etc createed

my query is what step I follow to restart upgrade because our system was 10.2 I upgrade it 11.2 and I have 10.2 database so I do not want to restore database ( fresh installation etc)

please guide me

Reagan
Advisor
Advisor
0 Kudos

You will need to reset the upgrade. There should be a reset option in the SUM tool and you may need to use it. Additionally read the SUM guide to know the procedure to reset the upgrade. After the reset start the upgrade once again with a newly extracted SUM.

Reagan

Answers (0)