PDQ Inventory Database corruption

Comments

18 comments

  • Brandon Rewis

    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

    -1
    Comment actions Permalink
  • William Apgar

    That seems to have fixed the issues. Thank you!

    0
    Comment actions Permalink
  • Shane Corellian

    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
    Comment actions Permalink
  • Rob Durkin

    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')) &lt;= @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
    Comment actions Permalink
  • Rob Durkin

    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
    Comment actions Permalink
  • Carl Raesly

    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')) &lt;= @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
    Comment actions Permalink
  • Jeff Miller

    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
    Comment actions Permalink
  • Shane Corellian

    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
    Comment actions Permalink
  • Jeff Miller

    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
    Comment actions Permalink
  • Jeff Miller

    Shane,

     

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

     

     

     

     

    0
    Comment actions Permalink
  • Terence Ngan

    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
    Comment actions Permalink
  • Nscholten

    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
    Comment actions Permalink
  • Frank Chahulski

    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
    Comment actions Permalink
  • Greg Jepperson

    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
    Comment actions Permalink
  • Colby Bouma

    @Greg Jepperson

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

    0
    Comment actions Permalink
  • Christopher Palmer

    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
    Comment actions Permalink
  • Benoit Heylens
    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()
    0
    Comment actions Permalink
  • Jonathan Vincent

    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.&lt;&gt;c.&lt;Load&gt;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
    Comment actions Permalink

Please sign in to leave a comment.