Parameterized info link - not getting any values when passing large unique keys

Hi All,

In my report, I am using parameterized information link.  Using data on demand,  passing column values from other table.  I am able to get values on my report when passing smaller number of unique keys to parameter but i am not getting any values on my report when we pass more number of keys( for ex 1 million keys).  It is keep on loading and without writing any log on SQL log, server log etc. 

After long time am getting below error in report's left bottom.

Could not load on-demand data for table xxxx table
Failed to execute data source query.
   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.<ExecuteFunction>d__0.MoveNext()
   at Spotfire.Dxp.Data.DataFunctions.DataFunctionExecutorService.<ExecuteFunction>d__6.MoveNext()

Could you please let me know is there any size limitation in array string when we pass the values to information links?

Your help really appreciated.


Velmurugan N


(1) Answer