Errors: AS/400 & ODBC after upgrade to the Operating system

Troubleshooting

Problem

After upgrading the AS/400 the following errors may be received in Impromptu: DMS-E-GENERAL, A general exception has occurred during operation 'asynchronous open'. [IBM][Client.Access/400 ODBC Driver] [DB2/400 SQL] SQL7008-not correct operation Or [Showcase Corp][Showcase ODBC][AS400] Program has ended 0X0046 Error #-9 DMS-E-GENERAL, A general exception has occurred during operation 'attach database' Unable to connect to data source Or DMS-E-GENERAL, A general exception has occurred during operation 'prepare request'. DMS-E-DBPARSER, The underlying database detected an error during processing of the SQL request. [IBM][Stuurprogramma Client Access/400 ODBC]Syntaxisfout. or Error #5: DMS-F-BUGCHECK An internal system failure has occurred during operation fetch. EMS-E-ODBC_INTERNAL, An Internal error (ODBCerror9) has occurred within the ODBC gateway

[{"Product":{"code":"SSTQPQ","label":"IBM Cognos Series 7 PowerPlay"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Impromptu","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"Impromptu 2.0","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Historical Number

51891

Was this topic helpful?

Document Information

Modified date:
09 May 2025

UID

swg21352043

Tips