topic Re: Too many SOQL queries in Talend Studio

Too many SOQL queries

_AnonymousUser — Tue, 19 Apr 2016 09:16:21 GMT

I have created a Batch Job which uses Bulk Upsert on salesForce. I keep on updating values for rows to commit and bytes.
still, I am having the error, 'Too many SOQL queries....'
What values should I input? and how 2 fields relate/vary with each other?

Re: Too many SOQL queries

Anonymous — Wed, 20 Apr 2016 03:45:59 GMT

Hi,
Are you using tSalesforceOutputBulkExce component? Could you please post your job setting screenshots into forum?
Best regards
Sabrina

Re: Too many SOQL queries

_AnonymousUser — Wed, 20 Apr 2016 04:56:37 GMT

Hi,
This is my Job,
tFileInputDelimited -->tJavaRow-->tSalesForceOutpurBulk
|
subJob ok
|
tSalesforceBulkExec
as of the moment, set rows to commit - 36 and bytes 10mb
this is the only setting where I did not encounter 'Too many SOQL queries'
but, I would like to consider the time(it is lonnger on smaller rows to commit) and Bulk Data Load Jobs on salesForce which takes up to 350 per file.

Thanks

Re: Too many SOQL queries

Anonymous — Wed, 20 Apr 2016 09:26:18 GMT

Hi,
Did you get this issue when use tSalesforceOutput instead? Have you tried to set bigger rows to commit to see if it works?
Best regards
Sabrina

Re: Too many SOQL queries

Anonymous — Wed, 20 Apr 2016 11:20:20 GMT

Is that the full error? Where are you seeing it?
An odd error for a bulk load.
Have you looked on the Salesforce batch load monitor to see if there is any more info?
Sometimes you may get issues with triggers and business rules being fired on Salesforce, especially if you're loading in parallel.

Re: Too many SOQL queries

_AnonymousUser — Tue, 26 Apr 2016 06:56:05 GMT

Hi,
there is no error on tSalesforceOuputBulk. The error encountered on tSalesforceBulkExec, each time I raise the rows to commit up to its max(10000) or lesser or even just 1000, I encountered that error.
on Salesforce bulk data load status it is less than the maximum. so I think there should not be any error.
Just want to confirm the relation of rows and bytes to commit, and what other instance causes this error.

Tahnks

Re: Too many SOQL queries

_AnonymousUser — Mon, 23 May 2016 04:30:38 GMT

Hi,
this is the error..... 'System.LimitException: Too many SOQL queries: 101'
Hope someone can help me with this.

thanks,
Daphne

Re: Too many SOQL queries

Anonymous — Mon, 23 May 2016 06:22:46 GMT

https://help.salesforce.com/apex/HTViewSolution?id=000181404&language=en_US