2014-11-06 12:40:38.260 [E] An unexpected error occurred during import. Violation of PRIMARY KEY constraint 'PK__etblDeleted'. Cannot insert duplicate key in object 'dbo._etblDeleted'

Dear Team,

I'm currently have challenges with my  SAGE  Pastel Evolution Synchronization. I' m running Inter branch accounting  with 16 depots.
None of the 16 Branches are importing from Consolidated. The two major errors i'm getting are:
1. 2014-11-06 12:40:38.260 [E] An unexpected error occurred during import. Violation of PRIMARY KEY constraint 'PK__etblDeleted'. Cannot insert duplicate key in object 'dbo._etblDeleted'
2. [W] Import of "F:\ftp\Consolidation\0000-0016-000000.dat" was unexpected. Expected update no: 160.
3.Argument is incomplete.
Thank You as you help unravel this issues
unnamed--1-.png
unnamed.png
Endurance UmenzehHead ITAsked:
Who is Participating?
 
Vitor MontalvãoConnect With a Mentor MSSQL Senior EngineerCommented:
1. 2014-11-06 12:40:38.260 [E] An unexpected error occurred during import. Violation of PRIMARY KEY constraint 'PK__etblDeleted'. Cannot insert duplicate key in object 'dbo._etblDeleted'
You are importing a record that already exists. I don't know SAGE but there's a way that you can configure to skip these kind of errors?
0
 
Endurance UmenzehHead ITAuthor Commented:
Thank You Victor for this Comment, my  request still remains how to solve the puzzle.
Thank You. I have deleted all the files in the tables but it persist
0
 
Endurance UmenzehHead ITAuthor Commented:
Thank You Victor,

Please how do I configure to skip this errors. You can help contact your friends that have sage experience to help. I will appreciate . Thank You
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
I never heard about SAGE before. I was only referring to the SQL Server error and wondering if in your tool there's a way to say to skip existing records.
0
All Courses

From novice to tech pro — start learning today.