[GDCBDE][2018-11-14 21:38:55] [SQLHLP] INIT [AZURE SQL HELPER v1.3.3]
[GDCBDE][2018-11-14 21:38:55] [SQLHLP] Using data folder:...www/html/api/_godrive_data/db_cache
[GDCBDE][2018-11-14 21:38:55] [SQLHLP] ODBC Conn try 1: DRIVER={ODBC Driver 17 for SQL Serv...
[GDCBDE][2018-11-14 21:38:55] [SQLHLP] Connection created on 37.251.139.87
[GDCBDE][2018-11-14 21:38:55] LOGfile: /var/www/html/api/_godrive_dat
[GDCBDE][2018-11-14 21:38:55] Work folder: [/var/www/html/api/_godrive_data]
[GDCBDE][2018-11-14 21:38:55] INIT DATA EXPLORER v0.1.1
[GDCBDE][2018-11-14 21:38:55] Setup predictors and raw data repo...
[GDCBDE][2018-11-14 21:38:55] [SQLHLP] Downloading data [SELECT TOP (8000000) FROM [Cod..] ...
[GDCBDE][2018-11-14 21:38:55] [SQLHLP] Check connection
[GDCBDE][2018-11-14 21:38:55] [SQLHLP] Connection ok
[GDCBDE][2018-11-14 21:38:55] [SQLHLP] ERROR: Execution failed on sql 'SELECT TOP (8000000) FROM [Codes]': ('42000', "[42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near the keyword 'FROM'. (156) (SQLExecDirectW)")
[GDCBDE][2018-11-14 21:38:55] [SQLHLP] Downloading data [SELECT TOP (1) * FROM [RawData..] ...
[GDCBDE][2018-11-14 21:38:55] [SQLHLP] Check connection
[GDCBDE][2018-11-14 21:38:55] [SQLHLP] Connection ok
[GDCBDE][2018-11-14 21:38:56] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows
[GDCBDE][2018-11-14 21:38:56] RawData: ['CarID', 'CodeID', 'StrValue', 'Value', 'ViewVal', 'ViewStr', 'TimeStamp', 'DeviceSN']
[GDCBDE][2018-11-14 21:38:56] [SQLHLP] Downloading data [SELECT TOP (8000000) FROM [Car..] ...
[GDCBDE][2018-11-14 21:38:56] [SQLHLP] Check connection
[GDCBDE][2018-11-14 21:38:56] [SQLHLP] Connection ok
[GDCBDE][2018-11-14 21:38:56] [SQLHLP] ERROR: Execution failed on sql 'SELECT TOP (8000000) FROM [Cars]': ('42000', "[42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near the keyword 'FROM'. (156) (SQLExecDirectW)")
[GDCBDE][2018-11-14 21:38:56] [SQLHLP] Downloading data [SELECT TOP (8000000) FROM [Acc..] ...
[GDCBDE][2018-11-14 21:38:56] [SQLHLP] Check connection
[GDCBDE][2018-11-14 21:38:56] [SQLHLP] Connection ok
[GDCBDE][2018-11-14 21:38:56] [SQLHLP] ERROR: Execution failed on sql 'SELECT TOP (8000000) FROM [Accounts]': ('42000', "[42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near the keyword 'FROM'. (156) (SQLExecDirectW)")
[GDCBDE][2018-11-14 21:38:56] [SQLHLP] Downloading data [SELECT c.ID Masina, f.Name Flo..] ...
[GDCBDE][2018-11-14 21:38:56] [SQLHLP] Check connection
[GDCBDE][2018-11-14 21:38:56] [SQLHLP] Connection ok
[GDCBDE][2018-11-14 21:38:56] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 118 rows
[GDCBDE][2018-11-14 21:38:56] CarsxAccounts copy: ['Masina', 'Flota', 'FlotaID']
[GDCBDE][2018-11-14 21:38:56] Done data preparation.
[GDCBDE][2018-11-14 21:38:56] [SQLHLP] Downloading data [SELECT TOP (8000000) FROM [Raw..] ...
[GDCBDE][2018-11-14 21:38:56] [SQLHLP] Check connection
[GDCBDE][2018-11-14 21:38:56] [SQLHLP] Connection ok
[GDCBDE][2018-11-14 21:38:56] [SQLHLP] ERROR: Execution failed on sql 'SELECT TOP (8000000) FROM [RawData]': ('42000', "[42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near the keyword 'FROM'. (156) (SQLExecDirectW)")
[GDCBDE][2018-11-14 21:38:56] [SQLHLP] Downloading data [SELECT TOP (8000000) FROM [Acc..] ...
[GDCBDE][2018-11-14 21:38:56] [SQLHLP] Check connection
[GDCBDE][2018-11-14 21:38:56] [SQLHLP] Connection ok
[GDCBDE][2018-11-14 21:38:56] [SQLHLP] ERROR: Execution failed on sql 'SELECT TOP (8000000) FROM [Accounts]': ('42000', "[42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near the keyword 'FROM'. (156) (SQLExecDirectW)")
[GDCBDE][2018-11-14 21:38:56] [SQLHLP] Downloading data [SELECT TOP (8000000) FROM [Car..] ...
[GDCBDE][2018-11-14 21:38:56] [SQLHLP] Check connection
[GDCBDE][2018-11-14 21:38:56] [SQLHLP] Connection ok
[GDCBDE][2018-11-14 21:38:56] [SQLHLP] ERROR: Execution failed on sql 'SELECT TOP (8000000) FROM [Cars]': ('42000', "[42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near the keyword 'FROM'. (156) (SQLExecDirectW)")
[GDCBDE][2018-11-14 21:38:56] [SQLHLP] Downloading data [SELECT TOP (8000000) FROM [Cod..] ...
[GDCBDE][2018-11-14 21:38:56] [SQLHLP] Check connection
[GDCBDE][2018-11-14 21:38:56] [SQLHLP] Connection ok
[GDCBDE][2018-11-14 21:38:56] [SQLHLP] ERROR: Execution failed on sql 'SELECT TOP (8000000) FROM [Codes]': ('42000', "[42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near the keyword 'FROM'. (156) (SQLExecDirectW)")
[GDCBDE][2018-11-14 21:38:56] [SQLHLP] Downloading data [SELECT TOP (8000000) FROM [Car..] ...
[GDCBDE][2018-11-14 21:38:56] [SQLHLP] Check connection
[GDCBDE][2018-11-14 21:38:56] [SQLHLP] Connection ok
[GDCBDE][2018-11-14 21:38:56] [SQLHLP] ERROR: Execution failed on sql 'SELECT TOP (8000000) FROM [CarsXCodes_v2]': ('42000', "[42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near the keyword 'FROM'. (156) (SQLExecDirectW)")
[GDCBDE][2018-11-14 21:39:03] [SQLHLP] Downloading data [SELECT * FROM Users WHERE Adre..] ...
[GDCBDE][2018-11-14 21:39:03] [SQLHLP] Check connection
[GDCBDE][2018-11-14 21:39:03] [SQLHLP] Connection ok
[GDCBDE][2018-11-14 21:39:03] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows
[GDCBDE][2018-11-14 21:39:03] [SQLHLP] Downloading data [SELECT * FROM Users WHERE Adre..] ...
[GDCBDE][2018-11-14 21:39:03] [SQLHLP] Check connection
[GDCBDE][2018-11-14 21:39:03] [SQLHLP] Connection ok
[GDCBDE][2018-11-14 21:39:03] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows
[GDCBDE][2018-11-14 21:39:03] [SQLHLP] Downloading data [SELECT * FROM Accounts WHERE I..] ...
[GDCBDE][2018-11-14 21:39:03] [SQLHLP] Check connection
[GDCBDE][2018-11-14 21:39:03] [SQLHLP] Connection ok
[GDCBDE][2018-11-14 21:39:03] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows
[GDCBDE][2018-11-14 21:39:03] [SQLHLP] Downloading data [SELECT * FROM Cars WHERE Accou..] ...
[GDCBDE][2018-11-14 21:39:03] [SQLHLP] Check connection
[GDCBDE][2018-11-14 21:39:03] [SQLHLP] Connection ok
[GDCBDE][2018-11-14 21:39:03] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 28 rows
[GDCBDE][2018-11-14 21:39:03] [SQLHLP] Downloading data [SELECT * FROM Users WHERE Adre..] ...
[GDCBDE][2018-11-14 21:39:03] [SQLHLP] Check connection
[GDCBDE][2018-11-14 21:39:03] [SQLHLP] Connection ok
[GDCBDE][2018-11-14 21:39:03] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows
[GDCBDE][2018-11-14 21:39:03] [SQLHLP] Downloading data [SELECT * FROM Users WHERE Adre..] ...
[GDCBDE][2018-11-14 21:39:03] [SQLHLP] Check connection
[GDCBDE][2018-11-14 21:39:03] [SQLHLP] Connection ok
[GDCBDE][2018-11-14 21:39:03] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows
[GDCBDE][2018-11-14 21:39:03] [SQLHLP] Downloading data [SELECT * FROM Accounts WHERE I..] ...
[GDCBDE][2018-11-14 21:39:03] [SQLHLP] Check connection
[GDCBDE][2018-11-14 21:39:03] [SQLHLP] Downloading data [SELECT * FROM Users WHERE Adre..] ...
[GDCBDE][2018-11-14 21:39:03] [SQLHLP] Check connection
[GDCBDE][2018-11-14 21:39:03] [SQLHLP] Connection ok
[GDCBDE][2018-11-14 21:39:03] [SQLHLP] Connection ok
[GDCBDE][2018-11-14 21:39:03] [SQLHLP] ERROR: Execution failed on sql 'SELECT * FROM Users WHERE Adresa_email ='oana@gdcb.ro';': ('HY000', '[HY000] [Microsoft][ODBC Driver 17 for SQL Server]Connection is busy with results for another command (0) (SQLExecDirectW)')
[GDCBDE][2018-11-14 21:39:03] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows
[GDCBDE][2018-11-14 21:39:03] [SQLHLP] Downloading data [SELECT * FROM Cars WHERE Accou..] ...
[GDCBDE][2018-11-14 21:39:03] [SQLHLP] Check connection
[GDCBDE][2018-11-14 21:39:03] [SQLHLP] Connection ok
[GDCBDE][2018-11-14 21:39:03] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 28 rows
[GDCBDE][2018-11-14 21:39:08] [SQLHLP] Downloading data [SELECT * FROM Users WHERE Adre..] ...
[GDCBDE][2018-11-14 21:39:08] [SQLHLP] Check connection
[GDCBDE][2018-11-14 21:39:08] [SQLHLP] Connection ok
[GDCBDE][2018-11-14 21:39:08] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows
[GDCBDE][2018-11-14 21:39:08] [SQLHLP] Downloading data [SELECT * FROM Users WHERE Adre..] ...
[GDCBDE][2018-11-14 21:39:08] [SQLHLP] Check connection
[GDCBDE][2018-11-14 21:39:08] [SQLHLP] Connection ok
[GDCBDE][2018-11-14 21:39:08] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows
[GDCBDE][2018-11-14 21:39:08] [SQLHLP] Downloading data [SELECT * FROM Accounts WHERE I..] ...
[GDCBDE][2018-11-14 21:39:08] [SQLHLP] Check connection
[GDCBDE][2018-11-14 21:39:08] [SQLHLP] Connection ok
[GDCBDE][2018-11-14 21:39:08] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows
[GDCBDE][2018-11-14 21:39:08] [SQLHLP] Downloading data [SELECT * FROM Cars WHERE Accou..] ...
[GDCBDE][2018-11-14 21:39:08] [SQLHLP] Check connection
[GDCBDE][2018-11-14 21:39:08] [SQLHLP] Connection ok
[GDCBDE][2018-11-14 21:39:08] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 28 rows
[GDCBDE][2018-11-14 21:39:08] [SQLHLP] Downloading data [SELECT * FROM Users WHERE Adre..] ...
[GDCBDE][2018-11-14 21:39:08] [SQLHLP] Check connection
[GDCBDE][2018-11-14 21:39:08] [SQLHLP] Connection ok
[GDCBDE][2018-11-14 21:39:08] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows
[GDCBDE][2018-11-14 21:39:08] [SQLHLP] Downloading data [SELECT * FROM Users WHERE Adre..] ...
[GDCBDE][2018-11-14 21:39:08] [SQLHLP] Check connection
[GDCBDE][2018-11-14 21:39:08] [SQLHLP] Connection ok
[GDCBDE][2018-11-14 21:39:08] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows
[GDCBDE][2018-11-14 21:39:09] [SQLHLP] Downloading data [SELECT * FROM Accounts WHERE I..] ...
[GDCBDE][2018-11-14 21:39:09] [SQLHLP] Check connection
[GDCBDE][2018-11-14 21:39:09] [SQLHLP] Connection ok
[GDCBDE][2018-11-14 21:39:09] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows
[GDCBDE][2018-11-14 21:39:09] [SQLHLP] Downloading data [SELECT * FROM Cars WHERE Accou..] ...
[GDCBDE][2018-11-14 21:39:09] [SQLHLP] Check connection
[GDCBDE][2018-11-14 21:39:09] [SQLHLP] Connection ok
[GDCBDE][2018-11-14 21:39:09] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 28 rows
[GDCBDE][2018-11-14 21:39:09] [SQLHLP] Downloading data [SELECT * FROM Users WHERE Adre..] ...
[GDCBDE][2018-11-14 21:39:09] [SQLHLP] Check connection
[GDCBDE][2018-11-14 21:39:09] [SQLHLP] Connection ok
[GDCBDE][2018-11-14 21:39:09] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows
[GDCBDE][2018-11-14 21:39:09] [SQLHLP] Downloading data [SELECT * FROM Accounts WHERE I..] ...
[GDCBDE][2018-11-14 21:39:09] [SQLHLP] Check connection
[GDCBDE][2018-11-14 21:39:09] [SQLHLP] Connection ok
[GDCBDE][2018-11-14 21:39:09] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows
[GDCBDE][2018-11-14 21:39:09] [SQLHLP] Downloading data [SELECT * FROM Cars WHERE Accou..] ...
[GDCBDE][2018-11-14 21:39:09] [SQLHLP] Check connection
[GDCBDE][2018-11-14 21:39:09] [SQLHLP] Connection ok
[GDCBDE][2018-11-14 21:39:09] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 28 rows
[GDCBDE][2018-11-14 21:39:18] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ...
[GDCBDE][2018-11-14 21:39:18] [SQLHLP] Check connection
[GDCBDE][2018-11-14 21:39:18] [SQLHLP] Connection ok
[GDCBDE][2018-11-14 21:39:18] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows
[GDCBDE][2018-11-14 21:39:18] [SQLHLP] Downloading data [SELECT * FROM Users WHERE Adre..] ...
[GDCBDE][2018-11-14 21:39:18] [SQLHLP] Check connection
[GDCBDE][2018-11-14 21:39:18] [SQLHLP] Connection ok
[GDCBDE][2018-11-14 21:39:18] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows
[GDCBDE][2018-11-14 21:39:19] [SQLHLP] Downloading data [SELECT * FROM Users WHERE Adre..] ...
[GDCBDE][2018-11-14 21:39:19] [SQLHLP] Check connection
[GDCBDE][2018-11-14 21:39:19] [SQLHLP] Connection ok
[GDCBDE][2018-11-14 21:39:19] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows
[GDCBDE][2018-11-14 21:39:19] [SQLHLP] Downloading data [SELECT * FROM Accounts WHERE I..] ...
[GDCBDE][2018-11-14 21:39:19] [SQLHLP] Check connection
[GDCBDE][2018-11-14 21:39:19] [SQLHLP] Connection ok
[GDCBDE][2018-11-14 21:39:19] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows
[GDCBDE][2018-11-14 21:39:19] [SQLHLP] Downloading data [SELECT * FROM Cars WHERE Accou..] ...
[GDCBDE][2018-11-14 21:39:19] [SQLHLP] Check connection
[GDCBDE][2018-11-14 21:39:19] [SQLHLP] Connection ok
[GDCBDE][2018-11-14 21:39:19] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 28 rows
[GDCBDE][2018-11-14 21:39:19] [SQLHLP] Downloading data [SELECT * FROM Users WHERE Adre..] ...
[GDCBDE][2018-11-14 21:39:19] [SQLHLP] Downloading data [SELECT * FROM Users WHERE Adre..] ...
[GDCBDE][2018-11-14 21:39:19] [SQLHLP] Check connection
[GDCBDE][2018-11-14 21:39:19] [SQLHLP] Check connection
[GDCBDE][2018-11-14 21:39:19] [SQLHLP] Connection ok
[GDCBDE][2018-11-14 21:39:19] [SQLHLP] Connection ok
[GDCBDE][2018-11-14 21:39:19] [SQLHLP] ERROR: Execution failed on sql 'SELECT * FROM Users WHERE Adresa_email ='oana@gdcb.ro';': ('HY000', '[HY000] [Microsoft][ODBC Driver 17 for SQL Server]Connection is busy with results for another command (0) (SQLExecDirectW)')
[GDCBDE][2018-11-14 21:39:19] [SQLHLP] ERROR: Execution failed on sql 'SELECT * FROM Users WHERE Adresa_email ='oana@gdcb.ro';': ('HY007', '[HY007] [Microsoft][ODBC Driver 17 for SQL Server]Associated statement is not prepared (0) (SQLColAttribute)')