j.nn.aaaa in prompts

[Former Member]

Hello,

We are facing a strange problem.

When refreshing a report and choosing date from calendar then date format looks like this j.nn.aaaa

It happens when browser language settings are Estonian

when choosing language Finnish, then prompt looks like this - j.n.aaaa

Is anyone faced this issue?

With best,

Kristi

[Former Member]

Hi Kristi,

Could you please try the following solution.

Symptom

The locale (date/time format) of a report can be specified in multiple locations including at the report level and object level.

Cause

You are looking for one place to specify a format which will ignore specifically set formats.

Resolution

To effect a global change first you should make a back-up copy of the i18n.xml file on the server. You can edit the i18n.xml file using a text editor such Notepad as described below.

Symptom

The locale (date/time format) of a report can be specified in multiple locations including at the report level and object level.

Cause

You are looking for one place to specify a format which will ignore specifically set formats.

Resolution

To effect a global change first you should make a back-up copy of the i18n.xml file on the server. You can edit the i18n.xml file using a text editor such Notepad as described below.

In the i18n.xml file, at the end of this file, there is a section as follows:

- <activate_languages>

<state value="0" />

<State value="0" cs_lang="Bulgarian" />

<State value="0" orig_lang="*" cible_lang="Bulgarian" />

<State value="0" />

</activate_languages>

You can try editing this as follows:

- <activate_languages>

<state value="0" />

<State value="0" cs_lang="Bulgarian" />

<State value="1" orig_lang="*" cible_lang="Estonian" />

<State value="1" />

</activate_languages>

Regards,

Sarbhjeet Kaur

[Former Member]

Hello,

Thank you for replying so soon but unfortunately this change doesn't work

I made the suggested changes in the i18n.xml file, restarted CMS and tried to refresh my test report -> result is the same

With best,

Kristi

[Former Member]

hi Kristi,

could you please confirm that which version of BO you are using is it BOXIR3 or BOXIR2?

If it is BOXIR2 then test the issue on SP5 because this might be related to the adapt (ADAPT01100550).

Regards,

Sarbhjeet Kaur

[Former Member]

Hello,

We have BOXIR2 and SP5 is also installed

This ADAPT you suggested is about Performance Manager, I don't believe this is it, because I have take random language settings, finnish, albanian some issue. but works correctly in for example Swedish, English

ADAPT01100550

Description:

When Internet Explorer is set to use Estonian locales, the Performance Management preferences are displayed incorrectly.

New Behavior:

This problem is resolved.

Regards,

Kristi

[Former Member]

Hi Kristi,

This issue occurs because the browser is set to a non-supported language (Estonian in your case) it will work only when browser will support the Estonian langauge.

Regards,

Sarbhjeet Kaur

[Former Member]

Hi,

This sounds strange. we have several customers that use browser language set to Estonian and none of them are facing this issue

This must be something else but I can't put my finger on it

With best,

Kristi

Edited by: Kristi Kaljurand on Mar 17, 2009 3:40 PM

[Former Member]

Hi Kristi,

Could you please confirm that are you using the following workflow.

1- In Internet Explorer Options change language preference to Estonian

2- In Infoview go to Preferences and set option "My Interface locale is..." to "Use browser locale" and click Apply

3- Go to infoview and verify the prompt.

Regards,

Sarbhjeet Kaur

[Former Member]

Yes, that is correct. Can I upload any pictures?

Regards,

Kristi

[Former Member]

Hi Kristi,

I tested the issue on BOXIR2 SP5 after applying the following settings it is working for me.

Open the corresponding .PRM file on the following path.

C:\Program Files\Business Objects\BusinessObjects enterprise 11.5\win32_X86\DataAccess\connectionServer\

Edit the following parameters in the .Prm file

<Parameter Name="User_input dateformat"> {\d 'dd/mm/yyyy'}</Parameter>

<Parameter Langauge="ja" Name="USER_INPUT_DATE_FORMAT">{!d 'dd/mm/yyyy'}</Parameter>

After modification it should be like this.

<Parameter Name="User_input dateformat"> {\d 'j.aa.nnnn'}</Parameter>

<Parameter Langauge="ja" Name="USER_INPUT_DATE_FORMAT">{!d 'j.aa.nnnn' }</Parameter>

I hope this will help you.

Regards,

Sarbhjeet Kaur

[Former Member]

Hi,

which .prm file should I choose?

Regards,

Kristi

[Former Member]

Hi Kristi,

Open the universe on which you report is based.

Go to files->parameters->click on test button on definition tab->Then click on details.

There you will get the path for the corresponding .PRM file universe and reports are using.

Copy the path and paste it in browser and open the notepad with browser.

Regards,

Sarbhjeet Kaur

[Former Member]

I tested the issue on BOXIR2 SP5 after applying the following settings it is working for me.

Open the corresponding .PRM file on the following path.

C:\Program Files\Business Objects\BusinessObjects enterprise 11.5\win32_X86\DataAccess\connectionServer\

Edit the following parameters in the .Prm file

<Parameter Name="User_input dateformat"> {\d 'dd/mm/yyyy'}</Parameter>

<Parameter Langauge="ja" Name="USER_INPUT_DATE_FORMAT">{!d 'dd/mm/yyyy'}</Parameter>

After modification it should be like this.

<Parameter Name="User_input dateformat"> {\d 'j.aa.nnnn'}</Parameter>

<Parameter Langauge="ja" Name="USER_INPUT_DATE_FORMAT">{!d 'j.aa.nnnn' }</Parameter>

I hope this will help you.

Regards,

Sarbhjeet Kaur

Could you me more specific what did it solve?

I don't understand why I must change parameter to a format that I don't want

Regards,

Kristi

[Chrispri]

Hi Kristi,

Have you seen this case note: https://websmp230.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/sno/ui_entry/entry.htm?param=69765F6D6F6465...

It is for 3.1? I would think R2 will have the same fix hopefully in coming FP's.

Symptom

Error "Illegal pattern character 'x'" when picking date from calendar in Infoview if the product locale is set to any non-English locale which does not use the letter 'd' for 'day'. (E.g. Dutch gives no error because it uses 'd' for 'dag'.)

E.g. "Illegal pattern character 't'" for German locale ('t' being for 'Tag').

"Illegal pattern character 'j'" for French locale ('j' being for 'jour').

Reproducing the Issue

Under "Preferences" in Infoview, set the Product Locale to German.

Open a report with a date prompt.

Select any date from the calendar picker.

Error message appears: "Illegal Pattern Character "t " and the query will not run.

Business Objects XI 3.1 SP2

Cause

This has been confirmed as a bug (ADAPT01290945).

The fix is targeted for XI 3.1 SP2 Fixpack 2.2

This target is subject to the successful completion of regression testing.

FP 2.2 will be soon out.