No active PSA table for DataSource ***** and source system ***** found

[former_member601185]

Hi all,

I have Process chain containing 3 steps:start variant,load data,data store data.

It is running daily and data store data step is failed.

Now the data is in psa and new table in dso.

If I manually activate data in dso the data is moving from new table to active table but still showing in new table.

And in SM37 I'm getting below error:

No active PSA table for DataSource ***** and source system ****** found

Could you please help me.

Regards,

Krishna sindhuja

[Private_Member_484518]

Check table RSTS, OBJSTAT=INA. If you find your ExportDatasoure of the DSO you need to activate the DSO again.

Either transport the DSO Object and transformations from development system or use report RSDG_ODSO_ACTIVATE to activate the DSO.

After the activation there should be no entry for the ExportDataSource in table RSTS. Don't forget to activate transformation again (RSDG_TRFN_ACTIVATE).

[Sriram2009]

Hi Krishna.

Check this thread about the same issue

https://answers.sap.com/questions/9182184/no-active-psa-table-for-datasource-8gdbxxx-and-sou.html

Regards

SS

[shanthi_bhaskar]

PSA name/ODS changelog table will change from one system to another.