0008037: Migration from 2.35mp11 to 2.40mp3 did not work fine

Description

When migrating a 2.35mp11 to a 2.40mp3 I got three errors on the logs. See attach.

Error 1

-- create temporary tables
CREATE GLOBAL TEMPORARY TABLE C_TEMP_SELECTION
(
   C_TEMP_SELECTION_ID NUMBER(10) NOT NULL,
   CONSTRAINT C_TEMP_SELECTION_key PRIMARY KEY (C_TEMP_SELECTION_ID)
  )
  ON COMMIT DELETE ROWS
SQL Command failed with: ORA-00955: name is already used by an existing object

-- END

CREATE GLOBAL TEMPORARY TABLE C_TEMP_SELECTION2
  (
  QUERY_ID NUMBER(10) NOT NULL,
  C_TEMP_SELECTION_ID NUMBER(10) NOT NULL,
   CONSTRAINT C_TEMP_SELECTION2_key PRIMARY KEY (QUERY_ID, C_TEMP_SELECTION_ID)
   )
   ON COMMIT PRESERVE ROWS
Executed 3 SQL command(s) with 2 error(s)

Error 2

SQL Command failed with: ORA-04080: trigger 'AD_COLUMN_TRG2' does not exist

-- END AD_COLUMN_TRG
-- -----------------------------------------------------------------------
-- TRIGGER AD_COLUMN_TRG2
-- -----------------------------------------------------------------------
DROP TRIGGER AD_COLUMN_TRG2
SQL Command failed with: ORA-04080: trigger 'AD_REGISTRATION_INFO_TRG' does not exist

-- END AD_REF_LIST_TRG
-- -----------------------------------------------------------------------
-- TRIGGER AD_REGISTRATION_INFO_TRG
-- -----------------------------------------------------------------------
DROP TRIGGER AD_REGISTRATION_INFO_TRG
SQL Command failed with: ORA-04080: trigger 'AD_SYSTEM_INFO_TRG' does not exist

-- END AD_ROLE_TRG
-- -----------------------------------------------------------------------
-- TRIGGER AD_SYSTEM_INFO_TRG
-- -----------------------------------------------------------------------
DROP TRIGGER AD_SYSTEM_INFO_TRG
SQL Command failed with: ORA-04080: trigger 'AD_TREENODE_TRG' does not exist

-- END AD_TEXTINTERFACES_TRG
-- -----------------------------------------------------------------------
-- TRIGGER AD_TREENODE_TRG
-- -----------------------------------------------------------------------
DROP TRIGGER AD_TREENODE_TRG
SQL Command failed with: ORA-04080: trigger 'C_BANKACCOUNTIBAN_TRG' does not exist

-- END C_ACCTSCHEMA_TRG
-- -----------------------------------------------------------------------
-- TRIGGER C_BANKACCOUNTIBAN_TRG
-- -----------------------------------------------------------------------
DROP TRIGGER C_BANKACCOUNTIBAN_TRG
SQL Command failed with: ORA-04080: trigger 'C_BANKCOUNTRY_TRG' does not exist

-- END C_BANKACCOUNT_TRG
-- -----------------------------------------------------------------------
-- TRIGGER C_BANKCOUNTRY_TRG
-- -----------------------------------------------------------------------
DROP TRIGGER C_BANKCOUNTRY_TRG
SQL Command failed with: ORA-04080: trigger 'C_BP_BANKACCOUNTIBAN_TRG' does not exist

-- END C_BPARTNER_TRG
-- -----------------------------------------------------------------------
-- TRIGGER C_BP_BANKACCOUNTIBAN_TRG
-- -----------------------------------------------------------------------
DROP TRIGGER C_BP_BANKACCOUNTIBAN_TRG
SQL Command failed with: ORA-04080: trigger 'C_BP_SALCATEGORY_TRG' does not exist

-- END C_BP_GROUP_TRG
-- -----------------------------------------------------------------------
-- TRIGGER C_BP_SALCATEGORY_TRG
-- -----------------------------------------------------------------------
DROP TRIGGER C_BP_SALCATEGORY_TRG
SQL Command failed with: ORA-04080: trigger 'C_BP_SALCATEGORY_TRG2' does not exist

-- END C_BP_SALCATEGORY_TRG
-- -----------------------------------------------------------------------
-- TRIGGER C_BP_SALCATEGORY_TRG2
-- -----------------------------------------------------------------------
DROP TRIGGER C_BP_SALCATEGORY_TRG2
SQL Command failed with: ORA-04080: trigger 'C_BUDGETLINE_TRG' does not exist

-- END C_BSTMT_CHK_RESTRICTIONS_TRG
-- -----------------------------------------------------------------------
-- TRIGGER C_BUDGETLINE_TRG
-- -----------------------------------------------------------------------
DROP TRIGGER C_BUDGETLINE_TRG
SQL Command failed with: ORA-04080: trigger 'C_INVOICELINE_TRG3' does not exist

-- END C_INVOICELINE_TRG2
-- -----------------------------------------------------------------------
-- TRIGGER C_INVOICELINE_TRG3
-- -----------------------------------------------------------------------
DROP TRIGGER C_INVOICELINE_TRG3
SQL Command failed with: ORA-04080: trigger 'C_INVOICETAX_TRG2' does not exist

-- END C_INVOICETAX_TRG
-- -----------------------------------------------------------------------
-- TRIGGER C_INVOICETAX_TRG2
-- -----------------------------------------------------------------------
DROP TRIGGER C_INVOICETAX_TRG2
SQL Command failed with: ORA-04080: trigger 'C_LOCATION_TRG' does not exist

-- END C_INVTAX_CHK_RESTRICTIONS_TRG
-- -----------------------------------------------------------------------
-- TRIGGER C_LOCATION_TRG
-- -----------------------------------------------------------------------
DROP TRIGGER C_LOCATION_TRG
SQL Command failed with: ORA-04080: trigger 'C_TAXPAYMENT_TRG' does not exist

-- END C_TAXCATEGORY_TRG
-- -----------------------------------------------------------------------
-- TRIGGER C_TAXPAYMENT_TRG
-- -----------------------------------------------------------------------
DROP TRIGGER C_TAXPAYMENT_TRG
SQL Command failed with: ORA-04080: trigger 'C_TAXREGISTERLINE_TRG' does not exist

-- END C_TAXPAYMENT_TRG
-- -----------------------------------------------------------------------
-- TRIGGER C_TAXREGISTERLINE_TRG
-- -----------------------------------------------------------------------
DROP TRIGGER C_TAXREGISTERLINE_TRG
SQL Command failed with: ORA-04080: trigger 'C_TAXREGISTER_TRG' does not exist

-- END C_TAXREGISTERLINE_TRG
-- -----------------------------------------------------------------------
-- TRIGGER C_TAXREGISTER_TRG
-- -----------------------------------------------------------------------
DROP TRIGGER C_TAXREGISTER_TRG
SQL Command failed with: ORA-04080: trigger 'M_REQUISITIONLINE_TRG' does not exist

-- END M_RAPPEL_INVOICE_TRG
-- -----------------------------------------------------------------------
-- TRIGGER M_REQUISITIONLINE_TRG
-- -----------------------------------------------------------------------
DROP TRIGGER M_REQUISITIONLINE_TRG
SQL Command failed with: ORA-04080: trigger 'M_REQUISITIONORDER_TRG' does not exist

-- END M_REQUISITIONLINE_TRG
-- -----------------------------------------------------------------------
-- TRIGGER M_REQUISITIONORDER_TRG
-- -----------------------------------------------------------------------
DROP TRIGGER M_REQUISITIONORDER_TRG
SQL Command failed with: ORA-04080: trigger 'M_REQUISITION_TRG' does not exist

-- END M_REQUISITIONORDER_TRG
-- -----------------------------------------------------------------------
-- TRIGGER M_REQUISITION_TRG
-- -----------------------------------------------------------------------
DROP TRIGGER M_REQUISITION_TRG
Executed 163 SQL command(s) with 19 error(s)

Error 3

SQL command failed with null
null
org.apache.ddlutils.DatabaseOperationException: Error while enabling foreign key
    at org.apache.ddlutils.platform.oracle.Oracle8Platform.enableAllFK(Unknown Source)
    at org.openbravo.ddlutils.task.AlterCustomizedDatabaseData.execute(Unknown Source)
    at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
    at sun.reflect.GeneratedMethodAccessor1.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:585)
    at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
    at org.apache.tools.ant.Task.perform(Task.java:348)
    at org.apache.tools.ant.Target.execute(Target.java:357)
    at org.apache.tools.ant.Target.performTasks(Target.java:385)
    at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1337)
    at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38)
    at org.apache.tools.ant.Project.executeTargets(Project.java:1189)
    at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:416)
    at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
    at sun.reflect.GeneratedMethodAccessor1.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:585)
    at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
    at org.apache.tools.ant.Task.perform(Task.java:348)
    at org.apache.tools.ant.Target.execute(Target.java:357)
    at org.apache.tools.ant.Target.performTasks(Target.java:385)
    at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1337)
    at org.apache.tools.ant.Project.executeTarget(Project.java:1306)
    at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
    at org.apache.tools.ant.Project.executeTargets(Project.java:1189)
    at org.apache.tools.ant.Main.runBuild(Main.java:758)
    at org.apache.tools.ant.Main.startAnt(Main.java:217)
    at org.apache.tools.ant.launch.Launcher.run(Launcher.java:257)
    at org.apache.tools.ant.launch.Launcher.main(Launcher.java:104)
Caused by: java.lang.NullPointerException
    at org.apache.ddlutils.platform.SqlBuilder.getStructureObjectName(Unknown Source)
    at org.apache.ddlutils.platform.SqlBuilder.writeExternalForeignKeyCreateStmt(Unknown Source)
    at org.apache.ddlutils.platform.SqlBuilder.createExternalForeignKeys(Unknown Source)
    ... 30 more
Error while enabling foreign key
Executing default postscript
Executed 10 SQL command(s) with 0 error(s)

Notes
(0014553) shuehner (administrator) 2009-03-10 14:44	Afaik the Error #1 (about the C_TEMP_SELECTION, and C_TEMP_SELECTION2) tables can be ignored, it shows up on every update.database in 2.40. For details please check with marvintm

(0014556) hgbot (developer) 2009-03-10 16:31	Repository: erp/stable/2.40 Changeset: a36470e5be9d89b0a1a7676e39385f5801928234 Author: Antonio Moreno <antonio.moreno <at> openbravo.com> Date: Tue Mar 10 16:34:53 2009 +0100 URL: http://code.openbravo.com/erp/stable/2.40/rev/a36470e5be9d89b0a1a7676e39385f5801928234 [^] Fixed issue 8037. Update.customized.database should now work with MP3 --- M src-db/database/lib/dbsourcemanager.jar ---

Issue History
Date Modified	Username	Field	Change
2009-03-10 10:48	plujan	New Issue
2009-03-10 10:48	plujan	Assigned To	=> jpabloae
2009-03-10 11:17	jpabloae	Assigned To	jpabloae => marvintm
2009-03-10 14:44	shuehner	Note Added: 0014553
2009-03-10 15:34	Dowid	Issue Monitored: Dowid
2009-03-10 16:05	plujan	Description Updated
2009-03-10 16:31	hgbot	Checkin
2009-03-10 16:31	hgbot	Note Added: 0014556
2009-03-10 16:31	hgbot	Status	new => resolved
2009-03-10 16:31	hgbot	Resolution	open => fixed
2009-03-10 16:31	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/stable/2.40/rev/a36470e5be9d89b0a1a7676e39385f5801928234 [^]
2009-03-16 17:43	plujan	Status	resolved => closed
2012-07-19 13:11	gorka_gil	Category	Appliance stack => Appliance rPath

Relationships [ Relation Graph ] [ Dependency Graph ]