Alteryx - Sales force input Connection time out errors

[KarthikM]

Hi,

I am getting the following error when we try to retrieve the data from Sales force input tool,

File "main.py", line 168, in pi_push_all_records
File "C:\ProgramData\Alteryx\Tools\SalesforceInput_v4.0.0\engine\sf_queries.py", line 74, 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:\ProgramData\Alteryx\Tools\SalesforceInput_v4.0.0\engine\sf_queries.py", line 51, in retrieve_query_json
response = await retrieve_query_json_chunk_parse_json(self, session, endpoint, header)
File "C:\ProgramData\Alteryx\Tools\SalesforceInput_v4.0.0\engine\sf_queries.py", line 27, in retrieve_query_json_chunk_parse_json
async with session.get(endpoint, headers = header) as response:
File "C:\ProgramData\Alteryx\Tools\SalesforceInput_v4.0.0\Lib\site-packages\aiohttp\client.py", line 843, in __aenter__
self._resp = await self._coro
File "C:\ProgramData\Alteryx\Tools\SalesforceInput_v4.0.0\Lib\site-packages\aiohttp\client.py", line 387, in _request
await resp.start(conn)
File "C:\ProgramData\Alteryx\Tools\SalesforceInput_v4.0.0\Lib\site-packages\aiohttp\client_reqrep.py", line 761, in start
self._continue = None
File "C:\ProgramData\Alteryx\Tools\SalesforceInput_v4.0.0\Lib\site-packages\aiohttp\helpers.py", line 677, in __exit__
raise asyncio.TimeoutError from None
asyncio.exceptions.TimeoutError 

What i need to do to get it fixed?

[SudeepGrover]

Any update on this? Were you able to resolve this issue?

[PanPP]

Hi @SudeepGrover 

1) I would recommend trying out the new Salesforce connector tool listed in the following link.

https://community.alteryx.com/t5/Community-Gallery/Salesforce-Input-Tool/ta-p/877898

You can remove old SF tools installed from the following directories.

Admin Install / Server Install: C:\ProgramData\Alteryx\Tools

Non-admin install: C:\Users\username\AppData\Roaming\Alteryx\Tools

2) We also now support a Salesforce ODBC Driver.  https://help.alteryx.com/20223/designer/salesforce

You can download the ODBC driver from downloads.alteryx.com 

How to set up a Salesforce ODBC Driver: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-to-set-up-Salesforce-ODBC-conne... 

Hope this helps, if it does please like this post and if it helps resolve your problem, mark it as a solution. If you have any other questions, please let us know.