[GDCBDE][2018-10-23 12:39:16] [SQLHLP] INIT [AZURE SQL HELPER v1.3.3]
[GDCBDE][2018-10-23 12:39:16] [SQLHLP] Using data folder:...www/html/api/_godrive_data/db_cache
[GDCBDE][2018-10-23 12:39:16] [SQLHLP] ODBC Conn try 1: DRIVER={ODBC Driver 17 for SQL Serv...
[GDCBDE][2018-10-23 12:39:17] [SQLHLP] Connection created on 37.251.139.87
[GDCBDE][2018-10-23 12:39:17] LOGfile: /var/www/html/api/_godrive_dat
[GDCBDE][2018-10-23 12:39:17] Work folder: [/var/www/html/api/_godrive_data]
[GDCBDE][2018-10-23 12:39:17] INIT DATA EXPLORER v0.1.1
[GDCBDE][2018-10-23 12:39:17] Setup predictors and raw data repo...
[GDCBDE][2018-10-23 12:39:17] [SQLHLP] Loading file [../SELECT_TOP_2000000_FROM_Codes_.csv] ...
[GDCBDE][2018-10-23 12:39:17] [SQLHLP] Dataset loaded: 0.01MB in 0.0s(0.0m) 134 rows
[GDCBDE][2018-10-23 12:39:17] Loaded 134 predictors
[GDCBDE][2018-10-23 12:39:17] [SQLHLP] Downloading data [SELECT TOP (1) * FROM [RawData..] ...
[GDCBDE][2018-10-23 12:39:17] [SQLHLP] Check connection
[GDCBDE][2018-10-23 12:39:17] [SQLHLP] Connection ok
[GDCBDE][2018-10-23 12:39:17] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows
[GDCBDE][2018-10-23 12:39:17] RawData: ['CarID', 'CodeID', 'StrValue', 'Value', 'ViewVal', 'ViewStr', 'TimeStamp', 'DeviceSN']
[GDCBDE][2018-10-23 12:39:17] [SQLHLP] Loading file [..e/SELECT_TOP_2000000_FROM_Cars_.csv] ...
[GDCBDE][2018-10-23 12:39:17] [SQLHLP] Dataset loaded: 0.01MB in 0.0s(0.0m) 120 rows
[GDCBDE][2018-10-23 12:39:17] Loaded 120 cars
[GDCBDE][2018-10-23 12:39:17] [SQLHLP] Loading file [..LECT_TOP_2000000_FROM_Accounts_.csv] ...
[GDCBDE][2018-10-23 12:39:17] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 3 rows
[GDCBDE][2018-10-23 12:39:17] Loaded 3 accounts
[GDCBDE][2018-10-23 12:39:17] [SQLHLP] Downloading data [SELECT c.ID Masina, f.Name Flo..] ...
[GDCBDE][2018-10-23 12:39:17] [SQLHLP] Check connection
[GDCBDE][2018-10-23 12:39:17] [SQLHLP] Connection ok
[GDCBDE][2018-10-23 12:39:17] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 120 rows
[GDCBDE][2018-10-23 12:39:17] CarsxAccounts copy: ['Masina', 'Flota', 'FlotaID']
[GDCBDE][2018-10-23 12:39:17] Done data preparation.
[GDCBDE][2018-10-23 12:39:17] [SQLHLP] Downloading data [SELECT TOP 2000000 * FROM [Raw..] ...
[GDCBDE][2018-10-23 12:39:17] [SQLHLP] Check connection
[GDCBDE][2018-10-23 12:39:17] [SQLHLP] Connection ok
[GDCBDE][2018-10-23 12:41:15] [SQLHLP] Dataset loaded: 137.33MB in 118.4s(2.0m) 2000000 rows
[GDCBDE][2018-10-23 12:41:15] [SQLHLP] Downloading data [SELECT TOP 2000000 * FROM [Acc..] ...
[GDCBDE][2018-10-23 12:41:15] [SQLHLP] Check connection
[GDCBDE][2018-10-23 12:41:15] [SQLHLP] Connection ok
[GDCBDE][2018-10-23 12:41:15] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 3 rows
[GDCBDE][2018-10-23 12:41:15] [SQLHLP] Downloading data [SELECT TOP 2000000 * FROM [Car..] ...
[GDCBDE][2018-10-23 12:41:15] [SQLHLP] Check connection
[GDCBDE][2018-10-23 12:41:15] [SQLHLP] Connection ok
[GDCBDE][2018-10-23 12:41:15] [SQLHLP] Dataset loaded: 0.01MB in 0.0s(0.0m) 120 rows
[GDCBDE][2018-10-23 12:41:15] [SQLHLP] Downloading data [SELECT TOP 2000000 * FROM [Cod..] ...
[GDCBDE][2018-10-23 12:41:15] [SQLHLP] Check connection
[GDCBDE][2018-10-23 12:41:15] [SQLHLP] Connection ok
[GDCBDE][2018-10-23 12:41:15] [SQLHLP] Dataset loaded: 0.01MB in 0.0s(0.0m) 134 rows
[GDCBDE][2018-10-23 12:41:15] [SQLHLP] Downloading data [SELECT TOP 2000000 * FROM [Car..] ...
[GDCBDE][2018-10-23 12:41:15] [SQLHLP] Check connection
[GDCBDE][2018-10-23 12:41:15] [SQLHLP] Connection ok
[GDCBDE][2018-10-23 12:41:15] [SQLHLP] Dataset loaded: 0.02MB in 0.0s(0.0m) 519 rows
[GDCBDE][2018-10-23 12:41:15] ....Trying to associate code and description columns to df_rawdata_toshow
[GDCBDE][2018-10-23 12:41:17] Finished associating columns
[GDCBDE][2018-10-23 12:42:32] [SQLHLP] Downloading data [SELECT * FROM Users WHERE Adre..] ...
[GDCBDE][2018-10-23 12:42:32] [SQLHLP] Check connection
[GDCBDE][2018-10-23 12:42:32] [SQLHLP] Connection ok
[GDCBDE][2018-10-23 12:42:32] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows
[GDCBDE][2018-10-23 12:42:32] [SQLHLP] Downloading data [SELECT * FROM Users WHERE Adre..] ...
[GDCBDE][2018-10-23 12:42:32] [SQLHLP] Check connection
[GDCBDE][2018-10-23 12:42:32] [SQLHLP] Connection ok
[GDCBDE][2018-10-23 12:42:32] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows
[GDCBDE][2018-10-23 12:42:32] [SQLHLP] Downloading data [SELECT TOP 2000000 * FROM [Acc..] ...
[GDCBDE][2018-10-23 12:42:32] [SQLHLP] Check connection
[GDCBDE][2018-10-23 12:42:32] [SQLHLP] Connection ok
[GDCBDE][2018-10-23 12:42:32] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 3 rows
[GDCBDE][2018-10-23 12:42:33] [SQLHLP] Downloading data [SELECT TOP 2000000 * FROM [Acc..] ...
[GDCBDE][2018-10-23 12:42:33] [SQLHLP] Check connection
[GDCBDE][2018-10-23 12:42:33] [SQLHLP] Connection ok
[GDCBDE][2018-10-23 12:42:33] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 3 rows
[GDCBDE][2018-10-23 12:43:00] [SQLHLP] Downloading data [SELECT TOP 2000000 * FROM [Acc..] ...
[GDCBDE][2018-10-23 12:43:00] [SQLHLP] Downloading data [SELECT * FROM Users WHERE Adre..] ...
[GDCBDE][2018-10-23 12:43:00] [SQLHLP] Check connection
[GDCBDE][2018-10-23 12:43:00] [SQLHLP] Check connection
[GDCBDE][2018-10-23 12:43:00] [SQLHLP] Connection ok
[GDCBDE][2018-10-23 12:43:00] [SQLHLP] Connection ok
[GDCBDE][2018-10-23 12:43:00] [SQLHLP] ERROR: ('HY010', '[HY010] [Microsoft][ODBC Driver 17 for SQL Server]Function sequence error (0) (SQLGetData)')
[GDCBDE][2018-10-23 12:43:00] [SQLHLP] ERROR: Execution failed on sql 'SELECT * FROM Users WHERE Adresa_email ='email_test@gmail.com';': ('HY000', '[HY000] [Microsoft][ODBC Driver 17 for SQL Server]Connection is busy with results for another command (0) (SQLExecDirectW)')
[GDCBDE][2018-10-23 12:43:06] [SQLHLP] Downloading data [SELECT TOP 2000000 * FROM [Acc..] ...
[GDCBDE][2018-10-23 12:43:06] [SQLHLP] Check connection
[GDCBDE][2018-10-23 12:43:06] [SQLHLP] Connection ok
[GDCBDE][2018-10-23 12:43:06] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 3 rows
[GDCBDE][2018-10-23 12:43:06] [SQLHLP] Downloading data [SELECT TOP 2000000 * FROM [Acc..] ...
[GDCBDE][2018-10-23 12:43:06] [SQLHLP] Check connection
[GDCBDE][2018-10-23 12:43:06] [SQLHLP] Downloading data [SELECT * FROM Users WHERE Adre..] ...
[GDCBDE][2018-10-23 12:43:06] [SQLHLP] Check connection
[GDCBDE][2018-10-23 12:43:06] [SQLHLP] Connection ok
[GDCBDE][2018-10-23 12:43:06] [SQLHLP] Connection ok
[GDCBDE][2018-10-23 12:43:06] [SQLHLP] ERROR: Execution failed on sql 'SELECT * FROM Users WHERE Adresa_email ='email_test@gmail.com';': ('HY000', '[HY000] [Microsoft][ODBC Driver 17 for SQL Server]Connection is busy with results for another command (0) (SQLExecDirectW)')
[GDCBDE][2018-10-23 12:43:06] [SQLHLP] ERROR: Execution failed on sql 'SELECT TOP 2000000 * FROM [Accounts]': ('HY007', '[HY007] [Microsoft][ODBC Driver 17 for SQL Server]Associated statement is not prepared (0) (SQLNumResultCols)')
[GDCBDE][2018-10-23 12:43:39] [SQLHLP] Downloading data [SELECT TOP 2000000 * FROM [Acc..] ...
[GDCBDE][2018-10-23 12:43:39] [SQLHLP] Check connection
[GDCBDE][2018-10-23 12:43:39] [SQLHLP] Downloading data [SELECT * FROM Users WHERE Adre..] ...
[GDCBDE][2018-10-23 12:43:39] [SQLHLP] Check connection
[GDCBDE][2018-10-23 12:43:39] [SQLHLP] Connection ok
[GDCBDE][2018-10-23 12:43:39] [SQLHLP] Connection ok
[GDCBDE][2018-10-23 12:43:39] [SQLHLP] ERROR: Execution failed on sql 'SELECT * FROM Users WHERE Adresa_email ='email_test@gmail.com';': ('HY000', '[HY000] [Microsoft][ODBC Driver 17 for SQL Server]Connection is busy with results for another command (0) (SQLExecDirectW)')
[GDCBDE][2018-10-23 12:43:39] [SQLHLP] ERROR: Execution failed on sql 'SELECT TOP 2000000 * FROM [Accounts]': ('HY007', '[HY007] [Microsoft][ODBC Driver 17 for SQL Server]Associated statement is not prepared (0) (SQLNumResultCols)')
[GDCBDE][2018-10-23 12:44:00] [SQLHLP] Downloading data [SELECT TOP 2000000 * FROM [Acc..] ...
[GDCBDE][2018-10-23 12:44:00] [SQLHLP] Check connection
[GDCBDE][2018-10-23 12:44:00] [SQLHLP] Connection ok
[GDCBDE][2018-10-23 12:44:00] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 3 rows
[GDCBDE][2018-10-23 12:44:00] [SQLHLP] Downloading data [SELECT * FROM Users WHERE Adre..] ...
[GDCBDE][2018-10-23 12:44:00] [SQLHLP] Downloading data [SELECT TOP 2000000 * FROM [Acc..] ...
[GDCBDE][2018-10-23 12:44:00] [SQLHLP] Check connection
[GDCBDE][2018-10-23 12:44:00] [SQLHLP] Check connection
[GDCBDE][2018-10-23 12:44:00] [SQLHLP] Connection ok
[GDCBDE][2018-10-23 12:44:00] [SQLHLP] Connection ok
[GDCBDE][2018-10-23 12:44:00] [SQLHLP] ERROR: Execution failed on sql 'SELECT TOP 2000000 * FROM [Accounts]': ('HY000', '[HY000] [Microsoft][ODBC Driver 17 for SQL Server]Connection is busy with results for another command (0) (SQLExecDirectW)')
[GDCBDE][2018-10-23 12:44:00] [SQLHLP] ERROR: Execution failed on sql 'SELECT * FROM Users WHERE Adresa_email ='email_test@gmail.com';': ('07005', '[07005] [Microsoft][ODBC Driver 17 for SQL Server]Prepared statement is not a cursor-specification (0) (SQLDescribeCol)')
[GDCBDE][2018-10-23 12:44:30] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ...
[GDCBDE][2018-10-23 12:44:30] [SQLHLP] Check connection
[GDCBDE][2018-10-23 12:44:30] [SQLHLP] Connection ok
[GDCBDE][2018-10-23 12:44:31] [SQLHLP] Dataset loaded: 0.00MB in 0.5s(0.0m) 1 rows
[GDCBDE][2018-10-23 12:44:31] [SQLHLP] Downloading data [SELECT * FROM Users WHERE Adre..] ...
[GDCBDE][2018-10-23 12:44:31] [SQLHLP] Check connection
[GDCBDE][2018-10-23 12:44:31] [SQLHLP] Connection ok
[GDCBDE][2018-10-23 12:44:31] [SQLHLP] Dataset loaded: 0.00MB in 0.2s(0.0m) 1 rows
[GDCBDE][2018-10-23 12:44:31] [SQLHLP] Downloading data [SELECT TOP 2000000 * FROM [Acc..] ...
[GDCBDE][2018-10-23 12:44:31] [SQLHLP] Check connection
[GDCBDE][2018-10-23 12:44:31] [SQLHLP] Connection ok
[GDCBDE][2018-10-23 12:44:31] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 3 rows
[GDCBDE][2018-10-23 12:44:32] [SQLHLP] Downloading data [SELECT TOP 2000000 * FROM [Acc..] ...
[GDCBDE][2018-10-23 12:44:32] [SQLHLP] Check connection
[GDCBDE][2018-10-23 12:44:32] [SQLHLP] Connection ok
[GDCBDE][2018-10-23 12:44:32] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 3 rows
[GDCBDE][2018-10-23 12:44:33] [SQLHLP] Downloading data [SELECT * FROM Users WHERE Adre..] ...
[GDCBDE][2018-10-23 12:44:33] [SQLHLP] Check connection
[GDCBDE][2018-10-23 12:44:33] [SQLHLP] Connection ok
[GDCBDE][2018-10-23 12:44:33] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows
[GDCBDE][2018-10-23 12:47:35] [SQLHLP] Downloading data [SELECT TOP 2000000 * FROM [Acc..] ...
[GDCBDE][2018-10-23 12:47:35] [SQLHLP] Check connection
[GDCBDE][2018-10-23 12:47:35] [SQLHLP] Connection ok
[GDCBDE][2018-10-23 12:47:35] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 3 rows
[GDCBDE][2018-10-23 12:47:36] [SQLHLP] Downloading data [SELECT TOP 2000000 * FROM [Acc..] ...
[GDCBDE][2018-10-23 12:47:36] [SQLHLP] Check connection
[GDCBDE][2018-10-23 12:47:36] [SQLHLP] Connection ok
[GDCBDE][2018-10-23 12:47:36] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 3 rows
[GDCBDE][2018-10-23 12:48:04] [SQLHLP] Downloading data [SELECT TOP 2000000 * FROM [Acc..] ...
[GDCBDE][2018-10-23 12:48:04] [SQLHLP] Check connection
[GDCBDE][2018-10-23 12:48:04] [SQLHLP] Connection ok
[GDCBDE][2018-10-23 12:48:04] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 3 rows
[GDCBDE][2018-10-23 12:49:11] [SQLHLP] Downloading data [SELECT TOP 2000000 * FROM [Acc..] ...
[GDCBDE][2018-10-23 12:49:11] [SQLHLP] Check connection
[GDCBDE][2018-10-23 12:49:11] [SQLHLP] Connection ok
[GDCBDE][2018-10-23 12:49:11] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 3 rows