Post reply

Insert Error

  • January 5, 2012 at 3:18 am

    #100431

    Hi Guys,

    I have a procedure which reads XML and insert values in to 1 Table.

    If i execute it from DB i will execute but from App i am getting the below error.

    Line 35: INSERT 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.

    Please help me in fixing this issue.

    Thanks in advance.

    Regards,

    Vijay

  • January 5, 2012 at 3:36 am

    #1428866

    http://msdn.microsoft.com/en-us/library/aa259212%28v=sql.80%29.aspx

    The above link explain what arithabort does.

    It is not the cause of the problem but just a setting telling SQL what to do when it faces a issue.

    If your shredding the xml and then storing the values in the DB then you need to verify if any parts of the data exceeds to limits for the datatype . e.g inserting 1027867 into a tinyint column etc.

    Jayanth Kurup[/url]

  • January 5, 2012 at 4:19 am

    #1428887

    Hi,

    I checked the query by parsing XML and inserting rows into table but i dint get any warnings or errors. I checked even the table structure and it looks fine. If i execute the Procedure from back end its working fine. its giving the error only while debugging from dot .net.

    Please advice.

    Thanks,

    Vijay

  • January 11, 2012 at 12:36 am

    #1431597

    You might want to check with a .net expert in that case , I guess there is a mismatch between the data types being used by the app to that of the database. system.data.sqltypes

    Jayanth Kurup[/url]

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply