7021050: Upgrade to ZENworks 2017 fails because of NTEXT column in the database

  • Upgrading the first Primary Server to ZENworks 2017
  • ZENworks zone has been upgraded from ZENworks 10.x
  • The upgrade to ZENworks 2017 fails on the database schemaupgrade

The following messages are seen in thepre-global-actions.log:

ERROR:

[SystemUpdate] [] [Attempt 5 of executingSQL (update zSystemSetting setData=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 replacefunction.] [java.sql.SQLException: Argument data type ntext isinvalid for argument 1 of replace function.

atnet.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372)



[SystemUpdate] [] [Exception while executing SQLs from/system-updates/v_17_0_0/sql-server/assetmanagement_update.sql] [][] [] [PreGlobalAction]

[SystemUpdate] [] [Exception while executing action/system-updates/v_17_0_0/sql-server/assetmanagement_update.sql forversion : v_17_0_0][com.novell.zenworks.systemupdate.exceptions.PreGlobalException:com.novell.zenworks.systemupdate.exceptions.PreGlobalException:Error executing SQL: update zSystemSetting setData=REPLACE(data,'<SkipDirectories>’,'<SkipDirectories><Item>C:$Recycle.Bin</Item>’)where Name=’inventorysw’

and CHARINDEX(‘C:$Recycle.Bin’,Data)=0;

atcom.novell.zenworks.systemupdate.utils.SQLUtils.executeSQLStatements(SQLUtils.java:245)



Caused by:com.novell.zenworks.systemupdate.exceptions.PreGlobalException:Error executing SQL: update zSystemSetting setData=REPLACE(data,'<SkipDirectories>’,'<SkipDirectories><Item>C:$Recycle.Bin</Item>’)where Name=’inventorysw’

and CHARINDEX(‘C:$Recycle.Bin’,Data)=0;

atcom.novell.zenworks.systemupdate.utils.SQLUtils.executeSQLStatements(SQLUtils.java:204)



Caused by: java.sql.SQLException: Argument data type ntext isinvalid for argument 1 of replace function.

atnet.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372)



[SystemUpdate] [] [Execution of update action :/system-updates/v_17_0_0/sql-server/assetmanagement_update.sql oftype : EXEC_SQL failed. Check logs for more details.] [] [] [][PreGlobalAction]

[SystemUpdate] [] [Failed to update schema to version : v_17_0_0.Check pre-global logs for more details.] [] [] [][PreGlobalAction]

[SystemUpdate] [] [Exception during pre-global-actions][com.novell.zenworks.systemupdate.exceptions.PreGlobalException:Schema upgrade failed. Check the pre-global-update.log for moredetails.

atcom.novell.zenworks.systemupdate.PreGlobalAction.processAction(PreGlobalAction.java:380)



[SystemUpdate] [] [Setting the status to FAILED for update :5017000000fc50000000002016121615] [] [] [][PreGlobalAction]

Related:

Leave a Reply