'System.NullReferenceException: Object reference not set to an instance of an object' error while Stored Procedure in Spotfire Client through Data Connector

'System.NullReferenceException: Object reference not set to an instance of an object' error while Stored Procedure through Data Connector.

There are 2 parameters involved with String  Data type used, on which Casting is applied to match it with DATE Datetype.We are seeing above error while pulling that Stored Procedure into Client using Data Connector.

Below is the remaining part of the error message.we are using currently 7.7.1

- at Spotfire.Dxp.Data.Adapters.Teradata.TeradataAdapterConnection.GetColumnOrdinals(DbDataReader reader, String tableName, IList`1 columnNames, Int32[]& columnOrdinals, List`1& columnNameMapOrdinal)
   at Spotfire.Dxp.Data.Adapters.Teradata.TeradataAdapterConnection.ExecuteQueryCommon(SqlQuery query, CommandType commandType, String queryString, Dictionary`2 parameters, IReadOnlyList`1 outParameters, IList`1 storedProcedureColumns, QueryResultWriter resultWriter, CancellationToken cancellationToken, DataTableSchema tableSchema)
   at Spotfire.Dxp.Data.Adapters.Teradata.TeradataAdapterConnection.ExecuteStoredProcedureQuery(SqlQuery query, AdapterDataSchema schema, QueryResultWriter resultWriter, CancellationToken cancellationToken)
   at Spotfire.Dxp.Data.Adapters.Teradata.TeradataAdapterConnection.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, CancellationToken cancellationToken, IDictionary`2 logContext)
   at Spotfire.Dxp.Data.Access.Adapters.DataAdapter.TryExecuteQuery(IDataAdapterExecutionContext executionContext, AdapterCredentialsValue credentials, SqlQuery query, AdapterDataSchema schema, QueryResultWriter resultWriter, CancellationToken cancellationToken, IDictionary`2 logContext)
   at Spotfire.Dxp.Data.Access.Adapters.DataAccessDataSourceLink.<>c__DisplayClass60.<>c__DisplayClass62.<ExecuteQueryAndCreateTable>b__5e(CancellationToken token)
   at Spotfire.Dxp.Data.Access.Adapters.DataAccessDataSourceLink.ExecuteAdapterMethod(ImpersonationPolicy impersonationPolicy, AdapterMethodDelegate method, Nullable`1 cancellationToken)

1 Comment

Please any help would be apprecaited

rajkomakula12 - Nov 27, 2017 - 4:17am ::
+ Add a Comment

(1) Answer

Login