topic Re: loading Salesforce data. in QlikView

loading Salesforce data.

israrkhan — Mon, 01 Sep 2014 08:14:17 GMT

Hello Community,

in one of my application, i am loading data from saleforce using salesforce conncetors,

its working fine ,when i load in my qlikview desktop, ad its also working fine when i manually load on server,

but did does not load data(mean its load 0 record), when i scheduler it in server...

it does show any error, but when i schedule it, and it run successfully, but no record in the QVD,

i am using qlikview 11.20 SR6, 64 bit..

any suggestions...??? what to check...or anybody has,had the same issue..???

Re: loading Salesforce data.

DavidFoster1 — Mon, 01 Sep 2014 08:21:24 GMT

The trick with the salesforce connector is the user details. Are you using domain users or separate email addresses?

If you are using domain users then you need to have an account for the system user as well as yourself.

Re: Re: loading Salesforce data.

israrkhan — Mon, 01 Sep 2014 08:39:34 GMT

Dear David,

Thanks for Reply,

i did not get you point "If you are using domain users then you need to have an account for the system user as well as yourself."

please see the additional details,

The account set up for the Publisher/Distribution service is a "domain" account.

While logging to the publisher server with "local" account, the manual reload process from salesforce is working fine

when i change The credentials for the Publisher/Distribution service account to my account(local account) and the reload using publisher found to be "working".

your help would be highly appreciated...

Re: Re: loading Salesforce data.

DavidFoster1 — Mon, 01 Sep 2014 08:44:34 GMT

Looks like you need to talk to your SalesForce administrator about getting a user account for the QlikView service account.

I tend to request a generic email address is setup as a user (qlikview@yourcompany.com) which is auto-forwarded to your QlikView administrator/s. This email address can then be used for developers and the system account (assuming you only have one Salesforce instance).

I hope that helps.

Re: loading Salesforce data.

israrkhan — Mon, 01 Sep 2014 08:57:42 GMT

Dear Davis,

sorry Totally lost...

but this had been working successfully for the last few months..

couple of days back, we noticed the issue...

Re: loading Salesforce data.

DavidFoster1 — Mon, 01 Sep 2014 09:02:31 GMT

OK I didn't appreciate that this has been working.

I suggest that you talk to your Salesforce administrator about any changes to the permissions of the system accounts security/connections.

Re: loading Salesforce data.

rajeshvaswani77 — Mon, 01 Sep 2014 11:51:18 GMT

Hi,

Have it checked that salesforce.com is not blocked by the firewall.

thanks,

Rajesh Vaswani

Re: loading Salesforce data.

israrkhan — Mon, 01 Sep 2014 12:24:12 GMT

Dear Rajesh,

i turned off the firewall, and tried to reload by scheduler in publisher, but no luck...

it only works, when i use local account, with the domain account it does not load even one row...

but execution of script goes successful...

dont know where to looks, have tried almost all options...

Many thanks

Khan

Re: loading Salesforce data.

rajeshvaswani77 — Mon, 01 Sep 2014 12:25:27 GMT

ok, on server go to browser and type salesforce.com

if you have firewall issues you will know. Else its ruled out.

thanks,

Rajesh Vaswani

Re: loading Salesforce data.

rajeshvaswani77 — Mon, 01 Sep 2014 12:26:52 GMT

Yes, to add, when you do this. Check once by logging in to the machine with the domain account and trying the URL, next with the local account same way.

thanks,

Rajesh Vaswani

Re: loading Salesforce data.

israrkhan — Mon, 01 Sep 2014 12:30:37 GMT

you mean on the server, i should just go to salesforce.com site in the browser..

by logging in to the machine by domain account..?

am i right???

Re: loading Salesforce data.

rajeshvaswani77 — Mon, 01 Sep 2014 12:31:14 GMT

yes

Re: loading Salesforce data.

israrkhan — Mon, 01 Sep 2014 12:41:15 GMT

it make sense , let me try

will let you know...

many thanks for you comments....

Re: loading Salesforce data.

israrkhan — Tue, 02 Sep 2014 07:34:00 GMT

Dear Rajesh,

we can browse the saleforce.come with both account..no issue in browsing site.

any other suggestion?

Re: loading Salesforce data.

rajeshvaswani77 — Tue, 02 Sep 2014 07:47:41 GMT

Sometimes table like the task table have toomany records and the connection waits and times out. Can you add a where clause and say Id=some ID and see if a single record comes through?

thanks,

Rajesh Vaswani

Re: loading Salesforce data.

israrkhan — Tue, 02 Sep 2014 08:31:31 GMT

but when we run manually from desktop, it work fine...

and when we run in the QMC manually it works fine...

and when we schedule by local account, then even it works fine...

it only does not work when we run with Domain account...then it load 0 records...

even with domain account it was working successfully, for few months back..

since a week ago, we faced the problem...

................................

in the log file it shows that like 400 record found, 0 record fetched....so on..

Re: loading Salesforce data.

rajeshvaswani77 — Tue, 02 Sep 2014 08:35:29 GMT

Your desktop could be 32-bit, Server will be 64-bit. Are you using 64 bit connector? If you are using 32 bit(though not recomnmended) then you must force 32 bit option when connection string is created. Can you check if its 16 or 32 bit?

thanks,

Rajesh Vaswani

Re: loading Salesforce data.

israrkhan — Tue, 02 Sep 2014 08:57:44 GMT

every machine is 64 bit.. and even when i run manually through QMC , it working fine..

only schedule not working...

Appreciate you time Rajesh....

Re: loading Salesforce data.

rajeshvaswani77 — Tue, 02 Sep 2014 09:22:24 GMT

Are manual and scheduling using the same account? You must use the service account specified in QlikView for all cases.

thanks,

Rajesh Vaswani

Re: loading Salesforce data.

israrkhan — Tue, 02 Sep 2014 09:28:35 GMT

Yes, same domain account.

and schedule is working only , when we use Local account, but manual loading is working with both domain account and local account..