Load DWH job frequently reported issues

book

Article ID: 212329

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

This KB contains a highlight of some of the more commonly and more recently reported issues for the Load Data Warehouse (DWH) job 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. 

Resolved Defects

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

SQL Server Specific

Postgres (PG)

All Databases

Load DWH Access Rights job

Performance

Studio (Objects/Attributes)

Tables

Jaspersoft Domains

Upgrade/Compatibility

Including issues with incompatibility