locked
Assement failed - Violation of PRIMARY KEY constraint 'LicensingAssessment_pk' RRS feed

  • 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