Resource XOG is slower after upgrade to 16.4.1 with DWH Sync Enabled
search cancel

Resource XOG is slower after upgrade to 16.4.1 with DWH Sync Enabled

book

Article ID: 445227

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

When using a large XOG with Resource and Contact information, there is a notable difference between 16.3.3 and 16.4.1 due to additional attributes added for DWH when DWH Sync is enabled

STEPS TO REPRODUCE:

  1. Make sure you enable DWH Instantaneous Sync in System Options
  2. Build a resource XOG write file with a large set of existing resources
  3. Make sure the XOG is populated with contact/supplemental fields mapping to res_job_title, res_address, res_phone, res_url (see attached) 7-10K resources sync
  4. XOG in the file and record elapsed type
  5. Compare against 16.3.3 - or against the same 16.4.1 instance is markedly slower.

Expected Results: the XOG to complete within a similar amount of time as in 16.3.3

Actual Results: XOG is significantly slower and the time correlates with the amount of resources

 

Environment

Clarity 16.4.1, 16.4.2

Cause

DE207050

Resolution

In Review by Engineering

Powered by Wolken Software