2 Replies Latest reply on Jun 17, 2014 1:35 AM by user13450231

    EIM Delete fails with error SBL-EIM-00107: ODBC error 37000



      While running an EIM delete of Products, we encounter an error:


      Error SBL-EIM-00107: ODBC error 37000:[Microsoft][SQL Native Client][SQL Server]DELETE failed because the following SET options have incorrect settings:
      'CONCAT_NULL_YIELDS_NULL, ANSI_WARNINGS'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or filtered indexes and/or query
      notifications and/or XML data type methods and/or spatial index operations.


      Can anyone help out regarding the reason for this error?

      This job had run fine on the dev environment however on QA we are getting this error.

      the EIM table status shows 'DELETED', however the actual record does not get deleted from database.