Cannot blend data from a specific composite provider using SAC with live connection

[#1]

Edit: the following now happens with various live connection models. The queries are based on different BW object types.

Edit 2 (26.11.2021): blending acts the same way when I try to blend BW live connection model with imported file directly in the story or with another model. based on Google drive import.

Hello,

I have problem blending data using a live connection model on a particular composite provider. Our system is BW 7.5 on Hana, SP 16 (last updated in Jan. 2020 with the most recent stable version by that date). We are using only live connection models. And, also, I am with the latest version of Chrome (86.0.4240.193 Official Build)

Blending basically works, but not with models based on queries from one specific CP. Its structure is attached

Let's say i want to put a table on a canvas page. When I first add the main model in a story it loads fine. I can link it with any other model - still no errors. But when I try to add measures or dimensions from the second model, the fields from the main one disappear and the table is filled with the measures and dimensions of the second model.

The log from Chrome's developer tools says Error during extraction.

InfoObject ZCKF_COUNT_SD_1 indeed included in the source query. I tried deleting the model and creating it again - it's the same. This error comes even if I use another query, which is based on the same CP.

I made separate models using queries on each of the InfoProviders . When I link them in a story everything blends just fine.

We have another composite provider, containing only the first two objects from the problematic one - blending works as well. I compared the main settings of the two CPs and I didn't find a difference.

The BW user I am using is with SAP ALL profile, and the SAC user is system owner so I don't think the problem is connected with authorizations.

I'll very happy if someone could help. I've searched in the community for something similar but I couldn't find a solution.

[mfoeken]

Hi Ivelina,

When you execute the scenario what is displayed in the 'network' tab with the developer tools? I assume the screenshot displayed is from the console tab, right?

Kind regards,

Martijn van Foeken | Interdobs

[ikirilova1]

Hello Martijn,

yes, the screenshot from the console tab. In the time of the error there, the network tab shows 3 times GetResponse:

1. {"Messages":[{"Type":2,"MessageClass":"","Number":0,"Text":"RS_EXCEPTION(000): InfoObject ZCKF_COUNT_SD_1 does not exist in version A","ExceptionClass":"","OlapMessageClass":0},{"Type":2,"MessageClass":"","Number":0,"Text":"RS_EXCEPTION(000): Error during execution","ExceptionClass":"","OlapMessageClass":0}]}

The status code is green, 200 OK

2. GetResponse with the grid of the secondary model

3. Again with the grid of the secondary model

And finally there is a queryStatistics response

{"message":"","stack":"","errorDetails":[],"status":200,"bUIMsg":false,"bWarning":false}