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.

PDQ Inventory syncing with Active Directory

Avatar
michael rawlings

Hi, hopefully you can all help 

Seeing the below SQLite Database  corruption when sync PDQ Inventory with Active Directory

 

 

SQLite database file is corrupt
AppDomain : PDQInventoryService.exe
CLR Version : 4.0.30319.42000
Current AppDomain : PDQInventoryService.exe
Database : C:\ProgramData\Admin Arsenal\PDQ Inventory\Database.db
Date : 2019-10-03T11:47:53.7177661Z
Entry : C:\Program Files (x86)\Admin Arsenal\PDQ Inventory\PDQInventoryService.exe
Error : SQLite database file is corrupt
Error Code : 11
Error Type : AdminArsenal.Data.SQLite.SqliteCorruptException
GetHashCode : 6673437
License Mode : Enterprise Mode
Manufacturer : VMware, Inc. (VMware Virtual Platform)
Memory : 6 GB (3 GB free)
Now : 03/10/2019 12:47:53
PID : 3912
Process : PDQInventoryService
Product : PDQ Inventory
SentryEnabled : True
Service Mode : Server
ServiceThread : AdminArsenal.PDQInventory.StartScheduledScans
SQL : delete from CollectionComputersRefresh where CollectionId = @0 and ComputerId = @1
Sqlite Connection Elapsed : 00:00:00
started : 03/10/2019 11:47:53
Version : 17.1.0.0
Windows : Microsoft Windows Server 2016 Standard (10.0.14393)

SQLite database file is corrupt
AdminArsenal.Data.SQLite.SqliteCorruptException
Database: C:\ProgramData\Admin Arsenal\PDQ Inventory\Database.db
Error Code: 11
SQL: delete from CollectionComputersRefresh where CollectionId = @0 and ComputerId = @1
Sqlite Connection Elapsed: 00:00:00
ServiceThread: AdminArsenal.PDQInventory.StartScheduledScans
GetHashCode: 6673437
Now: 03/10/2019 12:47:53
started: 03/10/2019 11:47:53
at AdminArsenal.Data.SQLite.SqliteEngine.TestReturnCode(Int32 code, String sql, SqliteEngine db)
at AdminArsenal.Data.SQLite.SqliteEngine.Statement.ExecuteNonQuery(Object[] parameters)
at AdminArsenal.Data.SQLite.SqliteEngine.Execute(SqliteTransaction transaction, String sql, Object[] parameters)
at AdminArsenal.Data.SQLite.SqliteConnection.Execute(String sql, Object[] parameters)
at AdminArsenal.PDQInventory.Collections.CollectionDataManager.InvalidateMembership(CollectionId collectionId, ComputerId computerId)
at AdminArsenal.PDQInventory.ComputerDataManager.SetComputerScanId(ComputerId computerId, ComputerScanId scanId)
at AdminArsenal.PDQInventory.ComputerScanDataManager.StartScan(ComputerId computerId, ScanProfileId scanProfileId, ComputerScanSource source, String consoleComputer, String consoleUser, Nullable`1 timeout, Boolean forceNew)
at AdminArsenal.PDQInventory.ComputerScanServer.StartScan(ComputerId computerId, ScanProfileId scanProfileId, ComputerScanSource source, Nullable`1 timeout, Boolean forceNew)
at AdminArsenal.PDQInventory.StartScheduledScans.Execute()
at AdminArsenal.Service.ServiceThread.TriggerExecuted()

0

Comments

1 comment
Date Votes
  • Official comment
    Avatar
    Steven van Dijk

    Hi Michael, I just submitted your post as a ticket so we can get and repair your database. If anyone needs help with corrupt databases in the future, just submit a support ticket and we can get it repaired for you.