TIBCO Spotfire Server Service fails to start with ERROR 1067: The process terminated unexpectedly.

TIBCO Spotfire Server Service fails to start with ERROR 1067: The process terminated unexpectedly.

TIBCO Spotfire Server Service in Windows Services Console (services.msc) fails to start with below error :


You may also see below error in TIBCO Spotfire server logs(server.log file):
------------ 
DEBUG 2020-02-01T02:13:18,986-0500 [localhost-startStop-2] util.sql.ConnectionUtil: Error closing database connection.
java.sql.SQLRecoverableException: No more data to read from socket
------------- Generally, when TIBCO Spotfire server service starts, it scans the data source(s) related driver's (jar files) placed in below folders :

Scenario 1) Spotfire server version 10.3 and lower: 
Driver location is <installation dir>/tomcat/lib

Scenario 2) Spotfire server version 10.3 and above:  
When defining a new data source or enabling any data source template, the vendor-specific JDBC jar file should now be copied to : <installation dir>/tomcat/custom-ext

NOTE:
1)  By default all the Datadirect drivers (provided by TIBCO) are now placed at <installation dir>/tomcat/spotfire-lib folder.
2)  It may work if you copy the jar files to <Spotfire Server>\tomcat\lib, but it is highly recommended to copy to "custom-ext" folder as mentioned above.

If there are data source related drivers in the locations mentioned above, but their associated/respective data source template are not enabled or the data source itself is invalid then Spotfire server service may fail to start.

Spotfire admin should remove such jar files from above mentioned folders.