Execute saved Query : error 38053 - Problem with the date format (fr_FR vs en_US)

0
Hello everyone,   I use the TCConnector module (version 2412.0225.0) to communicate with Teamcenter, and more specifically the function to interrogate a saved query to retrieve data. Everything works normally as long as I don't use a query with a date as a parameter. As soon as I query a query with a date as a parameter, I get no results, and I especially get the following error in the Teamcenter logs: UTC - INFO  - Teamcenter.SOA.Server                    - 044781B7DNONE - - 0BB14E87AR077 - Service Request:  Query-2008-06-SavedQuery:executeSavedQueries UTC - ERROR - Teamcenter.Search.qry                    - 044781B7DNONE - - 0BB14E87AR077 - 38053: Valeur spécifiée févr. n'est pas un mois valable. ifail is 38053 at E:/udu/tc143013_0127_865655wn/src/core/qry/attributedescriptor.cxx(3476) UTC - ERROR - Teamcenter.Search.qry                    - 044781B7DNONE - - 0BB14E87AR077 - 3006: Requête incorrecte . Failed to create enquiry at E:/udu/tc143013_0127_865655wn/src/core/qry/ImanQueryImpl.cxx(2411)   For your information, the default language of my application is French (fr_FR). And I understand that my error is related to my date format, but even trying to format it differently, I still get this error.   I can't change the default language of my application because it affects the format of the dates displayed on my various screens. Is it possible to force the date format so that Teamcenter can interpret it correctly?Or is it possible to connect to Teamcenter in en_US mode while keeping French as the default language of my application?   Thank you in advance for your help.
asked
3 answers
0

Hi Nicolas Pinaud,

 

Team Center has there own date parameter format and it understand the same only. if you pass anything other then the below format it will give error. 

 

YYYY-MM-DDTHH:mm:ss.SSSZ

 

For example, January 26, 2024, at 2:30 PM, in the Central European Time zone would be represented as 2024-01-26T14:30:00.000+01:00

answered
0

Sorry, here are the missing screenshots

 

The contents of my base date variable

Mendix_1.png

 

Setting the Java action

Mendix_2.png

 

The error encoutered is : the error encountered: Unable to parse date 2025-06-23 00:00:00.000

 

Can you tell me where the problem is?

answered
0

Hello everyone,

After further testing, I'm able to pinpoint exactly when the problem occurs.

When my application's default language is "French, France" (fr_FR), the date parameter in my query is not interpreted correctly by Teamcenter.

When my application's default language is "English, United States" (en_US), the date parameter in my query is interpreted correctly by Teamcenter.

The problem therefore stems from my application's default language.

 

I've tried formatting my date multiple times, but it doesn't change anything.

Does anyone have any ideas on how to resolve my problem?

answered