topic Re: Anyone having salesforce connections issues today? in QlikView

Anyone having salesforce connections issues today?

Thu, 30 Jan 2014 15:52:17 GMT

All my salesforce QVW's are not working today.

Connecting works and it even creates the CONNECT command line but when you click on the SELECT button to see the objects/tables, no objects are displayed.

It was working last night and we have not changed any scripts.

we are getting "Error: Premature end of file."

(and more strangely, we got another email 2 hours after about another QVW failure that does not exists. anyway this is probably another issue)

update 9:24 AM PST. Got email from QV Support

Dear Janet,

We are currently investigation this, but it seems that the error is on SalesForce's side. A number of customers have called/emailed in with the same issue, and there are discussions on QlikCommunity about it going on currently. We are asking our customers to contact SalesForce support for now. I do know that some customers have been able to get their reloads to work on a sporadic basis, which is better than not at all. They've done nothing special to get this to work, they just kept trying. We will update you as soon as we know more.

as of 7:17 PM PST... its working again now. cross fingers that it keeps working.

Re: Anyone having salesforce connections issues today?

Thu, 30 Jan 2014 16:05:34 GMT

We are having the same issue on our QV Server - Same error message on multiple files that pull from SFDC.

When I pull a file down locally and run the load script it reloads fine.

Re: Anyone having salesforce connections issues today?

Thu, 30 Jan 2014 16:07:18 GMT

Janet,

We're having the exact same issue. Yesterday, our reloads were performing just fine, today is a different story. We'll let you know if we find a solution. At first, we went in and connected w/ our username, password+token, and it seemed to work on one document, but not all of them.

Thanks,

Luke

Re: Anyone having salesforce connections issues today?

Thu, 30 Jan 2014 16:18:36 GMT

ours wont run manually as well, from the server or personal machines. So we have to wait for Customer Support. I created a Bus Critical ticket and still waiting for a reply. Will update here when we get a solution

Re: Anyone having salesforce connections issues today?

Thu, 30 Jan 2014 16:18:49 GMT

All,

I'm having the same problem. Yesterday everything worked correctly, but today not at all. My Sales force admin tested the credentials for the API using a Sales Force app and it works fine. but, whenever I try to use the Sales Force Connector it fails.

Robert

Re: Anyone having salesforce connections issues today?

Thu, 30 Jan 2014 16:26:54 GMT

Just out of curiosity, which instances of SFDC are you all on? We're on NA13 (current status is Good).

Re: Anyone having salesforce connections issues today?

Thu, 30 Jan 2014 16:29:23 GMT

NA3 here

Re: Anyone having salesforce connections issues today?

Thu, 30 Jan 2014 16:34:43 GMT

Hi Janet,

I called support who asked me to send a couple of document logs. We too have a case open at this point. I let the support rep know that there were a bunch of customers experiencing this issue (all of whom are using SFDC). Hopefully it will help them isolate the issue.

We'll keep you posted.

Thanks,

Luke

Re: Anyone having salesforce connections issues today?

Thu, 30 Jan 2014 16:40:38 GMT

We have opened a case w/ SFDC support per Qlikview's instructions.

Dear Luke,

I would recommend you call Salesforce directly. It's something going on their end, it not QlikView. We haven't changed anything on our end and since it's Salesforce ETL it's definitely something going on their end.

Go to Case in Customer Portal

Kind regards,

Lucas Gatling

QlikView Support

Re: Anyone having salesforce connections issues today?

Thu, 30 Jan 2014 18:37:27 GMT

NA14 here.

Re: Anyone having salesforce connections issues today?

Thu, 30 Jan 2014 19:11:19 GMT

QV Support said that we should contact salesforce support instead. What a bummer. Our salesforce support has 24 hour turn around and not very good so i hope someone out there finds a solution for this

Re: Anyone having salesforce connections issues today?

Thu, 30 Jan 2014 20:25:11 GMT

Us too. Should have checked with everyone here before changing the security token. So that probably means everyone who uses the salesforce.dll are getting the same message. We're on EU1.

Re: Anyone having salesforce connections issues today?

Thu, 30 Jan 2014 21:21:00 GMT

This is a bummer. I cannot use QlikView at all today. I cannot find an update and Salesforce support has not made a response to my ticket. Anyone heard anything else? The trust site for salesforce is not reporting anything at all.

Re: Anyone having salesforce connections issues today?

Thu, 30 Jan 2014 21:21:37 GMT

Did changing your token help?

Re: Anyone having salesforce connections issues today?

Thu, 30 Jan 2014 21:26:44 GMT

Here is my current conclusion:

My server has 64bit salesforce.dll connector and it is FAILING each time.

My local machine has 32bit salesforce.dll connector and it IS WORKING FINE.

Has anyone else had these same results? or am I an outlier

Re: Anyone having salesforce connections issues today?

Thu, 30 Jan 2014 21:30:36 GMT

Hi Thomas,

We have the 64 bit server and 64 bit local machines. We've been able to reload sporadically on the server if we disable the scheduler and manually trigger the reload. It's really hit or miss. We can intermittently reload locally (manually) as well.

Re: Anyone having salesforce connections issues today?

Thu, 30 Jan 2014 21:35:13 GMT

I am 64 bit and it fails. Have not tried 32 bit, but I am tempted to install because I have high priority projects.

Re: Anyone having salesforce connections issues today?

Thu, 30 Jan 2014 21:36:15 GMT

I am able to get a test connection to work about once in every 20 attempts.

Re: Anyone having salesforce connections issues today?

Fri, 31 Jan 2014 07:04:42 GMT

I'm also 64bit and it fails. If anyone get the solution, please let me know!

Thanks in advance.

Hnin

Re: Anyone having salesforce connections issues today?

Greg_Hood — Fri, 31 Jan 2014 08:33:56 GMT

Hi all, is this issue still occurring? We suspect the problem is SFDC side, but are keen to know if anyone is still having the problem.