+21It looks like that the StartupProcedure no longer works?
Has something changed?
Last test shows that it only works for the Windows GUI and users with Windows Authentication.
I thought it should work for all GUI's and any type of user authentication, correct?
Windows GUI + Windows Authentication
Windows GUI + SQL Authentication
Best answer by Mark Jongeling
You're right about that Harm. Currently that indeed has to be configured in IAM itself. However, using Post synchronization code, you are able to set Start objects after synchronizing the model to IAM (or include it in the Deployment package). Using an insert query on table usr_grp_pref_start_object, you technically could add start objects to all tenants and user groups that have access to a particular IAM application. We also use this for the Software Factory. Example:
1-- Add start object for all sf developers2insert into usr_grp_pref_start_object 3(4 tenant_id, 5 usr_grp_id, 6 model_id, 7 branch_id, 8 gui_appl_id, 9 start_object_id, 10 start_object_type, 11 task_id, 12 order_no, 13 abs_order_no, 14 insert_user, 15 insert_date_time, 16 update_user, 17 update_date_time18)19select 20 1, -- Default tenant21 'sf_developers',22 g.model_id,23 g.branch_id,24 g.gui_appl_id,25 'check_sf_upgrade_msg',26 1,27 'check_sf_upgrade_msg',28 1,29 1,30 system_user,31 sysdatetime(),32 system_user,33 sysdatetime()34from gui_appl g35where g.model_id = @model_id36 and g.branch_id = @branch_id37 and not exists38 (select 139 from usr_grp_pref_start_object p40 where p.tenant_id = 1 -- Default tenant41 and p.usr_grp_id = 'sf_developers'42 and p.model_id = g.model_id43 and p.branch_id = g.branch_id44 and p.gui_appl_id = g.gui_appl_id45 and p.start_object_id = 'check_sf_upgrade_msg')You could argue that it would be more convenient for developers to be able to set Start objects inside the Software Factory in a way, and/or configure a StartupProcedure or ShutdownProcedure.
Feel free to create an Idea for this. I do feel that we could improve upon the StartupProcedure and implement a native way of allowing a Task/Procedure to run on startup (and on shutdown even)
+23Hi Harm,
To my knowledge, nothing has changed surrounding this extended property. To put it to the test, I've tested this with the following procedure:
Listed it as Extended property:
Started up with my Windows auth account:
And lastely started up with a RDBMS account:
Could it be that you perhaps have opened another branch that does not have this extended property?
+21Hello Mark,
I have checked the branch and tried again this:
1create or alter procedure "proc_startup"2(3 @model_id "text_1024" output,4 @message "text_max" output5)6as7begin89 -- Do not count affected rows for performance10 SET NOCOUNT ON;111213 --control_proc_id: proc_startup14 --template_id: proc_startup15 --prog_object_item_id: proc_startup16 --template_description: 1718 EXEC dbo.tsf_send_message 'This is just a test', NULL, 01920end21go2223grant execute on "proc_startup" to public 24go and
1create or alter procedure "proc_startup"23as4begin56 -- Do not count affected rows for performance7 SET NOCOUNT ON;89 --control_proc_id: proc_startup10 --template_id: proc_startup11 --prog_object_item_id: proc_startup12 --template_description: 1314 EXEC dbo.tsf_send_message 'This is just a test', NULL, 01516end17go1819grant execute on "proc_startup" to public 20go I still see different behavior for the Windows- and Universal GUI and Windows- and RDBMS authentication.
Windows GUI (2023.2.11) + Windows Authentication:
No problems
Windows GUI (2023.2.11) + RDBMS Authentication:
Stored procedure 'proc_startup' generated an error while deriving the parameters.
Information:
Parameter 0 - model_id (model_id):
An SqlParameter with ParameterName '@model_id' is not contained by this SqlParameterCollection.
Parameter 1 - message (message):
An SqlParameter with ParameterName '@message' is not contained by this SqlParameterCollection.
Universal GUI
Nothing happens at all
Does the startup procedure need the parameters model_id and message?
Can you confirm that the startup procedure also works for the Universal GUI?
+23Hi Harm,
I'm not sure the StartupProcedure can have parameters, I didn't check that. But I also wouldn't know how values could be given to these parameters. Not sure why the login authentication type would cause different behavior. According to your description, we can classify this as a bug. Could you create a ticket in TCP? Linking this topic would most likely give enough information for a reproduction.
The extended property StartupProcedure is not available to the Universal GUI.
+21Mark,
Ok it is clear to me that using the StartupProcedure is not a good approach anymore, because it won't work for users that are using Universal or make use of the platform via Indicium.
According your response to the Question below, using a StartObject and start a task is a better approach.
The problem I see here is that proper function depends very much on an action to set the StartObject for users(groups) by the IAM administrator.
+23You're right about that Harm. Currently that indeed has to be configured in IAM itself. However, using Post synchronization code, you are able to set Start objects after synchronizing the model to IAM (or include it in the Deployment package). Using an insert query on table usr_grp_pref_start_object, you technically could add start objects to all tenants and user groups that have access to a particular IAM application. We also use this for the Software Factory. Example:
1-- Add start object for all sf developers2insert into usr_grp_pref_start_object 3(4 tenant_id, 5 usr_grp_id, 6 model_id, 7 branch_id, 8 gui_appl_id, 9 start_object_id, 10 start_object_type, 11 task_id, 12 order_no, 13 abs_order_no, 14 insert_user, 15 insert_date_time, 16 update_user, 17 update_date_time18)19select 20 1, -- Default tenant21 'sf_developers',22 g.model_id,23 g.branch_id,24 g.gui_appl_id,25 'check_sf_upgrade_msg',26 1,27 'check_sf_upgrade_msg',28 1,29 1,30 system_user,31 sysdatetime(),32 system_user,33 sysdatetime()34from gui_appl g35where g.model_id = @model_id36 and g.branch_id = @branch_id37 and not exists38 (select 139 from usr_grp_pref_start_object p40 where p.tenant_id = 1 -- Default tenant41 and p.usr_grp_id = 'sf_developers'42 and p.model_id = g.model_id43 and p.branch_id = g.branch_id44 and p.gui_appl_id = g.gui_appl_id45 and p.start_object_id = 'check_sf_upgrade_msg')You could argue that it would be more convenient for developers to be able to set Start objects inside the Software Factory in a way, and/or configure a StartupProcedure or ShutdownProcedure.
Feel free to create an Idea for this. I do feel that we could improve upon the StartupProcedure and implement a native way of allowing a Task/Procedure to run on startup (and on shutdown even)
+21Mark,
Thanks, your idea is clear to me and I will be able to make this.
Anyway, it will result in a much more complicated solution and mistakes can be made easily.
I will add an idea for a StartupProcedure and ShutdownProcedure that work also for Universal enviroments.
+21
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.