SQL Curves - Known Issues

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Known issues related to the SQL Curve functionality introduced in 15.9.1. 

Note: There have been a number of issues fixed in 15.9.3 and higher, so it's recommended to be on the latest GA release. 

Resolution

Table of Contents

• Fixed in 16.0.0
• Fixed in 15.9.3 and 15.9.2 Patch #1 (15.9.2.1)
• Fixed in 15.9.2
• Slow Job Performance
• Enable or Disable SQL Curves

Fixed in 16.0.0

• [DE60813] Database deadlock/slowness post upgrade to 15.9.1 
• [DE62122] Time Slicing deadlocks on multiple tables on PostgreSQL (GCP)

Fixed in 15.9.3 and 15.9.2 Patch #1 (15.9.2.1)

• [DE60926] Investment Allocation crashes BG with OOM due to SQL Curves 
• [DE60061] Time Slicing job slow on 15.9.1+ due to SQL Curves
  • Caused by [DE60061] Slow Update Earned Value and Cost Totals Job Performance with SQL Curve 
• [DE61044] Per Period Metrics: 'An Exception occurred...' due to Deadlock with Time Slicing 

Fixed in 15.9.2

• [DE59946] Per Period Metrics TSV Actuals and some ETCs missing - also fixed in 15.9.1 Patch #1 (15.9.1.1)
• [DE59946] Time slicing job fails with Arithmetic overflow error post upgrade  - also fixed in 15.9.1 Patch #1 (15.9.1.1) 
• [DE59899] Error When Create/Copy Cost Plan - NK_PARSE_CURVE_FCT 

Slow Job Performance

• SQL Curves null out queries - For On-Premise customers not using the Modern UX yet 

Enable or Disable SQL Curves

• Enable or disable the SQL Curve feature toggle
  • This feature should typically only be disabled if recommended by Broadcom support as a workaround for an issue.
  • There have been a number of issues fixed in later GA releases, so it's recommended to upgrade to the latest GA release where possible to avoid any issues / prevent the need of disabling this feature.
  • If using the Modern User Experience, it is not recommended to disable this as doing so can impact some data displayed

Additional Information

See also: 'Time Slicing Sync' job - Master KB