TP error SHADOW_IMPORT_UPG2

[Former Member]

Hi All,

We are in process of doing BW Upgrade from 3.5 to 7.0 during SHADOW_IMPORT_UPG2 we are getting the TP error

SApup.log

*************

UPGRADEPHASE SHADOW_IMPORT_UPG2

...started at 20071105123457

1. Reading Parameter File "/usr/sap/put/bin/SHDUPGIMP2.TPP" at 20071105123457

...begin processing at 20071105123457

...tp-pid 20880

..finished at 20071105123518 with status UNRESOLVED REQUESTS IN BUFFER.

...begin dialogue at 20071105123518

running /usr/sap/put/exe/tp pf=/usr/sap/put/bin/SHDUPGIMP2.TPP put BWD

WARNING: tp terminated with status 12

SAPK700WD4.ELG

***************************

4 ETW000 R3trans was called as follows: /usr/sap/put/exe/R3trans -u 26 -w /usr/sap/put/tmp/SAPK700WD4.BWD /usr/sap/put/tmp/SAPKK700WD4.BWD

4 ETW000 active unconditional modes: 26

2EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY ('/usr/sap/put/exe') or dbms_type ('ORA')"

1 ETP187 R3TRANS SHADOW IMPORT

1 ETP110 end date and time : "20071105123518"

1 ETP111 exit code : "12"

no connect possible: "maybe someone set invalid values for DIR_LIBRARY ('/usr/sap/put/exe') or dbms_type ('ORA')

*****************************************

When we try the tp connect BWD pf =usr/sap/put/bin/TP_DOMAIN_BWD.PFL

RROR: No connect due to DbSl Load Lib Failure

ERROR: The values set for DIR_LIBRARY ('/usr/sap/BWD/SYS/exe/run') or dbms_type ('ORA') are invalid.

ERROR: Connect to BWD failed (20071105131827).

TRACE-INFO: 1: [dev trc ,00000] Mon Nov 5 13:18:27 2007 418960 0.418960

TRACE-INFO: 2: [dev trc ,00000] load shared library (/usr/sap/BWD/SYS/exe/run/dboraslib.so), hdl 0

TRACE-INFO: 3: 177 0.419137

tp returncode summary:

TOOLS: Highest return code of single steps was: 0

ERRORS: Highest tp internal error was: 0249

tp finished with return code: 249

meaning:

connect failed due to DbSL load lib failure

We are on Oracle 10.2 with client 9.2, and we found that Client 10.2 is needed.

We have already installed 10.2 and dboraslib10g.so is already there it's not picking the 10g client environment.

Please suggest how to set 10g client environment.

Thanks,

Subahsh.G

[Former Member]

An pop-up that gets displayed from the SAPup containing an exception message, may be of some help:

==============================

LIST OF ERRORS AND RETURN CODES

==============================

SHADOW IMPORT ERRORS and RETURN CODE in SAPK700WD4.BWD

2EETW169 no connect possible: "maybe someone set invalid values for the DIR_LIBRARY ('/usr/sap/put/exe') or dbms_type ('ORA')"

1 ETP111 exit code: "12"

Any ideas?

[markus_doehr2]

Take out the instantclient path out of LD_LIBRARY_PATH (as suggest by me and the note).

--

Markus

[markus_doehr2]

dboraslib.so is not the client but the database interface from ABAP to the database.

You need to install the Oracle instantclient:

819829 - Oracle Database 10g: Instant Client 10.x on Unix

I wonder how you were able to do the prepare without that client.

--

Markuks

[Former Member]

before we started the upgrade we installed 10.2 oracle client.

[markus_doehr2]

Did you read the note I just posted?

What´s the output of

ldd dboraslib.so (the file in /usr/sap/put/exe)?

If you changed the environment of adm AFTER you started the upgrade assistant, you need to stop it and start it again with the new environment.

--

Markus

[Former Member]

Hi Markus,

Thanks for the reply the below is the o/p of the command when we run at /usr/sap/put/exe.

libdl.so.1 => /lib/64/libdl.so.1

libnsl.so.1 => /lib/64/libnsl.so.1

libsocket.so.1 => /lib/64/libsocket.so.1

libclntsh.so.10.1 => /oracle/client/10x_64/instantclient/libclntsh.so.10.1

libnnz10.so => /oracle/client/10x_64/instantclient/libnnz10.so

libc.so.1 => /lib/64/libc.so.1

libmp.so.2 => /lib/64/libmp.so.2

libmd.so.1 => /lib/64/libmd.so.1

libscf.so.1 => /lib/64/libscf.so.1

libkstat.so.1 => /lib/64/libkstat.so.1

libgen.so.1 => /lib/64/libgen.so.1

libsched.so.1 => /usr/lib/64/libsched.so.1

libaio.so.1 => /lib/64/libaio.so.1

librt.so.1 => /lib/64/librt.so.1

libm.so.1 => /lib/64/libm.so.1

libdoor.so.1 => /lib/64/libdoor.so.1

libuutil.so.1 => /lib/64/libuutil.so.1

libm.so.2 => /lib/64/libm.so.2

/platform/SUNW,Sun-Fire-V440/lib/sparcv9/libc_psr.so.1

/platform/SUNW,Sun-Fire-V440/lib/sparcv9/libmd_psr.so.1

**********************************

These are the env variable list:

**********************************

HOME=/home/bwdadm

PATH=/oracle/BWD/102_64/bin:/opt/j2sdk1.4.2_08/bin:/home/bwdadm:/usr/sap/BWD/SYS/exe/run:/etc:/usr/bin:.:/opt/EMCpower/bin/64:/etc/emc/bin:/usr/ccs/bin:/usr/ucb

LOGNAME=bwdadm

HZ=

TERM=vt100

SHELL=/bin/csh

MAIL=/var/mail/bwdadm

TZ=US/Pacific

PWD=/home/bwdadm

USER=bwdadm

SAPSYSTEMNAME=BWD

DIR_LIBRARY=/usr/sap/BWD/SYS/exe/run

LD_LIBRARY_PATH=/usr/sap/BWD/SYS/exe/run:/oracle/client/10x_64/instantclient

JAVA_HOME=/opt/j2sdk1.4.2_08

THREAD=NOPS

dbms_type=ORA

dbs_ora_tnsname=BWD

dbs_ora_schema=SAPBWP

ORACLE_SID=BWD

DB_SID=BWD

ORACLE_BASE=/oracle

ORA_NLS33=/oracle/client/92x_64/ocommon/nls/admin/data

TNS_ADMIN=/usr/sap/BWD/SYS/profile/oracle

ORACLE_HOME=/oracle/BWD/102_64

NLS_LANG=AMERICAN_AMERICA.WE8DEC

SAPDATA_HOME=/oracle/BWD

Plz suggest if we need to set any env varaible ....

Thanks,

Subhash

[markus_doehr2]

According to note 830758:

- unset ORA_NLS33

- take out the instantclient of LD_LIBRARY_PATH

- stop SAPup

- stop UaServer

- create a new session and check the parameters

- restart UaServer

- repeat the phase

--

Markus

[Former Member]

Hi Markus,

Note 830758 is not available, is this the same note which you are suggesting?

Thanks.

Subheads.

[markus_doehr2]

Sorry- typo - the note is

830578 - Oracle database 10g: Unix environment variable

--

Markus

[Former Member]

Tried as per revised note, changed the value , restarted the database, restarted the SAPup tool making the same changes, but did not work. below is the env setting for ref.

bash #: env

HOME=/home/bwdadm

PATH=/oracle/BWD/102_64/bin:/opt/j2sdk1.4.2_08/bin:/home/bwdadm:/usr/sap/BWD/SYS/exe/run:/etc:/usr/bin:.:/opt/EMCpower/bin/64:/etc/emc/bin:/usr/ccs/bin:/usr/ucb

LOGNAME=bwdadm

HZ=

TERM=vt100

SHELL=/bin/csh

MAIL=/var/mail/bwdadm

TZ=US/Pacific

PWD=/usr/sap/put/log

USER=bwdadm

SAPSYSTEMNAME=BWD

DIR_LIBRARY=/usr/sap/BWD/SYS/exe/run

LD_LIBRARY_PATH=/usr/sap/BWD/SYS/exe/run:/oracle/client/10x_64/instantclient

JAVA_HOME=/opt/j2sdk1.4.2_08

THREAD=NOPS

dbms_type=ORA

dbs_ora_tnsname=BWD

dbs_ora_schema=SAPBWP

ORACLE_SID=BWD

DB_SID=BWD

ORACLE_BASE=/oracle

ORA_NLS33=

TNS_ADMIN=/usr/sap/BWD/SYS/profile/oracle

ORACLE_HOME=/oracle/BWD/102_64

NLS_LANG=AMERICAN_AMERICA.WE8DEC

SAPDATA_HOME=/oracle/BWD

Appreciate your continued help

[markus_doehr2]

...and additionally - delete ORA_NLS33 - it is still set (though pointing to NULL).

--

Markus

[Former Member]

No luck , Markhus,

below is our settings

HOME=/home/bwdadm

PATH=/oracle/BWD/102_64/bin:/opt/j2sdk1.4.2_08/bin:/home/bwdadm:/usr/sap/BWD/SYS/exe/run:/etc:/usr/bin:.:/opt/EMCpower/bin/64:/etc/emc/bin:/usr/ccs/bin:/usr/ucb

LOGNAME=bwdadm

HZ=

TERM=vt100

SHELL=/bin/csh

MAIL=/var/mail/bwdadm

TZ=US/Pacific

PWD=/home/bwdadm

USER=bwdadm

SAPSYSTEMNAME=BWD

DIR_LIBRARY=/usr/sap/BWD/SYS/exe/run

LD_LIBRARY_PATH=/usr/sap/BWD/SYS/exe/run

JAVA_HOME=/opt/j2sdk1.4.2_08

THREAD=NOPS

dbms_type=ORA

dbs_ora_tnsname=BWD

dbs_ora_schema=SAPBWP

ORACLE_SID=BWD

DB_SID=BWD

ORACLE_BASE=/oracle

TNS_ADMIN=/usr/sap/BWD/SYS/profile/oracle

ORACLE_HOME=/oracle/BWD/102_64

NLS_LANG=AMERICAN_AMERICA.WE8DEC

SAPDATA_HOME=/oracle/BWD

we have one question

Where does the upgrade phase pickup the environment variable.

sapenvt [ this looks like a binary file]

Thanks

Subhash

[markus_doehr2]

Did you stop SAPup, UaServer and started it in another console with the correct settings? sapevt is a process inherited by SAPup - inherited by UaServer and thus it will inherit those settings.

--

Markus

[Former Member]

Yes Markus,

we have followed the suggestion and restated the UA server still no use..

we had found the below error in Sapup.log

UPGRADEPHASE SHADOW_IMPORT_UPG2

...started at 20071106080733

1. Reading Parameter File "/usr/sap/put/bin/SHDUPGIMP2.TPP" at 20071106080733

...begin processing at 20071106080733

...tp-pid 3808

..finished at 20071106080737 with status UNRESOLVED REQUESTS IN BUFFER.

...begin dialogue at 2007110608073

Please suggest...

Thanks,

Subhash

[Former Member]

Hi Markus,

We found that both the shadow and source system are not up only the DB is up at this stage, can we restart the shadow system and check the stms now.

Like unlock the shadow system and strating only the shadow.

Please suggest....

Thanks,

Subhash

[markus_doehr2]

Which error message do you get? I don't see any error in the provided file...

--

Markus

[Former Member]

Hi markus,

we found this message in SApup.log. with status UNRESOLVED REQUESTS IN BUFFER</b>...

UPGRADEPHASE SHADOW_IMPORT_UPG2

...started at 20071106104211

1. Reading Parameter File "/usr/sap/put/bin/SHDUPGIMP2.TPP" at 20071106104211

...begin processing at 20071106104211

...tp-pid 26831

..finished at 20071106104212 <b><b>with status <b>UNRESOLVED REQUESTS IN BUFFER</b>.</b></b>...begin dialogue at 20071106104212

Message was edited by:

subhash gadde

[markus_doehr2]

This does just mean, that some transports are still to be imported.

Check your logs:

cd /usr/sap/put/log
ls -lt | more

Check the newest ones.

--

Markus

[Former Member]

Hi Markus,

we checked the log files and found below info:

<b>Slog files</b>

1. Phase SHADOW_IMPORT_UPG2:

START SHADOW IMPORT BWD K 20071105084651 bwdadm jazzsap4 20071105084651003f3f

ERROR SAPK700WD4 BWD K 0012 20071105090154 SAPUSER bwdadm jazzsap4 20071105084651003f3f

STOP SHADOW IMPORT BWD K 20071105090154 bwdadm jazzsap4 20071105084651003f3f

ERROR: stopping on error 12 during SHADOW IMPORT

1. Phase SHADOW_IMPORT_UPG2:

START SHADOW IMPORT BWD K 20071105103841 bwdadm jazzsap4 2007110510383600082c

ERROR SAPK700WD4 BWD K 0012 20071105103842 SAPUSER bwdadm jazzsap4 2007110510383600082c

STOP SHADOW IMPORT BWD K 20071105103842 bwdadm jazzsap4 2007110510383600082c

ERROR: stopping on error 12 during SHADOW IMPORT

<b>Ulog file</b>

BUF

1. Phase SHADOW_IMPORT_UPG2:

bwdadm 20071105084651 : /usr/sap/put/exe/tp pf=/usr/sap/put/bin/SHDUPGIMP2.TPP put BWD

bwdadm 20071105090204 : /usr/sap/put/exe/tp extrdocu BWD pf=/usr/sap/put/bin/DEFAULT.TPP if=/usr/sap/put/tmp/MSGIN.LST of=/usr/sap/put/tmp/MSGOUT.LST

1. Phase SHADOW_IMPORT_UPG2:

bwdadm 20071105103837 : /usr/sap/put/exe/tp pf=/usr/sap/put/bin/SHDUPGIMP2.TPP put BWD

bwdadm 20071105103844 : /usr/sap/put/exe/tp extrdocu BWD pf=/usr/sap/put/bin/DEFAULT.TPP if=/usr/sap/put/tmp/MSGIN.LST of=/usr/sap/put/tmp/MSGOUT.LST

[Former Member]

Hi Markus,

We found this error in trans.log file.

4 ETW000 R3trans was called as follows: R3trans -x

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

4 ETW000 [dev trc ,00000] Tue Nov 6 06:10:26 2007 32436 0.032436

4 ETW000 [dev trc ,00000] db_con_init called 80 0.032516

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

4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/BWD/SYS/exe/run/dboraslib.so' ...

4 ETW000 466 0.034253

4 ETW000 [dev trc ,00000] Tue Nov 6 06:10:30 2007 3832801 3.867054

4 ETW000 [dev trc ,00000] load shared library (/usr/sap/BWD/SYS/exe/run/dboraslib.so), hdl 0

4 ETW000 129 3.867183

4 ETW000 [dev trc ,00000] Library '/usr/sap/BWD/SYS/exe/run/dboraslib.so' loaded

4 ETW000 9123 3.876306

4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library /usr/sap/BWD/SYS/exe/run/dboraslib.so

4 ETW000 100 3.876406

4 ETW000 [dev trc ,00000] Tue Nov 6 06:10:31 2007 1375589 5.251995

4 ETW000 [dev trc ,00000] Version of '/usr/sap/BWD/SYS/exe/run/dboraslib.so' is "640.00", patchlevel (0.175)

4 ETW000 161 5.252156

4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library /usr/sap/BWD/SYS/exe/run/dboraslib.so

4 ETW000 94 5.252250

4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library /usr/sap/BWD/SYS/exe/run/dboraslib.so

4 ETW000 1194 5.253444

4 ETW000 [dev trc ,00000] New connection 0 created 636 5.254080

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 88 5.254168

4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 7213 5.261381

4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:

4 ETW000 72 5.261453

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 58 5.261511

4 ETW000 [dev trc ,00000] Got ORACLE_HOME=/oracle/BWD/102_64 from environment

4 ETW000 2430 5.263941

4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0) 89107 5.353048

4 ETW000 [dev trc ,00000] got NLS_LANG='AMERICAN_AMERICA.WE8DEC' from environment

4 ETW000 85 5.353133

4 ETW000 [dev trc ,00000] Tue Nov 6 06:10:32 2007 1172387 6.525520

4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.US7ASCII 93 6.525613

4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPBWP's password 65399 6.591012

4 ETW000 [dev trc ,00000] Connecting as /@BWD on connection 0 (nls_hdl 0) ... (dbsl 640 250407)

4 ETW000 119 6.591131

4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

4 ETW000 71 6.591202

4 ETW000 [dev trc ,00000] 0 US7ASCII 1 101282600 101289e40 1012897d8

4 ETW000 56 6.591258

4 ETW000 [dev trc ,00000] Allocating service context handle for con_hdl=0 16034 6.607292

4 ETW000 [dev trc ,00000] Allocating server context handle 76 6.607368

4 ETW000 [dev trc ,00000] Attaching to DB Server BWD (con_hdl=0,svchp=101289708,srvhp=10128a508)

4 ETW000 500 6.607868

4 ETW000 [dev trc ,00000] Tue Nov 6 06:10:34 2007 1988154 8.596022

4 ETW000 [dev trc ,00000] Assigning server context 10128a508 to service context 101289708

4 ETW000 143 8.596165

4 ETW000 [dev trc ,00000] Allocating user session handle 95 8.596260

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=101289708,srvhp=10128a508,usrhp=101294758)

4 ETW000 83 8.596343

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 12705

4 ETW000 10851 8.607194

4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=10128a508)

4 ETW000 64 8.607258

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=101289708,srvhp=10128a508)

4 ETW000 52 8.607310

4 ETW000 [dev trc ,00000] Deallocating server context handle 10128a508 806 8.608116

4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '12705'

4 ETW000 142 8.608258

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 12705 515 8.608773

4 ETW000 [dev trc ,00000] Try to connect with default password 89 8.608862

4 ETW000 [dev trc ,00000] Connecting as SAPBWP/<pwd>@BWD on connection 0 (nls_hdl 0) ... (dbsl 640 250407)

4 ETW000 77 8.608939

4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

4 ETW000 55 8.608994

4 ETW000 [dev trc ,00000] 0 US7ASCII 1 101282600 101289e40 1012897d8

4 ETW000 53 8.609047

4 ETW000 [dev trc ,00000] Allocating server context handle 33 8.609080

4 ETW000 [dev trc ,00000] Attaching to DB Server BWD (con_hdl=0,svchp=101289708,srvhp=10128a508)

4 ETW000 84 8.609164

4 ETW000 [dev trc ,00000] Tue Nov 6 06:10:35 2007 181237 8.790401

4 ETW000 [dev trc ,00000] Assigning server context 10128a508 to service context 101289708

4 ETW000 116 8.790517

4 ETW000 [dev trc ,00000] Assigning username to user session 101294758 43 8.790560

4 ETW000 [dev trc ,00000] Assigning password to user session 101294758 47 8.790607

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=101289708,srvhp=10128a508,usrhp=101294758)

4 ETW000 111 8.790718

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 12705

4 ETW000 35230 8.825948

4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=10128a508)

4 ETW000 64 8.826012

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=101289708,srvhp=10128a508)

4 ETW000 55 8.826067

4 ETW000 [dev trc ,00000] Deallocating server context handle 10128a508 446 8.826513

4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '12705'

4 ETW000 92 8.826605

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 12705 33 8.826638

4 ETW000 [dblink ,00428] ***LOG BY2=>sql error 12705 performing CON [dblink#3 @ 428]

4 ETW000 20704 8.847342

4 ETW000 [dblink ,00428] ***LOG BY0=>ORA-12705: Cannot access NLS data files or invalid environment specified [dblink#3 @ 428]

4 ETW000 65 8.847407

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

[markus_doehr2]

You are calling the "old" R3trans of your old release in the new environment thus the error.

What do you see in

SHDUPGIMP2.ELG

--

Markus

[Former Member]

**************************************************

• LIST OF ERRORS AND RETURN CODES *******

**************************************************

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

SHADOW IMPORT ERRORS and RETURN CODE in SAPK700WD4.BWD

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

2EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY ('/usr/sap/put/exe') or dbms_type ('ORA')"

1 ETP111 exit code : "12

[Former Member]

problem is solved....

Markus thanks for the tip you have given .

We have exported the R3trans as per notes 1064257 for DD04l problem, during that we have mistakenly copied my latest kernal SYS/exe/run /R3trans to put/exe that means copying 640 R3trans to 700 kernal put/exe.