• Skyvia does not allow me to pull more than 2048 records, then it errors out.

Skyvia does not allow me to pull more than 2048 records, then it errors out.

  • 273Views
  • Last Post 08 April 2021
0
votes
Craig Gjerdingen posted this 05 April 2021

https://app.skyvia.com/#/29060/packages/123786/debug

Source Connection is Marketing Cloud using a Data Extension.

 

Target is a SQL server 2016 connecting through an Agent. 

 

We are using the new runtime.  

 

It seems that Skyvia does not allow me to pull more than 2048 records, then it errors out. 

 

Can you assist us?

 

We are pulling over 10,000 records from Other Marketing Cloud connections using the same connection, but a different Target.  Is there are specific setting that you had to request to allow more records to be pulled?

Is this a limitation of the new runtime or the use of an Agent?

 

Thanks for your help!

sql-server agent
0
votes
Dmitriy Muzurov posted this 08 April 2021

Hi Craig,

Thank you for submitting a ticket with us.

We don't see a limit of 2048 records on the package.

There is different quantity that is count against the filter conditions.

Please open Skyvia Query, select your Marketing Cloud connection and query the same data extension with the same filter conditions similar to this one:

SELECT COUNT(*) AS expr1

FROM Send_Open_Click_Unsubscribe AS t

WHERE (t.Action_Type = 'Email Sent')

Let us know the quantity of records.

New Ticket
Categories
Popular Tags
Close