oracle probe 5.30 doesn't show Test Query result

Document ID : KB000118730
Last Modified Date : 31/10/2018
Show Technical Document Details
Issue:
After creating an Oracle profile in the oracle probe, the connection test is successful however when testing a custom query the Test Query result is not presented and the checkpoint cannot be saved.
Environment:
UIM 8.51
oracle probe 5.30
Cause:
Although this is a very unlikely scenario, the issue can be caused by the format of the encrypted password string.

The following error message might be logged in oracle.log after the query is tested:

oracle: (nimDecrypt) detecting mode from decoded string failed.
oracle: Profile: test query profile, Oracle error! Status: -1, - ORA-01005: null password given; logon denied
Resolution:
If the profile test works fine but only the test query is failing, this means there is an issue with the password.

Make any change to the Oracle account password and the problem should be resolved.