Skip to Content
0
Aug 04, 2023 at 01:18 PM

Unexpected Error on joining in remote tables from Success Factor

257 Views

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