Creating an import source in metric designer generates RQP-DEF-0177, UDA-SQL-0107 and Oracle errors

1

Symptom
RQP-DEF-0177 An error occurred while performing operation 'sqlUpdateAttach' status='-9'.
UDA-SQL-0107 A general exception has occurred during the operation "update attach".
ORA-20000: Operation failed. Error code ()
ORA-06512: at "COGNOS_MM.DEBUG", line 151
ORA-06512: at "COGNOS_MM.SET_SESSION", line 135
ORA-06512: at line 1

Problem
When creating an 'Import source' in Metrics Designer which is pointing to a Framework Manager relational package, gives the errors above. Metric Studio works without a problem.

Solution
Delete and recreate the Cognos 8 data source connection for the Metric Store.
Do not use roles to define capabilities, use simple GRANT statements or GRANT capabilities within Oracle Enterprise Manager.

 

www.cogknowhow.com