Question

Reading data from SQL is returning a large amount of data

Workflow

Updated March 25, 2019

asked on October 26, 2018

We need to read from a SQL table a value that exceeds 100 characters. By including the Query Data activity in the workflow and trying to read that column, we get the error: "Colum ELECTRONIC DOCUMENT is returning to a large amount of data Consider using the Custom Quey activity to exclude this colum [0638-WF0]"

Any suggestions on how to solve this problem?

0 0

Replies

replied on October 29, 2018

This is not an error, it's a warning. If you don't need that column, exclude it from your query. If you do need it, then you can ignore the warning.

1 0

replied on October 29, 2018

I can not ignore the warning, I need to read the whole column, they are around 9056 characters, however, it only brings 3698 characters with any of the indicated activities

0 0

replied on March 19, 2019

I am receiving the same error, could you find a solution to this problem?

0 0

replied on March 25, 2019

Again, this is a warning, not an error. The entire data is returned. Token values are truncated to 3700 characters when tracked to the database, so you may not be able to see the entire value in the instance details. However, the full value is used at runtime when other activities interact with the token.

1 0

replied on October 29, 2018

Hola David buen día,

considera cambiar tu "Query Data" por un "Custom query" , la diferencia es que la primera como el mensaje te señala cuenta con ciertas limitantes, que el "Custom query" no tiene,

Las ventajas de cambiar a un "Custom query" es que ahora podrás utilizar consultas mas complejas (desde un simple Inner a una tabla externa a una creación de tabla temporal, bulks, etc) siempre y cuando no incluyas en las columnas de retorno un "uniqueidentifier" todo estará bien.

Saludos!

0 0

replied on October 29, 2018

Hola David,

Gracias por la ayuda, he cambiado de actividad sin embargo el mensaje sigue siendo el mismo;

Alguna idea?

0 0

You are not allowed to follow up in this post.

Question

Question

Reading data from SQL is returning a large amount of data

Replies

Sign in to reply to this post.