Dear Forum,

I'm getting the below error when loading my scenery database. It's not pointing to a problematic airport that I can see.

Can anyone assist?

[2022-12-20 11:12:31.877 CRIT ]: Caught exception: NOT NULL constraint failed: tmp_waypoint.region Unable to fetch row. SqlQuery::exec(): Error executing query. Query is "insert into tmp_waypoint select waypoint_id,   case when type == 'V' then 'V' when type == 'N' then 'N' else 'O' end as type,   ident, region,   lonx, laty from waypoint".
[2022-12-20 11:13:54.938 DEBUG]: int atools::fs::weather::MetarIndex::readJson(QTextStream&, const QString&, bool) "https://api.ivao.aero/v2/airports/all/metar" 5406
[2022-12-20 11:13:55.480 DEBUG]: int atools::fs::weather::MetarIndex::readFlat(QTextStream&, const QString&, bool) "https://metar.vatsim.net/metar.php?id=ALL" 6033
[2022-12-20 11:13:59.504 DEBUG]: int atools::fs::weather::MetarIndex::readNoaaXplane(QTextStream&, const QString&, bool) "https://tgftp.nws.noaa.gov/data/observations/metar/cycles/12Z.TXT" 5318
[2022-12-20 11:14:00.248 DEBUG]: int atools::fs::weather::MetarIndex::readNoaaXplane(QTextStream&, const QString&, bool) "https://tgftp.nws.noaa.gov/data/observations/metar/cycles/11Z.TXT" 5328
[2022-12-20 11:14:01.276 DEBUG]: int atools::fs::weather::MetarIndex::readNoaaXplane(QTextStream&, const QString&, bool) "https://tgftp.nws.noaa.gov/data/observations/metar/cycles/10Z.TXT" 5328
[2022-12-20 11:19:19.619 DEBUG]: Closing database "C:/Users/JC/AppData/Roaming/ABarthel\\little_navmap_db\\little_navmap_compiling.sqlite"
[2022-12-20 11:19:19.629 INFO ]: Closed database "C:/Users/JC/AppData/Roaming/ABarthel\\little_navmap_db\\little_navmap_compiling.sqlite"
[2022-12-20 11:19:19.629 DEBUG]: void atools::sql::SqlDatabase::close() Removed "C:/Users/JC/AppData/Roaming/ABarthel\\little_navmap_db\\little_navmap_compiling.sqlite-journal"
[2022-12-20 11:19:19.629 INFO ]: Removed "C:/Users/JC/AppData/Roaming/ABarthel\\little_navmap_db\\little_navmap_compiling.sqlite"
[2022-12-20 11:19:19.629 DEBUG]: bool DatabaseManager::runInternal()
[2022-12-20 11:19:20.977 DEBUG]: void DatabaseManager::insertSimSwitchActions()
[2022-12-20 11:19:20.978 INFO ]: Opened database "C:/Users/JC/AppData/Roaming/ABarthel\\little_navmap_db\\little_navmap_xp11.sqlite"
[2022-12-20 11:19:20.979 DEBUG]: Closing database "C:/Users/JC/AppData/Roaming/ABarthel\\little_navmap_db\\little_navmap_xp11.sqlite"
[2022-12-20 11:19:20.979 INFO ]: Closed database "C:/Users/JC/AppData/Roaming/ABarthel\\little_navmap_db\\little_navmap_xp11.sqlite"
[2022-12-20 11:19:20.979 INFO ]: Opened database "C:/Users/JC/AppData/Roaming/ABarthel\\little_navmap_db\\little_navmap_navigraph.sqlite"
[2022-12-20 11:19:20.992 DEBUG]: Closing database "C:/Users/JC/AppData/Roaming/ABarthel\\little_navmap_db\\little_navmap_navigraph.sqlite"
[2022-12-20 11:19:20.992 INFO ]: Closed database "C:/Users/JC/AppData/Roaming/ABarthel\\little_navmap_db\\little_navmap_navigraph.sqlite"
[2022-12-20 11:19:26.306 DEBUG]: static void atools::gui::HelpHandler::openFile(QWidget*, const QString&) "C:/Users/JC/AppData/Local/Temp/abarthel-little_navmap.log"
[2022-12-20 11:19:26.306 DEBUG]: static void atools::gui::HelpHandler::openUrl(QWidget*, const QUrl&) About to open URL QUrl("file:///C:/Users/JC/AppData/Local/Temp/abarthel-little_navmap.log")
 

Update to the release candidate. It is fixed there:

Alex

Thanks for your help and continued support