Im trying to use the big query OBDC Simba connection to write data to a big query table.
I keep getting an error that says "Operation not allowed during the transaction state"
I have the Output Tool configured to Append Existing data to the table. Does anyone know why this error is populating?
Having the same issue after driver upgrade to SIMBA ODBC v2.5.2.1004 and re-configuring the DSN with User Authentication. Not sure what else has changed to cause this error as the workflow tooling has not changed. This doesn't appear to go away with any Output Mode change or Table Name change.
@LPETRUS This post might resolve your particular error: https://alteryx.my.site.com/knowledgecenter/s/article/Error-Operation-not-allowed-during-the-transac...
However, it did not work for me.
Thanks,
Joe