import monitor failed

[Former Member]

Hello,

We have performed an heterogeneous migration from solaris to linux.

DB is oracle 10.2.0.4 and sap is 6.40 version.

Export has ran successfully and we are now at import phase.

However, when running the import_monitor.sh script, it fails with this error:

INFO: 2010-10-01 09:03:15

Version table 'SVERS' is found in STR file '/oracle/PR1/sapdatas/EXP/DATA/SAPNTAB.STR' from package 'SAPNTAB'.

INFO: 2010-10-01 09:03:15

Data conversion tables 'DDNTF,DDNTF_CONV_UC,DDNTT,DDNTT_CONV_UC' are found in STR file '/oracle/PR1/sapdatas/EXP/DATA/SAPNTAB.STR' from package 'SAPNTAB'.

TRACE: 2010-10-01 09:03:15 com.sap.inst.migmon.LoadTask run

Loading of 'SAPNTAB' import package is started.

TRACE: 2010-10-01 09:03:15 com.sap.inst.migmon.LoadTask processPackage

Loading of 'SAPNTAB' import package into database:

R3load -i SAPNTAB.cmd -dbcodepage 4103 -k 1W9gdUM50Dh01eqtdAQv0Qmw -l SAPNTAB.log -loadprocedure fast

ERROR: 2010-10-01 09:03:16 com.sap.inst.migmon.LoadTask run

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

Process 'R3load -i SAPNTAB.cmd -dbcodepage 4103 -k 1W9gdUM50Dh01eqtdAQv0Qmw -l SAPNTAB.log -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: 2010-10-01 09:03:27

Cannot continue import because not all import packages with data conversion tables are loaded successfully.

WARNING: 2010-10-01 09:03:27

1 error(s) during processing of packages.

INFO: 2010-10-01 09:03:27

Import Monitor is stopped.

Checking the SAPNTAB.log, we can see this error:

/usr/sap/EP2/SYS/exe/run/R3load: START OF LOG: 20101001090315

/usr/sap/EP2/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/640_REL/src/R3ld/R3load/R3ldmain.c#27 $ SAP

/usr/sap/EP2/SYS/exe/run/R3load: version R6.40/V1.4 [UNICODE]

Compiled Jun 28 2010 11:10:30

/usr/sap/EP2/SYS/exe/run/R3load -i SAPNTAB.cmd -dbcodepage 4103 -k 1W9gdUM50Dh01eqtdAQv0Qmw -l SAPNTAB.log -loadprocedure fast

(DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF8

(GSI) INFO: dbname = "EP220100924030906 "

(GSI) INFO: vname = "ORACLE "

(GSI) INFO: hostname = "adpsap136 "

(GSI) INFO: sysname = "Linux"

(GSI) INFO: nodename = "adpsap136"

(GSI) INFO: release = "2.6.16.60-0.59.1-smp"

(GSI) INFO: version = "#1 SMP Thu Jan 14 18:30:10 UTC 2010"

(GSI) INFO: machine = "x86_64"

(DB) ERROR: DDL statement failed

(DROP TABLE "SVERS")

DbSlExecute: rc = 103

(SQL error 942)

error message returned by DbSl:

ORA-00942: table or view does not exist

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

DbSl Trace: ORA-922 occurred when executing SQL statement (parse error offset=86)

(DB) ERROR: DDL statement failed

(CREATE TABLE "SVERS" ( "VERSION" VARCHAR2(216) DEFAULT ' ' NOT NULL ) TABLESPACE PSAP@SCHEMAID@ STORAGE (INITIAL 65536 NEXT 0000000040K MINEXTENTS 0000000

001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) )

DbSlExecute: rc = 99

(SQL error 922)

error message returned by DbSl:

ORA-00922: missing or invalid option

(DB) ERROR: DDL statement failed

(TRUNCATE TABLE "SVERS")

DbSlExecute: rc = 103

(SQL error 942)

error message returned by DbSl:

ORA-00942: table or view does not exist

(DB) ERROR: DDL statement failed

(DROP INDEX "SVERS~0")

DbSlExecute: rc = 103

(SQL error 1418)

error message returned by DbSl:

ORA-01418: specified index does not exist

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

DbSl Trace: ORA-2158 occurred when executing SQL statement (parse error offset=70)

Thanks for the help.

Best regards

[Former Member]

Hello,

Thanks for the input

It is the first package which fails. In parallel, we have tried to execute these SQL statements directly and they worked.

The migration is not a UC migration but only an OS migration (from solaris to linux).

Best regards

[Former Member]

Hello,

Error solved.

The error is ORA-00922 produced when importing package SAPNTAB.

This error is caused by wrong tablespace name "PSAP@SCHEMAID@", this

means that placeholder @SCHEMAID@ has not been replaced correctly

whithin your DDLORA.TPL. Usually this variable is replaced at runtime

with the help of the environment variable 'DBS_ORA_SCHEMA'.

However, environment variable are well set:

xxx:SIDadm 117> env |grep -i sch

dbs_ora_schema=SAPDB0

So we have replaced files DDLORA.TPL from export directory by

DDLORA.TPL from installation directory

Import has been launched successfully.

Thanks for your replies.

Best regards

[former_member188883]

Hi,

Can you provide us inputs like

1) Is this the first package which is getting failed or there are other errors as well ?

2) Are u doing Unicode migration or only system copy process?

Regards,

Deepak Kori