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.
Historical Number
PRI49332
Product Synonym
[<p><b>]Fact[</b><p>];
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21549804