Re: Plugin Error (8760) when accessing Server Information Form
I have observed this kind of error when value for Plugin-Port in ar.cfg file is wrong. I could resolve this issue by rectifying the value of the Plugin-Port Hope that helps 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. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: SRM permissions / auto logout
I see this in ITSM 764 starting from the home page. If you try and open the Request Entry console without the correct permissions the window immediately closes but does not give you an indication of why. I would think a direct link the RE console would perform the same way. On Mon, Feb 27, 2012 at 1:04 PM, John Baker jba...@javasystemsolutions.comwrote: Hello I recently came across a client with a modified ITSM however I'm not sure if this aspect was modified. If a user linked directly to the SRM console, and logged in, workflow logs the user back out immediately if they do not have the relevant SRM permissions. Is this a common configuration? The client stated this functionality was out of the box. 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
Re: Plugin Error (8760) when accessing Server Information Form
Just a thought, If behind a firewall, try allowing Plugin-Port: X thru the firewall. -- View this message in context: http://ars-action-request-system.1093659.n2.nabble.com/Plugin-Error-8760-when-accessing-Server-Information-Form-tp7321401p7325568.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Remedy Approval 7.6.04
Listers, We are in the process of building a new system. windows 2008, AR server 7.6.04 install. The approval server failed to install initially due to some group permissions on the server set by the network lockdown. We have resolved those but now the approval server fails its post install sanity check. I get the following Warnings. LOG EVENT {Description=[Approval server post install sanity check execution - timed out]} LOG EVENT {Description=[BMC_APPROVAL_SERVER_SANITY_FAILED],Detail=[The Approval Server post installation check failed.]} Any ideas what could/would cause this. What is it trying to do during the sanity check that could cause a time out. I have a feeling it may be something on the server that is causing it to time out but just not sure where to look as I am not sure what it is trying to do during this part of the sanity check. Thanks Dan ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
CMDB Experts Needed in the DC Area
Hello ARS subscribers, I'm reaching out to all of you to find out if you know any colleagues with strong experience with CMDB. Windward IT Solutions has projects with commercial and federal clients that are centered around the implementation and configuration of CMDB. We are looking for candidates that have hands on experience working with CMDB and experience interacting directly with clients to collect business requirements. If you know of any colleagues that are looking to move onto their next project or are looking for a new opportunity yourself please give me a call or email me your resume. We have the ability to hire both full time employees and contractors (W2 hourly/1099/corp. 2 corp.) and our hourly rates/salaries are extremely competitive. Below I've included an example of one of the positions we have available at this time along with the application link. Thanks, Christopher Werner Technical Recruiter (703) 812-0117 (desk) (571) 234-0586 (cell) cwer...@windwardits.commailto:cwer...@windwardits.com [cid:image001.jpg@01CCF603.FFB839A0]http://www.windwardits.com/index.php Application Link: http://sj.tbe.taleo.net/SJ6/ats/careers/requisition.jsp?org=WINDWARDITScws=1rid=264 Technical CMDB Consultant Position Summary We are currently seeking to add a technical CMDB consultant to our team with experience extracting detailed customer requirements and implementing those requirements within one or more vendor technologies. The consultant will also have the aptitude to lend technical assistance during the analysis, design, and implementation of service desk, for Federal clients. The candidate must have experience and knowledge in deploying core functionality in an out of box CMDB system; including the ability to install the system on at least one server platform and one database. The characteristics of this position include: a working command of technology and architectural concepts; the ability to perform an analysis of client processes; ability to document and develop work flows for system functionality and customization. Upon hire, Windward will provide up to four (4) weeks training to ensure candidates are familiar with and have hands-on exposure to the most recent version of the BC Atrium CMDB product and accompanying modules to support specific client requirements as the majority of the client work will be within the BMC Atrium CMDB product. Position Requirements * Experience integrating with one or more federated data sources preferred. * Familiarity with or ITIL(r) certifications preferred. * Work with client management and staff to integrate the client's business objectives, current technical infrastructure and state of the art technologies into enterprise-wide solutions. * Design and/or assess operational processes for effective enterprise wide network and systems technology management. * Minimum of 5 years experience working with leading vendor products. * US Citizen with the ability to obtain a Secret level clearance * Prior consulting experience is mandatory * Candidates based in the Washington DC metro area up to 25% travel, outside of the Washington DC metro area up to 75% travel * Degree in CS, EE or related MIS field preferred. Windward strives to attract and retain the best individuals and provide an environment where they can all grow professionally and build a rewarding career. We continually strive to create an environment that balances work life and offers benefits that will enhance the compensation package. We offer Medical, Dental, Vision, Flexible Spending Accounts, Short Term Disability, Long Term Disability, Life Insurance and ADD, as well as the option to purchase additional Ife Insurance and ADD, Paid Time Off, Personal Leave, Holidays, 401(k) plan with company match and work/life balance. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are inline: image001.jpg
Immediate opening with CSC for a Remedy Developer with active TS in Quantico, VA
** CSC is seeking an experienced Remedy Systems Administrator to work at Quantico VA. Candidates must possess a current DoD Top Secret security clearance and meet minimum DoD 8570.1 certification requirements. DoD 8570.1 Certification requirements: CompTIA Security+ Plusses: Microsoft Certified Database Administrator (MCDBA) Essential Job Functions: • Performs complex product design, system analysis and programming activities on application software to ensure that company technology needs are met. • Performs design, implementation and maintenance of complex multiple product modules/subsystems or on lower level issues of multiple products to ensure proper functioning of products. Participates in product design meeting to ensure that design concepts are transferred into application development successfully. • Analysis, design, development, deployment, installation, configuration, customization, troubleshooting & tuning of Remedy Action Request System from version 6.0 to 7.x. • Performs complex bug verification, release testing and beta support for assigned products; researches problems discovered by quality analysts or product support to ensure that appropriate solutions are developed. • Coordinates with appropriate management personnel in implementing changes. • Supports complex data/media recoverability through system backups and database archive operations. Plans, coordinates and directs appropriate level data refresh strategies. • Gather and document requirements and support the design of implementation of additional Remedy services, such as CMDB and Remedy Dashboards. • Develop and maintain user documentation, including user manuals, quick references, and training documentation. • Works with technical staff to understand problems with software to ensure that they are resolved in a timely manner. • Diagnose and repair problems within the Remedy system. For more info please email or go to: http://www.csc.com/careersus/flx/16177-job_opportunities Search for Job # 12001FJ _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_
Assignment Company and Organization values in 7.6.4 SP2
Dears, Anyone know how can I obtain the values of Assignment Company and Organization separately as I used both in a lot of customizations.?? Note:- I'm upgrading from version 7.1 to 7.6.4 SP2 and only the last layer appears Assigned Group. Thanks, Best Regards, Mahmoud Mahdy Mohammed,PMP | Business Process Automation Technology | Products Services Delivery Phone: +20(0)104999638 Mail: mahmoud.mahdy-moha...@vodafone.commailto:mohamed.abdel-haf...@vodafone.com * The content of this document is classified as Vodafone Egypt S.A.E. Confidential and Proprietary Information. The recipient hereby is committed to hold in strict confidence the contents of this (e-mail, document, information) and not to disclose to any third party without the prior written consent of Vodafone Egypt S.A.E. Recipient will be held liable for any unauthorized disclosure. If you have received this message in error, please notify the sender by return e-mail and delete the message in its entirety, including any attachments. http://www.vodafone.com.eg * ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
ARERR 1889 received on changing date to 03/11/12 02:00
All, ARS 7.5 patch 4 Midtier 7.5 patch 4 ITSM 7.5.01 I had a user report an issue this morning. They are unable to update a Change CRQ requested start date to 3/11/2012 2:00:00 AM On midtier web client it does not show an error and when you enter 3/11/2012 2:00:00 AM it simply changes your entry to 1 hour later 3/11/2012 3:00:00 AM On the WUT (I'm using 7.6.04 patch 3) you get the below error message: Date is out of allowed range of 01/01/1970 - 01/19/2038 (GMT) for Windows client. : 3/11/2012 2:00:00 AM: Requested Start Date+ (ARERR 1889) Any help would be appreciated, we'll be contacting support :-) Regards, Andrew Goodall Software Engineer 2 | Development Services | jcpenney . www.jcp.com http://www.jcp.com/ font face=monospacesize=-3brThe information transmitted is intended only for the person or entity to which it is addressed and brmay contain confidential and/or privileged material. If the reader of this message is not the intendedbrrecipient, you are hereby notified that your access is unauthorized, and any review, dissemination,brdistribution or copying of this message including any attachments is strictly prohibited. If you are notbrthe intended recipient, please contact the sender and delete the material from any computer.br ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: ARERR 1889 received on changing date to 03/11/12 02:00
Hello Andrew, March 11, 2012 is when DST starts. On March 11, it goes from 1:59am to 3:am. 2am to 2:59am is invalid on March 11, 2012. Elizabeth Low Date: Tue, 28 Feb 2012 11:48:48 -0500 From: ago...@jcpenney.com Subject: ARERR 1889 received on changing date to 03/11/12 02:00 To: arslist@ARSLIST.ORG ** All, ARS 7.5 patch 4 Midtier 7.5 patch 4 ITSM 7.5.01 I had a user report an issue this morning. They are unable to update a Change CRQ requested start date to 3/11/2012 2:00:00 AM On midtier web client it does not show an error and when you enter 3/11/2012 2:00:00 AM it simply changes your entry to 1 hour later 3/11/2012 3:00:00 AM On the WUT (I’m using 7.6.04 patch 3) you get the below error message: Date is out of allowed range of 01/01/1970 - 01/19/2038 (GMT) for Windows client. : 3/11/2012 2:00:00 AM: Requested Start Date+ (ARERR 1889) Any help would be appreciated, we’ll be contacting support J Regards, Andrew Goodall Software Engineer 2 | Development Services | jcpenney . www.jcp.com The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If the reader of this message is not the intended recipient, you are hereby notified that your access is unauthorized, and any review, dissemination, distribution or copying of this message including any attachments is strictly prohibited. If you are not the intended recipient, please contact the sender and delete the material from any computer. _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
Re: ARERR 1889 received on changing date to 03/11/12 02:00
Thanks Elizabeth - I thought this was something to do with daylight savings, so it sounds like that is by design even if it was poorly implemented? If so, a more meaningful user friendly reason should have been populated to the user. Regards, Andrew Goodall Software Engineer 2 | Development Services | jcpenney . www.jcp.com http://www.jcp.com/ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Elizabeth Low Sent: Tuesday, February 28, 2012 10:56 AM To: arslist@ARSLIST.ORG Subject: Re: ARERR 1889 received on changing date to 03/11/12 02:00 Hello Andrew, March 11, 2012 is when DST starts. On March 11, it goes from 1:59am to 3:am. 2am to 2:59am is invalid on March 11, 2012. Elizabeth Low Date: Tue, 28 Feb 2012 11:48:48 -0500 From: ago...@jcpenney.com Subject: ARERR 1889 received on changing date to 03/11/12 02:00 To: arslist@ARSLIST.ORG ** All, ARS 7.5 patch 4 Midtier 7.5 patch 4 ITSM 7.5.01 I had a user report an issue this morning. They are unable to update a Change CRQ requested start date to 3/11/2012 2:00:00 AM On midtier web client it does not show an error and when you enter 3/11/2012 2:00:00 AM it simply changes your entry to 1 hour later 3/11/2012 3:00:00 AM On the WUT (I'm using 7.6.04 patch 3) you get the below error message: Date is out of allowed range of 01/01/1970 - 01/19/2038 (GMT) for Windows client. : 3/11/2012 2:00:00 AM: Requested Start Date+ (ARERR 1889) Any help would be appreciated, we'll be contacting support :-) Regards, Andrew Goodall Software Engineer 2 | Development Services | jcpenney . www.jcp.com http://www.jcp.com/ The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If the reader of this message is not the intended recipient, you are hereby notified that your access is unauthorized, and any review, dissemination, distribution or copying of this message including any attachments is strictly prohibited. If you are not the intended recipient, please contact the sender and delete the material from any computer. _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _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
Re: ARERR 1889 received on changing date to 03/11/12 02:00
This is the description of error 1889 Message Text: Date is out of allowed range of 01/01/1970 to 01/19/2038 (GMT) for Windows client. Description: If you enter a date outside of the listed range, based on Greenwich Mean Time (GMT), you receive this error message. GMT is the time zone from which all other time zones are adjusted. This error also appears for dates that are within the hour that the time changes for the start of daylight saving time. For more information, see knowledge base article ID 5816 on the BMC Remedy Customer Support website. Fred From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Andrew C Goodall Sent: Tuesday, February 28, 2012 11:09 AM To: arslist@ARSLIST.ORG Subject: Re: ARERR 1889 received on changing date to 03/11/12 02:00 ** Thanks Elizabeth - I thought this was something to do with daylight savings, so it sounds like that is by design even if it was poorly implemented? If so, a more meaningful user friendly reason should have been populated to the user. Regards, Andrew Goodall Software Engineer 2 | Development Services | jcpenney . www.jcp.com http://www.jcp.com/ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Elizabeth Low Sent: Tuesday, February 28, 2012 10:56 AM To: arslist@ARSLIST.ORG Subject: Re: ARERR 1889 received on changing date to 03/11/12 02:00 Hello Andrew, March 11, 2012 is when DST starts. On March 11, it goes from 1:59am to 3:am. 2am to 2:59am is invalid on March 11, 2012. Elizabeth Low Date: Tue, 28 Feb 2012 11:48:48 -0500 From: ago...@jcpenney.com Subject: ARERR 1889 received on changing date to 03/11/12 02:00 To: arslist@ARSLIST.ORG ** All, ARS 7.5 patch 4 Midtier 7.5 patch 4 ITSM 7.5.01 I had a user report an issue this morning. They are unable to update a Change CRQ requested start date to 3/11/2012 2:00:00 AM On midtier web client it does not show an error and when you enter 3/11/2012 2:00:00 AM it simply changes your entry to 1 hour later 3/11/2012 3:00:00 AM On the WUT (I'm using 7.6.04 patch 3) you get the below error message: Date is out of allowed range of 01/01/1970 - 01/19/2038 (GMT) for Windows client. : 3/11/2012 2:00:00 AM: Requested Start Date+ (ARERR 1889) Any help would be appreciated, we'll be contacting support :) Regards, Andrew Goodall Software Engineer 2 | Development Services | jcpenney . www.jcp.com http://www.jcp.com/ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: ARERR 1889 received on changing date to 03/11/12 02:00
Thanks - I should have looked at that sooner :-) Although, that's obvious to a Remedy Admin - to the user it's not very clear why the tool is behaving in that manner. A message to the user could have explained this action to them in plain English - not the tech jargon. Note: the error message was not received on the web client (which most of our customers use), only the WUT. Regards, Andrew Goodall Software Engineer 2 | Development Services | jcpenney . www.jcp.com http://www.jcp.com/ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Tuesday, February 28, 2012 11:21 AM To: arslist@ARSLIST.ORG Subject: Re: ARERR 1889 received on changing date to 03/11/12 02:00 This is the description of error 1889 Message Text: Date is out of allowed range of 01/01/1970 to 01/19/2038 (GMT) for Windows client. Description: If you enter a date outside of the listed range, based on Greenwich Mean Time (GMT), you receive this error message. GMT is the time zone from which all other time zones are adjusted. This error also appears for dates that are within the hour that the time changes for the start of daylight saving time. For more information, see knowledge base article ID 5816 on the BMC Remedy Customer Support website. Fred From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Andrew C Goodall Sent: Tuesday, February 28, 2012 11:09 AM To: arslist@ARSLIST.ORG Subject: Re: ARERR 1889 received on changing date to 03/11/12 02:00 ** Thanks Elizabeth - I thought this was something to do with daylight savings, so it sounds like that is by design even if it was poorly implemented? If so, a more meaningful user friendly reason should have been populated to the user. Regards, Andrew Goodall Software Engineer 2 | Development Services | jcpenney . www.jcp.com http://www.jcp.com/ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Elizabeth Low Sent: Tuesday, February 28, 2012 10:56 AM To: arslist@ARSLIST.ORG Subject: Re: ARERR 1889 received on changing date to 03/11/12 02:00 Hello Andrew, March 11, 2012 is when DST starts. On March 11, it goes from 1:59am to 3:am. 2am to 2:59am is invalid on March 11, 2012. Elizabeth Low Date: Tue, 28 Feb 2012 11:48:48 -0500 From: ago...@jcpenney.com Subject: ARERR 1889 received on changing date to 03/11/12 02:00 To: arslist@ARSLIST.ORG ** All, ARS 7.5 patch 4 Midtier 7.5 patch 4 ITSM 7.5.01 I had a user report an issue this morning. They are unable to update a Change CRQ requested start date to 3/11/2012 2:00:00 AM On midtier web client it does not show an error and when you enter 3/11/2012 2:00:00 AM it simply changes your entry to 1 hour later 3/11/2012 3:00:00 AM On the WUT (I'm using 7.6.04 patch 3) you get the below error message: Date is out of allowed range of 01/01/1970 - 01/19/2038 (GMT) for Windows client. : 3/11/2012 2:00:00 AM: Requested Start Date+ (ARERR 1889) Any help would be appreciated, we'll be contacting support :-) Regards, Andrew Goodall Software Engineer 2 | Development Services | jcpenney . www.jcp.com http://www.jcp.com/ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ font face=monospacesize=-3brThe information transmitted is intended only for the person or entity to which it is addressed and brmay contain confidential and/or privileged material. If the reader of this message is not the intendedbrrecipient, you are hereby notified that your access is unauthorized, and any review, dissemination,brdistribution or copying of this message including any attachments is strictly prohibited. If you are notbrthe intended recipient, please contact the sender and delete the material from any computer.br ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
MS SQL question
I know that there are a couple of short comings with running the AR System on Oracle. Namely case sensitivity and searching a large character field. I'm wondering if there are short comings running on MS SQL. Not really looking for a debate on the advantages of one over the other. Just looking to see if MS SQL has any similar peculiarities. Thanks Dave Dave Shellman +1 717 810 3687 tel +1 717 810 2124 fax dave.shell...@te.commailto:dave.shell...@te.com MS 161-043 PO Box 3608 Harrisburg, PA 17105-3608 [http://www.te.com/imagesTE/socialmedia/smallTElogo.gif]http://www.te.com/ [http://www.te.com/imagesTE/socialmedia/twitter.png]http://twitter.com/teconnectivity [http://www.te.com/imagesTE/socialmedia/facebook.png] http://www.facebook.com/teconnectivity [http://www.te.com/imagesTE/socialmedia/flickr.png] http://www.flickr.com/photos/teconnectivity/ [http://www.te.com/imagesTE/socialmedia/linkedin.png] http://www.linkedin.com/groups?gid=1591657 [http://www.te.com/imagesTE/socialmedia/youtube.png] http://www.youtube.com/teconnectivity ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are inline: smallTElogo.gifinline: twitter.pnginline: facebook.pnginline: flickr.pnginline: linkedin.pnginline: youtube.png
My first 7-up question
Hello, I'm back on arslist, long time ago. Now I belong to our 7-up management unit. Our home built system Tabasco is a dying application, but it has lived since -97:) My question is: Is there any issues with Foundation/Data Management Tool/Data Wizard Console, or is this module working as expected. Direct SQL, or ars workflow? Thanks in advance, Lars ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: My first 7-up question
Lars: Welcome back - some of us old timers remember you. :) IMO, the Data Management Tool provides basic functionality and is reliable. It's build around a combination of Windows .bat (.cmd?) files, Microsoft Excel macros, and ARS workflow, and any of these three can be enhanced as desired. HTH, --Phil From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of lars.j.petters...@vattenfall.com Sent: Tuesday, February 28, 2012 14:02 To: arslist@ARSLIST.ORG Subject: My first 7-up question ** Hello, I'm back on arslist, long time ago. Now I belong to our 7-up management unit. Our home built system Tabasco is a dying application, but it has lived since -97:) My question is: Is there any issues with Foundation/Data Management Tool/Data Wizard Console, or is this module working as expected. Direct SQL, or ars workflow? Thanks in advance, Lars _attend WWRUG12 www.wwrug.comhttp://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
1099 Opportunity (Remedy v7.5/Clarify)
Need an experienced BMC (7.5.x) Remedy Developer for BMC ITSM suite. This includes BMC Service Desk the incident and problem management solution and BMC Change Management the process and planning management solution. The successful candidate will be required to develop, document, code and implement workflows and change management application forms and dashboards from scratch. The candidate is required to have a strong knowledge to integrate the Remedy functionality with network monitoring software such as Netcool. Desired Skills Prior experience with BMC Remedy ITSM suite of applications and APIs Prior experience with technical requirements gathering Prior integration experience and knowledge of Oracle databases Prior integration experience and knowledge of Netcool NMS Familiar with Web Service Definition Language (WSDL) Strong written and documentation skills BMC certifications 3+ month 1099 contract to start. Rates negotiable. If you are interested in learning more please send me a resume and contact information. Ken Rizzo OpsVision Solutions, LLC Cell: 571.285.7649 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
CMDB Datasets
Hi, In the CMDB, the Client requested that there be a dataset for each of the support users. Approximately 50 to 60 datasets. I normally build the datasets based on the business need to manage the data. I do not create a sandbox for each support user. Can this become an issue later? If yes, how? Also multii-tenancy was created for each sub-division just to keep each sub-division from seeing the cost center # of the other subdivision, and to be able to generate reports on the cost center of each subdivision. I do not normally use multi-tenancy in this way. Is this design a good solution for this type of requirement? Are we using multi-tenancy wrong? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: CMDB Datasets
You did not mention what version this is for. With 7.5 and later Atrium Core will automatically create a new dataset for each user that selects a CI and wants to modify it. This does not happen in Asset Management. -Original Message- From: Koyb P. Liabt tekkyto...@aol.com To: arslist arslist@ARSLIST.ORG Sent: Tue, Feb 28, 2012 2:24 pm Subject: CMDB Datasets ** Hi, In the CMDB, the Client requested that there be a dataset for each of the support users. Approximately 50 to 60 datasets. I normally build the datasets based on the business need to manage the data. I do not create a sandbox for each support user. Can this become an issue later? If yes, how? Also multii-tenancy was created for each sub-division just to keep each sub-division from seeing the cost center # of the other subdivision, and to be able to generate reports on the cost center of each subdivision. I do not normally use multi-tenancy in this way. Is this design a good solution for this type of requirement? Are we using multi-tenancy wrong? _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
Re: MS SQL question
Dave, Case Sensitivity is not an issue with MS SQL. Also with 7.6.04 you have FTS, which provides better search capabilities for both Oracle and SQL. In my opinion MS SQL has come a long way in the last few releases and can stand up to Oracle as a true enterprise solution. I think a few years ago there were some valid reasons to go Linux(or flavor of Unix)/Oracle. Microsoft has come a long way though from both the OS and DB side of the house. I think now it just depends on the level of onsite expertise for your DB. I have set up multiple systems on both Oracle and MS SQL over the years and these days I find it much easier to go the Microsoft route. Both are rock solid if configured properly. If you have FTS configured properly it does relief some of the Oracle constraints, but it is something additional you would have to manage. Brian From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Shellman, David Sent: Tuesday, February 28, 2012 2:00 PM To: arslist@ARSLIST.ORG Subject: MS SQL question ** I know that there are a couple of short comings with running the AR System on Oracle. Namely case sensitivity and searching a large character field. I'm wondering if there are short comings running on MS SQL. Not really looking for a debate on the advantages of one over the other. Just looking to see if MS SQL has any similar peculiarities. Thanks Dave Dave Shellman +1 717 810 3687 tel +1 717 810 2124 fax mailto:dave.shell...@te.com dave.shell...@te.com MS 161-043 PO Box 3608 Harrisburg, PA 17105-3608 http://www.te.com/ http://twitter.com/teconnectivity http://www.facebook.com/teconnectivity http://www.flickr.com/photos/teconnectivity/ http://www.linkedin.com/groups?gid=1591657 http://www.youtube.com/teconnectivity _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 image001.gifimage002.pngimage003.pngimage004.pngimage005.pngimage006.png
Re: MS SQL question
Brian, I understand. As I said I'm not asking which is better. I'm attempting to understand if there are any hidden gotchas with MS SQL like there is with Oracle. There my not be any but that is what I want to identify. Thanks Dave On Feb 28, 2012, at 4:51 PM, Brian Pancia panc...@finityit.commailto:panc...@finityit.com wrote: ** Dave, Case Sensitivity is not an issue with MS SQL. Also with 7.6.04 you have FTS, which provides better search capabilities for both Oracle and SQL. In my opinion MS SQL has come a long way in the last few releases and can stand up to Oracle as a true enterprise solution. I think a few years ago there were some valid reasons to go Linux(or flavor of Unix)/Oracle. Microsoft has come a long way though from both the OS and DB side of the house. I think now it just depends on the level of onsite expertise for your DB. I have set up multiple systems on both Oracle and MS SQL over the years and these days I find it much easier to go the Microsoft route. Both are rock solid if configured properly. If you have FTS configured properly it does relief some of the Oracle constraints, but it is something additional you would have to manage. Brian From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Shellman, David Sent: Tuesday, February 28, 2012 2:00 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: MS SQL question ** I know that there are a couple of short comings with running the AR System on Oracle. Namely case sensitivity and searching a large character field. I'm wondering if there are short comings running on MS SQL. Not really looking for a debate on the advantages of one over the other. Just looking to see if MS SQL has any similar peculiarities. Thanks Dave Dave Shellman +1 717 810 3687 tel +1 717 810 2124 fax dave.shell...@te.commailto:dave.shell...@te.com MS 161-043 PO Box 3608 Harrisburg, PA 17105-3608 image001.gifhttp://www.te.com/ image002.pnghttp://twitter.com/teconnectivityimage003.pnghttp://www.facebook.com/teconnectivityimage004.pnghttp://www.flickr.com/photos/teconnectivity/image005.pnghttp://www.linkedin.com/groups?gid=1591657image006.pnghttp://www.youtube.com/teconnectivity _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.comhttp://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
Re: My first 7-up question
Lars, According to our SHARE:Application Properties, we are using version 1.0.01 of the Data Wizard tool (ARS 7.1 / ITSM 7.0.3) (not sure what version you are on). We used the Data Wizard (not the Data Load tool) to update our Support Organizations and found two issues with our version: 1. The Change Assignee Support Group Name was not being updated. This was a known issue (KA317736 / SW00346842). The KB article says there is no solution, but I found that the issue was some SQL using incorrect column ids. I can dig out my notes if you need me to. 2. The SQL doesn't update the Support Organization information in the 'Full Name' field on the AST:AssetPeople form. This is the data that is displayed on the People tab of Assets (CIs). When the people relationship is for a support group, it has a value like SupportCompany-SupportOrganization-SupportGroup. The wizard doesn't update it to show the new Support Org. There are a couple of things that we would like it to be able to do with Operational Categories and Product Categories that it doesn't, like merge/update old values into existing values. For example, say there are two Product Catalog entries such as Oracle DB and Oracle Database, and you wanted to get rid of Oracle DB and just have Oracle Database. You can't use the Wizard to update the Incidents or Changes that are categorized with Oracle DB. Anyway, that's been our experience with it so far. Thad On Tue, Feb 28, 2012 at 11:01 AM, lars.j.petters...@vattenfall.com wrote: ** Hello, I'm back on arslist, long time ago. Now I belong to our 7-up management unit. Our home built system Tabasco is a dying application, but it has lived since -97:) My question is: Is there any issues with Foundation/Data Management Tool/Data Wizard Console, or is this module working as expected. Direct SQL, or ars workflow? Thanks in advance, Lars _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
Re: MS SQL question
I installed SRM and had FTS enabled, the SRM keyword search would not work. I disabled FTS and the search worked fine and was case insensitive. FTS has a problem with searching a LIKE %value%. It will not work at all. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Brian Pancia Sent: Tuesday, February 28, 2012 3:51 PM To: arslist@ARSLIST.ORG Subject: Re: MS SQL question ** Dave, Case Sensitivity is not an issue with MS SQL. Also with 7.6.04 you have FTS, which provides better search capabilities for both Oracle and SQL. In my opinion MS SQL has come a long way in the last few releases and can stand up to Oracle as a true enterprise solution. I think a few years ago there were some valid reasons to go Linux(or flavor of Unix)/Oracle. Microsoft has come a long way though from both the OS and DB side of the house. I think now it just depends on the level of onsite expertise for your DB. I have set up multiple systems on both Oracle and MS SQL over the years and these days I find it much easier to go the Microsoft route. Both are rock solid if configured properly. If you have FTS configured properly it does relief some of the Oracle constraints, but it is something additional you would have to manage. Brian From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Shellman, David Sent: Tuesday, February 28, 2012 2:00 PM To: arslist@ARSLIST.ORG Subject: MS SQL question ** I know that there are a couple of short comings with running the AR System on Oracle. Namely case sensitivity and searching a large character field. I'm wondering if there are short comings running on MS SQL. Not really looking for a debate on the advantages of one over the other. Just looking to see if MS SQL has any similar peculiarities. Thanks Dave Dave Shellman +1 717 810 3687 tel +1 717 810 2124 fax dave.shell...@te.commailto:dave.shell...@te.com MS 161-043 PO Box 3608 Harrisburg, PA 17105-3608 [cid:image001.gif@01CCF631.6D1E8990]http://www.te.com/ [cid:image002.png@01CCF631.6D1E8990]http://twitter.com/teconnectivity[cid:image003.png@01CCF631.6D1E8990]http://www.facebook.com/teconnectivity[cid:image004.png@01CCF631.6D1E8990]http://www.flickr.com/photos/teconnectivity/[cid:image005.png@01CCF631.6D1E8990]http://www.linkedin.com/groups?gid=1591657[cid:image006.png@01CCF631.6D1E8990]http://www.youtube.com/teconnectivity _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.comhttp://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 inline: image001.gifinline: image002.pnginline: image003.pnginline: image004.pnginline: image005.pnginline: image006.png
Re: Remedy Approval 7.6.04
Hi Dan Try the health check in the utilitied directory of the uinstaller. It's my experience that it gives a little more detail thanthe post install sanity check. BR Jonas Stevsnvig Den 28-02-2012 16:02, Dan skrev: Listers, We are in the process of building a new system. windows 2008, AR server 7.6.04 install. The approval server failed to install initially due to some group permissions on the server set by the network lockdown. We have resolved those but now the approval server fails its post install sanity check. I get the following Warnings. LOG EVENT {Description=[Approval server post install sanity check execution - timed out]} LOG EVENT {Description=[BMC_APPROVAL_SERVER_SANITY_FAILED],Detail=[The Approval Server post installation check failed.]} Any ideas what could/would cause this. What is it trying to do during the sanity check that could cause a time out. I have a feeling it may be something on the server that is causing it to time out but just not sure where to look as I am not sure what it is trying to do during this part of the sanity check. Thanks Dan ___ 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: ARERR 1889 received on changing date to 03/11/12 02:00
If you want to start to criticize the Remedy error sentences we can make a good collection :) Regards, Jose Huerta http://theremedyforit.com/ On Tue, Feb 28, 2012 at 18:26, Andrew C Goodall ago...@jcpenney.com wrote: ** ** ** Thanks – I should have looked at that sooner J ** ** Although, that’s obvious to a Remedy Admin – to the user it’s not very clear why the tool is behaving in that manner. A message to the user could have explained this action to them in plain English – not the tech jargon. Note: the error message was not received on the web client (which most of our customers use), only the WUT. ** ** Regards, *Andrew Goodall* Software Engineer 2 | Development Services | jcpenney . www.jcp.com http://www.jcp.com/ -- *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Grooms, Frederick W *Sent:* Tuesday, February 28, 2012 11:21 AM *To:* arslist@ARSLIST.ORG *Subject:* Re: ARERR 1889 received on changing date to 03/11/12 02:00 ** ** This is the description of error 1889 ** ** *Message Text:* Date is out of allowed range of 01/01/1970 to 01/19/2038 (GMT) for Windows client. ** ** *Description:* If you enter a date outside of the listed range, based on Greenwich Mean Time (GMT), you receive this error message. GMT is the time zone from which all other time zones are adjusted. ** ** This error also appears for dates that are within the hour that the time changes for the start of daylight saving time. For more information, see knowledge base article ID 5816 on the BMC Remedy Customer Support website. ** ** Fred ** ** ** ** *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Andrew C Goodall *Sent:* Tuesday, February 28, 2012 11:09 AM *To:* arslist@ARSLIST.ORG *Subject:* Re: ARERR 1889 received on changing date to 03/11/12 02:00 ** ** ** Thanks Elizabeth - I thought this was something to do with daylight savings, so it sounds like that is by design even if it was poorly implemented? If so, a more meaningful user friendly reason should have been populated to the user. ** ** Regards, *Andrew Goodall* Software Engineer 2 | Development Services | jcpenney . www.jcp.com http://www.jcp.com/ -- *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Elizabeth Low *Sent:* Tuesday, February 28, 2012 10:56 AM *To:* arslist@ARSLIST.ORG *Subject:* Re: ARERR 1889 received on changing date to 03/11/12 02:00 ** ** Hello Andrew, March 11, 2012 is when DST starts. On March 11, it goes from 1:59am to 3:am. 2am to 2:59am is invalid on March 11, 2012. Elizabeth Low -- Date: Tue, 28 Feb 2012 11:48:48 -0500 From: ago...@jcpenney.com Subject: ARERR 1889 received on changing date to 03/11/12 02:00 To: arslist@ARSLIST.ORG ** All, ARS 7.5 patch 4 Midtier 7.5 patch 4 ITSM 7.5.01 I had a user report an issue this morning. They are unable to update a Change CRQ requested start date to 3/11/2012 2:00:00 AM On midtier web client it does not show an error and when you enter 3/11/2012 2:00:00 AM it simply changes your entry to 1 hour later 3/11/2012 3:00:00 AM On the WUT (I’m using 7.6.04 patch 3) you get the below error message: Date is out of allowed range of 01/01/1970 - 01/19/2038 (GMT) for Windows client. : 3/11/2012 2:00:00 AM: Requested Start Date+ (ARERR 1889) Any help would be appreciated, we’ll be contacting support J Regards, *Andrew Goodall* Software Engineer 2 | Development Services | jcpenney . www.jcp.com http://www.jcp.com/ ** ** The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If the reader of this message is not the intended recipient, you are hereby notified that your access is unauthorized, and any review, dissemination, distribution or copying of this message including any attachments is strictly prohibited. If you are not the intended recipient, please contact the sender and delete the material from any computer. _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _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
Re: Assignment Company and Organization values in 7.6.4 SP2
Don't understand what are you looking for. If you are talking about the HPD:Help Desk form, those fields are still in the form, but are not attached to any view. Regards, Jose Huerta http://theremedyforit.com/ On Tue, Feb 28, 2012 at 17:46, Mahmoud Mahdy-Mohamed mahmoud.mahdy-moha...@vodafone.com wrote: ** Dears, Anyone know how can I obtain the values of Assignment Company and Organization separately as I used both in a lot of customizations.?? Note:- I’m upgrading from version 7.1 to 7.6.4 SP2 and only the last layer appears “Assigned Group”. ** ** *Thanks,* *Best Regards,* * * *Mahmoud Mahdy Mohammed,PMP* | Business Process Automation* **Technology | Products Services Delivery* *Phone:* +20(0)104999638 * Mail:* *mahmoud.mahdy-moha...@vodafone.commohamed.abdel-haf...@vodafone.com * ** ** * The content of this document is classified as Vodafone Egypt S.A.E. Confidential and Proprietary Information. The recipient hereby is committed to hold in strict confidence the contents of this (e-mail, document, information) and not to disclose to any third party without the prior written consent of Vodafone Egypt S.A.E. Recipient will be held liable for any unauthorized disclosure. If you have received this message in error, please notify the sender by return e-mail and delete the message in its entirety, including any attachments. http://www.vodafone.com.eg * _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
Re: MS SQL question
Dave, Sorry. I wasn't trying to come across as comparing which is better, but after re-reading my post it doesn't directly answer your question. I have not found any major gotchas with MS SQL. Oracle case sensitivity has always been an issue. You can set flags at the db level to change that, but then you are risking performance hits. Tommy, I have seen some issues with how FTS performs certain searches like wildcard searches. It's been a few months since I've messed with FTS. I'll see if I can dig up my notes from an installation we did that we ended up doing a bunch of tweaks to FTS. FTS has been around for a long time now, so I'm sure a bunch of people can chime in on FTS tips and tricks. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Shellman, David Sent: Tuesday, February 28, 2012 4:57 PM To: arslist@ARSLIST.ORG Subject: Re: MS SQL question ** Brian, I understand. As I said I'm not asking which is better. I'm attempting to understand if there are any hidden gotchas with MS SQL like there is with Oracle. There my not be any but that is what I want to identify. Thanks Dave On Feb 28, 2012, at 4:51 PM, Brian Pancia panc...@finityit.com wrote: ** Dave, Case Sensitivity is not an issue with MS SQL. Also with 7.6.04 you have FTS, which provides better search capabilities for both Oracle and SQL. In my opinion MS SQL has come a long way in the last few releases and can stand up to Oracle as a true enterprise solution. I think a few years ago there were some valid reasons to go Linux(or flavor of Unix)/Oracle. Microsoft has come a long way though from both the OS and DB side of the house. I think now it just depends on the level of onsite expertise for your DB. I have set up multiple systems on both Oracle and MS SQL over the years and these days I find it much easier to go the Microsoft route. Both are rock solid if configured properly. If you have FTS configured properly it does relief some of the Oracle constraints, but it is something additional you would have to manage. Brian From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Shellman, David Sent: Tuesday, February 28, 2012 2:00 PM To: arslist@ARSLIST.ORG Subject: MS SQL question ** I know that there are a couple of short comings with running the AR System on Oracle. Namely case sensitivity and searching a large character field. I'm wondering if there are short comings running on MS SQL. Not really looking for a debate on the advantages of one over the other. Just looking to see if MS SQL has any similar peculiarities. Thanks Dave Dave Shellman +1 717 810 3687 tel +1 717 810 2124 fax mailto:dave.shell...@te.com dave.shell...@te.com MS 161-043 PO Box 3608 Harrisburg, PA 17105-3608 http://www.te.com/ image001.gif http://twitter.com/teconnectivity image002.png http://www.facebook.com/teconnectivity image003.png http://www.flickr.com/photos/teconnectivity/ image004.png http://www.linkedin.com/groups?gid=1591657 image005.png http://www.youtube.com/teconnectivity image006.png _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _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
Re: MS SQL question
No performance hits in Oracle if you follow my post: http://theremedyforit.com/2011/12/case-insensitive-in-remedy/ Jose M. Huerta Project Manager** Movil: 661 665 088 Telf.: 971 75 03 24 Fax: 971 75 07 94 http://www.sm2baleares.es/ SM2 Baleares S.A. C/Rita Levi Edificio SM2 Parc Bit 07121 Palma de Mallorca http://es-es.facebook.com/pages/SM2-Baleares/158608627954 http://twitter.com/#!/SM2Baleares http://www.linkedin.com/company/sm2-baleares La información contenida en este mensaje de correo electrónico es confidencial. La misma, es enviada con la intención de que únicamente sea leída por la persona(s) a la(s) que va dirigida. El acceso a este mensaje por otras personas no está autorizado, por lo que en tal caso, le rogamos que nos lo comunique por la misma vía, se abstenga de realizar copias del mensaje o remitirlo o entregarlo a otra persona y proceda a borrarlo de inmediato. P Por favor, no imprima este mensaje ni sus documentos adjuntos si no es necesario. On Wed, Feb 29, 2012 at 06:04, Brian Pancia panc...@finityit.com wrote: ** Dave, ** ** Sorry. I wasn't trying to come across as comparing which is better, but after re-reading my post it doesn't directly answer your question. I have not found any major gotchas with MS SQL. Oracle case sensitivity has always been an issue. You can set flags at the db level to change that, but then you are risking performance hits. ** ** Tommy, ** ** I have seen some issues with how FTS performs certain searches like wildcard searches. It's been a few months since I've messed with FTS. I'll see if I can dig up my notes from an installation we did that we ended up doing a bunch of tweaks to FTS. FTS has been around for a long time now, so I'm sure a bunch of people can chime in on FTS tips and tricks.*** * ** ** *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Shellman, David *Sent:* Tuesday, February 28, 2012 4:57 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: MS SQL question ** ** ** Brian, ** ** I understand. As I said I'm not asking which is better. I'm attempting to understand if there are any hidden gotchas with MS SQL like there is with Oracle. ** ** There my not be any but that is what I want to identify. ** ** Thanks Dave On Feb 28, 2012, at 4:51 PM, Brian Pancia panc...@finityit.com wrote:* *** ** Dave, Case Sensitivity is not an issue with MS SQL. Also with 7.6.04 you have FTS, which provides better search capabilities for both Oracle and SQL. In my opinion MS SQL has come a long way in the last few releases and can stand up to Oracle as a true enterprise solution. I think a few years ago there were some valid reasons to go Linux(or flavor of Unix)/Oracle. Microsoft has come a long way though from both the OS and DB side of the house. I think now it just depends on the level of onsite expertise for your DB. I have set up multiple systems on both Oracle and MS SQL over the years and these days I find it much easier to go the Microsoft route. Both are rock solid if configured properly. If you have FTS configured properly it does relief some of the Oracle constraints, but it is something additional you would have to manage. Brian *From:* Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] *On Behalf Of *Shellman, David *Sent:* Tuesday, February 28, 2012 2:00 PM *To:* arslist@ARSLIST.ORG *Subject:* MS SQL question ** I know that there are a couple of short comings with running the AR System on Oracle. Namely case sensitivity and searching a large character field. I'm wondering if there are short comings running on MS SQL. Not really looking for a debate on the advantages of one over the other. Just looking to see if MS SQL has any similar peculiarities. Thanks Dave *Dave Shellman** *+1 717 810 3687 tel +1 717 810 2124 fax dave.shell...@te.com MS 161-043 PO Box 3608 Harrisburg, PA 17105-3608 image001.gif http://www.te.com/ image002.png http://twitter.com/teconnectivityimage003.pnghttp://www.facebook.com/teconnectivity image004.png http://www.flickr.com/photos/teconnectivity/ image005.png http://www.linkedin.com/groups?gid=1591657image006.pnghttp://www.youtube.com/teconnectivity _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _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
Re: MS SQL question
Jose, This is a good explanation on how to accomplish this in Oracle. However, I would really caution going down this path if you do not understand the database side and remedy tables on the backend. Your recommendation for FTS is as you say the best option. One slight update though to your article FTS is no longer separately licensed in 7.6.04. We went back and forth on a client site recently to make the database changes and ultimately chose the FTS route because the risk of updating and maintaining the indexes was too high. Brian From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jose Huerta Sent: Wednesday, February 29, 2012 12:18 AM To: arslist@ARSLIST.ORG Subject: Re: MS SQL question ** No performance hits in Oracle if you follow my post: http://theremedyforit.com/2011/12/case-insensitive-in-remedy/ Jose M. Huerta Project Manager Movil: 661 665 088 Telf.: 971 75 03 24 Fax: 971 75 07 94 http://www.sm2baleares.es/ SM2 Baleares S.A. C/Rita Levi Edificio SM2 Parc Bit 07121 Palma de Mallorca http://es-es.facebook.com/pages/SM2-Baleares/158608627954 http://twitter.com/#!/SM2Baleares http://www.linkedin.com/company/sm2-baleares La información contenida en este mensaje de correo electrónico es confidencial. La misma, es enviada con la intención de que únicamente sea leída por la persona(s) a la(s) que va dirigida. El acceso a este mensaje por otras personas no está autorizado, por lo que en tal caso, le rogamos que nos lo comunique por la misma vía, se abstenga de realizar copias del mensaje o remitirlo o entregarlo a otra persona y proceda a borrarlo de inmediato. P Por favor, no imprima este mensaje ni sus documentos adjuntos si no es necesario. On Wed, Feb 29, 2012 at 06:04, Brian Pancia panc...@finityit.com wrote: ** Dave, Sorry. I wasn't trying to come across as comparing which is better, but after re-reading my post it doesn't directly answer your question. I have not found any major gotchas with MS SQL. Oracle case sensitivity has always been an issue. You can set flags at the db level to change that, but then you are risking performance hits. Tommy, I have seen some issues with how FTS performs certain searches like wildcard searches. It's been a few months since I've messed with FTS. I'll see if I can dig up my notes from an installation we did that we ended up doing a bunch of tweaks to FTS. FTS has been around for a long time now, so I'm sure a bunch of people can chime in on FTS tips and tricks. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Shellman, David Sent: Tuesday, February 28, 2012 4:57 PM To: arslist@ARSLIST.ORG Subject: Re: MS SQL question ** Brian, I understand. As I said I'm not asking which is better. I'm attempting to understand if there are any hidden gotchas with MS SQL like there is with Oracle. There my not be any but that is what I want to identify. Thanks Dave On Feb 28, 2012, at 4:51 PM, Brian Pancia panc...@finityit.com wrote: ** Dave, Case Sensitivity is not an issue with MS SQL. Also with 7.6.04 you have FTS, which provides better search capabilities for both Oracle and SQL. In my opinion MS SQL has come a long way in the last few releases and can stand up to Oracle as a true enterprise solution. I think a few years ago there were some valid reasons to go Linux(or flavor of Unix)/Oracle. Microsoft has come a long way though from both the OS and DB side of the house. I think now it just depends on the level of onsite expertise for your DB. I have set up multiple systems on both Oracle and MS SQL over the years and these days I find it much easier to go the Microsoft route. Both are rock solid if configured properly. If you have FTS configured properly it does relief some of the Oracle constraints, but it is something additional you would have to manage. Brian From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Shellman, David Sent: Tuesday, February 28, 2012 2:00 PM To: arslist@ARSLIST.ORG Subject: MS SQL question ** I know that there are a couple of short comings with running the AR System on Oracle. Namely case sensitivity and searching a large character field. I'm wondering if there are short comings running on MS SQL. Not really looking for a debate on the advantages of one over the other. Just looking to see if MS SQL has any similar peculiarities. Thanks Dave Dave Shellman +1 717 810 3687 tel:%2B1%20717%20810%203687 tel +1 717 810 2124 tel:%2B1%20717%20810%202124 fax mailto:dave.shell...@te.com dave.shell...@te.com MS 161-043 PO Box 3608 Harrisburg, PA 17105-3608 http://www.te.com/ image001.gif http://twitter.com/teconnectivity image002.png http://www.facebook.com/teconnectivity image003.png
Re: MS SQL question
Sorry about that David. I was assuming most people have switched over to the blue pricing by now. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Easter, David Sent: Wednesday, February 29, 2012 12:50 AM To: arslist@ARSLIST.ORG Subject: Re: MS SQL question ** Ø FTS is no longer separately licensed in 7.6.04 To clarify, FTS is separately licensed in 7.6.04 still, but it is now a server based license. Previous versions used a user-based licensing model. For customers who have purchased the ITSM Suite under suite pricing (sometimes referred to as “blue pricing”), that FTS sever based license is included in the ITSM Suite at no additional charge – which is to what you’re probably thinking. However, customer on legacy (sometimes referred to as “green” pricing) will still need to purchase the FTS server-based license separately. In either case, one does still need to go into the Admin Console and ensure that the FTS license is enabled if entitlement has been obtained and one wishes to use it. -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 Brian Pancia Sent: Tuesday, February 28, 2012 9:41 PM To: arslist@ARSLIST.ORG Subject: Re: MS SQL question ** Jose, This is a good explanation on how to accomplish this in Oracle. However, I would really caution going down this path if you do not understand the database side and remedy tables on the backend. Your recommendation for FTS is as you say the best option. One slight update though to your article FTS is no longer separately licensed in 7.6.04. We went back and forth on a client site recently to make the database changes and ultimately chose the FTS route because the risk of updating and maintaining the indexes was too high. Brian From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jose Huerta Sent: Wednesday, February 29, 2012 12:18 AM To: arslist@ARSLIST.ORG Subject: Re: MS SQL question ** No performance hits in Oracle if you follow my post: http://theremedyforit.com/2011/12/case-insensitive-in-remedy/ Jose M. Huerta Project Manager Movil: 661 665 088 Telf.: 971 75 03 24 Fax: 971 75 07 94 http://www.sm2baleares.es/ SM2 Baleares S.A. C/Rita Levi Edificio SM2 Parc Bit 07121 Palma de Mallorca http://es-es.facebook.com/pages/SM2-Baleares/158608627954 http://twitter.com/#!/SM2Baleares http://www.linkedin.com/company/sm2-baleares La información contenida en este mensaje de correo electrónico es confidencial. La misma, es enviada con la intención de que únicamente sea leída por la persona(s) a la(s) que va dirigida. El acceso a este mensaje por otras personas no está autorizado, por lo que en tal caso, le rogamos que nos lo comunique por la misma vía, se abstenga de realizar copias del mensaje o remitirlo o entregarlo a otra persona y proceda a borrarlo de inmediato. P Por favor, no imprima este mensaje ni sus documentos adjuntos si no es necesario. On Wed, Feb 29, 2012 at 06:04, Brian Pancia panc...@finityit.com wrote: ** Dave, Sorry. I wasn't trying to come across as comparing which is better, but after re-reading my post it doesn't directly answer your question. I have not found any major gotchas with MS SQL. Oracle case sensitivity has always been an issue. You can set flags at the db level to change that, but then you are risking performance hits. Tommy, I have seen some issues with how FTS performs certain searches like wildcard searches. It's been a few months since I've messed with FTS. I'll see if I can dig up my notes from an installation we did that we ended up doing a bunch of tweaks to FTS. FTS has been around for a long time now, so I'm sure a bunch of people can chime in on FTS tips and tricks. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Shellman, David Sent: Tuesday, February 28, 2012 4:57 PM To: arslist@ARSLIST.ORG Subject: Re: MS SQL question ** Brian, I understand. As I said I'm not asking which is better. I'm attempting to understand if there are any hidden gotchas with MS SQL like there is with Oracle. There my not be any but that is what I want to identify. Thanks Dave On Feb 28, 2012, at 4:51 PM, Brian Pancia panc...@finityit.com wrote: ** Dave, Case Sensitivity is not an issue with MS SQL. Also with 7.6.04 you have FTS, which provides better search capabilities for both