Skip to main content
Solved

FME failing to connect to Oracle, only from outside app

  • February 28, 2019
  • 8 replies
  • 34 views
S

Our app, on server 1, calls on a FME fmw file translation, also on server 1, and sends the data back to the user via the app. This was working perfectly up until ? time, I can't be sure exactly when it started as I only got the helpdesk issue routed to me yesterday. I did upgrade our Weblogic server on the same machine (server 1) last weekend but no other changes were made to the Oracle client or Java or anything other than Weblogic specific, but I'm not ruling out that it's not realted.

From server1, I can tnsping the database server, withing FME workbence the database connection test successful, running the fmw file from within the workbench connects successfully also, yet via the app I get the infamous ORA-12154: TNS: could not resolve the connect identifier specified.

I've played with the tnsnames.ora file modifying various items, setting IP as opposed to machine name, setting service_name as opposed to sid, etc....to no avail.

Any ideas?

Best answer by sdlasiter

Found the issue. When I installed Weblogic, which our java app uses, I also installed a windows weblogic service that, by default installs and runs as local system account. By changing the service "Log On" to run under the admin account we use for all our maintenance and installations. the app was able to access the required files.....

View original
Did this help you find an answer to your question?

8 replies

david_r
Celebrity
  • david_rCelebrity
  • February 28, 2019

How are you making the Oracle connection, using a database connection or with embedded connection properties?

If using a database connection, try to temporarily replace it with embedded connection properties, hardcoded into the workspace. It that works, it may be some issue with the app service user maybe not finding or having a corrupt internal database connection file.

S
  • sdlasiter
  • Author
  • February 28, 2019

Still failing with embedded parameters also, same error.

S
  • sdlasiter
  • Author
  • February 28, 2019

I jumped the gun on a previous post of log. Here is the log output and the database connection.

 

 

S
  • sdlasiter
  • Author
  • March 1, 2019

In the log you can see "Connecting to Oracle database 'fme_ro', but fme_ro is the user, not the database, the database is CVCPRI1. Not sure why FME doesn't see this from the database connection description shown below.

S
  • sdlasiter
  • Author
  • March 1, 2019
sdlasiter wrote:

In the log you can see "Connecting to Oracle database 'fme_ro', but fme_ro is the user, not the database, the database is CVCPRI1. Not sure why FME doesn't see this from the database connection description shown below.

Showing results of database connection test

S
  • sdlasiter
  • Author
  • March 1, 2019

I don't believe the system is gaining access to the database connection file. The earlier fail with embedded parameters was actually working until the file hit the defined database connection part of the fmw file, then failing. So, my previous post of same error was correct, but not on the embedded parameters but later on the defined connection. I've tried deleting all connections and associated files and recreating but it still seems unaccessable.

S
  • sdlasiter
  • Author
  • March 1, 2019
david_r wrote:

How are you making the Oracle connection, using a database connection or with embedded connection properties?

If using a database connection, try to temporarily replace it with embedded connection properties, hardcoded into the workspace. It that works, it may be some issue with the app service user maybe not finding or having a corrupt internal database connection file.

Is there a way to ensure app service finds the file?

S
  • sdlasiter
  • Author
  • Best Answer
  • March 1, 2019

Found the issue. When I installed Weblogic, which our java app uses, I also installed a windows weblogic service that, by default installs and runs as local system account. By changing the service "Log On" to run under the admin account we use for all our maintenance and installations. the app was able to access the required files.....

Reply


Helpful Members This Week

Community Stats

31,325
Posts
118,843
Replies
38,954
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.