There is an error with the database

Purpose:

PDQ Deploy or PDQ Inventory reports there is an error with the database due to "SQL: "PRAGMA integrity_check".

Some possible causes are: 

  • Corrupt database.
  • Orphaned\stuck registry key pertaining to a database integrity check.

Resolution:

  • Restart PDQ Deploy or PDQ Inventory service.
  • Run the database repair command in an elevated command prompt for the corresponding application.
    • pdqdeploy repairdatabase
    • pdqinventory repairdatabase
  • Delete registry key pertaining to a database integrity check.
    • Stop PDQ Deploy or PDQ Inventory service.
    • Delete the registry key below corresponding to the application.
      • HKLM\SOFTWARE\Admin Arsenal\PDQ Deploy\Settings\Database
      • HKLM\SOFTWARE\Admin Arsenal\PDQ Inventory\Settings\Database
    • Start PDQ Deploy or PDQ Inventory service.

 

Notes

It is recommended to whitelist the PDQ Deploy and PDQ Inventory database directories from software that may interfere.

%PROGRAMDATA%\AdminArsenal

 

See Also:

Article - Recommended Antivirus/Antimalware Exclusions for PDQ Products

 

Still have a question or want to share what you have learned? Visit our Community to get help and collaborate with others.