Shop

Your Notifications (0)

There are currently no notifications. You're all set!

Demos Trials
Knowledge Base
ChemDraw and ChemOffice+ Products Signals Notebook E-Notebook and ChemBioOffice Enterprise Spotfire and Signals Spotfire Products Columbus Signals Image Artist
Downloads
Downloads
Community
Support Forums Ideas Portal Product Basics
About Support
Legal Resources Support and Maintenance Plans Product Life Cycle Support News
Contact Support

Spotfire Server not accessible when using Integrated Authentication with Spotfire Database

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

Problem:

Spotfire Server not accessible when using Integrated Authentication with Spotfire Database


Solution:

The Spotfire Server might not come up when the database server is using Integrated Windows Authentication. Catalina log will be stuck at the following status for a long time, after every restart. 
=====
04-Feb-2019 13:57:47.690 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["http-nio-80"]
04-Feb-2019 13:57:47.706 INFO [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read
04-Feb-2019 13:57:47.706 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["http-nio-9080"]
04-Feb-2019 13:57:47.706 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["http-nio-9443"]
04-Feb-2019 13:57:47.706 INFO [main] org.apache.catalina.startup.Catalina.load Initialization processed in 529 ms
04-Feb-2019 13:57:47.706 INFO [main] org.apache.catalina.core.StandardService.startInternal Starting service [Spotfire]
04-Feb-2019 13:57:47.706 INFO [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet Engine: Apache Tomcat/9.0.13
04-Feb-2019 13:57:48.753 INFO [main] org.apache.catalina.core.ApplicationContext.log Initializing com.spotfire.server.root.RootHttpMethodsFilter
04-Feb-2019 13:57:48.769 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [C:\tibco\tss\10.0.1\tomcat\webapps\spotfire]
04-Feb-2019 13:57:53.503 INFO [main] org.apache.catalina.core.ApplicationContext.log 1 Spring WebApplicationInitializers detected on classpath
04-Feb-2019 14:04:46.866 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["http-nio-80"]
04-Feb-2019 14:04:46.882 INFO [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read
04-Feb-2019 14:04:46.897 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["http-nio-9080"]
04-Feb-2019 14:04:46.897 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["http-nio-9443"]
04-Feb-2019 14:04:46.897 INFO [main] org.apache.catalina.startup.Catalina.load Initialization processed in 544 ms
04-Feb-2019 14:04:46.897 INFO [main] org.apache.catalina.core.StandardService.startInternal Starting service [Spotfire]
04-Feb-2019 14:04:46.897 INFO [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet Engine: Apache Tomcat/9.0.13
04-Feb-2019 14:04:47.976 INFO [main] org.apache.catalina.core.ApplicationContext.log Initializing com.spotfire.server.root.RootHttpMethodsFilter
04-Feb-2019 14:04:47.991 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [C:\tibco\tss\10.0.1\tomcat\webapps\spotfire]
04-Feb-2019 14:04:52.757 INFO [main] org.apache.catalina.core.ApplicationContext.log 1 Spring WebApplicationInitializers detected on classpath
=====
  This issue can be seen if the Spotfire server service is running through a Windows domain account that does not have permission to use the Spotfire database.  When using the Windows Integrated Authentication, the account running the Spotfire Server service needs to have database owner access to the Spotfire database.

Note: When the database server is set up for Windows Integrated Authentication, the bootstrap will always use the account running the Spotfire Server service. Refer to the Spotfire Server Installation & Configuration manual for additional information

Related articles