No user session found with ID error when open Spotfire Web Player

I am receiving an error when trying to access spotfire webplayer through my CRM integration:

This is what shows up in the event viewer log:

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[InvalidOperationException: The user session is not logged on to server.

No user session found with id 'ilstxtnsngwrp3xjvbzlqpkd'.]

   Spotfire.Dxp.Web.SiteManager.GetUserSession(String sessionId) +257

   Spotfire.Dxp.Web.Forms.Library.get_userSession() +88

   Spotfire.Dxp.Web.Forms.Library.Page_Load(Object sender, EventArgs e) +2680

   System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +25

   System.Web.UI.Control.LoadRecursive() +71

   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3064

This is what shows up in the Spotfire.Dxp.Web.Log:

 

INFO  2013-10-22 11:00:27,839 [1, (null)] Spotfire.Dxp.Web.Forms.Global - Web application starting...

INFO  2013-10-22 11:00:29,493 [1, (null)] Spotfire.Dxp.Web.SiteManager - Machine environment: Name=SERVER-SSAA, OS Version=Microsoft Windows NT 6.1.7601 Service Pack 1, Is 64 bit OS=True, Processor count=2, .NET version=4.0.30319.296.

INFO  2013-10-22 11:00:29,493 [1, (null)] Spotfire.Dxp.Web.SiteManager - Process environment: Assembly version: 11.22.6525.4034, Runs as=NT AUTHORITY\NETWORK SERVICE, Is 64 bit process=True.

INFO  2013-10-22 11:00:39,104 [1, (null)] Spotfire.Dxp.Services.ManifestReader - Downloading the manifest from 'http://slx-ssaa:8081/spotfire/manifest' took 9517.159 milliseconds

INFO  2013-10-22 11:00:40,196 [1, (null)] Spotfire.Dxp.Web.Library.ScheduledUpdates - Loading scheduled updates from Library, cache file C:\Program Files\TIBCO\Spotfire Web Player\5.0.0\webroot\App_Data\ScheduledUpdates.xml

INFO  2013-10-22 11:00:42,255 [1, (null)] Spotfire.Dxp.Web.Library.ScheduledUpdates - Creating scheduler user session with credentials from applicationSettings/Spotfire.Dxp.Web.Properties.Settings

WARN  2013-10-22 11:00:45,634 [1, (null)] Spotfire.Dxp.Data.Access.Adapters.LicensedDataAdapterRegistry - Licensed data adapter "Oracle" is unavailable. (The Oracle Data Provider for .NET is not available.)

WARN  2013-10-22 11:00:45,634 [1, (null)] Spotfire.Dxp.Data.Access.Adapters.LicensedDataAdapterRegistry - Licensed data adapter "Microsoft SQL Server Analysis Services" is unavailable. (The Microsoft ADOMD.NET driver is not available.)

WARN  2013-10-22 11:00:45,650 [1, (null)] Spotfire.Dxp.Data.Access.Adapters.LicensedDataAdapterRegistry - Licensed data adapter "Teradata" is unavailable. (The .NET Data Provider for Teradata is not available.)

INFO  2013-10-22 11:00:46,399 [1, (null)] Spotfire.Dxp.Web.SiteManager - Web Player server started on host 'SERVER-SSAA'.

ERROR 2013-10-22 11:00:47,398 [9, (null)] Spotfire.Dxp.Services.SessionEnabledSoapClient - Failed to make web service call. WebRequest details: Timeout='3600000', RequestUri='http://servername:8081/spotfire/ws/LoginService', Cookies=''

System.Net.WebException: The remote server returned an error: (500) Internal Server Error

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><soap:Fault><faultcode>soap:Server</faultcode><faultstring>Impersonation failed.</faultstring><detail><ns2:LoginWebServiceException xmlns:ns2="http://spotfire.tibco.com/ws/2008/11/faults.xsd"><errorCode>Server.LoginService.ImpersonationFailed</errorCode><message>Impersonation failed.</message><stackTrace xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"></stackTrace></ns2:LoginWebServiceException></detail></soap:Fault></soap:Body></soap:Envelope>.

   at Spotfire.Dxp.Framework.HttpClient.NativeWebResponse..ctor(NativeHttpClient httpClient, NativeWebRequest request)

   at Spotfire.Dxp.Framework.HttpClient.WinHttp.WinHttpWebRequest.GetResponseCore()

   at Spotfire.Dxp.Framework.HttpClient.NativeWebRequest.GetResponse()

   at Spotfire.Dxp.Services.SessionEnabledSoapClient.GetWebResponse(WebRequest request)

INFO  2013-10-22 11:00:47,414 [9, (null)] Spotfire.Dxp.Services.Authenticator - Failed to authenticate user 'ImpersonationIdentity: [SpotfireIdentity: Admin, IsAuthenticated False, AllowPreAuthenticate False], Impersonator: [SerializableIdentity: [SpotfireIdentity: ssaaservice, IsAuthenticated False, AllowPreAuthenticate True], Username ssaaservice, Password hash 345516557, App type MultiUser], Impersonatee [SpotfireIdentity: Admin, IsAuthenticated False, AllowPreAuthenticate True]'.

System.Web.Services.Protocols.SoapException: Impersonation failed.

   at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)

   at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)

   at Spotfire.Dxp.WebServices.LoginService.impersonate(String asNewUser)

   at Spotfire.Dxp.Services.Login.LoginService.Impersonate(String username)

   at Spotfire.Dxp.Services.Authenticator.Authenticate(SpotfireIdentity identity, PrincipalProvider provider)

ERROR 2013-10-22 11:00:47,414 [9, (null)] Spotfire.Dxp.Web.Forms.Global - Error in session start.

System.Web.Services.Protocols.SoapException: Impersonation failed.

   at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)

   at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)

   at Spotfire.Dxp.WebServices.LoginService.impersonate(String asNewUser)

   at Spotfire.Dxp.Services.Login.LoginService.Impersonate(String username)

   at Spotfire.Dxp.Services.Authenticator.Authenticate(SpotfireIdentity identity, PrincipalProvider provider)

   at Spotfire.Dxp.Web.WebAuthenticator.PerformAuthenticate(SpotfireIdentity identity, PrincipalProvider provider, Boolean createUserSession)

   at Spotfire.Dxp.Web.Forms.Global.Session_Start(Object sender, EventArgs e)

ERROR 2013-10-22 11:00:47,710 [9, (null)] Spotfire.Dxp.Web.Forms.Global - Application error:

Sender:

ASP.global_asax

QueryString:

System.InvalidOperationException: The user session is not logged on to server.

No user session found with id 'ilstxtnsngwrp3xjvbzlqpkd'.

   at Spotfire.Dxp.Web.SiteManager.GetUserSession(String sessionId)

   at Spotfire.Dxp.Web.Forms.Library.get_userSession()

   at Spotfire.Dxp.Web.Forms.Library.Page_Load(Object sender, EventArgs e)

   at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)

   at System.Web.UI.Control.LoadRecursive()

   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

INFO  2013-10-22 11:00:48,584 [WorkThread 14, ssaaservice WAT 2] Spotfire.Dxp.Framework.Persistence.PersistenceManager - Opening file 'C:\Program Files\TIBCO\Spotfire Web Player\5.0.0\Temp\Library\588c179e-58c0-49b5-aa6b-77851d55e3dfcd8b447b-9f8a-4656-b3f4-6fe8131350e2.dxp' as best match of file type 'Spotfire.Dxp.Framework.Persistence.DxpDocumentFileReader'.

INFO  2013-10-22 11:00:48,584 [WorkThread 15, ssaaservice WAT 1] Spotfire.Dxp.Framework.Persistence.PersistenceManager - Opening file 'C:\Program Files\TIBCO\Spotfire Web Player\5.0.0\Temp\Library\636cefcf-4350-4fae-b5ec-9b77695e16c6e82b591a-8c41-4280-bfd8-ff8bcba6bb12.dxp' as best match of file type 'Spotfire.Dxp.Framework.Persistence.DxpDocumentFileReader'.

WARN  2013-10-22 11:00:49,395 [WorkThread 15, ssaaservice WAT 1] Spotfire.Dxp.Framework.Persistence.Xml.DeserializationFormatter - Cannot bind type 'Spotfire.Dxp.Data.DerivedOwningColumnImpl, Spotfire.Dxp.Data, Version=7.8.4003.19586, Culture=neutral, PublicKeyToken=789861576bd64dc5'. Using Spotfire.Dxp.Framework.Persistence.UnknownObject.

WARN  2013-10-22 11:00:49,395 [WorkThread 15, ssaaservice WAT 1] Spotfire.Dxp.Framework.Persistence.Xml.DeserializationFormatter - Cannot bind type 'Spotfire.Dxp.Data.Producers.DerivedColumnProducer, Spotfire.Dxp.Data, Version=7.8.4003.19586, Culture=neutral, PublicKeyToken=789861576bd64dc5'. Using Spotfire.Dxp.Framework.Persistence.UnknownObject.

WARN  2013-10-22 11:00:49,411 [WorkThread 14, ssaaservice WAT 2] Spotfire.Dxp.Framework.Persistence.Xml.DeserializationFormatter - Cannot bind type 'Spotfire.Dxp.Data.DerivedOwningColumnImpl, Spotfire.Dxp.Data, Version=7.8.4003.19586, Culture=neutral, PublicKeyToken=789861576bd64dc5'. Using Spotfire.Dxp.Framework.Persistence.UnknownObject.

WARN  2013-10-22 11:00:49,427 [WorkThread 14, ssaaservice WAT 2] Spotfire.Dxp.Framework.Persistence.Xml.DeserializationFormatter - Cannot bind type 'Spotfire.Dxp.Data.Producers.DerivedColumnProducer, Spotfire.Dxp.Data, Version=7.8.4003.19586, Culture=neutral, PublicKeyToken=789861576bd64dc5'. Using Spotfire.Dxp.Framework.Persistence.UnknownObject.

WARN  2013-10-22 11:00:49,676 [WorkThread 14, ssaaservice WAT 2] Spotfire.Dxp.Framework.Persistence.Xml.DeserializationFormatter - Cannot bind type 'Spotfire.Dxp.Application.Visuals.PlotDataStatus, Spotfire.Dxp.Application, Version=7.8.4003.19586, Culture=neutral, PublicKeyToken=789861576bd64dc5'. Using Spotfire.Dxp.Framework.Persistence.UnknownObject.

WARN  2013-10-22 11:00:49,692 [WorkThread 15, ssaaservice WAT 1] Spotfire.Dxp.Framework.Persistence.Xml.DeserializationFormatter - Cannot bind type 'Spotfire.Dxp.Application.Visuals.PlotDataStatus, Spotfire.Dxp.Application, Version=7.8.4003.19586, Culture=neutral, PublicKeyToken=789861576bd64dc5'. Using Spotfire.Dxp.Framework.Persistence.UnknownObject.

WARN  2013-10-22 11:00:49,707 [WorkThread 14, ssaaservice WAT 2] Spotfire.Dxp.Framework.Persistence.Xml.DeserializationFormatter - Cannot bind type 'Spotfire.Dxp.Application.Visuals.PlotLayer, Spotfire.Dxp.Application, Version=7.8.4003.19586, Culture=neutral, PublicKeyToken=789861576bd64dc5'. Using Spotfire.Dxp.Framework.Persistence.UnknownObject.

This is what shows up in the Tibco Spotfire server.log:

WARN 2013-10-22T11:00:25,025-0400 [*Initialization*] spotfire.server.LifecycleManager: The Java Cryptography Extension (JCE) Unlimited Strength Jurisdiction Policy does not seem to be installed. Please consider installing it for improved security.

WARN 2013-10-22T11:00:47,047-0400 [ssaaservice@SPOTFIRE, #2] server.security.AllowedHosts: All hosts are allowed!

WARN 2013-10-22T11:00:47,047-0400 [ssaaservice@SPOTFIRE, #2] server.security.ImpersonationManager: Ignoring impersonator specified without domain ssaaservice

WARN 2013-10-22T11:00:47,047-0400 [ssaaservice@SPOTFIRE, #2] server.security.ImpersonationManager: User ssaaservice[323e904e-513f-4614-8858-475a20bb9b25] is not permitted to impersonate other users

ERROR 2013-10-22T11:00:55,055-0400 [ssaaservice@SPOTFIRE, #1] util.sql.PoolingDataSource: Error registering an MBean for data source 'TempData (6e4690eb-0097-432f-8401-eff341d0d0cc)'. No MBean will be registered for the data source.

javax.management.InstanceAlreadyExistsException: com.spotfire.server:type=DataSource,name="TempData (6e4690eb-0097-432f-8401-eff341d0d0cc)"

          at com.sun.jmx.mbeanserver.Repository.addMBean(Repository.java:437)

          at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.registerWithRepository(DefaultMBeanServerInterceptor.java:1898)

          at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.registerDynamicMBean(DefaultMBeanServerInterceptor.java:966)

          at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.registerObject(DefaultMBeanServerInterceptor.java:900)

          at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.registerMBean(DefaultMBeanServerInterceptor.java:324)

          at com.sun.jmx.mbeanserver.JmxMBeanServer.registerMBean(JmxMBeanServer.java:512)

          at com.spotfire.server.util.sql.PoolingDataSource.registerMBean(PoolingDataSource.java:423)

          at com.spotfire.server.util.sql.PoolingDataSource.init(PoolingDataSource.java:360)

          at com.spotfire.server.util.ConnectionPoolFactory.createConnectionPool(ConnectionPoolFactory.java:67)

          at com.spotfire.ws.im.ds.sql.JDBCDataSourceManager.init(JDBCDataSourceManager.java:394)

          at com.spotfire.ws.im.InformationModel.getDataSource(InformationModel.java:589)

          at com.spotfire.ws.api.query.QueryManagerService.getStatusForDataSources(QueryManagerService.java:755)

          at com.spotfire.ws.api.query.QueryManagerService.getJobSpec(QueryManagerService.java:851)

          at com.spotfire.ws.api.query.QueryManagerService.getJobSpecForId(QueryManagerService.java:143)

          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

          at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

          at java.lang.reflect.Method.invoke(Method.java:601)

          at org.apache.cxf.service.invoker.AbstractInvoker.performInvocation(AbstractInvoker.java:173)

          at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:89)

          at org.apache.cxf.jaxws.JAXWSMethodInvoker.invoke(JAXWSMethodInvoker.java:61)

          at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:75)

          at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:58)

          at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)

          at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)

          at java.util.concurrent.FutureTask.run(FutureTask.java:166)

          at org.apache.cxf.workqueue.SynchronousExecutor.execute(SynchronousExecutor.java:37)

          at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:106)

          at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:263)

          at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121)

          at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:206)

          at org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:218)

          at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:200)

          at org.apache.cxf.transport.servlet.CXFNonSpringServlet.invoke(CXFNonSpringServlet.java:114)

          at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:184)

          at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doPost(AbstractHTTPServlet.java:107)

          at javax.servlet.http.HttpServlet.service(HttpServlet.java:641)

          at org.apache.cxf.transport.servlet.AbstractHTTPServlet.service(AbstractHTTPServlet.java:163)

          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)

          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

          at com.spotfire.server.security.SecurityFilter.doFilter(SecurityFilter.java:236)

          at com.spotfire.server.security.AbstractFilter.doFilter(AbstractFilter.java:111)

          at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)

          at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)

          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)

          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

          at com.spotfire.server.security.CacheControlFilter.doFilter(CacheControlFilter.java:85)

          at com.spotfire.server.security.AbstractFilter.doFilter(AbstractFilter.java:111)

          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)

          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

          at com.spotfire.server.security.HttpMethodsFilter.doFilter(HttpMethodsFilter.java:203)

          at com.spotfire.server.security.HttpMethodsFilter.doFilter(HttpMethodsFilter.java:172)

          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)

          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

          at com.spotfire.server.security.AccessLogFilter.doFilter(AccessLogFilter.java:75)

          at com.spotfire.server.security.AbstractFilter.doFilter(AbstractFilter.java:111)

          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)

          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

          at com.spotfire.server.security.WrappingFilter.doFilter(WrappingFilter.java:56)

          at com.spotfire.server.security.AbstractFilter.doFilter(AbstractFilter.java:111)

          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)

          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

          at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)

          at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)

          at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)

          at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)

          at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)

          at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)

          at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)

          at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1002)

          at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:585)

          at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)

          at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)

          at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)

          at java.lang.Thread.run(Thread.java:722)

Things that I have tried and that I know work:

  1. I can browse to the "http://localhost/spotfireweb" through a broswer session and it correctly displays "Sorry you are not authorized to access the analytics system."
  2. I can browse to the tibco spotfire server and access the administration panel and the logs through a browser session.
  3. I can login to the Tibco Spotfire server using the application and add users, licenses, libraries, etc.
  4. I have added users to both the database, and to the local machine that match in terms of usernames and passwords and permissions.
  5. I have tried modifying the web player web.config with different permutations, and all end with the same result above.
  6. I have reset the app pool, iisreset, and rebooted machine many times.

Any help or insight is much appreciated!

(6) Answers

Login