IBM Support

JR33617: SQL SERVER WRAPPER CRASHES CONNECTING TO DATA SOURCE IF OPTION FOLD_ID='U' SET,OR FEDERATE DB CODEPAGE NOT SAME AS DATA SOURCE.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • SQL Server Wrapper crashes when connecting to remote data source
    if:
    - Federated SERVER object defined with FOLD_ID='U' option.
    - Federated database has different codepage with remote MS SQL
    Server.
    
    This crash is recorded as a "Signal 11, Address not mapped to
    object" in trap file.
    The top of calling stack is like:
    
    <StackTrace>
    -------Frame------ ------Function + Offset------
    0x09000000081065A0 connect__16Mssql_ConnectionFv + 0x960
    0x09000000024A0FB0
    connect__12FencedServerFP17FencedRemote_UserPP17Remote_Connectio
    n + 0x624
    0x09000000024A05C8
    connect_current_user__12FencedServerFPP17Remote_Connection +
    0x2B8
    0x090000000249F668 sqlqgConnect__FPUcPP17Remote_Connection +
    0x144
    0x090000000249CDCC sqlqg_FMP_FedStart__FP10SQLQG_F2PC + 0x1B0
    0x090000000249045C
    sqlqgRouter__FP17sqlqg_FMP_RequestPP15sqlqg_FMP_ReplyP10sqlri_uf
    ob + 0x260
    0x0900000002292A80
    sqlqg_Call_FMP_Thread__FP17sqlqg_FMP_RequestPP15sqlqg_FMP_Reply
    + 0x4BC
    0x0900000001162A34 sqlqgFedStart__FP14UnfencedServerc + 0x728
    

Local fix

  • None.
    Customer can use fenced wrapper instead of unfenced wrapper to
    reduce the possibility of the crash
    

Problem summary

  • Problem was first fixed in Version 9.1 FixPak 9 (s100326 ). This
    fix should be applied on the federation server.
    

Problem conclusion

  • Users affected:
       Users of the MS SQL Server wrapper in InfoSphere Federation
    Server
    Problem description and summary:
       See error description.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR33617

  • Reported component name

    MSSQL WRAPPER

  • Reported component ID

    5724N9705

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-07-08

  • Closed date

    2010-04-14

  • Last modified date

    2010-04-14

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    JR33674 JR33682

Fix information

  • Fixed component name

    MSSQL WRAPPER

  • Fixed component ID

    5724N9705

Applicable component levels

  • R910 PSN

       UP

  • R911 PSN

       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":"910","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
14 April 2010