Hi, I'm trying to evaluation Pilot2Atc but after installing it it comes up with a tabe error using SQLLite, I tried to resolve this but still get the same issue could someone assist?

 

Thanks

Download and install the full version from the V3 Download page of the website. 

Only the full version has the data included, so installing the latest update without the full version would have a SQLite error because the data is missing.  This could also happen if the file was corrupted during download.

Then, if you have a Navigraph subscription and want to update the data, use the Navigraph Auto Update button in the Data Mnt tool's Data Conversion tab.  The Data Mnt tool can be found on the Utilities tab of Settings.

Dave

Hi Dave,

I have a similar problem. I downloaded the 'Pilot2ATCv3_Full_Setup_EarlyAccess_0.0.29 with Navigraph Data' and did a clean install. I then opened the Data Updater and used the Navigraph Auto Update button. After a while I got an error message:

code = Error (1), message = System.Data.SQLite.SQLiteException (0x87AF001F): SQL logic error
no such table: ATCControllers
   at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, SQLiteCommand command, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)
   at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
   at System.Data.SQLite.SQLiteDataReader.NextResult()
   at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
   at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
   at LinqToDB.Data.DataConnection.ExecuteReader(CommandBehavior commandBehavior)
   at LinqToDB.Data.DataConnection.ExecuteDataReader(CommandBehavior commandBehavior)
   at LinqToDB.Data.DataConnection.QueryRunner.ExecuteReader()
   at LinqToDB.Linq.QueryRunner.<ExecuteQuery>d__11`1.MoveNext()
   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
   at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
   at P2ADataLinq.Data.DataMgr.LoadATCControllers()
   at P2ADataLinq.Data.DataMgr.Init()

I'm on Windows 11.

At the moment there is no way for me to get p2atch to work.

 

Jens

 

8 hours ago, PapaWhiskey0976 said:

Hi Dave,

I have a similar problem. I downloaded the 'Pilot2ATCv3_Full_Setup_EarlyAccess_0.0.29 with Navigraph Data' and did a clean install. I then opened the Data Updater and used the Navigraph Auto Update button. After a while I got an error message:

code = Error (1), message = System.Data.SQLite.SQLiteException (0x87AF001F): SQL logic error
no such table: ATCControllers
   at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, SQLiteCommand command, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)
   at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
   at System.Data.SQLite.SQLiteDataReader.NextResult()
   at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
   at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
   at LinqToDB.Data.DataConnection.ExecuteReader(CommandBehavior commandBehavior)
   at LinqToDB.Data.DataConnection.ExecuteDataReader(CommandBehavior commandBehavior)
   at LinqToDB.Data.DataConnection.QueryRunner.ExecuteReader()
   at LinqToDB.Linq.QueryRunner.<ExecuteQuery>d__11`1.MoveNext()
   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
   at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
   at P2ADataLinq.Data.DataMgr.LoadATCControllers()
   at P2ADataLinq.Data.DataMgr.Init()

I'm on Windows 11.

At the moment there is no way for me to get p2atch to work.

 

Jens

 

Do you have a navigraph subscription?

Yes, I have a Navigraph subscription.

 

Jens

 

Hi, yes it was a clean install from your website, I also have a navigraph subscription. On windows 11, p3d v5.4

I have re downloaded this but it is saying my trial has expired so I cant get any further @Dave-Pilot2ATC

My email I registered as is [email protected]

Thanks for your email Dave, I managed to reset the trial and the application appears to be opening fine so I'll now go through the settings etc to review. Thanks for the prompt response!

Check to be sure you have Microsoft SQL Server 2019 LocalDB installed in your Windows -> Settings -> Apps & Features page.  This is needed to open and read the V2 data during the data conversion and is installed with the Full version of P2A.

Check the data folder for a file named P2ATCDynamicData.db and be sure its size is about 125,280 KB.  If it's 0, then look for a file named P2ADynamicDataBkup.db.  This is a backup file made during the conversion.  It should be of a similar size.  If so, delete the empty file and rename the backup file to P2ADynamicData.db.  If the backup file isn't there, you will need to download and install the full version again.

Make sure your Windows security software will allow P2A to read and write to disk in the location you have it installed.  Sometimes installing to a different location will solve these issues.  Installing directly to the C:\Pilot2ATC_3_x64 might fix these issues.

Once you have a good P2ADynamicData.db file in the Data folder, you should be able to run the Navigraph Auto Update process again.

Dave

It seems I solved my problem.

The steps above didn't resolve the database probem. After some tests I had a look into the Windows Event Log and there is an error message: LocalDB parent instance version is invalid: MSSQL12E.LOCALDB. For this error message I found a solution at dba.stackexchange.com. In the command shell (cmd) execute the following commands:

sqllocaldb stop MSSQLLocalDB
sqllocaldb delete MSSQLLocalDB
sqllocaldb create MSSQLLocalDB

After a reinstallation of P2A full installation and SQL Server 2019 LocalDB and before first start of P2A I executed the three commands. Now the Navigraph update is now working without any error.

Jens