[Emerald] consolidation errors - update #1

Tom Bilan ( Tom@TDI.NET )
Sun, 7 Feb 1999 10:09:29 -0500


I'm getting "SQL Server Error: 2627 Violation of PRIMARY KEY constraint
'pk_CallHistory': Attempt to insert duplicate key in object 'CallHisotry'
State=1, Severity=14" when running consolidation.

The screen says "Calls Processed So Far: 495" and the blue bar has a long
way to go.

I hit OK and then in runs for a few minutes and then gives me the same error
with a different account. When I hit OK it went to "Calls Processed So Far:

After it finished it did not delete the calls table. It also did not
make any new entries in the charges table but it did put entries in the
callhistory table.

AccountID StartDate Months Mins Calls
----------- --------------------------- ----------- ----------- -----------
411 Feb 5 1999 12:00AM 1 54 1

What is wrong and how do I fix it?



For more information about this list, including removal,
please see http://www.iea-software.com/maillist.html