SAS Federation Server Manager becomes unresponsive under the following conditions:

• You connect to an Oracle database from SAS Federation Server Manager.
• You run an SQL query that is longer than 30,000 characters.

In this scenario, the SAS Federation Server log shows the following error in the log:

In order to recover from this state, you must stop and then restart the SAS Federation Server service.

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
			Reported	Fixed*	Reported	Fixed*
SAS System	SAS Federation Server	Solaris for x64	4.2	4.2	9.4 TS1M3	9.4 TS1M5
		Linux for x64	4.2	4.2	9.4 TS1M3	9.4 TS1M5
		64-bit Enabled Solaris	4.2	4.2	9.4 TS1M3	9.4 TS1M5
		Microsoft Windows Server 2012 R2 Std	4.2	4.2	9.4 TS1M3	9.4 TS1M5
		Microsoft Windows Server 2008 for x64	4.2	4.2	9.4 TS1M3	9.4 TS1M5
		Microsoft Windows 8.1 Pro x64	4.2	4.2	9.4 TS1M3	9.4 TS1M5
		Microsoft Windows 8.1 Enterprise x64	4.2	4.2	9.4 TS1M3	9.4 TS1M5
		Microsoft Windows 8 Pro x64	4.2	4.2	9.4 TS1M3	9.4 TS1M5
		Microsoft Windows 8 Enterprise x64	4.2	4.2	9.4 TS1M3	9.4 TS1M5
		Microsoft® Windows® for x64	4.2	4.2	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.

---

A fix for this issue for SAS Federation Server 4.2 is available at:

https://tshf.sas.com/techsup/download/hotfix/HF2/Y46.html#63468

---

Running a large Oracle SQL query stops the SAS Federation Server process with this error in the log: "T_PREPARE: Table Service: Function failed. Diagnostics: SQLState=HY000, NativeRC=80FFF99F, Text: General Error- invalid Exception." To recover, you must stop and restart SAS Federation Server.

Type:	Problem Note
Priority:	high
Topic:	Data Management ==> Data Sources ==> External Databases ==> Oracle

Date Modified:	2019-01-17 09:00:21
Date Created:	2019-01-10 11:11:10