Problem when sync deliverys
I have received error after upgrade to PL12. Anyone know how to fix this ?
NPBase - more than one object found. at netpoint.api.NPBase.PopulateFromReader(String sql, DataParameters dp) at netpoint.api.NPBase.Fetch(String keys) at netpoint.api.commerce.NPOrderDetail..ctor(String synchid, NPConnection conn) at NetPoint.SynchSBO.SBOObjects.SBODelivery.SBOToNetPoint(SBOQueueObject qData) at NetPoint.SynchSBO.SynchObjectBase.Synch()
Deleting the duplicated orderdetail rows should be sufficient. But you will likely run into dependancy problems. You will also need to delete the payment attatched to the row and the delivery.
You should definitely examine the data first to guarantee that the data is in fact duplicate. The query I posted only tested for the same synchid. You need to confirm that everything else on the two records is also duplicate.
Alternately, you could delete all order detail in WT from the orders with duplicates. The B1->WT synch will correctly readd them all. If you do this, you must make sure these orders are in the B1 queue.
The query would take me a bit of time to write, if you are comfortable with SQL, you should be able to figure it out. Just be careful and make sure you test a couple one at a time before running the whole thing.
You can probably also limit this by paying attention to the the ones that are throwing errors in the synch. If this is a small number, you can probably do them all manually.