Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

ERROR: "Connection information is invalid Test Connection failed. Invalid connection properties. An error occurred while enumerating the result" when Microsoft Azure Blob Storage Resource Test Connection fails in EDC
Problem Description
In Enterprise Data Catalog (EDC), the Microsoft Azure Blob Storage Resource Test Connection fails with the following error:

Connection information is invalid
Test Connection failed. Invalid connection properties. An error occurred while enumerating the result. check the original exception for details

azureblobtestconnection.png 
 
  
The following error is seen in the LDM.log:

Caused by: shade.com.microsoft.azure.storage.StorageException: The account being accessed does not support http.
Cause
This issue occurs when ​the Blob Endpoint URL is provided with http.

azureblobgeneraltab.png 

Blob Endpoint URL from Azure Portal:


azureportal.png
Solution
​To resolve this issue, change the Blob Endpoint URL to https://XXX.blob.core.windows.net in the Catalog Admin Azure Blob Storage Resource Configuration and perform test connection.

correctazure.png 
More Information
 

The following error is seen in ​LDM.log:


ERROR [testConnection_1578376062872_Native\Administrator_:AzureBlobConnectionValidator@61] - java.util.NoSuchElementException: An error occurred while enumerating the result, check the original exception for details.

at shade.com.microsoft.azure.storage.core.LazySegmentedIterator.hasNext(LazySegmentedIterator.java:113)

at com.infa.products.ldm.scanners.azureblobscanner.utils.AzureBlobConnectionValidator.validateConnection(AzureBlobConnectionValidator.java:31)

at com.infa.products.ldm.scanners.azureblobscanner.AzureBlobScanner.testConnection(AzureBlobScanner.java:37)

at com.infa.products.ldm.framework.scanner.configmgmt.impl.BaseConfigurationManager.validateConnection(BaseConfigurationManager.java:95)

at sun.reflect.GeneratedMethodAccessor1717.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Method.java:498)

Caused by: shade.com.microsoft.azure.storage.StorageException: The account being accessed does not support http.

at shade.com.microsoft.azure.storage.StorageException.translateException(StorageException.java:89)

at shade.com.microsoft.azure.storage.core.StorageRequest.materializeException(StorageRequest.java:315)


If the Azure BLOB Endpoint URL is using https, then you need to make sure to follow the below steps:

 

1) Export the certificate from Azure BLOB Endpoint URL.

 

2) Import the above certificate into infa_truststore.jks of the Domain.

 

If Domain is TLS enabled, then you can find the location of infa_truststore.jks file in Admin console > Node > Properties > Advanced Properties > Truststore Directory.

If Domain is not TLS enabled, you can find it in Default Truststore Directory: <InfaHome>/services/shared/security.

 

To import the certificates, run the below command:

 

keytool -import -file <Azure Blob Certificate Name> -alias <Alias Name> -keystore infa_truststore.jks -storepass <Password of infa_truststore.jks>

 

3) Import the above certificate into cacerts of the Java.

 

keytool -import -trustcacerts -file <Azure Blob Certificate Name> -alias <Alias Name> -keystore $INFA_HOME/java/jre/lib/security/cacerts

 

4) Make sure that the test connection is successful.

 

If not, you will hit the below error message from LDM.log:

 

Caused by: shade.com.microsoft.azure.storage.StorageException:

            at shade.com.microsoft.azure.storage.StorageException.translateException(StorageException.java:87)

            at shade.com.microsoft.azure.storage.core.ExecutionEngine.executeWithRetry(ExecutionEngine.java:220)

            at shade.com.microsoft.azure.storage.core.LazySegmentedIterator.hasNext(LazySegmentedIterator.java:109)

            ... 148 more

Caused by: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target

            at sun.security.ssl.Alerts.getSSLException(Alerts.java:192)​

Applies To
Product: Enterprise Data Catalog
Problem Type: Connectivity; Configuration
User Type: Administrator; Architect; Business Analyst; Data Analyst; Data Scientist; Data Steward; Developer
Project Phase: Configure; Implement
Product Version:
Database:
Operating System:
Other Software:

Reference
Attachments
Last Modified Date:7/1/2020 2:24 AMID:613522
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)