problem Sync HQ Client

HI... I have a store that until 2 days ago was makin it's 401 wrkhst sync properly. Suddenly it started to failed this syncronization giving me the following error: "Cannot insert the value NULL into column quantitycommited, table .dbo.itemdynamic ;column does not allow nulls. Update fails Update Itemdynamic set quantitycommited =itemdynamic.snapshot..." The stores that sync with this database work well....

Thanks in advance for your help.

Reply to
ROD
Loading thread data ...

some record in your hq or store database is missing a value. You should be able to fix the hq record with this command on the hq database:

update itemdynamic set quantitycommitted=0 where quantitycommitted is null

or the store record with this command on the store database:

update item set quantitycommitted=0 where quantitycommitted is null

The problem is that that k> HI... I have a store that until 2 days ago was makin it's 401 wrkhst sync

Reply to
Matt Hurst

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.