Jump to content

On demand data fails when too many keys are selected.

Michele Scarpa

Recommended Posts


I created a dashboard that uses a series of on demand data load to select a small portion of a big dataset.

I can use two differente servers to use my dashboard on.

Inone of them everything works fine. On the other hand the second show the following error when too many keys for the on demand data load are selected:

Failed to execute data source query for data source "XXXXXXXXXXX".

at Spotfire.Dxp.Data.DataSourceConnection.ExecuteQuery2()

at Spotfire.Dxp.Data.OnDemand.InformationLinkFunctionExecutor.SetOutputResult(DataSource dataSource, DataFunctionInvocation invocation, Boolean isEmpty)

at Spotfire.Dxp.Data.OnDemand.InformationLinkFunctionExecutor.d__0.MoveNext()

at Spotfire.Dxp.Data.DataFunctions.DataFunctionExecutorService.d__6.MoveNext()


Is there a server setting that mightcause such behaviour



Link to comment
Share on other sites

I am replying in case anyone else might need this.

As far as I understood when few on demadn keys are selected Spotfire creates a query with a WHERE conditionssuch as "WHERE key in ('a', 'b', 'c')".

If too many keys are selected Spotfire creates a temporary tablein the DataSource and a join is performed.

The Spotfire template determines how the temporary table is created. In my case the template had the following attributes: "#$$name$$"

The character # is invalid for my DataSource (Postgresql DataBase) and therfore the on demand load failed.

The server administratorchanged the attribute in "$$name$$" to have it working.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...