When password of an ODBC or OLE DB connection to Oracle database contains a semicolon (;) character, reload task fails with error [Oracle][ODBC][Ora]ORA-01017: invalid username/password; logon denied.
QlikView/ Qlik Sense fails to send the password string containing semicolon (;) character to Oracle. This character is commonly used as command terminator in both QlikView/ Qlik Sense, Oracle as well as other software products. Therefore, using this character in credentials may break the connection string interpretation.Environment:
- QlikView all versions
- Qlik Sense all versions
The issue only happens to semicolon and not other special characters. As a quick fix to this issue, consider using other special characters (! # $) for the password instead of semicolon.