cancel
Showing results for 
Search instead for 
Did you mean: 

Error when inserting the data record for data package

Former Member
0 Kudos

Hi All,

I am getting error during activation of ODS ...I checked the forums but could not find proper answer.

Please help!!

Error when inserting the data record for data package 4

Message no. RSODSO_PROCESSING002

Diagnosis

Failed to store data records persistently. Possible causes are:

You tried to save a record that is already stored in the database.

This error only occurs with DataStore objects with option "Unique Data Records".

A unique index was created for the table of active data.

You can check this in the Data Warehousing Workbench by choosing "Display" for the DataStore object and opening the "Indexes" folder.

There is a technical problem on the database.

It isn't DSO with "Unique Dara Records" . There is a unique index on 2 fields but do not want to disturb that.

So is there a way to activate with out deleting the Index???

Is is a technical problem on the database?

Any help is much appreciated!!

Thanks,

JB

Accepted Solutions (0)

Answers (1)

Answers (1)

yogesh8984
Contributor
0 Kudos

Hi,

What is the setting for "Unique Data Records"? If it is checked, then it will not allow you to insert the duplicate record in it.

See if this happening in your case.

Regards,

Yogesh

Former Member
0 Kudos

Hi Yogesh,

'Unique records' is unchecked.

But any how problem solved...just deleted the unique indexes on the ODS.

Thanks for your prompt response!!!

JB

Former Member
0 Kudos

Hi JB,

I am facing the same problem here.

But i checked the DSO and Unique data records is "unchecked". Also there are NO indexes defined in the Index folder.

Is there any way to solve this? plz help

Former Member
0 Kudos

Hi Shreya,

I'm getting the same error, Please let me know How did you solve this problem. because i have also unchecked "uniqure records" in DSO settings, but i have one secondary non-unquie index.

I am looking forward for your help.

Thank you very much.

Ravi,