Initialize and Run Sync error

[Former Member]

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 netpoint.api.data.DataFunctions.Execute(String 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]

it appears that this may have been caused earlier in the installation when the "Install Plug In" step was missed. When the install plugin button is now pushed the error generated is:

Completed InstallPlugin with unhandled error:SBO_SP_TransactionNotification exists but does not contain code that is recognizable to Webtools.

The Webtools synch queue code will have to be manually added.

I see on page 19 of the admin guide that "If you have modified the transaction notification stored procedure (SP_TransactionNotification) in the SAP Business One database or installed a plug-in that modified it, back up this procedure. Installing the plug in overwrites this stored procedure. With a copy of it, you can merge the changes made by SAP Business One E-Commerce and Web CRM with those from existing customizations or add-ons."

I don't believe that the transaction was modified by Webtools. What code should be added to the stored proc?

[Former Member]

add the following code to the SBO_SP_TransactionNotification

IF (ISNUMERIC(@object_type) = 1)

BEGIN

INSERT INTO PRX_Transaction_Queue (

object_type,

transaction_type,

num_of_cols_in_key,

list_of_key_cols_tab_del,

list_of_cols_val_tab_del

) VALUES(

@object_type,

@transaction_type,

@num_of_cols_in_key,

@list_of_key_cols_tab_del,

@list_of_cols_val_tab_del

)

END

[Former Member]

fixed this part, now onward and upward