Error while setting status for Data Store Object

[Former Member]

Dear All,

I am facing a error "Error while setting status for DataStore 0PY_DS51 and request DTPR_DGWPP2HX81HHF0QEJFGUI6THG" when i am trying to load the data from PSA to DSO. Kindly help me resolve this issue.

Note: This is first time i am trying to load the data in DSO in PRD system.

Regards,

Suman T

[former_member182470]

Hi Suman,

Please delete that red request from RSODSACTREQ table. After that run DTP.

Regards,

Suman

[Former Member]

Hi Suman,

Thanks for the reply,

I have delete the request from the table still i am getting the same error.

@Abdullah Quershi:- deleted the data from PSA also and loaded the data from the scratch still i am facing the error.

Even expanding the error i am not clear about the error mess.

This is the error message every time after it fails.

Regards,

SumanT

[former_member182470]

I think the DTP req which is there in error needs to be deleted from the table.

[KodandaPani_KV]

Hi Suman,

it seems to be DSO inconsistency problem check in RSRV.

for testing purpose load only some test records (100-200) then it will work fine do full load.

please check the data source level data and transformation mapping form DS to DSO and DTP.

if you possible create one more new DTP set parell process 5 and data package size set 20,000.

hope it will help.

Thanks,

Phani.

[Former Member]

Dear Suman,

I have deleted the entries from the table you have mentioned.

after that i have loaded the data into the DSO, still i am getting the same error.

Regards,

Suman T

[former_member182470]

HI Suman,

You have to delete all the requests which comes up in the error message. Copy them and delete. I think some incorrect deletions happened in your DSO before. So those are hanging in that table.

Regards,

Suman

[Former Member]

Dear Suman,

Thanks for the replying immediately,

I have deleted all the request from the table.

failed Request details.

Error Again:

Vipin : Please take look at the component details.

Regards,

Suman T

[former_member182470]

You should not make your table blank. There might be correct requests also, right? I have clearly told you to delete only error requests. Please read replies carefully before taking any action.

[Former Member]

Dear Suman,

First i tried to delete only the related requests its not working that,s why i tried to delete all the request from the table just to want to give a try to see whether its loading or what.

Will correct my mistake.

Thanks,

Suman T

[former_member182470]

R u in Production system? If so, pls check your DSO to confirm any previous requests have been deleted. If not, then you are safe, otherwise you will have to load DSO again. Please be very careful with this activity.

Definitely there is an inconsistency in your DSO req statuses.

[Former Member]

Yes i am doing this in PRD but this is first time loading to the DSO, will correct my mistake.

If the inconsistency are there in DSO how to correct it.

I Think its getting failed when the status is in "U" update mode itself.

Kindly help me in this.