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

[israrkhan]

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

[rajeshvaswani77]

yes

[israrkhan]

it make sense , let me try

will let you know...

many thanks for you comments....

[israrkhan]

Dear Rajesh,

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

any other suggestion?

[rajeshvaswani77]

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

[israrkhan]

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

[rajeshvaswani77]

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

[israrkhan]

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

only schedule not working...

Appreciate you time Rajesh....

[rajeshvaswani77]

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

thanks,

Rajesh Vaswani

[israrkhan]

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