Setting additional debug options for the SAS® OLAP Server 9.2 and later


Enabling additional logging within your SAS OLAP Server can help resolve many issues. By default, the SAS OLAP Server records only minimal information in an effort to limit the amount of resources used for activity other than the queries. The additional logging can be enabled or disabled through the SAS Management Console interface, or by using the logging.trace.xml file or the sasv9_trace.cfg file available in your SAS OLAP Server's configuration directory.

JNLSTRMAX=50000 JNLLINEMAX=50000

In order to capture the complete messages being sent between an OLAP client, the SAS OLAP Server, and the SAS Metadata Server, you must add two additional parameters to the -OBJECTSERVERPARMS option in the SAS OLAP Server's configuration file. You need to perform this step only once. Leaving the parameters set will not cause any impact to a server with the default logger level.

  1. Stop your SAS OLAP Server.
  2. Add the following parameters to your -OBJECTSERVERPARMS option in sasv9.cfg or OLAPServer.sh located in your SAS OLAP Server's configuration directory

    The complete statement will look like the following:

-objectserverparms "cel=credentials classfactory=F3F46472-1E31-11D5-87C2-00C04F38F9F6 servercomponent='...server name...' JNLLINEMAX=50000 JNLSTRMAX=50000"

3. Start your SAS OLAP Server.

The following steps can be used to enable additional logging information in a SAS OLAP Server using SAS Management Console.

  1. Open SAS Management Console.
  2. Expand the Server Manager plug-in.
  3. Expand your application server (SASApp).
  4. Expand your logical OLAP Server (SASApp - Logical OLAP Server).
  5. Right-click on the OLAP Server (SASApp - OLAP Server) and select Connect. The Loggers tab will become active at this point.
  6. Right-click the App logger and select Properties.
  7. Set the Assigned level to Trace.
  8. Click OK to save the change.
  9. Execute your report to replicate the problem scenario.

To disable the logging, set the Assigned level for the App logger back to Information.