cancel
Showing results for 
Search instead for 
Did you mean: 

Data extraction taken forever to run

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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.

Former Member
0 Kudos

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!


Former Member
0 Kudos

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.

Former Member
0 Kudos

I will give it a try.. thank you so much!