SQL Server XML failure

[dlabazzo]

Hi all,

Been trying to figure out an error I keep getting when trying to execute a Stored Procedure that does an update with a trigger on it. The error message is "Microsoft OLE DB Provider for SQL Server: The statement has been terminated.\01000 = 3621; Microsoft OLE DB Provider for SQL Server: A .NET Framework error occurred during execution of user-defined routine or aggregate "trg_UserAccount_AuditCLR":
System.InvalidOperationException: Invalid command sent to ExecuteXmlReader. The command must return an Xml result." 

Anyone seen this before and a solution. I run the SP fine in SQL server but fails in Alteryx when it hits the update on the table. Any help would be greatly appreciative. 

[CailinS]

@dlabazzo I think this one may be a candidate to report through my.alteryx.com to see if Customer Support can confirm if this is expected or not. Details you can share that may help are the version of Alteryx you're running as well as which tool this error is occurring though (I assume the Input tool?) and the exact configuration of the tool.