ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Data Warehouse (DWH) known issues

book

Article ID: 212329

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

Known issues related to Data Warehouse (DWH) including:

  • job failures
  • data issues
  • 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 the 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-00001

ORA-00600

ORA-00904

ORA-00942

ORA-01407

ORA-01427

ORA-01722

ORA-12899

ORA-01555

ORA-02019

ORA-02298

ORA-02049

ORA-04036 / ORA-02063

ORA-30926

ORA-04063

ORA-04020

ORA-04022

ORA-06502

ORA-28000

SQL Server Specific

Postgres (PG)

All Databases

Load DWH Access Rights job

Studio (Objects/Attributes)

Tables

Time Periods

Jaspersoft Domains

Upgrade/Compatibility

Including issues with incompatibility