Skip to main content
Question

Unable to run the FME workflows through server:

  • August 20, 2019
  • 1 reply
  • 9 views

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)

 

1 reply

sipsysigh
Contributor
Forum|alt.badge.img+7
  • 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


Reply


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