I guess as a cheap test, you could reconfigure Computer System to pull from the other data set's DB view and see if that works?
Tauf Chowdhury | Forest Laboratories, Inc. Service Portfolio Manager Infrastructure - Service Management Office: 631.858.7765 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Cook Sent: Monday, October 03, 2011 3:20 PM To: arslist@ARSLIST.ORG Subject: Re: AIE error on Relationship Class Mapping ** I can see the fields in the DB view just fine when building or modifying the Mappings, and I just re-verified (through AIE DB Field Menu console) that the Connection is good. Again, we are using this same set of connection parameters and DB view to successfully bring over CIs into one CMDB class. We are just having issues with the others. Rick On Mon, Oct 3, 2011 at 12:12 PM, Joe Martin D'Souza <jdso...@shyle.net> wrote: ** Have you tried refreshing the table after the connection with AIE is made? Do you see the columns in the column list field?? If you cannot see those columns in that list you may want to check on the data type of those columns in the external table. They might not be compatible with your current version and install of the AR System.. Joe From: Rick Cook <mailto:remedyr...@gmail.com> Sent: Monday, October 03, 2011 2:47 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: AIE error on Relationship Class Mapping ** We have several CI Class Mappings set up to pull data from an external DB view. We can pull in the Computer System data just fine, but none of the System Component (i.e. Disk Drive, OS) tables will work at all, even when run manually and individually. The error message we are seeing - for all fields in all relationship forms - is this: *** Field Mapping Error for <field name> --> Column <fieldname> not defined in table '<DBVIEWNAME>' The column names are most certainly defined in the DB view, because that's what I used to build the mappings in the first place. The fact that we get that message for every field on every form *except* ComputerSystem tells me that it is likely a connectivity error, but we are using the same connection parameters for all of the mappings and connections. We can't see any significant setup differences between what is working and what isn't. Has anyone seen this before? ARS/ITSM/AIE 7.6.04 SP1 Linux/Oracle Rick _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ ********************************************************************** This e-mail and its attachments may contain Forest Laboratories, Inc. proprietary information that is privileged, confidential or subject to copyright belonging to Forest Laboratories, Inc. This e-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this e-mail, or the employee or agent responsible for delivering this e-mail to the intended recipient, you are hereby notified that any dissemination, distribution, copying or action taken in relation to the contents of and attachments to this e-mail is strictly prohibited and may be unlawful. If you have received this e-mail in error, please notify the sender immediately and permanently delete the original and any copy of this e-mail and any printout. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"