Salesforce Input Tool Traceback Error

Question

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esolver.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	hread.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]

Screenshot 2021-08-05 090023.png

AdrianWSH · Answer

@Treyson

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?

Treyson · Answer

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?