Error when activate Data in DSO

[former_member811290]

Hi all,

I got the error below when activating Data in DSO :

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

The note i follow for this problem:

https://answers.sap.com/questions/10730086/unique-data-records-option-in-dso.html

Result: if am loading the data to DSO and activating the request the records move to active table and if there exist same records it just overwrites those records. So hence we can say that there will not be any duplicate records in the active table.

Also, the option "Unique Data Records" is only exist in BW4HANA as far as I know.

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

This is the sap note for this problem :

SAP Note 1943633 - SYSTEM_CANCELED upon activation of a Data Store Object (DSO) request

I followed the steps in this SAP Note :

Resolution

Please check the indexes via transaction SE14 or transaction DB02 and create/rebuild them as required...

Right click on the DSO -> Manage -> Contents -> Active Data -> Copy the name of the table from the top of the screen.

Go to transaction SE11 (Data Dictionary Tables, DD) -> Enter DSO Active Table name -> Display -> Indexes.

Go to transaction SE14 (Database Tables, DB) -> Enter DSO Active Table name -> Edit -> Indexes -> Double-click on the Primary Index -> Check the Status.

Determine if the index exists in both the data dictionary and at database level and also that it is consistent. If it does not exist in either one of the transactions, then recreate the DD or DB object. If it is inconsistent, please delete and recreate in both the DD and the DB. Please see SAP Note 117219 for further considerations.

Alternatively, you can check via transaction DB02 -> Click Diagnostic Node -> Click Missing Tables and Indexes.

Result: But I did not find any index neither in Data Dictionary Tables or Database Tables

• There is a technical problem on Database

I don’t know what to do in this part

Please any idea to resolve this ?

Thank you