Hi All,
I have been trying to get this working for days no and can't find anything specific to workflow on the internet about it.
I have a MySQL DB which connects to Workflow when going to read all records it comes back with "unable to convert mysql date/time value to system.datetime". The generator I created works fine if I don't select that field. I seen something online about its because of NULL entrys in the field but I don't have any NULL entrys.
I have tried any and all combination of the tick boxes in the table generator to get it working ( ie user quotes, can be null) as well as changing the provider type.
I don't know enough to start looking around the source code so hoping someone here might be able to help.
The full error I get back from debuging is:
ErrorMessage = "Unable to convert MySQL date/time value to System.DateTime"
LastComponent = "Read All Records From ITSM_ Estate"
ModelID = "72d43934-bbb9-11e2-b69f-00163504c83e"
StackTrace = " at GeneratedComponents.ITSM_Estate.ReadAllRecordsFromITSM_Estate.Run(IData data)
at LogicBase.Core.ExecutionEngine.MultiPathProcessComponentExecutionDelegate.Execute(IData data, IOrchestrationComponent comp, String& outputPath, IExecutionEngine engine, TLExecutionContext context)
at LogicBase.Core.ExecutionEngine.AbstractExecutionEngine.RunComponent(TLExecutionContext context, IData data, IOrchestrationComponent comp)"
ThisFormData =
userid = "wil49291"
UsersRetrievedData = array
[0] Type: UsersObject
Thanks in advance
James