Error: Output Data (23): Error SQLPrepare: [Simba][ODBC] (11210) Operation not allowed

[LPETRUS]

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?

[JMB001]

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.

[JMB001]

@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

[ehsan5u]

Please do let me know if this issue was resolved

I am trying to write back to big query 
Message: Error SQLPrepare: [Simba][ODBC] (11210) Operation not allowed during the transaction state
ODBC Driver: 8.3
Simba GCP ODBC Driver: v 3.0.5.1011

[Shaaz]

Do we have any solution for the above?

[JMB001]

What's your Alteryx version? The upgrade to 2023.1 with the SIMBA 3.0 solved this issue for our team.

[Shaaz]

I was able to resolve the error.

All that I did is download and install the latest Simba driver as available in Alteryx official download site.

Once installed, create a new connection, also under Advanced Options, select Enable Session.