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 Database corruption

William Apgar

September 29, 2014 17:42

Starting last Thursday, I've been seeing every 10 seconds, in my Event Log under Application, an error for PDQ Inventory. Everything seems to be running ok, I can scan computers, Active Directory integration seems to be pulling in new computers just fine, so I'm not really sure what the issue might be (other than filling up my event log). I'm not sure what changed Thursday, but I hadn't noticed it before that.

The following is the entry I'm getting, it seems to be the same every time:

CLR Version : 4.0.30319.34209
Entry       : C:\Program Files (x86)\Admin Arsenal\PDQ Inventory\PDQInventoryService.exe
Error       : SQLite database file is corrupt
Error Type : AdminArsenal.Data.SQLite.SqliteCorruptException
Memory      : 8 GB (2 GB free)
Product     : PDQ Inventory
Version     : 3.1.3.0
Windows     : Microsoft Windows 7 Professional (6.1.7601.65536)

SQLite database file is corrupt
AdminArsenal.Data.SQLite.SqliteCorruptException
Database: C:\ProgramData\Admin Arsenal\PDQ Inventory\Database.db
Error Code: 11
SQL: select ComputerId
                    from Computers left join
                    (select * from ScanProfileComputers where ScanProfileId = @0) SPC using (ComputerId)
                    where COALESCE(SPC.AttemptedScanDate, SPC.SuccessfulScanDate, datetime('now','-1 year')) <= @1
   at AdminArsenal.Data.SQLite.SqliteEngine.TestReturnCode(Int32 code, String sql, SqliteEngine db)
   at AdminArsenal.Data.SQLite.SqliteEngine.Statement.Next()
   at AdminArsenal.Data.SQLite.SqliteEngine.QueryScalars(String sql, Object[] parameters)
   at AdminArsenal.Data.SQLite.SqliteConnection.QueryIds[T](String sql, Object[] parameters)
   at AdminArsenal.PDQInventory.ScanProfile.GetScheduledComputerIds(DateTime date)
   at AdminArsenal.PDQInventory.StartScheduledScans.Execute()
   at AdminArsenal.Service.ServiceThread.Run()

Any help/advice would be welcome, thank you!

Comments

20 comments

Brandon Rewis
September 29, 2014 18:02

Hi William,

Run the SQL commands in the attached file in the Inventory DB.(File -> Preferences -> Database -> SQLite Console)

The commands should clear the DB errors you are seeing. Let me know if you continue seeing the DB errors after running the commands.

-Brandon

0
William Apgar
September 29, 2014 18:13

That seems to have fixed the issues. Thank you!

0
Shane Corellian
October 02, 2014 18:53

For others who experience a "SQLite database is corrupt" error, please post the error here. The SQL file that was posted was specific to the corrupted indexes specific to William's post. There are many tables and indexes that get corrupted. This is why we need to see the specific error to determine what to fix.

0
Rob Durkin
October 24, 2014 15:29

Here are the errors in my event log, looks similar to what I see above.

Log Name:      Application
Source:        PDQ Inventory
Date:          10/24/2014 8:27:08 AM
Event ID:      0
Task Category: None
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      OHS-Monitor.oregonhumane.org
Description:
CLR Version : 4.0.30319.18444
Entry       : C:\Program Files (x86)\Admin Arsenal\PDQ Inventory\PDQInventoryService.exe
Error       : SQLite database file is corrupt
Error Type : AdminArsenal.Data.SQLite.SqliteCorruptException
Memory      : 4 GB (1 GB free)
Product     : PDQ Inventory
Version     : 3.1.3.0
Windows     : Microsoft Windows 7 Professional (6.1.7601.65536)

SQLite database file is corrupt
AdminArsenal.Data.SQLite.SqliteCorruptException
Database: C:\ProgramData\Admin Arsenal\PDQ Inventory\Database.db
Error Code: 11
SQL: select ComputerId
                    from Computers left join
                    (select * from ScanProfileComputers where ScanProfileId = @0) SPC using (ComputerId)
                    where COALESCE(SPC.AttemptedScanDate, SPC.SuccessfulScanDate, datetime('now','-1 year')) <= @1
   at AdminArsenal.Data.SQLite.SqliteEngine.TestReturnCode(Int32 code, String sql, SqliteEngine db)
   at AdminArsenal.Data.SQLite.SqliteEngine.Statement.Next()
   at AdminArsenal.Data.SQLite.SqliteEngine.QueryScalars(String sql, Object[] parameters)
   at AdminArsenal.Data.SQLite.SqliteConnection.QueryIds[T](String sql, Object[] parameters)
   at AdminArsenal.PDQInventory.ScanProfile.GetScheduledComputerIds(DateTime date)
   at AdminArsenal.PDQInventory.StartScheduledScans.Execute()
   at AdminArsenal.Service.ServiceThread.Run()
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
    <Provider Name="PDQ Inventory" />
    <EventID Qualifiers="0">0</EventID>
    <Level>2</Level>
    <Task>0</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2014-10-24T15:27:08.000000000Z" />
    <EventRecordID>1101971</EventRecordID>
    <Channel>Application</Channel>
    <Computer>OHS-Monitor.oregonhumane.org</Computer>
    <Security />
</System>
<EventData>
    <Data>CLR Version : 4.0.30319.18444
Entry       : C:\Program Files (x86)\Admin Arsenal\PDQ Inventory\PDQInventoryService.exe
Error       : SQLite database file is corrupt
Error Type : AdminArsenal.Data.SQLite.SqliteCorruptException
Memory      : 4 GB (1 GB free)
Product     : PDQ Inventory
Version     : 3.1.3.0
Windows     : Microsoft Windows 7 Professional (6.1.7601.65536)

SQLite database file is corrupt
AdminArsenal.Data.SQLite.SqliteCorruptException
Database: C:\ProgramData\Admin Arsenal\PDQ Inventory\Database.db
Error Code: 11
SQL: select ComputerId
                    from Computers left join
                    (select * from ScanProfileComputers where ScanProfileId = @0) SPC using (ComputerId)
                    where COALESCE(SPC.AttemptedScanDate, SPC.SuccessfulScanDate, datetime('now','-1 year')) <= @1
   at AdminArsenal.Data.SQLite.SqliteEngine.TestReturnCode(Int32 code, String sql, SqliteEngine db)
   at AdminArsenal.Data.SQLite.SqliteEngine.Statement.Next()
   at AdminArsenal.Data.SQLite.SqliteEngine.QueryScalars(String sql, Object[] parameters)
   at AdminArsenal.Data.SQLite.SqliteConnection.QueryIds[T](String sql, Object[] parameters)
   at AdminArsenal.PDQInventory.ScanProfile.GetScheduledComputerIds(DateTime date)
   at AdminArsenal.PDQInventory.StartScheduledScans.Execute()
   at AdminArsenal.Service.ServiceThread.Run()</Data>
</EventData>
</Event>

0
Rob Durkin
October 24, 2014 15:38

I ran the commands, and it seems to have fixed the problem, no event log corruption errors for 5-6 minutes, and a scan started running.

0
Carl Raesly
October 24, 2014 19:07

Here are the errors in my event log:

Log Name:      Application
Source:        PDQ Inventory
Date:          10/24/2014 2:48:16 PM
Event ID:      0
Task Category: None
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      Iupat-Wsus.iupat.org
Description:
CLR Version : 4.0.30319.18444
Entry       : C:\Program Files (x86)\Admin Arsenal\PDQ Inventory\PDQInventoryService.exe
Error       : SQLite database file is corrupt
Error Type : AdminArsenal.Data.SQLite.SqliteCorruptException
Memory      : 8 GB (1 GB free)
Product     : PDQ Inventory
Version     : 3.1.3.0
Windows     : Microsoft Windows Server 2008 R2 Standard (6.1.7601.65536)

SQLite database file is corrupt
AdminArsenal.Data.SQLite.SqliteCorruptException
Database: C:\ProgramData\Admin Arsenal\PDQ Inventory\Database.db
Error Code: 11
SQL: select ComputerId
                    from Computers left join
                    (select * from ScanProfileComputers where ScanProfileId = @0) SPC using (ComputerId)
                    where COALESCE(SPC.AttemptedScanDate, SPC.SuccessfulScanDate, datetime('now','-1 year')) <= @1
   at AdminArsenal.Data.SQLite.SqliteEngine.TestReturnCode(Int32 code, String sql, SqliteEngine db)
   at AdminArsenal.Data.SQLite.SqliteEngine.Statement.Next()
   at AdminArsenal.Data.SQLite.SqliteEngine.QueryScalars(String sql, Object[] parameters)
   at AdminArsenal.Data.SQLite.SqliteConnection.QueryIds[T](String sql, Object[] parameters)
   at AdminArsenal.PDQInventory.ScanProfile.GetScheduledComputerIds(DateTime date)
   at AdminArsenal.PDQInventory.StartScheduledScans.Execute()
   at AdminArsenal.Service.ServiceThread.Run()
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
    <Provider Name="PDQ Inventory" />
    <EventID Qualifiers="0">0</EventID>
    <Level>2</Level>
    <Task>0</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2014-10-24T18:48:16.000000000Z" />
    <EventRecordID>937213</EventRecordID>
    <Channel>Application</Channel>
    <Computer>Iupat-Wsus.iupat.org</Computer>
    <Security />
</System>
<EventData>
    <Data>CLR Version : 4.0.30319.18444
Entry       : C:\Program Files (x86)\Admin Arsenal\PDQ Inventory\PDQInventoryService.exe
Error       : SQLite database file is corrupt
Error Type : AdminArsenal.Data.SQLite.SqliteCorruptException
Memory      : 8 GB (1 GB free)
Product     : PDQ Inventory
Version     : 3.1.3.0
Windows     : Microsoft Windows Server 2008 R2 Standard (6.1.7601.65536)

SQLite database file is corrupt
AdminArsenal.Data.SQLite.SqliteCorruptException
Database: C:\ProgramData\Admin Arsenal\PDQ Inventory\Database.db
Error Code: 11
SQL: select ComputerId
                    from Computers left join
                    (select * from ScanProfileComputers where ScanProfileId = @0) SPC using (ComputerId)
                    where COALESCE(SPC.AttemptedScanDate, SPC.SuccessfulScanDate, datetime('now','-1 year')) <= @1
   at AdminArsenal.Data.SQLite.SqliteEngine.TestReturnCode(Int32 code, String sql, SqliteEngine db)
   at AdminArsenal.Data.SQLite.SqliteEngine.Statement.Next()
   at AdminArsenal.Data.SQLite.SqliteEngine.QueryScalars(String sql, Object[] parameters)
   at AdminArsenal.Data.SQLite.SqliteConnection.QueryIds[T](String sql, Object[] parameters)
   at AdminArsenal.PDQInventory.ScanProfile.GetScheduledComputerIds(DateTime date)
   at AdminArsenal.PDQInventory.StartScheduledScans.Execute()
   at AdminArsenal.Service.ServiceThread.Run()</Data>
</EventData>
</Event>

0
Jeff Miller
January 12, 2015 15:15

My event log

CLR Version : 4.0.30319.34014
Entry       : C:\Program Files (x86)\Admin Arsenal\PDQ Inventory\PDQInventoryService.exe
Error       : SQLite database file is corrupt (The system cannot find the file specified)
Error Type : AdminArsenal.Data.SQLite.SqliteCorruptException
Memory      : 12 GB (9 GB free)
Product     : PDQ Inventory
Version     : 4.2.0.0
Windows     : Microsoft Windows 8.1 Pro (6.2.9200.0)

SQLite database file is corrupt (The system cannot find the file specified)
AdminArsenal.Data.SQLite.SqliteCorruptException
Database: C:\ProgramData\Admin Arsenal\log.db
Error Code: 11
Windows Error: 2
SQL: insert into Log (Date, Source, Message) values (@0,@1,@2)
   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(String sql, Object[] parameters)
   at AdminArsenal.Data.SQLite.SqliteConnection.Insert(String tableName, String fields, Object[] parameters)
   at AdminArsenal.Diagnostics.Log.WriteToFile()

0
Shane Corellian
January 12, 2015 17:16

Hi Jeff,

Does the log.db file exist in C:\ProgramData\Admin Arsenal? If so, does the credentials that run the Background Service have access to the file? This error appears to be stating that it cannot find this log file.

0
Jeff Miller
January 12, 2015 18:00

Hi Shane,

The log.db does exist in C:\ProgramData\Admin Arsenal and credentials for the background service have full control to the file.

0
Jeff Miller
January 12, 2015 19:24

Shane,

I resolved the issue by renaming log.db and letting PDQ Inventory create a new log.db file.

0
Terence Ngan
April 29, 2015 14:44

We have some systems will have error when scan, error "SQLite database file is corrupted, The system cannot found the file specified"

My Event Log is below.

CLR Version : 4.0.30319.34209

Entry       : C:\Program Files (x86)\Admin Arsenal\PDQ Inventory\PDQInventoryService.exe

Error : SQLite database file is corrupt (The system cannot find the file specified)

Error Type : AdminArsenal.Data.SQLite.SqliteCorruptException

Memory      : 8 GB (4 GB free)

Product     : PDQ Inventory

Version     : 4.2.0.0

Windows     : Microsoft Windows Server 2008 R2 Standard (6.1.7601.65536)

SQLite database file is corrupt (The system cannot find the file specified)

AdminArsenal.Data.SQLite.SqliteCorruptException

Database: \\<name removed>\Data\Global IT\PDQ\Inventory\PDQInventory.ScanCache.db

Error Code: 11

Windows Error: 2

SQL: select ComputerId from Computers where HostName = @0 collate nocase

Elapsed Time: 00:00:00.0150000

   at AdminArsenal.Data.SQLite.SqliteEngine.TestReturnCode(Int32 code, String sql, SqliteEngine db)

   at AdminArsenal.Data.SQLite.SqliteEngine.Statement.Next()

   at AdminArsenal.Data.SQLite.SqliteEngine.QueryScalar(String sql, Object[] parameters)

   at AdminArsenal.Data.SQLite.SqliteConnection.QueryLong(String sql, Object[] parameters)

   at AdminArsenal.PDQInventory.ScanCacheDatabase.GetComputerId(SqliteConnection db, String hostName, Boolean insertOnNotFound)

   at AdminArsenal.PDQInventory.ScanCacheDatabase.ReadCache(SqliteConnection db, Computer computer, Scanner scanner)

   at AdminArsenal.PDQInventory.ScanCacheDatabase.ReadCache(Computer computer, IEnumerable`1 scanners)

0
Nscholten
June 07, 2016 07:04

This is my error:

- <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
- <System>
<Provider Name="PDQ Inventory" />
<EventID Qualifiers="0">0</EventID>
<Level>2</Level>
<Task>0</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2016-06-07T06:48:10.000000000Z" />
<EventRecordID>21827</EventRecordID>
<Channel>Application</Channel>
<Computer>SANTANA-2.greefa.nl</Computer>
<Security />
</System>
- <EventData>
<Data>CLR Version : 4.0.30319.42000 Entry : C:\Program Files (x86)\Admin Arsenal\PDQ Inventory\PDQInventoryService.exe Error : SQLite database file is corrupt Error Type : System.InvalidOperationException Memory : 12 GB (9 GB free) Product : PDQ Inventory Version : 8.1.0.0 Windows : Microsoft Windows Server 2012 R2 Standard (6.2.9200.0) SQLite database file is corrupt AdminArsenal.Data.SQLite.SqliteCorruptException Database: C:\ProgramData\Admin Arsenal\PDQ Deploy\Database.db Error Code: 11 SQL: pragma journal_mode=wal at AdminArsenal.Data.SQLite.SqliteEngine.TestReturnCode(Int32 code, String sql, SqliteEngine db) at AdminArsenal.Data.SQLite.SqliteEngine.Statement..ctor(SqliteEngine db, String sql) at AdminArsenal.Data.SQLite.SqliteEngine.Statement..ctor(SqliteEngine db, String sql, IEnumerable`1 parameters) at AdminArsenal.Data.SQLite.SqliteEngine.Execute(String sql, Object[] parameters) at AdminArsenal.Data.SQLite.SqliteEngine..ctor(SqliteConnectionString connectionString) at AdminArsenal.Data.SQLite.SqliteConnectionPool.Checkout() at AdminArsenal.Data.SQLite.SqliteConnection.Open() at AdminArsenal.SharedNotifyPublisherManager.Initialize(SqliteConnectionString connectionString) at AdminArsenal.Data.ProductDatabaseManager.OpenCurrent(String fileName, IDatabaseSchema schema) at AdminArsenal.Database.DatabaseSettings.Initialize(String defaultFileName) at AdminArsenal.Commands.CommandLineCommand..ctor(Boolean isDatabaseRequired) at AdminArsenal.PDQDeploy.Commands.SystemInfo..ctor() ------- OUTER EXCEPTION ------- SQLite database file is corrupt System.InvalidOperationException Command: SystemInfo ServiceThread: AdminArsenal.PDQInventory.PDQSiblingThread HResult: -2146233079 at AdminArsenal.Integration.PDQSiblingInstallation.ExecuteCommandLine(String command, String[] args) at AdminArsenal.Integration.PDQSiblingInstallation.ReadSystemInfo() at AdminArsenal.Service.ServiceThread.Run()</Data>
</EventData>
</Event>

0
Frank Chahulski
December 28, 2016 20:18

My error is:

CLR Version : 4.0.30319.34014

Entry : C:\Program Files (x86)\Admin Arsenal\PDQ Inventory\PDQInventoryService.exe

Error : SQLite database file is corrupt (The system cannot find the file specified)

Error Type : AdminArsenal.Data.SQLite.SqliteCorruptException

Memory : 4 GB (2 GB free)

Product : PDQ Inventory

Version : 11.2.0.0

Windows : Microsoft Windows Server 2012 R2 Datacenter (6.2.9200.0)

　

SQLite database file is corrupt (The system cannot find the file specified)

AdminArsenal.Data.SQLite.SqliteCorruptException

Database: C:\ProgramData\Admin Arsenal\PDQ Inventory\log.db

Error Code: 11

Windows Error: 2

SQL: insert into Log (Date, Source, Message) values (@0,@1,@2)

Sqlite Connection Elapsed: 00:00:00.0020028

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.Data.SQLite.SqliteConnection.Insert(String tableName, String fields, Object[] parameters)

at AdminArsenal.Data.ProductDatabaseManager.WriteToLogFile()

0
Greg Jepperson
August 29, 2017 20:21 (Edited August 29, 2017 20:49)

Here is the error I am getting:

CLR Version : 4.0.30319.42000
Date : 2017-08-29T20:26:45.1595039Z
Entry : C:\Program Files (x86)\Admin Arsenal\PDQ Inventory\PDQInventoryService.exe
Error : SQLite database file is corrupt
Error Type : AdminArsenal.Data.SQLite.SqliteCorruptException
Memory : 8 GB (4 GB free)
Product : PDQ Inventory
Version : 13.2.0.0
Windows : Microsoft Windows Server 2016 Standard (10.0.14393.0)

SQLite database file is corrupt
AdminArsenal.Data.SQLite.SqliteCorruptException
Database: C:\ProgramData\Admin Arsenal\PDQ Inventory\Database.db
Error Code: 11
SQL: update Computers set HeartbeatDate = @1 where ComputerId = @0
Sqlite Connection Elapsed: 00:00:00
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.ComputerDataManager.SetHeartbeat(ComputerId computerId, Boolean isOnline, String ipAddress)
at AdminArsenal.PDQInventory.HeartbeatThread.ThreadProcess()

0
Permanently deleted user
August 29, 2017 21:03

@Greg Jepperson

Please contact Support@pdq.com, they will help you fix your database.

0
Christopher Palmer
January 17, 2018 03:46

Getting this error

Log Name: Application
Source: PDQ Inventory
Date: 17/01/2018 2:39:11 PM
Event ID: 1007
Task Category: None
Level: Error
Keywords: Classic
User: N/A
Computer: 8567sch000sa002.DETNSW.WIN
Description:
CLR Version : 4.0.30319.42000
Date : 2018-01-17T03:39:11.2152960Z
Entry : C:\Program Files (x86)\Admin Arsenal\PDQ Inventory\PDQInventoryService.exe
Error : Sequence contains no elements
Error Type : System.InvalidOperationException
Manufacturer : Microsoft Corporation (Virtual Machine)
Memory : 8 GB (6 GB free)
Product : PDQ Inventory
Version : 14.1.0.0
Windows : Microsoft Windows Server 2012 R2 Datacenter (6.3.9600.0)

Sequence contains no elements
System.InvalidOperationException
HResult: -2146233079
at System.Linq.Enumerable.Max(IEnumerable`1 source)
at AdminArsenal.PDQInventory.ADSyncLog.WriteLog()
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="PDQ Inventory" />
<EventID Qualifiers="0">1007</EventID>
<Level>2</Level>
<Task>0</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2018-01-17T03:39:11.000000000Z" />
<EventRecordID>9957062</EventRecordID>
<Channel>Application</Channel>
<Computer>8567sch000sa002.DETNSW.WIN</Computer>
<Security />
</System>
<EventData>
<Data>CLR Version : 4.0.30319.42000
Date : 2018-01-17T03:39:11.2152960Z
Entry : C:\Program Files (x86)\Admin Arsenal\PDQ Inventory\PDQInventoryService.exe
Error : Sequence contains no elements
Error Type : System.InvalidOperationException
Manufacturer : Microsoft Corporation (Virtual Machine)
Memory : 8 GB (6 GB free)
Product : PDQ Inventory
Version : 14.1.0.0
Windows : Microsoft Windows Server 2012 R2 Datacenter (6.3.9600.0)

Sequence contains no elements
System.InvalidOperationException
HResult: -2146233079
at System.Linq.Enumerable.Max(IEnumerable`1 source)
at AdminArsenal.PDQInventory.ADSyncLog.WriteLog()</Data>
</EventData>
</Event>

0

Benoit Heylens

May 08, 2018 11:15

Hi there,

Got this with new PDQ inventory 16.1.0.0 :

Duplicate schema Table: WMIScanner_47_View
CLR Version   : 4.0.30319.42000
Database      : C:\ProgramData\Admin Arsenal\PDQ Inventory\Database.db
Date          : 2018-05-08T11:03:18.6533520Z
Entry         : C:\Program Files (x86)\Admin Arsenal\PDQ Inventory\PDQInventoryConsole.exe
Error         : Duplicate schema Table: WMIScanner_47_View
Error Type    : AdminArsenal.Reports.Engine.Basic.DuplicateSchemaObjectException
License Mode  : Enterprise Mode
Manufacturer  : VMware, Inc. (VMware Virtual Platform)
Memory        : 8 GB (7 GB free)
Name          : WMIScanner_47_View
Product       : PDQ Inventory
RaygunEnabled : True
Service Mode  : Server
Type          : Table
Version       : 16.1.0.0
Windows       : Microsoft Windows Server 2012 R2 Standard (6.3.9600)

Duplicate schema Table: WMIScanner_47_View
AdminArsenal.Reports.Engine.Basic.DuplicateSchemaObjectException
Type: Table
Name: WMIScanner_47_View
   at AdminArsenal.Reports.Engine.Basic.SourceTables.Add(SourceTable table)
   at AdminArsenal.PDQInventory.WMIView.Create(IWMIScanner scanner, IEnumerable`1 properties)
   at AdminArsenal.PDQInventory.WMIView.<>c.<Load>b__29_0(WMIScanner item)
   at System.Collections.Generic.List`1.ForEach(Action`1 action)
   at AdminArsenal.PDQInventory.WMIView.Load()
   at AdminArsenal.PDQInventory.Scanners.WMIScannerViewModel.Load(IEnumerable`1 wmiScanners)
   at AdminArsenal.PDQInventory.AppViewModel.LoadingPublished()
   at AdminArsenal.NotifyPublisher.Publish()
   at AdminArsenal.AppViewModelBase.ReloadExecuted()
   at AdminArsenal.BasicCommand.Execute()

Jonathan Vincent
May 16, 2018 06:35

Hi Teams !!

Can you help me please , after activate a new scanner profile with WMI (that works perfectly !) this morning PDQ inventory show me this error message : "Duplicate Schema Table:WMIScanenr_37_View"

This the event error message :

Nom du journal :Application
Source : PDQ Inventory
Date : 16/05/2018 15:54:13
ID de l’événement :1000
Catégorie de la tâche :Aucun
Niveau : Avertissement
Mots clés : Classique
Utilisateur : N/A
Ordinateur : NOUSVRMON2.D83.tes.local
Description :
Duplicate schema Table: WMIScanner_37_View
CLR Version : 4.0.30319.42000
Database : C:\ProgramData\Admin Arsenal\PDQ Inventory\Database.db
Date : 2018-05-16T04:54:13.1099274Z
Entry : C:\Program Files (x86)\Admin Arsenal\PDQ Inventory\PDQInventoryConsole.exe
Error : Duplicate schema Table: WMIScanner_37_View
Error Type : AdminArsenal.Reports.Engine.Basic.DuplicateSchemaObjectException
License Mode : Enterprise Mode
Manufacturer : VMware, Inc. (VMware Virtual Platform)
Memory : 8 GB (6 GB free)
Name : WMIScanner_37_View
Product : PDQ Inventory
RaygunEnabled : True
Service Mode : Server
Type : Table
Version : 16.1.0.0
Windows : Microsoft Windows Server 2012 R2 Standard (6.3.9600)

Duplicate schema Table: WMIScanner_37_View
AdminArsenal.Reports.Engine.Basic.DuplicateSchemaObjectException
Type: Table
Name: WMIScanner_37_View
à AdminArsenal.Reports.Engine.Basic.SourceTables.Add(SourceTable table)
à AdminArsenal.PDQInventory.WMIView.Create(IWMIScanner scanner, IEnumerable`1 properties)
à AdminArsenal.PDQInventory.WMIView.<>c.<Load>b__29_0(WMIScanner item)
à System.Collections.Generic.List`1.ForEach(Action`1 action)
à AdminArsenal.PDQInventory.WMIView.Load()
à AdminArsenal.PDQInventory.Scanners.WMIScannerViewModel.Load(IEnumerable`1 wmiScanners)
à AdminArsenal.PDQInventory.AppViewModel.LoadingPublished()
à AdminArsenal.NotifyPublisher.Publish()
à AdminArsenal.AppViewModelBase.ReloadExecuted()
à AdminArsenal.BasicCommand.Execute()

XML de l’événement :
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="PDQ Inventory" />
<EventID Qualifiers="0">1000</EventID>
<Level>3</Level>
<Task>0</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2018-05-16T04:54:13.000000000Z" />
<EventRecordID>786235</EventRecordID>
<Channel>Application</Channel>
<Computer>NOUSVRMON2.D83.tes.local</Computer>
<Security />
</System>
<EventData>
<Data>Duplicate schema Table: WMIScanner_37_View
CLR Version : 4.0.30319.42000
Database : C:\ProgramData\Admin Arsenal\PDQ Inventory\Database.db
Date : 2018-05-16T04:54:13.1099274Z
Entry : C:\Program Files (x86)\Admin Arsenal\PDQ Inventory\PDQInventoryConsole.exe
Error : Duplicate schema Table: WMIScanner_37_View
Error Type : AdminArsenal.Reports.Engine.Basic.DuplicateSchemaObjectException
License Mode : Enterprise Mode
Manufacturer : VMware, Inc. (VMware Virtual Platform)
Memory : 8 GB (6 GB free)
Name : WMIScanner_37_View
Product : PDQ Inventory
RaygunEnabled : True
Service Mode : Server
Type : Table
Version : 16.1.0.0
Windows : Microsoft Windows Server 2012 R2 Standard (6.3.9600)

Duplicate schema Table: WMIScanner_37_View
AdminArsenal.Reports.Engine.Basic.DuplicateSchemaObjectException
Type: Table
Name: WMIScanner_37_View
à AdminArsenal.Reports.Engine.Basic.SourceTables.Add(SourceTable table)
à AdminArsenal.PDQInventory.WMIView.Create(IWMIScanner scanner, IEnumerable`1 properties)
à AdminArsenal.PDQInventory.WMIView.<>c.<Load>b__29_0(WMIScanner item)
à System.Collections.Generic.List`1.ForEach(Action`1 action)
à AdminArsenal.PDQInventory.WMIView.Load()
à AdminArsenal.PDQInventory.Scanners.WMIScannerViewModel.Load(IEnumerable`1 wmiScanners)
à AdminArsenal.PDQInventory.AppViewModel.LoadingPublished()
à AdminArsenal.NotifyPublisher.Publish()
à AdminArsenal.AppViewModelBase.ReloadExecuted()
à AdminArsenal.BasicCommand.Execute()
</Data>
</EventData>
</Event>

Thanks in advance

0
Andre Leopold
February 26, 2021 13:09

Hi Guys,

we got the same Event in our EventViewer:

Event ID: 1007 Error
Exception has been thrown by the target of an invocation.
AppDomain : PDQInventoryConsole.exe
CLR Version : 4.0.30319.42000
Current AppDomain : PDQInventoryConsole.exe
Database : C:\ProgramData\Admin Arsenal\PDQ Inventory\Database.db
Date : 2020-12-02T13:11:44.4440952Z
Entry : C:\Program Files (x86)\Admin Arsenal\PDQ Inventory\PDQInventoryConsole.exe
Error : Object reference not set to an instance of an object.
Error Type : System.NullReferenceException
HResult : 0x80131604 Code:5636 Facility:19 Warning
License Mode : Enterprise Mode
Manufacturer : Amazon EC2 (t3a.large)
Memory : 7.9 GB (2.7 GB free)
PID : 7456
Process : PDQInventoryConsole
Product : PDQ Inventory
SentryEnabled : True
Service Mode : Server
Version : 19.2.137.0
Windows : Microsoft Windows Server 2019 Datacenter (10.0.17763)

Object reference not set to an instance of an object.
System.NullReferenceException
Method: CustomComputerValueProtocol.Open(CustomComputerValueId):CustomComputerValue
HResult: 0x80004003 Code:16387 Warning
------- INNER EXCEPTIONS -------
Object reference not set to an instance of an object.
System.NullReferenceException
Method: CustomComputerValueProtocol.Open(AdminArsenal.PDQInventory.CustomComputerValueId):AdminArsenal.PDQInventory.CustomComputerValue
HResult: 0x80004003 Code:16387 Warning
at AdminArsenal.PDQInventory.CustomComputerValueDataManager.Open(CustomComputerValueId id)
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at AdminArsenal.Protocol.ExecuteServer.Execute(Object[] parameters)
at AdminArsenal.Protocol.ServerConnection.ExecuteStream(Stream stream)
------- OUTER EXCEPTION -------
Object reference not set to an instance of an object.
System.NullReferenceException
Method: CustomComputerValueProtocol.Open(CustomComputerValueId):CustomComputerValue
HResult: 0x80004003 Code:16387 Warning
at AdminArsenal.ExceptionExtensions.Rethrow(Exception ex)
at AdminArsenal.Protocol.ProtocolError.Throw()
at AdminArsenal.Protocol.ClientConnection.Execute(ExecuteRequestMessage request, CancellationToken cancellationToken)
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at AdminArsenal.Protocol.ClientConnection.Execute(ExecuteRequestMessage request, CancellationToken cancellationToken)
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at AdminArsenal.Protocol.ClientConnection.Execute(ExecuteRequestMessage request, CancellationToken cancellationToken)
at AdminArsenal.Protocol.ExecuteClient.Execute(ClientConnection connection, CancellationToken cancellationToken, Object[] parameters)
at AdminArsenal.Protocol.ExecuteClient.Execute(ProtocolClient client, MethodInfo method, CancellationToken cancellationToken, Object[] parameters)
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at AdminArsenal.Protocol.ExecuteClient.Execute(ProtocolClient client, MethodInfo method, CancellationToken cancellationToken, Object[] parameters)
at AdminArsenal.Protocol.ProtocolClient.Execute(Protocol protocol, MethodBase caller, CancellationToken cancellationToken, Object[] parameters)
at AdminArsenal.Protocol.ProtocolClient.Execute(Protocol protocol, MethodBase caller, Object[] parameters)
at CustomComputerValueClientClient.Open(CustomComputerValueId )
at AdminArsenal.PDQInventory.Computers.AllCustomComputerFields.InsertedOnPublished(CustomComputerValueId id)
at System.Action`1.Invoke(T obj)
at AdminArsenal.NotifyPublisher`1.Publish(TPayload payload)
------- OUTER EXCEPTION -------
Exception has been thrown by the target of an invocation.
System.Reflection.TargetInvocationException
HResult: 0x80131604 Code:5636 Facility:19 Warning
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at AdminArsenal.Protocol.NotificationQueue.ProcessQueue(IReadOnlyList`1 batch)

0
Colby Bouma
February 26, 2021 15:41

Andre Leopold

I recommend updating to 19.3.9.0. If that doesn't help, contact support@pdq.com.

0