OBIEE --Presentation services No Log Found

User was not able to view the contents of the Log from OBIEE presentation services.
i.e

Re producing the issue:In OBIEE.



under administrattion:

go to Mange Sessions:




 click on Manage sessions Then click on view log.



You got the error message:



Solution:

Make sure logging is turned on for the user. i.e >2 or more.





Now bounce the OBIEE services and you should be able to view the logs now.






2)
If you still have the issue then verify the session variable " Log Level"  is not set with any default value like "0"

see below:




If yes then
Remove this default value and try again by bouncing the OBIEE services.

3) If you still have issues make sure there are not custom initialization blocks defined to block the logging.

see example  below:





Remove this and bounce the OBIEE. You should be all set ..


Reference:
MOS:817010.1

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