This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
Not sure if you still need help or not, but I just did the same thing and
got the same error. You also need to export the lookups.xml and add a
line there. Also your Lookup value should not say valuelist, it should be
what is referenced in the Relationship. That's how I got over this one.
Also make sure the MAXLOOKUPMAP is referanced correctly. I got stumped on
which attribute whent in which field and actually miss-spelled one, which
caused it not to work. I did a search in google on MAXLOOKUPMAP and got a
good document that explained it well..
Hope it helps..
Brian Swanson
Systems Analyst-Maximo
Information Technology
HermanMiller
From: "hankinskeith@ymail.com" <keith.d.hankins@aexp.com>
To: MAXIMO@yahoogroups.com
Date: 06/16/2011 12:46 PM
Subject: [MAXIMO List] HELP! Need to create relationship assetnum
to assetnum - MAXLOOKUPMAP / Class
Sent by: MAXIMO@yahoogroups.com
Can anyone assist?
I need the ability to create multiple relationships between assets in
Maximo. For example, a server will have a Rack as a PARENT (no problem)
but will also need to have a relationship to two CDU's (a primary and a
secondary) both of which are assets in Maximo.
I've created the attributes ASSET.CDU1 and ASSET.CDU2. The lookup for
these attributes will be a Table Domain which I created and associated to
the attributes in database config.
In the application, I added VALUELIST to the lookup field. All working.
I also created a relationship in the ASSET table to each attribute. (I'll
just show one below)
CHILDOBJECT = ASSET
WHERECLAUSE = assetnum = :cdu1 and siteid = :siteid
In my application, the lookup is working but when I select a record I get
this error message...
"You have encountered an implementation or customization problem. Please
contact your system administrator to report this error. The system does
not know which attribute(s) of the current object are the foreign key(s)
to object ASSET. This information should be provided in MAXLOOKUPMAP table
or in the field validation class of CDU1."
So... I went to the MAXLOOKUP table and added the following:
ALLOWNULL = '1' LOOKUPATTRIBUTE = 'ASSETNUM' MAXLOOKUPMAPID = '901' SEQNUM
= '1' SOURCE = 'ASSET' SOURCEKEY = 'ASSETNUM' TARGET = 'ASSET' TARGETATT =
'CDU1'
but still get the same error...
Can anyone tell me what I'm doing wrong? Thanks in advance!
Keith