Archived discussions are read-only. Learn more about SAP Q&A

BW batch job in r/3 taking long time.

Hi SAP experts,

Please help me resolving this issue.

Issue :

BW batch job in r/3 taking long time and failed with error. This is delta load usually finished in 15- 20 mins, but from last 2 days, this BW batch job is taking every long time and failing with error.

details of job runs:

on 31.01.2012, BW batch job took around 7 hours and extracted 208 records.

on 01.02.2012 BW batch job took around 10 hour and extracted 802 records

Today batch job took around 11 hours and failed with following error message.

Job started

Step 001 started (program SBIE0001, variant &0000000106933, user name BWALEREMOTE)

DATASOURCE = ZEXTRACT_ACTUALS

  • Current values of selected profile parameter *

  • abap/heap_area_nondia......... 2000683008 *

  • abap/heap_area_total.......... 2000683008 *

  • abap/heaplimit................ 40894464 *

  • zcsa/installed_languages...... E2 *

  • zcsa/system_language.......... E *

  • ztta/max_memreq_MB............ 64 *

  • ztta/roll_area................ 6500000 *

  • ztta/roll_extension........... 2000683008 *

0 LUWs confirmed and 0 LUWs to be deleted with FB RSC2_QOUT_CONFIRM_DATA

ABAP/4 processor: DBIF_RSQL_SQL_ERROR

Job cancelled

Details of the data source:

It is "Z" data source, created on view (View joining 6 table(all stand tables))

I have checked with basis for available resources, increased priority of the job.

Please help

Thanks and Regards

Chakri

replied

Hi Chakri,

Yes, you have identified the issue. if you have indexes on your base tables , try to create them once again, it will work.

Regards,

Venkatesh

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question