Submit a ticketCall us

AnnouncementsChange Is Inevitable

Get valuable help when it comes to tracking and monitoring changes. SolarWinds® Server Configuration Monitor (SCM) is designed to help you: detect, track, and receive alerts when changes occur, correlate system performance against configuration changes, compare server and application configuration against custom baselines, and verify application and system changes.

Learn more.

Home > Success Center > Server & Application Monitor (SAM) > SAM - Knowledgebase Articles > 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: 2,497 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