IZ49784: TABLES THAT INVOLVE A COLUMN WITH THE DATA TYPE OF CLOB

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Problem description
    In Maximo 6.2.3, there is a defect concerning the creation of
    IFACE
    tables that involve a column with the data type of CLOB that is
    NOT a
    long description.  The WriteToTable.class checks for the CLOB
    datatype
    and, if it exist, attempts to write to a column name of
    [attributename
    +  2 ].  In the CreateTable.class, this column is ONLY created
    if the
    attribute name ends in  LongDescription .  For an attribute that
    is a
    CLOB, but does not end in  LongDescription , this result in an
    error
     Invalid Identifier  being thrown.
    The mis-match between the CreateTable.class and the
    WriteToTable.class
    needs to be resolved.
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Customer using Oracle Interface tables in    *
    *                 Rel 6.x                                      *
    ****************************************************************
    * PROBLEM DESCRIPTION: In Maximo 6.2.3, there is a defect      *
    *                      concerning the creation of IFACE tables *
    *                      that involve a column with the data     *
    *                      type of CLOB that is NOT a long         *
    *                      description.  The WriteToTable.class    *
    *                      checks for the CLOB                     *
    *                                                              *
    *                      datatype and, if it exist, attempts to  *
    *                      write to a column name of attributename *
    *                      +  2  .  In the CreateTable.class, this *
    *                      column is ONLY created if the attribute *
    *                      name ends in  LongDescription .  For an *
    *                      attribute that is a CLOB, but does not  *
    *                      end in   LongDescription , this result  *
    *                      in an error Invalid Identifier  being   *
    *                      thrown. The mis-match between the       *
    *                      CreateTable.class and the               *
    *                                                              *
    *                      WriteToTable.class needs to be          *
    *                      resolved.                               *
    *                                                              *
    ****************************************************************
    * RECOMMENDATION:                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    ****************************************************************
    Creation of InterFace tables that involve a column with the
    data type of CLOB that is NOT a Long Description.
    

Problem conclusion

  • This APAR has been resolved by supporting the creation of
    InterFace tables that involve a column with the data type of
    CLOB that is NOT a Long Description.
    
    
    
    
    
    The fix for this APAR is contained in the following maintenance
    package:
    
      | release\fix pack | REL 6.2.5
    

Temporary fix

Comments

APAR Information

  • APAR number

    IZ49784

  • Reported component name

    MEA GENERIC

  • Reported component ID

    5724R46EA

  • Reported release

    621

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-04-22

  • Closed date

    2009-05-01

  • Last modified date

    2009-05-01

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

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

Modules/Macros

  • MAXIMO
    

Fix information

  • Fixed component name

    MEA GENERIC

  • Fixed component ID

    5724R46EA

Applicable component levels

  • R621 PSY

       UP



Rate this page:

(0 users)Average rating

Document information


More support for:

IBM Maximo Asset Management
MEA: Generic

Software version:

621

Reference #:

IZ49784

Modified date:

2009-05-01

Translate my page

Machine Translation

Content navigation