TDM: Localization Settings Cause Errors in WHERE clause

Document ID : KB000092640
Last Modified Date : 25/07/2018
Show Technical Document Details
Issue:
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://communities.ca.com/videos/5898-demo-how-to-open-a-support-case

You can download the latest version of TDM by following the directions in this document: https://support.ca.com/us/knowledge-base-articles.TEC1903942.html.   

To contact support, go to https://www.ca.com/us/services-support/ca-support/contact-support.html