Planning Analytics

 View Only

  • 1.  Creating subset and non-existent member causing the TM1 Server to crash

    Posted Mon December 05, 2022 12:57 PM
    I had a client try to do the following:

    user tried to create a subset with non-existing member on a scenario dimension and tried to open a view , this led the server to crash .
    Looks to me this is a product bug and in such scenarios, is there a solution from IBM to avoid these server shutdowns ?
    Has anyone had this happen with PA/TM1?



    ------------------------------
    paul YOUNG
    ------------------------------

    #PlanningAnalyticswithWatson


  • 2.  RE: Creating subset and non-existent member causing the TM1 Server to crash

    Posted Tue December 06, 2022 04:44 AM
    Hi Paul,

    I know people use element and member interchangeably, and often (read: without multi-parentage) it is the same, but a subset stores elements and any form of MDX set refers to members (and dynamic subsets implicitly convert back to the elements the members represent whereas TM1SubsetToSet finds the most 'suitable' member to represent each and every element). 

    That said, can you help me understand how you created "a subset with a non-existing member"? Preferably a REST request send to TM1 that shows the operation which I can execute to crash the server;-?

    ------------------------------
    Hubert Heijkers
    ------------------------------

    Original Message


  • 3.  RE: Creating subset and non-existent member causing the TM1 Server to crash

    Posted Tue December 06, 2022 01:13 PM
    Hi,
    What version of the PA server are you on?  We had this issue where invalid MDX was causing a server crash.  It was resolved in PA 2.0.9.15.

    ------------------------------
    Scott Brown
    ------------------------------

    Original Message


  • 4.  RE: Creating subset and non-existent member causing the TM1 Server to crash

    Posted Wed December 07, 2022 04:01 AM
    I've not seen this recently but my reading of the above is that it would of resulted in a view that contained an empty set, which I have known cause crashes in historical releases.
    How were they creating the set and how did they put the set in the view and how is the view being used?

    The only way I know of creating set and getting it into a view with an error in the set definition would be to use something like the following, you'd need specify the dimension to force the set to be created. (If you don't include then the function errors as it doesn't want to create and empty set.)

    SubsetCreatebyMDX( 'Test Sub', '{[Version].[Version].[Apple]}', 'Version' );

    and then add the set to the view in the usual way in the TI.

    I supposed you could have a view containing a set with a reference to a single member in MDX that is subsequantly deleted.

    ------------------------------
    Steven Rowe
    ------------------------------

    Original Message