Data source inactive after the upgarde

[Former Member]

Hello,

The BI system has been upgarded from SP11 to SP25. After successful SP implementation, the connection has been restored, activated and metadata replicated successfully. But the datasources are all in modified state and thus inactive. The standard as well as custom data sources are inactive.

The DTPs are also missing, though transformations are active.

What needs to be done and is there a program to reactivate the datasources??

Regards,

KP

[Former Member]

You can use RSDS_DATASOURCE_ACTIVATE_ALL to activate the datasources.

And are your DTP's really gone, or just not displayed?

[Former Member]

Hello 2X U,

The DTP are gone. I cant see them in RSA1. The transformations are also inactive.

Kindly help.

Regards,

KP

[Former Member]

activate the datasources using the program mentioned above.

To activate transformations use program RSDG_TRFN_ACTIVATE (see note 1408161).

About your DTP's: I think they are still there, but not displayed.  You can check the DTP tables (RSBKDTP for example).

I'd first activate the DS & TRFN, and see if the DTP's show up.