SharePoint 2013, SSRS 2013 SharePoint integrated mode. Document library with correct content types for SSRS. Workflow on that library set to run on "new item" and "edit item". Workflow is set to a legacy (2010 ) workflow type.
User creates report using BIDS (Business Intelligence Development Suite). They publish the report from BIDS to that library and worflows fails with error: "Workflow XXX was canceled by System Account"
Diagnostic logs contain message: AutoStart Workflow: Microsoft.SharePoint.SPException: Recursive workflows are not permitted. at Microsoft.SharePoint.Workflow.SPWorkflowAutostartEventReceiver.<>c__DisplayClass1.b__0(SPSite superUserSite, SPWeb superUserWeb)
The workflow does not contain anything recursive. It does however contain the "Impersonation Step" to run as the workflow author.
If the user saves RDL local and manually upload file, the workflow runs just fine.
Has anyone come across SSRS reports being published via BIDS not triggering workflows and if so, have they found a resolution for it? Or is it the "impersonation step" causing the issue (I will be attempting to test this theory shortly myself).
Additional Information: Not a recursive issue. I have a workflow, single step. "set workflow variable" and I have the same issue. Still can't get "on change" or "on create" even to trigger when item published from BIDS.
Get the error:
RunWorkflow: Microsoft.SharePoint.SPException: <Error><CompilerError Line="1" Column="1" Text="The root activity type is invalid." /></Error> at Microsoft.SharePoint.Workflow.SPNoCodeXomlCompiler.LoadXomlAssembly(SPWorkflowAssociation association, SPWeb web) at Microsoft.SharePoint.Workflow.SPWinOeHostServices.LoadDeclarativeAssembly(SPWorkflowAssociation association, Boolean fallback) at Microsoft.SharePoint.Workflow.SPWinOeHostServices.CreateInstance(SPWorkflow workflow) at Microsoft.SharePoint.Workflow.SPWinOeEngine.RunWorkflow(SPWorkflowHostService host, SPWorkflow workflow, Collection`1 events, TimeSpan timeOut) at Microsoft.SharePoint.Workflow.SPWorkflowManager.RunWorkflowElev(SPWorkflow workflow, Collection`1 events, SPWorkflowRunOptionsInternal runOptions)
Additional information: "Root Activity":
<ns0:RootWorkflowActivityWithData x:Class="Microsoft.SharePoint.Workflow.ROOT" x:Name="ROOT" xmlns:ns1="clr-namespace:Microsoft.SharePoint.WorkflowActions.WithKey;Assembly=Microsoft.SharePoint.WorkflowActions, Version=18.104.22.168, Culture=neutral, PublicKeyToken=null" xmlns="http://schemas.microsoft.com/winfx/2006/xaml/workflow" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" xmlns:ns0="clr-namespace:Microsoft.SharePoint.WorkflowActions;Assembly=Microsoft.SharePoint.WorkflowActions, Version=22.214.171.124, Culture=neutral, PublicKeyToken=null">
I have looked through the logs even further and found nothing more, even with "Legacy workflow" traced turned to verbose.
There are some strange SSRS related messages, starting to wonder if it is an SSRS issue not a workflow issue.