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