OBIEE 12c: How to Change the TEMP Files Location qexxxxxx Generated in "/tmp"

(Doc ID 2309770.1)

Last updated on SEPTEMBER 21, 2017

Applies to:

Business Intelligence Server Enterprise Edition - Version 12.2.1.2.0 and later
Linux x86-64

Goal

The qexxxxxx Files which has a prefix "qe" are generated in "/tmp" when running OBIEE Analysis reports as following

Analysis Report would throws "insufficient diskspace" error as following  if the "/tmp" is not large enough for the running report.

How to Change the TEMP Files Location qexxxxxx Generated in "/tmp"?

Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000)
State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. (HY000)
State: HY000. Code: 43119. [nQSError: 43119] Query Failed: (HY000)
State: HY000. Code: 16001. [nQSError: 16001] ODBC error state: S1000 code: 1506 message: [Oracle DataDirect][ODBC DB2 Wire Protocol driver]Insufficient disk space.. (HY000)
State: HY000. Code: 16015. [nQSError: 16015] SQL statement execution failed. (HY000)
SQL Issued: SELECT 0 s_0, ....FETCH FIRST 100000001 ROWS ONLY
 

 

Solution

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