Error: 'Error importing the finder file: The conversion of the nvarchar value '12345678901' overflowed an int column. The statement has been terminated.' when uploading a finder file with a 10 digit finder number + check digit.

Adding a finder file with an 11 digit finder number including check digit (10+1) gives an error on upload: 'Error importing the finder file: The conversion of the nvarchar value '10101781358' overflowed an int column.The statement has been terminated.' This occurs when you try to upload the finder file. This is an exclucive issue for 10 digit finder numbers with the check digit enabled and does not affect finder numbers of different lengths.
Download and install the latest version and patch, if applicable. 

Environment

 2.93
 3.0.516

Was this article helpful?


Thanks for your feedback! Did this solve your issue?

Comments (optional):


Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):


Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.