Error Message :
SQL Server : U00003590 UCUDB - DB error: 'SQLDriverConnect', 'ERROR ', '28000', 'Login failed for user 'uc4'.'
Oracle : U00003592 UCUDB - Status: '' Native error: '1017' Msg: 'ORA-01017: invalid username/password; logon denied'
The program ucybcryp creates an encrypted password that is not decoded correctly by the Automation Engine or by the Utilities.
The component using this password (i.e. Utility, AE server or CallAPI) returns an invalid credentials error, then writes a forced trace and crashes.
(Note that the result of ucybcryp, with the same password, is still always different.)
Expected : the component should run with no issues.
Actual : the connection to the database fails with an 'invalid login' error.
Cause type: By design
Root Cause: This is not related to the encryption tool. The issue is related to the escape character (^), which is interpreted by the windows shell (cmd.exe).
OS: All Windows
There can be 2 causes:
1 - The two leading hyphens of the encrypted password (stored in Password.ucc) should not be copy / pasted, but rather typed in manually inside the ini file. If they are copied the password will not be correctly recognized.
2 - The password contains a '^' (carrot) which is wrongly interpreted by the windows "shell". This prevents the encryption tool from working properly.
In order to generate a password that is recognized, use Powershell to start the encryption tool.
Example: the password 'te^st' is encrypted
Other characters that are known to cause issues are commas and slashes ("," or "/")
Fix Status: No Fix