RSA1 Source System Hierarchy Issue (SRCTYPE of RSBASIDOC)

[Former Member]

Dear Experts,

Greetings to you all and thanks in advance for your valuable responses!

I am stuck here with a BW issue again. The issue is:

We have a DS connection, which earlier used to get displayed under DATASERVICES node, but I don't who/what changed what/how and now it gets displayed under External System. No matter what I do, it still stays there and due to this we are having issues in Data Extraction.

This our DEV system and in QA we don't have this issue. I don't know what/where to compare.

Earlier, I had the same display issue (but that was an R/3 system) which was solved by 1087980. Still I tried:

• Deleted the entry with  RSAP_BIW_DISCONNECT.
• Recreated the entry under Data Services node, but it still didn't work. It jumped back to External System.

I have compared the tables and found that the SRCTYPE in RSBASIDOC is responsible for all this it should be 'X' instead of 'B'.

Can we change this manually from SAP level? If yes, then how and if no, then is there any alternative?

Thanks,

Avishek

[former_member185239]

Hi Avishek,

Check whether the sapnote 1692642 - Data Services source system for 3.x DataSources

is relevant to your system or not.

If relevant , then apply it and  recreate the source system.

With Regards

Ashutosh Chaturvedi

[Former Member]

Dear Friend,

The note is not applicable in our system. We are already at a higher version of SAP_BW.

We are at level 9, and this note says corrections delivered in level 8 itself.

Thanks

[Sriram2009]

Hi Avishek

Are you getting any dump or error log during this process?

Regards

Sriram

[Former Member]

Any updates anyone? Been stuck on this for a while now..

[Sriram2009]

Hi

Just do the "restore" the data source connection.

refer the SAP Note 140276 - Error in source system assignment

Regards

Sriram

[Former Member]

Dear Sriram,

Sadly, this note wont work. I have tried RESTORE multiple times but to no avail.

I am more concerned with the SRCTYPE field in RSBASIDOC.

By the way, Thanks a ton for your response!

Thanks,

Avishek