Post
by pavelkonir » Wed Feb 07, 2018 1:16 pm
Connection is now ready, schema was created, but tables are empty. In log are errors.
[2018-02-07 13:13:43.328 UTC] [t19] Caught an exception on a fast tick heartbeat event: 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__AnonymousType7`1[System.Data.DataTable]:ParamInfof0cf69b1-cbe6-4694-a5bc-894802d42ceb (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+<QueryImpl>d__136`1[T].MoveNext () [0x000ba] in <63a8cc06dfb842f1823bc51677815d4b>:0
at System.Collections.Generic.List`1[T]..ctor (System.Collections.Generic.IEnumerable`1[T] collection) [0x00077] in <c9f8153c41de4f8cbafd0e32f9bf6b28>:0
at System.Linq.Enumerable.ToList[TSource] (System.Collections.Generic.IEnumerable`1[T] source) [0x00018] in <9da65c3aa2654e53b5f11b79677182e0>:0
at Dapper.SqlMapper.Query[T] (System.Data.IDbConnection cnn, System.String sql, System.Object param, System.Data.IDbTransaction transaction, System.Boolean buffered, System.Nullable`1[T] commandTimeout, System.Nullable`1[T] commandType) [0x0003c] in <63a8cc06dfb842f1823bc51677815d4b>:0
at VirtualRadar.Plugin.SqlServer.BaseStationDatabase+<>c__DisplayClass83_0.<GetManyAircraftAndFlightsCountByCode>b__0 (VirtualRadar.Plugin.SqlServer.ConnectionWrapper wrapper) [0x00042] in <41efae8bf49945009e0487d3b50b2ebd>:0
at VirtualRadar.Plugin.SqlServer.BaseStationDatabase.PerformInConnection (System.Action`1[T] action) [0x0000f] in <41efae8bf49945009e0487d3b50b2ebd>:0
at VirtualRadar.Plugin.SqlServer.BaseStationDatabase.GetManyAircraftAndFlightsCountByCode (System.Collections.Generic.IEnumerable`1[T] icao24s) [0x0001b] in <41efae8bf49945009e0487d3b50b2ebd>:0
at VirtualRadar.Library.AircraftDetailFetcher.DoFetchManyAircraft (System.Collections.Generic.IEnumerable`1[T] fetchedDetails) [0x000d4] in <b7286c723c894270aa8da0ed53899e65>:0
at VirtualRadar.Interface.AircraftFetcher`2[TKey,TDetail].FetchAllAircraft (System.Collections.Generic.IEnumerable`1[T] fetchedDetails) [0x00011] in <249e9c2d71db409a84e6c3a181bd8ef5>:0
at VirtualRadar.Interface.AircraftFetcher`2[TKey,TDetail].Heartbeat_FastTimerTicked (System.Object sender, System.EventArgs args) [0x00095] in <249e9c2d71db409a84e6c3a181bd8ef5>:0
at (wrapper dynamic-method) System.Object:lambda_method (System.Runtime.CompilerServices.Closure,object,object,System.EventArgs)
at VirtualRadar.Interface.EventHelper.Raise[TEventArgs] (System.Delegate eventHandler, System.Object sender, System.Func`1[TResult] buildArgsCallback, System.Action`1[T] exceptionCallback, System.Boolean throwEventHelperException) [0x000f5] in <249e9c2d71db409a84e6c3a181bd8ef5>:0
[2018-02-07 13:13:44.389 UTC] [t20] Caught an exception on a fast tick heartbeat event: 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__AnonymousType7`1[System.Data.DataTable]:ParamInfof0cf69b1-cbe6-4694-a5bc-894802d42ceb (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+<QueryImpl>d__136`1[T].MoveNext () [0x000ba] in <63a8cc06dfb842f1823bc51677815d4b>:0
at System.Collections.Generic.List`1[T]..ctor (System.Collections.Generic.IEnumerable`1[T] collection) [0x00077] in <c9f8153c41de4f8cbafd0e32f9bf6b28>:0
at System.Linq.Enumerable.ToList[TSource] (System.Collections.Generic.IEnumerable`1[T] source) [0x00018] in <9da65c3aa2654e53b5f11b79677182e0>:0
at Dapper.SqlMapper.Query[T] (System.Data.IDbConnection cnn, System.String sql, System.Object param, System.Data.IDbTransaction transaction, System.Boolean buffered, System.Nullable`1[T] commandTimeout, System.Nullable`1[T] commandType) [0x0003c] in <63a8cc06dfb842f1823bc51677815d4b>:0
at VirtualRadar.Plugin.SqlServer.BaseStationDatabase+<>c__DisplayClass83_0.<GetManyAircraftAndFlightsCountByCode>b__0 (VirtualRadar.Plugin.SqlServer.ConnectionWrapper wrapper) [0x00042] in <41efae8bf49945009e0487d3b50b2ebd>:0
at VirtualRadar.Plugin.SqlServer.BaseStationDatabase.PerformInConnection (System.Action`1[T] action) [0x0000f] in <41efae8bf49945009e0487d3b50b2ebd>:0
at VirtualRadar.Plugin.SqlServer.BaseStationDatabase.GetManyAircraftAndFlightsCountByCode (System.Collections.Generic.IEnumerable`1[T] icao24s) [0x0001b] in <41efae8bf49945009e0487d3b50b2ebd>:0
at VirtualRadar.Library.AircraftDetailFetcher.DoFetchManyAircraft (System.Collections.Generic.IEnumerable`1[T] fetchedDetails) [0x000d4] in <b7286c723c894270aa8da0ed53899e65>:0
at VirtualRadar.Interface.AircraftFetcher`2[TKey,TDetail].FetchAllAircraft (System.Collections.Generic.IEnumerable`1[T] fetchedDetails) [0x00011] in <249e9c2d71db409a84e6c3a181bd8ef5>:0
at VirtualRadar.Interface.AircraftFetcher`2[TKey,TDetail].Heartbeat_FastTimerTicked (System.Object sender, System.EventArgs args) [0x00095] in <249e9c2d71db409a84e6c3a181bd8ef5>:0
at (wrapper dynamic-method) System.Object:lambda_method (System.Runtime.CompilerServices.Closure,object,object,System.EventArgs)
at VirtualRadar.Interface.EventHelper.Raise[TEventArgs] (System.Delegate eventHandler, System.Object sender, System.Func`1[TResult] buildArgsCallback, System.Action`1[T] exceptionCallback, System.Boolean throwEventHelperException) [0x000f5] in <249e9c2d71db409a84e6c3a181bd8ef5>:0