Anonymous | Login

Project:

News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ]

[ Issue History ] [ Print ]

ID

0006489

Type

Category

Severity

Reproducibility

Date Submitted

Last Update

defect

[Openbravo ERP] 09. Financial management

critical

have not tried

2008-12-11 16:31

2009-01-09 14:45

Reporter

shuehner

View Status

public

Assigned To

eduardo_Argal

Priority

urgent

Resolution

out of date

Fixed in Version

Status

closed

Fix in branch

pi

Fixed in SCM revision

Projection

none

ETA

none

Target Version

OS

Any

Database

Any

Java version

OS Version

Database version

Ant version

Product Version

2.40MP1

SCM revision

Review Assigned To

Web browser

Modules

Core

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

No

Summary

0006489: Upgrade from 2.40MP1 (or equivalent svn-rev) to current 2.40 maintenance branch fails

Description

Commit 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 Reproduce

create a 2.40 database with svn revivision prior to r10409
svn update to a revision higher than r10409
run ant update.database

Proposed Solution

Assign a onCreateDefault tag which calculcates the fields-value with ad_get_next_sequence

Tags

No tags attached.

postpone.diff [^] (807 bytes) 2008-12-11 18:18 [Show Content] [Hide Content]

Index: src-db/database/model/tables/C_ACCTSCHEMA_GL.xml
===================================================================
--- src-db/database/model/tables/C_ACCTSCHEMA_GL.xml	(revision 11118)
+++ src-db/database/model/tables/C_ACCTSCHEMA_GL.xml	(working copy)
@@ -3,7 +3,7 @@
     <table name="C_ACCTSCHEMA_GL" primaryKey="C_ACCTSCHEMA_GL_KEY">
       <column name="C_ACCTSCHEMA_GL_ID" primaryKey="true" required="true" type="DECIMAL" size="10,0" autoIncrement="false">
         <default/>
-        <onCreateDefault/>
+        <onCreateDefault><![CDATA[SELECT Ad_Get_Next_Sequence('C_AcctSchema_GL', AD_CLIENT_ID) from DUAL]]></onCreateDefault>
       </column>
       <column name="C_ACCTSCHEMA_ID" primaryKey="false" required="true" type="DECIMAL" size="10,0" autoIncrement="false">
         <default/>

Relationships [ Relation Graph ] [ Dependency Graph ]

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

Notes
(0011202) shuehner (administrator) 2008-12-11 18:24	Reassigning as fix is blocked by dbsourcemanager issue 6501.

(0011926) iciordia (manager) 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 (administrator) 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 (developer) 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 (administrator) 2009-01-09 14:45	Affects only 2.40 as the code in trunk was done correctly. Closing defect/leaving backport open.

Issue History
Date Modified	Username	Field	Change
2008-12-11 16:31	shuehner	New Issue
2008-12-11 16:31	shuehner	Assigned To	=> shuehner
2008-12-11 16:31	shuehner	sf_bug_id	0 => 2417415
2008-12-11 16:31	shuehner	Regression testing	=> No
2008-12-11 16:31	shuehner	Summary	Upgrade 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:31	shuehner	Status	new => scheduled
2008-12-11 16:31	shuehner	fix_in_branch	=> trunk
2008-12-11 16:44	shuehner	Priority	normal => urgent
2008-12-11 16:44	shuehner	fix_in_branch	trunk =>
2008-12-11 17:55	shuehner	Relationship added	related to 0005944
2008-12-11 18:18	shuehner	File Added: postpone.diff
2008-12-11 18:24	shuehner	Note Added: 0011202
2008-12-11 18:24	shuehner	Assigned To	shuehner => marvintm
2008-12-11 18:24	shuehner	Status	scheduled => acknowledged
2009-01-05 18:54	iciordia	Assigned To	marvintm => eduardo_Argal
2009-01-05 18:55	iciordia	Note Added: 0011926
2009-01-07 12:15	shuehner	Note Added: 0011940
2009-01-09 14:42	rafaroda	Status	acknowledged => scheduled
2009-01-09 14:42	rafaroda	Note Added: 0012031
2009-01-09 14:42	rafaroda	fix_in_branch	=> trunk
2009-01-09 14:45	shuehner	Status	scheduled => closed
2009-01-09 14:45	shuehner	Note Added: 0012032
2009-01-09 14:45	shuehner	Resolution	open => out of date

Copyright © 2000 - 2009 MantisBT Group