question

MartijnKrijger-5533 avatar image
0 Votes"
MartijnKrijger-5533 asked KrijgerMartijn-3469 answered

Maptool accessment refresh fails

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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ShaikMaheer-MSFT avatar image
0 Votes"
ShaikMaheer-MSFT answered

Hi @MartijnKrijger-5533 ,

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

KrijgerMartijn-3469 avatar image
0 Votes"
KrijgerMartijn-3469 answered

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.