Hi!

Was trying an upgrade from 10.3.1 to 10.3.3 on sles10sp2, but I got errors.
Looking in loader-messages it is refering to the external database, which also is on a sles10sp2.
Other updates has gone rather smooth, but not this one.

Anyone got a clue how to upgrade/update the database?

/P


[DEBUG] [5/24/11 12:20:25 PM] [] [Loader.SystemUpdateModule] [] [FINER: Executing:
v_10_3_3/sql-anywhere/schema_update_10.3.3.sql] [] []
[DEBUG] [5/24/11 12:20:25 PM] [] [Loader.SystemUpdateModule] [] [FINER: Error executing schema_update_10.3.3.sql]
[com.novell.zenworks.datamodel.exceptions.InternalD ataModelException: Error executing SQL: ALTER TABLE
zZENServerSchedule DELETE FOREIGN KEY fk_zZENServerSchedul_ZENServer;
at com.novell.zenworks.datamodel.database.SQLExecutor .executeSQLStatements(SQLExecutor.java:142)
at com.novell.zenworks.datamodel.database.SQLExecutor .executeSQLStatements(SQLExecutor.java:81)
at com.novell.zenworks.datamodel.database.SQLExecutor .executeSQL(SQLExecutor.java:68)
at com.novell.zenworks.systemupdate.v_10_3_3.PreGloba lAction.execute(PreGlobalAction.java:116)
at com.novell.zenworks.systemupdate.handlers.JarComma ndHandler.executeCommand(JarCommandHandler.java:82 )
at com.novell.zenworks.systemupdate.handlers.JarComma ndHandler.executeCommand(JarCommandHandler.java:47 )
at
com.novell.zenworks.loader.modules.queue.handlers. ProcessCommandsHandler.executeCommands(ProcessComm andsHandler.java:65)
at com.novell.zenworks.loader.modules.queue.handlers. PreGlobalHandler.processAction(PreGlobalHandler.ja va:93)
at com.novell.zenworks.loader.modules.queue.runner.Qu eueThreadWorker.processAction(QueueThreadWorker.ja va:208)
at com.novell.zenworks.loader.modules.queue.runner.Qu eueThreadWorker.run(QueueThreadWorker.java:139)
at java.util.concurrent.ThreadPoolExecutor$Worker.run Task(ThreadPoolExecutor.java:651)
at java.util.concurrent.ThreadPoolExecutor$Worker.run (ThreadPoolExecutor.java:676)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: [[Sybase]][[ODBC Driver]][[SQL Anywhere]]Foreign key name
'fk_zZENServerSchedul_ZENServer' not found
at ianywhere.ml.jdbcodbc.IIStatement.nativeExecuteUpd ate(Native Method)
at ianywhere.ml.jdbcodbc.IIStatement.executeUpdate(IS tatement.java:362)
at ianywhere.ml.jdbcodbc.IStatement.executeUpdate(ISt atement.java:215)
at com.mchange.v2.c3p0.impl.NewProxyStatement.execute Update(NewProxyStatement.java:64)
at com.novell.zenworks.datamodel.database.SQLExecutor .executeSQLStatements(SQLExecutor.java:111)
... 12 more
] []
[DEBUG] [5/24/11 12:20:30 PM] [] [Loader.SystemUpdateModule] [] [FINER: Error executing schema_update_10.3.3.sql. Max
number of retries reached. Unable to succesfully execute this sql file] [] []
[DEBUG] [5/24/11 12:20:30 PM] [] [Loader.SystemUpdateModule] [] [FINE: Exception during pre-global-actions]
[com.novell.zenworks.systemupdate.exceptions.System UpdateException: Unable to update database schema
at com.novell.zenworks.systemupdate.v_10_3_3.PreGloba lAction.execute(PreGlobalAction.java:139)
at com.novell.zenworks.systemupdate.handlers.JarComma ndHandler.executeCommand(JarCommandHandler.java:82 )
at com.novell.zenworks.systemupdate.handlers.JarComma ndHandler.executeCommand(JarCommandHandler.java:47 )
at
com.novell.zenworks.loader.modules.queue.handlers. ProcessCommandsHandler.executeCommands(ProcessComm andsHandler.java:65)
at com.novell.zenworks.loader.modules.queue.handlers. PreGlobalHandler.processAction(PreGlobalHandler.ja va:93)
at com.novell.zenworks.loader.modules.queue.runner.Qu eueThreadWorker.processAction(QueueThreadWorker.ja va:208)
at com.novell.zenworks.loader.modules.queue.runner.Qu eueThreadWorker.run(QueueThreadWorker.java:139)
at java.util.concurrent.ThreadPoolExecutor$Worker.run Task(ThreadPoolExecutor.java:651)
at java.util.concurrent.ThreadPoolExecutor$Worker.run (ThreadPoolExecutor.java:676)
at java.lang.Thread.run(Thread.java:595)
Caused by: com.novell.zenworks.datamodel.exceptions.InternalD ataModelException: Error executing SQL: ALTER TABLE
zZENServerSchedule DELETE FOREIGN KEY fk_zZENServerSchedul_ZENServer;
at com.novell.zenworks.datamodel.database.SQLExecutor .executeSQLStatements(SQLExecutor.java:142)
at com.novell.zenworks.datamodel.database.SQLExecutor .executeSQLStatements(SQLExecutor.java:81)
at com.novell.zenworks.datamodel.database.SQLExecutor .executeSQL(SQLExecutor.java:68)
at com.novell.zenworks.systemupdate.v_10_3_3.PreGloba lAction.execute(PreGlobalAction.java:116)
... 9 more
Caused by: java.sql.SQLException: [[Sybase]][[ODBC Driver]][[SQL Anywhere]]Foreign key name
'fk_zZENServerSchedul_ZENServer' not found
at ianywhere.ml.jdbcodbc.IIStatement.nativeExecuteUpd ate(Native Method)
at ianywhere.ml.jdbcodbc.IIStatement.executeUpdate(IS tatement.java:362)
at ianywhere.ml.jdbcodbc.IStatement.executeUpdate(ISt atement.java:215)
at com.mchange.v2.c3p0.impl.NewProxyStatement.execute Update(NewProxyStatement.java:64)
at com.novell.zenworks.datamodel.database.SQLExecutor .executeSQLStatements(SQLExecutor.java:111)
... 12 more
] []
[DEBUG] [5/24/11 12:20:30 PM] [] [Loader.SystemUpdateModule] [] [FINE: Unable to run global pre actions]
[com.novell.zenworks.systemupdate.exceptions.System UpdateException: Unable to launch custom action command
at com.novell.zenworks.systemupdate.handlers.JarComma ndHandler.executeCommand(JarCommandHandler.java:51 )
at
com.novell.zenworks.loader.modules.queue.handlers. ProcessCommandsHandler.executeCommands(ProcessComm andsHandler.java:65)
at com.novell.zenworks.loader.modules.queue.handlers. PreGlobalHandler.processAction(PreGlobalHandler.ja va:93)
at com.novell.zenworks.loader.modules.queue.runner.Qu eueThreadWorker.processAction(QueueThreadWorker.ja va:208)
at com.novell.zenworks.loader.modules.queue.runner.Qu eueThreadWorker.run(QueueThreadWorker.java:139)
at java.util.concurrent.ThreadPoolExecutor$Worker.run Task(ThreadPoolExecutor.java:651)
at java.util.concurrent.ThreadPoolExecutor$Worker.run (ThreadPoolExecutor.java:676)
at java.lang.Thread.run(Thread.java:595)
Caused by: com.novell.zenworks.systemupdate.exceptions.System UpdateException: Unable to launch custom action command
at com.novell.zenworks.systemupdate.handlers.JarComma ndHandler.executeCommand(JarCommandHandler.java:91 )
at com.novell.zenworks.systemupdate.handlers.JarComma ndHandler.executeCommand(JarCommandHandler.java:47 )
... 7 more
Caused by: com.novell.zenworks.systemupdate.exceptions.System UpdateException: Unable to update database schema
at com.novell.zenworks.systemupdate.v_10_3_3.PreGloba lAction.execute(PreGlobalAction.java:139)
at com.novell.zenworks.systemupdate.handlers.JarComma ndHandler.executeCommand(JarCommandHandler.java:82 )
... 8 more
Caused by: com.novell.zenworks.datamodel.exceptions.InternalD ataModelException: Error executing SQL: ALTER TABLE
zZENServerSchedule DELETE FOREIGN KEY fk_zZENServerSchedul_ZENServer;
at com.novell.zenworks.datamodel.database.SQLExecutor .executeSQLStatements(SQLExecutor.java:142)
at com.novell.zenworks.datamodel.database.SQLExecutor .executeSQLStatements(SQLExecutor.java:81)
at com.novell.zenworks.datamodel.database.SQLExecutor .executeSQL(SQLExecutor.java:68)
at com.novell.zenworks.systemupdate.v_10_3_3.PreGloba lAction.execute(PreGlobalAction.java:116)
... 9 more
Caused by: java.sql.SQLException: [[Sybase]][[ODBC Driver]][[SQL Anywhere]]Foreign key name
'fk_zZENServerSchedul_ZENServer' not found
at ianywhere.ml.jdbcodbc.IIStatement.nativeExecuteUpd ate(Native Method)
at ianywhere.ml.jdbcodbc.IIStatement.executeUpdate(IS tatement.java:362)
at ianywhere.ml.jdbcodbc.IStatement.executeUpdate(ISt atement.java:215)
at com.mchange.v2.c3p0.impl.NewProxyStatement.execute Update(NewProxyStatement.java:64)
at com.novell.zenworks.datamodel.database.SQLExecutor .executeSQLStatements(SQLExecutor.java:111)
... 12 more
] []
[DEBUG] [5/24/11 12:20:30 PM] [] [Loader.SystemUpdateModule] [] [FINER: An exception was encountered during pre-global
actions...attempting to cancel any pending update assignments] [] []
[DEBUG] [5/24/11 12:20:30 PM] [] [Loader.SystemUpdateModule] [] [FINER: getting query string for
ALL_DEVICES_DIRECTLY_ASSIGNED when no stages exist] [] []
[DEBUG] [5/24/11 12:20:30 PM] [] [Loader.SystemUpdateModule] [] [FINER: query: from Device d where
d.UID in (select Distinct d1.UID from Device d1, Assignment a, SystemUpdateDeviceInfo s, Grouping g where
a.ContentUID = ?
AND d1.UID = s.DeviceUID
AND s.UpdateUID = ?
AND (d1.UID = g.memberUID and a.ConsumerUID = g.groupUID)
AND (d1.Retired = 0 OR s.isIgnored = 0)
and s.UpdateStatus in ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
or d.UID in (select Distinct d1.UID from Device d1, Assignment a, SystemUpdateDeviceInfo s where
a.ContentUID = ?
AND d1.UID = s.DeviceUID
AND s.UpdateUID = ?AND d1.UID = a.ConsumerUID
AND (d1.Retired = 0 OR s.isIgnored = 0)
and s.UpdateStatus in ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))] [] []
[DEBUG] [5/24/11 12:20:30 PM] [] [Loader.SystemUpdateModule] [] [FINEST: Objects are not assigned to update]
[com.novell.zenworks.datamodel.exceptions.ObjectsNo tAssignedException: Consumer: /~devices~, Content:
5010030300bcf28ea3110aae5d457fde, Type: SystemUpdateAssignment
at
com.novell.zenworks.datamodel.session.hibernate.Hi bernateAssignmentSession.getAssignment(HibernateAs signmentSession.java:621)
at
com.novell.zenworks.datamodel.session.hibernate.Hi bernateAssignmentSession.removeAssignment(Hibernat eAssignmentSession.java:667)
at com.novell.zenworks.datamodel.services.assignments .AssignmentImpl.removeAssignment(AssignmentImpl.ja va:449)
at
com.novell.zenworks.datamodel.services.systemupdat e.SystemUpdateAdminImpl2.unassignUpdate(SystemUpda teAdminImpl2.java:1920)
at
com.novell.zenworks.datamodel.services.systemupdat e.SystemUpdateAdminImpl2.cancelStage(SystemUpdateA dminImpl2.java:2630)
at
com.novell.zenworks.loader.modules.queue.handlers. PreGlobalHandler.handlePreGlobalFailure(PreGlobalH andler.java:246)
at com.novell.zenworks.loader.modules.queue.handlers. PreGlobalHandler.processAction(PreGlobalHandler.ja va:153)
at com.novell.zenworks.loader.modules.queue.runner.Qu eueThreadWorker.processAction(QueueThreadWorker.ja va:208)
at com.novell.zenworks.loader.modules.queue.runner.Qu eueThreadWorker.run(QueueThreadWorker.java:139)
at java.util.concurrent.ThreadPoolExecutor$Worker.run Task(ThreadPoolExecutor.java:651)
at java.util.concurrent.ThreadPoolExecutor$Worker.run (ThreadPoolExecutor.java:676)
at java.lang.Thread.run(Thread.java:595)

----------------------------
Paul Thurn - Skulking along since Nw2.15
----------------------------
Never argue with an idiot. They drag you down to their level and beat you with experience.