Problem and Solution
The following error is written in the FIX Analyser 2 Netprobe log when it cannot create its *.db file:
2021-07-13 05:18:56.030-0400 INFO: FIX-ANALYSER2[FIX Analyser 2 Sampler name] Opening order database file: FIX Analyser 2 ME name.FIX Analyser 2 Sampler name.db
2021-07-13 05:18:56.030-0400 ERROR: FIX-ANALYSER2[FIX Analyser 2 Sampler name] Failed to open order database connection: DBMSAPI: There was a problem connecting => db error msg: unable to open database file, db error code: 14 (type: DBMSAPI); unable to open database file
To address this, make sure that the FIX Analyser 2 Netprobe has read, write and execute permissions on the *.db file and the file's parent directory.
Location of the *.db file
- Default location - By default, the *.db file is created in the FIX Analyser 2 Netprobe's working directory. The working directory is logged in the FIX Analyser 2 Netprobe log file. Search the string "Running from". For example:
- 2022-07-22 15:50:19.298+0800 INFO: Running from: /home/MNL/sandbox/tickets/6371
- Configurable location - The location and filename of the *.db file can be modified by inputting an absolute path in the localCache > database > sqlite > file setting.