Skip to main content

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

Rich Talbot
  • Created
Date Posted:
Product: TIBCO Spotfire®

Problem:

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


Solution:

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
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.

TIBCO Spotfire Installation and Administration Manual:

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

Related articles

Comments

0 comments

Article is closed for comments.