Scheduling workflow in company gallery error opening 'select * from'

I have a workflow that uses an In-db connection to pull data, filters it, Data Streams out, and uses an output tool to write the data to a SQL Server database table. This workflow runs perfectly when running it within alteryx desktop, but when I try to schedule it to the gallery I get the error 'Error Opening: Select * from database.schema.table: no columns returned'. Any ideas?

Error Message

Accepted answers

CortlynHatch

I figured out that it was how I was saving my workflow on the gallery server. I needed to set up credentials to run the workflow when saving it. Super easy but frustrating solution, thanks for your help!

All comments

MichalM

@CortlynHatch

This could be for number of reasons. Do you know what user is used to run the workflows on the server? Does this user have access to the table you're trying to access?

CortlynHatch

Yes, the user used to run the workflows on the server has full permissions to the sql server database

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703