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:
Export the TIBCO Spotfire Server configuration from the server using the “export-config” command or via the TIBCO Spotfire Server Configuration tool.
Edit the configuration.xml in a plain text editor (like Notepad)
Find the <connection-login-timeout> entry: <!-- Login timeout for JDBC database connections. --> <connection-login-timeout>10</connection-login-timeout>
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>
Save the file.
Import the configuration to the database using the “import-config” command or via the TIBCO Spotfire Server Configuration tool.
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: