Unable to create new publish container getting below error in Cognos planning 8.

[ravikanth]

Getting below error while creating new Publish container

++++++++++++++++++++++++++++++++++++++++

---------------------------
Contributor
---------------------------
Unable to create new container

Unable to execute the statement.The CREATE DATABASE statement failed. The primary file must be at least 50 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 [imp_european_mkting_inves_view] ON PRIMARY ( NAME = [imp_european_mkting_inves_view_dat],  FILENAME = N'E:\cognos\Application_Data\imp_european_mkting_inves_view_dat.mdf',  SIZE = 10MB,  FILEGROWTH = 10% )     LOG ON  ( NAME = [imp_european_mkting_inves_view_log],  FILENAME = N'E:\cognos\Application_Data\imp_european_mkting_inves_view_log.mdf',  SIZE = 10MB,  FILEGROWTH = 10% )

The CREATE DATABASE statement failed. The primary file must be at least 50 MB to accommodate a copy of the model database.
---------------------------
OK   
---------------------------

Please do let me know if some one has comeacross this error. any thoughts on this plz well come.

[ericlfg]

Hi Ravikanth,

SQL server copies the model system database when you create a new database, so in this case it is failing because your model database is 50mb, yet planning is trying to create a DB with a size of 10mb. 

You will want to work with your DBA group and they can try to shrink the model database to less than or equal to 10MB and then try to create the container again.  The general idea is that they would run the below, which will try to shrink the model database to 10MB:
DBCC SHRINKFILE(Model, 10)

Hope this helps

[SomeClown]

Alternative is to edit the sql resources xml and make the default size bigger.  The file is called something like epeadminsql7resources.xml (or similar - going from memory).  In there is the template line for database create.  Edit the initial allocation size to be 50mb and you should be good to go.

You can also edit this line to change the logfile location if your DBA want to have them split up -- the  %n  numbers are parms passed in to the file, like app name or file location.

Services restart is required after editing - xml files are read only on startup of services.