Problem Note 16599: IGNORE_MISSING_DIMKEYS option may cause data integrity problems or Write
Access Violation with PROC OLAP
You may get a write access violation error or incorrect data values for
measures in a cube built with the IGNORE_MISSING_DIMKEYS option. You may
see measures that are unexpectedly large or small such that they are
displayed in scientific notation or that appear to be possibly correct
when in fact they may not be. Alternatively, the cube build may fail
with the following write access violation:
ERROR: Write Access Violation In Task [ OLAP )
Exception occurred at (609ECCC5)
Task Traceback
Address Frame (DBGHELP API Version 4.0 rev 5)
609ECCC5 04F3F5A4 saspolap:mcn_main+0x1BCC5
609D315E 04F3FF88 saspolap:mcn_main+0x215E
01082B02 04F3FFA0 sashost:Main+0xBE72
01086C10 04F3FFB4 sashost:Main+0xFF80
7C57B388 04F3FFEC KERNEL32:lstrcmpiW+0xB7
It is strongly recommended that you NOT use this option.
If only one dimension in the cube has missing dimension keys, this
problem can be avoided by defining that dimension first in either PROC
OLAP code or in SAS® OLAP Cube Studio.
Select the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| SAS System | SAS OLAP Server | Tru64 UNIX | 9.1 TS1M3 SP2 | |
| 64-bit Enabled AIX | 9.1 TS1M3 SP2 | |
| OpenVMS Alpha | 9.1 TS1M3 SP2 | |
| 64-bit Enabled HP-UX | 9.1 TS1M3 SP2 | |
| HP-UX IPF | 9.1 TS1M3 SP2 | |
| Linux on Itanium | 9.1 TS1M3 SP2 | |
| Linux | 9.1 TS1M3 SP2 | |
| z/OS | 9.1 TS1M3 SP2 | |
| 64-bit Enabled Solaris | 9.1 TS1M3 SP2 | |
| Microsoft Windows 2000 Advanced Server | 9.1 TS1M3 SP2 | |
| Microsoft Windows 2000 Datacenter Server | 9.1 TS1M3 SP2 | |
| Microsoft Windows 2000 Professional | 9.1 TS1M3 SP2 | |
| Microsoft Windows 2000 Server | 9.1 TS1M3 SP2 | |
| Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M3 SP2 | |
| Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M3 SP2 | |
| Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M3 SP2 | |
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 SP2 | |
| Microsoft Windows XP 64-bit Edition | 9.1 TS1M3 SP2 | |
| Microsoft Windows NT Workstation | 9.1 TS1M3 SP2 | |
| Microsoft Windows XP Professional | 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: | alert |
| Topic: | Query and Reporting ==> OLAP (Online Analytical Processing)
System Administration ==> Servers ==> OLAP
|
| Date Modified: | 2006-02-08 17:25:42 |
| Date Created: | 2005-11-30 09:45:33 |
