1. PDQ Deploy & Inventory Help Center
  2. Community
  3. PDQ Inventory
 

Important Notice: On February 29th, this community was put into read-only mode. All existing posts will remain but customers are unable to add new posts or comment on existing. Please feel to join our Community Discord for any questions and discussions.

Database Error - Uninstalled/Reinstalled

Avatar
BJ Hobbs

Can anyone help w/ this. I kept getting database errors so I completely uninstalled everything, reinstalled (deleted all the files in Admin Arsenal throughout the machine and after starting the scan I got this message.

 

CLR Version : 4.0.30319.42000 Comments : Database : C:\ProgramData\Admin Arsenal\PDQ Inventory\Database.db Email : Entry : C:\Program Files (x86)\Admin Arsenal\PDQ Inventory\PDQInventoryConsole.exe Error : There is an error with the database Error Type : AdminArsenal.Data.SQLite.SqliteCorruptException License Mode : Enterprise Mode Memory : 7 GB (5 GB free) Product : PDQ Inventory Subject : PDQ Inventory Diagnose Report Version : 11.2.0.0 Windows : Microsoft Windows 10 Pro (6.2.9200.0) There is an error with the database AdminArsenal.Data.SQLite.SqliteCorruptException Database: C:\ProgramData\Admin Arsenal\PDQ Inventory\Database.db Error Code: 11 SQL: "PRAGMA integrity_check" at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at AdminArsenal.Database.DatabaseSettings.IntegrityCheckInternal(String& output, String& error, String& stacktrace) at AdminArsenal.Database.DatabaseSettings.IntegrityCheck(String& output, String& error) at AdminArsenal.Services.BackgroundService.DatabaseIntegrityCheck() at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart()

0

Comments

1 comment
Date Votes
  • Avatar
    Marcel Lipovsky

    The database is located in C:\ProgramData\Admin Arsenal\PDQ Inventory

    To repair a corrupted database, use the database repair tool in File > Preferenes > Database > [Optimize Database]

    If it does not help try to run the SQLite console (same menu location) and run the following command:
    pragma integrity_check;

    Don't forget to backup the databse first!

    0