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.
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
Have something to add? Share your thoughts — no account required.
Ask the community — no account required