+20
I am trying to simply execute a task, without parameters with a process flow every hour.
Indicium Universal (2020.2.2) is running, but I don't see any activity.
The version of IAM is 2020.1 and al hotfixes are done.
Could someone explain, step by step, what to do?
Best answer by Harm Horstman
View original
+20
Yes! Finally the solution is found. Thanks Mark.
Just for anyone who needs to schedule a stored procedure:
1. Create this very simple process flow
2. With a schedule
Set the schedule as default
3. Assign a Control Procedure / Template to the decision node
+23
The latest version (2022.2.10.1) of Indicium (Universal) supports 2021.2 as well as newer versions.
But is the system flow schedule now active? A newer version of Indicium won't help in that regard. Once the schedule is active, Indicium should run the system flow successfully. If not, the error log should provide some clarification to why it is not running as intended.
+20
Hi Mark,
Indicium is running fine, but I am using version 2021.2. I could upgrade Indicium to a newer version, but cannot upgrade IAM now.
Do you think upgrade of Indicium will help?
What is the highest version of Indicum (Universal) that is compatible with IAM version 2021.2?
+23
Hi Harm,
By default within the Scheduled system flows screen, you'll see only Active system flows. To also see system flows that do not have any active schedule, disable the “Active” prefilter:
When this prefilter is Off, all system flows are visible and you can look up the flow you are missing. Select that flow and navigate to the Schedules detail tab of that flow. Here it should show all available schedules for your system flow. To Activate/Use a certain schedule, select it and execute the Activate schedule task:
Once the schedule is activated, Indicium will pick-up instances of this system flow on the configured intervals; e.g. every hour.
Regarding Indicium's error log, I am talking about the Indicium (Universal) which runs the System flows in the background. This Indicium can be navigated to using a browser such as Google Chrome. The URL should be known to you and looks like: https//[server]/[indicium].
When navigated to, you can log-in into Indicium and if you are a Main Administrator in IAM, you should be able to download an Error log from the website:
Hope this helps!
+20
Hi
At this moment the process flow is not visible in 'Scheduled System Flows’
How can I make a schedule 'Active’ in IAM or in TSF?
Indicium should run in the background, but I am not sure it always is, because end users use the WinGUI and don't make use of indicium.
I have also started indicium.exe to see if that makes any difference, but nothing happens.
With error log you mean all txt files in folder ...\Logs? If so, I see no errors in any of these files
+23
Hi
In addition, the times set in the schedule are UTC times (-02:00 hour at the moment)
+20
I have tried both suggestions
Application connector
Decision node
In both cases nothing happens after sync with IAM.
Something wrong in de schedule?
+20
From which version will it be possible? I am currently using 2021.2 and cannot upgrade soon.
Hi Erwin, thanks. I already tried that, but I did not get it to work. I will try to solve it this way. If I don’t succeed I will post here again. Thanks for now.
Perhaps it would be easier to call a task instead of a table task. A table task needs to be called from within the context of the table. A regular task is easier to call and can also activate a flow.
Thanks, but I do not want to tell a website builder to make use of the staging functionality.
I just want him to give one endpoint of the corresponding task, which works perfectly except for the process flow. Then, the functionality would be the same for the windows GUI and the API.
As ThinkWise states in its documentation for resource staging: "For example, when Indicium is called automatically by a third party application or service or by some scheduled process.
In these cases, when there is no need to indicate to some user whether or not input fields are mandatory, disabled etcetera, a record can still be saved in a single request." That sound logical to me. But this single task request should also trigger any process flows attached to it.
I do not understand why I need to do this in another way. At this moment I have one task for a subscription and I should not create a API flow to be able to do the same. Do you have any other suggestions?
+23
My problem is this. I have a subscription task subscription_task (i.e. name, email) and in the Process Flow I defined a flow that when this task is executed, a mail should be send (in my case via HTTP connector). When I execute this task in the windows GUI, everything goes well and I receive an email. However, if I execute its API endpoint (http://…………/subscription_task) then the task is executed well, but the email is not sent. So the behaviour of the windows GUI task and the API counterpart is different.
This is probably due to the calling of the Task itself instead of calling it as a Table task. Some examples can be found here: https://docs.thinkwisesoftware.com/docs/indicium/resource_staging#request-examples-1
F.e.: /country(99)/task_delete_country/stage
So after the Indicium URL, replace [country] with the table you want to start the Task from, between the (), give in the PK, followed by the task name subscription_task, then stage the Task. Patch any changes to the Task parameters if values need to be changed. Commit once all values are correct.
This is quite a challenging way of programming a process flow to start, so I recommend creating a process flow you can call, like here: https://docs.thinkwisesoftware.com/docs/indicium/process_flows
Hi Mark, thanks for you reply. Can you help me than with my problem? Maybe this should not be in this thread, but you can probably move it. My problem is this. I have a subscription task subscription_task (i.e. name, email) and in the Process Flow I defined a flow that when this task is executed, a mail should be send (in my case via HTTP connector). When I execute this task in the windows GUI, everything goes well and I receive an email. However, if I execute its API endpoint (http://…………/subscription_task) then the task is executed well, but the email is not sent. So the behaviour of the windows GUI task and the API counterpart is different. Can you help me with this?
+23
Is it true that we still can not expect the flow to start if we execute the task via the API? I think this should get more priority, because now we cannot expect the API to behave the same as the GUI’s. That seems as a great liability to me. Is this correct or do I miss something and should it work?
Hi Marcjan,
Incorrect, the Universal GUI uses the Indicium API to execute process flow actions.
You can start process flow by using the Execute table task process action, but it cannot start System flows. The difference between the two is that one is initiated by the User (in the GUI or via de API) and the other one by the System - on a scheduled moment or ad-hoc by calling its starting point.
The difference between process flows and system flows become a bit vague due to both types of flows can be started from the API; which is understandable. In our documentation and Software Factory we therefore made it visible which process action are valid for process flows and which are valid for system flows.
I was searching for process flow start by executing a table task. Read this thread. Is it true that we still can not expect the flow to start if we execute the task via the API? I think this should get more priority, because now we cannot expect the API to behave the same as the GUI’s. That seems as a great liability to me. Is this correct or do I miss something and should it work? I am running Indicium version 2022.1
Hey,
stumbled upon this topic doing research for a system flow that needs to execute a task.
If I am not mistaken we can now use task's in our system flows by using the process action
“execute system task”.
Wanted to put that answer here for future people.
+23
To verify, the Decision process action does not have Input and Output parameters (Erwin was mentioning the Input and Output tab in the Process flow screen) but yes, the Process procedure does have all the process flow variables available.
That way you can execute any code you would want to in that Process procedure such as reading, using and setting process variables. Yes, insert/update/delete/etc. is all possible.
Monitoring this process action will not result in much information as it doesn’t do anything by itself. It solely executes a process procedure in which a decision can be made 
In this way it is possible for a decision to actually perform an activity. I have not tried to insert/update/delete records through a decision, but retrieving information and updating the the process variables is something I have done, and thus is possible. If this is a bug I'm glad it is there and hope it remains.
I did notice that monitoring the process flow is not as informative as using tasks. That is something that could be improved upon.
+23
I'm currently trying to implement my first scheduled process and had several Execute Task-actions in mind. In https://docs.thinkwisesoftware.com/docs/sf/process_flows.html#process-schedules I see that Decisions are also supported for scheduling. Since a decision is about the same as an Execute task, I'll put my code inside a Decision.
If anyone knows a reason why this would not work, please let me know why.
Hi Roy,
Since the 2020.2.8 version of the Indicium (Universal) the Decision node should function inside a System Flow. Edit: So the decision node is a good alternative yes. Also the Application connector can be used for this.
Kind regards,
Mark Jongeling
I'm currently trying to implement my first scheduled process and had several Execute Task-actions in mind. In https://docs.thinkwisesoftware.com/docs/sf/process_flows.html#process-schedules I see that Decisions are also supported for scheduling. Since a decision is about the same as an Execute task, I'll put my code inside a Decision.
If anyone knows a reason why this would not work, please let me know why.
+23
Hi,
Do you know if there are any update on this? I'm also trying something with just simply executing a task (stored procedure) every minute or so.
I do have a very obscure work around for this 🤨. I’ve created a process flow which only executes a http connector (a dummy call to google.com i.e.) and then I’ve attached a control procedure to the http connector (of type processes). I've scheduled this call every minute, and because the proces sql code is called, I can execute sql code scheduled.
Hi René,
As far as I know they are working on supporting a couple more process actions with the next release of the Thinkwise Suite. I did hear that using the Database connector will be more convenient but we will see when they share the new features and developments.
For my project, we using Database connectors to execute procedures since in the SQL code field of the DB connector we can specify the query. Your solution is also a viable one. We use the Convert JSON to XML process action for creating the connection string needed for the DB connector since we use JSON string text to give parameters and values to the DB connector. The benefit of that is that converting JSON will always work, while theoretically a http connector call to google.com could give an error when google.com doesn’t respond. But I'm very glad google.com virtually always is available 
I understand the troubles with that. Last I heard is that Product Innovation is working hard to realize all process actions that don’t require user input for the System Flow. It's certainly on their radar.
Good luck Harm!
Kind regards,
Mark Jongeling
Hi,
Do you know if there are any update on this? I'm also trying something with just simply executing a task (stored procedure) every minute or so.
I do have a very obscure work around for this 🤨. I’ve created a process flow which only executes a http connector (a dummy call to google.com i.e.) and then I’ve attached a control procedure to the http connector (of type processes). I've scheduled this call every minute, and because the proces sql code is called, I can execute sql code scheduled.
+3
Just to be sure: this means that when you want to run a task on a regular basis, the only option is to use the connector? Or is there another way to run scheduled tasks? I'm also trying to get this to work.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
