Re: SQL or Oracle
Some things I like with Oracle: - XMLGEN package: if you want to get at your AR data in xml format, this works great - Dynamic performance views: want to see what your database is, or was, doing? - Flashback capabilities: want to take a snapshot before major releases and fail back in a matter of minutes? - BCV: Want to get a copy of your database in minutes? - It runs on OS's that are not Windows (I don't care for MS as a server OS; it's my personal preference, but I loathe the mentality that a reboot is a cure-all; I like my machines to run like ... machines -- efficient, predictable, and reliable) - I can manage it without a GUI Maybe some of these things are available with MSSQL. I try to separate myself from MS technologies because they only tend to work with other MS technologies and I don't like to be boxed in. Axton Grams On Fri, Sep 28, 2012 at 4:03 PM, patchsk wrote: > ** Yes it works. > We do it all the time copying db from prod to pre-production environments. > It is a standard task to dbas. No special instructions needed. > > > On Friday, September 28, 2012 12:24:40 PM UTC-7, Hennigan, Sandra wrote: > >> BMC guide speaks to SQL but not Oracle. >> >> Can a backup of Oracle be taken and moved to another environment then ARS >> be made to point to the database backup? Will this be a capability with >> Oracle? >> >> Thank you, >> >> Sandra Hennigan >> Remedy Developer >> Criminal Division | U.S. Department of Justice >> ☎ (202) 353-0557 >> Mobile: 202-716-0848 >> >> sandra@usdoj.gov >> >> >> >> -Original Message- >> From: Action Request System discussion list(ARSList) [mailto: >> ars...@arslist.org] On Behalf Of Joe Martin D'Souza >> Sent: Friday, September 28, 2012 3:10 PM >> To: ars...@arslist.org >> Subject: Re: SQL or Oracle >> >> I'm not quite sure I understood your question.. What exactly is your >> requirement? >> >> Joe >> >> -Original Message- >> From: Hennigan, Sandra >> Sent: Friday, September 28, 2012 2:28 PM Newsgroups: >> public.remedy.arsystem.general >> To: ars...@arslist.org >> Subject: Re: SQL or Oracle >> >> Thank you, Lister. I also reviewed the archives. >> >> For you Oracle users, a question: >> >> Even with every best intention, keeping Support Group IDs, foundation >> data >> etc. matched between Test and Production is difficult so routinely, the >> production database is backed up and a copy moved to our test >> environment. >> Using SQL, this is a simple process. Is this an action I can take with >> Oracle? >> >> Sandra Hennigan >> Remedy Developer >> >> >> -Original Message- >> From: Action Request System discussion list(ARSList) >> [mailto:ars...@arslist.org] On Behalf Of Joe Martin D'Souza >> Sent: Friday, September 28, 2012 2:04 PM >> To: ars...@arslist.org >> Subject: Re: SQL or Oracle >> >> I agree about MS-SQL being maintenance light, cheap, and at the same time >> a >> fairly robust database, which has a winning point on case sensitivity.. >> >> But because of the nature of searches and the format data is stored in >> your >> organization, if case insensitivity isn't going to buy much and you'll >> already have a full time Oracle DBA, I would go with Oracle as Oracle >> tends >> to be more flexible on certain maintenance standpoints than MS-SQL can >> ever >> be to the best of my knowledge.. I'm not even a fully qualified Oracle >> DBA >> nor am I a fully qualified MS-SQL DBA, and I find Oracles scripting >> capacities far more superior than MS-SQL. For e.g. I have in the past >> been >> able to script oracle backups and restore, selecting specific parameters >> to >> export and import (only structures, only data, only certain tables or >> views, >> etc) in scripts that has given me the ability to pretty much replicate >> production databases minus all the application data.. I really do not >> think >> there is a way to do the same in MS-SQL, but then I could be wrong... I >> just >> may have not found a way to script that in MS-SQL... >> >> All in all I agree with most of the comments on this thread as well as >> one >> similar to this a few weeks ago, MS-SQL can be fairly cheaper and easier >> to >> maintain than Oracle which would need an expensive full time DBA.. >> >> Joe >> >> -Original Message- >> From: Pierson, Shawn >> Sent: Friday, September 28, 2012 11:23 AM Newsgroups: >> public.remedy.arsystem.general >> To: ars...@arslist.org >> Subject: Re: SQL or Oracle >> >> SQL Server is cheaper and easier to manage. It works better when it >> comes >> to case sensitivity. For the amount of users you have, there are no >> performance advantages or anything when it comes to Oracle. Basically, >> Remedy works perfectly fine on both, but you should use whatever you and >> your DBAs are more comfortable with, and what works on the hardware and >> OS >> you are using (e.g. you can't run SQL Server on Linux but you can run >> Oracle.) Management should listen at least to the dollars involved if >> you >> are purchasing new l
Re: Question about incident scripts
Scripts are for Support Personnel not end users. If your end users are actually using the Incident form to create their own Incidents you would need to give them permissions that they should not have to see a script. -Original Message- From: Jose Manuel Huerta Gu illén To: arslist Sent: Sat, Sep 29, 2012 3:48 pm Subject: Question about incident scripts **Hi listers, I have, what I think, a very silly question. How can users access to the attachments of an script? When you create an incident script you can attach some troubleshooting documentation. My intention was to allow users that read the script to download the docs. But seems impossible. So, What's the intention of these attachments? We are using ITSM 7.6.0 with ARS 7.5.0. Regards, Jose Manuel Huerta http://theremedyforit.com/ _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Question about incident scripts
Hi listers, I have, what I think, a very silly question. How can users access to the attachments of an script? When you create an incident script you can attach some troubleshooting documentation. My intention was to allow users that read the script to download the docs. But seems impossible. So, What's the intention of these attachments? We are using ITSM 7.6.0 with ARS 7.5.0. Regards, Jose Manuel Huerta http://theremedyforit.com/ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Re: Cannot login to mid-tier but CAN login using Windows user tool
I 'customised' my mid-tier installation. So a problem with paths etc. I am going to do a more default install to see what happens. - Original Message - From: "Carl Wilson" Newsgroups: public.remedy.arsystem.general To: Sent: Thursday, September 27, 2012 9:15 AM Subject: Re: Cannot login to mid-tier but CAN login using Windows user tool Hi, this is usually an indication that the passwords for the AR Server Mid Tier connection do not match. You can reset the password for the Mid Tier from within ARS (AR System Administration), then use this password in the Mid Tier setup. Cheers Carl http://www.missingpiecessoftware.com/ -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Angus Comber Sent: 27 September 2012 08:17 To: arslist@ARSLIST.ORG Subject: Cannot login to mid-tier but CAN login using Windows user tool Hi I have Remedy v7.5 mid-tier setup and I can login using the Windows user tool (thick client) with standard Demo account. If I try to login to the mid-tier I go to http://myserver:8080/arsys/shared/login.jsp and get the login page as expected. But if I login using username Demo and leave password field and authentication fields blank then I get ARERR [623] Authentication failed Is there some step I have missed? Angus p.s. I get exactly same error if I attempt to login with an unknown username, eg john. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Re: SRM - Blank requests
Hi Christine, Make sure that the fulfillment tickets are creating. If that is okay, then you need to do the variable mapping on SRDs. This actually holds the response given by the request user for particualr questions. Regards, Shashi On Fri, Sep 28, 2012 at 8:00 PM, Christine Milton Hall < christine_milton_h...@pepperidgefarm.com> wrote: > ** > > Hoping someone can help me out! > > > > We have implemented SRM and we are having a intermittent problem with the > data from the questions not being saved and creating Blank Requests. Has > anyone else seen this issue and if so, help to guide me where to look? > > > > All of our service categories are simple flows – 1 Request to 1 work > order. It occurs with any one of the service categories, so no one > specific one is the problem > > > > Our environment: > > > > ARS: AR Server 7.5 .00 Patch 002 > Atrium CMDB: 7.5 .00 Patch 005 > ITSM: 7.5 .01 Patch 001 > SRM: 7.6.00 Patch 001 > Database : SQL 2005 version 5.2.3790 > > > > Anyone’s help will be greatly appreciated! > > > > Thanks > > christine > > > > > > * > > > This e-mail and any files transmitted with it may contain confidential > information and is intended solely for use by the individual to whom it is > addressed. If you received this e-mail in error, please notify the sender, > do not disclose its contents to others and delete it from your system. > > * > > _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ -- Jst gimmee a Break.. -9964607234 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Re: SRM - Blank requests
Check the question character length on the SRD, I believe the max is 254 char. We had this issue and that was the culprit. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"