Error Msg:2627

[christine1]

Hi, <br><br>I have an upload from an ASA (Sybase)server to SQL 6.5 dB.&nbsp;&nbsp;After the load I run a stored procedure that creates a cube.&nbsp;&nbsp;sp_cube_unit<br><br>After I run the cube I get back a long list of results regarding this &quot;error msg. 2627, Level 14, State 1 Violation of the primary Key Constraint.&quot;&nbsp;&nbsp;It just started happening, can anyone tell me what this error message is and how can I fix it?<br><br>Christine<br><A HREF="mailto:christine@spsinc.com">christine@spsinc.com</A>

 

[redlam]

The error message indicates that you are attempting to insert a duplicate record - or at least one that has the same values in the fields that make up the primary key.&nbsp;&nbsp;Is it possible that you have run the same upload twice?

 

[christine1]

Yes it is possible.&nbsp;&nbsp;We outsource the task of uploading the Sybase data&nbsp;&nbsp;(server is in-house).&nbsp;&nbsp;A situation occured when event records where missing from the most recent upload.&nbsp;&nbsp;So we asked them to do it again.&nbsp;&nbsp;Only of the records that seemingly didn't make it in.&nbsp;&nbsp;The upload goes like this: There is a VB app that basically says if record not found insert if true (found)update.&nbsp;&nbsp;It references a cross reference table and bam we have data.&nbsp;&nbsp;How do you get your data from your Sybase system to SQL 6.5 ?&nbsp;&nbsp;Any advice is greatly appreciated.