Record stuck in Pervasive with no KID (Key ID=0)

Record stuck in Pervasive with no KID (Key ID=0)

Record stuck in Pervasive with no KID (Key ID=0)
KID is zero which should never happen. Will always happen to the LEAD pax.
So if you have a lead pax that shows up in every report for trips they are not even on, more than likely these instructions below will fix the issue.

There are 5 KIDs created:
1. Date
2. Time
3. User
4. Mult
5. Comm

When record is created a unique KID is created.

With FOS open on the server, go to Start – Pervasive – Control Center. Expand the computer name – databases- FOS data – Tables

Go to the Trip Passenger Table

Type in this:


With cursor in the space below, right click and choose Execute in Grid


In the bottom there should be a record for the name that was populating, right click and delete row

Once done, exit out and chose NO on the message

    • Related Articles

    • Repairing a Pervasive PSQL Key

      Before PSQL v11 SP3 a key in a Failed Validation or Disabled state meant a call to support. With Pervasive PSQL v11 SP3, Engineering has added a do it yourself Repair feature to the Pervasive License Administrator. It's simple to use - if your key is ...

    • Convert KID Date into real date

      In Pervasive and the Interface logs, you may run across KID dates. To mathematically turn these values into real dates you would take the KID date, add 1, put that in an Excel sheet, then convert the field to a date. For example: Convert KID date ...

    • Changing an Aircraft ID

      If you need to change an Aircraft Record's ID there are specific steps that need to be follow to make sure you successfully maintain the record's historical data. 1. Make sure all other users are out of FOS 2. Open the Aircraft Database and then the ...

    • Error: Invalid regulation key

      Error: ----Online Subpart Q Legality Checks Run---- Invalid regulation key ----Online Subpart Q Legality Checks End---- Solution: This error displays all other positions on the trip, aside from PIC. This error may occur if the FM credentials are ...

    • Extracting Data from FOS Pervasive Tables

      Installing Pervasive & Initial Information *If Pervasive is already installed on the machine, please skip to the next section (Extracting Data from the Pervasive Database)* Before beginning the extraction, you will need to download and install ...