Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0021915Openbravo ERP07. Sales managementpublic2012-10-11 13:322012-10-19 14:45
Reporterdmiguelez 
Assigned Todmiguelez 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionCommunity Appliance
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Todmiguelez
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression levelAutomated tests
Regression date2012-10-11
Regression introduced in release
Regression introduced by commithttps://code.openbravo.com/erp/devel/pi/rev/7fba0985c35d [^]
Triggers an Emergency PackNo
Summary0021915: DB Consistency broken
Descriptiondiff -r d54c2b9fe7f1 src-db/database/model/tables/C_INVOICELINE.xml
--- a/src-db/database/model/tables/C_INVOICELINE.xml Thu Oct 11 11:35:17 2012 +0200
+++ b/src-db/database/model/tables/C_INVOICELINE.xml Thu Oct 11 11:04:33 2012 +0000
@@ -161,7 +161,7 @@
         <default><![CDATA[0]]></default>
         <onCreateDefault/>
       </column>
- <column name="grosspricestd" primaryKey="false" required="true" type="DECIMAL" autoIncrement="false">
+ <column name="GROSSPRICESTD" primaryKey="false" required="true" type="DECIMAL" autoIncrement="false">
         <default><![CDATA[0]]></default>
         <onCreateDefault/>
       </column>
diff -r d54c2b9fe7f1 src-db/database/model/tables/C_ORDERLINE.xml
--- a/src-db/database/model/tables/C_ORDERLINE.xml Thu Oct 11 11:35:17 2012 +0200
+++ b/src-db/database/model/tables/C_ORDERLINE.xml Thu Oct 11 11:04:33 2012 +0000
@@ -213,7 +213,7 @@
         <default/>
         <onCreateDefault/>
       </column>
- <column name="grosspricestd" primaryKey="false" required="true" type="DECIMAL" autoIncrement="false">
+ <column name="GROSSPRICESTD" primaryKey="false" required="true" type="DECIMAL" autoIncrement="false">
         <default><![CDATA[0]]></default>
         <onCreateDefault/>
       </column>
Steps To Reproducediff -r d54c2b9fe7f1 src-db/database/model/tables/C_INVOICELINE.xml
--- a/src-db/database/model/tables/C_INVOICELINE.xml Thu Oct 11 11:35:17 2012 +0200
+++ b/src-db/database/model/tables/C_INVOICELINE.xml Thu Oct 11 11:04:33 2012 +0000
@@ -161,7 +161,7 @@
         <default><![CDATA[0]]></default>
         <onCreateDefault/>
       </column>
- <column name="grosspricestd" primaryKey="false" required="true" type="DECIMAL" autoIncrement="false">
+ <column name="GROSSPRICESTD" primaryKey="false" required="true" type="DECIMAL" autoIncrement="false">
         <default><![CDATA[0]]></default>
         <onCreateDefault/>
       </column>
diff -r d54c2b9fe7f1 src-db/database/model/tables/C_ORDERLINE.xml
--- a/src-db/database/model/tables/C_ORDERLINE.xml Thu Oct 11 11:35:17 2012 +0200
+++ b/src-db/database/model/tables/C_ORDERLINE.xml Thu Oct 11 11:04:33 2012 +0000
@@ -213,7 +213,7 @@
         <default/>
         <onCreateDefault/>
       </column>
- <column name="grosspricestd" primaryKey="false" required="true" type="DECIMAL" autoIncrement="false">
+ <column name="GROSSPRICESTD" primaryKey="false" required="true" type="DECIMAL" autoIncrement="false">
         <default><![CDATA[0]]></default>
         <onCreateDefault/>
       </column>
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-10-11 13:32dmiguelezNew Issue
2012-10-11 13:32dmiguelezAssigned To => dmiguelez
2012-10-11 13:32dmiguelezModules => Core
2012-10-11 13:33hgbotCheckin
2012-10-11 13:33hgbotNote Added: 0053307
2012-10-11 13:33hgbotStatusnew => resolved
2012-10-11 13:33hgbotResolutionopen => fixed
2012-10-11 13:33hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/d5a54ef8d574725650ed66f5e878cf16c37f7f7f [^]
2012-10-11 17:01hgbotCheckin
2012-10-11 17:01hgbotNote Added: 0053313
2012-10-11 18:40shuehnerRegression level => Automated tests
2012-10-11 18:40shuehnerRegression date => 2012-10-11
2012-10-11 18:40shuehnerRegression introduced by commit => https://code.openbravo.com/erp/devel/pi/rev/7fba0985c35d [^]
2012-10-13 15:50hudsonbotCheckin
2012-10-13 15:50hudsonbotNote Added: 0053331
2012-10-13 15:50hudsonbotCheckin
2012-10-13 15:50hudsonbotNote Added: 0053332
2012-10-19 14:45dmiguelezReview Assigned To => dmiguelez
2012-10-19 14:45dmiguelezNote Added: 0053496
2012-10-19 14:45dmiguelezStatusresolved => closed

Notes
(0053307)
hgbot   
2012-10-11 13:33   
Repository: erp/devel/pi
Changeset: d5a54ef8d574725650ed66f5e878cf16c37f7f7f
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Thu Oct 11 13:33:05 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/d5a54ef8d574725650ed66f5e878cf16c37f7f7f [^]

Fixes issue 21915. Fixes database consistency.

---
M src-db/database/model/functions/C_INVOICE_CREATE.xml
M src-db/database/model/tables/C_INVOICELINE.xml
M src-db/database/model/tables/C_ORDERLINE.xml
---
(0053313)
hgbot   
2012-10-11 17:01   
Repository: erp/devel/pi
Changeset: 3a71027b0600bdc072a205d3ca6f9d1084ead32b
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Thu Oct 11 16:59:59 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/3a71027b0600bdc072a205d3ca6f9d1084ead32b [^]

Related to Issue 21915.

---
M src-db/database/model/functions/C_INVOICE_CREATE.xml
---
(0053331)
hudsonbot   
2012-10-13 15:50   
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/99e438a6f972 [^]

Maturity status: Test
(0053332)
hudsonbot   
2012-10-13 15:50   
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/99e438a6f972 [^]

Maturity status: Test
(0053496)
dmiguelez   
2012-10-19 14:45   
DB Consistency fixed.