Usage Note 36728: 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 only records 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.
In order to capture the complete messages being sent between a 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.
- Stop your SAS OLAP Server.
- Add the following parameters to your -OBJECTSERVERPARMS option in sasv9.cfg or OLAPServer.sh located in your SAS OLAP Server's configuration directory
JNLSTRMAX=50000 JNLLINEMAX=50000
The complete statement will look like:
-objectserverparms "cel=credentials classfactory=F3F46472-1E31-11D5-87C2-00C04F38F9F6 servercomponent='...server name...' JNLLINEMAX=50000 JNLSTRMAX=50000"
- 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.
- Open SAS Management Console.
- Expand the Server Manager plug-in.
- Expand your application server (SASApp).
- Expand your logical OLAP Server (SASApp - Logical OLAP Server).
- Right-click on the OLAP Server (SASApp - OLAP Server) and select Connect. The Loggers tab will become active at this point.
- Right-click on the App logger and select Properties.
- Set the Assigned level to Trace.
- Click OK to save the change.
- Execute your report to replicate the problem scenario.
To disable the logging, set the Assigned level for the App logger back to Information.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS OLAP Server | z/OS | 9.2 TS2M0 | |
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.2 TS2M0 | |||
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.2 TS2M0 | |||
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.2 TS2M0 | |||
| Microsoft Windows XP 64-bit Edition | 9.2 TS2M0 | |||
| Microsoft® Windows® for x64 | 9.2 TS2M0 | |||
| Microsoft Windows Server 2003 Datacenter Edition | 9.2 TS2M0 | |||
| Microsoft Windows Server 2003 Enterprise Edition | 9.2 TS2M0 | |||
| Microsoft Windows Server 2003 Standard Edition | 9.2 TS2M0 | |||
| Microsoft Windows XP Professional | 9.2 TS2M0 | |||
| Windows Vista | 9.2 TS2M0 | |||
| 64-bit Enabled AIX | 9.2 TS2M0 | |||
| 64-bit Enabled HP-UX | 9.2 TS2M0 | |||
| 64-bit Enabled Solaris | 9.2 TS2M0 | |||
| HP-UX IPF | 9.2 TS2M0 | |||
| Linux | 9.2 TS2M0 | |||
| Linux for x64 | 9.2 TS2M0 | |||
| OpenVMS on HP Integrity | 9.2 TS2M0 | |||
| Solaris for x64 | 9.2 TS2M0 | |||
| Type: | Usage Note |
| Priority: | |
| Topic: | System Administration ==> Servers ==> OLAP |
| Date Modified: | 2010-02-05 11:06:24 |
| Date Created: | 2009-08-05 15:44:06 |