Icon View Incident Report

Serious Serious
Reported By: Mark Culos [Blackberry Civil Works]
Reported On: 11/25/2014
For: Version 2.18 Build 1
# 4120 Loading a Replication Updates File into a Table with Computed Columns Can Cause Load Error

Loading an update fails referencing a table field that does not exist in the source or target databases and that is not in the RowData of the update.

Based on the contents of the error message, I surmised that the problem was caused by there being a computed field in the table being updated. When I alter the table so that the field is no longer computed, the update loads without error.

I have included the source catalogue as well as the target catalogue along with two updates that show the issue. The field of interest is Payment.CardType and the error when loading states that the field "Visa" for the first example and "MasterCard" for the second example, does not exist in the table Payment.


Comments Comments
This issue was slightly different than incident #4047. It was possible to still load updates containing computed column row values successfully. It would depend upon whether the computed column evaluated to NULL in the row. If the computed column evaluated to NULL, then it would trigger this error.


Resolution Resolution
Fixed Problem on 11/28/2014 in version 2.18 build 2


Products Affected Products Affected
ElevateDB Additional Software and Utilities
ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial
ElevateDB LCL Standard with Source
ElevateDB PHP Standard
ElevateDB PHP Standard with Source
ElevateDB PHP Trial
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial

Image