Cause of System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection

[Manojkumar T]

Below error is occuring while using Odata connector in Spotfire 10.3.1 for Odata connection. Is there a limilation for no. of columns to select. It seems the size of collection is exceeding while reading data from data source. Can someone please advise on the same.

Error message: An exception was thrown by the data connection.

ImportException at Spotfire.Dxp.Data:

An exception was thrown by the data connection.

Exception text:

System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.

Parameter name: index

at System.Collections.ArrayList.get_Item(Int32 index)

at Spotfire.Dxp.Data.Adapters.OData.ODataQueryContext.AddRowsDataForJSon(ArrayList[] dataBlocks, SbdfTableWriter writer, QueryUrlInfo queryInfo)

at Spotfire.Dxp.Data.Adapters.OData.ODataAdapterConnection.ExecuteQueryForJSon(ODataQueryContext queryContext, QueryUrlInfo queryInfo, SbdfTableWriter writer)

at Spotfire.Dxp.Data.Adapters.OData.ODataAdapterConnection.c__DisplayClass8_1.b__0(NativeQueryExecutionDiagnostics executionDia)

at Spotfire.Dxp.Data.Access.QueryExecution.QueryTrackerService.ExecuteQuery(QueryExecutionInfo queryExecutionInfo, QueryExecutor queryExecutor, CancellationToken cancellationToken)

at Spotfire.Dxp.Data.Adapters.OData.ODataAdapterConnection.ExecuteQueryCore(SqlQuery query, AdapterDataSchema schema, QueryResultWriter resultWriter, CancellationToken cancellationToken, IDictionary`2 logContext)

at Spotfire.Dxp.Data.Access.Adapters.DataAdapterConnection.ExecuteQuery(SqlQuery query, AdapterDataSchema schema, QueryResultWriter resultWriter, IDictionary`2 logContext, CancellationToken cancellationToken)

at Spotfire.Dxp.Data.Access.Adapters.DataAdapter.TryExecuteQuery(IDataAdapterExecutionContext executionContext, AdapterCredentialsValue credentials, SqlQuery query, AdapterDataSchema schema, QueryResultWriter resultWriter, IDictionary`2 logContext, CancellationToken cancellationToken)

at Spotfire.Dxp.Data.Access.Adapters.DataAccessDataSourceLink.c__DisplayClass81_1.b__1(CancellationToken token)

at Spotfire.Dxp.Data.Access.Adapters.DataAccessDataSourceLink.ExecuteAdapterMethod(ImpersonationPolicy impersonationPolicy, AdapterMethodDelegate method, Nullable`1 cancellationToken)

[Srinivas reddy somireddy]

reply pls i am also facing same issue on above