ARITHABORT exception while calling SP using SQLAdapter RRS feed

  • Question

  • I am getting the following exception while invoking a stored proc(on SQL server 2005) which does some updates using SQL Adapter(of Adapter Pack2.0) on BizTalk Server R2.

    System.Data.SqlClient.SqlException: SELECT failed because the following SET options have incorrect settings: 'ARITHABORT'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or query notifications and/or xml data type methods.

    Same stored proc works fine when I test in the SQL Query Analyzer with same input parameter.
    Also, I observed that, the following statements get called by adapter before calling the SP

    -- network protocol: TCP/IP
    set quoted_identifier on
    set arithabort off
    set numeric_roundabort off
    set ansi_warnings on
    set ansi_padding on
    set ansi_nulls on
    set concat_null_yields_null on
    set cursor_close_on_commit off
    set implicit_transactions off
    set language us_english
    set dateformat mdy
    set datefirst 7
    set transaction isolation level read committed

    Looks like, these settings are set before invoking the SP. But I could not find any setting on Sql Adapter to set arithabort on.

    Would this issue be related to SQL instance or Database or WCF SQL Adapter?

    Has anyone faced similar issue and fixed in the past??

    Sr Consultant
    Tuesday, September 1, 2009 5:07 PM