Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Salesforce Input Tool Traceback Error

AdrianWSH
7 - Meteor

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]

 

 

 

 

2 REPLIES 2
Treyson
13 - Pulsar
13 - Pulsar

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?

Treyson Marks
Senior Analytics Engineer
AdrianWSH
7 - Meteor

@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?

Labels