Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0018940Openbravo ERP09. Financial managementpublic2011-10-31 10:152011-11-12 16:01
Reportermirurita 
Assigned Toeduardo_Argal 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target Version3.0MP5Fixed in Version3.0MP5 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0018940: Reconciliation posting does not work: This record is being posted by another process
DescriptionWhen you try to post a reconciliation the application shows the following warning:
This record is being posted by another process

a3196480 1557202 [TP-Processor6] WARN org.openbravo.erpCommon.ad_forms.AcctServer - AcctServer - Post -Cannot lock Document - ignored: FIN_Finacc_Transaction_ID=8A64B71A2C351129012C356C357A000F

Looking at Posted.java servlet (org.openbravo.erpCommon.ad_actionButton)
when you get the strTableId
String strTableId = vars.getGlobalVariable("inpTableId", "Posted|tableId");
you get the identifier of Fin_Finacc_Transaction table.

4D8C3B3C31D1410DA046140C9F024D17

So, when trying to lock the document
if (AcctServerData.update(conn, tableName, strClave) != 1) {

it fails because it does not find the document because it is querying other table.

select *
from FIN_Finacc_Transaction
WHERE FIN_Finacc_Transaction_ID = '8A64B71A2C351129012C356C357A000F'
     AND Processed='Y'
     AND (Processing='N' OR Processing IS NULL)
     AND Posted<>'Y'


Steps To Reproduce1) Unschedule accounting background process.
2) Go to Cashbook US East Coast financial account
3) Create a new transaction of Fee transaction type of 5€
4) Reconcile it manually
5) Try to post the reconciliation
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Filespng Reconciliation post warning.png (97,037) 2011-10-31 10:15
https://issues.openbravo.com/file_download.php?file_id=4691&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2011-10-31 10:15miruritaNew Issue
2011-10-31 10:15miruritaAssigned To => eduardo_Argal
2011-10-31 10:15miruritaFile Added: Reconciliation post warning.png
2011-10-31 10:15miruritaModules => Core
2011-10-31 10:15miruritaOBNetwork customer => No
2011-10-31 12:58miruritaNote Added: 0042409
2011-10-31 12:58miruritaStatusnew => closed
2011-10-31 12:58miruritaResolutionopen => unable to reproduce
2011-11-10 10:03psarobeStatusclosed => new
2011-11-10 10:03psarobeResolutionunable to reproduce => open
2011-11-10 10:03psarobeTarget Version => 3.0MP5
2011-11-10 12:28hgbotCheckin
2011-11-10 12:28hgbotNote Added: 0042723
2011-11-10 12:28hgbotStatusnew => resolved
2011-11-10 12:28hgbotResolutionopen => fixed
2011-11-10 12:28hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/0ad9eb1441249dbbd01fd5328e00a5fb09e69478 [^]
2011-11-10 13:46miruritaNote Added: 0042728
2011-11-10 13:46miruritaStatusresolved => closed
2011-11-10 17:26hgbotCheckin
2011-11-10 17:26hgbotNote Added: 0042738
2011-11-10 17:26hgbotStatusclosed => resolved
2011-11-10 17:26hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/0ad9eb1441249dbbd01fd5328e00a5fb09e69478 [^] => http://code.openbravo.com/erp/pmods/org.openbravo.advpaymentmngt/rev/4b548983f1d6df0ddcfe75e78f8b6a8b4adb2be2 [^]
2011-11-11 11:56miruritaNote Added: 0042756
2011-11-11 11:56miruritaStatusresolved => closed
2011-11-12 15:47hgbotCheckin
2011-11-12 15:47hgbotNote Added: 0042766
2011-11-12 15:47hgbotStatusclosed => resolved
2011-11-12 15:47hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.advpaymentmngt/rev/4b548983f1d6df0ddcfe75e78f8b6a8b4adb2be2 [^] => http://code.openbravo.com/erp/devel/pi/rev/dd26f27fd606113d24f7a6fd1c2f93e5946cd8e8 [^]
2011-11-12 15:49hudsonbotCheckin
2011-11-12 15:49hudsonbotNote Added: 0042790
2011-11-12 16:01shuehnerNote Added: 0042796
2011-11-12 16:01shuehnerStatusresolved => closed
2011-11-12 16:01shuehnerFixed in Version => 3.0MP5

Notes
(0042409)
mirurita   
2011-10-31 12:58   
Not able to reproduce it again.
(0042723)
hgbot   
2011-11-10 12:28   
Repository: erp/devel/pi
Changeset: 0ad9eb1441249dbbd01fd5328e00a5fb09e69478
Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
Date: Thu Nov 10 12:15:42 2011 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/0ad9eb1441249dbbd01fd5328e00a5fb09e69478 [^]

Fixes bug 18940: Reconciliation posting does not work: This record is being posted by another process

---
M modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_AUXILIARINPUT.xml
---
(0042728)
mirurita   
2011-11-10 13:46   
Verified.

Also working in http://builds.openbravo.com/view/qa-internal/job/qa-pi-functional-accounting-pgsql/9/ [^]
(0042738)
hgbot   
2011-11-10 17:26   
Repository: erp/pmods/org.openbravo.advpaymentmngt
Changeset: 4b548983f1d6df0ddcfe75e78f8b6a8b4adb2be2
Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
Date: Thu Nov 10 13:59:10 2011 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.advpaymentmngt/rev/4b548983f1d6df0ddcfe75e78f8b6a8b4adb2be2 [^]

fixes bug 18940: Reconciliation posting does not work: This record is being posted by another process

---
M src-db/database/sourcedata/AD_AUXILIARINPUT.xml
---
(0042756)
mirurita   
2011-11-11 11:56   
Verified also in 2.50 as backport has not been created.
(0042766)
hgbot   
2011-11-12 15:47   
Repository: erp/devel/pi
Changeset: dd26f27fd606113d24f7a6fd1c2f93e5946cd8e8
Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
Date: Thu Nov 10 12:15:42 2011 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/dd26f27fd606113d24f7a6fd1c2f93e5946cd8e8 [^]

Fixes bug 18940: Reconciliation posting does not work: This record is being posted by another process

---
M modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_AUXILIARINPUT.xml
---
(0042790)
hudsonbot   
2011-11-12 15:49   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/9752fe729257 [^]

Maturity status: Test
(0042796)
shuehner   
2011-11-12 16:01   
re-closing: has been reopened only because of code-line merge during mp5 release.