SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 32376: Access violation occurs when updating metadata for a table that contains multiple indexes with long index names

DetailsHotfixAboutRate It

If you run the METALIB procedure to update a table that contains indexes with names longer than 30 characters, the procedure truncates the index names to 30 characters. If this truncation causes duplicate index names (in other words, the first 30 characters are not unique for two or more indexes), the following error occurs:

 ERROR:  Read Access Violation In Task [ METALIB )  
 Exception occurred at (076D3914)
 Task Traceback
 Address   Frame     (DBGHELP API Version 4.0 rev 5)
 076D3914  077FF700  sasmetas:mcn_main+0x12914
 076D57EC  077FF758  sasmetas:mcn_main+0x147EC
 076CEA25  077FF9D0  sasmetas:mcn_main+0xDA25
 076CC8A2  077FFBDC  sasmetas:mcn_main+0xB8A2
 076C23A3  077FFF88  sasmetas:mcn_main+0x13A3
 01262B02  077FFFA0  sashost:Main+0xBE72
 01266C20  077FFFB4  sashost:Main+0xFF90
 7C80B683  077FFFEC  kernel32:GetModuleFileNameA+0x1B4

To work around this problem you must rename the indexes in the original data source such that they are either shorter than 30 characters, or that the first 30 characters are unique for all indexes.

Select the Hot Fix tab in this note to access the hot fix for this issue. After applying the hot fix, the maximum length for index names that can be registered by PROC METALIB will be 256 characters. However, other components of SAS or the DBMS might enforce a shorter length, causing the index name to be truncated. Whichever index name registered, either the full name or the truncated name, must be a unique name for all indexes.



Operating System and Release Information

Product FamilyProductSystemSAS Release
ReportedFixed*
SAS SystemSAS Metadata Serverz/OS9.1 TS1M3 SP49.2 TS2M0
Microsoft® Windows® for 64-Bit Itanium-based Systems9.1 TS1M3 SP49.2 TS2M0
Microsoft Windows Server 2003 Datacenter 64-bit Edition9.1 TS1M3 SP49.2 TS2M0
Microsoft Windows Server 2003 Enterprise 64-bit Edition9.1 TS1M3 SP49.2 TS2M0
Microsoft Windows XP 64-bit Edition9.1 TS1M3 SP49.2 TS2M0
Microsoft® Windows® for x649.1 TS1M3 SP49.2 TS2M0
Microsoft Windows 2000 Advanced Server9.1 TS1M3 SP4
Microsoft Windows 2000 Datacenter Server9.1 TS1M3 SP4
Microsoft Windows 2000 Server9.1 TS1M3 SP4
Microsoft Windows 2000 Professional9.1 TS1M3 SP4
Microsoft Windows NT Workstation9.1 TS1M3 SP4
Microsoft Windows Server 2003 Datacenter Edition9.1 TS1M3 SP49.2 TS2M0
Microsoft Windows Server 2003 Enterprise Edition9.1 TS1M3 SP49.2 TS2M0
Microsoft Windows Server 2003 Standard Edition9.1 TS1M3 SP49.2 TS2M0
Microsoft Windows XP Professional9.1 TS1M3 SP49.2 TS2M0
64-bit Enabled AIX9.1 TS1M3 SP49.2 TS2M0
64-bit Enabled HP-UX9.1 TS1M3 SP49.2 TS2M0
64-bit Enabled Solaris9.1 TS1M3 SP49.2 TS2M0
HP-UX IPF9.1 TS1M3 SP49.2 TS2M0
Linux9.1 TS1M3 SP49.2 TS2M0
Linux on Itanium9.1 TS1M3 SP49.2 TS2M0
* 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.