TM1 Forum

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

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

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

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.