Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

check_sql_list() failed for Table during ABAP Import

Hello Gurus,

While doing a system copy via R3Load method for a ECC6.0 EHP6 on Win 2008 R2 , Oracle 11.2.0.3  system , I got an error during the ABAP Import phase on the target system for the last 2 packages

SAPAPPL0_1 & SAPAPPL0_2

Error Details for SAPAPPL0_1

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

START OF LOG: 20140527194315

D:\usr\sap\DEV\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/720_REL/src/R3ld/R3load/R3ldmain.c#17 $ SAP

D:\usr\sap\DEV\SYS\exe\uc\NTAMD64\R3load.exe: version R7.20/V1.4 [UNICODE]

Compiled Jan 16 2013 17:01:57

patchinfo (patches.h): (0.324) SYB: migration to sybase using unsorted unload/load (note 1734039)

process id 1556

D:\usr\sap\DEV\SYS\exe\uc\NTAMD64\R3load.exe -i SAPAPPL0_1.cmd -dbcodepage 4103 -l SAPAPPL0_1.log -stop_on_error

DbSl Trace: ORA-1403 when accessing table SAPUSER

(DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF16

(GSI) INFO: dbname   = "DEV20140526020559                                                                                                               "

(GSI) INFO: vname    = "ORACLE                          "

(GSI) INFO: hostname = "ORSAPDEV02                                                      "

(GSI) INFO: sysname  = "Windows NT"

(GSI) INFO: nodename = "ORSAPDEV02"

(GSI) INFO: release  = "6.1"

(GSI) INFO: version  = "7601 Service Pack 1"

(GSI) INFO: machine  = "2x AMD64 Level 6 (Mod 44 Step 2)"

(RTF) ########## WARNING ###########

  Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases

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

(SQL) INFO: SQLFiles.LST not found

(SQL) INFO: Searching for SQL file S:\SBX_Export_dump\ABAP\DB/SQLFiles.LST

(SQL) INFO: found S:\SBX_Export_dump\ABAP\DB/SQLFiles.LST

(SQL) INFO: Trying to open S:\SBX_Export_dump\ABAP\DB/SQLFiles.LST

(SQL) INFO: S:\SBX_Export_dump\ABAP\DB/SQLFiles.LST opened

(SQL) INFO: Searching for SQL file APPL0.SQL

(SQL) INFO: APPL0.SQL not found

(SQL) INFO: Searching for SQL file S:\SBX_Export_dump\ABAP\DB/ORA/APPL0.SQL

(SQL) INFO: found S:\SBX_Export_dump\ABAP\DB/ORA/APPL0.SQL

(SQL) INFO: Trying to open S:\SBX_Export_dump\ABAP\DB/ORA/APPL0.SQL

(SQL) INFO: S:\SBX_Export_dump\ABAP\DB/ORA/APPL0.SQL opened

(SQL) ERROR: Invalid entry at line 5 in file S:\SBX_Export_dump\ABAP\DB/ORA/APPL0.SQL

(SQL) ERROR: SQL list was not built successfully

(DDL) ERROR: check_sql_list() failed for /1CN/CPASAP00001

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

(SQL) ERROR: SQL list was not built successfully

(DDL) ERROR: check_sql_list() failed for /1CN/CPASAP00001

(DB) INFO: disconnected from DB

D:\usr\sap\DEV\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 1 error(s)

D:\usr\sap\DEV\SYS\exe\uc\NTAMD64\R3load.exe:

END OF LOG: 20140527194325

Error log for package SAPAAPL0_2

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

D:\usr\sap\DEV\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20140527194315

D:\usr\sap\DEV\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/720_REL/src/R3ld/R3load/R3ldmain.c#17 $ SAP

D:\usr\sap\DEV\SYS\exe\uc\NTAMD64\R3load.exe: version R7.20/V1.4 [UNICODE]

Compiled Jan 16 2013 17:01:57

patchinfo (patches.h): (0.324) SYB: migration to sybase using unsorted unload/load (note 1734039)

process id 5028

D:\usr\sap\DEV\SYS\exe\uc\NTAMD64\R3load.exe -i SAPAPPL0_2.cmd -dbcodepage 4103 -l SAPAPPL0_2.log -stop_on_error

DbSl Trace: ORA-1403 when accessing table SAPUSER

(DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF16

(GSI) INFO: dbname   = "DEV20140526020559                                                                                                               "

(GSI) INFO: vname    = "ORACLE                          "

(GSI) INFO: hostname = "ORSAPDEV02                                                      "

(GSI) INFO: sysname  = "Windows NT"

(GSI) INFO: nodename = "ORSAPDEV02"

(GSI) INFO: release  = "6.1"

(GSI) INFO: version  = "7601 Service Pack 1"

(GSI) INFO: machine  = "2x AMD64 Level 6 (Mod 44 Step 2)"

(RTF) ########## WARNING ###########

  Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases

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

(SQL) INFO: SQLFiles.LST not found

(SQL) INFO: Searching for SQL file S:\SBX_Export_dump\ABAP\DB/SQLFiles.LST

(SQL) INFO: found S:\SBX_Export_dump\ABAP\DB/SQLFiles.LST

(SQL) INFO: Trying to open S:\SBX_Export_dump\ABAP\DB/SQLFiles.LST

(SQL) INFO: S:\SBX_Export_dump\ABAP\DB/SQLFiles.LST opened

(SQL) INFO: Searching for SQL file APPL0.SQL

(SQL) INFO: APPL0.SQL not found

(SQL) INFO: Searching for SQL file S:\SBX_Export_dump\ABAP\DB/ORA/APPL0.SQL

(SQL) INFO: found S:\SBX_Export_dump\ABAP\DB/ORA/APPL0.SQL

(SQL) INFO: Trying to open S:\SBX_Export_dump\ABAP\DB/ORA/APPL0.SQL

(SQL) INFO: S:\SBX_Export_dump\ABAP\DB/ORA/APPL0.SQL opened

(SQL) ERROR: Invalid entry at line 5 in file S:\SBX_Export_dump\ABAP\DB/ORA/APPL0.SQL

(SQL) ERROR: SQL list was not built successfully

(DDL) ERROR: check_sql_list() failed for KALM

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

(SQL) ERROR: SQL list was not built successfully

(DDL) ERROR: check_sql_list() failed for KALM

(DB) INFO: disconnected from DB

D:\usr\sap\DEV\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 1 error(s)

D:\usr\sap\DEV\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20140527194334

Further Details

==============

Had chosen to split tables before copy and had also executed SMIGR_CREATE_DDL report prior to DB export with target - Oracle DB.

Copied the resultant .SQL files into Export_dump/ABAP/DB directory.

After getting the error, and reading the guides and the posts on SCN , I copied the .SQL files into ABAP/DB/ORA directory as well and then restarted the Import again for the failed packages, but the import fails again.

Any clues/ suggestions would really be helpful.

Regards

Prashant

Tags:
Former Member
Former Member replied

Hi Deepak,

Thanks for the quick response,

I have executed the  SMIGR_CREATE_DDL report prior to DB export with target - Oracle DB.

Copied the resultant .SQL files into Export_dump/ABAP/DB directory.

This has worked for us in the past when our ECC 6.0 system was unupgraded  , however post the EHP6 upgrade, this is the 1st System copy via R3load method.

After getting the error, and reading the guides and the posts on SCN , I copied the .SQL files into ABAP/DB/ORA directory as well and then restarted the Import again for the failed packages, but the import fails again.


I think we may have to restart the import from scratch.


Regards

Prashant

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question