I am the Product Owner in our Thinkwise project, I usually don't work too much with the SF, except for Subject & Role-related settings. Tonight I am ‘hobbying’ around and trying to get a Task + Process Flow working to mimic Deeplinking behavior from within the Universal GUI.
I got it working, but only after some frustrating debugging. I was encountering an error in the GUI and then found this error in the Indicium log:
2021-12-27T20:10:21.4545130+00:00 800011ab-0000-a700-b63f-84710c7967bb [ERR] TSFMessagesMiddleware: An unhandled exception occurred while processing the request. (fffadd8a)
Microsoft.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'def_deeplink'.
Let me walk through my line of reasoning/debugging and explain why it feels not intuitive at all to have to add a Stored Procedure to get any random Task working:
- I didn't think I'd need any kind of Default logic, so first I reviewed my Task Settings and noticed that Task logic type was set to Template. I figured it might make more sense to set this to None, which I did
- I still got the error, and noticed in the Task Settings > Performance that ‘Use concept’ Default was checked. I unchecked this setting, but still the error remained
- I went to Functionality and decided to create a Control procedure def_deeplink, but still got the error
- I created a Template with a single line of code ‘select 1’ (I got this idea by reviewing tasks from my colleagues), but still the error occurred
- I decided to Assign the program object, then run Generate definition & Execute, and after these actions the Task finally worked
- Next up, I changed the Task name from deeplink to poc_deeplink. Again I got a similar error in the Indicium log.
- I re-assigned the def_deeplink Template to the newly created Program object default_poc_deeplink instead of default_deeplink, then ran Generate definition & Execute, and after these actions the Task worked again
Is there anyone who could explain to me why this Control Procedure + Template + Assigning + Generate definition + Execute is needed?
It doesn't add any value to the Task and it complicates the Low Code concept of creating a simple (Table) Task with some Task parameters...
