0% found this document useful (0 votes)
305 views33 pages

SAP R3load Log Analysis

The R3load program was run multiple times to load data into several tables in a Sybase database. The loads failed each time with the same errors - data overflow errors when loading columns, and errors creating unique indexes on tables due to duplicate keys. The logs show the program attempting to delete and reload the tables several times with the same results.

Uploaded by

kishleo
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
305 views33 pages

SAP R3load Log Analysis

The R3load program was run multiple times to load data into several tables in a Sybase database. The loads failed each time with the same errors - data overflow errors when loading columns, and errors creating unique indexes on tables due to duplicate keys. The logs show the program attempting to delete and reload the tables several times with the same results.

Uploaded by

kishleo
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 33

/usr/sap/SOL/SYS/exe/run/R3load: START OF LOG: 20140222035925

/usr/sap/SOL/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/720_REL/src/R3ld/R3load/R3ldmain.c#13 $ SAP /usr/sap/SOL/SYS/exe/run/R3load: version R7.20/V1.4 [UNICODE] Compiled Dec 1 2011 20:15:50 /usr/sap/SOL/SYS/exe/run/R3load -ctf I /software_dump/Exp2/DATA_UNITS/EXP4/DATA/SAPNTAB.STR /tmp/sapinst_instdir/SOLMAN71/SYSTEM/SYB/CENTRAL/AS/DDLSYB.TPL SAPNTAB.TSK SYB -l SAPNTAB.log

/usr/sap/SOL/SYS/exe/run/R3load: job completed /usr/sap/SOL/SYS/exe/run/R3load: END OF LOG: 20140222035925

/usr/sap/SOL/SYS/exe/run/R3load: START OF LOG: 20140222035925

/usr/sap/SOL/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/720_REL/src/R3ld/R3load/R3ldmain.c#13 $ SAP /usr/sap/SOL/SYS/exe/run/R3load: version R7.20/V1.4 [UNICODE] Compiled Dec 1 2011 20:15:50 /usr/sap/SOL/SYS/exe/run/R3load -i SAPNTAB.cmd -dbcodepage 4103 -l SAPNTAB.log -c 99000000 loadprocedure fast

(DB) INFO: connected to DB (SQL) INFO: Searching for SQL file SQLFiles.LST (SQL) INFO: SQLFiles.LST not found (SQL) INFO: Searching for SQL file /software_dump/Exp2/DATA_UNITS/EXP4/DB/SQLFiles.LST

(SQL) INFO: /software_dump/Exp2/DATA_UNITS/EXP4/DB/SQLFiles.LST not found (SQL) INFO: Searching for SQL file SDIC.SQL (SQL) INFO: SDIC.SQL not found (SQL) INFO: Searching for SQL file /software_dump/Exp2/DATA_UNITS/EXP4/DB/SYB/SDIC.SQL (SQL) INFO: /software_dump/Exp2/DATA_UNITS/EXP4/DB/SYB/SDIC.SQL not found (DB) INFO: SVERS created (IMP) INFO: import of SVERS completed (1 rows) #20140222035925

(DB) INFO: SVERS~0 created (DB) INFO: DDNTF created (SYB_IMP) ERROR: DbSlExeModify/DbSlLobPutPiece failed rc = 99, table "DDNTF" (SQL error 30128) error message returned by DbSl: [ASE Error SQL30128:HY000]Data overflow. Increase specified column size or buffer size (IMP) ERROR: ExeFastload: rc = 2 (DB) INFO: DDNTF~0 created (DB) INFO: DDNTF_CONV_UC created (SYB_IMP) ERROR: DbSlExeModify/DbSlLobPutPiece failed rc = 99, table "DDNTF_CONV_UC" (SQL error 30128) error message returned by DbSl: [ASE Error SQL30128:HY000]Data overflow. Increase specified column size or buffer size (IMP) ERROR: ExeFastload: rc = 2 (DB) INFO: DDNTF_CONV_UC~0 created

(DB) INFO: DDNTT created (SYB_IMP) ERROR: DbSlEndModify failed rc = 99, table "DDNTT" (SQL error 30128) error message returned by DbSl: [ASE Error SQL30128:HY000]Data overflow. Increase specified column size or buffer size (IMP) ERROR: EndFastload: rc = 2 (DB) ERROR: DDL statement failed (CREATE UNIQUE INDEX "DDNTT~0" ON "DDNTT" ( "TABNAME" ) ) DbSlExecute: rc = 99 (SQL error 1505) error message returned by DbSl: [ASE Error SQL1505]Create unique index aborted on duplicate key. Primary key is '""'

(DB) INFO: DDNTT_CONV_UC created (SYB_IMP) ERROR: DbSlEndModify failed rc = 99, table "DDNTT_CONV_UC" (SQL error 30128) error message returned by DbSl: [ASE Error SQL30128:HY000]Data overflow. Increase specified column size or buffer size (IMP) ERROR: EndFastload: rc = 2 (DB) ERROR: DDL statement failed (CREATE UNIQUE INDEX "DDNTT_CONV_UC~0" ON "DDNTT_CONV_UC" ( "TABNAME" ) ) DbSlExecute: rc = 99 (SQL error 1505)

error message returned by DbSl: [ASE Error SQL1505]Create unique index aborted on duplicate key. Primary key is '""'

(DB) INFO: disconnected from DB

/usr/sap/SOL/SYS/exe/run/R3load: job finished with 6 error(s) /usr/sap/SOL/SYS/exe/run/R3load: END OF LOG: 20140222035948

/usr/sap/SOL/SYS/exe/run/R3load: START OF LOG: 20140222173549

/usr/sap/SOL/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/720_REL/src/R3ld/R3load/R3ldmain.c#13 $ SAP /usr/sap/SOL/SYS/exe/run/R3load: version R7.20/V1.4 [UNICODE] Compiled Dec 1 2011 20:15:50 /usr/sap/SOL/SYS/exe/run/R3load -i SAPNTAB.cmd -dbcodepage 4103 -l SAPNTAB.log -c 99000000 loadprocedure fast

(DB) INFO: connected to DB (DB) INFO: DDNTF deleted/truncated (SYB_IMP) ERROR: DbSlExeModify/DbSlLobPutPiece failed rc = 99, table "DDNTF" (SQL error 30128) error message returned by DbSl: [ASE Error SQL30128:HY000]Data overflow. Increase specified column size or buffer size (IMP) ERROR: ExeFastload: rc = 2 (DB) INFO: DDNTF_CONV_UC deleted/truncated

(SYB_IMP) ERROR: DbSlExeModify/DbSlLobPutPiece failed rc = 99, table "DDNTF_CONV_UC" (SQL error 30128) error message returned by DbSl: [ASE Error SQL30128:HY000]Data overflow. Increase specified column size or buffer size (IMP) ERROR: ExeFastload: rc = 2 (DB) INFO: DDNTT deleted/truncated (SYB_IMP) ERROR: DbSlEndModify failed rc = 99, table "DDNTT" (SQL error 30128) error message returned by DbSl: [ASE Error SQL30128:HY000]Data overflow. Increase specified column size or buffer size (IMP) ERROR: EndFastload: rc = 2 (SQL) INFO: Searching for SQL file SQLFiles.LST (SQL) INFO: SQLFiles.LST not found (SQL) INFO: Searching for SQL file /software_dump/Exp2/DATA_UNITS/EXP4/DB/SQLFiles.LST (SQL) INFO: /software_dump/Exp2/DATA_UNITS/EXP4/DB/SQLFiles.LST not found (SQL) INFO: Searching for SQL file SDIC.SQL (SQL) INFO: SDIC.SQL not found (SQL) INFO: Searching for SQL file /software_dump/Exp2/DATA_UNITS/EXP4/DB/SYB/SDIC.SQL (SQL) INFO: /software_dump/Exp2/DATA_UNITS/EXP4/DB/SYB/SDIC.SQL not found (DB) ERROR: DDL statement failed (DROP INDEX "DDNTT"."DDNTT~0") DbSlExecute: rc = 103 (SQL error 3701)

error message returned by DbSl: [ASE Error SQL3701]Cannot drop the index 'DDNTT.DDNTT~0', because it doesn't exist in the system catalogs.

(IMP) INFO: a failed DROP attempt is not necessarily a problem (DB) ERROR: DDL statement failed (CREATE UNIQUE INDEX "DDNTT~0" ON "DDNTT" ( "TABNAME" ) ) DbSlExecute: rc = 99 (SQL error 1505) error message returned by DbSl: [ASE Error SQL1505]Create unique index aborted on duplicate key. Primary key is '""'

(DB) INFO: DDNTT_CONV_UC deleted/truncated (SYB_IMP) ERROR: DbSlEndModify failed rc = 99, table "DDNTT_CONV_UC" (SQL error 30128) error message returned by DbSl: [ASE Error SQL30128:HY000]Data overflow. Increase specified column size or buffer size (IMP) ERROR: EndFastload: rc = 2 (DB) ERROR: DDL statement failed (DROP INDEX "DDNTT_CONV_UC"."DDNTT_CONV_UC~0") DbSlExecute: rc = 103 (SQL error 3701) error message returned by DbSl: [ASE Error SQL3701]Cannot drop the index 'DDNTT_CONV_UC.DDNTT_CONV_UC~0', because it doesn't exist in the system catalogs.

(IMP) INFO: a failed DROP attempt is not necessarily a problem (DB) ERROR: DDL statement failed (CREATE UNIQUE INDEX "DDNTT_CONV_UC~0" ON "DDNTT_CONV_UC" ( "TABNAME" ) ) DbSlExecute: rc = 99 (SQL error 1505) error message returned by DbSl: [ASE Error SQL1505]Create unique index aborted on duplicate key. Primary key is '""'

(DB) INFO: disconnected from DB

/usr/sap/SOL/SYS/exe/run/R3load: job finished with 6 error(s) /usr/sap/SOL/SYS/exe/run/R3load: END OF LOG: 20140222173600

/usr/sap/SOL/SYS/exe/run/R3load: START OF LOG: 20140222174618

/usr/sap/SOL/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/720_REL/src/R3ld/R3load/R3ldmain.c#13 $ SAP /usr/sap/SOL/SYS/exe/run/R3load: version R7.20/V1.4 [UNICODE] Compiled Dec 1 2011 20:15:50 /usr/sap/SOL/SYS/exe/run/R3load -i SAPNTAB.cmd -dbcodepage 4103 -l SAPNTAB.log -c 99000000 loadprocedure fast

(DB) INFO: connected to DB (DB) INFO: DDNTF deleted/truncated (SYB_IMP) ERROR: DbSlExeModify/DbSlLobPutPiece failed

rc = 99, table "DDNTF" (SQL error 30128) error message returned by DbSl: [ASE Error SQL30128:HY000]Data overflow. Increase specified column size or buffer size (IMP) ERROR: ExeFastload: rc = 2 (DB) INFO: DDNTF_CONV_UC deleted/truncated (SYB_IMP) ERROR: DbSlExeModify/DbSlLobPutPiece failed rc = 99, table "DDNTF_CONV_UC" (SQL error 30128) error message returned by DbSl: [ASE Error SQL30128:HY000]Data overflow. Increase specified column size or buffer size (IMP) ERROR: ExeFastload: rc = 2 (DB) INFO: DDNTT deleted/truncated (SYB_IMP) ERROR: DbSlEndModify failed rc = 99, table "DDNTT" (SQL error 30128) error message returned by DbSl: [ASE Error SQL30128:HY000]Data overflow. Increase specified column size or buffer size (IMP) ERROR: EndFastload: rc = 2 (SQL) INFO: Searching for SQL file SQLFiles.LST (SQL) INFO: SQLFiles.LST not found (SQL) INFO: Searching for SQL file /software_dump/Exp2/DATA_UNITS/EXP4/DB/SQLFiles.LST (SQL) INFO: /software_dump/Exp2/DATA_UNITS/EXP4/DB/SQLFiles.LST not found (SQL) INFO: Searching for SQL file SDIC.SQL (SQL) INFO: SDIC.SQL not found

(SQL) INFO: Searching for SQL file /software_dump/Exp2/DATA_UNITS/EXP4/DB/SYB/SDIC.SQL (SQL) INFO: /software_dump/Exp2/DATA_UNITS/EXP4/DB/SYB/SDIC.SQL not found (DB) ERROR: DDL statement failed (DROP INDEX "DDNTT"."DDNTT~0") DbSlExecute: rc = 103 (SQL error 3701) error message returned by DbSl: [ASE Error SQL3701]Cannot drop the index 'DDNTT.DDNTT~0', because it doesn't exist in the system catalogs.

(IMP) INFO: a failed DROP attempt is not necessarily a problem (DB) ERROR: DDL statement failed (CREATE UNIQUE INDEX "DDNTT~0" ON "DDNTT" ( "TABNAME" ) ) DbSlExecute: rc = 99 (SQL error 1505) error message returned by DbSl: [ASE Error SQL1505]Create unique index aborted on duplicate key. Primary key is '""'

(DB) INFO: DDNTT_CONV_UC deleted/truncated (SYB_IMP) ERROR: DbSlEndModify failed rc = 99, table "DDNTT_CONV_UC" (SQL error 30128) error message returned by DbSl: [ASE Error SQL30128:HY000]Data overflow. Increase specified column size or buffer size (IMP) ERROR: EndFastload: rc = 2 (DB) ERROR: DDL statement failed

(DROP INDEX "DDNTT_CONV_UC"."DDNTT_CONV_UC~0") DbSlExecute: rc = 103 (SQL error 3701) error message returned by DbSl: [ASE Error SQL3701]Cannot drop the index 'DDNTT_CONV_UC.DDNTT_CONV_UC~0', because it doesn't exist in the system catalogs.

(IMP) INFO: a failed DROP attempt is not necessarily a problem (DB) ERROR: DDL statement failed (CREATE UNIQUE INDEX "DDNTT_CONV_UC~0" ON "DDNTT_CONV_UC" ( "TABNAME" ) ) DbSlExecute: rc = 99 (SQL error 1505) error message returned by DbSl: [ASE Error SQL1505]Create unique index aborted on duplicate key. Primary key is '""'

(DB) INFO: disconnected from DB

/usr/sap/SOL/SYS/exe/run/R3load: job finished with 6 error(s) /usr/sap/SOL/SYS/exe/run/R3load: END OF LOG: 20140222174629

/usr/sap/SOL/SYS/exe/run/R3load: START OF LOG: 20140222180213

/usr/sap/SOL/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/720_REL/src/R3ld/R3load/R3ldmain.c#13 $ SAP /usr/sap/SOL/SYS/exe/run/R3load: version R7.20/V1.4 [UNICODE] Compiled Dec 1 2011 20:15:50

/usr/sap/SOL/SYS/exe/run/R3load -i SAPNTAB.cmd -dbcodepage 4103 -l SAPNTAB.log -c 99000000 loadprocedure fast

(DB) INFO: connected to DB (DB) INFO: DDNTF deleted/truncated (SYB_IMP) ERROR: DbSlExeModify/DbSlLobPutPiece failed rc = 99, table "DDNTF" (SQL error 30128) error message returned by DbSl: [ASE Error SQL30128:HY000]Data overflow. Increase specified column size or buffer size (IMP) ERROR: ExeFastload: rc = 2 (DB) INFO: DDNTF_CONV_UC deleted/truncated (SYB_IMP) ERROR: DbSlExeModify/DbSlLobPutPiece failed rc = 99, table "DDNTF_CONV_UC" (SQL error 30128) error message returned by DbSl: [ASE Error SQL30128:HY000]Data overflow. Increase specified column size or buffer size (IMP) ERROR: ExeFastload: rc = 2 (DB) INFO: DDNTT deleted/truncated (SYB_IMP) ERROR: DbSlEndModify failed rc = 99, table "DDNTT" (SQL error 30128) error message returned by DbSl: [ASE Error SQL30128:HY000]Data overflow. Increase specified column size or buffer size (IMP) ERROR: EndFastload: rc = 2 (SQL) INFO: Searching for SQL file SQLFiles.LST

(SQL) INFO: SQLFiles.LST not found (SQL) INFO: Searching for SQL file /software_dump/Exp2/DATA_UNITS/EXP4/DB/SQLFiles.LST (SQL) INFO: /software_dump/Exp2/DATA_UNITS/EXP4/DB/SQLFiles.LST not found (SQL) INFO: Searching for SQL file SDIC.SQL (SQL) INFO: SDIC.SQL not found (SQL) INFO: Searching for SQL file /software_dump/Exp2/DATA_UNITS/EXP4/DB/SYB/SDIC.SQL (SQL) INFO: /software_dump/Exp2/DATA_UNITS/EXP4/DB/SYB/SDIC.SQL not found (DB) ERROR: DDL statement failed (DROP INDEX "DDNTT"."DDNTT~0") DbSlExecute: rc = 103 (SQL error 3701) error message returned by DbSl: [ASE Error SQL3701]Cannot drop the index 'DDNTT.DDNTT~0', because it doesn't exist in the system catalogs.

(IMP) INFO: a failed DROP attempt is not necessarily a problem (DB) ERROR: DDL statement failed (CREATE UNIQUE INDEX "DDNTT~0" ON "DDNTT" ( "TABNAME" ) ) DbSlExecute: rc = 99 (SQL error 1505) error message returned by DbSl: [ASE Error SQL1505]Create unique index aborted on duplicate key. Primary key is '""'

(DB) INFO: DDNTT_CONV_UC deleted/truncated (SYB_IMP) ERROR: DbSlEndModify failed rc = 99, table "DDNTT_CONV_UC"

(SQL error 30128) error message returned by DbSl: [ASE Error SQL30128:HY000]Data overflow. Increase specified column size or buffer size (IMP) ERROR: EndFastload: rc = 2 (DB) ERROR: DDL statement failed (DROP INDEX "DDNTT_CONV_UC"."DDNTT_CONV_UC~0") DbSlExecute: rc = 103 (SQL error 3701) error message returned by DbSl: [ASE Error SQL3701]Cannot drop the index 'DDNTT_CONV_UC.DDNTT_CONV_UC~0', because it doesn't exist in the system catalogs.

(IMP) INFO: a failed DROP attempt is not necessarily a problem (DB) ERROR: DDL statement failed (CREATE UNIQUE INDEX "DDNTT_CONV_UC~0" ON "DDNTT_CONV_UC" ( "TABNAME" ) ) DbSlExecute: rc = 99 (SQL error 1505) error message returned by DbSl: [ASE Error SQL1505]Create unique index aborted on duplicate key. Primary key is '""'

(DB) INFO: disconnected from DB

/usr/sap/SOL/SYS/exe/run/R3load: job finished with 6 error(s) /usr/sap/SOL/SYS/exe/run/R3load: END OF LOG: 20140222180226

/usr/sap/SOL/SYS/exe/run/R3load: START OF LOG: 20140222183316

/usr/sap/SOL/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/720_REL/src/R3ld/R3load/R3ldmain.c#13 $ SAP /usr/sap/SOL/SYS/exe/run/R3load: version R7.20/V1.4 [UNICODE] Compiled Dec 1 2011 20:15:50 /usr/sap/SOL/SYS/exe/run/R3load -i SAPNTAB.cmd -dbcodepage 4103 -l SAPNTAB.log -c 99000000 loadprocedure fast

(DB) INFO: connected to DB (DB) INFO: DDNTF deleted/truncated (SYB_IMP) ERROR: DbSlExeModify/DbSlLobPutPiece failed rc = 99, table "DDNTF" (SQL error 30128) error message returned by DbSl: [ASE Error SQL30128:HY000]Data overflow. Increase specified column size or buffer size (IMP) ERROR: ExeFastload: rc = 2 (DB) INFO: DDNTF_CONV_UC deleted/truncated (SYB_IMP) ERROR: DbSlExeModify/DbSlLobPutPiece failed rc = 99, table "DDNTF_CONV_UC" (SQL error 30128) error message returned by DbSl: [ASE Error SQL30128:HY000]Data overflow. Increase specified column size or buffer size (IMP) ERROR: ExeFastload: rc = 2 (DB) INFO: DDNTT deleted/truncated (SYB_IMP) ERROR: DbSlEndModify failed rc = 99, table "DDNTT"

(SQL error 30128) error message returned by DbSl: [ASE Error SQL30128:HY000]Data overflow. Increase specified column size or buffer size (IMP) ERROR: EndFastload: rc = 2 (SQL) INFO: Searching for SQL file SQLFiles.LST (SQL) INFO: SQLFiles.LST not found (SQL) INFO: Searching for SQL file /software_dump/Exp2/DATA_UNITS/EXP4/DB/SQLFiles.LST (SQL) INFO: /software_dump/Exp2/DATA_UNITS/EXP4/DB/SQLFiles.LST not found (SQL) INFO: Searching for SQL file SDIC.SQL (SQL) INFO: SDIC.SQL not found (SQL) INFO: Searching for SQL file /software_dump/Exp2/DATA_UNITS/EXP4/DB/SYB/SDIC.SQL (SQL) INFO: /software_dump/Exp2/DATA_UNITS/EXP4/DB/SYB/SDIC.SQL not found (DB) ERROR: DDL statement failed (DROP INDEX "DDNTT"."DDNTT~0") DbSlExecute: rc = 103 (SQL error 3701) error message returned by DbSl: [ASE Error SQL3701]Cannot drop the index 'DDNTT.DDNTT~0', because it doesn't exist in the system catalogs.

(IMP) INFO: a failed DROP attempt is not necessarily a problem (DB) ERROR: DDL statement failed (CREATE UNIQUE INDEX "DDNTT~0" ON "DDNTT" ( "TABNAME" ) ) DbSlExecute: rc = 99 (SQL error 1505) error message returned by DbSl:

[ASE Error SQL1505]Create unique index aborted on duplicate key. Primary key is '""'

(DB) INFO: DDNTT_CONV_UC deleted/truncated (SYB_IMP) ERROR: DbSlEndModify failed rc = 99, table "DDNTT_CONV_UC" (SQL error 30128) error message returned by DbSl: [ASE Error SQL30128:HY000]Data overflow. Increase specified column size or buffer size (IMP) ERROR: EndFastload: rc = 2 (DB) ERROR: DDL statement failed (DROP INDEX "DDNTT_CONV_UC"."DDNTT_CONV_UC~0") DbSlExecute: rc = 103 (SQL error 3701) error message returned by DbSl: [ASE Error SQL3701]Cannot drop the index 'DDNTT_CONV_UC.DDNTT_CONV_UC~0', because it doesn't exist in the system catalogs.

(IMP) INFO: a failed DROP attempt is not necessarily a problem (DB) ERROR: DDL statement failed (CREATE UNIQUE INDEX "DDNTT_CONV_UC~0" ON "DDNTT_CONV_UC" ( "TABNAME" ) ) DbSlExecute: rc = 99 (SQL error 1505) error message returned by DbSl: [ASE Error SQL1505]Create unique index aborted on duplicate key. Primary key is '""'

(DB) INFO: disconnected from DB

/usr/sap/SOL/SYS/exe/run/R3load: job finished with 6 error(s) /usr/sap/SOL/SYS/exe/run/R3load: END OF LOG: 20140222183327

/usr/sap/SOL/SYS/exe/run/R3load: START OF LOG: 20140222185722

/usr/sap/SOL/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/720_REL/src/R3ld/R3load/R3ldmain.c#13 $ SAP /usr/sap/SOL/SYS/exe/run/R3load: version R7.20/V1.4 [UNICODE] Compiled Dec 1 2011 20:15:50 /usr/sap/SOL/SYS/exe/run/R3load -i SAPNTAB.cmd -dbcodepage 4103 -l SAPNTAB.log -c 99000000 loadprocedure fast

(DB) INFO: connected to DB (DB) INFO: DDNTF deleted/truncated (SYB_IMP) ERROR: DbSlExeModify/DbSlLobPutPiece failed rc = 99, table "DDNTF" (SQL error 30128) error message returned by DbSl: [ASE Error SQL30128:HY000]Data overflow. Increase specified column size or buffer size (IMP) ERROR: ExeFastload: rc = 2 (DB) INFO: DDNTF_CONV_UC deleted/truncated (SYB_IMP) ERROR: DbSlExeModify/DbSlLobPutPiece failed rc = 99, table "DDNTF_CONV_UC" (SQL error 30128) error message returned by DbSl:

[ASE Error SQL30128:HY000]Data overflow. Increase specified column size or buffer size (IMP) ERROR: ExeFastload: rc = 2 (DB) INFO: DDNTT deleted/truncated (SYB_IMP) ERROR: DbSlEndModify failed rc = 99, table "DDNTT" (SQL error 30128) error message returned by DbSl: [ASE Error SQL30128:HY000]Data overflow. Increase specified column size or buffer size (IMP) ERROR: EndFastload: rc = 2 (SQL) INFO: Searching for SQL file SQLFiles.LST (SQL) INFO: SQLFiles.LST not found (SQL) INFO: Searching for SQL file /software_dump/Exp2/DATA_UNITS/EXP4/DB/SQLFiles.LST (SQL) INFO: /software_dump/Exp2/DATA_UNITS/EXP4/DB/SQLFiles.LST not found (SQL) INFO: Searching for SQL file SDIC.SQL (SQL) INFO: SDIC.SQL not found (SQL) INFO: Searching for SQL file /software_dump/Exp2/DATA_UNITS/EXP4/DB/SYB/SDIC.SQL (SQL) INFO: /software_dump/Exp2/DATA_UNITS/EXP4/DB/SYB/SDIC.SQL not found (DB) ERROR: DDL statement failed (DROP INDEX "DDNTT"."DDNTT~0") DbSlExecute: rc = 103 (SQL error 3701) error message returned by DbSl: [ASE Error SQL3701]Cannot drop the index 'DDNTT.DDNTT~0', because it doesn't exist in the system catalogs.

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

(DB) ERROR: DDL statement failed (CREATE UNIQUE INDEX "DDNTT~0" ON "DDNTT" ( "TABNAME" ) ) DbSlExecute: rc = 99 (SQL error 1505) error message returned by DbSl: [ASE Error SQL1505]Create unique index aborted on duplicate key. Primary key is '""'

(DB) INFO: DDNTT_CONV_UC deleted/truncated (SYB_IMP) ERROR: DbSlEndModify failed rc = 99, table "DDNTT_CONV_UC" (SQL error 30128) error message returned by DbSl: [ASE Error SQL30128:HY000]Data overflow. Increase specified column size or buffer size (IMP) ERROR: EndFastload: rc = 2 (DB) ERROR: DDL statement failed (DROP INDEX "DDNTT_CONV_UC"."DDNTT_CONV_UC~0") DbSlExecute: rc = 103 (SQL error 3701) error message returned by DbSl: [ASE Error SQL3701]Cannot drop the index 'DDNTT_CONV_UC.DDNTT_CONV_UC~0', because it doesn't exist in the system catalogs.

(IMP) INFO: a failed DROP attempt is not necessarily a problem (DB) ERROR: DDL statement failed (CREATE UNIQUE INDEX "DDNTT_CONV_UC~0" ON "DDNTT_CONV_UC" ( "TABNAME" ) ) DbSlExecute: rc = 99

(SQL error 1505) error message returned by DbSl: [ASE Error SQL1505]Create unique index aborted on duplicate key. Primary key is '""'

(DB) INFO: disconnected from DB

/usr/sap/SOL/SYS/exe/run/R3load: job finished with 6 error(s) /usr/sap/SOL/SYS/exe/run/R3load: END OF LOG: 20140222185733

/usr/sap/SOL/SYS/exe/run/R3load: START OF LOG: 20140222193950

/usr/sap/SOL/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/720_REL/src/R3ld/R3load/R3ldmain.c#13 $ SAP /usr/sap/SOL/SYS/exe/run/R3load: version R7.20/V1.4 [UNICODE] Compiled Dec 1 2011 20:15:50 /usr/sap/SOL/SYS/exe/run/R3load -i SAPNTAB.cmd -dbcodepage 4103 -l SAPNTAB.log -c 99000000 loadprocedure fast

(DB) INFO: connected to DB (DB) INFO: DDNTF deleted/truncated (SYB_IMP) ERROR: DbSlExeModify/DbSlLobPutPiece failed rc = 99, table "DDNTF" (SQL error 30128) error message returned by DbSl: [ASE Error SQL30128:HY000]Data overflow. Increase specified column size or buffer size (IMP) ERROR: ExeFastload: rc = 2

(DB) INFO: DDNTF_CONV_UC deleted/truncated (SYB_IMP) ERROR: DbSlExeModify/DbSlLobPutPiece failed rc = 99, table "DDNTF_CONV_UC" (SQL error 30128) error message returned by DbSl: [ASE Error SQL30128:HY000]Data overflow. Increase specified column size or buffer size (IMP) ERROR: ExeFastload: rc = 2 (DB) INFO: DDNTT deleted/truncated (SYB_IMP) ERROR: DbSlEndModify failed rc = 99, table "DDNTT" (SQL error 30128) error message returned by DbSl: [ASE Error SQL30128:HY000]Data overflow. Increase specified column size or buffer size (IMP) ERROR: EndFastload: rc = 2 (SQL) INFO: Searching for SQL file SQLFiles.LST (SQL) INFO: SQLFiles.LST not found (SQL) INFO: Searching for SQL file /software_dump/Exp2/DATA_UNITS/EXP4/DB/SQLFiles.LST (SQL) INFO: /software_dump/Exp2/DATA_UNITS/EXP4/DB/SQLFiles.LST not found (SQL) INFO: Searching for SQL file SDIC.SQL (SQL) INFO: SDIC.SQL not found (SQL) INFO: Searching for SQL file /software_dump/Exp2/DATA_UNITS/EXP4/DB/SYB/SDIC.SQL (SQL) INFO: /software_dump/Exp2/DATA_UNITS/EXP4/DB/SYB/SDIC.SQL not found (DB) ERROR: DDL statement failed (DROP INDEX "DDNTT"."DDNTT~0") DbSlExecute: rc = 103

(SQL error 3701) error message returned by DbSl: [ASE Error SQL3701]Cannot drop the index 'DDNTT.DDNTT~0', because it doesn't exist in the system catalogs.

(IMP) INFO: a failed DROP attempt is not necessarily a problem (DB) ERROR: DDL statement failed (CREATE UNIQUE INDEX "DDNTT~0" ON "DDNTT" ( "TABNAME" ) ) DbSlExecute: rc = 99 (SQL error 1505) error message returned by DbSl: [ASE Error SQL1505]Create unique index aborted on duplicate key. Primary key is '""'

(DB) INFO: DDNTT_CONV_UC deleted/truncated (SYB_IMP) ERROR: DbSlEndModify failed rc = 99, table "DDNTT_CONV_UC" (SQL error 30128) error message returned by DbSl: [ASE Error SQL30128:HY000]Data overflow. Increase specified column size or buffer size (IMP) ERROR: EndFastload: rc = 2 (DB) ERROR: DDL statement failed (DROP INDEX "DDNTT_CONV_UC"."DDNTT_CONV_UC~0") DbSlExecute: rc = 103 (SQL error 3701) error message returned by DbSl:

[ASE Error SQL3701]Cannot drop the index 'DDNTT_CONV_UC.DDNTT_CONV_UC~0', because it doesn't exist in the system catalogs.

(IMP) INFO: a failed DROP attempt is not necessarily a problem (DB) ERROR: DDL statement failed (CREATE UNIQUE INDEX "DDNTT_CONV_UC~0" ON "DDNTT_CONV_UC" ( "TABNAME" ) ) DbSlExecute: rc = 99 (SQL error 1505) error message returned by DbSl: [ASE Error SQL1505]Create unique index aborted on duplicate key. Primary key is '""'

(DB) INFO: disconnected from DB

/usr/sap/SOL/SYS/exe/run/R3load: job finished with 6 error(s) /usr/sap/SOL/SYS/exe/run/R3load: END OF LOG: 20140222194001

/usr/sap/SOL/SYS/exe/run/R3load: START OF LOG: 20140222194749

/usr/sap/SOL/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/720_REL/src/R3ld/R3load/R3ldmain.c#13 $ SAP /usr/sap/SOL/SYS/exe/run/R3load: version R7.20/V1.4 [UNICODE] Compiled Dec 1 2011 20:15:50 /usr/sap/SOL/SYS/exe/run/R3load -i SAPNTAB.cmd -dbcodepage 4103 -l SAPNTAB.log -c 99000000 loadprocedure fast

(DB) INFO: connected to DB (DB) INFO: DDNTF deleted/truncated

(SYB_IMP) ERROR: DbSlExeModify/DbSlLobPutPiece failed rc = 99, table "DDNTF" (SQL error 30128) error message returned by DbSl: [ASE Error SQL30128:HY000]Data overflow. Increase specified column size or buffer size (IMP) ERROR: ExeFastload: rc = 2 (DB) INFO: DDNTF_CONV_UC deleted/truncated (SYB_IMP) ERROR: DbSlExeModify/DbSlLobPutPiece failed rc = 99, table "DDNTF_CONV_UC" (SQL error 30128) error message returned by DbSl: [ASE Error SQL30128:HY000]Data overflow. Increase specified column size or buffer size (IMP) ERROR: ExeFastload: rc = 2 (DB) INFO: DDNTT deleted/truncated (SYB_IMP) ERROR: DbSlEndModify failed rc = 99, table "DDNTT" (SQL error 30128) error message returned by DbSl: [ASE Error SQL30128:HY000]Data overflow. Increase specified column size or buffer size (IMP) ERROR: EndFastload: rc = 2 (SQL) INFO: Searching for SQL file SQLFiles.LST (SQL) INFO: SQLFiles.LST not found (SQL) INFO: Searching for SQL file /software_dump/Exp2/DATA_UNITS/EXP4/DB/SQLFiles.LST (SQL) INFO: /software_dump/Exp2/DATA_UNITS/EXP4/DB/SQLFiles.LST not found (SQL) INFO: Searching for SQL file SDIC.SQL

(SQL) INFO: SDIC.SQL not found (SQL) INFO: Searching for SQL file /software_dump/Exp2/DATA_UNITS/EXP4/DB/SYB/SDIC.SQL (SQL) INFO: /software_dump/Exp2/DATA_UNITS/EXP4/DB/SYB/SDIC.SQL not found (DB) ERROR: DDL statement failed (DROP INDEX "DDNTT"."DDNTT~0") DbSlExecute: rc = 103 (SQL error 3701) error message returned by DbSl: [ASE Error SQL3701]Cannot drop the index 'DDNTT.DDNTT~0', because it doesn't exist in the system catalogs.

(IMP) INFO: a failed DROP attempt is not necessarily a problem (DB) ERROR: DDL statement failed (CREATE UNIQUE INDEX "DDNTT~0" ON "DDNTT" ( "TABNAME" ) ) DbSlExecute: rc = 99 (SQL error 1505) error message returned by DbSl: [ASE Error SQL1505]Create unique index aborted on duplicate key. Primary key is '""'

(DB) INFO: DDNTT_CONV_UC deleted/truncated (SYB_IMP) ERROR: DbSlEndModify failed rc = 99, table "DDNTT_CONV_UC" (SQL error 30128) error message returned by DbSl: [ASE Error SQL30128:HY000]Data overflow. Increase specified column size or buffer size (IMP) ERROR: EndFastload: rc = 2

(DB) ERROR: DDL statement failed (DROP INDEX "DDNTT_CONV_UC"."DDNTT_CONV_UC~0") DbSlExecute: rc = 103 (SQL error 3701) error message returned by DbSl: [ASE Error SQL3701]Cannot drop the index 'DDNTT_CONV_UC.DDNTT_CONV_UC~0', because it doesn't exist in the system catalogs.

(IMP) INFO: a failed DROP attempt is not necessarily a problem (DB) ERROR: DDL statement failed (CREATE UNIQUE INDEX "DDNTT_CONV_UC~0" ON "DDNTT_CONV_UC" ( "TABNAME" ) ) DbSlExecute: rc = 99 (SQL error 1505) error message returned by DbSl: [ASE Error SQL1505]Create unique index aborted on duplicate key. Primary key is '""'

(DB) INFO: disconnected from DB

/usr/sap/SOL/SYS/exe/run/R3load: job finished with 6 error(s) /usr/sap/SOL/SYS/exe/run/R3load: END OF LOG: 20140222194800

/usr/sap/SOL/SYS/exe/run/R3load: START OF LOG: 20140222195341

/usr/sap/SOL/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/720_REL/src/R3ld/R3load/R3ldmain.c#13 $ SAP /usr/sap/SOL/SYS/exe/run/R3load: version R7.20/V1.4 [UNICODE]

Compiled Dec 1 2011 20:15:50 /usr/sap/SOL/SYS/exe/run/R3load -i SAPNTAB.cmd -dbcodepage 4103 -l SAPNTAB.log -c 99000000 loadprocedure fast

(DB) INFO: connected to DB (DB) INFO: DDNTF deleted/truncated (SYB_IMP) ERROR: DbSlExeModify/DbSlLobPutPiece failed rc = 99, table "DDNTF" (SQL error 30128) error message returned by DbSl: [ASE Error SQL30128:HY000]Data overflow. Increase specified column size or buffer size (IMP) ERROR: ExeFastload: rc = 2 (DB) INFO: DDNTF_CONV_UC deleted/truncated (SYB_IMP) ERROR: DbSlExeModify/DbSlLobPutPiece failed rc = 99, table "DDNTF_CONV_UC" (SQL error 30128) error message returned by DbSl: [ASE Error SQL30128:HY000]Data overflow. Increase specified column size or buffer size (IMP) ERROR: ExeFastload: rc = 2 (DB) INFO: DDNTT deleted/truncated (SYB_IMP) ERROR: DbSlEndModify failed rc = 99, table "DDNTT" (SQL error 30128) error message returned by DbSl: [ASE Error SQL30128:HY000]Data overflow. Increase specified column size or buffer size (IMP) ERROR: EndFastload: rc = 2

(SQL) INFO: Searching for SQL file SQLFiles.LST (SQL) INFO: SQLFiles.LST not found (SQL) INFO: Searching for SQL file /software_dump/Exp2/DATA_UNITS/EXP4/DB/SQLFiles.LST (SQL) INFO: /software_dump/Exp2/DATA_UNITS/EXP4/DB/SQLFiles.LST not found (SQL) INFO: Searching for SQL file SDIC.SQL (SQL) INFO: SDIC.SQL not found (SQL) INFO: Searching for SQL file /software_dump/Exp2/DATA_UNITS/EXP4/DB/SYB/SDIC.SQL (SQL) INFO: /software_dump/Exp2/DATA_UNITS/EXP4/DB/SYB/SDIC.SQL not found (DB) ERROR: DDL statement failed (DROP INDEX "DDNTT"."DDNTT~0") DbSlExecute: rc = 103 (SQL error 3701) error message returned by DbSl: [ASE Error SQL3701]Cannot drop the index 'DDNTT.DDNTT~0', because it doesn't exist in the system catalogs.

(IMP) INFO: a failed DROP attempt is not necessarily a problem (DB) ERROR: DDL statement failed (CREATE UNIQUE INDEX "DDNTT~0" ON "DDNTT" ( "TABNAME" ) ) DbSlExecute: rc = 99 (SQL error 1505) error message returned by DbSl: [ASE Error SQL1505]Create unique index aborted on duplicate key. Primary key is '""'

(DB) INFO: DDNTT_CONV_UC deleted/truncated (SYB_IMP) ERROR: DbSlEndModify failed

rc = 99, table "DDNTT_CONV_UC" (SQL error 30128) error message returned by DbSl: [ASE Error SQL30128:HY000]Data overflow. Increase specified column size or buffer size (IMP) ERROR: EndFastload: rc = 2 (DB) ERROR: DDL statement failed (DROP INDEX "DDNTT_CONV_UC"."DDNTT_CONV_UC~0") DbSlExecute: rc = 103 (SQL error 3701) error message returned by DbSl: [ASE Error SQL3701]Cannot drop the index 'DDNTT_CONV_UC.DDNTT_CONV_UC~0', because it doesn't exist in the system catalogs.

(IMP) INFO: a failed DROP attempt is not necessarily a problem (DB) ERROR: DDL statement failed (CREATE UNIQUE INDEX "DDNTT_CONV_UC~0" ON "DDNTT_CONV_UC" ( "TABNAME" ) ) DbSlExecute: rc = 99 (SQL error 1505) error message returned by DbSl: [ASE Error SQL1505]Create unique index aborted on duplicate key. Primary key is '""'

(DB) INFO: disconnected from DB

/usr/sap/SOL/SYS/exe/run/R3load: job finished with 6 error(s) /usr/sap/SOL/SYS/exe/run/R3load: END OF LOG: 20140222195352

/usr/sap/SOL/SYS/exe/run/R3load: START OF LOG: 20140222200632

/usr/sap/SOL/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/720_REL/src/R3ld/R3load/R3ldmain.c#13 $ SAP /usr/sap/SOL/SYS/exe/run/R3load: version R7.20/V1.4 [UNICODE] Compiled Dec 1 2011 20:15:50 /usr/sap/SOL/SYS/exe/run/R3load -i SAPNTAB.cmd -dbcodepage 4103 -l SAPNTAB.log -c 99000000 loadprocedure fast

(DB) INFO: connected to DB (DB) INFO: DDNTF deleted/truncated (SYB_IMP) ERROR: DbSlExeModify/DbSlLobPutPiece failed rc = 99, table "DDNTF" (SQL error 30128) error message returned by DbSl: [ASE Error SQL30128:HY000]Data overflow. Increase specified column size or buffer size (IMP) ERROR: ExeFastload: rc = 2 (DB) INFO: DDNTF_CONV_UC deleted/truncated (SYB_IMP) ERROR: DbSlExeModify/DbSlLobPutPiece failed rc = 99, table "DDNTF_CONV_UC" (SQL error 30128) error message returned by DbSl: [ASE Error SQL30128:HY000]Data overflow. Increase specified column size or buffer size (IMP) ERROR: ExeFastload: rc = 2 (DB) INFO: DDNTT deleted/truncated (SYB_IMP) ERROR: DbSlEndModify failed

rc = 99, table "DDNTT" (SQL error 30128) error message returned by DbSl: [ASE Error SQL30128:HY000]Data overflow. Increase specified column size or buffer size (IMP) ERROR: EndFastload: rc = 2 (SQL) INFO: Searching for SQL file SQLFiles.LST (SQL) INFO: SQLFiles.LST not found (SQL) INFO: Searching for SQL file /software_dump/Exp2/DATA_UNITS/EXP4/DB/SQLFiles.LST (SQL) INFO: /software_dump/Exp2/DATA_UNITS/EXP4/DB/SQLFiles.LST not found (SQL) INFO: Searching for SQL file SDIC.SQL (SQL) INFO: SDIC.SQL not found (SQL) INFO: Searching for SQL file /software_dump/Exp2/DATA_UNITS/EXP4/DB/SYB/SDIC.SQL (SQL) INFO: /software_dump/Exp2/DATA_UNITS/EXP4/DB/SYB/SDIC.SQL not found (DB) ERROR: DDL statement failed (DROP INDEX "DDNTT"."DDNTT~0") DbSlExecute: rc = 103 (SQL error 3701) error message returned by DbSl: [ASE Error SQL3701]Cannot drop the index 'DDNTT.DDNTT~0', because it doesn't exist in the system catalogs.

(IMP) INFO: a failed DROP attempt is not necessarily a problem (DB) ERROR: DDL statement failed (CREATE UNIQUE INDEX "DDNTT~0" ON "DDNTT" ( "TABNAME" ) ) DbSlExecute: rc = 99 (SQL error 1505)

error message returned by DbSl: [ASE Error SQL1505]Create unique index aborted on duplicate key. Primary key is '""'

(DB) INFO: DDNTT_CONV_UC deleted/truncated (SYB_IMP) ERROR: DbSlEndModify failed rc = 99, table "DDNTT_CONV_UC" (SQL error 30128) error message returned by DbSl: [ASE Error SQL30128:HY000]Data overflow. Increase specified column size or buffer size (IMP) ERROR: EndFastload: rc = 2 (DB) ERROR: DDL statement failed (DROP INDEX "DDNTT_CONV_UC"."DDNTT_CONV_UC~0") DbSlExecute: rc = 103 (SQL error 3701) error message returned by DbSl: [ASE Error SQL3701]Cannot drop the index 'DDNTT_CONV_UC.DDNTT_CONV_UC~0', because it doesn't exist in the system catalogs.

(IMP) INFO: a failed DROP attempt is not necessarily a problem (DB) ERROR: DDL statement failed (CREATE UNIQUE INDEX "DDNTT_CONV_UC~0" ON "DDNTT_CONV_UC" ( "TABNAME" ) ) DbSlExecute: rc = 99 (SQL error 1505) error message returned by DbSl: [ASE Error SQL1505]Create unique index aborted on duplicate key. Primary key is '""'

(DB) INFO: disconnected from DB

/usr/sap/SOL/SYS/exe/run/R3load: job finished with 6 error(s) /usr/sap/SOL/SYS/exe/run/R3load: END OF LOG: 20140222200643

You might also like