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, ...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]: ...Change module data : Import into Analytics Plus
Change module data : Import into Analytics Plus Note: When Analytics Plus officially supports Change module integration Out of the box, then these imported tables and reports might get overwritten. Please ensure to name the table as 'Change_localDB'. ...Steps to import Archived Request into Analytics Plus
By default, we don't import archived request details into Analytics Plus but we are working on a model to import these details out of the box and will be available in one of our future builds. Meanwhile, please follow the below text instructions Step ...Workaround to add Region Field in Servicedesk plus data
With the out of the box integration, we don't bring 'Region' details from the ServiceDesk Plus. However, you can follow the below steps to import the region details into a new table 1. Import using Local Database by connecting to the Servicedesk Plus ...