SUM1SP16P2: EHP8 Upg Stoppage at MAIN_SHDIMP/SUBMOD_SHDDEL2/PSCRGEN_DROP_SHD_TABLE_EX

[Ray_Rickard]

Using SUM16p2 to update ECC6EHP7 to ECC6EHP8, and have encountered a stoppage at phase MAIN_SHDIMP/SUBMOD_SHDDEL2/PSCRGEN_DROP_SHD_TABLE_EXE

The issue is the TSHDDR01 and TSHDDR10.XQL files contain errors: each contain a single statement 'drop table []', which is erroring our when the tool parses the files. The files seem to have a CRC check built in as well, so I am unable to manually update the files to proceed. I have tried to remove this line from each file, but then SUM throws a different message stating there are errors in the files.

If anyone has a suggestion as to how to proceed, please share this. I have an open OSS message but am told it will need a developer to investigate, and that will be Monday.

We do not have blank or null aliases for any of our tables - so I suspect the module that generated the files encountered some manner of fault.

I would love to skip this step and manually clean the tables up later, just so I do not still in place stalled until Monday on my upgrade.

I have attempted to go back in the upgrade in hopes of repeating the phase that generates these files, but I can only go back to the point of the failure, and it never reaches that point. From my estimate, the files were generated very early in the upgrade, as the DTS on the files shows a date of yesterday at 10pm, but the upgrade did not reach this failed step until 3:20am this morning.

4 ETQ010 Date & Time: 20160319120437  2 ETQ102 Finished execution of 10 process(es). 2 ETQ108 Analyzing logs for errors. 1 ETQ124 Scanned file 'log\TSHDDR01.LOG' from offset 114 to 56571 for errors. 4EETQ399 Some errors found during the log scan! 2EETQ399 Scanning 'TSHDDR01.LOG' in 'D:\usr\sap\SE2\SUM\abap\log' yields 2: Non single errors (code > 😎 found in logfile 'SQLDRSHD.ELG' 1 ETQ124 Scanned file 'log\TSHDDR02.LOG' from offset 114 to 57218 for errors. 1 ETQ124 Scanned file 'log\TSHDDR03.LOG' from offset 114 to 57138 for errors. 1 ETQ124 Scanned file 'log\TSHDDR04.LOG' from offset 114 to 57167 for errors. 1 ETQ124 Scanned file 'log\TSHDDR05.LOG' from offset 114 to 57086 for errors. 1 ETQ124 Scanned file 'log\TSHDDR06.LOG' from offset 114 to 57184 for errors. 1 ETQ124 Scanned file 'log\TSHDDR07.LOG' from offset 114 to 57219 for errors. 1 ETQ124 Scanned file 'log\TSHDDR08.LOG' from offset 114 to 57191 for errors. 1 ETQ124 Scanned file 'log\TSHDDR09.LOG' from offset 114 to 57240 for errors. 1 ETQ124 Scanned file 'log\TSHDDR10.LOG' from offset 114 to 56406 for errors. 4EETQ399 Some errors found during the log scan! 2EETQ399 Scanning 'TSHDDR10.LOG' in 'D:\usr\sap\SE2\SUM\abap\log' yields 2: Non single errors (code > 😎 found in logfile 'SQLDRSHD.ELG' 3 ETQ114 Analyzed 10 log files. 2EETQ109 Found 2 errors in logs and 0 missing logs. 2EETQ106 2 processes failed. 1EETQ399 Last error code set is: Non single errors (code > 😎 found in logfile 'SQLDRSHD.ELG' 2 error during parallel execution of processes, check 'SQLDRSHD.ELG' for details 4 processes failed, check 'PSCRGEN_.*' for details 1EETQ204 Upgrade phase "PSCRGEN_DROP_SHD_TABLE_EXE" aborted with severe errors ("20160319120438")

snippet from SQL showing incorrect statement:   DROP TABLE [VGPT2~]  DROP TABLE [VRSSC_ATTR~]  DROP TABLE [VRSTC_RESULTS~]  DROP TABLE [VSCAN_PROF~]  DROP TABLE []  DROP TABLE [W3BHTMWIZZ~]  DROP TABLE [W3GENSTYLES~]  DROP TABLE [W3PUBDIR~]  DROP TABLE [WBCROSSGTI~]  DROP TABLE [WBOSYSCNTRL~]  DROP TABLE [WBXMLCUST~]

[Ray_Rickard · Accepted solution]

Opened OSS message and SAP Support assisted us with this. Despite the fact there are errors in the SQL files, you cannot simply edit those as they have a CRC. If you do edit the files manually the SUM process will not use them, because they will fail the CRC.

Issue is resolved.