Thursday, February 14, 2013

OBIEE 11g - State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 46118] Out of disk space. (HY000)

Error Details
Error Codes: AAD5E5X3:OPR4ONWY:U9IM8TAC
Odbc driver returned an error (SQLFetchScroll).
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 46118] Out of disk space. (HY000) 

I had like 30Gb of free space in the server but still i was facing the issue where i was facing out of disk space error in the portal.

Issue: Users were running reports that occupied all the tmp space. Mount point where obiee was installed had only 3gb free space which was getting filled i had another mount point in the server where i had 25G free space. 

Resolution: change the workdirectory to the new mount point in NQSconfig.ini and restart the services.