I am testing a LF Cloud Rule that runs a C# script via the Agent. I get this message and I am not sure what this means
This is my test script
namespace ClassLibrary1
{
public class Class1
{ //This is a method that takes inputs and returns outputs
//The names of the input and output parameters configured in the Rule are used as input and output Dictionary keys
public static Task<IDictionary<string, object>> MyScript(IDictionary<string, object> inputsFromRule)
{
var outputsFromScript = new Dictionary<string, object>();
outputsFromScript["Status"] = "Finished";
try
{
OdbcCommand command = new OdbcCommand(inputsFromRule["Query"].ToString());
using (OdbcConnection connection = new OdbcConnection("Driver={ODBC Driver 11 for SQL Server};Server=(local);Database=WorkflowData;UID=X;PWD=X;"))
{
command.Connection = connection;
connection.Open();
command.ExecuteNonQuery();
// The connection is automatically closed at
// the end of the Using block.
}
}
catch(InvalidCastException e) { outputsFromScript["Status"] = e.Message; }
return Task.FromResult<IDictionary<string, object>>(outputsFromScript);
}
}
}
Update:
Trying to use a different library and getting another error I am not sure what to make of. The odd thing is that I should never get any errors back from the agent. I am using a try catch to ensure the error is sent back in the status in case there is anything wrong with my code: