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