Maptool accessment refresh fails

Martijn Krijger 1 Reputation point
2022-04-29T11:39:09.16+00:00

Dear team,
when i run the maptool for the 2nd time it shows an error that it fails. In the log file we see:
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

how to fix this?

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
3,098 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. ShaikMaheer-MSFT 31,626 Reputation points Microsoft Employee
    2022-05-02T16:34:59.897+00:00

    Hi @Martijn Krijger ,

    Thank you for posting query in Microsoft Q&A Platform.

    From error message its clear that you are trying to insert duplicate values in to primary key column. When we have primary key constrain on a column, that column will not duplicate values.

    Kindly consider not to insert duplicate values in to primary key column to avoid this error.

    Hope this helps. Please let us know if any queries.

    ------------

    Please consider hitting Accept Answer button. Accepted answers help community as well.

    0 comments No comments

  2. Krijger, Martijn 1 Reputation point
    2022-05-03T08:11:17.57+00:00

    Hi, unfortunately the answer makes no sense, because i do not initiate the insert but the MAP tool does that after i scan the network for the 2nd or 3rd time.
    So this is programmed in the maptool software. I do not have access to the database and i have no idea what the software wants to do.

    0 comments No comments