New SQL server plugin

Discussions about the preview versions of Virtual Radar Server.
Forum rules
Please bear in mind if you do install a preview version that it is unfinished code, there may be bugs, bits missing, things that don't work etc.

Posts in this forum will not show up in forum search results. Old threads will be pruned occasionally.
pavelkonir
Posts: 11
Joined: Mon Nov 21, 2016 11:40 am

Re: New SQL server plugin

Post by pavelkonir » Thu Feb 08, 2018 9:42 pm

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

Post Reply