Submit a ticketCall us

Have You Auto Renewed? If not, you're missing out.
The SolarWinds Renewal Program comes with a host of benefits including the most recent product updates, 24/7 technical support, virtual instructor-led training and more. Experience all of this with the convenience of Auto Renewal, and never worry about missing any of these great benefits. Learn More.

Home > Success Center > Server & Application Monitor (SAM) > Error while executing script-Hint 'noexpand' on object 'dbo.APM_MultivalueAlertsDataInternal is invalid

Error while executing script-Hint 'noexpand' on object 'dbo.APM_MultivalueAlertsDataInternal is invalid

Created by Aileen de Lara_ret, last modified by MindTouch on Jun 23, 2016

Views: 420 Votes: 0 Revisions: 3

Overview

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

 

Environment

​All SAM versions

Cause 

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.

Resolution

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
INSERT #UserOptions
EXEC sp_configure 'User options'
SELECT CASE WHEN run_value & 8192 = 8192 THEN 'Enabled' ELSE 'Disabled' END FROM #UserOptions

 

 

 

Last modified

Tags

Classifications

Public