Hi
I have selected the checkbox "External SAP HANA View" on my composite provider, the view is created on our HANA, but when I try to get data from it I get the error that says I dont have privileges to execute it, when I run the
CALL SYS.GET_INSUFFICIENT_PRIVILEGE_ERROR_DETAILS ('6BFC8A9B93F73A49827CC97E91AF504D',?)
the PRIVILEGE column is empty.
So I opened the CV and went to the base table, which in this case is
"SAPHANADB"."0BW:BIA:ZPM_CP02:QO"
And when I try to SELECT * FROM "SAPHANADB"."0BW:BIA:ZPM_CP02:QO"
i get the following error.
SAP DBTech JDBC: [2048]: column store error: search table error: [34023] Instantiation of calculation model failed;exception 306002
Our basis tried to execute it as well, no luck, so I'm ruling out access problems.
So the COLUMN VIEW generated automatically by BW4HANA has a problem in it, and I cant figure it out, can you guys help me?
We have BW4HANA 2.0. I have tried multiple Composite providers, and all of them comes back with the same error.
Best
Leandro