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 Member · Accepted solution]

Hi Suman,

Did u try to load data in development system ???

R u getting same error in the development also , just try once .

I think u have to reactivate ur transformation ......If this is the problem use RSDG_TRFN_ACTIVATE program to activate transformation ..  ...in that there will be object status field for transformation u have to select active (ACT)  only .

Try it I had the same issue , it worked for me.

Regards,

Saurabh Singh

[Former Member · Accepted solution]

Dear All,

Thanks for your support.

The problem was with the infoprovider, earlier i tried to load the data source with the DSO. As we are doing only the full loads for this datasource, I tried removing the DSO and point to the Infocube now its getting loaded perfectly.

Note: The datasource 0HR_PY_REC_51 with the delta process "ADD"

But still my confusion is its getting loaded in QA and DEV system, but unable to load in PRD with the dataflow of DS--->DSO--->CUBE.

Regards,

Suman T

[Former Member]

Are there any short dumps in ST22 with respect to this data load? if yes share the short dump details.

Check the below OSS

  1926514 - SYB: Various short dumps, fetch errors and incomplete results with Sybase ODBC Driver ver...

Regards

KP

[Former Member]

Dear Prasanth,

The worst point is i am not even getting dumps, gone through this note. Informed to basis team.

Any other hope is there.

Regards,

Suman T

[anshu_lilhori]

Did you do a RSRV check on that DSO ?

Please do the same and see if that gives some consistency error.

Regards,

AL

[Former Member]

Hi Suman,

Can you share your BW component details.

Thanks & Regards,

Vipin

[abdullahqureshi]

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

[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.

[KodandaPani_KV]

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.

[RamanKorrapati]

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

[Former Member]

Dear Ram,

Thanks for the reply,

Done as per ur advice, still error persist.

RSDG_ODSO_ACTIVATE (Result)

RSODSO_SETTINGS

Error:

s

Regards,

Suman T

[RamanKorrapati]

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

[KodandaPani_KV]

HI suman,

delete the total data in DSO and Load the data.

please expand the node of data package screen screen shot

Thanks,

Phani.

[Former Member]

Dear Ram,

Still error persist.

[KodandaPani_KV]

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.

[Former Member]

Phani,

Tried still error.

Regards,

Suman T

[KodandaPani_KV]

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.