Skip to Content
author's profile photo Former Member
Former Member

error in sap b1

hi friends,

while i am log in the manager user in the server i am getting below error. it is happen only server

"[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert the value NULL into column 'logInstanc', table 'SBO_MAGNA_LIVE.dbo.AUSR'; column does not allow nulls. INSERT fails. '' (AUSR)"

is it make any problem????

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    Posted on Oct 31, 2012 at 01:29 PM

    Hi Ramesh

    Check this

    1653119 - Error when update or logon into the application

    Symptom

    1. When you try to update any information in any Business One (B1) object you get an error 'This Entry Already Exists in the Following Tables "(AXXX)(ODBC - 2035) [ Message131-183]'.
    2. One or more users try to connect to SAP Business One and get the following error message:

    [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert the value NULL into column 'logInstanc', table '[DATABASE_NAME].dbo.AUSR'; column does not allow nulls. INSERT fails. '' (AUSR)

    Cause

    Application error

    The log instance field in the history tables of all Business One objects is a 16-bit integer field with maximum value 32767. Every time the object is changed, a record will be written to the history table with the log instance number increased by 1. Hence if the object is changed too frequently, the log instance number will exceed the upper limit of the 16-bit integer field and overflow. This probably happens when you are using some add-ons which change the B1 object automatically.

    Solution

    SAP intends to provide a patch or patches in order to solve the problem described.

    The section Reference to Related Notes below will list the specific patches once they become available.

    The corresponding Info file of the patches in SAP Service Marketplace will also show the SAP Note number.

    Please note that these references can only be set at patch release date.

    SAP will deliver patches only for selected releases at its own discretion, based on the business impact and the complexity of the implementation.

    Header Data


    Released On 15.11.2011 12:56:17 Release Status Released for Customer Component SBO-BC System Priority Correction with medium priority Category Program error

    References

    This document refers to:

    SAP Business One Notes

    1596532 Cannot insert the value NULL into column 'LogInstanc'

    This document is referenced by:

    SAP Business One Notes (4)

    1681770 Overview Note for SAP Business One 8.81 patch 11 1596532 Cannot insert the value NULL into column 'LogInstanc' 1660887 Overview Note SAP Business One 2007 A SP01 PL 17 1665806 Overview Note for SAP Business One 2007 B Patch 26
    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 31, 2012 at 03:02 PM

    Hi,

    What is your B1 version and PL? You may upgrade to a new version to avoid such error.

    Thanks,

    Gordon

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 29, 2013 at 02:39 AM

    Hi Ramesh,

    This is issue fixed in 8.81 PL11. Please refer SAP note 1653119

    Thanks & Regards,

    Nagarajan

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 31, 2012 at 11:03 AM

    Hi Ramesh......

    It seems something is internally damaged to the Database.

    Is that happening when your any of the Addon is running?

    Or is that happening to every client machine?

    Regards,

    Rahul

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.