Problem Note 14353: MDX LAG function used on first measure of OLAP cube causes Access
Violation
If you attempt to use the MDX LAG function to point to a measure prior
to the first physical measure in an SAS OLAP cube, you may receive the
following access violation on your SAS OLAP Server:
First-Chance Exception: SIGACCESS (Access Violation).
EXCEPTION_ACCESS_VIOLATION (C0000005) write access at Address
00000000.
[044] tkmk:\ufuncs.c\sastb_print 129 (+0x3)
Source file not found: C:/workspaces/panic/sastb/ufuncs.c
CPR>where
1* In routine tkmk:\ufuncs.obj\sastb_print 129 (+0x3)
2 Called from tkmk:\bksastbi.obj\bktb_print 196 (+0xD)
3 Called from tkmk:\bksastb.obj\tktb_print 88 (+0x20)
4 Called from tkmk:\bkassert.obj\bkassert 122 (+0x15)
5 Called from tkeols:\skassert.obj\skassert 36 (+0x1A)
6 Called from tkeols:\olswrfrm.obj\ols_wfexpandmeasures 1542 (+0x32)
7 Called from tkeols:\olswrfrm.obj\ols_wfgetnxtrgnqry 1871 (+0x17)
8 Called from tkeols:\olsexecute.obj\ExecThread 499 (+0x14)
9 Called from tkeols:\olsexecute.obj\ols_execcube 297 (+0x8)
10 Called from tkeols:\olsstmt.obj\ols_mdxdriver 504 (+0x1D)
11 Called from tkeols:\olsutil.obj\ols_thrlogic 47 (+0xB)
12 Called from tkepdl:\tkepdlb.obj\basicPuddleMain 561 (+0x1C)
13 Called from tkmk:\sktMain.obj\sktMain 95 (+0x11)
14 Called from tkmk:\bktMain.obj\bktMain 50 (+0x8)
For example, you could receive this exception if you use the following
SELECT statement on a cube built from SASHELP.PRDSALE:
SELECT [measures].[ACTUAL_N].lag(1) on columns
from [prdmddb]
A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:
http://www.sas.com/techsup/download/hotfix/e9_sbcs_prod_list.html#014353
For customers running SAS with Asian Language Support (DBCS), this
fix should be downloaded from:
http://www.sas.com/techsup/download/hotfix/e9_dbcs_prod_list.html#014353
Operating System and Release Information
SAS System | SAS OLAP Server | Tru64 UNIX | 9.1 TS1M0 | 9.1 TS1M3 SP2 |
64-bit Enabled AIX | 9.1 TS1M0 | 9.1 TS1M3 SP2 |
OpenVMS Alpha | 9.1 TS1M0 | 9.1 TS1M3 SP2 |
64-bit Enabled HP-UX | 9.1 TS1M0 | 9.1 TS1M3 SP2 |
HP-UX IPF | 9.1 TS1M0 | 9.1 TS1M3 SP2 |
Linux | 9.1 TS1M0 | 9.1 TS1M3 SP2 |
z/OS | 9.1 TS1M0 | 9.1 TS1M3 SP2 |
64-bit Enabled Solaris | 9.1 TS1M0 | 9.1 TS1M3 SP2 |
Microsoft Windows 2000 Advanced Server | 9.1 TS1M0 | 9.1 TS1M3 SP2 |
Microsoft Windows 2000 Datacenter Server | 9.1 TS1M0 | 9.1 TS1M3 SP2 |
Microsoft Windows 2000 Professional | 9.1 TS1M0 | 9.1 TS1M3 SP2 |
Microsoft Windows 2000 Server | 9.1 TS1M0 | 9.1 TS1M3 SP2 |
Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M0 | 9.1 TS1M3 SP2 |
Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M0 | 9.1 TS1M3 SP2 |
Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M0 | 9.1 TS1M3 SP2 |
Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M0 | 9.1 TS1M3 SP2 |
Microsoft Windows NT Workstation | 9.1 TS1M0 | 9.1 TS1M3 SP2 |
Microsoft Windows XP Professional | 9.1 TS1M0 | 9.1 TS1M3 SP2 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Type: | Problem Note |
Priority: | high |
Topic: | Query and Reporting ==> OLAP (Online Analytical Processing) System Administration ==> Servers ==> OLAP
|
Date Modified: | 2005-04-27 14:18:01 |
Date Created: | 2005-01-24 16:36:33 |