Comparison Fails to Record an Inconsistency

Problem: Job comparison results are not recording inconsistencies for database hash column comparison.

Possible cause one: The inconsistency exists in a large object (LOB) column, such as image. By default, DA server compares only the first 1024 bytes of LOB columns, so some sections of LOB values are not compared.

Solution: Increase the lob_fetch_size value.

Possible cause two: The source and target column values produces the same MD5/SHA/CRC32 hash value.

Solution: Use the literal option to recompare the rows.

Related tasks
Configuring Data Assurance Server Parameters