Planning Analytics

Planning Analytics

Get AI-infused integrated business planning

 View Only
  • 1.  2.0.9.16 ROUNDP issue

    Posted Fri April 21, 2023 12:10 AM

    We are in the middle of changing our support arrangements so raising a support ticket is problematic at the moment. The rule in question involves a calculation nested within the ROUNDP function. It should be easy to reproduce. 

    TM1 Forum

    Tm1forum remove preview
    TM1 Forum
    FYI to anyone moving to 2.0.9.16 and using ROUNDDP with negative parameters. We have just upgraded to 2.0.9.16 (Only to address vulnerability: https://www.ibm.com/support/pages/node/6856457) a few days ago and have found that our use of ROUNDP is no longer working.
    View this on Tm1forum >


    ------------------------------
    John O'Leary
    ------------------------------


  • 2.  RE: 2.0.9.16 ROUNDP issue

    Posted Mon April 24, 2023 08:52 AM

    Hi John, are you implying that 2.0.9.16 still has this issue? 2.0.9.15IF2 had it, as it contained the initial fix for a ROUNDP related issue which resulted in this new issue, described in the referenced APAR in the TM1 Forum item, with negative 'decimal' parameter. This issue has since been fixed (actually I made the fix on Jan 26th) so I'd be surprised if that missed the 2.0.9.16 (as AFAIK that contains the 11.8.19 version of TM1 server - you can quickly check by looking at the version information of the tm1s[d].exe or tm1server.dll files, it'll appear as 11.8.01900.11 presumably).



    ------------------------------
    Hubert Heijkers
    STSM, Program Director TM1 Functional Database Technology and OData Evangelist
    ------------------------------



  • 3.  RE: 2.0.9.16 ROUNDP issue

    Posted Mon April 24, 2023 01:32 PM

    Hubert,

    11.8.01900.11 must be an interim fix after 2.0.9.16 was released. I have 11.8.01900.10 for my 2.0.9.16 install. I wish Interim Fixes were on Fix Central.

    The 2.0.9.16 that was available 2/28 that I downloaded on 2/28, contains tm1server-winx64h-app-11.8.01900.10-inst.tar.gz dated for 1/26/2023, so it probably doesn't have your fix made the same day. :-(



    ------------------------------
    Walter Coffen
    Technology Manager
    QueBIT Consulting, LLC
    ------------------------------



  • 4.  RE: 2.0.9.16 ROUNDP issue

    Posted Mon April 24, 2023 05:05 PM

    Thanks Hubert

    11.8.01900.10 is what we have. Our IBM Partner provided a download link to us for this in mid March. We don't have direct access to IBM downloads as our support is currently through the partner.

    If there is an available fix pack that addresses this issue that would be great, can you confirm?

    John



    ------------------------------
    John O'Leary
    ------------------------------



  • 5.  RE: 2.0.9.16 ROUNDP issue

    Posted Mon April 24, 2023 06:12 PM

    Apologies for the confusion, there must be a breakdown in the system somewhere, 11 shouldn't have existed if 10 is in that release, but that aside, I checked, that fix is in 11.8.01900.10 as well! 

    So I had another peek at the code and verified that the case provided was fixed with that fix so decided to throw some arbitrary big and small numbers with many or few digits at it to find out that there is still an issue if the value is smaller then 0.07-ish. I've reopened the issue and will take another look.



    ------------------------------
    Hubert Heijkers
    STSM, Program Director TM1 Functional Database Technology and OData Evangelist
    ------------------------------



  • 6.  RE: 2.0.9.16 ROUNDP issue

    Posted Tue April 25, 2023 06:42 PM

    Thanks Hubert

    To be clear, this is a new issue for us so it's a regression issue. The function was working as we expected in 2.0.6 and we then upgraded to 2.0.9.14 and 2.0.9.15 (tm1_winx64h_2.0.915.13_ml.tar.gz) without problems. Only when we upgraded to 2.0.9.16 have we encountered this issue.

    John



    ------------------------------
    John O'Leary
    ------------------------------



  • 7.  RE: 2.0.9.16 ROUNDP issue

    Posted Tue April 25, 2023 11:50 PM

    Understood John, absolutely!

    In the meantime I've fixed it (for good;-) and we are making sure this fix goes into TM1 Server 11.8.20 which is the version that ought to be picked up by PA 2.0.9.17.

    Apologize for the inconvenience,



    ------------------------------
    Hubert Heijkers
    STSM, Program Director TM1 Functional Database Technology and OData Evangelist
    ------------------------------



  • 8.  RE: 2.0.9.16 ROUNDP issue

    Posted Wed April 26, 2023 12:17 AM

    Thank you!



    ------------------------------
    John O'Leary
    ------------------------------