Workbench UNKNOWN ERROR: read error on connection to ec2-34-194-152-137.compute-1.amazonaws.com:6379
Hi,
I was trying to run an SOQL query in Salesforce Workbench and I got below error.
Error: "UNKNOWN ERROR: read error on connection to ec2-34-194-152-137.compute-1.amazonaws.com:6379"
There is no immediate resolution to this error provided by Salesforce yet.
Solution:
You can use Salesforce Inspector chrome extension if you have install rights on your computer and using Chrome as your primary browser.
Please see below for a web solution similar to Workbench that can work in any browser.
1. Login to https://www.packmagix.com using your Salesforce credentials.
2. Click on Data Export menu item in the Home tab.
3. Select the Salesforce Object you want to query on. e.g. Account.
4. Select the fields you want in SOQL query and click on Add to Fields button.
5. The selected fields should appear in SOQL Fields box below. Optionally you can add or remove fields in this box manually.
6. If you have an WHERE clause in your query please enter the condition(s) in the WHERE Clause box
7. If you have any other clauses (e.g. GROUP BY field / ORDER BY field) then enter it in the Other Clauses box
8. Update the default LIMIT of 200 if you would like more records up to 10000 max.
9. Check the SOQL Query in the end box (Read Only) if is correct
10. Then click on Run SOQL Query button right above the SOQL Fields box.
11. It should display the result of SOQL Query in a separate table
12. Click on Download as CSV button in to download the results in a CSV file for documentation or analysis purposes.
Comments
Post a Comment