IBM Support

Report with Union query fails: CLI0125E Function sequence error. SQLSTATE=HY010

Technote (troubleshooting)


Problem(Abstract)

When running a report containing a UNION on DB2, an error message occurs.

Symptom

Original Error: 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 'fetch' [IBM][CLI Driver] CLI0125E Function sequence error. SQLSTATE=HY010 UDA-CUR-0000 Unable to fetch the row.


Environment

Windows Server 2003 DB2 Connect v8.1.9.917 fixpack 9

Resolving the problem

Set the 'use WITH clause when generating SQL' governor for the model in Framework Manager

Document information

More support for: Cognos Business Intelligence
Framework Manager

Software version: 10.2, 10.2.1, 10.2.2

Operating system(s): AIX, Windows

Reference #: 1365844

Modified date: 15 February 2011


Translate this page: