Topic
In Studio versions prior to 22.9.3 we may face an issue with saving a specific wizard with a blank value:
The root cause can be seen in the SEQ Logs:
- Exception saving #xx (Scripts) data by user
- Exception saving script #xx dynamic commands data
We can verify it in the database using:
select * from LeoScriptDynamicCommandsData or
select * from LeoScriptDynamicCommandsData where DefinitionID='00000000-0000-0000-0000-000000000000' 00000000-0000-0000-0000-000000000000 is an invalid value and we need to give it a new unique one.
Instructions
Before we proceed to resolve the issue, we would want to make a BACKUP of the database
To resolve it, we need to execute:
update LeoScriptDynamicCommandsData set DefinitionID=NEWID() where ScriptID=XX and CommandName='XXXXX'(In our scenario the query is update LeoScriptDynamicCommandsData set DefinitionID=NEWID() where ScriptID=34 and CommandName='RunMacro')
The expected return is:
Once again run the select query to verify that we no longer have that invalid value:
select * from LeoScriptDynamicCommandsData where DefinitionID='00000000-0000-0000-0000-000000000000'
Restart the Studio and the issue should be resolved.
Additional Information
The issue is resolved in:
- The latest 21.10.9 version.
- 22.9.3 onwards.