How to resolve the issue of unable to populate the dropdown list of a queried label in Statistica Web DataEntry when using only https

How to resolve the issue of unable to populate the dropdown list of a queried label in Statistica Web DataEntry when using only https

book

Article ID: KB0070158

calendar_today

Updated On:

Products Versions
Spotfire Statistica 14.x and higher

Description

When a label is created with a sample list queried from a Statistica spreadsheet that was added to Enterprise, it fails to populate the drop-down list of the sample query in Web Data Entry.

For instance, the column "SQL Driver" in the web data entry form, below, is supposed to query value from a database connection that links to an Enterprise spreadsheet. However, clicking the dropdown list, it doesn't populate any value.
User-added image

 

Environment

Windows OS

Resolution

1.   Edit the web.config file and enable the https endpoint, as below (note if using both http and https, then both can be enabled):

User-added image

2. Save the web.config file and then restart IIS by opening an admin command prompt and issuing this command:  iisreset

The query labels will now populate.
 

Issue/Introduction

This article will guide you in case where the dropdown list of a queried label in Web Data Entry is not populating when using https and the steps to resolve the issue.

Additional Information

Another known issue and solution:
https://support.tibco.com/s/article/Unable-to-populate-the-dropdown-list-of-a-queried-label-in-Web-Data-Entry