Skip to main content
Solved

FME Flow 2023.1 - Issues with SQL Transformers and Deployment Parameters/Database Connections

  • December 11, 2023
  • 2 replies
  • 557 views
paulmacintyre
Contributor
Forum|alt.badge.img

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.

Best answer by paulmacintyre

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.

jjf
jaapvanboheemen
julien_m
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

paulmacintyre
Contributor
Forum|alt.badge.img
  • paulmacintyreContributor
  • Author
  • Contributor
  • Best Answer
  • December 11, 2023

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.

jjf
julien_m
robd
Contributor
Forum|alt.badge.img+2
  • robdContributor
  • Contributor
  • July 29, 2025

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!

henrikstagnell

Community Stats

32,128
Posts
121,966
Replies
39,779
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.