Hi,
Has anyone come across this error before. Recently two of our shops started to show error in 401 worksheet and never get complete.
First it get timeout and then following error shows.
Error-2147217873 - Cannot insert the value Null into column "Quantitycommitted . (screen shots)
- I checked Quantitycommitted in store level & itemdynamic in HQ and there are not Null value in those tables.
*This post is locked for comments
Just not sure i see the solution to the problem in the replies above.
I have the same issue with a new store. Is there a temp table in the store that i have to clear out or is the problem in HQ.
Thanks
Shane
Oh yeah i got it! right! :D
You encountered a connection error while creating the temporary table where the data has been selected and uploaded. Since there are no communications between client and server, the transactions rolled back and no temporary table has been created. The time when the server calls the temporary table, there is no such thing as update/insert happened like the one display in the screen but, the server could not find the temporary table.
First you need to check what makes the sync throws an error.
Based on your attachment, you encountered connection error (internet, sql locks etc. etc) which makes transactions failed. Make sure internet are stable and store database are in normal state. Retry sync. If the next error comes out, check or analyze the data itself.
If you wanna catch the record causes it, you can run series of queries and analyze data.
Try to run the following query:
SELECT ItemLookupCode ,
Quantity ,
QuantityCommitted ,
*
FROM Item
WHERE DBTimestamp > ( SELECT MAX(Servertimestamp)
FROM dbo.TimeStampLog
)
Since it was stucked in itemdynamic table, i guess you got a problem while inserting a new item in hq but the so called item got no quantitycommitted which throws this error.
Can you run this SQL in your store database and show us the result?
Select [ID], ItemLookupcode, [Description],[QuantityCommitted] from [Item]
where [QuantityCommitted] is null
I have this error in the syncronization: Error: 2147217873 Cannot insert duplicate key rowin object"dbo Customer"with unique index"IX"_Customer_SocialSecurity" How can I solved this error. Please provide detailed instructions.
also I think it creates a TEMP table and that temp table is not created right.. in the app itself
yes of course, does restarting SQL server help ?
from the DBNAME.dob.TABLE I see you could be running SQL 2008 ?
try a restart and backdate a 401.. does it work once , twice ?
You mentioned that the quantitycommited column has no nulls. I would like to note that checking this in Store Operations Administrator, any nulls would show up as 0 for SQL columns that are set up as numbers instead of text. You will need to run the script through SQL Management Studio, or revise the script to look for entries that are not in the QuantityCommitted.
First I would try running a re-index and then a Check in SO and HQ Admin.
Seems like we saw this in early versions on RMS, what are you running?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,902 Super User 2024 Season 2
Martin Dráb 229,297 Most Valuable Professional
nmaenpaa 101,156