CCF Workflow and Workflow step addition fails with "Unable to update the requested information"
When in the CCF admin console, you may get an "Unable to update the requested information" error when trying to add a new workflow or workflow step (from here, I will just say workflow but mean both). This is because you cannot add a workflow when no others exist. For example, don’t delete the demo ones until you create one of your own.
What’s happening is that the ID field in the table is used in a relationship and thus cannot be an identity field. So the admin tool checks for the highest value, adds one to it, and uses it as the new ID. When there are no items, it fails.
If you need to manually add a workflow (instead of redeploying), it’s in dbo.ContactCenterAIF.WorkflowsMaster, and for workflow steps, it’s in dbo.ContactCenterAIF.WorkflowStepsMaster.