Error occurs while activating a 'Write Optimized' DSO.

[Former Member]

I am getting error " There is no PSA for infosource 'XXXX' and source system 'XXX' while activating a newly defined DSO object.

I am able to activate a Standard DSOs, however the error occurs while activating a 'Write Optimized' DSO

[former_member209728]

HI,

Steps mentioned in the note 518426 might help.

Solution

Execute transaction "RSSGPCLA".

Set the status of the programs belonging to program classes "RSDRO_ACTIVATE", "RSDRO_UPDATE" and "RSDRO_EXTRACT" to "Generation required".

To do this, select the program class and then activate the "Set statuses" button. Important: Reset the three named program classes only.

[former_member188080]

Hi,

Just look at following points

1. Check the data flow in case you have converted from 3.X to BI7?

2. Recheck data flow. See if you need to look into RSDS transaction for any conversion again.

3. Check in case you need to reactivate the complete data flow and if there is any issue occuring while reactivation?

Thanks and regards

[srikanthbwbw]

Hi,

For write optimised DSO, check if you have tick the uniqueness of the records. If you check that and if there are two same records coming from source in one go, then you will get error

From SAP help

You can specify that you do not want to run a check to ensure that the data is unique. If you do not check the uniqueness of the data, the DataStore object table may contain several records with the same key. If you do not set this indicator, and you do check the uniqueness of the data, the system generates a unique index in the semantic key of the InfoObject. This index has the technical name "KEY". Since write-optimized DataStore objects do not have a change log, the system does not create delta (in the sense of a before image and an after image). When you update data into the connected InfoProviders, the system only updates the requests that have not yet been posted.

Thanks

Srikanth

[Former Member]

Hi

do you have any data flow between this DSO and your info source(i mean transformations)

If you have try to activate it and replicate the data source once.

RSDS_DATASOURCE_ACTIVATE_ALL -- if data flow is SAP BI 7.0

RS_TRANSTRU_ACTIVATE_ALL -- in data flow is SAP BW 3.5

RSDG_TRFN_ACTIVATE -- activate transformation in SAP BI 7.0

Regards,

Venkatesh.