Solved

how to change paths to SQL server in fmw file?


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.

icon

Best answer by keziaatsafe 21 March 2022, 16:33

View original

2 replies

Badge +6

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!

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!

hello.

long story short: open fmw file with text editor, replace all OLDSERVERNAME with NEWSERVERNAME, save.

Thanks a lot!

Reply