Re: Request ID In Process .. again, SQL Error
What the error in the CAI Event form is telling you is that data that is being pushed to a certain field is too large for the field (for instance, pushing 101 characters to a 100 character length field). Most probably this is coming from a free text field on the Requester Console, that's why when the same categorization and summary are selected by two different people the error occurs for one and not the other. Scott Parrish IT Prophets, LLC (770) 653-5203 www.itprophets.com -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mauricio M. Sent: Friday, June 20, 2008 9:15 PM To: arslist@ARSLIST.ORG Subject: Request ID In Process .. again, SQL Error Dear All, I´d appreciate your help with this odd issue regarding incident generation from the Requester Console, thanks in advance for your help as always... When I push the New Request button, the Incident ID will not be created and the Incident will not be pushed to Helpdesk form. The ID gets stuck in status In Process. It happens only to some users, some users don´t have any problem at all, even though both lucky and failing users use the same categorization, summary, etc., and I haven´t been able to find a pattern. A record is actually created in SRM:Request, but If I check the latest entry in CAI:Event, I will get the following information: SRM_OUT_CREATE_APP_REQUEST Form: HPD:IncidentInterface_Create Return Code:Error Error: ARCreateEntry - Failure during DB operation. The statement has been terminated.String or binary data would be truncated. (SQL Server 8152) I have checked the filter log, and I can detect one error, stopping filter processing, somewhere between filter SHR:SHR:UpdateGroupListAdd_100 and the filter that updates the HPD:Worklog, but there is no detail where the error is exactly ocurring. Please, shed some light, Thanks and best regards, -Mauricio ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
ERROR (326): Required field cannot be reset to a NULL value; HPD:Help Desk : Contact Company
Remedy ARServer 7.1.0 Patch 2 CMDB 2.1 Incident Management Module 7003 OS: Solaris 2.10 Hi: when I try to create a incident by submitting to HPD_IncidentInterface_Create_WS, I get the following error. ERROR (326): Required field cannot be reset to a NULL value; HPD:Help Desk : Contact Company According to BMC Remedy IT Service Management 7 0_INTEGRATIONS.pdf this field is set by a workflow (Table 2-3 Page 18). I have a company called My Company in the BMC REMEDY IT SERVICE MANAGEMENT console. Anyone know what specifically needs to be set for this company item so incident creation works in the ITSM suite? Thanks Ravi ___ 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
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