Cannot display users in Administration tool after upgrade

Products

• CA Harvest Software Change Manager

Issue/Introduction

After upgraded Harvest SCM to 14.5, from Administrator tool Output Log, on the Users tab, getting error while trying to retrieve users:

Database error [Oracle][ODBC][Ora]ORA-00932: inconsistent datatypes: expected BLOB got CLOB

Environment

Linux Harvest SCM 14.5, Oracle database

Resolution

This is a known issue.

Please apply patch v14.5 - Hot Fixes and then run these statements on Oracle DBMS

drop table harusrgrplisttemp;

CREATE GLOBAL TEMPORARY TABLE HARUSRGRPLISTTEMP
   (USROBJID NUMBER, USRGRPLIST CLOB)
   ON COMMIT DELETE ROWS;