Skip to main content
Solved

Error when uploading workspace to FME Flow from FME Form. "Failed to update definition of database type Microsoft SQL Server


thomastupuivao
Contributor
Forum|alt.badge.img+6

Workspace I’m uploading from FME Form (2024.0.1.0) returns this error. 

 

Failed to update definition of database type 'Microsoft SQL Server (JDBC)' - FME Flow encountered an error and reported the following message.
Database type Microsoft SQL Server (JDBC) cannot be edited.
Request to http://XXXXXXXXX/fmeapiv4/databasetypes/Microsoft SQL Server (JDBC) returned status code 422.

 

Is a workspace that has SQL Executors pointing to a SQL Server database and outputs results to a XLSX file on my laptop.

Any help would be appreciated.
 

Best answer by mattmatsafe

Hi ​@thomastupuivao,

Thanks for the info. When publishing from Form to Flow, the year and major version should ideally be the same. There is a chance things will still work, but you may run into issues like this. I recommend authoring workspaces in FME Form 2024.2 b24783 to match your version of FME Flow.

Please see https://support.safe.com/hc/en-us/articles/25407441075469-FME-Versions-and-Workspace-Compatibility#h_01J29G9BQFGW12KR9MVHBG0V69 to learn more


The warning icon is just letting you know that the connection already exists on FME Flow and will be overwritten if you leave it checked off when publishing. However, based on the error you’re seeing, this might not actually be happening. If you publish from Form 2024.2, then I would expect the error to go away.

View original
Did this help you find an answer to your question?

6 replies

mattmatsafe
Safer
Forum|alt.badge.img+13
  • Safer
  • January 9, 2025

Hi ​@thomastupuivao, can you please confirm that the version of FME Flow you’re publishing to is also 2024.0.1.0? Or a 2024.x build that is newer than 2024.0.1.0? This may be caused by a version mismatch.

If you look for the connection on FME Flow (Connections & Parameters > Database Connections), is it there and does your workspace run on Flow despite the error? Are you able to publish other types of database connections without error?


thomastupuivao
Contributor
Forum|alt.badge.img+6
  • Author
  • Contributor
  • January 14, 2025

Hi Matt, 

Its FME Flow 2024.2 Build 24783

 

I’ve noticed that when I upload the workspace at the “upload connections” window, there is a ‘warning icon’ when select my SQL server connection. Not sure if thats expected or not?

 

 


mattmatsafe
Safer
Forum|alt.badge.img+13
  • Safer
  • Best Answer
  • January 14, 2025

Hi ​@thomastupuivao,

Thanks for the info. When publishing from Form to Flow, the year and major version should ideally be the same. There is a chance things will still work, but you may run into issues like this. I recommend authoring workspaces in FME Form 2024.2 b24783 to match your version of FME Flow.

Please see https://support.safe.com/hc/en-us/articles/25407441075469-FME-Versions-and-Workspace-Compatibility#h_01J29G9BQFGW12KR9MVHBG0V69 to learn more


The warning icon is just letting you know that the connection already exists on FME Flow and will be overwritten if you leave it checked off when publishing. However, based on the error you’re seeing, this might not actually be happening. If you publish from Form 2024.2, then I would expect the error to go away.


thomastupuivao
Contributor
Forum|alt.badge.img+6
  • Author
  • Contributor
  • January 14, 2025

Thanks for that Matt, yep I’ll work off that.

 

Cheers


mathiku
Supporter
Forum|alt.badge.img+7
  • Supporter
  • May 8, 2025

I have the same very persistent error:

Even if I delete the workspace from the server I can’t publish it more than once.

Request to http://fmesrv01/fmeapiv4/repositories/Dashboards/items/upload?overwrite=true returned status code 422.

The workspace is created entirely in this version of FME, so everything is upgraded, including packages.
 


mattmatsafe
Safer
Forum|alt.badge.img+13

@mathiku Is there an additional error message logged in the translation log? It may be a different issue entirely, 422 is a fairly generic error saying the Flow API couldn’t process the request. 

For example, do you have a reader/writer that was registered to a translation service that has been modified or deleted? On the last “Register Services” step of publishing to FME Flow, click edit next to each registered service. Remove any readers or writers that are showing as registered, but no longer exist in the workspace. They will be red. 

If this doesn’t help, please submit a ticket with the full translation log capturing any errors during publish.

Thanks!


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