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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0015794
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 09. Financial managementmajoralways2011-01-27 13:192011-03-01 13:56
ReporteradrianromeroView Statuspublic 
Assigned Todalsasua 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branch2.50Fixed in SCM revision63c194f03f6c
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_18
OS VersionCommunity ApplianceDatabase version8.3.9Ant version1.7.1
Product Version2.50MP25SCM revision 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0015794: 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
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
depends on defect 00155662.50MP26 closeddalsasua bankstatement in a wrong status: it is not processed and debt payments are cancelled 

-  Notes
(0034013)
hgbot (developer)
2011-02-02 14:14

 Repository: erp/stable/2.50
Changeset: 820242d519ab4a5e0e4972290f750341e63fa980
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Wed Feb 02 14:13:34 2011 +0100
URL: http://code.openbravo.com/erp/stable/2.50/rev/820242d519ab4a5e0e4972290f750341e63fa980 [^]

Fixes issue 0015794: 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
---
(0034015)
adrianromero (viewer)
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.
(0034023)
hgbot (developer)
2011-02-03 11:27

 Repository: erp/stable/2.50
Changeset: 63c194f03f6cf44c2ff04098a92c5dbed3824939
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Thu Feb 03 11:25:55 2011 +0100
URL: http://code.openbravo.com/erp/stable/2.50/rev/63c194f03f6cf44c2ff04098a92c5dbed3824939 [^]

Fixes issue 0015794: 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-27 13:19 adrianromero New Issue
2011-01-27 13:19 adrianromero Assigned To => dalsasua
2011-01-27 13:19 adrianromero Modules => Core
2011-01-27 13:19 adrianromero OBNetwork customer => Yes
2011-01-27 13:19 adrianromero Issue generated from 0015566
2011-01-27 13:19 adrianromero Relationship added depends on 0015566
2011-01-27 13:20 adrianromero Status new => scheduled
2011-01-27 13:20 adrianromero fix_in_branch => pi
2011-01-28 16:51 dalsasua fix_in_branch pi => 2.50
2011-02-02 14:14 hgbot Checkin
2011-02-02 14:14 hgbot Note Added: 0034013
2011-02-02 14:14 hgbot Status scheduled => resolved
2011-02-02 14:14 hgbot Resolution open => fixed
2011-02-02 14:14 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/stable/2.50/rev/820242d519ab4a5e0e4972290f750341e63fa980 [^]
2011-02-02 14:22 adrianromero Note Added: 0034015
2011-02-03 11:27 hgbot Checkin
2011-02-03 11:27 hgbot Note Added: 0034023
2011-02-03 11:27 hgbot Fixed in SCM revision http://code.openbravo.com/erp/stable/2.50/rev/820242d519ab4a5e0e4972290f750341e63fa980 [^] => http://code.openbravo.com/erp/stable/2.50/rev/63c194f03f6cf44c2ff04098a92c5dbed3824939 [^]
2011-03-01 13:56 dalsasua Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker