Error : "Cannot create filegroups and partition files for ANALYSIS_EVENT because SQL Server is not Enterprise Edition" while installing Symantec Data Center Security 6.7
search cancel

Error : "Cannot create filegroups and partition files for ANALYSIS_EVENT because SQL Server is not Enterprise Edition" while installing Symantec Data Center Security 6.7

book

Article ID: 164713

calendar_today

Updated On:

Products

Data Center Security Server Advanced

Issue/Introduction

During the installation when creating the database you get an error.

806 2017-02-24 16:31:22.575 [DEBUG] [DatabaseUtil:793] FAILED STATEMENT [

DECLARE @sql            varchar(MAX),
@dbName         nvarchar(100),
@baseFolderPath nvarchar(260),
@filegroupName  nvarchar(100),
@filePath       nvarchar(300),
@index          int,
@dbType         varchar(15),
@fileSize       varchar(10),
@fileGrowth     varchar(10);

EXEC dbo.WriteDebug @STATUS=1065, @DESCR='** Determining partition file size and growth values for ANALYSIS_EVENT **';

SET @dbType = dbo.FmtDbType('Production');  -- use DB_TYPE environment variable from msde-params.bat

SET @fileSize   = '1 MB';
SET @fileGrowth = '10 MB';

IF (@dbType = 'PRODUCTION')
BEGIN
SET @fileSize   = '10 MB';
SET @fileGrowth = '200 MB';
END

SET @dbName = DB_NAME();

IF (dbo.IsEnterpriseEdition() = 1)    -- 0 is FALSE; 1 is TRUE
BEGIN
EXEC dbo.WriteDebug @STATUS=1066, @DESCR='** Creating filegroups and partition files for ANALYSIS_EVENT **';

SELECT @baseFolderPath =LEFT(f.physical_name,LEN(f.physical_name)-CHARINDEX(CHAR(92),REVERSE(f.physical_name))+1)
FROM sys.master_files f INNER JOIN sys.databases d
ON f.database_id = d.database_id
WHERE d.name = DB_NAME()
AND f.type = 0
AND f.name LIKE '%primary'

SET @index = 1;
WHILE (@index <= 733)
BEGIN
SET @filegroupName = 'analysis_eventDailyFG' + CONVERT(varchar(10), @index);   -- analysis_eventDailyFG1, etc.
SET @filePath = @baseFolderPath + @dbName + '_' + @filegroupName + '.ndf';     -- e.g., E:\SQLServerCustomDBs\Data\scsp_analysis_eventDailyFG1)

IF NOT EXISTS (SELECT * FROM sys.filegroups WHERE name = @filegroupName)
BEGIN
SET @sql = 'ALTER DATABASE "' + @dbName + '" ADD FILEGROUP ' + @filegroupName;
EXEC (@sql)
END

IF NOT EXISTS (SELECT *
FROM sys.master_files f INNER JOIN sys.databases d
ON f.database_id = d.database_id
WHERE d.name = @dbName
AND f.type = 0
AND f.name = @filegroupName)
BEGIN
SET @sql = 'ALTER DATABASE "' + @dbName + '" ADD FILE (name = ' + @filegroupName + ', ' +
'filename = ''' + @filePath + ''', ' +
'size = ' + @fileSize + ', ' +
'filegrowth = ' + @fileGrowth + ') ' +
'TO FILEGROUP ' + @filegroupName;
EXEC (@sql)
END

SET @index = @index + 1;
END  -- end of while-loop
END
ELSE
BEGIN
EXEC dbo.WriteDebug @STATUS=1066, @DESCR='** Cannot create filegroups and partition files for ANALYSIS_EVENT because SQL Server is not Enterprise Edition **';
END  -- end of (dbo.IsEnterpriseEdition() = 1)  if-else-statement
]
807 2017-02-24 16:31:22.575 [ERROR] [DatabaseUtil:799] java.sql.SQLException: One or more files listed in the statement could not be found or could not be initialized.

Environment

File location with Error : C:\Program Files (x86)\Symantec\Data Center Security Server\Server\tomcat\logs 

Name = configuration.log

Resolution

Disk space required is missing. You need at least 60GB free. More details on file structure see : http://www.symantec.com/docs/TECH236236