Error:
'### Error updating database. Cause: com.microsoft.sqlserver.jdbc.SQLServerException: The query was canceled.\r\n### The error may exist in URL'
This is fixed in Mosaic 21.2.2.0, 22.1.1.0, 22.2.1.0 and future releases from 23.1.0.0.
The issue here is that the code for this API is locking the newly created step in one transaction and, within the same transaction, opening a second transaction to unlock the step. This seems to cause a deadlock in SQL Server.
This occurs when the step is configured to be left incomplete on entry and also configured to be subjectless.