Skip to main content
Question

Unable to run the FME workflows through server:

  • August 20, 2019
  • 1 reply
  • 18 views
B

Unable to run the FME Master workflow which has 39 workflows as single workflow through FME Server. It used to run fine until 2 weeks back. Now,It is returning an ORA-12154 error in the log file. Please help

2019-08-19 06:00:14| 0.8| 0.0|INFORM|Feature Type: `FEATURE_TYPE'

2019-08-19 06:00:14| 0.8| 0.0|INFORM|Attribute(string): `_reader_error' has value `Error connecting to Oracle database: message was `ORA-12154: TNS:could not resolve the connect identifier specified'. (serverType=`*****', serverName=`*****', userName=`', password=`***', dbname=`')'

2019-08-19 06:00:14| 0.8| 0.0|INFORM|Attribute(string): `fme_type' has value `fme_no_geom'

2019-08-19 06:00:14| 0.8| 0.0|INFORM|Geometry Type: Unknown (0)

 

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

sipsysigh
Contributor
Forum|alt.badge.img+12
  • sipsysighContributor
  • Contributor
  • August 20, 2019

Hi,

Do you connect to Oracle using local naming (tnsnames.ora file)?

If so, you might want to check the following:

  • Verify that a tnsnames.ora file exists and is in the proper directory and is accessible.
  • Check that the net service name used as the connect identifier exists in the tnsnames.ora file.
  • Make sure there are no syntax errors anywhere in the tnsnames.orafile. Look for unmatched parentheses or stray characters. Errors in a tnsnames.ora file may make it unusable.

Simon

Community Stats

32,154
Posts
122,043
Replies
39,812
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.