Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0031975Openbravo ERPA. Platformpublic2016-01-21 11:052016-01-21 16:54
Reporteralostale 
Assigned Toalostale 
PriorityimmediateSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR15Q4.2Fixed in Version3.0PR15Q4.2 
Merge Request Status
Review Assigned Tocaristu
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0031975: detect situation created by issue 31959
DescriptionIssue 0031959 creates a situation where data can be corrupted by setting incorrect dates.

This situation should be detected in order to notify users about possible problems.
Steps To Reproducesee 0031959
Proposed SolutionCreate a module script that generates an alert in case of all of the following conditions are satisfied:
1. PG instance
2. updating from PR14Q4
3. using old pool (note this condition does not cover the case of having used old pool for a while, and later moving to new one)
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0031973 closed alostale detect situation created by issue 31959 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2016-01-21 11:06alostaleTypedefect => backport
2016-01-21 11:06alostaleTarget Version => 3.0PR15Q4.2
2016-01-21 13:13txasuIssue Monitored: txasu
2016-01-21 14:06hgbotCheckin
2016-01-21 14:06hgbotNote Added: 0083500
2016-01-21 14:06hgbotStatusscheduled => resolved
2016-01-21 14:06hgbotResolutionopen => fixed
2016-01-21 14:06hgbotFixed in SCM revision => http://code.openbravo.com/erp/backports/3.0PR15Q4.2/rev/51a2befdaed15dc4d765e841eb0695974ce562ca [^]
2016-01-21 15:19alostaleReview Assigned To => caristu
2016-01-21 16:53caristuNote Added: 0083508
2016-01-21 16:53caristuNote Edited: 0083508bug_revision_view_page.php?bugnote_id=0083508#r10740
2016-01-21 16:54caristuNote Deleted: 0083508
2016-01-21 16:54caristuNote Added: 0083509
2016-01-21 16:54caristuStatusresolved => closed
2016-01-21 16:54caristuFixed in Version => 3.0PR15Q4.2

Notes
(0083500)
hgbot   
2016-01-21 14:06   
Repository: erp/backports/3.0PR15Q4.2
Changeset: 51a2befdaed15dc4d765e841eb0695974ce562ca
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Thu Jan 21 13:57:04 2016 +0100
URL: http://code.openbravo.com/erp/backports/3.0PR15Q4.2/rev/51a2befdaed15dc4d765e841eb0695974ce562ca [^]

fixed issue 31975: detect situation created by issue 31959

  Added module script that creates alert when in this situation

---
A src-util/modulescript/build/classes/org/openbravo/modulescript/PgJdbcDatesIssue.class
A src-util/modulescript/build/classes/org/openbravo/modulescript/PgJdbcDatesIssueData.class
A src-util/modulescript/src/org/openbravo/modulescript/PgJdbcDatesIssue.java
A src-util/modulescript/src/org/openbravo/modulescript/PgJdbcDatesIssue_data.xsql
---
(0083509)
caristu   
2016-01-21 16:54   
Code review + tested OK.

 - Modulescript is executed when updating from a version between PR15Q4 and PR15Q4.2

 - Modulescript is not executed when updating before and/or after that version range.

 - Alert rule is just created once.