Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0010841Openbravo ERPA. Platformpublic2009-10-02 11:302009-10-23 00:00
Reporternetworkb 
Assigned Tomarvintm 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40MP3 
Target Version2.50MP7Fixed in Version 
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
Summary0010841: 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
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-10-02 11:30networkbNew Issue
2009-10-02 11:30networkbAssigned To => rafaroda
2009-10-02 11:30networkbOBNetwork customer => Yes
2009-10-02 16:38shuehnerNote Added: 0020674
2009-10-05 07:55rafarodaAssigned Torafaroda => marvintm
2009-10-05 07:55rafarodaPriorityimmediate => urgent
2009-10-05 07:55rafarodaStatusnew => scheduled
2009-10-05 07:55rafarodaCategoryK. Packaging => A. Platform
2009-10-05 17:37hgbotCheckin
2009-10-05 17:37hgbotNote Added: 0020715
2009-10-05 17:37hgbotStatusscheduled => resolved
2009-10-05 17:37hgbotResolutionopen => fixed
2009-10-05 17:37hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/6c00a64a75574fe2292218c22f0e0b9982632c6a [^]
2009-10-05 17:50hgbotCheckin
2009-10-05 17:50hgbotNote Added: 0020716
2009-10-05 17:50hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/6c00a64a75574fe2292218c22f0e0b9982632c6a [^] => http://code.openbravo.com/erp/devel/pi/rev/ef307fc1968e1943f1f4f5bcc95f64d38fa6dcc4 [^]
2009-10-22 11:21plujanStatusresolved => closed
2009-10-23 00:00anonymoussf_bug_id0 => 2884254

Notes
(0020674)
shuehner   
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   
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   
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
---