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

book

Article ID: 37594

calendar_today

Updated On:

Products

CA Capacity Manager CA MICS Resource Management

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>

Error2.PNG

<Please see attached file for image>

Error1.PNG

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>

    Regedit.PNG
  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>

Regedit2.PNG

 

 

      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:

Attachments

1558723732886000037594_sktwi1f5rjvs16wyx.png get_app
1558723731212000037594_sktwi1f5rjvs16wyw.png get_app
1558723729466000037594_sktwi1f5rjvs16wyv.png get_app
1558723727608000037594_sktwi1f5rjvs16wyu.png get_app