Filters getting duplicated when reports are saved and reopened

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:

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

                  New to ADManager Plus?

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