Hello Abdelrahman!
WOACTIVITY is actually a view of the WORKORDER table...Maximo DB configuration will not allow you to modify the attributes of a view if they originate from a parent table. So, in order to increase the size of the DESCRIPTION column, you would need to modify it at the WORKORDER object (which then will be available on WOACTIVITY (and also all other views that sit on top of WORKORDER)).
Cheers,
Jade
------------------------------
Jade Warren
Great River Energy
------------------------------
Original Message:
Sent: 03-15-2022 11:54
From: Abdelrahman Elwakeel
Subject: How to update/Change Length for description, which is read only in Database Configuration for object "woactivity"
Hi,
I used Data Loading from Access DB Microsoft to Maximo application, there some length value large than 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 not work well. in sqldeveloper the length not have changed but in database configuration have changed and the application not read correct when the data update.
Do you have one idea to solve the problem?
thanks
#Administration
#Infrastructure
------------------------------
Abdelrahman Elwakeel
smartsystemeg.com
------------------------------