IMPORT PROPER PHASE - TP_STEP_FAILURE - SAPKW70105 - Return Code 16

[Former Member]

Hi All, <br>

We have an SAP SCM 7.0 system will the below mentioned details<br>

OS - HP-UX<br>

Machine type - ia64<br>

Database system - ORACLE<br>

DB client lib.- OCI_102 (10.2.0.4.0<br>

Release - 11.2.0.1.0<br>

Kernel Release - 701<br>

Sup.Pkg lvl. - 111<br><br>

Started a Support pack upgrade from SP03 to SP07 of 701 release<br>

I am done with BASIS, ABA, PI_BASIS, ST-PI(2008_1_700-03), and then when I added SAP_BW from 701(04-07) and now facing any issue in the import proper phase.<br>

Error in phase: IMPORT_PROPER<br>

Reason for error: TP_STEP_FAILURE<br>

Return code: 0016<br>

Error message: OCS Package SAPKW70105, tp step "I", return code 0016<br><br>

When checked the log files<br>

SQL error 3113 accessing RSTT_TDATA: ORA-03113: end-of-file on communication channel

SQL error 3114 accessing RSTT_TDATA: ORA-03114: not connected to ORACLE<br>

SQL error 3114 accessing RSTT_TDATA: ORA-03114: not connected to ORACLE<br>

SQL error 3114 accessing RSTT_TDATA: ORA-03114: not connected to ORACLE<br>

SQL error 3114 accessing RSTT_TDATA: ORA-03114: not connected to ORACLE<br>

SQL error 3114 accessing RSTT_TDATA: ORA-03114: not connected to ORACLE<br>

SQL error 3114 accessing RSTT_TDATA: ORA-03114: not connected to ORACLE<br>

SQL error 3114 accessing RSTT_TDATA: ORA-03114: not connected to ORACLE<br>

SQL error 3114 accessing RSTT_TDATA: ORA-03114: not connected to ORACLE<br>

SQL error 3114 accessing RSTT_TDATA: ORA-03114: not connected to ORACLE<br>

and goes on....<br>

SQL error 3114 accessing RSTT_TDATA: ORA-03114: not connected to ORACLE<br>

SQL error 3114 accessing RSTT_TDATA: ORA-03114: not connected to ORACLE<br>

SQL error 3114 accessing RSTT_TDATA: ORA-03114: not connected to ORACLE<br>

SQL error 3114 accessing RSTT_TDATA: ORA-03114: not connected to ORACLE<br>

===> HALT: maximal number of SQL errors reached. It may be better to stop now. Please contact the SAP support.<br>

Main import<br>

End date and time : 20110812121359<br>

Ended with return code: ===> 16 <===<br>

######################################<br><br>

For your info- when we were doing PI_BASIS components, oraarch arch folder was filled up because of which the import stopped, restarted the sap system and the import went well.<br>

When checked the /usr/sap/trans/log file SAPIW70105.D3J<br>

4 ETW000 [dbtrtab ,03913] ***LOG BY0=>ORA-03114: not connected to ORACLE [dbtrtab#2 @ 3913] 17 11.449694<br>

2EETW125 SQL error "3114" during "RSTT_TDATA" access: "ORA-03114: not connected to ORACLE"<br>

4 ETW000 0 entries for RSTT_TDATA imported (0DFCTEXT0D_FC_COUN).<br>

4 ETW000 [dev trc ,00000] OCIStmtExecute() failed with -1=OCI_ERROR 288 11.449982<br>

4 ETW000 [dev trc ,00000] SQL error 3114: 19 11.450001<br>

4 ETW000 [dbsloci. ,00000] *** ERROR => Error 3114 in stmt_execute() from oci_execute_stmt(), orpc=1<br>

4 ETW000 27 11.450028<br>

4 ETW000 [dbsloci. ,00000] *** ERROR => ORA-3114 occurred when executing SQL stmt (parse error offset=0)<br>

4 ETW000 26 11.450054<br>

4 ETW000 [dev trc ,00000] sc_p=0x60000000010261e0,no=18,idc_p=0x600000000103ed20,con=0,act=1,slen=248,smax=256,#vars=12,stmt=0x6000000001956a50,table=RSTT_TDATA<br>

4 ETW000 28 11.450082<br>

4 ETW000 [dev trc ,00000] UPDATE "RSTT_TDATA" SET "TDATA" = :A0 , "TPARAM" = :A1 , "ROWCNT" = :A2 , "AUTHOR" = :A3 , "MODTIME"\<br>

4 ETW000 25 11.450107<br>

4 ETW000 [dev trc ,00000] = :A4 WHERE "TDCLAS" = :A5 AND "TDATATP" = :A6 AND "OBJNM" = :A7 AND "OBJID" = :A8 AND "OBJREFNM" =\<br>

4 ETW000 25 11.450132<br>

4 ETW000 [dev trc ,00000] :A9 RETURNING "TDATA", "TPARAM" INTO :A10, :A11; 15 11.450147<br>

4 ETW000 [dev trc ,00000] sc_p=0x60000000010261e0,no=18,idc_p=0x600000000103ed20,con=0,act=1,slen=248,smax=256,#vars=12,stmt=0x6000000001956a50,table=RSTT_TDATA

4 ETW000 81 11.450228

4 ETW000 [dev trc ,00000] prep=0,lit=0,nsql=0,lobret=2,#exec=1,dbcnt=1,upsh_p=(nil),ocistmth_p=0x6000000001957258<br>

4 ETW000 26 11.450254<br>

4 ETW000 [dev trc ,00000] IN : cols=10,rmax=1,xcnt=1,rpc=0,rowi=0,rtot=1,upto=4294967295,rsize=225,vmax=32,bound=1,iobuf_p=0x6000000000fe12f0,vda_p=0x6000000001959e80<br>

4 ETW000 29 11.450283<br>

4 ETW000 [dev trc ,00000] lobs=2,lmax=4,lpcnt=0,larr=0x6000000000fe9670,lcurr_p=(nil),rret=0<br>

4 ETW000 24 11.450307<br>

4 ETW000 [dev trc ,00000] OUT: cols=2,rmax=0,xcnt=0,rpc=0,rowi=0,rtot=0,upto=0,rsize=0,vmax=32,bound=0,iobuf_p=(nil),vda_p=0x600000000195a5b0<br>

4 ETW000 28 11.450335<br>

4 ETW000 [dev trc ,00000] lobs=2,lmax=4,lpcnt=0,larr=0x6000000000fe9720,lcurr_p=(nil),rret=0<br>

4 ETW000 24 11.450359<br>

4 ETW000 [dev trc ,00000] UPDATE "RSTT_TDATA" SET "TDATA" = :A0 , "TPARAM" = :A1 , "ROWCNT" = :A2 , "AUTHOR" = :A3 , "MODTIME"\<br>

4 ETW000 25 11.450384<br>

4 ETW000 [dev trc ,00000] = :A4 WHERE "TDCLAS" = :A5 AND "TDATATP" = :A6 AND "OBJNM" = :A7 AND "OBJID" = :A8 AND "OBJREFNM" =\<br>

4 ETW000 33 11.450417<br>

4 ETW000 [dev trc ,00000] :A9 RETURNING "TDATA", "TPARAM" INTO :A10, :A11; 15 11.450432<br>

4 ETW000 [dbtrtab ,03913] ***LOG BY4=>sql error 3114 performing UPD on table RSTT_TDATA [dbtrtab#2 @ 3913]<br>

4 ETW000 29 11.450461<br>

4 ETW000 [dbtrtab ,03913] ***LOG BY0=>ORA-03114: not connected to ORACLE [dbtrtab#2 @ 3913] 17 11.450478<br>

2EETW125 SQL error "3114" during "RSTT_TDATA" access: "ORA-03114: not connected to ORACLE"<br>

1AETW000 ===> HALT: maximal number of SQL errors reached. It may be better to stop now. Please contact the SAP support.<br>

4 ETW000 [dev trc ,00000] OCITransRollback(OCI_DEFAULT) failed with SQL error 3114: 316 11.450794<br>

4 ETW000 [dev trc ,00000] ORA-03114: not connected to ORACLE <br>

4 ETW000 30 11.450824<br>

4 ETW000 [dev trc ,00000] hdl_error_on_commit_rollback: DB-ROLLBACK detected RECONNECT state 72 11.450896<br>

4 ETW000 End of Transport (0016).<br>

4 ETW000 date&time: 12.08.2011 - 12:13:59<br>

4 ETW000 101 errors occured.<br>

1 ETP154 MAIN IMPORT<br>

1 ETP110 end date and time : "20110812121359"<br>

1 ETP111 exit code : "16"<br>

1 ETP199 ######################################<br><br><br><br>

I have restarted the system twice and checked if listener, R3trans -d and tnsping SID works fine.<br><br>

Adding to the above I have implemented notes to apply the SAP_BASIS components.<br>

1354957 Tables with more than 3 long string fields<br>

1366282 Type "SFW_SWITCH_DETERMINE_OBJ" is unknown<br>

1414700 Switch Framework: New BAdIs<br><br>

Kindly advice on this. Not sure what went wrong, and I am not able to find the note of this kind of error.<br><br><br>

Thanks<br><br>

Jaianandh V<br>

[former_member204746 · Accepted solution]

maybe you ran out of "processes" or "sessions" with Oracle...

I would increase both these values as per SAP note 1431798.

[Former Member]

<br>Hi,

<br>Thanks to all for the valuable inputs.

<br>SAP suggested me to do an SBP Upgrade/Oracle Patch upgrade and the issue is now resolved.

<br>

<br>Thanks

<br>

<br>Jaianandh V

[Former Member]

Still no luck. I have raised an OSS message for the same.

[Former Member]

Jaianandh V

Did you get any solution from SAP ?

Cheers !

Manish

[Former Member]

Hi Eric,<br>

Are you asking me to reboot the entire LINUX MACHINE.<br>

<br>

Thanks<br>

<br>

Jaianandh V<br>

[former_member204746]

yes, if this is possible, if not, you can skip reboot... but make sure that no SAP TP, R3trans or Oracle are alive at this step.

[Former Member]

Hi, <br>

FYI- Kernel level was 111, I now updated R3trans to latest 148 Patch level.<br>

Still issue exists, I noticed the below mentioned logs in SM21 <br>

11:12:40 S-A 000 sidadm E0 1 Program rslgsend Started:<br>

11:17:18 S-A 000 sidadm E0 2 Program rslgsend Ended: o.k., SIGINT<br>

11:17:19 S-A 000 sidadm E0 2 Program rslgcoll Ended: o.K.<br>

11:17:20 DIA 006 Q0 2 Stop Workproc 6, PID 13358<br>

11:17:20 UP1 010 Q0 2 Stop Workproc10, PID 13362<br>

11:17:20 DIA 009 Q0 2 Stop Workproc 9, PID 13361<br>

11:17:20 DIA 003 Q0 2 Stop Workproc 3, PID 13355<br>

11:17:20 UP2 016 Q0 2 Stop Workproc16, PID 13368<br>

11:17:20 DIA 002 Q0 2 Stop Workproc 2, PID 13354<br>

11:17:20 DIA 004 Q0 2 Stop Workproc 4, PID 13356<br>

11:17:20 DIA 000 Q0 2 Stop Workproc 0, PID 13352<br>

11:17:20 BTC 014 Q0 2 Stop Workproc14, PID 13366<br>

11:17:20 SPO 015 Q0 2 Stop Workproc15, PID 13367<br>

11:17:20 DIA 001 Q0 2 Stop Workproc 1, PID 13353<br>

11:17:20 BTC 013 Q0 2 Stop Workproc13, PID 13365<br>

11:17:20 DIA 005 Q0 2 Stop Workproc 5, PID 13357<br>

11:17:20 DIA 007 Q0 2 Stop Workproc 7, PID 13359<br>

11:17:20 DIA 008 Q0 2 Stop Workproc 8, PID 13360<br>

11:17:20 BTC 012 Q0 2 Stop Workproc12, PID 13364<br>

11:17:20 ENQ 011 Q0 2 Stop Workproc11, PID 13363<br>

11:17:21 RD S3 0 SAP gateway was closed<br>

11:17:28 DP Q0 M Message server disconnected<br>

11:17:28 DP Q0 5 Stop SAP System, Dispatcher Pid 133<br>

11:17:29 MS Q0 2 Stop Msg Server, PID 13342<br>

11:21:22 S-A 000 sidadm E1 5 Buffer SCSA Already Exists. (Length= 4096)<br>

11:21:22 MS Q0 1 Start Msg Server, 1 times since system startup. PID 17840<br>

11:21:22 S-A 000 sidadm E0 1 Program rslgcoll Started:<br>

11:21:23 DP Q0 0 Start SAP System, SAPSYSTEM 80, Dispatcher Pid 17841<br>

<br>

Any inputs on this will be highly helpful.<br>

<br>

Thanks<br>

<br>

Jaianandh V<br>

[former_member204746]

stop SAP

stop Oracle

reboot

start Oracle

start SAP

...pray

[Former Member]

Hi Eric,<br>

I doubled the values of processes and sessions using the below command. But no luck.<br>

alter system set processes=160 scope=spfile;<br>

alter system set sessions=320 scope=spfile;<br>

Correct me if I have used the incorrect commands, or if you were talking about somthing else.<br><br>

FYI - Adding to my first post. I also had an issue with ST-PI component, this was because the oraarch filesystem was filled up and so there was an error <br>stop, to fix this I cleared the filesystem except the recent two files and restarted the sap system, when executed SPAM it was asking me to confirm <br>queue and the error got cleared.<br>

<br>

Kindly advice.<br>

<br>

Thanks<br>

<br>

Jaianandh V<br>