My Oracle Support Banner

Error: 'The CREATE DATABASE Statement Failed. The Primary File Must be at Least 1000 MB to Accommodate a Copy of the Model Database' When Running DBSETUP (Doc ID 2538302.1)

Last updated on MARCH 22, 2022

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 18.8.8.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to run the dbsetup.bat (/.sh) Database Setup Wizard to create a new P6 database, the following error occurs.

RunTimeException: Error in Create the SQL Server tablespaces for Project Manager: RuntimeException (Error in Run SQL Script sspm_init_db.sql : DatabaseToolException (The CREATE DATABASE statement failed. The primary file must be at least 1000 MB to accommodate a copy of the model database.)) (Error in Create the SQL Server tablespaces for Project Manager: RuntimeException (Error in Run SQL Script sspm_init_db.sql : DatabaseToolException (The CREATE DATABASE statement failed. The primary file must be at least 1000 MB to accommodate a copy of the model database.)))

 

The issue can be reproduced at will with the following steps:
   1. Run dbsetup.bat from the database folder of the EPPM media (ex. P6EPPM-<version>\Database).
   2. Select Create a new database and the Microsoft SQL Server database type.
   3. Note reported error.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.