Unable to Activate DSO after System Copy

[Former Member]

Dear Experts,

Till last month we had only BW Production System (No BW Dev and BW QA).

We made a System copy of BW Production to BW Dev system, so that we can make changes in BW dev and transport to BW PRD.

So we tried to change the existing DSO in BW Dev System and when we are activating it we are getting Error Message "Transformation 0jXXXXXXX is inactive.Action can not be executed".

However the Transformation "0jXXXXXX" exists in BW PRD system. In BW Dev system, we have another transformation "0DXXXXXX" which is active.

I believe somewhere its pointing to BW PRD transformation.

Please kindly help.

Regards

[RamanKorrapati · Accepted solution]

Hi,

Due to the system copy logical mappings will be copied from ecc prod instead of ecc dev.

So seek basis team help and do proper logical mappings between ECC dev and BW dev.

Useful tables to check source/target systems.

RSLOGSYSMAP

RSLOGSYSDEST

RSBASIDOC

Once connections are established properly then you can do below steps.

1. Later replicate your data source from ECC Dev to BW dev.

2. Activate data source at bw side.

3. Continue to activate the rest of the data flow at bw side.

Thanks

[Former Member · Accepted solution]

Dear Raman,

The Table RSLOGSYSMAP is empty in BW Dev System.

The tables RSLOGSYSDEST and RSBASIDOC are filled with data (BW DEV & R3 DEV).

I think I need to maintain RSLOGSYSMAP in BW Dev System.

Can you please guide me what I need to maintain in RSLOGSYSMAP table.

Regards

Sam

[Former Member · Accepted solution]

Dear Raman,

The Entries of RSLOGSYSMAP in BW PRD is following

Original Source System- R3 DEV

Target Source System - R3 PRD

Regards

Sam

[RamanKorrapati · Accepted solution]

Hi.

at ECC/BE Dev servers table RSLOGSYSMAP need to have respective servers technical details.

Ask basis team they know it.

above table need to have source as ECC Dev technical name

Target as BW Dev technical name.

Just ask basis to team do the logical mappings or run Tx- BDLS.

Thanks

[RamanKorrapati · Accepted solution]

Maintain above table like below.

Original Source System- R3 DEV

Target System -BW Dev

[Former Member · Accepted solution]

Dear Raman,

I have done this but when I activate the DSO, still it gives the same error .

Regards

Sam

[RamanKorrapati · Accepted solution]

Hi,

After table maintenance.

Have you replicate data source into bw?

Have you activated data source at bw?

Later, see your data source/source system details under it.

whether still it shows prod or ecc dev as source instead of table level.

if data source was active then rest of data flow objects to need to make active.

Thanks

[adamjab1]

Hi,

Try: run program RSDG_TRFN_ACTIVATE with transaction se38 (this will let you reactivate transformations) than - reactivate DSO again.

Regards

[chanda]

As mentioned by Raman, only BI is copied and not ECC. because of this you will have issues at the data source level.

you will find the data source missing or not active .

Kindly check on this.

Thanks & regards,

Sudhir.

[former_member186053]

Hi,

What about other transformations, are they also have different technical names. Seems to be new technical name created for the same transformation in Dev when compared to Prod. you need to check the logical mapping of system names.

Regards,

Vengal.

[venkatanareshkumar_chittu]

Hi,

Sometimes transformation id's will be populated wrongly in the target system. Please check table - RSTRAN to check the link between the installed transformation and source transformation.

Also check with Basis team if they have mapped the logical system of Dev system to Dev R3 as this will also lead to problems. I believe they will be changing the logical system using BDLS t code.

Hope this helps.

Thanks