Python code unable to make connection to Oracle database through Alteryx Gallery/Server

[NemesiaKantekar]

Hello

I have an Aletryx workflow that is scheduled to a run python code. The pyhton code is creating dynamic oracle database connections using cx_Oracle package.

This works fine in the designer and i get expected results.

However when we schedule it on the gallery/server - it fails with error:

(cx_Oracle.DatabaseError) ORA-12154: TNS:could not resolve the connect identifier specified (Background on this error at: http://sqlalche.me/e/4xp6)

this is only happening in the gallery. Kindly suggest

python code making connection to oracle db

[joshuaburkhow]

Did you ensure that the same drivers you have on your machine are on the server as well?

[NemesiaKantekar]

Yes

we have the same ODBC drivers in local and server machine