Hi,
When deploying (using stages) to our first server update fails because of "An unexpected error occurred during the zone-wide pre-install actions. Check the loader-messages.log for details. ".

Below is the error message i find in loader-messages.log.



[DEBUG] [6/10/09 9:28:10 PM] [] [Loader.SystemUpdateModule] [FINER: Error executing discovery_schema_update.sql] [FINER: Error executing discover
y_schema_update.sql] [com.novell.zenworks.datamodel.exceptions.InternalD ataModelException: Error executing SQL: alter table NC_NetworkDeviceBase
alter column PrimaryIPAddress nvarchar(42)
at com.novell.zenworks.datamodel.database.SQLExecutor .executeSQLStatements(SQLExecutor.java:140)
at com.novell.zenworks.datamodel.database.SQLExecutor .executeSQLStatements(SQLExecutor.java:79)
at com.novell.zenworks.datamodel.database.SQLExecutor .executeSQL(SQLExecutor.java:66)
at com.novell.zenworks.systemupdate.PreGlobalAction.e xecute(PreGlobalAction.java:95)
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:92)
at com.novell.zenworks.loader.modules.queue.runner.Qu eueThreadWorker.processAction(QueueThreadWorker.ja va:193)
at com.novell.zenworks.loader.modules.queue.runner.Qu eueThreadWorker.run(QueueThreadWorker.java:139)
at java.util.concurrent.ThreadPoolExecutor$Worker.run Task(ThreadPoolExecutor.java:650)
at java.util.concurrent.ThreadPoolExecutor$Worker.run (ThreadPoolExecutor.java:675)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: The index 'idx_NC_NDB_PrimaryIPAddr' is dependent on column 'PrimaryIPAddress'.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnos tic(SQLDiagnostic.java:365)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(Td sCore.java:2781)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCor e.java:2224)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(T dsCore.java:628)
at net.sourceforge.jtds.jdbc.JtdsStatement.processRes ults(JtdsStatement.java:525)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL (JtdsStatement.java:487)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeImp l(JtdsStatement.java:664)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpd ate(JtdsStatement.java:1120)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpd ate(JtdsStatement.java:1073)
at com.mchange.v2.c3p0.impl.NewProxyStatement.execute Update(NewProxyStatement.java:64)
at com.novell.zenworks.datamodel.database.SQLExecutor .executeSQLStatements(SQLExecutor.java:109)
... 12 more
] []
[DEBUG] [6/10/09 9:28:15 PM] [] [Loader.SystemUpdateModule] [FINER: Executing: sql-server/discovery_schema_update.sql] [FINER: Executing: sql-ser
ver/discovery_schema_update.sql] [] []
[DEBUG] [6/10/09 9:28:15 PM] [] [Loader.SystemUpdateModule] [FINER: Error executing discovery_schema_update.sql] [FINER: Error executing discover
y_schema_update.sql] [com.novell.zenworks.datamodel.exceptions.InternalD ataModelException: Error executing SQL: alter table NC_NetworkDeviceBase
alter column PrimaryIPAddress nvarchar(42)
at com.novell.zenworks.datamodel.database.SQLExecutor .executeSQLStatements(SQLExecutor.java:140)
at com.novell.zenworks.datamodel.database.SQLExecutor .executeSQLStatements(SQLExecutor.java:79)
at com.novell.zenworks.datamodel.database.SQLExecutor .executeSQL(SQLExecutor.java:66)



Has anyone had the same problem with the same sql-script? How can we fix it?

And some other scripts has already run before this, will this be a problem?

Please advice.