Friends, if you could advise in solving this issue, I'll greatly appreciate it. Working on the weekend and dealing with
this issue and next week I have to show a demo.
1) I have a Case Table created in DB2 DB (Done)
2) Used Framework to create the Subject Query (Done)
3) Published Package to Cognos Content (Done)
Looks good so far,
Opened Report Author or Query Studio:
Tried dragging one of the Case columns (Case_ID) to a List.
Getting an ugly error:
UDA-SQL-0107 A general exception has occurred during the operation "prepare".[IBM][CLI Driver][DB2/NT64] SQL0551N The statement failed because the authorization ID does not have the required authorization or privilege to perform the operation. Authorization ID: "SYSTEM". Operation: "SELECT". Object: "JSMITH.CASE". SQLSTATE=42501
Thank you in advance for your time. :( :(
Hi gosoccer,
"does not have the required authorization or privilege to perform the operation" looks like a privilege issue. Did you succesfull test the metadata in FM (Connection and test of the query subject)?
I assume you receive this error with every object of the package, right? What kind of permissions does the db user have which you used for the cognos db connection?
Yep - looks like a permissions problem to me too. As Charon suggests, look carefully at the permissions your database user has in the underlying DB2 database - the error seems to suggest that your user does not have privileges to select from the table or tables you are reporting over.
Cheers!
MF.
Thank you guys. After 6 hours of troubleshooting, it all came to this which is specific to DB2.
In DB2, there some DBADM privilages that must exist in order for the Cognos Tool to work correctly. Weird!!
GRANT DBADM ON DATABASE to SYSTEM
http://stackoverflow.com/questions/28929634/ibm-data-studio-cant-browse-data-on-sample-db2-express-c (http://stackoverflow.com/questions/28929634/ibm-data-studio-cant-browse-data-on-sample-db2-express-c)
Thx so much! >:( :o :'( :)