Technical Blog Post
Abstract
Cannot create rotating assets
Body
Today you decided that would create several assets with associated rotating items!
But it seems that "something" is conspiring against you!
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"
Don't worry.... please read the procedure bellow:
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.
UID
ibm11130241