Experience: is what you get soon after you need it.

Experience: is what you get soon after you need it.

Rasul Allah (sal Allahu alaihi wa sallam) said: "Restore the trusts of those who trust you, and deal not falsely with him who deals falsely with you." [Abu Dawud, Tirmidhi]

Search This Blog

Tuesday, December 13, 2011

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..

No comments: