KBI 310334 Argent AT Daughter Engines Fail To Start After Upgrading
Version
Argent Advanced Technology 3.1A-1301-E
Date
29 Jan 2013
Summary
After upgrading to 3.1A-1301-E, Argent Daughter Engine may stop communicating with the Mother Engine.
This occurs due to a newly enforced database integrity check on the ARGSOFT_AT_LOCATION table which does not allow for a duplicate entry for the City & State/Province/Region field.
The Argent Daughter Engine Service stops running after upgrading itself if this integrity check fails.
Location Definition (Screen P3) in Argent Advanced Technology
Technical Background
In previous versions warnings appear in the Supervising Log but the Daughter Engine would continue to function as per normal.
In Argent AT 3.1A-1301-E, the Argent Daughter Engine service will stop functioning.
The following error lines (or similar) appears in the Daughter Engine Supervising Log of the affected product (e.g Argent Guardian Ultra)
***** ERROR ***** An error condition has been detected by ArgSoft_DAL.cpp (D6150_Insert_SQL) at line 1463: DAL could not execute SQL statement (insert into ARGSOFT_AT_LOCATION (UUID, CREATE_TIME, MODIFY_TIME, NAME, CITY, REGION, COUNTRY, DESCRIPTION, OWNER, CRC_LOW, CRC_HIGH) values ('b787ff77-277a-4796-ada1-158b8780abfc', {ts '2012-02-01 11:24:29'}, {ts '2013-01-29 01:58:55'}, 'FPSO Sunshine Blvd, 'BURBANK', 'CALIFONIA', 'UNITED STATES', null, 'Z27\__103920argent', -1723104432, 1310375998)). Microsoft Error Code = Value violated the integrity constraints for a column or table.. HRESULT: 0x80040e2f
***** ERROR ***** An error condition has been detected by RSBase.cpp (RSBase::ExecuteModificationStatement) at line 3395: DAL could not successfully complete a database insert operation for table 'ARGSOFT_AT_LOCATION'
***** ERROR ***** An error condition has been detected by ArgSoft_DAL_XML.cpp (L6360_Put_XML_RS) at line 2517: SKIPPED updating record (UUID = 'b787ff77-277a-4796-ada1-158b8780abfc'). Reason: Call to D6320_Commit_DB_Operation() did not complete successfully
This occurs due to a newly enforced database integrity check on the ARGSOFT_AT_LOCATION table.
This in turn prevents the Daughter Engine from starting up as it should.
Resolution
To address this issue, ensure that there are no duplicate entries in the ‘City‘ field as shown below:
Argent is still reviewing this issue as some customers may require two location definition entries which the same City and State.
Argent will update this KBI accordingly.