While trying to Upgrade our test-zone from 11.4.0 to 2017 the updater stops with the following error from system-update log.

Any ideas? The DB is running on an external MSSQL server.

ERROR 06/30/2017 08:24:08 Exception while upgrading database schema. INFO: Setting log level to : FINER [2017.06.30-08:24:07] FINER: Setting schema version in DB. INFO: PreGlobalActions launched from media upgrade. FINER: Setting the status to IN_PROGRESS for update : 5017000000fc50000000002016121615 INFO: Attempting to create connection for schema : ZCM FINE: Updating zOpaqueData affected : 1 rows. INFO: Current zone version is (11.4.0), PreGlobal version is (17.0.0.1252) FINE: Available updates : [pre-update, v_11_4_1, v_11_4_2, v_11_4_3, v_12_0_1, v_12_0_2, v_17_0_0, post-update] FINE: Will create Preglobal Upgrade Log table if required.. FINE: Got 2 SQLs to execute. INFO: PreglobalUpgradeLog table already has 78 commands already loaded for current update : 5017000000fc50000000002016121615 FINER: Loading SU Metadata for Update : pre-update to db. INFO: No sqls specified for database : SQLServer, Version : pre-update, Update :5017000000fc50000000002016121615. Not loading SQLs. INFO: Completed loading of SU Metadata for Update : pre-update to db. INFO: Preglobal version 17.0.0.1252 is higher than zone version : 11.4.0 INFO: Comparing UpdateVersion : 11.4.1 against the latest version :17.0.0.1252 INFO: ShouldRunUpdateScripts : false INFO: Skipping processing of pre global action for the version : v_11_4_1 as current zone version 11.4.0 is newer. INFO: Preglobal version 17.0.0.1252 is higher than zone version : 11.4.0 INFO: Comparing UpdateVersion : 11.4.2 against the latest version :17.0.0.1252 INFO: ShouldRunUpdateScripts : false INFO: Skipping processing of pre global action for the version : v_11_4_2 as current zone version 11.4.0 is newer. INFO: Preglobal version 17.0.0.1252 is higher than zone version : 11.4.0 INFO: Comparing UpdateVersion : 11.4.3 against the latest version :17.0.0.1252 INFO: ShouldRunUpdateScripts : false INFO: Skipping processing of pre global action for the version : v_11_4_3 as current zone version 11.4.0 is newer. INFO: Preglobal version 17.0.0.1252 is higher than zone version : 11.4.0 INFO: Comparing UpdateVersion : 12.0.1 against the latest version :17.0.0.1252 INFO: ShouldRunUpdateScripts : false INFO: Skipping processing of pre global action for the version : v_12_0_1 as current zone version 11.4.0 is newer. INFO: Preglobal version 17.0.0.1252 is higher than zone version : 11.4.0 INFO: Comparing UpdateVersion : 12.0.2 against the latest version :17.0.0.1252 INFO: ShouldRunUpdateScripts : false INFO: Skipping processing of pre global action for the version : v_12_0_2 as current zone version 11.4.0 is newer. INFO: Preglobal version 17.0.0.1252 is higher than zone version : 11.4.0 INFO: Comparing UpdateVersion : 17.0.0.1252 against the latest version :17.0.0.1252 INFO: ShouldRunUpdateScripts : true INFO: Update details for update : v_17_0_0 already loaded in DB. Skipping it. INFO: Update details for update : post-update already loaded in DB. Skipping it. INFO: Need to update 3 version : [pre-update, v_17_0_0, post-update] INFO: Updating schema to version : pre-update INFO: Need to perform 0 actions for upgrading to version : pre-update INFO: Schema updated to version : pre-update successfully. INFO: Setting pre-global version to : 17.0.0.1252 FINE: Updating zOpaqueData affected : 1 rows. INFO: Updating schema to version : 17.0.0 INFO: Need to perform 9 actions for upgrading to version : v_17_0_0 FINE: Executing [ID=>52, Schema => ZCM, Action => EXEC_SQL, Version => v_17_0_0, Entry => /system-updates/v_17_0_0/sql-server/assetmanagement_update.sql] FINE: Got 10 SQLs to execute. INFO: Attempt 1 of executing SQL [update zSystemSetting set Data=REPLACE(data,'<SkipDirectories>','<SkipDirect ories><Item>C:\$Recycle.Bin</Item>') where Name='inventorysw' and CHARINDEX('C:\$Recycle.Bin',Data)=0;] failed with exception : Argument data type ntext is invalid for argument 1 of replace function.. Retrying... INFO: Attempt 2 of executing SQL [update zSystemSetting set Data=REPLACE(data,'<SkipDirectories>','<SkipDirect ories><Item>C:\$Recycle.Bin</Item>') where Name='inventorysw' and CHARINDEX('C:\$Recycle.Bin',Data)=0;] failed with exception : Argument data type ntext is invalid for argument 1 of replace function.. Retrying... INFO: Attempt 3 of executing SQL [update zSystemSetting set Data=REPLACE(data,'<SkipDirectories>','<SkipDirect ories><Item>C:\$Recycle.Bin</Item>') where Name='inventorysw' and CHARINDEX('C:\$Recycle.Bin',Data)=0;] failed with exception : Argument data type ntext is invalid for argument 1 of replace function.. Retrying... INFO: Attempt 4 of executing SQL [update zSystemSetting set Data=REPLACE(data,'<SkipDirectories>','<SkipDirect ories><Item>C:\$Recycle.Bin</Item>') where Name='inventorysw' and CHARINDEX('C:\$Recycle.Bin',Data)=0;] failed with exception : Argument data type ntext is invalid for argument 1 of replace function.. Retrying... SEVERE: Attempt 5 of executing SQL [update zSystemSetting set Data=REPLACE(data,'<SkipDirectories>','<SkipDirect ories><Item>C:\$Recycle.Bin</Item>') where Name='inventorysw' and CHARINDEX('C:\$Recycle.Bin',Data)=0;] failed with exception : Argument data type ntext is invalid for argument 1 of replace function. java.sql.SQLException: Argument data type ntext is invalid for argument 1 of replace function. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnos tic(SQLDiagnostic.java:372) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(Td sCore.java:2988) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCor e.java:2421) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(T dsCore.java:671) at net.sourceforge.jtds.jdbc.JtdsStatement.processRes ults(JtdsStatement.java:613) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL (JtdsStatement.java:572) at net.sourceforge.jtds.jdbc.JtdsStatement.executeImp l(JtdsStatement.java:809) at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpd ate(JtdsStatement.java:1288) at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpd ate(JtdsStatement.java:1241) at com.novell.zenworks.systemupdate.utils.SQLUtils.ex ecuteSQLStatements(SQLUtils.java:141) at com.novell.zenworks.systemupdate.utils.SQLUtils.ex ecuteSQLStatements(SQLUtils.java:86) at com.novell.zenworks.systemupdate.utils.SQLUtils.ex ecuteSQL(SQLUtils.java:60) at com.novell.zenworks.systemupdate.executor.SQLExecu tor.execute(SQLExecutor.java:72) at com.novell.zenworks.systemupdate.executor.SystemUp dateExecutor.doUpdate(SystemUpdateExecutor.java:64 ) at com.novell.zenworks.systemupdate.PreGlobalAction.r unPreGlobalForUpdates(PreGlobalAction.java:465) at com.novell.zenworks.systemupdate.PreGlobalAction.p rocessAction(PreGlobalAction.java:372) at com.novell.zenworks.systemupdate.PreGlobalAction.e xecute(PreGlobalAction.java:212) at com.novell.zenworks.configure.actions.ExecutePreGl obalConfigureAction.configure(ExecutePreGlobalConf igureAction.java:206) at com.novell.zenworks.configure.actions.ExecutePreGl obalConfigureAction.main(ExecutePreGlobalConfigure Action.java:259) SEVERE: Exception while executing SQLs from /system-updates/v_17_0_0/sql-server/assetmanagement_update.sql SEVERE: Exception while executing action /system-updates/v_17_0_0/sql-server/assetmanagement_update.sql for version : v_17_0_0 com.novell.zenworks.systemupdate.exceptions.PreGlo balException: com.novell.zenworks.systemupdate.exceptions.PreGlo balException: Error executing SQL: update zSystemSetting set Data=REPLACE(data,'<SkipDirectories>','<SkipDirect ories><Item>C:\$Recycle.Bin</Item>') where Name='inventorysw' and CHARINDEX('C:\$Recycle.Bin',Data)=0; at com.novell.zenworks.systemupdate.utils.SQLUtils.ex ecuteSQLStatements(SQLUtils.java:245) at com.novell.zenworks.systemupdate.utils.SQLUtils.ex ecuteSQLStatements(SQLUtils.java:86) at com.novell.zenworks.systemupdate.utils.SQLUtils.ex ecuteSQL(SQLUtils.java:60) at com.novell.zenworks.systemupdate.executor.SQLExecu tor.execute(SQLExecutor.java:72) at com.novell.zenworks.systemupdate.executor.SystemUp dateExecutor.doUpdate(SystemUpdateExecutor.java:64 ) at com.novell.zenworks.systemupdate.PreGlobalAction.r unPreGlobalForUpdates(PreGlobalAction.java:465) at com.novell.zenworks.systemupdate.PreGlobalAction.p rocessAction(PreGlobalAction.java:372) at com.novell.zenworks.systemupdate.PreGlobalAction.e xecute(PreGlobalAction.java:212) at com.novell.zenworks.configure.actions.ExecutePreGl obalConfigureAction.configure(ExecutePreGlobalConf igureAction.java:206) at com.novell.zenworks.configure.actions.ExecutePreGl obalConfigureAction.main(ExecutePreGlobalConfigure Action.java:259) Caused by: com.novell.zenworks.systemupdate.exceptions.PreGlo balException: Error executing SQL: update zSystemSetting set Data=REPLACE(data,'<SkipDirectories>','<SkipDirect ories><Item>C:\$Recycle.Bin</Item>') where Name='inventorysw' and CHARINDEX('C:\$Recycle.Bin',Data)=0; at com.novell.zenworks.systemupdate.utils.SQLUtils.ex ecuteSQLStatements(SQLUtils.java:204) ... 9 more Caused by: java.sql.SQLException: Argument data type ntext is invalid for argument 1 of replace function. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnos tic(SQLDiagnostic.java:372) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(Td sCore.java:2988) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCor e.java:2421) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(T dsCore.java:671) at net.sourceforge.jtds.jdbc.JtdsStatement.processRes ults(JtdsStatement.java:613) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL (JtdsStatement.java:572) at net.sourceforge.jtds.jdbc.JtdsStatement.executeImp l(JtdsStatement.java:809) at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpd ate(JtdsStatement.java:1288) at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpd ate(JtdsStatement.java:1241) at com.novell.zenworks.systemupdate.utils.SQLUtils.ex ecuteSQLStatements(SQLUtils.java:141) ... 9 more SEVERE: Execution of update action : /system-updates/v_17_0_0/sql-server/assetmanagement_update.sql of type : EXEC_SQL failed. Check logs for more details. SEVERE: Failed to update schema to version : v_17_0_0. Check pre-global logs for more details. INFO: Exception during pre-global-actions com.novell.zenworks.systemupdate.exceptions.PreGlo balException: Schema upgrade failed. Check the pre-global-update.log for more details. at com.novell.zenworks.systemupdate.PreGlobalAction.p rocessAction(PreGlobalAction.java:380) at com.novell.zenworks.systemupdate.PreGlobalAction.e xecute(PreGlobalAction.java:212) at com.novell.zenworks.configure.actions.ExecutePreGl obalConfigureAction.configure(ExecutePreGlobalConf igureAction.java:206) at com.novell.zenworks.configure.actions.ExecutePreGl obalConfigureAction.main(ExecutePreGlobalConfigure Action.java:259) FINER: Setting the status to FAILED for update : 5017000000fc50000000002016121615 FINE: Updating zOpaqueData affected : 1 rows. [2017.06.30-08:24:08] SEVERE: Exception while upgrading database schema. com.novell.zenworks.systemupdate.exceptions.PreGlo balException: Schema upgrade failed. Check the pre-global-update.log for more details. at com.novell.zenworks.systemupdate.PreGlobalAction.p rocessAction(PreGlobalAction.java:380) at com.novell.zenworks.systemupdate.PreGlobalAction.e xecute(PreGlobalAction.java:212) at com.novell.zenworks.configure.actions.ExecutePreGl obalConfigureAction.configure(ExecutePreGlobalConf igureAction.java:206) at com.novell.zenworks.configure.actions.ExecutePreGl obalConfigureAction.main(ExecutePreGlobalConfigure Action.java:259) @FAILED@com.novell.zenworks.systemupdate.exception s.PreGlobalException: Schema upgrade failed. Check the pre-global-update.log for more details. at com.novell.zenworks.systemupdate.PreGlobalAction.p rocessAction(PreGlobalAction.java:380) at com.novell.zenworks.systemupdate.PreGlobalAction.e xecute(PreGlobalAction.java:212) at com.novell.zenworks.configure.actions.ExecutePreGl obalConfigureAction.configure(ExecutePreGlobalConf igureAction.java:206) at com.novell.zenworks.configure.actions.ExecutePreGl obalConfigureAction.main(ExecutePreGlobalConfigure Action.java:259)


ERROR 06/30/2017 08:24:08 Exception while upgrading database schema. INFO: Setting log level to : FINER [2017.06.30-08:24:07] FINER: Setting schema version in DB. INFO: PreGlobalActions launched from media upgrade. FINER: Setting the status to IN_PROGRESS for update : 5017000000fc50000000002016121615 INFO: Attempting to create connection for schema : ZCM FINE: Updating zOpaqueData affected : 1 rows. INFO: Current zone version is (11.4.0), PreGlobal version is (17.0.0.1252) FINE: Available updates : [pre-update, v_11_4_1, v_11_4_2, v_11_4_3, v_12_0_1, v_12_0_2, v_17_0_0, post-update] FINE: Will create Preglobal Upgrade Log table if required.. FINE: Got 2 SQLs to execute. INFO: PreglobalUpgradeLog table already has 78 commands already loaded for current update : 5017000000fc50000000002016121615 FINER: Loading SU Metadata for Update : pre-update to db. INFO: No sqls specified for database : SQLServer, Version : pre-update, Update :5017000000fc50000000002016121615. Not loading SQLs. INFO: Completed loading of SU Metadata for Update : pre-update to db. INFO: Preglobal version 17.0.0.1252 is higher than zone version : 11.4.0 INFO: Comparing UpdateVersion : 11.4.1 against the latest version :17.0.0.1252 INFO: ShouldRunUpdateScripts : false INFO: Skipping processing of pre global action for the version : v_11_4_1 as current zone version 11.4.0 is newer. INFO: Preglobal version 17.0.0.1252 is higher than zone version : 11.4.0 INFO: Comparing UpdateVersion : 11.4.2 against the latest version :17.0.0.1252 INFO: ShouldRunUpdateScripts : false INFO: Skipping processing of pre global action for the version : v_11_4_2 as current zone version 11.4.0 is newer. INFO: Preglobal version 17.0.0.1252 is higher than zone version : 11.4.0 INFO: Comparing UpdateVersion : 11.4.3 against the latest version :17.0.0.1252 INFO: ShouldRunUpdateScripts : false INFO: Skipping processing of pre global action for the version : v_11_4_3 as current zone version 11.4.0 is newer. INFO: Preglobal version 17.0.0.1252 is higher than zone version : 11.4.0 INFO: Comparing UpdateVersion : 12.0.1 against the latest version :17.0.0.1252 INFO: ShouldRunUpdateScripts : false INFO: Skipping processing of pre global action for the version : v_12_0_1 as current zone version 11.4.0 is newer. INFO: Preglobal version 17.0.0.1252 is higher than zone version : 11.4.0 INFO: Comparing UpdateVersion : 12.0.2 against the latest version :17.0.0.1252 INFO: ShouldRunUpdateScripts : false INFO: Skipping processing of pre global action for the version : v_12_0_2 as current zone version 11.4.0 is newer. INFO: Preglobal version 17.0.0.1252 is higher than zone version : 11.4.0 INFO: Comparing UpdateVersion : 17.0.0.1252 against the latest version :17.0.0.1252 INFO: ShouldRunUpdateScripts : true INFO: Update details for update : v_17_0_0 already loaded in DB. Skipping it. INFO: Update details for update : post-update already loaded in DB. Skipping it. INFO: Need to update 3 version : [pre-update, v_17_0_0, post-update] INFO: Updating schema to version : pre-update INFO: Need to perform 0 actions for upgrading to version : pre-update INFO: Schema updated to version : pre-update successfully. INFO: Setting pre-global version to : 17.0.0.1252 FINE: Updating zOpaqueData affected : 1 rows. INFO: Updating schema to version : 17.0.0 INFO: Need to perform 9 actions for upgrading to version : v_17_0_0 FINE: Executing [ID=>52, Schema => ZCM, Action => EXEC_SQL, Version => v_17_0_0, Entry => /system-updates/v_17_0_0/sql-server/assetmanagement_update.sql] FINE: Got 10 SQLs to execute. INFO: Attempt 1 of executing SQL [update zSystemSetting set Data=REPLACE(data,'<SkipDirectories>','<SkipDirect ories><Item>C:\$Recycle.Bin</Item>') where Name='inventorysw' and CHARINDEX('C:\$Recycle.Bin',Data)=0;] failed with exception : Argument data type ntext is invalid for argument 1 of replace function.. Retrying... INFO: Attempt 2 of executing SQL [update zSystemSetting set Data=REPLACE(data,'<SkipDirectories>','<SkipDirect ories><Item>C:\$Recycle.Bin</Item>') where Name='inventorysw' and CHARINDEX('C:\$Recycle.Bin',Data)=0;] failed with exception : Argument data type ntext is invalid for argument 1 of replace function.. Retrying... INFO: Attempt 3 of executing SQL [update zSystemSetting set Data=REPLACE(data,'<SkipDirectories>','<SkipDirect ories><Item>C:\$Recycle.Bin</Item>') where Name='inventorysw' and CHARINDEX('C:\$Recycle.Bin',Data)=0;] failed with exception : Argument data type ntext is invalid for argument 1 of replace function.. Retrying... INFO: Attempt 4 of executing SQL [update zSystemSetting set Data=REPLACE(data,'<SkipDirectories>','<SkipDirect ories><Item>C:\$Recycle.Bin</Item>') where Name='inventorysw' and CHARINDEX('C:\$Recycle.Bin',Data)=0;] failed with exception : Argument data type ntext is invalid for argument 1 of replace function.. Retrying... SEVERE: Attempt 5 of executing SQL [update zSystemSetting set Data=REPLACE(data,'<SkipDirectories>','<SkipDirect ories><Item>C:\$Recycle.Bin</Item>') where Name='inventorysw' and CHARINDEX('C:\$Recycle.Bin',Data)=0;] failed with exception : Argument data type ntext is invalid for argument 1 of replace function. java.sql.SQLException: Argument data type ntext is invalid for argument 1 of replace function. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnos tic(SQLDiagnostic.java:372) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(Td sCore.java:2988) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCor e.java:2421) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(T dsCore.java:671) at net.sourceforge.jtds.jdbc.JtdsStatement.processRes ults(JtdsStatement.java:613) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL (JtdsStatement.java:572) at net.sourceforge.jtds.jdbc.JtdsStatement.executeImp l(JtdsStatement.java:809) at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpd ate(JtdsStatement.java:1288) at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpd ate(JtdsStatement.java:1241) at com.novell.zenworks.systemupdate.utils.SQLUtils.ex ecuteSQLStatements(SQLUtils.java:141) at com.novell.zenworks.systemupdate.utils.SQLUtils.ex ecuteSQLStatements(SQLUtils.java:86) at com.novell.zenworks.systemupdate.utils.SQLUtils.ex ecuteSQL(SQLUtils.java:60) at com.novell.zenworks.systemupdate.executor.SQLExecu tor.execute(SQLExecutor.java:72) at com.novell.zenworks.systemupdate.executor.SystemUp dateExecutor.doUpdate(SystemUpdateExecutor.java:64 ) at com.novell.zenworks.systemupdate.PreGlobalAction.r unPreGlobalForUpdates(PreGlobalAction.java:465) at com.novell.zenworks.systemupdate.PreGlobalAction.p rocessAction(PreGlobalAction.java:372) at com.novell.zenworks.systemupdate.PreGlobalAction.e xecute(PreGlobalAction.java:212) at com.novell.zenworks.configure.actions.ExecutePreGl obalConfigureAction.configure(ExecutePreGlobalConf igureAction.java:206) at com.novell.zenworks.configure.actions.ExecutePreGl obalConfigureAction.main(ExecutePreGlobalConfigure Action.java:259) SEVERE: Exception while executing SQLs from /system-updates/v_17_0_0/sql-server/assetmanagement_update.sql SEVERE: Exception while executing action /system-updates/v_17_0_0/sql-server/assetmanagement_update.sql for version : v_17_0_0 com.novell.zenworks.systemupdate.exceptions.PreGlo balException: com.novell.zenworks.systemupdate.exceptions.PreGlo balException: Error executing SQL: update zSystemSetting set Data=REPLACE(data,'<SkipDirectories>','<SkipDirect ories><Item>C:\$Recycle.Bin</Item>') where Name='inventorysw' and CHARINDEX('C:\$Recycle.Bin',Data)=0; at com.novell.zenworks.systemupdate.utils.SQLUtils.ex ecuteSQLStatements(SQLUtils.java:245) at com.novell.zenworks.systemupdate.utils.SQLUtils.ex ecuteSQLStatements(SQLUtils.java:86) at com.novell.zenworks.systemupdate.utils.SQLUtils.ex ecuteSQL(SQLUtils.java:60) at com.novell.zenworks.systemupdate.executor.SQLExecu tor.execute(SQLExecutor.java:72) at com.novell.zenworks.systemupdate.executor.SystemUp dateExecutor.doUpdate(SystemUpdateExecutor.java:64 ) at com.novell.zenworks.systemupdate.PreGlobalAction.r unPreGlobalForUpdates(PreGlobalAction.java:465) at com.novell.zenworks.systemupdate.PreGlobalAction.p rocessAction(PreGlobalAction.java:372) at com.novell.zenworks.systemupdate.PreGlobalAction.e xecute(PreGlobalAction.java:212) at com.novell.zenworks.configure.actions.ExecutePreGl obalConfigureAction.configure(ExecutePreGlobalConf igureAction.java:206) at com.novell.zenworks.configure.actions.ExecutePreGl obalConfigureAction.main(ExecutePreGlobalConfigure Action.java:259) Caused by: com.novell.zenworks.systemupdate.exceptions.PreGlo balException: Error executing SQL: update zSystemSetting set Data=REPLACE(data,'<SkipDirectories>','<SkipDirect ories><Item>C:\$Recycle.Bin</Item>') where Name='inventorysw' and CHARINDEX('C:\$Recycle.Bin',Data)=0; at com.novell.zenworks.systemupdate.utils.SQLUtils.ex ecuteSQLStatements(SQLUtils.java:204) ... 9 more Caused by: java.sql.SQLException: Argument data type ntext is invalid for argument 1 of replace function. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnos tic(SQLDiagnostic.java:372) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(Td sCore.java:2988) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCor e.java:2421) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(T dsCore.java:671) at net.sourceforge.jtds.jdbc.JtdsStatement.processRes ults(JtdsStatement.java:613) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL (JtdsStatement.java:572) at net.sourceforge.jtds.jdbc.JtdsStatement.executeImp l(JtdsStatement.java:809) at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpd ate(JtdsStatement.java:1288) at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpd ate(JtdsStatement.java:1241) at com.novell.zenworks.systemupdate.utils.SQLUtils.ex ecuteSQLStatements(SQLUtils.java:141) ... 9 more SEVERE: Execution of update action : /system-updates/v_17_0_0/sql-server/assetmanagement_update.sql of type : EXEC_SQL failed. Check logs for more details. SEVERE: Failed to update schema to version : v_17_0_0. Check pre-global logs for more details. INFO: Exception during pre-global-actions com.novell.zenworks.systemupdate.exceptions.PreGlo balException: Schema upgrade failed. Check the pre-global-update.log for more details. at com.novell.zenworks.systemupdate.PreGlobalAction.p rocessAction(PreGlobalAction.java:380) at com.novell.zenworks.systemupdate.PreGlobalAction.e xecute(PreGlobalAction.java:212) at com.novell.zenworks.configure.actions.ExecutePreGl obalConfigureAction.configure(ExecutePreGlobalConf igureAction.java:206) at com.novell.zenworks.configure.actions.ExecutePreGl obalConfigureAction.main(ExecutePreGlobalConfigure Action.java:259) FINER: Setting the status to FAILED for update : 5017000000fc50000000002016121615 FINE: Updating zOpaqueData affected : 1 rows. [2017.06.30-08:24:08] SEVERE: Exception while upgrading database schema. com.novell.zenworks.systemupdate.exceptions.PreGlo balException: Schema upgrade failed. Check the pre-global-update.log for more details. at com.novell.zenworks.systemupdate.PreGlobalAction.p rocessAction(PreGlobalAction.java:380) at com.novell.zenworks.systemupdate.PreGlobalAction.e xecute(PreGlobalAction.java:212) at com.novell.zenworks.configure.actions.ExecutePreGl obalConfigureAction.configure(ExecutePreGlobalConf igureAction.java:206) at com.novell.zenworks.configure.actions.ExecutePreGl obalConfigureAction.main(ExecutePreGlobalConfigure Action.java:259) @FAILED@com.novell.zenworks.systemupdate.exception s.PreGlobalException: Schema upgrade failed. Check the pre-global-update.log for more details. at com.novell.zenworks.systemupdate.PreGlobalAction.p rocessAction(PreGlobalAction.java:380) at com.novell.zenworks.systemupdate.PreGlobalAction.e xecute(PreGlobalAction.java:212) at com.novell.zenworks.configure.actions.ExecutePreGl obalConfigureAction.configure(ExecutePreGlobalConf igureAction.java:206) at com.novell.zenworks.configure.actions.ExecutePreGl obalConfigureAction.main(ExecutePreGlobalConfigure Action.java:259)