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.

[ikirilova1 · Accepted solution]

After setting SDI blending it didn't work as well. Then we created an official incident to SAP and the solution was importing these two notes:

2889356-SAP BW 7.5 - SAP Analytics Cloud - removal of result-based size limitation

2817234 - BW 7.5 - SAP Analytics Cloud OOC aggregation (formula) - part II

[mfoeken]

Hi Ivelina,

Can you share a screenshot of how you blended the models in SAP Analytics Cloud?

Kind regards,

Martijn van Foeken | Interdobs

[ikirilova1]

Edit: Sorry for the many comments, but I was unable to add all the pictures in one.

1. Before blending

[ikirilova1]

2. Linking

2.jpg

[ikirilova1]

The lined model is shown

3.png

[ikirilova1]

3. After trying to add the measures from Daily sales as columns

4.jpg

[mfoeken]

Hi Ivelina,

Are you linking based on id or description in screenshot 2.jpg?

Kind regards,

Martijn van Foeken | Interdobs

[ikirilova1]

Hi Martijn,

I link Cal year/month and Rayon by ID. Plant short name is currently linked by description, but I also tried by ID (description = ID in its case). Budget is on a cube, which is a part of the composite provider, so the fields are based on the same infoobjects.

[mfoeken]

Hi Ivelina,

Do you see anything in BW when you execute this request in terms of error messages or warnings?

Kind regards,

Martijn van Foeken | Interdobs

[ikirilova1]

Hi Martijn,

the same errors show in RSTT trace with Message no. RS_EXCEPTION000.

I tried re-saving ZCKF_COUNT_SD_1 and activated the composite provider again. Activation finished with message that ZCKF_COUNT_SD_1 is consistent, but that didn't help.

Also, I noticed something else: lets say my models are Daily sales (based on that CP) and Budget (based on an infocube). When Daily sales is primary, after an attempt of blending the table shows the info only from Budget. When Budget is primary, the table shows the fields of Daily sales. And I always get the same error.

[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}