60086 - "ERROR: An exception has been encountered" occurs when registering a table in a concatenated library that contains a SAS® metadata-bound library

Problem Note 60086: "ERROR: An exception has been encountered" occurs when registering a table in a concatenated library that contains a SAS® metadata-bound library

When trying to register a table in a concatenated library containing a SAS metadata-bound library, you might see the following errors:

Here is the error that you are likely to encounter under UNIX:

ERROR:  An exception has been encountered.

Please contact technical support and provide them with the following traceback

information:

The SAS task name is [SQL (2) ]

Segmentation Violation

Traceback of the Exception:

_ptrgl+0x4

yoopen+0x250

xoopen+0x38 -- bridge stub

sel_open+0x2b0

sel_columns+0xf0

sqxsob_get_next+0xc4

sqxcrta_get_next+0x104

sqxcrta_open+0x46c

sqxcrta_init+0x218

sqxexec+0x72c

process_sql+0x554

sqlloop+0x1e0

sqlloop+0x38 -- bridge stub

sassql+0x188

vvtentr+0x194

_pthread_body+0xf0

Here is the error that you are likely to encounter under Windows:

ERROR:  An exception has been encountered.

Please contact technical support and provide them with the following traceback

information:

The SAS task name is [SQL]

ERROR:  Write Access Violation SQL

Exception occurred at (00000000)

Task Traceback

Address   Frame     (DBGHELP API Version 4.0 rev 5)

Click the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

Product Family	Product	System	Product Release		SAS Release
Product Family	Product	System	Reported	Fixed*	Reported	Fixed*
SAS System	Base SAS	Microsoft® Windows® for x64	9.4_M3	9.4_M5	9.4 TS1M3	9.4 TS1M5
		Microsoft Windows 8 Enterprise 32-bit	9.4_M3	9.4_M5	9.4 TS1M3	9.4 TS1M5
		Microsoft Windows 8 Enterprise x64	9.4_M3	9.4_M5	9.4 TS1M3	9.4 TS1M5
		Microsoft Windows 8 Pro 32-bit	9.4_M3	9.4_M5	9.4 TS1M3	9.4 TS1M5
		Microsoft Windows 8 Pro x64	9.4_M3	9.4_M5	9.4 TS1M3	9.4 TS1M5
		Microsoft Windows 8.1 Enterprise 32-bit	9.4_M3	9.4_M5	9.4 TS1M3	9.4 TS1M5
		Microsoft Windows 8.1 Enterprise x64	9.4_M3	9.4_M5	9.4 TS1M3	9.4 TS1M5
		Microsoft Windows 8.1 Pro 32-bit	9.4_M3	9.4_M5	9.4 TS1M3	9.4 TS1M5
		Microsoft Windows 8.1 Pro x64	9.4_M3	9.4_M5	9.4 TS1M3	9.4 TS1M5
		Microsoft Windows 10	9.4_M3	9.4_M5	9.4 TS1M3	9.4 TS1M5
		Microsoft Windows Server 2008	9.4_M3		9.4 TS1M3
		Microsoft Windows Server 2008 R2	9.4_M3		9.4 TS1M3
		Microsoft Windows Server 2008 for x64	9.4_M3		9.4 TS1M3
		Microsoft Windows Server 2012 Datacenter	9.4_M3	9.4_M5	9.4 TS1M3	9.4 TS1M5
		Microsoft Windows Server 2012 R2 Datacenter	9.4_M3	9.4_M5	9.4 TS1M3	9.4 TS1M5
		Microsoft Windows Server 2012 R2 Std	9.4_M3	9.4_M5	9.4 TS1M3	9.4 TS1M5
		Microsoft Windows Server 2012 Std	9.4_M3	9.4_M5	9.4 TS1M3	9.4 TS1M5
		Windows 7 Enterprise 32 bit	9.4_M3	9.4_M5	9.4 TS1M3	9.4 TS1M5
		Windows 7 Enterprise x64	9.4_M3	9.4_M5	9.4 TS1M3	9.4 TS1M5
		Windows 7 Home Premium 32 bit	9.4_M3	9.4_M5	9.4 TS1M3	9.4 TS1M5
		Windows 7 Home Premium x64	9.4_M3	9.4_M5	9.4 TS1M3	9.4 TS1M5
		Windows 7 Professional 32 bit	9.4_M3	9.4_M5	9.4 TS1M3	9.4 TS1M5
		Windows 7 Professional x64	9.4_M3	9.4_M5	9.4 TS1M3	9.4 TS1M5
		Windows 7 Ultimate 32 bit	9.4_M3	9.4_M5	9.4 TS1M3	9.4 TS1M5
		Windows 7 Ultimate x64	9.4_M3	9.4_M5	9.4 TS1M3	9.4 TS1M5
		64-bit Enabled AIX	9.4_M3	9.4_M5	9.4 TS1M3	9.4 TS1M5
		64-bit Enabled Solaris	9.4_M3	9.4_M5	9.4 TS1M3	9.4 TS1M5
		HP-UX IPF	9.4_M3	9.4_M5	9.4 TS1M3	9.4 TS1M5
		Linux for x64	9.4_M3	9.4_M5	9.4 TS1M3	9.4 TS1M5
		Solaris for x64	9.4_M3	9.4_M5	9.4 TS1M3	9.4 TS1M5

* 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:	medium

Date Modified:	2017-03-24 09:46:44
Date Created:	2017-03-03 15:58:04

Support

Problem Note 60086: "ERROR: An exception has been encountered" occurs when registering a table in a concatenated library that contains a SAS® metadata-bound library

Operating System and Release Information