Hi,
WOACTIVITY is a database
view based on WORKORDER- it is not a table in its own right. That means that WOACTIVITY.DESCRIPTION is always as long as WORKORDER.DESCRIPTION. There is no way to change the length of one without it affecting the other, because it is essentially the same attribute.
If you want to increase the length, you will need to increase it in the WORKORDER table and WOACTIVITY will simply follow suit.
------------------------------
Fabian Selzer
------------------------------
Original Message:
Sent: Wed March 16, 2022 09:45 AM
From: Abdelrhaman Elwakeel
Subject: HOW TO UPDATE/CHANGE LENGTH FOR DESCRIPTION, WHICH IS READONLY IN DATABASE CONFIGURATION FOR OBJECT "WOACTIVITY"
Hi,
I used Data Loading from Access DB Microsoft to Maximo application, there some length value large than a length in attribute at Maximo, I used update length for attribute "description" in Object "woactivity" via SQL update in object maxattribute and maxattributecfg then restart the application Maximo, but the length did not work well. in sqldeveloper the length not have changed but in database configuration has changed and the application does not read correctly when the data updated.
Do you have one idea to solve the problem?
thanks
------------------------------
Abdelrhaman Elwakeel
------------------------------
#AssetandFacilitiesManagement
#Maximo