Error: "FILESTREAM Feature Is Disabled." When Installing or Upgrading to a P6 EPPM 16.1 or Later Database (Doc ID 2123402.1)

Last updated on APRIL 05, 2017

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 16.1 and later
Information in this document applies to any platform.

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

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms