How to enter labels that contain multiple angle brackets into TIBCO Statistica Data Entry form ?

How to enter labels that contain multiple angle brackets into TIBCO Statistica Data Entry form ?

book

Article ID: KB0074004

calendar_today

Updated On:

Products Versions
Spotfire Statistica 13.5 and higher

Description

How to enter labels that contain multiple angle brackets into TIBCO Statistica Data Entry form ? For example: Entering a value like "10<WT<13"  as shown below will throw an error by default.

User-added image

The error will read :

 An unexpected error has occured in STATISTICA Web Data Entry.

An event log message with details of the error has been logged on the server.


If you were to login to the Web Data Entry server and examine the Event Log on the server , this will have a validation error with event details as :
Event code: 3003
Event message: A validation error has occurred.
Event time: 1/19/2021 3:31:58 PM
Event time (UTC): 1/19/2021 11:31:58 PM
Event ID: bc7a3a8ccf534d3fbbcd024b37bdb76e
Event sequence: 660
Event occurrence: 1
Event detail code: 0
 
Application information:
    Application domain: /LM/W3SVC/1/ROOT/DataEntry-1-132554857859578669
    Trust level: Full
    Application Virtual Path: /DataEntry
    Application Path: C:\WebSTATISTICAPub\DataEntry\
    Machine name: 10TSSSTATISTICA
 
Process information:
    Process ID: 11420
    Process name: w3wp.exe
    Account name: NT AUTHORITY\SYSTEM
 
Exception information:
    Exception type: HttpRequestValidationException
    Exception message: A potentially dangerous Request.Form value was detected from the client (ctl00$ContentPlaceHolder$LBL_14_1="10<WT<13").
   at System.Web.HttpRequest.ValidateString(String value, String collectionKey, RequestValidationSource requestCollection)
   at System.Web.HttpRequest.ValidateHttpValueCollection(HttpValueCollection collection, RequestValidationSource requestCollection)
   at System.Web.HttpRequest.get_Form()
   at System.Web.HttpRequest.get_HasForm()
   at System.Web.UI.Page.GetCollectionBasedOnMethod(Boolean dontReturnNull)
   at System.Web.UI.Page.DeterminePostBackMode()
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   at System.Web.UI.Page.ProcessRequest()
   at System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

Cause: The .NET framework is throwing up an error because it detected something in the entered text which looks like an HTML statement. The text doesn’t need to contain valid HTML, just anything with opening and closing angled brackets
 

Issue/Introduction

How to enter labels that contain multiple angle brackets into TIBCO Statistica Data Entry form ?

Resolution

If this is an expected data (data containing multiple angle brackets) that users need to enter in the Web Data Entry form, consider turning off the validation. This can be done as described below.

1. Remote into the Data Entry Server as a user with Administrative privileges.
2. Navigate to : [drive]:\WebSTATISTICAPub\DataEntry
3. Right click on DataEntry.aspx and select Properties. Unselect the Read Only attribute if it is selected.
4.  Open DataEntry.aspx with a text editor of your choice. On the first line, insert ValidateRequest="false" on the first line as illustrated below:

User-added image

5. Save the changes.
6.  Open [drive]:\WebSTATISTICAPub\DataEntry\Web.config with a text editor of choice (Launch as an administrator is recommended)
7. Find the line that has the tag : httpRuntime

User-added image

8.  Add the attribute before the closing tag : requestValidationMode="2.0" as shown below :

User-added image
9. In the same file, find the string named : passwordFormat and change the value from Clear to Hashed as shown below:

User-added image
10. Save the file with the changes made.
11. Launch Command Prompt as an administrator. (Type CMD , Right click and select "Run as an administrator")
12. Type iisreset and wait for the Internet services to restart as shown below

User-added image

 All users logging on subsequently should be able to enter samples with data containing multiple angle brackets.

User-added image