SUM 1.0 SP15 Error: MAIN_SHDIMP/SUBMOD_SHDDEL2

[Former Member]

Hi Everyone,

I'm performing an ABAP add-on installation for the Fiori for ERP apps on my NetWeaver 7.5 ABAP server. I used the Maintenance Planner to generate the stack, and download the files. Everything seemed to going fine until I received the following error:

Severe error(s) occurred in phase MAIN_SHDIMP/SUBMOD_SHDDEL2/PSCRGEN_DROP_SHD_TABLE_EXE!

Last error code set: Non single errors (code > 😎 found in logfile 'SQLDRSHD.ELG' 4 error during parallel execution of processes, check 'SQLDRSHD.ELG' for details 8 processes failed, check 'PSCRGEN_.*' for details

ERROR:
Detected the following errors:

# D:\usr\sap\GWS\SUM\abap\log\TSHDDR01.LOG:
3 ETQ398 SQL: DROP TABLE [DDXTF_2~]
3 ETQ398 SQL: DROP TABLE [DELDYNPS~]
3 ETQ398 SQL: DROP TABLE [DEMO_BLOB_TABLE~]
3 ETQ398 SQL: DROP TABLE [DEMO_GTT~]
4 ETQ010 Date & Time: 20151109221910
1EETQ008 Error message: DBSL error 99 (db code 3705):
1EETQ009XCannot use DROP TABLE with 'DEMO_GTT~' because 'DEMO_GTT~' is a view. Use DROP
1EETQ009XVIEW.
1EETQ003 exit code: "20"

ERROR:
Detected the following errors:

# D:\usr\sap\GWS\SUM\abap\log\TSHDDR02.LOG:
3 ETQ398 SQL: DROP TABLE [SATC_AC_RSLT_VT~]
3 ETQ398 SQL: DROP TABLE [SATC_AC_USER~]
3 ETQ398 SQL: DROP TABLE [SATC_CI_APPROVER~]
3 ETQ398 SQL: DROP TABLE [SATC_CI_GTT_CNTC~]
4 ETQ010 Date & Time: 20151109221911
1EETQ008 Error message: DBSL error 99 (db code 3705):
1EETQ009XCannot use DROP TABLE with 'SATC_CI_GTT_CNTC~' because 'SATC_CI_GTT_CNTC~' is
1EETQ009Xa view. Use DROP VIEW.
1EETQ003 exit code: "20"

ERROR:
Detected the following errors:

# D:\usr\sap\GWS\SUM\abap\log\TSHDDR03.LOG:
3 ETQ398 SQL: DROP TABLE [SATC_AC_STATE~]
3 ETQ398 SQL: DROP TABLE [SATC_AC_VERDCT_B~]
3 ETQ398 SQL: DROP TABLE [SATC_CI_APPR_UI~]
3 ETQ398 SQL: DROP TABLE [SATC_CI_GTT_OBJ~]
4 ETQ010 Date & Time: 20151109221911
1EETQ008 Error message: DBSL error 99 (db code 3705):
1EETQ009XCannot use DROP TABLE with 'SATC_CI_GTT_OBJ~' because 'SATC_CI_GTT_OBJ~' is a
1EETQ009Xview. Use DROP VIEW.
1EETQ003 exit code: "20"

ERROR:
Detected the following errors:

# D:\usr\sap\GWS\SUM\abap\log\TSHDDR04.LOG:
3 ETQ398 SQL: DROP TABLE [DELWBCROSS~]
3 ETQ398 SQL: DROP TABLE [DEMO_CR_CUSTOMRS~]
3 ETQ398 SQL: DROP TABLE [DEMO_JOIN2~]
3 ETQ398 SQL: DROP TABLE [DEMO_SFLIGHT_AGG~]
4 ETQ010 Date & Time: 20151109221911
1EETQ008 Error message: DBSL error 99 (db code 3705):
1EETQ009XCannot use DROP TABLE with 'DEMO_SFLIGHT_AGG~' because 'DEMO_SFLIGHT_AGG~' is
1EETQ009Xa view. Use DROP VIEW.
1EETQ003 exit code: "20"

This is a brand new installation on NW7.5 with an updated kernel to 7.45 PL 23. OS/DB is Windowser 2012R2 with SQL2014 running as a Central System.

Any help would be appreciated.

Thanks, Erik

[Mofizur · Accepted solution]

Hi Erik,

I believe you can use Database Utility/command to drop the views manually.You can test it with one and see.

Thanks,

Mofizur

[Former Member · Accepted solution]

Thanks, Mofizur

That's what I did and it allowed me to proceed with finishing the installation.

I have a ticket in with SAP to confirm this approach.

Erik