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
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 |
*
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.
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 |