Primary key violation for pre-sale transactions in Xstore

Hi All,

We are having primary key violation errors at Xstore level for some pre-sale transactions.

This issue might cause due to wrong sequence number in presale.seq file (C:\xstore\sequence\active).Usually we modify the sequence file in order to fix these kind of issues.

But in case of multiple stores, it would be difficult to manually identify max sequence numbers first and modify the sequence file based on that.

Problem here is with pre sale as customer account related table does not have business date as part of primary keys, accounts has to be unique per customer per sale.