Hide this message
Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.
This article provides brief information and steps to resolve the following error after SAM polling:
Error while executing script-Hint 'noexpand' on object 'dbo.APM_MultivalueAlertsDataInternal is invalid
All SAM versions
This is caused by a view getting created without an Index.
Information: From MSDN documentation:
When SET NUMERIC_ROUNDABORT is ON, an error is generated after a loss of precision occurs in an expression. When OFF, losses of precision do not generate error messages and the result is rounded to the precision of the column or variable storing the result.
SET NUMERIC_ROUNDABORT must be OFF when you are creating or changing indexes on computed columns or indexed views.
In SQL Management Studio, ensure the highlighted box (Numeric Round Abort) is clear, as illustrated below:
To check this setting without SQL Management Studio, the following script can be used:
--define the table structure
IF OBJECT_ID('tempdb..#UserOptions', 'U') IS NOT NULL DROP TABLE #UserOptions
CREATE TABLE #UserOptions ( name VARCHAR(100), minimum INT, maximum INT, config_vale INT, run_value INT)
--Retrieve the data
EXEC sp_configure 'User options'
SELECT CASE WHEN run_value & 8192 = 8192 THEN 'Enabled' ELSE 'Disabled' END FROM #UserOptions