Problem Note 63231: Opening an Oracle table with the Federation Server engine causes SAS® Federation Server to fail with "ERROR: CLI cursor fetch error..."
 |  |  |  |  |
When you try to open an Oracle table from SAS® Enterprise Guide®, SAS Federation Server fails with the following message:
ERROR: CLI cursor fetch error: General Error - invalid Exception
This issue occurs when you have driver tracing on with the APPLEVEL=52 option.
To work around this problem, remove the APPLEVEL= option by completing the following steps:
- Go to the etc directory under the Federation Server configuration directory (it is similar to /config/Lev1/FederationServer/etc, depending on installation location and name).
- Edit the dfs_serv.xml file and remove the APPLEVEL=52 option. Here is an example:
<Option name="ObjectServerParms">SERVER='&cfg.fsid;' APPLEVEL=52</Option>
After you edit the file, it should look similar to the following:
<Option name="ObjectServerParms">SERVER='&cfg.fsid;'</Option>
- Check for any tktstrace.txt files and either remove or rename them:
find /opt/sas/. -name tktstrace.txt - Restart SAS Federation Server:
fsadmin restart
After you complete these steps, the issue should be resolved and you should no longer be getting a tktstrace.txt file.
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 | Microsoft® Windows® for x64 | 4.2 | 4.2 | 9.4 TS1M4 | 9.4 TS1M6 |
| 64-bit Enabled AIX | 4.2 | 4.2 | 9.4 TS1M4 | 9.4 TS1M6 | ||
| 64-bit Enabled Solaris | 4.2 | 4.2 | 9.4 TS1M4 | 9.4 TS1M6 | ||
| HP-UX IPF | 4.2 | 4.2 | 9.4 TS1M4 | 9.4 TS1M6 | ||
| Linux for x64 | 4.2 | 4.2 | 9.4 TS1M4 | 9.4 TS1M6 | ||
| Solaris for x64 | 4.2 | 4.2 | 9.4 TS1M4 | 9.4 TS1M6 | ||
A fix for this issue for SAS Federation Server 4.2 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/Y46.html#63231
SAS Federation Server fails when you try to open an Oracle table from SAS® Enterprise Guide® and the APPLEVEL=52 tracing option is on. In this scenario, "ERROR: CLI cursor fetch error: General Error - invalid Exception" occurs.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2018-11-29 14:35:31 |
| Date Created: | 2018-11-14 21:58:38 |