Skip to Content
author's profile photo Former Member
Former Member

Will deletion of ECC client delete the datasource in BW?

Dear All,

Recently we deleted a few dummy clients in our ECC development system.

Our original golden config client for ECC is ED1 client 200.

Test system to load data was ED1 client 220.

We suspect that our BW system was built using the data sources from ED1 client 220, therefore when we deleted this client from ECC, the data flow in BW was affected causing the infopackage, datasource, transformation and DTP below the DSO to disappear as shown in the screen shot below.

The data flow ends at the DSO SIS Sales Forecast and there is no transformation, DTP, datasource or infopackage linked to this DSO.

Initially the data flow was as shown below.

Can anyone confirm that the missing data flow is due to the deletion of client 220 and provide some documentation evidence to prove that or is there any other reason which could have caused this issue?

Please advice.

Thank you very much!

Kind regards,

Rebekah

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Posted on Sep 17, 2015 at 09:09 AM

    Hi Sunil,

    at Bw side, RSA1-->data source, lets try to see, whether your data source is exist or not at respective source system.

    Even check at table levels. use tables - RSOSFIELDMAP or ROOSOURCE or RSOLTPSOURCE or RSDS.

    check table - RSLOGSYSMAP - whether its have source name as ED1 220 or not.

    check whether it shows PSA table for your data source at bw side. table -RSDSTS.

    Even check data source exist in Active version or not?

    Are you sure about actions at bw side, No one deleted your data flow by mistake?

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 17, 2015 at 09:23 AM

    Hi Sunil,

    When you delete a source system in BW, you will, for sure, delete all transfer rules, transformation, PSA (etc.) linked to this system source.

    However I don't think the deletion of an ECC client (on ECC) will have the same impact. Is the system source corresponding to the deleted client still existing in your BW ? did you delete it ?

    Regards,

    Frederic

    Add a comment
    10|10000 characters needed characters exceeded

    • Anyway, your system is now not usable. Before deleting the ECC client, you should have copied all the transformations you don't want to loose to one of the remaining ECC client (a transport can do this kind of thing).

      At this time, I don't think you can easily restore the lost objects. The only way I can think of is to transport all the lost objects from your QUA or PRD to your DEV.

      Regards,

      Frederic

  • author's profile photo Former Member
    Former Member
    Posted on Sep 17, 2015 at 02:46 PM

    Can you see your data sources and source system (ED1CLNT200) in RSA1?

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.