BI SFTP connection no longer working due to Key Exchange Algorithm Deprecation
Summary:
One of our SFTP delivery configuration in Oracle BI Publisher has stopped working due to deprecation of diffie-hellman-group14-sha1
SSH Kexs on the target server.
Error message: Could not establish connection. oracle.xdo.delivery.ssh2.SshException: Timeout waiting for response from server
As per Oracle docs, https://docs.oracle.com/en/cloud/saas/otbi/otbi-pub-admin/ssh-options-sftp.html
The following algorithms are available only when Publisher is running on a JVM on which the Java Cryptography Extension (JCE) unlimited strength jurisdiction policy files are installed:
- diffie-hellman-group-exchange-sha256
- diffie-hellman-group14-sha256
- diffie-hellman-group16-sha512
- diffie-hellman-group18-sha512
- rsa-sha2-256
- rsa-sha2-512
- aes192-ctr
- aes256-ctr