Skip to Content

Datsource took more time in delta load

Hi

Datasoure 0REFX_4 usually brings in records (around 45000) in few seconds but took a lot of time (21 minutes) today for 38000 records. Looking at the job log i can see it took more time between Asynchronos transmission and call customer enhancement.

i have checked the below and found no issues.

SMQ1 for any stuck entries - None showing.

Any other jobs which ran at the same time, if they were affected - None affected.

Job Server busy - Not Busy.

Please can someone let me know what else can i look at to find the issue. Also what is this customer enhancement BW_BTE. Did the extractor take 20 mins in the call of the customer enhancement or it took 20 mins in the asynchronous transmission.

Thanks

Capture.PNG (26.0 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Oct 28, 2015 at 01:56 PM

    Hi Tom,

    Its took 20 minutes during asynchronous transmission process.

    Actually when you checkedĀ  SM58?

    During your load time or after the completion of load?

    Before this load, have you done/applied changes on this data source?

    What is load burden on ECC system during your load time?

    Lets try to check more information about Idoc 3.

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Raman

      No changes have been applied to the datasource. Also the other idocs didnot take much time.

      The server wasnt busy at all.
      I have looked at previous days and it didnt take a lot time. One change i can see is that earlier it was running on another app server but yesterday ran on another.

      Thanks

  • Oct 28, 2015 at 02:00 PM

    Hi Tom

    It might be that the TRFC would have been in recorded mode during that time. It will be good to check SM58 for any recorded TRFCs when the data load is running.

    Even we had such instances where the system performance was slow at times and the TRFCs will not be automatically pushed for a while.

    If this runtime issue has not happened earlier and if you have not any enhancement, please wait for the next load to happen. It might be a temporary issue.

    When the load is in process, check SM58 for recorded TRFCs

    Regards

    Karthik

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 28, 2015 at 02:26 PM

    Hi,

    what comes to my mind is that you can do a performance check using transaction SAT.

    you can set a listener on a spefiic programm / fuba etc. if this gets called, it will record the performance. you may can check this to find a performance problem related to the underlaying sap programm.

    As Karthik Vasudevan already mentioned, check if other jobs are running parallelly. Because if the sm58 queue is big, it will need some time until the sap-programm starts to extract data.


    regards

    Stefan Seeburger

    Add comment
    10|10000 characters needed characters exceeded

    • Hi,

      in transaction RSA2, you see the details of the extractor. e.g. what programm or Fuba is called.

      with big i meant alot of parallel tasks running at the same time when you did the extraction.

      regards

      Stefan Seeburger

  • Oct 29, 2015 at 01:36 AM

    HI,

    can you check it out SM58 and TRFC's issues.

    for the 0REFX_6 have fisical year as mandatory slections .

    if you give proper selections it will full the data.

    use the selecitons company code, contract, fisical year data.

    for us also smae time took for extract data.

    Thanks,

    Phani,

    Add comment
    10|10000 characters needed characters exceeded