Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0031974Openbravo ERPA. Platformpublic2016-01-21 11:052016-01-21 16:52
Reporteralostale 
Assigned Toalostale 
PriorityimmediateSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR16Q1Fixed in Version3.0PR16Q1 
Merge Request Status
Review Assigned Tocaristu
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0031974: 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.0PR16Q1
2016-01-21 14:07hgbotCheckin
2016-01-21 14:07hgbotNote Added: 0083502
2016-01-21 14:07hgbotStatusscheduled => resolved
2016-01-21 14:07hgbotResolutionopen => fixed
2016-01-21 14:07hgbotFixed in SCM revision => http://code.openbravo.com/erp/backports/3.0PR16Q1/rev/83073641d170a8f789b483bdcc4a14bc0a927bbf [^]
2016-01-21 15:19alostaleReview Assigned To => caristu
2016-01-21 16:52caristuNote Added: 0083507
2016-01-21 16:52caristuStatusresolved => closed
2016-01-21 16:52caristuFixed in Version => 3.0PR16Q1
2016-01-21 16:55caristuNote Edited: 0083507bug_revision_view_page.php?bugnote_id=0083507#r10744

Notes
(0083502)
hgbot   
2016-01-21 14:07   
Repository: erp/backports/3.0PR16Q1
Changeset: 83073641d170a8f789b483bdcc4a14bc0a927bbf
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Thu Jan 21 12:44:16 2016 +0100
URL: http://code.openbravo.com/erp/backports/3.0PR16Q1/rev/83073641d170a8f789b483bdcc4a14bc0a927bbf [^]

fixed issue 31974: 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
---
(0083507)
caristu   
2016-01-21 16:52   
(edited on: 2016-01-21 16:55)
Code review + tested OK.

 - Modulescript is executed when updating from a version between PR15Q4 and 3.0.28174 (pi version which contains the fix)

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

 - Alert rule is just created once.