IBM Support

"Attribute CONTENTUID does not exist."

Troubleshooting


Problem

Unable to enable MLS for Measure Unit Description

Diagnosing The Problem

The following step by step have been used to reproduce the problem in SCCD 7.5

1. Go to Database Configuration, Select Object MEASUREUNIT


2. On "Object" Tab, Populate
Language Table = L_MEASUREUNIT
Language Column = LANGCODE

3. On "Attributes" Tab, Select "Description", Check "Multilanguage in Use"
4. Save and Run DB Config
5. Login as a user whose Language is set to a non-english language.
6. Go to "Administration"-> Classification
7. Select Action "Add Unit of Measure" 8. Edit and existing UOM or any other description.

Expected Result:
You should be able to enter a description for a UOM in a foreign
language while preserving English description for English speaking users

Actual Results :
You get an error "Attribute CONTENTUID does not exist."

Resolving The Problem

The problem is that the contentattribute is copied from the main table, to solve this problem run the following update:

update maxtable set contentattribute = null where tablename = 'L_MEASUREUNIT';
update maxtablecfg set contentattribute = null where tablename = 'L_MEASUREUNIT';
Unfortunately this is a buffered value so a restart of MXServer is needed.
Then please run the following to see if there are any other problematic tables,
select * from maxtable where contentattribute is not null and islangtable = 1;

[{"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Not Applicable","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"7.1;7.1.1;7.2.1;7.5","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}},{"Product":{"code":"SSWT9A","label":"IBM Control Desk"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}},{"Product":{"code":"SSKTXT","label":"Tivoli Change and Configuration Management Database"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}},{"Product":{"code":"SS6HJK","label":"Tivoli Service Request Manager"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
17 June 2018

UID

swg21650316