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)