EHP3 IMPORT_PROPER PHASE

[Former Member]

Dear experts,

i lately installed a new ECC 6 on ORACLE 10.2 G and WINDOWS server 2003 64bit , in a new implementation ALL-IN-ONE and when i started to import the EHP3 and EHP3 SP01 , and when it came to this step

*Installation of Add-on LSOFE Rel.603 : Import of the queue* it took around 24 hours and still waiting . i dont know if it stuck or something. the phase is IMPORT_PROPER

and the backgroud job over view:

OCS_QUEUE_IMPORT DDIC Active 10.01.2010 17:37:22 69.099 0

the SAPMMC abap wp table says

BTC stop and (reason) RFC

in the proccess overview

23 BGD 10084 On Hold RFC Yes 69512 SAPLSTPA 000 DDIC

could you help me to know the reason or should i cancel the job

the second issue is a syntax error in SU01 when saveing a new user the error details

/ISDFPS/SAPLCIF_ALEPOINTER

Syntax error in program

Error in the ABAP Application Program

The current ABAP program "/ISDFPS/CL_IM_HRBAS00INFTY====CP" had

terminated because it has

come across a statement that unfortunately cannot be executed.

The following syntax error occurred in program "/ISDFPS/SAPLCIF_

include "/ISDFPS/CL_FORCE==============CU " in

line 307:

"Type "/ISDFPS/FORCE_HR_EXT_TAB" is unknown"

" "

" "

" "

The include has been created and last changed by:

Created by: "SAP "

Last changed by: "SAP "

Error in the ABAP Application Program

The current ABAP program "/ISDFPS/CL_IM_HRBAS00INFTY====CP" had

terminated because it has

come across a statement that unfortunately cannot be executed.

please help me ASAP

[sunny_pahuja2 · Accepted solution]

Hi,

could you please check logs in /usr/sap/trans/tmp and /usr/sap/trans/log ?

also paste here if contains errors.

Thanks

Sunny

[Former Member · Accepted solution]

i cant find any errors in the log files for the specified component

1 ETP199X######################################

1 ETP155 ACTIVATION OF DD-OBJECTS

1 ETP101 transport order : "SAPK-603DIINLSOFE"

1 ETP102 system : "DEV"

1 ETP108 tp path : "tp"

1 ETP109 version and release : "372.04.08"; "700"

1 ETP198

3 EPU324 See log for request "
devlopment\sapmnt\trans\tmp\SAPA-603DDINSAPAPPL." (timestamp "17:04:42", system "DEV")

1 ETP155 ACTIVATION OF DD-OBJECTS

1 ETP110 end date and time : "20100105195411"

1 ETP111 exit code : "8"

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

1 ETP199X######################################

1 ETP155 ACTIVATION OF DD-OBJECTS

1 ETP101 transport order : "SAPK-603DIINLSOFE"

1 ETP102 system : "DEV"

1 ETP108 tp path : "tp"

1 ETP109 version and release : "372.04.08"; "700"

1 ETP198

3 EPU324 See log for request "
devlopment\sapmnt\trans\tmp\SAPA-603DDINSAPAPPL." (timestamp "10:57:25", system "DEV")

1 ETP155 ACTIVATION OF DD-OBJECTS

1 ETP110 end date and time : "20100110105833"

1 ETP111 exit code : "4"

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

but in the same time i cant see any progress and the exact process time is 86.000 sec

should i wait longer or should i abort

and about the second issue of the syntax error , any recommendation

thanks for replying anyway

[Former Member]

*Dear expert*
  *i tried the installation and the EHP3 import from scratch and i faced the same error in IMPORT_PROPER phase*

*\SAPI-603DRINSAPAPPL.DEV*
 *SAP_APPL 603 Upgrade: Other objects (MAIN)*
 *Import                                   15.01.2010 00:59:08   (12) Canceled*
*and the log file says the following*

4 ETW000  [dev trc     ,00000]  Fri Jan 15 00:59:08 2010                         2816103  4.961061
4 ETW000  [dev trc     ,00000]  OCI-call failed with -1=OCI_ERROR                     25  4.961086
4 ETW000  [dev trc     ,00000]     SQL error 3106: 'ORA-03106: fatal two-task communication protocol error'
4 ETW000                                                                              19  4.961105
4 ETW000  [dbsloci.    ,00000]  *** ERROR => Error 3106 in stmt_fetch() from oci_execute_stmt(), orpc=1
4 ETW000                                                                            5175  4.966280
4 ETW000  [dbsloci.    ,00000]  *** ERROR => ORA-3106 occurred when executing SQL stmt (parse error offset=0)
4 ETW000                                                                              33  4.966313
4 ETW000  [dev trc     ,00000]  sc_p=000000000031B128,no=81,idc_p=00000000060B1CB0,con=0,act=1,slen=110,smax=256,#vars=2,stmt=00000000067A95E0,table=AQGDB                         
4 ETW000                                                                              34  4.966347
4 ETW000  [dev trc     ,00000]  SELECT * FROM "AQGDB" WHERE "RELID" = :A0 AND "SRTFD" LIKE :A1 ESCAPE '#' ORDER BY "RELID" , "SRTFD"\
4 ETW000                                                                              20  4.966367
4 ETW000  [dev trc     ,00000]   , "SRTF2";                                            9  4.966376
4 ETW000  [dev trc     ,00000]  sc_p=000000000031B128,no=81,idc_p=00000000060B1CB0,con=0,act=1,slen=110,smax=256,#vars=2,stmt=00000000067A95E0,table=AQGDB                         
4 ETW000                                                                              51  4.966427
4 ETW000  [dev trc     ,00000]  prep=0,lit=0,nsql=0,lobret=0,#exec=72,dbcnt=0,upsh_p=0000000000000000,ocistmth_p=00000000067D2888
4 ETW000                                                                             123  4.966550
4 ETW000  [dev trc     ,00000]  IN : cols=2,rmax=1,xcnt=0,rpc=0,rowi=0,rtot=0,upto=-1,rsize=38,vmax=32,bound=1,iobuf_p=000000000022E4F0,vda_p=00000000067D91D0
4 ETW000                                                                              24  4.966574
4 ETW000  [dev trc     ,00000]       lobs=0,lmax=0,lpcnt=0,larr=0000000000000000,lcurr_p=0000000000000000,rret=0
4 ETW000                                                                              23  4.966597
4 ETW000  [dev trc     ,00000]  OUT: cols=5,rmax=21,xcnt=21,rpc=1,rowi=0,rtot=1,upto=-1,rsize=3020,vmax=32,bound=1,iobuf_p=000000000022E540,vda_p=00000000067D9920
4 ETW000                                                                              37  4.966634
4 ETW000  [dev trc     ,00000]       lobs=0,lmax=0,lpcnt=0,larr=0000000000000000,lcurr_p=0000000000000000,rret=0
4 ETW000                                                                              31  4.966665
4 ETW000  [dev trc     ,00000]  SELECT * FROM "AQGDB" WHERE "RELID" = :A0 AND "SRTFD" LIKE :A1 ESCAPE '#' ORDER BY "RELID" , "SRTFD"\
4 ETW000                                                                              31  4.966696
4 ETW000  [dev trc     ,00000]   , "SRTF2";                                           15  4.966711
4 ETW000  [dbtrtab     ,03908]  ***LOG BY4=>sql error 3106   performing SEL on table AQGDB      [dbtrtab#6 @ 3908]
4 ETW000                                                                            4680  4.971391
4 ETW000  [dbtrtab     ,03908]  ***LOG BY0=>ORA-03106: fatal two-task communication protocol error [dbtrtab#6 @ 3908]
4 ETW000                                                                              37  4.971428
2EETW000 sap_dext called with msgnr "1": 
2EETW000 ---- db call info ----
2EETW000 function:   db_setget
2EETW000 fcode:      RT_GET (0)
2EETW000 tabname:    AQGDB                         
2EETW000 len (char): 30
2EETW000 key:        AQQU/SAPQUERY/AUAD            
2EETW000 ok fetches: 0
2EETW000 last entry: 
2EETW000 retcode:    1
2EETW125 SQL error "3106" during "" access: "ORA-03106: fatal two-task communication protocol error"
1 ETP154 MAIN IMPORT
1 ETP110 end date and time   : "20100115005908"
1 ETP111 exit code           : "12"
1 ETP199 ######################################

please help me to slove this issue

Edited by: Sameh Essa on Jan 15, 2010 10:07 PM

Edited by: Sameh Essa on Jan 15, 2010 10:09 PM

Edited by: Sameh Essa on Jan 15, 2010 10:10 PM

[peter_dzurov]

Hi,

do you have Oracle 10.2.0.2 with Patch Collection 10?

Please check Note 1005758 - ORA 3106 in Oracle 10.2.0.2.

What is your Oracle release?

[Former Member]

oracle 10.2.0.1.0

i passed the error by starting the phase again in dialog it came with warning and im still waiting for the rest of the IMPORT.

thanks anyway , if you can advice anything it would be good.

[peter_dzurov]

Well,

you are using unsupported version of Oracle. I would apply latest patchset as well as patches and then try again.

[Former Member]

i installed an ORACLE patch 10.2.0.4.0 patchset 3 but when im done i found that the dispatcher dosent startup .

any advice of what i can do.

[peter_dzurov]

You can at least review dev_disp in work directory and post it here.