Skip to main content
Solved

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

  • December 11, 2023
  • 1 reply
  • 457 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.

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

1 reply

paulmacintyre
Contributor
Forum|alt.badge.img
  • 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.


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