span8
span4
span8
span4
Symptoms: After configuring FME Server to use a new Database for the FME Server Database you may experience:
The following tables provide an overview of database specific error messages and their causes:
Errors found in *fmeserver.logError | Cause | Database |
SQLException: COM.亚搏在线safe.fmeserver.database.FMEServerDBException: java.sql.SQLException: Listener refused the connection with the following error: ORA-12505,TNS:listener does not currently know of SID given in connect descriptor |
Bad JDBC Connection String - SID or Service Name is wrong Database in shutdown state |
Oracle |
SQLException: COM.亚搏在线safe.fmeserver.database.FMEServerDBException: java.sql.SQLException: The Network Adapter could not establish the connection | Most likely a bad hostname in the JDBC connection string or firewall issues with the Oracle Database System |
Oracle |
SQLException: ORA-00942: table or view does not exist | Correct credentials but no fme_* tables in the schema - Oracle |
Oracle |
SQLException: COM.亚搏在线safe.fmeserver.database.FMEServerDBException: java.sql.SQLException: ORA-01017: invalid username/password;logon denied | Incorrect Username | Oracle |
SQLException: COM.亚搏在线safe.fmeserver.database.FMEServerDBException: java.sql.SQLException: ORA-28000: the account is locked | Incorrect password tried ten times and now account is locked - usually indicating a bad password for a valid user |
Oracle |
SQLException: COM.亚搏在线safe.fmeserver.database.FMEServerDBException: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'fmeserver' | Likely incorrect password used | SQL |
SQLException: Invalid column name 'rtc'. com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'rtc' |
FMEServer schema objects are out of date for the new version of FME Server. Recreate the FMEServer schema objects |
SQL |
SQLException: COM.亚搏在线safe.fmeserver.database.FMEServerDBException: com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the hostcomputer1/instance1,port 1433 has failed.Error: "null.Verify the connection properties,check that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port,and that no firewall is blocking TCP connections to the port.". | This may be related to a host entry that looks like this FME Server doesn't not handle this correctly.Try this format for DB_JDBC_URL - the Port reference is removed and instanceName has been added: DB_JDBC_URL= jdbc:sqlserver://proserve1;instanceName= support;databaseName=fmeserver A PR has been filed that will address support for this syntax. |
SQL |
SQLException: COM.亚搏在线safe.fmeserver.database.FMEServerDBException: org.postgresql.util.PSQLException: Connection refused. | Bad Port in config file - PostgreSQL | Postgres |
SQLException: COM.亚搏在线safe.fmeserver.database.FMEServerDBException: org.postgresql.util.PSQLException: FATAL: password authentication failed for user "fmeserver" | May indicate a Bad User or Bad Password | Postgres |
SQLException: ERROR: relation "fme_jobs" does not exist | Connection was made but no fme_* tables found in the schema | Postgres |
Error | Cause | Database |
Exception in thread "main" COM.亚搏在线safe.fmeserver.api.FMEServerException: QSConnectionFailed | No fme_* tables in schema | SQL Server |
Error | Cause | Database |
SQLException: Invalid object name 'fme_sharedres'. com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'fme_sharedres'. |
Permissions not set correctly on the fmeserver user.Ensure User Mapping has been configured in SQL Server Management Studio. | SQL Server |
In most cases the problem is that the FME Server core cannot connect to the new Database Provider.
Please ensure before proceeding that FME Server operates as expected with the delivered FME Server Database.The FME Server Database would exist in this form if you selected the Express Install option from the Installer.
NOTE: FME Server 2012- 2015+ uses PostgreSQL DB.FME Server 2011 and earlier an HSQL Database is used.
Here's the link to the section in the FME Server Administration Guide applicable to this configuration change and should be reviewed if you are experiencing issues:
Changing the Database Provider for the FME Server Database.This section in the admin guide will provide the necessary information and links for the configuration changes.Pay particular attention to thedatabase configurationand thepost configuration scriptssteps.For thedatabase configurationstep you'll need to have access to a DBA that can create users and run scripts against the Database.
Tip when reviewing the configuration changes:
File paths and names areallcase sensitive.
NOTES
FME Server 2011
TheCLASSPATHsettings in particular must be done correctly.
The website given in the Admin Guide for FME Server 2011 for downloading the Oracle JDBC driver is no longer valid.See the link above for the latest location.
For FME Server 2011 use the ojdbc5.jar driver.
Download the JDBC driver.The drivers can be found here:
DBC and Universal Connection Pool (UCP):
http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html
Having the correct Oracle JDBC driver for FME Server 2011 can also be a source of a connection issue.If you are not certain of the driver to use please contactfmeserversupport@亚搏在线safe.comand we can provide you with the correct one.
3 Machine Distributed Installation
Can't Login to FME Server Web UI | Error "Exception loading sessions from persistent storage"
Forwarding email to FME Server from another mail server
Bulk load workspaces to FME Server (2012)
FME Server Web Services are Unavailable
Run a service from Web UI: Sample Job Fails
Problem Publishing to FME Server using Web Connection
FME Server Web UI unresponsive
Problem Manually Enabling Security (FME Server 2015 or Older)
FME Server Resources - Uploading,Referencing and Configuration
© 2019 亚搏在线Safe Software Inc |Legal