Client Management Suite

Hi all,

I have the same error as that of this article  http://www.symantec.com/docs/TECH170970

but the solution does not work.

My server is version 7.5 SP1

My SMP log ...

Unhandled exception.

Incorrect syntax near '-'.

Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.

[System.Data.SqlClient.SqlException @ .Net SqlClient Data Provider]

at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()

at System.Data.SqlClient.SqlDataReader.get_MetaData()

at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)

at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)

at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)

at System.Data.SqlClient.SqlCommand.ExecuteReader()

at Altiris.NS.DataAccessLayer.Implementation.Altiris_NS_ResourceManagement_DataAccessLayerRMDashboardDAL.spDataClassGetNonEmptyForResourceAsSet(Guid ResourceGuid, Int32 DataClassType)

at Altiris.NS.ResourceManagement.ResourceTypeDataClassTreeBuilder.Initialize(Hashtable commonArgs)

at Altiris.NS.Tree.TreeBuilder.GetBuilder(Guid treeId, Hashtable commonArgs)

at Altiris.Console.WebControls.UITreeUtils.GetTreeAsXml(Guid treeGuid, String startGuid, Hashtable urlArgs)

at Altiris.Console.WebControls.UITreeUtils.AddTreeNodes(Guid treeGuid, String startGuid, Boolean demandLoad, Boolean expandRootNodes, Hashtable urlArgs)

at Altiris.CustomConsole.Web.Dashboard.TreeView.PopulateTrees(Guid treeGuid)

at Altiris.CustomConsole.Web.Dashboard.TreeView.Render(HtmlTextWriter writer)

at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

SQL Exception details: code=102, line=1

Exception logged from:

at Altiris.Diagnostics.Logging.EventLog.ReportException(Int32 severity, String strMessage, String category, Exception exception, String footer)

at Altiris.NS.Logging.EventLog.ReportException(Int32 severity, String strMessage, String category, Exception exception)

at Altiris.NS.UI.AltirisWebApplication.Application_Error(Object sender, EventArgs e)

at System.EventHandler.Invoke(Object sender, EventArgs e)

at System.Web.HttpApplication.RaiseOnError()

at System.Web.HttpApplication.ApplicationStepManager.ResumeSteps(Exception error)

at System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)

at System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)

at System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr)

at System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)

If anyone can help me solve this problem ...

I already tried:
CMS repair
Aexconfig / configureall without result

Hi CBO_TCS !

Please check this KB http://www.symantec.com/docs/TECH218174

Thanks,

IP.