Hi there
Can anyone recommend a good way to set up email alerts if a process fails? Is there any native functionality built into built into the latest versions of Paw? OR are we still stuck the gold old batch file approach?
Many thanks
Chris
Email Alerts with PAW
-
- Regular Participant
- Posts: 212
- Joined: Wed May 06, 2020 2:58 pm
- OLAP Product: Planning Analytics
- Version: 2.0.9
- Excel Version: 2016
Re: Email Alerts with PAW
I believe the only way to return the state of the process is via a master process and getting the state code.
A way around this may be to create a generic process to execute desired process and pass the relevant parameters. And map the buttons to the generic process instead.
The master parameter may have some of the following parameters
- process (process name wish to call)
- param1 (first parameter of process)
- param2 (second parameter of process)
-.... And so on
Then it could return the state of the process and on failure trigger an email alert
A way around this may be to create a generic process to execute desired process and pass the relevant parameters. And map the buttons to the generic process instead.
The master parameter may have some of the following parameters
- process (process name wish to call)
- param1 (first parameter of process)
- param2 (second parameter of process)
-.... And so on
Then it could return the state of the process and on failure trigger an email alert
-
- Community Contributor
- Posts: 161
- Joined: Tue Apr 02, 2013 1:41 pm
- OLAP Product: tm1, cognos bi
- Version: from TM1 9.4 to PA 2.0.9.6
- Excel Version: 2010
- Location: Toronto, ON
Re: Email Alerts with PAW
I use a different approach. I have a 3-dimensional cube, with one of dimensions being }Processes where for each process I have a few flags such as : email on successful completion, email on complition with minor errors and email on failure with major error
Then in Epilog of each process I have a few codes checking the process execution status and based on Status and the values defined for the Flags above, i send the email to the appropriate group of people
Then in Epilog of each process I have a few codes checking the process execution status and based on Status and the values defined for the Flags above, i send the email to the appropriate group of people
Ardian Alikaj
-
- MVP
- Posts: 3182
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.0.9.18
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: Email Alerts with PAW
Maybe not in real time but near-real time.
You could have a chore that looks at the ProcessError files (from a certain day/time period like last 5 minutes), merge the files and send out the email.
PowerShell is something I used to retrieve the contents of said files and send a 'summary' email with errors/issues.
Or use a TM1 REST API solution to retrieve this information.
You could have a chore that looks at the ProcessError files (from a certain day/time period like last 5 minutes), merge the files and send out the email.
PowerShell is something I used to retrieve the contents of said files and send a 'summary' email with errors/issues.
Or use a TM1 REST API solution to retrieve this information.
Best regards,
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly