Skip to Content
0

SQL Analytic Privileg with Procedure has activation issues in SP10

Jan 17, 2017 at 07:47 PM

275

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

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

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

Please check 2293984 which explains more about this issue.

Share
10 |10000 characters needed characters left characters exceeded