Hi All,

We believe we've hit a bug with the BULK API. When trying to perform a large query using PKChunking and an ORDER BY keyword the query fails.

Specifically, it appears that the BULK API is trying to submit multiple batches on different ranges (as it should), but since it's appending the range filter after the ORDER BY clause it's failing with the following error:

(msg=InvalidBatch : Failed to process query: MALFORMED_QUERY: Field_name FROM Account ORDER BY Id where Id >= '001150000yyyyyy' and ^ ERROR at Row:1:Column:xxxx unexpected token: 'where'), aborting

A sample SOQL query that will fail when Sforce-Enable-PKChunking header is set to True:

'SELECT Id,Name from Account ORDER BY Id'

Any suggestions/thoughts would be highly appreciated!

Thanks in advance,
Ariel.

Hi,

When using the Metadata API to list all the ApexTrigger files (via the listMetadata() call), we are getting a "MALFORMED_ID: bad id XXXXX" error and then all subsequent requests return a "INVALID_LOCATOR: Retrieve result has been deleted" error.

We've been using this method to list (and then extract data) from the Metadata API for quite some time, from many Orgs, and this is the first time we are seeing this behavior.

We've tried both v34 and v35 of the API.

Any idea what could be causing this error?

Thanks in advance,
Ariel.

Hi,

We've been seeing cases where certain fields in certain sObjects (e.g. 'MonthlyPageViewsUsed' field in the 'Organization' sObject, or the 'Name' field in the 'OpportunityLineItem' sObject) could change, without any of the audit fields (SystemModstamp, LastModifiedDate, CreatedDate)  changing as well.

While there are cases where this make sense (e.g. in Calculated fields depending on the current day), the above two examples are not calcualted fields.

Any idea what could be the cause of this behavior? Any other fields/sObjects combination that this could happened for?

Thanks in advance,
Ariel.

(this is somewhat related to a different question I asked a few days back: https://developer.salesforce.com/forums/ForumsMain?id=906F0000000AvJhIAK)

Hi,

The replication API calls (GetUpdated() and GetDeleted()) do not seem to behave consistently across all sObjects.

Specifically:

1) The 'Organization' sObject does not seem to get updates for changes in the 'MonthlyPageViewsUsed' column (maybe in other columns as well) despite this sobject being 'replicable' and this filed is not a 'calculated' field.

2) The 'OpportunityLineItem' sObject does not seem to  get updates for changes in the 'Name' column (this sObject is 'replicable' and this field is not a 'calculated' field)

As far as we can tell, this incosistency is only in these two sObjects (we are not running into any problems with any other sObject so far).

Do you have any idea what could be the cause of that? 

(While I can simply not replication these two sObject, we would like to understand the cause of this issue so that we properly handle these situations).

I'm using the REST API (v32), but believe this is also the case with (atleast) API v31.

Any insights would be highly appreciated.

Thanks,
Ariel.

 

Hi All,

We believe we've hit a bug with the BULK API. When trying to perform a large query using PKChunking and an ORDER BY keyword the query fails.

Specifically, it appears that the BULK API is trying to submit multiple batches on different ranges (as it should), but since it's appending the range filter after the ORDER BY clause it's failing with the following error:

(msg=InvalidBatch : Failed to process query: MALFORMED_QUERY: Field_name FROM Account ORDER BY Id where Id >= '001150000yyyyyy' and ^ ERROR at Row:1:Column:xxxx unexpected token: 'where'), aborting

A sample SOQL query that will fail when Sforce-Enable-PKChunking header is set to True:

'SELECT Id,Name from Account ORDER BY Id'

Any suggestions/thoughts would be highly appreciated!

Thanks in advance,
Ariel.

Hi,

When using the Metadata API to list all the ApexTrigger files (via the listMetadata() call), we are getting a "MALFORMED_ID: bad id XXXXX" error and then all subsequent requests return a "INVALID_LOCATOR: Retrieve result has been deleted" error.

We've been using this method to list (and then extract data) from the Metadata API for quite some time, from many Orgs, and this is the first time we are seeing this behavior.

We've tried both v34 and v35 of the API.

Any idea what could be causing this error?

Thanks in advance,
Ariel.

Hi,

The replication API calls (GetUpdated() and GetDeleted()) do not seem to behave consistently across all sObjects.

Specifically:

1) The 'Organization' sObject does not seem to get updates for changes in the 'MonthlyPageViewsUsed' column (maybe in other columns as well) despite this sobject being 'replicable' and this filed is not a 'calculated' field.

2) The 'OpportunityLineItem' sObject does not seem to  get updates for changes in the 'Name' column (this sObject is 'replicable' and this field is not a 'calculated' field)

As far as we can tell, this incosistency is only in these two sObjects (we are not running into any problems with any other sObject so far).

Do you have any idea what could be the cause of that? 

(While I can simply not replication these two sObject, we would like to understand the cause of this issue so that we properly handle these situations).

I'm using the REST API (v32), but believe this is also the case with (atleast) API v31.

Any insights would be highly appreciated.

Thanks,
Ariel.