Microsoft KB Archive/243674

= Usage Import Fails with Arithmetic Overflow Error for Data Type Smallint =

Article ID: 243674

Article Last Modified on 6/28/2004

-

APPLIES TO


 * Microsoft Site Server 3.0 Commerce Edition
 * Microsoft Site Server 3.0 Standard Edition

-



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.



RESOLUTION
To 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.

Keywords: kbbug kbfix kbqfe KB243674

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.