This error occurs randomly and will disappear at times when I rerun the workflow. Running with Alteryx 2021.2.1.35394 and Salesforce Input Tool 4.1.0.
From what I gather it is a traceback error.
00:00:00.359 - Alteryx: This is AMP Engine; running 8 worker threads; memory limit 3995.0 MB.
00:00:00.362 - Alteryx: The following tool ids are using an e1 compatibility layer with 8 conversion point(s): 33, 16, 38, 18, 43, 25, 48, 28
00:00:04.460 - Error - ToolId 16: Traceback (most recent call last):
File "C:\Users\user\AppData\Roaming\Alteryx\Engine/../Tools\SalesforceInput_v4.1.0\Lib\site-packages\aiohttp\connector.py", line 840, in _create_direct_connection
hosts = await asyncio.shield(self._resolve_host(
File "C:\Users\user\AppData\Roaming\Alteryx\Engine/../Tools\SalesforceInput_v4.1.0\Lib\site-packages\aiohttp\connector.py", line 729, in _resolve_host
addrs = await \
File "C:\Users\user\AppData\Roaming\Alteryx\Engine/../Tools\SalesforceInput_v4.1.0\Lib\site-packages\aiohttp\resolver.py", line 29, in resolve
infos = await self._loop.getaddrinfo(
File "C:\Program Files\Alteryx\bin\Miniconda3\lib\asyncio\base_events.py", line 825, in getaddrinfo
return await self.run_in_executor(
File "C:\Program Files\Alteryx\bin\Miniconda3\lib\concurrent\futures\thread.py", line 57, in run
result = self.fn(*self.args, **self.kwargs)
File "C:\Program Files\Alteryx\bin\Miniconda3\lib\socket.py", line 918, in getaddrinfo
for res in _socket.getaddrinfo(host, port, family, type, proto, flags):
socket.gaierror: [Errno 11001] getaddrinfo failed
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "main.py", line 163, in pi_push_all_records
File "C:\Users\user\AppData\Roaming\Alteryx\Engine/../Tools\SalesforceInput_v4.1.0\engine\sf_queries.py", line 76, in process_query
loop.run_until_complete(retrieve_query_json(self, query_endpoint, header))
File "C:\Program Files\Alteryx\bin\Miniconda3\lib\asyncio\base_events.py", line 616, in run_until_complete
return future.result()
File "C:\Users\user\AppData\Roaming\Alteryx\Engine/../Tools\SalesforceInput_v4.1.0\engine\sf_queries.py", line 59, in retrieve_query_json
response = await retrieve_query_json_chunk_parse_response(self, session, endpoint, header)
File "C:\Users\user\AppData\Roaming\Alteryx\Engine/../Tools\SalesforceInput_v4.1.0\engine\sf_queries.py", line 14, in retrieve_query_json_chunk_parse_response
async with session.get(endpoint, headers = header) as response:
File "C:\Users\user\AppData\Roaming\Alteryx\Engine/../Tools\SalesforceInput_v4.1.0\Lib\site-packages\aiohttp\client.py", line 843, in __aenter__
self._resp = await self._coro
File "C:\Users\user\AppData\Roaming\Alteryx\Engine/../Tools\SalesforceInput_v4.1.0\Lib\site-packages\aiohttp\client.py", line 363, in _request
conn = await self._connector.connect(
File "C:\Users\user\AppData\Roaming\Alteryx\Engine/../Tools\SalesforceInput_v4.1.0\Lib\site-packages\aiohttp\connector.py", line 445, in connect
proto = await self._create_connection(req, traces, timeout)
File "C:\Users\user\AppData\Roaming\Alteryx\Engine/../Tools\SalesforceInput_v4.1.0\Lib\site-packages\aiohttp\connector.py", line 756, in _create_connection
_, proto = await self._create_direct_connection(
File "C:\Users\user\AppData\Roaming\Alteryx\Engine/../Tools\SalesforceInput_v4.1.0\Lib\site-packages\aiohttp\connector.py", line 847, in _create_direct_connection
raise ClientConnectorError(req.connection_key, exc) from exc
aiohttp.client_exceptions.ClientConnectorError: Cannot connect to host westshorehome.my.salesforce.com:443 ssl:None [getaddrinfo failed]
Here are some low-hanging fruit questions.
1) Does the error occur on different devices or all on the same device?
2) Are you doing some sort of VPN connection? Does the error occur when you are off the network? On the network?
3) Do you have an unstable internet connection?
I did a quick Google search on this error, because it doesn't read as an Alteryx specific error to me and I found this thread:
https://stackoverflow.com/questions/7334199/getaddrinfo-failed-what-does-that-mean
Which talks about being unable to resolve the host name?
1) Does the error occur on different devices or all on the same device?
The errors have been on the same device.
2) Are you doing some sort of VPN connection? Does the error occur when you are off the network? On the network?
I'm not on a VPN connection and because I download the records, I've only tested this while on network.
3) Do you have an unstable internet connection?
My internet connect is stable and I haven't encountered any drops.
I saw something in your reply about configuring a proxy variable in Python. Do you think this would help?
User | Count |
---|---|
18 | |
14 | |
13 | |
9 | |
8 |