Qlik Community

QlikView Connectors

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

SalesForce connector account gets locked

Hi all,

We are using the Qlikview SalesForce Connector 11.0 (SalesForceDLL.dll v. 11.0.10017.0) and our problem is that it seems to lock our the account we use to log in.

When executed manually it works fine most of the time. Sometimes if we have been doing development during the day it has been locked, but that could simply be because of duplicate logins or excessive logins. The real problem is our scheduled execution in the morning hours that *almost* all of the time ends up with the following error:

25.2.2014 6:05:12: 0099    CUSTOM CONNECT*Provider*SalesForceDLL.dll*XUserId*XPassword*

25.2.2014 6:05:14:         Error: Invalid username, password, security token; or user locked out.

I say "almost always" as every now and then it works OK. So far we have checked the following:

- The account used to execute the scheduled load is the same that we use to log on to the server manually, so we believe that rights on our server should not be the problem.

- After unlocking the account the task will run without problems and we never need to touch the connection string.

- We do not have restrictions in SalesForce for login time and we have also added the servers public IP to the range of trusted addresses.

- The problem started with an older version of the connector running in 32-bit mode, but upgrading to 64-bit version 11 didn't help.

- We raised a support request with SalesForce, but they simply washerd their hands and told us to contact Qliktech that provides the connector. I still suspect that they could investigate their logs better, but at the moment I don't have enough information on the error to attack them. The log doesn't really help me in telling why this is happening.

I have tried searching the community for similar problems, but so far I have drawn a blank. I am wondering if anyone has seen the same behaviour?

Kind regards,

Mats


1 Solution

Accepted Solutions
Not applicable

Re: SalesForce connector account gets locked

It seems that the problem was resolved by changing the login account. Salesforce was not able to help us and identify the issue, but with a different login everything seems to be running OK.

1 Reply
Not applicable

Re: SalesForce connector account gets locked

It seems that the problem was resolved by changing the login account. Salesforce was not able to help us and identify the issue, but with a different login everything seems to be running OK.

Community Browser