HQ Client error -2147217873 Cannot insert the value null

(0) Share

Report

Posted on by Community Member

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.

0652.error1.JPG

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (1)

Jeff @ Check Point ... 13,382 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Shawn Meade on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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 ?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

also I think it creates a TEMP table and that temp table is not created right.. in the app itself

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

archelle16 1,743 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Verified answer

archelle16 1,743 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Shane O' Malley 388 on at

Like (0)

Report

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

Was this reply helpful? Yes No