Scenario:
Fresh Data platform install for version 5.5.22
Data Platform configuration wizard fails on Create BDNA Schema.
Error occurred when executing mssql_CreateDatabase.sql
Error in setup.log:
ERROR Read script file error:
Microsoft.SqlServer.Management.Common.ExecutionFailureException: An exception occurred while executing a Transact-SQL statement or batch. ---> System.Data.SqlClient.SqlException: MODIFY FILE failed. Specified size is less than or equal to current size.
Cause:
The script uses the ALTER DATABASE with MODIFY FILE command which can only make a file size bigger.
If a smaller size is encountered the above error is caused.
a)If "BDNA" and "BDNA_PUBLISH" already exists with a default size greater than what is specified in the script, this can give the above error.
b)If the model database in SQL server is set to a size greater than what is specified in the script, this can give the above error.
Resolution:
1)If its a fresh install - Drop existing "BDNA" and "BDNA_PUBLISH" database.
2)Close the config wizard if still opened.
3)In file explorer browse to C:\Program Files\BDNA\Data Platform\Database\SQLServer\Script or the equivalent location in your system.
4)Open the file mssql_CreateDatabase in edit mode and find the following code:
Original Code snippet:
"ALTER DATABASE [${BMS_CATALOG_NAME}] MODIFY FILE(Name = ${BMS_CATALOG_NAME}, SIZE =5GB , FILEGROWTH=200MB);
ALTER DATABASE [${BMS_CATALOG_NAME}] MODIFY FILE(Name = ${BMS_CATALOG_NAME}_LOG, SIZE =50MB , FILEGROWTH=50MB); "
Now replace or edit the above code to match the below:
ALTER DATABASE [${BMS_CATALOG_NAME}] MODIFY FILE(Name = ${BMS_CATALOG_NAME}, SIZE =350MB , FILEGROWTH=350MB);
ALTER DATABASE [${BMS_CATALOG_NAME}] MODIFY FILE(Name = ${BMS_CATALOG_NAME}_LOG, SIZE =250MB , FILEGROWTH=250MB);
5)Validate the Model database size. The modeldev and modellog size should be less than what is being used in the script. If it is not, you may either decrease the initial size in the model database or increase the size in the mssql_CreateDatabase.sql script.
