Solman 7.1 Installation Error: Fails on 18 of 48 "Import ABAP"

[Former Member]

Hello all,

I'm getting an error while trying to install Solution Manager 7.1 on AIX 5.3, Oracle 11.2

Phase 18 is throwing an error that migration monitor is failing to load packages with error 103. Output of logs is below.

<p>

import_montor.java.log

-

---

java version "1.4.2"

Java(TM) 2 Runtime Environment, Standard Edition (build 2.3)

IBM J9 VM (build 2.3, J2RE 1.4.2 IBM J9 2.3 AIX ppc64-64 j9ap64142ifx-20110628 (JIT enabled)

J9VM - 20110627_85693_BHdSMr

JIT - 20090210_1447ifx5_r8

GC - 200902_24)

Import Monitor jobs: running 1, waiting 9, completed 19, failed 0, total 29.

Import Monitor jobs: running 2, waiting 8, completed 19, failed 0, total 29.

Import Monitor jobs: running 3, waiting 7, completed 19, failed 0, total 29.

Loading of 'SASACONT1' import package: ERROR

Import Monitor jobs: running 2, waiting 7, completed 19, failed 1, total 29.

Loading of 'DSVASREPODOCS' import package: ERROR

Import Monitor jobs: running 1, waiting 7, completed 19, failed 2, total 29.

Import Monitor jobs: running 2, waiting 6, completed 19, failed 2, total 29.

Import Monitor jobs: running 3, waiting 5, completed 19, failed 2, total 29.

Loading of 'SACONT01' import package: ERROR

Import Monitor jobs: running 2, waiting 5, completed 19, failed 3, total 29.

Loading of 'SAPAPPL0' import package: ERROR

Import Monitor jobs: running 1, waiting 5, completed 19, failed 4, total 29.

Import Monitor jobs: running 2, waiting 4, completed 19, failed 4, total 29.

Import Monitor jobs: running 3, waiting 3, completed 19, failed 4, total 29.

Loading of 'SMIMCONT1' import package: ERROR

Import Monitor jobs: running 2, waiting 3, completed 19, failed 5, total 29.

Loading of 'SAPAPPL1' import package: ERROR

Import Monitor jobs: running 1, waiting 3, completed 19, failed 6, total 29.

Import Monitor jobs: running 2, waiting 2, completed 19, failed 6, total 29.

Import Monitor jobs: running 3, waiting 1, completed 19, failed 6, total 29.

Loading of 'SAPSSRC' import package: ERROR

Import Monitor jobs: running 2, waiting 1, completed 19, failed 7, total 29.

Loading of 'SAPAPPL2' import package: ERROR

Import Monitor jobs: running 1, waiting 1, completed 19, failed 8, total 29.

Loading of 'SAPSSEXC' import package: ERROR

Import Monitor jobs: running 0, waiting 1, completed 19, failed 9, total 29.

-

---

<p>

<br>

import_monitor.log

-

---

ERROR: 2011-09-22 08:25:39 com.sap.inst.migmon.LoadTask run

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

Process '/usr/sap/SAM/SYS/exe/run/R3load -i SAPAPPL2.cmd -dbcodepage 4102 -l SAPAPPL2.log -stop_on_error' exited with return code 2.

For mode details see 'SAPAPPL2.log' file.

Standard error output:

sapparam: sapargv(argc, argv) has not been called!

sapparam(9): environment variable $SAPSYSTEM format error.

sapparam(1c): No Profile used.

sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

ERROR: 2011-09-22 08:37:13 com.sap.inst.migmon.LoadTask run

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

Process '/usr/sap/SAM/SYS/exe/run/R3load -i SAPSSEXC.cmd -dbcodepage 4102 -l SAPSSEXC.log -stop_on_error' exited with return code 2.

For mode details see 'SAPSSEXC.log' file.

Standard error output:

sapparam: sapargv(argc, argv) has not been called!

sapparam(9): environment variable $SAPSYSTEM format error.

sapparam(1c): No Profile used.

sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

WARNING: 2011-09-22 08:37:40

Cannot start import of packages with views because not all import packages with tables are loaded successfully.

-

---

<p>

<br>

SAPSSEXC.log

-

---

DbSl Trace: ORA-1403 when accessing table SAPUSER

(DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF8

(DB) INFO: REPOSRC deleted/truncated #20110922082148

(RFF) ERROR: invalid checksum in data file "/archive/software/solman71/51039398_2/DATA_UNITS/EXP3/DATA/SAPSSEXC.001"

current table was "REPOSRC"

(DB) INFO: disconnected from DB

/usr/sap/SAM/SYS/exe/run/R3load: job finished with 1 error(s)

/usr/sap/SAM/SYS/exe/run/R3load: END OF LOG: 20110922083713

-

---

<p>

<br>

Not sure if the "invalid checksum" error is misleading. Seems I cannot connect to my DB. output of R3trans -d and trans.log is below.

<p>

<br>

R3trans -d

-

---

This is R3trans version 6.19 (release 720 - 27.07.10 - 13:40:00).

unicode enabled version

2EETW169 no connect possible: "environment variable dbms_type is not set."

R3trans finished (0012).

-

---

<p>

<br>

trans.log

-

---

This is R3trans version 6.19 (release 720 - 27.07.10 - 13:40:00).

unicode enabled version

2EETW169 no connect possible: "environment variable dbms_type is not set."

R3trans finished (0012).

samadm@:/home/samadm> cat trans.log

4 ETW000 R3trans version 6.19 (release 720 - 27.07.10 - 13:40:00).

4 ETW000 unicode enabled version

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time : 22.09.2011 - 09:03:29

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -d

4 ETW000 trace at level 2 opened for a given file pointer

4 ETW000 [dev trc ,00000] Thu Sep 22 09:03:29 2011 85 0.000085

4 ETW000 [dev trc ,00000] db_con_init called 23 0.000108

4 ETW000 [dev trc ,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3

4 ETW000 52 0.000160

4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 31 0.000191

4 ETW000 [dbcon.c ,00000] *** ERROR => Invalid profile parameter dbms/type (or environment variable dbms_type) = <undef>, cann

ot load DB library

4 ETW000 63 0.000254

2EETW169 no connect possible: "environment variable dbms_type is not set."

-

---

<p>

<br>

Am I simply missing an environment variable? If so, how do I set "dbms_type"? Shouldn't this have been done in the previous steps when I installed Oracle 11g?

<p>

Any help would be GREATLY appreciated. Thanks everyone!

[Former Member]

That worked. Turns out there was an error in the profiles for IBM JAVA that was causing my .profile to not work. This caused errors in my installation.

[Former Member]

Hello Ben,

Environment variable should be set for the users sidadm and orasid.

First try to check the SHELL assigned to sidadm and orasid, by command - echo $SHELL

Most probably it should be cshell, if yes then command to set the env variable is 'setenv'. Set it like this -

'setenv dbms_type ORA' (for oracle)

Thanks

[Former Member]

That fixed one of the errors, but unfortunately I'm still receiving the following

<p>

<br>

-

---

sapparam(9): environment variable $SAPSYSTEM format error.

sapparam(1c): No Profile used.

sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

-

---

<p>

<br>

R3trans -d

-

---

This is R3trans version 6.19 (release 720 - 27.07.10 - 13:40:00).

unicode enabled version

2EETW169 no connect possible: "DBMS = ORACLE --- TWO_TASK = ''"

R3trans finished (0012).

-

---

<p>

<br>

trans.log

-

---

4 ETW000 [dbsloci. ,00000] *** ERROR => Cannot connect: dbs/ora/tnsname in profile missing. 82 0.004375

4 ETW000 [dev trc ,00000] DbSlConnect(con=-1) -> orc=0, 18=DBSL_ERR_CONNECT 40 0.004415

2EETW169 no connect possible: "DBMS = ORACLE --- TWO_TASK = ''"

-

---

I have checked both my TNS names files and they are setup correctly. Not sure if I am missing another environment param?

[Former Member]

Hello,

Try to verify this parameter as well. Set it's value as 'SID' in sap profile and in environment variables

Thanks