What is the purpose and impact of the “Localizable” field property?

I’m seeing issues within report results, where if the user profile language is in US English, the results are of one type, but if the user profile language is in German, it is showing some other data. The record while checked is the same for both cases. While opening and checking the record, the ID and name of the record varies from what it showed as a result in the report. While investigating, what we observed is that these fields are marked as “Localizable” in Data Modeler. What is the use and impact of the “Localizable” field property? Any suggestions?

Here is a PDF link to the 3.5.3 Globalization (Localization) user guide. Also, perhaps this technote on localized database storage will help provide some insight.

[Admin: The same question is also posted in the main Application Platform forum. To see other related posts, use the Localization tag or Language tag.]

Advertisements

IV96374: Various non-US English users get “An Error Occurred”

Various existing users with non-US English language profiles are getting the following error when they click on the System tab on each form:

An Error Occurred. Contact your System Administrator. – [MID-3402867005]

When translating object references, the platform needed to catch the “smart object not found” error, and follow the path as if it was non-translated. Moving forward, when invalid data is contained in a reference field (like System Geography), the platform will no longer throw a MID error, and will now show the field as blank, since the referenced record does not exist.

IV95XXX: Multiple APARs on Section 508 compliance for web

IV95219: Section 508 compliance for TRIRIGA login page
Visually impaired users dependent on Section 508 compliance to use TRIRIGA may run into a problem in the login page. They might have difficulty in navigating to enter the ID and Password.

IV95289: Section 508 compliance in Projects page
Keyboard access, style sheet dependence, language, page titles, and images for Section 508 compliance fail test on Projects tab.

IV95290: Section 508 compliance in My Reports page
Keyboard access, web forms have invalid HTML, web links, and user controls. Images have no description in plain text.

[Admin: This post is related to the 10.17.16 post about multiple APARs on Section 508 compliance.]

Why aren’t tasks always showing up in tabular metric reports?

Our client’s tabular metric reports, which are set to show the tasks of service requests, seem to have some issues. Although the tasks are found by the report, they don’t always show up or aren’t displayed on the list.

Here are two examples below: (1) In the first case, 6 tasks are found, but only 2 of them show up. (2) In the second case, 3 tasks are found, but none is displayed. Any ideas on what could be happening?

[Updated 05.03.17]

It seems that the user’s language (set in his profile) and the existence of a contract for the tasks affect their visibility one way or another on the tabular report. Here’s an example below: (1) When the user’s language is set to EN (English), all of the tasks show up fine. (2) When the user’s language is set to FR (French), only tasks which have a contract show up (in this case, only 1) even though all 8 are found…

How are currencies handled in a globalized TRIRIGA environment?

IBM TRIRIGA made vast improvements in the globalization of currencies starting with TRIRIGA Application Platform 3.4.2. If you are on a platform version before 3.4.2, we urge you to upgrade to the most current version to take advantage of these enhancements. For the enhancements to work correctly, you must update your environment after you upgrade your platform. The following discussion highlights globalization areas to review after upgrade:

• User Language: A language is defined in each user’s profile record. The language establishes the locale of the user…
• User Currency: A currency is defined in each user’s profile record. When a user creates a record that includes a currency UOM…
• UOM Value: Currency UOMs are defined in the Unit of Measure (UOM) values, which are found in Tools > Administration > Unit of Measure (UOM) > Values…
• Language Code: Review the language codes in Tools > Administration > Globalization Manager > Language Code to ensure that they are correct for your company…

[Admin: To see other related posts, use the Currency tag or Globalization tag.]

IV93507: Running query executes multiple calls to IBS_SPEC table

Running queries for non-base language users (such as British English) will execute multiple calls to the IBS_SPEC table unnecessarily.

We needed changes in platform to cache many of the frequently-hit items in Classifications and My Profile, so that it reduces pressure on IBS_SPEC. Moving forward, the IBS_SPEC table is no longer queried multiple times when Classifications are included in reports. Classifications are considered metadata and the values will now be cached for a default of 24 hours.

[Admin: This post is related to the 02.20.17 post about a query generating multiple SQL statements when the user is in British English.]

IV93471: Changing language of “System-Help” form breaks help

Changing the language of the “System-Help” form breaks it…

This is because the new language is appended to the end of the publish name. This means that when it looks for the publish name of “System-Help”, it can’t find it. Additionally, changing it back to US English does not resolve the problem, since it appends yet another language name to the publish name.