This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Executing PreSQL: [Oracle][ODBC]Syntaxt error or access violation Error Running PreSQL: [Oracle][ODBC]Syntaxt error or access violation
When you run a workflow locally in Alteryx Designer it runs as the user who is currently logged in. When you the schedule or push that workflow to the server it will run as the local system account (not logged in user). If you set up your database to use windows authentication you could get errors since the workflow will essentially run as a different user on the server and thus not be able to authenticate.
To combat this you can ask your DBA to permission the local system account for the database or you can set a Run As user in the system settings of Alteryx. Setting a Run As User will allow the workflow to run under different credentials.
Can you try setting up the Run As credentials under tools-->System Settings? The Run As User will allows the workflow to access files or data that may otherwise be inaccessible by default. Please let me know if it works.