Planning Analytics

 View Only
  • 1.  Quit TI process without "ERROR" post to tm1server.log

    Posted Tue May 07, 2024 06:21 AM

    Hi, I use the server log to follow up on the helth of my PA servers and what I usually do is to scan for the "ERROR" lines in the tm1server.log

    What is bothering me is that I have processes that I run on schedule and if certain conditions are met then the run full, else I just stop the process. To do that I have used "ProcessBreak" and based on what I have read it should just send me to Epilog where I can decide on further actions. But what happens in the tm1server.log is that I get an "ERROR" line...se following for process that only runs ProcessBreak:

    17792   [4]   ERROR   2024-05-07 10:10:18.480   TM1.Process   Process "TEMP":  finished with ProcessBreak

    Is there a way to terminate process without at least getting an "ERROR" id code in the tm1server.log file?



    ------------------------------
    Hallbjorn Bjornsson
    ------------------------------


  • 2.  RE: Quit TI process without "ERROR" post to tm1server.log

    Posted Wed May 08, 2024 09:49 AM

    If the error trapping is in the prolog then the approach I take is to set the datasource to null rather than use ProcessBreak, this way you skip to the epilog without an error in the server log.  Effectively we are removing the datasource from the TI if errors are found at run time.

    Something like this

    #Prolog

    If (Some error check fails);

    errorCode=1; #Reference this in the epilog to decide on action.

    DatasourceNameForServer='NULL';

    EndIf;

    Note this isn't documented anywhere and I've not done it for a while so testing required...



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



  • 3.  RE: Quit TI process without "ERROR" post to tm1server.log

    Posted Thu May 09, 2024 07:04 AM

    Hi Hallbjorn,

    I'm a bit hestitant to change this behaviour in TM1 v11.  Right or wrong, we likely have other customers that rely on the Error level log output when a ProcessQuit function is used.  We do agree that ProcessQuit should not generate a log error.  We have opened a work item to track this change for TM1 v12.



    ------------------------------
    Stuart King
    IBM Planning Analytics Offering Manager
    ------------------------------



  • 4.  RE: Quit TI process without "ERROR" post to tm1server.log

    Posted 20 days ago

    Stuart, 

    I believe that Hallbjorn is using ProcessBreak, not ProcessQuit. 



    ------------------------------
    Christopher Redmond
    ------------------------------



  • 5.  RE: Quit TI process without "ERROR" post to tm1server.log

    Posted 20 days ago

    Hi Christopher,

    You are correct. Given the description of ProcessBreak (https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=pctf-processbreak) I will talk to our development team about removing the error in the log.  However, we might change this only in TM1 v12 as we may have existing use cases that expect the error when ProcessBreak is used.  I like Steven's suggested work around. However, it might not work mid way through the Data section of the process. 



    ------------------------------
    Stuart King
    IBM Planning Analytics Offering Manager
    ------------------------------