How to resolve the issue of Webstatistica redirecting if added a large number of filter values?

How to resolve the issue of Webstatistica redirecting if added a large number of filter values?

book

Article ID: KB0072759

calendar_today

Updated On:

Products Versions
Spotfire Statistica 13.5,13.6

Description

Sometimes, WebStatistica redirects to the login page if we try to add a large number of filter values with SQL operators like " is one of ".

GIF of the exact issue

redirect_to_screen

You could follow the below resolution to get rid of this issue.
 

Issue/Introduction

How to resolve the issue of Webstatistica redirecting if added a large number of filter values?

Environment

N/A

Resolution

Step 1: Navigate to "C:\WebSTATISTICAPub\wwwroot\PHP\php.ini"
Step 2: Add "  max_input_vars = 10000 " in the php.ini file [Refer to the below screenshot]

PHPINI_changes.PNG

Step 3: Reset IIS settings by the "iisrest" command in the administrative command prompt.
Step 4: Then try to add a large number of filter values in WebStatistica's SQL filter dialog box.

GIF of the output after applying resolution - 

resolution_of_redirect_to_screen

If you are still observing the issue, please contact TIBCO Support at  https://support.tibco.com/s/