View Issue Details

IDProjectCategoryView StatusLast Update
0000808Database ComparerGeneralpublic2020-02-23 08:00
Reportershirokov Assigned Tobarry  
PriorityhighSeveritymajorReproducibilityalways
Status closedResolutionfixed 
Fixed in Version8.0.0.1913.Beta 
Summary0000808: Table Data Comparer LOB file is not generated, BLOB files are not stored.
DescriptionThe attached file contains master and target databases. When trying to generate the update script, the script contains errors: the number of fields differs from number of parameters.
When trying to use Update Immediately, the script executing errors appear and the target table data gets corrupted.
Additional Information====>

11:25:17 Error: FormTableDataComparer.TableDataComparer:
An error was found in the application program input parameters for the SQL statement.Dynamic SQL Error.
SQL error code = -804.
Count of read-write columns does not equal count of values.

11:25:17 Error: FormTableDataComparer.TableDataComparer:
An error was found in the application program input parameters for the SQL statement.Dynamic SQL Error.
SQL error code = -804.
Count of read-write columns does not equal count of values.

11:25:17 Error: FormTableDataComparer.TableDataComparer:
An error was found in the application program input parameters for the SQL statement.Dynamic SQL Error.
SQL error code = -804.
Count of read-write columns does not equal count of values.

11:25:17 Error: FormTableDataComparer.TableDataComparer:
An error was found in the application program input parameters for the SQL statement.Dynamic SQL Error.
SQL error code = -804.
Count of read-write columns does not equal count of values.

11:25:17 Error: FormTableDataComparer.TableDataComparer:
An error was found in the application program input parameters for the SQL statement.Dynamic SQL Error.
SQL error code = -804.
Count of read-write columns does not equal count of values.

11:25:17 Error: FormTableDataComparer.TableDataComparer:
An error was found in the application program input parameters for the SQL statement.Dynamic SQL Error.
SQL error code = -804.
Count of read-write columns does not equal count of values.

11:25:17 Error: FormTableDataComparer.TableDataComparer:
An error was found in the application program input parameters for the SQL statement.Dynamic SQL Error.
SQL error code = -804.
Count of read-write columns does not equal count of values.

11:25:17 Error: FormTableDataComparer.TableDataComparer:
An error was found in the application program input parameters for the SQL statement.Dynamic SQL Error.
SQL error code = -804.
Count of read-write columns does not equal count of values.

11:25:17 Error: FormTableDataComparer.TableDataComparer:
An error was found in the application program input parameters for the SQL statement.Dynamic SQL Error.
SQL error code = -804.
Count of read-write columns does not equal count of values.

11:25:17 Error: FormTableDataComparer.TableDataComparer:
An error was found in the application program input parameters for the SQL statement.Dynamic SQL Error.
SQL error code = -804.
Count of read-write columns does not equal count of values.

11:25:17 Error: FormTableDataComparer.TableDataComparer:
An error was found in the application program input parameters for the SQL statement.Dynamic SQL Error.
SQL error code = -804.
Count of read-write columns does not equal count of values.

11:25:17 Error: FormTableDataComparer.TableDataComparer:
An error was found in the application program input parameters for the SQL statement.Dynamic SQL Error.
SQL error code = -804.
Count of read-write columns does not equal count of values.

11:25:17 Error: FormTableDataComparer.TableDataComparer:
An error was found in the application program input parameters for the SQL statement.Dynamic SQL Error.
SQL error code = -804.
Count of read-write columns does not equal count of values.

11:25:17 Error: FormTableDataComparer.TableDataComparer:
An error was found in the application program input parameters for the SQL statement.Dynamic SQL Error.
SQL error code = -804.
Count of read-write columns does not equal count of values.

11:25:17 Error: FormTableDataComparer.TableDataComparer:
An error was found in the application program input parameters for the SQL statement.Dynamic SQL Error.
SQL error code = -804.
Count of read-write columns does not equal count of values.

11:25:17 Error: FormTableDataComparer.TableDataComparer:
An error was found in the application program input parameters for the SQL statement.Dynamic SQL Error.
SQL error code = -804.
Count of read-write columns does not equal count of values.

11:25:17 Error: FormTableDataComparer.TableDataComparer:
An error was found in the application program input parameters for the SQL statement.Dynamic SQL Error.
SQL error code = -804.
Count of read-write columns does not equal count of values.

11:25:17 Error: FormTableDataComparer.TableDataComparer:
An error was found in the application program input parameters for the SQL statement.Dynamic SQL Error.
SQL error code = -804.
Count of read-write columns does not equal count of values.

11:25:17 Error: FormTableDataComparer.TableDataComparer:
An error was found in the application program input parameters for the SQL statement.Dynamic SQL Error.
SQL error code = -804.
Count of read-write columns does not equal count of values.

<===

When comparing with at resulting script. The same problems as described below occurs.

The first attachment is a screenshot of the DatabasComparer utility.
The second attachment contains the "edit alias" dialogues of both connections.
The third attachment is a zip file containing the two firebird (2.5) databases used, both as fdb and backups.
TagsNo tags attached.

Activities

shirokov

2015-04-13 16:53

administrator  

barry

2019-12-27 13:32

administrator   ~0004285

? Firebird version not specified.

Issue History

Date Modified Username Field Change
2015-04-13 16:53 shirokov New Issue
2015-04-13 16:53 shirokov File Added: tabledatacomparer_blob.zip
2019-12-27 13:32 barry Note Added: 0004285
2019-12-27 14:40 barry Assigned To => barry
2019-12-27 14:40 barry Status new => resolved
2019-12-27 14:40 barry Resolution open => fixed
2019-12-27 14:40 barry Fixed in Version => 8.0.0.1913.Beta
2020-02-23 08:00 barry Status resolved => closed