AirportDelays rejected

[PicelBoi]

Describe the bug
AirportDelays is rejected by i2Service due to a missing exception_time_gmt, which is provided by the XML generated by i2ME.

To Reproduce
Steps to reproduce the behavior:

1. Have AirportDelays enabled in config.
2. Run i2ME.

Expected behavior
AirportDelays is processed by i2ME.

Log File

<Error dateTime="1/24/2026 05:59:51.176 PM" process="TWC.Executioner" thread="RoutineData(10)">exception during processing of record AirportDelays: TWC.I2.Util.DataAccess.DalStore.SqliteStoreExceptionWithRollbackFailure: SqliteStore.StoreData() Failure
Rollback Exception: DB Rollback due to: SqliteStore.StoreData() Failure ---&gt; TWC.I2.Util.DataAccess.DataAccessException: Expiration Path (process_time_gmt) not found for record type (AirportDelays)
   at TWC.I2.Util.DataAccess.DataAccessLayer.GetExpiration(XmlElement e, DataRecordDescriptor descriptor) in D:\buildsrc\tags\7.1.0-release\i2\src\lib\I2Libs\Util\DataAccess\DataAccessLayer.cs:line 510
   at TWC.I2.Util.DataAccess.DalStore.SqliteStore.Store(XmlElement record) in D:\buildsrc\tags\7.1.0-release\i2\src\lib\I2Libs\Util\DataAccess\DalStore\SqliteStore.cs:line 180
   at TWC.I2.Util.DataAccess.DalStore.AbtsractDalStore.StoreData(IEnumerable`1 records) in D:\buildsrc\tags\7.1.0-release\i2\src\lib\I2Libs\Util\DataAccess\DalStore\AbtsractDalStore.cs:line 63
   at TWC.I2.Util.DataAccess.DalStore.SqliteStore.StoreData(IEnumerable`1 records) in D:\buildsrc\tags\7.1.0-release\i2\src\lib\I2Libs\Util\DataAccess\DalStore\SqliteStore.cs:line 225
   --- End of inner exception stack trace ---
   at TWC.I2.Util.DataAccess.DalStore.SqliteStore.TryRollbackAndThrowSqliteStoreException(SQLiteTransaction trans, String msg, Exception ex) in D:\buildsrc\tags\7.1.0-release\i2\src\lib\I2Libs\Util\DataAccess\DalStore\SqliteStore.cs:line 539
   at TWC.I2.Util.DataAccess.DalStore.SqliteStore.StoreData(IEnumerable`1 records) in D:\buildsrc\tags\7.1.0-release\i2\src\lib\I2Libs\Util\DataAccess\DalStore\SqliteStore.cs:line 230
   at TWC.I2.Util.DataAccess.DataAccessLayer.StoreData(XmlDocument data) in D:\buildsrc\tags\7.1.0-release\i2\src\lib\I2Libs\Util\DataAccess\DataAccessLayer.cs:line 310
   at TWC.I2.AirportDelay.AirportDelayProcessor.ProcessAirportDelayRecord(XmlDocument docAirportDelayRecord) in D:\buildsrc\tags\7.1.0-release\i2\src\lib\I2Libs\AirportDelay\AirportDelayProcessor.cs:line 31
   at TWC.I2.FS.StoreData.getProcessors@52-16.Invoke(ProcessingContext ctx, a record) in D:\buildsrc\tags\7.1.0-release\i2\src\lib\I2FSharpLib\StoreDataJob.fs:line 52
   at TWC.I2.FS.StoreData.processElement[a,b,c](a context, b origElement, FSharpFunc`2 processor) in D:\buildsrc\tags\7.1.0-release\i2\src\lib\I2FSharpLib\StoreDataJob.fs:line 96
Rollback Exception: TWC.I2.Util.DataAccess.DalStore.SqliteStoreException: DB Rollback due to: SqliteStore.StoreData() Failure ---&gt; TWC.I2.Util.DataAccess.DataAccessException: Expiration Path (process_time_gmt) not found for record type (AirportDelays)
   at TWC.I2.Util.DataAccess.DataAccessLayer.GetExpiration(XmlElement e, DataRecordDescriptor descriptor) in D:\buildsrc\tags\7.1.0-release\i2\src\lib\I2Libs\Util\DataAccess\DataAccessLayer.cs:line 510
   at TWC.I2.Util.DataAccess.DalStore.SqliteStore.Store(XmlElement record) in D:\buildsrc\tags\7.1.0-release\i2\src\lib\I2Libs\Util\DataAccess\DalStore\SqliteStore.cs:line 180
   at TWC.I2.Util.DataAccess.DalStore.AbtsractDalStore.StoreData(IEnumerable`1 records) in D:\buildsrc\tags\7.1.0-release\i2\src\lib\I2Libs\Util\DataAccess\DalStore\AbtsractDalStore.cs:line 63
   at TWC.I2.Util.DataAccess.DalStore.SqliteStore.StoreData(IEnumerable`1 records) in D:\buildsrc\tags\7.1.0-release\i2\src\lib\I2Libs\Util\DataAccess\DalStore\SqliteStore.cs:line 225
   --- End of inner exception stack trace ---
   at TWC.I2.Util.DataAccess.DalStore.SqliteStore.TryRollbackAndThrowSqliteStoreException(SQLiteTransaction trans, String msg, Exception ex) in D:\buildsrc\tags\7.1.0-release\i2\src\lib\I2Libs\Util\DataAccess\DalStore\SqliteStore.cs:line 535</Error> 

System Information (please complete the following information):

• OS: Windows 11 IOT Enterprise
• Unit Version: XD
• Release Version: V1.4.1 Release Candidate 1

Additional context
None.

[A-c0rN]

I just noticed this log:
DB Rollback due to: SqliteStore.StoreData() Failure ---> TWC.I2.Util.DataAccess.DataAccessException: Expiration Path (process_time_gmt) not found for record type (AirportDelays)
If you can post the AirportDelays file that is generated, I can compare it against known working files.

[PicelBoi]

@A-c0rN

<Data type="AirportDelays">
  <AirportDelays xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
    <key>ASE</key>
    <icao_code>KASE</icao_code>
    <iata_code>ASE</iata_code>
    <faa_code>ASE</faa_code>
    <airport_name>Aspen-Pitkin Co/Sardy Field</airport_name>
    <delays>
      <category>arrival</category>
      <color>yellow</color>
      <delay_sec>900</delay_sec>
      <reasons_all>
        <delay>
          <reason>Other</reason>
          <category>arrival</category>
          <color>yellow</color>
          <delay_sec>900</delay_sec>
        </delay>
      </reasons_all>
    </delays>
    <arrival>
      <cancellations>0</cancellations>
      <percentage_cancelled>100</percentage_cancelled>
      <total>1000</total>
    </arrival>
    <departure>
      <cancellations>0</cancellations>
      <percentage_cancelled>100</percentage_cancelled>
      <total>1000</total>
    </departure>
    <process_time_gmt>1769212588</process_time_gmt>
  </AirportDelays>
  <AirportDelays xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
    <key>DEN</key>
    <icao_code>KDEN</icao_code>
    <iata_code>DEN</iata_code>
    <faa_code>DEN</faa_code>
    <airport_name>Denver International</airport_name>
    <delays>
      <category>arrival</category>
      <color>yellow</color>
      <delay_sec>0</delay_sec>
      <reasons_all>
        <delay>
          <reason />
          <category>arrival</category>
          <color>yellow</color>
          <delay_sec>0</delay_sec>
        </delay>
      </reasons_all>
    </delays>
    <arrival>
      <cancellations>0</cancellations>
      <percentage_cancelled>100</percentage_cancelled>
      <total>1000</total>
    </arrival>
    <departure>
      <cancellations>0</cancellations>
      <percentage_cancelled>100</percentage_cancelled>
      <total>1000</total>
    </departure>
    <process_time_gmt>1769212588</process_time_gmt>
  </AirportDelays>
  <AirportDelays xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
    <key>LAS</key>
    <icao_code>KLAS</icao_code>
    <iata_code>LAS</iata_code>
    <faa_code>LAS</faa_code>
    <airport_name>Harry Reid International</airport_name>
    <delays>
      <category>airport closure</category>
      <color>red</color>
      <delay_sec>0</delay_sec>
      <reasons_all>
        <delay>
          <reason>TO NON SKED TRANSIENT GA ACFT EXC 24HR PPR 702-261-7775</reason>
          <category>airport closure</category>
          <color>red</color>
          <delay_sec>0</delay_sec>
        </delay>
      </reasons_all>
    </delays>
    <arrival>
      <cancellations>0</cancellations>
      <percentage_cancelled>100</percentage_cancelled>
      <total>1000</total>
    </arrival>
    <departure>
      <cancellations>0</cancellations>
      <percentage_cancelled>100</percentage_cancelled>
      <total>1000</total>
    </departure>
    <process_time_gmt>1769212588</process_time_gmt>
  </AirportDelays>
  <AirportDelays xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
    <key>LAW</key>
    <icao_code>KLAW</icao_code>
    <iata_code>LAW</iata_code>
    <faa_code>LAW</faa_code>
    <airport_name>Lawton-Fort Sill Regional</airport_name>
    <delays>
      <category>airport closure</category>
      <color>red</color>
      <delay_sec>0</delay_sec>
      <reasons_all>
        <delay>
          <reason>Airport is closed</reason>
          <category>airport closure</category>
          <color>red</color>
          <delay_sec>0</delay_sec>
        </delay>
      </reasons_all>
    </delays>
    <arrival>
      <cancellations>0</cancellations>
      <percentage_cancelled>100</percentage_cancelled>
      <total>1000</total>
    </arrival>
    <departure>
      <cancellations>0</cancellations>
      <percentage_cancelled>100</percentage_cancelled>
      <total>1000</total>
    </departure>
    <process_time_gmt>1769212588</process_time_gmt>
  </AirportDelays>
  <AirportDelays xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
    <key>SAN</key>
    <icao_code>KSAN</icao_code>
    <iata_code>SAN</iata_code>
    <faa_code>SAN</faa_code>
    <airport_name>San Diego-Lindbergh Field</airport_name>
    <delays>
      <category>airport closure</category>
      <color>red</color>
      <delay_sec>0</delay_sec>
      <reasons_all>
        <delay>
          <reason>TO NON SKED TRANSIENT GA ACFT EXC PPR 619-298-7704</reason>
          <category>airport closure</category>
          <color>red</color>
          <delay_sec>0</delay_sec>
        </delay>
      </reasons_all>
    </delays>
    <arrival>
      <cancellations>0</cancellations>
      <percentage_cancelled>100</percentage_cancelled>
      <total>1000</total>
    </arrival>
    <departure>
      <cancellations>0</cancellations>
      <percentage_cancelled>100</percentage_cancelled>
      <total>1000</total>
    </departure>
    <process_time_gmt>1769212588</process_time_gmt>
  </AirportDelays>
  <AirportDelays xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
    <key>SEA</key>
    <icao_code>KSEA</icao_code>
    <iata_code>SEA</iata_code>
    <faa_code>SEA</faa_code>
    <airport_name>Seattle-Tacoma International</airport_name>
    <delays>
      <category>arrival</category>
      <color>yellow</color>
      <delay_sec>0</delay_sec>
      <reasons_all>
        <delay>
          <reason />
          <category>arrival</category>
          <color>yellow</color>
          <delay_sec>0</delay_sec>
        </delay>
      </reasons_all>
    </delays>
    <arrival>
      <cancellations>0</cancellations>
      <percentage_cancelled>100</percentage_cancelled>
      <total>1000</total>
    </arrival>
    <departure>
      <cancellations>0</cancellations>
      <percentage_cancelled>100</percentage_cancelled>
      <total>1000</total>
    </departure>
    <process_time_gmt>1769212588</process_time_gmt>
  </AirportDelays>
  <AirportDelays xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
    <key>SLC</key>
    <icao_code>KSLC</icao_code>
    <iata_code>SLC</iata_code>
    <faa_code>SLC</faa_code>
    <airport_name>Salt Lake City International</airport_name>
    <delays>
      <category>arrival</category>
      <color>yellow</color>
      <delay_sec>0</delay_sec>
      <reasons_all>
        <delay>
          <reason />
          <category>arrival</category>
          <color>yellow</color>
          <delay_sec>0</delay_sec>
        </delay>
      </reasons_all>
    </delays>
    <arrival>
      <cancellations>0</cancellations>
      <percentage_cancelled>100</percentage_cancelled>
      <total>1000</total>
    </arrival>
    <departure>
      <cancellations>0</cancellations>
      <percentage_cancelled>100</percentage_cancelled>
      <total>1000</total>
    </departure>
    <process_time_gmt>1769212588</process_time_gmt>
  </AirportDelays>
  <AirportDelays xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
    <key>SNA</key>
    <icao_code>KSNA</icao_code>
    <iata_code>SNA</iata_code>
    <faa_code>SNA</faa_code>
    <airport_name>John Wayne Airport-Orange County</airport_name>
    <delays>
      <category>airport closure</category>
      <color>red</color>
      <delay_sec>0</delay_sec>
      <reasons_all>
        <delay>
          <reason>Airport is closed</reason>
          <category>airport closure</category>
          <color>red</color>
          <delay_sec>0</delay_sec>
        </delay>
      </reasons_all>
    </delays>
    <arrival>
      <cancellations>0</cancellations>
      <percentage_cancelled>100</percentage_cancelled>
      <total>1000</total>
    </arrival>
    <departure>
      <cancellations>0</cancellations>
      <percentage_cancelled>100</percentage_cancelled>
      <total>1000</total>
    </departure>
    <process_time_gmt>1769212588</process_time_gmt>
  </AirportDelays>
  <AirportDelays xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
    <key>STX</key>
    <icao_code>KSTX</icao_code>
    <iata_code>STX</iata_code>
    <faa_code>STX</faa_code>
    <airport_name>Henry E. Rohlsen International Airport</airport_name>
    <delays>
      <category>airport closure</category>
      <color>red</color>
      <delay_sec>0</delay_sec>
      <reasons_all>
        <delay>
          <reason>TO NON SKED TRANSIENT GA ACFT EXC PPR 340-201-4645</reason>
          <category>airport closure</category>
          <color>red</color>
          <delay_sec>0</delay_sec>
        </delay>
      </reasons_all>
    </delays>
    <arrival>
      <cancellations>0</cancellations>
      <percentage_cancelled>100</percentage_cancelled>
      <total>1000</total>
    </arrival>
    <departure>
      <cancellations>0</cancellations>
      <percentage_cancelled>100</percentage_cancelled>
      <total>1000</total>
    </departure>
    <process_time_gmt>1769212588</process_time_gmt>
  </AirportDelays>
</Data>

[A-c0rN]

Looked through my archives, here's an example of a (supposedly) working Airport Delays call.

<Data type="AirportDelays">
  <AirportDelays id="8946084" locationKey="ATL" isWxscan="1">
    <airport_result>
      <class>airport_delays</class>
      <source>flightaware.com</source>
      <icao_code>KATL</icao_code>
      <iata_code>ATL</iata_code>
      <faa_code>ATL</faa_code>
      <airport_name>Hartsfield-Jackson Intl</airport_name>
      <local_airport_name />
      <departure>
        <cancellations>1</cancellations>
        <delays>21</delays>
        <percentage_cancelled>0</percentage_cancelled>
        <total>1699</total>
      </departure>
      <process_time_gmt>1601932682</process_time_gmt>
      <expire_time_gmt>1601936282</expire_time_gmt>
    </airport_result>
    <metadata>
      <language>en-US</language>
      <transaction_id>1601932811198:-994765503</transaction_id>
      <version>1</version>
      <airport_code>ATL</airport_code>
      <expire_time_gmt>1601936282</expire_time_gmt>
      <status_code>200</status_code>
    </metadata>
    <clientKey>ATL</clientKey>
  </AirportDelays>
</Data>

Here's one from the new, looks quite different... Don't know how important that is.

<Data type="AirportDelays">
  <AirportDelays xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
    <key>STX</key>
    <icao_code>KSTX</icao_code>
    <iata_code>STX</iata_code>
    <faa_code>STX</faa_code>
    <airport_name>Henry E. Rohlsen International Airport</airport_name>
    <delays>
      <category>airport closure</category>
      <color>red</color>
      <delay_sec>0</delay_sec>
      <reasons_all>
        <delay>
          <reason>TO NON SKED TRANSIENT GA ACFT EXC PPR 340-201-4645</reason>
          <category>airport closure</category>
          <color>red</color>
          <delay_sec>0</delay_sec>
        </delay>
      </reasons_all>
    </delays>
    <arrival>
      <cancellations>0</cancellations>
      <percentage_cancelled>100</percentage_cancelled>
      <total>1000</total>
    </arrival>
    <departure>
      <cancellations>0</cancellations>
      <percentage_cancelled>100</percentage_cancelled>
      <total>1000</total>
    </departure>
    <process_time_gmt>1769212588</process_time_gmt>
  </AirportDelays>
</Data>

[PicelBoi]

Looked through my archives, here's an example of a (supposedly) working Airport Delays call.

airport_delays flightaware.com KATL ATL ATL Hartsfield-Jackson Intl 1 21 0 1699 1601932682 1601936282 en-US 1601932811198:-994765503 1 ATL 1601936282 200 ATL Here's one from the new, looks quite different... Don't know how important that is. STX KSTX STX STX Henry E. Rohlsen International Airport airport closure red 0 TO NON SKED TRANSIENT GA ACFT EXC PPR 340-201-4645 airport closure red 0 0 100 1000 0 100 1000 1769212588

@A-c0rN seems like the data is surrounded by “airport_result”, so most likely if that’s what is required for airport delays to work I might modify the schema to add this tmrw and test this out

[A-c0rN]

The old format matches more closely to the XSL template, but I know there's data fields that have to be missing. I'll scrounge around and see if I can find more info in my archives, but may take awhile ( 30 gigs of 2020 i2m files to sift through ;-; )

[PicelBoi]

Seems like recreating that format fixed stuff, just gotta fill out possibly the rest.
This isn't how something like i2ME-Legacy does this btw, it actually sends the info for the currently set airports, not every airport listed on the FAA data type.