How to change DTP Overall Status from Yellow to Red

[Former Member]

Dear all,

if I choose "set overall status automatically", how can I change DTP overall status when I want to stop the DTP running? Thanks.

[Former Member]

Folks

I know how frustrating this problem is even in netweaver 7.0 environment. I found a solution for this problem atlast and it works but a not direct way of resolving this issue.

When this request is in yellow status and not able to change / delete the request, its actually in a pseudo status and it is a bug in the program. This request sits in table RSBKREQUEST with processing type as 5 in data elements USTATE, TSTATE and this 5 is actually "Active" status which is obviously wrong.

All we need is, ask your basis person to change the status to 3 in both these data elements and then it allows to reload the delta. Once the delta is successfully loaded, you can delete the previous bad request even though it is still in yellow. Once the request is deleted, the request status gets updated as "4" in table RSBKREQUEST.

Hope this helps.

Thanks

[Former Member]

Is this a master data load ?

If yes, check if the below OSS is applicable:

Note 1095828 - P16:Manage:DTP:Cannot delete yellow DTP requests in Manage

[Private_Member_101989]

Hello,

Just go to the datatarget and change the load to red. To stop the job in the source system kill the jobs in sm50.

Regards,

Jorge Diogo

[Former Member]

As I said, all the jobs of BIDTP* were marked Finished.

[Former Member]

Hi Jin,

Since there is no active job, there is a possibility that your job is still in the released state. Please check if this job BIDTP* is in the released state. If so, Cancel it and start the DTP again.

Revert with the updates.

Thanks...

Shambhu

[Former Member]

Hi Shambhu, all the jobs are marked finished in SM37

[Former Member]

The overall status is grey and I can't click to change.

[Former Member]

The job name will start with BIDTP*. ( for example ... BIDTPR_2175_1) where 2175 is the requset id generated in the DTP(you will find this in the DTP monitor screen). Check with this job name in SM37.

Thanks...

Shambhu

[Former Member]

Hi,

Go to the Infoprovider manage by the context menu -> click on the monitor icon which will take u to the monitor screen->select the Header tab,set the overall status to red r green which ever u want.

hope this helps.

Regards,

vid.

[Former Member]

But in SM37, there is no job running.

[Former Member]

Hi Friend,

The Job name would be something like BIDTPR_6446_1.

Goto SM37 and give BIDTP* in Job name* and your user ID.

Now you will see your job. To cancel it just click on the your Job, Then go to the Menu Bar JOB under that 2nd option Cancel Active Job.

Click on this. Your Job which was running for DTP load is cancelled.

Hope it helps.

Reward if helpful.

Regards

Hemant Khemani

[Former Member]

You can cancel the DTP job in SM37 and it will turn to red.

Thanks...

Shambhu