Transports fail after Oracle upgrade to 10.2.0.2

[Former Member]

Hi All,

After oracle upgrade all transports fail. Even though the transport logs does not show any error, the transport monitor shows tp error 8.

I am using 9.2.0.7 client with oracle 10g as suggested by SAP. The system is R/3 4.7X2.

Can someone help me figure this out.

Thanks

S.

[Former Member · Accepted solution]

Nope, the logs says it is there. But the object is not there and tp command itself end with RC8.

This is tp version 340.16.24 (release 640)

Warning: Parameter DBHOST is no longer used.

Warning: Parameter DBLIBPATH is no longer used.

Warning: Parameter DBNAME is no longer used.

Warning: Parameter DBSWPATH is no longer used.

This is R3trans version 6.13 (release 640 - 25.07.06 - 17:34:00).

R3trans finished (0000).

This is R3trans version 6.13 (release 640 - 25.07.06 - 17:34:00).

R3trans finished (0000).

Warning: Parameter DBHOST is no longer used.

Warning: Parameter DBLIBPATH is no longer used.

Warning: Parameter DBNAME is no longer used.

Warning: Parameter DBSWPATH is no longer used.

Warning: Parameter DBHOST is no longer used.

Warning: Parameter DBLIBPATH is no longer used.

Warning: Parameter DBNAME is no longer used.

Warning: Parameter DBSWPATH is no longer used.

tp finished with return code: 8

meaning:

A tool used by tp produced errors

And the logs do not show anything wrong.

Thanks

S.

[markus_doehr2 · Accepted solution]

Hmm.. the only I idea I have now is

Note 1017418 - Installing Oracle 9208 Client software on UNIX

Use Oracle 9.2.0.8 client.

If that does not help, I´d open an OSS call and let SAP have a look on the system.

What I wonder most is, that I no logfile is produced...

--

Markus

[Former Member · Accepted solution]

Markus,

9.2.0.8 client did not help either. I also tried using the latest R3trans and tp versions.

Thanks for your replies.

Thanks

S.

[markus_doehr2 · Accepted solution]

If your /usr/sap/trans/log resides on an NFS mounted drive, this may also be a reason for failing (lockd on the server not running, permission problems for the directory, . I doubt that it has something to do with the database upgrade whatsoever...

If you have a chance, you can try to

tp -t9 tf=<tracefilename> <import command....>

To get a tracefile, what tp is doing and why it has problems.

--

Markus

[Former Member · Accepted solution]

Markus,

I do not understand the syntax of the command. Can you give an example please.

Thanks

S.

[markus_doehr2 · Accepted solution]

> Markus,

> I do not understand the syntax of the command. Can

> you give an example please.

something like that:

tp -t9 -tf=tp_dev import DV1K900999 QA1 pf=/usr/sap/trans/bin/tpparam_instQA1

"-t9" adds a tracelevel 9

"-tf=tp_dev" gives the trace file

--

Markus

[Former Member · Accepted solution]

Markus,

When I run the tp -t9 .... command it says the transport is not in the buffer and it has been already imported. So I add the transport again to the buffer and run the command to get the trace and still it says not in the buffer.

Also I assumed "tp_dev" would be created in the present directory. It was not instead another file "dev_trc_0000025895" was created which is empty.

Following is what I did:

_____________________________________________________________

qa1adm@<host>:/usr/sap/trans/bin>tp -t9 -tf=tp_dev import DV1K906776 QA1 pf=TP_DOMAIN_DV1.PFL

This is tp version 340.16.33 (release 640)

Warning: Parameter DBHOST is no longer used.

Warning: Parameter DBLIBPATH is no longer used.

Warning: Parameter DBNAME is no longer used.

Warning: Parameter DBSWPATH is no longer used.

Opened trace to "dev_trc_0000025811" on level 0.

The import of the transport request DV1K906776 for system QA1 was not performed.

Please check the tp command. The buffer entry is printed out below.

QA1 buffer:

DV1K906776 | | |has already been imported completely.

TASK |PROJECT |P|CMD I |DD Im |Activ |MainI |MC Ac |ADO I |VersF |XPRA |Gener |UMODE|TAGS

-

---

----

---

-----------+--+--+--+--+--+--+--+-+--

No valid entry found for DV1K906776 in QA1 buffer.

tp returncode summary:

TOOLS: Highest return code of single steps was: 8

SWARNS: Highest tp internal severe warning was: 0152

tp finished with return code: 152

meaning:

Nothing done.

______________________________________________________________________________________

qa1adm@<host>:/usr/sap/trans/bin>tp addtobuffer DV1K906776 QA1

This is tp version 340.16.33 (release 640)

Warning: Parameter DBHOST is no longer used.

Warning: Parameter DBLIBPATH is no longer used.

Warning: Parameter DBNAME is no longer used.

Warning: Parameter DBSWPATH is no longer used.

Addtobuffer successful for DV1K906776

tp finished with return code: 0

meaning:

Everything OK

_________________________________________________________________________________________________

qa1adm@<host>:/usr/sap/trans/bin>tp -t9 -tf=tp_dev import DV1K906776 QA1 pf=TP_DOMAIN_DV1.PFL

This is tp version 340.16.33 (release 640)

Warning: Parameter DBHOST is no longer used.

Warning: Parameter DBLIBPATH is no longer used.

Warning: Parameter DBNAME is no longer used.

Warning: Parameter DBSWPATH is no longer used.

Opened trace to "dev_trc_0000025895" on level 0.

The import of the transport request DV1K906776 for system QA1 was not performed.

Please check the tp command. The buffer entry is printed out below.

QA1 buffer:

DV1K906776 | | |has already been imported completely.

TASK |PROJECT |P|CMD I |DD Im |Activ |MainI |MC Ac |ADO I |VersF |XPRA |Gener |UMODE|TAGS

-

---

----

---

-----------+--+--+--+--+--+--+--+-+--

No valid entry found for DV1K906776 in QA1 buffer.

tp returncode summary:

TOOLS: Highest return code of single steps was: 8

SWARNS: Highest tp internal severe warning was: 0152

tp finished with return code: 152

meaning:

Nothing done.

___________________________________________________________

Can you make sense out of it.

Thanks

S.

[markus_doehr2 · Accepted solution]

Really strange...

This particular transport - has it been imported to QA1 before (not to DV1(015))? The system clearly states that...

Can you try with tracelevel 3 instead of 9?

--

Markus

[Former Member · Accepted solution]

Trace level 3 gives teh same result. Earlier you had mentioned about /usr/sap/trans being NFS mounted. It is NFS mounted from another server. Do you think that matters and if so how do I check it?

Thanks

S.

____________________________________________________________________

qa1adm@<host>:/usr/sap/trans/bin>tp -t3 -tf=tp_dev import DV1K906776 QA1 pf=TP_DOMAIN_DV1.PFL

This is tp version 340.16.33 (release 640)

Warning: Parameter DBHOST is no longer used.

Warning: Parameter DBLIBPATH is no longer used.

Warning: Parameter DBNAME is no longer used.

Warning: Parameter DBSWPATH is no longer used.

Opened trace to "dev_trc_0000026160" on level 0.

The import of the transport request DV1K906776 for system QA1 was not performed.

Please check the tp command. The buffer entry is printed out below.

QA1 buffer:

DV1K906776 | | |has already been imported completely.

TASK |PROJECT |P|CMD I |DD Im |Activ |MainI |MC Ac |ADO I |VersF |XPRA |Gener |UMODE|TAGS

-

---

----

---

-----------+--+--+--+--+--+--+--+-+--

No valid entry found for DV1K906776 in QA1 buffer.

tp returncode summary:

TOOLS: Highest return code of single steps was: 8

SWARNS: Highest tp internal severe warning was: 0152

tp finished with return code: 152

meaning:

Nothing done.

[markus_doehr2 · Accepted solution]

R3trans says, that this transport is already in QA1. If that was true, it should be possible to import it using unconditional mode 26:

tp import Note 1017418 DV1K906766 QA1 pf=TP_DOMAIN_DV1.PFL u26

This will re-import it again.

NFS: You can check if on the NFS server lockd is running (depending on your operating system).

--

Markus

[Former Member · Accepted solution]

Markus,

It does seem like "nfsd" and "mountd" are not running:

root 1378 1 0 Jul 13 ? 0:00 /usr/lib/nfs/lockd

daemon 1377 1 0 Jul 13 ? 0:00 /usr/lib/nfs/statd

Only these two are running.

On another system in the landscape all four are running.

I am not sure if I should restart the nfs ( Our OS guys are pretty territorial). I have asked someone else to take a look at it.

I very much appreciate your time and patience. Will let you know if this issue gets resolved.

Thanks

S.

[markus_doehr2 · Accepted solution]

Markus,

It does seem like "nfsd" and "mountd" are not

running:

> root        1378     1  0   Jul 13 ?         0:00 /usr/lib/nfs/lockd
> daemon  1377     1  0   Jul 13 ?        0:00  /usr/lib/nfs/statd

Only these two are running.

n another system in the landscape all four are

running.

I am not sure if I should restart the nfs ( Our OS

guys are pretty territorial). I have asked someone

else to take a look at it.

Maybe that´s the reason - a stale NFS handle - possibly...

I very much appreciate your time and patience. Will

let you know if this issue gets resolved.

you´re welcome

--

Markus

[Former Member · Accepted solution]

Markus,

It was not a NFS problem.

The dba user 'SAPR3' was missing the SAPCONN role. Once this role was assigned the transport went through fine.

Actually, we could have figured it out on friday itself had I executed tp -t command properly (my bad). When I executed tp -t1 today, trace showed error ORA-01031 : insufficent privileges.

I might not have run the sapconn_role.sql script in the 10.2.0.2 environment during the oracle upgrade.

Anyway, the one transport went through fine, I am waiting for more transports to go through.

Thanks for all your help

S.

[Former Member · Accepted solution]

THNX

[markus_doehr2 · Accepted solution]

You're welcome

--

Markus

[Former Member]

Yes, exactly. The log is for a transport going from DV1 010 to QA1 030.

Thanks

S.

[markus_doehr2]

So - you transported something, that is already in QA.. that's what the log tells me... isn't that true?

--

Markus

[Former Member]

Markus,

I have tried command line as well as TMS

This is how my landscape looks: DV1 is the domain controller

DV1(010 - ABAP Dev client)

DV1 (015 - Test Client) -> QA ->PRD

tp connect gives the following:

>tp connect QA1 pf=TP_DOMAIN_DV1.PFL

This is tp version 340.16.24 (release 640)

Warning: Parameter DBHOST is no longer used.

Warning: Parameter DBLIBPATH is no longer used.

Warning: Parameter DBNAME is no longer used.

Warning: Parameter DBSWPATH is no longer used.

Connection to Database of QA1 was successful.

This is R3trans version 6.13 (release 640 - 25.07.06 - 17:34:00).

R3trans finished (0000).

tp finished with return code: 0

meaning:

Everything OK

Thanks

S.

[markus_doehr2]

Ok - now I understood.

The problem (I would see) in your configuration is, that ABAP is "cross client" - means, if someone in DV1(010) creates an ABAP program and you're trying to import that into DV1(015), it is "already there", this is true for all workbench objects.

A setup as you have it is not supported (I had a BIG discussion on OSS), means, if you transport from DV1(010) to DV1(015) a workbench transport, it won't work since it's the same physical system.

So - the log you provided is from a transport going from DV1(010) or DV1(015) to QA?

--

Markus

[Former Member]

Markus,

This problem occurs in our QA system. Transports created in the DEV systems developement client are already moved to the DEV test client and then the QA system.

Since they were already moved to one system(DEV test) in the transport landscape it says that the transport has already imported.

Correct me if I am wrong.

Thanks

S.

[markus_doehr2]

Do you use TMS or do you try to import the from commandline?

It's a bit confusing what you write (DEV system, DEV client, QA system...).

A TRANSPORT between a system landscape occurs between SYSTEMS not between CLIENTS.

Does your transport route look like

DEV System (e. g. client 001)

--> Transport to DEV Client (002)

--> QA System

--> PR System?

What happens if you give a

tp connect <TARGET-SID> (the system with Oracle 10g just upgraded)?

--

Markus

[markus_doehr2]

Can you connect via "R3trans -d" to the database?

The transport monitor evaluates the returncodes of the transport, of the logs, if it shows a returncode 8, there's certainly a log with returncode 8.

--

Markus

[former_member204746]

please provide transport log

also supply trans.log after executing r3trans -d

[Former Member]

Thanks for your replies,

I am able to start sap. R3trans -d return (0000)

here is the trans.log and transport log:

ETW000

4 ETW000 ================== STEP 1 =====================

4 ETW000 date&time : 20.07.2007 - 15:05:06

4 ETW000 function : CONNECT

4 ETW000 buffersync : YES

4 ETW000 clients : default

4 ETW000 l.s.m. : VECTOR

4 ETW000 commit : 100000

4 ETW000 table cache : dynamic

4 ETW000

4 ETW000 [dev trc ,00000] Disconnecting from ALL connections: 13005 0.013005

4 ETW000 [dev trc ,00000] Disconnecting from connection 0 ... 76 0.013081

4 ETW000 [dev trc ,00000] Close user session (con_hdl=0,svchp=101262a98,usrhp=10126e990)

4 ETW000 1178 0.014259

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=101262a98,srvhp=101264f38)

4 ETW000 1856 0.016115

4 ETW000 [dev trc ,00000] Now I'm disconnected from ORACLE 1285 0.017400

4 ETW000 [dev trc ,00000] Disconnected from connection 0 36 0.017436

4 ETW000 [dev trc ,00000] statistics db_con_commit (com_total=1, com_tx=1)

4 ETW000 34 0.017470

4 ETW000 [dev trc ,00000] statistics db_con_rollback (roll_total=0, roll_tx=0)

4 ETW000 31 0.017501

4 ETW000 Disconnected from database.

4 ETW000 End of Transport (0000).

4 ETW000 date&time: 20.07.2007 - 15:05:06

_______________________________________________________________

XXXI906776.XXX :

ETW000 Summary:

4 ETW000

4 ETW000 128 bytes modified in database.

4 ETW000 [dev trc ,00000] Disconnecting from ALL connections: 77538 0.077538

4 ETW000 [dev trc ,00000] Disconnecting from connection 0 ... 92 0.077630

4 ETW000 [dev trc ,00000] Close user session (con_hdl=0,svchp=101267568,usrhp=101273460)

4 ETW000 1718 0.079348

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=101267568,srvhp=101269a08)

4 ETW000 2352 0.081700

4 ETW000 [dev trc ,00000] Now I'm disconnected from ORACLE 1400 0.083100

4 ETW000 [dev trc ,00000] Disconnected from connection 0 35 0.083135

4 ETW000 [dev trc ,00000] statistics db_con_commit (com_total=2, com_tx=2)

4 ETW000 36 0.083171

4 ETW000 [dev trc ,00000] statistics db_con_rollback (roll_total=0, roll_tx=0)

4 ETW000 32 0.083203

4 ETW000 Disconnected from database.

4 ETW000 End of Transport (0000).

4 ETW000 date&time: 20.07.2007 - 14:44:38

1 ETP154 MAIN IMPORT

1 ETP110 end date and time : "20070720144439"

1 ETP111 exit code : "0"

1 ETP199 ######################################

Thanks

S.

[markus_doehr2]

This does not show any connect - just the disconnect...

What version of R3trans are you using?

--

Markus

[Former Member]

Here is the R3trans version:

>R3trans -d

This is R3trans version 6.13 (release 640 - 25.07.06 - 17:34:00).

R3trans finished (0000).

I had replied with the last 40 lines of the <SID>i906776.<SID> log.

Thanks

S.

[markus_doehr2]

The version looks good.

But do you see an initial connect? Without providing the FULL log, one can't rather help you, what we see is a disconnect - you will see that also if R3trans -d is not able to connect (for whatever reason).

--

Markus

[Former Member]

Here is the full log:

1356 1 ETP154 MAIN IMPORT

1357 1 ETP101 transport order : "<SID>K906776"

1358 1 ETP102 system : "<SID>"

1359 1 ETP108 tp path : "tp"

1360 1 ETP109 version and release : "340.16.24" "640"

1361 1 ETP198

1362 4 ETW000 R3trans version 6.13 (release 640 - 25.07.06 - 17:34:00).

1363 4 ETW000 ===============================================

1364 4 ETW000

1365 4 ETW000 date&time : 20.07.2007 - 15:48:52

1366 4 ETW000 control file: /usr/sap/trans/tmp/<SID>KK906776.<SID>

1367 4 ETW000 > #pid 20686 on <host> (<SID>adm)

1368 4 ETW000 > import

1369 4 ETW000 > buffersync=yes

1370 4 ETW000 > file='/usr/sap/trans/data/R906776.<SID>'

1371 4 ETW000 > continuation='/usr/sap/trans/data/R906776_#.<SID>'

1372 4 ETW000 > client=300

1373 4 ETW000 >

1374 4 ETW000 > excluding 'R3TRDDDD','R3TRDOMA','R3TRDTEL','R3TRENQU','R3TRMACO','R3TRMCID','R3TRMCOB','R3TRSHLP','R3TRSQLT','R3TRTABL','R3TRTTYP','R3TRUE

NO','R3TRVIEW'

1375 4 ETW000 R3trans was called as follows: R3trans -u 268 -w /usr/sap/trans/tmp/<SID>I906776.<SID> /usr/sap/trans/tmp/<SID>KK906776.<SID>

1376 4 ETW000 active unconditional modes: 268

1377 4 ETW000 Connected to DBMS = ORACLE --- dbs_ora_tnsname = '<SID>' --- SYSTEM = '<SID>'.

1378 4 ETW690 "0" "0"

1379 4 ETW000 COMMIT (0).

1380 4 ETW000 trace at level 1 opened for a given file pointer

1381 4 ETW000

1382 4 ETW000 ================== STEP 1 =====================

1383 4 ETW000 date&time : 20.07.2007 - 15:48:52

1384 4 ETW000 function : IMPORT

1385 4 ETW000 data file : /usr/sap/trans/data/R906776.<SID>

1386 4 ETW000 Continuation: /usr/sap/trans/data/R906776_#.<SID>

1387 4 ETW000 buffersync : YES

1388 4 ETW000 client : 300

1389 4 ETW000 repeatimport: NO

1390 4 ETW000 repeatclimp.: NO

1391 4 ETW000 c.s.i. : NO

1392 4 ETW000 l.s.m. : VECTOR

4 ETW000 charsetadapt: YES

1394 4 ETW000 def. charset: WEUROPEAN

1395 4 ETW000 commit : 100000

1396 4 ETW000 table cache : dynamic

1397 4 ETW000 EXCLUDING : 'R3TRVIEW','R3TRUENO','R3TRTTYP','R3TRTABL','R3TRSQLT','R3TRSHLP','R3TRMCOB','R3TRMCID','R3TRMACO','R3TRENQU','R3TRDTEL','R3TR

DOMA','R3TRDDDD'

1398 4 ETW000

1399 4 ETW000 Data file is compressed with algorithm 'L'.

1400 4 ETW000 Export was executed on 18.07.2007 at 12:18:15 by <SID>adm

1401 3 ETW709 "620 "

1402 4 ETW000 with R3trans version: 25.07.06 - 17:34:00

1403 4 ETW000 Source System = Solaris on SPARCV9 CPU on DBMS = ORACLE --- dbs_ora_tnsname = '<SID>' --- SYSTEM = '<SID>'.

1404 4 ETW000

1405 4 ETW000 language vector during export: ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789abcdefghijklmnopqrstuvwxyz(),./:;&

1406 4 ETW000 lsm during export: VECTOR

1407 4 ETW000 trfunction = K (transport to consolidation system)

1408 4 ETW000 Used Commandfile <SID>K906776 (MNAYAK/2)

1409 4 ETW000 This commandfile was already imported completely. Skipping ...

1410 4 ETW000 <SID>K906776 touched.

1411 4 ETW690 "128" "128"

1412 4 ETW000 COMMIT (2022).

1413 4 ETW000 2022 bytes read.

1414 4 ETW000 Transport overhead 100.0 %.

1415 4 ETW000 Duration: 0 sec (2022 bytes/sec).

1416 3 ETW710 "0" "0"

1417 4 ETW000

1418 4 ETW000 Summary:

1419 4 ETW000

1420 4 ETW000 128 bytes modified in database.

1421 4 ETW000 [dev trc ,00000] Disconnecting from ALL connections: 19142 0.019142

1422 4 ETW000 [dev trc ,00000] Disconnecting from connection 0 ... 69 0.019211

1423 4 ETW000 [dev trc ,00000] Close user session (con_hdl=0,svchp=101265548,usrhp=101271440)

1424 4 ETW000 820 0.020031

1425 4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=101265548,srvhp=1012679e8)

1426 4 ETW000 1448 0.021479

1427 4 ETW000 [dev trc ,00000] Now I'm disconnected from ORACLE 1084 0.022563

1428 4 ETW000 [dev trc ,00000] Disconnected from connection 0 33 0.022596

1429 4 ETW000 [dev trc ,00000] statistics db_con_commit (com_total=2, com_tx=2)

1430 4 ETW000 33 0.022629

1431 4 ETW000 [dev trc ,00000] statistics db_con_rollback (roll_total=0, roll_tx=0)

4 ETW000 30 0.022659

1433 4 ETW000 Disconnected from database.

1434 4 ETW000 End of Transport (0000).

1435 4 ETW000 date&time: 20.07.2007 - 15:48:52

1436 1 ETP154 MAIN IMPORT

1437 1 ETP110 end date and time : "20070720154852"

1438 1 ETP111 exit code : "0"

1439 1 ETP199 ######################################

Thanks

Shabna

[markus_doehr2]

> 1408 4 ETW000 Used Commandfile <SID>K906776

> (MNAYAK/2)

> TW000 This commandfile was already imported

> completely. Skipping ...

You see here RC=0 because the transport is already in the system.

Can you create a (dummy) transport, something, that is imported for the first time, import it and post the full log again?

--

Markus