Violation of PRIMARY KEY constraint

This article has been archived. It is offered "as is" and will no longer be updated.
TechKnowledge Content
Issue Summary:

Violation of PRIMARY KEY constraint

Issue Detail:

Quality Report Description:
When you go into the Additional Charges window in Service Management, and try to consolidate PO's for line items 1 and 3, the error message Violation of PRIMARY KEY constraint "PKSVC00710' Cannot insert duplicate key in object SVC00710 is returned.

Reported in Version\Build:
7.50g01a

Steps to Recreate:
1. Enter a service call.
2. Enter 3 lines in the addtional charges window for a service call.
3. Mark all 3 lines to create a PO.
4. Mark only lines 1 and 3 to colsolidate the PO.

Expected Result:
You can consolidate any of the lines for purchase orders. The system is not consistent on when the error message is received. I can mark lines 1 and 2 to consolidate, however if I then mark line 3 the error is displayed. If I first mark the consolidate buttons for lines 1 and 3 and then mark the create PO button, this seems to work.Actual Result:The error message Violation of PRIMARY KEY constraint "PKSVC00710' Cannot insert duplicate key in object SVC00710 is returned.

Status of Resolution:

This Quality Report is resolved with the latest Field Service Hot Fix. The latest Field Service Hot Fix can be downloaded in the Downloads & Updates area under Hot Fixes.

This article was TechKnowledge Document ID: 267
Properties

Article ID: 856937 - Last Review: 12/29/2014 15:42:00 - Revision: 3.0

  • kbnosurvey kbarchive kbmbsmigrate KB856937
Feedback