IBM Support

JR29782: WE ARE EXPERIENCING A BUG WITH THE ODBC STAGE.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • We are experiencing a bug with the odbc stage. We have a case
    where the
    odbc operator is issuing this fatal error:
    
    [DataDirect][ODBC DB2 Wire Protocol driver][UDB DB2 for Windows,
    UNIX,
    and Linux]ILLEGAL SYMBOL (; VALID SYMBOLS ARE O
    MDM8MCA1.BLUMCA01..
    <identifier> [odbcUtils.C:1289]
    
    The problem turned out to be an incorrectly populated table name
    in the
    job parameters. However, the job completed successfully.
    
    This message should either be reduced to a warning, or the job
    should abort. I have noticed this on numerous occasions with the
    ODBC stage, with a variety of messages.
    
    Running DataaStage version 8.  Have requested further
    information from IBM'er about OS & patch/FP installed.
    

Local fix

Problem summary

  • ****************************************************************
    USERS AFFECTED:
    ALL
    ****************************************************************
    PROBLEM DESCRIPTION:
    ODBC Upsert operator returns Status Ok even when Fatal Errors
    are logged in the Director
    ****************************************************************
    RECOMMENDATION:
    Planned for 8.0.1 Fix Pack2
    ****************************************************************
    

Problem conclusion

  • Re-implemented the Fatal Error determination for ODBC Upsert
    

Temporary fix

Comments

  • This change is included in 8.0.1 Fix Pack 2.
    

APAR Information

  • APAR number

    JR29782

  • Reported component name

    WIS DATASTAGE

  • Reported component ID

    5724Q36DS

  • Reported release

    801

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-07-01

  • Closed date

    2008-08-07

  • Last modified date

    2009-06-29

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

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

Modules/Macros

  • SERVER
    

Fix information

  • Fixed component name

    WIS DATASTAGE

  • Fixed component ID

    5724Q36DS

Applicable component levels

  • R801 PSN

       UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.0.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
29 June 2009