Skip to Content
avatar image
Former Member

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    May 28, 2014 at 04:55 PM

    Hi Prashant,

    From the error logs

    (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

    You did not execute SMIGR_CREATE_DDL on the source system and copied the resulting SQL files over...

    You need to execute this report before the export and copy these files to target system export dump location before starting the import.

    Hope this helps.

    Regards,

    Deepak Kori

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      There is also a know issue within SAP where the .SQL files are created in error and include on line 5 for the .SQL fillles the entry ind:

      ....

      Dear Chris,

      It was wrongly generating the .SQL files as we can see in the log of each package from import, as I mentioned before:

      "(SQL) ERROR: Invalid entry at line 5 in file

      /<export dump location>/ABAP/DB/ORA/APPL0.SQL"

      Edit all the .SQL files generated and remove the line 5:, that have the content:

      ind:

      Just remove the line and save the files. After that restart the import from scratch.

      .....

  • avatar image
    Former Member
    Jul 25, 2014 at 12:19 PM

    Hi to all,

    I get exactly the same problem as yours Prashants.

    I made a lot of OS/DB Migrations since years without this problem before (I'm used to run SMIGR and so on).

    This problem Its follows an SAP Upgrade to ECC6 Ehp7.

    After an SAP Upgrade ECC6 Ehp6 it was not the case !

    My log files show exactly the same errors :

    (RDI) INFO: /EXPORT_DB/ABAP/DATA/SAP0000.STR has format version 3

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

    (SQL) INFO: SQLFiles.LST not found

    (SQL) INFO: Searching for SQL file /EXPORT_DB/ABAP/DB/SQLFiles.LST

    (SQL) INFO: found /EXPORT_DB/ABAP/DB/SQLFiles.LST

    (SQL) INFO: Trying to open /EXPORT_DB/ABAP/DB/SQLFiles.LST

    (SQL) INFO: /EXPORT_DB/ABAP/DB/SQLFiles.LST opened

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

    (SQL) INFO: SLEXC.SQL not found

    (SQL) INFO: Searching for SQL file /EXPORT_DB/ABAP/DB/ORA/SLEXC.SQL

    (SQL) INFO: found /EXPORT_DB/ABAP/DB/ORA/SLEXC.SQL

    (SQL) INFO: Trying to open /EXPORT_DB/ABAP/DB/ORA/SLEXC.SQL

    (SQL) INFO: /EXPORT_DB/ABAP/DB/ORA/SLEXC.SQL opened

    (SQL) ERROR: Invalid entry at line 5 in file /EXPORT_DB/ABAP/DB/ORA/SLEXC.SQL

    (SQL) ERROR: SQL list was not built successfully

    (DDL) ERROR: check_sql_list() failed for REPOLOAD

    (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 REPOLOAD

    (DB) INFO: disconnected from DB

    I've never seen this message, not sure to have to delete the line 5 with "ind:".

    Any help would be appreciated. Did you solve your problem ? How ?

    Regards,

    Stéphan

    Add comment
    10|10000 characters needed characters exceeded