haeriphos

Unhandled Exception

Recommended Posts

Planning a flight from SARI to SPIM, both of which were accepted by P2A. As soon as I click STAR I get an unhandled exception"

************** Exception Text **************
System.Data.Entity.Core.EntityCommandExecutionException: An error occurred while executing the command definition. See the inner exception for details. ---> System.Data.SqlClient.SqlException: Invalid column name 'NavaidIdentifier'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.<Reader>b__c(DbCommand t, DbCommandInterceptionContext`1 c)
   at System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TTarget,TInterceptionContext,TResult](TTarget target, Func`3 operation, TInterceptionContext interceptionContext, Action`3 executing, Action`3 executed)
   at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.Reader(DbCommand command, DbCommandInterceptionContext interceptionContext)
   at System.Data.Entity.Internal.InterceptableDbCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)
   --- End of inner exception stack trace ---
   at System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)
   at System.Data.Entity.Core.Objects.Internal.ObjectQueryExecutionPlan.Execute[TResultType](ObjectContext context, ObjectParameterCollection parameterValues)
   at System.Data.Entity.Core.Objects.ObjectQuery`1.<>c__DisplayClass7.<GetResults>b__6()
   at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess)
   at System.Data.Entity.Core.Objects.ObjectQuery`1.<>c__DisplayClass7.<GetResults>b__5()
   at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute[TResult](Func`1 operation)
   at System.Data.Entity.Core.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption)
   at System.Data.Entity.Core.Objects.ObjectQuery`1.Execute(MergeOption mergeOption)
   at System.Data.Entity.Core.Objects.DataClasses.EntityCollection`1.Load(List`1 collection, MergeOption mergeOption)
   at System.Data.Entity.Core.Objects.DataClasses.EntityCollection`1.Load(MergeOption mergeOption)
   at System.Data.Entity.Core.Objects.DataClasses.RelatedEnd.DeferredLoad()
   at System.Data.Entity.Core.Objects.Internal.LazyLoadBehavior.LoadProperty[TItem](TItem propertyValue, String relationshipName, String targetRoleName, Boolean mustBeNull, Object wrapperObject)
   at System.Data.Entity.Core.Objects.Internal.LazyLoadBehavior.<>c__DisplayClass7`2.<GetInterceptorDelegate>b__1(TProxy proxy, TItem item)
   at System.Data.Entity.DynamicProxies.APPRTransition_327C947D3B3A58F6BFABC11661B1586FF1C5E188771BB34C52CA19AF1F594B5C.get_TERP_Legs()
   at P2A_2016.Airport.AddRecommendedTransition(FINALApproach& Appr, FPWpt LastRouteWpt)
   at P2A_2016.Airport.GetRecommendedApproach(String RWYName, String Type, FPWpt LastRouteWpt, String TransName)
   at P2A_2016.Airport.CreateRecommendedApproachPlan(String RWName, String ApprType, FltPlan FP, Boolean UseRecommendedSTAR)
   at P2A_2016.Airport.SetUpForIFRArrival(String SimRwyName, FltPlan FP, String ApprType, Boolean UseRecommendedSTAR)
   at P2A_2016.Airport.SetUpIFRArrivalOperations(String SimRwyName, FltPlan FP, String RequestedRWName)
   at P2A_2016.frmSTARs.set_Airport(Airport value)
   at P2A_2016.frmSTARs.set_FlightPln(FltPlan value)
   at P2A_2016.ucFltPln.d(Object A_0, EventArgs A_1)
   at System.Windows.Forms.Control.OnClick(EventArgs e)
   at System.Windows.Forms.Button.OnClick(EventArgs e)
   at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ButtonBase.WndProc(Message& m)
   at System.Windows.Forms.Button.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

 

One unique thing about SPIM is that was recently renamed to SPJC. Trying to add SPJC also gives me an unhandled exception:

************** Exception Text **************
System.NullReferenceException: Object reference not set to an instance of an object.
   at P2A_2016.Airport.Init()
   at P2A_2016.FlightData.GetAirport(String ICAOCode)
   at P2A_2016.FlightData.GetNearestWaypoint(String Ident, GeoPoint Pos)
   at P2A_2016.ucFltPln.p(Object A_0, EventArgs A_1)
   at System.Windows.Forms.Control.OnClick(EventArgs e)
   at System.Windows.Forms.Button.OnClick(EventArgs e)
   at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ButtonBase.WndProc(Message& m)
   at System.Windows.Forms.Button.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

 

 


Share this post


Link to post
Share on other sites
Help AVSIM continue to serve you!
Please donate today!

Another possibly related update. I planned SLPO AKTUN UM548 ASI SPIM but when I tried to file the plan, nothing happened. I found some exceptions in the log which I'll post below. Possibly also something to do with SPIM/SPJC?

I filed the same route with destination of SPLP (just south of SPIM) and it worked fine.

 

Program StartedPilot 2 ATC (P2A) - version 2.2.1.8  06/30/2017 13:19:18
Application frmP2AMain starting 06/30/2017 13:19:37
 GPS FlightPlan Changed 
 GPS FlightPlan Changed 
 GPS FlightPlan Changed 
 GPS FlightPlan Changed 
 GPS FlightPlan Changed 
 GPS FlightPlan Changed 
Com1StandbyFreqChanged: 120.825.  CtlrShrtName: None Found;  CtlrType: None Found13:20:38
Com2FreqChanged: 118.25.  CtlrShrtName: None Found;  CtlrType: None Found13:20:38
Com2StandbyFreqChanged: 123.575.  CtlrShrtName: None Found;  CtlrType: None Found13:20:38
Pilot2ATC_200.exe	Information	0	SAPI does not implement phonetic alphabet selection.
No controller assigned 13:20:38
Sim Connected: 06/30/2017 13:20:38
ATCAssignsSIDs: False
ATCAssignsSTARs: False
ATCAssignsAPPRs: True
ForcePilotRunwaySelection: False
AutoLoadRecommendedProcedures: False
 GPS FlightPlan Changed 
SIM Version Num: 8; SIM Version: XP; ProcessCheck for FSX or P3D: False False13:20
Begin FPLFile 06/30/2017 13:20:45
AssignedRunway: RW24 - 
Error in btnFPLFile: System.Data.Entity.Core.EntityCommandExecutionException: An error occurred while executing the command definition. See the inner exception for details. ---> System.Data.SqlClient.SqlException: Invalid column name 'NavaidIdentifier'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.<Reader>b__c(DbCommand t, DbCommandInterceptionContext`1 c)
   at System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TTarget,TInterceptionContext,TResult](TTarget target, Func`3 operation, TInterceptionContext interceptionContext, Action`3 executing, Action`3 executed)
   at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.Reader(DbCommand command, DbCommandInterceptionContext interceptionContext)
   at System.Data.Entity.Internal.InterceptableDbCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)
   --- End of inner exception stack trace ---
   at System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)
   at System.Data.Entity.Core.Objects.Internal.ObjectQueryExecutionPlan.Execute[TResultType](ObjectContext context, ObjectParameterCollection parameterValues)
   at System.Data.Entity.Core.Objects.ObjectQuery`1.<>c__DisplayClass7.<GetResults>b__6()
   at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess)
   at System.Data.Entity.Core.Objects.ObjectQuery`1.<>c__DisplayClass7.<GetResults>b__5()
   at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute[TResult](Func`1 operation)
   at System.Data.Entity.Core.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption)
   at System.Data.Entity.Core.Objects.ObjectQuery`1.Execute(MergeOption mergeOption)
   at System.Data.Entity.Core.Objects.DataClasses.EntityCollection`1.Load(List`1 collection, MergeOption mergeOption)
   at System.Data.Entity.Core.Objects.DataClasses.EntityCollection`1.Load(MergeOption mergeOption)
   at System.Data.Entity.Core.Objects.DataClasses.RelatedEnd.DeferredLoad()
   at System.Data.Entity.Core.Objects.Internal.LazyLoadBehavior.LoadProperty[TItem](TItem propertyValue, String relationshipName, String targetRoleName, Boolean mustBeNull, Object wrapperObject)
   at System.Data.Entity.Core.Objects.Internal.LazyLoadBehavior.<>c__DisplayClass7`2.<GetInterceptorDelegate>b__1(TProxy proxy, TItem item)
   at System.Data.Entity.DynamicProxies.APPRTransition_327C947D3B3A58F6BFABC11661B1586FF1C5E188771BB34C52CA19AF1F594B5C.get_TERP_Legs()
   at P2A_2016.Airport.AddRecommendedTransition(FINALApproach& Appr, FPWpt LastRouteWpt)
   at P2A_2016.Airport.GetRecommendedApproach(String RWYName, String Type, FPWpt LastRouteWpt, String TransName)
   at P2A_2016.modGlobalSpeech.SetUpArrivalAirport(Airport Apt, FltPlan FP, Boolean UpdateATCFltPlan, Boolean PreliminarySetup, String ReqRWName, Boolean StarIsOptional)
   at P2A_2016.ucFltPln.q(Object A_0, EventArgs A_1)

 

Share this post


Link to post
Share on other sites

Thanks for the report.

I did find a bug that caused the issue with SPIM and in the next update, if an airport is out of date, like SPIM, you will not be allowed to try and add procedures, but will get a message that the airport is renamed or has no instrument procedures.

I couldn't recreate the error for SPJC, but that could have been fixed with the other bug.

Thanks,

Dave

 

Share this post


Link to post
Share on other sites

Yes, SPIM is not really a valid airport anymore, so I suggest you use SPJC for all flight planning.  SPIM is in the "old data" that is kept around mainly for small, remote airports that are not included in AIRAC updates.

In fact, I will be removing it from the BaseData because I believe that is what causes the error when looking for data about SPJC.

Dave

Share this post


Link to post
Share on other sites

Also, in the current version, because of the above, SPJC will not work correctly.  For example, no Controllers.

So, no trips to Lima until 2219.

Sorry,

Dave

Share this post


Link to post
Share on other sites

No worries, every bug I find today is another I won't have to deal with later on down the road!

SPLP also didn't work. It appeared to file fine, but no one would respond to me when I called for clearance. This was in the log:

Error in btnFPLFile: System.NullReferenceException: Object reference not set to an instance of an object.
   at P2A_2016.ATCFlt.SetNearestActiveWaypoint(Int32 AcftMagHdg)
   at P2A_2016.ucFltPln.q(Object A_0, EventArgs A_1)

The next airport to the south, SPLX, appears to be working fine. I'll just fly up there and go VFR the rest of the way to Lima :)

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now