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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0020527
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] Z. Othersmajoralways2012-05-16 17:302012-05-28 11:58
ReportermiruritaView Statuspublic 
Assigned Tomirurita 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision46bcbbcf35c2
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

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

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0048708)
mirurita (developer)
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 (developer)
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 (developer)
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 (developer)
2012-05-28 11:58

 testing OK

- Issue History
Date Modified Username Field Change
2012-05-16 17:30 mirurita New Issue
2012-05-16 17:30 mirurita Assigned To => mirurita
2012-05-16 17:30 mirurita Modules => Core
2012-05-16 17:55 mirurita Steps to Reproduce Updated View Revisions
2012-05-16 17:56 mirurita Note Added: 0048708
2012-05-16 19:02 hgbot Checkin
2012-05-16 19:02 hgbot Note Added: 0048712
2012-05-16 19:02 hgbot Status new => resolved
2012-05-16 19:02 hgbot Resolution open => fixed
2012-05-16 19:02 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/46bcbbcf35c2b5f9b5018add28fa5ca041a3215a [^]
2012-05-25 12:12 hudsonbot Checkin
2012-05-25 12:12 hudsonbot Note Added: 0049151
2012-05-28 11:58 Sandrahuguet Note Added: 0049348
2012-05-28 11:58 Sandrahuguet Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker