Skip to main content

Morning All,

 

Has anyone else identified an issue with all SQL transformers when specifying the connection via either deployment parameter or database connection? When run on Form it operates correctly but when run via Flow (either scheduled or manually submitted) the following error is returned:

 

Error occurred while opening database reader with server type `MSSQL_ADO', server name `XXXXX', user name `', database name = `' : `Encryption Error: AES Decrypt finalization failed.'

 

If the database connection is embedded into the transformers Flow is able to operate these transformers correctly, however this would then require each transformer to be reconfigured as we migrate between environments.

 

Thanks in advance,

Paul.

For anyone interested I have stumbled upon the answer. The presence of an _ in passwords is causing issues with the encryption in Flow. When the underscores are removed the functionality works as expected. So there is an issue with the encryption to be aware of.


This might not be related but I had the same error in FME Flow 2023.2 in an SSL/HTTPS deployment and the solution was different:

Changing the host in The FME Flow interface or during Publish from FME Form seemed to cause the db connection to encounter Encryption Error: AES Decrypt finalization failed. (This is using PostGRES)

The solution that worked for me was to overwrite the connection password as plain text into the WebUI interface and save. Seemed that the automated side of updating the connection credentials was introducing some problem.

Hope this helps somebody!


Reply