Problem Note 36261: Table registration errors might be returned for SAS® OLAP Server drill-through requests
After applying the second maintenance release for SAS 9.2 (TS2M2), the SAS OLAP Server might display an error that is similar to the following:
ERROR: The drillthrough table for cube "MyCube" was not found with the cube's registration. The table registration may have been deleted
This error indicates that the SAS Trusted User identity or the group to which the SAS Trusted User belongs has been denied ReadMetadata permission on the library and possibly the table that is being used for the drill-through request. The SAS Trusted User is a member of the SAS System Services group by default. A grant of ReadMetadata permission on the libraries and tables is a new requirement for SAS 9.2. In the third maintenance release for SAS 9.2 (TS2M3), the message has been changed as follows:
ERROR: The drillthrough table "DT_LIB.TABLE" was not found. The table registration may have been deleted or permissions to the library or table may be lacking.
Operating System and Release Information
| SAS System | SAS OLAP Server | z/OS | 9.2 TS2M2 | 9.2 TS2M3 |
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.2 TS2M2 | 9.2 TS2M3 |
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.2 TS2M2 | 9.2 TS2M3 |
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.2 TS2M2 | 9.2 TS2M3 |
| Microsoft Windows XP 64-bit Edition | 9.2 TS2M2 | 9.2 TS2M3 |
| Microsoft® Windows® for x64 | 9.2 TS2M2 | 9.2 TS2M3 |
| Microsoft Windows Server 2003 Datacenter Edition | 9.2 TS2M2 | 9.2 TS2M3 |
| Microsoft Windows Server 2003 Enterprise Edition | 9.2 TS2M2 | 9.2 TS2M3 |
| Microsoft Windows Server 2003 Standard Edition | 9.2 TS2M2 | 9.2 TS2M3 |
| Microsoft Windows XP Professional | 9.2 TS2M2 | 9.2 TS2M3 |
| Windows Vista | 9.2 TS2M2 | 9.2 TS2M3 |
| 64-bit Enabled AIX | 9.2 TS2M2 | 9.2 TS2M3 |
| 64-bit Enabled HP-UX | 9.2 TS2M2 | 9.2 TS2M3 |
| 64-bit Enabled Solaris | 9.2 TS2M2 | 9.2 TS2M3 |
| HP-UX IPF | 9.2 TS2M2 | 9.2 TS2M3 |
| Linux | 9.2 TS2M2 | 9.2 TS2M3 |
| Linux for x64 | 9.2 TS2M2 | 9.2 TS2M3 |
| OpenVMS on HP Integrity | 9.2 TS2M2 | 9.2 TS2M3 |
| Solaris for x64 | 9.2 TS2M2 | 9.2 TS2M3 |
*
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)
|
| Date Modified: | 2009-11-02 16:31:37 |
| Date Created: | 2009-06-17 15:43:10 |
