Gallery Data Connection Problem with Multiple Database Platforms

[DMH1]

Hello, 

I ran across an interesting (but painful) problem using the Gallery.  I am running Designer 2020.4.  We recently made sure that our server/Gallery was upgraded to be compatible.

When I create a workflow that reads date from SQL Server and writes data to the SQL Server, I can save the workflow to the Gallery and run it.

Same with Oracle.  Reading from Oracle and writing to an Oracle table - no problem.

When I create a very simple workflow to read from an SQL Server table and write to an Oracle table, I cannot save the workflow to the Gallery.  When doing the save, I get the message: "Unable to translate alias SVCS_GLOBAL"

SVCS_GLOBAL is the Gallery data connection for the output table.  It is the same connector that I used in the Oracle-to-Oracle and the SQL Server-to-SQL Server test.  By the way, the tests were VERY simple "read a few rows from one table and write them to a new table on the destination server (or overwrite on repeated runs).

Anybody else run across this peculiar situation?  I now have a number of scheduled production workflows in my Gallery that will not run!!!

Thanks in advance for any ideas/repairs.

Regards,

Dave Harper

[JagdeeshN]

@DMH1 

A few clarifications:-

1. Can you confirm what type of connection you have created on the server for SVCS_GLOBAL

2. Can you also confirm the access levels for these connections

Best,

Jagdeesh Narayanan

[DMH1]

Hi jagdeeshn,

Thanks for your response.  The connector on the development server I'm using looks like this:

SVCS_GLOBAL

oci:SVCS_GLOBAL/__EncPwd1__@pls#######.avaya.com:1526/SMBPRD

I'm not sure how to answer your second question

Regards,

Dave Harper

[JagdeeshN]

@DMH1 

Through the second question i was trying to ask if the Data Connection was created for a particular user or as a system connection.

Do you have access to the designer instance on the Development Gallery you are trying to publish to?

If so can you please verify the workflow with the same alias, but by running it through the Designer on the server machine?

Best,

Jagdeesh Narayanan

[DMH1]

• Yes, it was created for a specific user (me).
• I do have access to the designer instance on our Gallery
• Your 3rd question - do you mean; will it run from the designer?  If so, the answer to that is yes.