KBI 310669 Issue Addressed: Daughter Engine Encounters Database Import Error When Using Shared SQL Server As Database

Version

Argent Advanced Technology 3.1A-1308-A or earlier

Date

Monday, 16 September 2013

Summary

Multiple Argent AT Daughter Engines may be installed on the same server using a shared SQL Server backend. Daughter Engines may perform midnight recycling at slightly different times.

In this scenario, one Daughter Engine process could overwrite the CMDB-X database while the other is using it, resulting in database errors

Technical Background

A global mutex is introduced in Argent AT 3.1A-1310-A to protect the shared SQL database.

Resolution

Upgrade to Argent AT 3.1A-1310-A or later.

For customers that do not want to upgrade immediately, customers can use either of the following workarounds:

1. Use SQL Server Compact as the Daughter Engine database.

2. Setup and install the Daughter Engines one by one. Make sure each Daughter Engine uses a separate SQL Server database (SQL Server Express works fine as well)