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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0015566
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajoralways2011-01-03 12:562011-05-24 10:56
ReportermalsasuaView Statuspublic 
Assigned Todalsasua 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revisiond57526d04e89
ProjectionnoneETAnoneTarget Version2.50MP26
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_18
OS VersionCommunity ApplianceDatabase version8.3.9Ant version1.7.1
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

0015566: bankstatement in a wrong status: it is not processed and debt payments are cancelled

Descriptionif a bankstatement has a lot of payments (we have reproduced the problem with 1200 lines, but the end client has got 368 lines), the execution of process of this bankstatement could be along to several seconds.
If during this execution, the header is saved by other user, this request is paused until the process is finished.
When the request is executed, the field "processed" is saved with value "N", but the bank statement has been processed, because the debt payments are cancelled in a setlement generated by bankstatement_post process
Steps To Reproduce1. create a bankstatement with a lot of lines (close to 1000)
2. process bankstatement.
3. before that bankstatement_post finish, other user edits the bankstatement header, changes the name (for example), and saves the bankstatement
4. the execution of step 2 finish, and the bankstatement is saved like "processed" = N
TagsclosingMay2011
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
blocks backport 0015794 closeddalsasua bankstatement in a wrong status: it is not processed and debt payments are cancelled 

-  Notes
(0033556)
psarobe (manager)
2011-01-10 10:15

 This is very strange since the PL update the field processing='Y'. This is just a comment that might help when fixing the issue.
(0034014)
hgbot (developer)
2011-02-02 14:18

 Repository: erp/devel/pi
Changeset: 3eee3bd161cf70bdc9d639832d881571f05da9b8
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Wed Feb 02 14:17:42 2011 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/3eee3bd161cf70bdc9d639832d881571f05da9b8 [^]

Fixes issue 0015566: bankstatement in a wrong status: it is not processed and debt payments are cancelled
It has been added a condition in the C_BANKSTATEMENT trigger that verifies when saving that there has not been running process concurrently

---
M src-db/database/model/triggers/C_BSTMT_CHK_RESTRICTIONS_TRG.xml
---
(0034016)
adrianromero (manager)
2011-02-02 14:22

 * Testing the issue

Kindly follow the steps to test and verify that now in one window the process finish successfully and in the window where the user tried to save a record it appears a message saying that there is other process active.

Verify also that the message appears when unprocessing bankstatements.

Verify also that records in bankstatemens can be created/deleted/updated without any impediment.

And finally check the correct behavior in both database engines PostgreSQL and Oracle.

* Other areas affected

It has been modified the trigger of table C_BANKSTATEMENS. All actions related to this table can be affected.
(0034024)
hgbot (developer)
2011-02-03 11:30

 Repository: erp/devel/pi
Changeset: d57526d04e89c2b6fd312c97debfc3a392b625ba
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Thu Feb 03 11:29:36 2011 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/d57526d04e89c2b6fd312c97debfc3a392b625ba [^]

Fixes issue 0015566: bankstatement in a wrong status: it is not processed and debt payments are cancelled
It has been added a condition in the C_BANKSTATEMENT trigger that verifies when saving that there has not been running process concurrently

---
M src-db/database/model/triggers/C_BSTMT_CHK_RESTRICTIONS_TRG.xml
---

- Issue History
Date Modified Username Field Change
2011-01-03 12:56 malsasua New Issue
2011-01-03 12:56 malsasua Assigned To => dalsasua
2011-01-03 12:56 malsasua Modules => Core
2011-01-10 10:15 psarobe Note Added: 0033556
2011-01-10 18:05 malsasua Issue Monitored: networkb
2011-01-27 13:19 adrianromero Status new => scheduled
2011-01-27 13:19 adrianromero fix_in_branch => pi
2011-01-27 13:19 adrianromero Issue cloned 0015794
2011-01-27 13:19 adrianromero Relationship added blocks 0015794
2011-01-27 13:20 adrianromero version 2.50MP25 => pi
2011-01-27 13:20 adrianromero fix_in_branch pi =>
2011-01-31 19:25 shuehner Issue Monitored: shuehner
2011-02-02 14:18 hgbot Checkin
2011-02-02 14:18 hgbot Note Added: 0034014
2011-02-02 14:18 hgbot Status scheduled => resolved
2011-02-02 14:18 hgbot Resolution open => fixed
2011-02-02 14:18 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/3eee3bd161cf70bdc9d639832d881571f05da9b8 [^]
2011-02-02 14:22 adrianromero Note Added: 0034016
2011-02-03 11:30 hgbot Checkin
2011-02-03 11:30 hgbot Note Added: 0034024
2011-02-03 11:30 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/3eee3bd161cf70bdc9d639832d881571f05da9b8 [^] => http://code.openbravo.com/erp/devel/pi/rev/d57526d04e89c2b6fd312c97debfc3a392b625ba [^]
2011-05-24 10:08 dalsasua Tag Attached: closingMay2011
2011-05-24 10:56 dalsasua Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker