Opening an analysis gets stuck on "Loading rows" due to the error: "com.spotfire.ws.dat.OperatorException: operator turned off during getData".

Opening an analysis gets stuck on "Loading rows" due to the error: "com.spotfire.ws.dat.OperatorException: operator turned off during getData".

book

Article ID: KB0080243

calendar_today

Updated On:

Products Versions
Spotfire Web Player All Versions

Description

When opening an analysis file, it gets stuck on "Loading rows" and the following error signature is found in the server.log on the TIBCO Spotfire Server:

ws.dat.AbstractOperator: Get data from job failed.

com.spotfire.ws.dat.OperatorException: operator turned off during getData

Resolution

This error is logged when a database connection from the TIBCO Spotfire Server to the data source is closed before all the data could be fetched. Therefore to resolve this issue, increase the “connection-login-timeout” setting in the configuration.xml file. To do this, follow these steps:
  1. Export the TIBCO Spotfire Server configuration from the server using the “export-config” command or via the TIBCO Spotfire Server Configuration tool.
  2. Edit the configuration.xml in a plain text editor (like Notepad)
  3. Find the <connection-login-timeout> entry:
    <!-- Login timeout for JDBC database connections. -->
    <connection-login-timeout>10</connection-login-timeout>
  4. Change the value of the “connection-login-timeout” setting to a higher value. For example:
    <!-- Login timeout for JDBC database connections. -->
    <connection-login-timeout>20</connection-login-timeout>
  5. Save the file.
  6. Import the configuration to the database using the “import-config” command or via the TIBCO Spotfire Server Configuration tool.
  7. Restart the TIBCO Spotfire Server service.

Issue/Introduction

Opening an analysis gets stuck on "Loading rows" due to the error: "com.spotfire.ws.dat.OperatorException: operator turned off during getData".

Additional Information

TIBCO Spotfire Installation and Administration Manual:

  • https://docs.tibco.com/products/tibco-spotfire-server