IBM Support

JR58059: ODBC CC JOB FAILS IF USERNAME AND PASSWORD PROPERTIES ARE EMPTY BUT CONNECTIONSTRING CONTAINS "DSN=" STRING.

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • ODBC CC job fails if ConenctionString contains explicit
    information about DSN and Database without username and
    password properties having values.
    

Local fix

Problem summary

  • ****************************************************************
    USERS AFFECTED:
    ODBC Connector Users
    ****************************************************************
    PROBLEM DESCRIPTION:
    ODBC CC job fails if Username and Password properties are empty
    but ConnectionString contains "DSN=" string. The job aborts with
    "Parallel job reports failure (code 139)"
    ****************************************************************
    RECOMMENDATION:
    Apply Patch JR58059
    ****************************************************************
    

Problem conclusion

  • As the Username and password properties don't have a value given
     by  the user they are considered to be  null  and accessing
    those null values caused the issue. So, made changes in the code
     to check for null condition before using username or password
    properties values.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR58059

  • Reported component name

    INFO SRVR PLATF

  • Reported component ID

    5724Q3612

  • Reported release

    B50

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-06-19

  • Closed date

    2017-08-16

  • Last modified date

    2017-08-16

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

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

Fix information

  • Fixed component name

    INFO SRVR PLATF

  • Fixed component ID

    5724Q3612

Applicable component levels

  • RB50 PSY

       UP

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

Document Information

Modified date:
16 August 2017