I started having a bunch of my scan files going into the error scan directory. When I looked into the issue it seems that my scans are erroring out with:
Database exception: SCAEC10.SCN, LDInv.dll-2146825023Item cannot be found in the collection corresponding to the requested name or ordinal.Update Table:TCP Column:ADDRESS PK:, Thread ID: 12428.
Database exception: SCAEC10.SCN, LDInv.dll
Item cannot be found in the collection corresponding to the requested name or ordinal.
Update Table:TCP Column:ADDRESS PK:, Thread ID: 12428.
I found a tid that said I should run a coredbutil to repair corruption in the database and to do a build.
When I ran the utility it errored out almost immediately with:
ExecuteNonQuery error for sql: Alter table Computer add on Varchar(255)
System.Data.OleDb.OleDbException: Incorrect syntax near the keyword 'on'.
I've attached the log. Anybody have any advice! Could really use some ideas to get this resolved.
Coredbutil is trying to add a column called 'ON' as per your datamart. ON is a reserved word in SQL and cannot be used as a column.
Nate is removing that from your datamart.xml so coredbutil can run.
Nate was able to help me with this and I sucessfully ran a coredbutil but this didn't fix the problem. I still seem to have corruption in the db and scans are being rejected.
Retrieving data ...