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;
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg21650316