ABAP Import Phase DDL Statement Error

[Former Member]

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 Member · Accepted solution]

Hi All,

I have solved the issue.

There has been some problem in the server due to which some of the tables were not created successfully.

Therefore, I reverted the installation process and performed a fresh installation and thus the issue got resolved.

If the same problem is faced by anyone else then you can follow these steps:

1. Take a restart of the DB.

2. Try to execute the DDL statement manually from the DB level.

3. Check for the tables from the DB level if they are created or not.

4. Check for the R3Load.LOG and TSK, if any other errors exist.

5. If none of the above work out, then you can perform a fresh installation or else raise an incident to SAP and let them find the solution for you.

Hope you will get the results.

Thanks everyone for their valuable time and feedback.

Regards,

Ayan