ABAP Import Phase DDL Statement Error

[#1]

Hi Experts!

I am installing SAP Netweaver PI 7.3 EHP1 and encountered an error in the ABAP import phase.

I checked the import monitor logs and found a clue about SAPVIEW.log.

I have checked the SAPVIEW.log and found out the following:

--------------------------------------------------------------------------------------------------------------------------------------------------------

ERROR: DDL statement failed

( DROP VIEW "APPL_MODS" )

dsql_exec_immediate returned DS_DBOBJECTUNKNOWN

(IMP) INFO: a failed DROP attempt is not necessarily a problem

(DB) ERROR: DDL statement failed

( CREATE VIEW "APPL_MODS" ( "NAME", "TYP", "MEMBER", "DEVCLASS" ) AS SELECT T0001."NAME", T0001."TYP", T0001."MEMBER", T0002."DEVCLASS" FROM "MODSAP" T0001, "MODSAPA" T0002 WHERE T0001."NAME" = T0002."NAME" AND T0002."MIGRATED" <> 'X' )

dsql_exec_immediate returned DS_DBOBJECTUNKNOWN

(DB) INFO: disconnected from DB

/usr/sap/PID/SYS/exe/uc/rs6000_64/R3load: job finished with 1 error(s)

/usr/sap/PID/SYS/exe/uc/rs6000_64/R3load: END OF LOG:

--------------------------------------------------------------------------------------------------------------------------------------------------------

Please help!

Also please let me know if any further detail is required.

Regards,

Ayan

[former_member182657]

Hi Ayan,

Kindly follow SAP Note  1837199 - DB6: Error DS_DBOBJECTUNKNOWN during ABAP import and share complete SAPVIEW.log file for analysis,also try to execute command

CREATE VIEW "APPL_MODS" ( "NAME", "TYP", "MEMBER", "DEVCLASS" ) AS SELECT T0001."NAME", T0001."TYP", T0001."MEMBER", T0002."DEVCLASS" FROM "MODSAP" T0001, "MODSAPA" T0002 WHERE T0001."NAME" = T0002."NAME" AND T0002."MIGRATED" <> 'X'

at db level and retry the phase again.

Regards,

Gaurav

[Former Member]

Hi Gaurav,

Thanks for your quick response!

The SAP note asks to create a support incident, which can only be created if I register my system.

Since my installation is not complete, so I cannot raise an incident.

Well, I have tried to execute the command in the DB level and it gives the following error:

----------------------------------------------------------------------------------------

db2 => CREATE VIEW "APPL_MODS" ( "NAME", "TYP", "MEMBER", "DEVCLASS" ) AS SELECT T0001."NAME", T0001."TYP", T0001."MEMBER", T0002."DEVCLASS" FROM "MODSAP" T0001, "MODSAPA" T0002 WHERE T0001."NAME" = T0002."NAME" AND T0002."MIGRATED" <> 'X'

DB21034E  The command was processed as an SQL statement because it was not a

valid Command Line Processor command.  During SQL processing it returned:

SQL0204N  "DB2PID.MODSAP" is an undefined name.  SQLSTATE=42704

----------------------------------------------------------------------------------------

Please suggest!

Regards,

Ayan

[Former Member]

Gaurav,

Please find the below pasted trace from SAPVIEW.log

-----------------------------------------------------------------------------------

/usr/sap/PID/SYS/exe/uc/rs6000_64/R3load: START OF LOG: 20140823014048

/usr/sap/PID/SYS/exe/uc/rs6000_64/R3load: sccsid @(#) $Id: //bas/721_REL/src/R3ld/R3load/R3ldmain.c#8 $ SAP

/usr/sap/PID/SYS/exe/uc/rs6000_64/R3load: version R7.20/V1.6 [UNICODE]

Compiled Dec  4 2013 12:54:08

/usr/sap/PID/SYS/exe/uc/rs6000_64/R3load -ctf I /backup/NW7.3_EHP1/ABAP_Inst_EXP/51043228/DATA_UNITS/EXP3/DATA/SAPVIEW.STR /tmp/sapinst_instdir/NW731/DB6/INSTALL/STD/AS/DDLDB6.TPL SAPVIEW.TSK DB6 -l SAPVIEW.log

/usr/sap/PID/SYS/exe/uc/rs6000_64/R3load: job completed

/usr/sap/PID/SYS/exe/uc/rs6000_64/R3load: END OF LOG: 20140823014048

/usr/sap/PID/SYS/exe/uc/rs6000_64/R3load: START OF LOG: 20140823014048

/usr/sap/PID/SYS/exe/uc/rs6000_64/R3load: sccsid @(#) $Id: //bas/721_REL/src/R3ld/R3load/R3ldmain.c#8 $ SAP

/usr/sap/PID/SYS/exe/uc/rs6000_64/R3load: version R7.20/V1.6 [UNICODE]

Compiled Dec  4 2013 12:54:08

/usr/sap/PID/SYS/exe/uc/rs6000_64/R3load -i SAPVIEW.cmd -dbcodepage 4102 -l SAPVIEW.log -stop_on_error -loadprocedure fast LOAD:DEF_CRT

(DB) INFO: connected to DB

(SQL) INFO: Searching for SQL file SQLFiles.LST

(SQL) INFO: SQLFiles.LST not found

(SQL) INFO: Searching for SQL file /backup/NW7.3_EHP1/ABAP_Inst_EXP/51043228/DATA_UNITS/EXP3/DB/SQLFiles.LST

(SQL) INFO: /backup/NW7.3_EHP1/ABAP_Inst_EXP/51043228/DATA_UNITS/EXP3/DB/SQLFiles.LST not found

(SQL) INFO: Searching for SQL file .SQL

(SQL) INFO: .SQL not found

(SQL) INFO: Searching for SQL file /backup/NW7.3_EHP1/ABAP_Inst_EXP/51043228/DATA_UNITS/EXP3/DB/DB6/.SQL

(SQL) INFO: /backup/NW7.3_EHP1/ABAP_Inst_EXP/51043228/DATA_UNITS/EXP3/DB/DB6/.SQL not found

(DB) INFO: /BI0/MHIER_VERS created #20140823014054

(DB) INFO: /BI0/RALEAFNODCH created #20140823014054

(DB) INFO: /BI0/RALEAFNODSP created #20140823014054

(DB) INFO: /BI0/RBUCKET created #20140823014054

(DB) INFO: /BI0/RCALMONTH created #20140823014054

(DB) INFO: /BI0/RCALMONTH2 created #20140823014054

(DB) INFO: /BI0/RCALQUART1 created #20140823014054

(DB) INFO: /BI0/RCALQUARTER created #20140823014054

(DB) INFO: /BI0/RCALWEEK created #20140823014054

(DB) INFO: /BI0/RCALYEAR created #20140823014054

(DB) INFO: /BI0/RCHNGID created #20140823014054

(DB) INFO: /BI0/RCURRENCY created #20140823014054

(DB) INFO: /BI0/RDATE created #20140823014054

(DB) INFO: /BI0/RFISCPER created #20140823014054

(DB) INFO: /BI0/RFISCPER3 created #20140823014054

(DB) INFO: /BI0/RFISCVARNT created #20140823014054

(DB) INFO: /BI0/RFISCYEAR created #20140823014054

(DB) INFO: /BI0/RHALFYEAR1 created #20140823014054

(DB) INFO: /BI0/RHIENM created #20140823014054

(DB) INFO: /BI0/RHIER_HIEID created #20140823014054

(DB) INFO: /BI0/RHIER_NODE created #20140823014054

(DB) INFO: /BI0/RHIER_VERS created #20140823014054

(DB) INFO: /BI0/RINFOPROV created #20140823014054

(DB) INFO: /BI0/RIOBJNM created #20140823014054

(DB) INFO: /BI0/RLANGU created #20140823014054

(DB) INFO: /BI0/RLOGSYS created #20140823014054

(DB) INFO: /BI0/RNODEPOSIT created #20140823014054

(DB) INFO: /BI0/RNORESTNODE created #20140823014054

(DB) INFO: /BI0/RRATE_TYPE created #20140823014054

(DB) INFO: /BI0/RRECORDMODE created #20140823014054

(DB) INFO: /BI0/RRECORDTP created #20140823014054

(DB) INFO: /BI0/RREQUID created #20140823014054

(DB) INFO: /BI0/RSIGNCH created #20140823014054

(DB) INFO: /BI0/RSOURSYSTEM created #20140823014054

(DB) INFO: /BI0/RTIME created #20140823014054

(DB) INFO: /BI0/RTXTLG created #20140823014054

(DB) INFO: /BI0/RTXTMD created #20140823014054

(DB) INFO: /BI0/RTXTSH created #20140823014054

(DB) INFO: /BI0/RUNIT created #20140823014054

(DB) INFO: /BI0/RWEEKDAY1 created #20140823014054

(DB) INFO: /BI0/ZBUCKET created #20140823014054

(DB) INFO: /BI0/ZCALMONTH created #20140823014054

(DB) INFO: /BI0/ZCALMONTH2 created #20140823014054

(DB) INFO: /BI0/ZDATE created #20140823014054

(DB) INFO: /BI0/ZFISCPER created #20140823014055

(DB) INFO: /BI0/ZHALFYEAR1 created #20140823014055

(DB) INFO: /BI0/ZINFOPROV created #20140823014055

(DB) INFO: /BI0/ZIOBJNM created #20140823014055

(DB) INFO: /GC1/VXXX created #20140823014055

(DB) INFO: /OSP/V_RAUI_CHRD created #20140823014055

(DB) INFO: /OSP/V_RAUI_CMVD created #20140823014055

(DB) INFO: /OSP/V_RAUI_CPVD created #20140823014055

(DB) INFO: /OSP/V_RAUI_CSED created #20140823014055

(DB) INFO: /OSP/V_RAUI_DCDB created #20140823014055

(DB) INFO: /OSP/V_RAUI_GRPD created #20140823014055

(DB) INFO: /OSP/V_RAUI_MTD created #20140823014055

(DB) INFO: /OSP/V_RAUI_MVDB created #20140823014055

(DB) INFO: /OSP/V_RAUI_PBDB created #20140823014055

(DB) INFO: /OSP/V_RAUI_RDDB created #20140823014055

(DB) INFO: /OSP/V_RAUI_RFCD created #20140823014055

(DB) INFO: /OSP/V_RAUI_RMTD created #20140823014055

(DB) INFO: /OSP/V_RAUI_RTDB created #20140823014055

(DB) INFO: /OSP/V_RAUI_SCD created #20140823014055

(DB) INFO: /OSP/V_RAUI_SCHD created #20140823014055

(DB) INFO: /OSP/V_RAUI_SELD created #20140823014055

(DB) INFO: /OSP/V_RAUI_TMVD created #20140823014055

(DB) INFO: /OSP/V_RAUI_TPBD created #20140823014055

(DB) INFO: /OSP/V_RAUI_TPDB created #20140823014055

(DB) INFO: /OSP/V_RAUI_TPRD created #20140823014055

(DB) INFO: /OSP/V_RAUI_TRGD created #20140823014055

(DB) INFO: /OSP/V_RAUI_VARD created #20140823014055

(DB) INFO: /SAPAPO/GEWICHT created #20140823014055

(DB) INFO: /SAPAPO/TRENDAM created #20140823014055

(DB) INFO: /SAPAPO/VWALPROF created #20140823014055

(DB) INFO: /SAPPO/FULL_HINT created #20140823014055

(DB) INFO: /SAPPO/V_PPOCMPL created #20140823014055

(DB) INFO: /SAPPO/V_PPO_UPD created #20140823014055

(DB) INFO: /SAPTRX/A_CONDF4 created #20140823014055

(DB) INFO: /SAPTRX/EE_FLDS created #20140823014055

(DB) INFO: /SAPTRX/MSG_PARA created #20140823014055

(DB) INFO: /SAPTRX/MSG_PTAB created #20140823014055

(DB) INFO: /SAPTRX/STR_FLDS created #20140823014055

(DB) INFO: /SAPTRX/VDASFEV created #20140823014055

(DB) INFO: /SAPTRX/VDASFPAR created #20140823014055

(DB) INFO: /SAPTRX/VD_AOMIL created #20140823014055

(DB) INFO: /SAPTRX/VD_AOPAC created #20140823014055

(DB) INFO: /SAPTRX/VD_AOPAE created #20140823014055

(DB) INFO: /SAPTRX/VD_AOPAI created #20140823014055

(DB) INFO: /SAPTRX/VD_AOPAR created #20140823014055

(DB) INFO: /SAPTRX/VD_AOTD1 created #20140823014055

(DB) INFO: /SAPTRX/VD_AOTD2 created #20140823014055

(DB) INFO: /SAPTRX/VD_AOTDD created #20140823014055

(DB) INFO: /SAPTRX/VD_AOTYP created #20140823014055

(DB) INFO: /SAPTRX/VD_ASPAR created #20140823014055

(DB) INFO: /SAPTRX/VD_CONDL created #20140823014055

(DB) INFO: /SAPTRX/VD_EVTD1 created #20140823014055

(DB) INFO: /SAPTRX/VD_EVTD2 created #20140823014055

(DB) INFO: /SAPTRX/VD_EVTD3 created #20140823014055

(DB) INFO: /SAPTRX/VD_EVTD4 created #20140823014055

(DB) INFO: /SAPTRX/V_AODD02 created #20140823014055

(DB) INFO: /SAPTRX/V_DD03 created #20140823014055

(DB) INFO: /SAPTRX/V_DD03X created #20140823014055

(DB) INFO: /SDF/CMO_OBJ_TR created #20140823014055

(DB) INFO: /SDF/CMO_SMDCMP created #20140823014056

(DB) INFO: /SDF/CMO_SMDDVC created #20140823014056

(DB) INFO: /SDF/CMO_UMDCMP created #20140823014056

(DB) INFO: /SDF/SMODICOMP created #20140823014056

(DB) INFO: /SDF/SMODIDEVC created #20140823014056

(DB) INFO: /SDF/UMOD_COMP created #20140823014056

(DB) INFO: AKB_TRHD_DETAIL created #20140823014056

(DB) INFO: ALTEXTHIST created #20140823014056

(DB) INFO: APPL_DEVC created #20140823014056

(DB) INFO: APPL_DIAL created #20140823014056

(DB) INFO: APPL_DOMA created #20140823014056

(DB) INFO: APPL_DTEL created #20140823014056

(DB) INFO: APPL_ENQU created #20140823014056

(DB) INFO: APPL_FUGR created #20140823014056

(DB) INFO: APPL_FUGRG created #20140823014056

(DB) INFO: APPL_FUNC created #20140823014056

(DB) INFO: APPL_INDX created #20140823014056

(DB) INFO: APPL_MCOB created #20140823014056

(DB) INFO: APPL_MENU created #20140823014056

(DB) ERROR: DDL statement failed

( CREATE VIEW "APPL_MODS" ( "NAME", "TYP", "MEMBER", "DEVCLASS" ) AS SELECT T0001."NAME", T0001."TYP", T0001."MEMBER", T0002."DEVCLASS" FROM "MODSAP" T0001, "MODSAPA" T0002 WHERE T0001."NAME" = T0002."NAME" AND T0002."MIGRATED" <> 'X' )

dsql_exec_immediate returned DS_DBOBJECTUNKNOWN

(DB) INFO: disconnected from DB

/usr/sap/PID/SYS/exe/uc/rs6000_64/R3load: job finished with 1 error(s)

/usr/sap/PID/SYS/exe/uc/rs6000_64/R3load: END OF LOG: 20140823014056

/usr/sap/PID/SYS/exe/uc/rs6000_64/R3load: START OF LOG: 20140823014312

/usr/sap/PID/SYS/exe/uc/rs6000_64/R3load: sccsid @(#) $Id: //bas/721_REL/src/R3ld/R3load/R3ldmain.c#8 $ SAP

/usr/sap/PID/SYS/exe/uc/rs6000_64/R3load: version R7.20/V1.6 [UNICODE]

Compiled Dec  4 2013 12:54:08

/usr/sap/PID/SYS/exe/uc/rs6000_64/R3load -i SAPVIEW.cmd -dbcodepage 4102 -l SAPVIEW.log -stop_on_error -loadprocedure fast LOAD:DEF_CRT

(DB) INFO: connected to DB

(SQL) INFO: Searching for SQL file SQLFiles.LST

(SQL) INFO: SQLFiles.LST not found

(SQL) INFO: Searching for SQL file /backup/NW7.3_EHP1/ABAP_Inst_EXP/51043228/DATA_UNITS/EXP3/DB/SQLFiles.LST

(SQL) INFO: /backup/NW7.3_EHP1/ABAP_Inst_EXP/51043228/DATA_UNITS/EXP3/DB/SQLFiles.LST not found

(SQL) INFO: Searching for SQL file .SQL

(SQL) INFO: .SQL not found

(SQL) INFO: Searching for SQL file /backup/NW7.3_EHP1/ABAP_Inst_EXP/51043228/DATA_UNITS/EXP3/DB/DB6/.SQL

(SQL) INFO: /backup/NW7.3_EHP1/ABAP_Inst_EXP/51043228/DATA_UNITS/EXP3/DB/DB6/.SQL not found

(DB) ERROR: DDL statement failed

( DROP VIEW "APPL_MODS" )

dsql_exec_immediate returned DS_DBOBJECTUNKNOWN

(IMP) INFO: a failed DROP attempt is not necessarily a problem

(DB) ERROR: DDL statement failed

( CREATE VIEW "APPL_MODS" ( "NAME", "TYP", "MEMBER", "DEVCLASS" ) AS SELECT T0001."NAME", T0001."TYP", T0001."MEMBER", T0002."DEVCLASS" FROM "MODSAP" T0001, "MODSAPA" T0002 WHERE T0001."NAME" = T0002."NAME" AND T0002."MIGRATED" <> 'X' )

dsql_exec_immediate returned DS_DBOBJECTUNKNOWN

(DB) INFO: disconnected from DB

/usr/sap/PID/SYS/exe/uc/rs6000_64/R3load: job finished with 1 error(s)

/usr/sap/PID/SYS/exe/uc/rs6000_64/R3load: END OF LOG: 20140823014318

/usr/sap/PID/SYS/exe/uc/rs6000_64/R3load: START OF LOG: 20140823015246

/usr/sap/PID/SYS/exe/uc/rs6000_64/R3load: sccsid @(#) $Id: //bas/721_REL/src/R3ld/R3load/R3ldmain.c#8 $ SAP

/usr/sap/PID/SYS/exe/uc/rs6000_64/R3load: version R7.20/V1.6 [UNICODE]

Compiled Dec  4 2013 12:54:08

/usr/sap/PID/SYS/exe/uc/rs6000_64/R3load -i SAPVIEW.cmd -dbcodepage 4102 -l SAPVIEW.log -stop_on_error -loadprocedure fast LOAD:DEF_CRT

(DB) INFO: connected to DB

(SQL) INFO: Searching for SQL file SQLFiles.LST

(SQL) INFO: SQLFiles.LST not found

(SQL) INFO: Searching for SQL file /backup/NW7.3_EHP1/ABAP_Inst_EXP/51043228/DATA_UNITS/EXP3/DB/SQLFiles.LST

(SQL) INFO: /backup/NW7.3_EHP1/ABAP_Inst_EXP/51043228/DATA_UNITS/EXP3/DB/SQLFiles.LST not found

(SQL) INFO: Searching for SQL file .SQL

(SQL) INFO: .SQL not found

(SQL) INFO: Searching for SQL file /backup/NW7.3_EHP1/ABAP_Inst_EXP/51043228/DATA_UNITS/EXP3/DB/DB6/.SQL

(SQL) INFO: /backup/NW7.3_EHP1/ABAP_Inst_EXP/51043228/DATA_UNITS/EXP3/DB/DB6/.SQL not found

(DB) ERROR: DDL statement failed

( DROP VIEW "APPL_MODS" )

dsql_exec_immediate returned DS_DBOBJECTUNKNOWN

(IMP) INFO: a failed DROP attempt is not necessarily a problem

(DB) ERROR: DDL statement failed

( CREATE VIEW "APPL_MODS" ( "NAME", "TYP", "MEMBER", "DEVCLASS" ) AS SELECT T0001."NAME", T0001."TYP", T0001."MEMBER", T0002."DEVCLASS" FROM "MODSAP" T0001, "MODSAPA" T0002 WHERE T0001."NAME" = T0002."NAME" AND T0002."MIGRATED" <> 'X' )

dsql_exec_immediate returned DS_DBOBJECTUNKNOWN

(DB) INFO: disconnected from DB

/usr/sap/PID/SYS/exe/uc/rs6000_64/R3load: job finished with 1 error(s)

/usr/sap/PID/SYS/exe/uc/rs6000_64/R3load: END OF LOG: 20140823015250

/usr/sap/PID/SYS/exe/uc/rs6000_64/R3load: START OF LOG: 20140825011924

/usr/sap/PID/SYS/exe/uc/rs6000_64/R3load: sccsid @(#) $Id: //bas/721_REL/src/R3ld/R3load/R3ldmain.c#8 $ SAP

/usr/sap/PID/SYS/exe/uc/rs6000_64/R3load: version R7.20/V1.6 [UNICODE]

Compiled Dec  4 2013 12:54:08

/usr/sap/PID/SYS/exe/uc/rs6000_64/R3load -i SAPVIEW.cmd -dbcodepage 4102 -l SAPVIEW.log -stop_on_error -loadprocedure fast LOAD:DEF_CRT

(DB) INFO: connected to DB

(SQL) INFO: Searching for SQL file SQLFiles.LST

(SQL) INFO: SQLFiles.LST not found

(SQL) INFO: Searching for SQL file /backup/NW7.3_EHP1/ABAP_Inst_EXP/51043228/DATA_UNITS/EXP3/DB/SQLFiles.LST

(SQL) INFO: /backup/NW7.3_EHP1/ABAP_Inst_EXP/51043228/DATA_UNITS/EXP3/DB/SQLFiles.LST not found

(SQL) INFO: Searching for SQL file .SQL

(SQL) INFO: .SQL not found

(SQL) INFO: Searching for SQL file /backup/NW7.3_EHP1/ABAP_Inst_EXP/51043228/DATA_UNITS/EXP3/DB/DB6/.SQL

(SQL) INFO: /backup/NW7.3_EHP1/ABAP_Inst_EXP/51043228/DATA_UNITS/EXP3/DB/DB6/.SQL not found

(DB) ERROR: DDL statement failed

( DROP VIEW "APPL_MODS" )

dsql_exec_immediate returned DS_DBOBJECTUNKNOWN

(IMP) INFO: a failed DROP attempt is not necessarily a problem

(DB) ERROR: DDL statement failed

( CREATE VIEW "APPL_MODS" ( "NAME", "TYP", "MEMBER", "DEVCLASS" ) AS SELECT T0001."NAME", T0001."TYP", T0001."MEMBER", T0002."DEVCLASS" FROM "MODSAP" T0001, "MODSAPA" T0002 WHERE T0001."NAME" = T0002."NAME" AND T0002."MIGRATED" <> 'X' )

dsql_exec_immediate returned DS_DBOBJECTUNKNOWN

(DB) INFO: disconnected from DB

/usr/sap/PID/SYS/exe/uc/rs6000_64/R3load: job finished with 1 error(s)

/usr/sap/PID/SYS/exe/uc/rs6000_64/R3load: END OF LOG: 20140825011937

---------------------------------------------------------------------------------------

Please look into this..

Regards,

Ayan

[Former Member]

Hi sir,

could you please tell me how to get user name and password for login to the link you have given..

A pop up is displayed saying authentication required.

http://service.sap.com/sap/support/notes/1837199