Maximo Open Forum

Greetings,

 

We are unable to move PM Work Order status to Complete on a large number of PM work orders with attachments.

 

With attachment(s) on the PM or related object, we are getting this error when we try to  change status on a PM work order status from techcomplete to complete.

 

From production:

BMXAA4129E - The record for Owner Table=COMMLOG, Owner ID=1,631,335, Docinfo ID=805, Document Folder=Attachments already exists. Ensure that the key value for the given record is unique.

 

We are on a SaaS instance, so we are unable to see our database.  To make any desired changes (or see data), we submit SQL to FedRamp for execution.  Our system info = Maximo Asset Management 7.6.1.3 Build 20220823-0909 DB Build V7611-01IoT

 

Does anyone have suggestions on how to overcome the BMXAA4129E error?  

 

All help and pointers will be greatly appreciated…

 

Thank you,

 

John 

#Administration
#Infrastructure
#WorkManagement

------------------------------
John Rose
USDA
------------------------------

John,

I am not positive if this is what you are experiencing or not, but one possibility is when more than one "Attachments" Document Folder is selected under the "Send with Communication?" Column on the "Attachments" Folder Tab for your Communication Template.

If you look at the screenshot below, you will see that all three Check Boxes for the "Attachments" Document Folder for the Main and Cloned Work Order Tracking Applications are Selected.

All three of these Applications point to the same Owner Table when the row is added to the COMMLOG Object, the WORKORDER Object.  The Owner ID/Owner Table (1,631,335/WORKORDER) is only needed once.  There should only be one of these "Attachments" Document Folder options checked in this situation, not all three.

Check and see if there is a Communication Template that might be associated with the process of "Completing a PM Work Order". Maybe certain individuals had requested an email for when a PM Work Order is completed?  If you can locate the Template, check and see if there are multiple Check Boxes Selected for the same Application Family, and the same Folder Type, relating to Work Order Tracking.

I hope this helps.

------------------------------
Steve Platt
Maximo Administrator
Georgia Building Authority
------------------------------