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 <tauf.chowdh...@frx.com>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: > 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 <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. > _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"