ABAP Import error during system copy

[former_member237791]

Hi

I am trying to do a system copy of a NW 7.4 system . The source system is 7.4 SR1 while the target system is 7.4 SR2. I have successfully done the export, but during the import phase 1 of the packages is failing .

TRACE: 2014-11-27 16:04:07 com.sap.inst.migmon.LoadTask processPackage

Loading of 'SAPAPPL1_27' starting import package into database:

/usr/sap/UI5/SYS/exe/uc/linuxx86_64/R3load -i SAPAPPL1_27.cmd -dbcodepage 4103 -l SAPAPPL1_27.log -stop_on_error -loadprocedure fast LOAD:DEF_CRT

INFO: 2014-11-27 16:06:14 com.sap.inst.migmon.LoadTask run_report

Monitor jobs: running 2, waiting 89, completed 3, failed 1, total 95  error processing of package SAPAPPL1_27

ERROR: 2014-11-27 16:06:14 com.sap.inst.migmon.LoadTask run

Loading of 'SAPAPPL1_27' import package is interrupted with R3load error.

Process '/usr/sap/UI5/SYS/exe/uc/linuxx86_64/R3load -i SAPAPPL1_27.cmd -dbcodepage 4103 -l SAPAPPL1_27.log -stop_on_error -loadpr

For mode details see 'SAPAPPL1_27.log' file.

Standard error output:

/usr/sap/UI5/SYS/exe/uc/linuxx86_64/R3load=>sapparam(1c): No Profile used.

/usr/sap/UI5/SYS/exe/uc/linuxx86_64/R3load=>sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

sh: module: line 1: syntax error: unexpected end of file

sh: error importing function definition for `BASH_FUNC_module'

sh: module: line 1: syntax error: unexpected end of file

sh: error importing function definition for `BASH_FUNC_module'

Here is the log of the SAPAPPL1_27.log

cat SAPAPPL1_27.log

/usr/sap/UI5/SYS/exe/uc/linuxx86_64/R3load: START OF LOG: 20141127160407

/usr/sap/UI5/SYS/exe/uc/linuxx86_64/R3load: sccsid @(#) $Id: //bas/742_REL/src/R3ld/R3load/R3ldmain.c#4 $ SAP

/usr/sap/UI5/SYS/exe/uc/linuxx86_64/R3load: version R7.42/V1.8 [UNICODE]

Compiled Sep  1 2014 18:12:24

/usr/sap/UI5/SYS/exe/uc/linuxx86_64/R3load -ctf I /exp/ABAP/DATA/SAPAPPL1_27.STR /tmp/sapinst_instdir/NW740SR2/DB6/COPY/SYSTEM/STD/AS-ABAP/DDLDB6.TPL SAPAPPL1_27.TSK DB6 -l SAPAPPL1_27.log

-------------------- Start of patch information ------------------------

patchinfo (patches.h): (0.013) R3load dependency loop if calles with -o V option (note 2044380)

DBSL patchinfo (patches.h): (0.015) DB6: seg fault on V10.5 FP4 during connect processing (note 2056603)

--------------------- End of patch information -------------------------

process id 35006

(RTF) WARNING: CREATE FUNCTION template not found in control file "/tmp/sapinst_instdir/NW740SR2/DB6/COPY/SYSTEM/STD/AS-ABAP/DDLDB6.TPL"

(RTF) WARNING: DROP FUNCTION template not found in control file "/tmp/sapinst_instdir/NW740SR2/DB6/COPY/SYSTEM/STD/AS-ABAP/DDLDB6.TPL"

(RDI) WARNING: /exp/ABAP/DATA/SAPAPPL1_27.STR: cannot find version token "ver:" at line 1

(RDI) WARNING: /exp/ABAP/DATA/SAPAPPL1_27.STR: unknown file format, assuming version 2

/usr/sap/UI5/SYS/exe/uc/linuxx86_64/R3load: job completed

(STAT) DATABASE times: 0.011/0.004/0.001 100.0%/100.0%/100.0% real/usr/sys.

/usr/sap/UI5/SYS/exe/uc/linuxx86_64/R3load: END OF LOG: 20141127160407

/usr/sap/UI5/SYS/exe/uc/linuxx86_64/R3load: START OF LOG: 20141127160407

/usr/sap/UI5/SYS/exe/uc/linuxx86_64/R3load: sccsid @(#) $Id: //bas/742_REL/src/R3ld/R3load/R3ldmain.c#4 $ SAP

/usr/sap/UI5/SYS/exe/uc/linuxx86_64/R3load: version R7.42/V1.8 [UNICODE]

Compiled Sep  1 2014 18:12:24

/usr/sap/UI5/SYS/exe/uc/linuxx86_64/R3load -i SAPAPPL1_27.cmd -dbcodepage 4103 -l SAPAPPL1_27.log -stop_on_error -loadprocedure fast LOAD:DEF_CRT

-------------------- Start of patch information ------------------------

patchinfo (patches.h): (0.013) R3load dependency loop if calles with -o V option (note 2044380)

DBSL patchinfo (patches.h): (0.015) DB6: seg fault on V10.5 FP4 during connect processing (note 2056603)

--------------------- End of patch information -------------------------

process id 35012

(DB) INFO: connected to DB

(GSI) INFO: dbname   = "UI5                                                                                                                             "

(GSI) INFO: vname    = "DB6                             "

(GSI) INFO: hostname = "UNKNOWN                                                         "

(GSI) INFO: sysname  = "Linux"

(GSI) INFO: nodename = "sapui5"

(GSI) INFO: release  = "2.6.32-504.el6.x86_64"

(GSI) INFO: version  = "#1 SMP Tue Sep 16 01:56:35 EDT 2014"

(GSI) INFO: machine  = "x86_64"

(RTF) WARNING: CREATE FUNCTION template not found in control file "/tmp/sapinst_instdir/NW740SR2/DB6/COPY/SYSTEM/STD/AS-ABAP/DDLDB6.TPL"

(RTF) WARNING: DROP FUNCTION template not found in control file "/tmp/sapinst_instdir/NW740SR2/DB6/COPY/SYSTEM/STD/AS-ABAP/DDLDB6.TPL"

(RDI) WARNING: /exp/ABAP/DATA/SAPAPPL1_27.STR: cannot find version token "ver:" at line 1

(RDI) WARNING: /exp/ABAP/DATA/SAPAPPL1_27.STR: unknown file format, assuming version 2

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

(SQL) INFO: SQLFiles.LST not found

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

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

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

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

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

(SQL) INFO: APPL1.SQL not found

(SQL) INFO: Searching for SQL file /exp/ABAP/DB/DB6/APPL1.SQL

(SQL) INFO: /exp/ABAP/DB/DB6/APPL1.SQL not found

(DB) INFO: SMIMCONT1 created #20141127160408

(DB) INFO: SMIMCONT1~0 created #20141127160408

(DB6) [IBM][CLI Driver][DB2/LINUXX8664] SQL0150N  The target fullselect, view, typed table, materialized query table, range-clustered table, or staging table in the INSERT, DELETE, UPDATE, MERGE, or TRUNCATE statement is a target for which the requested operation is not permitted.  SQLSTATE=42807

(DB6) INFO: Virtual Table SMIMCONT1 has been successfully converted ( ignore SQL0150N )

(DB6) Using LOAD API for table SMIMCONT1

(IMP) INFO: import of SMIMCONT1 completed (412726 rows) #20141127160547

(DB) INFO: SMIME_CAPABILITY created #20141127160547

(DB) INFO: SMIME_CAPABILITY~0 created #20141127160547

(IMP) INFO: import of SMIME_CAPABILITY completed (0 rows) #20141127160547

(DB) INFO: SMIME_CAPA_CRYPT created #20141127160547

(DB) INFO: SMIME_CAPA_CRYPT~0 created #20141127160547

(IMP) INFO: import of SMIME_CAPA_CRYPT completed (0 rows) #20141127160547

(DB) INFO: SMIME_CAPA_SIGN created #20141127160547

(DB) INFO: SMIME_CAPA_SIGN~0 created #20141127160547

(IMP) INFO: import of SMIME_CAPA_SIGN completed (0 rows) #20141127160547

(DB) INFO: SMI_BORDER_HIST created #20141127160547

(DB) INFO: SMI_BORDER_HIST~0 created #20141127160547

(IMP) INFO: import of SMI_BORDER_HIST completed (0 rows) #20141127160547

(DB) INFO: SMI_HEADER created #20141127160547

(DB) INFO: SMI_HEADER~0 created #20141127160547

(IMP) INFO: import of SMI_HEADER completed (0 rows) #20141127160547

(DB) INFO: SMI_ITEM created #20141127160547

(DB) INFO: SMI_ITEM~0 created #20141127160547

(IMP) INFO: import of SMI_ITEM completed (0 rows) #20141127160547

(DB) INFO: SMI_RUNTIME_INFO created #20141127160547

(DB) INFO: SMI_RUNTIME_INFO~0 created #20141127160547

(IMP) INFO: import of SMI_RUNTIME_INFO completed (0 rows) #20141127160547

(DB) INFO: SMI_TIMESERIES created #20141127160547

(DB) INFO: SMI_TIMESERIES~0 created #20141127160547

(IMP) INFO: import of SMI_TIMESERIES completed (0 rows) #20141127160547

(DB) INFO: SMI_USER_RNTM created #20141127160547

(DB) INFO: SMI_USER_RNTM~0 created #20141127160547

(IMP) INFO: import of SMI_USER_RNTM completed (0 rows) #20141127160547

(DB) INFO: SMI_VOICE_CUST created #20141127160547

(DB) INFO: SMI_VOICE_CUST~0 created #20141127160548

(IMP) INFO: import of SMI_VOICE_CUST completed (0 rows) #20141127160548

(DB) INFO: SMJV created #20141127160548

(DB) INFO: SMJV~0 created #20141127160548

(IMP) INFO: import of SMJV completed (0 rows) #20141127160548

(DB) INFO: SMMAIN created #20141127160548

(DB) INFO: SMMAIN~0 created #20141127160548

(DB) INFO: SMMAIN~001 created #20141127160548

(DB6) [IBM][CLI Driver][DB2/LINUXX8664] SQL0150N  The target fullselect, view, typed table, materialized query table, range-clustered table, or staging table in the INSERT, DELETE, UPDATE, MERGE, or TRUNCATE statement is a target for which the requested operation is not permitted.  SQLSTATE=42807

(DB6) INFO: Virtual Table SMMAIN has been successfully converted ( ignore SQL0150N )

(DB6) Using LOAD API for table SMMAIN

(IMP) INFO: import of SMMAIN completed (126577 rows) #20141127160600

(DB) INFO: SMMESSAGE created #20141127160600

(DB) INFO: SMMESSAGE~0 created #20141127160600

(DB6) [IBM][CLI Driver][DB2/LINUXX8664] SQL0150N  The target fullselect, view, typed table, materialized query table, range-clustered table, or staging table in the INSERT, DELETE, UPDATE, MERGE, or TRUNCATE statement is a target for which the requested operation is not permitted.  SQLSTATE=42807

(DB6) INFO: Virtual Table SMMESSAGE has been successfully converted ( ignore SQL0150N )

(DB6) Using LOAD API for table SMMESSAGE

(IMP) INFO: import of SMMESSAGE completed (37356 rows) #20141127160601

(DB) INFO: SMPARAM created #20141127160601

(DB) INFO: SMPARAM~0 created #20141127160601

(DB6) [IBM][CLI Driver][DB2/LINUXX8664] SQL0150N  The target fullselect, view, typed table, materialized query table, range-clustered table, or staging table in the INSERT, DELETE, UPDATE, MERGE, or TRUNCATE statement is a target for which the requested operation is not permitted.  SQLSTATE=42807

(DB6) INFO: Virtual Table SMPARAM has been successfully converted ( ignore SQL0150N )

(DB6) Using LOAD API for table SMPARAM

(IMP) INFO: import of SMPARAM completed (191280 rows) #20141127160608

(DB) INFO: SMPS created #20141127160608

(DB) INFO: SMPS~0 created #20141127160608

(DB6) [IBM][CLI Driver][DB2/LINUXX8664] SQL0150N  The target fullselect, view, typed table, materialized query table, range-clustered table, or staging table in the INSERT, DELETE, UPDATE, MERGE, or TRUNCATE statement is a target for which the requested operation is not permitted.  SQLSTATE=42807

(DB6) INFO: Virtual Table SMPS has been successfully converted ( ignore SQL0150N )

(DB6) Using LOAD API for table SMPS

(IMP) INFO: import of SMPS completed (38449 rows) #20141127160610

(DB) INFO: SMRL created #20141127160610

(DB) INFO: SMRL~0 created #20141127160610

(DB6) [IBM][CLI Driver][DB2/LINUXX8664] SQL0150N  The target fullselect, view, typed table, materialized query table, range-clustered table, or staging table in the INSERT, DELETE, UPDATE, MERGE, or TRUNCATE statement is a target for which the requested operation is not permitted.  SQLSTATE=42807

(DB6) INFO: Virtual Table SMRL has been successfully converted ( ignore SQL0150N )

(DB6) Using LOAD API for table SMRL

(IMP) INFO: import of SMRL completed (76586 rows) #20141127160613

(DB) INFO: SMRTA created #20141127160613

(DB) INFO: SMRTA~0 created #20141127160613

(DB6) [IBM][CLI Driver][DB2/LINUXX8664] SQL0150N  The target fullselect, view, typed table, materialized query table, range-clustered table, or staging table in the INSERT, DELETE, UPDATE, MERGE, or TRUNCATE statement is a target for which the requested operation is not permitted.  SQLSTATE=42807

(DB6) INFO: Virtual Table SMRTA has been successfully converted ( ignore SQL0150N )

(DB6) LOAD API is not used for table with small buffer

(DB6) Using ARRAY INSERT for table SMRTA

(IMP) INFO: import of SMRTA completed (7 rows) #20141127160613

(DB) INFO: SMSCMAID created #20141127160614

(DB) INFO: SMSCMAID~0 created #20141127160614

(DB) INFO: SMSCMAID~A01 created #20141127160614

(DB6) [IBM][CLI Driver][DB2/LINUXX8664] SQL0150N  The target fullselect, view, typed table, materialized query table, range-clustered table, or staging table in the INSERT, DELETE, UPDATE, MERGE, or TRUNCATE statement is a target for which the requested operation is not permitted.  SQLSTATE=42807

(DB6) INFO: Virtual Table SMSCMAID has been successfully converted ( ignore SQL0150N )

(DB6) LOAD API is not used for table with small buffer

(DB6) Using ARRAY INSERT for table SMSCMAID

(DB6) [IBM][CLI Driver][DB2/LINUXX8664] SQL0803N  One or more values in the INSERT statement, UPDATE statement, or foreign key update caused by a DELETE statement are not valid because the primary key, unique constraint or unique index identified by "2" constrains table "SAPUI5.SMSCMAID" from having duplicate values for the index key.  SQLSTATE=01661

row=2

(IMP) ERROR: ExeFastload: rc = 2

(DB) INFO: disconnected from DB

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

(STAT) DATABASE times: 91.359/2.981/0.198 72.3%/19.9%/18.2% real/usr/sys.

(STAT) FILE    times: 34.928/12.027/0.891 27.7%/80.1%/81.8% real/usr/sys.

/usr/sap/UI5/SYS/exe/uc/linuxx86_64/R3load: END OF LOG: 2014112716061

Can anyone tell what could be the issue

[srinivasan_vinayagam]

Hi Haider,

1. Update the kernel patch level equal to Source system.

2.Check the permission for export saved directory

3.If possible copy the export from to where your saved the export copies.

Regards,

V Srinivasan

[former_member237791]

By the way, the system is

Linux sapui5 2.6.32-504.el6.x86_64 #1 SMP Tue Sep 16 01:56:35 EDT 2014 x86_64 x86_64 x86_64 GNU/Linux

and the database being used is DB2 10.5.3

[former_member185239]

Hi Haider,

Paste the SAPAPPL1_27.log file and also try to update R3load , R3trans and tp.

Rebuild the SAPAPPL1_27.TSK file

R3laod -make_only SAPAPPL1_27.TSK

Also do paste latest updated 5 logs.

With Regards

Ashutosh Chaturvedi

[former_member237791]

Thanks Ashutosh for your quick response

SAPAPPL1_27.log is also pasted in the original question. Maybe I should bold the line from where it starts  🙂

The import stops because of this 1 package, so I had to redo everything again. The import is still processing the other packages and as soon as it reaches the end I will post the latest log for the updates.

Here is the log again

cat SAPAPPL1_27.log

/usr/sap/UI5/SYS/exe/uc/linuxx86_64/R3load: START OF LOG: 20141127160407

/usr/sap/UI5/SYS/exe/uc/linuxx86_64/R3load: sccsid @(#) $Id: //bas/742_REL/src/R3ld/R3load/R3ldmain.c#4 $ SAP

/usr/sap/UI5/SYS/exe/uc/linuxx86_64/R3load: version R7.42/V1.8 [UNICODE]

Compiled Sep  1 2014 18:12:24

/usr/sap/UI5/SYS/exe/uc/linuxx86_64/R3load -ctf I /exp/ABAP/DATA/SAPAPPL1_27.STR /tmp/sapinst_instdir/NW740SR2/DB6/COPY/SYSTEM/STD/AS-ABAP/DDLDB6.TPL SAPAPPL1_27.TSK DB6 -l SAPAPPL1_27.log

-------------------- Start of patch information ------------------------

patchinfo (patches.h): (0.013) R3load dependency loop if calles with -o V option (note 2044380)

DBSL patchinfo (patches.h): (0.015) DB6: seg fault on V10.5 FP4 during connect processing (note 2056603)

--------------------- End of patch information -------------------------

process id 35006

(RTF) WARNING: CREATE FUNCTION template not found in control file "/tmp/sapinst_instdir/NW740SR2/DB6/COPY/SYSTEM/STD/AS-ABAP/DDLDB6.TPL"

(RTF) WARNING: DROP FUNCTION template not found in control file "/tmp/sapinst_instdir/NW740SR2/DB6/COPY/SYSTEM/STD/AS-ABAP/DDLDB6.TPL"

(RDI) WARNING: /exp/ABAP/DATA/SAPAPPL1_27.STR: cannot find version token "ver:" at line 1

(RDI) WARNING: /exp/ABAP/DATA/SAPAPPL1_27.STR: unknown file format, assuming version 2

/usr/sap/UI5/SYS/exe/uc/linuxx86_64/R3load: job completed

(STAT) DATABASE times: 0.011/0.004/0.001 100.0%/100.0%/100.0% real/usr/sys.

/usr/sap/UI5/SYS/exe/uc/linuxx86_64/R3load: END OF LOG: 20141127160407

/usr/sap/UI5/SYS/exe/uc/linuxx86_64/R3load: START OF LOG: 20141127160407

/usr/sap/UI5/SYS/exe/uc/linuxx86_64/R3load: sccsid @(#) $Id: //bas/742_REL/src/R3ld/R3load/R3ldmain.c#4 $ SAP

/usr/sap/UI5/SYS/exe/uc/linuxx86_64/R3load: version R7.42/V1.8 [UNICODE]

Compiled Sep  1 2014 18:12:24

/usr/sap/UI5/SYS/exe/uc/linuxx86_64/R3load -i SAPAPPL1_27.cmd -dbcodepage 4103 -l SAPAPPL1_27.log -stop_on_error -loadprocedure fast LOAD:DEF_CRT

-------------------- Start of patch information ------------------------

patchinfo (patches.h): (0.013) R3load dependency loop if calles with -o V option (note 2044380)

DBSL patchinfo (patches.h): (0.015) DB6: seg fault on V10.5 FP4 during connect processing (note 2056603)

--------------------- End of patch information -------------------------

process id 35012

(DB) INFO: connected to DB

(GSI) INFO: dbname   = "UI5                                                                                                                             "

(GSI) INFO: vname    = "DB6                             "

(GSI) INFO: hostname = "UNKNOWN                                                         "

(GSI) INFO: sysname  = "Linux"

(GSI) INFO: nodename = "sapui5"

(GSI) INFO: release  = "2.6.32-504.el6.x86_64"

(GSI) INFO: version  = "#1 SMP Tue Sep 16 01:56:35 EDT 2014"

(GSI) INFO: machine  = "x86_64"

(RTF) WARNING: CREATE FUNCTION template not found in control file "/tmp/sapinst_instdir/NW740SR2/DB6/COPY/SYSTEM/STD/AS-ABAP/DDLDB6.TPL"

(RTF) WARNING: DROP FUNCTION template not found in control file "/tmp/sapinst_instdir/NW740SR2/DB6/COPY/SYSTEM/STD/AS-ABAP/DDLDB6.TPL"

(RDI) WARNING: /exp/ABAP/DATA/SAPAPPL1_27.STR: cannot find version token "ver:" at line 1

(RDI) WARNING: /exp/ABAP/DATA/SAPAPPL1_27.STR: unknown file format, assuming version 2

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

(SQL) INFO: SQLFiles.LST not found

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

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

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

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

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

(SQL) INFO: APPL1.SQL not found

(SQL) INFO: Searching for SQL file /exp/ABAP/DB/DB6/APPL1.SQL

(SQL) INFO: /exp/ABAP/DB/DB6/APPL1.SQL not found

(DB) INFO: SMIMCONT1 created #20141127160408

(DB) INFO: SMIMCONT1~0 created #20141127160408

(DB6) [IBM][CLI Driver][DB2/LINUXX8664] SQL0150N  The target fullselect, view, typed table, materialized query table, range-clustered table, or staging table in the INSERT, DELETE, UPDATE, MERGE, or TRUNCATE statement is a target for which the requested operation is not permitted.  SQLSTATE=42807

(DB6) INFO: Virtual Table SMIMCONT1 has been successfully converted ( ignore SQL0150N )

(DB6) Using LOAD API for table SMIMCONT1

(IMP) INFO: import of SMIMCONT1 completed (412726 rows) #20141127160547

(DB) INFO: SMIME_CAPABILITY created #20141127160547

(DB) INFO: SMIME_CAPABILITY~0 created #20141127160547

(IMP) INFO: import of SMIME_CAPABILITY completed (0 rows) #20141127160547

(DB) INFO: SMIME_CAPA_CRYPT created #20141127160547

(DB) INFO: SMIME_CAPA_CRYPT~0 created #20141127160547

(IMP) INFO: import of SMIME_CAPA_CRYPT completed (0 rows) #20141127160547

(DB) INFO: SMIME_CAPA_SIGN created #20141127160547

(DB) INFO: SMIME_CAPA_SIGN~0 created #20141127160547

(IMP) INFO: import of SMIME_CAPA_SIGN completed (0 rows) #20141127160547

(DB) INFO: SMI_BORDER_HIST created #20141127160547

(DB) INFO: SMI_BORDER_HIST~0 created #20141127160547

(IMP) INFO: import of SMI_BORDER_HIST completed (0 rows) #20141127160547

(DB) INFO: SMI_HEADER created #20141127160547

(DB) INFO: SMI_HEADER~0 created #20141127160547

(IMP) INFO: import of SMI_HEADER completed (0 rows) #20141127160547

(DB) INFO: SMI_ITEM created #20141127160547

(DB) INFO: SMI_ITEM~0 created #20141127160547

(IMP) INFO: import of SMI_ITEM completed (0 rows) #20141127160547

(DB) INFO: SMI_RUNTIME_INFO created #20141127160547

(DB) INFO: SMI_RUNTIME_INFO~0 created #20141127160547

(IMP) INFO: import of SMI_RUNTIME_INFO completed (0 rows) #20141127160547

(DB) INFO: SMI_TIMESERIES created #20141127160547

(DB) INFO: SMI_TIMESERIES~0 created #20141127160547

(IMP) INFO: import of SMI_TIMESERIES completed (0 rows) #20141127160547

(DB) INFO: SMI_USER_RNTM created #20141127160547

(DB) INFO: SMI_USER_RNTM~0 created #20141127160547

(IMP) INFO: import of SMI_USER_RNTM completed (0 rows) #20141127160547

(DB) INFO: SMI_VOICE_CUST created #20141127160547

(DB) INFO: SMI_VOICE_CUST~0 created #20141127160548

(IMP) INFO: import of SMI_VOICE_CUST completed (0 rows) #20141127160548

(DB) INFO: SMJV created #20141127160548

(DB) INFO: SMJV~0 created #20141127160548

(IMP) INFO: import of SMJV completed (0 rows) #20141127160548

(DB) INFO: SMMAIN created #20141127160548

(DB) INFO: SMMAIN~0 created #20141127160548

(DB) INFO: SMMAIN~001 created #20141127160548

(DB6) [IBM][CLI Driver][DB2/LINUXX8664] SQL0150N  The target fullselect, view, typed table, materialized query table, range-clustered table, or staging table in the INSERT, DELETE, UPDATE, MERGE, or TRUNCATE statement is a target for which the requested operation is not permitted.  SQLSTATE=42807

(DB6) INFO: Virtual Table SMMAIN has been successfully converted ( ignore SQL0150N )

(DB6) Using LOAD API for table SMMAIN

(IMP) INFO: import of SMMAIN completed (126577 rows) #20141127160600

(DB) INFO: SMMESSAGE created #20141127160600

(DB) INFO: SMMESSAGE~0 created #20141127160600

(DB6) [IBM][CLI Driver][DB2/LINUXX8664] SQL0150N  The target fullselect, view, typed table, materialized query table, range-clustered table, or staging table in the INSERT, DELETE, UPDATE, MERGE, or TRUNCATE statement is a target for which the requested operation is not permitted.  SQLSTATE=42807

(DB6) INFO: Virtual Table SMMESSAGE has been successfully converted ( ignore SQL0150N )

(DB6) Using LOAD API for table SMMESSAGE

(IMP) INFO: import of SMMESSAGE completed (37356 rows) #20141127160601

(DB) INFO: SMPARAM created #20141127160601

(DB) INFO: SMPARAM~0 created #20141127160601

(DB6) [IBM][CLI Driver][DB2/LINUXX8664] SQL0150N  The target fullselect, view, typed table, materialized query table, range-clustered table, or staging table in the INSERT, DELETE, UPDATE, MERGE, or TRUNCATE statement is a target for which the requested operation is not permitted.  SQLSTATE=42807

(DB6) INFO: Virtual Table SMPARAM has been successfully converted ( ignore SQL0150N )

(DB6) Using LOAD API for table SMPARAM

(IMP) INFO: import of SMPARAM completed (191280 rows) #20141127160608

(DB) INFO: SMPS created #20141127160608

(DB) INFO: SMPS~0 created #20141127160608

(DB6) [IBM][CLI Driver][DB2/LINUXX8664] SQL0150N  The target fullselect, view, typed table, materialized query table, range-clustered table, or staging table in the INSERT, DELETE, UPDATE, MERGE, or TRUNCATE statement is a target for which the requested operation is not permitted.  SQLSTATE=42807

(DB6) INFO: Virtual Table SMPS has been successfully converted ( ignore SQL0150N )

(DB6) Using LOAD API for table SMPS

(IMP) INFO: import of SMPS completed (38449 rows) #20141127160610

(DB) INFO: SMRL created #20141127160610

(DB) INFO: SMRL~0 created #20141127160610

(DB6) [IBM][CLI Driver][DB2/LINUXX8664] SQL0150N  The target fullselect, view, typed table, materialized query table, range-clustered table, or staging table in the INSERT, DELETE, UPDATE, MERGE, or TRUNCATE statement is a target for which the requested operation is not permitted.  SQLSTATE=42807

(DB6) INFO: Virtual Table SMRL has been successfully converted ( ignore SQL0150N )

(DB6) Using LOAD API for table SMRL

(IMP) INFO: import of SMRL completed (76586 rows) #20141127160613

(DB) INFO: SMRTA created #20141127160613

(DB) INFO: SMRTA~0 created #20141127160613

(DB6) [IBM][CLI Driver][DB2/LINUXX8664] SQL0150N  The target fullselect, view, typed table, materialized query table, range-clustered table, or staging table in the INSERT, DELETE, UPDATE, MERGE, or TRUNCATE statement is a target for which the requested operation is not permitted.  SQLSTATE=42807

(DB6) INFO: Virtual Table SMRTA has been successfully converted ( ignore SQL0150N )

(DB6) LOAD API is not used for table with small buffer

(DB6) Using ARRAY INSERT for table SMRTA

(IMP) INFO: import of SMRTA completed (7 rows) #20141127160613

(DB) INFO: SMSCMAID created #20141127160614

(DB) INFO: SMSCMAID~0 created #20141127160614

(DB) INFO: SMSCMAID~A01 created #20141127160614

(DB6) [IBM][CLI Driver][DB2/LINUXX8664] SQL0150N  The target fullselect, view, typed table, materialized query table, range-clustered table, or staging table in the INSERT, DELETE, UPDATE, MERGE, or TRUNCATE statement is a target for which the requested operation is not permitted.  SQLSTATE=42807

(DB6) INFO: Virtual Table SMSCMAID has been successfully converted ( ignore SQL0150N )

(DB6) LOAD API is not used for table with small buffer

(DB6) Using ARRAY INSERT for table SMSCMAID

(DB6) [IBM][CLI Driver][DB2/LINUXX8664] SQL0803N  One or more values in the INSERT statement, UPDATE statement, or foreign key update caused by a DELETE statement are not valid because the primary key, unique constraint or unique index identified by "2" constrains table "SAPUI5.SMSCMAID" from having duplicate values for the index key.  SQLSTATE=01661

row=2

(IMP) ERROR: ExeFastload: rc = 2

(DB) INFO: disconnected from DB

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

(STAT) DATABASE times: 91.359/2.981/0.198 72.3%/19.9%/18.2% real/usr/sys.

(STAT) FILE    times: 34.928/12.027/0.891 27.7%/80.1%/81.8% real/usr/sys.

/usr/sap/UI5/SYS/exe/uc/linuxx86_64/R3load: END OF LOG: 2014112716061

[former_member237791]

One thing I have should mention is that the source system is NW740 SR1 with the latest R3load and other files. The target system is planned to be NW740 SR2. Could that be a issue? How do i rebuild a TSK file. Is it by typing ok at the table which caused the error?. I am also using the latest Software provisioning manager. Can you look at the logs below and is there anything else you need.

Here are latest logs

R3load.exe.log

cat R3load.exe.log

/usr/sap/UI5/SYS/exe/uc/linuxx86_64/R3load=>sapparam(1c): No Profile used.

/usr/sap/UI5/SYS/exe/uc/linuxx86_64/R3load=>sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

sh: module: line 1: syntax error: unexpected end of file

sh: error importing function definition for `BASH_FUNC_module'

sh: module: line 1: syntax error: unexpected end of file

sh: error importing function definition for `BASH_FUNC_module'

import_monitor.log

TRACE: 2014-11-28 13:05:45 com.sap.inst.migmon.LoadTask processPackage

Loading of 'SAPAPPL1_27' starting import package into database:

/usr/sap/UI5/SYS/exe/uc/linuxx86_64/R3load -i SAPAPPL1_27.cmd -dbcodepage 4103 -l SAPAPPL1_27.log -stop_on_error -loadprocedure fast LOAD:DEF_CRT

INFO: 2014-11-28 13:05:46 com.sap.inst.migmon.LoadTask run_report

Monitor jobs: running 0, waiting 1, completed 93, failed 1, total 95  error processing of package SAPAPPL1_27

ERROR: 2014-11-28 13:05:47 com.sap.inst.migmon.LoadTask run

Loading of 'SAPAPPL1_27' import package is interrupted with R3load error.

Process '/usr/sap/UI5/SYS/exe/uc/linuxx86_64/R3load -i SAPAPPL1_27.cmd -dbcodepage 4103 -l SAPAPPL1_27.log -stop_on_error -loadprocedure fast LOAD:DEF_CRT' exited with return code 2.

For mode details see 'SAPAPPL1_27.log' file.

Standard error output:

/usr/sap/UI5/SYS/exe/uc/linuxx86_64/R3load=>sapparam(1c): No Profile used.

/usr/sap/UI5/SYS/exe/uc/linuxx86_64/R3load=>sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

sh: module: line 1: syntax error: unexpected end of file

sh: error importing function definition for `BASH_FUNC_module'

sh: module: line 1: syntax error: unexpected end of file

sh: error importing function definition for `BASH_FUNC_module'

WARNING: 2014-11-28 13:06:15

Cannot start import of packages with views because not all import packages with tables are loaded successfully.

WARNING: 2014-11-28 13:06:15

1 error(s) during processing of packages.

INFO: 2014-11-28 13:06:15

Import Monitor is stopped.

SAPAPPL1_27.log

root@sapui5 AS-ABAP]# cat SAPAPPL1_27.log

/usr/sap/UI5/SYS/exe/uc/linuxx86_64/R3load: START OF LOG: 20141127160407

/usr/sap/UI5/SYS/exe/uc/linuxx86_64/R3load: sccsid @(#) $Id: //bas/742_REL/src/R3ld/R3load/R3ldmain.c#4 $ SAP

/usr/sap/UI5/SYS/exe/uc/linuxx86_64/R3load: version R7.42/V1.8 [UNICODE]

Compiled Sep  1 2014 18:12:24

/usr/sap/UI5/SYS/exe/uc/linuxx86_64/R3load -ctf I /exp/ABAP/DATA/SAPAPPL1_27.STR /tmp/sapinst_instdir/NW740SR2/DB6/COPY/SYSTEM/STD/AS-ABAP/DDLDB6.TPL SAPAPPL1_27.TSK DB6 -l SAPAPPL1_27.log

-------------------- Start of patch information ------------------------

patchinfo (patches.h): (0.013) R3load dependency loop if calles with -o V option (note 2044380)

DBSL patchinfo (patches.h): (0.015) DB6: seg fault on V10.5 FP4 during connect processing (note 2056603)

--------------------- End of patch information -------------------------

process id 35006

(RTF) WARNING: CREATE FUNCTION template not found in control file "/tmp/sapinst_instdir/NW740SR2/DB6/COPY/SYSTEM/STD/AS-ABAP/DDLDB6.TPL"

(RTF) WARNING: DROP FUNCTION template not found in control file "/tmp/sapinst_instdir/NW740SR2/DB6/COPY/SYSTEM/STD/AS-ABAP/DDLDB6.TPL"

(RDI) WARNING: /exp/ABAP/DATA/SAPAPPL1_27.STR: cannot find version token "ver:" at line 1

(RDI) WARNING: /exp/ABAP/DATA/SAPAPPL1_27.STR: unknown file format, assuming version 2

/usr/sap/UI5/SYS/exe/uc/linuxx86_64/R3load: job completed

(STAT) DATABASE times: 0.011/0.004/0.001 100.0%/100.0%/100.0% real/usr/sys.

/usr/sap/UI5/SYS/exe/uc/linuxx86_64/R3load: END OF LOG: 20141127160407

/usr/sap/UI5/SYS/exe/uc/linuxx86_64/R3load: START OF LOG: 20141127160407

/usr/sap/UI5/SYS/exe/uc/linuxx86_64/R3load: sccsid @(#) $Id: //bas/742_REL/src/R3ld/R3load/R3ldmain.c#4 $ SAP

/usr/sap/UI5/SYS/exe/uc/linuxx86_64/R3load: version R7.42/V1.8 [UNICODE]

Compiled Sep  1 2014 18:12:24

/usr/sap/UI5/SYS/exe/uc/linuxx86_64/R3load -i SAPAPPL1_27.cmd -dbcodepage 4103 -l SAPAPPL1_27.log -stop_on_error -loadprocedure fast LOAD:DEF_CRT

-------------------- Start of patch information ------------------------

patchinfo (patches.h): (0.013) R3load dependency loop if calles with -o V option (note 2044380)

DBSL patchinfo (patches.h): (0.015) DB6: seg fault on V10.5 FP4 during connect processing (note 2056603)

--------------------- End of patch information -------------------------

process id 35012

(DB) INFO: connected to DB

(GSI) INFO: dbname   = "UI5                                                                                                                             "

(GSI) INFO: vname    = "DB6                             "

(GSI) INFO: hostname = "UNKNOWN                                                         "

(GSI) INFO: sysname  = "Linux"

(GSI) INFO: nodename = "sapui5"

(GSI) INFO: release  = "2.6.32-504.el6.x86_64"

(GSI) INFO: version  = "#1 SMP Tue Sep 16 01:56:35 EDT 2014"

(GSI) INFO: machine  = "x86_64"

(RTF) WARNING: CREATE FUNCTION template not found in control file "/tmp/sapinst_instdir/NW740SR2/DB6/COPY/SYSTEM/STD/AS-ABAP/DDLDB6.TPL"

(RTF) WARNING: DROP FUNCTION template not found in control file "/tmp/sapinst_instdir/NW740SR2/DB6/COPY/SYSTEM/STD/AS-ABAP/DDLDB6.TPL"

(RDI) WARNING: /exp/ABAP/DATA/SAPAPPL1_27.STR: cannot find version token "ver:" at line 1

(RDI) WARNING: /exp/ABAP/DATA/SAPAPPL1_27.STR: unknown file format, assuming version 2

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

(SQL) INFO: SQLFiles.LST not found

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

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

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

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

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

(SQL) INFO: APPL1.SQL not found

(SQL) INFO: Searching for SQL file /exp/ABAP/DB/DB6/APPL1.SQL

(SQL) INFO: /exp/ABAP/DB/DB6/APPL1.SQL not found

(DB) INFO: SMIMCONT1 created #20141127160408

(DB) INFO: SMIMCONT1~0 created #20141127160408

(DB6) [IBM][CLI Driver][DB2/LINUXX8664] SQL0150N  The target fullselect, view, typed table, materialized query table, range-clustered table, or staging table in the INSERT, DELETE, UPDATE, MERGE, or TRUNCATE statement is a target for which the requested operation is not permitted.  SQLSTATE=42807

(DB6) INFO: Virtual Table SMIMCONT1 has been successfully converted ( ignore SQL0150N )

(DB6) Using LOAD API for table SMIMCONT1

(IMP) INFO: import of SMIMCONT1 completed (412726 rows) #20141127160547

(DB) INFO: SMIME_CAPABILITY created #20141127160547

(DB) INFO: SMIME_CAPABILITY~0 created #20141127160547

(IMP) INFO: import of SMIME_CAPABILITY completed (0 rows) #20141127160547

(DB) INFO: SMIME_CAPA_CRYPT created #20141127160547

(DB) INFO: SMIME_CAPA_CRYPT~0 created #20141127160547

(IMP) INFO: import of SMIME_CAPA_CRYPT completed (0 rows) #20141127160547

(DB) INFO: SMIME_CAPA_SIGN created #20141127160547

(DB) INFO: SMIME_CAPA_SIGN~0 created #20141127160547

(IMP) INFO: import of SMIME_CAPA_SIGN completed (0 rows) #20141127160547

(DB) INFO: SMI_BORDER_HIST created #20141127160547

(DB) INFO: SMI_BORDER_HIST~0 created #20141127160547

(IMP) INFO: import of SMI_BORDER_HIST completed (0 rows) #20141127160547

(DB) INFO: SMI_HEADER created #20141127160547

(DB) INFO: SMI_HEADER~0 created #20141127160547

(IMP) INFO: import of SMI_HEADER completed (0 rows) #20141127160547

(DB) INFO: SMI_ITEM created #20141127160547

(DB) INFO: SMI_ITEM~0 created #20141127160547

(IMP) INFO: import of SMI_ITEM completed (0 rows) #20141127160547

(DB) INFO: SMI_RUNTIME_INFO created #20141127160547

(DB) INFO: SMI_RUNTIME_INFO~0 created #20141127160547

(IMP) INFO: import of SMI_RUNTIME_INFO completed (0 rows) #20141127160547

(DB) INFO: SMI_TIMESERIES created #20141127160547

(DB) INFO: SMI_TIMESERIES~0 created #20141127160547

(IMP) INFO: import of SMI_TIMESERIES completed (0 rows) #20141127160547

(DB) INFO: SMI_USER_RNTM created #20141127160547

(DB) INFO: SMI_USER_RNTM~0 created #20141127160547

(IMP) INFO: import of SMI_USER_RNTM completed (0 rows) #20141127160547

(DB) INFO: SMI_VOICE_CUST created #20141127160547

(DB) INFO: SMI_VOICE_CUST~0 created #20141127160548

(IMP) INFO: import of SMI_VOICE_CUST completed (0 rows) #20141127160548

(DB) INFO: SMJV created #20141127160548

(DB) INFO: SMJV~0 created #20141127160548

(IMP) INFO: import of SMJV completed (0 rows) #20141127160548

(DB) INFO: SMMAIN created #20141127160548

(DB) INFO: SMMAIN~0 created #20141127160548

(DB) INFO: SMMAIN~001 created #20141127160548

(DB6) [IBM][CLI Driver][DB2/LINUXX8664] SQL0150N  The target fullselect, view, typed table, materialized query table, range-clustered table, or staging table in the INSERT, DELETE, UPDATE, MERGE, or TRUNCATE statement is a target for which the requested operation is not permitted.  SQLSTATE=42807

(DB6) INFO: Virtual Table SMMAIN has been successfully converted ( ignore SQL0150N )

(DB6) Using LOAD API for table SMMAIN

(IMP) INFO: import of SMMAIN completed (126577 rows) #20141127160600

(DB) INFO: SMMESSAGE created #20141127160600

(DB) INFO: SMMESSAGE~0 created #20141127160600

(DB6) [IBM][CLI Driver][DB2/LINUXX8664] SQL0150N  The target fullselect, view, typed table, materialized query table, range-clustered table, or staging table in the INSERT, DELETE, UPDATE, MERGE, or TRUNCATE statement is a target for which the requested operation is not permitted.  SQLSTATE=42807

(DB6) INFO: Virtual Table SMMESSAGE has been successfully converted ( ignore SQL0150N )

(DB6) Using LOAD API for table SMMESSAGE

(IMP) INFO: import of SMMESSAGE completed (37356 rows) #20141127160601

(DB) INFO: SMPARAM created #20141127160601

(DB) INFO: SMPARAM~0 created #20141127160601

(DB6) [IBM][CLI Driver][DB2/LINUXX8664] SQL0150N  The target fullselect, view, typed table, materialized query table, range-clustered table, or staging table in the INSERT, DELETE, UPDATE, MERGE, or TRUNCATE statement is a target for which the requested operation is not permitted.  SQLSTATE=42807

(DB6) INFO: Virtual Table SMPARAM has been successfully converted ( ignore SQL0150N )

(DB6) Using LOAD API for table SMPARAM

(IMP) INFO: import of SMPARAM completed (191280 rows) #20141127160608

(DB) INFO: SMPS created #20141127160608

(DB) INFO: SMPS~0 created #20141127160608

(DB6) [IBM][CLI Driver][DB2/LINUXX8664] SQL0150N  The target fullselect, view, typed table, materialized query table, range-clustered table, or staging table in the INSERT, DELETE, UPDATE, MERGE, or TRUNCATE statement is a target for which the requested operation is not permitted.  SQLSTATE=42807

(DB6) INFO: Virtual Table SMPS has been successfully converted ( ignore SQL0150N )

(DB6) Using LOAD API for table SMPS

(IMP) INFO: import of SMPS completed (38449 rows) #20141127160610

(DB) INFO: SMRL created #20141127160610

(DB) INFO: SMRL~0 created #20141127160610

(DB6) [IBM][CLI Driver][DB2/LINUXX8664] SQL0150N  The target fullselect, view, typed table, materialized query table, range-clustered table, or staging table in the INSERT, DELETE, UPDATE, MERGE, or TRUNCATE statement is a target for which the requested operation is not permitted.  SQLSTATE=42807

(DB6) INFO: Virtual Table SMRL has been successfully converted ( ignore SQL0150N )

(DB6) Using LOAD API for table SMRL

(IMP) INFO: import of SMRL completed (76586 rows) #20141127160613

(DB) INFO: SMRTA created #20141127160613

(DB) INFO: SMRTA~0 created #20141127160613

(DB6) [IBM][CLI Driver][DB2/LINUXX8664] SQL0150N  The target fullselect, view, typed table, materialized query table, range-clustered table, or staging table in the INSERT, DELETE, UPDATE, MERGE, or TRUNCATE statement is a target for which the requested operation is not permitted.  SQLSTATE=42807

(DB6) INFO: Virtual Table SMRTA has been successfully converted ( ignore SQL0150N )

(DB6) LOAD API is not used for table with small buffer

(DB6) Using ARRAY INSERT for table SMRTA

(IMP) INFO: import of SMRTA completed (7 rows) #20141127160613

(DB) INFO: SMSCMAID created #20141127160614

(DB) INFO: SMSCMAID~0 created #20141127160614

(DB) INFO: SMSCMAID~A01 created #20141127160614

(DB6) [IBM][CLI Driver][DB2/LINUXX8664] SQL0150N  The target fullselect, view, typed table, materialized query table, range-clustered table, or staging table in the INSERT, DELETE, UPDATE, MERGE, or TRUNCATE statement is a target for which the requested operation is not permitted.  SQLSTATE=42807

(DB6) INFO: Virtual Table SMSCMAID has been successfully converted ( ignore SQL0150N )

(DB6) LOAD API is not used for table with small buffer

(DB6) Using ARRAY INSERT for table SMSCMAID

(DB6) [IBM][CLI Driver][DB2/LINUXX8664] SQL0803N  One or more values in the INSERT statement, UPDATE statement, or foreign key update caused by a DELETE statement are not valid because the primary key, unique constraint or unique index identified by "2" constrains table "SAPUI5.SMSCMAID" from having duplicate values for the index key.  SQLSTATE=01661

row=2

(IMP) ERROR: ExeFastload: rc = 2

(DB) INFO: disconnected from DB

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

(STAT) DATABASE times: 91.359/2.981/0.198 72.3%/19.9%/18.2% real/usr/sys.

(STAT) FILE    times: 34.928/12.027/0.891 27.7%/80.1%/81.8% real/usr/sys.

/usr/sap/UI5/SYS/exe/uc/linuxx86_64/R3load: END OF LOG: 20141127160614

/usr/sap/UI5/SYS/exe/uc/linuxx86_64/R3load: START OF LOG: 20141128130545

/usr/sap/UI5/SYS/exe/uc/linuxx86_64/R3load: sccsid @(#) $Id: //bas/742_REL/src/R3ld/R3load/R3ldmain.c#4 $ SAP

/usr/sap/UI5/SYS/exe/uc/linuxx86_64/R3load: version R7.42/V1.8 [UNICODE]

Compiled Sep  1 2014 18:12:24

/usr/sap/UI5/SYS/exe/uc/linuxx86_64/R3load -i SAPAPPL1_27.cmd -dbcodepage 4103 -l SAPAPPL1_27.log -stop_on_error -loadprocedure fast LOAD:DEF_CRT

-------------------- Start of patch information ------------------------

patchinfo (patches.h): (0.013) R3load dependency loop if calles with -o V option (note 2044380)

DBSL patchinfo (patches.h): (0.015) DB6: seg fault on V10.5 FP4 during connect processing (note 2056603)

--------------------- End of patch information -------------------------

process id 43830

(DB) INFO: connected to DB

(GSI) INFO: dbname   = "UI5                                                                                                                             "

(GSI) INFO: vname    = "DB6                             "

(GSI) INFO: hostname = "UNKNOWN                                                         "

(GSI) INFO: sysname  = "Linux"

(GSI) INFO: nodename = "sapui5"

(GSI) INFO: release  = "2.6.32-504.el6.x86_64"

(GSI) INFO: version  = "#1 SMP Tue Sep 16 01:56:35 EDT 2014"

(GSI) INFO: machine  = "x86_64"

(RTF) WARNING: CREATE FUNCTION template not found in control file "/tmp/sapinst_instdir/NW740SR2/DB6/COPY/SYSTEM/STD/AS-ABAP/DDLDB6.TPL"

(RTF) WARNING: DROP FUNCTION template not found in control file "/tmp/sapinst_instdir/NW740SR2/DB6/COPY/SYSTEM/STD/AS-ABAP/DDLDB6.TPL"

(RDI) WARNING: /exp/ABAP/DATA/SAPAPPL1_27.STR: cannot find version token "ver:" at line 1

(RDI) WARNING: /exp/ABAP/DATA/SAPAPPL1_27.STR: unknown file format, assuming version 2

(DB) INFO: SMSCMAID deleted/truncated #20141128130546

(DB6) LOAD API is not used for table with small buffer

(DB6) Using ARRAY INSERT for table SMSCMAID

(DB6) [IBM][CLI Driver][DB2/LINUXX8664] SQL0803N  One or more values in the INSERT statement, UPDATE statement, or foreign key update caused by a DELETE statement are not valid because the primary key, unique constraint or unique index identified by "2" constrains table "SAPUI5.SMSCMAID" from having duplicate values for the index key.  SQLSTATE=01661

row=2

(IMP) ERROR: ExeFastload: rc = 2

(DB) INFO: disconnected from DB

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

(STAT) DATABASE times: 1.073/0.694/0.025 100.0%/99.9%/100.0% real/usr/sys.

(STAT) FILE    times: 0.000/0.001/0.000 0.0%/0.1%/0.0% real/usr/sys.

/usr/sap/UI5/SYS/exe/uc/linuxx86_64/R3load: END OF LOG: 20141128130546

SAPAPPL1_27.TSK

T SMIMCONT1 C ok

P SMIMCONT1~0 C ok

D SMIMCONT1 I ok

T SMIME_CAPABILITY C ok

P SMIME_CAPABILITY~0 C ok

D SMIME_CAPABILITY I ok

T SMIME_CAPA_CRYPT C ok

P SMIME_CAPA_CRYPT~0 C ok

D SMIME_CAPA_CRYPT I ok

T SMIME_CAPA_SIGN C ok

P SMIME_CAPA_SIGN~0 C ok

D SMIME_CAPA_SIGN I ok

T SMI_BORDER_HIST C ok

P SMI_BORDER_HIST~0 C ok

D SMI_BORDER_HIST I ok

T SMI_HEADER C ok

P SMI_HEADER~0 C ok

D SMI_HEADER I ok

T SMI_ITEM C ok

P SMI_ITEM~0 C ok

D SMI_ITEM I ok

T SMI_RUNTIME_INFO C ok

P SMI_RUNTIME_INFO~0 C ok

D SMI_RUNTIME_INFO I ok

T SMI_TIMESERIES C ok

P SMI_TIMESERIES~0 C ok

D SMI_TIMESERIES I ok

T SMI_USER_RNTM C ok

P SMI_USER_RNTM~0 C ok

D SMI_USER_RNTM I ok

T SMI_VOICE_CUST C ok

P SMI_VOICE_CUST~0 C ok

D SMI_VOICE_CUST I ok

T SMJV C ok

P SMJV~0 C ok

D SMJV I ok

T SMMAIN C ok

P SMMAIN~0 C ok

I SMMAIN~001 C ok

D SMMAIN I ok

T SMMESSAGE C ok

P SMMESSAGE~0 C ok

D SMMESSAGE I ok

T SMPARAM C ok

P SMPARAM~0 C ok

D SMPARAM I ok

T SMPS C ok

P SMPS~0 C ok

D SMPS I ok

T SMRL C ok

P SMRL~0 C ok

D SMRL I ok

T SMRTA C ok

P SMRTA~0 C ok

D SMRTA I ok

T SMSCMAID C ok

P SMSCMAID~0 C ok

I SMSCMAID~A01 C ok

D SMSCMAID I err

T SMSELKRIT C xeq

P SMSELKRIT~0 C xeq

D SMSELKRIT I xeq

T SMSPOOL C xeq

P SMSPOOL~0 C xeq

D SMSPOOL I xeq

T SMSTATUS C xeq

P SMSTATUS~0 C xeq

D SMSTATUS I xeq

T SMSTATUS_HIST C xeq

P SMSTATUS_HIST~0 C xeq

D SMSTATUS_HIST I xeq

T SMWF C xeq

P SMWF~0 C xeq

D SMWF I xeq

T SMYOTREE C xeq

P SMYOTREE~0 C xeq

I SMYOTREE~PAR C xeq

D SMYOTREE I xeq

T SMYOWP C xeq

P SMYOWP~0 C xeq

D SMYOWP I xeq

T SMZB_BINREL C xeq

P SMZB_BINREL~0 C xeq

I SMZB_BINREL~001 C xeq

D SMZB_BINREL I xeq

T SNAP C xeq

P SNAP~0 C xeq

I SNAP~DSX C xeq

D SNAP I xeq

T SNAPTTREX C xeq

P SNAPTTREX~0 C xeq

D SNAPTTREX I xeq

T SNAP_ADT C xeq

P SNAP_ADT~0 C xeq

I SNAP_ADT~CMP C xeq

DDLDB6.TPL

prikey: BEFORE_LOAD ORDER_BY_PKEY

seckey: BEFORE_LOAD

cretab: CREATE TABLE &tab_name&

        ( /{ &fld_name& &fld_desc& /-, /} )

        IN &location&

        INDEX IN &locationI&

        LONG IN &locationL&

lazytb: CREATE VIEW &tab_name& AS SELECT * FROM

        ( VALUES( /{ &fld_cast& /-, /} )) AS &tab_name&

        ( /{ &fld_name& /-, /} )

        WHERE 1 = 2

drptab: DROP TABLE &tab_name&

crepky: CREATE UNIQUE INDEX &pri_key&

        ON &tab_name&

        ( /{ &key_fld& /-, /} )

        ALLOW REVERSE SCANS ;

        ALTER TABLE &tab_name&

        ADD CONSTRAINT &pri_key&

        PRIMARY KEY ( &key_fld& /-, )

drppky: ALTER TABLE &tab_name& DROP PRIMARY KEY ;

        DROP INDEX &pri_key&

creind: CREATE &unique& INDEX &ind_name&

        ON &tab_name&

        ( /{ &fld_name& /-, /} )

        ALLOW REVERSE SCANS

drpind: DROP INDEX &ind_name&

crevie: CREATE VIEW &view_name&

        ( /{ &fld_name& /-, /} )

        AS &query&

drpvie: DROP VIEW &view_name&

trcdat: TRUNCATE TABLE &tab_name&

deldat: DELETE FROM &tab_name& &where&

negtab: LICHECK MLICHECK

negdat: LICHECK MLICHECK

negind: LICHECK~0 MLICHECK~0 LICHECK^0 MLICHECK^0

negvie:

# table storage parameters

loc: APPL0 SND#STABD                      SND#STABI                      SND#STABD                    

     APPL1 SND#BTABD                      SND#BTABI                      SND#BTABD                    

     APPL2 SND#POOLD                      SND#POOLI                      SND#POOLD                    

     CLUST SND#CLUD                       SND#CLUI                       SND#CLUD                     

     DDIM  SND#DIMD                       SND#DIMI                       SND#DIMD                     

     DFACT SND#FACTD                      SND#FACTI                      SND#FACTD                    

     DODS  SND#ODSD                       SND#ODSI                       SND#ODSD                     

     POOL  SND#POOLD                      SND#POOLI                      SND#POOLD                    

     SDIC  SND#DDICD                      SND#DDICI                      SND#DDICD                    

     SDOCU SND#DOCUD                      SND#DOCUI                      SND#DOCUD                    

     SLDEF SND#EL740D                     SND#EL740I                     SND#EL740D                   

     SLEXC SND#EL740D                     SND#EL740I                     SND#EL740D                   

     SLOAD SND#LOADD                      SND#LOADI                      SND#LOADD                    

     SPROT SND#PROTD                      SND#PROTI                      SND#PROTD                    

     SSDEF SND#ES740D                     SND#ES740I                     SND#ES740D                   

     SSEXC SND#ES740D                     SND#ES740I                     SND#ES740D                   

     SSRC  SND#SOURCED                    SND#SOURCEI                    SND#SOURCED                  

     TEMP  SND#PROTD                      SND#PROTI                      SND#PROTD                    

     USER  SND#USER1D                     SND#USER1I                     SND#USER1D                   

     USER1 SND#USER1D                     SND#USER1I                     SND#USER1D                   

# To addapt tablespace names for server consolidation

# e.g. PSAPBTABD -> <SAPSID>#BTABD

# Use the following parameter:

modify_tbs_names: 1

[Former Member]

Hello  Haider...

Please update SBP (SAP bundle patch) of your database.

Regards

S.BASIS