You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by "Ritu Raj Lakhera (JIRA)" <ji...@apache.org> on 2014/02/11 10:27:19 UTC
[jira] [Created] (OFBIZ-5538) Method getNextSeqId of
SequenceUtil.java does not insure that generated id is already exist in DB
or not
Ritu Raj Lakhera created OFBIZ-5538:
---------------------------------------
Summary: Method getNextSeqId of SequenceUtil.java does not insure that generated id is already exist in DB or not
Key: OFBIZ-5538
URL: https://issues.apache.org/jira/browse/OFBIZ-5538
Project: OFBiz
Issue Type: Improvement
Components: ALL COMPONENTS
Affects Versions: SVN trunk
Reporter: Ritu Raj Lakhera
Priority: Minor
Attachments: Ofbiz-5538.patch
Currently method getNextSeqId of SequenceUtil.java does not insure that generated id is already exist in DB or not.
The problem is that If we export the production environment's order data to UAT environment and UAT environment order's sequence value(SequenceValueItem) in DB are behind from production.
So if we create an order on UAT environment then generated order id may exist in DB and code will throw the error until we do not increase the order sequence in DB manually.
This problem may also arise when we use the two Ofbiz instance, one for e-commerce site only and another for order fulfillment and accounting.
I think we can modify the method getNextSeqId to generate the sequence id which is not exist in DB.
--
This message was sent by Atlassian JIRA
(v6.1.5#6160)