IBM Support

Cannot create rotating assets

Technical Blog Post


Cannot create rotating assets


Today you decided that would create several assets with associated rotating items!

But it seems that "something" is conspiring against you! Opa

When you try to associate an asset to a rotating item that has a classification, you get the following error message:

BMXAA4187E - The relationship ASSETSPEC does not exist for business object ITEMSPEC.Verify that the relationship specified in the parameter ASSETSPEC exists in the Maxrelationship table

Then you look at the message and think:
"You again! This message that is often generic and does not really represent the problem" Zangado

Don't worry.... please read the procedure bellow: Piscar

1.) Go to System Configuration > Platform Configuration > Database Configuration application                                               
2.) Find for ITEMSPEC object                                            
3.) Go to Relationships tab                                             
4.) Find for ROTATINGASSETSPEC Relationship and make sure the Where Clause field is filled as follows:                                      
inheritedfromitem = 1 and classstructureid=:classstructureid and  assetattrid=:assetattrid and assetnum in (select b.assetnum from asset b where b.itemnum = :itemnum and assetspec.assetnum = b.assetnum and assetspec.siteid = b.siteid)                             
5) Click in New Row and complete the fields as follows:                 
Relationship = ASSETSPEC                                                
Child Object = ASSETSPEC                                                
Where Clause = (assetspec.inheritedfromitem = 'yes' and assetspec.classstructureid = itemspec.classstructureid and assetspec.assetattrid = itemspec.assetattrid)                           
6.) Save changes                                                        
7.) Try to create a new Asset.           

[{"Business Unit":{"code":"BU005","label":"IoT"}, "Product":{"code":"SSLKT6","label":"Maximo Asset Management"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":""}]