on 08-19-2016 8:48 AM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Thanks for your reply.
Yes same issue happened when we tested the datasource in ECC even we using some values instead of a full load.
Since the underlying of datasource is an infoset query
/SAPQUERY/CFM_BW_VALUES
It has a number of tables, should we index all the related tables? Btw, how to apply index to the table?
thanks!
Hi,
Look into the infoset and do an analysis about the largest table, create an Index in that table.
This is the procedure I found for an index creation.
Hello,
1,In SE11 Transaction display your table.
2.press button index... in tool bar, it will ask you
to create a new one.
3.give the index name
4. give short text description
5. in bottom table give the field name on which
you want index.
6. save and activate.
Or
http://www.saphub.com/abap-dictionary/sap-secondary-index/
If the problem continues, I think it's time to search for a Note.
Regards.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.