IBM Support

Error When Saving Pipeline With Changes "Delete Record Count != 1 for.."; ORA-0

Troubleshooting


Problem

Error When Saving Pipeline With Changes "Delete Record Count != 1 for.."; ORA-0

Symptom

When trying to change a pipeline - especially by inserting conditions, you get error something like this :


<Errors>
<Error ErrorCode="ORA-0"<br> ErrorDescription="Error description not available"<br>ErrorRelatedMoreInfo="Delete Record Count != 1 for Statement [DELETE FROM<br>YFS_PIPELINE_DROP_STS_COND WHERE LOCKID =0 AND<br>PIPELINE_DROP_STS_COND_KEY='200306021450273816356']">
<Attribute Name="ErrorDescription" Value="Error description not<br>available"/>
<Attribute Name="DBErrorCode" Value="0"/>
<Attribute Name="SQLState" Value=""/>
<Attribute Name="ErrorCode" Value="ORA-0"/>
<Attribute Name="ErrorRelatedMoreInfo" Value="Delete Record Count !=<br>1 for Statement [DELETE FROM YFS_PIPELINE_DROP_STS_COND WHERE LOCKID =0 AND<br>PIPELINE_DROP_STS_COND_KEY='200306021450273816356']"/>
<Attribute Name="Entity" Value="PipelineDefinition"/>
<Error ErrorCode="java.sql.SQLException" ErrorDescription=""<br>ErrorRelatedMoreInfo="Delete Record Count != 1 for Statement [DELETE FROM<br>YFS_PIPELINE_DROP_STS_COND WHERE LOCKID =0 AND<br>PIPELINE_DROP_STS_COND_KEY='200306021450273816356']">
<Stack>java.sql.SQLException: Delete Record Count != 1 for
Statement [DELETE FROM YFS_PIPELINE_DROP_STS_COND WHERE
LOCKID =0 AND

PIPELINE_DROP_STS_COND_KEY='200306021450273816356']
<<no stack trace available>> </Stack>
</Error>
<Stack>com.yantra.yfc.dblayer.YFCDBException <<no stack<br> trace available>> </Stack>
</Error>
<Error ErrorCode="com.yantra.yfc.dblayer.YFCDBException"<br> ErrorDescription="Error description not available"<br>ErrorRelatedMoreInfo="">
<Attribute Name="ErrorDescription" Value="Error description not<br>available"/>
<Attribute Name="ErrorCode"<br>Value="com.yantra.yfc.dblayer.YFCDBException"/>
<Stack>com.yantra.yfc.util.YFCException <<no stack trace<br> available>> </Stack>
</Error>
</Errors>



PART: Platform-Config 4.0 SP3 Platform
PRODUCT: Distributed Order Management
COMPONENT: Users
OS: <None> - <None>
DATABASE: <None> - <None>
WEB SERVER: <None> - <None>
WEB BROWSER: Internet Explorer - 5.5 sp2

Cause

Resolving The Problem

Resolution is to remove caching from yfs.properties for the database tables associated with pipelines - yfs_pipeline, yfs_status, yfs_pipeline_definition, yfs_pipeline_drop_status, yfs_pipeline_pickup_status, etc. This might work.

[{"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

PRI49332

Product Synonym

[<p><b>]Fact[</b><p>];

Document Information

Modified date:
16 June 2018

UID

swg21549804

Page Feedback