hi @JuniSihombing,

Since the issue is mentioned as the ‘102:Incorrect syntax near 'EN'’,  I have tried to execute the below query(same query in your exception) to check where the issue is.

As you can see, I am getting the same error during the execution of the above code. The issue of this code is below reasons.

1. Inverted commas which are defined in the local_code section are not equal
2. There are some spaces before the EN-US.

By removing and fixing the above mentioned issues, the below query was working fine.

So, it seems there are some places which using this query created some unwanted spaces, inverted commas. (You need to check and investigate the specific place where this error is coming from)

Please note that this is just an assumption in this case.

Thanks and regards,

Hasara

Hi @Hasara Dinu

the data in locale-code looks correct.  And there are no double entries.

 Length of code value reflects the number of characters in code-value. 

Hi @JuniSihombing,

Could you please check below approach?

hi @JuniSihombing,

Since the issue is mentioned as the ‘102:Incorrect syntax near 'EN'’,  I have tried to execute the below query(same query in your exception) to check where the issue is.

As you can see, I am getting the same error during the execution of the above code. The issue of this code is below reasons.

1. Inverted commas which are defined in the local_code section are not equal
2. There are some spaces before the EN-US.

By removing and fixing the above mentioned issues, the below query was working fine.

So, it seems there are some places which using this query created some unwanted spaces, inverted commas. (You need to check and investigate the specific place where this error is coming from)

Please note that this is just an assumption in this case.

Thanks and regards,

Hasara

Thanks,

Hasara

Hi @Hasara Dinu,

understood that the query returns error because of not correct statement.

The question, what causes the query returns when doing the cache refresh.  

You mentioned: (You need to check and investigate the specific place where this error is coming from)  » this is the intention of my post :-)   How can I check and investigate the specific place where the error is coming.  Entry of locale-code is correct, but error  occurs when doing cache refresh. ;-)

I have tried to increase the exception, information, BR level of server log, but don’t see any other exception unless that message..

Any other idea how to check and investigate?

Best regards,

~Juni

Hi @JuniSihombing 

Since the issue is coming from the baseline fsm message translations (metrix_message_def), you might need to raise a support case to have a look on this, unless if you haven’t done any changes to metrix_message_def data forcefully. Most likely this looks to be a bug, if this is replicated on the other environments. What is the fsm version that you’re using here?

Hi Saranga,

it’s not replicated on other environments.  It’s only on DEV.

What I also notice, cache refresh for webclient version on DEV is also very slow.

We use FSM6U16.

~Juni

Just a guess - try this query: select distinct locale_code from person.  If you get more than one that looks like EN-US, then you’ve got bad data.  Maybe someone was doing bad things by updating the database directly.

Hi @brian.gummin,

the locale_code(s) are all correct.