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 ...AnalyticsPlus Startup issue
Issue: Unable to start the services when there is a formula column created with static data Cause: When a formula column holds static data static data (like 123 or 1*24) then those data types are stored as INT4 or INT8 or float8 because which the ...