Error while Upgrading 11.4.0 to 2017

[bjuhlig]

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>','<SkipDirectories><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>','<SkipDirectories><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>','<SkipDirectories><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>','<SkipDirectories><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>','<SkipDirectories><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.addDiagnostic(SQLDiagnostic.java:372) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2988) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2421) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:671) at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:613) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:572) at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:809) at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1288) at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1241) at com.novell.zenworks.systemupdate.utils.SQLUtils.executeSQLStatements(SQLUtils.java:141) at com.novell.zenworks.systemupdate.utils.SQLUtils.executeSQLStatements(SQLUtils.java:86) at com.novell.zenworks.systemupdate.utils.SQLUtils.executeSQL(SQLUtils.java:60) at com.novell.zenworks.systemupdate.executor.SQLExecutor.execute(SQLExecutor.java:72) at com.novell.zenworks.systemupdate.executor.SystemUpdateExecutor.doUpdate(SystemUpdateExecutor.java:64) at com.novell.zenworks.systemupdate.PreGlobalAction.runPreGlobalForUpdates(PreGlobalAction.java:465) at com.novell.zenworks.systemupdate.PreGlobalAction.processAction(PreGlobalAction.java:372) at com.novell.zenworks.systemupdate.PreGlobalAction.execute(PreGlobalAction.java:212) at com.novell.zenworks.configure.actions.ExecutePreGlobalConfigureAction.configure(ExecutePreGlobalConfigureAction.java:206) at com.novell.zenworks.configure.actions.ExecutePreGlobalConfigureAction.main(ExecutePreGlobalConfigureAction.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.PreGlobalException: com.novell.zenworks.systemupdate.exceptions.PreGlobalException: Error executing SQL: update zSystemSetting set Data=REPLACE(data,'<SkipDirectories>','<SkipDirectories><Item>C:\$Recycle.Bin</Item>') where Name='inventorysw' and CHARINDEX('C:\$Recycle.Bin',Data)=0; at com.novell.zenworks.systemupdate.utils.SQLUtils.executeSQLStatements(SQLUtils.java:245) at com.novell.zenworks.systemupdate.utils.SQLUtils.executeSQLStatements(SQLUtils.java:86) at com.novell.zenworks.systemupdate.utils.SQLUtils.executeSQL(SQLUtils.java:60) at com.novell.zenworks.systemupdate.executor.SQLExecutor.execute(SQLExecutor.java:72) at com.novell.zenworks.systemupdate.executor.SystemUpdateExecutor.doUpdate(SystemUpdateExecutor.java:64) at com.novell.zenworks.systemupdate.PreGlobalAction.runPreGlobalForUpdates(PreGlobalAction.java:465) at com.novell.zenworks.systemupdate.PreGlobalAction.processAction(PreGlobalAction.java:372) at com.novell.zenworks.systemupdate.PreGlobalAction.execute(PreGlobalAction.java:212) at com.novell.zenworks.configure.actions.ExecutePreGlobalConfigureAction.configure(ExecutePreGlobalConfigureAction.java:206) at com.novell.zenworks.configure.actions.ExecutePreGlobalConfigureAction.main(ExecutePreGlobalConfigureAction.java:259) Caused by: com.novell.zenworks.systemupdate.exceptions.PreGlobalException: Error executing SQL: update zSystemSetting set Data=REPLACE(data,'<SkipDirectories>','<SkipDirectories><Item>C:\$Recycle.Bin</Item>') where Name='inventorysw' and CHARINDEX('C:\$Recycle.Bin',Data)=0; at com.novell.zenworks.systemupdate.utils.SQLUtils.executeSQLStatements(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.addDiagnostic(SQLDiagnostic.java:372) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2988) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2421) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:671) at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:613) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:572) at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:809) at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1288) at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1241) at com.novell.zenworks.systemupdate.utils.SQLUtils.executeSQLStatements(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.PreGlobalException: Schema upgrade failed. Check the pre-global-update.log for more details. at com.novell.zenworks.systemupdate.PreGlobalAction.processAction(PreGlobalAction.java:380) at com.novell.zenworks.systemupdate.PreGlobalAction.execute(PreGlobalAction.java:212) at com.novell.zenworks.configure.actions.ExecutePreGlobalConfigureAction.configure(ExecutePreGlobalConfigureAction.java:206) at com.novell.zenworks.configure.actions.ExecutePreGlobalConfigureAction.main(ExecutePreGlobalConfigureAction.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.PreGlobalException: Schema upgrade failed. Check the pre-global-update.log for more details. at com.novell.zenworks.systemupdate.PreGlobalAction.processAction(PreGlobalAction.java:380) at com.novell.zenworks.systemupdate.PreGlobalAction.execute(PreGlobalAction.java:212) at com.novell.zenworks.configure.actions.ExecutePreGlobalConfigureAction.configure(ExecutePreGlobalConfigureAction.java:206) at com.novell.zenworks.configure.actions.ExecutePreGlobalConfigureAction.main(ExecutePreGlobalConfigureAction.java:259) @FAILED@com.novell.zenworks.systemupdate.exceptions.PreGlobalException: Schema upgrade failed. Check the pre-global-update.log for more details. at com.novell.zenworks.systemupdate.PreGlobalAction.processAction(PreGlobalAction.java:380) at com.novell.zenworks.systemupdate.PreGlobalAction.execute(PreGlobalAction.java:212) at com.novell.zenworks.configure.actions.ExecutePreGlobalConfigureAction.configure(ExecutePreGlobalConfigureAction.java:206) at com.novell.zenworks.configure.actions.ExecutePreGlobalConfigureAction.main(ExecutePreGlobalConfigureAction.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>','<SkipDirectories><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>','<SkipDirectories><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>','<SkipDirectories><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>','<SkipDirectories><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>','<SkipDirectories><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.addDiagnostic(SQLDiagnostic.java:372) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2988) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2421) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:671) at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:613) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:572) at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:809) at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1288) at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1241) at com.novell.zenworks.systemupdate.utils.SQLUtils.executeSQLStatements(SQLUtils.java:141) at com.novell.zenworks.systemupdate.utils.SQLUtils.executeSQLStatements(SQLUtils.java:86) at com.novell.zenworks.systemupdate.utils.SQLUtils.executeSQL(SQLUtils.java:60) at com.novell.zenworks.systemupdate.executor.SQLExecutor.execute(SQLExecutor.java:72) at com.novell.zenworks.systemupdate.executor.SystemUpdateExecutor.doUpdate(SystemUpdateExecutor.java:64) at com.novell.zenworks.systemupdate.PreGlobalAction.runPreGlobalForUpdates(PreGlobalAction.java:465) at com.novell.zenworks.systemupdate.PreGlobalAction.processAction(PreGlobalAction.java:372) at com.novell.zenworks.systemupdate.PreGlobalAction.execute(PreGlobalAction.java:212) at com.novell.zenworks.configure.actions.ExecutePreGlobalConfigureAction.configure(ExecutePreGlobalConfigureAction.java:206) at com.novell.zenworks.configure.actions.ExecutePreGlobalConfigureAction.main(ExecutePreGlobalConfigureAction.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.PreGlobalException: com.novell.zenworks.systemupdate.exceptions.PreGlobalException: Error executing SQL: update zSystemSetting set Data=REPLACE(data,'<SkipDirectories>','<SkipDirectories><Item>C:\$Recycle.Bin</Item>') where Name='inventorysw' and CHARINDEX('C:\$Recycle.Bin',Data)=0; at com.novell.zenworks.systemupdate.utils.SQLUtils.executeSQLStatements(SQLUtils.java:245) at com.novell.zenworks.systemupdate.utils.SQLUtils.executeSQLStatements(SQLUtils.java:86) at com.novell.zenworks.systemupdate.utils.SQLUtils.executeSQL(SQLUtils.java:60) at com.novell.zenworks.systemupdate.executor.SQLExecutor.execute(SQLExecutor.java:72) at com.novell.zenworks.systemupdate.executor.SystemUpdateExecutor.doUpdate(SystemUpdateExecutor.java:64) at com.novell.zenworks.systemupdate.PreGlobalAction.runPreGlobalForUpdates(PreGlobalAction.java:465) at com.novell.zenworks.systemupdate.PreGlobalAction.processAction(PreGlobalAction.java:372) at com.novell.zenworks.systemupdate.PreGlobalAction.execute(PreGlobalAction.java:212) at com.novell.zenworks.configure.actions.ExecutePreGlobalConfigureAction.configure(ExecutePreGlobalConfigureAction.java:206) at com.novell.zenworks.configure.actions.ExecutePreGlobalConfigureAction.main(ExecutePreGlobalConfigureAction.java:259) Caused by: com.novell.zenworks.systemupdate.exceptions.PreGlobalException: Error executing SQL: update zSystemSetting set Data=REPLACE(data,'<SkipDirectories>','<SkipDirectories><Item>C:\$Recycle.Bin</Item>') where Name='inventorysw' and CHARINDEX('C:\$Recycle.Bin',Data)=0; at com.novell.zenworks.systemupdate.utils.SQLUtils.executeSQLStatements(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.addDiagnostic(SQLDiagnostic.java:372) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2988) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2421) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:671) at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:613) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:572) at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:809) at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1288) at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1241) at com.novell.zenworks.systemupdate.utils.SQLUtils.executeSQLStatements(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.PreGlobalException: Schema upgrade failed. Check the pre-global-update.log for more details. at com.novell.zenworks.systemupdate.PreGlobalAction.processAction(PreGlobalAction.java:380) at com.novell.zenworks.systemupdate.PreGlobalAction.execute(PreGlobalAction.java:212) at com.novell.zenworks.configure.actions.ExecutePreGlobalConfigureAction.configure(ExecutePreGlobalConfigureAction.java:206) at com.novell.zenworks.configure.actions.ExecutePreGlobalConfigureAction.main(ExecutePreGlobalConfigureAction.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.PreGlobalException: Schema upgrade failed. Check the pre-global-update.log for more details. at com.novell.zenworks.systemupdate.PreGlobalAction.processAction(PreGlobalAction.java:380) at com.novell.zenworks.systemupdate.PreGlobalAction.execute(PreGlobalAction.java:212) at com.novell.zenworks.configure.actions.ExecutePreGlobalConfigureAction.configure(ExecutePreGlobalConfigureAction.java:206) at com.novell.zenworks.configure.actions.ExecutePreGlobalConfigureAction.main(ExecutePreGlobalConfigureAction.java:259) @FAILED@com.novell.zenworks.systemupdate.exceptions.PreGlobalException: Schema upgrade failed. Check the pre-global-update.log for more details. at com.novell.zenworks.systemupdate.PreGlobalAction.processAction(PreGlobalAction.java:380) at com.novell.zenworks.systemupdate.PreGlobalAction.execute(PreGlobalAction.java:212) at com.novell.zenworks.configure.actions.ExecutePreGlobalConfigureAction.configure(ExecutePreGlobalConfigureAction.java:206) at com.novell.zenworks.configure.actions.ExecutePreGlobalConfigureAction.main(ExecutePreGlobalConfigureAction.java:259)

[bjuhlig]

The ZDC Database Report might help in this case...

ZENworks Database Verifier

All required tables are found in the database.

Following objects missing are in tables' structures.


Severity

Description

ERROR Missing object in table 'NC_SoftwareFP'
Object type: [Column] , Object name: [Offset]
Detail: [Name: Offset, Size: 10, Type: INTEGER, Nullable: true]


Following mismatches were found in tables' structures.


Severity

Description

ERROR Mismatch in table 'LC_MachinesCovered' structure.
Object type: [Column] , Object name: [MachineName]
Expected: [Name: MachineName, Size: 32, Type: VARCHAR, Nullable: true]
Found: [Name: MachineName, Size: 512, Type: VARCHAR, Nullable: true]
ERROR Mismatch in table 'NC_OperatingSystem' structure.
Object type: [Column] , Object name: [OSInternalVersion]
Expected: [Name: OSInternalVersion, Size: 8, Type: VARCHAR, Nullable: true]
Found: [Name: OSInternalVersion, Size: 16, Type: VARCHAR, Nullable: true]
ERROR Mismatch in table 'NC_Workstation' structure.
Object type: [Column] , Object name: [OSBuild]
Expected: [Name: OSBuild, Size: 8, Type: VARCHAR, Nullable: true]
Found: [Name: OSBuild, Size: 16, Type: VARCHAR, Nullable: true]
ERROR Mismatch in table 'zDevice' structure.
Object type: [Column] , Object name: [Language]
Expected: [Name: Language, Size: 10, Type: VARCHAR, Nullable: true]
Found: [Name: Language, Size: 25, Type: VARCHAR, Nullable: true]

All required database Procedures/Views are present in the database.

Following mismatches were found in database Procedures/Views.


Severity

Description

ERROR Mismatch in View 'DeploymentStatusView' structure.
Expected: [Name: DeploymentStatusView, Definition hash: 66f7482b ]
Found: [Name: DeploymentStatusView, Definition hash: ef21a392]
ERROR Mismatch in View 'NC_Component' structure.
Expected: [Name: NC_Component, Definition hash: 6fcbdda6 ]
Found: [Name: NC_Component, Definition hash: 47fbe01c]
ERROR Mismatch in View 'zrs_assignment' structure.
Expected: [Name: zrs_assignment, Definition hash: 6c3ecaf8 ]
Found: [Name: zrs_assignment, Definition hash: 79c7158c]
ERROR Mismatch in Procedure 'z_bo_formatEventMsg' structure.
Expected: [Name: z_bo_formatEventMsg, Definition hash: 921219bb ]
Found: [Name: z_bo_formatEventMsg, Definition hash: 58fa1858]
ERROR Mismatch in Procedure 'zQueuePop' structure.
Expected: [Name: zQueuePop, Definition hash: 708192a6 ]
Found: [Name: zQueuePop, Definition hash: cd309655]

[CRAIGDWILSON]

pre-global-update.log would have details about the failure............

[bjuhlig]

Could this issue be related to this TID? https://www.novell.com/support/kb/doc.php?id=7021050

The Pre Global Update Log contains this information

[INFO] [06/30/2017 13:31:29.107] [4260] [SQLUtils] [1] [] [SystemUpdate] [] [Attempt 1 of executing SQL (update zSystemSetting set Data=REPLACE(data,'<SkipDirectories>','<SkipDirectories><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...] [] [] [] [PreGlobalAction]
[INFO] [06/30/2017 13:31:29.107] [4260] [SQLUtils] [1] [] [SystemUpdate] [] [Attempt 2 of executing SQL (update zSystemSetting set Data=REPLACE(data,'<SkipDirectories>','<SkipDirectories><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...] [] [] [] [PreGlobalAction]
[INFO] [06/30/2017 13:31:29.107] [4260] [SQLUtils] [1] [] [SystemUpdate] [] [Attempt 3 of executing SQL (update zSystemSetting set Data=REPLACE(data,'<SkipDirectories>','<SkipDirectories><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...] [] [] [] [PreGlobalAction]
[INFO] [06/30/2017 13:31:29.107] [4260] [SQLUtils] [1] [] [SystemUpdate] [] [Attempt 4 of executing SQL (update zSystemSetting set Data=REPLACE(data,'<SkipDirectories>','<SkipDirectories><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...] [] [] [] [PreGlobalAction]
[ERROR] [06/30/2017 13:31:29.107] [4260] [SQLUtils] [1] [] [SystemUpdate] [] [Attempt 5 of executing SQL (update zSystemSetting set Data=REPLACE(data,'<SkipDirectories>','<SkipDirectories><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.

[CRAIGDWILSON]

That is probably the issue.
An SR would be necessary to fix it.....

Long Story Short.....One of the Columns in your table should have been previously converted to another type, but for some reason this did not occur.