Skip to main content

Hi,

 

since a month we are getting this error:

08:06:39: Using the Salesforce SOAP API.  SQLSTATE 01000]
08:06:39: Create AuraDefinitionInfo_Previous20250630080639716 with new structure.  SQLSTATE 01000]
08:06:40: Error System.Web.Services.Protocols.SoapException: EXCEEDED_ID_LIMIT: AuraDefinitionInfo does not support queryMore(), use LIMIT to restrict the results to a single batch  SQLSTATE 01000]
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)  SQLSTATE 01000]
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Objectt] parameters)  SQLSTATE 01000]
at DBAmpAZ.sforce.SforceService.query(String queryString)  SQLSTATE 01000]
at afo220A.iA.s()  SQLSTATE 01000]
08:06:40: Drop  if it exists.  SQLSTATE 01000]
08:06:40: Error: Unable to drop the  table.  SQLSTATE 01000]
08:06:40: System.InvalidOperationException: ExecuteReader: Connection property has not been initialized.  SQLSTATE 01000]
at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async)  SQLSTATE 01000]
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolea  SQLSTATE 01000]
n inRetry)  SQLSTATE 01000]
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)  SQLSTATE 01000]
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)  SQLSTATE 01000]
at System.Data.SqlClient.SqlCommand.ExecuteReader()  SQLSTATE 01000]
at afo220A.iD.o()  SQLSTATE 01000]
08:06:40: DBAmpAZ Operation FAILED.  SQLSTATE 01000]
08:06:40: Error: Replicate program was unsuccessful.  SQLSTATE 01000]

 

 

We are using DBamp 22.0.8781.0.

 

What i need to do?

 

thanks

Peter

Hi ​@Peter_Boelke 

The AuraDefinitionInfo table is failing with the following error: "EXCEEDED_ID_LIMIT: AuraDefinitionInfo does not support queryMore(), use LIMIT to restrict the results to a single batch". This is coming straight from Salesforce and unfortunately indicates that you will not be able to include this table in your SF_MirrorAll run. If you need this table, you can limit it with the SF_BulkSOQL stored procedure:

SF_BulkSOQL: https://cdn.cdata.com/help/AFH/dbampd/SF_BulkSOQL.html

 

It is possible to filter specific fields when you are making local Salesforce copies using the SF_BulkSOQL and SF_BulkSOQL_Refresh stored procedures. These work similarly to SF_Mirror, but rather than bringing down every field in a table, they make local copies based on a SOQL query that you provide. SF_BulkSOQL does a full copy run, recreating the table from scratch, while SF_BulkSOQL_Refresh does a delta copy run, refreshing the table with updated records.

You might want to either make use of the Options (https://cdn.cdata.com/help/AFH/dbampd/SF_BulkSOQL.html#options) by defining a lower BatchSize or just use a LIMIT in your SOQL query to reduce the amount of the data so that you can work around the error. For your convenience I am including an example below:

Exec SF_BulkSOQL 'Salesforce', 'AuraDefinitionInfo1', 'pkchunk,batchsize(50000)', 'Select * From AuraDefinitionInfo LIMIT 100000';


If you keep having issues or in case you need further assistance, I would recommend you submit a support ticket  in the CData Portal and someone from our Support team will get back to you with troubleshooting steps.

Hi Ethem,

 

thanks for you response. This error occurs when running the SF_ReplicateAll-Procedure. I tried to look into it, the implement the change, but i couldn’t locate the line where it should be.

 

Can you advise what to change there?

 

thanks

Peter

Hi ​@Peter_Boelke,

In that case you might want to skip the AuraDefinitionInfo table from your SF_ReplicateAll command using the DBAmpTableOptions table. I linked our documentation below on using the DBAmpTableOptions table, where you can find instructions on skipping tables from your SF_ReplicateAll/SF_MirrorAll runs:

Using the DBAmpTableOptions table: https://cdn.cdata.com/help/AFH/dbampd/UsingTheDBAmpTableOptionsTable.html

If you still need a local copy of this table, you can pass the proper SOQL query with a LIMIT as instructed earlier with SF_BulkSOQL.

Should you have any other questions, feel free to reach out to the support team at [email protected].

CData Foundations 2025
Terms and ConditionsCookie settings