DTP request automatically deleted

[Former Member]

Hi All,

while loading Data from PSA to DSO, one request(delta) is successfully loaded. and another request(Delta) from same source was triggered  after some time. But this load was terminated giving this error: 1. DTP request is already processed(Gave last request number as processed one in the error ) 

2. and this error is automatically deleted by system.

Daily it used to load 2 delta with a gap and both were successful. Please suggest me something useful..

Regards:

sandeep

[Former Member · Accepted solution]

It was a resource allocation issue.. 2 process chains trying to access the same resource within a gap of few secs.. now we resolved by triggering the process chains with a gap... now it is successful..

[jino_jose]

Hi,

You can avoid this error by setting the number of process to 1 on the batch manager setting of the DTP. Once you set this delete the failed load and reload the data.  The disadvantage of this option you will be loading the data in a serial mode.

Thanks,

Jino

[former_member182196]

Hi,

Go to SM12 and delete all the locked request.

delete error request from DSO or PSA and rerun again.

Regards,

sm

[Former Member]

Hi All,Exception CX_RSBK_REQUEST_LOCKED logged

Message no. RSBK228

thi is the error. Data load is from DSO to Infoobject attribute thorugh DTP..

[former_member182470]

This is a confusion now. You were saying that two delta loads from PSA to DSO. Now you say DSO to Infoobject.

Can you say my understanding is correct as per my first reply?

[RamanKorrapati]

pls check below thread which indicate same kind of issue.

http://scn.sap.com/thread/1310564

till now i didn't get your data flow. sorry.

Are you loading DSO to Info object?

[Former Member]

check backgrond process in dtp. using menu bar-->goto-->setting for batch manager.and also check the lock in SM12. and see the below threads related to this  error

http://scn.sap.com/thread/1920989

http://help.sap.com/saphelp_nw04/helpdata/en/13/f583d9c6153947b1c81f7db75cb77c/frameset.htm

[Former Member]

yes

[anshu_lilhori]

Hi,

Check this thread

http://scn.sap.com/thread/3294288

Regards,

AL

[former_member182470]

Missed my reply?

[Former Member]

It is DSO to Info object..

[former_member182470]

Implement this SAP Note : SAP Note 1546906

[Former Member]

Hi,

Check whether there are any locks in SM12 and delete it if any.

Thanks,

Venu

[Former Member]

Hi,

If my above reply not works, please check these following points.

http://scn.sap.com/message/14237373.

Normally, if you encounter the above error, the DTP loading was failing because of the request which was still executing (yellow status). On refreshing this request in the DTP monitor, it may be set to red status and you can delete this request.

If it can not be refreshed to red status, you have to change its status manually in table RSBKREQUEST:

Please try to update the table RSBKREQUEST under the SE16 transaction.
    1.1 - Go to SE16 transaction.
    1.2 - Fill the Table name with RSBKREQUEST.
    1.3 - Press F7.
    1.4 - On the field REQUID, fill with the DTP request ID
    1.5 - See that the columns USTATE and TSTATE value to be 4, and save
    1.6 - After this, please try to execute the step to delete the
          request.

After that you will be able to execute the DTP successfully without any yellow status.

Thanks,

Venu

[Former Member]

Better share your data flow screen shot. Will helps to understand better. Thanks.

Regards,

Venu

[former_member182470]

Hi,

Load Infopackage->PSA-->Delta DTP-->Again Load Infopackage-->PSA-->Delta DTP got failed , right?

Instead of this, you can run Delta DTP request by request option in DTP.

Regards,

Suman

[RamanKorrapati]

Hi sandeep,

No idea why you run delta from same source with gap of minutes?? even if you run also you may get 0 records.

What is your data source name and have you check ECC job? pls check and share if you see any error at ecc job log.

From info pack, monitor, Menu--> environment--> job overview--> jon in the source system--> enter ecc id and pass word, you will get related job, select and click on job log details.

Thanks