[GDCBDE][2018-06-27 12:27:10] [SQLHLP] INIT [AZURE SQL HELPER v1.3.3]
[GDCBDE][2018-06-27 12:27:10] [SQLHLP] Using data folder:...www/html/api/_godrive_data/db_cache
[GDCBDE][2018-06-27 12:27:10] [SQLHLP] ODBC Conn: DRIVER={ODBC Driver 13 for SQL Serv...
[GDCBDE][2018-06-27 12:27:10] [SQLHLP] Connection created on carbox.database.windows.net
[GDCBDE][2018-06-27 12:27:10] LOGfile: /var/www/html/api/_godrive_dat
[GDCBDE][2018-06-27 12:27:10] Work folder: [/var/www/html/api/_godrive_data]
[GDCBDE][2018-06-27 12:27:10] INIT DATA EXPLORER v0.1.1
[GDCBDE][2018-06-27 12:27:10] Setup predictors and raw data repo...
[GDCBDE][2018-06-27 12:27:10] [SQLHLP] Loading file [..ata/db_cache/SELECT_FROM_Codes_.csv] ...
[GDCBDE][2018-06-27 12:27:10] [SQLHLP] Dataset loaded: 0.01MB in 0.0s(0.0m) 134 rows
[GDCBDE][2018-06-27 12:27:10] Loaded 134 predictors
[GDCBDE][2018-06-27 12:27:10] [SQLHLP] Downloading data [SELECT TOP (1) * FROM [RawData..] ...
[GDCBDE][2018-06-27 12:27:10] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows
[GDCBDE][2018-06-27 12:27:10] RawData: ['CarID', 'CodeID', 'StrValue', 'Value', 'ViewVal', 'ViewStr', 'TimeStamp', 'DeviceSN']
[GDCBDE][2018-06-27 12:27:10] [SQLHLP] Loading file [..data/db_cache/SELECT_FROM_Cars_.csv] ...
[GDCBDE][2018-06-27 12:27:10] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 56 rows
[GDCBDE][2018-06-27 12:27:10] Loaded 56 cars
[GDCBDE][2018-06-27 12:27:10] [SQLHLP] Loading file [..a/db_cache/SELECT_FROM_RawData_.csv] ...
[GDCBDE][2018-06-27 12:27:11] [SQLHLP] Dataset loaded: 1.07MB in 0.1s(0.0m) 17504 rows
[GDCBDE][2018-06-27 12:27:11] Rawdata copy: ['ID', 'CarID', 'CodeID', 'StrValue', 'Value', 'ViewVal', 'ViewStr', 'TimeStamp']
[GDCBDE][2018-06-27 12:27:11] [SQLHLP] Loading file [../db_cache/SELECT_FROM_Accounts_.csv] ...
[GDCBDE][2018-06-27 12:27:11] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 3 rows
[GDCBDE][2018-06-27 12:27:11] Loaded 3 accounts
[GDCBDE][2018-06-27 12:27:11] [SQLHLP] Downloading data [SELECT c.ID Masina, f.Name Flo..] ...
[GDCBDE][2018-06-27 12:27:11] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 60 rows
[GDCBDE][2018-06-27 12:27:11] CarsxAccounts copy: ['Masina', 'Flota', 'FlotaID']
[GDCBDE][2018-06-27 12:27:11] Done data preparation.
[GDCBDE][2018-06-27 12:27:11] [SQLHLP] Downloading data [SELECT * FROM [RawData]..] ...
[GDCBDE][2018-06-27 12:28:04] [SQLHLP] Dataset loaded: 85.40MB in 52.9s(0.9m) 1243708 rows
[GDCBDE][2018-06-27 12:28:04] [SQLHLP] Downloading data [SELECT * FROM [Accounts]..] ...
[GDCBDE][2018-06-27 12:28:04] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 3 rows
[GDCBDE][2018-06-27 12:28:04] [SQLHLP] Downloading data [SELECT * FROM [Cars]..] ...
[GDCBDE][2018-06-27 12:28:04] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 60 rows
[GDCBDE][2018-06-27 12:28:04] [SQLHLP] Downloading data [SELECT * FROM [Codes]..] ...
[GDCBDE][2018-06-27 12:28:04] [SQLHLP] Dataset loaded: 0.01MB in 0.1s(0.0m) 134 rows
[GDCBDE][2018-06-27 12:28:04] [SQLHLP] Downloading data [SELECT * FROM [CarsXCodes_v2]..] ...
[GDCBDE][2018-06-27 12:28:04] [SQLHLP] Dataset loaded: 0.02MB in 0.1s(0.0m) 519 rows
[GDCBDE][2018-06-27 12:28:04] ....Trying to associate code and description columns to df_rawdata_toshow
[GDCBDE][2018-06-27 12:28:04] Finished associating columns
[GDCBDE][2018-06-27 12:28:17] [SQLHLP] Downloading data [SELECT ID FROM Users WHERE Adr..] ...
[GDCBDE][2018-06-27 12:28:17] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows
[GDCBDE][2018-06-27 12:28:17] [SQLHLP] Downloading data [SELECT * FROM Users WHERE ID =..] ...
[GDCBDE][2018-06-27 12:28:17] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows
[GDCBDE][2018-06-27 12:28:17] [SQLHLP] Downloading data [SELECT * FROM [Accounts]..] ...
[GDCBDE][2018-06-27 12:28:17] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 3 rows
[GDCBDE][2018-06-27 12:28:22] [SQLHLP] Downloading data [SELECT TOP (1) * FROM [Users]..] ...
[GDCBDE][2018-06-27 12:28:22] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows
[GDCBDE][2018-06-27 12:28:22] [SQLHLP] Downloading data [SELECT * FROM [Users]..] ...
[GDCBDE][2018-06-27 12:28:22] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 5 rows
[GDCBDE][2018-06-27 12:32:57] [SQLHLP] Downloading data [SELECT TOP (1) * FROM [Users]..] ...
[GDCBDE][2018-06-27 12:32:57] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 1 rows
[GDCBDE][2018-06-27 12:32:57] [SQLHLP] Downloading data [SELECT * FROM [Users]..] ...
[GDCBDE][2018-06-27 12:32:57] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 5 rows
[GDCBDE][2018-06-27 12:33:16] [SQLHLP] Downloading data [SELECT TOP (1) * FROM [Users]..] ...
[GDCBDE][2018-06-27 12:33:16] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 1 rows
[GDCBDE][2018-06-27 12:33:16] [SQLHLP] Downloading data [SELECT * FROM [Users]..] ...
[GDCBDE][2018-06-27 12:33:16] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 5 rows
[GDCBDE][2018-06-27 12:33:40] [SQLHLP] Downloading data [SELECT TOP (1) * FROM [Users]..] ...
[GDCBDE][2018-06-27 12:33:40] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 1 rows
[GDCBDE][2018-06-27 12:33:40] [SQLHLP] Downloading data [SELECT * FROM [Users]..] ...
[GDCBDE][2018-06-27 12:33:41] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 5 rows
[GDCBDE][2018-06-27 12:34:03] [SQLHLP] Downloading data [SELECT ID FROM Users WHERE Adr..] ...
[GDCBDE][2018-06-27 12:34:03] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows
[GDCBDE][2018-06-27 12:34:03] [SQLHLP] Downloading data [SELECT * FROM Users WHERE ID =..] ...
[GDCBDE][2018-06-27 12:34:03] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows
[GDCBDE][2018-06-27 12:34:03] [SQLHLP] Downloading data [SELECT * FROM [Accounts]..] ...
[GDCBDE][2018-06-27 12:34:03] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 3 rows
[GDCBDE][2018-06-27 12:34:10] [SQLHLP] Downloading data [SELECT TOP (1) * FROM [Users]..] ...
[GDCBDE][2018-06-27 12:34:10] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows
[GDCBDE][2018-06-27 12:34:10] [SQLHLP] Downloading data [SELECT * FROM [Users]..] ...
[GDCBDE][2018-06-27 12:34:10] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 5 rows
[GDCBDE][2018-06-27 12:35:39] [SQLHLP] Downloading data [SELECT TOP (1) * FROM [Users]..] ...
[GDCBDE][2018-06-27 12:35:39] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 1 rows
[GDCBDE][2018-06-27 12:35:39] [SQLHLP] Downloading data [SELECT * FROM [Users]..] ...
[GDCBDE][2018-06-27 12:35:39] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 5 rows
[GDCBDE][2018-06-27 12:36:08] [SQLHLP] Downloading data [SELECT TOP (1) * FROM [Users]..] ...
[GDCBDE][2018-06-27 12:36:08] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 1 rows
[GDCBDE][2018-06-27 12:36:08] [SQLHLP] Downloading data [SELECT * FROM [Users]..] ...
[GDCBDE][2018-06-27 12:36:08] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 5 rows
[GDCBDE][2018-06-27 12:36:14] [SQLHLP] Downloading data [SELECT TOP (1) * FROM [Users]..] ...
[GDCBDE][2018-06-27 12:36:14] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 1 rows
[GDCBDE][2018-06-27 12:36:14] [SQLHLP] Downloading data [SELECT * FROM [Users]..] ...
[GDCBDE][2018-06-27 12:36:14] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 5 rows
[GDCBDE][2018-06-27 12:36:26] [SQLHLP] Downloading data [SELECT TOP (1) * FROM [Users]..] ...
[GDCBDE][2018-06-27 12:36:26] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows
[GDCBDE][2018-06-27 12:36:26] [SQLHLP] Downloading data [SELECT * FROM [Users]..] ...
[GDCBDE][2018-06-27 12:36:26] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 5 rows
[GDCBDE][2018-06-27 12:36:52] [SQLHLP] Downloading data [SELECT TOP (1) * FROM [Users]..] ...
[GDCBDE][2018-06-27 12:36:52] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 1 rows
[GDCBDE][2018-06-27 12:36:52] [SQLHLP] Downloading data [SELECT * FROM [Users]..] ...
[GDCBDE][2018-06-27 12:36:52] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 5 rows
[GDCBDE][2018-06-27 12:36:57] [SQLHLP] Downloading data [SELECT TOP (1) * FROM [Users]..] ...
[GDCBDE][2018-06-27 12:36:58] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows
[GDCBDE][2018-06-27 12:36:58] [SQLHLP] Downloading data [SELECT * FROM [Users]..] ...
[GDCBDE][2018-06-27 12:36:58] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 5 rows
[GDCBDE][2018-06-27 12:37:13] [SQLHLP] Downloading data [SELECT TOP (1) * FROM [Users]..] ...
[GDCBDE][2018-06-27 12:37:13] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows
[GDCBDE][2018-06-27 12:37:13] [SQLHLP] Downloading data [SELECT * FROM [Users]..] ...
[GDCBDE][2018-06-27 12:37:13] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 5 rows
[GDCBDE][2018-06-27 12:37:18] [SQLHLP] Downloading data [SELECT TOP (1) * FROM [Users]..] ...
[GDCBDE][2018-06-27 12:37:18] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows
[GDCBDE][2018-06-27 12:37:18] [SQLHLP] Downloading data [SELECT * FROM [Users]..] ...
[GDCBDE][2018-06-27 12:37:18] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 5 rows
[GDCBDE][2018-06-27 12:38:43] [SQLHLP] Downloading data [SELECT TOP (1) * FROM [Users]..] ...
[GDCBDE][2018-06-27 12:38:43] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 1 rows
[GDCBDE][2018-06-27 12:38:43] [SQLHLP] Downloading data [SELECT * FROM [Users]..] ...
[GDCBDE][2018-06-27 12:38:43] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 5 rows
[GDCBDE][2018-06-27 12:45:16] [SQLHLP] Downloading data [SELECT TOP (1) * FROM [Users]..] ...
[GDCBDE][2018-06-27 12:45:16] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 1 rows
[GDCBDE][2018-06-27 12:45:16] [SQLHLP] Downloading data [SELECT * FROM [Users]..] ...
[GDCBDE][2018-06-27 12:45:17] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 5 rows
[GDCBDE][2018-06-27 12:45:23] [SQLHLP] Downloading data [SELECT TOP (1) * FROM [Users]..] ...
[GDCBDE][2018-06-27 12:45:23] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows
[GDCBDE][2018-06-27 12:45:23] [SQLHLP] Downloading data [SELECT * FROM [Users]..] ...
[GDCBDE][2018-06-27 12:45:23] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 5 rows
[GDCBDE][2018-06-27 12:45:26] [SQLHLP] Downloading data [SELECT * FROM [Accounts]..] ...
[GDCBDE][2018-06-27 12:45:26] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 3 rows
[GDCBDE][2018-06-27 12:46:31] [SQLHLP] Downloading data [SELECT TOP (1) * FROM [Users]..] ...
[GDCBDE][2018-06-27 12:46:31] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 1 rows
[GDCBDE][2018-06-27 12:46:31] [SQLHLP] Downloading data [SELECT * FROM [Users]..] ...
[GDCBDE][2018-06-27 12:46:31] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 5 rows
[GDCBDE][2018-06-27 12:48:12] [SQLHLP] Downloading data [SELECT TOP (1) * FROM [Users]..] ...
[GDCBDE][2018-06-27 12:48:12] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 1 rows
[GDCBDE][2018-06-27 12:48:12] [SQLHLP] Downloading data [SELECT * FROM [Users]..] ...
[GDCBDE][2018-06-27 12:48:12] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 5 rows
[GDCBDE][2018-06-27 12:48:22] [SQLHLP] Downloading data [SELECT TOP (1) * FROM [Users]..] ...
[GDCBDE][2018-06-27 12:48:22] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows
[GDCBDE][2018-06-27 12:48:22] [SQLHLP] Downloading data [SELECT * FROM [Users]..] ...
[GDCBDE][2018-06-27 12:48:22] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 5 rows
[GDCBDE][2018-06-27 12:48:25] [SQLHLP] Downloading data [SELECT * FROM [Accounts]..] ...
[GDCBDE][2018-06-27 12:48:25] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 3 rows
[GDCBDE][2018-06-27 12:48:29] [SQLHLP] Downloading data [SELECT * FROM [Users]..] ...
[GDCBDE][2018-06-27 12:48:29] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 5 rows
[GDCBDE][2018-06-27 12:48:29] [SQLHLP] Downloading data [SELECT TOP (1) * FROM [Users]..] ...
[GDCBDE][2018-06-27 12:48:29] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows
[GDCBDE][2018-06-27 12:48:32] [SQLHLP] Downloading data [SELECT TOP (1) * FROM [Users]..] ...
[GDCBDE][2018-06-27 12:48:32] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows
[GDCBDE][2018-06-27 12:48:32] [SQLHLP] Downloading data [SELECT * FROM [Users]..] ...
[GDCBDE][2018-06-27 12:48:32] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 5 rows