Usage Note 38429: Generating journal files for the SAS® OLAP Server by using SAS® Management Console
 |  |  |  |
Journal files can provide information that will help you troubleshoot problems and understand the queries that are being submitted to the SAS OLAP Server. To generate journal files, follow these steps:
- Stop your SAS OLAP Server.
- Log into SAS Management Console.
- Expand Server Manager ► AppServerName ► AppServerName - Logical OLAP Server ► AppServerName - OLAP Server.
- Right click on AppServerName - OLAP Server and select Properties.
- Click the Options tab.
- Click Advanced Options.
- Click the Debug Query tab.
- Select only these two options: Print input MDX statement and Print Generated SQL.
- Restart your SAS OLAP Server.
CAUTION: Do not select any other options. In addition, for performance reasons, you should disable these options after your goal is achieved.
The journal files will begin with SSNJxxx and they will be in a location such as C:\sas\sasconfigdir\Lev1\SASApp.
For information about journal files in SAS 9.3 and later, see SAS Note 50015.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS OLAP Server | AIX | ||
| HP-UX | ||||
| HP-UX IPF | ||||
| IRIX | ||||
| Linux | ||||
| Linux for x64 | ||||
| Linux on Itanium | ||||
| OpenVMS on HP Integrity | ||||
| OpenVMS Alpha | ||||
| 64-bit Enabled AIX | ||||
| Windows Vista | ||||
| Windows Millennium Edition (Me) | ||||
| Windows 7 Ultimate x64 | ||||
| Windows 7 Ultimate 32 bit | ||||
| Windows 7 Professional x64 | ||||
| 64-bit Enabled HP-UX | ||||
| 64-bit Enabled Solaris | ||||
| ABI+ for Intel Architecture | ||||
| Windows 7 Home Premium x64 | ||||
| Windows 7 Home Premium 32 bit | ||||
| Windows 7 Enterprise x64 | ||||
| Windows 7 Professional 32 bit | ||||
| Windows 7 Enterprise 32 bit | ||||
| Microsoft Windows XP Professional | ||||
| Microsoft Windows Server 2008 | ||||
| Microsoft Windows Server 2003 Standard Edition | ||||
| Microsoft Windows Server 2003 Enterprise Edition | ||||
| Microsoft Windows Server 2003 Datacenter Edition | ||||
| Microsoft Windows NT Workstation | ||||
| Microsoft Windows 2000 Professional | ||||
| Microsoft Windows 2000 Server | ||||
| Microsoft Windows 2000 Datacenter Server | ||||
| Microsoft Windows 2000 Advanced Server | ||||
| Microsoft Windows 95/98 | ||||
| OS/2 | ||||
| Microsoft® Windows® for x64 | ||||
| Microsoft Windows XP 64-bit Edition | ||||
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | ||||
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | ||||
| Microsoft® Windows® for 64-Bit Itanium-based Systems | ||||
| OpenVMS VAX | ||||
| z/OS | ||||
| Solaris | ||||
| Solaris for x64 | ||||
| Tru64 UNIX | ||||
| Type: | Usage Note |
| Priority: | |
| Topic: | System Administration ==> Logging System Administration ==> Servers ==> OLAP |
| Date Modified: | 2010-01-19 11:32:27 |
| Date Created: | 2010-01-18 15:02:39 |