[GDCBDE][2018-03-15 16:33:58] [SQLHLP] INIT [AZURE SQL HELPER v1.3.3]
[GDCBDE][2018-03-15 16:33:58] [SQLHLP] Using data folder:...ition_v2\api\_godrive_data\db_cache
[GDCBDE][2018-03-15 16:33:58] [SQLHLP] ODBC Conn: DRIVER={ODBC Driver 13 for SQL Serv...
[GDCBDE][2018-03-15 16:33:59] [SQLHLP] Connection created on carbox.database.windows.net
[GDCBDE][2018-03-15 16:33:59] LOGfile: C:\Users\Erik\Dropbox\21. GODR
[GDCBDE][2018-03-15 16:33:59] Work folder: [C:\Users\Erik\Dropbox\21. GODRIVE_WORK\01_work\TESTS\iot_acquisition_v2\api\_godrive_data]
[GDCBDE][2018-03-15 16:33:59] INIT DATA EXPLORER v0.1.1
[GDCBDE][2018-03-15 16:33:59] Setup predictors and raw data repo...
[GDCBDE][2018-03-15 16:33:59] [SQLHLP] Loading file [..ata\db_cache\SELECT_FROM_Codes_.csv] ...
[GDCBDE][2018-03-15 16:33:59] [SQLHLP] Dataset loaded: 0.01MB in 0.0s(0.0m) 134 rows
[GDCBDE][2018-03-15 16:33:59] Loaded 134 predictors
[GDCBDE][2018-03-15 16:33:59] [SQLHLP] Downloading data [SELECT TOP (1) * FROM [RawData..] ...
[GDCBDE][2018-03-15 16:33:59] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 1 rows
[GDCBDE][2018-03-15 16:33:59] RawData: ['CarID', 'CodeID', 'StrValue', 'Value', 'ViewVal', 'ViewStr', 'TimeStamp', 'DeviceSN']
[GDCBDE][2018-03-15 16:33:59] [SQLHLP] Loading file [..data\db_cache\SELECT_FROM_Cars_.csv] ...
[GDCBDE][2018-03-15 16:33:59] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 56 rows
[GDCBDE][2018-03-15 16:33:59] Loaded 56 cars
[GDCBDE][2018-03-15 16:33:59] [SQLHLP] Loading file [..a\db_cache\SELECT_FROM_RawData_.csv] ...
[GDCBDE][2018-03-15 16:33:59] [SQLHLP] Dataset loaded: 1.07MB in 0.1s(0.0m) 17504 rows
[GDCBDE][2018-03-15 16:33:59] Rawdata copy: ['ID', 'CarID', 'CodeID', 'StrValue', 'Value', 'ViewVal', 'ViewStr', 'TimeStamp']
[GDCBDE][2018-03-15 16:33:59] [SQLHLP] Loading file [..\db_cache\SELECT_FROM_Accounts_.csv] ...
[GDCBDE][2018-03-15 16:33:59] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 3 rows
[GDCBDE][2018-03-15 16:33:59] Loaded 3 accounts
[GDCBDE][2018-03-15 16:33:59] [SQLHLP] Downloading data [SELECT c.ID Masina, f.Name Flo..] ...
[GDCBDE][2018-03-15 16:33:59] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 57 rows
[GDCBDE][2018-03-15 16:33:59] CarsxAccounts copy: ['Masina', 'Flota', 'FlotaID']
[GDCBDE][2018-03-15 16:33:59] Done data preparation.
[GDCBDE][2018-03-15 16:33:59] [SQLHLP] Downloading data [SELECT * FROM [RawData]..] ...
[GDCBDE][2018-03-15 16:34:36] [SQLHLP] Dataset loaded: 32.77MB in 36.5s(0.6m) 477173 rows
[GDCBDE][2018-03-15 16:34:36] [SQLHLP] Downloading data [SELECT * FROM [Accounts]..] ...
[GDCBDE][2018-03-15 16:34:36] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 3 rows
[GDCBDE][2018-03-15 16:34:36] [SQLHLP] Downloading data [SELECT * FROM [Cars]..] ...
[GDCBDE][2018-03-15 16:34:36] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 57 rows
[GDCBDE][2018-03-15 16:34:36] [SQLHLP] Downloading data [SELECT * FROM [Codes]..] ...
[GDCBDE][2018-03-15 16:34:36] [SQLHLP] Dataset loaded: 0.01MB in 0.1s(0.0m) 134 rows
[GDCBDE][2018-03-15 16:34:36] [SQLHLP] Downloading data [SELECT * FROM [CarsXCodes_v2]..] ...
[GDCBDE][2018-03-15 16:34:36] [SQLHLP] Dataset loaded: 0.02MB in 0.1s(0.0m) 519 rows
[GDCBDE][2018-03-15 16:34:36] ....Trying to associate code and description columns to df_rawdata_toshow
[GDCBDE][2018-03-15 16:34:36] Finished associating columns
[GDCBDE][2018-03-15 16:34:36] Rawdata copy: ['ID', 'CarID', 'CodeID', 'StrValue', 'Value', 'ViewVal', 'ViewStr', 'TimeStamp', 'DeviceSN', 'Description', 'Code']
[GDCBDE][2018-03-15 16:35:19] [SQLHLP] Downloading data [SELECT * FROM [Users]..] ...
[GDCBDE][2018-03-15 16:35:19] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 3 rows
[GDCBDE][2018-03-15 16:35:19] [SQLHLP] Downloading data [SELECT * FROM [Users]..] ...
[GDCBDE][2018-03-15 16:35:19] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 3 rows
[GDCBDE][2018-03-15 16:36:04] [SQLHLP] Downloading data [SELECT * FROM [Users]..] ...
[GDCBDE][2018-03-15 16:36:04] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 3 rows
[GDCBDE][2018-03-15 16:36:04] [SQLHLP] Downloading data [SELECT * FROM [Users]..] ...
[GDCBDE][2018-03-15 16:36:04] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 3 rows
[GDCBDE][2018-03-15 16:36:04] [SQLHLP] SAVING TABLE [APPEND](3 records 0.00MB)...
[GDCBDE][2018-03-15 16:36:05] [SQLHLP] ERROR: (pyodbc.IntegrityError) ('23000', "[23000] [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Cannot insert explicit value for identity column in table 'Users' when IDENTITY_INSERT is set to OFF. (544) (SQLExecDirectW)") [SQL: 'INSERT INTO [Users] ([ID], [Nume], [Prenume], [Telefon], [Adresa_email], [Parola], [Tip_cont], [Nume_companie], [Descriere_companie], [Rol_user], [Flota_detinuta]) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'] [parameters: ((1, 'NUME2', 'PRENUME2', '0756123111', 'TEST@YAHOO.COM', 'PASS', 'companie', 'TEST SRL', 'ASDASDASDAD', 'COMPANIE', 'Test1'), (3, 'NUME2', 'PRENUME2', '0756123111', 'TEST@YAHOO.COM', 'PASS', 'companie', 'TEST SRL', 'ASDASDASDAD', 'COMPANIE', 'Test1'), (8, 'NUME2', 'PRENUME2', '0756123111', 'TEST@YAHOO.COM', 'PASS', 'companie', 'TEST SRL', 'ASDASDASDAD', 'COMPANIE', 'Test1'))] (Background on this error at: http://sqlalche.me/e/gkpj)