Credentials manager for Azure Data Factory not working

Question

Good day!

I am working on moving files via Azure Data Factory from on-prem file store and/or ftp site to Azure Blob storage using Copy Data activity. When setting security access, I am using credential manager. However, when clicking 'Set credential' a string 'Preparing...' shows for a split moment, and then nothing happens and box is left blank. What is exactly credentials manager? Is is a separate application, which needs to be installed or Windows credentials manager available via Administrative tools? I used IE for this. In Chrome it tries to install ClickOnce app, which fails to install with this error log (googling it reveals nothing). Does anyone know the solution?

IDENTITIES
    Deployment Identity        : CredentialsManager.application, Version=1.1.6273.1, Culture=neutral, PublicKeyToken=c3bce3770c238a49, processorArchitecture=msil

APPLICATION SUMMARY
    * Online only application.
    * Trust url parameter is set.
ERROR SUMMARY
    Below is a summary of the errors, details of these errors are listed later in the log.
    * Activation of C:\Users\YToropov\Downloads\CredentialsManager.application resulted in exception. Following failure messages were detected:
        + Deployment and application do not have matching security zones.

COMPONENT STORE TRANSACTION FAILURE SUMMARY
    No transaction error was detected.

WARNINGS
    There were no warnings during this operation.

OPERATION PROGRESS STATUS
    * [4/5/2017 5:50:08 AM] : Activation of C:\Users\YToropov\Downloads\CredentialsManager.application has started.
    * [4/5/2017 5:50:08 AM] : Processing of deployment manifest has successfully completed.
    * [4/5/2017 5:50:08 AM] : Installation of the application has started.

ERROR DETAILS
    Following errors were detected during this operation.
    * [4/5/2017 5:50:08 AM] System.Deployment.Application.InvalidDeploymentException (Zone)
        - Deployment and application do not have matching security zones.
        - Source: System.Deployment
        - Stack trace:
            at System.Deployment.Application.DownloadManager.DownloadApplicationManifest(AssemblyManifest deploymentManifest, String targetDir, Uri deploymentUri, IDownloadNotification notification, DownloadOptions options, Uri& appSourceUri, String& appManifestPath)
            at System.Deployment.Application.ApplicationActivator.DownloadApplication(SubscriptionState subState, ActivationDescription actDesc, Int64 transactionId, TempDirectory& downloadTemp)
            at System.Deployment.Application.ApplicationActivator.InstallApplication(SubscriptionState& subState, ActivationDescription actDesc)
            at System.Deployment.Application.ApplicationActivator.PerformDeploymentActivation(Uri activationUri, Boolean isShortcut, String textualSubId, String deploymentProviderUrlFromExtension, BrowserSettings browserSettings, String& errorPageUrl)
            at System.Deployment.Application.ApplicationActivator.ActivateDeploymentWorker(Object state)

COMPONENT STORE TRANSACTION DETAILS
No transaction information is available. 

Answer 1

You may need to clean this folder and try again by using IE11. C:\Users{account}\AppData\Local\Apps\2.0

if it still not work, you may need to reset the internet options.

Answer 2

Instead of trying to use the credentials manager, can I suggest you create your data factory in Visual Studio. Then simply deploy it to Azure with different sets of configuration files.

Check out this blog post on how.

https://www.purplefrogsystems.com/paul/2017/01/using-azure-data-factory-configuration-files/

This way credentials do not need to be copied into any portal blades and can be handled using other tools. Plus source controlled.

The JSON strings will also be masked if viewed via the Author and Deploy blade.

Plus any changes can be dealt with locally and your on prem linked service in ADF just redeployed.

Hope this helps.

Answer 3

The credential manager is a .NET ClickOnce application running on your OnPrem machine. When using the credential manager to set the username/password, it directly talks to the Gateway so there is no username/password data transfer over the wire. If you use "by web browser" option, the encrypted username/password will be transferred over the wire with a post request and then gets pushed to Gateway. In both options credentials are encrypted, but the Credential Manages saves the roundtrip through public network.

The reason why you get this error is because Chrome by default does not support the .NET ClickOnce application. It should work if you are using IE or Edge.

For this to work on Chrome, you can add an extention to enable ClickOnce application support in Chrome, like the below one

https://chrome.google.com/webstore/detail/meta4-clickonce-launcher/jkncabbipkgbconhaajbapbhokpbgkdc?hl=en

Answer 4

Solution: Clear the oneClick cache and try to install the application again. Here is the way to clear oneClick cache

From command line run: rundll32 dfshim CleanOnlineAppCache

If it doesn’t work, delete the real folder:

Windows Vista/7/8/10

C:\users[username]\AppData\Local\Apps\2.0\

Windows XP/2003

C:\Documents and Settings\username\LocalSettings\Apps\2.0\

for more information, you can look at this. it may be helpful. http://codeketchup.blogspot.sg/2013/06/how-to-fix-deployment-and-application.html

====================================================== security zone