Qlik Data Gateway erroring out with "Invalid metadata response (DirectAccess-2201) " message. The error could be due to a different issues.
Resolution
Verify Privileges on the space where the Gateway was created and the Space where user is attempting to create the connection, our documentation describes the details here
If privileges are correct, try to restart Qlik Data Gateway services on the Server where it resides.
Verify if the issue is specific to a connection, if one user was able to successfully create a connection, attempt to create a new connection with the user that is getting the error.
If nobody is able to create a connection for an specific Data Source, attempt to configure a DSN ODBC connection from the Data Gateway Server to verify it succeeds.
Cause
The cause of the issue is usually configuration, if the suggestions above didn't fix the issue it will be necessary to report the issue for further analysis.
Hi everyone, is there any solution for this issue? I'm experiencing the same as above ("Invalid metadata response (DirectAccess-2201)"), followed all the steps and even checked that my remote desktop can reach the server. I told the customer also to check if 443 port is open.
checking on this , many other customers try below and it resolve their issue :
The issue was identified after Run StartOdbcConnector.bat from a command line in '‘C:\Program Files\Qlik\ConnectorAgent\runOdbcConnector’'. The issue was because of the .net version in the Data Gateway server. after upgrading .net from 6.0.21 to 6.0.29 then the issue is fixed. ---- Provided customer best practices Help entry and article https://community.qlik.com/t5/Official-Support-Articles/Data-Gateway-failing-with-Invalid-metadata-r.... Customer installed Data Gateway Direct Access on a dedicated server and the issue was resolved. ---- https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Gateways/direct-access-g... ---- Make sure you have checked the article and ticked all of the boxes. https://community.qlik.com/t5/Official-Support-Articles/Data-Gateway-failing-with-Invalid-metadata-r... If step 1 doesn't help, try to perform below steps. - Remote access to the Data Gateway server. - Open the folder path ‘C:\Program Files\Qlik\ConnectorAgent\runOdbcConnector’. Find the right path if you installed Data Gateway on another drive/folder - Run StartOdbcConnector.bat from a command line and share the output. From the output you will understand the root cause more clearly. Most of the issues was caused by the Microsoft .net version. For example, upgrade .net from 6.0.21 to 6.0.29 fixes the issue. ----
Qlik Data Gateway deployment are attached to a Space, and you need to have at least the Can view + Can Edit role in the space which is attached to this Data Gateway Deployment. If not you can't create a connector with this Data Gateway deployment.
thanks for your support. I executed the .bat file.
I think the important stuff is here: fail: Microsoft.Extensions.Hosting.Internal.Host[11] Hosting failed to start System.IO.IOException: Failed to bind to address http://127.0.0.1:50060: address already in use. ---> Microsoft.AspNetCore.Connections.AddressInUseException: Only one usage of each socket address (protocol/network address/port) is normally permitted. ---> System.Net.Sockets.SocketException (10048): Only one usage of each socket address (protocol/network address/port) is normally permitted.
What does it mean? There's already a service or a Odbc connection using that port?
'address alreadyin use' and 'Only one usage of each socket address (protocol/network address/port) is normally permitted' indicate that this port is already in use by a different process. You will need to investigate which one it is and troubleshoot accordingly.
For any further assistance, I recommend posting your requirement in the Connectivity and Data Prep forum, where our active product experts and your knowledgeable Qlik peers can better assist you.
