Skip to main content
Kofax

Unable to install Service Pack 1 on Capture 11 when the database contains a dash

3011353

Question / Problem: 

When attempting to install Service pack 1 (11.0.1.0.0.646) on Capture 11 base, if the database name contains a dash, the following error occurs:

 

Unable to Obtain an Exclusive Database Connection

[4006] Kdolib: Error executing SQL command
Incorrect syntax near "-"
Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context

After clicking "ok" on the error, the installation of the service pack rolls back.

Answer / Solution: 

This was resolved by doing the following:


• Run the setup with the /NoDb switch (KofaxCapture-11.0_Updater_En /NoDb)
• After running this command, Capture binaries should updated to 11.01.0.0.646 and database will still be on the base build.
• Look in the ERR_YYMM.log file for the location of the generated PatchDB.sql file.:  
(Default is: C:\ProgramData\Kofax\CaptureSV\Logs\patchdb.sql)
• Modify the line:
 USE database-name adding the brackets to display as:  USE [database-name]
• Run the modified patchdb.sql in SQLCMD mode by selecting Query ¦ SQLCMD Mode in Studio.
• Upon a successful execution, the Capture database will now be updated to build: 11.01.0.0.646
• Confirm that Kofax Capture is functioning.

Applies to:  

Product Version Category
CAPTURE 11.0 Database

 

  • Was this article helpful?