3 Replies Latest reply on Jul 6, 2009 4:24 AM by phoffmann

    LDDashboardReportService Error in Event Log.

    ghogan Rookie

      I am getting this error every night in my event log, anyone seen this before its a big long one. Iam running 8.8 SP2A.

       

      Unexpected exception:
      System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Data.OleDb.OleDbException: The statement has been terminated.
      Violation of PRIMARY KEY constraint 'XPKProductComputer'. Cannot insert duplicate key in object 'dbo.PRODUCTCOMPUTER'.
         at System.Data.Common.DbDataAdapter.UpdatedRowStatusErrors(RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount)
         at System.Data.Common.DbDataAdapter.UpdatedRowStatus(RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount)
         at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping)
         at System.Data.Common.DbDataAdapter.UpdateFromDataTable(DataTable dataTable, DataTableMapping tableMapping)
         at System.Data.Common.DbDataAdapter.Update(DataTable dataTable)
         at LANDesk.ManagementSuite.Database.Database.ExecuteBulkInsert(DataTable dt, String sql, OleDbParameter[] sqlParams)
         at SLM.WinUI.Monitoring.Compliance.GetProductInstallationCountsTurboDeuce(LanDeskDatabase database)
         at SLM.WinUI.Groups.ProductGroup.get_ProductInstallationCounts()
         at SLM.WinUI.Groups.ProductGroup.get_ProductInstallationCounts()
         at SLM.WinUI.Groups.ProductGroup.CalculateCompliance()
         at SLM.WinUI.Groups.ProductGroup.CalculateCompliance()
         at SLM.WinUI.Monitoring.Report.GetAggregateProductInfo(IComparer comparer, Boolean includeUsage)
         at SLM.WinUI.Monitoring.Report.GetDashboardUnlicensedProducts(LanDeskDatabase database, ReportParameters parameters, XmlDocument reportsXml)
         --- End of inner exception stack trace ---
         at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
         at System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
         at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
         at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
         at System.Reflection.MethodBase.Invoke(Object obj, Object[] parameters)
         at LANDesk.ManagementSuite.Reporting.DataSource.Get(LanDeskDatabase database, ReportParameters parameters, XmlDocument reportsXml, ActiveReport report)
         at LANDesk.ManagementSuite.Reporting.Dashboard.GetData(String connectionString, String coreName, String language, String reportName)
         at LANDesk.ManagementSuite.Reporting.DashboardReportService.DashboardReportService.SummarizeReport(String report, String summaryTable, String[] columnNames)
         at LANDesk.ManagementSuite.Reporting.DashboardReportService.DashboardReportService.SLMSummary(String report, String summaryTable)
         at LANDesk.ManagementSuite.Reporting.DashboardReportService.DashboardReportService.GenerateReportSummaries()
         at LANDesk.ManagementSuite.Reporting.DashboardReportService.DashboardReportService.OnReportTimer(Object sender, ElapsedEventArgs args)