cancel
Showing results for 
Search instead for 
Did you mean: 

SQL Analytic Privileg with Procedure has activation issues in SP10

0 Kudos

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 .

Regards,

Goutham

Accepted Solutions (0)

Answers (1)

Answers (1)

0 Kudos

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

Please check 2293984 which explains more about this issue.