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

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, 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.1

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-01400

ORA-01407

ORA-01427

ORA-01722

ORA-01775

ORA-12899

ORA-01555

ORA-01735

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

Additional Information

See also Clarity frequently reported issues