Error compiling XP11 Database

[HammerTime_MC]

Build 220:

Error in log file:

[noae]

20:14:19.5 Building database for X-Plane. Folder is: F:\Games\steamapps\common\X-Plane 11
20:14:19.5 Hand-placed localisers earth_nav.dat found.
20:14:19.5 Scanning F:\Games\steamapps\common\X-Plane 11\Custom Scenery\Global Airports\Earth nav data\earth_nav.dat
20:14:19.5 Decoding F:\Games\steamapps\common\X-Plane 11\Custom Scenery\Global Airports\Earth nav data\earth_nav.dat
20:14:19.5 PC format
20:14:19.5 1100 Version - data cycle 1912, build 20190024, metadata NavXP1100.  Copyright � 2019, Robin A. Peel (robin@x-plane.com).   This data is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version.  This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU General Public License for more details.  You should have received a copy of the GNU General Public License along with this program ("AptNavGNULicence.txt"); if not, write to the Free Software Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307, USA.
20:14:20.3 Scanning F:\Games\steamapps\common\X-Plane 11\Custom Scenery\Global Airports\Earth nav data\apt.dat
20:14:20.3 Decoding F:\Games\steamapps\common\X-Plane 11\Custom Scenery\Global Airports\Earth nav data\apt.dat
20:14:21.7 9364823 lines.
20:14:21.7 PC format
20:14:29.2 Done apt.dat
20:14:29.2 Scanning F:\Games\steamapps\common\X-Plane 11\Custom Data\earth_nav.dat
20:14:29.2 Decoding F:\Games\steamapps\common\X-Plane 11\Custom Data\earth_nav.dat
20:14:29.2 PC format
20:14:29.2 1100 Version - data cycle 2009, build 20200805, metadata NavXP1100. Copyright (c) 2020 Navigraph, Datasource Jeppesen
20:14:31.4 Scanning F:\Games\steamapps\common\X-Plane 11\Custom Data\earth_fix.dat
20:14:31.4 Decoding Intersections F:\Games\steamapps\common\X-Plane 11\Custom Data\earth_fix.dat
20:14:31.4 PC format
20:14:31.4 1101 Version - data cycle 2009, build 20200805, metadata FixXP1101. Copyright (c) 2020 Navigraph, Datasource Jeppesen
20:14:48.7 Scanning F:\Games\steamapps\common\X-Plane 11\Custom Data\earth_awy.dat
20:14:48.7 Decoding F:\Games\steamapps\common\X-Plane 11\Custom Data\earth_awy.dat
20:14:48.7 PC format
20:14:48.7 1100 Version - data cycle 2009, build 20200805, metadata AwyXP1100. Copyright (c) 2020 Navigraph, Datasource Jeppesen
20:14:50.3 SITET
20:14:50.6 SITET
20:14:53.8 Scanning CIFP files.
20:15:21.3 DownloadCurrentMetars thread started
20:15:21.3 Metar18Z.TXT started
20:15:21.3 Metar19Z.TXT started
20:15:24.3 Metar19Z.TXT done
20:15:25.0 Metar18Z.TXT done
20:15:25.0 DownloadCurrentMetars done
20:15:25.1 ProcessMetars done
20:15:30.2 Assigning 27449 approaches to airports.
20:15:30.2 Assigning 46896 departures to airports.
20:15:30.3 Patching lookup data for 52824 airways.
20:15:30.3 SITET
20:15:30.3 SITET
20:15:30.4 52824 airway segments remain after patching.
20:15:30.4 Preparing database for new data
20:15:30.4 Writing 0 Airspace Boundaries
20:15:30.5 Writing 36068 Airports
20:15:30.6 Error writing airport: 0Y3 [H] Stuttgart Memorial Hospital
20:15:30.6 WriteAirportsData: : Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 19: 'FOREIGN KEY constraint failed'.
   at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db)
   at Microsoft.Data.Sqlite.SqliteDataReader.NextResult()
   at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
   at Microsoft.Data.Sqlite.SqliteCommand.ExecuteNonQuery()
   at EFCore.BulkExtensions.SqlBulkOperation.Merge[T](DbContext context, Type type, IList`1 entities, TableInfo tableInfo, OperationType operationType, Action`1 progress)
   at EFCore.BulkExtensions.SqlBulkOperation.Merge[T](DbContext context, IList`1 entities, TableInfo tableInfo, OperationType operationType, Action`1 progress)
   at Plan_G.Data.FSData.WriteAirportsData(SortedDictionary`2 apts) in C:\Users\Tim\source\repos\Plan-G\Data\FSData.cs:line 1656
20:15:30.6 Writing 219909 Intersections
20:15:33.6 Generating Airways
20:15:33.9 Totals: isecs = 219909 isecs with routes = 0 airway segments = 0
20:15:33.9 Writing 52824 Airway Segments
20:15:42.1 Wrote 52824 airway segments.
20:15:42.1 Writing 4608 NDBs
20:15:42.2 Writing 3576 VORs
20:15:42.5 Writing 4671 VORs
20:15:42.8 Build-DB cleanup lambda
20:15:42.9 AirportsInBounds 1230
20:15:43.0 Too many apts (1230)
20:15:43.1 AirspaceInBounds 2288

[/noae]

[tim arnot]

Hmm. I don't get the error here, but I can see there's definitely a problem with 0YC heliport. I shall investigate that. Can I ask what addon scenery you have installed?

While I'm looking into the problem, here's a copy of the XP11 database from my system to get you going. Main difference is that my navdata is dated 1912 whereas yours is 2009.

https://1drv.ms/u/s!AkfXrd8YzuWw7AYDNQJs0VVjXS3j?e=femiAc

[HammerTime_MC]

Hmm. I don't get the error here, but I can see there's definitely a problem with 0YC heliport. I shall investigate that. Can I ask what addon scenery you have installed?

While I'm looking into the problem, here's a copy of the XP11 database from my system to get you going. Main difference is that my navdata is dated 1912 whereas yours is 2009.

https://1drv.ms/u/s!AkfXrd8YzuWw7AYDNQJs0VVjXS3j?e=femiAc

Hi Tim,

Valid question.

I have a largely stock XP11 install, as it is very much my "2nd" sim... Aside from the default install, I have some of Forkboy's Ortho in the US, but I dont think Arkansas is an area that's covered by that.. and some uk2000 airports... Possible error in the 2009 navdata?

Many thanks for the speedy reply, and for the XP DB

I
1000 Version
SCENERY

SCENERY_PACK Custom Scenery/X-Plane Landmarks - New York/
SCENERY_PACK Custom Scenery/X-Plane Landmarks - Washington DC/
SCENERY_PACK Custom Scenery/_DefaultStreets London-Heathrow/
SCENERY_PACK Custom Scenery/Airport Environment HD/
SCENERY_PACK Custom Scenery/Aerosoft - EDDF Frankfurt/
SCENERY_PACK Custom Scenery/Aerosoft - EDLP Paderborn-Lippstadt/
SCENERY_PACK Custom Scenery/Aerosoft - EGLL Airport London-Heathrow/
SCENERY_PACK Custom Scenery/Aerosoft - LFMN Nice Cote d Azur X/
SCENERY_PACK Custom Scenery/Aerosoft - LFPO Paris Orly/
SCENERY_PACK Custom Scenery/Aerosoft - LPFR Faro/
SCENERY_PACK Custom Scenery/UK2000 Aberdeen Xtreme/
SCENERY_PACK Custom Scenery/UK2000 Belfast City Xtreme/
SCENERY_PACK Custom Scenery/UK2000 Birmingham Xtreme/
SCENERY_PACK Custom Scenery/UK2000 East Midlands Xtreme/
SCENERY_PACK Custom Scenery/UK2000 Edinburgh Xtreme/
SCENERY_PACK Custom Scenery/UK2000 Gatwick Xtreme/
SCENERY_PACK Custom Scenery/UK2000 Guernsey Xtreme/
SCENERY_PACK Custom Scenery/UK2000 Liverpool Xtreme/
SCENERY_PACK Custom Scenery/UK2000 Luton Xtreme/
SCENERY_PACK Custom Scenery/UK2000 Manchester Xtreme/
SCENERY_PACK Custom Scenery/UK2000 Prestwick Xtreme/
SCENERY_PACK Custom Scenery/UK2000_Cardiff_Xtreme/
SCENERY_PACK Custom Scenery/UK2000_Norwich_Xtreme/
SCENERY_PACK Custom Scenery/UK2000_Stansted_Xtreme/
SCENERY_PACK Custom Scenery/Global Airports/
SCENERY_PACK Custom Scenery/KSEA Demo Area/
SCENERY_PACK Custom Scenery/LOWI Demo Area/
SCENERY_PACK Custom Scenery/X-Plane Landmarks - Chicago/
SCENERY_PACK Custom Scenery/X-Plane Landmarks - Dubai/
SCENERY_PACK Custom Scenery/X-Plane Landmarks - Las Vegas/
SCENERY_PACK Custom Scenery/X-Plane Landmarks - London/
SCENERY_PACK Custom Scenery/X-Plane Landmarks - Sydney/
SCENERY_PACK Custom Scenery/yOrtho4XP_Overlays/
SCENERY_PACK Custom Scenery/Arizona_2015_1m/
SCENERY_PACK Custom Scenery/Idaho_2015_1m/
SCENERY_PACK Custom Scenery/Nevada_2015_1m/
SCENERY_PACK Custom Scenery/z_ortho_California_v5/
SCENERY_PACK Custom Scenery/z_ortho_Oregon_v6/
SCENERY_PACK Custom Scenery/z_ortho_Washington_v6a/
SCENERY_PACK Custom Scenery/zOrtho4XP_+53-002/
SCENERY_PACK Custom Scenery/zOrtho4XP_+53-003/
SCENERY_PACK Custom Scenery/zzz_hd_global_scenery4/

[tim arnot]

Had you already built another database in the same session, when you built the X-Plane db?

I found some counters that were not being reset at the start of an X-Plane db build. That wouldn't be a problem if X-Plane was the first database built, but if you built the database for another sim first (or if you build the X-Plane database twice), then it would throw that error..

The good news is, if you start Plan-G with your current version, and build the X-Plane database without building any others, it should build fine. Just be sure to quit before you try to build it again!

[HammerTime_MC]

Had you already built another database in the same session, when you built the X-Plane db?

Ah yes I had Tim. I had built FSX, MSFS and P3D databases in the same session before attempting XP11. Will attempt again tonight.

Apologies for the delay in getting back to you