Unable to extract the data from ECC 6.0 to PSA

[Former Member]

Hello,

I'm trying to extract the data from ECC 6.0 data source name as 2LIS_11_VAHDR into BI 7.0

When i try to load Full Load into PSA , I'm getting following error message

Error Message: "DataSource 2LIS_11_VAHDR must be activated"

Actually the data source already active , I look at the datasource using T-code LBWE it is active.

In BI on datasource(2LIS_11_VAHDR) when i right click selected "Manage" system is giving throughing below error message

"Invalid DataStore object name /BIC/B0000043: Reason: No valid entry in table RSTS"

If anybody faced this error message please advise what i'm doing wrong?

Advance thanks

[Former Member]

it might help if you tell us which steps you already took... did you start the job control? did you fill the setup tables? ...

[Former Member]

ECC 6.0 side

Delete the setup tables

Fill the data into setup tables

Schedule the job

I can see the data using RSA3 (2LIS_11_VAHDR) 1000 records

BI7.0(Service Pack 15)

Replicate the datasource in Production in Backgroud

Migrate Datasource 3.5 to 7.0 in Development

I did't migrate 3.5 to 7.0 in Production it's not allowing

When i try to schedule the InfoPakage it's giving error message "Data Source is not active"

I'm sure this problem relate to Data Source 3.5 to 7.0 convertion problem in production. In Development there is no problem because manually i convert the datasource 3.5 to 7.0

Thanks

[Former Member]

ok, so you upgraded to 7.0

is your datasource active in BI (this is new in 7.0)?

go to RSA1

Modeling

DataSources

go to your specific DataSource & display it

my bet is that it's not active there... now, something I'm not getting from your situation... you migrated the DataSource in dev but not in prd?

that's asking for trouble...

[Former Member]

2LIS_11_VAHDR is active in ECC6.0

Also BI7.0 active.

When we replicate the data source in BI7.O source repliated as 3.X not 7.0 then i migrated into BI7.0 in Development box system never asked me the Transport request my question is how can we transport this migration step in production you can't do manually.?

Thanks

[Former Member]

display your datasource in BI (via Admin Workbench > Datasources)

follow menu path Extras > Object Directory Entry

if it's still on $TMP there, change it to a transportable Package