# Error when retrieving AuraDefinition

**URL:** <https://community.cdata.com/t/error-when-retrieving-auradefinition/1122>\
**Category:** CData DBAmp\
**Tags:** question\
**Created:** [June 30, 2025, 7:56am UTC](https://community.cdata.com/t/error-when-retrieving-auradefinition/1122 "2025-06-30T07:56:51Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Peter\_Boelke](https://avatars.discourse-cdn.com/v4/letter/p/dfb087/32.png) [@Peter\_Boelke](https://community.cdata.com/u/Peter_Boelke)\
**Post date:** [June 30, 2025, 7:56am UTC](https://community.cdata.com/t/error-when-retrieving-auradefinition/1122/1 "2025-06-30T07:56:52Z")

</div>

Hi,

since a month we are getting this error:

```auto
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, Object[] 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

---

<div class="post-metadata">

**Author:** ![Ethem\_Q](https://sea3.discourse-cdn.com/cdata/user_avatar/community.cdata.com/ethem_q/32/1997_2.png) [@Ethem\_Q](https://community.cdata.com/u/Ethem_Q)\
**Post date:** [June 30, 2025, 4:43pm UTC](https://community.cdata.com/t/error-when-retrieving-auradefinition/1122/2 "2025-06-30T16:43:02Z")

</div>

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: [DBAmp - 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](https://cdn.cdata.com/help/AFH/dbampd/SF%5C_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:

```auto
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](https://portal.cdata.com/support/submit-ticket)&nbsp;&nbsp;in the CData Portal and someone from our Support team will get back to you with troubleshooting steps.

---

<div class="post-metadata">

**Author:** ![Peter\_Boelke](https://avatars.discourse-cdn.com/v4/letter/p/dfb087/32.png) [@Peter\_Boelke](https://community.cdata.com/u/Peter_Boelke)\
**Post date:** [July 3, 2025, 7:58am UTC](https://community.cdata.com/t/error-when-retrieving-auradefinition/1122/3 "2025-07-03T07:58:47Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Ethem\_Q](https://sea3.discourse-cdn.com/cdata/user_avatar/community.cdata.com/ethem_q/32/1997_2.png) [@Ethem\_Q](https://community.cdata.com/u/Ethem_Q)\
**Post date:** [July 3, 2025, 1:51pm UTC](https://community.cdata.com/t/error-when-retrieving-auradefinition/1122/4 "2025-07-03T13:51:53Z")

</div>

Hi ​ @Peter_Boelke ,

In that case you might want to skip&nbsp;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: [DBAmp - 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&nbsp;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 [support@cdata.com](mailto:support@cdata.com).
