IBM Support

JR33655: FAULT OCCURRED IN BASIC PROGRAM DSP.OPEN AT ADDRESS 574 USING ORACLE OCI AND SYBASE OC STAGES WITH NLS ON

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Fault occurred in BASIC program DSP.Open at address 574 was the
    original error message reported.  This happened in some jobs
    that were exported from 7.5.2 to 8.1 and that worked in 7.5.2.
    
    The 8.1 installation also has NLS installed whereas 7.5.2 did
    not.
    
    From the CRM for this issue:
    
    "The problem occurs when the Table Name field is left blank for
    User defined SQL. In this case, if NLS is turned on, since the
    size of the tablename has not been initialised to 0, memcpy for
    a huge number is attempted. This causes the memcpy to fail."
    

Local fix

  • apply patch e130672 for the Oracle issue
    apply patch JR33417 for the Sybase issue
    set env var DS_NO_PROCESS_METADATA=1
    

Problem summary

  • ****************************************************************
    USERS AFFECTED:
    All platforms, jobs using SybaseOC with NLS
    ****************************************************************
    PROBLEM DESCRIPTION:
    SybaseOC fails with sigsegv trying to get process metadata when
    NLS is ON
    ****************************************************************
    RECOMMENDATION:
    Install patch for JR33655
    The fix has been included in the IS 8.1 FP1. Apply the FixPack1
    for IS 8.1.
    ****************************************************************
    

Problem conclusion

  • SybaseOC was failing with sigsegv when trying to get process
    metadata if the tablename field was left blank for user defined
    SQL.
    
    Modified code to initialise tablename size to 0, so that if
    tablename field is blank, we do not attempt memcpy.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR33655

  • Reported component name

    WIS DATASTAGE

  • Reported component ID

    5724Q36DS

  • Reported release

    753

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-07-10

  • Closed date

    2009-07-20

  • Last modified date

    2009-12-19

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

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

Modules/Macros

  • SYBASEOC
    

Fix information

  • Fixed component name

    WIS DATASTAGE

  • Fixed component ID

    5724Q36DS

Applicable component levels

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

Document Information

Modified date:
19 December 2009