IBM Support

PM39893: WHEN USING LARGE NUMBERS DEFINED AS DECIMAL, DATA WILL BE TRUNCATE THE LAST DIGIT WILL BE PAD WITH 0

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When using large numbers defined on the database as decimal (
    number for Oracle ), data will be truncated and the last digit
    and will be padded with 0.????Note that the number could be
    entirely displayed on CRN.????The issue was reproduced using
    Cognos 8.4.1 and Oracle 10G but the same takes place if SQL
    Server ior Oracle 9 is used.????The original issue was reported
    by a customer using Oracle 9i.??
    

Local fix

  • Where possible CAST() the large number items already in Framewor
    k Manager.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Users                                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See error description.                                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Cognos BI Server 10.2                             *
    ****************************************************************
    

Problem conclusion

  • Code Fix
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM39893

  • Reported component name

    COG8 BI COG CON

  • Reported component ID

    5724W12CC

  • Reported release

    841

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-05-24

  • Closed date

    2012-09-11

  • Last modified date

    2012-09-11

  • 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

    COG8 BI COG CON

  • Fixed component ID

    5724W12CC

Applicable component levels

  • RA20 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCHNWN","label":"Portal v11x"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"841","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
11 September 2012