EHPI install - Error in phase MAIN_SHDINST/SUBMOD_SHDALIASCRE/SCEXEC_GRANT!

[Former Member]

I am trying to install EHPI and this is the error I am getting:

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

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

This is what hte PTALGR02.LOG says:

tp_exec_statement: GRANT ALL ON SAPSR3."FLEMP~" TO SAPSR3SHD

tp_exec_statement: GRANT ALL ON SAPSR3."FLIGHTB~" TO SAPSR3SHD

tp_exec_statement: GRANT ALL ON SAPSR3."FLIGHTM~" TO SAPSR3SHD

tp_exec_statement: GRANT ALL ON SAPSR3."FLIGHTP~" TO SAPSR3SHD

tp_exec_statement: GRANT ALL ON SAPSR3."FLIGHTS~" TO SAPSR3SHD

tp_exec_statement: GRANT ALL ON SAPSR3."SRTFT_QUEUE~" TO SAPSR3SHD

tp_exec_statement: GRANT ALL ON SAPSR3."SRTFT_QUEUE_DATA~" TO SAPSR3SHD

tp_exec_statement: GRANT ALL ON SAPSR3."SRTFT_QUEUE_LG_T~" TO SAPSR3SHD

I guessed it's a ppermissions issue and I "gave SAPDBA and DBA roles to both the users SAPSR3 and SAPSR3SHD". But that didn't work.

Any help is appreciated.

[Former Member]

HI Siri Nemani,

I have the same problem on preprocessing phase, Did you solve you problem? Pleas help me on this if you can.

Many regards

[sunny_pahuja2]

Hi,

Could you please paste SQLEXEGR.LOG ?

Thanks

Sunny

[Former Member]

Here is the SQLEXEGR.LOG:

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

ANALYSIS OF LOG FILE '/usr/sap/NWD/upg/EHPI/abap/log/PTALGR00.LOG'

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

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

ANALYSIS OF LOG FILE '/usr/sap/NWD/upg/EHPI/abap/log/PTALGR01.LOG'

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

ERROR: Found pattern "TPERR-" 2 times, but expected 0!

Analyze the log file for further error messages or program abort.

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

ANALYSIS OF LOG FILE '/usr/sap/NWD/upg/EHPI/abap/log/PTALGR02.LOG'

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

_______________________________________________________________________

This is the PTALGR02.LOG:

tp_exec_statement: GRANT ALL ON SAPSR3."SRTFT_QUEUE_LG_T~" TO SAPSR3SHD

tp_exec_statement: GRANT ALL ON SAPSR3."SRTFT_QUEUE_LOG~" TO SAPSR3SHD

tp_exec_statement: GRANT ALL ON SAPSR3."SRTFT_SA_APPL~" TO SAPSR3SHD

tp_exec_statement: GRANT ALL ON SAPSR3."SRTFT_SA_APPL_T~" TO SAPSR3SHD

tp_exec_statement: GRANT ALL ON SAPSR3."SRTMCORREL~" TO SAPSR3SHD

tp_exec_statement: GRANT ALL ON SAPSR3."SRTMEXTID~" TO SAPSR3SHD

tp_exec_statement: GRANT ALL ON SAPSR3."SRTMLEXENT~" TO SAPSR3SHD

tp_exec_statement: GRANT ALL ON SAPSR3."SRTMLEXICO~" TO SAPSR3SHD

[tomas_black]

Hello Siri,

I'm afraid this error remote to possible errors you have faced in phase DBCLONE, on the begging of the EHP.

Usually these errors are related to tables that do not exist - please check other SCEXEC_G* log files for entries like this:

ERROR: Statement: GRANT ALL ON SAPSR3."O2PAGINC~" 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."O2PAGRT~" TO SAPSR3SHD
ERROR: ERROR 512: DB object does not exist
ERROR: SQL ERROR 942: ORA-00942: table or view does not exist

If you run a select statement on the DB level for the DB objects in question, they should not exist, which means these tables do not exist in the shadow schema - which are created in DBCLONE phases.

Please check the DBCLONE logs for anything like "Error when cloning table structure" error messages, there should be located the root cause of the errors you're now seeing in SCEXEC_GRANT - we've many customer that faced this issue.

Unfortunetly, if this is the case, there's no other option but to reset the EHPI and restart from beggining. Errors in DBCLONE are crucial, since on this phase the DB objects are copied to the shadow instance.

I hope this helps.

Best regards,

Tomas Black