Analysis does not open in Web Player

I have created an analysis in Spotifre which is based on data from a SQL Server database. The data tables are linked to the source and the credentials are stored in the analysis. Web Player, Spotfire Server and SQL Server are running on three different machines within the same network. Both server running the Spotfire components can access each other as well as the SQL database. With Spotfire on my desktop it works fine. However, when I store the analysis in the library and access it via Web Player it fails. The Web Player shows an error page that it could not open the analysis. Checking the logfile brings up the following:

ERROR 2015-10-29 18:17:44,712 [334qbrbhgyoo52oaktmgeyhi, 9768, WorkThread 5, luftf WAT 1] Spotfire.Dxp.Web.Prompting.PromptHandler+PromptItem - System.InvalidOperationException: Sequence contains more than one matching element at Spotfire.Dxp.Data.Producers.ConnectorImportColumnProducer.b__b(Exception exception, Boolean changed) at Spotfire.Dxp.Data.Producers.ConnectorImportColumnProducer.d__0.MoveNext() at Spotfire.Dxp.Data.DataTable.d__52.MoveNext() at Spotfire.Dxp.Data.DataManager.d__93.MoveNext() at Spotfire.Dxp.Data.DataManager.d__4c.MoveNext() at Spotfire.Dxp.Data.DataManager.d__38.MoveNext() at Spotfire.Dxp.Data.DataManager.d__1f.MoveNext() at Spotfire.Dxp.Application.PartiallyOpenedDxpFile.d__0.MoveNext() at Spotfire.Dxp.Application.AnalysisApplication.d__34.MoveNext() at Spotfire.Dxp.Web.WebAnalysis.d__bc.MoveNext() at Spotfire.Dxp.Web.WebAnalysis.d__c4.MoveNext() at Spotfire.Dxp.Web.WebAnalysis.d__dd.MoveNext() at Spotfire.Dxp.Web.Prompting.PromptHandler.PromptItem.PromptNext() at Spotfire.Dxp.Web.Prompting.PromptHandler.PromptItem.Execute()

Does anyone has an idea what's the reason for this error and how to solve it? Thanks for your support!

1 Comment

I also got the same issue. Please find my error log below.

ERROR 2016-11-15T14:31:12,597-0500 [balajikumar.srinivasan@abc.com, #5175, #160746] wp.controller.ErrorPageController: Reference=1b6d652d-4d0a-4896-a286-3200351cb93c, ClientError: Unable to open analysis '/market/analysis/myfile.
Spotfire.Dxp.Framework.DocumentModel.ApplyStateException: An exception occurred during applying document state. ---> System.InvalidOperationException: Row count mismatch.
   at Spotfire.Dxp.Data.Cxx.CxxTable.AddFreeColumnAllValid(CxxDataType dataType, Action`1 columnBuilder)
   at Spotfire.Dxp.Data.Cxx.CxxDataTransfer.TransferIndexSet(CxxTable table, IndexSet indexSet, CxxSession session)
   at Spotfire.Dxp.Application.Filters.ListBoxFilter.<>c__DisplayClass20.<SetValueIndexes>b__1f()
   at Spotfire.Dxp.Framework.DocumentModel.Node.InternalTransaction(Executor executor, Boolean rollbackNestedInternalTransactionAtException)
   at Spotfire.Dxp.Application.Filters.ListBoxFilter.HandleValueSetChangesFromDocumentState(IndexSet selection, IList oldValues)
   at Spotfire.Dxp.Application.Filters.ListBoxFilter.Spotfire.Dxp.Framework.DocumentModel.IDocumentNodeState.OnPropertyStateChanged(Set`1 properties, Object additionalData)
   at Spotfire.Dxp.Framework.DocumentModel.DocumentState.BroadcastPropertyStateChanged(Set`1 roots, Dictionary`2 additional)
   at Spotfire.Dxp.Framework.DocumentModel.DocumentState.ChangeCollector.BroadcastChanges()
   at Spotfire.Dxp.Framework.DocumentModel.Node.InternalTransaction(Executor executor, Boolean rollbackNestedInternalTransactionAtException)
   at Spotfire.Dxp.Framework.DocumentModel.DocumentState.ApplyTo(DocumentNode root, Boolean allViews)
   --- End of inner exception stack trace ---
   at Spotfire.Dxp.Framework.DocumentModel.DocumentState.ApplyTo(DocumentNode root, Boolean allViews)
   at Spotfire.Dxp.Web.WebAnalysisRoot.ApplyDocumentState(DocumentState state, Boolean allViews)
   at Spotfire.Dxp.Web.UserSession.ApplyStateFromLibrary(WebAnalysis wa)
   at Spotfire.Dxp.Application.AnalysisApplication.<OpenPartiallyOpenedDocument>d__34.MoveNext()
   at Spotfire.Dxp.Web.WebAnalysisRoot.<Open>d__53.MoveNext()
   at Spotfire.Dxp.Web.WebAnalysisRoot.<OpenFromCache>d__37.MoveNext()
   at Spotfire.Dxp.Web.WebAnalysisRoot.<OpenWithProgress>d__1f.MoveNext()
   at Spotfire.Dxp.Web.WebAnalysis.<OpenWithProgress>d__b9.MoveNext()
   at Spotfire.Dxp.Web.Prompting.PromptHandler.PromptItem.PromptNext()
   at Spotfire.Dxp.Web.Prompting.PromptHandler.PromptItem.Execute()
 

Vidya Sagar - Nov 15, 2016 - 11:41am
+ Add a Comment

(4) Answers

Login