DataSync FAQs and Frequent Errors

The HTTP/1.1 403 Forbidden error is most commonly caused by an issue with your credentials in Datasync. If you've received this error, we suggest verifying your credentials and app token and trying to run the job again.

Please note that when a user inputs incorrect credentials 3 times, they will be locked out of their account for 30 mins and subsequent login attempts are blocked.

If this is the case, we suggest waiting 1 hour before attempting any other updates. Then log in to your Data & Insights domain to confirm your username and password. Once you have verified your login, copy/paste your username and password into the Datasync job's credential area and make sure the app token is correct and specific to your Data & Insights account.

There are a number of factors that contribute to your ability to successfully run a DataSync job. Common issues we see include network/firewall issues and security issues related to outdated Java versions or TLS settings.

Network/Firewall Issues Troubleshooting

The first test to try to ensure there is no issue with your network settings or firewall is to run a simple command in your command window (Run -> cmd in Windows, using the Terminal application in Mac):

ping {{domain}}

For example, if the domain you have configured in DataSync is opendata.socrata.com, you'd run:

ping opendata.socrata.com

If you see a message like "request timeout", "connection timeout", or "could not resolve", that indicates that something at the network level is probably blocking the connection to your Data & Insights domain. You should reach out to your IT/networking folks to determine why we are being blocked.

Java Version and TLS Issues

Open a command window and run:

java -version

If you see anything other than a version starting with "1.8....", you will need to upgrade your Java per our list of supported secure integration clients.

Numeric and money data types need to be ingressed without a dollar sign ($). Excel may automatically add this formatting to columns configured asn "Currency." Changing the column type to "Number" in Excel should remove this formatting. If the formatting exists elsewhere in your automation workflow, it will need to be removed.

If the data that is uploaded has no differences from the dataset online, the update date will not change on the dataset. Datasync will only update your data if there are differences in your source file and the published dataset.

This can be resolved by updating the Java cert on the server. Instructions on how to do that are here: Datasync: Network Considerations
This source has more information about how to add SSL certs to the affected server's Java trust store: Oracle: Keytool Utility