IBM Support

PI25606: MIX OF DOUBLE AND INTEGER VALUES IN CELLS THROWS ERROR RANG() AN#ERR! IN TM1 WEB 10.2.2

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

  • Error while displaying an Excel-Report in TM1 Web.
    ?The error is shown when the RANG() function is used and the
    input range contains a mix of integer and double value.
                       ?
                               ?If all the values are of the same
    type, everything is working fine but  ?if there is a mix of
    double and integer values TM1Web throws in the cells with the
    RANG() an #ERR! message.
           ?
                   ?Step to reproduce: ?1. Download the attached
    Excel and upload it to a TM1 application       ?folder.
                                                           ?2.
    Display the form in TM1 Web?
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Users                                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See error description.                                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to TM1 10.2 RP2 FP2                                  *
    ****************************************************************
    

Problem conclusion

  • Code Fix
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI25606

  • Reported component name

    TM1 WEB

  • Reported component ID

    5724W49WB

  • Reported release

    A22

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-09-12

  • Closed date

    2014-12-19

  • Last modified date

    2014-12-19

  • 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

    TM1 WEB

  • Fixed component ID

    5724W49WB

Applicable component levels

  • RA22 PSN

       UP



Document information

More support for: Cognos TM1
TM1 Web

Software version: 10.2.2

Reference #: PI25606

Modified date: 19 December 2014