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

DB2 RQP-DEF-0177 UDA-SQL-0107

Started by chriskat, 27 Jul 2010 03:37:38 AM

Previous topic - Next topic

chriskat

Hello guys!

I have been in trouble for a couple of days now.
I have recently installed Cognos Express and I use DB2 as datasource. From DB2, ADMIN can do any request and I have successfully add my database as a datasource of Cognos Express.

But in framework manager, when I try to build queries I always receive the message below :

RQP-DEF-0177 An error occurred during the execution of the operation 'sqlPrepareWithOptions' état = '-9'.
UDA-SQL-0107 An error occurred during the operation.
IBM][CLI Driver][DB2/NT] SQL0551N "ADMIN" has no privileges or rights required to perform the operation "SELECT" on object "JERRYVERSON.STAFF". SQLSTATE = 42501

Is it because Cognos Manager Admin and DB2 Adminhas the same username?

Any help will be appreciated.

Thanks in Advance.

Chris who is really in trouble.

MFGF

Hi Chris,

This seems to be saying that the User ID you entered when you set up the connection to DB2 from Cognos Express does not have any privileges to select data from your STAFF table within the database.

It's not a Cognos Express issue, it's a permissions issue within DB2. Does this thread help any in getting it sorted?

Cheers!

MF.
Meep!

chriskat