Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0006489Openbravo ERP09. Financial managementpublic2008-12-11 16:312009-01-09 14:45
Reportershuehner 
Assigned Toeduardo_Argal 
PriorityurgentSeveritycriticalReproducibilityhave not tried
StatusclosedResolutionout of date 
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
Summary0006489: 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
related to backport 0005944 closed eduardo_Argal error to create a new element in account schema general ledger 
depends on backport 0006817 closed eduardo_Argal Upgrade from 2.40MP1 (or equivalent svn-rev) to current 2.40 maintenance branch fails 
Attached Filesdiff postpone.diff (807) 2008-12-11 18:18
https://issues.openbravo.com/file_download.php?file_id=526&type=bug
Issue History
Date ModifiedUsernameFieldChange
2008-12-11 16:31shuehnerNew Issue
2008-12-11 16:31shuehnerAssigned To => shuehner
2008-12-11 16:31shuehnersf_bug_id0 => 2417415
2008-12-11 16:31shuehnerOBNetwork customer => No
2008-12-11 16:31shuehnerRegression testing => No
2008-12-11 16:31shuehnerSummaryUpgrade vom 2.40MP1 (or equivalent svn-rev) to current 2.40 maintenance branch fails => Upgrade from 2.40MP1 (or equivalent svn-rev) to current 2.40 maintenance branch fails
2008-12-11 16:31shuehnerStatusnew => scheduled
2008-12-11 16:31shuehnerfix_in_branch => trunk
2008-12-11 16:44shuehnerPrioritynormal => urgent
2008-12-11 16:44shuehnerfix_in_branchtrunk =>
2008-12-11 17:55shuehnerRelationship addedrelated to 0005944
2008-12-11 18:18shuehnerFile Added: postpone.diff
2008-12-11 18:24shuehnerNote Added: 0011202
2008-12-11 18:24shuehnerAssigned Toshuehner => marvintm
2008-12-11 18:24shuehnerStatusscheduled => acknowledged
2009-01-05 18:54iciordiaAssigned Tomarvintm => eduardo_Argal
2009-01-05 18:55iciordiaNote Added: 0011926
2009-01-07 12:15shuehnerNote Added: 0011940
2009-01-09 14:42rafarodaStatusacknowledged => scheduled
2009-01-09 14:42rafarodaNote Added: 0012031
2009-01-09 14:42rafarodafix_in_branch => trunk
2009-01-09 14:45shuehnerStatusscheduled => closed
2009-01-09 14:45shuehnerNote Added: 0012032
2009-01-09 14:45shuehnerResolutionopen => out of date

Notes
(0011202)
shuehner   
2008-12-11 18:24   
Reassigning as fix is blocked by dbsourcemanager issue 6501.
(0011926)
iciordia   
2009-01-05 18:55   
Eduardo,

I've reassigned this bug to you because it requires a change in C_ACCTSCHEMA_TABLE
and it is your plate (you can manage who finally will fix it).

Thanks,

Ismael
(0011940)
shuehner   
2009-01-07 12:15   
The fix is already attached as a patch file, just needs to be re-tested and applied if it works.
(0012031)
rafaroda   
2009-01-09 14:42   
Now that dbsourcemanager issue 6501 is fixed you should be able to move forward with the resolution of this bug.
(0012032)
shuehner   
2009-01-09 14:45   
Affects only 2.40 as the code in trunk was done correctly. Closing defect/leaving backport open.