Problem Note 64562: Cognos does not connect to SAS® Federation Server 4.2 via the provided ODBC driver and you see messages regarding error HY092
 |  |  |  |  |
A Cognos connection to SAS Federation Server 4.2 fails, and you see the following error messages in the log file created by Cognos:
ENTER: SQLGetInfo(ConnectionHandle = 0xc08110, info = SQL_OUTER_JOINS, Value=, BufferLength = 1028, StringLenPtr = 0)
EXIT: SQL_ERROR = SQLGetInfo(ConnectionHandle = 0xc08110, info = SQL_OUTER_JOINS, Value=, BufferLength = 1028, StringLenPtr = 0)
ENTER: SQLGetDiagRec(HandleType = SQL_HANDLE_DBC, Handle = 0xc08110, RecNumber = 1, SQLState = , NativeErrorPtr = 0, MessageText = , BufferLength = 512, TextLengthPtr = 0)
EXIT: SQL_SUCCESS = SQLGetDiagRec(HandleType = SQL_HANDLE_DBC, Handle = 0xc08110, RecNumber = 1, SQLState = HY092, NativeErrorPtr = -2130708341, MessageText = Invalid attribute/option identifier, BufferLength = 512, TextLengthPtr = 35)
This issue occurs under these conditions:
- You use the Open Database Connectivity (ODBC) Driver that is provided by the SAS® Federation Server client.
- The version number for the ODBC driver is 9403.100.22119.29796.
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 8 Enterprise 32-bit | 4.2 | 4.2 | 9.4 TS1M3 | |
| Microsoft Windows 8 Pro 32-bit | 4.2 | 4.2 | 9.4 TS1M3 | |||
| Microsoft Windows 8.1 Enterprise 32-bit | 4.2 | 4.2 | 9.4 TS1M3 | |||
| Microsoft Windows 8.1 Pro 32-bit | 4.2 | 4.2 | 9.4 TS1M3 | |||
| Microsoft® Windows® for x64 | 4.2 | 4.2 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| Linux for x64 | 4.2 | 4.2 | 9.4 TS1M3 | 9.4 TS1M3 | ||
A fix for this issue for SAS Drivers for Federation Server 4.2 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/Z51.html#64562
Cognos does not connect to SAS Federation Server via ODBC Driver version 9403.100.22119.29796. The Cognos log file shows issues with the SQLGetInfo function and SQL_OUTER_JOINS.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2019-09-13 08:31:31 |
| Date Created: | 2019-08-06 09:07:35 |