Skip to Content
Author's profile photo Arun Sasi

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


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 <> error message for operation <SQLFreeStmt>: <>.


SAP BODS Version: 4.2 SP4


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.

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.