Error in BODS ETL job: ODBC data source error message for operation

Symptom:

Error when executing a BODS job with database views as a source with incorrect definition in one of the view. The job will run for some time and fetch some records from the database view, but will error out after some record count

Error: ODBC data source <10.194.32.46> error message for operation <SQLFreeStmt>: <>.

Environment:

SAP BODS Version: 4.2 SP4

DATABASE VERSION: SQL Server 2008 R2

Cause: One of the columns in the view has an incorrect definition at the query level

You can check this by doing a select distinct on the column which gives error. You will get the below error message:

Error: Msg 512, Level 16, State 1, Line 1

Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

Resolution: Correct the definition of the view for the column which is returning incorrect value with the help of DBA team.