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.
<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
Historical Number
NFX7252
Product Synonym
[<p><b>]Escalation ID[</b><p>];64494;[<p><b>]Fix ID[</b><p>];195858
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21557980