datasphere intelligent lookup - error: No deployed version available

[morhardc]

Hi there,

in SAP Datasphere I created an intelligent lookup with two tables

• input: local table (Big Rock List)
• lookup: remote table (Accounting General Data in Customer Master), data is replicated
• rule: exact match with names, no case sensitivity deselected

After deployment I run the lookup and get an error: No deployed version available

But for sure, both tables are deployed.

Any idea, what is wrong?

[allenyeung]

I encountered the same, with different tables though, even for those previously without such error. Would it be caused by Datasphere update?

[morhardc · Accepted solution]

Today following solution has been provided by SAP

Dear Customer,

I am happy to inform you that the fix for the issue reported in this customer case has now been implemented and is planned to be available via SAP Datasphere wave 2024.07. The fix will be available to you immediately upon RTC of the wave. Please see note 2984828 regarding the planned availability of the fix. Please ensure to refer the column indicating the availability of the content without needing activation. Also, please be advised that in the case of any changes to the planned wave availability schedule, this note will be updated in advance. Hence, kindly ensure to check the note for updates on a regular basis.

[TuncayKaraca · Accepted solution]

@morhardcThanks for the update. It's so really a bug. It's good to hear that it will be fixed in wave 2024.07 on March 26, 2024.

[bohdan_kureshov]

Have same issue (error and some matching casses) when try to reproduce example of Intelligent Lookup from SAP blog.
Initially both sources are views based on remote tables. When I had changed both sources to local tables (incl. loading data from remote to local via data flow) - everything OK. But when I use views created on top of the local tables - I get that error again.

[morhardc]

Same here as well. In the meantime I opened a ticket to SAP

[morhardc]

Today 'solution' for the ticket arrived, I'll paste it below:

[TuncayKaraca]

Hi @morhardc,

Probably Accounting General Data in Customer Master or the other input one has not deployed yet! You may check and deploy again. 

Regards,
Tuncay

[morhardc]

Hi @TuncayKaraca, thank you for swift reply. But this I checked first and for sure, both tables are properly deployed.

[TuncayKaraca]

@morhardcThen maybe --I think that's the case-- some other dependent objects of these two inputs are not deployed yet!  Check out from top to down all dependencies! All objects should be in deployed status in SAP Datasphere.

[morhardc]

@TuncaayKaraca, since I used tables, there is no dependency. And the tables are the origin and so the very first step in respective chain.

[morhardc]

@TuncayKaraca, since I used tables, there is no dependency. And the tables are the origin and so the very first step in respective chain.

[TuncayKaraca]

@morhardc, Even the tables are supposed to be deployed? Aren't they? Are they remote tables?

[morhardc]

@TuncayKaraca, as stated above, one table is remote table with replicated data, one is local table, both properly deployed. BR Christian

[TuncayKaraca]

@morhardc, Ok, I understand. Then it must be something else!

[morhardc]

one addition:

lookup is finding some matches ...