import support package SAPKB70015 at PI System is stuck on IMPORT_PROPER

[Former Member]

Dear Expert,

I have some problem when import support package SAPKB70015 at PI System.

IT had shown as below.

######################################

Main import

Transport request : SAPKB70015

System : CXI

tp path : tp

Version and release: 372.04.08 700

sap_dext called with msgnr 4:

db call info

function: db_report_interface

fcode: UPDATE_REPORT

tabname: TEXT

len (char): 40

key: /OSP/CL_CJS_CONTEXT===========CP

retcode: 4

Main import

End date and time : 20081120021353

Ended with return code: ===> 12 <===

######################################

And I checked the transport log,It shown as below.

##########################################################################

4 ETW690 COMMIT "360444" "53156878"

3 ETW674Xstart import of "LIMUCLSD/OSP/CL_CJS_CONTEXT" ...

4 ETW000 1 entry for TADIR updated (R3TRCLAS/OSP/CL_CJS_CONTEXT ).

4 ETW000 REPOS /OSP/CL_CJS_CONTEXT===========CP A replaced.

4 ETW000 dev trc ,00000 Thu Nov 20 02:13:53 2008 39924798 39.924798

4 ETW000 http://dbsloci. ,00000 *** ERROR => Cannot update a LOB column for more than one row piecewise

4 ETW000 85 39.924883

4 ETW000 dev trc ,00000 sc_p=0x110f57d68,no=55,idc_p=0x110f70638,con=0,act=1,slen=125,smax=256,#vars=5,stmt=0x111e1f700,tabl

e=REPOTEXT

4 ETW000 66 39.924949

4 ETW000 dev trc ,00000 prep=0,lit=0,nsql=0,lobret=1,#exec=1,dbcnt=2,upsh_p=(nil),ocistmth_p=0x111e20098

4 ETW000 53 39.925002

4 ETW000 dev trc ,00000 IN : cols=4,rmax=1,xcnt=1,rpc=0,rowi=0,rtot=1,upto=4294967295,rsize=84,vmax=32,bound=1,iobuf_p=0x111

0a4220,vda_p=0x111e21a60

4 ETW000 58 39.925060

4 ETW000 dev trc ,00000 lobs=1,lmax=4,lpcnt=0,larr=0x111e22180,lcurr_p=(nil),rret=0

4 ETW000 48 39.925108

4 ETW000 dev trc ,00000 OUT: cols=1,rmax=0,xcnt=0,rpc=0,rowi=0,rtot=0,upto=0,rsize=0,vmax=32,bound=0,iobuf_p=(nil),vda_p=0x1

11e222c0

4 ETW000 55 39.925163

4 ETW000 dev trc ,00000 lobs=1,lmax=4,lpcnt=0,larr=0x111e22220,lcurr_p=(nil),rret=2

4 ETW000 47 39.925210

4 ETW000 dev trc ,00000 UPDATE "REPOTEXT" SET "DATA" = :A0 WHERE "PROGNAME" = :A1 AND "R3STATE" = :A2 AND "LANGUAGE" = :A3

\

4 ETW000 51 39.925261

4 ETW000 dev trc ,00000 RETURNING "DATA" INTO :A4; 29 39.925290

4 ETW000 dbrepolo ,00735 ***LOG BZY=>unexpected return code 2 calling dbrepolo#? @ 735

4 ETW000 75 39.925365

2EETW000 sap_dext called with msgnr "4":

2EETW000 -

---

db call info -

---

2EETW000 function: db_report_interface

2EETW000 fcode: UPDATE_REPORT

2EETW000 tabname: TEXT

2EETW000 len (char): 40

2EETW000 key: /OSP/CL_CJS_CONTEXT===========CP

2EETW000 retcode: 4

1 ETP154 MAIN IMPORT

1 ETP110 end date and time : "20081120021353"

1 ETP111 exit code : "12"

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

System information

SAP = NW2004s SR3

Database = Oracle 10.2.0.2

OS versions = AIX 5.3

Tp version = 700 Unicode 179

R3trans version = 700 Unicode 183

PS.I checked tp connect return code 0 and R3trans u2013s return code 0

Could you please suggest how to fix this problem?

Thank you very much

Jaturong

[Former Member]

Hi,

I suggest you to update database statistics and then try to reimport the package.

I also face the same error & after running the DB statistics it is resolved.

Hope this help.

Regards,

Rajesh

[Former Member]

Hi all,

Iu2019ve updated database statistics and then try to reimport the package again. But It canu2019t import package.

And update tp and R3trans to new version.

Could you please suggest any solution to me.

Thank you so much

[Former Member]

Iu2019ve updated database statistics and then try to reimport the package again. But It canu2019t import package.

Are you still getting the same error after you retry the statistics update?

[Former Member]

try to retry again or else upgrade your TP and R3trans version and then again retry.

cheers,

-Sunil