Maptool accessment refresh fails

Question

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?

Answer 1

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.

Answer 2

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.