We have a report we created in Report Studio using Cognos 8.2
It is based on a Framework published from the Cognos Planning system.
Sometimes when we run the report, we get the error below.
The environment is Windows 2003 and SQL Server 2005.
Any help would be appreciated.
Terry
172.21.16.67:9300 4100 2007-05-09 11:33:51.608 -5 0 0 2980 QOS 1166 1 Audit.RTUsage.QOS <message code="-9" severity="error" title="QE-DEF-0459 CCLException" type="general">RQP-DEF-0177 An error occurred while performing operation 'sqlAOpen' status='-9'.
UDA-SQL-0107 A general exception has occurred during the operation "sqlAOpen".
</message>
172.21.16.67:9300 4100 2007-05-09 11:33:51.608 -5 0 0 2980 QOS 1166 1 Audit.RTUsage.QOS <message code="-9" severity="error" title="QE-DEF-0459 CCLException" type="general">RQP-DEF-0177 An error occurred while performing operation 'sqlAOpen' status='-9'.
UDA-SQL-0107 A general exception has occurred during the operation "sqlAOpen".
</message>
172.21.16.67:9300 4100 2007-05-09 11:33:53.405 -5 C5E6593228A7A8B6FC43D78BDE36686582A70811 8hMvh4lyqqs8qsj8h9vyhwss2yvM498hwlGlwlhs wl2qwqG8q498lsj84s8Msvw224h9hv4s4899j4hG 2940 RSVP 1198 1 Audit.RTUsage.RSVP Response Failure RQP-DEF-0177 An error occurred while performing operation 'sqlAOpen' status='-9'.UDA-SQL-0107 A general exception has occurred during the operation "sqlAOpen".
172.21.16.67:9300 4100 2007-05-09 11:33:51.639 -5 C5E6593228A7A8B6FC43D78BDE36686582A70811 8hMvh4lyqqs8qsj8h9vyhwss2yvM498hwlGlwlhs 8hMvh4lyqqs8qsj8h9vyhwss2yvM498hwlGlwlhs 2980 RSVP 1198 1 Audit.RTUsage.RSVP Response Report /content/package[@name='Statistical Gross Margin']/folder[@name='Volume Reports']/report[@name='Sales Volume By Item Class With Summaries'] Failure RQP-DEF-0177 An error occurred while performing operation 'sqlAOpen' status='-9'.UDA-SQL-0107 A general exception has occurred during the operation "sqlAOpen".
Cognos 8.2 has gotten a bit pickier (for good and secure reasons I think?) in how queries are written in Report Studio.
Run your queries in the query explorer individually. You should hopefully see a less generic error that maybe will point to a specific item(s). That error popped up a lot when we were doing any calculation with query items in that query. You may need to define the aggregation types within the calc itself.
Example
if you are saying that [query item 1] - [query item 2] you may need to redefine it as
aggregate([query item 1]) - aggregate([query item 2]) and then define the query item as a calculation. This forces cognos to do a very specific function when making this calculation. This helped us out very much in solving our problems when migrating to 8.2.
I also made another post that may offer a suggestion as well. It in response to a posting called "query works with list but not with "
That error you are getting is basically a generic error from the Cognos engine. Definitely start with dissecting your queries individually.
The report is based on a number of queries that are unioned and joined.
Sometimes the report works and other times I get the error.
If I run the whole query using SQL Server Management Studio (natively on the server), the query runs fine with no errors.
If I use the "View Tabular Data" option in Report Studio, the data is returned back with no issues.
I also sometimes get this error message on the same report, so I don't know if they are connected.
Terry
172.21.16.67:9300 4100 2007-05-10 08:46:45.451 -5 0 0 3544 QOS 1166 1 Audit.RTUsage.QOS <message code="-28" severity="error" title="QE-DEF-0459 CCLException" type="general">RQP-DEF-0177 An error occurred while performing operation 'sqlOpenResult' status='-28'.
UDA-SQL-0114 The cursor supplied to the operation "APICursor::OpenResult" is inactive.
UDA-SQL-0107 A general exception has occurred during the operation "{0}".
</message>
172.21.16.67:9300 4100 2007-05-10 08:46:45.451 -5 378E1561904FE0F080B961C8B57FDFF60ADD43BC wq9Ghsj924qqyM4wsls8yyd248jvlhl88dljyqCh wq9Ghsj924qqyM4wsls8yyd248jvlhl88dljyqCh 3544 RSVP 1198 1 Audit.RTUsage.RSVP Response Report /content/package[@name='Statistical Gross Margin']/folder[@name='Volume Reports']/report[@name='Sales Volume By Item Class With Summaries'] Failure RQP-DEF-0177 An error occurred while performing operation 'sqlOpenResult' status='-28'.UDA-SQL-0114 The cursor supplied to the operation "APICursor::OpenResult" is inactive.UDA-SQL-0107 A general exception has occurred during the operation "{0}".
172.21.16.67:9300 4100 2007-05-10 08:46:45.435 -5 0 0 3544 QOS 1166 1 Audit.RTUsage.QOS <message code="-28" severity="error" title="QE-DEF-0459 CCLException" type="general">RQP-DEF-0177 An error occurred while performing operation 'sqlOpenResult' status='-28'.
UDA-SQL-0114 The cursor supplied to the operation "APICursor::OpenResult" is inactive.
UDA-SQL-0107 A general exception has occurred during the operation "{0}".
</message>
172.21.16.67:9300 4100 2007-05-10 08:46:45.435 -5 0 0 3544 QOS 1166 1 Audit.RTUsage.QOS <message code="-28" severity="error" title="QE-DEF-0459 CCLException" type="general">RQP-DEF-0177 An error occurred while performing operation 'sqlOpenResult' status='-28'.
UDA-SQL-0114 The cursor supplied to the operation "APICursor::OpenResult" is inactive.
UDA-SQL-0107 A general exception has occurred during the operation "{0}".
</message>
172.21.16.67:9300 4100 2007-05-10 08:46:45.451 -5 378E1561904FE0F080B961C8B57FDFF60ADD43BC wq9Ghsj924qqyM4wsls8yyd248jvlhl88dljyqCh wq9Ghsj924qqyM4wsls8yyd248jvlhl88dljyqCh 2940 RSVP 1198 1 Audit.RTUsage.RSVP Response Report Failure RQP-DEF-0177 An error occurred while performing operation 'sqlOpenResult' status='-28'.UDA-SQL-0114 The cursor supplied to the operation "APICursor::OpenResult" is inactive.UDA-SQL-0107 A general exception has occurred during the operation "{0}".
Terry
Did you ever get a solution to this - I am having the same problem and can't find what's wrong...
I'm also getting this error when I'm trying to connect to a VVM DSN for the first time that points to an MSSQL database.
I setup the ODBC connection on Windows to the VVM(Linux)and it failed with this error when testing: See attached image
So I left that and tried making adding the data source via Framework Manage anyway and got this error:
RQP-DEF-0177 An error occurred while performing operation 'sqlOpen' status='-9'.
UDA-SQL-0107 A general exception has occurred during the operation "AOpen".
Unable to execute: SELECT catalog_name AS TABLE_CAT, schema_name AS TABLE_SCHEM, table_name AS TABLE_NAME, table_type AS TABLE_TYPE, annotation AS REMARKS, cast(null as VARCHAR) AS TYPE_CAT, cast(null as VARCHAR) AS TYPE_SCHEMA, cast(null as VARCHAR) AS TYPE_NAME, cast(null as VARCHAR) AS SELF_REFERENCING_COL_NAME, cast(null as VARCHAR) AS REF_GENERATION FROM /services/databases/system/ALL_TABLES WHERE datasource_name='CardSwipe' AND (table_type='TABLE' OR table_type='VIEW' OR table_type='SYNONYM') ORDER B