Skip to Content
author's profile photo Former Member
Former Member

Extraction Issue

HI all

I have full load which is part of process chain and runs on daily basis.It updates around 300 records only.

However it takes more than 3 hours to complete.

I have check the job log in source system

Date Time Message text Message class Message no. Message type

17.03.2009 18:58:09 Job started 00 516 S

17.03.2009 18:58:09 Step 001 started (program SBIE0001, variant &0000000010365, user ID ALEREMOTE) 17.03.2009 18:58:09 Asynchronous transmission of info IDoc 2 in task 0001 (0 parallel tasks) 17.03.2009 18:58:09 DATASOURCE = 0BP_UNAME_ORGUNIT_ATTR 17.03.2009 18:58:09 ************************************************************************* 17.03.2009 18:58:09 * Current Values for Selected Profile Parameters 17.03.2009 18:58:09 ************************************************************************* 17.03.2009 18:58:09 * abap/heap_area_nondia......... 2000683008 * 17.03.2009 18:58:09 * abap/heap_area_total.......... 4000000000 * 17.03.2009 18:58:09 * abap/heaplimit................ 40894464 * 17.03.2009 18:58:09 * zcsa/installed_languages...... ED * 17.03.2009 18:58:09 * zcsa/system_language.......... E * 17.03.2009 18:58:09 * ztta/max_memreq_MB............ 500 * 17.03.2009 18:58:09 * ztta/roll_area................ 3500032 *

17.03.2009 18:58:09 * ztta/roll_extension........... 2000683008 *

17.03.2009 18:58:09 *************************************************************************

17.03.2009 19:05:12 BEGIN EXIT_SAPLRSAP_002 287

17.03.2009 19:05:12 END EXIT_SAPLRSAP_002 287

17.03.2009 19:05:12 Asynchronous send of data package 1 in task 0002 (1 parallel tasks)

17.03.2009 19:05:12 IDOC: Info IDoc 2, IDoc No. 7367574, Duration 00:00:00

17.03.2009 19:05:12 IDoc: Start = 17.03.2009 18:58:09, End = 17.03.2009 18:58:09 17.03.2009 19:05:12 tRFC: Data Package = 1, TID = 13C502E513C049BF83E801E2, Duration = 00:00:00, ARFCSTATE = RECORDED R3 038 S

17.03.2009 19:05:12 tRFC: Start = 17.03.2009 19:05:12, End = 17.03.2009 19:05:12

17.03.2009 19:05:12 Asynchronous transmission of info IDoc 3 in task 0003 (0 parallel tasks)

Please let me know what is the problem with this issue

suggest the solution???

Regards

Edited by: Bi power on Mar 17, 2009 2:49 PM

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Mar 17, 2009 at 02:02 PM

    Your job log in the source system seems to suggest about8 minutes or so ...

    You should get the time taken in the infopackage also ..?

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi

      Please see the below routine and give suggestions..

      PROGRAM CONVERSION_ROUTINE.

      • Type pools used by conversion program

      TYPE-POOLS: RS, RSARC, RSARR, SBIWA, RSSM.

      • Declaration of transfer structure (selected fields only)

      TYPES: BEGIN OF TRANSFER_STRUCTURE ,

      • InfoObject 0BPARTNER: CHAR - 000010

      • PARTNER(000010) TYPE C,

      • InfoObject 0USER_SYST: CHAR - 000010

      • OLTP_SYSTEM(000010) TYPE C,

      • InfoObject 0USER_NAME: CHAR - 000012

      • OLTP_USERNM(000012) TYPE C,

      • InfoObject 0ORGUNIT: NUMC - 000008

      • ORGEH(000008) TYPE N,

      • dummy field to avoid syntax error

      $dummy(1) type c,

      END OF TRANSFER_STRUCTURE .

      • Global code used by conversion rules

      $$ begin of global - insert your declaration only below this line -

      • TABLES: ...

      • DATA: ...

      $$ end of global - insert your declaration only before this line -

      ----


      • FORM COMPUTE_/BIC/ZLASTDATE

      ----


      • Compute value of InfoObject ZLASTDATE

      • in communication structure /BI0/MBPARTNER

      *

      • Technical properties:

      • field name = /BIC/ZLASTDATE

      • data element = /BIC/OIZLASTDATE

      • data type = DATS

      • length = 000008

      • decimals = 000000

      • ABAP type = D

      • ABAP length = 000016

      • reference field =

      ----


      • Parameters:

      • --> RECORD_NO Record number

      • --> TRAN_STRUCTURE Transfer structure

      • <-- RESULT Return value of InfoObject

      • <-> G_T_ERRORLOG Error log

      • <-- RETURNCODE Return code (to skip one record)

      • <-- ABORT Abort code (to skip whole data package)

      ----


      FORM COMPUTE_/BIC/ZLASTDATE

      USING RECORD_NO LIKE SY-TABIX

      TRAN_STRUCTURE TYPE TRANSFER_STRUCTURE

      G_S_MINFO TYPE RSSM_S_MINFO

      CHANGING RESULT TYPE /BIC/OIZLASTDATE

      G_T_ERRORLOG TYPE rssm_t_errorlog_int

      RETURNCODE LIKE SY-SUBRC

      ABORT LIKE SY-SUBRC. "set ABORT <> 0 to cancel datapackage

      $$ begin of routine - insert your code only below this line -

      • DATA: l_s_errorlog TYPE rssm_s_errorlog_int.

      RESULT = sy-datum.

      • returncode <> 0 means skip this record

      RETURNCODE = 0.

      • abort <> 0 means skip whole data package !!!

      ABORT = 0.

      $$ end of routine - insert your code only before this line -

      ENDFORM.

      Regards

      Edited by: Bi power on Mar 18, 2009 11:46 PM

      Edited by: Bi power on Mar 19, 2009 3:05 PM

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.