Skip to main content
Kofax

Schema is not Empty error using DBUtil to change SQL Server name to FQDN

22496

Question / Problem:

When using the Database Utility (DBUTIL) and trying to change the database from domain to Fully Qualified Domain Name for the SQL server name, I'm getting the following error:

Error 1004: A database error occurred while moving the database (8004102A, [4142] KdoLib: The database schema is not empty.: Kofax.KfxDb.KfxDbException)

How can I fix this?

Answer / Solution:

To change the SQL Server name to the Fully Qualified Domain Name:

  1. Stop the KC service
  2. Make a backup copy of the ACConfig.xml file
  3. Modify the ACConfig.xml file Database section <KfxDB> to use the FQDN for the server name.
    Example:
    <SqlServerInstance>servername.domainname.com\KofaxCapture</SqlServerInstance>
  4. Restart the Kofax Capture service

Applies to: 

Product Version
CAPTURE 10.2
  11.0