Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0006817Openbravo ERP09. Financial managementpublic2008-12-11 16:312009-03-03 17:16
Reportershuehner 
Assigned Toeduardo_Argal 
PriorityurgentSeveritycriticalReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40MP1 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0006817: Upgrade from 2.40MP1 (or equivalent svn-rev) to current 2.40 maintenance branch fails
DescriptionCommit r10409 (issue 5944) changed the primary key of the C_ACCTSCHEMA_TABLE to a new field created in the same changeset. The new field-definition is missing the onCreateDefault -tag to specify how the value for existing rows in this table should be calculated. Later switching the PK fails because of the null-values in this column for already existing rows.
Steps To Reproducecreate a 2.40 database with svn revivision prior to r10409
svn update to a revision higher than r10409
run ant update.database
Proposed SolutionAssign a onCreateDefault tag which calculcates the fields-value with ad_get_next_sequence
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0006489 closed eduardo_Argal Upgrade from 2.40MP1 (or equivalent svn-rev) to current 2.40 maintenance branch fails 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-01-09 14:42rafarodaTypedefect => backport
2009-01-09 14:42rafarodafix_in_branch => 2.40
2009-01-09 14:46shuehnerNote Added: 0012033
2009-01-12 18:48svnbotCheckin
2009-01-12 18:48svnbotNote Added: 0012126
2009-01-12 18:48svnbotStatusscheduled => resolved
2009-01-12 18:48svnbotResolutionopen => fixed
2009-01-12 18:48svnbotsvn_revision => 11806
2009-03-03 17:16psarobeStatusresolved => closed

Notes
(0012033)
shuehner   
2009-01-09 14:46   
The (closed) defect 6489 has a diff-file with a possible solution attached.
(0012126)
svnbot   
2009-01-12 18:48   
Repository: openbravo
Revision: 11806
Author: eduardoargal
Date: 2009-01-12 18:48:01 +0100 (Mon, 12 Jan 2009)

Fixes bug 0006817: Upgrade from 2.40MP1 (or equivalent svn-rev) to current 2.40 maintenance branch fails. Also added oncreatedefault for column allownegative

---
U branches/r2.40/src-db/database/model/tables/C_ACCTSCHEMA.xml
U branches/r2.40/src-db/database/model/tables/C_ACCTSCHEMA_GL.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=11806&sc=1 [^]