[AMBARI-23829] Inconsistent datatypes error when authenticating users when Oracle is the backend database for Ambari

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 2.7.0
• Fix Version/s: 2.7.0
• Component/s: ambari-server
• Assignee: Robert Levas
• Reporter: Denis Tarasyuk
• Created: 11/May/18 19:26
• Updated: 21/May/18 14:36
• Resolved: 21/May/18 13:36

Description

Inconsistent datatypes error when authenticating users when Oracle is the backend database for Ambari:

ORA-00932: inconsistent datatypes: expected - got CLOB

This occurs when selecting from the user_authentication table when the where clause compares a string with value from the authentication_key column.

Issue Links

• links to: GitHub Pull Request #1330