span8
span4
Note: the FME Server Repository schema can change between major and minor releases of FME Server (i.e.2014 to 2015.1 to 2015.2).
We do not support the migration of the fme_job_history table.Although,in some instances we have been asked how to do this and we have provided some basic instructions here.
Have your DBA perform the following:
Updating fme_jobs_job_id_seq:Once the new FME Server Repository database has all the old job history in fme_job_history.To change the sequence it will depend on the database.For PostgreSQL / Express Install,you'd need to update the sequence: fme_jobs_job_id_seq
By Default we deliver FME Server Repository on top of Postgres SQL database and the sequence name is called fme_jobs_job_id_seq.
Here is an example of how to update the next sequence value.ALTER SEQUENCE fme_jobs_job_id_seq RESTART WITH
For Oracle,similar to PostgresSQL the fme_jobs_sequence needs to be adjusted to 1+max value for job_id in the job history table.
For SQL Server the job_id of the fme_jobs table is an IDENTITY field and this drives the job_id that would eventually be inserted in the Job History table.So adjust this IDENTITY value to 1+max value (job_id) in fme_job_history table.
FME Server Does Not Start When Configured with Oracle Database
FME Server may not allow you to connect to the UI returning HTTP 500 error.
FME Server Database Service Does Not Start After Reboot
3 Machine Distributed Installation
FME Server Database Service Won't Start (FME Server 2013,SP2)
FME Server Database Service Won't Start with Error 193: Not a Valid Win32 Application
Error Configuring SQL Server Database
Shared Resources not accessible when workspace run on FME-Server
FME Server Fails to Start When Configured to Use Active Directory
Ports and Executables and Firewall Exceptions for FME Server
© 2019 亚搏在线Safe Software Inc |法律