IBM Support

JR26981: ORACLE WRAPPER ON UNICODE FEDERATED SERVER DOES NOT RETURN CORRECT REQUIRED LENGTH WHEN CONVERTING STRING CONSTANT.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • SQL0901 returned in Oracle wrapper on unicode federated server.
    Query does not return correct required length when converting
    string constant.
     Error text:
    SQL0901N The SQL statement failed because of a non-severe system
    error. Subsequent SQL statements can be processed. (Reason
    "sqlnt_add_constant        ■150:rc(     0)                ")
    SQLSTATE=58004
    

Local fix

Problem summary

  • Users affected: all
    
    Problem description and summary:
    The recreate script is:
    
    CREATE DB test USING codeset IBM-943 territory JP;
    CONNECT TO test;
    CREATE WRAPPER net8;
    CREATE SERVER ora TYPE oracle VERSION 9 WRAPPER net8 options (
          NODE 'ORA9I.SEEL',
          COLLATING_SEQUENCE 'Y',
          DB2_MAXIMAL_PUSHDOWN 'Y',
          DB2_MAX_SEL_SIZE '32000',
          PLAN_HINTS 'N',
          VARCHAR_NO_TRAILING_BLANKS 'Y');
    CREATE USER MAPPING FOR USER SERVER ora OPTIONS
       (REMOTE_AUTHID 'xxxxxxxx', REMOTE_PASSWORD 'xxxxxxxx');
    SET PASSTHRU ora;
    CREATE TABLE c_sample
       (smplcomm VARCHAR2(500));
    INSERT INTO c_sample(SMPLCOMM) VALUES('ID1234567890');
    SET PASSTHRU reset;
    CREATE NICKNAME c_sample FOR ora.xxxxxxxx.c_sample;
    SELECT * FROM c_sample WHERE smplcomm LIKE 'ID%' ;
    
    The error message is:
    SQL0901N The SQL statement failed because of a non-severe system
    error.
    Subsequent SQL statements can be processed.
    (Reason "sqlnn_tra_1st_err: the tra stack is empty!")
    SQLSTATE=58004
    

Problem conclusion

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

Temporary fix

Comments

APAR Information

  • APAR number

    JR26981

  • Reported component name

    ODBC WRAPPER

  • Reported component ID

    5724N9707

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2007-06-27

  • Closed date

    2008-02-05

  • Last modified date

    2008-02-05

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

    IY96692

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

Fix information

  • Fixed component name

    ODBC WRAPPER

  • Fixed component ID

    5724N9707

Applicable component levels

  • R910 PSN

       UP

  • R911 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCAVPM","label":"Data Sources and Wrappers - ODBC"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"910","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
05 February 2008