Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Initialize and Run Sync error

The INSERT statement conflicted with the FOREIGN KEY constraint "FK_PartsCategory_PartsMaster". The conflict occurred in database "B1WebTools", table "dbo.PartsMaster", column 'PartNo'.

The statement has been terminated.

at SQL, IDataParameter[] parameters, String connectionstring)

at NetPoint.SynchSBO.Synch.AddItemToCategory(String itemCode, Int32 npCategoryID)

at NetPoint.SynchSBO.Synch.MergeB1ItemsToWT(Int32 npCategoryID, String npCategoryName)

at NetPoint.SynchSBO.Synch.PopulateOnlineCatalogItems()

at NetPoint.SynchSBO.Synch.SynchAll2()

This error occurs just prior to the one above

SBOInventory | Part or warehouse does not exist in NetPoint | SBOToNetPointDetail(01) | OITW/OITM | 01/K-VRS

I have checked the tables and all appear to exist.

Former Member
Not what you were looking for? View more on this topic or Ask a question