none
MAP tool assessment failed after inventory RRS feed

  • Question

  • After completing the inventory assessment is failing.

    Here are contents of the MapToolkit.log file, any help would be appreciated.

    <2020-03-04 11:18:40.88 TID-1@DefaultLogRecordSink,I> 
       |========================================
       |
       |Logging started at 03/04/2020 11:18:40
       |    Application:     MapToolkit.exe Build 9.9.13.00 debug
       |    Platform:        Win32NT 6.2.9200.0 
       |    UI Culture:      en-US
       |    Culture:         en-US
       |    Architecture:    64-bit
       |    OS Product Name: Microsoft Windows Server 2016 Datacenter
       |    Machine Type:    Virtual
       |    CPU:             Intel(R) Xeon(R) CPU E5-2683 v3 @ 2.00GHz
       |    #CPU:            2
       |    #Cores:          1
       |    #Logical:        1
       |    System Memory:   8191 MB
       |    Avail Memory:    6117 MB
       |    Free Disk:       39919 MB
       |
       |========================================
    <2020-03-04 11:18:40.93 TID-1@SqmSessionHelper,I> GetSession(): Started SQM session Main with AppId 101457979
    <2020-03-04 11:18:41.89 TID-12@InitializingPageViewModel,I> DoInitialization(): Checking for duplicate process.
    <2020-03-04 11:18:41.90 TID-12@InitializingPageViewModel,I> DoInitialization(): Loading extensions.
    <2020-03-04 11:18:42.45 TID-12@InitializingPageViewModel,I> DoInitialization(): Completing database management initialization.
    <2020-03-04 11:18:42.51 TID-12@InitializingPageViewModel,I> DoInitialization(): Loading metadata.
    <2020-03-04 11:18:43.59 TID-12@InitializingPageViewModel,I> DoInitialization(): Checking PowerShell version.
    <2020-03-04 11:18:43.65 TID-12@InitializingPageViewModel,I> DoInitialization(): Validating version values.
    <2020-03-04 11:18:43.66 TID-11@ServerConnectionManager,I> SQL Server connection name: (LocalDB)\MAPToolkit
    <2020-03-04 11:18:43.73 TID-11@ServerConnectionManager,I> SQL Server version info: Microsoft SQL Server 2012 - 11.0.2100.60 (X64) 
       | Feb 10 2012 19:39:15 
       | Copyright (c) Microsoft Corporation
       | Express Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: ) (Hypervisor)
       |
    <2020-03-04 11:18:43.75 TID-12@InitializingPageViewModel,I> DoInitialization(): Preparing database.
    <2020-03-04 11:18:44.72 TID-12@InitializingPageViewModel,I> OpenPreviouslySelectedDatabase(): Opening previously selected database. CCC2020
    <2020-03-04 11:18:45.30 TID-12@InitializingPageViewModel,I> DoInitialization(): Initialization complete.
    <2020-03-04 11:18:45.53 TID-15@ScuiFxTraceListener,W> <NavigationModelAdaptor.GetNode> Query for node 'msscnav://root/Windows' from provider 'msscnav://providers/definition' return no result.
    <2020-03-04 11:18:45.53 TID-15@ScuiFxTraceListener,W> <TasksPublisher.OnParentNavigationNodeAvailable|WARN> No node returned for query to location 'msscnav://root/Windows', no tasks will be displayed for this location.
    <2020-03-04 11:18:48.90 TID-1@MainMenuSupport,I> OnRefreshAssessmentCommand() - The user chose to refresh the inventory assessment.
    <2020-03-04 11:18:49.64 TID-15@TaskProcessor,I> Run: Processing task: 'Assess inventory'
    <2020-03-04 11:18:49.65 TID-15@TaskProcessor,I> StartWorkers: Starting worker thread: 'AssessInventoryWorker'
    <2020-03-04 11:18:49.65 AssessInventoryWorker@TaskProcessor,I> RunWorker: Running worker: 'AssessInventoryWorker'
    <2020-03-04 11:18:49.66 AssessInventoryWorker@AssessInventoryWorker,I> AssessmentStartedEventHandler: Assessment start event.
    <2020-03-04 11:18:51.10 AssessInventoryWorker@StoredProcAssessment,I> RunAssessment() - [Perf] [[Core_Assessment].[RemoveInactiveIpAddresses]] : 1421 ms
    <2020-03-04 11:18:51.85 AssessInventoryWorker@StoredProcAssessment,I> RunAssessment() - [Perf] [[Core_Assessment].[RemoveDuplicateDevices]] : 750 ms
    <2020-03-04 11:18:52.06 AssessInventoryWorker@StoredProcAssessment,I> RunAssessment() - [Perf] [[Core_Assessment].[PostInventorySetting]] : 204 ms
    <2020-03-04 11:18:52.06 AssessInventoryWorker@Analyzer,I> RunAssessments() - Elapsed time for assessment 'StoredProcAssessment': 2406 ms
    <2020-03-04 11:18:52.07 AssessInventoryWorker@Analyzer,I> RunAssessments() - Elapsed time for assessment 'SetAssessmentFlagsAssessment': 0 ms
    <2020-03-04 11:18:55.52 AssessInventoryWorker@StoredProcAssessment,I> RunAssessment() - [Perf] [[Win_Assessment].[WindowsInstalledSoftwareAssessment]] : 3437 ms
    <2020-03-04 11:18:57.27 AssessInventoryWorker@StoredProcAssessment,I> RunAssessment() - [Perf] [[Win_Assessment].[DeviceAssessmentProc]] : 1750 ms
    <2020-03-04 11:18:57.33 AssessInventoryWorker@StoredProcAssessment,I> RunAssessment() - [Perf] [[AllDevices_Assessment].[PrepareAssessment]] : 63 ms
    <2020-03-04 11:18:59.39 AssessInventoryWorker@StoredProcAssessment,I> RunAssessment() - [Perf] [[Win_Assessment].[CategorizeInventoriedDevices]] : 2062 ms
    <2020-03-04 11:18:59.48 AssessInventoryWorker@StoredProcAssessment,I> RunAssessment() - [Perf] [[Unix_Assessment].[CategorizeInventoriedDevices]] : 78 ms
    <2020-03-04 11:19:02.90 AssessInventoryWorker@StoredProcAssessment,I> RunAssessment() - [Perf] [[Win_Assessment].[CategorizeDiscoveredDevices]] : 3422 ms
    <2020-03-04 11:19:06.05 AssessInventoryWorker@StoredProcAssessment,I> RunAssessment() - [Perf] [[Unix_Assessment].[CategorizeDiscoveredDevices]] : 3157 ms
    <2020-03-04 11:19:06.38 AssessInventoryWorker@StoredProcAssessment,I> RunAssessment() - [Perf] [[Win_Assessment].[CalculateHardwareInventoryCore]] : 328 ms
    <2020-03-04 11:19:06.48 AssessInventoryWorker@StoredProcAssessment,I> RunAssessment() - [Perf] [[Unix_Assessment].[CalculateHardwareInventoryCore]] : 109 ms
    <2020-03-04 11:19:06.54 AssessInventoryWorker@StoredProcAssessment,I> RunAssessment() - [Perf] [[AllDevices_Assessment].[DiscoveryHardwareInventoryCore]] : 47 ms
    <2020-03-04 11:19:06.54 AssessInventoryWorker@StoredProcAssessment,I> RunAssessment() - [Perf] [[UT_FEP_Assessment].[AssessmentUsageTrackerForefrontEndpointProtection]] : 0 ms
    <2020-03-04 11:19:06.81 AssessInventoryWorker@Analyzer,E> RunAssessments() - Assessment threw an exception:
       |Microsoft.AssessmentPlatform.MapException: Caught SqlException running the stored procedure [WinClient_Assessment].[LicensingAssessmentProc]. ---> System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'LicensingAssessment_pk'. Cannot insert duplicate key in object 'WinClient_Assessment.LicensingAssessment'. The duplicate key value is (be8e8f38-42dc-487e-89ea-ab3da43902aa).
       |The statement has been terminated.
       |   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
       |   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
       |   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
       |   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
       |   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
       |   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
       |   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
       |   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
       |   at Microsoft.AssessmentPlatform.DataAccess.DataAccessCore.ExecuteStoredProcHelper(String storedProcName, Object[] parameters)
       |   at Microsoft.AssessmentPlatform.DataAccess.DataAccessCore.<>c__DisplayClassa.<ExecuteStoredProc>b__9()
       |   at Microsoft.AssessmentPlatform.DataAccess.DataAccessCore.DoWorkInTransaction[T](Nullable`1 isolationLevel, String onSqlExceptionMessage, TransactionWorkCallback`1 callback)
       |   --- End of inner exception stack trace ---
       |   at Microsoft.AssessmentPlatform.DataAccess.DataAccessCore.DoWorkInTransaction[T](Nullable`1 isolationLevel, String onSqlExceptionMessage, TransactionWorkCallback`1 callback)
       |   at Microsoft.AssessmentPlatform.DataAccess.DataAccessCore.ExecuteStoredProc(Nullable`1 isolationLevel, String storedProcName, Object[] parameters)
       |   at Microsoft.AssessmentPlatform.Analytics.Assessments.StoredProcAssessment.RunAssessment(ThreadSafeFlag continueProcessingFlag, SecureString connectionString)
       |   at Microsoft.AssessmentPlatform.Analytics.Analyzer.RunAssessments(IEnumerable`1 assessments)
    <2020-03-04 11:19:06.81 AssessInventoryWorker@AssessInventoryWorker,I> AssessmentCompletedEventHandler: Assessment completed event.
    <2020-03-04 11:19:06.81 AssessInventoryWorker@TaskProcessor,I> WorkerCompleted: Worker: 'AssessInventoryWorker'
    <2020-03-04 11:19:06.82 TID-15@TaskProcessor,I> Run: Completed. Status: Failed
    <2020-03-04 11:19:07.03 TID-15@ProgressPage,I> ProgressPage.TaskCompletedCallback: sender: Microsoft.AssessmentPlatform.UI.WpfConsole.Tasks.TaskProcessor
    <2020-03-04 11:19:08.63 TID-1@ProgressPage,I> FormClosingHandler: Closing reason: UserClosing
    <2020-03-04 11:19:09.76 TID-9@ScuiFxTraceListener,W> <NavigationModelAdaptor.GetNode> Query for node 'msscnav://root/Windows' from provider 'msscnav://providers/definition' return no result.
    <2020-03-04 11:19:09.76 TID-9@ScuiFxTraceListener,W> <TasksPublisher.OnParentNavigationNodeAvailable|WARN> No node returned for query to location 'msscnav://root/Windows', no tasks will be displayed for this location.
    <2020-03-04 11:25:20.38 TID-5@ScuiFxTraceListener,W> <NavigationModelAdaptor.GetNode> Query for node 'msscnav://root/Windows' from provider 'msscnav://providers/definition' return no result.
    <2020-03-04 11:25:20.38 TID-5@ScuiFxTraceListener,W> <TasksPublisher.OnParentNavigationNodeAvailable|WARN> No node returned for query to location 'msscnav://root/Windows', no tasks will be displayed for this location.
    <2020-03-04 11:34:29.81 TID-1@ScuiFxTraceListener,W> <WindowJobsService.Dispose|WARN> This instance of console jobs has already been disposed, returning.
       |
    <2020-03-04 11:34:29.84 TID-1@SqmSessionHelper,I> GetSession(): Started SQM session Database with AppId 101457990
    <2020-03-04 11:34:29.84 TID-1@SqmSessionHelper,I> Upload(): 0 files queued.  Skipping upload.

    Wednesday, March 4, 2020 4:37 PM