BI Source system already exist

[Former Member]

Hi

I already have an ECC system connected to my BI system in RSA1.

But now i want to connect one more ECC system to my BI system

When i go in RSA1 --> source system -->SAP-->give the RFC and user details and then try to create a connection it gives an error that source system already exist.

I checked with my BI resource and he conformed that we can have more than one ECC system connected to BI system

Can someone let me know how to do that

Thanks

Tushar

[former_member185239]

Hi Tushar,

You have to remove the entry from RSSOURSYSTEM and then retry the steps.

Follow the below sap note and link

187479 - Assigning several source systems to the same ID

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/70a7b233-8be5-2c10-4190-aed723af5...

http://joeysbasisblog.blogspot.com/2013/01/connecting-two-bw-systems-to-same-ecc.html

Defining Source Systems and Connecting SAP BW to OLTP Systems (SAP Library - Configuration Content f...

With Regards

Ashutosh Chaturvedi

[alejandro_queredamartinez]

Hello Tushar,

Check here:

BR,

Àlex

[Former Member]

Hi Alex,

In table RSSOURSYSTEM I have a different system source sysid assigned to 2 ECC systems.

I am trying to add source system UG1CLNT200 , but when i click on create and provide details it says t error "souce system already exist"

Also when i click on RSA1 source system i do not see UG1CLNT200 there

Any clue why ?

Thanks

Tushar

[Reagan]

I believe this is due to the fact that there is an entry called UG1CLNT200 present in the table RSSOURSYSTEM which is preventing you from creating the source system called UG1CLNT200 in Tx RSA1. I would try removing the entry called UG1CLNT200 from the table RSSOURSYSTEM using the view V_RSSOURSYSTEM in Tx SM30 and see if that helps.

Tx SM30 - V_RSSOURSYSTEM

Also check the tips given in the SAP note 1850890 - Source System ID not found

Regards

RB

[Former Member]

Hi RB,

this is what i am doing

i run t code RSA1 and go to source system.

Then right click on SAP and click on create

Then i  enter the RFC and user details

Then it pops up in UG1(ECC system ) login screen and asks to enter with admin user

The it pops up below screens

When is click on use i get below error

R3SBP200 being other ECC source already connected to BI system

[former_member185239]

Hi Tushar,

Is UG1 is a copy of R3SBP200?

Kindly paste the screenshot of RSBASIDOC of UG1.

With Regards

Ashutosh Chaturvedi