Data Warehouse (DWH) known issues for Clarity

book

Article ID: 212329

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

Highlight of some of the more common and recently reported issues for the Load Data Warehouse (DWH) including job failures, data issues, and performance.

Note: This article is not a full list, so it's recommended to utilize self-service if your issue isn't found here. 

Resolution

As the list of articles below is not a full list of KBs for DWH issues, if a match for your issue isn’t found below, please also search using the Broadcom support search portal. See Known Clarity issues: Tips in using self service.

General Troubleshooting

It's recommended to review the Troubleshooting guide first as this can assist in uncovering root cause. 

Known Defects

Under Review

Fixed in 16.0

Fixed in 15.9.3

Fixed in 15.9.2

Fixed in 15.9.1

Fixed in 15.9

Data

DWH Bean

DB Link

DWH Slices

Job Failures

For job failures, checking the job logs and bg-dwh.logs can help narrow down the related error. See Load DWH job failures - troubleshooting for further details / troubleshooting. If the related error is not found below, check the knowledge base as well for related issues. 

Post Refresh

New Environments

Oracle Specific

ORA-00904

ORA-00942

ORA-02019

ORA-02298

ORA-04036 / ORA-02063

ORA-30926

ORA-04063

ORA-04020

SQL Server Specific

Postgres (PG)

All Databases

 Load DWH Access Rights job

Studio (Objects/Attributes)

Tables

Jaspersoft Domains

Upgrade/Compatibility

Including issues with incompatibility