BI Extraction job in ECC

[ashish_vikas]

Hi friends,

We are facing a problem where some of BW extraction jobs in ECC are seems to be taking much longer time and for few hours there is no update in Job log. After few hours, it starts sending tRFC packets automatically and then it finishes.

What can be the reason for no activity visible for few hours in between ?

(Since they run in night, tracing them is difficult as job name is not known in advance)

I checked and did not find any note for 0CO_PC_01 valid for 701 system.

Job log overview for job:    BIREQU_DJQST9E8G1COLTBBS7QUXF6SH / 22242500

Date       Time     Message text                                                                                      Message class Message no. Message type

02.04.2015 22:24:25 Job started                                                                                            00           516          S

02.04.2015 22:24:25 Step 001 started (program SBIE0001, variant &0000000072040, user ID ALEREMOTE)                         00           550          S

02.04.2015 22:24:25 Asynchronous transmission of info IDoc 2 in task 0001 (0 parallel tasks)                               R3           413          S

02.04.2015 22:24:25 DATASOURCE = 0CO_PC_01                                                                                 R3           299          S

02.04.2015 22:24:25 RLOGSYS    = PWXCLNT100                                                                                R3           299          S

02.04.2015 22:24:25 REQUNR     = REQU_DJQST9E8G1COLTBBS7QUXF6SH                                                            R3           299          S

02.04.2015 22:24:25 UPDMODE    = F                                                                                         R3           299          S

02.04.2015 22:24:25 LANGUAGES  = *                                                                                         R3           299          S

02.04.2015 22:24:25 *************************************************************************                              R8           048          S

02.04.2015 22:24:25 *          Current Values for Selected Profile Parameters               *                              R8           049          S

02.04.2015 22:24:25 *************************************************************************                              R8           048          S

02.04.2015 22:24:25 * abap/heap_area_nondia......... 4000683008                              *                             R8           050          S

02.04.2015 22:24:25 * abap/heap_area_total.......... 21472739328                             *                             R8           050          S

02.04.2015 22:24:25 * abap/heaplimit................ 40000000                                *                             R8           050          S

02.04.2015 22:24:25 * zcsa/installed_languages...... EJ                                      *                             R8           050          S

02.04.2015 22:24:25 * zcsa/system_language.......... E                                       *                             R8           050          S

02.04.2015 22:24:25 * ztta/max_memreq_MB............ 2047                                    *                             R8           050          S

02.04.2015 22:24:25 * ztta/roll_area................ 3000000                                 *                             R8           050          S

02.04.2015 22:24:25 * ztta/roll_extension........... 4000683008                              *                             R8           050          S

02.04.2015 22:24:25 *************************************************************************                              R8           048          S

03.04.2015 04:10:23 Call customer enhancement BW_BTE_CALL_BW204010_E (BTE) with 26,486 records                             R3           407          S

03.04.2015 04:10:23 Result of customer enhancement: 26,486 records                                                         R3           408          S

03.04.2015 04:10:23 Call customer enhancement EXIT_SAPLRSAP_001 (CMOD) with 26,486 records                                 R3           407          S

03.04.2015 04:12:21 Result of customer enhancement: 26,486 records                                                         R3           408          S

03.04.2015 04:12:21 PSA=1 USING SMQS SCHEDULER / IF [tRFC=ON] STARTING qRFC ELSE STARTING SAPI                             R3           299          S

03.04.2015 04:12:21 Asynchronous send of data package 1 in task 0002 (1 parallel tasks)                                    R3           409          S

03.04.2015 04:12:22 IDOC: Info IDoc 2, IDoc No. 27389213, Duration 00:00:00                                                R3           088          S

Regards,

Ashish

[Former Member]

Hello,

Check in background work process logs- see if there is any 'waiting for ABAP call' or wp reached memory limit which takes sometime to restart work process or is it waiting for spool creation. Also see if there is any parallel processing involved and number of processes are free at the time of job execution.

Try activating trace on Job/program name through ST12 and check in trace where its getting delayed.

Regards,

Ashish

[Former Member]

Hi Ashish,

Apart from this check the number of work process configured in SMQS connection setup and the parallelization and packet sizes, RZ12 server group settings which can impact the extraction jobs.

And do check for any indexing and fields how much data your having in the system.

Let us know further on your system health. so that we can help you more on this

regards,

Ram

[anup_singh5]

Hi ,

I see only one background work process running through out the extraction and others are in waiting in ECC

Where do we configure , so that more than 1 background work process is utlised ?

I think parallel processing is not happening , where do i check this configuration ..

Thanks & Regards,

Anup Singh

[Former Member]

Hi Anup,

Check the SMQS for the queue and the BI connection and set the Max. Connection & Max runtime in ECC.

Also refer below links for parallel processing setup in BI.

https://help.sap.com/saphelp_nw73/helpdata/en/48/807834109a1b5ae10000000a42189c/frameset.htm

Performance Tips for Data Transfer Processes - Business Intelligence - SAP Library

Introducing to SAP BI Background Management in BW Context - Contributor Corner - SCN Wiki

Let us know if this helped you.

Regards,

ram

[anup_singh5]

Hi Ram,

Thanks , SMQS setting in ECC has has max connection set to 2 and Max run time to 60 in ECC,

Please advise , if i need to check parallel processing in BI or ECC ?

As i see a job gets triggered in ECC for respective job request from BI and in ECC there is only one background job utilized

RSBATCH setting in BI for "Load with New DS without process chain variant" is set to "3" for parallel processing

Thanks & Regards,

Anup Singh

[Former Member]

Hi anup,

try to increase the SMQS connection to more than 2 as that will be number of process used in ECC and this will bring in slowness in data extraction. Ideally we set to 10 if you have 1CI & 5+ application server incase of Prod enviorment this can vary based on your processing power of your ECC.

BI side should be fine, but you can increase there two atleast 5.

Regards.

Ram

[anup_singh5]

Hi Ashish,

Did u find solution for your issue , even i'm seeing the same behavior of load not showing any progress and after long time , it starts sending idocs and finishes immediately ...

Please advise ...

Thanks & Regards,

Anup Singh

[Sriram2009]

Hi Ashish

1. In source system(On ECC) you can monitor the activity in SM66 or SM50.

2. Is this any resource bottle nick in Source system?

3. Package size settings for BW data loads from Soucre to target system. refer the SAP Note

    1597364 - FAQ: BW-BCT: Extraction performance in source system

4. Are you performing the PSA & Change log deletion in BI system?

BR

SS