topic Re: Qlik Web Connector Error Could not save connector table parameters. (status code = 500, Unauthorized Access (See log file for details)., connector in Connectivity & Data Prep

Qlik Web Connector Error Could not save connector table parameters. (status code = 500, Unauthorized Access (See log file for details)., connectorId=A

nikita150 — Fri, 22 Apr 2022 09:28:54 GMT

I am getting error while creating connection for Amazon S3 DB, Before 4 Connection is created and working fine now but while creating new connection that time i am getting error. By using service account i am doing this activity.

Thanks for Suggestion/Reply.

Re: Qlik Web Connector Error Could not save connector table parameters. (status code = 500, Unauthorized Access (See log file for details)., connector

Francisco_Fernandez — Sun, 24 Apr 2022 20:26:47 GMT

Hi @nikita150 ,

What's the error message that you are seeing on the logs?

If the access key and secret key are correct I would suggest to check if the antivirus is blocking the connector.

Re: Qlik Web Connector Error Could not save connector table parameters. (status code = 500, Unauthorized Access (See log file for details)., connector

nikita150 — Mon, 25 Apr 2022 04:47:03 GMT

Hi @Francisco_Fernandez ,

Thanks for your reply,

Access key and secret key i am entering right but getting error in log like,

<Message>Could not save connector table parameters.</Message>
<Exception>System.UnauthorizedAccessException: Access to the path 'c:\QlikWebConnectors\App_Data\DEFAULT0-0000-0000-0000-000000000000\ConnectorSettings.xml' is denied.
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)
at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share)
at APIConnectorEngine.Qwc.XmlFileSettingsStorerGeneric.SaveSettings(ConfigSettings settings)
at APIConnectorEngine.Qwc.XmlFileSettingsStorerWithMutex.RunLocked(Action action)
at APIConnectorWeb.Nancy.Modules.WebAPIAuth.<>c__DisplayClass3_0.<.ctor>b__18(Object x)</Exception>
<ExceptionMessage>Access to the path 'c:\QlikWebConnectors\App_Data\DEFAULT0-0000-0000-0000-000000000000\ConnectorSettings.xml' is denied.</ExceptionMessage>
<AdditionalInfo>
<UserIP>::1</UserIP>
<User>Admin (Default)</User>
</AdditionalInfo>

Thanks

Re: Qlik Web Connector Error Could not save connector table parameters. (status code = 500, Unauthorized Access (See log file for details)., connector

Francisco_Fernandez — Mon, 25 Apr 2022 06:38:01 GMT

Hi@nikita150 ,

Based on the logs, seems like the system is blocking access to this path "c:\QlikWebConnectors\App_Data\DEFAULT0-0000-0000-0000-000000000000\ConnectorSettings.xml" were connections are stored.

I would check the following:

Check if the service is running under the service account
Allow the folder in your antivirus and verify that is not blocking it
Make sure that the folder has de correct permissions.

Hopefully this will solve the problem.

Best regards,

Francisco