Hi,
We currently have two environments which I will summarize below. After a HANA db upgrade from version 95 to version 102 all views which have descriptions added to an attribute now produce an error about authorizations.
Environment Overview:
Non Prod:
- HANA DB version 102
- SBOP 4.1 SP7
- Office Analysis 2.2 Sp3.1
- Lumira 1.30
Prod:
- HANA DB version 95
- SBOP 4.1 SP7
- Office Analysis 1.4 SP7
- Lumira 1.30
It is worth noting that when making the move to Analysis 2.x and upgrading your hana system, you no longer can use ODBC to connect to HANA. We have our non prod environment configured to use HTTP connection with SAML SSO through SBOP. This is working great with no problems. The issue we are facing is that any attribute in a view which has a description mapped to it fails with the error: Caught exception : exception 42111: SQL Error : insufficient privilege: Not authorized at ptime/query/checker/query_check.cc:3389 (42014)
If I connect to our non prod hana database using the odbc connection method and analysis 1.4 SP7 not issues or errors are thrown and the descirptions are displayed as normal. If I switch to Analysis 2.2 SP3.1 and use the HTTP connection I get the authorization error which I noted above. .
I have done further testing and found Lumira 1.30 connects to non prod hana ( direct connect not HTTP) and works fine producing the attributes and descriptions with out error. Has anyone else encountered this error? I have not found any SAP notes or blogs with this problem. I do have a case open with SAP but currently no traction.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.