Skip to Content

[258]: insufficient privilege: [2950] user is not authorized - Calculation View

Hi

A user is getting this error while accessing a calculation view: "Error: SAP DBTech JDBC: [258]: insufficient privilege: [2950] user is not authorized".

I tried the troubleshooting steps in SAP note 2433916, the output in the IndexServer trace file is:


[52432]{333895}[58/-1] 2017-07-20 16:37:10.199745 i TraceContext TraceContext.cpp(00952) : UserName=TESTUSER1, ApplicationUserName=ht1adm, ApplicationName=HDBStudio, ApplicationSource=csns.modeler.datapreview.providers.ResultSetDelegationDataProvider.<init>(ResultSetDelegationDataProvider.java:130);csns.modeler.actions.DataPreviewDelegationAction.getDataProvider(DataPreviewDelegationAction.java:339);csns.modeler.actions.DataPreviewDelegationAction.run(DataPreviewDelegationAction.java:279);csns.modeler.actions.DataPreviewDelegationAction.run(DataPreviewDelegationAction.java:133);csns.modeler.command.handlers.DataPreviewHandler.execute(DataPreviewHandler.java:70);org.eclipse.core.commands, StatementHash=0434df96fdc58c9cf212c106daa66392

[52432]{333895}[58/-1] 2017-07-20 16:37:10.199715 i Authorization XmlAnalyticalPrivilegeFacade.cpp(01330) : Authorization error: User TESTUSER1 is missing analytic privileges in order to access _SYS_BIC:TFR/TESTDATA_MAX There aren't any AP's defined for that view.

[52432]{333895}[58/-1] 2017-07-20 16:37:10.199766 i Authorization ceAuthorizationCheckImpl.cpp(00419) : AuthorizationCheckHandler::isAuthorizedToSelect (AP check): (Original) User TESTUSER1 is not authorized on _SYS_BIC:TFR/TESTDATA_MAX (t -1) due to XmlAP check

[52432]{333895}[58/-1] 2017-07-20 16:37:10.199905 i Authorization XmlAnalyticalPrivilegeFacade.cpp(01330) : Authorization error: User TESTUSER1 is missing analytic privileges in order to access _SYS_BIC:TFR/TESTDATA_MAX There aren't any AP's defined for that view.

[52432]{333895}[58/-1] 2017-07-20 16:37:10.199999 i Authorization XmlAnalyticalPrivilegeFacade.cpp(01330) : Authorization error: User TESTUSER1 is missing analytic privileges in order to access _SYS_BIC:DiBo.Financials/VERSION There aren't any AP's defined for that view.
[52432]{333895}[58/-1] 2017-07-20 16:37:10.200056 i Authorization XmlAnalyticalPrivilegeFacade.cpp(01330) : Authorization error: User TESTUSER1 is missing analytic privileges in order to access _SYS_BIC:DiBo.Financials/PERIOD_NAME There aren't any AP's defined for that view.
[52432]{333895}[58/-1] 2017-07-20 16:37:10.200123 i Authorization XmlAnalyticalPrivilegeFacade.cpp(01330) : Authorization error: User TESTUSER1 is missing analytic privileges in order to access _SYS_BIC:DiBo.Financials/COST_OBJECT There aren't any AP's defined for that view.
[52432]{333895}[58/-1] 2017-07-20 16:37:10.200168 i Authorization XmlAnalyticalPrivilegeFacade.cpp(01330) : Authorization error: User TESTUSER1 is missing analytic privileges in order to access _SYS_BIC:DiBo.Financials/LINE_ITEM There aren't any AP's defined for that view.

[52432]{333895}[58/-1] 2017-07-20 16:37:10.200412 e SqlOpt_ceqo Ce2qoUtils.cc(00903) : Ptime Exception: insufficient privilege: [2950] user is not authorized : occurred while unfolding _SYS_BIC:TFR/TESTDATA_MAX

Not sure what Auth is missing, please assist?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Sep 08, 2017 at 11:59 AM

    Hi Peter

    It was a bug in the database on version 12.04, we fixed it by re-activating all the affected views then upgrading to 12.11.

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 07, 2017 at 03:17 PM

    Hello Willem,

    were you able to fix your issue? I am facing a similar problem. Even the full Analytical privilegues profile does not work. Is there something wrong in the view definition?

    UPDATE: I was able to solve this by accident for me now. I reset the the "Apply Privilege" to <blank> and then back to original value <Classic Analytical Privileges>. Suddently it worked without changing anything else. Hopefully it works for you too - however this is not a fix and seems like a bug in the database which should be reported.

    Add comment
    10|10000 characters needed characters exceeded