installing 7.1 on win7
I have 7.1 user and admin trying to install on windows7. I used to could set compatibility mode on the install file to run as vista sp2, but this stopped working. Any other ideas of what I can try? Thanks, Gary Opela, Jr. Remedy Engineer ITIL V3 Foundations Certified Avaya Phone Support CNI/IT Tinker 72 SC (405) 582-4272 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: installing 7.1 on win7
@Rick: Thanks, I'll try xp. @David: I always knew the user tool was backwards compatible, I never did know that the admin tool would be. If xp won't work, then I'll have to use 7.5 Thanks! Thanks, Gary Opela, Jr. Remedy Engineer ITIL V3 Foundations Certified Avaya Phone Support CNI/IT Tinker 72 SC (405) 582-4272 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@arslist.org] On Behalf Of Easter, David Sent: Tuesday, October 04, 2011 1:40 PM To: arslist@arslist.org Subject: Re: installing 7.1 on win7 ** Your other option is to install the 7.5.00 Remedy User client and use Developer Studio - both of which are supported on Windows 7 and are backwards compatible to working with an AR System 7.1.00 server. -David J. Easter Manager of Product Management, Remedy Platform BMC Software, Inc. The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Cook Sent: Tuesday, October 04, 2011 11:33 AM To: arslist@ARSLIST.ORG Subject: Re: installing 7.1 on win7 ** Most of us use XP as the compatibility mode. More stable than Vista. Rick On Tue, Oct 4, 2011 at 11:30 AM, Opela, Gary L CTR USAF ABW 72 ABW/SCOOA gary.opela@tinker.af.mil wrote: ** I have 7.1 user and admin trying to install on windows7. I used to could set compatibility mode on the install file to run as vista sp2, but this stopped working. Any other ideas of what I can try? Thanks, Gary Opela, Jr. Remedy Engineer ITIL V3 Foundations Certified Avaya Phone Support CNI/IT Tinker 72 SC (405) 582-4272 tel:%28405%29%20582-4272 _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
Re: Error using Remedy 7.1 APIs in VB.Net
Yes, it was compiled in release mode. I just changed to which executable my scheduled task pointed. I was pointing to the exe in the Application Files\ProjectNameAndVersion\programname.exe now I'm hitting the one in the release folder under bin. They are both the same size. I will see if this helps. Thanks for the input. Thanks, Gary Opela, Jr. Remedy Engineer ITIL V3 Foundations Certified Avaya Phone Support CNI/IT Tinker 72 SC (405) 582-4272 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@arslist.org] On Behalf Of Lyle Taylor Sent: Thursday, August 04, 2011 4:56 PM To: arslist@arslist.org Subject: Re: Error using Remedy 7.1 APIs in VB.Net ** Are you building and running your project in Release mode (as opposed to Debug mode)? Always use Release mode - even for debugging. Lyle From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Opela, Gary L CTR USAF ABW 72 ABW/SCOOA Sent: Thursday, August 04, 2011 1:45 PM To: arslist@ARSLIST.ORG Subject: Error using Remedy 7.1 APIs in VB.Net ** Hello all, I was just wondering if anyone had had the following error before, and if so, then what did you do to resolve it? System.AccessViolationException: Attempted to read or write protected memory. This is often an indication that other memory is corrupt. at evalImpl(tagVARIANT* , tagVARIANT* ) at ARNetToC.API.eval(Object v) at BMC.ARSystem.Server._Eval(Object v) at BMC.ARSystem.Server._performLogin(String methodName, String server, String user, String password, String authentication, String locale, String charSet, Int32 port, String apiCmdLog, String apiResLog, Boolean logInitAndTerm) at BMC.ARSystem.Server.Login(String server, String user, String password, String authentication, String locale, String charSet, Int32 port) at BMC.ARSystem.Server.Login(String server, String user, String password, String authentication) at BMC.ARSystem.Server.Login(String server, String user, String password) I am getting this occasionally. Most days it runs fine, but then very rarely it will start throwing that error on every ticket which I try to create. Below is a snippet of my code: Sub CreateTicket(ByVal id As Integer, ByVal machine_name As String, ByVal collection_name As String, ByVal submitter_user As String, ByVal report_location As String) Dim usrArray() As String = getUsrInfo(submitter_user) Dim asgGroup() As String = GetGroup(submitter_user, usrArray(8), usrArray(3)) Dim scheduledDate As Integer = GetSchedDate() Dim workLog As String = getWorkLog(report_location) Dim formName As String = remedy form Dim server As BMC.ARSystem.Server Dim fieldValues As New BMC.ARSystem.FieldValueList Dim entryID As String = Dim result As String = Dim serverName As String = server name Dim userName As String = login name Dim userPass As String = password server = CreateObject(BMC.ARSystem.Server) fieldValues = CreateObject(BMC.ARSystem.FieldValueList) Try server.Login(serverName, userName, userPass) fieldValues.Item(x) = Submitter fieldValues.Item(x) = Status fieldValues.Item(x) = Priority fieldValues.Item(x) = scheduledDate fieldValues.Item(x) = asgGroup(0) fieldValues.Item(x) = asgGroup(1) fieldValues.Item(x) = Category fieldValues.Item(x) = Type fieldValues.Item(x) = Item fieldValues.Item(x) = Problem Description fieldValues.Item(x) = workLog fieldValues.Item(x) = machine_name fieldValues.Item(x) = usrArray(7) fieldValues.Item(x) = usrArray(0) fieldValues.Item(x) = usrArray(1) fieldValues.Item(x) = usrArray(2) fieldValues.Item(x) = usrArray(3) fieldValues.Item(x) = Other fieldValues.Item(x) = usrArray(5) usrArray(6) Try entryID = server.CreateEntry(formName, fieldValues) If entryID Then 'Update database record updateTicket(id, entryID) End If Catch ex As Exception 'ERROR! log(ex.ToString) server.Logout() End Try server.Logout
Error using Remedy 7.1 APIs in VB.Net
Hello all, I was just wondering if anyone had had the following error before, and if so, then what did you do to resolve it? System.AccessViolationException: Attempted to read or write protected memory. This is often an indication that other memory is corrupt. at evalImpl(tagVARIANT* , tagVARIANT* ) at ARNetToC.API.eval(Object v) at BMC.ARSystem.Server._Eval(Object v) at BMC.ARSystem.Server._performLogin(String methodName, String server, String user, String password, String authentication, String locale, String charSet, Int32 port, String apiCmdLog, String apiResLog, Boolean logInitAndTerm) at BMC.ARSystem.Server.Login(String server, String user, String password, String authentication, String locale, String charSet, Int32 port) at BMC.ARSystem.Server.Login(String server, String user, String password, String authentication) at BMC.ARSystem.Server.Login(String server, String user, String password) I am getting this occasionally. Most days it runs fine, but then very rarely it will start throwing that error on every ticket which I try to create. Below is a snippet of my code: Sub CreateTicket(ByVal id As Integer, ByVal machine_name As String, ByVal collection_name As String, ByVal submitter_user As String, ByVal report_location As String) Dim usrArray() As String = getUsrInfo(submitter_user) Dim asgGroup() As String = GetGroup(submitter_user, usrArray(8), usrArray(3)) Dim scheduledDate As Integer = GetSchedDate() Dim workLog As String = getWorkLog(report_location) Dim formName As String = remedy form Dim server As BMC.ARSystem.Server Dim fieldValues As New BMC.ARSystem.FieldValueList Dim entryID As String = Dim result As String = Dim serverName As String = server name Dim userName As String = login name Dim userPass As String = password server = CreateObject(BMC.ARSystem.Server) fieldValues = CreateObject(BMC.ARSystem.FieldValueList) Try server.Login(serverName, userName, userPass) fieldValues.Item(x) = Submitter fieldValues.Item(x) = Status fieldValues.Item(x) = Priority fieldValues.Item(x) = scheduledDate fieldValues.Item(x) = asgGroup(0) fieldValues.Item(x) = asgGroup(1) fieldValues.Item(x) = Category fieldValues.Item(x) = Type fieldValues.Item(x) = Item fieldValues.Item(x) = Problem Description fieldValues.Item(x) = workLog fieldValues.Item(x) = machine_name fieldValues.Item(x) = usrArray(7) fieldValues.Item(x) = usrArray(0) fieldValues.Item(x) = usrArray(1) fieldValues.Item(x) = usrArray(2) fieldValues.Item(x) = usrArray(3) fieldValues.Item(x) = Other fieldValues.Item(x) = usrArray(5) usrArray(6) Try entryID = server.CreateEntry(formName, fieldValues) If entryID Then 'Update database record updateTicket(id, entryID) End If Catch ex As Exception 'ERROR! log(ex.ToString) server.Logout() End Try server.Logout() Catch ex As Exception 'ERROR! log(ex.ToString) End Try Thanks, Gary Opela, Jr. Remedy Engineer, RSP Certified ITIL V3 Foundations Certified Avaya Phone Support CNI/IT Tinker 72 SC ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Does the order of the Set Fields or Push Fields If matter in relation to Index
Chris good question. I had always assumed that the ARSystem just took the query, then formatted it in TSQL and sent it off to the database engine. If this is the case, then the database engine will follow the query optimizer settings to follow the index trail. If, however, the ARSystem actually does the querying itself (which I had always assumed it hadn't) then that would be a good question for Mr. Mueller. Thanks, Gary Opela, Jr. Remedy Engineer ITIL V3 Foundations Certified Avaya Phone Support CNI/IT Tinker 72 SC (405) 582-4272 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@arslist.org] On Behalf Of Pruitt, Christopher (Bank of America Account) Sent: Tuesday, May 10, 2011 10:48 AM To: arslist@arslist.org Subject: Does the order of the Set Fields or Push Fields If matter in relation to Index Need some feedback from all your database SQL experts out there. We have been having an ongoing discussion regarding the use of Indexed fields within a Set Field If Action and/or a Push fields If Action qualification. Here is what we are looking at. You have a form with three indexes, Inx1, Inx2, and Inx3. Either the Set Field If Action or Push fields If Action qualification is set up in this format. Form Field 1 = Database Field 1 AND Form Field 2 = Database Field Inx3 AND Form Field 3 = Database Field Inx1 AND Form Field 4 = Database Field Inx2 The question is does AR Server evaluate the qualification as whole and determine if any of the fields are indexed first and then pull a subset of records to find the last value Form Field 1 = Database Field 1 or does it build the records sets in the order the Set Field If Action or Push fields If Action qualification is designed. Meaning it first pulls those records in the Form Field 1 = Database Field 1, then Form Field 2 = Database Field Inx3, and so forth. Christopher Pruitt Business Consulting III HP Enterprises Services christopher.pru...@hp.com www.hp.comhttp://www.hp.com/ Confidentiality Notice: This message and any files transmitted with it are intended for the sole use of the entity or individual to whom it is addressed, and may contain information that is confidential, privileged, and exempt from disclosure under applicable law. If you are not the intended addressee for this e-mail, you are hereby notified that any copying, distribution, or dissemination of this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately destroy, erase, or discard this message. Please notify the sender immediately by return e-mail if you have received this e-mail by mistake. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org 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
Re: Reset Password At Login, Web Version
Drew, check to see if they are using the Init form. This works for WUT but not for the web based tool. I use the init form here to allow me to force people to change their passwords and it works nicely. I'm not sure how you would use it with the web tool, as I don't think there is a way to use the Init form. Thanks, Gary Opela, Jr. Remedy Engineer ITIL V3 Foundations Certified Avaya Phone Support CNI/IT Tinker 72 SC (405) 582-4272 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@arslist.org] On Behalf Of Drew Shuller Sent: Tuesday, May 10, 2011 12:40 PM To: arslist@arslist.org Subject: Reset Password At Login, Web Version ** Hello everyone, on my 7.6.4 Remedy custom app on windows servers, my users are prompted to change their password when logging into the User Tool, but not when they are logging onto the web version. Is this expected behavior? Have I missed a setting somewhere? Thanks for the help! Drew Shuller Remedy Admin Joint Task Force Bravo Soto Cano Air Base Comayagua, Honduras _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
Re: Problem searching records
Also turn on workflow logging before hitting search to see if there are any active links that are altering the search whenever you hit search. Occasionally I've seen where someone has set it up this way to restrict even admins from viewing certain tickets. If you have an active link running on 'Search' then it could very well be changing your query statement. Thanks, Gary Opela, Jr. Remedy Engineer ITIL V3 Foundations Certified Avaya Phone Support CNI/IT Tinker 72 SC (405) 582-4272 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@arslist.org] On Behalf Of Drew Shuller Sent: Thursday, April 14, 2011 8:38 AM To: arslist@arslist.org Subject: Re: Problem searching records ** Hit ctrl-E, then enter your search terms. If that doesn't work, describe your search and we can see if that's the problem. Drew JTF-Bravo On Thu, Apr 14, 2011 at 7:17 AM, Oyefeso, Bola boyef...@dpscs.state.md.us wrote: ** We are having problem searching for records. We do not get any or all of the records back when we do a search. We receive ARWARN 1200 No Matching requests (or no permission to requests) for qualification criteria. We know there are records for the search, and there is no permission set to prevent anyone from doing a search. Even I, as the administrator cannot get any record back. Does anyone know what the problem could be? Bola _attend WWRUG11 www.wwrug.com http://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
Re: Email Issue
I have random hangs as well. I've learned to accept it. However, what I've done is write a vb.net program that queries the AR System Email Messages form for Send Message = 'Yes' and gets a count of those. If the count surpasses a certain threshold, I then send myself an email. I need to tweak it to where it will do a net stop and net start on the BMC Remedy Email Engine service so that it will recover on its own. I have a scheduled task, or maybe an SQL Server Agent job that runs this every 30 minutes or so and it works marvelously for me. It's basically very simple, below is some of the code (written in vb.net): Dim myConnection As SqlConnection = New SqlConnection(Server=SQL Server;UID=SQL User;PWD=SQL DB Password;Database=ARSystem) Dim myQuery As String = SELECT count(*) FROM dbo.AR_System_Email_Messages WHERE Send_Message = 1 Dim myCount As New SqlCommand(myQuery, myConnection) Dim count As Integer Dim toAddr As String = my email address myConnection.Open() Dim drCount As SqlDataReader = myCount.ExecuteReader() While drCount.Read() count = drCount(0) End While myConnection.Close() If count 0 Then SendEmail(toAddr, fromAddr, subject, body) End If Sub SendEmail(ByVal ToAddress As String, ByVal FromAddress As String, ByVal Subject As String, ByVal Body As String) 'Create the MailMessage instance Dim message As New MailMessage(FromAddress, ToAddress) 'Assign the MailMessage's properties message.Subject = Subject message.Body = Body message.IsBodyHtml = False 'Create the SmtpClient object Dim smtp As New SmtpClient smtp.Host = SMTP Server Address smtp.Port = SMTP Server Email Port (Defaults to 25) smtp.Send(message) End Sub That's most of it. There are some variables which I've not shown here, such as the subject and the body. I have those preset as either constants or as variables. It's pretty simple and it works nicely. I was giogn to originally put an escalation on the remedy email form to mail me if the email engine hung, but you get a catch 22 because the email engine is hung, so the email never goes out So, my best solution was to use VB.NET to do it for me. Thanks, Gary Opela, Jr. Remedy Engineer ITIL V3 Foundations Certified Avaya Phone Support CNI/IT Tinker 72 SC (405) 582-4272 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@arslist.org] On Behalf Of Jason Miller Sent: Tuesday, March 29, 2011 10:51 AM To: arslist@arslist.org Subject: Re: Email Issue ** We too have had issues with various versions over the years with 7.5 being the worst. We have an escalation form where we keep service type escalations. We have a control records and an escalation that fires every 10 minutes and does a set fields on that record where: 'Send Message' = Yes AND 'Create Date' $TIMESTAMP$ - 60 * 60 AND 'Create Date' = $TIMESTAMP$ - 60 * 11 If there is a match the 'Email ID' from one record is set in a field and our process runs to restart the service. The process is a batch file that writes to a log, stops the service, cleans up some temp email engine, pauses and restarts the email engine. It works so well we have forgotten it there is a problem still. Looking at the log we can go a days without issue and some days it restarts throughout the day. We definitely see more restarts on busier days. Here is the content of the batch: @Echo Off Rem Stops and starts Email engine if messages are not being sent on a timely basis echo * %date% %TIME% -- Email Engine stopped sending emails, restarting D:\Logs\EmailEngine.log net stop BMC Remedy Email Engine - OURSERVERNAME 1 D:\Logs\EmailEngine.log c: cd C:\Users\ServiceAccountName\AppData\Local\Temp\ @Echo Deleting temp files in C:\Users\ServiceAccountName\AppData\Local\Temp\ D:\Logs\EmailEngine.log del AT*.tmp email*.eml email*.txt email*.rtf chk*.tmp email*.html red*.tmp email*.msg red*tmp E*_*.tmp rem the ping is just a pause to allow previous task to finish ping 1.0.0.0 -n 1 -w 5000 NUL net start BMC Remedy Email Engine - OURSERVERNAME 1 D:\Logs\EmailEngine.log ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: LIKE Query
I agree with Dwayne. I don't know if it has something to do with how Remedy parses out the variable or not, but I've found that sometimes I have to use LIKE ($Company$ + %) in cases where I'm using a variable within a filter. Thanks, Gary Opela, Jr. Remedy Engineer Avaya Phone Support CNI/IT Tinker 72 SC (405) 582-4272 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Martin, Dwayne - martinrd Sent: Tuesday, November 16, 2010 7:51 AM To: arslist@arslist.org Subject: Re: LIKE Query ** Hi Gavin, I am curious as to which one works. I've only heard of using the + sign with a variable, eg. 'LIKE $Company$ + %', but it seems like 'LIKE Company + %' should work too. Dwayne Martin James Madison University From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Coleman, Gavin Sent: Tuesday, November 16, 2010 7:43 AM To: arslist@ARSLIST.ORG Subject: LIKE Query ** Hi List - we've got an interesting problem here. What is the difference between the following: LIKE Company + % LIKE Company% I would have assumed nothing, but one of these works and one doesn't. Is there anybody that can explain the difference? I've run across this before, but never really wanted to find out WHY it worked / didn't work. The above qualification occurs in a Filter Run If statement. Thanks, Gavin Coleman Senior Analyst/Programmer Computacenter (UK) Ltd Services Solutions Hatfield Avenue Hatfield, Hertfordshire, AL10 9TW, United Kingdom T: +44 (0) 1707 631662 E: gavin.cole...@computacenter.com mailto:gavin.cole...@computacenter.com W: www.computacenter.com ** COMPUTACENTER PLC is registered in England and Wales with the registered number 03110569. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW COMPUTACENTER (UK) Limited is registered in England and Wales with the registered number 01584718. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW COMPUTACENTER (Mid-Market) Limited is registered in England and Wales with the registered number 3434654. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW COMPUTACENTER (FMS) Limited is registered in England and Wales with the registered number 3798091. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW The contents of this email are intended for the named addressee only. It contains information which may be confidential and which may also be privileged. Unless you are the named addressee (or authorised to receive mail for the addressee) you may not copy or use it, or disclose it to anyone else. If you receive it in error please notify us immediately and then destroy it. Computacenter information is available from: http://www.computacenter.com ** _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
Re: Java Developer needed for full time job in Chicago, IL. Must have BPEL, ESP, and Oracle experience and be a US Citizen or Green Card Holder
The DoD uses remedy, so all jobs they have should be posted here. We have an aircraft mechanic position open. Anyone know any aircraft mechanics? Thanks, Gary Opela, Jr. Remedy Engineer Avaya Phone Support CNI/IT Tinker 72 SC (405) 582-4272 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Rick Cook Sent: Wednesday, November 17, 2010 10:45 AM To: arslist@arslist.org Subject: Re: Java Developer needed for full time job in Chicago, IL. Must have BPEL, ESP, and Oracle experience and be a US Citizen or Green Card Holder ** Using that logic, any job solicitation for any software developer, support, or other IT job, regardless of vendor, would be appropriate. The skill sets he seeks are not likely to be found here to any significant degree. And that's the key. Rick On Wed, Nov 17, 2010 at 10:40 AM, John Atherly john.athe...@apc.com wrote: ** I would have to Side with Claire since Remedy and other applications that work with Remedy are using Java. I'm surprised that they are not also requiring Remedy skills _ John Atherly | APC by Schneider Electric | Information, Process Organization (IPO) | Remedy Administrator / Developer Phone: +401-789-5735 ext. 2120 | Fax: +401-789-3710 | Email: john.athe...@apcc.com mailto:+john.athe...@apcc.com | Site: www.apc.com/ http://www.apc.com/ | Address: 132 Fairgrounds Road, West Kingston, RI 02892 USA *** Please consider the environment before printing this e-mail Rick Cook remedyr...@gmail.com Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 11/17/2010 11:34 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Java Developer needed for full time job in Chicago, IL. Must have BPEL, ESP, and Oracle experience and be a US Citizen or Green Card Holder ** Normally, I would agree with you, Claire, but the job requirements don't mention Remedy at all, so I have to go with Phil on this one. Rick On Wed, Nov 17, 2010 at 10:25 AM, Sanford, Claire claire.sanf...@memorialhermann.org mailto:claire.sanf...@memorialhermann.org wrote: ** Since Column is pretty much a BMC/Remedy only shop, it would stand to reason that this is a Remedy related position, even if it does not explicitly say it is... From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG ] On Behalf Of Murnane, Phil Sent: Wednesday, November 17, 2010 10:02 AM To: arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG Subject: Re: Java Developer needed for full time job in Chicago, IL. Must have BPEL, ESP, and Oracle experience and be a US Citizen or Green Card Holder ** David: We respectfully request that you keep posts to the ARSlist limited to topics related to the family of BMC Remedy AR System and related products. There are many, many more suitable places on the internet for Java Developer Wanted postings. Thank You, --Phil From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG ] On Behalf Of Frankfater, David Sent: Wednesday, November 17, 2010 10:54 To: arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG Subject: Java Developer needed for full time job in Chicago, IL. Must have BPEL, ESP, and Oracle experience and be a US Citizen or Green Card Holder ** We have a full time opening for Java developer. Do you know of anyone that might be interested? Responsibilities: * Participate as a team member in the application development area. * Learn business functions to effectively participate in technical analysis, design, construction and implementation. * Code solutions to problems using a structured approach keeping in mind long term maintainability and quick accessibility. * Test coded solutions properly against customer acceptance criteria to ensure a quality application * Document consistently and accurately on all application projects. All technical documentation (new development and maintenance) should be complete, understandable and accessible. * Communicate and maintain a productive working relationship with user base of product/service line as well as all appropriate parties to an assignment, both internal and external to IT. * Report appropriate and correct status to project leadership, manager and Director.
Re: OT- BMC Jumps to Highest Since 2000 on Report of Potential Sale
I'm in for $20.00. Hrmm, market cap of $7.6 bill. 4,000 ppl on ARlist, if it sells for $8bill, then that's $2,000,000 per person? Let's start saving! Thanks, Gary Opela, Jr. Sr. Remedy Engineer Avaya Phone Admin RSP Cert, Sec+ COMM: 405 582 4272 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Tommy Morris Sent: Friday, October 08, 2010 8:22 AM To: arslist@ARSLIST.ORG Subject: Re: OT- BMC Jumps to Highest Since 2000 on Report of Potential Sale ** Better luck investing that $20 in Lotto tickets From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Warren Baltimore Sent: Friday, October 08, 2010 7:50 AM To: arslist@ARSLIST.ORG Subject: Re: OT- BMC Jumps to Highest Since 2000 on Report of Potential Sale ** I've got 20! Anyone in? On Fri, Oct 8, 2010 at 8:48 AM, Danny Kellett danny.kell...@strategicworkflow.com wrote: ** Hmmm I smell a BMC being sold. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Warren Baltimore Sent: 08 October 2010 13:41 To: arslist@ARSLIST.ORG Subject: Re: OT- BMC Jumps to Highest Since 2000 on Report of Potential Sale ** Probably not. Given that it sounds like they are in the early courting stages, I doubt they will say anything until something is finalized. On Fri, Oct 8, 2010 at 1:08 AM, Joe Martin D'Souza jdso...@shyle.net wrote: Interesting article... I wonder if they would discuss it at the RUG if this was brought up at the QA sessions with their CEO's or CFO's.. Joe -- From: Sanford, Claire claire.sanf...@memorialhermann.org Sent: Friday, October 08, 2010 12:32 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: OT- BMC Jumps to Highest Since 2000 on Report of Potential Sale Anyone see this article? http://www.bloomberg.com/news/2010-10-07/bmc-jumps-to-highest-since-2000 -on-report-of-potential-sale.html BMC Software Inc. http://www.bloomberg.com/apps/quote?ticker=BMC:US climbed the most in 20 months in Nasdaq Stock Market trading on a report the business-software maker may be putting itself up for sale. The shares jumped as much as 9.6 percent after DealReporter said BMC may have started exploring a sale as many as two weeks ago. The news service cited three industry bankers and an executive familiar with the situation. Houston-based BMC has a market capitalization of about $7.6 billion. Claire ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org http://www.arslist.org/ attend wwrug10 www.wwrug.com http://www.wwrug.com/ ARSlist: Where the Answers Are -- Warren R. Baltimore II Remedy Developer 410-533-5367 _attend WWRUG10 www.wwrug.com http://www.wwrug.com/ ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com http://www.wwrug.com/ ARSlist: Where the Answers Are_ -- Warren R. Baltimore II Remedy Developer 410-533-5367 _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Survey Monkey
Yeah... I was hoping no one would catch that :) But hey, Kinetic and Buoyant are business parters, and unless I'm losing it, Gidd is Buoyant (or at least he sinks slowly). -Rep for me Thanks, Gary Opela, Jr. Sr. Remedy Engineer Avaya Phone Admin RSP Cert, Sec+ COMM: 405 582 4272 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Shellman, David Sent: Thursday, September 30, 2010 7:37 AM To: arslist@ARSLIST.ORG Subject: Re: Survey Monkey Gidd? Did you mean to say John Sundberg? Dave -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Matthew Perrault Sent: Wednesday, September 29, 2010 10:04 PM To: arslist@ARSLIST.ORG Subject: Re: Survey Monkey LOL. I should charge him for the free advertisement! No, I just really like the product and the support staff that I've worked with there. Been very helpful, no run-around, no nonsense etc. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Opela, Gary L CTR USAF ABW 72 ABW/SCOOA Sent: Wednesday, September 29, 2010 2:19 PM To: arslist@ARSLIST.ORG Subject: Re: Survey Monkey Did Gidd pay you to say this??? :) Thanks, Gary Opela, Jr. Sr. Remedy Engineer Avaya Phone Admin RSP Cert, Sec+ COMM: 405 582 4272 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Matthew Perrault Sent: Wednesday, September 29, 2010 9:27 AM To: arslist@ARSLIST.ORG Subject: Re: Survey Monkey ** Have you guys thought about Kinetic's Survey module? It ties into Remedy REALLY well, has a web front end for customers to answer the surveys, Extremely customizable, and data driven. Also, The Support from Kinetic has been OUTSTANDING! I've had to contact them a couple of times, and I have been really impressed at how they handled the issue. If you're looking for a Survey tool to integrate into Remedy, I would really recommend Kinetic. Just my 2 cents, Matt P. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Roberts, Chas Sent: Wednesday, September 29, 2010 9:01 AM To: arslist@ARSLIST.ORG Subject: Re: Survey Monkey ** Just like any external application. You can launch it from a Remedy app in the usual fashion, of course. You can then download the survey results in Excel format and AR Import the interesting parts into Remedy. The full Pro version is ¼ the cost of the other one mentioned, for those who are curious. Yours truly, Charles H. Roberts, 4th Riverside County Information Technology Office: 951-486-7780 Cell: 951-840-8699 eMail: crobe...@riversidecountyit.org mailto:crobe...@riversidecountyit.org From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Chowdhury, Tauf Sent: Wednesday, September 29, 2010 6:53 AM To: arslist@ARSLIST.ORG Subject: Re: Survey Monkey ** I don't think it is. It's a web based tool. I'm trying to figure out if it can be done. Tauf Chowdhury | Forest Laboratories, Inc. Analyst, Service Management Mobile:646.483.2779 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Meyer, Jennifer L Sent: Wednesday, September 29, 2010 9:12 AM To: arslist@ARSLIST.ORG Subject: Re: Survey Monkey Out of curiosity, how does Survey Monkey tie in with Remedy? How is tenancy information tracked? Jennifer Meyer From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe DeSouza Sent: Tuesday, September 28, 2010 6:57 PM To: arslist@ARSLIST.ORG Subject: OT:Re: Anyone has made use of this web based survey engine? ** Hi Chas, I think I may have heard of Survey Monkey before.. I'm not intending to do anything with any of these at the moment but was just going through the features of the one I found just in case it is useful at some point. I will go through your suggestion too.. Thanks for that tip.. Joe From: Roberts, Chas crobe...@riversidecountyit.org To: arslist@ARSLIST.ORG Sent: Tue, September 28, 2010 6:40:46 PM Subject: Re: Anyone has made use of this web based survey engine? ** Joe, Survey Monkey is the best thing for this purpose. It has a funny name but very good features and reliability, and you can use SurveyMK.com/yoursurveycode http://surveymk.com/yoursurveycode so it looks like Survey Marketing Yours truly, Charles H. Roberts, 4th Riverside County Information Technology Office: 951-486-7780 Cell: 951-840-8699 eMail: crobe...@riversidecountyit.org mailto:crobe...@riversidecountyit.org From: Action Request System discussion list(ARSList) [mailto:arsl
Re: Survey Monkey
I wish. And it's also nice that since the list is duplicating posts for some reason, I got roasted in two emails instead of just one! Thanks, Gary Opela, Jr. Sr. Remedy Engineer Avaya Phone Admin RSP Cert, Sec+ COMM: 405 582 4272 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of LJ LongWing Sent: Thursday, September 30, 2010 9:17 AM To: arslist@ARSLIST.ORG Subject: Re: Survey Monkey LOL, is it Friday already? -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Opela, Gary L CTR USAF ABW 72 ABW/SCOOA Sent: Thursday, September 30, 2010 7:31 AM To: arslist@ARSLIST.ORG Subject: Re: Survey Monkey Yeah... I was hoping no one would catch that :) But hey, Kinetic and Buoyant are business parters, and unless I'm losing it, Gidd is Buoyant (or at least he sinks slowly). -Rep for me Thanks, Gary Opela, Jr. Sr. Remedy Engineer Avaya Phone Admin RSP Cert, Sec+ COMM: 405 582 4272 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Shellman, David Sent: Thursday, September 30, 2010 7:37 AM To: arslist@ARSLIST.ORG Subject: Re: Survey Monkey Gidd? Did you mean to say John Sundberg? Dave -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Matthew Perrault Sent: Wednesday, September 29, 2010 10:04 PM To: arslist@ARSLIST.ORG Subject: Re: Survey Monkey LOL. I should charge him for the free advertisement! No, I just really like the product and the support staff that I've worked with there. Been very helpful, no run-around, no nonsense etc. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Opela, Gary L CTR USAF ABW 72 ABW/SCOOA Sent: Wednesday, September 29, 2010 2:19 PM To: arslist@ARSLIST.ORG Subject: Re: Survey Monkey Did Gidd pay you to say this??? :) Thanks, Gary Opela, Jr. Sr. Remedy Engineer Avaya Phone Admin RSP Cert, Sec+ COMM: 405 582 4272 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Matthew Perrault Sent: Wednesday, September 29, 2010 9:27 AM To: arslist@ARSLIST.ORG Subject: Re: Survey Monkey ** Have you guys thought about Kinetic's Survey module? It ties into Remedy REALLY well, has a web front end for customers to answer the surveys, Extremely customizable, and data driven. Also, The Support from Kinetic has been OUTSTANDING! I've had to contact them a couple of times, and I have been really impressed at how they handled the issue. If you're looking for a Survey tool to integrate into Remedy, I would really recommend Kinetic. Just my 2 cents, Matt P. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Roberts, Chas Sent: Wednesday, September 29, 2010 9:01 AM To: arslist@ARSLIST.ORG Subject: Re: Survey Monkey ** Just like any external application. You can launch it from a Remedy app in the usual fashion, of course. You can then download the survey results in Excel format and AR Import the interesting parts into Remedy. The full Pro version is ¼ the cost of the other one mentioned, for those who are curious. Yours truly, Charles H. Roberts, 4th Riverside County Information Technology Office: 951-486-7780 Cell: 951-840-8699 eMail: crobe...@riversidecountyit.org mailto:crobe...@riversidecountyit.org From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Chowdhury, Tauf Sent: Wednesday, September 29, 2010 6:53 AM To: arslist@ARSLIST.ORG Subject: Re: Survey Monkey ** I don't think it is. It's a web based tool. I'm trying to figure out if it can be done. Tauf Chowdhury | Forest Laboratories, Inc. Analyst, Service Management Mobile:646.483.2779 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Meyer, Jennifer L Sent: Wednesday, September 29, 2010 9:12 AM To: arslist@ARSLIST.ORG Subject: Re: Survey Monkey Out of curiosity, how does Survey Monkey tie in with Remedy? How is tenancy information tracked? Jennifer Meyer From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe DeSouza Sent: Tuesday, September 28, 2010 6:57 PM To: arslist@ARSLIST.ORG Subject: OT:Re: Anyone has made use of this web based survey engine? ** Hi Chas, I think I may have heard of Survey Monkey before.. I'm not intending to do anything with any of these at the moment but was just going through the features of the one I found just in case it is useful at some point. I will go through your suggestion too.. Thanks for that tip.. Joe From
Re: Survey Monkey
Did Gidd pay you to say this??? :) Thanks, Gary Opela, Jr. Sr. Remedy Engineer Avaya Phone Admin RSP Cert, Sec+ COMM: 405 582 4272 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Matthew Perrault Sent: Wednesday, September 29, 2010 9:27 AM To: arslist@ARSLIST.ORG Subject: Re: Survey Monkey ** Have you guys thought about Kinetic's Survey module? It ties into Remedy REALLY well, has a web front end for customers to answer the surveys, Extremely customizable, and data driven. Also, The Support from Kinetic has been OUTSTANDING! I've had to contact them a couple of times, and I have been really impressed at how they handled the issue. If you're looking for a Survey tool to integrate into Remedy, I would really recommend Kinetic. Just my 2 cents, Matt P. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Roberts, Chas Sent: Wednesday, September 29, 2010 9:01 AM To: arslist@ARSLIST.ORG Subject: Re: Survey Monkey ** Just like any external application. You can launch it from a Remedy app in the usual fashion, of course. You can then download the survey results in Excel format and AR Import the interesting parts into Remedy. The full Pro version is ¼ the cost of the other one mentioned, for those who are curious. Yours truly, Charles H. Roberts, 4th Riverside County Information Technology Office: 951-486-7780 Cell: 951-840-8699 eMail: crobe...@riversidecountyit.org mailto:crobe...@riversidecountyit.org From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Chowdhury, Tauf Sent: Wednesday, September 29, 2010 6:53 AM To: arslist@ARSLIST.ORG Subject: Re: Survey Monkey ** I don't think it is. It's a web based tool. I'm trying to figure out if it can be done. Tauf Chowdhury | Forest Laboratories, Inc. Analyst, Service Management Mobile:646.483.2779 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Meyer, Jennifer L Sent: Wednesday, September 29, 2010 9:12 AM To: arslist@ARSLIST.ORG Subject: Re: Survey Monkey Out of curiosity, how does Survey Monkey tie in with Remedy? How is tenancy information tracked? Jennifer Meyer From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe DeSouza Sent: Tuesday, September 28, 2010 6:57 PM To: arslist@ARSLIST.ORG Subject: OT:Re: Anyone has made use of this web based survey engine? ** Hi Chas, I think I may have heard of Survey Monkey before.. I'm not intending to do anything with any of these at the moment but was just going through the features of the one I found just in case it is useful at some point. I will go through your suggestion too.. Thanks for that tip.. Joe From: Roberts, Chas crobe...@riversidecountyit.org To: arslist@ARSLIST.ORG Sent: Tue, September 28, 2010 6:40:46 PM Subject: Re: Anyone has made use of this web based survey engine? ** Joe, Survey Monkey is the best thing for this purpose. It has a funny name but very good features and reliability, and you can use SurveyMK.com/yoursurveycode http://surveymk.com/yoursurveycode so it looks like Survey Marketing Yours truly, Charles H. Roberts, 4th Riverside County Information Technology Office: 951-486-7780 Cell: 951-840-8699 eMail: crobe...@riversidecountyit.org mailto:crobe...@riversidecountyit.org From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe DeSouza Sent: Tuesday, September 28, 2010 3:14 PM To: arslist@ARSLIST.ORG Subject: OT: Anyone has made use of this web based survey engine? ** http://www.esurveyspro.com/ I just came across it after I filled up a frequent traveler survey. It looks like they have a free edition too but appears like they might display advertisements etc on the free version.. Joe _attend WWRUG10 www.wwrug.com http://www.wwrug.com/ ARSlist: Where the Answers Are_ This email is confidential and intended solely for the use of the individual(s) to whom it is addressed. The information contained in this message may be privileged and confidential and protected from disclosure. If you are not the author's intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please delete all copies, both electronic and printed, and contact the author immediately. _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ E-mail correspondence to and from this address may be subject to the
Re: Set Fields from SQL
Roy, if you have more information on this, you can look up 'SQL Injection'. Thanks, Gary Opela, Jr. Sr. Remedy Engineer Avaya Phone Admin RSP Cert, Sec+ COMM: 405 582 4272 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Mueller, Doug Sent: Monday, September 27, 2010 12:27 PM To: arslist@ARSLIST.ORG Subject: Re: Set Fields from SQL Roy, What you are seeing is what is designed. We protect you against illegal SQL or someone trying to play with breaking your SQL by sticking SQL inside other SQL by properly protecting against any bad SQL by always quoting any text substituted into the command. This prevents anyone from mis-appropriating your SQL command with bad text. Now, you also found that we gave you an out. If you as Administrator make the ENTIRE SQL command a substitution, then we give up and say you are substituting the entire command so you must know what you are doing and we assume you are doing whatever protecting from bad SQL the customer may do. For those who wonder what does he mean bad sql? What if you had a command like the following: SELECT a FROM b WHERE ColName = '$subs parameter$' If the user would enter aa'; DROP TABLE xx; Select a from b where ColName = 'xyz as the data value for subs paramter They can complete the command, issue another SQL command, and then do something so that the command is valid again to avoid an error. This would allow bad SQL to be submitted by the customer. By always quoting and escaping any user quotes, we prevent that. If you create the entire command yourself, you have to protect against the end user entering text that is like the above that could affect your SQL command syntax I hope this explaination helps with why the system works the way it does. Doug Mueller -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Ashcraft, Roy W CTR USAF AFWA 2 SYOS/SYOE Sent: Wednesday, September 22, 2010 7:07 AM To: arslist@ARSLIST.ORG Subject: Re: Set Fields from SQL Never mind. A coworker suggested trying to build the enter SQL query in a separate character field and then substitute that into the SQL set fields rather than building it piecemeal there. That worked, it did not escape the single quotes using this action. Thanks, Roy //SIGNED// ROY ASHCRAFT, Contractor, 2 SOS/SYOE Remedy ARS Support, SAIC (402) 294-8225, DSN 271-8225 roy.ashcraft@offutt.af.mil -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Ashcraft, Roy W CTR USAF AFWA 2 SYOS/SYOE Sent: Wednesday, September 22, 2010 8:59 AM To: arslist@ARSLIST.ORG Subject: Set Fields from SQL -- Information from the mail header --- Sender: Action Request System discussion list(ARSList) ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: 'ISNUMBER' function?
Oh, come on Misi, let's not make this too easy now! We want to keep the pool of
developers small :)
Thanks,
Gary Opela, Jr.
Sr. Remedy Engineer
Avaya Phone Admin
RSP Cert, Sec+
COMM: 405 582 4272
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Misi Mladoniczky
Sent: Friday, September 17, 2010 2:11 AM
To: arslist@ARSLIST.ORG
Subject: Re: 'ISNUMBER' function?
Oops,
Forgot the wildcard characters in the LIKE statement:
It should read like this and nothing else:
Run If: 'SerialNumber' LIKE %[^0-9]%
Action: Message Error
Best Regards - Misi, RRR AB, http://rrr.se
Hi,
Are we not complicating things here? Why not use this simple strategy?
Run If: 'SerialNumber' LIKE [^0-9]
Action: Message Error
This will match non-digit characters, and I have used it since version 2.0
:-)
Best Regards - Misi, RRR AB, http://www.rrr.se
Products from RRR Scandinavia:
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.
The hard way: (This might be a solution if you have non-English
characters in there)
Filter 0:
Run-if: 'SerialNumber' != $NULL$
If-Action: Set fields: tmpInt = 0, tmpIsInt = 0, and tmpChar = $NULL$
If-Action: Call filter guide
Set a guide label named 'Start' at the beginning of the guide.
Filter 1:
Run-if: 'SerialNumber' != $NULL$ AND 'tmpIsInt' = 0
If-Action: Set Fields: tmpChar = SUBSTR($SerialNumber$, $tmpInt$,
$tmpInt$ + 1)
Filter 2:
Run-if: NOT('tmpChar' LIKE %[0-9]%)
If-Action: Set Fields: tmpIsInt = 1
If-Action: EXIT GUIDE or do a REPLACE($SerialNumber$, $tmpChar$, )
to get rid of the non-digit.
Else-Action: tmpInt = tmpInt + 1
Filter 3:
Run-if: tmpIsInt = 0 AND tmpInt LENGTH($SerialNumber$) + 1
If-Action: GO TO GUIDE LABEL = Start
Else-Action: Set Fields tmpInt = 0 and tmpChar = $NULL$
Else-Action: EXIT GUIDE
Filter 4: This is outside of the guide
Run-if: tmpIsInt = 1
If-Action: Set Fields: tmpIsInt = 0
If-Action: ERROR PLEASE ENTER ONLY INTEGERS or take whatever action
you want
I didn't test this out, so it might have a few adjustments that needs to
be made, but basically it will iterate through each character in the
SerialNumber field, checking to see if it is an integer. If it is not an
integer, it sets a flag (sets tmpIsInt = 1) and then exits the guide.
Then you can see if tmpIsInt = 1 and perform action on it. It also exits
the guide once it reaches the last character of the SerialNumber field.
This is determined by the tmpInt LENGTH($SerialNumber$) + 1 in the
Run-if for Filter 3. You might have to change it to tmpInt =
LENGTH($SerialNumber$) + 1 to accomidate the difference between
zero-indexed and non-zero indexed functions, I would have to test this.
Also, Filter 3, the LENGTH($SerialNumber$) will be modified if you
replace a non-digit character with . In this event, You would likely
need to perform setting tmpInt = tmpInt - 1 on filter 2 if you choose to
REPLACE($SerialNumber$, $tmpChar$, ).
Thanks,
Gary Opela, Jr.
Sr. Remedy Engineer
Avaya Phone Admin
RSP Cert, Sec+
COMM: 405 582 4272
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of
brian.bis...@goldstag.demon.co.uk
Sent: Thursday, September 16, 2010 2:11 PM
To: arslist@ARSLIST.ORG
Subject: Re: 'ISNUMBER' function?
**
I had to do something like this a long time ago. I needed to confirm
that a value was all numeric. I used the REPLACE function to replace all
numeric characters with nothing and if after doing it there was still a
value left the string must have at least one alpha or special character
in it.
This ought to work regardless of language and use of special characters.
Brian
Brian Bishop
Goldstag Consultants Ltd
+44(0)7973 746832
From: Mueller, Doug doug_muel...@bmc.com
Sender: Action Request System discussion list(ARSList)
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
--
This message was scanned by ESVA and is believed to be clean.
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
--
This message was scanned by ESVA and is believed to be clean.
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: 'ISNUMBER' function?
The hard way: (This might be a solution if you have non-English
characters in there)
Filter 0:
Run-if: 'SerialNumber' != $NULL$
If-Action: Set fields: tmpInt = 0, tmpIsInt = 0, and tmpChar = $NULL$
If-Action: Call filter guide
Set a guide label named 'Start' at the beginning of the guide.
Filter 1:
Run-if: 'SerialNumber' != $NULL$ AND 'tmpIsInt' = 0
If-Action: Set Fields: tmpChar = SUBSTR($SerialNumber$, $tmpInt$,
$tmpInt$ + 1)
Filter 2:
Run-if: NOT('tmpChar' LIKE %[0-9]%)
If-Action: Set Fields: tmpIsInt = 1
If-Action: EXIT GUIDE or do a REPLACE($SerialNumber$, $tmpChar$, )
to get rid of the non-digit.
Else-Action: tmpInt = tmpInt + 1
Filter 3:
Run-if: tmpIsInt = 0 AND tmpInt LENGTH($SerialNumber$) + 1
If-Action: GO TO GUIDE LABEL = Start
Else-Action: Set Fields tmpInt = 0 and tmpChar = $NULL$
Else-Action: EXIT GUIDE
Filter 4: This is outside of the guide
Run-if: tmpIsInt = 1
If-Action: Set Fields: tmpIsInt = 0
If-Action: ERROR PLEASE ENTER ONLY INTEGERS or take whatever action
you want
I didn't test this out, so it might have a few adjustments that needs to
be made, but basically it will iterate through each character in the
SerialNumber field, checking to see if it is an integer. If it is not an
integer, it sets a flag (sets tmpIsInt = 1) and then exits the guide.
Then you can see if tmpIsInt = 1 and perform action on it. It also exits
the guide once it reaches the last character of the SerialNumber field.
This is determined by the tmpInt LENGTH($SerialNumber$) + 1 in the
Run-if for Filter 3. You might have to change it to tmpInt =
LENGTH($SerialNumber$) + 1 to accomidate the difference between
zero-indexed and non-zero indexed functions, I would have to test this.
Also, Filter 3, the LENGTH($SerialNumber$) will be modified if you
replace a non-digit character with . In this event, You would likely
need to perform setting tmpInt = tmpInt - 1 on filter 2 if you choose to
REPLACE($SerialNumber$, $tmpChar$, ).
Thanks,
Gary Opela, Jr.
Sr. Remedy Engineer
Avaya Phone Admin
RSP Cert, Sec+
COMM: 405 582 4272
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of
brian.bis...@goldstag.demon.co.uk
Sent: Thursday, September 16, 2010 2:11 PM
To: arslist@ARSLIST.ORG
Subject: Re: 'ISNUMBER' function?
**
I had to do something like this a long time ago. I needed to confirm
that a value was all numeric. I used the REPLACE function to replace all
numeric characters with nothing and if after doing it there was still a
value left the string must have at least one alpha or special character
in it.
This ought to work regardless of language and use of special characters.
Brian
Brian Bishop
Goldstag Consultants Ltd
+44(0)7973 746832
From: Mueller, Doug doug_muel...@bmc.com
Sender: Action Request System discussion list(ARSList)
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: 'ISNUMBER' function?
I don't know if you can do it or not with developer studio, but it would be very nice if we could create our own functions and then remedy would add it to the function set within the system. This would allow for us to create things like ISNUMBER and such. Basically we could reuse some embedded code and make things more pretty. We would need the ability to use variables instead of having to add temporary fields to the form. Maybe allow us to choose between VBS, Javascript, or maybe LUA or something like that to embed within the function. Then the scripts that were written would just receive arguments, and then return values, just like functions within standard programming languages. There's an enhancement request for you. Thanks, Gary Opela, Jr. Sr. Remedy Engineer Avaya Phone Admin RSP Cert, Sec+ COMM: 405 582 4272 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of brian.bis...@goldstag.demon.co.uk Sent: Thursday, September 16, 2010 2:11 PM To: arslist@ARSLIST.ORG Subject: Re: 'ISNUMBER' function? ** I had to do something like this a long time ago. I needed to confirm that a value was all numeric. I used the REPLACE function to replace all numeric characters with nothing and if after doing it there was still a value left the string must have at least one alpha or special character in it. This ought to work regardless of language and use of special characters. Brian Brian Bishop Goldstag Consultants Ltd +44(0)7973 746832 From: Mueller, Doug doug_muel...@bmc.com Sender: Action Request System discussion list(ARSList) ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
ARAPI.NET
Okay, I've done this before, however I've reimaged my computer. I've tried to set everything up, but I'm still getting an error. Here are the steps which I've taken to set up my new environment: -- 1) Create a folder: C:\ARAPI.NET 2) Unizip the ARAPI71.NET.zip to c:\ARAPI.NET; move files directly into ARAPI.NET 3) Created a new Environment Variable named LIB with the value of C:\ARAPI.NET 4) Added to the EV PATH the value C:\ARAPI.NET 5) Created a new EV named ARTCPPORT and set it to the value I have in my AR Server, not to 5920 6) Used RegAsm from Microsoft.net/framework/2.x to register BMC.ARSystem.dll 7) Rebooted computer 8) Opened new visual basic project in Microsoft Visual Studio 2008 9) Added Reference to C:\ARAPI.NET\BMC.ARSystem.dll 10) Added Reference to C:\ARAPI.NET\BMC.arnettoc.dll 11) Added the following code: -- Imports BMC.ARSystem Module Module1 Sub Main() Dim ARServer As New BMC.ARSystem.Server Try ARServer.Login(Server, User, Password) Console.WriteLine(Successfully logged in to remedy server) ARServer.Logout() Catch ex As Exception Console.WriteLine(ex) System.Threading.Thread.Sleep(1000) End Try End Sub End Module -- 12) Ran in debug mode and received the following error: -- System.IO.FileNotFoundException: The specified module could not be found. (Excep tion from HRESULT: 0x8007007E) at BMC.ARSystem.Server._Eval(Object v) at BMC.ARSystem.Server._performLogin(String methodName, String server, String user, String password, String authentication, String locale, String charSet, In t32 port, String apiCmdLog, String apiResLog, Boolean logInitAndTerm) at BMC.ARSystem.Server.Login(String server, String user, String password, Str ing authentication, String locale, String charSet, Int32 port) at BMC.ARSystem.Server.Login(String server, String user, String password, Str ing authentication, Int32 port) at BMC.ARSystem.Server.Login(String server, String user, String password, Str ing authentication) at BMC.ARSystem.Server.Login(String server, String user, String password) at ConsoleApplication1.Module1.Main() in C:\Users\Gary.Opela\AppData\Local\Te mporary Projects\ConsoleApplication1\Module1.vb:line 7 -- Like I said, I've done this before and it worked. This is very simple and straightforward, just trying to open a connection. I've verified the user name and password and server are correct. The error is saying I'm missing a module, but everything that I can find is included and is in its place. I've tried this both on Vista and on Windows Server 2k3. I'm running AR System 7.1 Any help is greatly appreciated. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Help with Active Link Button Close Window action
You could have the user try Ctrl-y after entering the data. That performs a Save action, and then automatically drops down to the next record in the list, setting focus to the same field which had the focus on the previous ticket. This is great if you are having to manually modify the same field on numerous records. Thanks, Gary Opela, Jr. Sr. Remedy Engineer Avaya Phone Admin RSP Cert, Sec+ COMM: 405 582 4272 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Drew Shuller Sent: Thursday, August 19, 2010 12:46 PM To: arslist@ARSLIST.ORG Subject: Re: Help with Active Link Button Close Window action ** More info, I've tried a couple of OPERATION keywords, Get, Set, but those don't seem to work. I'm on a windows 6.3 install. Drew On Aug 19, 2010, at 7:49 AM, Drew Shuller drew.shul...@gmail.com wrote: Hello everyone, I'm trying to make a button save and close a record in modify mode. Easy enough, yes, but I want the button to close the window only if the record has been opened from a results list. Eventually I want to add a PERFORM-ACTION-NEXT action to the AL so that the button will save the record, close the current one, and then open the next one in the list. Any help? Muchas Gracias! Drew Shuller Soto Cano Air Base Comayagua, Honduras _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_
Re: Self-Join
Self join: TableA ___ FieldA FieldB FieldC Assuming Field A is the unique identifier Assuming Field B is the field that is being duplicated, such as email address SELECT a.FieldA, b.FieldA, a.FieldB from TableA a, TableA b WHERE a.FieldB = b.FieldB AND a.FieldA != b.FieldA This will join up the two tables based on FieldB, and will return results where the unique identifier is different on each one. I've used this a lot to clean out duplicate records. Thanks, Gary Opela, Jr. Sr. Remedy Engineer Avaya Phone Admin RSP Cert, Sec+ COMM: 405 582 4272 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Drew Shuller Sent: Thursday, July 22, 2010 10:15 AM To: arslist@ARSLIST.ORG Subject: Re: Self-Join Joe, Sean, thank you, that is probably the best way. The requirement is to provide backup customer info in case our AD integration fails. My thoughts are to load a snapshot of data gathered from actual help desk records (where there are a lot of duplicates!) every so often into a backup form and than enable some AL's. I'm still wondering how to do the self-join, it may help me with another requirement. Drew ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Escalation or Filter
I agree with everyone else, mainly because of threading issues. But I guess with 7 you can increase the number of escalation threads. Still, if you have a lot of other escalations, then you could potentially tie up your threads. I run 2 threads just in case something does happen to tie up 1. I do have some escalations that take a while. I was using some escalations to kick of exe files on my server to do jobs, but then I just offloaded those to sql server agent job because the remedy escalations were bogging down at night. Just bear in mind that each thread is a single-file line. Thanks, Gary Opela, Jr. Sr. Remedy Engineer Avaya Phone Admin RSP Cert, Sec+ COMM: 405 582 4272 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Chuck Sent: Thursday, July 01, 2010 1:31 PM To: arslist@ARSLIST.ORG Subject: Re: Escalation or Filter Yup, Escalation to start the Event, Filter to Perform the Action... On Jul 1, 1:01 pm, Grooms, Frederick W frederick.w.gro...@xo.com wrote: I prefer to use the Escalation sets field and a Filter does the work method. The only real advantage of using this method is that you can test it from the user tool and log the actions locally (instead of having to read server side logs). Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Brittain, Mark Sent: Thursday, July 01, 2010 11:15 AM To: arsl...@arslist.org Subject: Escalation or Filter ** Hi All From a performance perspective which would be better? Escalation on Form A set field and push fields to create a new record on Form B Escalation on Form A set field. Filter on Form A does the push fields to create a new record on Form B. ARS 6.3 patch 20 Oracle 9.2 SunOS 5.9 Thanks Mark Mark Brittain Remedy Developer NaviSite mbritt...@navisite.com (315) 453-2912 x5335 (Phone) (315) 317.2897 (Cell) ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org attend wwrug10www.wwrug.comARSlist: Where the Answers Are- Hide quoted text - - Show quoted text - ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Methods to display PopUp window on mutliple user's client screen without using Remedy Alert client
I sent this once, but I don't think it went through. I have created a view field on my main form. Then I created a new form. The new form has a character field on it. On the main form, I placed an active link. The active link runs on 30 second intervals. It checks the new form to see if there is data in the character field. If there is, it sets the view field to the contents of the character field, adding html marquee tags at the beginning and end. The effect is to give a scrolling banner at the top of my remedy form. This is very beneficial in broadcasting messages to the users to let them know if there are outages that might increase their calls. You could tweak this some to allow it to only run for certain groups. Basically, what you are wanting to do is usually handled through emails though. Thanks, Gary Opela, Jr. Sr. Remedy Engineer Avaya Phone Admin RSP Cert, Sec+ COMM: 405 582 4272 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of LJ LongWing Sent: Tuesday, June 29, 2010 11:34 AM To: arslist@ARSLIST.ORG Subject: Re: Methods to display PopUp window on mutliple user's client screen without using Remedy Alert client ** You could try this...never done it but you could try. Create a global field on any form you want to be able perform this 'popup' and have it set with the record's create date on that form Create another Global field that it set by an interval AL that gets the same information, if the information gotten via interval is different than the one in the other global field, you know you have a new record and take appropriate action. It wouldn't be immediate, but it would provide a method to determine when a new record was created and take action on ityour action is anything you want. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Anderson Debra (PRN) Sent: Monday, June 28, 2010 2:22 PM To: arslist@ARSLIST.ORG Subject: Methods to display PopUp window on mutliple user's client screen without using Remedy Alert client ** Hi Everyone, We're using Remedy 7.0. I can't think of a way to do this but perhaps some of you Remedy Gurus may have a solution. My user's want to see a popup message window displayed for all members of their group when a new record is added to a specific form. We are not using Remedy Alert client (which could do this) does anyone know any other method to make this happen - I can't see any way to do this. My plan-B was to suggest an email notification but this is not really what they are asking for. Thanks Debra -- -- -- -- -- -- -- -- -- -- Debra Anderson 415 808 9118 direct | 600 Harrison St., 4th Floor, San Francisco CA 94107 Tomorrow's Network for Today's Shopper http://www.prn.com P Think Green- please do not print this email unless necessary This e-mail (including any attachments) is meant for only the intended recipient of the transmission, and may include confidential information. If you are not the intended recipient or you received this e-mail in error, any review, use, dissemination, distribution, or copying of this e-mail is strictly prohibited. If you have received this message in error, please notify the sender immediately by telephone at (415) 808-3500 or by return e-mail and delete this e-mail, along with any attachments and copies, from your system. Thank you. _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: IIS config being corrupted
Ron, http://support.microsoft.com/kb/885654 has a great write-up on this. The KB article mentions permissions issues on registry keys and shows how to resolve them. I'm working it right now and I'll let you know my result. Thanks, Gary Opela, Jr. Sr. Remedy Engineer Avaya Phone Admin RSP Cert, Sec+ COMM: 405 582 4272 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Smith, Ron [TBC] Sent: Thursday, June 03, 2010 3:45 PM To: arslist@ARSLIST.ORG Subject: IIS config being corrupted We have two brand new Win 2003 VMWare instances that serve as our Midtier servers. We are running version 6.3 Patch 21 of both Midtier and AR server. These were brought up in January, one for our Production environment and one for our Development environment. Back in April, our Production servers IIS configuration became corrupt. It would not start back up. In the event logs, we saw that it was a slow degradation starting a 7-10 days prior, where it began having to restart IIS. After that period, IIS would no longer start up and our users got the error of Service Unavailable. We swapped our Dev server into Prod, and rebuilt the old Prod server into the new Dev server. Another 6 weeks go by and the new Prod Server had the same issue, completely shutting down on Memorial day. So we swapped out the servers again, taking the Dev server and making it the Prod server. I have a gut feeling that we will see this again. The previous servers were running Windows 2000, and ran flawlessly for 5 years. We are tentatively upgrading later this year, but I really do not want to go through this exercise every 6 weeks until we finally have them upgraded. Has anyone seen this kind of behavior? Thanks in advance, Ron Smith Remedy/Web Developer Providence Health Services OR ron.sm...@providence.org 503-216-7866 This message is intended for the sole use of the addressee, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: IIS config being corrupted
I installed JDK 1.6 trying to fix my issue with JSP pages, after re-installign the MT 6.3 P 21 that I'm also running, along with servlet exec 5.0 in a VM instance. I have the identical environment to you. After installing JDK 1.6 (6u20), I begin to get the Service Unavailable error also. I suspect that if you view your Event Log - Application Log, you'll see the errors. I just checked, and for some reason, the errors I was seeing yesterday are not being generated. If you go to http://www.go4expert.com/forums/showthread.php?t=545 they have a little write-up on it. It looks to be an issue maybe with VM. I tried doing what all they suggested on the write-up (In the support.microsoft.com link), but it didn't fix the issue. Also, I tried what the write-up itself stated, setting isolation mode to run www service in iis 5.0 isolation mode. I tried that awhile back and it totally messed up IIS where it would instantly crash as soon as it came up. You might look at that page though, some of the comments state that it helped them, and they were using VM also. I'd be interested in what you did if you get it working. Again, I only started having this issue whenever I installed JDK 1.6 update 20. I did that because whenever I went to re-install the MT to fix other issues which I was having, I was heartily prompted with an error message stating no JDK was installed and began to wonder if that was causing my issues with some of the JSP pages not serving up. Thanks, Gary Opela, Jr. Sr. Remedy Engineer Avaya Phone Admin RSP Cert, Sec+ COMM: 405 582 4272 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe D'Souza Sent: Thursday, June 03, 2010 4:52 PM To: arslist@ARSLIST.ORG Subject: Re: IIS config being corrupted Anything that gets written to the Windows Event log (Application, System, etc) at the time the server goes down? Anything that you see in those same logs at the time that you attempt to bring up the server once it is down but when it fails to come back up? Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Smith, Ron [TBC] Sent: Thursday, June 03, 2010 5:20 PM To: arslist@ARSLIST.ORG Subject: Re: IIS config being corrupted Oh yeah, I guess I should have included that. We are running ServletExec 5.0, which was the preferred Servlet engine back then. Thanks, Ron Smith Remedy/Web Developer Providence Health Services OR ron.sm...@providence.org 503-216-7866 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Chuck Sent: Thursday, June 03, 2010 2:17 PM To: arslist@ARSLIST.ORG Subject: Re: IIS config being corrupted If you are using Tomcat, then Use Apache web server. OR don't use Apache, use Tomcat on Port 80 w/APR it will serve files just as fast. But if you need a web server for other reasons, then try Apache - Tomcat combination, the Mod)JK AJP protocol between Apache and Tomcat is a bit faster than the IIS Tomcat redirector ISAPI. On Jun 3, 3:45 pm, Smith, Ron [TBC] ron.sm...@providence.org wrote: We have two brand new Win 2003 VMWare instances that serve as our Midtier servers. We are running version 6.3 Patch 21 of both Midtier and AR server. These were brought up in January, one for our Production environment and one for our Development environment. Back in April, our Production servers IIS configuration became corrupt. It would not start back up. In the event logs, we saw that it was a slow degradation starting a 7-10 days prior, where it began having to restart IIS. After that period, IIS would no longer start up and our users got the error of Service Unavailable. We swapped our Dev server into Prod, and rebuilt the old Prod server into the new Dev server. Another 6 weeks go by and the new Prod Server had the same issue, completely shutting down on Memorial day. So we swapped out the servers again, taking the Dev server and making it the Prod server. I have a gut feeling that we will see this again. The previous servers were running Windows 2000, and ran flawlessly for 5 years. We are tentatively upgrading later this year, but I really do not want to go through this exercise every 6 weeks until we finally have them upgraded. Has anyone seen this kind of behavior? Thanks in advance, Ron Smith Remedy/Web Developer Providence Health Services OR ron.sm...@providence.org 503-216-7866 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Mid-Tier 6.3 p21 not serving up SOME of the JSP pages
Joe, I'm troubleshooting two problems. The HTTP 500 error is not related to being able to log into the mid-tier, only to being able to load some of the configuration pages. My other error is the standard ARERR[623] Authentication Failed. It is with the back-end permissions. So, I went in to the config page to change the password set with my remedy server to which I authenticate with my remedy server, but that page doesn't serve up. So, because of the first listed error, I cannot resolve the second listed error! I'll try rolling back the version of Java, but I'm not sure if that will fly with our server admins. The error with serving up the JSP pages started quite some time ago, long before I upgraded my AR Server. Thanks, Gary Opela, Jr. Sr. Remedy Engineer Avaya Phone Admin RSP Cert, Sec+ COMM: 405 582 4272 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe D'Souza Sent: Tuesday, June 01, 2010 1:02 PM To: arslist@ARSLIST.ORG Subject: Re: Mid-Tier 6.3 p21 not serving up SOME of the JSP pages Gary, Actually 500 http error code represents an internal web server error. There is probably nothing wrong with the page or permissions itself. It may display if you hit refresh. These errors are usually temporary caused by a temporary internal web server problem. Did you try refreshing the page? Does it work? You may also want to check your version of the JDK and JRE installed on your server. Stick to a recommended version, do not go too far ahead and definitely do not go even a single patch or version lower.. Going lower in my past experience causes problems 90% of the times and going too far ahead sometimes works, and sometimes works with problems and sometimes doesn't work at all... Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Opela, Gary L CTR USAF ABW 72 ABW/SCOOA Sent: Tuesday, June 01, 2010 10:01 AM To: arslist@ARSLIST.ORG Subject: Re: Mid-Tier 6.3 p21 not serving up SOME of the JSP pages Joe, thanks for the response. It is HTTP 500 error. The website cannot display the page It's just perplexing why some of the jsp pages load, but not others. I was hoping to avoid a re-install. This part hasn't worked for quite some time, and I'm afraid it's because we are running multiple application pools in IIS. I might just need to change Servlet Exec to run in AS mode instead of ISAPI. Has anyone had to do this before? Thanks, Gary Opela, Jr. Sr. Remedy Engineer Avaya Phone Admin RSP Cert, Sec+ COMM: 405 582 4272 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe D'Souza Sent: Saturday, May 29, 2010 11:44 AM To: arslist@ARSLIST.ORG Subject: Re: Mid-Tier 6.3 p21 not serving up SOME of the JSP pages ** Gary, Have you tried re-installing the mid-tier? Unless you had custom modifications to the login or logout pages, you will not impact much by re-installing. You could always back up customizations and replace these after your installs. Also when the page is not displayed, what is the http error number/code that you receive? Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Opela, Gary L CTR USAF ABW 72 ABW/SCOOA Sent: Thursday, May 27, 2010 10:20 AM To: arslist@ARSLIST.ORG Subject: Mid-Tier 6.3 p21 not serving up SOME of the JSP pages ** Mid-Tier 6.3 P 021 AR Server 7.1 Windows 2k3 I have tested out NewAtlanta servlet exec to make sure it is working. They suggest going to the test page that displays the current time (https://localhost/servlet/DateServlet, that all works. Login.jsp works. Config.jsp works. From the Configuration Tool page, I get the following result: Overview (/arsys/shared/config/config_overview.jsp) works General Settings (/arsys/shared/config/config_general.jsp) works AR Server Settings (/arsys/shared/config/config_arslist.jsp) works Cache Settings (/arsys/shared/config/config_cache.jsp) works Web Service Settings (arsys/shared/config/config_webservice.jsp) DOES NOT WORK ß this is not a big deal for this one. Log Settings (arsys/shared/config/config_logs.jsp) DOES NOT WORK Change Password (arsys/shared/config/config_password.jsp) DOES NOT WORK Also that doesn't work, from the AR Server Settings page: Add Server (arsys/shared/config/config_add_arserver.jsp) and Edit (arsys/servlet/DeleteServerServlet?) buttons don't work. The pages that don't load all give me The website cannot display the page error. I thought at first it was New Atlanta, I read that it can have issues with IIS if you are using multiple application pools, which I am. However, if it were New Atlanta, why would
Re: Mid-Tier 6.3 p21 not serving up SOME of the JSP pages
I'm running ARServer 7.1. I was hoping to avoid upgrading to 7.1 because I cannot use tomcat. Will my existing instance of new Atlanta work with 7.1, or would there be licensing issues? Thanks, Gary Opela, Jr. Sr. Remedy Engineer Avaya Phone Admin RSP Cert, Sec+ COMM: 405 582 4272 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Donald Morton Sent: Wednesday, June 02, 2010 2:42 PM To: arslist@ARSLIST.ORG Subject: Re: Mid-Tier 6.3 p21 not serving up SOME of the JSP pages Midtier 7.0 works fine against the 6.3 arserverd, but I think there are issues with webservices if you use the 7.1 midtier against a 6.3 arserverd. Sent from my iPod On Jun 2, 2010, at 1:46 PM, Joe D'Souza jdso...@shyle.net wrote: If the java version does not match exactly then you might have a business case for your server admins that they need to respect the requirement for the version of Mid-Tier you are running.. Or get approvals for upgrading your mid-tier to a higher version. In my past experience Mid-tier 7.x works fine with ARS 6.x. I haven't really encountered any problems (I was on Linux as far as the Mid-tiers were concerned when I did that though). Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Opela, Gary L CTR USAF ABW 72 ABW/SCOOA Sent: Wednesday, June 02, 2010 9:46 AM To: arslist@ARSLIST.ORG Subject: Re: Mid-Tier 6.3 p21 not serving up SOME of the JSP pages Joe, I'm troubleshooting two problems. The HTTP 500 error is not related to being able to log into the mid-tier, only to being able to load some of the configuration pages. My other error is the standard ARERR[623] Authentication Failed. It is with the back-end permissions. So, I went in to the config page to change the password set with my remedy server to which I authenticate with my remedy server, but that page doesn't serve up. So, because of the first listed error, I cannot resolve the second listed error! I'll try rolling back the version of Java, but I'm not sure if that will fly with our server admins. The error with serving up the JSP pages started quite some time ago, long before I upgraded my AR Server. Thanks, Gary Opela, Jr. Sr. Remedy Engineer Avaya Phone Admin RSP Cert, Sec+ COMM: 405 582 4272 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe D'Souza Sent: Tuesday, June 01, 2010 1:02 PM To: arslist@ARSLIST.ORG Subject: Re: Mid-Tier 6.3 p21 not serving up SOME of the JSP pages Gary, Actually 500 http error code represents an internal web server error. There is probably nothing wrong with the page or permissions itself. It may display if you hit refresh. These errors are usually temporary caused by a temporary internal web server problem. Did you try refreshing the page? Does it work? You may also want to check your version of the JDK and JRE installed on your server. Stick to a recommended version, do not go too far ahead and definitely do not go even a single patch or version lower.. Going lower in my past experience causes problems 90% of the times and going too far ahead sometimes works, and sometimes works with problems and sometimes doesn't work at all... Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Opela, Gary L CTR USAF ABW 72 ABW/SCOOA Sent: Tuesday, June 01, 2010 10:01 AM To: arslist@ARSLIST.ORG Subject: Re: Mid-Tier 6.3 p21 not serving up SOME of the JSP pages Joe, thanks for the response. It is HTTP 500 error. The website cannot display the page It's just perplexing why some of the jsp pages load, but not others. I was hoping to avoid a re-install. This part hasn't worked for quite some time, and I'm afraid it's because we are running multiple application pools in IIS. I might just need to change Servlet Exec to run in AS mode instead of ISAPI. Has anyone had to do this before? Thanks, Gary Opela, Jr. Sr. Remedy Engineer Avaya Phone Admin RSP Cert, Sec+ COMM: 405 582 4272 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe D'Souza Sent: Saturday, May 29, 2010 11:44 AM To: arslist@ARSLIST.ORG Subject: Re: Mid-Tier 6.3 p21 not serving up SOME of the JSP pages ** Gary, Have you tried re-installing the mid-tier? Unless you had custom modifications to the login or logout pages, you will not impact much by re-installing. You could always back up customizations and replace these after your installs. Also when the page is not displayed, what is the http error number/ code that you receive? Joe -Original Message- From: Action Request System discussion list
Re: Mid-Tier 6.3 p21 not serving up SOME of the JSP pages
Joe, thanks for the response. It is HTTP 500 error. The website cannot display the page It's just perplexing why some of the jsp pages load, but not others. I was hoping to avoid a re-install. This part hasn't worked for quite some time, and I'm afraid it's because we are running multiple application pools in IIS. I might just need to change Servlet Exec to run in AS mode instead of ISAPI. Has anyone had to do this before? Thanks, Gary Opela, Jr. Sr. Remedy Engineer Avaya Phone Admin RSP Cert, Sec+ COMM: 405 582 4272 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe D'Souza Sent: Saturday, May 29, 2010 11:44 AM To: arslist@ARSLIST.ORG Subject: Re: Mid-Tier 6.3 p21 not serving up SOME of the JSP pages ** Gary, Have you tried re-installing the mid-tier? Unless you had custom modifications to the login or logout pages, you will not impact much by re-installing. You could always back up customizations and replace these after your installs. Also when the page is not displayed, what is the http error number/code that you receive? Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Opela, Gary L CTR USAF ABW 72 ABW/SCOOA Sent: Thursday, May 27, 2010 10:20 AM To: arslist@ARSLIST.ORG Subject: Mid-Tier 6.3 p21 not serving up SOME of the JSP pages ** Mid-Tier 6.3 P 021 AR Server 7.1 Windows 2k3 I have tested out NewAtlanta servlet exec to make sure it is working. They suggest going to the test page that displays the current time (https://localhost/servlet/DateServlet, that all works. Login.jsp works. Config.jsp works. From the Configuration Tool page, I get the following result: Overview (/arsys/shared/config/config_overview.jsp) works General Settings (/arsys/shared/config/config_general.jsp) works AR Server Settings (/arsys/shared/config/config_arslist.jsp) works Cache Settings (/arsys/shared/config/config_cache.jsp) works Web Service Settings (arsys/shared/config/config_webservice.jsp) DOES NOT WORK ß this is not a big deal for this one. Log Settings (arsys/shared/config/config_logs.jsp) DOES NOT WORK Change Password (arsys/shared/config/config_password.jsp) DOES NOT WORK Also that doesn't work, from the AR Server Settings page: Add Server (arsys/shared/config/config_add_arserver.jsp) and Edit (arsys/servlet/DeleteServerServlet?) buttons don't work. The pages that don't load all give me The website cannot display the page error. I thought at first it was New Atlanta, I read that it can have issues with IIS if you are using multiple application pools, which I am. However, if it were New Atlanta, why would some of the jsps serve up and some not? Also worth mentioning, the JSP issue was here prior to my upgrading of the remedy server to 7.1, and the web server and ar server are on separate boxes. My root error I'm trying to troubleshoot is one that I've seen other people run into a lot: ARERR[623] Authentication failed. This is not an authentication failed error due to my remedy login account and password not matching, this is an issue with the Mid-Tier itself trying to connect to the remedy server. Thanks, Gary Opela, Jr. _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Mid-Tier 6.3 p21 not serving up SOME of the JSP pages
Mid-Tier 6.3 P 021 AR Server 7.1 Windows 2k3 I have tested out NewAtlanta servlet exec to make sure it is working. They suggest going to the test page that displays the current time (https://localhost/servlet/DateServlet, that all works. Login.jsp works. Config.jsp works. From the Configuration Tool page, I get the following result: Overview (/arsys/shared/config/config_overview.jsp) works General Settings (/arsys/shared/config/config_general.jsp) works AR Server Settings (/arsys/shared/config/config_arslist.jsp) works Cache Settings (/arsys/shared/config/config_cache.jsp) works Web Service Settings (arsys/shared/config/config_webservice.jsp) DOES NOT WORK ß this is not a big deal for this one. Log Settings (arsys/shared/config/config_logs.jsp) DOES NOT WORK Change Password (arsys/shared/config/config_password.jsp) DOES NOT WORK Also that doesn't work, from the AR Server Settings page: Add Server (arsys/shared/config/config_add_arserver.jsp) and Edit (arsys/servlet/DeleteServerServlet?) buttons don't work. The pages that don't load all give me The website cannot display the page error. I thought at first it was New Atlanta, I read that it can have issues with IIS if you are using multiple application pools, which I am. However, if it were New Atlanta, why would some of the jsps serve up and some not? Also worth mentioning, the JSP issue was here prior to my upgrading of the remedy server to 7.1, and the web server and ar server are on separate boxes. My root error I'm trying to troubleshoot is one that I've seen other people run into a lot: ARERR[623] Authentication failed. This is not an authentication failed error due to my remedy login account and password not matching, this is an issue with the Mid-Tier itself trying to connect to the remedy server. Thanks, Gary Opela, Jr. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Remedy Upgrade -- Now DSO doesn't work -- Urgent!
I'm running Java version 1.6_16. I will upgrade to Update 20 and see if that fixes it. I think that is probably a good indication, I forgot that whenever the log files say that remedy is unable to find the minor version, that usually means that I'm using an unsupported version. My confusion is just htat 1.6 update 16 is not that old. I'll update version quickly and then let you know how it goes. Thanks for the suggestion. Thanks, Gary Opela, Jr. Sr. Remedy Engineer Avaya Phone Admin RSP Cert, Sec+ COMM: 405 582 4272 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Monday, May 24, 2010 9:07 AM To: arslist@ARSLIST.ORG Subject: Re: Remedy Upgrade -- Now DSO doesn't work -- Urgent! ** It looks like 7.1 is having a problem with your Java version Unable to extract minor version from Java VM version string: 16.0-b13 and that is what is causing DSO not to run. What version of Java are you running? From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Opela, Gary L CTR USAF ABW 72 ABW/SCOOA Sent: Sunday, May 23, 2010 5:14 PM To: arslist@ARSLIST.ORG Subject: Remedy Upgrade -- Now DSO doesn't work -- Urgent! ** I upgraded from AR System version 6.3 to version 7.1 (Version 7.1.00 Build 200708221849). I upgraded the system, all went well. I then created the licenses in the license form, including the DSO license. However, whenever I try to DSO a ticket from my server to another server, below are the lines generated in the arerror.log: Sun May 23 16:37:56 2010 : Action Request System(R) Server Version 7.1.00 Build 200708221849 (c) Copyright 1991-2007 BMC Software, Inc. Sun May 23 16:37:56 2010 390695 : Unable to extract minor version from Java VM version string: 16.0-b13 (ARERR 9130) Sun May 23 16:50:38 2010 Distrib : The server being accessed is not licensed for the Distributed Server Option (ARDSERR 3106) Sun May 23 16:50:38 2010 Remote Server Name Sun May 23 16:51:09 2010 Distrib : The server being accessed is not licensed for the Distributed Server Option (ARDSERR 3106) Sun May 23 16:51:09 2010 Remote Server Name Sun May 23 16:51:09 2010 Distrib : Pending distributed operation for this entry canceled due to error (ARDSNOTE 3003) Sun May 23 16:51:09 2010 Ticket Number - Local Form Name If the remote server is version 6.3, will I not be able to DSO tickets to it from a 7.1 server?? Thanks, Gary Opela, Jr. Sr. Remedy Engineer Avaya Phone Admin RSP Cert, Sec+ COMM: 405 582 4272 _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Remedy Upgrade -- Now DSO doesn't work -- Urgent!
I upgraded from AR System version 6.3 to version 7.1 (Version 7.1.00 Build 200708221849). I upgraded the system, all went well. I then created the licenses in the license form, including the DSO license. However, whenever I try to DSO a ticket from my server to another server, below are the lines generated in the arerror.log: Sun May 23 16:37:56 2010 : Action Request System(R) Server Version 7.1.00 Build 200708221849 (c) Copyright 1991-2007 BMC Software, Inc. Sun May 23 16:37:56 2010 390695 : Unable to extract minor version from Java VM version string: 16.0-b13 (ARERR 9130) Sun May 23 16:50:38 2010 Distrib : The server being accessed is not licensed for the Distributed Server Option (ARDSERR 3106) Sun May 23 16:50:38 2010 Remote Server Name Sun May 23 16:51:09 2010 Distrib : The server being accessed is not licensed for the Distributed Server Option (ARDSERR 3106) Sun May 23 16:51:09 2010 Remote Server Name Sun May 23 16:51:09 2010 Distrib : Pending distributed operation for this entry canceled due to error (ARDSNOTE 3003) Sun May 23 16:51:09 2010 Ticket Number - Local Form Name If the remote server is version 6.3, will I not be able to DSO tickets to it from a 7.1 server?? Thanks, Gary Opela, Jr. Sr. Remedy Engineer Avaya Phone Admin RSP Cert, Sec+ COMM: 405 582 4272 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: sql server
Thanks, LJ. I have looked forever for the stupid compatibility matrix for 7.1, but cannot find it anywhere. If anyone has a link to it, please provide, or if you have it, email it to me privately! Thanks, Gary Opela, Jr. Sr. Remedy Engineer Avaya Phone Admin RSP Cert, Sec+ COMM: 405 582 4272 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of LJ LongWing Sent: Wednesday, May 19, 2010 4:00 PM To: arslist@ARSLIST.ORG Subject: Re: sql server ** WellGary, as I'm sure you are aware that's not a supported configuration...I don't have any experience with it kuz I try to stay within supported configurationsbut BMC I'm sure wouldn't recommend it J From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Opela, Gary L CTR USAF ABW 72 ABW/SCOOA Sent: Wednesday, May 19, 2010 2:42 PM To: arslist@ARSLIST.ORG Subject: sql server ** Has anyone experienced any issues using SQL Server 2k8 standard edition instead of enterprise edition? This is with 7.1 version of AR System. Thanks, Gary Opela, Jr. Sr. Remedy Engineer Avaya Phone Admin RSP Cert, Sec+ COMM: 405 582 4272 _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: sql server
Okay, finally got a compatibility matrix, thanks for it you know who you are. So, the following line for 7.1: 32 or 64 bit x86 PC Compatible Windows 2000, 2003 (32 or x64) [Server, Advanced Server, Datacenter, Enterprise, Standard] Microsoft SQL Server 2000, 2005 (32 or 64-bit) [Enterprise, Standard] Oracle 9i, 10g [Standard, Std One, Enterprise + RAC] IBM DB2 8.2.2, 9.1 [Enterprise, Workgroup, Workgroup Unlimited] This clearly states that SQL Server 2000 32-bit Enterprise Edition will work with BMC AR System 7.1. However, I'm getting a bunch of errors: ARSql.log: SQL TID: 003692 RPC ID: 00 Queue: Admin Client-RPC: 00USER: /* Mon May 17 2010 13:23:09.5320 */*** ERROR *** Cannot drop the table 'AR0int3692', because it does not exist in the system catalog. (SQL Server 3701) SQL TID: 003692 RPC ID: 00 Queue: Admin Client-RPC: 00USER: /* Mon May 17 2010 13:23:09.5320 */DROP TABLE AR0float3692 SQL TID: 003692 RPC ID: 00 Queue: Admin Client-RPC: 00USER: /* Mon May 17 2010 13:23:09.5320 */*** ERROR *** Cannot drop the table 'AR0float3692', because it does not exist in the system catalog. (SQL Server 3701) SQL TID: 003692 RPC ID: 00 Queue: Admin Client-RPC: 00USER: /* Mon May 17 2010 13:23:09.5320 */DROP TABLE AR0char3692 SQL TID: 003692 RPC ID: 00 Queue: Admin Client-RPC: 00USER: /* Mon May 17 2010 13:23:09.5480 */*** ERROR *** Cannot drop the table 'AR0char3692', because it does not exist in the system catalog. (SQL Server 3701) SQL TID: 003692 RPC ID: 00 Queue: Admin Client-RPC: 00USER: /* Mon May 17 2010 13:23:09.5480 */DROP TABLE AR0decimal3692 SQL TID: 003692 RPC ID: 00 Queue: Admin Client-RPC: 00USER: /* Mon May 17 2010 13:23:09.5480 */*** ERROR *** Cannot drop the table 'AR0decimal3692', because it does not exist in the system catalog. (SQL Server 3701) SQL TID: 003692 RPC ID: 00 Queue: Admin Client-RPC: 00USER: /* Mon May 17 2010 13:23:09.5790 */SQL Trace Log -- OFF And then the real confusing one from the arerror.log: Mon May 17 13:23:09 2010 390600 : The database is not the expected version (may need to run upgrade program) (ARERR 36) Mon May 17 13:23:09 2010 390600 : AR System server terminated -- fatal error encountered (ARNOTE 21) I'm running SQL Server 2k EE on Windows Server 2k3 EE SP2. According to the Compatibility Matrix, this should be a supported configuration. Thanks, Gary Opela, Jr. Sr. Remedy Engineer Avaya Phone Admin RSP Cert, Sec+ COMM: 405 582 4272 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of LJ LongWing Sent: Wednesday, May 19, 2010 4:00 PM To: arslist@ARSLIST.ORG Subject: Re: sql server ** WellGary, as I'm sure you are aware that's not a supported configuration...I don't have any experience with it kuz I try to stay within supported configurationsbut BMC I'm sure wouldn't recommend it J From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Opela, Gary L CTR USAF ABW 72 ABW/SCOOA Sent: Wednesday, May 19, 2010 2:42 PM To: arslist@ARSLIST.ORG Subject: sql server ** Has anyone experienced any issues using SQL Server 2k8 standard edition instead of enterprise edition? This is with 7.1 version of AR System. Thanks, Gary Opela, Jr. Sr. Remedy Engineer Avaya Phone Admin RSP Cert, Sec+ COMM: 405 582 4272 _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: sql server
I am trying to upgrade from 6.3 to 7.1. I had looked at the ar_install log from the c:\documents and settings\me\local settings\temp\1 and all it gave me was that there was a failure updating the database because of a unique index violation. I had seen that before, but without knowing exactly where the violation was, it was hard to determine anything. Well, I also just now noticed there is an arsql.log in the same .\temp\1 folder. I looked at it, and it let me know that the error was in the user_cache table. That prompted me to go there to find the unique error issue. I was able to see the exact sql it was running, and it was with the user_cache table. I went in and removed the two duplicate entries that I found, and that seemed to fix the issue. Thanks for the help! Thanks, Gary Opela, Jr. Sr. Remedy Engineer Avaya Phone Admin RSP Cert, Sec+ COMM: 405 582 4272 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Walters, Mark Sent: Thursday, May 20, 2010 1:14 PM To: arslist@ARSLIST.ORG Subject: Re: sql server Are you attempting an upgrade? These errors; /* Mon May 17 2010 13:23:09.5320 */*** ERROR *** Cannot drop the table 'AR0int3692', because it does not exist in the system catalog. (SQL Server 3701) Can be ignored - they're threads shutting down and trying to remove any temporary tables they may have created. Now this; Mon May 17 13:23:09 2010 390600 : The database is not the expected version (may need to run upgrade program) (ARERR 36) Mon May 17 13:23:09 2010 390600 : AR System server terminated -- fatal error encountered (ARNOTE 21) Suggest the upgrade failed for some reason and has left the db in the format of the previous version. There's a log of the SQL run by the installer in the temp directory (I think) that should explain what failed. If you're not upgrading what happened before these messages started appearing? Mark -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Opela, Gary L CTR USAF ABW 72 ABW/SCOOA Sent: 20 May 2010 18:01 To: arslist@ARSLIST.ORG Subject: Re: sql server Okay, finally got a compatibility matrix, thanks for it you know who you are. So, the following line for 7.1: 32 or 64 bit x86 PC Compatible Windows 2000, 2003 (32 or x64) [Server, Advanced Server, Datacenter, Enterprise, Standard] Microsoft SQL Server 2000, 2005 (32 or 64-bit) [Enterprise, Standard] Oracle 9i, 10g [Standard, Std One, Enterprise + RAC] IBM DB2 8.2.2, 9.1 [Enterprise, Workgroup, Workgroup Unlimited] This clearly states that SQL Server 2000 32-bit Enterprise Edition will work with BMC AR System 7.1. However, I'm getting a bunch of errors: ARSql.log: SQL TID: 003692 RPC ID: 00 Queue: Admin Client-RPC: 00USER: /* Mon May 17 2010 13:23:09.5320 */*** ERROR *** Cannot drop the table 'AR0int3692', because it does not exist in the system catalog. (SQL Server 3701) SQL TID: 003692 RPC ID: 00 Queue: Admin Client-RPC: 00USER: /* Mon May 17 2010 13:23:09.5320 */DROP TABLE AR0float3692 SQL TID: 003692 RPC ID: 00 Queue: Admin Client-RPC: 00USER: /* Mon May 17 2010 13:23:09.5320 */*** ERROR *** Cannot drop the table 'AR0float3692', because it does not exist in the system catalog. (SQL Server 3701) SQL TID: 003692 RPC ID: 00 Queue: Admin Client-RPC: 00USER: /* Mon May 17 2010 13:23:09.5320 */DROP TABLE AR0char3692 SQL TID: 003692 RPC ID: 00 Queue: Admin Client-RPC: 00USER: /* Mon May 17 2010 13:23:09.5480 */*** ERROR *** Cannot drop the table 'AR0char3692', because it does not exist in the system catalog. (SQL Server 3701) SQL TID: 003692 RPC ID: 00 Queue: Admin Client-RPC: 00USER: /* Mon May 17 2010 13:23:09.5480 */DROP TABLE AR0decimal3692 SQL TID: 003692 RPC ID: 00 Queue: Admin Client-RPC: 00USER: /* Mon May 17 2010 13:23:09.5480 */*** ERROR *** Cannot drop the table 'AR0decimal3692', because it does not exist in the system catalog. (SQL Server 3701) SQL TID: 003692 RPC ID: 00 Queue: Admin Client-RPC: 00USER: /* Mon May 17 2010 13:23:09.5790 */SQL Trace Log -- OFF And then the real confusing one from the arerror.log: Mon May 17 13:23:09 2010 390600 : The database is not the expected version (may need to run upgrade program) (ARERR 36) Mon May 17 13:23:09 2010 390600 : AR System server terminated -- fatal error encountered (ARNOTE 21) I'm running SQL Server 2k EE on Windows Server 2k3 EE SP2. According to the Compatibility Matrix, this should be a supported configuration. Thanks, Gary Opela, Jr. Sr. Remedy Engineer Avaya Phone Admin RSP Cert, Sec+ COMM: 405 582 4272 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of LJ LongWing Sent: Wednesday
sql server
Has anyone experienced any issues using SQL Server 2k8 standard edition instead of enterprise edition? This is with 7.1 version of AR System. Thanks, Gary Opela, Jr. Sr. Remedy Engineer Avaya Phone Admin RSP Cert, Sec+ COMM: 405 582 4272 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: On Window Loaded active link doesn't see field values???
Rabi, just put a read only radio button on the form and have the macro set that button on window open. Then, have your workflow that you want to fire when the macro runs to run only if that radio button is set. Thanks, Gary Opela, Jr. Sr. Remedy Engineer Avaya Phone Admin RSP Cert, Sec+ COMM: 405 582 4272 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Rabi Tripathi Sent: Tuesday, April 27, 2010 11:40 AM To: arslist@ARSLIST.ORG Subject: Re: On Window Loaded active link doesn't see field values??? I absolutely hate to do this, but I can have an on interval active link fire on the window with interval of 1 sec. When the target window opens this way, I am expecting that the window loaded active links there will see the field values. Somebody tell me there's a different way to do this. Not to mess up the main form, I will go with an intermediate form that is opened by the macro on which after a sec an AL will fire to open the main ticket window and close the intermediate window. Ugly ugly. --- On Tue, 4/27/10, Rabi Tripathi ars_l...@yahoo.com wrote: From: Rabi Tripathi ars_l...@yahoo.com Subject: Re: On Window Loaded active link doesn't see field values??? To: arslist@ARSLIST.ORG Date: Tuesday, April 27, 2010, 12:35 PM LJ, log trace is not helping. There are no active links clearing the fields. I have found absolutely no way to have active links (Win Open, Win Loaded) read values passed to a window, if the window was **opened by a macro**!! All fields appear blank to these active links, although, when the window fully opens, all the values are right there for me to see! It appears that when a macro opens a window, there is something funky (I say bug) which makes the field values load *after* the Window Loaded event has completed. :( I tried opening the same window with code (open win action) and passed values; these values are correctly seen by the active links on that form. I tried playing with different window modes no luck. I need to trigger code before the window fully opens, based on value received by the window from the macro. Can't be done??? --- On Thu, 4/22/10, LJ LongWing lj.longw...@gmail.com wrote: From: LJ LongWing lj.longw...@gmail.com Subject: Re: On Window Loaded active link doesn't see field values??? To: arslist@ARSLIST.ORG Date: Thursday, April 22, 2010, 1:51 PM Rabi, I recommend having AL Logging turned on and see if the field is being set some time after the AL you are looking athappens to me all the time...I have AL1 set to fire if value = X, but AL2 fires at a later execution order setting the field... -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Rabi Tripathi Sent: Thursday, April 22, 2010 11:19 AM To: arslist@ARSLIST.ORG Subject: On Window Loaded active link doesn't see field values??? I have an active link firing on Window Loaded. It sees a field as having no value when it fires. That makes me not happy, because the value is there or should be there. The submit window is opened by a macro with a parameter, and the macro is correctly populating the parameter value on the field. I can see it when the window is fully open (meaning active links have all completed firing). When a submit window opens, my understanding is that by the time Window Loaded event occurs, all field values (set by set to default feature, sent with a macro etc) should already be there on the fields, such that on Window Loaded active links should see the values. Why is my active link not seeing the field value? I put a debug message, and yes, the field is blank when the active links fires. But the value gets to the field, when the window has opened fully. ARS 6.3. from the doc: Window Loaded Executes after all the data values have been loaded into a Submit or Search window (from defaults, from a copy to new, or from an open window action). ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist:
Simple problem with Table Walking, filter guides, and push fields - Solution
Okay, so I solved this problem before sending the email. Please see solution at the bottom after reading the problem. Problem* ARS 6.3 on Windows with SQ Server. So, I have a table field with 384 records. The table has Table Drill Down enabled, Auto Fit Columns enabled, Refresh on Entry Change disabled, and Fixed Headers Disabled. Under Advanced Display, I have Initial Row Selection and Refresh Row Selection set to 'No Selection'. Single Selection Only is not checked. I have a filter that runs against the table with table looping selected. This filter performs a Call Guide function. The guide then calls a filter that pushes the current row to another remedy form. Basically, I'm using a table to load data from one form to another. Well, I run the workflow, then check my secondary form, the form that is getting loaded from the filter, and I have 384 entries in the form, just like I would expect. The problem, however, is that all of the entries are the same, they are all the last entry from the table instead of each of the individual entries. What I'm thinking is happening is that, since push fields run at a later phase, that remedy is pushing 384 times, but by that time its focus is set on the last record in the table. I've tried changing the options for Initial Row Selection and Refresh Row Selection from their defaults to No Selection, and that hasn't seemed to help. I'm pretty sure that I've done this before, however I cannot seem to find the setting that is preventing each individual row from the table field from being pushed. I know that I've pushed data from a table field to the records being displayed, IE: changing the status on selected rows. NOTE**SOLUTION** I fixed this prior to sending the email, but I thought I would post it anyways for anyone else who might need to do this. I was indeed correct that filter phasing was preventing each individual row from getting pushed. So, I overrode filter phasing on the filter that the guide called by adding `! to the end of the filter name. This forced the push fields to happen using phase 1 data, so before the focus was changed on the table. The data doesn't actually get pushed until phase 3 like before, because it is using a push fields process, but it still has the data from the first phase. Thanks, Gary Opela, Jr. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: need to design a counter
I've done this. On the form that has the counter, put a display only radio button. Whenever a ticket is submitted in form two, push a value to the radio button. Next, put a filter on the form with the counter that runs when the radio button != $NULL$. The If actions is Integer = Integer + 1. This will give you your counter. Need: Filter on Form 2 that runs on submit and pushes value of 1 to read/only radio button field on Form 1 Filter on Form 1 that will set Integer = Integer + 1 on Modify when Radio Button ! $NULL$. Make sure the radio button is read only or this will not work. Thanks, Gary Opela, Jr. Sr. Remedy Engineer Avaya Phone Admin RSP Cert, Sec+ COMM: 405 582 4272 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Raj Sent: Thursday, April 15, 2010 7:04 PM To: arslist@ARSLIST.ORG Subject: need to design a counter Hello all, There is an integer field on form1. need to design a counter which increments the count by one for every submit on form2. So, need to write a filter on submit of form 2 which increments the integer field on form 1 by 1 for every submit on form 2.please advise. thanks, Raj ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: sql server 2k8 and ar system 6.3
Thank you all! Thanks, Gary Opela, Jr. Sr. Remedy Engineer Avaya Phone Admin RSP Cert, Sec+ COMM: 405 582 4272 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe DeSouza Sent: Wednesday, March 31, 2010 7:06 PM To: arslist@ARSLIST.ORG Subject: Re: sql server 2k8 and ar system 6.3 ** Gary, The built in stored proceedure sp_dbcmptlevel is your friend to do what LJ wrote below. If you have any questions about using it feel free to write to me. I've used it several times since version 7 of the SQL server and it works pretty good.. Joe From: Opela, Gary L CTR USAF ABW 72 ABW/SCOOA gary.opela@tinker.af.mil To: arslist@ARSLIST.ORG Sent: Wed, March 31, 2010 4:54:22 PM Subject: Re: sql server 2k8 and ar system 6.3 Interesting, thanks LJ. I was also concerned that 2k5 was not supported, I'm at 2k right now. Thanks, Gary Opela, Jr. Sr. Remedy Engineer Avaya Phone Admin RSP Cert, Sec+ COMM: 405 582 4272 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of LJ Longwing Sent: Wednesday, March 31, 2010 3:36 PM To: arslist@ARSLIST.ORG Subject: Re: sql server 2k8 and ar system 6.3 ** Thoughts.SQL 2K8 has the ability to run in 2K compatibility mode, which is supposed to make it invisible to the client that it's actually a 2K8 serverand being that's the most recent version that 6.3 supports (if I remember correctly)then I would say you could run it like that. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Opela, Gary L CTR USAF ABW 72 ABW/SCOOA Sent: Wednesday, March 31, 2010 1:50 PM To: arslist@ARSLIST.ORG Subject: sql server 2k8 and ar system 6.3 ** I'm wondering if anyone has tried AR System 6.3 on windows server 2k3 and SQL Server 2k8? I checked the compatibility matrix for 6.3 and it doesn't show 2k8, probably because 2k8 came out so recently. Primarily I'm concerned about the SQL Server 2k8, as I've had it running on windows server 2k3 for quite some time now. Has anyone tried it, or do any of you have any thoughts? Thanks, Gary Opela, Jr. Sr. Remedy Engineer Avaya Phone Admin RSP Cert, Sec+ COMM: 405 582 4272 _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
sql server 2k8 and ar system 6.3
I'm wondering if anyone has tried AR System 6.3 on windows server 2k3 and SQL Server 2k8? I checked the compatibility matrix for 6.3 and it doesn't show 2k8, probably because 2k8 came out so recently. Primarily I'm concerned about the SQL Server 2k8, as I've had it running on windows server 2k3 for quite some time now. Has anyone tried it, or do any of you have any thoughts? Thanks, Gary Opela, Jr. Sr. Remedy Engineer Avaya Phone Admin RSP Cert, Sec+ COMM: 405 582 4272 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: sql server 2k8 and ar system 6.3
Interesting, thanks LJ. I was also concerned that 2k5 was not supported, I'm at 2k right now. Thanks, Gary Opela, Jr. Sr. Remedy Engineer Avaya Phone Admin RSP Cert, Sec+ COMM: 405 582 4272 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of LJ Longwing Sent: Wednesday, March 31, 2010 3:36 PM To: arslist@ARSLIST.ORG Subject: Re: sql server 2k8 and ar system 6.3 ** Thoughts.SQL 2K8 has the ability to run in 2K compatibility mode, which is supposed to make it invisible to the client that it's actually a 2K8 serverand being that's the most recent version that 6.3 supports (if I remember correctly)then I would say you could run it like that. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Opela, Gary L CTR USAF ABW 72 ABW/SCOOA Sent: Wednesday, March 31, 2010 1:50 PM To: arslist@ARSLIST.ORG Subject: sql server 2k8 and ar system 6.3 ** I'm wondering if anyone has tried AR System 6.3 on windows server 2k3 and SQL Server 2k8? I checked the compatibility matrix for 6.3 and it doesn't show 2k8, probably because 2k8 came out so recently. Primarily I'm concerned about the SQL Server 2k8, as I've had it running on windows server 2k3 for quite some time now. Has anyone tried it, or do any of you have any thoughts? Thanks, Gary Opela, Jr. Sr. Remedy Engineer Avaya Phone Admin RSP Cert, Sec+ COMM: 405 582 4272 _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
The RegQueryValueEx function failed for the following reason: The system cannot find the file specified.
My email engine is hung and whenever I stop/restart it, I see the subject line in the event log viewer as an error message for the email engine. I'm running windows server 2k3, ars 6.3. Nothing changed on my server, but all of the sudden my email engine hung. It is not unusual for it to hang (usually java issues), however it is unusual for a restart of the service to not clear it up. Any help would be greatly appreciated. I cannot figure out which file it is missing. It would be nice if the event log would tell me. I've looked through all of my email logs and nothing is listed. Date: 3/10/2010 Source:AR System Email Engine Time: 10:01:58 AM Category: None Type: ErrorEvent ID: 4097 User: N/A Computer: Computer Description: The RegQueryValueEx function failed for the following reason: The system cannot find the file specified. Thanks, Gary Opela, Jr. Sr. Remedy Engineer Avaya Phone Admin RSP Cert, Sec+ COMM: 405 582 4272 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: The RegQueryValueEx function failed for the following reason: The system cannot find the file specified.
Resolved. There was a DC down, it came back up and email flowed through like a charm. Thanks, Gary Opela, Jr. Sr. Remedy Engineer Avaya Phone Admin RSP Cert, Sec+ COMM: 405 582 4272 -Original Message- From: Opela, Gary L CTR USAF ABW 72 ABW/SCOOA Sent: Wednesday, March 10, 2010 10:49 AM To: arslist@ARSLIST.ORG Subject: The RegQueryValueEx function failed for the following reason: The system cannot find the file specified. My email engine is hung and whenever I stop/restart it, I see the subject line in the event log viewer as an error message for the email engine. I'm running windows server 2k3, ars 6.3. Nothing changed on my server, but all of the sudden my email engine hung. It is not unusual for it to hang (usually java issues), however it is unusual for a restart of the service to not clear it up. Any help would be greatly appreciated. I cannot figure out which file it is missing. It would be nice if the event log would tell me. I've looked through all of my email logs and nothing is listed. Date: 3/10/2010 Source:AR System Email Engine Time: 10:01:58 AM Category: None Type: ErrorEvent ID: 4097 User: N/A Computer: Computer Description: The RegQueryValueEx function failed for the following reason: The system cannot find the file specified. Thanks, Gary Opela, Jr. Sr. Remedy Engineer Avaya Phone Admin RSP Cert, Sec+ COMM: 405 582 4272 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
