IBM Support

IT26607: INSERT ALL FAILS WITH AN "ORA-00903 INVALID TABLE NAME" TO AN ORACLE DATABASE.

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

  • When calling "INSERT ALL" to insert multiple rows to an Oracle
    database an error is returned and the rows are not inserted.
    

Local fix

Problem summary

  • ****************************************************************
    USERS AFFECTED:
    All users of IBM App Connect Enterprise v11 and IBM Integration
    Bus V10 who use the DataDirect Oracle ODBC driver.
    
    
    Platforms affected:
    AIX, HP-UX Itanium platform, Linux on Power platform, Linux on
    x86 platform, Linux on x86-64 platform, Linux on zSeries
    platform, Solaris x86-64 platform, Solaris SPARC platform,
    Windows on x86 platform, Windows on x86-64 platform
    
    ****************************************************************
    PROBLEM DESCRIPTION:
    After upgrading to IIB V10 FP07 or later, "INSERT ALL" calls to
    an Oracle database fail with "ORA-00903 INVALID TABLE NAME".
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    IT26607

  • Reported component name

    INTEGRATION BUS

  • Reported component ID

    5724J0540

  • Reported release

    A00

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-10-25

  • Closed date

    2019-02-12

  • Last modified date

    2019-02-12

  • 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

    INTEGRATION BUS

  • Fixed component ID

    5724J0540

Applicable component levels

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSNQK6","label":"IBM Integration Bus"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.0","Edition":"","Line of Business":{"code":"LOB36","label":"IBM Automation"}}]

Document Information

Modified date:
12 February 2019