Data Center Security Server Advance (DCS) Manager installation fails with unable to create database error

Products

• Data Center Security Server Advanced

Issue/Introduction

DCS primary manager installation failed with unable to create database error. 

 

 [ERROR] [DatabaseUtil:900] java.sql.SQLException: The CREATE DATABASE statement failed. The primary file must be at least 1024 MB to accommodate a copy of the model database.

                at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372)

                at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2893)

                at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2335)

                at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:644)

                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.symantec.server.configuration.helper.DatabaseUtil.runAsServerAdministrator(DatabaseUtil.java:884)

                at com.symantec.server.configuration.helper.DatabaseUtil.createDatabase(DatabaseUtil.java:286)

                at com.symantec.server.configuration.ui.ProgressPage$CreateDatbaseWorker.doInBackground(ProgressPage.java:1397)

                at com.symantec.server.configuration.ui.ProgressPage$CreateDatbaseWorker.doInBackground(ProgressPage.java:1356)

                at javax.swing.SwingWorker$1.call(SwingWorker.java:295)

                at java.util.concurrent.FutureTask.run(FutureTask.java:266)

                at javax.swing.SwingWorker.run(SwingWorker.java:334)

                at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

                at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

                at java.lang.Thread.run(Thread.java:748)

 

Environment

Release : 6.8 MP2

Component : Database

Cause

This message is generated by the SQL Server engine.

For Microsoft SQL 2008 R2 and SQL 2012 a primary file needs a minimum capacity of 3 MB to receive a copy of the Model database and create a SQL Server database successfully. 

When DCS installer creates a new database, SQL server uses Model DB as a template. SQL server doesn't like to create a database that is smaller than their Model DB.

Since the customer have it set to 1024 MB (no the default value) then SQL server displayed the mentioned error.

Resolution

In this particular instance, change the Model database size from 1024 MB (or whatever higher value that you may be using) to 3 MB.

Retry the installation process this time SCSPDB database should be created successfully.

1. Open Microsoft SQL Server Management Studio
2. Under Databases> System Databases, right-click on Model and open Properties.
3. Under 'Files', change the 'Initial Size (MB)' to 3. Click OK.