During EndOfDay the error message"Violation of PRIMARY KEY constraint'PK_RtlStoreData_1'is displayed
Environment:
iVend 6.5 Update 6
Problem Statement:
At the time of End of day below message appear
“Violation of PRIMARY KEY constraint 'PK_RtlStoreData_1'. Cannot insert duplicate key in object 'dbo.RtlStoreData'.”
Proposed Solution:
With such an error message we require you to check data on Table SysNextNumber and also check if any open till is still available with previous business date in Store MC Till Screen. If yes, then you need to close it from Store MC . If you get an error to close it, check its Till tables in the Store database base..
Issue is only reported on dated version iVend ver. 6.5 Update 6 and is not noticed on the latest branch of iVend release available for production use.
Steps if any:
Below are the steps we require to follow-up to resolve the issue.
1.Require to check entry Table.RtlStoreData exists on Table SysNextNumber against column NextNumberID.If not exist then we require to insert data same as Table.Store
select * from SysNextNumber where NextNumberID='Table.rtlStoredata'
2. if any open till still available with previous business and unable to close/finalize due to error you need to close/finalize it.
Related Articles
Violation of PRIMARY KEY constraint 'PK_sysnotificationuser'.cannot insert duplicate key in object
****** Internal to CitiXsys****** Environment: 6.6 Patch 7608 Problem Statement: Getting error while restoring the backup file at a new store. Symptom: Below is the error message: 'violation of PRIMARY KEY constraint 'PK_sysnotificationuser'.cannot ...Violation of PRIMARY KEY constraint 'PK_TrxTransaction'. Cannot insert duplicate key in object 'dbo.
Product Version: iVend 6.5 Update 6 Replication Problem Statement: One of their store replication monitor logs is not moving from both sides (Enterprise and store) and its culminating in the replication monitor. Replication log file: Error message : ...commit failed object type transaction sale item key"key number"
Problem Statement :- Getting an error "commit failed object type transaction sale item key"key number" while completing the sale transaction . Proposed solution:- Check the POS log file if below error occur "Violation of PRIMARY KEY constraint ...iVend Primary Key Violation issue after Re-initialize of Store
Product Version: 6.5 Update 6 Patch 2 Problem Statement - Primary Key Violation issue after Re-initialize of Store. Proposed Solution: - We require to increase sysnextnumber for smooth function of store. Steps if any: Below are the steps we require ...Email showing error message through schedule "Failure sending mail"
Environment: iVend Version 6.6 with SAPB1 10 Problem Statement: Email showing error message through schedule "Failure sending mail" Symptoms: Email showing error message through schedule "Failure sending mail". The error is displayed in schedule log ...