TDV data source throws "InformationModelException at Spotfire.Dxp.Data: Data source busy error in TIBCO Spotfire Analyst

TDV data source throws "InformationModelException at Spotfire.Dxp.Data: Data source busy error in TIBCO Spotfire Analyst

book

Article ID: KB0072349

calendar_today

Updated On:

Products Versions
Spotfire Server 10.10 and later

Description

Added a new data source on Spotfire and validated successfully, but when we try to see the contents ( from Information Designer) it throws the following error:
  
Error message: Could not get contents of 'TDV_test' from the server.

InformationModelException at Spotfire.Dxp.Data:
Data source busy. (HRESULT: 80131500)

Stack Trace:
   at Spotfire.Dxp.Data.InformationModel.InternalInformationModelManager.ListDataSourceChildren(Guid dataSourceId, String dataSourceName)
   at Spotfire.Dxp.Forms.Data.InformationDesigner.Cache.CachedDataSource.<GetChildren>d__34.MoveNext()
   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
   at Spotfire.Dxp.Forms.Data.InformationDesigner.Cache.CachedItem.EnsureChildrenLoaded()
   at Spotfire.Dxp.Forms.Data.InformationDesigner.VirtualMultiSelectTreeView.TreeItem.Expand()

InformationModelServiceException at Spotfire.Dxp.Services:
Data source busy. (HRESULT: 80131509)

Stack Trace:
   at Spotfire.Dxp.Services.WcfSoapService`2.InvokeService[T](Func`1 serviceMethod, String customMethodNameForLogging)
   at Spotfire.Dxp.Data.InformationModel.InternalInformationModelManager.ListDataSourceChildren(Guid dataSourceId, String dataSourceName)

Issue/Introduction

The article provides information about TDV data source throws "InformationModelException at Spotfire.Dxp.Data: Data source busy error on expanding the data source in Information Designer

Environment

All supported OS

Resolution

Increasing Max Connections on the data source shall resolve the "Data Source Busy" error:

1) Login to Spotfire Analyst Client as an Administrator.
2) Go to Tools -> Information Designer.
3) Select the same data source and Edit.
4) In the Edit Page, increase the max value of No of Connections
5) Save the data source.

Or you can set min and max to 0 to disable connection pooling if that is desired.

Additional Information

https://docs.tibco.com/pub/sfire-analyst/11.8.0/doc/html/en-US/TIB_sfire-analyst_UsersGuide/id/id_data_source_tab.htm
Powered by Wolken Software