Usage Import Fails with Arithmetic Overflow Error for Data Type Smallint (243674)
The information in this article applies to:
- Microsoft Site Server 3.0 Commerce Edition
- Microsoft Site Server 3.0
This article was previously published under Q243674 SYMPTOMS
The Usage Import tool may fail with the following error message:
[Microsoft][ODBC SQL Server Driver][SQL Server]Arithmetic overflow error for data type smallint, value = 32768
The following error message may appear in the Uimport.log file:
uimport 7/3/99 9:42:55 PM
Error: Internal Microsoft error
Error querying the Import job. [Microsoft][ODBC SQL Server Driver][SQL Server]Arithmetic overflow error for data type smallint, value = 32768.
[Microsoft][ODBC SQL Server Driver][SQL Server]Arithmetic overflow error for data type smallint, value = 32768.
CAUSE
The tblImportParamLinkVP field VPID is linked to IDENTITY in the tblImportParamVP table, as soon as it exceeds 32768, SQL server overflows.
RESOLUTIONTo resolve this problem, obtain the latest service pack for Site Server 3.0. For additional information, click the following article number to view the article in the
Microsoft Knowledge Base:
219292 How to Obtain the Latest Site Server 3.0 Service Pack
STATUS This problem was first corrected in Site Server 3.0 Service Pack 3.
| Modification Type: | Major | Last Reviewed: | 6/28/2004 |
|---|
| Keywords: | kbbug kbfix kbQFE KB243674 |
|---|
|