Failed to retrieve data from the database. Details: 42S22: DataDirect ODBC Progress OpenEdge Wire Protocol driver OPENEDGE Column IGAMApplicantID cannot be found or is not specified for query. 13865 Database Vendor Code: -210074

When running a Crystal report directly in Crystal the error, "failed to retrieve data from the database. Details: 42S22:[DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Column "IGAMApplicantID" cannot be found or is not specified for query. (13865)[Database Vendor Code: -210074]" occurs when there is no 'IGAMApplicantID' field or column visible in the SQL nor in the report itself.

In FIMS, this issue presents itself as the error, 'Failed to retrieve data from the database. Details: [Database Vendor Code: -210074].

 
To resolve this, rebuild SQL Views by completing the following steps:

Note: When running this tool, all other users need to be logged out of FIMS except the person running the tool.

1. Run FIMS | Tools | System Utilities | SQL Tools| SQL Views & Widths Configuration. The tool runs fairly quickly when none of the options are checked.



2. Restart FIMS in order to apply the changes.



 

Steps to Duplicate

Running the report directly in Crystal Reports:

1. Open Crystal Reports Business Objects
2. Open the report in question
3. Click on the Refresh button
4. Provide credentials to log into the data source; Host Name, Port Number, Database Name, User ID and Password
5. Click OK
6. See error occur.

Running the report in FIMS:
1.  Go to Custom
2.  Select the report in question from the menu
3.  Enter in the parameters to run the report such as date from and date to
4.  See error occur, ''Failed to retrieve data from the database. Details: [Database Vendor Code: -210074].'
 

Environment

 FIMS

Was this article helpful?


Thanks for your feedback! Did this solve your issue?

Comments (optional):


Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):


Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.