Skip to main content
Kofax

Kofax TotalAgility 7.4.x - KTA Configuration Utility does not update the Data Layer Database

Using the KTA Configuration Utility to update the Database Server settings it is not retaining the Data Layer database configuration details.  This refers to the table SERVER_DATA of the main database.  This setting specifies the Documents database connection string for the TotalAgility database server.  On saving the configuration changes the Data Layer configuration is not being updated as expected.

Applies To

Kofax TotalAgility v7.4 onwards

Behaviour

Using the KTA Configuration Utility, under the Common tab, on choosing to update the Data Layer database and saving the changes the SERVER_DATA table is not being updated as expected.

Resolution

To manually update the Database Connection String please refer to the following steps;

  • Update the KTA SERVER_DATA table CEBPM_SETTINGS column with the new documents database connection string
UPDATE server_data SET CEBPM_SETTINGS = REPLACE(CAST(CEBPM_SETTINGS as varchar(max)), 
'OLDCONNECTIONSTRING', 'NEWCONNECTIONSTRING')

eg

UPDATE server_data SET CEBPM_SETTINGS = REPLACE(CAST(CEBPM_SETTINGS as varchar(max)), 'Data
Source=W2K8-SQL2012;Initial Catalog=TotalAgility_Documents;User ID=;Password=;Integrated
Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False', 'Data
Source=NEWINSTANCE;Initial Catalog=TotalAgility_Documents;User ID=;Password=;Integrated
Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False')