Report with Union query fails: CLI0125E Function sequence error. SQLSTATE=HY010
When running a report containing a UNION on DB2, an error message occurs.
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.
Windows Server 2003 DB2 Connect v126.96.36.1997 fixpack 9
Resolving the problem
Set the 'use WITH clause when generating SQL' governor for the model in Framework Manager
More support for:
Cognos Business Intelligence
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: