Usage Import Fails with Arithmetic Overflow Error for Data Type Smallint

ID: Q243674

The information in this article applies to:

Microsoft Site Server version 3.0, Commerce Edition
Microsoft Site Server version 3.0

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.

RESOLUTION

To resolve this problem, obtain the latest service pack for Site Server 3.0. For additional information, please see the following article in the Microsoft Knowledge Base:

Q219292 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.

Additional query words:

Keywords : SS3SP3Fix
Version : winnt:3.0
Platform : winnt
Issue type : kbbug