Azure Data Catalog
An Azure service that serves as a system of registration and system of discovery for enterprise data assets.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(25.6, 65%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZA%3C/text%3E%3C/svg%3E)
Hi @PRADEEPCHEEKATLA , is there an update from the product team on this?
Azure Data Catalog RegTool: Error when registering a HANA view
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 25%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Arne
1
Reputation point
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
-
PRADEEPCHEEKATLA 91,866 Reputation points2020-10-09T11:31:10.067+00:00 Hello @Arne ,
Welcome to Microsoft Q&A platform.
I’m working with the product team and get back to you when I have more information.
-
PRADEEPCHEEKATLA 91,866 Reputation points
2020-10-12T12:33:54.56+00:00 Hello @Arne ,
We are still waiting for the response from the product team. I will let you know once I heard back from product team.
Stay Tuned!
-
Arne 1 Reputation point
2020-11-25T17:25:33.477+00:00 Hi @PRADEEPCHEEKATLA , is there an update on this?
-
PRADEEPCHEEKATLA 91,866 Reputation points
2020-11-30T07:40:41.033+00:00 Hello @Arne ,
Apologize for the delay in response.
This is a known issue with Azure Data Catalog.
Azure Data Catalog engineering team is actively working on the resolution, but at this time they do not have an ETA as to when the resolution will be rolled out.
Sign in to comment