on 01-17-2017 7:47 PM
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
Yes you are right. This issue is resolved in SPS11 forward.
Please check 2293984 which explains more about this issue.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
70 | |
26 | |
9 | |
9 | |
7 | |
6 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.