Problem Note 63468: Running a large Oracle SQL query causes SAS® Federation Server to stop responding with "General Error - invalid Exception"
 |  |  |  |  |
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:
T_PREPARE: Table Service: Function failed. Diagnostics: SQLState=HY000, NativeRC=80FFF99F, Text: General Error - invalid Exception.
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 | ||
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 |