cancel
Showing results for 
Search instead for 
Did you mean: 

Sync Errors

Former Member
0 Kudos
63

I am getting over 2000 of these sync errors. Not sure what to check but nothing from SBO is loading into Ecommerce.

The INSERT statement conflicted with the FOREIGN KEY constraint "FK_OrderExpenses_OrderExpensesMaster". The conflict occurred in database "B1WebTools", table "dbo.OrderExpensesMaster", column 'ExpenseCode'.

The statement has been terminated.

at netpoint.api.data.DataFunctions.ExecuteScalar(String SQL, IDataParameter[] parameters, String connectionstring)

at netpoint.api.NPBase.Save(Boolean logTransaction)

at NetPoint.SynchSBO.SBOObjects.SBODocument.AddExpenses(Documents document, NPOrder order)

at NetPoint.SynchSBO.SBOObjects.SBODocument.SBO_2_NP(Documents& document, NPOrder order)

at NetPoint.SynchSBO.SBOObjects.SBOOrder.SBOToNetPoint(SBOQueueObject qData)

at NetPoint.SynchSBO.SynchObjectBase.Synch()

Thanks in advance!

Adam Hairston

Sitka Inc.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

I will check those and reply back.

Thank you!

Adam Hairston

Sitka Inc.

Former Member
0 Kudos

Paulo;

Down to just 1005 errors! Going in the right direction.

Unsure of how to do what was recomended in the below:

*2. Please also check that catalog chosen as synch catalog in synchmanager

contains a category with a code used for an item group in Business One.*

I do not see a place to choose a synch catalog in synchmanager.

Thanks for your assistance.

Former Member
0 Kudos

The expense mapping should have done the trick...

What are the other errors?

Former Member
0 Kudos

Now I am going the wrong way...back up to over 2000 sync errors. I have rechecked all the mappings and they appear correct. We have more pricelists than what the admin guide shows so perhaps that is the problem? I do have all 4 pricelists that are in the admin guide.

Not sure what to start with. Here is a copy of one of the errors:

The INSERT statement conflicted with the FOREIGN KEY constraint "FK_PartsPricing_PartsPricingMaster". The conflict occurred in database "B1WebTools", table "dbo.PartsPricingMaster", column 'PriceListCode'.

The statement has been terminated.

at netpoint.api.data.DataFunctions.ExecuteScalar(String SQL, IDataParameter[] parameters, String connectionstring)

at netpoint.api.NPBase.Save(Boolean logTransaction)

at NetPoint.SynchSBO.SBOObjects.SBOPricelist.SynchPrices(String sboConnectionString, NPConnection wtConnection, String where, IDataParameter[] parameters)

at NetPoint.SynchSBO.SBOObjects.SBOItem.SynchPrice(String itemcode)

at NetPoint.SynchSBO.SBOObjects.SBOItem.SBOToNetPoint(SBOQueueObject qData)

at NetPoint.SynchSBO.SynchObjectBase.Synch()

Former Member
0 Kudos

I think you mean expense mappings that are in the admin guide?

Anyways, it looks like from the SQL error that the synch is trying to add a pricelist that is already present.

If you login to the web tools admin and go to Sales - Pricelists, are the pricelists in B1 listed?

Former Member
0 Kudos

No pricelists shown.

I have double checked the pricelists in SBO and they are coded according to the administrators guide.

In sync manager I do not have a price list table. I have the following:

Opportunity

Weight

Length

Expenses

Thanks,

Adam

Former Member
0 Kudos

Down to 6 sync errors at present.

5 related to specific invoices which I will go check. However, 1 error I am unsure of where to check:

Index was outside the bounds of the array.

at netpoint.api.data.DataParameters.Add(NPDataType dataType, String parameterName, Object parameterValue)

at NetPoint.SynchSBO.SBOObjects.SBOLastEvalutatedPricelist.AddPrices(SecurityTicket ticket)

at NetPoint.SynchSBO.Synch.SynchAll2()

I am hoping that once these errors are resolved I can login to the website to start configuration.

Thanks in advance!

Former Member
0 Kudos

Hi

Could you please check the following:

1. If the Expenses are mapped correctly:

In SynchManager > Tables > Expenses, please check that all

Business One Entries have a Webtools Code to map to.

If one is missing a mapping it would cause errors.

Please use the code as reffered in the Administrator Guide as follow:

shipping

handling

paymentmethod

2. Please also check that catalog chosen as synch catalog in synchmanager

contains a category with a code used for an item group in Business One.

Paulo Calado

SAP Business One Forums Team

1.

2.

Catalog chosen as synch catalog in synchmanager didnt contain

a category with a code used for the item group in B1

initially created catalog, 'online catalog' was removed