Openbravo Issue Tracking System - Openbravo Deployment Options | |||||
View Issue Details | |||||
ID | Project | Category | View Status | Date Submitted | Last Update |
0008037 | Openbravo Deployment Options | Appliance rPath | public | 2009-03-10 10:48 | 2009-08-31 16:23 |
Reporter | plujan | ||||
Assigned To | marvintm | ||||
Priority | urgent | Severity | critical | Reproducibility | have not tried |
Status | closed | Resolution | fixed | ||
Platform | OS | 5 | OS Version | ||
Product Version | 2.40MP3 | ||||
Target Version | Fixed in Version | 2.40MP4 | |||
Merge Request Status | |||||
Review Assigned To | |||||
Support ticket | |||||
OBNetwork customer | |||||
Summary | 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) | ||||
Steps To Reproduce | |||||
Proposed Solution | |||||
Additional Information | |||||
Tags | No tags attached. | ||||
Relationships | |||||
Attached Files | |||||
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 |
Notes | |||||
|
|||||
|
|
||||
|
|||||
|
|