on 05-17-2013 8:09 AM
Hi All,
I am installing SAP Solution Manager 7.1 SR1 i am facing below issue ,any one please suggest me how to proceed further.I am new to sybase .
An error occurred while processing option SAP Solution Manager 7.1 SR1 > SAP Systems > Sybase ASE > Central System > Central System( Last error reported by the step: Program 'Migration Monitor' exits with error code 103. For details see log file(s) import_monitor.java.log, import_monitor.log.). You can now:
Log files are written to C:\Program Files/sapinst_instdir/SOLMAN71SR1/SYSTEM/SYB/CENTRAL/AS
.
import_monitor.java log:
java version "1.4.2_32"
Java(TM) 2 Runtime Environment, Standard Edition (build 4.1.016)
SAP Java Server VM (build 4.1.016 1.6-b03, Dec 31 2011 00:41:53 - 41_REL - optU - windows amd64 - 6 - bas2:164914 (mixed mode))
Import Monitor jobs: running 1, waiting 28, completed 0, failed 0, total 29.
Loading of 'SAPNTAB' import package: ERROR
Import Monitor jobs: running 0, waiting 28, completed 0, failed 1, total 29.
import_monitor Log:
INFO: 2013-05-16 23:36:24
Import Monitor is started.
CONFIG: 2013-05-16 23:36:24
Application options:
dbCodepage=4103
dbType=SYB
extFiles=no
importDirs=E:\Software\SAP Solution Manager Software\51042607_DVD SAP SOLMAN 7.1 SR1 INST Export\D51042607_1\DATA_UNITS\EXP1;E:\Software\SAP Solution Manager Software\51042607_DVD SAP SOLMAN 7.1 SR1 INST Export\D51042607_1\DATA_UNITS\EXP2;E:\Software\SAP Solution Manager Software\51042607_DVD SAP SOLMAN 7.1 SR1 INST Export _2\D51042607_2\DATA_UNITS\EXP3;E:\Software\SAP Solution Manager Software\51042607_DVD SAP SOLMAN 7.1 SR1 INST Export _2\D51042607_2\DATA_UNITS\EXP4
installDir=C:\Program Files\sapinst_instdir\SOLMAN71SR1\SYSTEM\SYB\CENTRAL\AS
jobNum=8
loadArgs=-c 99000000 -loadprocedure fast
monitorTimeout=30
orderBy=
r3loadExe=E:\usr\sap\SOL\SYS\exe\uc\NTAMD64\R3load.exe
sapinst=
trace=all
tskFiles=yes
CONFIG: 2013-05-16 23:36:24
List of packages with table structure: 'SAP0000'.
CONFIG: 2013-05-16 23:36:24
List of packages with views: 'SAPVIEW'.
TRACE: 2013-05-16 23:36:24 com.sap.inst.migmon.imp.ImportStandardTask preCreate
Parse of 'C:\Program Files\sapinst_instdir\SOLMAN71SR1\SYSTEM\SYB\CENTRAL\AS\DDLSYB.TPL' template file is started.
INFO: 2013-05-16 23:36:24 com.sap.inst.migmon.imp.ImportStandardTask preCreate
Parse of 'C:\Program Files\sapinst_instdir\SOLMAN71SR1\SYSTEM\SYB\CENTRAL\AS\DDLSYB.TPL' template file is successfully completed.
Primary key creation: after load.
Index creation: after load.
INFO: 2013-05-16 23:36:24
Data codepage 1100 is determined using TOC file 'E:\Software\SAP Solution Manager Software\51042607_DVD SAP SOLMAN 7.1 SR1 INST Export\D51042607_1\DATA_UNITS\EXP1\DATA\SAPSSEXC.TOC' for package 'SAPSSEXC'.
INFO: 2013-05-16 23:36:31
Version table 'SVERS' is found in STR file 'E:\Software\SAP Solution Manager Software\51042607_DVD SAP SOLMAN 7.1 SR1 INST Export _2\D51042607_2\DATA_UNITS\EXP4\DATA\SAPNTAB.STR' from package 'SAPNTAB'.
INFO: 2013-05-16 23:36:31
Data conversion tables 'DDNTF,DDNTF_CONV_UC,DDNTT,DDNTT_CONV_UC' are found in STR file 'E:\Software\SAP Solution Manager Software\51042607_DVD SAP SOLMAN 7.1 SR1 INST Export _2\D51042607_2\DATA_UNITS\EXP4\DATA\SAPNTAB.STR' from package 'SAPNTAB'.
TRACE: 2013-05-16 23:36:32 com.sap.inst.migmon.LoadTask run
Loading of 'SAPNTAB' import package is started.
TRACE: 2013-05-16 23:36:32 com.sap.inst.migmon.LoadTask processPackage
Task file generation for 'SAPNTAB' import package:
E:\usr\sap\SOL\SYS\exe\uc\NTAMD64\R3load.exe -ctf I "E:\Software\SAP Solution Manager Software\51042607_DVD SAP SOLMAN 7.1 SR1 INST Export _2\D51042607_2\DATA_UNITS\EXP4\DATA\SAPNTAB.STR" "C:\Program Files\sapinst_instdir\SOLMAN71SR1\SYSTEM\SYB\CENTRAL\AS\DDLSYB.TPL" SAPNTAB.TSK SYB -l SAPNTAB.log
TRACE: 2013-05-16 23:36:32 com.sap.inst.migmon.LoadTask processPackage
Loading of 'SAPNTAB' import package into database:
E:\usr\sap\SOL\SYS\exe\uc\NTAMD64\R3load.exe -i SAPNTAB.cmd -dbcodepage 4103 -l SAPNTAB.log -c 99000000 -loadprocedure fast
ERROR: 2013-05-16 23:37:12 com.sap.inst.migmon.LoadTask run
Loading of 'SAPNTAB' import package is interrupted with R3load error.
Process 'E:\usr\sap\SOL\SYS\exe\uc\NTAMD64\R3load.exe -i SAPNTAB.cmd -dbcodepage 4103 -l SAPNTAB.log -c 99000000 -loadprocedure fast' exited with return code 2.
For mode details see 'SAPNTAB.log' file.
Standard error output:
sapparam: sapargv(argc, argv) has not been called!
sapparam(1c): No Profile used.
sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline
WARNING: 2013-05-16 23:37:24
Cannot continue import because not all import packages with data conversion tables are loaded successfully.
WARNING: 2013-05-16 23:37:24
1 error(s) during processing of packages.
INFO: 2013-05-16 23:37:24
Import Monitor is stopped.
Please suggest
ERROR: 2013-05-16 23:37:12 com.sap.inst.migmon.LoadTask run
Loading of 'SAPNTAB' import package is interrupted with R3load error.
Process 'E:\usr\sap\SOL\SYS\exe\uc\NTAMD64\R3load.exe -i SAPNTAB.cmd -dbcodepage 4103 -l SAPNTAB.log -c 99000000 -loadprocedure fast' exited with return code 2.
For mode details see 'SAPNTAB.log' file.
Check SAPNTAB.log file for more info.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI,
Please find the Log below
E:\usr\sap\SOL\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20130516233632
E:\usr\sap\SOL\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/720_REL/src/R3ld/R3load/R3ldmain.c#13 $ SAP
E:\usr\sap\SOL\SYS\exe\uc\NTAMD64\R3load.exe: version R7.20/V1.4 [UNICODE]
Compiled Dec 2 2011 03:21:30
patchinfo (patches.h): (0.113) NewDB R3load better support (note 1564286)
process id 4124
E:\usr\sap\SOL\SYS\exe\uc\NTAMD64\R3load.exe -ctf I E:\Software\SAP Solution Manager Software\51042607_DVD SAP SOLMAN 7.1 SR1 INST Export _2\D51042607_2\DATA_UNITS\EXP4\DATA\SAPNTAB.STR C:\Program Files\sapinst_instdir\SOLMAN71SR1\SYSTEM\SYB\CENTRAL\AS\DDLSYB.TPL SAPNTAB.TSK SYB -l SAPNTAB.log
E:\usr\sap\SOL\SYS\exe\uc\NTAMD64\R3load.exe: job completed
E:\usr\sap\SOL\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20130516233632
E:\usr\sap\SOL\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20130516233632
E:\usr\sap\SOL\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/720_REL/src/R3ld/R3load/R3ldmain.c#13 $ SAP
E:\usr\sap\SOL\SYS\exe\uc\NTAMD64\R3load.exe: version R7.20/V1.4 [UNICODE]
Compiled Dec 2 2011 03:21:30
patchinfo (patches.h): (0.113) NewDB R3load better support (note 1564286)
process id 3240
E:\usr\sap\SOL\SYS\exe\uc\NTAMD64\R3load.exe -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 E:\Software\SAP Solution Manager Software\51042607_DVD SAP SOLMAN 7.1 SR1 INST Export _2\D51042607_2\DATA_UNITS\EXP4\DB/SQLFiles.LST
(SQL) INFO: E:\Software\SAP Solution Manager Software\51042607_DVD SAP SOLMAN 7.1 SR1 INST Export _2\D51042607_2\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 E:\Software\SAP Solution Manager Software\51042607_DVD SAP SOLMAN 7.1 SR1 INST Export _2\D51042607_2\DATA_UNITS\EXP4\DB/SYB/SDIC.SQL
(SQL) INFO: E:\Software\SAP Solution Manager Software\51042607_DVD SAP SOLMAN 7.1 SR1 INST Export _2\D51042607_2\DATA_UNITS\EXP4\DB/SYB/SDIC.SQL not found
(DB) INFO: SVERS created
(IMP) INFO: import of SVERS completed (1 rows) #20130516233634
(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
E:\usr\sap\SOL\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 6 error(s)
E:\usr\sap\SOL\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20130516233712
E:\usr\sap\SOL\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20130516233842
E:\usr\sap\SOL\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/720_REL/src/R3ld/R3load/R3ldmain.c#13 $ SAP
E:\usr\sap\SOL\SYS\exe\uc\NTAMD64\R3load.exe: version R7.20/V1.4 [UNICODE]
Compiled Dec 2 2011 03:21:30
patchinfo (patches.h): (0.113) NewDB R3load better support (note 1564286)
process id 1148
E:\usr\sap\SOL\SYS\exe\uc\NTAMD64\R3load.exe -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 E:\Software\SAP Solution Manager Software\51042607_DVD SAP SOLMAN 7.1 SR1 INST Export _2\D51042607_2\DATA_UNITS\EXP4\DB/SQLFiles.LST
(SQL) INFO: E:\Software\SAP Solution Manager Software\51042607_DVD SAP SOLMAN 7.1 SR1 INST Export _2\D51042607_2\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 E:\Software\SAP Solution Manager Software\51042607_DVD SAP SOLMAN 7.1 SR1 INST Export _2\D51042607_2\DATA_UNITS\EXP4\DB/SYB/SDIC.SQL
(SQL) INFO: E:\Software\SAP Solution Manager Software\51042607_DVD SAP SOLMAN 7.1 SR1 INST Export _2\D51042607_2\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
E:\usr\sap\SOL\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 6 error(s)
E:\usr\sap\SOL\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20130516233857
E:\usr\sap\SOL\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20130516235129
E:\usr\sap\SOL\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/720_REL/src/R3ld/R3load/R3ldmain.c#13 $ SAP
E:\usr\sap\SOL\SYS\exe\uc\NTAMD64\R3load.exe: version R7.20/V1.4 [UNICODE]
Compiled Dec 2 2011 03:21:30
patchinfo (patches.h): (0.113) NewDB R3load better support (note 1564286)
process id 4484
E:\usr\sap\SOL\SYS\exe\uc\NTAMD64\R3load.exe -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 E:\Software\SAP Solution Manager Software\51042607_DVD SAP SOLMAN 7.1 SR1 INST Export _2\D51042607_2\DATA_UNITS\EXP4\DB/SQLFiles.LST
(SQL) INFO: E:\Software\SAP Solution Manager Software\51042607_DVD SAP SOLMAN 7.1 SR1 INST Export _2\D51042607_2\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 E:\Software\SAP Solution Manager Software\51042607_DVD SAP SOLMAN 7.1 SR1 INST Export _2\D51042607_2\DATA_UNITS\EXP4\DB/SYB/SDIC.SQL
(SQL) INFO: E:\Software\SAP Solution Manager Software\51042607_DVD SAP SOLMAN 7.1 SR1 INST Export _2\D51042607_2\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
E:\usr\sap\SOL\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 6 error(s)
E:\usr\sap\SOL\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20130516235142
E:\usr\sap\SOL\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20130517002635
E:\usr\sap\SOL\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/720_REL/src/R3ld/R3load/R3ldmain.c#13 $ SAP
E:\usr\sap\SOL\SYS\exe\uc\NTAMD64\R3load.exe: version R7.20/V1.4 [UNICODE]
Compiled Dec 2 2011 03:21:30
patchinfo (patches.h): (0.113) NewDB R3load better support (note 1564286)
process id 4496
E:\usr\sap\SOL\SYS\exe\uc\NTAMD64\R3load.exe -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 E:\Software\SAP Solution Manager Software\51042607_DVD SAP SOLMAN 7.1 SR1 INST Export _2\D51042607_2\DATA_UNITS\EXP4\DB/SQLFiles.LST
(SQL) INFO: E:\Software\SAP Solution Manager Software\51042607_DVD SAP SOLMAN 7.1 SR1 INST Export _2\D51042607_2\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 E:\Software\SAP Solution Manager Software\51042607_DVD SAP SOLMAN 7.1 SR1 INST Export _2\D51042607_2\DATA_UNITS\EXP4\DB/SYB/SDIC.SQL
(SQL) INFO: E:\Software\SAP Solution Manager Software\51042607_DVD SAP SOLMAN 7.1 SR1 INST Export _2\D51042607_2\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
E:\usr\sap\SOL\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 6 error(s)
E:\usr\sap\SOL\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20130517002648
E:\usr\sap\SOL\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20130517004415
E:\usr\sap\SOL\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/720_REL/src/R3ld/R3load/R3ldmain.c#13 $ SAP
E:\usr\sap\SOL\SYS\exe\uc\NTAMD64\R3load.exe: version R7.20/V1.4 [UNICODE]
Compiled Dec 2 2011 03:21:30
patchinfo (patches.h): (0.113) NewDB R3load better support (note 1564286)
process id 4400
E:\usr\sap\SOL\SYS\exe\uc\NTAMD64\R3load.exe -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 E:\Software\SAP Solution Manager Software\51042607_DVD SAP SOLMAN 7.1 SR1 INST Export _2\D51042607_2\DATA_UNITS\EXP4\DB/SQLFiles.LST
(SQL) INFO: E:\Software\SAP Solution Manager Software\51042607_DVD SAP SOLMAN 7.1 SR1 INST Export _2\D51042607_2\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 E:\Software\SAP Solution Manager Software\51042607_DVD SAP SOLMAN 7.1 SR1 INST Export _2\D51042607_2\DATA_UNITS\EXP4\DB/SYB/SDIC.SQL
(SQL) INFO: E:\Software\SAP Solution Manager Software\51042607_DVD SAP SOLMAN 7.1 SR1 INST Export _2\D51042607_2\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
E:\usr\sap\SOL\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 6 error(s)
E:\usr\sap\SOL\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20130517004429
E:\usr\sap\SOL\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20130517004857
E:\usr\sap\SOL\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/720_REL/src/R3ld/R3load/R3ldmain.c#13 $ SAP
E:\usr\sap\SOL\SYS\exe\uc\NTAMD64\R3load.exe: version R7.20/V1.4 [UNICODE]
Compiled Dec 2 2011 03:21:30
patchinfo (patches.h): (0.113) NewDB R3load better support (note 1564286)
process id 4616
E:\usr\sap\SOL\SYS\exe\uc\NTAMD64\R3load.exe -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 E:\Software\SAP Solution Manager Software\51042607_DVD SAP SOLMAN 7.1 SR1 INST Export _2\D51042607_2\DATA_UNITS\EXP4\DB/SQLFiles.LST
(SQL) INFO: E:\Software\SAP Solution Manager Software\51042607_DVD SAP SOLMAN 7.1 SR1 INST Export _2\D51042607_2\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 E:\Software\SAP Solution Manager Software\51042607_DVD SAP SOLMAN 7.1 SR1 INST Export _2\D51042607_2\DATA_UNITS\EXP4\DB/SYB/SDIC.SQL
(SQL) INFO: E:\Software\SAP Solution Manager Software\51042607_DVD SAP SOLMAN 7.1 SR1 INST Export _2\D51042607_2\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
E:\usr\sap\SOL\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 6 error(s)
E:\usr\sap\SOL\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20130517004914
Please suggest
Hi,
Please check whether the files being used for installation are not corrupted. check if the size of these files are same as the one in marketplace.
Searching for SQL file SQLFiles.LST
(SQL) INFO: SQLFiles.LST not found
(SQL) INFO: Searching for SQL file E:\Software\SAP Solution Manager Software\51042607_DVD SAP SOLMAN 7.1 SR1 INST Export _2\D51042607_2\DATA_UNITS\EXP4\DB/SQLFiles.LST
(SQL) INFO: E:\Software\SAP Solution Manager Software\51042607_DVD SAP SOLMAN 7.1 SR1 INST Export _2\D51042607_2\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 E:\Software\SAP Solution Manager Software\51042607_DVD SAP SOLMAN 7.1 SR1 INST Export _2\D51042607_2\DATA_UNITS\EXP4\DB/SYB/SDIC.SQL
(SQL) INFO: E:\Software\SAP Solution Manager Software\51042607_DVD SAP SOLMAN 7.1 SR1 INST Export _2\D51042607_2\DATA_UNITS\EXP4\DB/SYB/SDIC.SQL not found
Please read Note 1716201 - SYB:Update control.xml files for installation: Sybase ASE. It contains solution for your problem.
Hi Roman,
Please clarify I am confused I ned to download the control_51042606.zip file from the note where can I put this file .
Thansk
HI Roman,
I have stopped the installtion and uninstalled everything incluing sybase database ,I am using the below DVDS recived from SAP.
51042606_DVD SAP SOLMAN 7.1 SR1 Inst Master
51044132_DVD SYbase ASE 15.7 RDBMS for Bus .Sui
51042617_DVD Solman 7.1 krnl 7.20 EXT Sybase AS
PLease suggest how to proceed further.
Hi,
As per my previous suggestion I see you have followed it somewhat.
Note 1716201 - SYB:Update control.xml files for installation: Sybase ASE
Use this note.
Johan
Hi,
Have you checked the files also very very important:
Looking at the errrors before you did your export on your source did you run report SMIGR_CREATE_DDL?
Refer to Note 888210 - NW 7.**: System copy (supplementary note) section 2
If so please verify where you ran the report i.e. CI or DI instance of source system then in that system go search for the files SQLFiles.LST and *.SQL and once you have these files please copy them to your sapinst running directory i.e. /sapinst_instdir/SOLMAN71SR1/SYSTEM/SYB/CENTRAL/AS
Then please retry.
Kind Regards,
Johan
Hi ,Please find the disp+work
disp+work information
--------------------
kernel release 720
kernel make variant 720_EXT_REL
compiled on NT 6.0 6002 S x86 MS VC++ 16.00 for NTAMD64
compiled for 64 BIT
compilation mode UNICODE
compile time Dec 2 2011 02:32:02
Could not load SYB library sybdrvodb64.dll. No database connection possi
update level 0
patch number 114
source id 0.114
Download more recent version of kernel (pl > 210) from http://service.sap.com/patches and unpack into kernel directory. From note:
Log on as user <sapsid>adm and unpack SAPEXE.SAR and SAPEXEDB.SAR of at least kernel version 720 EXT UC 64 pl 210 into the kernel directory:
<Drive:>\usr\sap\<SAPSID>\SYS\exe\<codepage>\<platform> (Windows)
Push 'Retry' in the installer.
Hi,
service.sap.com\downloads
Browse download category:
Additional Components" SAP Kernel" SAP KERNEL 64-BIT UNICODE" SAP KERNEL 7.20 64-BIT UNICODE
Regards,
Johan
http://service.sap.com/patches ->
Browse Our Download Catalog ->
Additional Components ->
SAP Kernel ->
SAP KERNEL 64-BIT UNICODE ->
SAP KERNEL 7.20 EXT 64-BIT UC ->
Windows on x64 64bit
1) #Database independent -> SAPEXE
2) SYBASE ASE -> SAPEXEDB
Hello Gurus,
I am trying to install
Netweaver 7.0 EHP2 (ABAP stack only) on Windows 2008 R2 & Sybase in
Distributed Mode. I have completed installation of Global Host Pre, ASCS
Instance & now I am Database Instance and stuck at "Import ABAP"
with the error mentioned in SAP note 1716201 in C:\Program
Files\sapinst_instdir\NW702\AS-ABAP\SYB\DISTRIBUTED\DB\SAPNTAB
For which I performed
below steps
Please let me know
what could be the possible cause as I am running out of time .
Thanks & Regards,
Victor
Dear All,
As per SAP Note 1688468, please apply latest lib_dbsl executables along with latest R3load to resolve this issue.
After successful completion of the said installation, do not forget to apply compatible latest kernel.
Regards,
Bhavik G. Shroff
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sap basis,
Error:
An import logfile created by R3load contains the following error message:
[ASE Error SQL30128:HY000]Data overflow. Increase specified column size or buffer size
(IMP) ERROR: ExeFastload: rc = 2
Analysis:
You use updated RDBMS media for the installation, for example, containing Sybase ASE 15.7.0.012. The ODBC driver 15.7.0.105 on these media requires a higher DBSL version than was part of the original delivery.
Solution:
Update the installation master and kernel media according to SAP Note 1716201.
Logon as user <sapsid>adm and Unpack SAPEXE.SAR and SAPEXEDB.SAR of at least kernel version 720 EXT UC 64 pl 210 into the kernel directory
/usr/sap/<SAPSID>/SYS/exe/run (unix)
/usr/sap/<SAPSID>/SYS/exe/<codepage>/<platform> (windows)
and push 'Retry' in SAPinst.
Also to verify:
Searching for SQL file SQLFiles.LST
(SQL) INFO: SQLFiles.LST not found
(SQL) INFO: Searching for SQL file E:\Software\SAP Solution Manager Software\51042607_DVD SAP SOLMAN 7.1 SR1 INST Export _2\D51042607_2\DATA_UNITS\EXP4\DB/SQLFiles.LST
(SQL) INFO: E:\Software\SAP Solution Manager Software\51042607_DVD SAP SOLMAN 7.1 SR1 INST Export _2\D51042607_2\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 E:\Software\SAP Solution Manager Software\51042607_DVD SAP SOLMAN 7.1 SR1 INST Export _2\D51042607_2\DATA_UNITS\EXP4\DB/SYB/SDIC.SQL
(SQL) INFO: E:\Software\SAP Solution Manager Software\51042607_DVD SAP SOLMAN 7.1 SR1 INST Export _2\D51042607_2\DATA_UNITS\EXP4\DB/SYB/SDIC.SQL not found
Looking at the errrors before you did your export did you run report SMIGR_CREATE_DDL?
If so please verify where you ran the report i.e. CI or DI instance then in that system go search for the files SQLFiles.LST and *.SQL and once you have these files please copy them to your sapinst running directory i.e. /sapinst_instdir/SOLMAN71SR1/SYSTEM/SYB/CENTRAL/AS
Then please retry.
Kind Regards,
Johan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Gurus,
I am trying to install
Netweaver 7.0 EHP2 (ABAP stack only) on Windows 2008 R2 & Sybase in
Distributed Mode. I have completed installation of Global Host Pre, ASCS
Instance & now I am Database Instance and stuck at "Import ABAP"
with the error mentioned in SAP note 1716201 in C:\Program
Files\sapinst_instdir\NW702\AS-ABAP\SYB\DISTRIBUTED\DB\SAPNTAB
For which I performed
below steps
Please let me know
what could be the possible cause as I am running out of time .
Thanks & Regards,
Victor
HI All,
Any one repply me its urgent
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.