Symantec Management Platform (Notification Server)

 View Only

  • 1.  IT Analytics ServiceDesk connection error

    Posted Nov 01, 2012 02:54 PM

     

    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>

     

     



  • 2.  RE: IT Analytics ServiceDesk connection error

    Posted Nov 01, 2012 04:08 PM

    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.



  • 3.  RE: IT Analytics ServiceDesk connection error

    Posted Nov 02, 2012 08:59 AM
      |   view attached

    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.

    Attachment(s)

    xml
    trace.xml   47 KB 1 version


  • 4.  RE: IT Analytics ServiceDesk connection error

    Posted Nov 02, 2012 09:08 AM

    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.



  • 5.  RE: IT Analytics ServiceDesk connection error

    Posted Nov 02, 2012 09:11 AM

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



  • 6.  RE: IT Analytics ServiceDesk connection error
    Best Answer

    Posted Nov 14, 2012 04:19 AM

    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".