Spotfire Statistics Services server suddenly stops working after a long period of working fine
Article ID: KB0078580
Updated On:
| Products | Versions |
|---|---|
| Spotfire Statistics Services | 7.5, 7.11.0, 7.11.1, 10.0.0 |
Description
Symptoms in logs:
java.lang.IllegalStateException: Problem starting a job
...
Caused by: java.lang.IllegalStateException: Unable to construct a directory: C:\Program Files\TIBCO\statsvcs75\TERR\data\requests\711
There can be other symptoms as well. If Spotfire Statistics Services (TSSS) has been running for a long time and suddenly does not work any longer it can be because the server fails to remove files on disk or the h2 database has filled up with too much information. The server may become gradually slower or just stop to work. Then a manual cleaning can help.
Issue/Introduction
Environment
Resolution
1. Stop TIBCO Spotfire Statistics Services
2. Delete <tsss install dir>/h2/*
3. Delete <tsss install dir>/data/artifacts/spotfire/*.sbdf
4. Delete <tsss install dir>/data/requests/*
5. Verify that the file permissions are set correctly for all file in the installation folder. Give full read/write permission to files in the installation path for the user running the TSSS service
6. Start the server
Feedback
