• Print |
• E-mail  |
• Bookmark

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

A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:

A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at :