Asked by:
Assement failed - Violation of PRIMARY KEY constraint 'LicensingAssessment_pk'

Question
-
Hi
I get assement failed using MAP Toolkit 9.9.13.0. I tried "Create a new database", uninstall and delete files and install again but assement still fails.
Here are the MAPToolkit.log:
<2020-02-20 10:28:30.90 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 (1087e698-c89d-4cb9-9244-002adb2cca1e).
|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-02-20 10:28:30.90 AssessInventoryWorker@AssessInventoryWorker,I> AssessmentCompletedEventHandler: Assessment completed event.
<2020-02-20 10:28:30.90 AssessInventoryWorker@TaskProcessor,I> WorkerCompleted: Worker: 'AssessInventoryWorker'
<2020-02-20 10:28:30.90 TID-17@TaskProcessor,I> Run: Completed. Status: Failed
<2020-02-20 10:28:31.15 TID-17@ProgressStatusViewModel,I> TaskCompletedCallback(): sender: Microsoft.AssessmentPlatform.UI.WpfConsole.Tasks.TaskProcessor
Best regards
Rikard Arvén
- Edited by Rikard Arven Thursday, February 20, 2020 9:49 AM
Thursday, February 20, 2020 9:48 AM
All replies
-
Hi Again
Installed a new computer and installed only MAP Toolkit and I got exactly the same exception and assessment failed.
Below are the MAPToolkit.log:
<2020-02-21 03:01:56.14 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 (b7198edb-c37e-4fae-9f63-0176f00425b2).
|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-02-21 03:01:56.14 AssessInventoryWorker@AssessInventoryWorker,I> AssessmentCompletedEventHandler: Assessment completed event.
<2020-02-21 03:01:56.14 AssessInventoryWorker@TaskProcessor,I> WorkerCompleted: Worker: 'AssessInventoryWorker'
<2020-02-21 03:01:56.15 TID-17@TaskProcessor,I> Run: Completed. Status: Failed
<2020-02-21 03:01:56.27 TID-17@ProgressStatusViewModel,I> TaskCompletedCallback(): sender: Microsoft.AssessmentPlatform.UI.WpfConsole.Tasks.TaskProcessor
<2020-02-21 03:06:52.27 WorkerThread3@WmiClassesCollectionStep,E> CreateCollectorClassInstances(Device(GUID={5fd257bc-2662-4b94-898a-f497469f0547},DnsHostName='MXMTYPC228'), <WmiClass Namespace='root\CIMV2' ClassName='Win32_PnPEntity'>) GetEnumerator Failed: Exception: System.Threading.ThreadAbortException: Thread was being aborted.
| at System.Management.IEnumWbemClassObject.Next_(Int32 lTimeout, UInt32 uCount, IWbemClassObject_DoNotMarshal[] apObjects, UInt32& puReturned)
| at System.Management.ManagementObjectCollection.ManagementObjectEnumerator.MoveNext()
| at Microsoft.AssessmentPlatform.InventoryEngine.DeviceInventory.WmiClassesCollectionStep.CreateCollectorClassInstances(WmiCollectionState stateRec, CollectorClassCollectionState cccs, CollectorClass cc, ManagementObjectCollection objectCollection)
<2020-02-21 03:06:52.46 WorkerThread3@WmiClassesCollectionStep,E> CollectWMIClass(Device(GUID={5fd257bc-2662-4b94-898a-f497469f0547},DnsHostName='MXMTYPC228'), <WmiClass Namespace='root\CIMV2' ClassName='Win32_PnPEntity'>): Failed due to exception System.Threading.ThreadAbortException: Thread was being aborted.
| at Microsoft.AssessmentPlatform.InventoryEngine.DeviceInventory.WmiClassesCollectionStep.CreateCollectorClassInstances(WmiCollectionState stateRec, CollectorClassCollectionState cccs, CollectorClass cc, ManagementObjectCollection objectCollection)
| at Microsoft.AssessmentPlatform.InventoryEngine.DeviceInventory.WmiClassesCollectionStep.CollectWMIClass(WmiCollectionState stateRec, ManagementScope mgmtScope, CollectorClassCollectionState cccs)
<2020-02-21 03:06:52.46 WorkerThread3@DeviceInventoryWorkItem,I> InventoryWorkCallback() - Device(GUID={5fd257bc-2662-4b94-898a-f497469f0547},DnsHostName='MXMTYPC228') : Device inventory was aborted.
<2020-02-21 03:06:52.47 WorkerThread3@WatchdogThreadPool,I> Worker() - WorkerThread3 is being aborted.
<2020-02-21 03:06:52.48 WorkerThread3@WatchdogThreadPool,I> Worker() - WorkerThread3 is exiting.
Friday, February 21, 2020 7:28 AM