N/APosted on - 07/14/2012
Hi, I have just started having this problem in two of our shops and I was wandering if anyone else has had the same problem. It is an error concerning the 401 worksheet. There is a timeout followed by this message.
Error-2147217873 – Cannot insert the value Null into column "Quantitycommitted…”, .
There are no null values in the Quantity committed in store level & itemdynamic in HQ
No null values in the Quantity committed in store level
I think you should do a thorough check on the worksheet specifically on the QuantityCommitted column. The NULL value mentioned in the error message means a blank or no value was declared or that there are no values inserted under the column QuantityCommitted of the worksheet.
If you are sure that this column doesn’t have any null values, meaning all fields of this column were completely filled then check again if any of these fields contain a “space” either before or after the inserted value.
Maybe the column doesn’t allow inserting a “space” or spaces in the value it contains.
You may also try checking your computer for any possible errors. Use a disk utility application to check the system. For a much thorough diagnostics test on your system, use disk utility applications like Norton Utilities, PC Tools Performance Toolkit, or Norton SystemWorks.
You may also try checking your machine for possible virus infection that is possibly affecting the functionality of your programs.