on 11-12-2013 8:53 AM
SAP Solution Manager 7.1 Support Release 1 Migration Monitor' exits with error code 103.
kindly help to process the same.
\
import monitor java
------------------------------
java version "1.6.0_31"
Java(TM) SE Runtime Environment (build 6.1.038)
SAP Java Server VM (build 6.1.038 19.1-b02, Feb 14 2012 12:53:28 - 61_REL - optU - aix ppc64 - 6 - bas2:166762 (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
--------------------
INFO: 2013-11-12 11:55:02
Import Monitor is started.
CONFIG: 2013-11-12 11:55:02
Application options:
dbCodepage=4102
dbType=SYB
extFiles=no
importDirs=/backup/SOLD/SOLd/51042607_1/DATA_UNITS/EXP1:/backup/SOLD/SOLd/51042607_1/DATA_UNITS/EXP2:/backup/SOLD/SOLd/51042607_2/DATA_UNITS/EXP3:/backup/SOLD/SOLd/51042607_2/DATA_UNITS/EXP4
installDir=/tmp/sapinst_instdir/SOLMAN71/SYSTEM/SYB/CENTRAL/AS
jobNum=3
loadArgs=-c 99000000 -loadprocedure fast
monitorTimeout=30
orderBy=
r3loadExe=/usr/sap/MST/SYS/exe/run/R3load
sapinst=
trace=all
tskFiles=yes
CONFIG: 2013-11-12 11:55:02
List of packages with table structure: 'SAP0000'.
CONFIG: 2013-11-12 11:55:02
List of packages with views: 'SAPVIEW'.
TRACE: 2013-11-12 11:55:02 com.sap.inst.migmon.imp.ImportStandardTask preCreate
Parse of '/tmp/sapinst_instdir/SOLMAN71/SYSTEM/SYB/CENTRAL/AS/DDLSYB.TPL' template file is started.
INFO: 2013-11-12 11:55:02 com.sap.inst.migmon.imp.ImportStandardTask preCreate
Parse of '/tmp/sapinst_instdir/SOLMAN71/SYSTEM/SYB/CENTRAL/AS/DDLSYB.TPL' template file is successfully completed.
Primary key creation: after load.
Index creation: after load.
INFO: 2013-11-12 11:55:02
Data codepage 1100 is determined using TOC file '/backup/SOLD/SOLd/51042607_1/DATA_UNITS/EXP1/DATA/SAPSSEXC.TOC' for package 'SAPSSEXC'.
INFO: 2013-11-12 11:55:04
Version table 'SVERS' is found in STR file '/backup/SOLD/SOLd/51042607_2/DATA_UNITS/EXP4/DATA/SAPNTAB.STR' from package 'SAPNTAB'.
INFO: 2013-11-12 11:55:04
Data conversion tables 'DDNTF,DDNTF_CONV_UC,DDNTT,DDNTT_CONV_UC' are found in STR file '/backup/SOLD/SOLd/51042607_2/DATA_UNITS/EXP4/DATA/SAPNTAB.STR' from package 'SAPNTAB'.
TRACE: 2013-11-12 11:55:04 com.sap.inst.migmon.LoadTask run
Loading of 'SAPNTAB' import package is started.
TRACE: 2013-11-12 11:55:04 com.sap.inst.migmon.LoadTask processPackage
Task file generation for 'SAPNTAB' import package:
/usr/sap/MST/SYS/exe/run/R3load -ctf I /backup/SOLD/SOLd/51042607_2/DATA_UNITS/EXP4/DATA/SAPNTAB.STR /tmp/sapinst_instdir/SOLMAN71/SYSTEM/SYB/CENTRAL/AS/DDLSYB.TPL SAPNTAB.TSK SYB -l SAPNTAB.log
TRACE: 2013-11-12 11:55:04 com.sap.inst.migmon.LoadTask processPackage
Loading of 'SAPNTAB' import package into database:
/usr/sap/MST/SYS/exe/run/R3load -i SAPNTAB.cmd -dbcodepage 4102 -l SAPNTAB.log -c 99000000 -loadprocedure fast
ERROR: 2013-11-12 11:55:15 com.sap.inst.migmon.LoadTask run
Loading of 'SAPNTAB' import package is interrupted with R3load error.
Process '/usr/sap/MST/SYS/exe/run/R3load -i SAPNTAB.cmd -dbcodepage 4102 -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.
Hello Abhisek,
Provide SAPNTAB.log.
BR,
K.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Find log details.
SAPNTAB.log
----------------------
/usr/sap/MST/SYS/exe/run/R3load: START OF LOG: 20131112115504
/usr/sap/MST/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/720_REL/src/R3ld/R3load/R3ldmain.c#13 $ SAP
/usr/sap/MST/SYS/exe/run/R3load: version R7.20/V1.4 [UNICODE]
Compiled Dec 1 2011 23:52:22
/usr/sap/MST/SYS/exe/run/R3load -ctf I /backup/SOLD/SOLd/51042607_2/DATA_UNITS/EXP4/DATA/SAPNTAB.STR /tmp/sapinst_instdir/SOLMAN71/SYSTEM/SYB/CENTRAL/AS/DDLSYB.TPL SAPNTAB.TSK SYB -l SAPNTAB.log
/usr/sap/MST/SYS/exe/run/R3load: job completed
/usr/sap/MST/SYS/exe/run/R3load: END OF LOG: 20131112115504
/usr/sap/MST/SYS/exe/run/R3load: START OF LOG: 20131112115504
/usr/sap/MST/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/720_REL/src/R3ld/R3load/R3ldmain.c#13 $ SAP
/usr/sap/MST/SYS/exe/run/R3load: version R7.20/V1.4 [UNICODE]
Compiled Dec 1 2011 23:52:22
/usr/sap/MST/SYS/exe/run/R3load -i SAPNTAB.cmd -dbcodepage 4102 -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 /backup/SOLD/SOLd/51042607_2/DATA_UNITS/EXP4/DB/SQLFiles.LST
(SQL) INFO: /backup/SOLD/SOLd/51042607_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 /backup/SOLD/SOLd/51042607_2/DATA_UNITS/EXP4/DB/SYB/SDIC.SQL
(SQL) INFO: /backup/SOLD/SOLd/51042607_2/DATA_UNITS/EXP4/DB/SYB/SDIC.SQL not found
(DB) INFO: SVERS created
(IMP) INFO: import of SVERS completed (1 rows) #20131112115504
(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/MST/SYS/exe/run/R3load: job finished with 6 error(s)
/usr/sap/MST/SYS/exe/run/R3load: END OF LOG: 20131112115515
/usr/sap/MST/SYS/exe/run/R3load: START OF LOG: 20131112120231
/usr/sap/MST/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/720_REL/src/R3ld/R3load/R3ldmain.c#13 $ SAP
/usr/sap/MST/SYS/exe/run/R3load: version R7.20/V1.4 [UNICODE]
Compiled Dec 1 2011 23:52:22
/usr/sap/MST/SYS/exe/run/R3load -i SAPNTAB.cmd -dbcodepage 4102 -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 /backup/SOLD/SOLd/51042607_2/DATA_UNITS/EXP4/DB/SQLFiles.LST
(SQL) INFO: /backup/SOLD/SOLd/51042607_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 /backup/SOLD/SOLd/51042607_2/DATA_UNITS/EXP4/DB/SYB/SDIC.SQL
(SQL) INFO: /backup/SOLD/SOLd/51042607_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
/usr/sap/MST/SYS/exe/run/R3load: job finished with 6 error(s)
/usr/sap/MST/SYS/exe/run/R3load: END OF LOG: 20131112120242
Hello Abhishek,
Check note 1716201 - SYB:Update control.xml files for installation: Sybase ASE
Installation phase 'ABAP Import' fails immediately
Error:
An import log file 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.
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:
/usr/sap/<SAPSID>/SYS/exe/run (Unix)
<Drive:>\usr\sap\<SAPSID>\SYS\exe\<codepage>\<platform> (Windows)
Push 'Retry' in the installer.
BR,
K.
Message was edited by: Kamil Kubrak
Thanks Kamil Kubrak
I done only this step and abap import phase is working.
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:
/usr/sap/<SAPSID>/SYS/exe/run (Unix)
once again thanks to Kamil Kubrak
Hi Abhishek
please upload 'SAPNTAB.log' this log file contains more information about the error,
also sapinst_dev.log
this might be something simple as a kernel update
Best Regards
Marius
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Log file attached q10429991-1.txt
Log file attached q10429991-2.txt
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.