Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0018940
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajoralways2011-10-31 10:152011-11-12 16:01
ReportermiruritaView Statuspublic 
Assigned Toeduardo_Argal 
PriorityhighResolutionfixedFixed in Version3.0MP5
StatusclosedFix in branchFixed in SCM revisiondd26f27fd606
ProjectionnoneETAnoneTarget Version3.0MP5
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0018940: 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
TagsNo tags attached.
Attached Filespng file icon Reconciliation post warning.png [^] (97,037 bytes) 2011-10-31 10:15

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0042409)
mirurita (developer)
2011-10-31 12:58

Not able to reproduce it again.
(0042723)
hgbot (developer)
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 (developer)
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 (developer)
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 (developer)
2011-11-11 11:56

Verified also in 2.50 as backport has not been created.
(0042766)
hgbot (developer)
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 (developer)
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 (administrator)
2011-11-12 16:01

re-closing: has been reopened only because of code-line merge during mp5 release.

- Issue History
Date Modified Username Field Change
2011-10-31 10:15 mirurita New Issue
2011-10-31 10:15 mirurita Assigned To => eduardo_Argal
2011-10-31 10:15 mirurita File Added: Reconciliation post warning.png
2011-10-31 10:15 mirurita Modules => Core
2011-10-31 12:58 mirurita Note Added: 0042409
2011-10-31 12:58 mirurita Status new => closed
2011-10-31 12:58 mirurita Resolution open => unable to reproduce
2011-11-10 10:03 psarobe Status closed => new
2011-11-10 10:03 psarobe Resolution unable to reproduce => open
2011-11-10 10:03 psarobe Target Version => 3.0MP5
2011-11-10 12:28 hgbot Checkin
2011-11-10 12:28 hgbot Note Added: 0042723
2011-11-10 12:28 hgbot Status new => resolved
2011-11-10 12:28 hgbot Resolution open => fixed
2011-11-10 12:28 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/0ad9eb1441249dbbd01fd5328e00a5fb09e69478 [^]
2011-11-10 13:46 mirurita Note Added: 0042728
2011-11-10 13:46 mirurita Status resolved => closed
2011-11-10 17:26 hgbot Checkin
2011-11-10 17:26 hgbot Note Added: 0042738
2011-11-10 17:26 hgbot Status closed => resolved
2011-11-10 17:26 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/0ad9eb1441249dbbd01fd5328e00a5fb09e69478 [^] => http://code.openbravo.com/erp/pmods/org.openbravo.advpaymentmngt/rev/4b548983f1d6df0ddcfe75e78f8b6a8b4adb2be2 [^]
2011-11-11 11:56 mirurita Note Added: 0042756
2011-11-11 11:56 mirurita Status resolved => closed
2011-11-12 15:47 hgbot Checkin
2011-11-12 15:47 hgbot Note Added: 0042766
2011-11-12 15:47 hgbot Status closed => resolved
2011-11-12 15:47 hgbot Fixed in SCM revision http://code.openbravo.com/erp/pmods/org.openbravo.advpaymentmngt/rev/4b548983f1d6df0ddcfe75e78f8b6a8b4adb2be2 [^] => http://code.openbravo.com/erp/devel/pi/rev/dd26f27fd606113d24f7a6fd1c2f93e5946cd8e8 [^]
2011-11-12 15:49 hudsonbot Checkin
2011-11-12 15:49 hudsonbot Note Added: 0042790
2011-11-12 16:01 shuehner Note Added: 0042796
2011-11-12 16:01 shuehner Status resolved => closed
2011-11-12 16:01 shuehner Fixed in Version => 3.0MP5


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker