TRUNCATEADD not deleting existing rows in DB import

TRUNCATEADD not deleting existing rows in DB import

Issue:
when 0 records are imported with 'delete and add records' chosen, the old entries in Analytics table is not getting removed. (DB import)

Builds identified: 4300, 4310, 4350

Description:

The problem with the table not removing the old entries was found that if the source table in SQL is empty (0 rows), then the Analytics Plus is not removing the old records in the table, but retains the old records as it is.

Only when there is a change in the source SQL table with at least 1 row, the update is working fine. With 0 rows, the import option 'Delete and add records' does not actually remove the old records.


Solution:

Please download the build specific fjar file from this link and place it under the <Product Home>/fixes directory(Create fixes folder if not available).

Add the below property in app.properties and restart the service.

zdb.emptyfile.handling.needed=true