Well, I am always in favor of abstract thought, but the problem doesn't appear to be with anything related to the CMDB - it is AIE trying to access the external data source. I think I will open an issue with BMC and see what they say.
Thanks, guys, and I will report back whatever the fix might end up being! Rick On Mon, Oct 3, 2011 at 1:01 PM, Joe Martin D'Souza <[email protected]>wrote: > ** > > Try something a little different then if you have the liberty to.. Try > modifying one of the class that doesn’t work.. Add a field/attribute, some > field that you may not find use for now but may later, eg. Number of > reported Breakdowns.. This might be the type of information that you > currently don’t use but might find use for in some later projects.. Then > reload the definitions.. See if that helps.. > > Joe > > *From:* Rick Cook <[email protected]> > *Sent:* Monday, October 03, 2011 3:42 PM > *Newsgroups:* public.remedy.arsystem.general > *To:* [email protected] > *Subject:* Re: AIE error on Relationship Class Mapping > > ** All CMDB forms in play are being populated from the same DB view, Tauf. > That's the weird part - parameters that work in one place don't work in > another. Every connectivity check passes, and I can see no place where the > data seems inaccessible. > > > And Joe, ALL fields in those other forms are returning errors. If it were > a portion of them, I would have jumped on that like a free beer. > > Rick > > On Mon, Oct 3, 2011 at 12:30 PM, Chowdhury, Tauf > <[email protected]>wrote: > >> ** >> >> 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? **** >> >> **** >> >> *T**auf** **C**howdhury** **|** **F**orest** **L**aboratories**, **I**nc. >> *** >> >> Service Portfolio Manager**** >> >> Infrastructure – Service Management**** >> >> Office: 631.858.7765**** >> >> **** >> >> *From:* Action Request System discussion list(ARSList) [mailto: >> [email protected]] *On Behalf Of *Rick Cook >> *Sent:* Monday, October 03, 2011 3:20 PM >> *To:* [email protected] >> *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 <[email protected]> >> 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 <[email protected]> **** >> >> *Sent:* Monday, October 03, 2011 2:47 PM**** >> >> *Newsgroups:* public.remedy.arsystem.general**** >> >> *To:* [email protected] **** >> >> *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. >> _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ >> > > _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ > _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
