[GDCBDE][2018-08-23 06:49:33] [SQLHLP] INIT [AZURE SQL HELPER v1.3.3] [GDCBDE][2018-08-23 06:49:33] [SQLHLP] Using data folder:...www/html/api/_godrive_data/db_cache [GDCBDE][2018-08-23 06:49:33] [SQLHLP] ODBC Conn try 1: DRIVER={ODBC Driver 13 for SQL Serv... [GDCBDE][2018-08-23 06:49:34] [SQLHLP] Connection created on carbox.database.windows.net [GDCBDE][2018-08-23 06:49:34] LOGfile: /var/www/html/api/_godrive_dat [GDCBDE][2018-08-23 06:49:34] Work folder: [/var/www/html/api/_godrive_data] [GDCBDE][2018-08-23 06:49:34] INIT DATA EXPLORER v0.1.1 [GDCBDE][2018-08-23 06:49:34] Setup predictors and raw data repo... [GDCBDE][2018-08-23 06:49:34] [SQLHLP] Loading file [..ata/db_cache/SELECT_FROM_Codes_.csv] ... [GDCBDE][2018-08-23 06:49:34] [SQLHLP] Dataset loaded: 0.01MB in 0.0s(0.0m) 134 rows [GDCBDE][2018-08-23 06:49:34] Loaded 134 predictors [GDCBDE][2018-08-23 06:49:34] [SQLHLP] Downloading data [SELECT TOP (1) * FROM [RawData..] ... [GDCBDE][2018-08-23 06:49:34] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows [GDCBDE][2018-08-23 06:49:34] RawData: ['CarID', 'CodeID', 'StrValue', 'Value', 'ViewVal', 'ViewStr', 'TimeStamp', 'DeviceSN'] [GDCBDE][2018-08-23 06:49:34] [SQLHLP] Loading file [..data/db_cache/SELECT_FROM_Cars_.csv] ... [GDCBDE][2018-08-23 06:49:34] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 56 rows [GDCBDE][2018-08-23 06:49:34] Loaded 56 cars [GDCBDE][2018-08-23 06:49:34] [SQLHLP] Loading file [../db_cache/SELECT_FROM_Accounts_.csv] ... [GDCBDE][2018-08-23 06:49:34] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 3 rows [GDCBDE][2018-08-23 06:49:34] Loaded 3 accounts [GDCBDE][2018-08-23 06:49:34] [SQLHLP] Downloading data [SELECT c.ID Masina, f.Name Flo..] ... [GDCBDE][2018-08-23 06:49:34] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 60 rows [GDCBDE][2018-08-23 06:49:34] CarsxAccounts copy: ['Masina', 'Flota', 'FlotaID'] [GDCBDE][2018-08-23 06:49:34] Done data preparation. [GDCBDE][2018-08-23 06:49:34] [SQLHLP] Downloading data [SELECT * FROM [RawData]..] ... [GDCBDE][2018-08-23 06:51:42] [SQLHLP] Dataset loaded: 86.95MB in 127.8s(2.1m) 1266268 rows [GDCBDE][2018-08-23 06:51:42] [SQLHLP] Downloading data [SELECT * FROM [Accounts]..] ... [GDCBDE][2018-08-23 06:51:42] [SQLHLP] Dataset loaded: 0.00MB in 0.2s(0.0m) 3 rows [GDCBDE][2018-08-23 06:51:42] [SQLHLP] Downloading data [SELECT * FROM [Cars]..] ... [GDCBDE][2018-08-23 06:51:42] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 60 rows [GDCBDE][2018-08-23 06:51:42] [SQLHLP] Downloading data [SELECT * FROM [Codes]..] ... [GDCBDE][2018-08-23 06:51:42] [SQLHLP] Dataset loaded: 0.01MB in 0.1s(0.0m) 134 rows [GDCBDE][2018-08-23 06:51:42] [SQLHLP] Downloading data [SELECT * FROM [CarsXCodes_v2]..] ... [GDCBDE][2018-08-23 06:51:42] [SQLHLP] Dataset loaded: 0.02MB in 0.1s(0.0m) 519 rows [GDCBDE][2018-08-23 06:51:42] ....Trying to associate code and description columns to df_rawdata_toshow [GDCBDE][2018-08-23 06:51:43] Finished associating columns [GDCBDE][2018-08-23 06:57:22] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ... [GDCBDE][2018-08-23 06:57:22] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 1 rows [GDCBDE][2018-08-23 06:57:22] [SQLHLP] Downloading data [SELECT * FROM Users WHERE Adre..] ... [GDCBDE][2018-08-23 06:57:22] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 1 rows [GDCBDE][2018-08-23 06:57:22] [SQLHLP] Downloading data [SELECT * FROM [Accounts]..] ... [GDCBDE][2018-08-23 06:57:22] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 3 rows [GDCBDE][2018-08-23 07:03:02] [SQLHLP] Downloading data [SELECT * FROM [Accounts]..] ... [GDCBDE][2018-08-23 07:03:02] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 3 rows [GDCBDE][2018-08-23 07:03:51] [SQLHLP] Downloading data [SELECT * FROM Users WHERE Adre..] ... [GDCBDE][2018-08-23 07:03:51] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 1 rows [GDCBDE][2018-08-23 07:03:52] [SQLHLP] Downloading data [SELECT * FROM [Accounts]..] ... [GDCBDE][2018-08-23 07:03:52] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 3 rows [GDCBDE][2018-08-23 07:03:58] [SQLHLP] Downloading data [SELECT * FROM [Users]..] ... [GDCBDE][2018-08-23 07:03:58] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 6 rows [GDCBDE][2018-08-23 07:03:58] [SQLHLP] Downloading data [SELECT * FROM [Errorcodes]..] ... [GDCBDE][2018-08-23 07:03:58] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 2 rows [GDCBDE][2018-08-23 07:03:58] [SQLHLP] Downloading data [SELECT * FROM [Statecodes]..] ... [GDCBDE][2018-08-23 07:03:58] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows [GDCBDE][2018-08-23 07:03:58] [SQLHLP] Downloading data [SELECT ID, AccountID, Name, De..] ... [GDCBDE][2018-08-23 07:03:58] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 60 rows [GDCBDE][2018-08-23 07:03:58] [SQLHLP] Downloading data [SELECT * FROM [CarsStatus]..] ... [GDCBDE][2018-08-23 07:03:58] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 57 rows [GDCBDE][2018-08-23 07:03:58] [SQLHLP] Downloading data [SELECT TOP (1) * FROM [Users]..] ... [GDCBDE][2018-08-23 07:03:58] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows [GDCBDE][2018-08-23 07:03:58] [SQLHLP] Downloading data [SELECT TOP (1) * FROM [Errorco..] ... [GDCBDE][2018-08-23 07:03:58] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows [GDCBDE][2018-08-23 07:03:58] [SQLHLP] Downloading data [SELECT TOP (1) * FROM [Stateco..] ... [GDCBDE][2018-08-23 07:03:58] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows [GDCBDE][2018-08-23 07:04:15] [SQLHLP] Downloading data [SELECT * FROM Users WHERE Adre..] ... [GDCBDE][2018-08-23 07:04:15] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 1 rows [GDCBDE][2018-08-23 07:04:15] [SQLHLP] Downloading data [SELECT * FROM [Accounts]..] ... [GDCBDE][2018-08-23 07:04:15] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 3 rows [GDCBDE][2018-08-23 07:04:33] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ... [GDCBDE][2018-08-23 07:04:33] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows [GDCBDE][2018-08-23 07:04:33] [SQLHLP] Downloading data [SELECT * FROM Users WHERE Adre..] ... [GDCBDE][2018-08-23 07:04:33] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows [GDCBDE][2018-08-23 07:04:33] [SQLHLP] Downloading data [SELECT * FROM [Accounts]..] ... [GDCBDE][2018-08-23 07:04:33] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 3 rows [GDCBDE][2018-08-23 07:05:02] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ... [GDCBDE][2018-08-23 07:05:02] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 1 rows [GDCBDE][2018-08-23 07:05:02] [SQLHLP] Downloading data [SELECT * FROM Users WHERE Adre..] ... [GDCBDE][2018-08-23 07:05:02] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows [GDCBDE][2018-08-23 07:05:02] [SQLHLP] Downloading data [SELECT * FROM [Accounts]..] ... [GDCBDE][2018-08-23 07:05:03] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 3 rows [GDCBDE][2018-08-23 07:05:31] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ... [GDCBDE][2018-08-23 07:05:31] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows [GDCBDE][2018-08-23 07:05:31] [SQLHLP] Downloading data [SELECT * FROM Users WHERE Adre..] ... [GDCBDE][2018-08-23 07:05:31] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows [GDCBDE][2018-08-23 07:05:31] [SQLHLP] Downloading data [SELECT * FROM [Accounts]..] ... [GDCBDE][2018-08-23 07:05:31] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 3 rows [GDCBDE][2018-08-23 07:06:10] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ... [GDCBDE][2018-08-23 07:06:10] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows [GDCBDE][2018-08-23 07:06:10] [SQLHLP] Downloading data [SELECT * FROM Users WHERE Adre..] ... [GDCBDE][2018-08-23 07:06:10] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows [GDCBDE][2018-08-23 07:06:10] [SQLHLP] Downloading data [SELECT * FROM [Accounts]..] ... [GDCBDE][2018-08-23 07:06:10] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 3 rows [GDCBDE][2018-08-23 07:20:38] [SQLHLP] Downloading data [SELECT * FROM [Accounts]..] ... [GDCBDE][2018-08-23 07:20:39] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 3 rows [GDCBDE][2018-08-23 07:20:51] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ... [GDCBDE][2018-08-23 07:20:51] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows [GDCBDE][2018-08-23 07:20:51] [SQLHLP] Downloading data [SELECT * FROM Users WHERE Adre..] ... [GDCBDE][2018-08-23 07:20:51] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows [GDCBDE][2018-08-23 07:20:51] [SQLHLP] Downloading data [SELECT * FROM [Accounts]..] ... [GDCBDE][2018-08-23 07:20:51] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 3 rows [GDCBDE][2018-08-23 07:21:14] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ... [GDCBDE][2018-08-23 07:21:14] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 1 rows [GDCBDE][2018-08-23 07:21:14] [SQLHLP] Downloading data [SELECT * FROM Users WHERE Adre..] ... [GDCBDE][2018-08-23 07:21:14] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows [GDCBDE][2018-08-23 07:21:14] [SQLHLP] Downloading data [SELECT * FROM [Accounts]..] ... [GDCBDE][2018-08-23 07:21:14] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 3 rows [GDCBDE][2018-08-23 07:52:30] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ... [GDCBDE][2018-08-23 07:52:30] [SQLHLP] ERROR: Execution failed on sql: SELECT ID, Adresa_email FROM Users WHERE Adresa_email ='email_test@gmail.com' AND Parola ='pass_test'; ('08S01', '[08S01] [Microsoft][ODBC Driver 13 for SQL Server]TCP Provider: Error code 0x68 (104) (SQLExecDirectW)') unable to rollback [GDCBDE][2018-08-23 07:55:14] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ... [GDCBDE][2018-08-23 07:55:14] [SQLHLP] ERROR: Execution failed on sql: SELECT ID, Adresa_email FROM Users WHERE Adresa_email ='email_test@gmail.com' AND Parola ='pass_test'; ('08S01', '[08S01] [Microsoft][ODBC Driver 13 for SQL Server]Communication link failure (0) (SQLExecDirectW)') unable to rollback [GDCBDE][2018-08-23 07:58:50] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ... [GDCBDE][2018-08-23 07:58:50] [SQLHLP] ERROR: Execution failed on sql: SELECT ID, Adresa_email FROM Users WHERE Adresa_email ='email_test@gmail.com' AND Parola ='pass_test'; ('08S01', '[08S01] [Microsoft][ODBC Driver 13 for SQL Server]Communication link failure (0) (SQLExecDirectW)') unable to rollback