Cannot retrieve data from SQL Server

[SSorianoA]

Hi community!

I am facing with a problem that after many consults I cannot resolve. I added a data connection in Gallery to a SQL Server database.

I added an input tool into Alteryx Designer and the connection is already done and it works perfectly. The problem is I want to retrieve all the data from a specific table from the data source and when I run the workflow it retrieves the column names but there is no data in there. If I run the query in the database directly the table has more than 800k rows. 

On the other hand if I consult other table from Alteryx the workflow works perfectly but I don't understand why not from the table I need.

Could anyone help me with this? What can I try to solve it?

Thank you team.

[shancmiralles · Accepted solution]

Server Environment -  If the workflow runs fine locally but not on the Alteryx Gallery, there may be an issue with the environment or server configuration, like : 

(1)Disk Space: Ensure there is enough disk space on the server for output data to be written.

(2)Memory or Processing Limitations: If the server is running low on resources (e.g., memory or CPU), it could result in incomplete workflow execution, causing no data to be output.

Also:

Server logs (I know you do but just Incase) Logs can often provide specific details about why the workflow failed to output data, such as timeout issues, connection problems, or resource constraints.

Other stuff I check later on - specially when I'm just working with a new workflow of mine.

Misconfiguration of filters, joins, or data processing tools.

Problems with the input data or data being filtered out.

Incorrect output file path or permissions.

Resource or environment-related issues on the server.

These are just the stuff I think of first when my server output is different from the desktop version.