Comparison Fails to Detect Differences In LOB Column

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

Solution 1: Increase LOB Fetch Size

The inconsistency might exist 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.

To solve this problem, increase the lob_fetch_size value.

Solution 2: Increase LOB Fetch Size

The source and target column values might produce the same MD5/SHA/CRC32 hash value.

To solve this problem, use the literal option to recompare the rows.

Parent topic: Troubleshoot SAP Control Center for Data Assurance
Related tasks
Configuring Data Assurance Server Parameters