IBM Support

JR36720: INFORMATION SERVER 8.1 - JOB WITH ORACLE OCI STAGE FAILS.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Information Server 8.1 - job with Oracle OCI stage fails.
    
    Error message in log:
    
    SP_Data_Loader..SP_INDEX_DAILY: Insert rows must be the update
    action to clear the table
    

Local fix

Problem summary

  • ****************************************************************
    USERS AFFECTED:
    Undetermined random occurrence with Oracle OCI stage when using
    user-provided SQL
    ****************************************************************
    PROBLEM DESCRIPTION:
    Job aborts with error "Insert rows must be the update action to
    clear the table"
    ****************************************************************
    RECOMMENDATION:
    Apply patch
    ****************************************************************
    

Problem conclusion

  • Uninitialized variables (programming error) may randomly take on
    the values corresponding to the error condition (namely update
    action other than insert rows and clear table property set).
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR36720

  • Reported component name

    WIS DATASTAGE

  • Reported component ID

    5724Q36DS

  • Reported release

    810

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-05-28

  • Closed date

    2010-06-07

  • Last modified date

    2010-06-07

  • 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

  • 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 June 2010