Page 2 of 2

Re: New SQL server plugin

Posted: Thu Feb 08, 2018 9:42 pm
by pavelkonir
I tried importing into SQL Server (2017 in docker container). The database was completely empty. User vrs is dbowner.

BaseStation Import
Source: [SQLite] /Users/pavel/.local/share/VirtualRadar/BaseStation.sqb
Target: [SqlServer] Server=localhost,1401;UID=vrs; Password=vrs-password1;Database=vrs; (apply schema)
Aircraft: Import / Update
Locations: Import / Update
Sessions: Import / Update
Flights: Import / Update 0001-01-01 to 9999-12-31

[####################] [1 / 1] [100.0%] 00:00:00 Applying schema
[####################] [1 / 1] [100.0%] 00:00:00 Importing locations
[####################] [1,487 / 1,487] [100.0%] 00:00:00 Importing sessions
[ ] [0 / 3,515,555] [0.0%] 00:00:00 Importing aircraft
Caught exception: System.ArgumentException: The parameter data type of System.Data.DataTable is invalid.
at System.Data.SqlClient.SqlParameter.InferSqlType (System.Object value) [0x00049] in <9ec44cbcc9fa4c6b81867c576ebbc98b>:0
at System.Data.SqlClient.SqlParameter.set_Value (System.Object value) [0x00008] in <9ec44cbcc9fa4c6b81867c576ebbc98b>:0
at Dapper.TableValuedParameter.Set (System.Data.IDbDataParameter parameter, System.Data.DataTable table, System.String typeName) [0x00007] in <63a8cc06dfb842f1823bc51677815d4b>:0
at Dapper.DataTableHandler.SetValue (System.Data.IDbDataParameter parameter, System.Object value) [0x00000] in <63a8cc06dfb842f1823bc51677815d4b>:0
at Dapper.SqlMapper+TypeHandlerCache`1[T].SetValue (System.Data.IDbDataParameter parameter, System.Object value) [0x00000] in <63a8cc06dfb842f1823bc51677815d4b>:0
at (wrapper dynamic-method) <>f__AnonymousType11`1[System.Data.DataTable]:ParamInfoa65b1f6a-b417-4973-8cb5-2e6e530e447c (System.Data.IDbCommand,object)
at Dapper.CommandDefinition.SetupCommand (System.Data.IDbConnection cnn, System.Action`2[T1,T2] paramReader) [0x000b4] in <63a8cc06dfb842f1823bc51677815d4b>:0
at Dapper.SqlMapper.QueryMultipleImpl (System.Data.IDbConnection cnn, Dapper.CommandDefinition& command) [0x000d0] in <63a8cc06dfb842f1823bc51677815d4b>:0
at Dapper.SqlMapper.QueryMultiple (System.Data.IDbConnection cnn, System.String sql, System.Object param, System.Data.IDbTransaction transaction, System.Nullable`1[T] commandTimeout, System.Nullable`1[T] commandType) [0x00018] in <63a8cc06dfb842f1823bc51677815d4b>:0
at VirtualRadar.Plugin.SqlServer.BaseStationDatabase+<>c__DisplayClass105_1.<UpsertManyAircraft>b__0 (VirtualRadar.Plugin.SqlServer.ConnectionWrapper wrapper) [0x00039] in <41efae8bf49945009e0487d3b50b2ebd>:0
at VirtualRadar.Plugin.SqlServer.BaseStationDatabase.PerformInConnection (System.Action`1[T] action) [0x0000f] in <41efae8bf49945009e0487d3b50b2ebd>:0
at VirtualRadar.Plugin.SqlServer.BaseStationDatabase.UpsertManyAircraft (System.Collections.Generic.IEnumerable`1[T] upsertAircraft) [0x00048] in <41efae8bf49945009e0487d3b50b2ebd>:0
at BaseStationImport.BaseStationImporter.LoadOrImportAircraft () [0x001d3] in <47632728a6c4447982a62992961cd869>:0
at BaseStationImport.BaseStationImporter.ProcessAircraft () [0x00010] in <47632728a6c4447982a62992961cd869>:0
at BaseStationImport.BaseStationImporter.Import () [0x00012] in <47632728a6c4447982a62992961cd869>:0
at BaseStationImport.CommandRunner_Import.Run () [0x002ca] in <47632728a6c4447982a62992961cd869>:0
at BaseStationImport.Program.Main (System.String[] args) [0x000f9] in <47632728a6c4447982a62992961cd869>:0

Full details have been recorded in the log