RFC destination for SAP BW is not maintained in source system

Today I encountered a return code 8 (RC=8) when a datastore object (DSO) was transported to the quality environment. Knowing that other transports were already imported successfully the error message below looked a bit odd to me.
RFC destination for BW is not maintained in source system
The error message indicates that there is something wrong with the RFC connection. With this message in mind I checked transaction SM59 to verify if everything was setup properly. Everything looked fine. Also the partner profiles, configured by using WE20, were correct.

After searching (again…) on the SCN website I bumped in to this thread, where table RSLOGSYSDEST is mentioned. The thread describes that the issue could be caused by the references found in this table. In my case record BWQ010 should point to destination BWQ010. As seen in the screenshot below the values were not aligned.
RSLOGSYSDEST difference in LOGSYS and DESTINATION
In order to align these values it is necessary to restore the BI source system in BW. After this action was executed the entries in table RSLOGSYSDEST were changed to the right values! It’s as simple as that!

Joury Jonkergouw

Joury Jonkergouw

Business Intelligence consultant a.k.a.a.k.a. Data Ninja, Blogger & Enthusiast. Experience in various SAP business processes. Believes strongly in a future where analytical EIM and Data Governance are the key to success.