Skip to Content
avatar image
Former Member

SQL Analytic Privileg with Procedure has activation issues in SP10

Hi All ,

We have SQL AP with procedure throws error when we try activating it . What i saw is "_SYS_BIC" is getting added to DDL's condition provider clause , below is the error that we get.

Message : Repository: Encountered an error in repository runtime extension;Internal error: Failed to execute ddl statement: CREATE STRUCTURED PRIVILEGE "ztest_ng/AP_DY_TEST" FOR SELECT ON "_SYS_BIC"."ztest_ng/ZWHL_CV_MATERIAL_MOVEMENT_ANALYSIS_SAP" CONDITION PROVIDER "_SYS_BIC".""_SYS_REPO".ztest_ng::filters_ap"; Reason: ERROR [SQL-257] sql syntax error: incorrect syntax near """: line 1 col 156 (at pos 156) at ptime/query/parser/qp_gram.y:54151 exception 1: no.71000257 (ptime/query/parser/qp_gram.y:54151) incorrect syntax near """ NO exception throw location recorded. Stack generation suppressed.

Is it a problem only in SPS10 with procedure because same thing works in SPS12?

I executed the same statement in SQL console by removing the appended _SYS_BIC .



Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jan 17, 2017 at 07:54 PM

    Yes you are right. This issue is resolved in SPS11 forward.

    Please check 2293984 which explains more about this issue.

    Add comment
    10|10000 characters needed characters exceeded