Show All Projects
Corrupt Access databases (mdb files) can cause problems in a Kofax Capture system and are the reason behind some types of stuck batches. In the case of publish.mdb, empty.mdb, or local\pubtypes, corruption may cause publish or batch creation problems. In other cases they can simply fill the error log with Microsoft Jet Database Engine errors.

Because they are passworded and because Microsoft Access may not be available on a given system these can be inconvenient to check. This utility tries to open all mdb files on both the server and local workstation and lists any that throw errors. It also provides a command line accessible alternative to DBUtil for running a Repair and Compact on Capture mdb files.

To go with this utility, I wrote Kofax Knowledgebase Article 12661.


Timeline

Files

Screenshots

  BENCHMARKS  
Loading Time: Base Classes  0.0018
Controller Execution Time ( Project / Id )  0.0112
Total Execution Time  0.0131
  GET DATA  
No GET data exists
  MEMORY USAGE  
911,184 bytes
  POST DATA  
No POST data exists
  URI STRING  
project/id/16/MDB_Corruption_Checker
  CLASS/METHOD  
project/id
  DATABASE:  smkprojects (Project:$db)   QUERIES: 5 (0.0032 seconds)  (Hide)
0.0006   SELECT *
FROM `ProjectResources`
WHERE `ProjectID` = '16' 
0.0005   SELECT *
FROM `Projects`
WHERE `ProjectID` = '16' 
0.0004   SELECT *
FROM `ProjectTags`
WHERE `ProjectID` = '16' 
0.0009   SELECT TagCOUNT(1) AS cnt
FROM 
`ProjectTags`
WHERE `Tag` != 'Private'
GROUP BY `Tag`
HAVING COUNT(1) >
0.0008   SELECT TagCOUNT(1) AS cnt
FROM 
`ProjectTags`
WHERE `Tag` != 'Private'
GROUP BY `Tag`
HAVING COUNT(1) > 
  HTTP HEADERS  (Show)
  CONFIG VARIABLES  (Show)