Could not handle join condition

[Former Member]

Hi Friends,

I am facing below error in the analytical view, though this looks familiar to me but unable to nail down the actual problem i have in Analytical view.

ERROR [S1000] [SAP AG][LIBODBCHDB32 DLL][HDBODBC32] General error;2048 column store error: search table error:  [2999] Error initializing joins: Could not handle join condition ""JOIN_TABLEA_TABLEB_6_JOIN_TABLEA_TABLEB_7_concat"

The actual analytic view has TABLEA in its data foundation joined as N:1 with attribute view ( TABLEB) using referential join. As far as I know TABLEB has duplicate records which makes the cardinality to throw the above error . In contrast ,when I checked TABLEB everything looks good in TABLEB and no duplicates and still throws this error.

Please let me know if anyone has faces this error and help me how this can be fixed.

Thanks

Kumar

[Former Member]

Hi Kumar,

I ran into the same exact error and ran out of all troubleshooting steps. Can you please provide the solution if you already got it.

Thanks

Suresh

[former_member226419]

Hi,

Can you please show the table and your model with screenshot?

Just want to see the contents if data is not much huge.

BR

Sumeet