How to resolve the issue of unable to populate the dropdown list of a queried label in Statistica Web DataEntry when using only https
Article ID: KB0070158
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.
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.
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.
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):
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.
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.
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
https://support.tibco.com/s/article/Unable-to-populate-the-dropdown-list-of-a-queried-label-in-Web-Data-Entry
Feedback
Yes
No
Powered by
