Fixes are available
APAR status
Closed as program error.
Error description
You might receive the following error when querying from a Microsoft SQL Server wrapper nickname: SQL1822N Unexpected error code "24000" received from data source "DATASTORE2". Associated text and tokens are "Invalid cursor state". SQLSTATE=560BD The error entry in db2diag.log is like below: 2010-05-10-16.36.47.031388+120 I13496158A1181 LEVEL: Error PID : 700528 TID : 2315 PROC : db2sysc 0 INSTANCE: xxxxxxxx NODE : xxx DB : xxxxx APPHDL : xxxxx APPID: xxxxxxxx AUTHID : xxxxxxxx EDUID : xxxx EDUNAME: xxxxxxxxx FUNCTION: DB2 UDB, mssql wrapper, Mssql_Server::get_error_info, probe:7 MESSAGE : ODBC error txt: DATA #1 : Hexdump, 132 bytes 0x0000000110D292A0 : 5B49 424D 2844 6174 6144 6972 6563 7420 [IBM(DataDirect 0x0000000110D292B0 : 4F45 4D29 5D5B 4F44 4243 2053 514C 2053 OEM)][ODBC SQL S 0x0000000110D292C0 : 6572 7665 7220 4472 6976 6572 5D49 6E76 erver Driver]Inv 0x0000000110D292D0 : 616C 6964 2063 7572 736F 7220 7374 6174 alid cursor stat 0x0000000110D292E0 : 6500 0000 0000 0000 0000 0000 0000 0000 e...............
Local fix
NO
Problem summary
**************************************************************** * USERS AFFECTED: * * This problem raises up when customer's operation sequence * * implicitly includes two close cursor operations against same * * statement handle. * **************************************************************** * PROBLEM DESCRIPTION: * * When querying from remote data source through nickname, * * mssql wrapper would report below error: * * * * SQL1822N Unexpected error code "24000" received from data * * source * * "DATASTORE2". Associated text and tokens are "Invalid cursor * * state". * * SQLSTATE=560BD * * * * Mssql wrapper is failed to deal with sqlstate '24000' when * * it closes a cursor. * **************************************************************** * RECOMMENDATION: * * Upgrade to Infosphere Federation Server version 9.5 fixpack * * 7. * ****************************************************************
Problem conclusion
This problem has been fixed in Infosphere Federation Server version 9.5 fixpack 7. With this fix, customer won't see SQL1822N error with sqlstate "24000" again.
Temporary fix
Comments
APAR Information
APAR number
JR37407
Reported component name
MSSQL WRAPPER
Reported component ID
5724N9705
Reported release
950
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-08-03
Closed date
2011-01-11
Last modified date
2011-01-11
APAR is sysrouted FROM one or more of the following:
JR37391
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
MSSQL WRAPPER
Fixed component ID
5724N9705
Applicable component levels
R950 PSN
UP
R950 PSY
UP
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCAVPL","label":"Data Sources and Wrappers - Microsoft SQL Server"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"950","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
11 January 2011