Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
exec QS_Databases - 8115: Arithmetic overflow error converting expression to data type
설명
Error:
-------------------------------------------------------------------------------- Product: Spotlight on SQL Server 5.6.0.539 -------------------------------------------------------------------------------- Message: An error occurred while refreshing the table "SQLDatabaseList" in connection "IMATCHPR".
* Click OK to continue, * Click Ignore to ignore any further errors related to this table, or * Click Disconnect to close this connection. -------------------------------------------------------------------------------- Details: 11/27/2007 12:53:28 PM exec QS_Databases 8115: Arithmetic overflow error converting expression to data type int. 3621: The statement has been terminated. (Connection "IMATCHPR") --------------------------------------------------------------------------------
What were you doing leading up to this point?
해결 방안
Upgrade your SoSS 5.6.0 to SoSS 5.7.
There was a case where we had INT instead of BIGINT/NUMERIC(28,0) This could be the reason for the overflow error.
You can download Spotlight on SQL Server 5.7 from supportlink:
1) Go to http://support.quest.com/ and login. 2) Click on "Downloads & Updates" 3) Type "Spotlight on SQL Server" for the product and click "Go". 4) Under "Products", click on 5.7 for the version. 5) Click on the link "Spotlight on SQL Server version 5.7 Installer " to download the product.