Novell Home

My Favorites

Close

Please to see your favorites.

ZCM 11.3 Update or new installation fails to create new Audit Database when using MSSQL Database Server

This document (7014681) is provided subject to the disclaimer at the end of this document.

Environment

Novell ZENworks Configuration Management 11.2 System Update using MSSQL Database Server
Novell ZENworks Configuration Management 11.3 New Installation using MSSQL Database Server

Situation

New installations or updates of ZENworks Configuration Management 11.3 running under MSSQL Server Database will fail to create the Audit Database if the size of a System Database named Model, created and updated by the MSSQL Database server, is bigger than 8192KB.
 
The following entry can be described on the installation log when the database creation process fails:
 
Caused by: java.sql.BatchUpdateException: The CREATE DATABASE statement failed. The primary file must be at least 50 MB to accommodate a copy of the model database.
 at net.sourceforge.jtds.jdbc.JtdsStatement.executeBatch(JtdsStatement.java:947)
 at com.novell.zenworks.datamodel.database.sqlserver.AuditSQLServerDatabaseConfigurator.createDatabase(AuditSQLServerDatabaseConfigurator.java:234)
 ... 20 more

Resolution

Workaround:
 
Using the assistance of any Database Management Administration tools, such as MSSQL Management Studio, create the Audit database and Audit User database manually and then during the install or update process of ZENworks Configuration Management 11.3 make sure to select the option described as "Use Existing database" under the installer screen that requests for thei nformation related to Audit Database.
 
Below you will find a list of steps that need to be performed to create this database and database user based on MSSQL Management Studio.
 
1. Open MSSQL Management Studio and login to the database server as sa or a user with full administrator rights over the database server.
2. Right click on the Database link and click on New Database and this will open the New Database screen
3. On the new database screen type the database name and leave the default values defined under the Database Files: tab.
4. Click OK and the new Database will be created and the new database will be created.
5. Go back to the MSSQL Management Studio Screen and Right click under the Security Folder and and click on New > Login
6. On the Login - New Window write the Audit Database username
7. Select SQL Authentication
8. Type the database password based on complexity settings of the MSSQL Server and confirm the password
9. Uncheck the option "Enforce Password policy"
10. Select "Default Database:" as the database previously created
11. Select "Default Language:" as English
12. Click on "User Mapping" located on the top left corner of the Login - New Window
13. Click on the Map column of the previously created database so it is properly selected.
14. Select "db_owner" and "public" under the "Database role membership for:" and click OK button.
15. Mount the ZENworks Configuration Management 11.3 ISO and start the update or installation
16. Follow the steps until you arrive to the section described below and select the option "Use existing database"
17. Provide the IP address or FQDN of your MSSQL database server and click ok
18. Provide the Database name and Database username created before and click ok and continue with the rest of the installation

Status

Reported to Engineering

Additional Information

Detailed Java exception when the issue is duplicated
]]></MessageString><Severity><![CDATA[8]]></Severity><Time><![CDATA[1393922887257]]></Time><Source><![CDATA[Unknown Device]]></Source><ComponentName><![CDATA[Server Install]]></ComponentName><AdditionalInfo><![CDATA[com.novell.zenworks.configure.ConfigureException: Failed to create the database. Check if the path 'D:\zenworks' exists on the SQL Server.
 at com.novell.zenworks.configure.actions.db.AuditDatabaseConfigureAction.configure(AuditDatabaseConfigureAction.java:332)
 at com.novell.zenworks.configure.ZENworksConfigure.execConfigAction(ZENworksConfigure.java:1758)
 at com.novell.zenworks.install.customcode.configure.BaseZenConfigAction.install(BaseZenConfigAction.java:63)
 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.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: com.novell.zenworks.datamodel.exceptions.InternalDataModelException: Failed to create the database. Check if the path 'D:\zenworks' exists on the SQL Server.
 at com.novell.zenworks.datamodel.database.sqlserver.AuditSQLServerDatabaseConfigurator.createDatabase(AuditSQLServerDatabaseConfigurator.java:240)
 at com.novell.zenworks.configure.actions.db.AuditDatabaseConfigureAction.configure(AuditDatabaseConfigureAction.java:256)
 ... 19 more
Caused by: java.sql.BatchUpdateException: The CREATE DATABASE statement failed. The primary file must be at least 50 MB to accommodate a copy of the model database.
 at net.sourceforge.jtds.jdbc.JtdsStatement.executeBatch(JtdsStatement.java:947)
 at com.novell.zenworks.datamodel.database.sqlserver.AuditSQLServerDatabaseConfigurator.createDatabase(AuditSQLServerDatabaseConfigurator.java:234)
 ... 20 more
 
On this particular scenario, the System Database named model has a current size of 50 MB

Disclaimer

This Support Knowledgebase provides a valuable tool for NetIQ/Novell/SUSE customers and parties interested in our products and solutions to acquire information, ideas and learn from one another. Materials are provided for informational, personal or non-commercial use within your organization and are presented "AS IS" WITHOUT WARRANTY OF ANY KIND.

  • Document ID:7014681
  • Creation Date:04-MAR-14
  • Modified Date:04-MAR-14
    • NovellZENworks Configuration Management

Did this document solve your problem? Provide Feedback