Unexpected Error on joining in remote tables from Success Factor

[satrajit_chatterjee]

Hi Experts,

During the process of developing reports (data models) in Datasphere, we have encountered an unusual issue. We are attempting to join multiple remote tables from Success Factor data sources. Unfortunately, we've discovered that only the full join is functioning correctly in the data builder. When we attempt to use Left Outer Join or Inner Join with two tables, we encounter the following error, preventing us from visualizing the data.

It's worth noting that the individual tables and views appear to be in perfect condition, and their data is visible without any problems.

------------------------------------------------------------------------------------------------------------------

Error information

-----------------------------------------------------------------------------------------------------------------

internal error: Error opening the cursor for the remote database Error parsing query: SELECT "RT_Per_Personal$VT"."customString22", "RT_Per_Personal$VT"."customString23", "RT_Per_Personal$VT"."firstName", "RT_Per_Personal$VT"."lastName", "RT_Per_Personal$VT"."personIdExternal", "RT_Per_Personal$VT4"."V1", "RT_Per_Personal$VT4"."V3" FROM ("PerPersonal" "RT_Per_Personal$VT" LEFT OUTER JOIN (SELECT "RT_Per_Email$VT"."emailAddress" AS "V1", "RT_Per_Email$VT"."personIdExternal" AS "V2", "RT_Per_Personal$VT5"."V1" AS "V3" FROM ("PerEmail" "RT_Per_Email$VT" LEFT OUTER JOIN

[XaviPolo]

When working with REMOTE sources, there are some limitations due to the remote source's own capabilities or due to the lack of implementation of certain features in DSP.

If the source does not allow you to apply your logic, you can always persist the data in DSP and then apply that logic (with all the possibilities offered by DSP or HANA DB).

Regards,

[vishalakshmi]

Hello Satrajit,

Can you recheck the joins creation?:

https://help.sap.com/doc/aa5cd4412124489490cb864a6139526c/cloud/en-US/DWC_Acquiring_Preparing_Modeli...

Thanks,

Lakshmi.