Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

IT Analytics ServiceDesk connection error

Created: 01 Nov 2012 • Updated: 14 Nov 2012 | 5 comments
This issue has been solved. See solution.
I am trying to add SD connection to IT Analytics But i am having an error.
 and when i check the log i m have the given below error. Can anybody tell me whats the problem.Is it with the SQL server or the SMP itself.
 
 
<event date="Nov 01 18:05:26 +00:00" severity="1" hostName="*************" source="Altiris.ITAnalyticsServiceDesk.Web.Settings.controlButtonsAdd_Click" module="w3wp.exe" process="w3wp" pid="5204" thread="3" tickCount="519798890"><![CDATA[Error occured attempting adding Linked Server
**CEDUrlStart** :http://entced.symantec.com/entt?product=SMP&version=7.1.8280.0&language=en&module=zjiMmp87OfuyRC31PHubdtz0zDyplrLAUb4/2/xTb5bGhZi+gZaVu2vjWVpcsx/N&error=-947283106&build=**CEDUrlEnd**
 
 
( Exception Details: Altiris.NS.Exceptions.AeXException: Exception in Regenerate Views inside ServiceDesk ConnectionsThe ntext data type cannot be selected as DISTINCT because it is not comparable.
The ntext data type cannot be selected as DISTINCT because it is not comparable.
The ntext data type cannot be selected as DISTINCT because it is not comparable.
The ntext data type cannot be selected as DISTINCT because it is not comparable.
Invalid object name 'vITAnalytics_SD_ProblemSummary'.
The ntext data type cannot be selected as DISTINCT because it is not comparable.
Invalid object name 'vITAnalytics_SD_ChangeSummary'.
The ntext data type cannot be selected as DISTINCT because it is not comparable.
Invalid object name 'vITAnalytics_SD_ReleaseSummary'. ---> System.Data.SqlClient.SqlException: The ntext data type cannot be selected as DISTINCT because it is not comparable.
The ntext data type cannot be selected as DISTINCT because it is not comparable.
The ntext data type cannot be selected as DISTINCT because it is not comparable.
The ntext data type cannot be selected as DISTINCT because it is not comparable.
Invalid object name 'vITAnalytics_SD_ProblemSummary'.
The ntext data type cannot be selected as DISTINCT because it is not comparable.
Invalid object name 'vITAnalytics_SD_ChangeSummary'.
The ntext data type cannot be selected as DISTINCT because it is not comparable.
Invalid object name 'vITAnalytics_SD_ReleaseSummary'.
   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.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.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Altiris.ITAnalyticsServiceDesk.Web.Settings.RegenerateViews()
   --- End of inner exception stack trace ---
   at Altiris.ITAnalyticsServiceDesk.Web.Settings.RegenerateViews()
   at Altiris.ITAnalyticsServiceDesk.Web.Settings.controlButtonsAdd_Click(Object sender, EventArgs e) )
( Exception logged from:
   at Altiris.Diagnostics.Logging.EventLog.ReportException(Int32 severity, String strMessage, String category, Exception exception)
   at Altiris.NS.Logging.EventLog.ReportException(Int32 severity, String strMessage, String category, Exception exception)
   at Altiris.ITAnalyticsServiceDesk.Web.Settings.controlButtonsAdd_Click(Object sender, EventArgs e)
   at System.Web.UI.WebControls.Button.OnClick(EventArgs e)
   at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
   at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   at System.Web.UI.Page.ProcessRequest()
   at System.Web.UI.Page.ProcessRequest(HttpContext context)
   at ASP.settings_aspx.ProcessRequest(HttpContext context)
   at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
   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)
 )
( Extra Details:  Type=Altiris.NS.Exceptions.AeXException Src=Altiris.ITAnalyticsServiceDesk.Web
 
  Inner Extra Details:  Type=System.Data.SqlClient.SqlException Src=.Net SqlClient Data Provider )]]></event>

Comments 5 CommentsJump to latest comment

andykn101's picture

It looks like the process is trying to add the ServiceDesk SQL server to the Symantec_CMDB SQL server as a "linked server", presumably using the stored procedure sp_addlinkedserver.

You could try and add the SQL Server hosting the ServiceDesk database as a linked server to the SQL Server hosting the Symantec_CMDB by using this stored procedure manually, check the SQL help for the options and run it in SQL Query Analyser on the SQL Server hosting the Symantec_CMDB.

Authorised Symantec Consultant (ASC) with Endpoint Management Limited, an Authorised Symantec Delivery Provider based in the UK.

Connect Etiquette: Please "Mark as Solution" posts that fix your problem.

kareddy's picture

andykn101,

 
I tried the query and attached a profiler and the execution was a success. but still there is no cubes showing up in the IT anylatics.
 
I also attached the trace file.
AttachmentSize
trace.xml 47.15 KB
andykn101's picture

I'd check the added server is listed in SQL Management Studio as a linked server then try and add the ServiceDesk server to IT Analyitics again.

Authorised Symantec Consultant (ASC) with Endpoint Management Limited, an Authorised Symantec Delivery Provider based in the UK.

Connect Etiquette: Please "Mark as Solution" posts that fix your problem.

kareddy's picture

Yes it is listed and i did try to add again but the same Error again.

andykn101's picture

Does this help:

Unable to set up Servicedesk connection "Error occured attempting adding Linked Server"

http://www.symantec.com/docs/TECH199585

Cause

Invalid linked server objects.

Solution

In SQL Server Management Studio, if a linked server object for IT Analytics exists, right click on it and choose Delete. This may be named similarly to "ITANALYTICS_SD_SYMANTEC" with other text following "Symantec". In any case, if a linked server for IT Analytics exists, it will start with "ITANALYTICS".

Authorised Symantec Consultant (ASC) with Endpoint Management Limited, an Authorised Symantec Delivery Provider based in the UK.

Connect Etiquette: Please "Mark as Solution" posts that fix your problem.

SOLUTION