Tag: Serial Data

Categories
Knowledge Support Support exacqVision Client exacqVision Server Categories

Search for Serial Data unexpectedly fails to return results

Description

When set to record, exacqVision Server stores serial data in a database called pospi.db

Default locations are:

  • Windows
    C:\Program Files\exacqVision\Server\pospi.db
  • Linux
    /usr/local/exacq/server/pospi.db

After verifying that serial data is configured correctly and data is being received if searches fail to return results for serial events check the exacqVision Server logs for entries similar to the following.

POSPI    Warning    Failed to insert new record into posdb. Statement step failed: 11 database disk image is malformed
POSPI    Warning    statement reset failed: database disk image is malformed

These messages are indicating the database is corrupted.

Solution

  1. Stop the exacqVision Server Service
  2. Rename or remove the file pospi.db
  3. Restart the exacqVision Server Service
    Note: The service will detect the missing pospi.db and create a new empty one.
  4. Generate serial data
  5. Verify searches are now returning results.

Related articles:

<br>