State: HY000. Code: 0. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. Not enough space (HY000)

Our users were not able to view the session logs via manage sessions in OBIEE.

error:
State: HY000. Code: 0. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. Not enough space (HY000)

screen shot:




Resolution:

Go to your NQSConfig.INI
and check the below parameter.

###############################################################################
#
# User Log Section
#
# The user log NQQuery.log is kept in the server\log directory. It logs
# activity about queries when enabled for a user. Entries can be
# viewed using a text editor or the nQLogViewer executable.
#
###############################################################################

[ USER_LOG ]

USER_LOG_FILE_SIZE = 10 MB; // default size
CODE_PAGE = "UTF8"; // ANSI, UTF8, 1252, etc.

Here you can see the LOG_FILE_SIZE=10mb which is very low and hence users were not able to open the session logs, so I went ahead and increased the size to 100MB


USER_LOG_FILE_SIZE = 100 MB;

and now bounce the obiee services.

and after this change users were able to view the logs.

go to settings->administration->Manage sessions



then

view log;


here we go;




all good..