loading Salesforce data.

[israrkhan]

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..???

[DavidFoster1]

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.

[israrkhan]

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...

[DavidFoster1]

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.

[israrkhan]

Dear Davis,

sorry Totally lost... 

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

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

[DavidFoster1]

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.

[rajeshvaswani77]

Hi,

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

thanks,

Rajesh Vaswani

[israrkhan]

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

[rajeshvaswani77]

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

[rajeshvaswani77]

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