Skip to Content
0
Feb 06, 2020 at 08:50 AM

Column View generated automatically does not work

1064 Views

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