OBIEE 10g: nQSError: 46073 - ANALYTICS TEMP FILES CANNOT BE LARGER THAN 2GB (Doc ID 786865.1)

Last updated on AUGUST 29, 2017

Applies to:

Business Intelligence Server Enterprise Edition - Version 10.1.3.4.0 [1900] to 10.1.3.4.2 [2405] [Release 10g]
Information in this document applies to any platform.

Symptoms


While running a report, we receive the following error message: State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 46073] Operation 'stat()' on file '/u02/OracleBIData/tmp/nQS_28056_15671_77250638.TMP' failed with error: (75) (HY000)

Watching the server as the report runs, a large file is created in the /OracleBIData/tmp directory. Once the file hits 2GB in size, the report generates the error. It appears that we are hitting a 2GB file size limitation.

Build:10.1.3.4.0 [1900] 
LINUX Red Hat Enterprise Linux AS release 4 (Nahant Update 6) 2.6.9 67.0.7.ELsmp (64-bit)


Please let me know how to resolve this issue. thank you. 

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