IBM Support

CREATE DATABASE error when creating Planning Administration Domain (PAD) in SQL Server

Troubleshooting


Problem

When an administrator tries to create a new PAD with the PAD creation wizard, they receive the following error message.

Symptom

There has been an error in the create process.

Unable to execute the statement.CREATE DATABASE failed. Could not allocate enough disk space for a new database on the named disks. Total space allocated must be at least 25 MB to accommodate a copy of the model database., Error number -2147217900 was raised by Microsoft OLE DB Provider for SQL Server. Native RDBMS error 1803

The SQL was:
CREATE DATABASE [pad_live] ON PRIMARY (NAME=[pad_live_dat], FILENAME=
N'E:\MSSQL\Data\pad_live_dat.mdf', SIZE=10MB, FILEGROWTH=10%) LOG ON (NAME=[pad_live_log],
FILENAME=N'E:\MSSQL\Data\pad_live_log.mdf', SIZE=10MB, FILEGROWTH=10%)

CREATE DATABASE failed. Could not allocate enough disk space for a new database on the named disks. Total space
allocated must be at least 25 MB to accommodate a copy of the model database.

The Planning Administration Domain datastore could not be created.

[{"Product":{"code":"SSEH6Q","label":"Cognos Planning for Series 7"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Contributor","Platform":[{"code":"PF033","label":"Windows"}],"Version":"Planning - Contributor 7.3","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SS9S5U","label":"Cognos 8 Planning"},"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Component":"Contributor","Platform":[{"code":"","label":""}],"Version":"8.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Historical Number

1029237

Document Information

Modified date:
09 May 2025

UID

swg21346712

Page Feedback