Author Topic: DB2 RQP-DEF-0177 UDA-SQL-0107  (Read 6683 times)

Offline chriskat

  • Full Member
  • ***
  • Join Date: Jul 2010
  • Posts: 5
  • Forum Citizenship: +0/-0
DB2 RQP-DEF-0177 UDA-SQL-0107
« on: 27 Jul 2010 03:37:38 am »
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.

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 10,769
  • Forum Citizenship: +642/-10
  • Cognos Software Muppet
Re: DB2 RQP-DEF-0177 UDA-SQL-0107
« Reply #1 on: 27 Jul 2010 05:50:02 am »
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!

Offline chriskat

  • Full Member
  • ***
  • Join Date: Jul 2010
  • Posts: 5
  • Forum Citizenship: +0/-0
Re: DB2 RQP-DEF-0177 UDA-SQL-0107
« Reply #2 on: 28 Jul 2010 09:15:49 am »
Thanks it helps....

 



       
Twittear