Hello community,
I have been facing an issue where when i run a workflow which fetches data from google big query input and writes the data in either Oracle, SQL server or Excel.
While running it manually, it runs fine without any error in both DCM and ODBC type input connection for big query, But when i schedule it using alteryx desktop scheduler it always fails and gives an error "Remote Storage Error".
I have searched alteryx community but haven't found any resolution for this yet. Kindly assist.
Same Issue
Meet the Alteryx Community Team
Dear Alteryx Team,
Many people are currently facing difficulties in completing their daily tasks. Please look into this issue as it is affecting a large number of users."
Schedule on Scheduler - or Server? Google Big Query Input is a Python tool and will not work on Scheduler.
Schedule on scheduler i.e. local system. Input is your normal input tool where we tried to set up the connection using DCM as well as DSN.
Neither of them is working with the scheduler and we are writing the data directly into MS SQL/Oracle Table.
and your bq is set up to auth via service authentication in your odbc 64?
turn on additional errors logging there (in odbc 64) to see what you see.
I have added the login credential via auth file(json txt file) given by the admin and then using the credential i setup the input accordingly.