Problem Note 67734: Unexpected behavior occurs when you execute the ROLLBACK statement from the SPDS library using the FEDSVR engine
 |  |  |  |  |
Unexpected behavior occurs when you disconnect from the SPDS library using the FEDSVR engine. You encounter this issue when you run code similar to the following:
Note: The code should contain your connection information for HOST=, SERV=, DBQ=, SCHEMA=, and UID=.
proc sql noerrorstop;
connect to sasts(CONNECT_STRING="DRIVER=TSSQL;CONOPTS=(DRIVER=SPDS;DBQ=dbq-name;LOCALE=en_us;HOST=host-name;SCHEMA=
(NAME=schema-name;DBQ=dbq-name;);SERV=serv-name;UID=uid-name;CATALOG=CATALOG_SPDS;)" autocommit=yes);
execute( create table duopts01(a INTEGER not null primary key, X CHAR(10), Y INTEGER NOT NULL ) )
by sasts;
execute( insert into duopts01 values(1, 'SunnyDay', 20 ) ) by sasts;
execute( insert into duopts01 values(2, 'TGIFriday', 0 ) ) by sasts;
execute( ROLLBACK ) by sasts;
title 'sunnyday/tgifriday';
select * from connection to sasts (select * from duopts01 order by a);
disconnect from sasts;
quit;
connect to sasts(CONNECT_STRING="DRIVER=TSSQL;CONOPTS=(DRIVER=SPDS;DBQ=dbq-name;LOCALE=en_us;HOST=host-name;SCHEMA=
(NAME=schema-name;DBQ=dbq-name;);SERV=serv-name;UID=uid-name;CATALOG=CATALOG_SPDS;)" autocommit=yes);
execute( create table duopts01(a INTEGER not null primary key, X CHAR(10), Y INTEGER NOT NULL ) )
by sasts;
execute( insert into duopts01 values(1, 'SunnyDay', 20 ) ) by sasts;
execute( insert into duopts01 values(2, 'TGIFriday', 0 ) ) by sasts;
execute( ROLLBACK ) by sasts;
title 'sunnyday/tgifriday';
select * from connection to sasts (select * from duopts01 order by a);
disconnect from sasts;
quit;
When you run code similar to this, you might encounter any of the following types of errors:
- Your system could stop responding and return the following: "Exception Handler ERROR: CLI execute error: Driver does not support this function"
- You might see the following: "ERROR: CLI execute error: Unable to retrieve error message"
- Or, you might see the following: "ERROR: CLI execute error: General Error"
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.4 | 9.4 TS1M6 | 9.4 TS1M7 |
| 64-bit Enabled AIX | 4.2 | 4.4 | 9.4 TS1M6 | 9.4 TS1M7 | ||
| 64-bit Enabled Solaris | 4.2 | 4.4 | 9.4 TS1M6 | 9.4 TS1M7 | ||
| HP-UX IPF | 4.2 | 4.4 | 9.4 TS1M6 | 9.4 TS1M7 | ||
| Linux for x64 | 4.2 | 4.4 | 9.4 TS1M6 | 9.4 TS1M7 | ||
| Solaris for x64 | 4.2 | 4.4 | 9.4 TS1M6 | 9.4 TS1M7 | ||
A fix for this issue for SAS Threaded Kernel Extensions for FedSQL and DS2 Standalone 9.4_M7 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/J1F.html#67734A fix for this issue for SAS Threaded Kernel Extensions for FedSQL and DS2 Standalone 9.4_M6 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/E5Q.html#67734| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2021-04-09 09:38:08 |
| Date Created: | 2021-04-07 10:41:51 |