Is there any size limit to fetch the data through On Demand settings.

[Sri A]

HI ,

We are having a data record of approx224626285 which we are pulling at presnt in our report through On demand settings .

The issue is like if we areapply eitheroneor two filter conditions "On demand functionality is not wokring".It throwing the below error .

If we apply 4 to 5 filter conditions then the data is retriving in couple ofseconds .

So is there any size limitation to fetch the data through on demand settings and if yeswhat are the other possible options to use this much records of data

Error message when two filters applied :

Failed to execute data query

at Spotfire.Dxp.Data.Import.InformationLinkDataSourceConnection.ExecuteQueryCore2()

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()

 

Thanks in adavnce