OBIEE 11g /12c Error 'FOProcessor cannot run without a valid TMP directory' When Exporting Data to Microsoft Excel 2007 (Doc ID 2008401.1)

Last updated on JUNE 26, 2017

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.7.150120 and later
Information in this document applies to any platform.

Symptoms

You have applied Patch 11.1.1.7.150120 and now the functionality for exporting data into Microsoft Excel 2007 doesn't work.

The following error is shown:

"There was an error processing your download. Please check with your administrator"

The steps in the readme for the patch 11.1.1.7.150120, suggest the following actions:

1. In the config.xml file, configure the XMLP tag for large data as follows:
    0
    false

2. In the xdo.cfg file, add the following parameter inside the properties tag:
    true

From the presentation services log, the error was observed:

"Error while executing ExcelRpcCall.processMessage oracle.xdo.XDOException: FOProcessor cannot run without a valid TMP directory. Please check if TMP directory exist and write enabled."

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