search cancel

Clarity PPM: Post Transactions to Financials Job Slow Performance

book

Article ID: 131630

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

The Post Transactions to Financials job is processing at a slow rate.
For 80,000 records, it takes about 3 hours.
 

Environment

Release:
Component: ODPRD

Cause

The job should be processing at a rate of approximately 30,000 records per 10 minutes or less.

 

Resolution

The DBA can review the SQL being ran on the database server.
If needed, please contact the Support team to have the job stats profiled and reviewed.