Internal plot error in Web Player - "Table ... Has Invalid Rows for ..."

Internal plot error in Web Player - "Table ... Has Invalid Rows for ..."

book

Article ID: KB0084141

calendar_today

Updated On:

Products Versions
Spotfire Web Player 6.5, 7.0, 7.5, 7.6, 7.7, 7.8

Description

If an analysis is saved using the installed Spotfire client and then opened using the web client, locale differences can lead to errors in changed plot data. To avoid this issue, the Web Player can be configured to refresh data if there are any locale inconsistencies.

Error:
Spotfire.Dxp.Data.DataView2Cxx - Table <TABLE> Has Invalid Rows for <COLUMN>

Issue/Introduction

Internal plot error in Web Player - "Table ... Has Invalid Rows for ..."

Environment

TIBCO Spotfire Web Player, Consumer, Business Author

Resolution

Version 7.0 and lower

To fix this, make the following changes to the Web Player Web.config file.
 
1). In Web.Config, find the section <Spotfire.Dxp.Data.Properties.Settings> .
2). Change the value of the setting "DataView_RefreshForLocaleChanges" from "False" to "True".
3). Save the Web.Config file.
4). Restart IIS.
 

Version 7.5 and higher

In the file Spotfire.Dxp.Worker.Host.exe.config file for the custom named service configuration for the Web Player service, add the following setting in the <Spotfire.Dxp.Data.Properties.Settings> section:
 
<Spotfire.Dxp.Data.Properties.Settings>
      <setting name="DataView_RefreshForLocaleChanges" serializeAs="String">
        <value>True</value>
      </setting>

See the documentation for how to edit/set a custom service configuration (e.g. https://docs.tibco.com/pub/spotfire_server/7.8.0/doc/html/TIB_sfire_server_tsas_admin_help/GUID-958A3AB5-7243-4837-9AEA-78AA274A6F7E.html for version 7.8).