Error Saving to Gallery

[S2N]

Hey all,

I'm trying to save a workflow to our gallery and I'm getting the message below.  I'm using designer version 2022.1 and server version is the same.  

[S2N]

[fmvizcaino]

Hi @S2N ,

You are connecting to a database, right? The issue is that your server doesn`t have access to the DSN connection you have created on your machine.

You have to ask your server admin to create the same connection on the server machine or for them to create a DSN-less connection and share it with you.

Best,

Fernando Vizcaino

[S2N]

Yes, I'm connecting to an Oracle database.  IT has a connection setup and have given me access, but when I try connecting (in designer) I get the error "ORA-12154 TNS could not resolve the connect identifier specified".  I'll have them setup a connection with my credentials and see if that works.  Thanks Fernando!    

[fmvizcaino]

Hi @S2N ,

You have to also ask them to share the tnsnames.ora file they are using on the Gallery and configure the ORACLE_HOME environment variable.

I'm not sure if this is the best tutorial, but here they are talking about both of the fixes.

https://www.datavail.com/blog/ora-12154-tnscould-not-resolve-the-connect-identifier-specified/

Best,

Fernando Vizcaino

[S2N]

Thanks Fernando.  I'm going to work on this today and will let you know.  Fingers crossed!