help.axcms.netAxinom Logo
Save Save Chapter Send Feedback
KB10013: CreateApplication throws PRIMARY KEY violation during member import
If PRIMARY KEY violation exception occurs during member import

SYMPTOMS

When you start Create Application, during member import, PRIMARY KEY violation exception occurs.

CAUSE

This is a bug in AxCMS versions before 7.1.6 caused by unsynchronized instances of SqlSequenceManager in Create Application and Publish Service.

SOLUTION

1. Upgrade to AxCMS 7.1.6, and call AxCmsWebApi.WebQueryService.ResetSequenceManager(); in the very end of SetSequences() method of SampleApplication class.

2. If upgrade is not possible, reset IIS (by calling iisreset) every time before you start Create Application.

APPLIES TO

AxCMS.net versions: before 7.1.6