sap errors and solutions

Just another SAP blog

Task failed with error: (SQL) SQL file ‘/soft/51050949/DATA_UNITS/EXP4/DB/HDB/SSEXC.SQL’ did not occur in ‘SQLFiles.LST’

Error:

This issue has encounter when you are doing  Solman 7.2 Installation on SAP HANA Database.

SWPM thrown error at  “Import ABAP” phase. When we verified in sapinst logs found the error  “R3load is failing for package SAPNTAB”. So gone through the SAPNTAB.log  and found “Task failed with error: (SQL) SQL file ‘/soft/51050949/DATA_UNITS/EXP*/DB/HDB/SDIC.SQL’ did not occur in ‘SQLFiles.LST’ ”

SAPNTAB.log

(GEN) INFO: /usr/sap/SID/SYS/exe/uc/linuxx86_64/R3load: START OF LOG: 20170419101308
(GEN) INFO: ====================================================
(GEN) INFO: KERNEL: release 749, patch number 200, code page [UNICODE]
(GEN) INFO: KERNEL: compile time “Mar 5 2017 03:51:13”, sccsid “@(#) $Id: //bas/749_STACK/src/R3ld/R3load/R3ldmain.c#3 $ SAP”
(GEN) INFO: FORMAT: data 1.10, logging “classic”, log level: 1
(GEN) INFO: ====================================================
(GEN) INFO: PROCENV: working directory “/tmp/sapinst_instdir/SOLMAN72SR1/SOLMAN72SR1/HDB/INSTALL/STD/ABAP”, process id 109141
(GEN) INFO: CMDLINE: “/usr/sap/SID/SYS/exe/uc/linuxx86_64/R3load -ctf I /soft/51050949/DATA_UNITS/EXP4/DATA/SAPNTAB.STR
/tmp/sapinst_instdir/SOLMAN72SR1/SOLMAN72SR1/HDB/INSTALL/STD/ABAP/DDLHDB.TPL SAPNTAB.TSK HDB -l SAPNTAB.log”
(GEN) INFO: ====================================================
(ENV) INFO: setting R3LOAD_ALLOW_MISSING_VER=TRUE
(GEN) INFO: ====================================================
(DMP) INFO: Resource usage: DATABASE times: 0.003/0.000/0.000 100.0%/0.0%/0.0% real/usr/sys
(GEN) INFO: /usr/sap/SID/SYS/exe/uc/linuxx86_64/R3load: job completed
(GEN) INFO: /usr/sap/SID/SYS/exe/uc/linuxx86_64/R3load: END OF LOG: 20170419101308
(GEN) INFO: /usr/sap/SID/SYS/exe/uc/linuxx86_64/R3load: START OF LOG: 20170419101308
(GEN) INFO: ====================================================
(GEN) INFO: KERNEL: release 749, patch number 200, code page [UNICODE]
(GEN) INFO: KERNEL: compile time “Mar 5 2017 03:51:13”, sccsid “@(#) $Id: //bas/749_STACK/src/R3ld/R3load/R3ldmain.c#3 $ SAP”
(GEN) INFO: FORMAT: data 1.10, logging “classic”, log level: 1
(GEN) INFO: ====================================================
(GEN) INFO: PROCENV: working directory “/tmp/sapinst_instdir/SOLMAN72SR1/SOLMAN72SR1/HDB/INSTALL/STD/ABAP”, process id 109145
(GEN) INFO: CMDLINE: “/usr/sap/SID/SYS/exe/uc/linuxx86_64/R3load -i SAPNTAB.cmd -dbcodepage 4103 -l SAPNTAB.log -c 100000 -loadprocedure dbsl -rowstorelist
/tmp/sapinst_instdir/SOLMAN72SR1/SOLMAN72SR1/HDB/INSTALL/STD/ABAP/rowstorelist.txt”
(GEN) INFO: ====================================================
(DBS) INFO: Connected to DB
(HDB) INFO: HANA Kernel version 1.00.122.08.1490178281
(HDB) INFO: SQLDBC 1.00.120.042.1474657934
(IMP) INFO: ====================================================
(ENV) INFO: setting R3LOAD_ALLOW_MISSING_VER=TRUE
(IMP) INFO: Starting create for object “SVERS” of type “table” #20170419101308
(IMP) ERROR: Task failed with error: (SQL) SQL file ‘/soft/51050949/DATA_UNITS/EXP4/DB/HDB/SDIC.SQL’ did not occur in ‘SQLFiles.LST’
(IMP) ERROR: (HDB) DBCreate failed
(IMP) INFO: Starting import for object “SVERS” of type “table” #20170419101308
(HDB) INFO: Loading data in table “SVERS” with DBSL #20170419101308
(IMP) ERROR: Task failed with error: (SQL) SQL file ‘/soft/51050949/DATA_UNITS/EXP4/DB/HDB/SDIC.SQL’ did not occur in ‘SQLFiles.LST’
(IMP) INFO: Starting create for object “SVERS” of type “merge” #20170419101308
(IMP) ERROR: Task failed with error: (HDB) Prepare/Read failed for ‘SELECT COUNT(*) FROM “DUMMY” WHERE EXISTS (SELECT * FROM “SVERS”)’
(IMP) ERROR: (HDB) DbSlErrorMsg rc = 0 ‘everything went well’
(IMP) ERROR: (HDB) invalid table name: Could not find table/view SVERS in schema SAPABAP1: line 1 col 58 (at pos 57)
(IMP) ERROR: (HDB) HDBexistsRow failed
(IMP) ERROR: (HDB) DBCreate failed
(IMP) INFO: Starting create for object “SVERS~0” of type “primary index” #20170419101308
(IMP) ERROR: Task failed with error: (SQL) SQL file ‘/soft/51050949/DATA_UNITS/EXP4/DB/HDB/SDIC.SQL’ did not occur in ‘SQLFiles.LST’
(IMP) ERROR: (HDB) DBCreate failed
(IMP) INFO: Starting create for object “SVERS” of type “unload” #20170419101308
(IMP) ERROR: Task failed with error: (HDB) DbSlExecute failed for DDL statement ‘ ALTER TABLE “SVERS” enable persistent merge

(IMP) ERROR: (HDB) DbSlErrorMsg rc = 0 ‘everything went well’
(IMP) ERROR: (HDB) invalid table name: SVERS: line 1 col 56 (at pos 55)
(IMP) ERROR: (HDB) DBCreate failed
(IMP) INFO: Starting create for object “DDLOG” of type “table” #20170419101308
(HDB) INFO: DDLOG created #20170419101308
(IMP) INFO: Finished create for object “DDLOG” of type “table” in 0 sec #20170419101308
(IMP) INFO: Starting create for object “DDLOG” of type “merge” #20170419101308
(HDB) INFO: DDLOG merged #20170419101308
(IMP) INFO: Finished create for object “DDLOG” of type “merge” in 0 sec #20170419101308
(IMP) INFO: Starting create for object “DDLOG~0” of type “primary index” #20170419101308
(HDB) INFO: DDLOG~0 created #20170419101308
(IMP) INFO: Finished create for object “DDLOG~0” of type “primary index” in 0 sec #20170419101308
(IMP) INFO: Starting create for object “DDLOG~DB2” of type “index” #20170419101308
(HDB) INFO: DDLOG~DB2 created #20170419101308
(IMP) INFO: Finished create for object “DDLOG~DB2” of type “index” in 0 sec #20170419101308
(IMP) INFO: Starting create for object “DDLOG” of type “unload” #20170419101308
(HDB) INFO: DDLOG unloaded #20170419101308
(IMP) INFO: Finished create for object “DDLOG” of type “unload” in 0 sec #20170419101308
(IMP) INFO: Starting create for object “DDNTF” of type “table” #20170419101308
(IMP) ERROR: Task failed with error: (SQL) SQL file ‘/soft/51050949/DATA_UNITS/EXP4/DB/HDB/SDIC.SQL’ did not occur in ‘SQLFiles.LST’
(IMP) ERROR: (HDB) DBCreate failed
(IMP) INFO: Starting import for object “DDNTF” of type “table” #20170419101308
(HDB) INFO: Loading data in table “DDNTF” with DBSL #20170419101308
(IMP) ERROR: Task failed with error: (SQL) SQL file ‘/soft/51050949/DATA_UNITS/EXP4/DB/HDB/SDIC.SQL’ did not occur in ‘SQLFiles.LST’
(IMP) INFO: Starting create for object “DDNTF” of type “merge” #20170419101308
(HDB) INFO: DDNTF merged #20170419101308
(IMP) INFO: Finished create for object “DDNTF” of type “merge” in 0 sec #20170419101308
(IMP) INFO: Starting create for object “DDNTF~0” of type “primary index” #20170419101308
(IMP) ERROR: Task failed with error: (SQL) SQL file ‘/soft/51050949/DATA_UNITS/EXP4/DB/HDB/SDIC.SQL’ did not occur in ‘SQLFiles.LST’
(IMP) ERROR: (HDB) DBCreate failed
(IMP) INFO: Starting create for object “DDNTF” of type “unload” #20170419101308
(HDB) INFO: DDNTF unloaded #20170419101308
(IMP) INFO: Finished create for object “DDNTF” of type “unload” in 0 sec #20170419101308
(IMP) INFO: Starting create for object “DDNTF_CONV_UC” of type “table” #20170419101308
(IMP) ERROR: Task failed with error: (SQL) SQL file ‘/soft/51050949/DATA_UNITS/EXP4/DB/HDB/SDIC.SQL’ did not occur in ‘SQLFiles.LST’
(IMP) ERROR: (HDB) DBCreate failed
(IMP) INFO: Starting import for object “DDNTF_CONV_UC” of type “table” #20170419101308
(HDB) INFO: Loading data in table “DDNTF_CONV_UC” with DBSL #20170419101308
(IMP) ERROR: Task failed with error: (SQL) SQL file ‘/soft/51050949/DATA_UNITS/EXP4/DB/HDB/SDIC.SQL’ did not occur in ‘SQLFiles.LST’
(IMP) INFO: Starting create for object “DDNTF_CONV_UC” of type “merge” #20170419101308
(HDB) INFO: DDNTF_CONV_UC merged #20170419101308
(IMP) INFO: Finished create for object “DDNTF_CONV_UC” of type “merge” in 0 sec #20170419101308
(IMP) INFO: Starting create for object “DDNTF_CONV_UC~0” of type “primary index” #20170419101308
(IMP) ERROR: Task failed with error: (SQL) SQL file ‘/soft/51050949/DATA_UNITS/EXP4/DB/HDB/SDIC.SQL’ did not occur in ‘SQLFiles.LST’
(IMP) ERROR: (HDB) DBCreate failed
(IMP) INFO: Starting create for object “DDNTF_CONV_UC” of type “unload” #20170419101308
(HDB) INFO: DDNTF_CONV_UC unloaded #20170419101308
(IMP) INFO: Finished create for object “DDNTF_CONV_UC” of type “unload” in 0 sec #20170419101308
(IMP) INFO: Starting create for object “DDNTT” of type “table” #20170419101308
(IMP) ERROR: Task failed with error: (SQL) SQL file ‘/soft/51050949/DATA_UNITS/EXP4/DB/HDB/SDIC.SQL’ did not occur in ‘SQLFiles.LST’
(IMP) ERROR: (HDB) DBCreate failed
(IMP) INFO: Starting import for object “DDNTT” of type “table” #20170419101308
(HDB) INFO: Loading data in table “DDNTT” with DBSL #20170419101308
(IMP) ERROR: Task failed with error: (SQL) SQL file ‘/soft/51050949/DATA_UNITS/EXP4/DB/HDB/SDIC.SQL’ did not occur in ‘SQLFiles.LST’
(IMP) INFO: Starting create for object “DDNTT” of type “merge” #20170419101308
(IMP) ERROR: Task failed with error: (HDB) Prepare/Read failed for ‘SELECT COUNT(*) FROM “DUMMY” WHERE EXISTS (SELECT * FROM “DDNTT”)’
(IMP) ERROR: (HDB) DbSlErrorMsg rc = 0 ‘everything went well’
(IMP) ERROR: (HDB) invalid table name: Could not find table/view DDNTT in schema SAPABAP1: line 1 col 58 (at pos 57)
(IMP) ERROR: (HDB) HDBexistsRow failed
(IMP) ERROR: (HDB) DBCreate failed
(IMP) INFO: Starting create for object “DDNTT~0” of type “primary index” #20170419101308
(IMP) ERROR: Task failed with error: (SQL) SQL file ‘/soft/51050949/DATA_UNITS/EXP4/DB/HDB/SDIC.SQL’ did not occur in ‘SQLFiles.LST’
(IMP) ERROR: (HDB) DBCreate failed
(IMP) INFO: Starting create for object “DDNTT” of type “unload” #20170419101308
(IMP) ERROR: Task failed with error: (HDB) DbSlExecute failed for DDL statement ‘ ALTER TABLE “DDNTT” enable persistent merge

(IMP) ERROR: (HDB) DbSlErrorMsg rc = 0 ‘everything went well’
(IMP) ERROR: (HDB) invalid table name: DDNTT: line 1 col 56 (at pos 55)
(IMP) ERROR: (HDB) DBCreate failed
(IMP) INFO: Starting create for object “DDNTT_CONV_UC” of type “table” #20170419101308
(IMP) ERROR: Task failed with error: (SQL) SQL file ‘/soft/51050949/DATA_UNITS/EXP4/DB/HDB/SDIC.SQL’ did not occur in ‘SQLFiles.LST’
(IMP) ERROR: (HDB) DBCreate failed
(IMP) INFO: Starting import for object “DDNTT_CONV_UC” of type “table” #20170419101308
(HDB) INFO: Loading data in table “DDNTT_CONV_UC” with DBSL #20170419101308
(IMP) ERROR: Task failed with error: (SQL) SQL file ‘/soft/51050949/DATA_UNITS/EXP4/DB/HDB/SDIC.SQL’ did not occur in ‘SQLFiles.LST’
(IMP) INFO: Starting create for object “DDNTT_CONV_UC” of type “merge” #20170419101308
(IMP) ERROR: Task failed with error: (HDB) Prepare/Read failed for ‘SELECT COUNT(*) FROM “DUMMY” WHERE EXISTS (SELECT * FROM “DDNTT_CONV_UC”)’
(IMP) ERROR: (HDB) DbSlErrorMsg rc = 0 ‘everything went well’
(IMP) ERROR: (HDB) invalid table name: Could not find table/view DDNTT_CONV_UC in schema SAPABAP1: line 1 col 58 (at pos 57)
(IMP) ERROR: (HDB) HDBexistsRow failed
(IMP) ERROR: (HDB) DBCreate failed
(IMP) INFO: Starting create for object “DDNTT_CONV_UC~0” of type “primary index” #20170419101308
(IMP) ERROR: Task failed with error: (SQL) SQL file ‘/soft/51050949/DATA_UNITS/EXP4/DB/HDB/SDIC.SQL’ did not occur in ‘SQLFiles.LST’
(IMP) ERROR: (HDB) DBCreate failed
(IMP) INFO: Starting create for object “DDNTT_CONV_UC” of type “unload” #20170419101308
(IMP) ERROR: Task failed with error: (HDB) DbSlExecute failed for DDL statement ‘ ALTER TABLE “DDNTT_CONV_UC” enable
persistent merge ‘
(IMP) ERROR: (HDB) DbSlErrorMsg rc = 0 ‘everything went well’
(IMP) ERROR: (HDB) invalid table name: DDNTT_CONV_UC: line 1 col 56 (at pos 55)
(IMP) ERROR: (HDB) DBCreate failed
(IMP) INFO: Starting create for object “DDXTF” of type “table” #20170419101308
(IMP) ERROR: Task failed with error: (SQL) SQL file ‘/soft/51050949/DATA_UNITS/EXP4/DB/HDB/SSEXC.SQL’ did not occur in ‘SQLFiles.LST’
(IMP) ERROR: (HDB) DBCreate failed
(IMP) INFO: Starting import for object “DDXTF” of type “table” #20170419101308
(HDB) INFO: Loading data in table “DDXTF” with DBSL #20170419101308
(IMP) ERROR: Task failed with error: (SQL) SQL file ‘/soft/51050949/DATA_UNITS/EXP4/DB/HDB/SSEXC.SQL’ did not occur in ‘SQLFiles.LST’
(IMP) INFO: Starting create for object “DDXTF” of type “merge” #20170419101308
(HDB) INFO: DDXTF merged #20170419101308
(IMP) INFO: Finished create for object “DDXTF” of type “merge” in 0 sec #20170419101308
(IMP) INFO: Starting create for object “DDXTF~0” of type “primary index” #20170419101308
(IMP) ERROR: Task failed with error: (SQL) SQL file ‘/soft/51050949/DATA_UNITS/EXP4/DB/HDB/SSEXC.SQL’ did not occur in ‘SQLFiles.LST’
(IMP) ERROR: (HDB) DBCreate failed
(IMP) INFO: Starting create for object “DDXTF” of type “unload” #20170419101308
(HDB) INFO: DDXTF unloaded #20170419101308
(IMP) INFO: Finished create for object “DDXTF” of type “unload” in 0 sec #20170419101308
(IMP) INFO: Starting create for object “DDXTF_CONV_UC” of type “table” #20170419101308
(IMP) ERROR: Task failed with error: (SQL) SQL file ‘/soft/51050949/DATA_UNITS/EXP4/DB/HDB/SSEXC.SQL’ did not occur in ‘SQLFiles.LST’
(IMP) ERROR: (HDB) DBCreate failed
(IMP) INFO: Starting import for object “DDXTF_CONV_UC” of type “table” #20170419101308
(HDB) INFO: Loading data in table “DDXTF_CONV_UC” with DBSL #20170419101308
(IMP) ERROR: Task failed with error: (SQL) SQL file ‘/soft/51050949/DATA_UNITS/EXP4/DB/HDB/SSEXC.SQL’ did not occur in ‘SQLFiles.LST’
(IMP) INFO: Starting create for object “DDXTF_CONV_UC” of type “merge” #20170419101308
(HDB) INFO: DDXTF_CONV_UC merged #20170419101308
(IMP) INFO: Finished create for object “DDXTF_CONV_UC” of type “merge” in 0 sec #20170419101308
(IMP) INFO: Starting create for object “DDXTF_CONV_UC~0” of type “primary index” #20170419101308
(IMP) ERROR: Task failed with error: (SQL) SQL file ‘/soft/51050949/DATA_UNITS/EXP4/DB/HDB/SSEXC.SQL’ did not occur in ‘SQLFiles.LST’
(IMP) ERROR: (HDB) DBCreate failed
(IMP) INFO: Starting create for object “DDXTF_CONV_UC” of type “unload” #20170419101308
(HDB) INFO: DDXTF_CONV_UC unloaded #20170419101308
(IMP) INFO: Finished create for object “DDXTF_CONV_UC” of type “unload” in 0 sec #20170419101308
(IMP) INFO: Starting create for object “DDXTT” of type “table” #20170419101308
(IMP) ERROR: Task failed with error: (SQL) SQL file ‘/soft/51050949/DATA_UNITS/EXP4/DB/HDB/SSEXC.SQL’ did not occur in ‘SQLFiles.LST’
(IMP) ERROR: (HDB) DBCreate failed
(IMP) INFO: Starting import for object “DDXTT” of type “table” #20170419101308
(HDB) INFO: Loading data in table “DDXTT” with DBSL #20170419101308
(IMP) ERROR: Task failed with error: (SQL) SQL file ‘/soft/51050949/DATA_UNITS/EXP4/DB/HDB/SSEXC.SQL’ did not occur in ‘SQLFiles.LST’
(IMP) INFO: Starting create for object “DDXTT” of type “merge” #20170419101308
(HDB) INFO: DDXTT merged #20170419101308
(IMP) INFO: Finished create for object “DDXTT” of type “merge” in 0 sec #20170419101308
(IMP) INFO: Starting create for object “DDXTT~0” of type “primary index” #20170419101308
(IMP) ERROR: Task failed with error: (SQL) SQL file ‘/soft/51050949/DATA_UNITS/EXP4/DB/HDB/SSEXC.SQL’ did not occur in ‘SQLFiles.LST’
(IMP) ERROR: (HDB) DBCreate failed
(IMP) INFO: Starting create for object “DDXTT” of type “unload” #20170419101308
(HDB) INFO: DDXTT unloaded #20170419101308
(IMP) INFO: Finished create for object “DDXTT” of type “unload” in 0 sec #20170419101308
(IMP) INFO: Starting create for object “DDXTT_CONV_UC” of type “table” #20170419101308
(IMP) ERROR: Task failed with error: (SQL) SQL file ‘/soft/51050949/DATA_UNITS/EXP4/DB/HDB/SSEXC.SQL’ did not occur in ‘SQLFiles.LST’
(IMP) ERROR: (HDB) DBCreate failed
(IMP) INFO: Starting import for object “DDXTT_CONV_UC” of type “table” #20170419101308
(HDB) INFO: Loading data in table “DDXTT_CONV_UC” with DBSL #20170419101308
(IMP) ERROR: Task failed with error: (SQL) SQL file ‘/soft/51050949/DATA_UNITS/EXP4/DB/HDB/SSEXC.SQL’ did not occur in ‘SQLFiles.LST’
(IMP) INFO: Starting create for object “DDXTT_CONV_UC” of type “merge” #20170419101308
(HDB) INFO: DDXTT_CONV_UC merged #20170419101308
(IMP) INFO: Finished create for object “DDXTT_CONV_UC” of type “merge” in 0 sec #20170419101308
(IMP) INFO: Starting create for object “DDXTT_CONV_UC~0” of type “primary index” #20170419101308
(IMP) ERROR: Task failed with error: (SQL) SQL file ‘/soft/51050949/DATA_UNITS/EXP4/DB/HDB/SSEXC.SQL’ did not occur in ‘SQLFiles.LST’
(IMP) ERROR: (HDB) DBCreate failed
(IMP) INFO: Starting create for object “DDXTT_CONV_UC” of type “unload” #20170419101308
(HDB) INFO: DDXTT_CONV_UC unloaded #20170419101308
(IMP) INFO: Finished create for object “DDXTT_CONV_UC” of type “unload” in 0 sec #20170419101308
(DBS) INFO: Disconnected from DB
(GEN) INFO: ====================================================
(DMP) INFO: Resource usage: DATABASE times: 0.141/0.012/0.008 97.4%/75.0%/100.0% real/usr/sys
(DMP) INFO: Resource usage: FILE times: 0.004/0.004/0.000 2.6%/25.0%/0.0% real/usr/sys
(GEN) ERROR: /usr/sap/SID/SYS/exe/uc/linuxx86_64/R3load: job finished with 33 error(s)
(GEN) INFO: /usr/sap/SID/SYS/exe/uc/linuxx86_64/R3load: END OF LOG: 20170419101308




Solution:

SQLFiles.LST file should be exist in Export dump, but it missed in Solman 7.2 DVD So it’s required to create SQLFiles.LST under export folders

/soft/51050949/DATA_UNITS/EXP1/DB/SQLFiles.LST

/soft/51050949/DATA_UNITS/EXP2/DB/SQLFiles.LST

/soft/51050949/DATA_UNITS/EXP3/DB/SQLFiles.LST

/soft/51050949/DATA_UNITS/EXP4/DB/SQLFiles.LST

After creating SQLFiles.LST file add APPL2.SQL, SDIC.SQL and SSEXC.SQL  file names in it.

The *.SQL files were located in four export dump folders

/soft/51050949/DATA_UNITS/EXP1/DB/HDB

/soft/51050949/DATA_UNITS/EXP2/DB/HDB

/soft/51050949/DATA_UNITS/EXP3/DB/HDB

/soft/51050949/DATA_UNITS/EXP4/DB/HDB

Refer below blog to get more about this issue.

https://answers.sap.com/questions/142781/import-abap-error-on-sapntab-package-sap-hana-solm.html

 

Updated: April 19, 2017 — 4:36 pm

Leave a Reply

Your email address will not be published. Required fields are marked *

sap errors and solutions © 2016 Frontier Theme
Copy Protected by Chetan's WP-Copyprotect.