ZENworks update to version 11.3 fails to complete when MSSQL database user is configured with a different default language than English

  • Document ID:7014747
  • Creation Date:17-Mar-2014
  • Modified Date:17-Mar-2014
    • Micro Focus Products:
      ZENworks Configuration Management

Environment

Novell ZENworks Configuration Management 11.3 Server Update
Microsoft SQL Server

Situation

This issue will be reproducible if you meet the following conditions.
 
1. Running Microsoft SQL Server 2008 or Higher
2. Using SQL Server Authentication
3. ZENworks database user has a different language than English configured as a default Language.

Resolution

Workaround:
 
Follow the steps below to confirm the default language defined for your ZENworks database user and change it to English.
 
1. Open the file named dmaccount.properties under /etc/opt/novell/zenworks/datamodel (LINUX) or %ZENWORKS_HOME%\conf\datamodel (Windows) to confirm the database user used by ZENworks servers to connect to your MSSQL Database server
 
2. Open Microsoft SQL Server Management Studio and access the Security Folder.
 
3. Look for the database user that matches the name under step 1 and open it's properties.
 
4. Go to the last property which is the Default Language and Select English and press the Ok button.
 
Once this change is done then try to run the update again and it will complete successfully.
 

Additional Information

Detailed information about the error message registered during the update process:
 
<Message><MessageID><![CDATA[0000]]></MessageID><MessageString><![CDATA[Error while Upgrading the Database]]></MessageString><Severity><![CDATA[1]]></Severity><Time><![CDATA[1394881029443]]></Time><Source><![CDATA[Unknown Device]]></Source><ComponentName><![CDATA[Server Install]]></ComponentName><AdditionalInfo><![CDATA[java.sql.SQLException: Bei der Konvertierung eines varchar-Datentyps in einen datetime-Datentyp liegt der Wert außerhalb des gültigen Bereichs.
 at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
 at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820)
 at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258)
 at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:632)
 at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:584)
 at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:546)
 at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:723)
 at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1166)
 at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1119)
 at com.novell.zenworks.configure.actions.db.MssqlUpgradeUtils.executeUpgradeCommands(MssqlUpgradeUtils.java:621)
 at com.novell.zenworks.configure.actions.db.MssqlUpgradeUtils.upgradeDatabase(MssqlUpgradeUtils.java:89)
 at com.novell.zenworks.configure.actions.db.AddIDColumnMssqlConfigureAction.startUpgradeProcess(AddIDColumnMssqlConfigureAction.java:122)
 at com.novell.zenworks.configure.actions.db.AddIDColumnMssqlConfigureAction.configure(AddIDColumnMssqlConfigureAction.java:87)
 at com.novell.zenworks.configure.ZENworksConfigure.execConfigAction(ZENworksConfigure.java:1758)
 at com.novell.zenworks.install.customcode.configure.BaseZenConfigAction.install(BaseZenConfigAction.java:63)
 at com.novell.zenworks.install.customcode.configure.ConfigAddIDColumnMssqlConfigureAction.install(ConfigAddIDColumnMssqlConfigureAction.java:21)
 at com.zerog.ia.installer.actions.CustomAction.installSelf(DashoA10*..)
 at com.zerog.ia.installer.InstallablePiece.install(DashoA10*..)
 at com.zerog.ia.installer.InstallablePiece.install(DashoA10*..)
 at com.zerog.ia.installer.InstallablePiece.install(DashoA10*..)
 at com.zerog.ia.installer.InstallablePiece.install(DashoA10*..)
 at com.zerog.ia.installer.InstallablePiece.install(DashoA10*..)
 at com.zerog.ia.installer.GhostDirectory.install(DashoA10*..)
 at com.zerog.ia.installer.InstallablePiece.install(DashoA10*..)
 at com.zerog.ia.installer.Installer.install(DashoA10*..)
 at com.zerog.ia.installer.LifeCycleManager.a(DashoA10*..)
 at com.zerog.ia.installer.LifeCycleManager.a(DashoA10*..)
 at com.zerog.ia.installer.Main.main(DashoA10*..)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
 at java.lang.reflect.Method.invoke(Unknown Source)
 at com.zerog.lax.LAX.launch(DashoA10*..)
 at com.zerog.lax.LAX.main(DashoA10*..)
]]></AdditionalInfo></Message>
<Message><MessageID><![CDATA[0000]]></MessageID><MessageString><![CDATA[Bei der Konvertierung eines varchar-Datentyps in einen datetime-Datentyp liegt der Wert außerhalb des gültigen Bereichs.
com.novell.zenworks.configure.ConfigureException: Bei der Konvertierung eines varchar-Datentyps in einen datetime-Datentyp liegt der Wert außerhalb des gültigen Bereichs.
 at com.novell.zenworks.configure.actions.db.AddIDColumnMssqlConfigureAction.configure(AddIDColumnMssqlConfigureAction.java:94)
 at com.novell.zenworks.configure.ZENworksConfigure.execConfigAction(ZENworksConfigure.java:1758)
 at com.novell.zenworks.install.customcode.configure.BaseZenConfigAction.install(BaseZenConfigAction.java:63)
 at com.novell.zenworks.install.customcode.configure.ConfigAddIDColumnMssqlConfigureAction.install(ConfigAddIDColumnMssqlConfigureAction.java:21)
 at com.zerog.ia.installer.actions.CustomAction.installSelf(DashoA10*..)
 at com.zerog.ia.installer.InstallablePiece.install(DashoA10*..)
 at com.zerog.ia.installer.InstallablePiece.install(DashoA10*..)
 at com.zerog.ia.installer.InstallablePiece.install(DashoA10*..)
 at com.zerog.ia.installer.InstallablePiece.install(DashoA10*..)
 at com.zerog.ia.installer.InstallablePiece.install(DashoA10*..)
 at com.zerog.ia.installer.GhostDirectory.install(DashoA10*..)
 at com.zerog.ia.installer.InstallablePiece.install(DashoA10*..)
 at com.zerog.ia.installer.Installer.install(DashoA10*..)
 at com.zerog.ia.installer.LifeCycleManager.a(DashoA10*..)
 at com.zerog.ia.installer.LifeCycleManager.a(DashoA10*..)
 at com.zerog.ia.installer.Main.main(DashoA10*..)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
 at java.lang.reflect.Method.invoke(Unknown Source)
 at com.zerog.lax.LAX.launch(DashoA10*..)
 at com.zerog.lax.LAX.main(DashoA10*..)
Caused by: java.sql.SQLException: Bei der Konvertierung eines varchar-Datentyps in einen datetime-Datentyp liegt der Wert außerhalb des gültigen Bereichs.
 at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
 at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820)
 at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258)
 at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:632)
 at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:584)
 at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:546)
 at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:723)
 at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1166)
 at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1119)
 at com.novell.zenworks.configure.actions.db.MssqlUpgradeUtils.executeUpgradeCommands(MssqlUpgradeUtils.java:621)
 at com.novell.zenworks.configure.actions.db.MssqlUpgradeUtils.upgradeDatabase(MssqlUpgradeUtils.java:89)
 at com.novell.zenworks.configure.actions.db.AddIDColumnMssqlConfigureAction.startUpgradeProcess(AddIDColumnMssqlConfigureAction.java:122)
 at com.novell.zenworks.configure.actions.db.AddIDColumnMssqlConfigureAction.configure(AddIDColumnMssqlConfigureAction.java:87)
 ... 21 more
java.sql.SQLException: Bei der Konvertierung eines varchar-Datentyps in einen datetime-Datentyp liegt der Wert außerhalb des gültigen Bereichs.
 at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
 at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820)
 at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258)
 at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:632)
 at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:584)
 at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:546)
 at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:723)
 at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1166)
 at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1119)
 at com.novell.zenworks.configure.actions.db.MssqlUpgradeUtils.executeUpgradeCommands(MssqlUpgradeUtils.java:621)
 at com.novell.zenworks.configure.actions.db.MssqlUpgradeUtils.upgradeDatabase(MssqlUpgradeUtils.java:89)
 at com.novell.zenworks.configure.actions.db.AddIDColumnMssqlConfigureAction.startUpgradeProcess(AddIDColumnMssqlConfigureAction.java:122)
 at com.novell.zenworks.configure.actions.db.AddIDColumnMssqlConfigureAction.configure(AddIDColumnMssqlConfigureAction.java:87)
 at com.novell.zenworks.configure.ZENworksConfigure.execConfigAction(ZENworksConfigure.java:1758)
 at com.novell.zenworks.install.customcode.configure.BaseZenConfigAction.install(BaseZenConfigAction.java:63)
 at com.novell.zenworks.install.customcode.configure.ConfigAddIDColumnMssqlConfigureAction.install(ConfigAddIDColumnMssqlConfigureAction.java:21)
 at com.zerog.ia.installer.actions.CustomAction.installSelf(DashoA10*..)
 at com.zerog.ia.installer.InstallablePiece.install(DashoA10*..)
 at com.zerog.ia.installer.InstallablePiece.install(DashoA10*..)
 at com.zerog.ia.installer.InstallablePiece.install(DashoA10*..)
 at com.zerog.ia.installer.InstallablePiece.install(DashoA10*..)
 at com.zerog.ia.installer.InstallablePiece.install(DashoA10*..)
 at com.zerog.ia.installer.GhostDirectory.install(DashoA10*..)
 at com.zerog.ia.installer.InstallablePiece.install(DashoA10*..)
 at com.zerog.ia.installer.Installer.install(DashoA10*..)
 at com.zerog.ia.installer.LifeCycleManager.a(DashoA10*..)
 at com.zerog.ia.installer.LifeCycleManager.a(DashoA10*..)
 at com.zerog.ia.installer.Main.main(DashoA10*..)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
 at java.lang.reflect.Method.invoke(Unknown Source)
 at com.zerog.lax.LAX.launch(DashoA10*..)
 at com.zerog.lax.LAX.main(DashoA10*..)
]]></MessageString><Severity><![CDATA[8]]></Severity><Time><![CDATA[1394881029445]]></Time><Source><![CDATA[Unknown Device]]></Source><ComponentName><![CDATA[Server Install]]></ComponentName><AdditionalInfo><![CDATA[com.novell.zenworks.configure.ConfigureException: Bei der Konvertierung eines varchar-Datentyps in einen datetime-Datentyp liegt der Wert außerhalb des gültigen Bereichs.
 at com.novell.zenworks.configure.actions.db.AddIDColumnMssqlConfigureAction.configure(AddIDColumnMssqlConfigureAction.java:94)
 at com.novell.zenworks.configure.ZENworksConfigure.execConfigAction(ZENworksConfigure.java:1758)
 at com.novell.zenworks.install.customcode.configure.BaseZenConfigAction.install(BaseZenConfigAction.java:63)
 at com.novell.zenworks.install.customcode.configure.ConfigAddIDColumnMssqlConfigureAction.install(ConfigAddIDColumnMssqlConfigureAction.java:21)
 at com.zerog.ia.installer.actions.CustomAction.installSelf(DashoA10*..)
 at com.zerog.ia.installer.InstallablePiece.install(DashoA10*..)
 at com.zerog.ia.installer.InstallablePiece.install(DashoA10*..)
 at com.zerog.ia.installer.InstallablePiece.install(DashoA10*..)
 at com.zerog.ia.installer.InstallablePiece.install(DashoA10*..)
 at com.zerog.ia.installer.InstallablePiece.install(DashoA10*..)
 at com.zerog.ia.installer.GhostDirectory.install(DashoA10*..)
 at com.zerog.ia.installer.InstallablePiece.install(DashoA10*..)
 at com.zerog.ia.installer.Installer.install(DashoA10*..)
 at com.zerog.ia.installer.LifeCycleManager.a(DashoA10*..)
 at com.zerog.ia.installer.LifeCycleManager.a(DashoA10*..)
 at com.zerog.ia.installer.Main.main(DashoA10*..)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
 at java.lang.reflect.Method.invoke(Unknown Source)
 at com.zerog.lax.LAX.launch(DashoA10*..)
 at com.zerog.lax.LAX.main(DashoA10*..)
Caused by: java.sql.SQLException: Bei der Konvertierung eines varchar-Datentyps in einen datetime-Datentyp liegt der Wert außerhalb des gültigen Bereichs.
 at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
 at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820)
 at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258)
 at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:632)
 at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:584)
 at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:546)
 at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:723)
 at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1166)
 at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1119)
 at com.novell.zenworks.configure.actions.db.MssqlUpgradeUtils.executeUpgradeCommands(MssqlUpgradeUtils.java:621)
 at com.novell.zenworks.configure.actions.db.MssqlUpgradeUtils.upgradeDatabase(MssqlUpgradeUtils.java:89)
 at com.novell.zenworks.configure.actions.db.AddIDColumnMssqlConfigureAction.startUpgradeProcess(AddIDColumnMssqlConfigureAction.java:122)
 at com.novell.zenworks.configure.actions.db.AddIDColumnMssqlConfigureAction.configure(AddIDColumnMssqlConfigureAction.java:87)
 ... 21 more
]]></AdditionalInfo></Message>