Question Re: Error while setting status for Data Store Object in Technology Q&A

Error while setting status for Data Store Object

Former Member — Fri, 24 Jan 2014 11:47:33 GMT

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

Re: Error while setting status for Data Store Object

RamanKorrapati — Fri, 24 Jan 2014 11:52:40 GMT

Hi,

Delete red the request from dso.

Reactivate your dso by using - RSDG_ODSO_ACTIVATE.

Again try to load data from PSA to DSO. if psa have huge data, then try to increase data packets sizes.

Use settings at Tx - RSODSO_SETTINGS to improve dso load.

Thanks

Re: Error while setting status for Data Store Object

KodandaPani_KV — Fri, 24 Jan 2014 11:56:18 GMT

Hi Suman,

Check the DTP not active status because failed and please decrease the data package size 20000 (by default - 50000) it will work and increase the parallel process

before doing activate the DSO, transformation, and DTP one more time

Thanks,

Phani.

Re: Error while setting status for Data Store Object

Former Member — Fri, 24 Jan 2014 12:13:41 GMT

Dear Ram,

Thanks for the reply,

Done as per ur advice, still error persist.

RSDG_ODSO_ACTIVATE (Result)

RSODSO_SETTINGS

Error:

Regards,

Suman T

Re: Error while setting status for Data Store Object

RamanKorrapati — Fri, 24 Jan 2014 12:26:00 GMT

if possible can you try to debug your dtp. can you try keep the data packet size to 50,000.

Check this oss note - 1405785

Re: Error while setting status for Data Store Object

KodandaPani_KV — Fri, 24 Jan 2014 12:58:10 GMT

HI suman,

delete the total data in DSO and Load the data.

please expand the node of data package screen screen shot

Thanks,

Phani.

Re: Error while setting status for Data Store Object

Former Member — Sat, 25 Jan 2014 12:59:43 GMT

Dear Ram,

Still error persist.

Re: Error while setting status for Data Store Object

KodandaPani_KV — Sat, 25 Jan 2014 13:45:55 GMT

Hi Suman,

please activate the DSO object using RSDG_ODSO_ACTIVATE and reactivate the transformations.

set the parallel process as 5 in DTP monitor.

Thanks,

Phani.

Re: Error while setting status for Data Store Object

Former Member — Sat, 25 Jan 2014 14:02:45 GMT

Phani,

Tried still error.

Regards,

Suman T

Re: Error while setting status for Data Store Object

KodandaPani_KV — Sat, 25 Jan 2014 14:50:14 GMT

Hi suman,

one more extract data form source to PSA and delete the data form DSO and again load form PSA to DSO. RSODSO_SETTINGS use settings and activate the DS, DSO and transformation and DTP and try.

have you write any code in transformation level?

Thanks,

phani.

Re: Error while setting status for Data Store Object

former_member182470 — Sun, 26 Jan 2014 04:40:15 GMT

Hi Suman,

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

Regards,

Suman

Re: Error while setting status for Data Store Object

abdullahqureshi — Sun, 26 Jan 2014 07:16:54 GMT

Hi Suman,

Can u expand it more deep level of your error that you are getting in data load. Hope there would be some clue of error.

Also check with setting those you have applied at DTP and DSO. I think there is some inconsistency.

Regards,

Abdullah

Re: Error while setting status for Data Store Object

Former Member — Mon, 27 Jan 2014 07:20:42 GMT

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

Re: Error while setting status for Data Store Object

former_member182470 — Mon, 27 Jan 2014 07:27:25 GMT

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

Re: Error while setting status for Data Store Object

KodandaPani_KV — Mon, 27 Jan 2014 07:32:33 GMT

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.

Re: Error while setting status for Data Store Object

Former Member — Mon, 27 Jan 2014 07:35:52 GMT

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

Re: Error while setting status for Data Store Object

Former Member — Mon, 27 Jan 2014 07:39:23 GMT

Hi Suman,

Can you share your BW component details.

Thanks & Regards,

Vipin

Re: Error while setting status for Data Store Object

former_member182470 — Mon, 27 Jan 2014 07:42:12 GMT

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

Re: Error while setting status for Data Store Object

Former Member — Mon, 27 Jan 2014 08:09:52 GMT

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

Re: Error while setting status for Data Store Object

former_member182470 — Mon, 27 Jan 2014 08:15:02 GMT

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.