How to resolve when the Statistica Server (a.k.a WebStatistica) object tree is blank

How to resolve when the Statistica Server (a.k.a WebStatistica) object tree is blank

book

Article ID: KB0138430

calendar_today

Updated On:

Products Versions
Spotfire Statistica 14.x
Spotfire Statistica - All Servers 14.x

Description

The issue appears for one or all of the selection trees under the Enterprise tab in Statistica Server.  The selection trees appear blank, as below:

 

 

image.png

 

 

image.png

 

 

One known cause is having the  "Non-Breaking Space (NBSP)" in any of the following objects in Statistica Enterprise Manager:

  • Enterprise folder name 
  • Data Configuration (DC)
  • Analysis Configuration (AC) 
  • Report

Note:  No other characters are know to cause this issue, including these:    $%^&*() \ / @  - _[ ] ! +=

 

Environment

OS:  Windows

Resolution

To troubleshoot and resolve the issue, follow these steps:

 

1.  Open the Developer Tools (Ctrl+Shift+I for the Chrome browser) in whatever browser is in use. The following shows the Developer Tools>>Console in Chrome:

2.  Click on one of the section trees to reproduce the issue.  Then right-click in the Dev Tools console and select Save As...  Name the file something like HAR DataConfig Log:

image.png

3.  Open the HAR Log in Notepad++ and select Plugins>>HEX-Editor>>View in HEX to view the file in HEX:

 

4.   Then search for "c2 a0" throughout the document, as below.  The "c2 a0" is the HEX equivalent of a "Non-Breaking space".  Below is showing a a Enterprise data configuration with the space in the name "dataconfigurationWITHspecialspace after this before this":

 

 

If there exists and entry of  c2 a0 in the search, the Non-Breaking Space is present in one of the Enterprise objects.  

 

5.  Run the attached SVB script in Statistica to find all the objects with the Non-Breaking Space.  The default value for constant DRY_RUN=True.  Run the SVB (F5) with the default to find all the affected objects:

 

 

Output:

 

 

6.  Change DRY_RUN=False and run the script again to fix :

 

Output:

image.png

 

Issue/Introduction

How to resolve when the Statistica Server (a.k.a WebStatistica) object tree is blank

Additional Information

https://www.ascii-code.com/character/nbsp

https://www.unicode.org/charts/PDF/U0080.pdf

 

Attachments

fix_object_bad_name_space.svb get_app