IBM Support

IBM Sterling 9.2 - DB Unique constraint violation for YFS_ORDER_DATE

Troubleshooting


Problem

Application throwing following error. Indicating Unique Constraint Violation for YFS_Order_Date table

Symptom

IBM Sterling error logs are showing following error
<Errors>
<Error ErrorCode="YFC0001"
ErrorDescription="Record already exists in the database."
ErrorRelatedMoreInfo="" ErrorUniqueExceptionId="10.4.33.6013545680010810000000000021">
<Attribute Name="ErrorCode" Value="YFC0001"/>
<Attribute Name="ErrorDescription" Value="Record already exists in the database."/>
<Attribute Name="SQLStatement" Value="PREPARED STATEMENT - INSERT /*YANTRA*/ INTO YFS_ORDER_DATE(ORDER_DATE_KEY,ORDER_HEADER_KEY,ORDER_LINE_KEY,ORDER_RELEASE_KEY,DATE_TYPE_ID,REQUESTED_DATE,EXPECTED_DATE,ACTUAL_DATE,COMMITTED_DATE,CREATETS,MODIFYTS,CREATEUSERID,MODIFYUSERID,CREATEPROGID,MODIFYPROGID,LOCKID) values ( '201212031589532199544885','2012120315284799543981','2012120315284799543982',' ','YCD_COMPLETELY_SHIPPED_OR_CANCELLED','2012-12-03T15:53:21','2012-12-03T15:53:21','2012-12-03T15:53:21','2012-12-03T15:53:21','2012-12-03T15:53:21','2012-12-03T15:53:21','admin','admin','SterlingHttpTester','SterlingHttpTester',0 ) "/>

with stack trace:

:

:

 at com.yantra.shared.dbclasses.YFS_Order_DateDBHome.insertNoKeyGen(YFS_Order_DateDBHome.java:994)
    at com.yantra.shared.dbclasses.YFS_Order_DateBase.insertNoKeyGen(YFS_Order_DateBase.java:1472)
    at com.yantra.shared.dbclasses.YFS_Order_DateDBHome.insert(YFS_Order_DateDBHome.java:912)
    at com.yantra.omp.business.order.status.YFSStatusMileStoneCreator.insertOrUpdateOrderDateRecord(YFSStatusMileStoneCreator.java:328)
    at com.yantra.omp.business.order.status.YFSStatusMileStoneCreator.createLineMSRecord(YFSStatusMileStoneCreator.java:217)
    at com.yantra.omp.business.order.status.YFSStatusMileStoneCreator.createMilestoneRecords(YFSStatusMileStoneCreator.java:160)
    at com.yantra.omp.business.order.status.YFSStatusMileStoneCreator.processMilestoneRecords(YFSStatusMileStoneCreator.java:59)
    at com.yantra.omp.business.order.status.YFSMoveStatusManager.moveStatus(YFSMoveStatusManager.java:69)

:

:

Cause

This has been identified as a product defect under APAR IC89900.
Defect Fixed as part of 9.2 FP10

Diagnosing The Problem

Validate error stack / message in log files

Resolving The Problem

Apply 9.2 FP10 or above

[{"Product":{"code":"SS6QYM","label":"Sterling Selling and Fulfillment Suite"},"Business Unit":{"code":"BU055","label":"Cognitive Applications"},"Component":"--","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.2","Edition":"All Editions","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
16 June 2018

UID

swg21623781

Page Feedback