Skip to main content
Question

Error when retrieving AuraDefinition

  • June 30, 2025
  • 3 replies
  • 70 views
P
Forum|alt.badge.img

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, 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

      This topic has been closed for replies.

      3 replies

      Ethem Q
      Forum|alt.badge.img
      • Ethem Q
      • Employee
      • June 30, 2025

      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.

        P
        Forum|alt.badge.img
        • Peter_Boelke
        • Author
        • Apprentice
        • July 3, 2025

        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

          Ethem Q
          Forum|alt.badge.img
          • Ethem Q
          • Employee
          • July 3, 2025

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

          State of AI Data Connectivity Report: 2026 Outlook
          Terms and ConditionsCookie settingsAccessibility statement