Re: Issue with AIE and Oracle
Chris, Is this when you are trying to do a data exchange to an ar form, such as the people one? Or just anything in the CMDB? Thanks, hbr On Sat, Jun 21, 2008 at 10:52 PM, strauss [EMAIL PROTECTED] wrote: ** The bugfix they sent me for patch 2 makes it possible to query against a condition on the AR Server – in my case it was in the Query tab, Data Key Query tab, AR Form Query where I had $Corporate ID Right$ = 0 as a condition for the data exchange to run. This was not a problem in 7.1 or patch 001, and is supposed to be fixed in patch 003, but if this is your problem BMC has a hotfix for the problem… a newer eie.exe and two dlls. The oradpr.dll was one of the changed files (the sql server adapter was not). Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Brian Gillock *Sent:* Saturday, June 21, 2008 4:50 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Issue with AIE and Oracle ** Hey Howard, I'm afraid I don't have any tidbits regarding Oracle, but having been brutalized by the AIE over the past 3 days, I can tell you that patch 2 isn't very cooperative. I have finally had success by dropping back to patch 1. This may not help you, but I figured it can't hurt to share my experience. Good Luck! Brian *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Howard Richter *Sent:* Saturday, June 21, 2008 2:27 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Issue with AIE and Oracle ** Happy weekend to all, I have tried everything I can think of and BMC as well, it might be a bug of some kind. Using the command line it work. I will post was BMC comes back with. Howard On Thu, Jun 19, 2008 at 6:08 PM, Joe DeSouza [EMAIL PROTECTED] wrote: ** Have you entered your oracle configurations correctly in the helper utility that is bundled with AIE? Oracle home, SID, username, password?? Joe - Original Message From: Howard Richter [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Thursday, June 19, 2008 9:49:51 AM Subject: Issue with AIE and Oracle ** Good morning all, I have the newest release of AIE and I am trying to get it to talk to a remote oracle database. The Server is 7.1 patch 3 and using MSSQL. I have installed the 10g client and can talk to the remote Oracle system using sqlplus from the box where the arserver is running. There is nothing in any log that I can find, that shows any attempt of the AIE trying to connect to the Oracle database. I did try setting up the AIE to talk to a MSSQL database and that worked. I am starting to wonder if, you can only talk to a database that the server talks to (for example in my case only MSSQL, since that is what the server is talking to). Any ideas, as of yet BMC support has had non. Howard -- Howard Richter Red Hat Certified Technician CompTIA Linux+ Certified ITIL Foundation Certified E-Mail = [EMAIL PROTECTED] LinkedIn http://www.linkedin.com/ Profile = http://www.linkedin.com/in/hbr4270 __Platinum Sponsor: www.rmsportal.comARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ -- Howard Richter Red Hat Certified Technician CompTIA Linux+ Certified ITIL Foundation Certified E-Mail = [EMAIL PROTECTED] LinkedIn Profile = http://www.linkedin.com/in/hbr4270 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ -- Howard Richter Red Hat Certified Technician CompTIA Linux+ Certified ITIL Foundation Certified E-Mail = [EMAIL PROTECTED] LinkedIn Profile = http://www.linkedin.com/in/hbr4270 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Issue with AIE and Oracle
To an AR staging form or any other existing AR form where you used a qualification to limit the scope of the data exchange. I don't know if it similarly affects CMDB forms, but I would expect it to. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Howard Richter Sent: Sunday, June 22, 2008 10:27 AM To: arslist@ARSLIST.ORG Subject: Re: Issue with AIE and Oracle ** Chris, Is this when you are trying to do a data exchange to an ar form, such as the people one? Or just anything in the CMDB? Thanks, hbr On Sat, Jun 21, 2008 at 10:52 PM, strauss [EMAIL PROTECTED] wrote: ** The bugfix they sent me for patch 2 makes it possible to query against a condition on the AR Server - in my case it was in the Query tab, Data Key Query tab, AR Form Query where I had $Corporate ID Right$ = 0 as a condition for the data exchange to run. This was not a problem in 7.1 or patch 001, and is supposed to be fixed in patch 003, but if this is your problem BMC has a hotfix for the problem... a newer eie.exe and two dlls. The oradpr.dll was one of the changed files (the sql server adapter was not). Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Brian Gillock Sent: Saturday, June 21, 2008 4:50 PM To: arslist@ARSLIST.ORG Subject: Re: Issue with AIE and Oracle ** Hey Howard, I'm afraid I don't have any tidbits regarding Oracle, but having been brutalized by the AIE over the past 3 days, I can tell you that patch 2 isn't very cooperative. I have finally had success by dropping back to patch 1. This may not help you, but I figured it can't hurt to share my experience. Good Luck! Brian From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Howard Richter Sent: Saturday, June 21, 2008 2:27 PM To: arslist@ARSLIST.ORG Subject: Re: Issue with AIE and Oracle ** Happy weekend to all, I have tried everything I can think of and BMC as well, it might be a bug of some kind. Using the command line it work. I will post was BMC comes back with. Howard On Thu, Jun 19, 2008 at 6:08 PM, Joe DeSouza [EMAIL PROTECTED] wrote: ** Have you entered your oracle configurations correctly in the helper utility that is bundled with AIE? Oracle home, SID, username, password?? Joe - Original Message From: Howard Richter [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Thursday, June 19, 2008 9:49:51 AM Subject: Issue with AIE and Oracle ** Good morning all, I have the newest release of AIE and I am trying to get it to talk to a remote oracle database. The Server is 7.1 patch 3 and using MSSQL. I have installed the 10g client and can talk to the remote Oracle system using sqlplus from the box where the arserver is running. There is nothing in any log that I can find, that shows any attempt of the AIE trying to connect to the Oracle database. I did try setting up the AIE to talk to a MSSQL database and that worked. I am starting to wonder if, you can only talk to a database that the server talks to (for example in my case only MSSQL, since that is what the server is talking to). Any ideas, as of yet BMC support has had non. Howard -- Howard Richter Red Hat Certified Technician CompTIA Linux+ Certified ITIL Foundation Certified E-Mail = [EMAIL PROTECTED] LinkedIn http://www.linkedin.com/ Profile = http://www.linkedin.com/in/hbr4270 __Platinum Sponsor: www.rmsportal.com http://www.rmsportal.com/ ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com http://www.rmsportal.com/ ARSlist: Where the Answers Are html___ -- Howard Richter Red Hat Certified Technician CompTIA Linux+ Certified ITIL Foundation Certified E-Mail = [EMAIL PROTECTED] LinkedIn Profile = http://www.linkedin.com/in/hbr4270 __Platinum Sponsor: www.rmsportal.com http://www.rmsportal.com/ ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com http://www.rmsportal.com/ ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com http://www.rmsportal.com/ ARSlist: Where the Answers Are html___ -- Howard Richter Red Hat Certified Technician CompTIA Linux+ Certified ITIL Foundation Certified E-Mail = [EMAIL PROTECTED] LinkedIn Profile = http://www.linkedin.com/in/hbr4270 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Issue with AIE and Oracle
Have you installed the Oracle Link? -Original Message- From: strauss [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Sun, 22 Jun 2008 12:56 pm Subject: Re: Issue with AIE and Oracle ** To an AR staging form or any other existing AR form where you used a qualification to limit the scope of the data exchange. I don’t know if it similarly affects CMDB forms, but I would expect it to. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Howard Richter Sent: Sunday, June 22, 2008 10:27 AM To: arslist@ARSLIST.ORG Subject: Re: Issue with AIE and Oracle ** Chris, Is this when you are trying to do a data exchange to an ar form, such as the people one? Or just anything in the CMDB? Thanks, hbr On Sat, Jun 21, 2008 at 10:52 PM, strauss [EMAIL PROTECTED] wrote: ** The bugfix they sent me for patch 2 makes it possible to query against a condition on the AR Server – in my case it was in the Query tab, Data Key Query tab, AR Form Query where I had $Corporate ID Right$ = 0 as a condition for the data exchange to run. This was not a problem in 7.1 or patch 001, and is supposed to be fixed in patch 003, but if this is your problem BMC has a hotfix for the problem… a newer eie.exe and two dlls. The oradpr.dll was one of the changed files (the sql server adapter was not). Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Brian Gillock Sent: Saturday, June 21, 2008 4:50 PM To: arslist@ARSLIST.ORG Subject: Re: Issue with AIE and Oracle ** Hey Howard, I'm afraid I don't have any tidbits regarding Oracle, but having been brutalized by the AIE over the past 3 days, I can tell you that patch 2 isn't very cooperative. I have finally had success by dropping back to patch 1. This may not help you, but I figured it can't hurt to share my experience. Good Luck! Brian From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Howard Richter Sent: Saturday, June 21, 2008 2:27 PM To: arslist@ARSLIST.ORG Subject: Re: Issue with AIE and Oracle ** Happy weekend to all, I have tried everything I can think of and BMC as well, it might be a bug of some kind. Using the command line it work. I will post was BMC comes back with. Howard On Thu, Jun 19, 2008 at 6:08 PM, Joe DeSouza [EMAIL PROTECTED] wrote: ** Have you entered your oracle configurations correctly in the helper utility that is bundled with AIE? Oracle home, SID, username, password?? Joe - Original Message From: Howard Richter [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Thursday, June 19, 2008 9:49:51 AM Subject: Issue with AIE and Oracle ** Good morning all, I have the newest release of AIE and I am trying to get it to talk to a remote oracle database. The Server is 7.1 patch 3 and using MSSQL. I have installed the 10g client and can talk to the remote Oracle system using sqlplus from the box where the arserver is running. There is nothing in any log that I can find, that shows any attempt of the AIE trying to connect to the Oracle database. I did try setting up the AIE to talk to a MSSQL database and that worked. I am starting to wonder if, you can only talk to a database that the server talks to (for example in my case only MSSQL, since that is what the server is talking to). Any ideas, as of yet BMC support has had non. Howard -- Howard Richter Red Hat Certified Technician CompTIA Linux+ Certified ITIL Foundation Certified E-Mail = [EMAIL PROTECTED] LinkedIn Profile = http://www.linkedin.com/in/hbr4270 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ -- Howard Richter Red Hat Certified Technician CompTIA Linux+ Certified ITIL Foundation Certified E-Mail = [EMAIL PROTECTED] LinkedIn Profile = http://www.linkedin.com/in/hbr4270 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ -- Howard Richter Red Hat Certified Technician CompTIA Linux+ Certified ITIL Foundation Certified E-Mail = [EMAIL PROTECTED] LinkedIn Profile = http://www.linkedin.com/in/hbr4270 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___
Re: Issue with AIE and Oracle
I installed everything but the db2 adapter, but I don’t connect to any oracle dbs. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Roger Justice Sent: Sunday, June 22, 2008 1:11 PM To: arslist@ARSLIST.ORG Subject: Re: Issue with AIE and Oracle ** Have you installed the Oracle Link? -Original Message- From: strauss [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Sun, 22 Jun 2008 12:56 pm Subject: Re: Issue with AIE and Oracle ** To an AR staging form or any other existing AR form where you used a qualification to limit the scope of the data exchange. I don’t know if it similarly affects CMDB forms, but I would expect it to. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG mailto:[EMAIL PROTECTED] ] On Behalf Of Howard Richter Sent: Sunday, June 22, 2008 10:27 AM To: arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG Subject: Re: Issue with AIE and Oracle ** Chris, Is this when you are trying to do a data exchange to an ar form, such as the people one? Or just anything in the CMDB? Thanks, hbr On Sat, Jun 21, 2008 at 10:52 PM, strauss [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: ** The bugfix they sent me for patch 2 makes it possible to query against a condition on the AR Server – in my case it was in the Query tab, Data Key Query tab, AR Form Query where I had $Corporate ID Right$ = 0 as a condition for the data exchange to run. This was not a problem in 7.1 or patch 001, and is supposed to be fixed in patch 003, but if this is your problem BMC has a hotfix for the problem… a newer eie.exe and two dlls. The oradpr.dll was one of the changed files (the sql server adapter was not). Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG ] On Behalf Of Brian Gillock Sent: Saturday, June 21, 2008 4:50 PM To: arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG Subject: Re: Issue with AIE and Oracle ** Hey Howard, I'm afraid I don't have any tidbits regarding Oracle, but having been brutalized by the AIE over the past 3 days, I can tell you that patch 2 isn't very cooperative. I have finally had success by dropping back to patch 1. This may not help you, but I figured it can't hurt to share my experience. Good Luck! Brian From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG ] On Behalf Of Howard Richter Sent: Saturday, June 21, 2008 2:27 PM To: arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG Subject: Re: Issue with AIE and Oracle ** Happy weekend to all, I have tried everything I can think of and BMC as well, it might be a bug of some kind. Using the command line it work. I will post was BMC comes back with. Howard On Thu, Jun 19, 2008 at 6:08 PM, Joe DeSouza [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: ** Have you entered your oracle configurations correctly in the helper utility that is bundled with AIE? Oracle home, SID, username, password?? Joe - Original Message From: Howard Richter [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] To: arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG Sent: Thursday, June 19, 2008 9:49:51 AM Subject: Issue with AIE and Oracle ** Good morning all, I have the newest release of AIE and I am trying to get it to talk to a remote oracle database. The Server is 7.1 patch 3 and using MSSQL. I have installed the 10g client and can talk to the remote Oracle system using sqlplus from the box where the arserver is running. There is nothing in any log that I can find, that shows any attempt of the AIE trying to connect to the Oracle database. I did try setting up the AIE to talk to a MSSQL database and that worked. I am starting to wonder if, you can only talk to a database that the server talks to (for example in my case only MSSQL, since that is what the server is talking to). Any ideas, as of yet BMC support has had non. Howard -- Howard Richter Red Hat Certified Technician CompTIA Linux+ Certified ITIL Foundation Certified E-Mail = [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] LinkedIn http://www.linkedin.com/ Profile = http://www.linkedin.com/in/hbr4270 http://www.linkedin.com/in/hbr4270 __Platinum Sponsor: www.rmsportal.com http://www.rmsportal.com/ ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com http://www.rmsportal.com
Re: Issue with AIE and Oracle
Happy weekend to all, I have tried everything I can think of and BMC as well, it might be a bug of some kind. Using the command line it work. I will post was BMC comes back with. Howard On Thu, Jun 19, 2008 at 6:08 PM, Joe DeSouza [EMAIL PROTECTED] wrote: ** Have you entered your oracle configurations correctly in the helper utility that is bundled with AIE? Oracle home, SID, username, password?? Joe - Original Message From: Howard Richter [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Thursday, June 19, 2008 9:49:51 AM Subject: Issue with AIE and Oracle ** Good morning all, I have the newest release of AIE and I am trying to get it to talk to a remote oracle database. The Server is 7.1 patch 3 and using MSSQL. I have installed the 10g client and can talk to the remote Oracle system using sqlplus from the box where the arserver is running. There is nothing in any log that I can find, that shows any attempt of the AIE trying to connect to the Oracle database. I did try setting up the AIE to talk to a MSSQL database and that worked. I am starting to wonder if, you can only talk to a database that the server talks to (for example in my case only MSSQL, since that is what the server is talking to). Any ideas, as of yet BMC support has had non. Howard -- Howard Richter Red Hat Certified Technician CompTIA Linux+ Certified ITIL Foundation Certified E-Mail = [EMAIL PROTECTED] LinkedIn http://www.linkedin.com/ Profile = http://www.linkedin.com/in/hbr4270 __Platinum Sponsor: www.rmsportal.comARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ -- Howard Richter Red Hat Certified Technician CompTIA Linux+ Certified ITIL Foundation Certified E-Mail = [EMAIL PROTECTED] LinkedIn Profile = http://www.linkedin.com/in/hbr4270 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Issue with AIE and Oracle
Hey Howard, I'm afraid I don't have any tidbits regarding Oracle, but having been brutalized by the AIE over the past 3 days, I can tell you that patch 2 isn't very cooperative. I have finally had success by dropping back to patch 1. This may not help you, but I figured it can't hurt to share my experience. Good Luck! Brian From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Howard Richter Sent: Saturday, June 21, 2008 2:27 PM To: arslist@ARSLIST.ORG Subject: Re: Issue with AIE and Oracle ** Happy weekend to all, I have tried everything I can think of and BMC as well, it might be a bug of some kind. Using the command line it work. I will post was BMC comes back with. Howard On Thu, Jun 19, 2008 at 6:08 PM, Joe DeSouza [EMAIL PROTECTED] wrote: ** Have you entered your oracle configurations correctly in the helper utility that is bundled with AIE? Oracle home, SID, username, password?? Joe - Original Message From: Howard Richter [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Thursday, June 19, 2008 9:49:51 AM Subject: Issue with AIE and Oracle ** Good morning all, I have the newest release of AIE and I am trying to get it to talk to a remote oracle database. The Server is 7.1 patch 3 and using MSSQL. I have installed the 10g client and can talk to the remote Oracle system using sqlplus from the box where the arserver is running. There is nothing in any log that I can find, that shows any attempt of the AIE trying to connect to the Oracle database. I did try setting up the AIE to talk to a MSSQL database and that worked. I am starting to wonder if, you can only talk to a database that the server talks to (for example in my case only MSSQL, since that is what the server is talking to). Any ideas, as of yet BMC support has had non. Howard -- Howard Richter Red Hat Certified Technician CompTIA Linux+ Certified ITIL Foundation Certified E-Mail = [EMAIL PROTECTED] LinkedIn http://www.linkedin.com/ Profile = http://www.linkedin.com/in/hbr4270 __Platinum Sponsor: www.rmsportal.com http://www.rmsportal.com/ ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com http://www.rmsportal.com/ ARSlist: Where the Answers Are html___ -- Howard Richter Red Hat Certified Technician CompTIA Linux+ Certified ITIL Foundation Certified E-Mail = [EMAIL PROTECTED] LinkedIn Profile = http://www.linkedin.com/in/hbr4270 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Issue with AIE and Oracle
Brian, Maybe they will test patch 3 have a good weekend and thanks. Good luck, hbr On Sat, Jun 21, 2008 at 5:50 PM, Brian Gillock [EMAIL PROTECTED] wrote: ** Hey Howard, I'm afraid I don't have any tidbits regarding Oracle, but having been brutalized by the AIE over the past 3 days, I can tell you that patch 2 isn't very cooperative. I have finally had success by dropping back to patch 1. This may not help you, but I figured it can't hurt to share my experience. Good Luck! Brian *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Howard Richter *Sent:* Saturday, June 21, 2008 2:27 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Issue with AIE and Oracle ** Happy weekend to all, I have tried everything I can think of and BMC as well, it might be a bug of some kind. Using the command line it work. I will post was BMC comes back with. Howard On Thu, Jun 19, 2008 at 6:08 PM, Joe DeSouza [EMAIL PROTECTED] wrote: ** Have you entered your oracle configurations correctly in the helper utility that is bundled with AIE? Oracle home, SID, username, password?? Joe - Original Message From: Howard Richter [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Thursday, June 19, 2008 9:49:51 AM Subject: Issue with AIE and Oracle ** Good morning all, I have the newest release of AIE and I am trying to get it to talk to a remote oracle database. The Server is 7.1 patch 3 and using MSSQL. I have installed the 10g client and can talk to the remote Oracle system using sqlplus from the box where the arserver is running. There is nothing in any log that I can find, that shows any attempt of the AIE trying to connect to the Oracle database. I did try setting up the AIE to talk to a MSSQL database and that worked. I am starting to wonder if, you can only talk to a database that the server talks to (for example in my case only MSSQL, since that is what the server is talking to). Any ideas, as of yet BMC support has had non. Howard -- Howard Richter Red Hat Certified Technician CompTIA Linux+ Certified ITIL Foundation Certified E-Mail = [EMAIL PROTECTED] LinkedIn http://www.linkedin.com/ Profile = http://www.linkedin.com/in/hbr4270 __Platinum Sponsor: www.rmsportal.comARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ -- Howard Richter Red Hat Certified Technician CompTIA Linux+ Certified ITIL Foundation Certified E-Mail = [EMAIL PROTECTED] LinkedIn Profile = http://www.linkedin.com/in/hbr4270 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ -- Howard Richter Red Hat Certified Technician CompTIA Linux+ Certified ITIL Foundation Certified E-Mail = [EMAIL PROTECTED] LinkedIn Profile = http://www.linkedin.com/in/hbr4270 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Issue with AIE and Oracle
The bugfix they sent me for patch 2 makes it possible to query against a condition on the AR Server - in my case it was in the Query tab, Data Key Query tab, AR Form Query where I had $Corporate ID Right$ = 0 as a condition for the data exchange to run. This was not a problem in 7.1 or patch 001, and is supposed to be fixed in patch 003, but if this is your problem BMC has a hotfix for the problem... a newer eie.exe and two dlls. The oradpr.dll was one of the changed files (the sql server adapter was not). Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Brian Gillock Sent: Saturday, June 21, 2008 4:50 PM To: arslist@ARSLIST.ORG Subject: Re: Issue with AIE and Oracle ** Hey Howard, I'm afraid I don't have any tidbits regarding Oracle, but having been brutalized by the AIE over the past 3 days, I can tell you that patch 2 isn't very cooperative. I have finally had success by dropping back to patch 1. This may not help you, but I figured it can't hurt to share my experience. Good Luck! Brian From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Howard Richter Sent: Saturday, June 21, 2008 2:27 PM To: arslist@ARSLIST.ORG Subject: Re: Issue with AIE and Oracle ** Happy weekend to all, I have tried everything I can think of and BMC as well, it might be a bug of some kind. Using the command line it work. I will post was BMC comes back with. Howard On Thu, Jun 19, 2008 at 6:08 PM, Joe DeSouza [EMAIL PROTECTED] wrote: ** Have you entered your oracle configurations correctly in the helper utility that is bundled with AIE? Oracle home, SID, username, password?? Joe - Original Message From: Howard Richter [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Thursday, June 19, 2008 9:49:51 AM Subject: Issue with AIE and Oracle ** Good morning all, I have the newest release of AIE and I am trying to get it to talk to a remote oracle database. The Server is 7.1 patch 3 and using MSSQL. I have installed the 10g client and can talk to the remote Oracle system using sqlplus from the box where the arserver is running. There is nothing in any log that I can find, that shows any attempt of the AIE trying to connect to the Oracle database. I did try setting up the AIE to talk to a MSSQL database and that worked. I am starting to wonder if, you can only talk to a database that the server talks to (for example in my case only MSSQL, since that is what the server is talking to). Any ideas, as of yet BMC support has had non. Howard -- Howard Richter Red Hat Certified Technician CompTIA Linux+ Certified ITIL Foundation Certified E-Mail = [EMAIL PROTECTED] LinkedIn http://www.linkedin.com/ Profile = http://www.linkedin.com/in/hbr4270 __Platinum Sponsor: www.rmsportal.com http://www.rmsportal.com/ ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com http://www.rmsportal.com/ ARSlist: Where the Answers Are html___ -- Howard Richter Red Hat Certified Technician CompTIA Linux+ Certified ITIL Foundation Certified E-Mail = [EMAIL PROTECTED] LinkedIn Profile = http://www.linkedin.com/in/hbr4270 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Issue with AIE and Oracle
Good morning all, I have the newest release of AIE and I am trying to get it to talk to a remote oracle database. The Server is 7.1 patch 3 and using MSSQL. I have installed the 10g client and can talk to the remote Oracle system using sqlplus from the box where the arserver is running. There is nothing in any log that I can find, that shows any attempt of the AIE trying to connect to the Oracle database. I did try setting up the AIE to talk to a MSSQL database and that worked. I am starting to wonder if, you can only talk to a database that the server talks to (for example in my case only MSSQL, since that is what the server is talking to). Any ideas, as of yet BMC support has had non. Howard -- Howard Richter Red Hat Certified Technician CompTIA Linux+ Certified ITIL Foundation Certified E-Mail = [EMAIL PROTECTED] LinkedIn Profile = http://www.linkedin.com/in/hbr4270 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Issue with AIE and Oracle
You must be hitting some sort of oracle-specific issue (on which I will be of no help). My AIE instances draw their data from a dedicated SQL Server that has databases populated from our eDir LDAP and PeopleSoft property systems. The SQL Server hosting the ARSystem database is on yet another, completely different SQL Server. The two SQL Servers, the AR Server, and the AIE server are all on separate machines, with connections limited to their subnet. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Howard Richter Sent: Thursday, June 19, 2008 8:50 AM To: arslist@ARSLIST.ORG Subject: Issue with AIE and Oracle ** Good morning all, I have the newest release of AIE and I am trying to get it to talk to a remote oracle database. The Server is 7.1 patch 3 and using MSSQL. I have installed the 10g client and can talk to the remote Oracle system using sqlplus from the box where the arserver is running. There is nothing in any log that I can find, that shows any attempt of the AIE trying to connect to the Oracle database. I did try setting up the AIE to talk to a MSSQL database and that worked. I am starting to wonder if, you can only talk to a database that the server talks to (for example in my case only MSSQL, since that is what the server is talking to). Any ideas, as of yet BMC support has had non. Howard -- Howard Richter Red Hat Certified Technician CompTIA Linux+ Certified ITIL Foundation Certified E-Mail = [EMAIL PROTECTED] LinkedIn Profile = http://www.linkedin.com/in/hbr4270 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Issue with AIE and Oracle
That is my thought as well or is it looking at what the arserver is talking to. Thanks for the info, Howard On 6/19/08, strauss [EMAIL PROTECTED] wrote: ** You must be hitting some sort of oracle-specific issue (on which I will be of no help). My AIE instances draw their data from a dedicated SQL Server that has databases populated from our eDir LDAP and PeopleSoft property systems. The SQL Server hosting the ARSystem database is on yet another, completely different SQL Server. The two SQL Servers, the AR Server, and the AIE server are all on separate machines, with connections limited to their subnet. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Howard Richter *Sent:* Thursday, June 19, 2008 8:50 AM *To:* arslist@ARSLIST.ORG *Subject:* Issue with AIE and Oracle ** Good morning all, I have the newest release of AIE and I am trying to get it to talk to a remote oracle database. The Server is 7.1 patch 3 and using MSSQL. I have installed the 10g client and can talk to the remote Oracle system using sqlplus from the box where the arserver is running. There is nothing in any log that I can find, that shows any attempt of the AIE trying to connect to the Oracle database. I did try setting up the AIE to talk to a MSSQL database and that worked. I am starting to wonder if, you can only talk to a database that the server talks to (for example in my case only MSSQL, since that is what the server is talking to). Any ideas, as of yet BMC support has had non. Howard -- Howard Richter Red Hat Certified Technician CompTIA Linux+ Certified ITIL Foundation Certified E-Mail = [EMAIL PROTECTED] LinkedIn Profile = http://www.linkedin.com/in/hbr4270 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ -- Howard Richter Red Hat Certified Technician CompTIA Linux+ Certified ITIL Foundation Certified E-Mail = [EMAIL PROTECTED] LinkedIn Profile = http://www.linkedin.com/in/hbr4270 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Issue with AIE and Oracle
Having never used AIE my question would be ... Is anyone using it to access multiple database manufacturers at the same time (i.e. MS SQL and Oracle at the same time), or are people using just one manufacturer at a time (i.e.accessing multiple Oracle databases, or accessing multiple MS SQL databases, or accessing multiple Sybase databases)? Fred From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Howard Richter Sent: Thursday, June 19, 2008 10:02 AM To: arslist@ARSLIST.ORG Subject: Re: Issue with AIE and Oracle ** That is my thought as well or is it looking at what the arserver is talking to. Thanks for the info, Howard On 6/19/08, strauss [EMAIL PROTECTED] wrote: ** You must be hitting some sort of oracle-specific issue (on which I will be of no help). My AIE instances draw their data from a dedicated SQL Server that has databases populated from our eDir LDAP and PeopleSoft property systems. The SQL Server hosting the ARSystem database is on yet another, completely different SQL Server. The two SQL Servers, the AR Server, and the AIE server are all on separate machines, with connections limited to their subnet. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Howard Richter Sent: Thursday, June 19, 2008 8:50 AM To: arslist@ARSLIST.ORG Subject: Issue with AIE and Oracle ** Good morning all, I have the newest release of AIE and I am trying to get it to talk to a remote oracle database. The Server is 7.1 patch 3 and using MSSQL. I have installed the 10g client and can talk to the remote Oracle system using sqlplus from the box where the arserver is running. There is nothing in any log that I can find, that shows any attempt of the AIE trying to connect to the Oracle database. I did try setting up the AIE to talk to a MSSQL database and that worked. I am starting to wonder if, you can only talk to a database that the server talks to (for example in my case only MSSQL, since that is what the server is talking to). Any ideas, as of yet BMC support has had non. Howard -- Howard Richter Red Hat Certified Technician CompTIA Linux+ Certified ITIL Foundation Certified E-Mail = [EMAIL PROTECTED] LinkedIn Profile = http://www.linkedin.com/in/hbr4270 __Platinum Sponsor: www.rmsportal.com http://www.rmsportal.com/ ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com http://www.rmsportal.com/ ARSlist: Where the Answers Are html___ -- Howard Richter Red Hat Certified Technician CompTIA Linux+ Certified ITIL Foundation Certified E-Mail = [EMAIL PROTECTED] LinkedIn Profile = http://www.linkedin.com/in/hbr4270 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Issue with AIE and Oracle
Hi There... We're kind of in the same boat. We're working on an AIE that is running on a separate Windoze box. I've not worked on that challenge yet. But wouldn't we need to configure an ODBC (System) Name client first using the Oracle Client (If such a thing exist). Once thats set up I believe we need to select a ODBC Adapter through AIE.. -d From: Action Request System discussion list(ARSList) on behalf of Howard Richter Sent: Thu 06/19/2008 6:49 AM To: arslist@ARSLIST.ORG Subject: Issue with AIE and Oracle ** Good morning all, I have the newest release of AIE and I am trying to get it to talk to a remote oracle database. The Server is 7.1 patch 3 and using MSSQL. I have installed the 10g client and can talk to the remote Oracle system using sqlplus from the box where the arserver is running. There is nothing in any log that I can find, that shows any attempt of the AIE trying to connect to the Oracle database. I did try setting up the AIE to talk to a MSSQL database and that worked. I am starting to wonder if, you can only talk to a database that the server talks to (for example in my case only MSSQL, since that is what the server is talking to). Any ideas, as of yet BMC support has had non. Howard -- Howard Richter Red Hat Certified Technician CompTIA Linux+ Certified ITIL Foundation Certified E-Mail = [EMAIL PROTECTED] LinkedIn Profile = http://www.linkedin.com/in/hbr4270 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Issue with AIE and Oracle
I'm not, but one installation of AIE with multiple service instances can host multiple data exchanges. Each data exchange can be configured to use a different database connector, so I see no reason why I could not have four service instances running four data exchanges (1 per) that draw from SQL Server, Oracle, a flat file, and a DB2 database, with all of the data exchanges pushing something to the same AR Server. Based on what I have seen performance-wise, I would try to separate the data exchanges from one another by time slices; I wouldn't want to have all four running simultaneously. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: Thursday, June 19, 2008 10:34 AM To: arslist@ARSLIST.ORG Subject: Re: Issue with AIE and Oracle ** Having never used AIE my question would be ... Is anyone using it to access multiple database manufacturers at the same time (i.e. MS SQL and Oracle at the same time), or are people using just one manufacturer at a time (i.e.accessing multiple Oracle databases, or accessing multiple MS SQL databases, or accessing multiple Sybase databases)? Fred _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Howard Richter Sent: Thursday, June 19, 2008 10:02 AM To: arslist@ARSLIST.ORG Subject: Re: Issue with AIE and Oracle ** That is my thought as well or is it looking at what the arserver is talking to. Thanks for the info, Howard On 6/19/08, strauss [EMAIL PROTECTED] wrote: ** You must be hitting some sort of oracle-specific issue (on which I will be of no help). My AIE instances draw their data from a dedicated SQL Server that has databases populated from our eDir LDAP and PeopleSoft property systems. The SQL Server hosting the ARSystem database is on yet another, completely different SQL Server. The two SQL Servers, the AR Server, and the AIE server are all on separate machines, with connections limited to their subnet. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Howard Richter Sent: Thursday, June 19, 2008 8:50 AM To: arslist@ARSLIST.ORG Subject: Issue with AIE and Oracle ** Good morning all, I have the newest release of AIE and I am trying to get it to talk to a remote oracle database. The Server is 7.1 patch 3 and using MSSQL. I have installed the 10g client and can talk to the remote Oracle system using sqlplus from the box where the arserver is running. There is nothing in any log that I can find, that shows any attempt of the AIE trying to connect to the Oracle database. I did try setting up the AIE to talk to a MSSQL database and that worked. I am starting to wonder if, you can only talk to a database that the server talks to (for example in my case only MSSQL, since that is what the server is talking to). Any ideas, as of yet BMC support has had non. Howard -- Howard Richter Red Hat Certified Technician CompTIA Linux+ Certified ITIL Foundation Certified E-Mail = [EMAIL PROTECTED] LinkedIn Profile = http://www.linkedin.com/in/hbr4270 __Platinum Sponsor: www.rmsportal.com http://www.rmsportal.com/ ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com http://www.rmsportal.com/ ARSlist: Where the Answers Are html___ -- Howard Richter Red Hat Certified Technician CompTIA Linux+ Certified ITIL Foundation Certified E-Mail = [EMAIL PROTECTED] LinkedIn Profile = http://www.linkedin.com/in/hbr4270 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Issue with AIE and Oracle
Have you entered your oracle configurations correctly in the helper utility that is bundled with AIE? Oracle home, SID, username, password?? Joe - Original Message From: Howard Richter [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Thursday, June 19, 2008 9:49:51 AM Subject: Issue with AIE and Oracle ** Good morning all, I have the newest release of AIE and I am trying to get it to talk to a remote oracle database. The Server is 7.1 patch 3 and using MSSQL. I have installed the 10g client and can talk to the remote Oracle system using sqlplus from the box where the arserver is running. There is nothing in any log that I can find, that shows any attempt of the AIE trying to connect to the Oracle database. I did try setting up the AIE to talk to a MSSQL database and that worked. I am starting to wonder if, you can only talk to a database that the server talks to (for example in my case only MSSQL, since that is what the server is talking to). Any ideas, as of yet BMC support has had non. Howard -- Howard Richter Red Hat Certified Technician CompTIA Linux+ Certified ITIL Foundation Certified E-Mail = [EMAIL PROTECTED] LinkedIn Profile = http://www.linkedin.com/in/hbr4270 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are