2019-07-23 02:51 PM DEBUG AOIntegrator.Program thread:1 - Opening the configuration file [C:\Users\admin\AppData\Roaming\NumberCruncher/All Orders Integrator/Config.xml].
2019-07-23 02:51 PM DEBUG AOIntegrator.Program thread:1 - The length of the filestream for the config file is [141615].
2019-07-23 02:51 PM INFO  AOIntegrator.GUI thread:1 - **************************************************************************************************
2019-07-23 02:51 PM DEBUG AOIntegrator.Program thread:1 - Opening the configuration file [C:\Users\admin\AppData\Roaming\NumberCruncher/All Orders Integrator/Config.xml].
2019-07-23 02:51 PM DEBUG AOIntegrator.Program thread:1 - The length of the filestream for the config file is [141615].
2019-07-23 02:51 PM DEBUG AOIntegrator.AORepository thread:1 - Logging in again...
2019-07-23 02:51 PM DEBUG AOIntegrator.AORepository thread:1 - Opening the company file 'E:\Microsoft SQL Server\AllOrders SQL Database\Allorders.ncd' for this integration.
2019-07-23 02:51 PM DEBUG AOIntegrator.AORepository thread:1 - Setting the connection string.
2019-07-23 02:51 PM DEBUG AOIntegrator.Program thread:1 - Opening the configuration file [C:\Users\admin\AppData\Roaming\NumberCruncher/All Orders Integrator/Config.xml].
2019-07-23 02:51 PM DEBUG AOIntegrator.Program thread:1 - The length of the filestream for the config file is [141615].
2019-07-23 02:51 PM DEBUG AOIntegrator.Bindings thread:5 - Setting up Ninject with the cartname [WooCommerce].
2019-07-23 02:51 PM DEBUG AOIntegrator.AORepository thread:5 - Initializing the AO Repository
2019-07-23 02:51 PM DEBUG AOIntegrator.AORepository thread:5 - The user is [Admin].
2019-07-23 02:51 PM DEBUG AOIntegrator.AORepository thread:5 - The company file is [E:\Microsoft SQL Server\AllOrders SQL Database\Allorders.ncd].
2019-07-23 02:51 PM DEBUG AOIntegrator.AORepository thread:5 - Opening the company file 'E:\Microsoft SQL Server\AllOrders SQL Database\Allorders.ncd' for this integration.
2019-07-23 02:51 PM DEBUG AOIntegrator.AORepository thread:5 - Setting the connection string.
2019-07-23 02:51 PM DEBUG AOIntegrator.Conductor thread:5 - Beginning the integration....
2019-07-23 02:51 PM DEBUG AOIntegrator.Bindings thread:5 - Setting up Ninject with the cartname [WooCommerce].
2019-07-23 02:51 PM DEBUG AOIntegrator.AORepository thread:5 - Initializing the AO Repository
2019-07-23 02:51 PM DEBUG AOIntegrator.AORepository thread:5 - The user is [Admin].
2019-07-23 02:51 PM DEBUG AOIntegrator.AORepository thread:5 - The company file is [E:\Microsoft SQL Server\AllOrders SQL Database\Allorders.ncd].
2019-07-23 02:51 PM DEBUG AOIntegrator.AORepository thread:5 - Opening the company file 'E:\Microsoft SQL Server\AllOrders SQL Database\Allorders.ncd' for this integration.
2019-07-23 02:51 PM DEBUG AOIntegrator.AORepository thread:5 - Setting the connection string.
2019-07-23 02:51 PM DEBUG AOIntegrator.Carts.WooCommerce.APIWrapper thread:5 - Appending Paremeter Key status
2019-07-23 02:51 PM DEBUG AOIntegrator.GUI thread:1 - Importing sales orders
2019-07-23 02:51 PM DEBUG AOIntegrator.Carts.WooCommerce.APIWrapper thread:5 - Appending Paremeter Value completed
2019-07-23 02:51 PM DEBUG AOIntegrator.Carts.WooCommerce.APIWrapper thread:5 - Appending Paremeter Key filter[created_at_min]
2019-07-23 02:51 PM DEBUG AOIntegrator.Carts.WooCommerce.APIWrapper thread:5 - Appending Paremeter Value 2019-07-23
2019-07-23 02:51 PM DEBUG AOIntegrator.Carts.WooCommerce.APIWrapper thread:5 - Appending Paremeter Key filter[created_at_max]
2019-07-23 02:51 PM DEBUG AOIntegrator.Carts.WooCommerce.APIWrapper thread:5 - Appending Paremeter Value 2019-07-25
2019-07-23 02:51 PM DEBUG AOIntegrator.Carts.WooCommerce.APIWrapper thread:5 - Appending Paremeter Key page
2019-07-23 02:51 PM DEBUG AOIntegrator.Carts.WooCommerce.APIWrapper thread:5 - Appending Paremeter Value 1
2019-07-23 02:51 PM DEBUG AOIntegrator.Carts.WooCommerce.APIWrapper thread:5 - Performing Substring on String Builder with 4 parameters : &status=completed&filter%5bcreated_at_min%5d=2019-07-23&filter%5bcreated_at_max%5d=2019-07-25&page=1
2019-07-23 02:51 PM ERROR AOIntegrator.Conductor thread:5 - System.ArgumentException: Invalid JSON primitive: .
   at System.Web.Script.Serialization.JavaScriptObjectDeserializer.DeserializePrimitiveObject()
   at System.Web.Script.Serialization.JavaScriptObjectDeserializer.DeserializeInternal(Int32 depth)
   at System.Web.Script.Serialization.JavaScriptObjectDeserializer.BasicDeserialize(String input, Int32 depthLimit, JavaScriptSerializer serializer)
   at System.Web.Script.Serialization.JavaScriptSerializer.Deserialize(JavaScriptSerializer serializer, String input, Type type, Int32 depthLimit)
   at System.Web.Script.Serialization.JavaScriptSerializer.Deserialize[T](String input)
   at AOIntegrator.Carts.WooCommerce.APIWrapper.GetAllOrders(DateTime dtStart, DateTime dtEnd)
   at AOIntegrator.Carts.WooCommerce.Cart.GetSalesOrders(BackgroundWorker worker)
   at AOIntegrator.Conductor.ImportSalesOrders(BackgroundWorker worker, Int32 iCartIndex)
   at AOIntegrator.Conductor.Conduct(BackgroundWorker worker, String sStoreURL)
2019-07-23 02:51 PM DEBUG AOIntegrator.Program thread:1 - Opening the configuration file [C:\Users\admin\AppData\Roaming\NumberCruncher/All Orders Integrator/Config.xml].
2019-07-23 02:51 PM DEBUG AOIntegrator.Program thread:1 - The length of the filestream for the config file is [141615].
2019-07-23 02:51 PM DEBUG AOLib.SQLHelper thread:1 - The following sql is about to be run from ExecScalar [SELECT CASE WHEN Count(Object_id) > 0 THEN 1 ELSE 0 END FROM sys.Objects WHERE Object_id = OBJECT_ID(N'dbo.tblPriceLevel') AND Type = N'U'] with no parameters.
2019-07-23 02:51 PM DEBUG AOLib.SQLHelper thread:1 - The following sql is about to be run from GetDataSet [SELECT  [Name] FROM [tblPriceLevel] WHERE  [Name] <> '']