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.