Submit a ticketCall us

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.

 

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, last modified by MindTouch on Jun 23, 2016

Views: 101 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