Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0040168Retail ModulesWeb POSpublic2019-02-06 18:252019-02-21 15:39
Reporterasiermartirena 
Assigned Toasiermartirena 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in VersionRR19Q2 
Merge Request Status
Review Assigned Tomarvintm
OBNetwork customerGold
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0040168: Some db colums shouldn't be mandatory
DescriptionThe columns 'obposPrepaymentlimitamt' and 'obposPrepaymentlaylimitamt' in the c_order shouldn't be NOT NULL columns. This causes a severe performance issue when doing an upgrade.
Those columns shouldn't also have a default value.
Steps To ReproduceCheck the
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on backport 0040188RR19Q1 closed asiermartirena Some db colums shouldn't be mandatory 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2019-02-06 18:25asiermartirenaNew Issue
2019-02-06 18:25asiermartirenaAssigned To => asiermartirena
2019-02-06 18:25asiermartirenaOBNetwork customer => No
2019-02-06 18:25asiermartirenaTriggers an Emergency Pack => No
2019-02-11 08:51guillermogilOBNetwork customerNo => Gold
2019-02-11 08:51guillermogilResolution time => 1551222000
2019-02-11 08:51guillermogilReproducibilityhave not tried => always
2019-02-13 09:07hgbotCheckin
2019-02-13 09:07hgbotNote Added: 0109790
2019-02-13 09:07hgbotStatusnew => resolved
2019-02-13 09:07hgbotResolutionopen => fixed
2019-02-13 09:07hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/f41faf2f3572fea27708c9c27b0161cf370dc78a [^]
2019-02-13 09:11asiermartirenaStatusresolved => new
2019-02-13 09:11asiermartirenaResolutionfixed => open
2019-02-13 09:12asiermartirenaStatusnew => scheduled
2019-02-13 09:12asiermartirenaStatusscheduled => resolved
2019-02-13 09:12asiermartirenaResolutionopen => fixed
2019-02-13 09:18hgbotCheckin
2019-02-13 09:18hgbotNote Added: 0109794
2019-02-13 09:18hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/f41faf2f3572fea27708c9c27b0161cf370dc78a [^] => http://code.openbravo.com/retail/backports/3.0RR19Q1/org.openbravo.retail.posterminal/rev/4fddf7fb527b78525dd2e6912f1fe9ea377ce3c1 [^]
2019-02-13 09:19asiermartirenaNote Deleted: 0109794
2019-02-21 15:39marvintmReview Assigned To => marvintm
2019-02-21 15:39marvintmStatusresolved => closed
2019-02-21 15:39marvintmFixed in Version => RR19Q2

Notes
(0109790)
hgbot   
2019-02-13 09:07   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: f41faf2f3572fea27708c9c27b0161cf370dc78a
Author: Asier Martirena <asier.martirena <at> openbravo.com>
Date: Mon Feb 11 09:15:01 2019 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/f41faf2f3572fea27708c9c27b0161cf370dc78a [^]

Fixed issue 40168: Some db colums shouldn't be mandatory

---
M src-db/database/model/modifiedTables/C_ORDER.xml
---