Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0005517Openbravo ERPY. DBSourceManagerpublic2008-10-14 11:372009-04-22 00:00
Reporterjpabloae 
Assigned Tomarvintm 
PriorityurgentSeveritycriticalReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS30OS Version
Product Version 
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
Summary0005517: update.customized.database fails in 2.35MP7->2.40
DescriptionThe update.customized.database gives a NullPointerException when updatting form 2.35MP7 to 2.40. Here's the log message:

[altercustomizeddatabasedata] Processing Column CREATETEMPPRICELIST (created for table C_PROJECT)
[altercustomizeddatabasedata] Processing Column C_PROJECTPHASE_ID (created for table C_PROJECT)
[altercustomizeddatabasedata] Processing Column PRICEACTUAL of table C_PROJECTPHASE (changed because of the default value)
[altercustomizeddatabasedata] Processing Column COMMITTEDAMT of table C_PROJECTPHASE (changed because of the default value)
[altercustomizeddatabasedata] Processing Foreign key Foreign key [name=CRELEASE_CPROJECTTASK; onupdate=null; ondelete=null; foreign table=C_RELEASE; 1 references] (removed from table C_PROJECTTASK)
[altercustomizeddatabasedata] Processing Foreign key Foreign key [name=RELEASECHAPTER_PROJECTTASK; onupdate=null; ondelete=null; foreign table=C_RELEASE_CHAPTER; 1 references] (removed from table C_PROJECTTASK)
[altercustomizeddatabasedata] java.lang.NullPointerException
[altercustomizeddatabasedata] at org.apache.ddlutils.model.ForeignKey.equalsIgnoreCase(Unknown Source)
[altercustomizeddatabasedata] at org.apache.ddlutils.alteration.ModelComparator.findCorrespondingForeignKey(Unknown Source)
[altercustomizeddatabasedata] at org.apache.ddlutils.alteration.ModelComparator.compareTables(Unknown Source)
[altercustomizeddatabasedata] at org.apache.ddlutils.alteration.ModelComparator.compare(Unknown Source)
[altercustomizeddatabasedata] at org.apache.ddlutils.platform.SqlBuilder.alterDatabase(Unknown Source)
[altercustomizeddatabasedata] at org.apache.ddlutils.platform.PlatformImplBase.alterTables(Unknown Source)
[altercustomizeddatabasedata] at org.apache.ddlutils.platform.PlatformImplBase.alterTables(Unknown Source)
[altercustomizeddatabasedata] at org.openbravo.ddlutils.task.AlterCustomizedDatabaseData.execute(Unknown Source)
[altercustomizeddatabasedata] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
[altercustomizeddatabasedata] at sun.reflect.GeneratedMethodAccessor1.invoke(Unknown Source)
[altercustomizeddatabasedata] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[altercustomizeddatabasedata] at java.lang.reflect.Method.invoke(Method.java:585)
[altercustomizeddatabasedata] at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
[altercustomizeddatabasedata] at org.apache.tools.ant.Task.perform(Task.java:348)
[altercustomizeddatabasedata] at org.apache.tools.ant.Target.execute(Target.java:357)
[altercustomizeddatabasedata] at org.apache.tools.ant.Target.performTasks(Target.java:385)
[altercustomizeddatabasedata] at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1337)
[altercustomizeddatabasedata] at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38)
[altercustomizeddatabasedata] at org.apache.tools.ant.Project.executeTargets(Project.java:1189)
[altercustomizeddatabasedata] at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:416)
[altercustomizeddatabasedata] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
[altercustomizeddatabasedata] at sun.reflect.GeneratedMethodAccessor1.invoke(Unknown Source)
[altercustomizeddatabasedata] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[altercustomizeddatabasedata] at java.lang.reflect.Method.invoke(Method.java:585)
[altercustomizeddatabasedata] at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
[altercustomizeddatabasedata] at org.apache.tools.ant.Task.perform(Task.java:348)
[altercustomizeddatabasedata] at org.apache.tools.ant.Target.execute(Target.java:357)
[altercustomizeddatabasedata] at org.apache.tools.ant.Target.performTasks(Target.java:385)
[altercustomizeddatabasedata] at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1337)
[altercustomizeddatabasedata] at org.apache.tools.ant.Project.executeTarget(Project.java:1306)
[altercustomizeddatabasedata] at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
[altercustomizeddatabasedata] at org.apache.tools.ant.Project.executeTargets(Project.java:1189)
[altercustomizeddatabasedata] at org.apache.tools.ant.Main.runBuild(Main.java:758)
[altercustomizeddatabasedata] at org.apache.tools.ant.Main.startAnt(Main.java:217)
[altercustomizeddatabasedata] at org.apache.tools.ant.launch.Launcher.run(Launcher.java:257)
[altercustomizeddatabasedata] at org.apache.tools.ant.launch.Launcher.main(Launcher.java:104)
[altercustomizeddatabasedata] null
[altercustomizeddatabasedata] SQL Command failed with: ORA-00942: table or view does not exist
Steps To Reproduce
Proposed Solution
Additional Information
Tagsdbsm_migrate
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-10-14 11:37jpabloaeNew Issue
2008-10-14 11:37jpabloaeAssigned To => marvintm
2008-10-16 10:59pjuvaraSeveritymajor => critical
2008-10-16 17:55svnbotCheckin
2008-10-16 17:55svnbotNote Added: 0009614
2008-10-16 17:55svnbotStatusnew => resolved
2008-10-16 17:55svnbotResolutionopen => fixed
2008-10-16 17:55svnbotsvn_revision => 145
2008-10-16 18:14svnbotCheckin
2008-10-16 18:14svnbotNote Added: 0009615
2008-10-16 18:14svnbotsvn_revision145 => 146
2008-11-11 17:56svnbotCheckin
2008-11-11 17:56svnbotNote Added: 0010178
2008-11-11 17:56svnbotsvn_revision146 => 167
2008-12-18 12:38jpabloaeSticky IssueNo => Yes
2008-12-18 12:39jpabloaeSticky IssueYes => No
2008-12-18 12:39jpabloaeTag Attached: dbsm_migrate
2008-12-18 12:41jpabloaeProject@4@ => Openbravo ERP
2008-12-18 12:41jpabloaeCategory => Y. DBSourceManager
2009-04-21 11:07psarobeStatusresolved => closed
2009-04-22 00:00anonymoussf_bug_id0 => 2777906

Notes
(0009614)
svnbot   
2008-10-16 17:55   
Repository: dbsourcemanager
Revision: 145
Author: marvintm
Date: 2008-10-16 17:55:53 +0200 (Thu, 16 Oct 2008)

Fixed bug 5517. While applying customized foreign keys, we will save the table name to prevent problems.

---
U branches/r0.8x/src/org/apache/ddlutils/alteration/AddForeignKeyChange.java
---

https://dev.openbravo.com/websvn/dbsourcemanager/?rev=145&sc=1 [^]
(0009615)
svnbot   
2008-10-16 18:14   
Repository: dbsourcemanager
Revision: 146
Author: marvintm
Date: 2008-10-16 18:14:19 +0200 (Thu, 16 Oct 2008)

Fixed previous issue 5517. Now table name will be preserved when applying a customized foreign key.

---
_U trunk/
U trunk/src/org/apache/ddlutils/alteration/AddForeignKeyChange.java
U trunk/src/org/apache/ddlutils/io/DataToDatabaseSink.java
---

https://dev.openbravo.com/websvn/dbsourcemanager/?rev=146&sc=1 [^]
(0010178)
svnbot   
2008-11-11 17:56   
Repository: dbsourcemanager
Revision: 167
Author: marvintm
Date: 2008-11-11 17:55:59 +0100 (Tue, 11 Nov 2008)

Backport of bug 5517. While applying customized foreign keys, we will save the table name to prevent problems

---
U branches/r0.7x/src/org/apache/ddlutils/alteration/AddForeignKeyChange.java
---

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