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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0021915
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 07. Sales managementmajoralways2012-10-11 13:322012-10-19 14:45
ReporterdmiguelezView Statuspublic 
Assigned Todmiguelez 
PriorityimmediateResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revisiond5a54ef8d574
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_18
OS VersionCommunity ApplianceDatabase version8.3.9Ant version1.7.1
Product VersionSCM revision 
Review Assigned Todmiguelez
Web browser
ModulesCore
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
Summary

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

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0053307)
hgbot (developer)
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 (developer)
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 (developer)
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 (developer)
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 (developer)
2012-10-19 14:45

 DB Consistency fixed.

- Issue History
Date Modified Username Field Change
2012-10-11 13:32 dmiguelez New Issue
2012-10-11 13:32 dmiguelez Assigned To => dmiguelez
2012-10-11 13:32 dmiguelez Modules => Core
2012-10-11 13:33 hgbot Checkin
2012-10-11 13:33 hgbot Note Added: 0053307
2012-10-11 13:33 hgbot Status new => resolved
2012-10-11 13:33 hgbot Resolution open => fixed
2012-10-11 13:33 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/d5a54ef8d574725650ed66f5e878cf16c37f7f7f [^]
2012-10-11 17:01 hgbot Checkin
2012-10-11 17:01 hgbot Note Added: 0053313
2012-10-11 18:40 shuehner Regression level => Automated tests
2012-10-11 18:40 shuehner Regression date => 2012-10-11
2012-10-11 18:40 shuehner Regression introduced by commit => https://code.openbravo.com/erp/devel/pi/rev/7fba0985c35d [^]
2012-10-13 15:50 hudsonbot Checkin
2012-10-13 15:50 hudsonbot Note Added: 0053331
2012-10-13 15:50 hudsonbot Checkin
2012-10-13 15:50 hudsonbot Note Added: 0053332
2012-10-19 14:45 dmiguelez Review Assigned To => dmiguelez
2012-10-19 14:45 dmiguelez Note Added: 0053496
2012-10-19 14:45 dmiguelez Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker