Job terminated in source system -> Request set to red during delta load

[Former Member]

Hi All,

There is issue with the delta load where as full load works fine and it results in below job termination with below log.

Job started

Step 001 started (program SBIE0001, variant &0000000128086, user ID ALEREMOTE1)

Asynchronous transmission of info IDoc 2 in task 0001 (0 parallel tasks)

DATASOURCE = 2LIS_13_VDITM

RLOGSYS = BWP_010

REQUNR = REQU_DA9R6Y5VOREXMP21CICMLZUZU

UPDMODE = R

LANGUAGES = *

*************************************************************************

• Current Values for Selected Profile Parameters *

*************************************************************************

• abap/heap_area_nondia......... 0 *

• abap/heap_area_total.......... 17173577728 *

• abap/heaplimit................ 40000000 *

• zcsa/installed_languages...... DE *

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

• ztta/max_memreq_MB............ 2047 *

• ztta/roll_area................ 3000000 *

• ztta/roll_extension........... 2000000000 *

*************************************************************************

Object requested is currently locked by user ALEREMOTE1

Job cancelled after system exception ERROR_MESSAGE

Please help me to resolve this issue.

Thanks,

Madhu,

[Former Member]

Hi PT / Rahul,

Thanks for your inputs.

I solved this issue as below.

1) There was a job in SM37 which was triggered due to previous data load active and runing for long time in source system.I have cancelled this job through SM50.

2) I have done the connection restore in BW.

3) Once done with repeat of last delta as suggested by Rahul I have done reinit without data transfer and now delta data loads are fine.

Thanks,

Madhu.

[Former Member]

Hi,

The data load has failed due to LOCK issue. wait for sometime and then start the data load again after deleting the red requests on the bw side. If the load fails again because of LOCK (Locked by ALEREMOTE1) contact the basisi team,

Regards,

rahul

[Former Member]

Hello,

As per the screen shot provided below, data soruce belongs to LO, so first check in RSA7, whether it has got mark in RSA7, for which you have entries in RSA7 against the data source. If you are not able to find the data source in RSA7, then you need to set-up the update methods, based on the requirement.

1) Direct Delta

2) Queued Delta

3) Unserialised V3 Update

Once it is done, Delete the Previous Initilisation, again perform the Re-Init With Out data and now schedule the Delta Data Loads

Hope this may Help you.

Thanks

PT