Submit a ticketCall us

Get a crash course on Network Monitoring delivered right to your inbox
This free 7-day email course provides a primer to the philosophy, theory, and fundamental concepts involved in IT monitoring. Lessons will explain not only how to perform various monitoring tasks, but why and when you should use them. Sign up now.

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: 221 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
02:52, 23 Jun 2016

Tags

Classifications

Public