[GDCBDE][2020-06-25 12:07:10] [SQLHLP] INIT [AZURE SQL HELPER v1.3.3]
[GDCBDE][2020-06-25 12:07:10] [SQLHLP] Using data folder:...www/html/api/_godrive_data/db_cache
[GDCBDE][2020-06-25 12:07:10] [SQLHLP] ODBC Conn try 1: DRIVER={ODBC Driver 17 for SQL Serv...
[GDCBDE][2020-06-25 12:07:10] [SQLHLP] Connection created on 37.251.139.87
[GDCBDE][2020-06-25 12:07:10] LOGfile: /var/www/html/api/_godrive_dat
[GDCBDE][2020-06-25 12:07:10] Work folder: [/var/www/html/api/_godrive_data]
[GDCBDE][2020-06-25 12:07:10] INIT DATA EXPLORER v0.1.1
[GDCBDE][2020-06-25 12:07:10] Setup predictors and raw data repo...
[GDCBDE][2020-06-25 12:07:10] [SQLHLP] Loading file [../SELECT_TOP_1000000_FROM_Codes_.csv] ...
[GDCBDE][2020-06-25 12:07:10] [SQLHLP] Dataset loaded: 0.01MB in 0.0s(0.0m) 134 rows
[GDCBDE][2020-06-25 12:07:10] Loaded 134 predictors
[GDCBDE][2020-06-25 12:07:10] [SQLHLP] Downloading data [SELECT TOP (1) * FROM [RawData..] ...
[GDCBDE][2020-06-25 12:07:10] [SQLHLP] Check connection
[GDCBDE][2020-06-25 12:07:10] [SQLHLP] Connection ok
[GDCBDE][2020-06-25 12:07:10] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows
[GDCBDE][2020-06-25 12:07:10] RawData: ['CarID', 'CodeID', 'StrValue', 'Value', 'ViewVal', 'ViewStr', 'TimeStamp', 'DeviceSN']
[GDCBDE][2020-06-25 12:07:10] [SQLHLP] Loading file [..e/SELECT_TOP_1000000_FROM_Cars_.csv] ...
[GDCBDE][2020-06-25 12:07:10] [SQLHLP] Dataset loaded: 0.01MB in 0.0s(0.0m) 118 rows
[GDCBDE][2020-06-25 12:07:10] Loaded 118 cars
[GDCBDE][2020-06-25 12:07:10] [SQLHLP] Loading file [..LECT_TOP_1000000_FROM_Accounts_.csv] ...
[GDCBDE][2020-06-25 12:07:10] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 3 rows
[GDCBDE][2020-06-25 12:07:10] Loaded 3 accounts
[GDCBDE][2020-06-25 12:07:10] [SQLHLP] Downloading data [SELECT c.ID Masina, f.Name Flo..] ...
[GDCBDE][2020-06-25 12:07:10] [SQLHLP] Check connection
[GDCBDE][2020-06-25 12:07:10] [SQLHLP] Connection ok
[GDCBDE][2020-06-25 12:07:10] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 118 rows
[GDCBDE][2020-06-25 12:07:10] CarsxAccounts copy: ['Masina', 'Flota', 'FlotaID']
[GDCBDE][2020-06-25 12:07:10] Done data preparation.
[GDCBDE][2020-06-25 12:07:10] [SQLHLP] Downloading data [SELECT TOP(1000000) * FROM [Ra..] ...
[GDCBDE][2020-06-25 12:07:10] [SQLHLP] Check connection
[GDCBDE][2020-06-25 12:07:10] [SQLHLP] Connection ok
[GDCBDE][2020-06-25 12:07:24] [SQLHLP] Dataset loaded: 68.66MB in 13.7s(0.2m) 1000000 rows
[GDCBDE][2020-06-25 12:07:24] [SQLHLP] Downloading data [SELECT TOP(1000000) * FROM [Ac..] ...
[GDCBDE][2020-06-25 12:07:24] [SQLHLP] Check connection
[GDCBDE][2020-06-25 12:07:24] [SQLHLP] Connection ok
[GDCBDE][2020-06-25 12:07:24] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 3 rows
[GDCBDE][2020-06-25 12:07:24] [SQLHLP] Downloading data [SELECT TOP(1000000) * FROM [Ca..] ...
[GDCBDE][2020-06-25 12:07:24] [SQLHLP] Check connection
[GDCBDE][2020-06-25 12:07:24] [SQLHLP] Connection ok
[GDCBDE][2020-06-25 12:07:24] [SQLHLP] Dataset loaded: 0.01MB in 0.0s(0.0m) 118 rows
[GDCBDE][2020-06-25 12:07:24] [SQLHLP] Downloading data [SELECT TOP(1000000) * FROM [Co..] ...
[GDCBDE][2020-06-25 12:07:24] [SQLHLP] Check connection
[GDCBDE][2020-06-25 12:07:24] [SQLHLP] Connection ok
[GDCBDE][2020-06-25 12:07:24] [SQLHLP] Dataset loaded: 0.01MB in 0.0s(0.0m) 134 rows
[GDCBDE][2020-06-25 12:07:24] [SQLHLP] Downloading data [SELECT TOP(1000000) * FROM [Ca..] ...
[GDCBDE][2020-06-25 12:07:24] [SQLHLP] Check connection
[GDCBDE][2020-06-25 12:07:24] [SQLHLP] Connection ok
[GDCBDE][2020-06-25 12:07:24] [SQLHLP] Dataset loaded: 0.02MB in 0.0s(0.0m) 519 rows
[GDCBDE][2020-06-25 12:07:24] ....Trying to associate code and description columns to df_rawdata_toshow
[GDCBDE][2020-06-25 12:07:24] Finished associating columns
[GDCBDE][2020-06-27 03:48:11] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ...
[GDCBDE][2020-06-27 03:48:11] [SQLHLP] Check connection
[GDCBDE][2020-06-27 03:48:11] [SQLHLP] Connection ok
[GDCBDE][2020-06-27 03:48:11] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 0 rows
[GDCBDE][2020-06-27 10:06:21] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ...
[GDCBDE][2020-06-27 10:06:21] [SQLHLP] Check connection
[GDCBDE][2020-06-27 10:06:21] [SQLHLP] Connection ok
[GDCBDE][2020-06-27 10:06:21] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 0 rows
[GDCBDE][2020-06-27 18:04:45] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ...
[GDCBDE][2020-06-27 18:04:45] [SQLHLP] Check connection
[GDCBDE][2020-06-27 18:04:45] [SQLHLP] Connection ok
[GDCBDE][2020-06-27 18:04:45] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 0 rows
[GDCBDE][2020-06-30 13:16:47] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ...
[GDCBDE][2020-06-30 13:16:47] [SQLHLP] Check connection
[GDCBDE][2020-06-30 13:16:47] [SQLHLP] Connection ok
[GDCBDE][2020-06-30 13:16:47] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 0 rows
[GDCBDE][2020-06-30 16:30:46] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ...
[GDCBDE][2020-06-30 16:30:46] [SQLHLP] Check connection
[GDCBDE][2020-06-30 16:30:46] [SQLHLP] Connection ok
[GDCBDE][2020-06-30 16:30:46] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 0 rows
[GDCBDE][2020-07-01 03:58:07] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ...
[GDCBDE][2020-07-01 03:58:07] [SQLHLP] Check connection
[GDCBDE][2020-07-01 03:58:07] [SQLHLP] Connection ok
[GDCBDE][2020-07-01 03:58:07] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 0 rows
[GDCBDE][2020-07-01 12:33:08] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ...
[GDCBDE][2020-07-01 12:33:08] [SQLHLP] Check connection
[GDCBDE][2020-07-01 12:33:08] [SQLHLP] Connection ok
[GDCBDE][2020-07-01 12:33:08] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 0 rows
[GDCBDE][2020-07-01 18:07:51] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ...
[GDCBDE][2020-07-01 18:07:51] [SQLHLP] Check connection
[GDCBDE][2020-07-01 18:07:52] [SQLHLP] Connection ok
[GDCBDE][2020-07-01 18:07:52] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 0 rows
[GDCBDE][2020-07-03 10:24:41] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ...
[GDCBDE][2020-07-03 10:24:41] [SQLHLP] Check connection
[GDCBDE][2020-07-03 10:24:41] [SQLHLP] Connection ok
[GDCBDE][2020-07-03 10:24:41] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 0 rows
[GDCBDE][2020-07-04 23:57:51] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ...
[GDCBDE][2020-07-04 23:57:51] [SQLHLP] Check connection
[GDCBDE][2020-07-04 23:57:51] [SQLHLP] Connection ok
[GDCBDE][2020-07-04 23:57:51] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 0 rows
[GDCBDE][2020-07-05 11:40:36] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ...
[GDCBDE][2020-07-05 11:40:36] [SQLHLP] Check connection
[GDCBDE][2020-07-05 11:40:36] [SQLHLP] Connection ok
[GDCBDE][2020-07-05 11:40:37] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 0 rows
[GDCBDE][2020-07-05 19:30:02] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ...
[GDCBDE][2020-07-05 19:30:02] [SQLHLP] Check connection
[GDCBDE][2020-07-05 19:30:02] [SQLHLP] Connection ok
[GDCBDE][2020-07-05 19:30:02] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 0 rows
[GDCBDE][2020-07-06 22:21:51] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ...
[GDCBDE][2020-07-06 22:21:51] [SQLHLP] Check connection
[GDCBDE][2020-07-06 22:21:51] [SQLHLP] Connection ok
[GDCBDE][2020-07-06 22:21:51] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 0 rows
[GDCBDE][2020-07-07 22:18:33] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ...
[GDCBDE][2020-07-07 22:18:33] [SQLHLP] Check connection
[GDCBDE][2020-07-07 22:18:33] [SQLHLP] Connection ok
[GDCBDE][2020-07-07 22:18:33] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 0 rows
[GDCBDE][2020-07-08 01:19:31] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ...
[GDCBDE][2020-07-08 01:19:31] [SQLHLP] Check connection
[GDCBDE][2020-07-08 01:19:31] [SQLHLP] Connection ok
[GDCBDE][2020-07-08 01:19:31] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 0 rows
[GDCBDE][2020-07-08 13:39:58] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ...
[GDCBDE][2020-07-08 13:39:58] [SQLHLP] Check connection
[GDCBDE][2020-07-08 13:39:58] [SQLHLP] Connection ok
[GDCBDE][2020-07-08 13:39:58] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 0 rows
[GDCBDE][2020-07-11 04:34:37] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ...
[GDCBDE][2020-07-11 04:34:37] [SQLHLP] Check connection
[GDCBDE][2020-07-11 04:34:37] [SQLHLP] Connection ok
[GDCBDE][2020-07-11 04:34:37] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 0 rows
[GDCBDE][2020-07-13 14:28:08] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ...
[GDCBDE][2020-07-13 14:28:08] [SQLHLP] Check connection
[GDCBDE][2020-07-13 14:28:08] [SQLHLP] Connection ok
[GDCBDE][2020-07-13 14:28:08] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 0 rows
[GDCBDE][2020-07-14 03:02:12] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ...
[GDCBDE][2020-07-14 03:02:12] [SQLHLP] Check connection
[GDCBDE][2020-07-14 03:02:12] [SQLHLP] Connection ok
[GDCBDE][2020-07-14 03:02:12] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 0 rows
[GDCBDE][2020-07-15 01:06:55] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ...
[GDCBDE][2020-07-15 01:06:55] [SQLHLP] Check connection
[GDCBDE][2020-07-15 01:06:55] [SQLHLP] Connection ok
[GDCBDE][2020-07-15 01:06:56] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 0 rows
[GDCBDE][2020-07-17 03:53:46] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ...
[GDCBDE][2020-07-17 03:53:46] [SQLHLP] Check connection
[GDCBDE][2020-07-17 03:53:46] [SQLHLP] Connection ok
[GDCBDE][2020-07-17 03:53:46] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 0 rows
[GDCBDE][2020-07-17 19:25:46] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ...
[GDCBDE][2020-07-17 19:25:46] [SQLHLP] Check connection
[GDCBDE][2020-07-17 19:25:46] [SQLHLP] Connection ok
[GDCBDE][2020-07-17 19:25:46] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 0 rows
[GDCBDE][2020-07-18 22:09:05] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ...
[GDCBDE][2020-07-18 22:09:05] [SQLHLP] Check connection
[GDCBDE][2020-07-18 22:09:05] [SQLHLP] Connection ok
[GDCBDE][2020-07-18 22:09:05] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 0 rows
[GDCBDE][2020-07-19 03:53:44] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ...
[GDCBDE][2020-07-19 03:53:44] [SQLHLP] Check connection
[GDCBDE][2020-07-19 03:53:44] [SQLHLP] Connection ok
[GDCBDE][2020-07-19 03:53:44] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 0 rows
[GDCBDE][2020-07-20 03:04:59] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ...
[GDCBDE][2020-07-20 03:04:59] [SQLHLP] Check connection
[GDCBDE][2020-07-20 03:04:59] [SQLHLP] Connection ok
[GDCBDE][2020-07-20 03:04:59] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 0 rows
[GDCBDE][2020-07-21 02:11:41] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ...
[GDCBDE][2020-07-21 02:11:41] [SQLHLP] Check connection
[GDCBDE][2020-07-21 02:11:41] [SQLHLP] Connection ok
[GDCBDE][2020-07-21 02:11:41] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 0 rows
[GDCBDE][2020-07-23 00:09:19] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ...
[GDCBDE][2020-07-23 00:09:19] [SQLHLP] Check connection
[GDCBDE][2020-07-23 00:09:19] [SQLHLP] Connection ok
[GDCBDE][2020-07-23 00:09:19] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 0 rows
[GDCBDE][2020-07-24 19:13:34] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ...
[GDCBDE][2020-07-24 19:13:34] [SQLHLP] Check connection
[GDCBDE][2020-07-24 19:13:34] [SQLHLP] Connection ok
[GDCBDE][2020-07-24 19:13:34] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 0 rows
[GDCBDE][2020-07-27 01:17:22] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ...
[GDCBDE][2020-07-27 01:17:22] [SQLHLP] Check connection
[GDCBDE][2020-07-27 01:17:22] [SQLHLP] Connection ok
[GDCBDE][2020-07-27 01:17:22] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 0 rows
[GDCBDE][2020-07-27 11:32:08] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ...
[GDCBDE][2020-07-27 11:32:08] [SQLHLP] Check connection
[GDCBDE][2020-07-27 11:32:08] [SQLHLP] Connection ok
[GDCBDE][2020-07-27 11:32:08] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 0 rows