Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0020527Openbravo ERPZ. Otherspublic2012-05-16 17:302012-05-28 11:58
Reportermirurita 
Assigned Tomirurita 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0020527: Alerts are not moved from New to Solved when they are created from a buildvalidation
DescriptionupdateAlert method in AlertProcess_data.xsql is comparing an string with null.

AND STATUS != 'SOLVED'

when STATUS is null it returns false.
Steps To Reproduce1) 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
Proposed SolutionModify updateAlert method in AlertProcess_data.xsql

Add a coalesce to status column
AND COALESCE(STATUS, 'NEW') != 'SOLVED'
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-05-16 17:30miruritaNew Issue
2012-05-16 17:30miruritaAssigned To => mirurita
2012-05-16 17:30miruritaModules => Core
2012-05-16 17:30miruritaOBNetwork customer => No
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