Frequest process chain issue - Database selection was interrupted

[Former Member]

hi experts,

we are running master data meta chains daily, and we have PP,SD,MM,LO,FI,PS masterdata meta chains running daily, and everyday 2-3 process chains are failing, it is extracting only 50000 records and the requests becomes RED.

if i check the long text of the error message, it is giving the below error message.

Database selection was interrupted (see long text)

Message no. RSBK072

Diagnosis

You are extracting data from a DataSource or an InfoProvider. The selection is made with an open database cursor. This cursor has been invalidated by one of the following ABAP statements:

COMMIT WORK

ROLLBACK WORK

CALL TRANSACTION

SUBMIT

The ABAP statement responsible for termination probably ran in a transformation routine programmed by you.

System Response

Request processing has ended with errors.

Procedure

Change the code for the transformation in which one of the specified ABAP statements is executed. If you are using statement COMMIT WORK, replace it with:

CALL FUNCTION 'DB_COMMIT'.

again if i delete the request from the target and repeat it is working fine but taking lot of time. but there are no routines in the transformations.

please provide us the solution to rectify the issues as it is causing lot of reporting issues.

regards

venuscm

[Former Member · Accepted solution]

Hi Venu,

Kindly check the below SAP Notes, this will solve your Issue.

1285640 - 70SP21: "Database selection was interrupted"

1519889 - DTP processing: "Database selection was interrupted"

1518750 - Additional trace messages in the DTP request log

Regards,

Ashish

[Former Member]

Hi Venu,

For error message "Message no. RSBK072", Kindly have a look at below note and check wheather it's valid for your system,

1285640 - 70SP21: "Database selection was interrupted"

1519889 - DTP processing: "Database selection was interrupted"

1518750 - Additional trace messages in the DTP request log

Hope this helps.

Regards,

Mani

[Former Member]

Hi Venu,

1. Have to check the Package size in DTP setting.

Double click on DTP> Goto Extraction tab> Check the Package size.

2. Onece check with Basis team for space allowcation issue.

Regards,

[Former Member]

Hi Venu,

When DTP gets fails, can you please check the job log in SM37. this may give lot more information. are you running full load or with any selections

Regards,

Venkatesh

[Former Member]

hi,

yes, it is full load.

Regards

venuscm

[Former Member]

Hi Venu,

Please check the job log in SM37 and give us some more details, i mean source and target of data load.

Please look at the notes once provided by others also.

Regards,

Venkatesh

[Former Member]

hi experts,

here is the source 0MAT_PLANT_TEXT and the target is 0MAT_PLANT.

info package load is very fast, but DTP it is taking lot of time if i execute the DTP Manually.

The data packets are processed very fast, but after that at the bottom

Set technical status to green and

set overall status to green in yellow very long time, due to this DTP Load for above master data is taking long time.

how to resolve this?

any solutionz pl.

Regards

venuscm

Edited by: venu WAD on Oct 24, 2011 6:37 AM

[Former Member]

Hi,

Check the SAP NOTE 1293589 if it solves your issue.

Thanks,

Nagarjuna.