Hi,
Current environment is CA11.0.11. When trying to create a user defined sql. We got RQP-DEF-0326 error.
I'm checked and confirm that the roles were set with correct permissions.
In capabilities Report Studio, the roles have execute and traverse.
For User Defined SQL, the same roles have execute and traverse as well.
In Capability permission we have Directory Admin to have Set policy and Traverse.
Everyone group have traverse.
let me know if there are other things to check.
sdf
Quote from: sdf on 06 Nov 2018 07:11:38 AM
Hi,
Current environment is CA11.0.11. When trying to create a user defined sql. We got RQP-DEF-0326 error.
I'm checked and confirm that the roles were set with correct permissions.
In capabilities Report Studio, the roles have execute and traverse.
For User Defined SQL, the same roles have execute and traverse as well.
In Capability permission we have Directory Admin to have Set policy and Traverse.
Everyone group have traverse.
let me know if there are other things to check.
sdf
Hi,
For the Report Studio capability, the user/group/role needs to have the Traverse capability granted
For the User Defined SQL capability within Report Studio, the user/group/role needs to have Read and Execute capabilities granted.
From the looks of what you've posted, the permissions you have allocated for User Defined SQL are not quite correct?
Cheers!
MF.
QuoteFor the Report Studio capability, the user/group/role needs to have the Traverse capability granted
For the User Defined SQL capability within Report Studio, the user/group/role needs to have Read and Execute capabilities granted.
Hi MF,
Should it be traverse only for Report Studio capability?
I set the roles with Execute and traverse for Report Studio
then Read and Execute for the User Defined SQL.
Still gives the same error.
:(
Quote from: sdf on 06 Nov 2018 08:11:38 AM
Hi MF,
Should it be traverse only for Report Studio capability?
I set the roles with Execute and traverse for Report Studio
then Read and Execute for the User Defined SQL.
Still gives the same error.
:(
What is the source of your report? Are you using a package or a data module?
Cheers!
MF.
Actually I have no source setup yet for that report. I was just trying to check the feature.
I created a new report, then just created a blank query and drag an SQL object beside it.
Then double click on the sql, with no entry what so ever I just click validate.
Usually this would say that I have not yet set a datasource for this but instead I see errors saying
"user defined SQL not permitted for the user who has the identity '{ list of my groupsand roles."
This is happening even if I am a sys admin in cognos.
Quote from: sdf on 06 Nov 2018 09:26:15 AM
Actually I have no source setup yet for that report. I was just trying to check the feature.
I created a new report, then just created a blank query and drag an SQL object beside it.
Then double click on the sql, with no entry what so ever I just click validate.
Usually this would say that I have not yet set a datasource for this but instead I see errors saying
"user defined SQL not permitted for the user who has the identity '{ list of my groupsand roles."
This is happening even if I am a sys admin in cognos.
Try adding a package to the report and see if it makes a difference...
Oh yeah.. I missed that! what a fool of me! :P
Thanks MF!