Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0020527Openbravo ERPZ. Otherspublic2012-05-16 17:302012-05-28 11:58
mirurita 
mirurita 
normalmajoralways
closedfixed 
5
 
 
Core
No
0020527: Alerts are not moved from New to Solved when they are created from a buildvalidation
updateAlert method in AlertProcess_data.xsql is comparing an string with null.

AND STATUS != 'SOLVED'

when STATUS is null it returns false.
1) Deactivate the c_conversion_rate_doc_trg2 trigger
2) Go to sales invoice >> Exchange Rates tab
3) Enter an exchange rate for EUR -> USD
4) Enter again the same exchange rate for EUR -> USD
5) execute ant smartbuild -Dlocal=no
6) The build process will fail and one alert will be created
7) Go to the application and remove exchange rate created in point 4)
8) Execute alert background process
9) The alert is not moved to SOLVED section
Modify updateAlert method in AlertProcess_data.xsql

Add a coalesce to status column
AND COALESCE(STATUS, 'NEW') != 'SOLVED'
No tags attached.
Issue History
2012-05-16 17:30miruritaNew Issue
2012-05-16 17:30miruritaAssigned To => mirurita
2012-05-16 17:30miruritaModules => Core
2012-05-16 17:55miruritaSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=3475#r3475
2012-05-16 17:56miruritaNote Added: 0048708
2012-05-16 19:02hgbotCheckin
2012-05-16 19:02hgbotNote Added: 0048712
2012-05-16 19:02hgbotStatusnew => resolved
2012-05-16 19:02hgbotResolutionopen => fixed
2012-05-16 19:02hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/46bcbbcf35c2b5f9b5018add28fa5ca041a3215a [^]
2012-05-25 12:12hudsonbotCheckin
2012-05-25 12:12hudsonbotNote Added: 0049151
2012-05-28 11:58SandrahuguetNote Added: 0049348
2012-05-28 11:58SandrahuguetStatusresolved => closed

Notes
(0048708)
mirurita   
2012-05-16 17:56   
Testing Plan
1) Deactivate the c_conversion_rate_doc_trg2 trigger
2) Go to sales invoice >> Exchange Rates tab
3) Enter an exchange rate for EUR -> USD
4) Enter again the same exchange rate for EUR -> USD
5) execute ant smartbuild -Dlocal=no
6) The build process will fail and one alert will be created
7) Go to the application and remove exchange rate created in point 4)
8) Execute alert background process
9) The alert should be moved to SOLVED section
(0048712)
hgbot   
2012-05-16 19:02   
Repository: erp/devel/pi
Changeset: 46bcbbcf35c2b5f9b5018add28fa5ca041a3215a
Author: Mikel Irurita <mikel.irurita <at> openbravo.com>
Date: Wed May 16 18:47:20 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/46bcbbcf35c2b5f9b5018add28fa5ca041a3215a [^]

Fixes issue 20527: Alerts are not moved from New to Solved when status is null

---
M src/org/openbravo/erpCommon/ad_process/AlertProcess_data.xsql
---
(0049151)
hudsonbot   
2012-05-25 12:12   
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/5401e185a8b0 [^]

Maturity status: Test
(0049348)
Sandrahuguet   
2012-05-28 11:58   
testing OK