Problem Note 36379: Transaction numbers for the SAS® OLAP Server might be incorrect when a large number of subqueries are generated
 |  |  |  |  |
Through ARM logging, the SAS OLAP Server provides the ability to log query and performance information. In some cases, when a large number of subqueries have been generated, the transaction number for the parent query might be incorrect, which results in an unusable ARM log.
Currently, there is no specific known threshold for the number of subqueries that would cause this problem. Also, there is no circumvention for this problem.
Select the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS OLAP Server | Linux | 9.2 TS2M0 | 9.2 TS2M2 |
| HP-UX IPF | 9.2 TS2M0 | 9.2 TS2M2 | ||
| 64-bit Enabled Solaris | 9.2 TS2M0 | 9.2 TS2M2 | ||
| 64-bit Enabled HP-UX | 9.2 TS2M0 | 9.2 TS2M2 | ||
| 64-bit Enabled AIX | 9.2 TS2M0 | 9.2 TS2M2 | ||
| Windows Vista | 9.2 TS2M0 | 9.2 TS2M2 | ||
| Microsoft Windows XP Professional | 9.2 TS2M0 | 9.2 TS2M2 | ||
| Microsoft Windows Server 2003 Standard Edition | 9.2 TS2M0 | 9.2 TS2M2 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 9.2 TS2M0 | 9.2 TS2M2 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 9.2 TS2M0 | 9.2 TS2M2 | ||
| Microsoft® Windows® for x64 | 9.2 TS2M0 | 9.2 TS2M2 | ||
| Microsoft Windows XP 64-bit Edition | 9.2 TS2M0 | 9.2 TS2M2 | ||
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.2 TS2M0 | 9.2 TS2M2 | ||
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.2 TS2M0 | 9.2 TS2M2 | ||
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.2 TS2M0 | 9.2 TS2M2 | ||
| z/OS | 9.2 TS2M0 | 9.2 TS2M2 | ||
| Linux for x64 | 9.2 TS2M0 | 9.2 TS2M2 | ||
| OpenVMS on HP Integrity | 9.2 TS2M0 | 9.2 TS2M2 | ||
| Solaris for x64 | 9.2 TS2M0 | 9.2 TS2M2 | ||
A fix for this issue for Base SAS 9.21 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/A01.html#36379| Type: | Problem Note |
| Priority: | alert |
| Topic: | Query and Reporting ==> OLAP (Online Analytical Processing) |
| Date Modified: | 2009-09-09 12:54:12 |
| Date Created: | 2009-06-26 11:36:05 |