Troubleshooting tips

Problem	Solution
When the component tries to establish connection with Informix server the following error message appears: "COM subsystem detected an error while performing a query execution within the Lookup in DB filter's operation. Report: IDispatch error #3092. Details: [Informix][Informix ODBC Driver][Informix]A syntax error has occurred. Error code: 0x80040E14."	This error appears when one system variables is absent or has invalid value. To solve this problem, perform the following steps: Open Advanced tab of the System properties on the machine, where workflow server is running. Open Environment variables at the bottom of the Advanced tab. Add or edit DELIMIDENT variable in the System variables group. This variable should contain "n" value. See more about meaning of this variable for the work with Informix in the IBM Informix 11.70 information center.

Problem

Solution

When the component tries to establish connection with Informix server the following error message appears:

"COM subsystem detected an error while performing a query execution within the Lookup in DB filter's operation. Report: IDispatch error #3092. Details: [Informix][Informix ODBC Driver][Informix]A syntax error has occurred. Error code: 0x80040E14."

This error appears when one system variables is absent or has invalid value. To solve this problem, perform the following steps:

Open Advanced tab of the System properties on the machine, where workflow server is running.
Open Environment variables at the bottom of the Advanced tab.
Add or edit DELIMIDENT variable in the System variables group. This variable should contain "n" value.

See more about meaning of this variable for the work with Informix in the IBM Informix 11.70 information center.