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 ...