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

Article:TECH199585  |  Created: 2012-11-09  |  Updated: 2012-11-13  |  Article URL http://www.symantec.com/docs/TECH199585
Article Type
Technical Solution


Issue



The following error occurs when attempting to add a ServiceDesk connection in IT Analytics:

When attempting to make a ServiceDesk connection in IT Analytics, the following error occurs "Error occured attempting adding Linked Server":

 


Error



Additional errors observed:

**CEDUrlStart** :https://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 )]]>


Cause



Invalid linked server objects.


Solution



  1. On the Symantec Management Platform 7.x (SMP) Microsoft SQL Server, click on the Windows Start button > All Programs > Microsoft SQL Server 2005 > SQL Server Management Studio.
  2. Log into the SQL Server Database Engine.
  3. Click to expand Server Objects > Linked Servers.
  4. 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".
  5. Close SQL Server Management Studio.

 




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


Terms of use for this information are found in Legal Notices