cancel
Showing results for 
Search instead for 
Did you mean: 

Migration Monitor' exits with error code 103

Former Member
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hello Abhisek,

Provide SAPNTAB.log.

BR,

K.

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

Thanks

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

Answers (1)

Answers (1)

former_member206552
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Log file attached q10429991-1.txt

Former Member
0 Kudos

Log file attached q10429991-2.txt