Hi.
Is there any enum in the system that can be used in BPM for SysTask.TaskStatus? Something like for rowmod
I noticed that it is possible to set the TaskStatus field to any nvarchar(20)
Hold up, more info. What are you doing and why?
We have couple of scenarios where we want set task status to “ERROR”.
I am just wondering is there any constant/enum that holds all “epicor standard” statuses. It does not really matter what and why I am doing.
1 Like
Youth? Culture? Summer’s Eve container? 
It might matter.
While I certainly understand the desire to just have your question answered, (probably more than you know), not every question is asked for purely your benefit.
2 Likes
It might. Did you know that Epicor is revamping how the System Agent is working and has even limited the use of Data Directives on this table because of the performance hit a DD can have? It’s possible that whatever solution you are working on could be affected by this work. Knowing what you’re doing might help you avoid rewriting this solution. Moreover, I find people are more willing to give help if they know the why behind the question. In fact, I rarely do what a user asks me without knowing the business reason behind it.
2 Likes
Well. I appreciate your composure.
When posting AR Invoices, sometimes it happens that there are some logs telling about that “invoice has some errors…”. Even we get these logs the System monitor will show the task status as COMPLETE (also pop-up will say “Task Status COMPLETE”).
What I did was just to create data directive in which I loop through the logs and if the log has some specific message in it then set the task status to ERROR.
Yes, I can see that if there are errors and the user is never notified to be a problem. It’s the opposite side of the coin where the task agent gets an error status for selecting no records. Not technically an error, but the user should be notified so they don’t wait forever.
Having a DD run on the SysTask table to read logs sounds like the kind of thing that @Rich is warning us about too.
As far as I know, the status field is indeed just text. Will that change in the future? 
I’m wondering if Epicor is going to allow us to register a call back when a task completes where we could put this kind of logic. In addition to A/R postings, warnings about MRP issues would be welcome too.
What I’ve done is create a scheduled function and pull the data from the tables. I then take those tables and pretty up the email with html formatting. Example:
2 Likes
I feel I owe you some explanation.
Please don’t get me wrong. I didn’t mean to offend anyone or be arrogant. I just thought that what I was doing and why I was doing it had nothing to do with the question asked (which is actually true). That’s why I wrote it that way.
However, I wasn’t aware that without describing what I was doing I did not allow you to save me from making a mistake.
Thank you very much.
2 Likes
And not just you. A data directive on the SysTask table is a popular technique used by many, and when @Rich mentioned his disdain for it, it seems like we might need to find an alternate and more performant solution.
This is the great thing about the forum. It makes me more informed when we work together.
1 Like
This is exactly what I needed
3 Likes
Ahh, us old GenX’ers don’t really get offended unless we know you personally, but we pretend pretty good.
It’s almost always helpful to know the why, even when you think it might not be. This forum is not just support, but a repository of knowledge and experience that is invaluable. We just want to help and keep it going in the right direction.
The next person that comes along may appreciate it. All good.
2 Likes