Unable to use latest MAP tool (Scan OK but unable to do the assessement)

Bernard, Christian 1 Reputation point
2021-01-14T21:54:32.25+00:00

Running discovery ok, but failed on assessement

<2021-01-14 10:12:47.84 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 (dd3c02ce-d814-4a4c-94e5-00f62ae0aa2a).
|The statement has been terminated.
| at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 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, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
| at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 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](Nullable1 isolationLevel, String onSqlExceptionMessage, TransactionWorkCallback1 callback) | --- End of inner exception stack trace --- | at Microsoft.AssessmentPlatform.DataAccess.DataAccessCore.DoWorkInTransaction[T](Nullable1 isolationLevel, String onSqlExceptionMessage, TransactionWorkCallback1 callback) | at Microsoft.AssessmentPlatform.DataAccess.DataAccessCore.ExecuteStoredProc(Nullable1 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)

I'm able to edit table but not to detach and reuse the DB after editing.

Looks to be related to ESU-Year1 licence for Windows 7/2008

A99E6FD3-DC62-4DAC-9749-5DFB9CDBD36D 553673ED-6DDF-419C-A153-B760283472FD Windows(R) 7, Server-ESU-Year1 add-on for ServerDatacenter,ServerDatacenterCore,ServerDatacenterV,ServerDatacenterVCore,ServerStandard,ServerStandardCore,ServerStandardV,ServerStandardVCore,ServerEnterprise,ServerEnterpriseCore,ServerEnterpriseV,ServerEnterpriseVCore
A99E6FD3-DC62-4DAC-9749-5DFB9CDBD36D 6A4BD364-4B60-4856-A727-EFB59D94348E Windows Server(R), ServerStandard edition

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,713 questions
Windows Server Migration
Windows Server Migration
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Migration: The process of making existing applications and data work on a different computer or operating system.
408 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Cris Zhan-MSFT 6,601 Reputation points
    2021-01-15T05:52:16.213+00:00

    Hi @Bernard, Christian ,

    I don’t know much about the Microsoft Assessment and Planning Toolkit.
    This product is currently not supported in the Q&A forums, I suggest you try to reach the experts in the dedicated MAP toolkit forum, or wait for someone familiar with this tool to give some suggestions.

    Best Regards,
    Cris