IBM Support

PK99650: Framework Manager changes existing Query Item Data Types from Int64 to Float64 when metadata is re-imported

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • Framework Manager will change the data type of a Query Item that
    was previously imported into a Model, when that Metadata is
    re-imported at a later time.????? ???????? ???????? When an
    Oracle database column was originally imported it       created
    a Query Item with the Data Type Int64. When?        that Query
    Item is re-imported, that Query Item data Type is     changed to
    Float64.?????? ???????       This occurs with Oracle Columns
    that were created with the      ALTERTABLE SQL statement to add
    a column specifying default and not  null:??????? ????????
    Example:??????        ALTER TABLE <table_name>????? ADD
    (<column_name> number(10) default 0 not null);?? ???????    If
    these Query Items are imported into existing Query Subject,
    Framework manager assigns Float64 data type.??? ???????       If
    corresponding columns were created with CREATE TABLE
    statement, Framework manager assigns Int64 data type and do not
    change it anymore.
    

Local fix

  • Alternative solution: use CAST function to change Float64 to
    Int64
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Users                                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See error description.                                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to IBM Cognos Business Intelligence 10.2 Refresh     *
    * Pack 1                                                       *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PK99650

  • Reported component name

    COG BI FRAMEWK

  • Reported component ID

    5724W12FM

  • Reported release

    840

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-10-27

  • Closed date

    2013-06-11

  • Last modified date

    2013-06-11

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

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

Fix information

Applicable component levels

  • RA21 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCHNWR","label":"Framework and Map Manager v11x"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"840","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
11 June 2013