Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0005517
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] Y. DBSourceManagercriticalalways2008-10-14 11:372009-04-22 00:00
ReporterjpabloaeView Statuspublic 
Assigned Tomarvintm 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision167
ProjectionnoneETAnoneTarget Version
OSLinux 64 bitDatabaseOracleJava version1.5.0_16
OS VersionDatabase version11gAnt version1.7.1
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0005517: 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
Tagsdbsm_migrate
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0009614)
svnbot (reporter)
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 (reporter)
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 (reporter)
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 [^]

- Issue History
Date Modified Username Field Change
2008-10-14 11:37 jpabloae New Issue
2008-10-14 11:37 jpabloae Assigned To => marvintm
2008-10-16 10:59 pjuvara Severity major => critical
2008-10-16 17:55 svnbot Checkin
2008-10-16 17:55 svnbot Note Added: 0009614
2008-10-16 17:55 svnbot Status new => resolved
2008-10-16 17:55 svnbot Resolution open => fixed
2008-10-16 17:55 svnbot svn_revision => 145
2008-10-16 18:14 svnbot Checkin
2008-10-16 18:14 svnbot Note Added: 0009615
2008-10-16 18:14 svnbot svn_revision 145 => 146
2008-11-11 17:56 svnbot Checkin
2008-11-11 17:56 svnbot Note Added: 0010178
2008-11-11 17:56 svnbot svn_revision 146 => 167
2008-12-18 12:38 jpabloae Sticky Issue No => Yes
2008-12-18 12:39 jpabloae Sticky Issue Yes => No
2008-12-18 12:39 jpabloae Tag Attached: dbsm_migrate
2008-12-18 12:41 jpabloae Project @4@ => Openbravo ERP
2008-12-18 12:41 jpabloae Category => Y. DBSourceManager
2009-04-21 11:07 psarobe Status resolved => closed
2009-04-22 00:00 anonymous sf_bug_id 0 => 2777906


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker