Seeing how other users are adding new attribute to Asset Classification.  Since when you add a new attribute, Maximo tries to add that to all Asset using that classification, which takes a long time and times out or errors out from UI.  I have tried flat file load on that Classification from External System and through the Flat File consumer cron task.  The external system does the same where it times out or errors out and the Flat File consumer will error out due to SQL time out and I have to run it multiple times.  Any suggestion would be appreciated.

------------------------------
Teng Moua
------------------------------

#AssetandFacilitiesManagement
#Maximo

If you have more than 3000 assets with that classification and are on SQL Server, consider enabling the system property mxe.app.assetcat.addAttributeforSQLServer. This turns it into direct insert statements instead of using MBOs which should be significantly faster. DB2/Oracle will automatically perform inserts when you're beyond 3000 records. I'm not sure why we decided on 3000 records and have it hardcoded.

------------------------------
Steven Shull
------------------------------

Original Message:
Sent: Wed December 21, 2022 05:02 PM
From: Teng Moua
Subject: Adding new attribute to Asset Classification

Seeing how other users are adding new attribute to Asset Classification.  Since when you add a new attribute, Maximo tries to add that to all Asset using that classification, which takes a long time and times out or errors out from UI.  I have tried flat file load on that Classification from External System and through the Flat File consumer cron task.  The external system does the same where it times out or errors out and the Flat File consumer will error out due to SQL time out and I have to run it multiple times.  Any suggestion would be appreciated.

------------------------------
Teng Moua
------------------------------

#AssetandFacilitiesManagement
#Maximo

When adding new attribute, uncheck "Use classification". After adding new attribute to classivication, check it again. Then new attribute won't be added to existing records.

To add attibutes, I recommend to use MX Loader bu Bruno Portaluri https://bportaluri.com/mxloader , and add them row by row, enebling attribute in loader

Split Child Rows

TRUE

------------------------------
Juris Flugins
------------------------------

Original Message:
Sent: Wed December 21, 2022 05:02 PM
From: Teng Moua
Subject: Adding new attribute to Asset Classification

Seeing how other users are adding new attribute to Asset Classification.  Since when you add a new attribute, Maximo tries to add that to all Asset using that classification, which takes a long time and times out or errors out from UI.  I have tried flat file load on that Classification from External System and through the Flat File consumer cron task.  The external system does the same where it times out or errors out and the Flat File consumer will error out due to SQL time out and I have to run it multiple times.  Any suggestion would be appreciated.

------------------------------
Teng Moua
------------------------------

#Maximo
#AssetandFacilitiesManagement