Azure Data Catalog RegTool: Error when registering a HANA view

Arne 1 Reputation point
2020-10-09T11:06:18.367+00:00

When trying to register an SAP HANA view as a data source for the Azure Data Catalog, we receive an error. The error message in the logs reads:

"Microsoft.HANA","1.0","Microsoft.Data.Mashup.MashupValueException","Der Schlüssel entsprach keiner Zeile in der Tabelle."

I believe this is related to error-when-trying-to-register-a-hana-database-the-key-didnt-match-any-rows-in-the-table. Thus, it would read the following in English:

"Failed to GetColumnsMetadata. Error Message: The key didn't match any rows in the table.. "

The full error log entry with stack trace is this:

{"PreciseTimeStamp":"2020-10-09T09:16:03.2711448Z","EventName":"QueryStatement","EventId":13,"ActivityId":"00000000-0000-0000-0000-000000000000","RelatedActivityId":"00000000-0000-0000-0000-000000000000","Payload":["Query1","00000000-0000-0000-0000-000000000000","","","ExecuteCommand","m:\\IMSEAgentAD-016\\_work\\207\\s\\Product\\Source\\OnPremPermitted\\MetadataDiscovery\\MetadataDiscoveryLib\\DataSourceProviderExtensibility\\Mashup\\MashupProvider.cs",142,"DataCenterUndefined","{\"CurrentSessionId\": \"70408531-9887-4da9-9190-3a4b054d20c1\", \"CurrentTenantId\": \"e1c28a0e-a7f2-4779-8bf3-1c4b0bc9183c\", \"CurrentDirectoryName\": \"TestCatalog\", \"CurrentDisplayableId\": \"xxx\", \"CurrentTaskId\": \"1168578d-2a1a-41c3-b38a-f925af126c6e\"}"],"PayloadNames":["Query","callCorrelationId","tenantName","directoryName","callerMemberName","callerFilePath","callerLineNumber","dataCenter","onPremContextStr"],"EventSource":{"Name":"Microsoft-DataDirectory-MetadataDiscovery-Informational","Guid":"cfd4959c-4e17-4580-93c5-49c799a6b78c","Settings":4,"ConstructionException":null},"Keywords":263882790666240,"Opcode":0,"Task":65521,"Tags":0,"Message":"QueryStatement","Channel":0,"Version":3,"Level":4,"SessionId":"70408531-9887-4da9-9190-3a4b054d20c1"}


{"PreciseTimeStamp":"2020-10-09T09:16:04.1332370Z","EventName":"ExtractionOperation","EventId":1,"ActivityId":"00000000-0000-0000-0000-000000000000","RelatedActivityId":"00000000-0000-0000-0000-000000000000","Payload":["MetadataDiscovery","1.0","Microsoft.HANA","1.0","Failed to GetColumnsMetadata. Error Message: Der Schlüssel entsprach keiner Zeile in der Tabelle.. StackTrace:    bei Microsoft.Data.Mashup.MashupResource.TranslateException(Exception exception)\r\n   bei Microsoft.Data.Mashup.MashupResource.StartEvaluationAndGetResultSource[T](Int32 timeout)\r\n   bei Microsoft.Data.Mashup.MashupCommand.EvaluateAndGetSource[T](String commandText, CommandType commandType, Int32 commandTimeout, MashupParameterCollection parameters, String resultTransform, Boolean forColumnInfo, Boolean executeAction)\r\n   bei Microsoft.Data.Mashup.MashupCommand.ExecuteReader(CommandBehavior commandBehavior, MashupCommandBehavior mashupCommandBehavior)\r\n   bei Microsoft.Data.Mashup.MashupCommand.ExecuteReader()\r\n   bei Microsoft.DataDirectory.MetadataDiscovery.DataSourceProviderExtensibility.Mashup.MashupProvider.ExecuteCommand(Dictionary`2 parameters, MashupConnectionStringBuilder builder)\r\n   bei Microsoft.DataDirectory.MetadataDiscovery.DataSourceProviderExtensibility.Mashup.MashupProvider.QueryTable(String mashupString, DataSourceSetting setting, Dictionary`2 parameters)\r\n   bei Microsoft.DataDirectory.MetadataDiscovery.DataSourceProviderExtensibility.Mashup.MashupMetadataExtractor.GetColumnsMetadata(MashupQuery assetData, DataSourceSetting metadataDataSourceSetting, IEnumerable`1& schemaDescriptions)","00000000-0000-0000-0000-000000000000","","","GetColumnsMetadata","m:\\IMSEAgentAD-016\\_work\\207\\s\\Product\\Source\\OnPremPermitted\\MetadataDiscovery\\MetadataDiscoveryLib\\DataSourceProviderExtensibility\\Mashup\\MashupMetadataExtractor.cs",257,"DataCenterUndefined","{\"CurrentSessionId\": \"70408531-9887-4da9-9190-3a4b054d20c1\", \"CurrentTenantId\": \"e1c28a0e-a7f2-4779-8bf3-1c4b0bc9183c\", \"CurrentDirectoryName\": \"TestCatalog\", \"CurrentDisplayableId\": \"xxx\", \"CurrentTaskId\": \"1168578d-2a1a-41c3-b38a-f925af126c6e\"}"],"PayloadNames":["ApplicationName","LibraryVersion","ProviderId","ProviderVersion","Message","callCorrelationId","tenantName","directoryName","callerMemberName","callerFilePath","callerLineNumber","dataCenter","onPremContextStr"],"EventSource":{"Name":"Microsoft-DataDirectory-MetadataDiscovery-Warning","Guid":"25679109-9fe8-4cb5-9cea-af075e0ad982","Settings":4,"ConstructionException":null},"Keywords":263882790666240,"Opcode":0,"Task":65533,"Tags":0,"Message":"ExtractionOperation","Channel":0,"Version":3,"Level":3,"SessionId":"70408531-9887-4da9-9190-3a4b054d20c1"}


{"PreciseTimeStamp":"2020-10-09T09:16:04.1912457Z","EventName":"FailedExtraction","EventId":1,"ActivityId":"00000000-0000-0000-0000-000000000000","RelatedActivityId":"00000000-0000-0000-0000-000000000000","Payload":["Microsoft.HANA","1.0","Microsoft.Data.Mashup.MashupValueException","Der Schlüssel entsprach keiner Zeile in der Tabelle.","   bei Microsoft.Data.Mashup.MashupResource.TranslateException(Exception exception)\r\n   bei Microsoft.Data.Mashup.MashupResource.StartEvaluationAndGetResultSource[T](Int32 timeout)\r\n   bei Microsoft.Data.Mashup.MashupCommand.EvaluateAndGetSource[T](String commandText, CommandType commandType, Int32 commandTimeout, MashupParameterCollection parameters, String resultTransform, Boolean forColumnInfo, Boolean executeAction)\r\n   bei Microsoft.Data.Mashup.MashupCommand.ExecuteReader(CommandBehavior commandBehavior, MashupCommandBehavior mashupCommandBehavior)\r\n   bei Microsoft.Data.Mashup.MashupCommand.ExecuteReader()\r\n   bei Microsoft.DataDirectory.MetadataDiscovery.DataSourceProviderExtensibility.Mashup.MashupProvider.ExecuteCommand(Dictionary`2 parameters, MashupConnectionStringBuilder builder)\r\n   bei Microsoft.DataDirectory.MetadataDiscovery.DataSourceProviderExtensibility.Mashup.MashupProvider.QueryTable(String mashupString, DataSourceSetting setting, Dictionary`2 parameters)\r\n   bei Microsoft.DataDirectory.MetadataDiscovery.DataSourceProviderExtensibility.Mashup.MashupMetadataExtractor.GetColumnsMetadata(MashupQuery assetData, DataSourceSetting metadataDataSourceSetting, IEnumerable`1& schemaDescriptions)\r\n   bei Microsoft.DataDirectory.MetadataDiscovery.DataSourceProviderExtensibility.Mashup.AssetMetadataBuilder.Build()\r\n   bei Microsoft.DataDirectory.MetadataDiscovery.DataSourceProviderExtensibility.Providers.HANAProvider.ExtractSingleMetadata(HANAConnectionInfo connection, Boolean uploadSampleData, Boolean uploadProfileData, Boolean uploadDataClassification, CancellationToken cancellationToken)\r\n   bei Microsoft.DataDirectory.MetadataDiscovery.DataSourceProviderExtensibility.Providers.DataSourceProviderBase`1.<>c__DisplayClass8.<ExtractMetadata>b__2(T connection)\r\n   bei System.Linq.Enumerable.WhereSelectListIterator`2.MoveNext()\r\n   bei System.Linq.Enumerable.WhereEnumerableIterator`1.MoveNext()\r\n   bei System.Collections.Generic.List`1.InsertRange(Int32 index, IEnumerable`1 collection)\r\n   bei Microsoft.DataDirectory.MetadataDiscovery.DataSourceProviderExtensibility.Providers.DataSourceProviderBase`1.ExtractMetadata(IEnumerable`1 dataSourceConnectionInfos, Boolean uploadSampleData, Boolean uploadProfileData, Boolean uploadDataClassification, CancellationToken cancellationToken)","00000000-0000-0000-0000-000000000000","","","ExtractMetadata","m:\\IMSEAgentAD-016\\_work\\207\\s\\Product\\Source\\OnPremPermitted\\MetadataDiscovery\\MetadataDiscoveryLib\\DataSourceProviderExtensibility\\Providers\\DataSourceProviderBase.cs",94,"DataCenterUndefined","{\"CurrentSessionId\": \"70408531-9887-4da9-9190-3a4b054d20c1\", \"CurrentTenantId\": \"e1c28a0e-a7f2-4779-8bf3-1c4b0bc9183c\", \"CurrentDirectoryName\": \"TestCatalog\", \"CurrentDisplayableId\": \"xxx\", \"CurrentTaskId\": \"1168578d-2a1a-41c3-b38a-f925af126c6e\"}"],"PayloadNames":["ProviderId","ProviderVersion","Type","Message","StackTrace","callCorrelationId","tenantName","directoryName","callerMemberName","callerFilePath","callerLineNumber","dataCenter","onPremContextStr"],"EventSource":{"Name":"Microsoft-DataDirectory-MetadataDiscovery-Error","Guid":"663c0f50-6210-49c9-b781-f13a83c8f3b5","Settings":4,"ConstructionException":null},"Keywords":263882790666240,"Opcode":0,"Task":65533,"Tags":0,"Message":"FailedExtraction","Channel":0,"Version":3,"Level":2,"SessionId":"70408531-9887-4da9-9190-3a4b054d20c1"}
Azure Data Catalog
Azure Data Catalog
An Azure service that serves as a system of registration and system of discovery for enterprise data assets.
102 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Zeising.Arne 1 Reputation point
    2021-02-22T16:59:30.987+00:00

    Hi @PRADEEPCHEEKATLA-MSFT , is there an update from the product team on this?

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.