Symptoms
Create Site Workflow Time Out Error
Diagnoses
I have a workflow similar to the "SharePoint site povisioning workflow" in the appit documentation: http://help.k2.com/onlinehelp/K2Appit/UserGuide/current/default.htm#Tutorials/Site_Provisioning/Site_Provisioning.htm%3FTocPath%3DTutorials%7CSharePoint%2520Site%2520Provisioning%7C_____0
The create site step of the workflow has worked but recently has been throwing an error:
"The operation has timed out"
Resolution
Increasing timeout for the instance via script alleviates the issue.
DECLARE @Timeout NVARCHAR(MAX) = '240000'
DECLARE @ServiceInstanceID UNIQUEIDENTIFIER = ''
UPDATE?[K2].[SmartBroker].[ServiceInstance]
SET [ServiceInstanceXML].modify('replace value of (/serviceinstance/serviceconfig/settings/key[@name="Service Time Out"]/text())[1] with sql:variable("@Timeout")' )
where [ServiceInstanceGUID] = @ServiceInstanceID