Good idea, Joe, but the problem is that it can't get to the point of even running any SQL. It won't connect to the data source to start the job. I am beginning to suspect a BMC issue.
Rick On Mon, Oct 3, 2011 at 12:27 PM, Joe Martin D'Souza <[email protected]>wrote: > ** > > That’s the strange thing that its working on Computer System but not on the > others.. > > Can you turn on SQL logging on the server that’s running these jobs and see > the difference in the SQL statements that are parsed during the jobs that > are successful and compare them to the ones that is unsuccessful? > > Joe > > *From:* Rick Cook <[email protected]> > *Sent:* Monday, October 03, 2011 3:20 PM > *Newsgroups:* public.remedy.arsystem.general > *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"_ > _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"
