Fix Pack Releases: PA2 / V11 Series

User avatar
Alan Kirk
Site Admin
Posts: 6541
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 »

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: 6541
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 »

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: 6541
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 »

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: 6541
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 »

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: 6541
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 »

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: 6541
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 »

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.
User avatar
Alan Kirk
Site Admin
Posts: 6541
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 »

Apologies for the tardiness here. I've been otherwise occupied for a bit.

Version 2.0.9.11 was released around 23 December.

PAL 2.0.9.11 (23 Dec 2021)
Release Page.

Key Fixes
I'll leave out the items on the fix list which relate to Polish, Lithuanian, or PAW / PAfE (because, hey, bugs in PAW, who'd have thought it), but there are plenty of server crash issues rectified:
  • Suppressing zeros (rows) does not work if you have previously added a calculation to the view. If you select suppress zeros (all), zeros are suppressed as expected.
  • HierarchyDeleteAllElements does not work as expected
  • String data in consolidation is allowed to be entered with multiple hierarchies and not saved - error should be returned
  • SaveDataAll failed when the complete temporary version of the locked cube remains due to the main cube file being locked. In case of excessive roll back, temporary file could also be locked leading to server hang.
  • Using CellPutProportionalSpread in TurboIntegrator doesn't update values in cube except for the last record
  • Turbointegrator function HierarchyContainsAllLeaves crashes server if hierarchy does not contain leaf element
  • Server crash when an MDX view in created one process then used in another process
  • MAX function in MDX returns the wrong value based on order
  • TM1 server crash - retrieving rule without checking for proper lock acquisition
  • Server crashed when creating hierarchy based on alias attribute when the alias is a duplicate
  • Spread failure when performing a relative percent adjustment
  • Data spread errors when a cell has a hold on it with alternate hierarchy in the context
  • Tm1 server crashes under certain conditions when creating a view with zero suppression
  • Tm1 server crash - during a failed dimension update due to lock exception
  • Tm1 server crash – divide by zero converting cell coordinates
  • Tm1 sever crash in CompareNoCaseNoBlanks
  • Tm1 server crash - querying ViewConsolidationOptimizationMethod setting
Departed Features
  • As of Planning Analytics 2.0.9.11, the SkipLoadingAliases parameter to Tm1s.cfg is not supported. If this parameter is present and enabled in your Tm1s.cfg file, it is ignored.
  • This is actually an older one, but it's in the 2.0.9.11 What's New: "IBM Planning Analytics TM1 Web 2.0.69 and later releases no longer support embedded Websheets in Planning Analytics Workspace (PAW) books without the PAW New Experience.
    Planning Analytics on Cloud environments can use either the PAW Classic or New Experience. Classic Experience for Planning Analytics Local refers to the user experience in PAW 2.0.55 and earlier releases.
    The PAW New Experience was released in October 2020 as part of the 2.0.56 update for Planning Analytics on Cloud and 2.0.57 for Planning Analytics Local. This new experience showcases a new look and feel, improves navigation and content management, and introduced the Applications and Plans, and Predictive Forecasting capabilities.
    Planning Analytics on Cloud customers that are using the PAW Classic Experience with Websheets that are embedded in books, should avoid updating to TM1 Web 2.0.69 or higher. If an upgrade to TM1 Server is required for a Planning Analytics on Cloud environment, contact IBM Support to discuss the version of TM1 Web packaged with the TM1 Server upgrade."
    Mmm. My Old Experience is the same as my New Experience. Can't get it to work, and with other, better, options for client software, don't really care if it doesn't work.
New Features
  • There is a new config parameter; HTTPOriginAllowList:
    This parameter sets a comma-delimited list of external origins (URLs) that are trusted and can access the TM1 server.
    Parameter type: optional, dynamic
    If the HTTPOriginAllowList parameter is not included in Tm1s.cfg, requests from all origins are trusted and granted access to the TM1 server, subject to authentication.
  • Planning Analytics 2.0.9.11 introduces support for RedHat Enterprise Linux® 8.x. Support for RedHat Enterprise Linux 7.x continues as well.
  • And I quote... "Due to a load order issue with an IBM-built wrapper library of openssl: libibmcogcrypto.dll, an attempt to start the TM1 Server in console mode (direct execution of Tm1s.exe) fails on Windows 12.
    After attempting to start the server, you receive an error indicating that the Admin Server cannot start due to the missing libibmcogcrypto.dll file.
    This issue occurs only on Window 12. The issue will be addressed in the next release of Planning Analytics after 2.0.9.11."
    You what?? There is no Windows 12. There is Windows 11, a useless piece of effluent that finds yet another way to hack users off by screwing with the start menu and making it worse, something that the Microsoft Windows team excels at, but they have yet to turn their hand to Windows 12. Then I read the title as well as the content... they're talking about Windows Server 2012. Not... quite the same thing, I think. Of course PAW doesn't run under "Windows 12", but then it doesn't run under "Windows 19". Or "Windows 22" either.
Related Software
TM1 Web can be updated with Spreadsheet Services 2.0.69, PAW 2.0.72 and PAfE 2.0.70.

File List
  • tm1client_winx64h_2.0.911.20_ml.tar.gz (817.06 MB)
  • tm1_linuxi38664h_2.0.911.20_ml.tar.gz (2.61 GB)
  • tm1_winx64h_2.0.911.20_ml.tar.gz (2.86 GB)
  • tm1_zlinux64h_2.0.911.20_ml.tar.gz (2.45 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: 6541
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 »

Version 2.0.9.12 was released on 11 March 2022.

PAL 2.0.9.12 (11 Mar 2022)
Release Page.

Key Fixes
There are 1.5 pages of fixes on the the fix list, but these caught my eye:
  • Suppressing zeros (rows) does not work if you have previously added a calculation to the view. If you select suppress zeros (all), zeros are suppressed as expected.
  • Patch request fails if body is over 65535 characters. I'm not sure what that is, but it doesn't sound good.
  • Leaf element lock functionality not working as expected when using multiple hierarchies
  • Processes extracting data from ODBC data sources and loading data to TM1 cubes is taking 4-5 times longer. From my own perspective this would be a Very. Bad. Thing. It would have been nice to know "compared to what", of course, and when this first appeared.
  • TM1 server crash with unhandled exception due to buffer size exceeded limit during a batch request.
  • TM1 server crash with invalid audit log entries retrieved with the REST API. With increasing use of the API, this could have been An Issue.
  • Server crashed after re-ordering dimension.
  • In Architect and Planning Analytics Workspace, by doing no selection in the direction of the spread, all data in the view is cleared out. Not a great way to start your day.
  • Re-order dimensions can cause a full data loss in the cube. Probably an even worse way to start your day.
  • Special filter with wildcards on large dimension leads to long running threads.
  • TM1 server can deadlock if both SaveDataAll and CubeSaveData are invoked at the same time. I haven't used CubeSaveData yet but I'll bet that plenty of people are.
  • TM1 server crash - when process function RuleloadFromFile processing feeders phase encountered a string stack overflow exception.
  • TM1 server crash due to missing reset of handle in REST API followed a rule compilation error.
  • TM1 server crash triggered by user login while chores were executing in bulk load mode.
  • REST API call only retrieves data above the cells containing zero values while using "with" keyword in the MDX statement.
  • TM1 server crashed with failed sandbox delta cube creation.
  • TM1 server crash due to obsolete hierarchies used in views.
  • Row suppression causes all data to be suppressed when an alternate hierarchy is used in context area. Soooo... maybe it's not feeders.
Departed Features
I'm not seeing anything that we haven't already heard about.

New Features
IBM have yet to post a New Features document yet; if and when they do I'll add a summary here.

Related Software
TM1 Web can be updated with Spreadsheet Services 2.0.74, PAW 2.0.73 and PAfE 2.0.74.

File List
  • tm1_linuxi38664h_2.0.912.9_ml.tar.gz (2.61 GB)
  • tm1client_winx64h_2.0.912.9_ml.tar.gz (776.99 MB)
  • tm1_winx64h_2.0.912.9_ml.tar.gz (2.82 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: 6541
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 »

Version 2.0.9.13 was released on 25 April 2022. Good luck to anyone who suffers from triskaidekaphobia. (Of course jumping straight into ANY new release regardless of number has risks.)

PAL 2.0.9.13 (25 Apr 2022)
Release Page.

Key Fixes
The the fix list for this version is fairly short, so I'll put all of the items listed here:
  • SERVER
  • Unable to use ClickHouse ODBC with Planning Analytics - cursor library not used. I'm sure someone out there cares.
  • Unexpected CAMID folders created in TM1 data directory on Linux (not under namespace folder as expected). Can you honestly blame innocent folders from trying to get as far away from CAM as is possible?
  • TM1 intermittently unable to connect to the ODBC data sources. Interestingly late last year I had a similar problem on 2.0.6, but it eventually went away.
  • Attaching another temporary subset to a view renders the previous subset unusable.
  • Unable to copy/paste value from a pick list after restarting Planning Analytics Workspace database.
  • Unexpected result for MDX query with filter expression on an axis, where filter uses a calculatedmember-based Boolean expression.
  • TM1 server crashed creating a view with zero suppression due to incorrect crossjoin memberset sizing.
  • Planning Analytics Workspace: Leaf-level cells are bolded
  • Cube cell clear does not work after second attempt. Error occurs: “attempt to update a nonupdatable cell”
  • ARCHITECT
  • Deleting an element does not remove the element from the dimension in Architect - intermittent issue.
  • PERSPECTIVES
  • Inserting an active form into an Excel sheet creates many blank columns.
Departed Features
I don't know whether this was added to the document later or whether I missed it, but "Planning Analytics 2.0.9.11 is the last release to include 32-bit versions of the TM1 clients (Architect and TM1 Perspectives)".

New Features
Nothing to date.

Related Software
I'm going to drop this section out of future posts because it's already covered in the What's Current thread.

File List
  • tm1client_winx64h_2.0.913.10_ml.tar.gz (781.03 MB)
  • tm1_linuxi38664h_2.0.913.10_ml.tar.gz (2.62 GB)
  • tm1_winx64h_2.0.913.10_ml.tar.gz (2.83 GB)
Locked