Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0018940 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Openbravo ERP] 09. Financial management | major | always | 2011-10-31 10:15 | 2011-11-12 16:01 | |||
Reporter | mirurita | View Status | public | |||||
Assigned To | eduardo_Argal | |||||||
Priority | high | Resolution | fixed | Fixed in Version | 3.0MP5 | |||
Status | closed | Fix in branch | Fixed in SCM revision | dd26f27fd606 | ||||
Projection | none | ETA | none | Target Version | 3.0MP5 | |||
OS | Any | Database | Any | Java version | ||||
OS Version | Database version | Ant version | ||||||
Product Version | pi | SCM revision | ||||||
Merge Request Status | ||||||||
Review Assigned To | ||||||||
OBNetwork customer | No | |||||||
Web browser | ||||||||
Modules | Core | |||||||
Support ticket | ||||||||
Regression level | ||||||||
Regression date | ||||||||
Regression introduced in release | ||||||||
Regression introduced by commit | ||||||||
Triggers an Emergency Pack | No | |||||||
Summary | 0018940: Reconciliation posting does not work: This record is being posted by another process | |||||||
Description | When 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 Reproduce | 1) 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 | |||||||
Tags | No tags attached. | |||||||
Attached Files | ![]() | |||||||
![]() |
|
![]() |
|
(0042409) mirurita (viewer) 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 (viewer) 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 (viewer) 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 (viewer) 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. |
![]() |
|||
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 10:15 | mirurita | OBNetwork customer | => No |
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 |