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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0010841
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformmajoralways2009-10-02 11:302009-10-23 00:00
ReporternetworkbView Statuspublic 
Assigned Tomarvintm 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revisionef307fc1968e
ProjectionnoneETAnoneTarget Version2.50MP7
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.40MP3SCM revision 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0010841: update.customized.database.modularity fails becuase of new added columns in 2.50

Descriptionwhen this task is executed, this error appears:

ALTER TABLE R_CONTACTINTEREST
ADD CONSTRAINT R_CONTACTINTEREST_KEY PRIMARY KEY (R_CONTACTINTEREST_ID)

ALTER TABLE R_CONTACTINTEREST
MODIFY R_CONTACTINTEREST_ID VARCHAR2(32) NOT NULL

New columns were added and there is no "by default" values for them.
Steps To ReproduceExecute update.customized.database.modularity in Openbravo 2.40
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0020674)
shuehner (administrator)
2009-10-02 16:38

 Explanation is right: It looks like a onCreateDefault value of get_uuid for the new artivicial primary key is missing. This was probably unnoticed in the previous upgrade tests, if this table did not contain any rows in the test.
(0020715)
hgbot (developer)
2009-10-05 17:37

 Repository: erp/devel/pi
Changeset: 6c00a64a75574fe2292218c22f0e0b9982632c6a
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Mon Oct 05 17:37:17 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/6c00a64a75574fe2292218c22f0e0b9982632c6a [^]

Fixed issue 10841. Added onCreateDefault value to Primary Key column.

---
M src-db/database/model/tables/R_CONTACTINTEREST.xml
---
(0020716)
hgbot (developer)
2009-10-05 17:50

 Repository: erp/devel/pi
Changeset: ef307fc1968e1943f1f4f5bcc95f64d38fa6dcc4
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Mon Oct 05 17:48:57 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/ef307fc1968e1943f1f4f5bcc95f64d38fa6dcc4 [^]

Related to issue 10841. Added onCreateDefault also for table AD_LANGUAGE.

---
M src-db/database/model/tables/AD_LANGUAGE.xml
---

- Issue History
Date Modified Username Field Change
2009-10-02 11:30 networkb New Issue
2009-10-02 11:30 networkb Assigned To => rafaroda
2009-10-02 11:30 networkb OBNetwork customer => Yes
2009-10-02 16:38 shuehner Note Added: 0020674
2009-10-05 07:55 rafaroda Assigned To rafaroda => marvintm
2009-10-05 07:55 rafaroda Priority immediate => urgent
2009-10-05 07:55 rafaroda Status new => scheduled
2009-10-05 07:55 rafaroda Category K. Packaging => A. Platform
2009-10-05 17:37 hgbot Checkin
2009-10-05 17:37 hgbot Note Added: 0020715
2009-10-05 17:37 hgbot Status scheduled => resolved
2009-10-05 17:37 hgbot Resolution open => fixed
2009-10-05 17:37 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/6c00a64a75574fe2292218c22f0e0b9982632c6a [^]
2009-10-05 17:50 hgbot Checkin
2009-10-05 17:50 hgbot Note Added: 0020716
2009-10-05 17:50 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/6c00a64a75574fe2292218c22f0e0b9982632c6a [^] => http://code.openbravo.com/erp/devel/pi/rev/ef307fc1968e1943f1f4f5bcc95f64d38fa6dcc4 [^]
2009-10-22 11:21 plujan Status resolved => closed
2009-10-23 00:00 anonymous sf_bug_id 0 => 2884254

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker