Article ID: 38711 KNOWN ISSUE: Error when running Monitor Packs for Servers Reports

<b>Article ID:</b> 38711

KNOWN ISSUE: Error when running Monitor Packs for Servers Reports

<b>Note:</b> If you are experiencing this particular known issue and wish to be notified of changes in the status of this issue, please subscribe to the article by clicking to the right of this article. As the status of this request is updated, subscribers will be notified of any changes and decisions that are made.

Applies To

• Monitor Solution 6.0

Problem/Symptoms

There was a SQL error while running some reports on Monitor Solution.

Description: Unexpected exception encountered while running a query.Report "Processor Utilization - Windows" Processor Utilization - Windows. ( Unhandled exception.  Type=Altiris.NS.StandardItems.Query.AeXSqlException Msg=Sql error in query. Error: System.Data.SqlClient.SqlError: ????? datetime ??????Sql CommandText:     -- MAX ROWCOUNT     SET ROWCOUNT 50000     --     exec pr_MonitorUniversalMetricReportSummary_v3   @pTableName = 'MonitorMetricLog',   @pSolutionName = 'Altiris Monitor Pack for Servers',   @pReportName = 'Processor Utilization',   @pOSName = 'Windows',   @pCollection = 'All Windows Computers with Monitor Agent installed

Environment

Notification Server 6.0 SP3 R6

Simplified Chinese Windows 2003

Simplified Chinese SQL 2000 or 2005

Monitor Solution 6.0.1337

Monitor Solution for Servers 6.0.2066      

Report Pack for Monitor Solution for Servers 6.0.1112      

Cause

The cause for this issue is still under investigation.

Resolution

Symantec is working towards a resolution and will update this article when a resolution is reached.

最近在客户测试Monitor 也遇到了这个问题，回来分析了一下，觉得应该是数据库时间格式的问题， 在服务器时间格式改成老美的，然后在数据库中运行下面语句：

ALTER LOGIN [SQLLoginHere]

WITH DEFAULT_LANGUAGE = us_english

执行，OK ，问题解决。

不过Monitor 6 现成的监控包比较少，7的就丰富很多，

最近新出的SP3  新增了 WS-MAN metric ，比较有意义的一个测量手段。

Added the WS-MAN metric

The WS-MAN metric uses the Web Services for Management (WS-Management) specification to poll data for metrics.

<b></b>赞

<b></b>收藏

<b></b>评论

分享

微博

QQ

微信

举报

上一篇：KNOWN ISSUE: Cannot type Chinese character in client chat window from the client machine.

下一篇：Altiris™ IT Management Suite 7 Release Notes