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 MARCH 22, 2022

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.