IBM Support

cannot recreate Node in 8.0

Troubleshooting


Problem

cannot recreate Node in 8.0

Symptom

After creating a node (using copy node) I delete it, then recreate again. I get an error because the YFS_SERVICE_SLOT_GROUP table is not
cleared out on deleteNode. This is in version 8.0.

Error Message


<Errors>
<Error ErrorCode="YFC0001"

<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_SERVICE_SLOT_GROUP(SERVICE_SLOT_GROUP_KEY,ORGANIZATION_KEY,
SERVICE_SLOT_GROUP_DESC,
CREATETS,MODIFYTS,CREATEUSERID,
MODIFYUSERID,CREATEPROGID,MODIFYPROGID,
LOCKID) values ( '200907011240287616073','DEFAULT','WMS-RP-MTNRK','WMS-RP-MTNRK','2009-07-01T12:4 0:27','2009-07-01T12:40:27','hmyint','hmyint','.WMSCopyOrgAPI','.
WMSCopyOrgAPI',0 ) "/>
<Attribute Name="SQLState" Value="23000"/>
<Attribute Name="DBErrorCode" Value="1"/>
<Error ErrorCode="java.sql.SQLException" ErrorDescription="" ErrorRelatedMoreInfo="ORA-00001: unique constraint (YFS80.YFS_SERVICE_SLOT_GROUP_I1) violated ">
<Stack>java.sql.SQLException: ORA-00001: unique constraint (YFS80.YFS_SERVICE_SLOT_GROUP_I1) violated

Resolving The Problem

Fix released in 8.0 HF48

[{"Product":{"code":"SS6PEW","label":"IBM Sterling Order Management"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Not Applicable","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Historical Number

NFX7252

Product Synonym

[<p><b>]Escalation ID[</b><p>];64494;[<p><b>]Fix ID[</b><p>];195858

Document Information

Modified date:
16 June 2018

UID

swg21557980