Unable to find connection

Question

Hi,

I setup my ETL and it runs fine manually. When it runs in scheduler it doesnt run, it says: "Unable to find Redshift in-db operations" which is the name I gave my "Data Stream In".

I tried editing it and put Password Encryption: Encrypt for Machine.

The ODBC is on System DSN and has Encrypt Password For: [x] All Users of This Machine.

Any ideas?

Thanks

Joao

joao · Accepted Answer

I had trouble figuring this out. I needed to Run the Desktop Alteryx as Administrator so that the System option becomes available.  After that the scheduling works.

I got this from another thread. https://community.alteryx.com/t5/Publishing-Gallery/In-DB-connection-on-app-published-to-Gallery/m-p/22944