Deleting Vendors

Forum Forums D-Tools General Forum Bugs Deleting Vendors

This topic contains 2 replies, has 2 voices, and was last updated by  Naresh 4 months ago.

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #13077

    jimmy Wright
    Participant

    Why I try to delete an old/duplicate Vendor, the following error occurs.

    The DELETE statement conflicted with the REFERENCE constraint “FK_Products_Clients”. The conflict occurred in database “SystemIntegrator”, table “dbo.Products”, column ‘VendorID’. The statement has been terminated.

    #13078

    Naresh
    Moderator

    Hi,

    This issue will be fixed in our next release SI 2018.
    If you need an immediate fix let us know and we can organize a server build for you.

    The issue relies with products assigned a Proffered Vendor deleting the vendor does not check this SQL relationship.

    Regards,

    Naresh

    #13079

    Naresh
    Moderator

    Hi,

    This issue has been fixed. Updated your SI Server with this link for SI 2017 R3 –
    http://downloads.d-tools.com/si/2017R3/SIServer.exe (version 6.11.2496.0)

    Naresh

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

You must be logged in to reply to this topic.