BW4HANA 2.0 Cannot delete red request from InfoObject attributes load

[burns_sh]

Hi all,

we are on BW4HANA 2.0, and I have tried to load a flat file into a new attribute for 0CUSTOMER.

The load failed due to some of the records having the text in lower case.

I have updated the transformation to transform to upper case, however it will not let me delete the error request, it just gives a short dump each time I try.

Has anyone come across this scenario before, and if so how did you resolve?

Thanks,

Shane.

[burns_sh]

Hi Abhi,

thanks for your suggestions, just to update you on my progress.

First of all, I do have the auths as have been able to delete a few days before, and checked SU01D and my auths has not changed.

So next step, I changed the status of the request to green, and tried deleting and still get the same short dump.

However, when the request is now green, I can load with data and plan as normal !!!

I have shared a screenshot of rspmrequest.jpg

You can see the line highlighted is the one with the issues, and it has the status of GR (Overall OK but technically not OK).

I was going to raise this with SAP, however now that I have loaded data I cannot revert to the previous state, and also it is a dev system so it seems to work with the workaround of changing status to Green.

If it happens again in the other systems I will raise a message with SAP to look at.

Many thanks for your help and suggestion,

Shane.

[SudhanshuSurma]

Thank you so much for sharing the fix Shane! We were stuck with the same issue, your tip (turn request to green) worked wonders 🙂

[burns_sh]

Hi Abhi,

I have attached the short dump;

st22.txt

There is data existing in the 0CUSTOMER InfoObject.

• It is a mixture of data loaded for most of the attributes from the S4 datasource,
• And some attributes loaded using an input query

0CUSTOMER is enabled for planning, and loading mode is set to;

• Real-Time Data Target Can be Loaded With Data; Planning Not Allowed

Thanks,

Shane.

[Abhishek_Hazra]

Hi Shane,
Thanks for the file & details. The dump details say it fails to start the batch job. I wonder if you have the authorization to delete requests from 0CUSTOMER infoobject? Could you check that with your authorization team? Or have you ever been able to delete requests from the same successfully? That way you can be sure if you have the authorization to do so. If the necessary authorizations are also in place & as you say the info object is set to loading mode & the request status in RSPMREQUEST table is also qualified for normal deletion (please also check the fields : REQUEST_STATUS_BEFORE_DELETION, LAST_REQUEST_STATUS & REQUEST_IS_IN_PROCESS : none of them should be ACTIVE or in Process), then I would suggest reach out to SAP with an incident.
If you find a solution, I would be eager to know too 🙂

Have a good day!
Abhi

[roland_szajko]

According the history of this thread there is a dump during request deletion in:

| "MESSAGE_TYPE_X" |

| "SAPLRSBATCH" bzw. LRSBATCHU01 |

| "RSBATCH_START_PROCESS"

This seems to be what is described in the KBA:

3165741 Dump when deleting error DTP request

Did you tried the solution from this KBA?

[anja_schlimme]

Hi All,

We're still facing this issue.

For sure we're able to follow the above mentioned trick but to do this all the time is really boring.

Does anyone know a consistent solution here?

[former_member787432]

Hi All,
Below did the trick
1. In table RSBKREQUEST locate the REQUID from the Load to the infoobject.
2. In table RSBKREQUEST for the specific error request change the value in the fields USTATE, TSTATE and TARGETSTATE to '4' from '3'.
3. Remove the request in the infoobject.
(in ourcase some code was corrupt)
4. Load again and enjoy the power of BW 🙂

.j

[ramos_sean]

This only works in lower versions of BW and since this is BW4 HANA 2.0, all requests are in RSPMREQUEST table.

[roland_szajko]

It is always a bad idea to manually adjust any of the request administration tables on your own. Something like this should be done only when instructed by SAP (Support or Development) as it can easily lead to inconsistencies which can lead to problems in the future. I would strongly suggest NOT to do anything like this unless instructed by SAP.

[former_member787432]

Hi,

I have the same problem. But changing the request to green does not help.
Pls Advice

Regards / Jan

[former_member328014]

Hi burns_sh,

Did you find a solution? We have the same problem.

Thanks,

Cátia S.

[burns_sh]

Hi Cátia,

just what I mentioned above;

"I changed the status of the request to green, and tried deleting and still get the same short dump.

However, when the request is now green, I can load with data and plan as normal !!!"

Thanks,

Shane

[former_member690096]

hi,

we have the same problem. we have traces the authorisation: There is no problem.

[luisgz]

Hi,

We have the same problem. It issue began after migrating our SAP HANA 2.0 from pach 05 to 07. We can find a new method in class "CL_RSBK_REQUEST_STATE" --> "UPDATE_RSBATCH_LAST_PROCESS" and this new method tries to find red request in bach table but, this a flat file load so is a direct request. It is in this momento when dump appears.

Do you know if there is any note or add-oc solution for this problem?

[burns_sh]

Hi Abhi,

many thanks for your reply.

It is marked as RR, and when I go to the transaction RSMNG, this brings me to the same screen as when I do a Manage Attributes on the 0CUSTOMER Infoobject.

When I try to delete, it just gives a short dump without deleting 😞

Thanks,

sahne.

[Abhishek_Hazra]

Hello Again,

Could you may be share the short dump details? What does it say as error? Also do you have existing data in your info object other than the failed upload request?

Best Regards,
Abhi

[Abhishek_Hazra]

Hi Shane,

Could you check in RSPMREQUEST table what is the REQUEST_STATUS of the uploaded request? If it is RR, then try to go to t-code RSMNG & give 0CUSTOMER under 'Characteristic' & then hit execute, once you are in the manage screen, try to delete the request from there.
Hope this will help.

Regards,
Abhi