IBM Support

JR34217: USERNAME LOST DURING RUNTIME WHEN USING INFORMIX EE STAGE IN IS 8.1

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When using Informix EE stage in IS 8.1 for new created jobs, job
    failed with error even the username and password are entered
    correctly in design time.
    
    ======
    An Informix call failed: sqlcode = -951, sqlstate = IX000
    message: Incorrect password or user dsadm@10.112.15.63 is not
    known on the database server.
    . [infxutils.C:2034]
    ======
    

Local fix

  • Set "Remote server" to "False", and set it back to "True",
    recompiled the job.
    

Problem summary

  • ****************************************************************
    USERS AFFECTED:
    Those customers using the Informix EE stage in parallel jobs
    ****************************************************************
    PROBLEM DESCRIPTION:
    On initially creating an Informix EE stage on the canvas,
    filling in properties including setting Remote Server to Yes,
    and then setting a user name and password, then compiling
    results in the user name and password not being compiled
    correctly
    ****************************************************************
    RECOMMENDATION:
    Install patch_JR34217_client_windows_8100 or use workaround
    described below
    ****************************************************************
    

Problem conclusion

  • This was an issue with how the stage was initialized. Closing,
    re-opening the job and re-compiling would cause the stage to fix
    itself. This issue has been fixed and a patch made available
    

Temporary fix

  • Close, re-open job and re-compile
    

Comments

APAR Information

  • APAR number

    JR34217

  • Reported component name

    WIS DATASTAGE

  • Reported component ID

    5724Q36DS

  • Reported release

    810

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-09-08

  • Closed date

    2009-12-07

  • Last modified date

    2009-12-07

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

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

Modules/Macros

  • CLIENT
    

Fix information

  • Fixed component name

    WIS DATASTAGE

  • Fixed component ID

    5724Q36DS

Applicable component levels

  • R810 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.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
07 December 2009