TDM: Localization Settings Cause Errors in WHERE clause
Article ID: 92640
CA Test Data Manager (Data Finder / Grid Tools)
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 ','.
TDM Portal 4.5
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
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/