Data inconsistencies have been detected in the database. Your data may be damaged.

SOLVED

I have trying sample application with Sage SDK in C# to create a new customer using DataBase utility. Using the SDK utility to insert a new customer record using " insert into table_name ....." , it was inserted successfully but after this when I open sage 50 application with Universal Database the  warning message has showing. How to solve this.

  • 0

    Hi,

    Probably the sample application did not damage the database, because it comes pre-damaged from the factory - like a 'distressed' faux antique.

    The 'Universal' sample company file as installed, will give you that warning the first time that you run the database verifier. The logs of what the database verifier did, are in your local 'Documents' or 'My Documents' folder, under Simply\DbVerifier\Logs.   They're plain text files.

    I'm guessing (because I don't work for Sage, and haven't asked) that this is intentional, so that the sample data can be used to demonstrate, or to test that the database verifier is installed and working properly.

    If you restore a backup of the sample data from before you ran the verifier, or do a 'change' / 'repair' reinstallation of Sage 50 to remove and reinstall the sample files, and run the DB verifier twice, it should not give you a warning the second time.  

    Then you're good to go, for testing with the SDK.

    I hope that helps, please post back!

    Randy

  • 0
    verified answer

    Sorry, re-read the post after my first answer, you need to increment the value for the customer table in tNxtPIDs if you insert a record.

    The software detected that the highest record ID in tCustomr was not less than the value for table ID 50 (tCustomr) in tNsxPIDs.

    The error message is similar to what you get if you run the table verifier.

    It's safer to use the SDK's methods.   See 'SDKExample.cs' in the c# folder, in the 'AddLedgersExample' region

  • 0 in reply to RandyW

    Thanks RandyW, The tnxtpids table contains the next id for each table. I missed the update while inserting records. Now this warning message not appeared!