Load DWH job fails with syntax error on currency_precision

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Load Data Warehouse fails with syntax error on updating currency_precision.

Update Config Settings - An error occurred executing this job entry : Couldn't execute SQL: UPDATE DWH_CFG_SETTINGS SET LANGUAGE_CODE_KEY = 1, LANGUAGE_CODE = 'en',     CURRENCY_PRECISION = 0,0,     WEEK_START_DAY = 1,

ERROR: error de sintaxis en o cerca de «0»

  Position: 114

Environment

Release : Any Clarity environment with a non-US locale

Cause

The Load DWH is trying to set CURRENCY_PRECISION which is not a whole number "0,0"

Resolution

Set the App server locale to United States

1. Set the Clarity app server to region and locale United States (more details here)
2. In both Control Panel - Region and Windows Settings
3. Save and reboot the entire server
4. Repeat for other servers in cluster

If this doesn't help, the locale isn't being picked up correctly. Try the below workaround:

Change the JVM parameters to force a US locale.

1. Open the properties.xml
2. For app and bg service JVM, add the following JVM parameters:
   -Duser.country=US -Duser.language=en
   
   Example:
3. Save and restart all services