On demand data fails when too many keys are selected.

[Michele Scarpa]

Hello,

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

Thanks

Michele

[Shandilya Peddi]

Can you add the complete error message you see That might provide some information about the cause

[Michele Scarpa]

The error I posted is all I can see. Should I ask to server administrator

[Michele Scarpa]

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.