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.
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.
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.
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?
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?
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.
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.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.
