Why am I getting a 500 error or schema error when trying to access salesforce from FME? It seems like a permissions error of some sort, but it's like the reader accepts my credentials and tokens, then cannot find the tables in salesforce.

Hi @chrisatsafe​ 

Thank you for the detailed response. Turns out the 500 error was from my account being locked out for too many access attempts. I managed to make that go away with a reset. You were correct on that account. I need to talk to my administrator because my ability to reset my access token has disappeared from my salesforce options. I am hoping it's the token. That would be an easy fix.

Changing to the default host, or the <instance>.my.salesforce.com. didn't work for me unfortunately. The more generic one that the reader defaults to doesn't accept my credentials in browser or with the reader. It returns a 504 error and the message of invalid username/password. The other returns a proxy error, but I can't visit the URL in browser so I think the URL does not exist at all. Our URL setup must be non-standard.

I never set up the salesforce web connection so that could be the culprit too. I need to find the client ID and secret. Does the reader need that connection setup to work?

I've had success with both to be honest. I've been able to connect using the default host to production salesforce instances but needed to provide the <instance>.my.salesforce.co host for staging/developer instances.

I'd start with the token before going down the client id/secret route.

Out of curiosity, are you able to authenticate using the SalesforceConnector transformer?

Thanks for the tip on the token.

I have tried with the transformer. When I try to authenticate via the web service authentication popup, I get an OAuth error with an 1800 error code when trying to set up remote access. The error message from salesforce isn't very descriptive so I will ask my administrator about that as well. Maybe that has been disabled as a security feature. Again thank you for the help. I'll update when I can get my salesforce account fixed.

Update on this. I was finally able to fix the token generation issue. Resetting my token and password did not help me when using the salesforce reader or salesforce connector. I also tried to create a connection to salesforce via the OAuth2 method in salesforce connections. This also didn't work and FME returns an 1800 error from salesforce. From the salesforce administrative log side it appears that I was successfully able to log in. So something is blocking me in the process. I'm not sure if it is a security control on the network, a security control in salesforce, or something I am doing wrong, but I can't access the tables. Any ideas?

I figured out the issue. My proxy settings in FME were set incorrectly. I had no proxy turned on. That was blocking my access to the salesforce endpoints.