Question

Jeff_Block on Mon, 12 Dec 2016 20:51:42


The SSIS task (VS 2015 Update 3, SSDT 2016 SP1) throws an exception for every profile type except nulls. The error is consistent. The task works against Azure DB and of course SQL DB. I can't imagine this is expected behavior. 

[Data Profiling Task] Error: Error occurred when profiling the data. The error message is: System.Data.SqlClient.SqlException (0x80131904): 111607;Error during statement generation: Object reference not set to an instance of an object.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at Microsoft.DataDebugger.DataProfiling.Sql8Service.GetTableSizeFast(TableQName table, Int32 timeout, DbConnection connection, ICommandAdapter commandService, Int64& rowCount, Int64& sizeInKB)
   at Microsoft.DataDebugger.DataProfiling.Sql8Service.IsNonMaterializedView(TableQName table, Int32 timeout, DbConnection connection, ICommandAdapter commandService)
   at Microsoft.DataDebugger.DataProfiling.DataSourceInternal.IsNonMaterializedView(TableQName table, Int32 timeout)
   at Microsoft.DataDebugger.DataProfiling.TableInfoInternal.Init(BuiltInProfiler profiler)
   at Microsoft.DataDebugger.DataProfiling.TablePartitionedBatch.ComputeProfiles()
   at Microsoft.DataDebugger.DataProfiling.BuiltInProfiler.Profile()
ClientConnectionId:d8f9dec6-04aa-41b4-bb0e-7614a7035840
Error Number:110813,State:1,Class:16
ClientConnectionId before routing:98e590f0-8a66-43ca-a6a6-e1c1a2495816



Jeff Block t:@sqlDictum (http://www.twitter.com/sqlDictum)


Sponsored