Unable to create database agent when enabling OS and adding a new RSA credential.
ERROR [ddqwwbdhts-1] com.quest.wcf.core.module.function.FunctionManager - Error executing script id=system:oracle_installer_apis_database.createAgent name="'createAgent' from the System module Databases/Oracle/Installer/APIs/Database"
message: com.quest.nitro.service.sl.interfaces.scripting.ScriptingException: com.quest.nitro.service.sl.interfaces.scripting.ScriptAbortException: java.lang.RuntimeException: java.security.InvalidKeyException: Wrong algorithm: AES or Rijndael required
After the first failure the following issues may be present in the environment:
A restart of the Foglight Management Server is required in order to clear the problem condition.
The issue happens in the database agent wizard: when selecting OS monitoring, if they add an RSA key via database agent wizard (and NOT from stored credentials), it should fail with InvalidKeyException: Wrong algorithm: AES or Rijndael required
Workaround 1:
Create the IC agent separately via Infrastructure agent wizard with no issues, Then create the agent (with no OS monitoring).
Workaround 2:
Create a Credential with RSA key from Manage Credentials dashboard. Then use the Stored credential in the agent wizard with OS monitoring, now both database agent and infrastructure agent can be created successfully from SQL Server wizard
Status
Issue logged as defect Id. FOG-7089 has been fixed in the 6.3.0.26 and higher releases of the Oracle cartridge, and in the 7.2.3.10 and higher releases of the SQL Server, Azure SQL, and DB2 cartridges.
Similar to Cannot enable OS collections for Oracle when using a RSA key pair (4212131) but impacting different product versions.
