Troubleshooting
Problem
When executing reports against DB2/400 V5R4 via the iSeries ODBC driver, errors occur on the majority of runs, particularly those where prompts are in use.
Symptom
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 "open result".
[IBM][iSeries Access ODBC Driver][DB2 UDB]PWS0005 - Error occurred in the i5/OS database server code
Cause
The root cause is determined to be the presence of support for Extended Dynamic Packages in the ODBC DSN. When diagnosing the issue, enabling tracing in the driver was sufficient to introduce a timing overhead which prevented the issue in the majority of cases, but disabling Extended Dynamic Packages was the ultimate successful solution.
Resolving The Problem
Edit the ODBC DSN and disable the Extended Dynamic Package support for the connection used by Cognos 10
Steps:- Open the ODBC Data Source Administrator via Control Panel
- Edit the properties of the relevant connection
- Click the 'Packages' tab in the driver
- Uncheck 'Enable extended dynamic (package) support'
- Click OK.
Historical Number
1027993
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21341194