Workflow and MySQL timestamp
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 Type: UsersObject