[GDCBDE][2018-02-28 15:16:08] [SQLHLP] INIT [AZURE SQL HELPER v1.3.3] [GDCBDE][2018-02-28 15:16:08] [SQLHLP] Using data folder:...ition_v2\api\_godrive_data\db_cache [GDCBDE][2018-02-28 15:16:08] [SQLHLP] ODBC Conn: DRIVER={ODBC Driver 13 for SQL Serv... [GDCBDE][2018-02-28 15:16:09] [SQLHLP] Connection created on carbox.database.windows.net [GDCBDE][2018-02-28 15:16:09] LOGfile: C:\Users\Erik\Dropbox\21. GODR [GDCBDE][2018-02-28 15:16:09] Work folder: [C:\Users\Erik\Dropbox\21. GODRIVE_WORK\01_work\TESTS\iot_acquisition_v2\api\_godrive_data] [GDCBDE][2018-02-28 15:16:09] INIT DATA EXPLORER v0.1.1 [GDCBDE][2018-02-28 15:16:09] Setup predictors and raw data repo... [GDCBDE][2018-02-28 15:16:09] [SQLHLP] Loading file [..ata\db_cache\SELECT_FROM_Codes_.csv] ... [GDCBDE][2018-02-28 15:16:09] [SQLHLP] Dataset loaded: 0.01MB in 0.0s(0.0m) 134 rows [GDCBDE][2018-02-28 15:16:09] Loaded 134 predictors [GDCBDE][2018-02-28 15:16:09] [SQLHLP] Downloading data [SELECT TOP (1) * FROM [RawData..] ... [GDCBDE][2018-02-28 15:16:09] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 1 rows [GDCBDE][2018-02-28 15:16:09] RawData: ['CarID', 'CodeID', 'StrValue', 'Value', 'ViewVal', 'ViewStr', 'TimeStamp', 'DeviceSN'] [GDCBDE][2018-02-28 15:16:09] [SQLHLP] Loading file [..data\db_cache\SELECT_FROM_Cars_.csv] ... [GDCBDE][2018-02-28 15:16:09] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 56 rows [GDCBDE][2018-02-28 15:16:09] Loaded 56 cars [GDCBDE][2018-02-28 15:16:09] [SQLHLP] Loading file [..a\db_cache\SELECT_FROM_RawData_.csv] ... [GDCBDE][2018-02-28 15:16:09] [SQLHLP] Dataset loaded: 1.07MB in 0.1s(0.0m) 17504 rows [GDCBDE][2018-02-28 15:16:09] Rawdata copy: ['ID', 'CarID', 'CodeID', 'StrValue', 'Value', 'ViewVal', 'ViewStr', 'TimeStamp'] [GDCBDE][2018-02-28 15:16:09] [SQLHLP] Loading file [..\db_cache\SELECT_FROM_Accounts_.csv] ... [GDCBDE][2018-02-28 15:16:09] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 3 rows [GDCBDE][2018-02-28 15:16:09] Loaded 3 accounts [GDCBDE][2018-02-28 15:16:09] [SQLHLP] Downloading data [SELECT c.ID Masina, f.Name Flo..] ... [GDCBDE][2018-02-28 15:16:09] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 57 rows [GDCBDE][2018-02-28 15:16:09] CarsxAccounts copy: ['Masina', 'Flota', 'FlotaID'] [GDCBDE][2018-02-28 15:16:09] Done data preparation. [GDCBDE][2018-02-28 15:16:19] [SQLHLP] Downloading data [SELECT * FROM Users WHERE Adre..] ... [GDCBDE][2018-02-28 15:16:19] [SQLHLP] ERROR: Execution failed on sql 'SELECT * FROM Users WHERE Adresa de email ='email_test@gmail.com' AND Parola ='pass_test';': ('42000', "[42000] [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]An expression of non-boolean type specified in a context where a condition is expected, near 'de'. (4145) (SQLExecDirectW)")