IBM Support

JR37407: SQL1822N WITH MESSAGE 'INVALID CURSOR STATE' REPORTED BY MICROSOFT SQL SERVER WRAPPER

Fixes are available

DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

Subscribe

You can track all active APARs for this component.

 

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
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback