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


                    New to ADSelfService Plus?

                      • Related Articles

                      • Procedure to upload local DB to Analytics Plus

                        Steps to use Upload Tool for uploading Data from any DB: 1. Download and extract the uploadtool.zip from this link 2. Configure the Database connection details: Open the file 'database_connection_params.conf' located under <Uploadtool>\conf\ folder, ...
                      • Troubleshooting ServiceDesk Plus and Analytics Plus Sync Issues

                        This document provides troubleshooting guidance for common synchronization and connectivity issues between ServiceDesk Plus and Analytics Plus. Ref: ...
                      • Data import via localdb fails with timeout error

                        Issue: SQL query timeouts after upgrade to version 4000. Analysis:  The timeout error pops up before generating the data preview. Log traces: [14:34:01:353]|[12-04-2018]|[SYSERR]|[INFO]|[128]:  ...
                      • Query to Fetch Warranty Details from Endpoint Central

                        Requirement: The requirement is to fetch warranty expiry details of managed machines from Endpoint Central into Analytics Plus using a custom query through local database import. This enables users to track warranty coverage, identify machines ...
                      • Dashboard PDF Export Takes a Long Time

                        Issue: Dashboard PDF Export Takes a Long Time Error: No specific error is reported. The complete dashboard PDF export takes significantly longer than expected. However, individual reports from the same dashboard may be exported within a considerably ...