Skip to Content
author's profile photo Former Member
Former Member

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

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Apr 20, 2011 at 05:52 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.