Details
-
Fix
-
Status: Resolved (View Workflow)
-
Minor
-
Resolution: Fixed
-
None
-
None
Description
As of now Situation
- When user try to upgrade earlier release of 1.10.0-SNAPSHOT with latest release, Setup throws and error
Es gibt bereits ein Objekt mit diesem Namen
- its logical since this table is already being renamed to jade_ etc.
- But if user will upgrade 1.10.0 to 1.10.1 then will this issue occur?
Install Log Snippet
+------------------------------------------------------------------------------------------------------------------------ | Initial database +------------------------------------------------------------------------------------------------------------------------ ... the database management system is Oracle ... create database tables which not already exist ... sos.connection.SOSConnectionFileProcessor.process(137): process file C:\Program Files\sos-berlin.com\jobscheduler\1.10-snapshot_4410\db\oracle\sosftphistory_to_jadehistory_rename.sql ... error occurred: java.sql.SQLException: sos.connection.SOSConnectionFileProcessor.process(137): an error occurred processing file [C:\Program Files\sos-berlin.com\jobscheduler\1.10-snapshot_4410\db\oracle\sosftphistory_to_jadehistory_rename.sql]: sos.connection.SOSConnection.executeStatements(3173) : java.sql.BatchUpdateException: Fehler bei Stapelverarbeitung aufgetreten: ORA-00955: Es gibt bereits ein Objekt mit diesem Namen at com.sos.izpack.process.InstallDbTables.parseStdout(InstallDbTables.java:322) at com.sos.izpack.process.InstallDbTables.execSql(InstallDbTables.java:272) at com.sos.izpack.process.InstallDbTables.execSql(InstallDbTables.java:157) at com.sos.izpack.process.InstallDbTables.execSql(InstallDbTables.java:173) at com.sos.izpack.process.InstallDbTables.execSql(InstallDbTables.java:157) at com.sos.izpack.process.InstallDbTables.execSqls(InstallDbTables.java:128) at com.sos.izpack.process.InstallDbTables.run(InstallDbTables.java:67) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:497) at com.izforge.izpack.installer.ProcessPanelWorker$ExecutableClass.run(Unknown Source) at com.izforge.izpack.installer.ProcessPanelWorker$ProcessingJob.run(Unknown Source) at com.izforge.izpack.installer.ProcessPanelWorker.run(Unknown Source) at java.lang.Thread.run(Thread.java:745)
How to reproduce
Let the 1.10.0-SNAPSHOT upgrade run two time on same JobScheduler instance and issue will appear