Fix Pack Releases: PA2 / V11 Series

User avatar
Alan Kirk
Site Admin
Posts: 6459
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.6 Classic(PAW-free zone)
Excel Version: 2010 and Office 365
Location: Sydney, Australia
Contact:

Re: Fix Pack Releases: PA2 / V11 Series

Post by Alan Kirk » Tue Mar 16, 2021 10:33 pm

It looks like I haven't been receiving some of the release updates. Maybe IBM just doesn't like me, though I can't imagine why that might be.

In any case I got the one for the newly released 2.0.6, and have updated the master post with all of the missing releases.

PAL 2.0.9.6 (16 Mar 2021)
Release Page.
Key Fixes
The fix list seems to consist of things that are (for the most part) more annoying than critical. For example disconnection issues with multiple instances of Excel (which I've always regarded as a "don't do that" situation), the password in TM1Web can be shorter than the one specified in the server config file, Cube Viewer showing a different number precision for a consolidation than you'd see in a slice. There are of course fixes for some issues that can cause a server crash, like when alternative leaf hierarchies were being deleted. The most critical is that single line feeders were only feeding the first element, not the subsequent ones.
New Features
Niente, nada, not a thing.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.

User avatar
Alan Kirk
Site Admin
Posts: 6459
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.6 Classic(PAW-free zone)
Excel Version: 2010 and Office 365
Location: Sydney, Australia
Contact:

Re: Fix Pack Releases: PA2 / V11 Series

Post by Alan Kirk » Sun Apr 18, 2021 10:41 pm

Version 2.0.9.7 is now out.

PAL 2.0.9.7 (16 Apr 2021)
Release Page.

Key Fixes
The fix list consists of a mere 7 items which would be great if there were only 7 bugs, but I think we know that to be unlikely. Almost half of them relate to hierarchy issues:
  • Planning Analytics Workspace: rule values other then zero are shown as zero on n-level when hierarchies are involved;
  • Error using DimensionElementComponentAdd() when the element name exists in a hierarchy created on the same dimension;
  • Rule calculations referencing alternate hierarchy take unexpectedly long time even with feeders.
Departed Features
Two config items have been removed:
  • LockPagesInMemory, which related to servers under 64 bit Windows; and
  • MTQ.CTreeRedundancyReducer, which was disabled following stability issues described in Technote 886359
New Features
None.

File List
  • tm1_winx64h_2.0.97.6_ml.tar.gz (2.83 GB)
  • tm1client_winx64h_2.0.97.6_ml.tar.gz (820.02 MB)
  • tm1server_cd-linuxple64n-inst-11.8.00600.6-ml.tar.gz (637.49 MB)
  • tm1_zlinux64h_2.0.97.6_ml.tar.gz (2.39 GB)
  • tm1_linuxi38664h_2.0.97.6_ml.tar.gz (2.52 GB)
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.

User avatar
Alan Kirk
Site Admin
Posts: 6459
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.6 Classic(PAW-free zone)
Excel Version: 2010 and Office 365
Location: Sydney, Australia
Contact:

Re: Fix Pack Releases: PA2 / V11 Series

Post by Alan Kirk » Sun Jun 27, 2021 4:48 am

Version 2.0.9.8 is... wait, what?

Yes, I'm a tad tardy about this one, which is fortunate. I'm posting it only for reference.

I received the notification about this on 28 May 2021.

I won't put up the links because they now all lead to "403 Forbidden" error pages.

Why?

Probably because of this.
IBM wrote:A defect has been identified in the IBM Planning Analytics 2.0.9.8 release. This defect will prevent non-admin users from seeing the value in calculated intersections when the Aggregate MDX function is used to calculate the value in the cell, and element security is applied to the dimension containing the members being aggregated. This defect does not impact non-calculated intersections, including consolidations and rule derived cells.

Content
The defect may present itself in any TM1 client that uses the Aggregate MDX functions. This list includes but is not limited to Cognos Analytics, Planning Analytics for Excel, and Planning Analytics Workspace.

The defect outlined in this notification will be corrected in the IBM Planning Analytics 2.0.9.9 update.
In other news, one of our redoubtable MVPs (Moby91) has kindly drawn my attention to some updated pages relating to the expiry dates of the 2.0x series. (And many thanks for that.)

In summary:
  • Everything from 2.0.0 to 2.0.7 will go out of support on 30 September 2021. So... kinda soon.
  • 2.0.8 will go out of support one year later on 30 September 2022.
Since 2.0.9 is current, it doesn't yet have an out of support date. Except maybe for 2.0.9.8 anyway...
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.

User avatar
Alan Kirk
Site Admin
Posts: 6459
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.6 Classic(PAW-free zone)
Excel Version: 2010 and Office 365
Location: Sydney, Australia
Contact:

Re: Fix Pack Releases: PA2 / V11 Series

Post by Alan Kirk » Fri Jul 16, 2021 8:00 pm

Version 2.0.9.9 is now out.

PAL 2.0.9.9 (14 Jul 2021)
Release Page.

Key Fixes
The fix list doesn't contain a huge list, but has quite a few things that could catch people out:
  • Can't reject a contributor node which has an apostrophe;
  • Slow login in Perspectives architect in 2.0.9.7, which will be rather important for the large number of people who, for whatever reason :roll: have not moved to PAfE;
  • Server hanging "when thread is inside transaction log critical section while acquiring a TM1 object lock". I'm not sure what that means, exactly, but I do know that working with the transaction log in PA2 is a "use at your own risk" experience.
  • An issue with tracing feeders in PAW.
  • A server crash when using an ODBC connection when column names are nulls. Which... OK, good to know.
  • Server crash when manipulating the Metadata tab of a TI Process. WHAT?? I assume, or certainly would hope, that this was only occurring in specific circumstances.
  • TM1 server crashes when executing in the same process to create new hierarchy into a dimension and create 'caption' attribute to leaf elements of the new hierarchy.
  • A crash occurs when using the undocumented parameter StargateOptimizationInRules=T. I can't find that parameter being referred to in any prior posts on the Forum so I doubt that it's widely used, being undocumented and all.
  • A problem with searching the set editor by alias in Cyrillic or Japanese.
  • Feeder recalculation being triggered in startup in some cases.
  • "TM1 server crash during construction of filler hierarchy member." Rrrright.
  • The server becoming unregistered from the Admin server when a runaway process causes event handle exhaustion on Windows.
  • "MDX with aggregate function returns nulls instead of values for non-admin users when the model has dimension security defined for the dimension participating in the query". I think this was the thing that caused 2.0.8 to be pulled. And finally:
  • Incorrect value running MDX Aggregate function when left hand side of the rule has no explicit dimension.
Departed Features
Nothing new. It's not news that TM1 Operations Console and PMHub are no longer supported. What might be is that they are apparently being pulled entirely from the Cloud deployment in 2.0.9.

New Features
None.

Related Software
TM1 Web can be updated with Spreadsheet Services 2.0.6.6.

File List
  • tm1_winx64h_2.0.97.6_ml.tar.gz (2.83 GB)
  • tm1_winx64h_2.0.99.8_ml.tar.gz (2.82 GB)
  • tm1client_winx64h_2.0.99.8_ml.tar.gz (820 MB)
  • tm1web-11.0.66-21070711-winx64h_bundle.zip (644.77 MB)
  • tm1_zlinux64h_2.0.99.8_ml.tar.gz (2.38 GB)
  • tm1_linuxi38664h_2.0.99.8_ml.tar.gz (2.51 GB)
  • tm1web-11.0.66-21070711-linuxi38664h_bundle.tar.gz (554.85 MB)
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.

User avatar
Alan Kirk
Site Admin
Posts: 6459
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.6 Classic(PAW-free zone)
Excel Version: 2010 and Office 365
Location: Sydney, Australia
Contact:

Re: Fix Pack Releases: PA2 / V11 Series

Post by Alan Kirk » Wed Jul 28, 2021 9:53 am

I've just been provided with a rather interesting piece of information.

The original end of support dates for 2.0.0 to 2.0.7 was 30 September 2021.

This has just been restated as 30 September 2022, so everything from 2.0.0 to 2.0.8 will go off support at the same time. That provides a significant chunk more lead time for anyone on one of the older versions and is, I think, something that IBM deserves a bit of applause for.

The document showing the new date will be found here. I'm adjusting the dates in the master post accordingly.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.

User avatar
Alan Kirk
Site Admin
Posts: 6459
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.6 Classic(PAW-free zone)
Excel Version: 2010 and Office 365
Location: Sydney, Australia
Contact:

Re: Fix Pack Releases: PA2 / V11 Series

Post by Alan Kirk » Wed Sep 22, 2021 7:31 am

Yes folks, it's that time of the cadence again. Well, sort of... it has been only 2 months since the last one although I'm a little tardy putting this one up. The e-mail came out 6 days ago but I only saw it this evening.

Version 2.0.9.10 is now out.

PAL 2.0.9.10 (14 Sep 2021)
Release Page.

Key Fixes
Again the fix list isn't huge, but there are some niggles:
  • PH24729 Wrong variable assignment order in MDX view processing
  • PH28724 Data tab is skipped on every second execution of a process
  • PH33564 Drill through process with hierarchy in the context open a view on consolidated element
  • PH36367 Audit log viewer does not work properly with operating system European date format
  • PH37641 NumberToString function not respecting regional settings in scheduled chores
  • PH38336 TM1 server crash during call to get hierarchy by name using string compare
  • PH38384 TM1 server crash due to deleted alternate/leaves hierarchy
  • PH38432 When a process is executed with a CellPutS statement that has only a string as an argument, the TM1
    server crashes
  • PH38684 WildcardFileSearch TurboIntegrator function is unable to retrieve files starting with left curly braces
    { on Linux
  • PH39225 TM1 server logon not completing due to a hang in LDAP server resulting in lock contention
  • PH39297 Unauthorized users can still see cell security protected values when requesting them from REST API on
    a trace calculation
Departed Features
Nothing new.

New Features
There are three new TI functions:
  • HierarchySubsetAliasGet returns the alias attribute for a subset within a hierarchy. This function was introduced in Planning Analytics 2.0.9.10/TM1 Server 11.8.9 and cannot be used in previous versions.
  • SubsetAliasGet returns the alias attribute for a subset. This function was introduced in Planning Analytics 2.0.9.10/TM1 Server 11.8.9 and cannot be used in previous versions.
  • PublishSubset publishes a named private subset on the server. This function was introduced in Planning Analytics 2.0.9.10/TM1 Server 11.8.9 and cannot be used in previous versions.
I assume that PublishSubset will publish the subset of the user who triggered the process... whether they are an admin or not? I won't be able to test that until it's on a test bed, but it'll be interesting to see. (The documentation (linked above) is silent on this point.)

Related Software
TM1 Web can be updated with Spreadsheet Services 2.0.67, which is the same version number as the current release of PAW and PAfe.

File List
  • tm1client_winx64h_2.0.910.5_ml.tar.gz (819.86 MB)
  • tm1_linuxi38664h_2.0.910.5_ml.tar.gz (2.5 GB)
  • tm1_winx64h_2.0.910.5_ml.tar.gz (2.81 GB)
  • tm1_zlinux64h_2.0.910.5_ml.tar.gz (2.37 GB)
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.

Locked