Upgrade to ZCM 11.0 or 11.1 fails for zones using MSSQL database

• Zone uses MSSQL database
• Upgrading from ZCM 10.3.x to ZCM 11 or ZCM 11.1/11.1a
• Database has previously had the scripts from Remove duplicate inventory.zip obtained from the patch entitled "Scripts to remove duplicate inventory products - See TID 583397" (the title of this patch is wrong, it should reference TID 7006479)
• Upgrade does not complete - the following errors can be seen in the logs:

system-update.log
ERROR;ERROR_STARTING_PROCESS;/opt/novell/zenworks/bin/novell-zenworks-configure,The exit code of the process did not match with success codes.;null
DEBUG;;;An error occured during command execution...details should have already been logged

novell-zenworks-configure.log
[2011.09.16-19:13:11] INFO: CleanupObsoletePackagesConfigureAction complete!
[2011.09.16-19:13:43]SEVERE: org.hibernate.exception.DataException: could not execute update query
com.novell.zenworks.configure.ConfigureException: org.hibernate.exception.DataException: could not execute update query
at com.novell.zenworks.configure.actions.ZoneConfigUpdateConfigureAction.configure(ZoneConfigUpdateConfigureAction.java:54)
at com.novell.zenworks.configure.ZENworksConfigure.execConfigAction(ZENworksConfigure.java:1549)
at com.novell.zenworks.configure.ZENworksConfigure.configure(ZENworksConfigure.java:1407)
at com.novell.zenworks.configure.ZENworksConfigure.main(ZENworksConfigure.java:1326)

A fix for this issue is intended to be included in a future update to the product: however, in the interim, Novell has made a script  available: it can be obtained at https://download.novell.com/Download?buildid=1RkXlvZHE9g~ as "ZCM 10.2.x/10.3.x - MS SQL script to fix error that prevents successful upgrade to ZCM 11.0/11.1/11.1a - See TID 7009409". This Patch should only be applied if the symptoms above are being experienced, and are causing problems.Ensure that a backup of the database is taken before applying the script.