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

Data extraction taken forever to run

Hi all,

Datasource "0CFM_MARKET_VALUES" is taking forever to run in our production environment. When we check on the job log in ECC, the process is always stayed at Indexing.

Job Log in ECC:

Date

Time Message text Message class Message no. Message type

18.08.2016 09:52:15 Job started 00 516 S 18.08.2016 09:52:15 Step 001 started (program SBIE0001, variant &0000000389490, user ID RFCBWP57) 00 550 S 18.08.2016 09:52:15 Asynchronous transmission of info IDoc 2 in task 0001 (0 parallel tasks) R3 413 S 18.08.2016 09:52:15 DATASOURCE = 0CFM_MARKET_VALUES R3 299 S 18.08.2016 09:52:15 RLOGSYS = PXXXXX R3 299 S 18.08.2016 09:52:15 REQUNR = REQU_DN1AQMXRQ95YRPZN6FQGMRV5H R3 299 S 18.08.2016 09:52:15 UPDMODE = F R3 299 S 18.08.2016 09:52:15 LANGUAGES = * R3 299 S 18.08.2016 09:52:15 ************************************************************************* R8 048 S 18.08.2016 09:52:15 * Current Values for Selected Profile Parameters * R8 049 S 18.08.2016 09:52:15 ************************************************************************* R8 048 S 18.08.2016 09:52:15 * abap/heap_area_nondia......... 0 * R8 050 S 18.08.2016 09:52:15 * abap/heap_area_total.......... 56000000000 * R8 050 S 18.08.2016 09:52:15 * abap/heaplimit................ 40000000 * R8 050 S 18.08.2016 09:52:15 * zcsa/installed_languages...... &12;E늘덆묩븑쁩 * R8 050 S 18.08.2016 09:52:15 * zcsa/system_language.......... E * R8 050 S 18.08.2016 09:52:15 * ztta/max_memreq_MB............ 2047 * R8 050 S 18.08.2016 09:52:15 * ztta/roll_area................ 13000000 * R8 050 S 18.08.2016 09:52:15 * ztta/roll_extension........... 5000000000 * R8 050 S 18.08.2016 09:52:15 ************************************************************************* R8 048 S 18.08.2016 09:52:17 IDOC: Info IDoc 2, IDoc No. 322548469, Duration 00:00:00 R3 088 S 18.08.2016 09:52:17 IDoc: Start = 18.08.2016 09:52:15, End = 18.08.2016 09:52:15 R3 089 S 18.08.2016 09:52:18 Index from: 1, Index to: 10, Index last: 207 FTI_LDB_MESSAGE 077 S 18.08.2016 09:52:20 Index from: 11, Index to: 20, Index last: 207 FTI_LDB_MESSAGE 077 S 18.08.2016 09:52:20 Index from: 21, Index to: 30, Index last: 207 FTI_LDB_MESSAGE 077 S 18.08.2016 09:52:21 Index from: 31, Index to: 40, Index last: 207 FTI_LDB_MESSAGE 077 S 18.08.2016 09:52:21 Index from: 41, Index to: 50, Index last: 207 FTI_LDB_MESSAGE 077 S 18.08.2016 09:52:22 Index from: 51, Index to: 60, Index last: 207 FTI_LDB_MESSAGE 077 S 18.08.2016 09:52:22 Index from: 61, Index to: 70, Index last: 207 FTI_LDB_MESSAGE 077 S 18.08.2016 09:52:23 Index from: 71, Index to: 80, Index last: 207 FTI_LDB_MESSAGE 077 S 18.08.2016 09:52:24 Index from: 81, Index to: 90, Index last: 207 FTI_LDB_MESSAGE 077 S 18.08.2016 09:52:24 Index from: 91, Index to: 100, Index last: 207 FTI_LDB_MESSAGE 077 S 18.08.2016 09:52:25 Index from: 101, Index to: 110, Index last: 207 FTI_LDB_MESSAGE 077 S 18.08.2016 09:52:26 Index from: 111, Index to: 120, Index last: 207 FTI_LDB_MESSAGE 077 S 18.08.2016 09:52:26 Index from: 121, Index to: 130, Index last: 207 FTI_LDB_MESSAGE 077 S 18.08.2016 09:52:27 Index from: 131, Index to: 140, Index last: 207 FTI_LDB_MESSAGE 077 S 18.08.2016 09:52:28 Index from: 141, Index to: 150, Index last: 207 FTI_LDB_MESSAGE 077 S 18.08.2016 09:52:28 Index from: 151, Index to: 160, Index last: 207 FTI_LDB_MESSAGE 077 S 18.08.2016 09:52:29 Index from: 161, Index to: 170, Index last: 207 FTI_LDB_MESSAGE 077 S 18.08.2016 09:52:29 Index from: 171, Index to: 180, Index last: 207 for FTI_LDB_MESSAGE 077 S 18.08.2016 09:52:30 Index from: 181, Index to: 190, Index last: 207 FTI_LDB_MESSAGE 077 S

Appreciate if any expert here is kind enough to provide me some insight for resolving this issue?

Thanks.

Regards,

Ong

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Aug 19, 2016 at 02:55 PM

    Hi,

    I would do an index in related Table(s) of that Datasource in ECC.

    In the mean time test the datasource in ECC and check if the error is the same. If not, try using some values instead of a Full Load. If the problem continues and after the table index, create a SAP message.

    Regards.

    Add a comment
    10|10000 characters needed characters exceeded

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.