In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.

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

NemesiaKantekar
5 - Atom
‎02-05-2020 01:27 PM

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



Preview file
200 KB
Labels:
Reply
0 Likes
2 REPLIES 2
joshuaburkhow
ACE Emeritus
ACE Emeritus
‎02-05-2020 07:50 PM

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

Joshua Burkhow - Alteryx Ace | Global Alteryx Architect @PwC | Blogger @ AlterTricks
Reply
0 Likes
NemesiaKantekar
5 - Atom
‎02-07-2020 08:01 AM

Yes

we have the same ODBC drivers in local and server machine 

Reply
0 Likes
server new user guide
Labels
Top Solution Authors
View All