If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

RQP-DEF-0326 when using sql

Started by sdf, 06 Nov 2018 07:11:38 AM

Previous topic - Next topic

sdf

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

MFGF

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.
Meep!

sdf

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.

:(

MFGF

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.
Meep!

sdf

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.


MFGF

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...
Meep!

sdf

Oh yeah.. I missed that! what a fool of me!  :P

Thanks MF!