cancel
Showing results for 
Search instead for 
Did you mean: 

" TP buffer prepared OK "/"XPRA_EXECUTION"

Former Member
0 Kudos

Dear Experts,

I am applying OCS Patch SAPKU50010 BBPCRM, including CRT SAPKITL424 - ST , I am struck in phase " TP buffer prepared OK " , it is taking too long time to execute ..

Whiel terminating the Process , it is throwing the error " XPRA_EXECUTION" in Solution Manager

I have applied it before in test scenario , it went successfull.

while monitoring the work process, I found a background SAPMS38L is executing for long hours with table D010INC.I am trying to Kill the Work process , but it is getting started automatically.

Please find the detailed screen shot attached herewith...

My golive activity is sceduled by the end of the week , please help ASAP....

Rahul Bibekar

Accepted Solutions (0)

Answers (5)

Answers (5)

Diggeshhjoshi
Contributor
0 Kudos

We had same issue and we resolved as follows:

- update statistics for table D010INC.

- restart SAP System.

- Restarted import and went pretty quick.

Thanks,

Digesh Joshi

Former Member
0 Kudos

I can also add that I had the same issue and used Digesh's suggestion to solve our issue. I updated stats for D010INC plus rebuilt the 2 associated Indexes D010INC0 & D010INC1. Then restarted the SAP system and kicked off SPAM again.

Ours was a new installation and the Standard jobs (including the Optimizer Stats job) had not been setup. This contributed to our issue.

Always schedule the standard jobs !!

Jim Boyden.

anindya_bose
Active Contributor
0 Kudos

Hi Rahuk

Could you please check table TRBAT and TRJOB?

What are the files present in :\usr\sap\trans\log?

Thanks and Regards

Anindya

Edited by: Anindya Bose on Jun 24, 2009 7:50 PM

Former Member
0 Kudos

Rahul,

Below link tell to update tp.exe( latest) & try. Check it for more details

can you try this

Thanks

Sushil

Former Member
0 Kudos

Rahul,

ERROR: RFC function TRINT_PROGRESS_INDICATOR returned 18

Can you check the SLOG file? Which error it is mentioning.

Below link tell to update tp.exe( latest) & try. Check it for more details

Hope it helps

Thanks

Sushil

Former Member
0 Kudos

Dear Susil,

Please find SLOG Error.

START tp_getprots SMN R 20090622113727 DDIC rasmn

START tp_getprots SMN R 20090622125749 DDIC rasmn

ERROR: RFC function TRINT_PROGRESS_INDICATOR returned 18

ERROR: RFC function TRINT_PROGRESS_INDICATOR returned 18

START tp_getprots SMN R 20090622174531 DDIC rasmn

ERROR SAPKU50010 SMN R 0012 20090622174547 SAPUSER DDIC rasmn

STOP tp_getprots SMN R 20090622174553 DDIC rasmn

START EXECUTION OF REPORTS SMN R 20090622174553 DDIC rasmn

START tp_getprots SMN R 20090622174553 DDIC rasmn

START tp_getprots SMN R 20090623110205 DDIC rasmn

ERROR: RFC function TRINT_PROGRESS_INDICATOR returned 18

ERROR: RFC function TRINT_PROGRESS_INDICATOR returned 18

ERROR: RFC function TRINT_PROGRESS_INDICATOR returned 18

START tp_getprots SMN R 20090623153727 DDIC rasmn

ERROR: RFC function TRINT_PROGRESS_INDICATOR error: SYSTEM_FAILURE

ERROR SAPKU50010 SMN R 0012 20090623155058 SAPUSER DDIC rasmn

STOP tp_getprots SMN R 20090623155100 DDIC rasmn

START EXECUTION OF REPORTS SMN R 20090623155100 DDIC rasmn

ERROR: RFC function TRINT_PROGRESS_INDICATOR returned 18

START tp_getprots SMN R 20090623155101 DDIC rasmn

2EETP000 sap_dext called with msgnr "1":

2EETP000 -


db call info -


2EETP000 function: db_setget

2EETP000 fcode: RT_GET (0)

2EETP000 tabname: TRBAT

2EETP000 len (char): 0

2EETP000 key:

2EETP000 ok fetches: 0

2EETP000 last entry:

2EETP000 retcode: 1

1AETP000 exit in function texitnow

ERROR: EXIT(16) -> process ID is: 3388

2EETP000 sap_dext called with msgnr "1":

2EETP000 -


db call info -


2EETP000 function: db_setget

2EETP000 fcode: RT_GET (0)

2EETP000 tabname: TRBAT

2EETP000 len (char): 0

2EETP000 key:

2EETP000 ok fetches: 0

2EETP000 last entry:

2EETP000 retcode: 1

1AETP000 exit in function texitnow

ERROR: EXIT(16) -> process ID is: 18852

2EETP000 sap_dext called with msgnr "1":

2EETP000 -


db call info -


2EETP000 function: db_setget

2EETP000 fcode: RT_GET (0)

2EETP000 tabname: TRBAT

2EETP000 len (char): 0

2EETP000 key:

2EETP000 ok fetches: 0

2EETP000 last entry:

2EETP000 retcode: 1

1AETP000 exit in function texitnow

ERROR: EXIT(16) -> process ID is: 5624

START tp_getprots SMN R 20090623162001 DDIC rasmn

ERROR SAPKU50010 SMN R 0012 20090623162017 SAPUSER DDIC rasmn

STOP tp_getprots SMN R 20090623162022 DDIC rasmn

START EXECUTION OF REPORTS SMN R 20090623162022 DDIC rasmn

START tp_getprots SMN R 20090623162022 DDIC rasmn

START tp_getprots SMN R 20090623170419 DDIC rasmn

Please help ASAP.........

Cheers

Rahul.

markus_doehr2
Active Contributor
0 Kudos

> 2EETP000 sap_dext called with msgnr "1":

> 2EETP000 -


db call info -


> 2EETP000 function: db_setget

> 2EETP000 fcode: RT_GET (0)

> 2EETP000 tabname: TRBAT

> 2EETP000 len (char): 0

> 2EETP000 key:

> 2EETP000 ok fetches: 0

> 2EETP000 last entry:

> 2EETP000 retcode: 1

> 1AETP000 exit in function texitnow

> ERROR: EXIT(16) -> process ID is: 3388

> 2EETP000 sap_dext called with msgnr "1":

> 2EETP000 -


db call info -


> 2EETP000 function: db_setget

> 2EETP000 fcode: RT_GET (0)

> 2EETP000 tabname: TRBAT

> 2EETP000 len (char): 0

> 2EETP000 key:

> 2EETP000 ok fetches: 0

> 2EETP000 last entry:

> 2EETP000 retcode: 1

> 1AETP000 exit in function texitnow

> ERROR: EXIT(16) -> process ID is: 18852

> 2EETP000 sap_dext called with msgnr "1":

> 2EETP000 -


db call info -


> 2EETP000 function: db_setget

> 2EETP000 fcode: RT_GET (0)

> 2EETP000 tabname: TRBAT

> 2EETP000 len (char): 0

> 2EETP000 key:

> 2EETP000 ok fetches: 0

> 2EETP000 last entry:

> 2EETP000 retcode: 1

> 1AETP000 exit in function texitnow

> ERROR: EXIT(16) -> process ID is: 5624

> START tp_getprots SMN R 20090623162001 DDIC rasmn

> ERROR SAPKU50010 SMN R 0012 20090623162017 SAPUSER DDIC rasmn

> STOP tp_getprots SMN R 20090623162022 DDIC rasmn

> START EXECUTION OF REPORTS SMN R 20090623162022 DDIC rasmn

> START tp_getprots SMN R 20090623162022 DDIC rasmn

> START tp_getprots SMN R 20090623170419 DDIC rasmn

>

> Please help ASAP.........

I say it again: ASAP help should be taken from the official support channels, this here is a forum. Read the rules!

What's your database version, database client and tp/R3trans versions?

Markus

Former Member
0 Kudos

Hi,

Have you checked import log? Did you get any error message. Hope you have applied latest SPAM Patch.

check below link. It explains all phases of a support pack upgrade.

http://help.sap.com/erp2005_ehp_04/helpdata/EN/7e/c6c2aa98a711d2b429006094b9ea64/frameset.htm

Thanks

Sushil

Former Member
0 Kudos

Dear Shusil,

I tried to reset the status , it is trrowing the error Status cannote be reset in phase XPRA_EXECUTION.

Please find the Log for file SAPRU50010 ..

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

1 ETP162 EXECUTION OF REPORTS AFTER PUT

1 ETP101 transport order : "SAPKU50010"

1 ETP102 system : "SMN"

1 ETP108 tp path : "tp"

1 ETP109 version and release : "372.04.40" "700"

1 ETP198

1AETR012XProgram terminated (job: "RDDEXECL", no.: "15094600")

1AEPU320 See job log"RDDEXECL""15094600""SMN"

1 ETP162 EXECUTION OF REPORTS AFTER PUT

1 ETP110 end date and time : "20090622170557"

1 ETP111 exit code : "12"

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

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

1 ETP162 EXECUTION OF REPORTS AFTER PUT

1 ETP101 transport order : "SAPKU50010"

1 ETP102 system : "SMN"

1 ETP108 tp path : "tp"

1 ETP109 version and release : "372.04.40" "700"

1 ETP198

2 EPU126XPost-import methods for change/transport request: "SAPKU50010"

4 EPU111 on the application server: "rasmn"

2 EPU122XPost-import method "O2_XSLT_AFTER_IMPORT" started for "XSLT" "L", date and time: "20090622170600"

3 EPU182 Post-processing for &2"XSLT" &3"CRMT_MB_CONV_DDIC_TO_ERRORXML" was already performed successfully earlier&1"R3TR"

3 EPU182 Post-processing for &2"XSLT" &3"CRMT_MB_CONV_ICAL_TO_DDIC_IN" was already performed successfully earlier&1"R3TR"

3 EPU182 Post-processing for &2"XSLT" &3"CRM_CCKPT_CFS_SERVICE_CRM_IC" was already performed successfully earlier&1"R3TR"

3 EPU123 Post-import method "O2_XSLT_AFTER_IMPORT" completed for "XSLT" "L", date and time: "20090622170600"

2 EPU122XPost-import method "AFTER_IMP_SXCI" started for "SXCI" "L", date and time: "20090622170600"

3 EPU182 Post-processing for &2"SXCI" &3"BUPA_ACE_UPDATE" was already performed successfully earlier&1"R3TR"

3 EPU182 Post-processing for &2"SXCI" &3"CRM_RF_BSP_OPP_TEMP" was already performed successfully earlier&1"R3TR"

3 EPU182 Post-processing for &2"SXCI" &3"PARTNER_ACE_UPDATE" was already performed successfully earlier&1"R3TR"

3 EPU123 Post-import method "AFTER_IMP_SXCI" completed for "SXCI" "L", date and time: "20090622170600"

2 EPU122XPost-import method "AFTER_IMP_SXSD" started for "SXSD" "L", date and time: "20090622170600"

3 EPU182 Post-processing for &2"SXSD" &3"/BON/RECIP_DETERMINE" was already performed successfully earlier&1"R3TR"

3 EPU182 Post-processing for &2"SXSD" &3"CRM_ACC_PL" was already performed successfully earlier&1"R3TR"

3 EPU182 Post-processing for &2"SXSD" &3"CRM_RF_SEARCH_EEW" was already performed successfully earlier&1"R3TR"

3 EPU123 Post-import method "AFTER_IMP_SXSD" completed for "SXSD" "L", date and time: "20090622170600"

2 EPU122XPost-import method "BEFB_AFTER_IMP" started for "BEFT" "T", date and time: "20090622170600"

1AETR012XProgram terminated (job: "RDDEXECL", no.: "17060000")

1AEPU320 See job log"RDDEXECL""17060000""SMN"

1 ETP162 EXECUTION OF REPORTS AFTER PUT

1 ETP110 end date and time : "20090622174547"

1 ETP111 exit code : "12"

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

SLOG:

START tp_getprots SMN R 20090622113727 DDIC rasmn

START tp_getprots SMN R 20090622125749 DDIC rasmn

ERROR: RFC function TRINT_PROGRESS_INDICATOR returned 18

ERROR: RFC function TRINT_PROGRESS_INDICATOR returned 18

START tp_getprots SMN R 20090622174531 DDIC rasmn

ERROR SAPKU50010 SMN R 0012 20090622174547 SAPUSER DDIC rasmn

STOP tp_getprots SMN R 20090622174553 DDIC rasmn

START EXECUTION OF REPORTS SMN R 20090622174553 DDIC rasmn

START tp_getprots SMN R 20090622174553 DDIC rasmn

START tp_getprots SMN R 20090623110205 DDIC rasmn

Please help me ASAP.....

Cheers,

Rahul.

markus_doehr2
Active Contributor
0 Kudos

> 1AETR012XProgram terminated (job: "RDDEXECL", no.: "17060000")

> 1AEPU320 See job log"RDDEXECL""17060000""SMN"

> 1 ETP162 EXECUTION OF REPORTS AFTER PUT

> Please help me ASAP.....

"ASAP" help should be taken using the official support channels.

Check the job log of job RDDEXEXCL in the system (SM37, ST22).

Markus

Former Member
0 Kudos

Dear Markus,

I fallowed your steps and monitored the system error .

In SM37 the job :RDDEXECL DDIC Active 23.06.2009 16:20:22 5.938 0

The above shows every time active. Hope active Jobs cannote be cancelled.

ST22 - the runtime error is System_cancelled

Runtime Errors SYSTEM_CANCELED

Date and Time 22.06.2009 17:05:52

User and Transaction

Client.............. 000

User................ "DDIC"

Language key........ "E"

Transaction......... " "

Transactions ID..... "197A5DDEB306F142B349001A649446EE"

Program............. "SAPMS38L"

Screen.............. "SAPMSSY0 1000"

Screen line......... 6

Information on where terminated

Termination occurred in the ABAP program "SAPMS38L" - in

"FU_DELETE_TFDIRENTRY".

The main program was "RDDEXECU ".

In the source code you have the termination point in line 1715

of the (Include) program "MS38LFFU".

The program "SAPMS38L" was started as a background job.

Job Name....... "RDDEXECL"

Job Initiator.. "DDIC"

Job Number..... 15094600

Source Code Extract

Line SourceCde

1685 dif_param_doc docu_tab dif_funct

1686 to database smodisrci(cv) id l_smodi_src_key.

1687 else.

1688 export dif_import dif_export dif_change dif_tables dif_except

1689 dif_param_doc docu_tab dif_funct

1690 to database smodisrc(cv) id l_smodi_src_key.

1691 endif.

1692 else.

1693 if g_version = c_inactiv.

1694 export g_mod_black_hole

1695 to database smodisrci(cv) id l_smodi_src_key.

1696 else.

1697 export g_mod_black_hole

1698 to database smodisrc(cv) id l_smodi_src_key.

1699 endif.

1700 endif.

1701

It seems like it a very serious issue of data base , my database is Oracle10g..

Kindly guide me on the same , so that it get resolved at the earliest....

With Warm Regards,

Rahul.

markus_doehr2
Active Contributor
0 Kudos

> ST22 - the runtime error is System_cancelled

> Runtime Errors SYSTEM_CANCELED

> Date and Time 22.06.2009 17:05:52

So someone killed the program using SM50/SM66.

I would just restart the import.

Markus