Violation of UNIQUE KEY constraint 'UQ__PackageNameIds'.

[parthu.reddy]

We're getting following error while trying to access this package. Pls suggest

[parthu.reddy]

[atripp]

Hi @parthu-reddy ,

I'm not sure what version you're using, but the latest version has a checkbox on the reindex function to delete duplicate ids/names wen running the reindex job.

I would try that -- note you may have to run it twice. This issue is fairly complicated and it's hard to fix without working against exported/backups of user databases.

Thanks,
Alana

[parthu.reddy]

Hi @atripp

We're using version 2025.8 and I've selected that box you mentioned during reindex. I'll run it one more time. If I run it one more time the issue related to UNIQUE KEY will also be fixed right?

Can you also explain us why this error is occurring for this package and how it resulted in this corrupted state.

JFI - in our sand environment we're not facing this issue for this package.

Thanks
Parthu

[parthu.reddy]

Hi @atripp

We've created new feed with new connector and still getting this error.

Thanks
Parthu

[pawel.ostrowski_5669]

What happens is your [dbo].[PackageNameIds_GetOrCreatePackageNameId] picks up the first row and tries to update this the value of the second row (and fails with a constraint).

https://www.diffchecker.com/zyfzX4ev/

Does this fix seem reasonable?

[atripp]

Hi @pawel-ostrowski_5669,

Actually the version you're using (2025.8) has a known regression relating these PackageIds that we already fixed via PG-3097. I didn't realize it until you told me the version and I found that issue.

Anyway please try latest version of ProGet 2025, it should work.

Thanks,
Alana