We migrated to Orcale 19c and Load Data Warehouse job started failing. From the logs I see that Load Data Warehouse is failing with error:
2021/01/04 18:08:14 - ClarityDB - isOracle? - [CA Clarity][Oracle JDBC Driver][Oracle]ORA-20100: ENCOUNTERED EXCEPTION WHILE INSERTING INTO DWH_TMP_RECORD_KEYS. SQLERRM : ORA-16000: database or pluggable database open for read-only access
Release : Any
Component : CA PPM INTEGRATIONS & INSTALLATIONS
This means the database is not open for read-write access but read only. Please ask your DBA to correct this and run Load Data Warehouse job - Full Load again.