Error while executing BEx Query on Composite Provider

[former_member401488]

Hi,

We have a BW on-HANA system, patch level SAPKW73105.

We have created a Composite provider based on the union of two DSOs, two infoobjects, one SPO, and there are a couple of joins with two other DSOs, on the top of that we built a BEx query.

While executing the BEx query, sometimes (depending on the filter values), We got the following error message

"Attribute engine failed;Error executing physical plan: exception 6900: AttributeEngine/Parallel/Dime..."

"Error 6,900 has occurred in the BWA/SAP HANA server"

"Error reading the data of InfoProvider @3ZSDRPCP5"

"Error while reading data; navigation is possible"

"Row: 59 Inc: MAP_TREX_EXCEPTION Prog: CL_RSDRH_TREX_STORAGE"

(Attached error message)

Ii We browse the composite provider data using the "display data" option in the RSA1, data is displayed without issue, the problem only appears during the BEx query execution and only with some filter vaues.

Any idea on how to fix the issue.

Thanks,

Federico

[former_member401488]

Thank you guys, I'll suggest to the customer to go to SP08 at least.