Dumb question but I will ask anyway. Is your DB view in a different schema from you Remedy schema? Maybe ARAdmin (I'm assuming that is your DB schema) has permission to query view 1 but doesn't have sufficient oracle permissions to query view 2?
On the AIE console go to "Database Field Menus" and try reloading the table/field definitions. That is the only other thing I can think of if the permissions are not correct. Thanks, Sean From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Rick Cook Sent: Monday, October 03, 2011 2:47 PM 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"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
