Filters getting duplicated when reports are saved and reopened
This issue is seen in Analytics Plus build 3800.
Issue: When a filter is added/edited to a report and saved, the report shows up fine. But, when we close and reopen the report, the filter gets duplicated and causes issues in loading the right data.
Before Saving the report filter:
After Saving the report filter:
Solution:
The cause of the problem with the filters getting duplicated on reports has been identified as an issue in the build 3800 and the same can be fixed now by replacing an XML file on the Analytics Plus installation.
Steps to fix the issue:
1. Download the attached SQLQueries.xml file and replace it under <Analytics Plus Home>\conf\ZohoAnalytics directory
2. Restart the Analytics Plus service
3. Once restarted, open the affected reports and make the filter section modifications, to remove the unwanted filters and save the reports.
For further assistance, please reach out to analyticsplus-support@manageengine.com
New to ADSelfService Plus?
Related Articles
Unexpected error prompted for while accessing reports for Servicedesk Plus MSP integrated setup
Issue : Unexpected error prompt while accessing reports Analysis: The exception caused is due to a syntax problem faced in the query formed while the user filter drop down is used on the SLA deviation report. The logs shared helped us to find the ...Sync getting stuck in In-progress state
Issue: Sync getting stuck in In-progress state. Usually, when the data type mismatch is present, this issue occurs. Logs required: <AnalyticsPlus>/pgsql/data/pg_log/ Check for the error trace by searching "ERROR: invalid input syntax for" Sample ...OPM reports dealing with performance data shows No Data
Issue: It seems that OPM reports dealing with performance data are having issues where it displays no data. The problem is present for reports which has Attribute added in the filter. Cause: The name change of the attributes used in the filter is ...Query Reports not refreshing on Build 3600
Issue: Once migrated to 3600, the existing query reports do not get refreshed with latest data. Needs manual update. Solution: This seems to be breakage in 3600 builds. Open the <AnalyticsPlus\conf\ app.properties> file and then change the value ...Sync issue between SDP MSP and Aplus
Issue: Sync fails between ServiceDesk Plus MSP and AnalyticsPlus, after upgrading the SDP to 14730. Cause: An example of a case mismatch issue is when Analytics Plus seeks column alias names such as BillID, but MSP returns BILLID instead. This is a ...