TDM: Localization Settings Cause Errors in WHERE clause

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

While profiling in the TDM Portal, this error condition is displayed in the log file:
 An expression of non-boolean type specified in a context where a condition is expected, near ','.
 

Environment

TDM  Portal 4.5

Resolution

Why this happens:
Differences in English and other European languages like Italian, Dutch etc..
In English the period is used, however in Italian a comma is used.
Which causes a problem and that is what the error message states.

Steps to resolve:
 1. Go to C:\Program Files\CA\CA Test Data Manager Portal\service\conf\wrapper.conf
  2. Click on wrapper.conf (take a back up thought) and open it on the editor
  3. Go to Java Additional parameters.
      Paste the following after 8
           wrapper.java.additional.9=-Duser.country=US
           wrapper.java.additional.10=-Duser.language=en
  4. Re-start the Portal service from services.msc screen

Additional Information

Video URL on how to open a Support Case - https://community.broadcom.com/groups/viewdocument/demo-how-to-update-a-case-with-ca?CommunityKey=c475a143-13f8-4809-b469-d8541b80ea91&tab=librarydocumentshttps://communities.ca.com/videos/5898-demo-how-to-open-a-support-case

To contact support, go to https://support.broadcom.com/