[GDCBDE][2018-03-15 17:30:05] [SQLHLP] INIT [AZURE SQL HELPER v1.3.3]
[GDCBDE][2018-03-15 17:30:05] [SQLHLP] Using data folder:...ition_v2\api\_godrive_data\db_cache
[GDCBDE][2018-03-15 17:30:05] [SQLHLP] ODBC Conn: DRIVER={ODBC Driver 13 for SQL Serv...
[GDCBDE][2018-03-15 17:30:05] [SQLHLP] Connection created on carbox.database.windows.net
[GDCBDE][2018-03-15 17:30:05] LOGfile: C:\Users\Erik\Dropbox\21. GODR
[GDCBDE][2018-03-15 17:30:05] Work folder: [C:\Users\Erik\Dropbox\21. GODRIVE_WORK\01_work\TESTS\iot_acquisition_v2\api\_godrive_data]
[GDCBDE][2018-03-15 17:30:05] INIT DATA EXPLORER v0.1.1
[GDCBDE][2018-03-15 17:30:05] Setup predictors and raw data repo...
[GDCBDE][2018-03-15 17:30:05] [SQLHLP] Loading file [..ata\db_cache\SELECT_FROM_Codes_.csv] ...
[GDCBDE][2018-03-15 17:30:05] [SQLHLP] Dataset loaded: 0.01MB in 0.0s(0.0m) 134 rows
[GDCBDE][2018-03-15 17:30:05] Loaded 134 predictors
[GDCBDE][2018-03-15 17:30:05] [SQLHLP] Downloading data [SELECT TOP (1) * FROM [RawData..] ...
[GDCBDE][2018-03-15 17:30:05] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 1 rows
[GDCBDE][2018-03-15 17:30:05] RawData: ['CarID', 'CodeID', 'StrValue', 'Value', 'ViewVal', 'ViewStr', 'TimeStamp', 'DeviceSN']
[GDCBDE][2018-03-15 17:30:05] [SQLHLP] Loading file [..data\db_cache\SELECT_FROM_Cars_.csv] ...
[GDCBDE][2018-03-15 17:30:05] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 56 rows
[GDCBDE][2018-03-15 17:30:05] Loaded 56 cars
[GDCBDE][2018-03-15 17:30:05] [SQLHLP] Loading file [..a\db_cache\SELECT_FROM_RawData_.csv] ...
[GDCBDE][2018-03-15 17:30:05] [SQLHLP] Dataset loaded: 1.07MB in 0.1s(0.0m) 17504 rows
[GDCBDE][2018-03-15 17:30:05] Rawdata copy: ['ID', 'CarID', 'CodeID', 'StrValue', 'Value', 'ViewVal', 'ViewStr', 'TimeStamp']
[GDCBDE][2018-03-15 17:30:05] [SQLHLP] Loading file [..\db_cache\SELECT_FROM_Accounts_.csv] ...
[GDCBDE][2018-03-15 17:30:05] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 3 rows
[GDCBDE][2018-03-15 17:30:05] Loaded 3 accounts
[GDCBDE][2018-03-15 17:30:05] [SQLHLP] Downloading data [SELECT c.ID Masina, f.Name Flo..] ...
[GDCBDE][2018-03-15 17:30:05] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 57 rows
[GDCBDE][2018-03-15 17:30:05] CarsxAccounts copy: ['Masina', 'Flota', 'FlotaID']
[GDCBDE][2018-03-15 17:30:05] Done data preparation.
[GDCBDE][2018-03-15 17:30:05] [SQLHLP] Downloading data [SELECT * FROM [RawData]..] ...
[GDCBDE][2018-03-15 17:30:37] [SQLHLP] Dataset loaded: 32.77MB in 31.4s(0.5m) 477173 rows
[GDCBDE][2018-03-15 17:30:37] [SQLHLP] Downloading data [SELECT * FROM [Accounts]..] ...
[GDCBDE][2018-03-15 17:30:37] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 3 rows
[GDCBDE][2018-03-15 17:30:37] [SQLHLP] Downloading data [SELECT * FROM [Cars]..] ...
[GDCBDE][2018-03-15 17:30:37] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 57 rows
[GDCBDE][2018-03-15 17:30:37] [SQLHLP] Downloading data [SELECT * FROM [Codes]..] ...
[GDCBDE][2018-03-15 17:30:37] [SQLHLP] Dataset loaded: 0.01MB in 0.1s(0.0m) 134 rows
[GDCBDE][2018-03-15 17:30:37] [SQLHLP] Downloading data [SELECT * FROM [CarsXCodes_v2]..] ...
[GDCBDE][2018-03-15 17:30:37] [SQLHLP] Dataset loaded: 0.02MB in 0.1s(0.0m) 519 rows
[GDCBDE][2018-03-15 17:30:37] ....Trying to associate code and description columns to df_rawdata_toshow
[GDCBDE][2018-03-15 17:30:37] Finished associating columns
[GDCBDE][2018-03-15 17:30:37] Rawdata copy: ['ID', 'CarID', 'CodeID', 'StrValue', 'Value', 'ViewVal', 'ViewStr', 'TimeStamp', 'DeviceSN', 'Description', 'Code']
[GDCBDE][2018-03-15 17:30:52] [SQLHLP] Downloading data [SELECT * FROM [Users]..] ...
[GDCBDE][2018-03-15 17:30:52] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 3 rows
[GDCBDE][2018-03-15 17:30:52] [SQLHLP] Downloading data [SELECT * FROM [Users]..] ...
[GDCBDE][2018-03-15 17:30:52] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 3 rows
[GDCBDE][2018-03-15 17:31:39] [SQLHLP] Downloading data [SELECT * FROM [Users]..] ...
[GDCBDE][2018-03-15 17:31:39] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 3 rows
[GDCBDE][2018-03-15 17:31:39] [SQLHLP] Downloading data [SELECT * FROM [Users]..] ...
[GDCBDE][2018-03-15 17:31:39] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 3 rows
[GDCBDE][2018-03-15 17:31:39] [SQLHLP] SAVING TABLE [APPEND](3 records 0.00MB)...
[GDCBDE][2018-03-15 17:31:40] [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, 'Nume_test                     ', 'Prenume_test                  ', '0712666999          ', 'email_test@gmail.com                    ', 'pass_test                               ', 'companie                      ', 'nume_comp_test                                              ', 'descriere_test                                                                                      ', 'admin               ', None), (3, 'test                          ', 'test                          ', '1231231232          ', 'email@asda.com                          ', 'test                                    ', 'asdasd                        ', 'asdasd                                                      ', 'asdasd                                                                                              ', 'admin               ', None), (8, 'test2323                      ', 'test2323                      ', 'test2323            ', 'test2323                                ', 'test2323                                ', 'test2323                      ', 'test2323                                                    ', 'test2323                                                                                            ', 'test2323            ', None))] (Background on this error at: http://sqlalche.me/e/gkpj)