2019-02-28 07:50:01:129 - Realisable.Data.Transform.ReaderReadException: An error occurred whilst reading the source data. Error - Error whilst getting the value for field [Discount1_allocation_method].
Error - Unexpected identifier []]... ---> Realisable.Data.Transform.InvalidPathException: Error whilst getting the value for field [Discount1_allocation_method].
Error - Unexpected identifier []]..
   at Realisable.Data.Transform.JSONReader.GetValueFromNode(TransformRecordField fldDef)
   at Realisable.Data.Transform.JSONReader.GetValues(TransformRecordDefinition recDef, String[] fieldIds, Object[] values)
   at Realisable.Data.Transform.ReadStrategy.LineIntoTransaction(TransformRecordDefinition recDef)
   at Realisable.Data.Transform.ReadStrategyNaturalHierarchical.IterateHeirarchicalData(BlockingQueue`1 transactionQueue, TransformRecordDefinition recDef, TransactionContext insertContext)
   at Realisable.Data.Transform.ReadStrategyCustomReader.ProcessSingleSource(BlockingQueue`1 transactionQueue, String systemId)
   at Realisable.Data.Transform.ReadStrategyCustomReader.<>c__DisplayClass6_0.<ReadData>b__0(String systemId)
   at System.Collections.Generic.List`1.ForEach(Action`1 action)
   at Realisable.Data.Transform.ReadStrategyCustomReader.ReadData(BlockingQueue`1 transactionQueue)
   at Realisable.Data.Transform.ReadStrategy.ReadData()
   --- End of inner exception stack trace ---
   at Realisable.Data.Transform.ReadStrategy.Read()
   at Realisable.Data.Transform.TransformRead.Process()
   at Realisable.Data.Transform.TransformControllerInterop.Process()

2019-02-28 07:50:16:126 - Realisable.Data.Transform.ReaderReadException: An error occurred whilst reading the source data. Error - Error whilst getting the value for field [Discount1_allocation_method].
Error - Unexpected identifier []]... ---> Realisable.Data.Transform.InvalidPathException: Error whilst getting the value for field [Discount1_allocation_method].
Error - Unexpected identifier []]..
   at Realisable.Data.Transform.JSONReader.GetValueFromNode(TransformRecordField fldDef)
   at Realisable.Data.Transform.JSONReader.GetValues(TransformRecordDefinition recDef, String[] fieldIds, Object[] values)
   at Realisable.Data.Transform.ReadStrategy.LineIntoTransaction(TransformRecordDefinition recDef)
   at Realisable.Data.Transform.ReadStrategyNaturalHierarchical.IterateHeirarchicalData(BlockingQueue`1 transactionQueue, TransformRecordDefinition recDef, TransactionContext insertContext)
   at Realisable.Data.Transform.ReadStrategyCustomReader.ProcessSingleSource(BlockingQueue`1 transactionQueue, String systemId)
   at Realisable.Data.Transform.ReadStrategyCustomReader.<>c__DisplayClass6_0.<ReadData>b__0(String systemId)
   at System.Collections.Generic.List`1.ForEach(Action`1 action)
   at Realisable.Data.Transform.ReadStrategyCustomReader.ReadData(BlockingQueue`1 transactionQueue)
   at Realisable.Data.Transform.ReadStrategy.ReadData()
   --- End of inner exception stack trace ---
   at Realisable.Data.Transform.ReadStrategy.Read()
   at Realisable.Data.Transform.TransformRead.Process()
   at Realisable.Data.Transform.TransformControllerInterop.Process()

2019-02-28 07:50:38:977 - Realisable.Data.Transform.ReaderReadException: An error occurred whilst reading the source data. Error - Error whilst getting the value for field [Discount1_allocation_method].
Error - Unexpected identifier []]... ---> Realisable.Data.Transform.InvalidPathException: Error whilst getting the value for field [Discount1_allocation_method].
Error - Unexpected identifier []]..
   at Realisable.Data.Transform.JSONReader.GetValueFromNode(TransformRecordField fldDef)
   at Realisable.Data.Transform.JSONReader.GetValues(TransformRecordDefinition recDef, String[] fieldIds, Object[] values)
   at Realisable.Data.Transform.ReadStrategy.LineIntoTransaction(TransformRecordDefinition recDef)
   at Realisable.Data.Transform.ReadStrategyNaturalHierarchical.IterateHeirarchicalData(BlockingQueue`1 transactionQueue, TransformRecordDefinition recDef, TransactionContext insertContext)
   at Realisable.Data.Transform.ReadStrategyCustomReader.ProcessSingleSource(BlockingQueue`1 transactionQueue, String systemId)
   at Realisable.Data.Transform.ReadStrategyCustomReader.<>c__DisplayClass6_0.<ReadData>b__0(String systemId)
   at System.Collections.Generic.List`1.ForEach(Action`1 action)
   at Realisable.Data.Transform.ReadStrategyCustomReader.ReadData(BlockingQueue`1 transactionQueue)
   at Realisable.Data.Transform.ReadStrategy.ReadData()
   --- End of inner exception stack trace ---
   at Realisable.Data.Transform.ReadStrategy.Read()
   at Realisable.Data.Transform.TransformRead.Process()
   at Realisable.Data.Transform.TransformControllerInterop.Process()

2019-02-28 08:00:04:363 - Realisable.Data.Transform.ReaderReadException: An error occurred whilst reading the source data. Error - Error whilst getting the value for field [Discount1_allocation_method].
Error - Unexpected identifier []]... ---> Realisable.Data.Transform.InvalidPathException: Error whilst getting the value for field [Discount1_allocation_method].
Error - Unexpected identifier []]..
   at Realisable.Data.Transform.JSONReader.GetValueFromNode(TransformRecordField fldDef)
   at Realisable.Data.Transform.JSONReader.GetValues(TransformRecordDefinition recDef, String[] fieldIds, Object[] values)
   at Realisable.Data.Transform.ReadStrategy.LineIntoTransaction(TransformRecordDefinition recDef)
   at Realisable.Data.Transform.ReadStrategyNaturalHierarchical.IterateHeirarchicalData(BlockingQueue`1 transactionQueue, TransformRecordDefinition recDef, TransactionContext insertContext)
   at Realisable.Data.Transform.ReadStrategyCustomReader.ProcessSingleSource(BlockingQueue`1 transactionQueue, String systemId)
   at Realisable.Data.Transform.ReadStrategyCustomReader.<>c__DisplayClass6_0.<ReadData>b__0(String systemId)
   at System.Collections.Generic.List`1.ForEach(Action`1 action)
   at Realisable.Data.Transform.ReadStrategyCustomReader.ReadData(BlockingQueue`1 transactionQueue)
   at Realisable.Data.Transform.ReadStrategy.ReadData()
   --- End of inner exception stack trace ---
   at Realisable.Data.Transform.ReadStrategy.Read()
   at Realisable.Data.Transform.TransformRead.Process()
   at Realisable.Data.Transform.TransformControllerInterop.Process()

2019-02-28 08:12:41:403 - Realisable.Data.Transform.ReaderReadException: An error occurred whilst reading the source data. Error - Error whilst getting the value for field [Discount1_code].
Error - Unexpected identifier []]... ---> Realisable.Data.Transform.InvalidPathException: Error whilst getting the value for field [Discount1_code].
Error - Unexpected identifier []]..
   at Realisable.Data.Transform.JSONReader.GetValueFromNode(TransformRecordField fldDef)
   at Realisable.Data.Transform.JSONReader.GetValues(TransformRecordDefinition recDef, String[] fieldIds, Object[] values)
   at Realisable.Data.Transform.ReadStrategy.LineIntoTransaction(TransformRecordDefinition recDef)
   at Realisable.Data.Transform.ReadStrategyNaturalHierarchical.IterateHeirarchicalData(BlockingQueue`1 transactionQueue, TransformRecordDefinition recDef, TransactionContext insertContext)
   at Realisable.Data.Transform.ReadStrategyCustomReader.ProcessSingleSource(BlockingQueue`1 transactionQueue, String systemId)
   at Realisable.Data.Transform.ReadStrategyCustomReader.<>c__DisplayClass6_0.<ReadData>b__0(String systemId)
   at System.Collections.Generic.List`1.ForEach(Action`1 action)
   at Realisable.Data.Transform.ReadStrategyCustomReader.ReadData(BlockingQueue`1 transactionQueue)
   at Realisable.Data.Transform.ReadStrategy.ReadData()
   --- End of inner exception stack trace ---
   at Realisable.Data.Transform.ReadStrategy.Read()
   at Realisable.Data.Transform.TransformRead.Process()
   at Realisable.Data.Transform.TransformControllerInterop.Process()

2019-02-28 08:13:08:135 - Realisable.Data.Transform.ReaderReadException: An error occurred whilst reading the source data. Error - Error whilst getting the value for field [Discount1_description].
Error - Unexpected identifier []]... ---> Realisable.Data.Transform.InvalidPathException: Error whilst getting the value for field [Discount1_description].
Error - Unexpected identifier []]..
   at Realisable.Data.Transform.JSONReader.GetValueFromNode(TransformRecordField fldDef)
   at Realisable.Data.Transform.JSONReader.GetValues(TransformRecordDefinition recDef, String[] fieldIds, Object[] values)
   at Realisable.Data.Transform.ReadStrategy.LineIntoTransaction(TransformRecordDefinition recDef)
   at Realisable.Data.Transform.ReadStrategyNaturalHierarchical.IterateHeirarchicalData(BlockingQueue`1 transactionQueue, TransformRecordDefinition recDef, TransactionContext insertContext)
   at Realisable.Data.Transform.ReadStrategyCustomReader.ProcessSingleSource(BlockingQueue`1 transactionQueue, String systemId)
   at Realisable.Data.Transform.ReadStrategyCustomReader.<>c__DisplayClass6_0.<ReadData>b__0(String systemId)
   at System.Collections.Generic.List`1.ForEach(Action`1 action)
   at Realisable.Data.Transform.ReadStrategyCustomReader.ReadData(BlockingQueue`1 transactionQueue)
   at Realisable.Data.Transform.ReadStrategy.ReadData()
   --- End of inner exception stack trace ---
   at Realisable.Data.Transform.ReadStrategy.Read()
   at Realisable.Data.Transform.TransformRead.Process()
   at Realisable.Data.Transform.TransformControllerInterop.Process()

2019-02-28 08:13:32:216 - Realisable.Data.Transform.ReaderReadException: An error occurred whilst reading the source data. Error - Error whilst getting the value for field [Discount2_allocation_method].
Error - Unexpected identifier []]... ---> Realisable.Data.Transform.InvalidPathException: Error whilst getting the value for field [Discount2_allocation_method].
Error - Unexpected identifier []]..
   at Realisable.Data.Transform.JSONReader.GetValueFromNode(TransformRecordField fldDef)
   at Realisable.Data.Transform.JSONReader.GetValues(TransformRecordDefinition recDef, String[] fieldIds, Object[] values)
   at Realisable.Data.Transform.ReadStrategy.LineIntoTransaction(TransformRecordDefinition recDef)
   at Realisable.Data.Transform.ReadStrategyNaturalHierarchical.IterateHeirarchicalData(BlockingQueue`1 transactionQueue, TransformRecordDefinition recDef, TransactionContext insertContext)
   at Realisable.Data.Transform.ReadStrategyCustomReader.ProcessSingleSource(BlockingQueue`1 transactionQueue, String systemId)
   at Realisable.Data.Transform.ReadStrategyCustomReader.<>c__DisplayClass6_0.<ReadData>b__0(String systemId)
   at System.Collections.Generic.List`1.ForEach(Action`1 action)
   at Realisable.Data.Transform.ReadStrategyCustomReader.ReadData(BlockingQueue`1 transactionQueue)
   at Realisable.Data.Transform.ReadStrategy.ReadData()
   --- End of inner exception stack trace ---
   at Realisable.Data.Transform.ReadStrategy.Read()
   at Realisable.Data.Transform.TransformRead.Process()
   at Realisable.Data.Transform.TransformControllerInterop.Process()

2019-02-28 08:14:49:181 - Realisable.Data.Transform.ReaderReadException: An error occurred whilst reading the source data. Error - Error whilst getting the value for field [DiscountCode1_amount].
Error - Unexpected identifier []]... ---> Realisable.Data.Transform.InvalidPathException: Error whilst getting the value for field [DiscountCode1_amount].
Error - Unexpected identifier []]..
   at Realisable.Data.Transform.JSONReader.GetValueFromNode(TransformRecordField fldDef)
   at Realisable.Data.Transform.JSONReader.GetValues(TransformRecordDefinition recDef, String[] fieldIds, Object[] values)
   at Realisable.Data.Transform.ReadStrategy.LineIntoTransaction(TransformRecordDefinition recDef)
   at Realisable.Data.Transform.ReadStrategyNaturalHierarchical.IterateHeirarchicalData(BlockingQueue`1 transactionQueue, TransformRecordDefinition recDef, TransactionContext insertContext)
   at Realisable.Data.Transform.ReadStrategyCustomReader.ProcessSingleSource(BlockingQueue`1 transactionQueue, String systemId)
   at Realisable.Data.Transform.ReadStrategyCustomReader.<>c__DisplayClass6_0.<ReadData>b__0(String systemId)
   at System.Collections.Generic.List`1.ForEach(Action`1 action)
   at Realisable.Data.Transform.ReadStrategyCustomReader.ReadData(BlockingQueue`1 transactionQueue)
   at Realisable.Data.Transform.ReadStrategy.ReadData()
   --- End of inner exception stack trace ---
   at Realisable.Data.Transform.ReadStrategy.Read()
   at Realisable.Data.Transform.TransformRead.Process()
   at Realisable.Data.Transform.TransformControllerInterop.Process()

2019-02-28 08:15:43:981 - Realisable.Data.Transform.ReaderReadException: An error occurred whilst reading the source data. Error - Error whilst getting the value for field [Note1_name].
Error - Unexpected identifier []]... ---> Realisable.Data.Transform.InvalidPathException: Error whilst getting the value for field [Note1_name].
Error - Unexpected identifier []]..
   at Realisable.Data.Transform.JSONReader.GetValueFromNode(TransformRecordField fldDef)
   at Realisable.Data.Transform.JSONReader.GetValues(TransformRecordDefinition recDef, String[] fieldIds, Object[] values)
   at Realisable.Data.Transform.ReadStrategy.LineIntoTransaction(TransformRecordDefinition recDef)
   at Realisable.Data.Transform.ReadStrategyNaturalHierarchical.IterateHeirarchicalData(BlockingQueue`1 transactionQueue, TransformRecordDefinition recDef, TransactionContext insertContext)
   at Realisable.Data.Transform.ReadStrategyCustomReader.ProcessSingleSource(BlockingQueue`1 transactionQueue, String systemId)
   at Realisable.Data.Transform.ReadStrategyCustomReader.<>c__DisplayClass6_0.<ReadData>b__0(String systemId)
   at System.Collections.Generic.List`1.ForEach(Action`1 action)
   at Realisable.Data.Transform.ReadStrategyCustomReader.ReadData(BlockingQueue`1 transactionQueue)
   at Realisable.Data.Transform.ReadStrategy.ReadData()
   --- End of inner exception stack trace ---
   at Realisable.Data.Transform.ReadStrategy.Read()
   at Realisable.Data.Transform.TransformRead.Process()
   at Realisable.Data.Transform.TransformControllerInterop.Process()

2019-02-28 08:16:33:280 - Realisable.Data.Transform.ReaderReadException: An error occurred whilst reading the source data. Error - Error whilst getting the value for field [Payment1_amount].
Error - Unexpected identifier []]... ---> Realisable.Data.Transform.InvalidPathException: Error whilst getting the value for field [Payment1_amount].
Error - Unexpected identifier []]..
   at Realisable.Data.Transform.JSONReader.GetValueFromNode(TransformRecordField fldDef)
   at Realisable.Data.Transform.JSONReader.GetValues(TransformRecordDefinition recDef, String[] fieldIds, Object[] values)
   at Realisable.Data.Transform.ReadStrategy.LineIntoTransaction(TransformRecordDefinition recDef)
   at Realisable.Data.Transform.ReadStrategyNaturalHierarchical.IterateHeirarchicalData(BlockingQueue`1 transactionQueue, TransformRecordDefinition recDef, TransactionContext insertContext)
   at Realisable.Data.Transform.ReadStrategyCustomReader.ProcessSingleSource(BlockingQueue`1 transactionQueue, String systemId)
   at Realisable.Data.Transform.ReadStrategyCustomReader.<>c__DisplayClass6_0.<ReadData>b__0(String systemId)
   at System.Collections.Generic.List`1.ForEach(Action`1 action)
   at Realisable.Data.Transform.ReadStrategyCustomReader.ReadData(BlockingQueue`1 transactionQueue)
   at Realisable.Data.Transform.ReadStrategy.ReadData()
   --- End of inner exception stack trace ---
   at Realisable.Data.Transform.ReadStrategy.Read()
   at Realisable.Data.Transform.TransformRead.Process()
   at Realisable.Data.Transform.TransformControllerInterop.Process()

2019-02-28 08:23:37:355 - Realisable.Data.Transform.ReaderReadException: An error occurred whilst reading the source data. Error - Error whilst getting the value for field [Discount1_allocation_method].
Error - Unexpected identifier []]... ---> Realisable.Data.Transform.InvalidPathException: Error whilst getting the value for field [Discount1_allocation_method].
Error - Unexpected identifier []]..
   at Realisable.Data.Transform.JSONReader.GetValueFromNode(TransformRecordField fldDef)
   at Realisable.Data.Transform.JSONReader.GetValues(TransformRecordDefinition recDef, String[] fieldIds, Object[] values)
   at Realisable.Data.Transform.ReadStrategy.LineIntoTransaction(TransformRecordDefinition recDef)
   at Realisable.Data.Transform.ReadStrategyNaturalHierarchical.IterateHeirarchicalData(BlockingQueue`1 transactionQueue, TransformRecordDefinition recDef, TransactionContext insertContext)
   at Realisable.Data.Transform.ReadStrategyCustomReader.ProcessSingleSource(BlockingQueue`1 transactionQueue, String systemId)
   at Realisable.Data.Transform.ReadStrategyCustomReader.<>c__DisplayClass6_0.<ReadData>b__0(String systemId)
   at System.Collections.Generic.List`1.ForEach(Action`1 action)
   at Realisable.Data.Transform.ReadStrategyCustomReader.ReadData(BlockingQueue`1 transactionQueue)
   at Realisable.Data.Transform.ReadStrategy.ReadData()
   --- End of inner exception stack trace ---
   at Realisable.Data.Transform.ReadStrategy.Read()
   at Realisable.Data.Transform.TransformRead.Process()
   at Realisable.Data.Transform.TransformControllerInterop.Process()

2019-02-28 08:25:39:639 - Realisable.Data.Transform.ReaderReadException: An error occurred whilst reading the source data. Error - Error whilst getting the value for field [Discount1_code].
Error - Unexpected identifier []]... ---> Realisable.Data.Transform.InvalidPathException: Error whilst getting the value for field [Discount1_code].
Error - Unexpected identifier []]..
   at Realisable.Data.Transform.JSONReader.GetValueFromNode(TransformRecordField fldDef)
   at Realisable.Data.Transform.JSONReader.GetValues(TransformRecordDefinition recDef, String[] fieldIds, Object[] values)
   at Realisable.Data.Transform.ReadStrategy.LineIntoTransaction(TransformRecordDefinition recDef)
   at Realisable.Data.Transform.ReadStrategyNaturalHierarchical.IterateHeirarchicalData(BlockingQueue`1 transactionQueue, TransformRecordDefinition recDef, TransactionContext insertContext)
   at Realisable.Data.Transform.ReadStrategyCustomReader.ProcessSingleSource(BlockingQueue`1 transactionQueue, String systemId)
   at Realisable.Data.Transform.ReadStrategyCustomReader.<>c__DisplayClass6_0.<ReadData>b__0(String systemId)
   at System.Collections.Generic.List`1.ForEach(Action`1 action)
   at Realisable.Data.Transform.ReadStrategyCustomReader.ReadData(BlockingQueue`1 transactionQueue)
   at Realisable.Data.Transform.ReadStrategy.ReadData()
   --- End of inner exception stack trace ---
   at Realisable.Data.Transform.ReadStrategy.Read()
   at Realisable.Data.Transform.TransformRead.Process()
   at Realisable.Data.Transform.TransformControllerInterop.Process()

2019-02-28 08:26:34:438 - Realisable.Data.Transform.ReaderReadException: An error occurred whilst reading the source data. Error - Error whilst getting the value for field [Payment1_amount].
Error - Unexpected identifier []]... ---> Realisable.Data.Transform.InvalidPathException: Error whilst getting the value for field [Payment1_amount].
Error - Unexpected identifier []]..
   at Realisable.Data.Transform.JSONReader.GetValueFromNode(TransformRecordField fldDef)
   at Realisable.Data.Transform.JSONReader.GetValues(TransformRecordDefinition recDef, String[] fieldIds, Object[] values)
   at Realisable.Data.Transform.ReadStrategy.LineIntoTransaction(TransformRecordDefinition recDef)
   at Realisable.Data.Transform.ReadStrategyNaturalHierarchical.IterateHeirarchicalData(BlockingQueue`1 transactionQueue, TransformRecordDefinition recDef, TransactionContext insertContext)
   at Realisable.Data.Transform.ReadStrategyCustomReader.ProcessSingleSource(BlockingQueue`1 transactionQueue, String systemId)
   at Realisable.Data.Transform.ReadStrategyCustomReader.<>c__DisplayClass6_0.<ReadData>b__0(String systemId)
   at System.Collections.Generic.List`1.ForEach(Action`1 action)
   at Realisable.Data.Transform.ReadStrategyCustomReader.ReadData(BlockingQueue`1 transactionQueue)
   at Realisable.Data.Transform.ReadStrategy.ReadData()
   --- End of inner exception stack trace ---
   at Realisable.Data.Transform.ReadStrategy.Read()
   at Realisable.Data.Transform.TransformRead.Process()
   at Realisable.Data.Transform.TransformControllerInterop.Process()

2019-02-28 08:28:18:001 - Realisable.Data.Transform.ReaderReadException: An error occurred whilst reading the source data. Error - Error whilst getting the value for field [Shipping1_Code].
Error - Unexpected identifier []]... ---> Realisable.Data.Transform.InvalidPathException: Error whilst getting the value for field [Shipping1_Code].
Error - Unexpected identifier []]..
   at Realisable.Data.Transform.JSONReader.GetValueFromNode(TransformRecordField fldDef)
   at Realisable.Data.Transform.JSONReader.GetValues(TransformRecordDefinition recDef, String[] fieldIds, Object[] values)
   at Realisable.Data.Transform.ReadStrategy.LineIntoTransaction(TransformRecordDefinition recDef)
   at Realisable.Data.Transform.ReadStrategyNaturalHierarchical.IterateHeirarchicalData(BlockingQueue`1 transactionQueue, TransformRecordDefinition recDef, TransactionContext insertContext)
   at Realisable.Data.Transform.ReadStrategyCustomReader.ProcessSingleSource(BlockingQueue`1 transactionQueue, String systemId)
   at Realisable.Data.Transform.ReadStrategyCustomReader.<>c__DisplayClass6_0.<ReadData>b__0(String systemId)
   at System.Collections.Generic.List`1.ForEach(Action`1 action)
   at Realisable.Data.Transform.ReadStrategyCustomReader.ReadData(BlockingQueue`1 transactionQueue)
   at Realisable.Data.Transform.ReadStrategy.ReadData()
   --- End of inner exception stack trace ---
   at Realisable.Data.Transform.ReadStrategy.Read()
   at Realisable.Data.Transform.TransformRead.Process()
   at Realisable.Data.Transform.TransformControllerInterop.Process()

2019-02-28 08:29:38:595 - Realisable.Data.Transform.ReaderReadException: An error occurred whilst reading the source data. Error - Error whilst getting the value for field [Tax1_title].
Error - Unexpected identifier []]... ---> Realisable.Data.Transform.InvalidPathException: Error whilst getting the value for field [Tax1_title].
Error - Unexpected identifier []]..
   at Realisable.Data.Transform.JSONReader.GetValueFromNode(TransformRecordField fldDef)
   at Realisable.Data.Transform.JSONReader.GetValues(TransformRecordDefinition recDef, String[] fieldIds, Object[] values)
   at Realisable.Data.Transform.ReadStrategy.LineIntoTransaction(TransformRecordDefinition recDef)
   at Realisable.Data.Transform.ReadStrategyNaturalHierarchical.IterateHeirarchicalData(BlockingQueue`1 transactionQueue, TransformRecordDefinition recDef, TransactionContext insertContext)
   at Realisable.Data.Transform.ReadStrategyCustomReader.ProcessSingleSource(BlockingQueue`1 transactionQueue, String systemId)
   at Realisable.Data.Transform.ReadStrategyCustomReader.<>c__DisplayClass6_0.<ReadData>b__0(String systemId)
   at System.Collections.Generic.List`1.ForEach(Action`1 action)
   at Realisable.Data.Transform.ReadStrategyCustomReader.ReadData(BlockingQueue`1 transactionQueue)
   at Realisable.Data.Transform.ReadStrategy.ReadData()
   --- End of inner exception stack trace ---
   at Realisable.Data.Transform.ReadStrategy.Read()
   at Realisable.Data.Transform.TransformRead.Process()
   at Realisable.Data.Transform.TransformControllerInterop.Process()

2019-02-28 08:30:02:989 - Realisable.Data.Transform.ReaderReadException: An error occurred whilst reading the source data. Error - Error whilst getting the value for field [Discount1_amount].
Error - Unexpected identifier []]... ---> Realisable.Data.Transform.InvalidPathException: Error whilst getting the value for field [Discount1_amount].
Error - Unexpected identifier []]..
   at Realisable.Data.Transform.JSONReader.GetValueFromNode(TransformRecordField fldDef)
   at Realisable.Data.Transform.JSONReader.GetValues(TransformRecordDefinition recDef, String[] fieldIds, Object[] values)
   at Realisable.Data.Transform.ReadStrategy.LineIntoTransaction(TransformRecordDefinition recDef)
   at Realisable.Data.Transform.ReadStrategyNaturalHierarchical.IterateHeirarchicalData(BlockingQueue`1 transactionQueue, TransformRecordDefinition recDef, TransactionContext insertContext)
   at Realisable.Data.Transform.ReadStrategyNaturalHierarchical.IterateHeirarchicalData(BlockingQueue`1 transactionQueue, TransformRecordDefinition recDef, TransactionContext insertContext)
   at Realisable.Data.Transform.ReadStrategyCustomReader.ProcessSingleSource(BlockingQueue`1 transactionQueue, String systemId)
   at Realisable.Data.Transform.ReadStrategyCustomReader.<>c__DisplayClass6_0.<ReadData>b__0(String systemId)
   at System.Collections.Generic.List`1.ForEach(Action`1 action)
   at Realisable.Data.Transform.ReadStrategyCustomReader.ReadData(BlockingQueue`1 transactionQueue)
   at Realisable.Data.Transform.ReadStrategy.ReadData()
   --- End of inner exception stack trace ---
   at Realisable.Data.Transform.ReadStrategy.Read()
   at Realisable.Data.Transform.TransformRead.Process()
   at Realisable.Data.Transform.TransformControllerInterop.Process()

2019-02-28 08:30:39:197 - Realisable.Data.Transform.ReaderReadException: An error occurred whilst reading the source data. Error - Error whilst getting the value for field [Discount1_amount].
Error - Unexpected identifier []]... ---> Realisable.Data.Transform.InvalidPathException: Error whilst getting the value for field [Discount1_amount].
Error - Unexpected identifier []]..
   at Realisable.Data.Transform.JSONReader.GetValueFromNode(TransformRecordField fldDef)
   at Realisable.Data.Transform.JSONReader.GetValues(TransformRecordDefinition recDef, String[] fieldIds, Object[] values)
   at Realisable.Data.Transform.ReadStrategy.LineIntoTransaction(TransformRecordDefinition recDef)
   at Realisable.Data.Transform.ReadStrategyNaturalHierarchical.IterateHeirarchicalData(BlockingQueue`1 transactionQueue, TransformRecordDefinition recDef, TransactionContext insertContext)
   at Realisable.Data.Transform.ReadStrategyNaturalHierarchical.IterateHeirarchicalData(BlockingQueue`1 transactionQueue, TransformRecordDefinition recDef, TransactionContext insertContext)
   at Realisable.Data.Transform.ReadStrategyCustomReader.ProcessSingleSource(BlockingQueue`1 transactionQueue, String systemId)
   at Realisable.Data.Transform.ReadStrategyCustomReader.<>c__DisplayClass6_0.<ReadData>b__0(String systemId)
   at System.Collections.Generic.List`1.ForEach(Action`1 action)
   at Realisable.Data.Transform.ReadStrategyCustomReader.ReadData(BlockingQueue`1 transactionQueue)
   at Realisable.Data.Transform.ReadStrategy.ReadData()
   --- End of inner exception stack trace ---
   at Realisable.Data.Transform.ReadStrategy.Read()
   at Realisable.Data.Transform.TransformRead.Process()
   at Realisable.Data.Transform.TransformControllerInterop.Process()

2019-02-28 08:31:08:302 - Realisable.Data.Transform.ReaderReadException: An error occurred whilst reading the source data. Error - Error whilst getting the value for field [Tax1_title].
Error - Unexpected identifier []]... ---> Realisable.Data.Transform.InvalidPathException: Error whilst getting the value for field [Tax1_title].
Error - Unexpected identifier []]..
   at Realisable.Data.Transform.JSONReader.GetValueFromNode(TransformRecordField fldDef)
   at Realisable.Data.Transform.JSONReader.GetValues(TransformRecordDefinition recDef, String[] fieldIds, Object[] values)
   at Realisable.Data.Transform.ReadStrategy.LineIntoTransaction(TransformRecordDefinition recDef)
   at Realisable.Data.Transform.ReadStrategyNaturalHierarchical.IterateHeirarchicalData(BlockingQueue`1 transactionQueue, TransformRecordDefinition recDef, TransactionContext insertContext)
   at Realisable.Data.Transform.ReadStrategyNaturalHierarchical.IterateHeirarchicalData(BlockingQueue`1 transactionQueue, TransformRecordDefinition recDef, TransactionContext insertContext)
   at Realisable.Data.Transform.ReadStrategyCustomReader.ProcessSingleSource(BlockingQueue`1 transactionQueue, String systemId)
   at Realisable.Data.Transform.ReadStrategyCustomReader.<>c__DisplayClass6_0.<ReadData>b__0(String systemId)
   at System.Collections.Generic.List`1.ForEach(Action`1 action)
   at Realisable.Data.Transform.ReadStrategyCustomReader.ReadData(BlockingQueue`1 transactionQueue)
   at Realisable.Data.Transform.ReadStrategy.ReadData()
   --- End of inner exception stack trace ---
   at Realisable.Data.Transform.ReadStrategy.Read()
   at Realisable.Data.Transform.TransformRead.Process()
   at Realisable.Data.Transform.TransformControllerInterop.Process()

2019-02-28 08:31:34:697 - Realisable.Data.Transform.ReaderReadException: An error occurred whilst reading the source data. Error - Error whilst getting the value for field [Tax1_rate].
Error - Unexpected identifier []]... ---> Realisable.Data.Transform.InvalidPathException: Error whilst getting the value for field [Tax1_rate].
Error - Unexpected identifier []]..
   at Realisable.Data.Transform.JSONReader.GetValueFromNode(TransformRecordField fldDef)
   at Realisable.Data.Transform.JSONReader.GetValues(TransformRecordDefinition recDef, String[] fieldIds, Object[] values)
   at Realisable.Data.Transform.ReadStrategy.LineIntoTransaction(TransformRecordDefinition recDef)
   at Realisable.Data.Transform.ReadStrategyNaturalHierarchical.IterateHeirarchicalData(BlockingQueue`1 transactionQueue, TransformRecordDefinition recDef, TransactionContext insertContext)
   at Realisable.Data.Transform.ReadStrategyNaturalHierarchical.IterateHeirarchicalData(BlockingQueue`1 transactionQueue, TransformRecordDefinition recDef, TransactionContext insertContext)
   at Realisable.Data.Transform.ReadStrategyCustomReader.ProcessSingleSource(BlockingQueue`1 transactionQueue, String systemId)
   at Realisable.Data.Transform.ReadStrategyCustomReader.<>c__DisplayClass6_0.<ReadData>b__0(String systemId)
   at System.Collections.Generic.List`1.ForEach(Action`1 action)
   at Realisable.Data.Transform.ReadStrategyCustomReader.ReadData(BlockingQueue`1 transactionQueue)
   at Realisable.Data.Transform.ReadStrategy.ReadData()
   --- End of inner exception stack trace ---
   at Realisable.Data.Transform.ReadStrategy.Read()
   at Realisable.Data.Transform.TransformRead.Process()
   at Realisable.Data.Transform.TransformControllerInterop.Process()

2019-02-28 09:13:00:541 - System.Web.HttpUnhandledException: Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
   at System.Collections.ArrayList.get_Item(Int32 index)
   at Syncfusion.Windows.Forms.Diagram.SymbolPalette.SetIcons(Node node, Int32 insertIndex)
   at Syncfusion.Windows.Forms.Diagram.SymbolPalette.RecreateIcons()
   at Syncfusion.Web.UI.WebControls.Diagram.PaletteGroupBar.OnPreRender(EventArgs e)
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   --- End of inner exception stack trace ---
   at System.Web.UI.Page.HandleError(Exception e)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   at System.Web.UI.Page.ProcessRequest()
   at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
   at System.Web.UI.Page.ProcessRequest(HttpContext context)
   at ASP.design_designpage_aspx.ProcessRequest(HttpContext context)
   at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

2019-02-28 09:18:45:524 - System.Web.HttpUnhandledException: Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
   at System.Collections.ArrayList.get_Item(Int32 index)
   at Syncfusion.Windows.Forms.Diagram.SymbolPalette.SetIcons(Node node, Int32 insertIndex)
   at Syncfusion.Windows.Forms.Diagram.SymbolPalette.RecreateIcons()
   at Syncfusion.Web.UI.WebControls.Diagram.PaletteGroupBar.OnPreRender(EventArgs e)
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   --- End of inner exception stack trace ---
   at System.Web.UI.Page.HandleError(Exception e)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   at System.Web.UI.Page.ProcessRequest()
   at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
   at System.Web.UI.Page.ProcessRequest(HttpContext context)
   at ASP.design_designpage_aspx.ProcessRequest(HttpContext context)
   at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

2019-02-28 09:22:42:309 - Realisable.Data.Transform.ReaderReadException: An error occurred whilst reading the source data. Error - Error [ProtocolError]: [The remote server returned an error: (400) Bad Request.]. [{"errors":"Invalid request parameters"}]. ---> Realisable.Connectors.Shopify.ShopifyException: Error [ProtocolError]: [The remote server returned an error: (400) Bad Request.]. [{"errors":"Invalid request parameters"}] ---> System.Net.WebException: The remote server returned an error: (400) Bad Request.
   at System.Net.HttpWebRequest.GetResponse()
   at Realisable.Utils.HttpClient.HttpClient.Execute(String method, String apiUrl, Dictionary`2 headers, Byte[] contentBody, Int32 retries)
   at Realisable.Utils.HttpClient.HttpClient.Execute(String method, String apiUrl, Dictionary`2 headers, Int32 retries)
   at Realisable.Utils.HttpClient.HttpClient.Get(String apiUrl, Dictionary`2 headers)
   at Realisable.Connectors.Shopify.ShopifyClient.<>c__DisplayClass13_0.<ProcessPullRequest>b__0()
   at Realisable.Connectors.Shopify.ShopifyClient.ProcessRequest(Func`1 request, String url)
   at Realisable.Connectors.Shopify.ShopifyClient.ProcessPullRequest(String urlPath)
   --- End of inner exception stack trace ---
   at Realisable.Connectors.Shopify.ShopifyClient.ProcessPullRequest(String urlPath)
   at Realisable.Connectors.Shopify.ShopifyIOControllerAdapter.RetrieveData()
   at Realisable.Connectors.Shopify.ShopifyIOControllerAdapter..ctor(TransformDefinition tfmDef, PropertyHelper controller, Boolean testMode, SystemConnectorDTO system)
   at Realisable.Connectors.Shopify.PullDataInterop.Initialise(TransformDefinition transformDef, Boolean testMode, SystemConnectorDTO system)
   at Realisable.Data.Transform.ReadStrategyCustomReader.ProcessSingleSource(BlockingQueue`1 transactionQueue, String systemId)
   at Realisable.Data.Transform.ReadStrategyCustomReader.<>c__DisplayClass6_0.<ReadData>b__0(String systemId)
   at System.Collections.Generic.List`1.ForEach(Action`1 action)
   at Realisable.Data.Transform.ReadStrategyCustomReader.ReadData(BlockingQueue`1 transactionQueue)
   at Realisable.Data.Transform.ReadStrategy.ReadData()
   --- End of inner exception stack trace ---
   at Realisable.Data.Transform.ReadStrategy.Read()
   at Realisable.Data.Transform.TransformRead.Process()
   at Realisable.Data.Transform.TransformControllerInterop.Process()
An error occurred whilst reading the source data. Error - Error [ProtocolError]: [The remote server returned an error: (400) Bad Request.]. [{"errors":"Invalid request parameters"}]. 
  Time='02/28/19 09:22:42' App='IManEngine:3.2.100' ADO-version='6.3' Computer='GGG-IMANN' 
  Method: TransformControllerInterop.PerformTransform 
  Number: -2146233088 = &H80131500 = vbObjectError + 988416 = ERRMAP_APP_FIRST + 983218 
  Source: Realisable.Data.Transform 
  Description: An error occurred whilst reading the source data. Error - Error [ProtocolError]: [The remote server returned an error: (400) Bad Request.]. [{"errors":"Invalid request parameters"}].
  Call Stack: TransformControllerInterop.PerformTransform() ----------------------------------------
    Env: sFileStorePath={Text},  bPassDataAsString=False
    Value Of sFileStorePath:
      'C:\IMan\Debug\GGG Shopify Order Post To Sage 300 v1-6'
  Call Stack: TransformControllerInterop.ITransformController_Process() ----------------------------
  Call Stack: TransformCoordinator.RunTransform(sTransformId='EUQIGUCT') ---------------------------
    Env: eTransformType=1,  bWriteSummaries=False,  bSummariesHandled=False
  Call Stack: TransformCoordinator.RunTransformStream(sParentTransform='') -------------------------
    Env: sTransformId='EUQIGUCT', l=0,  m=0
  Call Stack: TransformCoordinator.Process() -------------------------------------------------------
  Call Stack: IntManEng.Main() ---------------------------------------------------------------------
    Env: sCmd={Text}
    Value Of sCmd:
      '"GGG Shopify Order Post To Sage 300 v1"'



Path does not exist [c:\iman\exports] 
  Time='02/28/19 09:24:04' App='IManEngine:3.2.100' ADO-version='6.3' Computer='GGG-IMANN' 
  Method: FileSystemWrapper.GetMatchingFiles 
  Number: 8501 = &H2135 = vbObjectError + 2147230005 = ERRMAP_APP_FIRST + 2147224807 
  Source: HuntERR.Check 
  Description: Path does not exist [c:\iman\exports]
  Call Stack: FileSystemWrapper.GetMatchingFiles(sPath='c:\iman\exports\shopifytestorders.csv') ----
    Env: sParent='c:\iman\exports',  sFilter='shopifytestorders.csv'
  Call Stack: FileIOController.GetFiles() ----------------------------------------------------------
    Env: sPath ='c:\iman\exports\shopifytestorders.csv'
  Call Stack: FileIOController.IInputOutputController_Initialise() ---------------------------------
  Call Stack: TransformWrite.CreateController() ----------------------------------------------------
    Env: eControllerType=1
  Call Stack: TransformWrite.ITransformController_CreateController() -------------------------------
  Call Stack: TransformCoordinator.RunTransform(sTransformId='YSOIZBXN') ---------------------------
    Env: eTransformType=2,  bWriteSummaries=False,  bSummariesHandled=False
  Call Stack: TransformCoordinator.RunTransformStream(sParentTransform='') -------------------------
    Env: sTransformId='YSOIZBXN', l=0,  m=0
  Call Stack: TransformCoordinator.Process() -------------------------------------------------------
  Call Stack: IntManEng.Main() ---------------------------------------------------------------------
    Env: sCmd={Text}
    Value Of sCmd:
      '"GGG Shopify Order Post To Sage 300 v1"'




2019-03-06 09:29:13:351 - System.Web.HttpUnhandledException: Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.InvalidCastException: Unable to cast object of type 'System.Int64' to type 'System.String'.
   at System.Data.SqlClient.SqlBuffer.get_String()
   at System.Data.SqlClient.SqlDataReader.GetString(Int32 i)
   at Realisable.Membership.RealisableMembershipProvider.GetUserFromReader(SqlDataReader reader)
   at Realisable.Membership.RealisableMembershipProvider.GetUser(String username, Boolean userIsOnline)
   at System.Web.Security.Membership.GetUser(String username, Boolean userIsOnline)
   at System.Web.Security.Membership.GetUser()
   at Realisable.IManWebUI.IntManAdmin.AuthorisePageOptionsAndRedirect()
   at Realisable.IManWebUI.IntManAdmin.OnInit(EventArgs e)
   at System.Web.UI.Control.InitRecursive(Control namingContainer)
   at System.Web.UI.Control.InitRecursive(Control namingContainer)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   --- End of inner exception stack trace ---
   at System.Web.UI.Page.HandleError(Exception e)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   at System.Web.UI.Page.ProcessRequest()
   at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
   at System.Web.UI.Page.ProcessRequest(HttpContext context)
   at ASP.design_designpage_aspx.ProcessRequest(HttpContext context)
   at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

2019-03-06 09:29:13:387 - NHibernate.Exceptions.GenericADOException: could not execute query
[ select cast(count(*) as INT) as col_0_0_ from MONITOR monitorent0_ where monitorent0_.JOB_ID=@p0 ]
  Name:p1 - Value:GGG Shopify Order Post To Sage 300 v1
[SQL: select cast(count(*) as INT) as col_0_0_ from MONITOR monitorent0_ where monitorent0_.JOB_ID=@p0] ---> System.IndexOutOfRangeException: col_0_0_
   at System.Data.ProviderBase.FieldNameLookup.GetOrdinal(String fieldName)
   at System.Data.SqlClient.SqlDataReader.GetOrdinal(String name)
   at NHibernate.Driver.NHybridDataReader.GetOrdinal(String name)
   at NHibernate.Type.NullableType.NullSafeGet(IDataReader rs, String name)
   at NHibernate.Type.NullableType.NullSafeGet(IDataReader rs, String[] names, ISessionImplementor session, Object owner)
   at NHibernate.Hql.Ast.ANTLR.Loader.QueryLoader.GetResultColumnOrRow(Object[] row, IResultTransformer resultTransformer, IDataReader rs, ISessionImplementor session)
   at NHibernate.Loader.Loader.GetRowFromResultSet(IDataReader resultSet, ISessionImplementor session, QueryParameters queryParameters, LockMode[] lockModeArray, EntityKey optionalObjectKey, IList hydratedObjects, EntityKey[] keys, Boolean returnProxies)
   at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies)
   at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies)
   at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters)
   --- End of inner exception stack trace ---
   at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters)
   at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters)
   at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces, IType[] resultTypes)
   at NHibernate.Hql.Ast.ANTLR.Loader.QueryLoader.List(ISessionImplementor session, QueryParameters queryParameters)
   at NHibernate.Hql.Ast.ANTLR.QueryTranslatorImpl.List(ISessionImplementor session, QueryParameters queryParameters)
   at NHibernate.Engine.Query.HQLQueryPlan.PerformList(QueryParameters queryParameters, ISessionImplementor session, IList results)
   at NHibernate.Impl.SessionImpl.List(IQueryExpression queryExpression, QueryParameters queryParameters, IList results)
   at NHibernate.Impl.AbstractSessionImpl.List(IQueryExpression queryExpression, QueryParameters parameters)
   at NHibernate.Impl.ExpressionQueryImpl.List()
   at NHibernate.Linq.NhQueryProvider.ExecuteQuery(NhLinqExpression nhLinqExpression, IQuery query, NhLinqExpression nhQuery)
   at NHibernate.Linq.NhQueryProvider.Execute(Expression expression)
   at NHibernate.Linq.NhQueryProvider.Execute[TResult](Expression expression)
   at System.Linq.Queryable.Count[TSource](IQueryable`1 source)
   at Realisable.JobDefinition.JobDefinition.get_HasMonitor()
   at Realisable.JobDefinition.JobDefinitionLoader.OpenJobDefinition(String jobId, JobDefinitionOpenFileType openType)
   at Realisable.JobDefinition.JobDefinitionLoader.IsModified(JobDefinition jobDefinition)
   at Realisable.JobDefinition.JobDefinitionLoader.AutoSaveDefinition(JobDefinition jobDef)
   at Realisable.IManWebUI.AutoSaver.Timer_Elapsed(Object sender, ElapsedEventArgs e)

2019-03-06 09:29:19:043 - System.Web.HttpUnhandledException: Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.InvalidCastException: Unable to cast object of type 'System.Int64' to type 'System.String'.
   at System.Data.SqlClient.SqlBuffer.get_String()
   at System.Data.SqlClient.SqlDataReader.GetString(Int32 i)
   at Realisable.Membership.RealisableMembershipProvider.GetUserFromReader(SqlDataReader reader)
   at Realisable.Membership.RealisableMembershipProvider.GetUser(String username, Boolean userIsOnline)
   at System.Web.Security.Membership.GetUser(String username, Boolean userIsOnline)
   at System.Web.Security.Membership.GetUser()
   at Realisable.IManWebUI.IntManAdmin.AuthorisePageOptionsAndRedirect()
   at Realisable.IManWebUI.IntManAdmin.OnInit(EventArgs e)
   at System.Web.UI.Control.InitRecursive(Control namingContainer)
   at System.Web.UI.Control.InitRecursive(Control namingContainer)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   --- End of inner exception stack trace ---
   at System.Web.UI.Page.HandleError(Exception e)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   at System.Web.UI.Page.ProcessRequest()
   at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
   at System.Web.UI.Page.ProcessRequest(HttpContext context)
   at ASP.design_designpage_aspx.ProcessRequest(HttpContext context)
   at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

2019-03-06 09:29:22:597 - System.Web.HttpUnhandledException: Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.InvalidCastException: Unable to cast object of type 'System.Int64' to type 'System.String'.
   at System.Data.SqlClient.SqlBuffer.get_String()
   at System.Data.SqlClient.SqlDataReader.GetString(Int32 i)
   at Realisable.Membership.RealisableMembershipProvider.GetUserFromReader(SqlDataReader reader)
   at Realisable.Membership.RealisableMembershipProvider.GetUser(String username, Boolean userIsOnline)
   at System.Web.Security.Membership.GetUser(String username, Boolean userIsOnline)
   at System.Web.Security.Membership.GetUser()
   at Realisable.IManWebUI.IntManAdmin.AuthorisePageOptionsAndRedirect()
   at Realisable.IManWebUI.IntManAdmin.OnInit(EventArgs e)
   at System.Web.UI.Control.InitRecursive(Control namingContainer)
   at System.Web.UI.Control.InitRecursive(Control namingContainer)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   --- End of inner exception stack trace ---
   at System.Web.UI.Page.HandleError(Exception e)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   at System.Web.UI.Page.ProcessRequest()
   at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
   at System.Web.UI.Page.ProcessRequest(HttpContext context)
   at ASP.design_designpage_aspx.ProcessRequest(HttpContext context)
   at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

2019-03-06 09:29:45:397 - System.Web.HttpUnhandledException: Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.InvalidCastException: Unable to cast object of type 'System.Int64' to type 'System.String'.
   at System.Data.SqlClient.SqlBuffer.get_String()
   at System.Data.SqlClient.SqlDataReader.GetString(Int32 i)
   at Realisable.Membership.RealisableMembershipProvider.GetUserFromReader(SqlDataReader reader)
   at Realisable.Membership.RealisableMembershipProvider.GetUser(String username, Boolean userIsOnline)
   at System.Web.Security.Membership.GetUser(String username, Boolean userIsOnline)
   at System.Web.Security.Membership.GetUser()
   at Realisable.IManWebUI.IntManAdmin.AuthorisePageOptionsAndRedirect()
   at Realisable.IManWebUI.IntManAdmin.OnInit(EventArgs e)
   at System.Web.UI.Control.InitRecursive(Control namingContainer)
   at System.Web.UI.Control.InitRecursive(Control namingContainer)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   --- End of inner exception stack trace ---
   at System.Web.UI.Page.HandleError(Exception e)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   at System.Web.UI.Page.ProcessRequest()
   at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
   at System.Web.UI.Page.ProcessRequest(HttpContext context)
   at ASP.design_designpage_aspx.ProcessRequest(HttpContext context)
   at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

2019-03-06 09:30:38:400 - System.Web.HttpUnhandledException: Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.InvalidCastException: Unable to cast object of type 'System.Int64' to type 'System.String'.
   at System.Data.SqlClient.SqlBuffer.get_String()
   at System.Data.SqlClient.SqlDataReader.GetString(Int32 i)
   at Realisable.Membership.RealisableMembershipProvider.GetUserFromReader(SqlDataReader reader)
   at Realisable.Membership.RealisableMembershipProvider.GetUser(String username, Boolean userIsOnline)
   at System.Web.Security.Membership.GetUser(String username, Boolean userIsOnline)
   at System.Web.Security.Membership.GetUser()
   at Realisable.IManWebUI.IntManAdmin.AuthorisePageOptionsAndRedirect()
   at Realisable.IManWebUI.IntManAdmin.OnInit(EventArgs e)
   at System.Web.UI.Control.InitRecursive(Control namingContainer)
   at System.Web.UI.Control.InitRecursive(Control namingContainer)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   --- End of inner exception stack trace ---
   at System.Web.UI.Page.HandleError(Exception e)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   at System.Web.UI.Page.ProcessRequest()
   at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
   at System.Web.UI.Page.ProcessRequest(HttpContext context)
   at ASP.design_designpage_aspx.ProcessRequest(HttpContext context)
   at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

2019-03-06 09:32:15:575 - System.Web.HttpUnhandledException: Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.InvalidCastException: Unable to cast object of type 'System.Int64' to type 'System.String'.
   at System.Data.SqlClient.SqlBuffer.get_String()
   at System.Data.SqlClient.SqlDataReader.GetString(Int32 i)
   at Realisable.Membership.RealisableMembershipProvider.GetUserFromReader(SqlDataReader reader)
   at Realisable.Membership.RealisableMembershipProvider.GetUser(String username, Boolean userIsOnline)
   at System.Web.Security.Membership.GetUser(String username, Boolean userIsOnline)
   at System.Web.Security.Membership.GetUser()
   at Realisable.IManWebUI.IntManAdmin.AuthorisePageOptionsAndRedirect()
   at Realisable.IManWebUI.IntManAdmin.OnInit(EventArgs e)
   at System.Web.UI.Control.InitRecursive(Control namingContainer)
   at System.Web.UI.Control.InitRecursive(Control namingContainer)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   --- End of inner exception stack trace ---
   at System.Web.UI.Page.HandleError(Exception e)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   at System.Web.UI.Page.ProcessRequest()
   at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
   at System.Web.UI.Page.ProcessRequest(HttpContext context)
   at ASP.design_designpage_aspx.ProcessRequest(HttpContext context)
   at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

2019-03-06 10:24:36:430 - Realisable.Utils.OM.NoMatchingEntityException: No matching Lookup entity for [300OrderNo].
   at Realisable.Utils.OM.HibernateQuery.Retrieve[T](ISessionBuilder builder, Object entityId, Boolean throwNoRetrieve, String noRetrieveExceptionMsg)
   at Realisable.Functions.Lookup.LookupFactory.GetLookupReader(String lookupId)
   at Realisable.Data.Transform.FunctionInterop.Lookup(String lookupId, String[]& returnField, String[]& whereVals, String whereClauseOverride, Boolean mustReturnValue, String[]& connectionContext)
Accpac API Error 1020 - Value WEB for Orders does not exist for optional field ORDBY. 
  Time='03/06/19 10:48:44' App='IManEngine:3.2.100' ADO-version='6.3' Computer='GGG-IMANN' 
  Method: ViewWrapper.ErrorHandler 
  Number: 11022 = &H2B0E = vbObjectError + 2147232526 = ERRMAP_APP_FIRST + 2147227328 
  Source: ViewWrapper.AccpacAPI 
  Description: Accpac API Error 1020 - Value WEB for Orders does not exist for optional field ORDBY.
  Call Stack: ViewWrapper.ErrorHandler() -----------------------------------------------------------
    Env: l=1,  lColErrCnt=0,  lCount=0,  eAccpacError=1020,  bRaiseError=True,  bHasWarning=True
  Call Stack: ViewWrapper.SetOptionalField(sOptFieldId='OE0520',  sFldPfx='',  sValFld='VALUE') ----
    Env: sOptFieldViewID='OE0522',  l=2,  lColPtr=4,  bUpdate=True
  Call Stack: AccpacOEOrder.CreateOrder() ----------------------------------------------------------
    Env: l=6,  s='5',  bCalcTax=True,  bJobRelated=False
  Call Stack: AccpacOEOrder.AccpacImport_CreateTransactions() --------------------------------------
  Call Stack: TransformAccpac.PerformTransform() ---------------------------------------------------
  Call Stack: TransformAccpac.ITransformController_Process() ---------------------------------------
    Env: sCompany='',  l=1,  bSupportsDynamicCompanies=False
  Call Stack: TransformCoordinator.RunTransform(sTransformId='HOLORD_SAGE1') -----------------------
    Env: eTransformType=90,  bWriteSummaries=False,  bSummariesHandled=False
  Call Stack: TransformCoordinator.RunTransformStream(sParentTransform='') -------------------------
    Env: sTransformId='HOLORD_SAGE1', l=0,  m=0
  Call Stack: TransformCoordinator.Process() -------------------------------------------------------
  Call Stack: IntManEng.Main() ---------------------------------------------------------------------
    Env: sCmd={Text}
    Value Of sCmd:
      '"GGG Shopify Order Post To Sage 300 v1"'




2019-03-11 07:49:23:416 - System.Web.HttpUnhandledException: Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
   at System.Collections.ArrayList.get_Item(Int32 index)
   at Syncfusion.Windows.Forms.Diagram.SymbolPalette.SetIcons(Node node, Int32 insertIndex)
   at Syncfusion.Windows.Forms.Diagram.SymbolPalette.RecreateIcons()
   at Syncfusion.Web.UI.WebControls.Diagram.PaletteGroupBar.OnPreRender(EventArgs e)
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   --- End of inner exception stack trace ---
   at System.Web.UI.Page.HandleError(Exception e)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   at System.Web.UI.Page.ProcessRequest()
   at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
   at System.Web.UI.Page.ProcessRequest(HttpContext context)
   at ASP.design_designpage_aspx.ProcessRequest(HttpContext context)
   at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

2019-03-11 07:51:12:304 - System.Web.HttpUnhandledException: Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
   at System.Collections.ArrayList.get_Item(Int32 index)
   at Syncfusion.Windows.Forms.Diagram.SymbolPalette.SetIcons(Node node, Int32 insertIndex)
   at Syncfusion.Windows.Forms.Diagram.SymbolPalette.RecreateIcons()
   at Syncfusion.Web.UI.WebControls.Diagram.PaletteGroupBar.OnPreRender(EventArgs e)
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   --- End of inner exception stack trace ---
   at System.Web.UI.Page.HandleError(Exception e)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   at System.Web.UI.Page.ProcessRequest()
   at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
   at System.Web.UI.Page.ProcessRequest(HttpContext context)
   at ASP.design_designpage_aspx.ProcessRequest(HttpContext context)
   at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

2019-03-11 07:51:14:263 - System.Web.HttpUnhandledException: Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
   at System.Collections.ArrayList.get_Item(Int32 index)
   at Syncfusion.Windows.Forms.Diagram.SymbolPalette.SetIcons(Node node, Int32 insertIndex)
   at Syncfusion.Windows.Forms.Diagram.SymbolPalette.RecreateIcons()
   at Syncfusion.Web.UI.WebControls.Diagram.PaletteGroupBar.OnPreRender(EventArgs e)
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   --- End of inner exception stack trace ---
   at System.Web.UI.Page.HandleError(Exception e)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   at System.Web.UI.Page.ProcessRequest()
   at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
   at System.Web.UI.Page.ProcessRequest(HttpContext context)
   at ASP.design_designpage_aspx.ProcessRequest(HttpContext context)
   at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

2019-03-11 07:51:22:052 - System.Web.HttpUnhandledException: Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
   at System.Collections.ArrayList.get_Item(Int32 index)
   at Syncfusion.Windows.Forms.Diagram.SymbolPalette.SetIcons(Node node, Int32 insertIndex)
   at Syncfusion.Windows.Forms.Diagram.SymbolPalette.RecreateIcons()
   at Syncfusion.Web.UI.WebControls.Diagram.PaletteGroupBar.OnPreRender(EventArgs e)
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   --- End of inner exception stack trace ---
   at System.Web.UI.Page.HandleError(Exception e)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   at System.Web.UI.Page.ProcessRequest()
   at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
   at System.Web.UI.Page.ProcessRequest(HttpContext context)
   at ASP.design_designpage_aspx.ProcessRequest(HttpContext context)
   at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)