hello
we migrated to new sql server (names changed from SERVER1 to SERVER2) and now jobs is failing.
i open failing fmw file in FMW Workbench, changed sql server names in parameters (where found), saved file, but jobs keep failing.
any suggestions?
thanks.
Best answer by keziaatsafe
Hi Tadaskiskenas,
Is the job failing on FME Desktop, FME Server or both?
There are two ways to add database connections on FME Server: On the Database Connections page or from FME Workbench.
Here are some documentations to look over:
Database connections for FME Server: https://docs.safe.com/fme/html/FME_Server_Documentation/WebUI/Database-Connections.htm
Database connections for FME Desktop: https://docs.safe.com/fme/html/FME_Server_Documentation/WebUI/Database-Connections.htm
https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_ReadersWriters/!NamedConnections/options_database_connections.htm
Hope this helps!
View original