Hello,

I'm trying to update from 10.1.2 to 10.2 (on SLES 10 SP2) and the update is
failing. I have deleted all other system updates, then downloaded the "ZCM
10.2 upgrade manual import file," verified its md5sum and imported it as per
its instructions
(http://download.novell.com/protected...d=W_T0ccigI8w~)

At this point, I am attempting to update the primary server only (via
"Deploy/ Selected devices").

The message below appears in
/var/opt/novell/log/zenworks/loader-messages.log.

I do see TIDs referencing "ZCM 10.0.3 to 10.1 Schema Repair Utility" (see
TID 3486285) but I would think that's unnecessary as we're already at
10.1.2.

Appreciate any additional troubleshooting pointers.

Thanks - Andy



[DEBUG] [6/5/09 11:07:21 AM] [] [Loader.SystemUpdateModule] [FINER: Error
executing schema_update.sql] [FINER: Error executing schema_update.sql]
[com.novell.zenworks.datamodel.exceptions.InternalD ataModelException: Error
executing SQL: --^M
-- zAdminRole FOREIGN KEYS^M
--^M
^M
if not exists (select role from sysforeignkeys where role=
'fk_zAdminRole_adminUID') then^M
ALTER TABLE zAdminRole ADD CONSTRAINT fk_zAdminRole_adminUID FOREIGN KEY
(adminUID) REFERENCES zAdministrator (ZUID)^M
ON DELETE
CASCADE^M
ON UPDATE
RESTRICT;^M
end if;
at
com.novell.zenworks.datamodel.database.SQLExecutor .executeSQLStatements(SQLE
xecutor.java:140)
at
com.novell.zenworks.datamodel.database.SQLExecutor .executeSQLStatements(SQLE
xecutor.java:79)
at
com.novell.zenworks.datamodel.database.SQLExecutor .executeSQL(SQLExecutor.ja
va:66)
at
com.novell.zenworks.systemupdate.PreGlobalAction.e xecute(PreGlobalAction.jav
a:95)
at
com.novell.zenworks.systemupdate.handlers.JarComma ndHandler.executeCommand(J
arCommandHandler.java:82)
at
com.novell.zenworks.systemupdate.handlers.JarComma ndHandler.executeCommand(J
arCommandHandler.java:47)
at
com.novell.zenworks.loader.modules.queue.handlers. ProcessCommandsHandler.exe
cuteCommands(ProcessCommandsHandler.java:65)
at
com.novell.zenworks.loader.modules.queue.handlers. PreGlobalHandler.processAc
tion(PreGlobalHandler.java:91)
at
com.novell.zenworks.loader.modules.queue.runner.Qu eueThreadWorker.processAct
ion(QueueThreadWorker.java:193)
at
com.novell.zenworks.loader.modules.queue.runner.Qu eueThreadWorker.run(QueueT
hreadWorker.java:139)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run Task(ThreadPoolExecutor.ja
va:650)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run (ThreadPoolExecutor.java:6
75)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: [[Sybase]][[ODBC Driver]][[SQL
Anywhere]]No primary key value for foreign key 'fk_zAdminRole_adminUID' in
table 'zAdminRole'
at ianywhere.ml.jdbcodbc.IIStatement.nativeExecuteUpd ate(Native
Method)
at
ianywhere.ml.jdbcodbc.IIStatement.executeUpdate(IS tatement.java:298)
at
ianywhere.ml.jdbcodbc.IStatement.executeUpdate(ISt atement.java:173)
at
com.mchange.v2.c3p0.impl.NewProxyStatement.execute Update(NewProxyStatement.j
ava:64)
at
com.novell.zenworks.datamodel.database.SQLExecutor .executeSQLStatements(SQLE
xecutor.java:109)
... 12 more
] []


--
Andy Smith-Petersen
System Administrator
IT Network Services
University of Southern Maine