Error when staging data "Error while parsing the expression. Make sure column names are valid in the expression and parentheses are balanced"

Products

• CA Capacity Manager

Issue/Introduction

Problem: 

Error received when staging data “Error while parsing the expression. Make sure column names are valid in the expression and parentheses are balanced”. See below screenshots of error from staging log. 

<Please see attached file for image>

<Please see attached file for image>

Environment:  

DM: 5.6, 5.7

CCC: 2.9, 2.9.2

Cause: 

The Data Manager data adapter is excepting the data files to be in English and US format. Other countries use comas in the place of periods(ie. 1.000 instead of 1,000) This causes errors when parsing the data for staging. 

Resolution:

Perform the below on the DM machine(Windows):

*Note: This fix requires a registry update, it is recommended that a backup of the Java registry folder below is made before any changes take place. 

1. Open registry edit(Start > search for 'Regedit')
2. Navigate to the following folderHKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Apache Software Foundation\Procrun 2.0\CA_CCC\Parameters\Java                          

   <Please see attached file for image>

   
3. Select the Options entry in the Java folder
4. In the Window add the below 2 lines
   1. -Duser.language=en
   2. -Duser.country=US

         

<Please see attached file for image>

 

 

      5. Restart Apache tomcat after making the registry change. 

      6. Stage the problem data source as normal. 

Environment

Release: VIRPLP99000-2.9-Virtual Placement Package
Component: