Troubleshooting
Problem
When using a data restriction on the Companies object in an environment with multiple languages, a company created (and visible) in one language cannot be seen when using a secondary language
Symptom
1) Log on to Maximo as maxadmin in the server's base language (in this case English)
2) Go To Administration -> Conditional Expression Manager
3) Click on New Row
4) Enter
5) Click on Save Condition
6) Go To Security -> Security Groups and select a Security Group (e.g. maxadmin) and click on Data Restrictions
7) Click on New Row in the Objects tab and create an Object Restriction on the COMPANIES object referencing the condition created above
8) Click on Save Group
9) Log off/on
10) Create some Companies in the Companies or Company Master application (and add to Organization)
11) Go To Work Orders -> Work Order Tracking and select a Work Order
12) Page down to the Responsibility section and click on Select Value for Vendor
13) Note the we see the expected list of Companies
14) Log off and log back on in a Secondary language (in this case French)
15) Go To Work Orders -> Work Order Tracking and select a Work Order
16) Page down to the Responsabilité section and click on Selectionner une valeur for Fournisseur
17) Note that the list of Companies is empty
18) An exception similar to this might be seen in SystemOut.logcom.ibm.db2.jcc.am.SqlSyntaxErrorException: A reference to column "NAME" is ambiguous.. SQLCODE=-203, SQLSTATE=42702, DRIVER=4.11.69
Log InLog in to view more of this document
Was this topic helpful?
Document Information
Modified date:
18 September 2025
UID
swg22010794