IBM Support

JR33602: SYBASE ENTERPRISE STAGE INCORRECTLY PULLING TABLE SCHEMA BASED ON USERS DEFAULT DATABASE, NOT THE DATABASE BEING ACCESSED.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Sybase Enterprise stage incorrectly pulling table schema
    information based on users default database, not the database
    being accessed when the table in the query exists in both the
    users default database and another database.
    

Local fix

  • Use the Database Connection property to override the users
    default database.
    
    This fix is included in 8.0.1 fixpack 3
    

Problem summary

  • ****************************************************************
    USERS AFFECTED:
    All platforms , jobs using Sybase ASE EE Stage
    ****************************************************************
    PROBLEM DESCRIPTION:
    Sybase Enterprise Stage incorrectly pulling table schema based
    on users default database , not the database being accessed.
    
    ****************************************************************
    RECOMMENDATION:
    Install Patch for JR33602
    ****************************************************************
    

Problem conclusion

  • The Sybase ASE operator was trying to get table definition from
    system tables, but gets confused when same table name exists in
    two different databases.
    
    Removed the function that got table definition from system
    tables as new procedure to get the table definition is
    sufficient.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR33602

  • Reported component name

    WIS DATASTAGE

  • Reported component ID

    5724Q36DS

  • Reported release

    801

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-07-08

  • Closed date

    2009-07-14

  • Last modified date

    2010-12-09

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

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

Modules/Macros

  • SYBASE
    

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:
09 December 2010