Report error message

[terry_stjean]

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 &apos;sqlAOpen&apos; status=&apos;-9&apos;.
UDA-SQL-0107 A general exception has occurred during the operation &quot;sqlAOpen&quot;.

</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 &apos;sqlAOpen&apos; status=&apos;-9&apos;.
UDA-SQL-0107 A general exception has occurred during the operation &quot;sqlAOpen&quot;.

</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".   

[larsonr]

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.

[terry_stjean]

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 &apos;sqlOpenResult&apos; status=&apos;-28&apos;.
UDA-SQL-0114 The cursor supplied to the operation &quot;APICursor::OpenResult&quot; is inactive.
UDA-SQL-0107 A general exception has occurred during the operation &quot;{0}&quot;.
</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 &apos;sqlOpenResult&apos; status=&apos;-28&apos;.
UDA-SQL-0114 The cursor supplied to the operation &quot;APICursor::OpenResult&quot; is inactive.
UDA-SQL-0107 A general exception has occurred during the operation &quot;{0}&quot;.
</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 &apos;sqlOpenResult&apos; status=&apos;-28&apos;.
UDA-SQL-0114 The cursor supplied to the operation &quot;APICursor::OpenResult&quot; is inactive.
UDA-SQL-0107 A general exception has occurred during the operation &quot;{0}&quot;.
</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

[jocarter]

Did you ever get a solution to this - I am having the same problem and can't find what's wrong...

[TROndrey]

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:

Code Select Expand

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