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.
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.
We’ve researched on this error and this issue has been logged as a BUG “BUG 6998143 – ANALYTICS TEMP FILES CANNOT BE LARGER THAN 2GB “.
According to BUG 6998143, in UNIX/LINUX env tmp files over 2 GB in size lead to an error. This bug was fixed for Window env in OBIEE 10.1.3.2, and has been fixed for UNIX/LINUX env in OBIEE 10.1.3.4.
Please note that a patch for BUG 5543386 – ANALYTICS TEMP FILES CANNOT BE LARGER THAN 2GB, for Linux is now available.