cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

MAIN_SHDINST/SUBMOD_SHDALIASCRE/SCEXEC_GRANT! ( erp 6.0 upgradation to EHP4

Former Member

on ‎04-18-2011 3:47 PM

0 Kudos

SAPehpi_troubleticket.loG :

Severe error(s) occured in phase MAIN_SHDINST/SUBMOD_SHDALIASCRE/SCEXEC_GRANT!

Last error code set: 2 error during parallel execution of processes, check 'SQLEXEGR.LOG' for details 4 processes failed, check 'SCEXEC_G.*' for details

SCEXEC_G.EC1

EXECUTING /EHPInt/EHPI/abap/exenew/tp (/EHPInt/EHPI/abap/exenew/tp) pf=/EHPInt/EHPI/abap/bin/EXDBNEW.TPP execdbscript ASX -x PTALGR00.XQL DBEXECNONT DBEXECNOCHECK

This is /EHPInt/EHPI/abap/exenew/tp version 376.01.14 (release 701, unicode enabled)

ERROR: Statement: GRANT ALL ON SAPSR3."DD01L~" TO SAPSR3SHD

ERROR: ERROR 512: DB object does not exist

ERROR: SQL ERROR 942: ORA-00942: table or view does not exist

ERROR: Statement: GRANT ALL ON SAPSR3."DD01T~" TO SAPSR3SHD

ERROR: ERROR 512: DB object does not exist

ERROR: SQL ERROR 942: ORA-00942: table or view does not exist

ERROR: Statement: GRANT ALL ON SAPSR3."DD02L~" TO SAPSR3SHD

ERROR: ERROR 512: DB object does not exist

ERROR: SQL ERROR 942: ORA-00942: table or view does not exist

ERROR: Statement: GRANT ALL ON SAPSR3."DD03T~" TO SAPSR3SHD

ERROR: ERROR 512: DB object does not exist

ERROR: SQL ERROR 942: ORA-00942: table or view does not exist

ERROR: Statement: GRANT ALL ON SAPSR3."DD06T~" TO SAPSR3SHD

ERROR: ERROR 512: DB object does not exist

ERROR: SQL ERROR 942: ORA-00942: table or view does not exist

ERROR: Statement: GRANT ALL ON SAPSR3."DD07L~" TO SAPSR3SHD

ERROR: ERROR 512: DB object does not exist

ERROR: SQL ERROR 942: ORA-00942: table or view does not exist

ERROR: Statement: GRANT ALL ON SAPSR3."DD07T~" TO SAPSR3SHD

ERROR: ERROR 512: DB object does not exist

ERROR: SQL ERROR 942: ORA-00942: table or view does not exist

ERROR: Statement: GRANT ALL ON SAPSR3."DD25L~" TO SAPSR3SHD

ERROR: ERROR 512: DB object does not exist

ERROR: SQL ERROR 942: ORA-00942: table or view does not exist

ERROR: Statement: GRANT ALL ON SAPSR3."DD26S~" TO SAPSR3SHD

ERROR: ERROR 512: DB object does not exist

ERROR: SQL ERROR 942: ORA-00942: table or view does not exist

ERROR: Statement: GRANT ALL ON SAPSR3."DD28S~" TO SAPSR3SHD

ERROR: ERROR 512: DB object does not exist

ERROR: SQL ERROR 942: ORA-00942: table or view does not exist

ERROR: Statement: GRANT ALL ON SAPSR3."DD29L~" TO SAPSR3SHD

ERROR: ERROR 512: DB object does not exist

ERROR: SQL ERROR 942: ORA-00942: table or view does not exist

ERROR: Statement: GRANT ALL ON SAPSR3."DD30T~" TO SAPSR3SHD

ERROR: ERROR 512: DB object does not exist

ERROR: SQL ERROR 942: ORA-00942: table or view does not exist

ERROR: Statement: GRANT ALL ON SAPSR3."DD40L~" TO SAPSR3SHD

ERROR: ERROR 512: DB object does not exist

ERROR: SQL ERROR 942: ORA-00942: table or view does not exist

ERROR: Statement: GRANT ALL ON SAPSR3."DD42S~" TO SAPSR3SHD

ERROR: ERROR 512: DB object does not exist

ERROR: SQL ERROR 942: ORA-00942: table or view does not exist

ERROR: Statement: GRANT ALL ON SAPSR3."DDFTX~" TO SAPSR3SHD

ERROR: ERROR 512: DB object does not exist

ERROR: SQL ERROR 942: ORA-00942: table or view does not exist

ERROR: Statement: GRANT ALL ON SAPSR3."DDTYPES~" TO SAPSR3SHD

ERROR: ERROR 512: DB object does not exist

ERROR: SQL ERROR 942: ORA-00942: table or view does not exist

ERROR: Statement: GRANT ALL ON SAPSR3."DF06T~" TO SAPSR3SHD

ERROR: ERROR 512: DB object does not exist

ERROR: SQL ERROR 942: ORA-00942: table or view does not exist

ERROR: Statement: GRANT ALL ON SAPSR3."DF07T~" TO SAPSR3SHD

ERROR: ERROR 512: DB object does not exist

ERROR: SQL ERROR 942: ORA-00942: table or view does not exist

ERROR: Statement: GRANT ALL ON SAPSR3."DF08T~" TO SAPSR3SHD

ERROR: ERROR 512: DB object does not exist

ERROR: SQL ERROR 942: ORA-00942: table or view does not exist

ERROR: Statement: GRANT ALL ON SAPSR3."DF10T~" TO SAPSR3SHD

ERROR: ERROR 512: DB object does not exist

ERROR: SQL ERROR 942: ORA-00942: table or view does not exist

ERROR: Statement: GRANT ALL ON SAPSR3."DF11T~" TO SAPSR3SHD

ERROR: ERROR 512: DB object does not exist

ERROR: SQL ERROR 942: ORA-00942: table or view does not exist

ERROR: Statement: GRANT ALL ON SAPSR3."DF12T~" TO SAPSR3SHD

ERROR: ERROR 512: DB object does not exist

ERROR: SQL ERROR 942: ORA-00942: table or view does not exist

ERROR: Statement: GRANT ALL ON SAPSR3."DF13T~" TO SAPSR3SHD

ERROR: ERROR 512: DB object does not exist

ERROR: SQL ERROR 942: ORA-00942: table or view does not exist

ERROR: Statement: GRANT ALL ON SAPSR3."DF14T~" TO SAPSR3SHD

ERROR: ERROR 512: DB object does not exist

ERROR: SQL ERROR 942: ORA-00942: table or view does not exist

ERROR: Statement: GRANT ALL ON SAPSR3."DF15L~" TO SAPSR3SHD

ERROR: ERROR 512: DB object does not exist

ERROR: SQL ERROR 942: ORA-00942: table or view does not exist

ERROR: Statement: GRANT ALL ON SAPSR3."DF34S~" TO SAPSR3SHD

ERROR: ERROR 512: DB object does not exist

ERROR: SQL ERROR 942: ORA-00942: table or view does not exist

ERROR: Statement: GRANT ALL ON SAPSR3."DF40D~" TO SAPSR3SHD

ERROR: ERROR 512: DB object does not exist

ERROR: SQL ERROR 942: ORA-00942: table or view does not exist

ERROR: Statement: GRANT ALL ON SAPSR3."DF41S~" TO SAPSR3SHD

ERROR: ERROR 512: DB object does not exist

ERROR: SQL ERROR 942: ORA-00942: table or view does not exist

ERROR: Statement: GRANT ALL ON SAPSR3."DM02L~" TO SAPSR3SHD

ERROR: ERROR 512: DB object does not exist

ERROR: SQL ERROR 942: ORA-00942: table or view does not exist

ERROR: Statement: GRANT ALL ON SAPSR3."DM02S~" TO SAPSR3SHD

ERROR: ERROR 512: DB object does not exist

ERROR: SQL ERROR 942: ORA-00942: table or view does not exist

ERROR: Statement: GRANT ALL ON SAPSR3."DM02T~" TO SAPSR3SHD

ERROR: ERROR 512: DB object does not exist

ERROR: SQL ERROR 942: ORA-00942: table or view does not exist

ERROR: Statement: GRANT ALL ON SAPSR3."DM03S~" TO SAPSR3SHD

ERROR: ERROR 512: DB object does not exist

ERROR: SQL ERROR 942: ORA-00942: table or view does not exist

ERROR: Statement: GRANT ALL ON SAPSR3."DM25L~" TO SAPSR3SHD

ERROR: ERROR 512: DB object does not exist

ERROR: SQL ERROR 942: ORA-00942: table or view does not exist

ERROR: Statement: GRANT ALL ON SAPSR3."DM26L~" TO SAPSR3SHD

ERROR: ERROR 512: DB object does not exist

ERROR: SQL ERROR 942: ORA-00942: table or view does not exist

ERROR: Statement: GRANT ALL ON SAPSR3."DM40L~" TO SAPSR3SHD

ERROR: ERROR 512: DB object does not exist

ERROR: SQL ERROR 942: ORA-00942: table or view does not exist

ERROR: Statement: GRANT ALL ON SAPSR3."DM40T~" TO SAPSR3SHD

ERROR: ERROR 512: DB object does not exist

ERROR: SQL ERROR 942: ORA-00942: table or view does not exist

ERROR: Statement: GRANT ALL ON SAPSR3."DM41S~" TO SAPSR3SHD

ERROR: ERROR 512: DB object does not exist

ERROR: SQL ERROR 942: ORA-00942: table or view does not exist

ERROR: Statement: GRANT ALL ON SAPSR3."DM43T~" TO SAPSR3SHD

ERROR: ERROR 512: DB object does not exist

ERROR: SQL ERROR 942: ORA-00942: table or view does not exist

ERROR: Statement: GRANT ALL ON SAPSR3."BRATEXT~" TO SAPSR3SHD

ERROR: ERROR 512: DB object does not exist

ERROR: SQL ERROR 942: ORA-00942: table or view does not exist

Warning: Parameter INTERRUPT is no longer used.

Warning: Parameter DAYLIGHT_SHUTDOWN is no longer used.

Warning: Parameter WITH_TACOB is no longer used.

Warning: Parameter IMPDP_BY_EVENT is no longer used.

Warning: Parameter INTERRUPT is no longer used.

Warning: Parameter DAYLIGHT_SHUTDOWN is no longer used.

Warning: Parameter WITH_TACOB is no longer used.

Warning: Parameter IMPDP_BY_EVENT is no longer used.

Warning: Parameter DBCONFPATH is no longer used.

tp returncode summary:

TOOLS: Highest return code of single steps was: 0

ERRORS: Highest tp internal error was: 0237

tp finished with return code: 237

meaning:

SQL-error

pLS HELP ?...I M NT ABLE TO PROCEED

Show replies
Show replies
Answer

Accepted Solutions (0)

Answers (1)

Answers (1)

paul_power
Active Contributor
‎04-20-2011 6:52 PM
0 Kudos

Hello Rohit,

That is an awfull lot of ORA-00942 messages:

ORA-00942: table or view does not exist

SAP Note 662644 - Composite SAP Note: ORA-00942

check if any of the reported objects do in fact exist in the sadow schema.

I suspect they do not.

Are there errors in the earlier

SHDUSRCRE.LOG file

which might suggest why these objects did not get created?

It may be that it will require a message to analyse this further, but post what you find and will try to help as best as possible.

Kind regards,

Paul

Show replies
Show replies
Ask a Question