Error: "FILESTREAM Feature Is Disabled." When Installing or Upgrading to a P6 EPPM 16.1 or Later Database

Last updated on APRIL 02, 2018

Applies to:

Symptoms

When attempting to install a P6 EPPM 16.1 or later database using dbsetup.bat/dbsetup.sh the following error is observed:

Error
-------------
"RuntimeException: Error in Create the SQL Server tablespaces for P6 EPPM: RuntimeException (Error in Run SQL Script sspm_init_db.sql: DatabaseToolException (FILESTREAM feature is disabled.)"

The following is noted in the DatabaseSetup.log:

[ERROR] [2016-04-02 11:51:06] FILESTREAM feature is disabled.
[ERROR] [2016-04-02 11:51:06] Database Error: error number=5591
[ERROR] [2016-04-02 11:51:06] Error Message: FILESTREAM feature is disabled.
[USER] Could not complete because the job "Run SQL Script sspm_init_db.sql" failed.
com.primavera.database.tools.DatabaseToolException: FILESTREAM feature is disabled.
at com.primavera.database.tools.ScriptRunner.ScriptRunner.runSQL(ScriptRunner.java:209)
at com.primavera.database.tools.ScriptRunner.ScriptRunner.run(ScriptRunner.java:145)
at com.primavera.database.tools.dbmt.workflow.SqlScriptJob.doJob(SqlScriptJob.java:86)
at com.primavera.database.tools.dbmt.AbstractJob.execute(AbstractJob.java:64)
at com.primavera.database.tools.dbmt.WorkflowStepJob.doJob(WorkflowStepJob.java:49)
at com.primavera.database.tools.dbmt.AbstractJob.execute(AbstractJob.java:64)
at com.primavera.database.tools.dbmt.actions.BaseWizardRunner.runJob(BaseWizardRunner.java:205)
at com.primavera.database.tools.dbmt.actions.BaseWizardRunner.commit(BaseWizardRunner.java:214)
at com.primavera.database.tools.dbmt.actions.CreateSSDatabaseTransOp.process(CreateSSDatabaseTransOp.java:74)
at com.primavera.database.tools.dbmt.actions.TransitionMap.perform(TransitionMap.java:241)
at com.primavera.database.tools.dbmt.actions.PropertyWizardNavigationAction.tryToLeavePage(PropertyWizardNavigationAction.java:44)
at com.primavera.database.tools.dbmt.gui.DefaultGuiWizardRunner$ProceedAction.actionPerformed(DefaultGuiWizardRunner.java:425)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
...

When attempting to upgrade to a P6 EPPM 16.1 or later database using dbsetup.bat/dbsetup.sh the following error is observed:

Error
-------------
"DECLARE @DB_NAME SYSNAME
SELECT @FILE_CNT=COUNT(*) FROM MASTER.SYS.MASTER_FILES WHERE NAME ='FS_FILE1';
IF @FILE_CNT = 0
BEGIN
SELECT @DB_NAME=DB_NAME()
SET @V_STREAMFILE_PATH=(SELECT SUBSTRING(PHYSICAL_NAME, 1, CHARINDEX(N'MASTER.MDF', LOWER(PHYSICAL_NAME)) - 1)
FROM MASTER.SYS.MASTER_FILES
WHERE DATABASE_ID = 1 AND FILE_ID = 1);
SET @V_STREAMFILE_PATH_NAME=@V_STREAMFILE_PATH + 'FILESTREAM_DOC.MDF';
SET @V_SQL = 'ALTER DATABASE ' + @DB_NAME + ' ADD FILEGROUP '+ @DB_NAME +'_FS_FILES CONTAINS FILESTREAM'
EXEC (@V_SQL)
SET @V_STREAMFILE_PATH_NAME= @V_STREAMFILE_PATH +@DB_NAME +'_FS_DOC.MDF'
SET @V_SQL = 'ALTER DATABASE '+ @DB_NAME +' ADD FILE (NAME= ''FS_FILE1'',FILENAME = '''+@V_STREAMFILE_PATH_NAME+''') TO FILEGROUP '+ @DB_NAME +'_FS_FILES'
EXEC (@V_SQL)
END"

The following is noted in the DatabaseSetup.log:

[ERROR] FILESTREAM feature is disabled.
[ERROR] Database Error: error number=5591
[ERROR] Error Message: FILESTREAM feature is disabled.
[WARN] [USER] Could not complete because the job "Run SQL Script SSPM_P152.sql" failed.
com.primavera.database.tools.DatabaseToolException: FILESTREAM feature is disabled.
at com.primavera.database.tools.ScriptRunner.ScriptRunner.runSQL(ScriptRunner.java:209)
at com.primavera.database.tools.ScriptRunner.ScriptRunner.run(ScriptRunner.java:145)
at com.primavera.database.tools.dbmt.workflow.SqlScriptJob.doJob(SqlScriptJob.java:86)
at com.primavera.database.tools.dbmt.AbstractJob.execute(AbstractJob.java:64)
at com.primavera.database.tools.dbmt.WorkflowStepJob.doJob(WorkflowStepJob.java:49)
at com.primavera.database.tools.dbmt.AbstractJob.execute(AbstractJob.java:64)
at com.primavera.database.tools.dbmt.actions.BaseWizardRunner.runJob(BaseWizardRunner.java:205)
at com.primavera.database.tools.dbmt.actions.BaseWizardRunner.commit(BaseWizardRunner.java:214)
at com.primavera.database.tools.dbmt.actions.JobTreeTypeDef$JobRunner.run(JobTreeTypeDef.java:253)
at java.lang.Thread.run(Unknown Source)

STEPS TO DUPLICATE:

1. Launch dbsetup.bat/dbsetup.sh
2. Select "Install a new database" or "Upgrade an existing database"
3. Select "Microsfot SQL Server", Next
4. Enter in connection details, follow prompts and observe error

Changes

Cause