MichiP 0 Posted October 22, 2017 Share Posted October 22, 2017 Hi, there is a error in the Updatadatabase.The airways seemed to be corrupt. Please take a look at it. Greeting Mike Example: Original airac from Pilot2Atc (1705) Airway "UL610" select Id from Airways where Identifier = 'UL610'; Result: 5283 select Airways.Id, Fix1Identifier, Fix2Identifier from AirwaySegments, Airways where AirwaySegments.Airway_Id = Airways.Id and Airways.Identifier = 'UL610'; Result: 5283 KFK KARGI 5283 KARGI SOMGU 5283 SOMGU ELVON 5283 ELVON DEKEK 5283 DEKEK YAA 5283 YAA IST 5283 IST FENER 5283 FENER VADEN 5283 UTEKA DONIV 5283 DONIV PELOV 5283 PELOV TISAK 5283 TISAK TONDO 5283 RENKA GONBA 5283 GONBA STAUB 5283 STAUB MAMOR 5283 MAMOR UNKUL 5283 UNKUL UPALA 5283 UPALA INBED 5283 INBED LOHRE 5283 LOHRE ADKUV 5283 ADKUV LAMLA 5283 LAMLA BATTY 5283 NIK DENUT 5283 DENUT LUMEN 5283 LUMEN BULAM 5283 BULAM DIBLI 5283 DIBLI RAPIX 5283 RAPIX SUNUP 5283 SUNUP TEBRA 5283 TEBRA KOPUL 5283 KOPUL UNSAD 5283 UNSAD NILON 5283 NILON GILDA 5283 GILDA LAM 5283 LAM HEMEL After Update: select Id from Airways where Identifier = 'UL610'; Result: 6980 6981 6982 6983 thats the first error because i assume that should be a unique id. select Airways.Id, Fix1Identifier, Fix2Identifier from AirwaySegments, Airways where AirwaySegments.Airway_Id = Airways.Id and Airways.Identifier = 'UL610'; 6980 UL610 UL610 6980 UL610 UL610 6980 UL610 UL610 6980 UL610 UL610 6981 UL610 UL610 6981 UL610 UL610 6981 UL610 UL610 6981 UL610 UL610 6981 UL610 UL610 6981 UL610 UL610 6981 UL610 UL610 6981 UL610 UL610 6981 UL610 UL610 6981 UL610 UL610 6982 UL610 UL610 6982 UL610 UL610 6982 UL610 UL610 6982 UL610 UL610 6982 UL610 UL610 6982 UL610 UL610 6982 UL610 UL610 6982 UL610 UL610 6983 UL610 UL610 6983 UL610 UL610 6983 UL610 UL610 6983 UL610 UL610 6983 UL610 UL610 6983 UL610 UL610 6983 UL610 UL610 6983 UL610 UL610 6983 UL610 UL610 6983 UL610 UL610 6983 UL610 UL610 6983 UL610 UL610 6983 UL610 UL610 thats the second error. Link to comment Share on other sites More sharing options...
Administrator Guenter Zehnel 77 Posted October 23, 2017 Administrator Share Posted October 23, 2017 Hello, we will check it. Thank you for the information. Link to comment Share on other sites More sharing options...
Administrator Guenter Zehnel 77 Posted October 25, 2017 Administrator Share Posted October 25, 2017 Hello, there is a new version of the dataset available. It fixes the second error you described. Use the NavDataPro client to download it again. The first problem in your descrption isn't wrong. There are really more than one entries for UL610 in the source file. Link to comment Share on other sites More sharing options...
MichiP 0 Posted October 25, 2017 Author Share Posted October 25, 2017 Hi, I did a first test. It seems that the Problem is solved. Thank you. Greetings Mike Link to comment Share on other sites More sharing options...
Aerosoft Aerosoft Team [Inactive Account] 51558 Posted October 27, 2017 Aerosoft Share Posted October 27, 2017 Because we believe this topic has been answered we have closed it. If you have any more questions feel free to open a new topic. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.