Schema does not exist error, when writing to a DB

Question

I have had a workflow that connects to a db table and appends new data to that same table.  The workflow has successfully run for month, until just recently.  My connection tests are successful and I can extract data from the database and schema, however, when my workflow progresses to write back to that same table I am getting a schema does not exist error.

I have rebuilt the workflow from the ground up, updated my connection leveraging a new driver, and even tried to use one workflow for the output and another for the write back.  The issue has persisted after all those attempts to address so hoping someone may have another idea.

Thank you,

Troy Zaruba (Novice)

Robin_McIntosh · Answer

You mention that no permissions have changed but have you double checked that you still have write access within the DB itself (not using Alteryx)?

Zaruba_6 · Answer

@IraWatt I am using a ODBC connection to a Netezza DB.  My connection works perfectly as I use the same ODBC on the front of the workflow to pull the data in,  It's when I try to write back to the DB ( no permissions have changed) that Alteryx is throwing the Error: Write Data In-DB (24): Error SQLPrepare: ERROR: Schema 'FCBEDM' does not exist.

I cannot for the life of me understand why, as the workflow has run just fine for months prior to this happening.

Zaruba_6 · Answer

Ira,

I am using an ODBC connection to a NetezzaSQL database.  The workflow has worked flawlessly for months and now, while I can connect to the database to extract data, when I try to append to the same table I get the schema does not exist error.

TZ