Skip to main content
Kofax

SQL Error During Upgrade - Cannot Open Backup Device

23004
307477

Question / Problem: 

When upgrading a Remote Site Server from Kofax Capture 9.x to Kofax Capture 10.2, then a database error is received: 

[4008] KdoLib: Error getting data reader from SQL command.
Cannot open backup device '\\{SERVER}\CaptureSV\Capture9\BatchDB\Catalog\BatchCat.dat'.
Operating system error 5(Access is denied.).


How can the Kofax Capture 10.2 Upgrade be completed with the existing KC9.x Database?

Answer / Solution: 

The Error indicates a file which needs to be recovered during the installation. 

Steps to resolve:

1. Complete the installation and get the 4008 error message; leave the error shown on the screen through Step #4. 

2. Navigate to the location of the BatchCat.Dat file noted in the error message.

3. Copy that BatchCat.Dat file to the root of C:\

4. Edit the ACConfig.xml file (..\CaptureSV\config) and replace the contents of the SQLSERVERBACKUPFILE replacing the Directory Path of BatchCat.Dat with the Root Location (C:\BatchCat.dat)
- Close the Error from Step#1

5. Restart the Kofax Capture Services. 

6. Launch an elevated Command Prompt (run as Admin), then change directory to the AppInit.exe located in ..\Kofax\CaptureSS\ServLib\Bin
-- cd C:\Program Files (x86)\Kofax\CaptureSS\ServLib\Bin
-- AppInit.exe

 

You should receive a window advising that Conversion is being completed. 

Applies to:  

Product Version Category
CAPTURE 9.0 Install / Uninstall
CAPTURE 10.0 Install / Uninstall
CAPTURE 10.1 Install / Uninstall
CAPTURE 10.2 Install / Uninstall
CAPTURE 11.0 Install / Uninstall