field length issue
Hi, can we any mechanism to increase the length of a character field dynamically as the data in that field increases ? Regards, Rajkumar Padole. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: field length issue
You could make it a 0 length field, essentially a clob that way. You will need to use like then on for this field in searches. Raj rajkumar.pad...@vyomlabs.com wrote: Hi, can we any mechanism to increase the length of a character field dynamically as the data in that field increases ? Regards, Rajkumar Padole. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: field length issue
If you make the field length 0 would do the trick for you as Abhijeet suggested but there are issues with FTS and QBE search depending your ARS version. I guess there is a BMC ticket open for this. You may like to know about it. The ARS version 7.5 and 7604 have this issue (at least till SP2). Thanks, Vikrant -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Gadgil, Abhijeet Sent: Thursday, April 11, 2013 12:04 PM To: arslist@ARSLIST.ORG Subject: Re: field length issue You could make it a 0 length field, essentially a clob that way. You will need to use like then on for this field in searches. Raj rajkumar.pad...@vyomlabs.com wrote: Hi, can we any mechanism to increase the length of a character field dynamically as the data in that field increases ? Regards, Rajkumar Padole. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: field length issue
Hi , Thank you for your quick reply Abhijit and Vikrant. Regards, Rajkumar Padole. -Original Message- From: Kulkarni, Vikrant Sent: 11/04/2013, 12:18 PM To: arslist@ARSLIST.ORG Subject: Re: field length issue If you make the field length 0 would do the trick for you as Abhijeet suggested but there are issues with FTS and QBE search depending your ARS version. I guess there is a BMC ticket open for this. You may like to know about it. The ARS version 7.5 and 7604 have this issue (at least till SP2). Thanks, Vikrant -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Gadgil, Abhijeet Sent: Thursday, April 11, 2013 12:04 PM To: arslist@ARSLIST.ORG Subject: Re: field length issue You could make it a 0 length field, essentially a clob that way. You will need to use like then on for this field in searches. Raj rajkumar.pad...@vyomlabs.com wrote: Hi, can we any mechanism to increase the length of a character field dynamically as the data in that field increases ? Regards, Rajkumar Padole. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Taking a database backup with ARServer running.
Hi All, Is there a remedy command that place the ARServer in a consistent state so i can freely backup the underlying database throught database native tools without the need of shutting down the ARServer? The goal is to take a database backup with application consistency having the ARServer uprunning, minimizing the downtime. Is there any way? Thanks in advance, Ale. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Values in the Column didn't appear
** HiWhat are the permissions on that column? I believe if you do not set the correct permissions no data will show.ThanksShafqat Ayaz From: "Heba Hashem, Vodafone Egypt" heba.has...@vodafone.com To: arslist@ARSLIST.ORG Sent: Wednesday, April 10, 2013 12:45 PM Subject: Re: Values in the Column didn't appear ** No the field length is 254 Heba Hashem SYSTEM ANALYST Customer Management Vodafone Egypt Telec. SA Mobile: +20 (10) 07033053 Email: heba.has...@vodafone.com vodafone.com.eg This message and any files or documents attached are confidential and may also be legally privileged, protected from disclosure and/or protected by other legal rules. It is intended only for the individual or entity named. If you are not the named addressee or you have received this email in error, please inform the sender immediately, delete it from your system and do not copy or disclose it or its contents or use it for any purpose. Thank you. Please also note that transmission cannot be guaranteed to be secure or error-free. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jlbess Sent: Wednesday, April 10, 2013 1:34 PM To: arslist@ARSLIST.ORG Subject: Re: Values in the Column didn't appear ** What's the data length of the field? If you add a field greater than 254 characters to a table, it doesn't display any data. Jason Bess On Apr 10, 2013, at 6:37 AM, "Heba Hashem, Vodafone Egypt" heba.has...@vodafone.com wrote: ** Yes, because when I double click on the record, the record with this data appeared. Heba Hashem SYSTEM ANALYST Customer Management Vodafone Egypt Telec. SA Mobile: +20 (10) 07033053 Email: heba.has...@vodafone.com image001.gif vodafone.com.eg This message and any files or documents attached are confidential and may also be legally privileged, protected from disclosure and/or protected by other legal rules. It is intended only for the individual or entity named. If you are not the named addressee or you have received this email in error, please inform the sender immediately, delete it from your system and do not copy or disclose it or its contents or use it for any purpose. Thank you. Please also note that transmission cannot be guaranteed to be secure or error-free. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Ankita Pankaj Sent: Wednesday, April 10, 2013 11:17 AM To: arslist@ARSLIST.ORG Subject: Re: Values in the Column didn't appear ** Hi Heba Hashem, Are you sure that you are looking at the same record in table as in backhand form ? for instance include some unique ID field(Request ID) in table as column then compare your table data with form data. On Wed, Apr 10, 2013 at 2:38 PM, Hullule, Kiran kiran_hull...@bmc.com wrote: ** Your question is not clear, would you please explain little further. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Heba Hashem, Vodafone Egypt Sent: Wednesday, April 10, 2013 2:10 PM To: arslist@ARSLIST.ORG Subject: Values in the Column didn't appear ** Dears, Please I need support as there is tables in customized form view another form. In specific column its vales didn’t appear although there is a value in this field in the form. BMC Remedy 7.6.04 Heba Hashem SYSTEM ANALYST Customer Management Vodafone Egypt Telec. SA Mobile: +20 (10) 07033053 Email: heba.has...@vodafone.com vodafone.com.eg This message and any files or documents attached are confidential and may also be legally privileged, protected from disclosure and/or protected by other legal rules. It is intended only for the individual or entity named. If you are not the named addressee or you have received this email in error, please inform the sender immediately, delete it from your system and do not copy or disclose it or its contents or use it for any purpose. Thank you. Please also note that transmission cannot be guaranteed to be secure or error-free. * 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 * _ARSlist:
Re: Issues in DSO 7.6.04 SP2 Linux-Windows
Nathan, If you are using a portmapper, then that port should be open in the firewall. If you are using private ports, all the appropriate cross bounder addresses must also be opened through the firewall. Regards, Chad Whilding Senior Developer CSC 3560 Pentagon Blvd., Beavercreek, OH 45431-1706 North American Public Sector | p: +1-937.320-7827 | f: | cwhild...@csc.com | www.csc.com This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. From: Nathan Brandt nathanrbra...@gmail.com To: arslist@ARSLIST.ORG Date: 04/09/2013 11:24 PM Subject:Re: Issues in DSO 7.6.04 SP2 Linux-Windows Sent by:Action Request System discussion list(ARSList) arslist@ARSLIST.ORG ** Thanks guys for all the help. I am still trying to figure it out. One more question. When servers are geographically dispersed, how does this work? Typically only mid tier port would be exposed for outside, if at all. If servers are behind firewalls, do we have to go with Placeholder Server which has a public IP? ~ Nathan On Tue, Apr 9, 2013 at 6:32 PM, Chad M Whilding cwhild...@csc.com wrote: ** Nathan, If there is no conflict between your /etc/hosts and DNS, then double check the ar.cfg. There is also an IP-Name parameter that can be used for a server with multiple names. There are also some DSO specific name parameters. Double check that none of these are conflicting. Regards, Chad Whilding Senior Developer CSC 3560 Pentagon Blvd., Beavercreek, OH 45431-1706 North American Public Sector | p: +1-937.320-7827 | f: | cwhild...@csc.com | www.csc.com This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. From:Nathan Brandt nathanrbra...@gmail.com To:arslist@ARSLIST.ORG Date:04/09/2013 01:13 AM Subject:Issues in DSO 7.6.04 SP2 Linux-Windows Sent by:Action Request System discussion list(ARSList) arslist@ARSLIST.ORG ** We are trying to setup DSO between 2 AR servers. One is on RHEL 5.3, 7.6.04 SP2 and other is on Win 2k 8, 7.6.04 SP2 We enabled DSO on both the servers. Machines are in same network and accessible from one another using machine name (same as AR Server name). After making all configuration changes, we observe following 1. From Developer Studio, if we connect to Windows ARS, we are able to connect to Linux Server in one of the distributed mappings. Even here, there is small glitch, we need to specify IP address of Linux machine. It doesn't work with AR Server Name of Linux machine. 2. But from Developer Studio, if we connect to Linux ARS, no matter what we put we are not able to establish connection to Windows ARS server. When configuring DSO on both, we have used machine names (same as AR Server Alias Name) (and not FQDN) of the remote AR Server. Any clues what might be going wrong? ~ Nathan _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Problem Internet Explorer 10.
Hello to all, anyone has problems using the Mid Tier with Internet Explorer 10? since I updated the browser I have to report a java exception! thanks in advance Pietro Ar Server 7.1.00 Patch 011 201007230200 Mit Tier Version 7.6.04 SP4 201209051922 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Taking a database backup with ARServer running.
You should be able to do that. It would be transparent to AR. Online backup is possible. Check with DBA. sent using Galaxy Nexus On Apr 11, 2013 2:29 PM, team.rem...@libero.it team.rem...@libero.it wrote: Hi All, Is there a remedy command that place the ARServer in a consistent state so i can freely backup the underlying database throught database native tools without the need of shutting down the ARServer? The goal is to take a database backup with application consistency having the ARServer uprunning, minimizing the downtime. Is there any way? Thanks in advance, Ale. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Taking a database backup with ARServer running.
BTW its DB activity and not AR. Remedy does not have inbuilt mechanism to backup underlying DB. sent using Galaxy Nexus On Apr 11, 2013 6:12 PM, Mayuresh Wagh mayurbw...@gmail.com wrote: You should be able to do that. It would be transparent to AR. Online backup is possible. Check with DBA. sent using Galaxy Nexus On Apr 11, 2013 2:29 PM, team.rem...@libero.it team.rem...@libero.it wrote: Hi All, Is there a remedy command that place the ARServer in a consistent state so i can freely backup the underlying database throught database native tools without the need of shutting down the ARServer? The goal is to take a database backup with application consistency having the ARServer uprunning, minimizing the downtime. Is there any way? Thanks in advance, Ale. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
R: Re: Taking a database backup with ARServer running.
I know that I can take the DB backup even if the ARServer is running. This isn't my question (I'm also the DBA, I know that I can and I know how to do this ).The matter is if I can consider the ARServer application consistent because it's running. Messaggio originale Da: mayurbw...@gmail.com Data: 11-apr-2013 14.47 A: arslist@ARSLIST.ORG Ogg: Re: Taking a database backup with ARServer running. ** BTW its DB activity and not AR. Remedy does not have inbuilt mechanism to backup underlying DB. sent using Galaxy Nexus On Apr 11, 2013 6:12 PM, Mayuresh Wagh mayurbw...@gmail.com wrote: You should be able to do that. It would be transparent to AR. Online backup is possible. Check with DBA. sent using Galaxy Nexus On Apr 11, 2013 2:29 PM, team.rem...@libero.it team.rem...@libero.it wrote: Hi All, Is there a remedy command that place the ARServer in a consistent state so i can freely backup the underlying database throught database native tools without the need of shutting down the ARServer? The goal is to take a database backup with application consistency having the ARServer upamp;running, minimizing the downtime. Is there any way? Thanks in advance, Ale. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: R: Re: Taking a database backup with ARServer running.
So you are concerned about the AR performance? If that is the case; then it shouldn't be the issue. Schedule backup during non peak hours. sent using Galaxy Nexus On Apr 11, 2013 6:21 PM, team.rem...@libero.it team.rem...@libero.it wrote: ** I know that I can take the DB backup even if the ARServer is running. This isn't my question (I'm also the DBA, I know that I can and I know how to do this ). The matter is if I can consider the ARServer application consistent because it's running. Messaggio originale Da: mayurbw...@gmail.com Data: 11-apr-2013 14.47 A: arslist@ARSLIST.ORG Ogg: Re: Taking a database backup with ARServer running. ** BTW its DB activity and not AR. Remedy does not have inbuilt mechanism to backup underlying DB. sent using Galaxy Nexus On Apr 11, 2013 6:12 PM, Mayuresh Wagh mayurbw...@gmail.com wrote: You should be able to do that. It would be transparent to AR. Online backup is possible. Check with DBA. sent using Galaxy Nexus On Apr 11, 2013 2:29 PM, team.rem...@libero.it team.rem...@libero.it wrote: Hi All, Is there a remedy command that place the ARServer in a consistent state so i can freely backup the underlying database throught database native tools without the need of shutting down the ARServer? The goal is to take a database backup with application consistency having the ARServer uprunning, minimizing the downtime. Is there any way? Thanks in advance, Ale. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Taking a database backup with ARServer running.
The only thing that should be 'in flight' during a backup would be data, and that is going to happen any time an online backup is done, but the application structure is 'consistent' by the fact that you aren't actively making changes to it, so no concerns from that point. On Thu, Apr 11, 2013 at 6:51 AM, team.rem...@libero.it team.rem...@libero.it wrote: ** I know that I can take the DB backup even if the ARServer is running. This isn't my question (I'm also the DBA, I know that I can and I know how to do this ). The matter is if I can consider the ARServer application consistent because it's running. Messaggio originale Da: mayurbw...@gmail.com Data: 11-apr-2013 14.47 A: arslist@ARSLIST.ORG Ogg: Re: Taking a database backup with ARServer running. ** BTW its DB activity and not AR. Remedy does not have inbuilt mechanism to backup underlying DB. sent using Galaxy Nexus On Apr 11, 2013 6:12 PM, Mayuresh Wagh mayurbw...@gmail.com wrote: You should be able to do that. It would be transparent to AR. Online backup is possible. Check with DBA. sent using Galaxy Nexus On Apr 11, 2013 2:29 PM, team.rem...@libero.it team.rem...@libero.it wrote: Hi All, Is there a remedy command that place the ARServer in a consistent state so i can freely backup the underlying database throught database native tools without the need of shutting down the ARServer? The goal is to take a database backup with application consistency having the ARServer uprunning, minimizing the downtime. Is there any way? Thanks in advance, Ale. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Problem Internet Explorer 10.
Heya, Internet Explorer 10 is not compatible or supported with your version. We are running 7.6.4sp3 MidTier and have users with IE 10 on Windows 7 8 machines, which has caused us a minor headache. So, to address this, I altered the login_common.jsp file to include an IE10 Browser check, which will throw up a warning message, if the user is on IE10, to have them use either Firefox, Chrome or a compatible version of Internet Explorer. You will need to alter the IE8 detection/handling code first and then add in the IE10 code. My altered code, as an example: function shoeIE8VersionAlert() { // get the path var pathstr = requrl; var patharr = pathstr.split(/); pathstr = patharr[0]; var ie8Warn = getCookieValue('I'); if (ie8Warn != 1) { ie8Warn = 1; //run popup check exactly once addAlert(%=MessageTranslation.getLocalizedText(locale, For Midtier to work properly on Internet Explorer 8, Please make sure that you have required patch installed. Please see)% + a target='_blank' href='http://www.microsoft.com/technet/security/bulletin/MS10-018.mspx'Microsoft Security Bulletin MS10-018/a); //set a cookie to show you have already displayed a message var ie8Cookie = I= + ie8Warn + ;path=/ + pathstr; document.cookie = ie8Cookie; } } function shoeIE10VersionAlert() { // get the path var pathstr = requrl; var patharr = pathstr.split(/); pathstr = patharr[0]; var ie10Warn = getCookieValue('I'); if (ie10Warn != 1) { ie10Warn = 1; //run popup check exactly once addAlert(%=MessageTranslation.getLocalizedText(locale, Internet Explorer 10 is NOT COMPATIBLE. Please use Internet Explorer 9 or another supported browser, such as Chrome or FireFox.)%); //set a cookie to show you have already displayed a message var ie10Cookie = I= + ie10Warn + ;path=/ + pathstr; document.cookie = ie10Cookie; } } function addAlert(msg) { document.getElementById(alertArea).style.display = block; var prnt = document.getElementById(errList); var li = document.createElement(LI); var para = document.createElement('P'); para.className = warning; para.innerHTML = msg; li.appendChild(para); prnt.appendChild(li); } /* * This function performs the necessary initialization * when page is loaded. */ function initLogin() { // check if cookie is enabled so applications can run if (document.cookie == ) { alert(%=MessageTranslation.getLocalizedText(locale, Cookies are disabled. Cannot access mid-tier with this setting.\\nPlease configure your browser to accept cookies.)%); return; } detectPopupBlockers(); detectFlash(); setInitialFormState(); // Check browser type and version var browserOK = false; var browserApp = navigator.appName; // Netscape if (browserApp == Netscape) { //all NN7 browsers and above are Gecko based if (navigator.userAgent.indexOf(Gecko) != -1) browserOK = true; } // IE else if (browserApp == Microsoft Internet Explorer) { var browserVersion = navigator.appVersion; var MSIEindex = browserVersion.indexOf('MSIE '); // Check for IE version 6.0 or higher if (MSIEindex = 0) { var MSIEversion = browserVersion.substring(MSIEindex+5); var vf = parseFloat(MSIEversion); if (vf = 6.0) browserOK = true; if(vf == 8) shoeIE8VersionAlert(); if(vf == 10) shoeIE10VersionAlert(); } } Hope this helps. Keith Sinclair Sr. Application Developer DeVry Inc. 814 Commerce Dr. Oakbrook, IL 60523-8822 p: 630.645.1143 e: ksincl...@devry.com w: www.devryinc.com -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of team.rem...@libero.it Sent: Thursday, April 11, 2013 7:35 AM To: arslist@ARSLIST.ORG Subject: Problem Internet Explorer 10. Hello to all, anyone has problems using the Mid Tier with Internet Explorer 10? since I updated the browser I have to report a java exception! thanks in advance Pietro Ar Server 7.1.00 Patch 011 201007230200 Mit Tier Version 7.6.04 SP4 201209051922 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist
Re: Problem Internet Explorer 10.
I had a report of a caught exception error with IE 10 against our 7.5 server/7.5 midtier, and just now found that I could work around it by selecting the Compatibility View icon for older web sites. (It's the small icon to the right of the security lock symbol at the top.) After I did that, the Remedy form worked fine. David Durling University of Georgia -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Sinclair, Keith Sent: Thursday, April 11, 2013 10:06 AM To: arslist@ARSLIST.ORG Subject: Re: Problem Internet Explorer 10. Heya, Internet Explorer 10 is not compatible or supported with your version. We are running 7.6.4sp3 MidTier and have users with IE 10 on Windows 7 8 machines, which has caused us a minor headache. So, to address this, I altered the login_common.jsp file to include an IE10 Browser check, which will throw up a warning message, if the user is on IE10, to have them use either Firefox, Chrome or a compatible version of Internet Explorer. --- break --- -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of team.rem...@libero.it Sent: Thursday, April 11, 2013 7:35 AM To: arslist@ARSLIST.ORG Subject: Problem Internet Explorer 10. Hello to all, anyone has problems using the Mid Tier with Internet Explorer 10? since I updated the browser I have to report a java exception! thanks in advance Pietro Ar Server 7.1.00 Patch 011 201007230200 Mit Tier Version 7.6.04 SP4 201209051922 __ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Taking a database backup with ARServer running.
Wouldn't putting the AR Server in Admin Only mode stop any transactions to the db? No one would be able to use the system, but it would take less time that a reboot. Drew JTF-Bravo Honduras On Thu, Apr 11, 2013 at 7:19 AM, Longwing, Lj llongw...@usgs.gov wrote: ** The only thing that should be 'in flight' during a backup would be data, and that is going to happen any time an online backup is done, but the application structure is 'consistent' by the fact that you aren't actively making changes to it, so no concerns from that point. On Thu, Apr 11, 2013 at 6:51 AM, team.rem...@libero.it team.rem...@libero.it wrote: ** I know that I can take the DB backup even if the ARServer is running. This isn't my question (I'm also the DBA, I know that I can and I know how to do this ). The matter is if I can consider the ARServer application consistent because it's running. Messaggio originale Da: mayurbw...@gmail.com Data: 11-apr-2013 14.47 A: arslist@ARSLIST.ORG Ogg: Re: Taking a database backup with ARServer running. ** BTW its DB activity and not AR. Remedy does not have inbuilt mechanism to backup underlying DB. sent using Galaxy Nexus On Apr 11, 2013 6:12 PM, Mayuresh Wagh mayurbw...@gmail.com wrote: You should be able to do that. It would be transparent to AR. Online backup is possible. Check with DBA. sent using Galaxy Nexus On Apr 11, 2013 2:29 PM, team.rem...@libero.it team.rem...@libero.it wrote: Hi All, Is there a remedy command that place the ARServer in a consistent state so i can freely backup the underlying database throught database native tools without the need of shutting down the ARServer? The goal is to take a database backup with application consistency having the ARServer uprunning, minimizing the downtime. Is there any way? Thanks in advance, Ale. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Taking a database backup with ARServer running.
Also other admin processes would continue to update the DB. Things like Escalations, Reconciliation Engine, Email Engine, Normalization, SLM. The only way to stop changes to the db is shut down the Remedy apps or put the db in a read-only mode but then the apps would most likely die. Can you specify what you concern is? Our organization and many others restore ARSystem databases from backups all the time without issue. Yes there are probably some records out of sync due to timing of the backups but for our purposes it is good enough. It sounds like you might be doing more than just restoring production to dev where consistency is a bit more critical. Jason On Thu, Apr 11, 2013 at 8:02 AM, Longwing, Lj llongw...@usgs.gov wrote: ** Yes, putting in admin mode would stop all non admin level traffic...but that kinda defeats the purpose of doing it 'online' On Thu, Apr 11, 2013 at 8:55 AM, Drew Shuller drew.shul...@gmail.comwrote: ** Wouldn't putting the AR Server in Admin Only mode stop any transactions to the db? No one would be able to use the system, but it would take less time that a reboot. Drew JTF-Bravo Honduras On Thu, Apr 11, 2013 at 7:19 AM, Longwing, Lj llongw...@usgs.gov wrote: ** The only thing that should be 'in flight' during a backup would be data, and that is going to happen any time an online backup is done, but the application structure is 'consistent' by the fact that you aren't actively making changes to it, so no concerns from that point. On Thu, Apr 11, 2013 at 6:51 AM, team.rem...@libero.it team.rem...@libero.it wrote: ** I know that I can take the DB backup even if the ARServer is running. This isn't my question (I'm also the DBA, I know that I can and I know how to do this ). The matter is if I can consider the ARServer application consistent because it's running. Messaggio originale Da: mayurbw...@gmail.com Data: 11-apr-2013 14.47 A: arslist@ARSLIST.ORG Ogg: Re: Taking a database backup with ARServer running. ** BTW its DB activity and not AR. Remedy does not have inbuilt mechanism to backup underlying DB. sent using Galaxy Nexus On Apr 11, 2013 6:12 PM, Mayuresh Wagh mayurbw...@gmail.com wrote: You should be able to do that. It would be transparent to AR. Online backup is possible. Check with DBA. sent using Galaxy Nexus On Apr 11, 2013 2:29 PM, team.rem...@libero.it team.rem...@libero.it wrote: Hi All, Is there a remedy command that place the ARServer in a consistent state so i can freely backup the underlying database throught database native tools without the need of shutting down the ARServer? The goal is to take a database backup with application consistency having the ARServer uprunning, minimizing the downtime. Is there any way? Thanks in advance, Ale. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Sr. Remedy Developer
I live in downtown Seattle! Sent from my iPhone On Apr 11, 2013, at 11:21 AM, Mike Brahn mbr...@jupgroup.com wrote: ** Rick, Would TeleCommunications be willing to relocate a candidate from Texas? Give me a call whenever you get a chance Mike Brahn Jupiter Group 832-778-1960 ext# 208 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Cook Sent: Thursday, April 11, 2013 10:49 AM To: arslist@ARSLIST.ORG Subject: JOB: Sr. Remedy Developer ** TeleCommunication Systems, Inc. (TCS) (NASDAQ: TSYS) is looking for a Sr. Remedy AR System Developer. This is an FTE job located in downtown Seattle. This is a great position for anyone with substantial experience doing old-school custom Remedy AR System development in an Agile environment to support important functions. You would be part of a team of solid Remedy Professionals, with the primary role of supporting E-911 technology being managed in a completely custom Remedy set of applications. This is not for the casual AR System developer or someone who built a few forms or an integration once – we are looking for someone who is really good and experienced at custom AR System development. Full details about the company and the position and a link to apply are below. Direct technical questions to me, and any others to Jainene Ruttner at jrutt...@telecomsys.com. http://ch.tbe.taleo.net/CH12/ats/careers/requisition.jsp?org=TELECOMSYScws=1rid=2615 Rick Cook Sr. Remedy ITSM Architect TeleCommunication Systems Inc. 206-792-2130 _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Sr. Remedy Developer
Hmm. I live outside of Harrisburg ;) From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Bruce - Gmail Sent: Thursday, April 11, 2013 12:47 PM To: arslist@ARSLIST.ORG Subject: Re: Sr. Remedy Developer ** I live in downtown Seattle! Sent from my iPhone On Apr 11, 2013, at 11:21 AM, Mike Brahn mbr...@jupgroup.commailto:mbr...@jupgroup.com wrote: ** Rick, Would TeleCommunications be willing to relocate a candidate from Texas? Give me a call whenever you get a chance Mike Brahn Jupiter Group 832-778-1960 ext# 208 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Cook Sent: Thursday, April 11, 2013 10:49 AM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: JOB: Sr. Remedy Developer ** TeleCommunication Systems, Inc. (TCS) (NASDAQ: TSYS) is looking for a Sr. Remedy AR System Developer. This is an FTE job located in downtown Seattle. This is a great position for anyone with substantial experience doing old-school custom Remedy AR System development in an Agile environment to support important functions. You would be part of a team of solid Remedy Professionals, with the primary role of supporting E-911 technology being managed in a completely custom Remedy set of applications. This is not for the casual AR System developer or someone who built a few forms or an integration once – we are looking for someone who is really good and experienced at custom AR System development. Full details about the company and the position and a link to apply are below. Direct technical questions to me, and any others to Jainene Ruttner at jrutt...@telecomsys.commailto:jrutt...@telecomsys.com. http://ch.tbe.taleo.net/CH12/ats/careers/requisition.jsp?org=TELECOMSYScws=1rid=2615 Rick Cook Sr. Remedy ITSM Architect TeleCommunication Systems Inc. 206-792-2130 _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Taking a database backup with ARServer running.
What about a clustered database? Could a backup be made of one of the db's while it was shut down, leaving the other databases running. ARS wouldn't know the difference. You would still have data sync problems. Drew Soto Cano Air Base Honduras ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Sr. Remedy Developer
I live two hours northeast of Harrisburg and work about two hours south - I'll wave on the way by twice a week :) - Original Message - From: David Shellman dave.shell...@te.com To: arslist@ARSLIST.ORG Sent: Thursday, April 11, 2013 12:49:48 PM Subject: Re: Sr. Remedy Developer ** Hmm. I live outside of Harrisburg ;) From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Bruce - Gmail Sent: Thursday, April 11, 2013 12:47 PM To: arslist@ARSLIST.ORG Subject: Re: Sr. Remedy Developer ** I live in downtown Seattle! Sent from my iPhone On Apr 11, 2013, at 11:21 AM, Mike Brahn mbr...@jupgroup.com wrote: ** Rick, Would TeleCommunications be willing to relocate a candidate from Texas? Give me a call whenever you get a chance Mike Brahn Jupiter Group 832-778-1960 ext# 208 From: Action Request System discussion list(ARSList) [ mailto:arslist@ARSLIST.ORG ] On Behalf Of Rick Cook Sent: Thursday, April 11, 2013 10:49 AM To: arslist@ARSLIST.ORG Subject: JOB: Sr. Remedy Developer ** TeleCommunication Systems, Inc. (TCS) (NASDAQ: TSYS) is looking for a Sr. Remedy AR System Developer. This is an FTE job located in downtown Seattle. This is a great position for anyone with substantial experience doing old-school custom Remedy AR System development in an Agile environment to support important functions. You would be part of a team of solid Remedy Professionals, with the primary role of supporting E-911 technology being managed in a completely custom Remedy set of applications. This is not for the casual AR System developer or someone who built a few forms or an integration once – we are looking for someone who is really good and experienced at custom AR System development. Full details about the company and the position and a link to apply are below. Direct technical questions to me, and any others to Jainene Ruttner at jrutt...@telecomsys.com . http://ch.tbe.taleo.net/CH12/ats/careers/requisition.jsp?org=TELECOMSYScws=1rid=2615 Rick Cook Sr. Remedy ITSM Architect TeleCommunication Systems Inc. 206-792-2130 _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Sr. Remedy Developer
Is today Friday? I live in Toronto but I have a direct flight to Seattle, don't know about Harrisburg but I bet I have flown over it. And if I were applying for a job, I'm not sure I would post my phone number on the list and say give me a call (although some have done worse and found themselves looking for a job instead of applying for another). Daniel -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of pritch Sent: April 11, 2013 1:35 PM To: arslist@ARSLIST.ORG Subject: Re: Sr. Remedy Developer I live two hours northeast of Harrisburg and work about two hours south - I'll wave on the way by twice a week :) - Original Message - From: David Shellman dave.shell...@te.com To: arslist@ARSLIST.ORG Sent: Thursday, April 11, 2013 12:49:48 PM Subject: Re: Sr. Remedy Developer ** Hmm.� I live outside of Harrisburg ;) � From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Bruce - Gmail Sent: Thursday, April 11, 2013 12:47 PM To: arslist@ARSLIST.ORG Subject: Re: Sr. Remedy Developer � ** I live in downtown Seattle! � Sent from my iPhone On Apr 11, 2013, at 11:21 AM, Mike Brahn mbr...@jupgroup.com wrote: ** Rick, � Would TeleCommunications be willing to relocate a candidate from Texas? Give me a call whenever you get a chance � Mike Brahn Jupiter Group 832-778-1960 ext# 208 � From: Action Request System discussion list(ARSList) [ mailto:arslist@ARSLIST.ORG ] On Behalf Of Rick Cook Sent: Thursday, April 11, 2013 10:49 AM To: arslist@ARSLIST.ORG Subject: JOB: Sr. Remedy Developer � ** TeleCommunication Systems, Inc. (TCS) (NASDAQ: TSYS) is looking for a Sr. Remedy AR System Developer. This is an FTE job located in downtown Seattle. This is a great position for anyone with substantial experience doing old-school custom Remedy AR System development in an Agile environment to support important functions. You would be part of a team of solid Remedy Professionals, with the primary role of supporting E-911 technology being managed in a completely custom Remedy set of applications. This is not for the casual AR System developer or someone who built a few forms or an integration once � we are looking for someone who is really good and experienced at custom AR System development. Full details about the company and the position and a link to apply are below. Direct technical questions to me, and any others to Jainene Ruttner at jrutt...@telecomsys.com . http://ch.tbe.taleo.net/CH12/ats/careers/requisition.jsp?org=TELECOMSYScws=1rid=2615 Rick Cook Sr. Remedy ITSM Architect TeleCommunication Systems Inc. 206-792-2130 _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Taking a database backup with ARServer running.
Good database backups do two things; (a) Take a database backup (b) Take a transaction log backup during the time that the database backup was running (included in the backup) As I am sure you already know, this is one of the differences between a SQL database backup and an MS Access DB backup. The included transaction log backup allows the DBMS to restore a database so that it is consistent. So, your database should be consistent from a purely backup/restore basis and from a Remedy-application basis. However, if you need to restore the database from this backup at a later time, you may restore to a point where you were in a middle of some processing, reconciliation, etc. etc. when the database backup was executed so the data may not be completely recovered from a business application perspective. If that is the case, you will also need to schedule your periodic transaction log backups to get the db restore to a point where the business data is consistent. Better transaction log recovery tools allow you to restore to a specific transaction/point in time. Scheduling of your database and transaction log backups should take this into consideration. I hope this answers your question. Terry _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jason Miller Sent: April-11-13 12:36 PM To: arslist@ARSLIST.ORG Subject: Re: Taking a database backup with ARServer running. ** Also other admin processes would continue to update the DB. Things like Escalations, Reconciliation Engine, Email Engine, Normalization, SLM. The only way to stop changes to the db is shut down the Remedy apps or put the db in a read-only mode but then the apps would most likely die. Can you specify what you concern is? Our organization and many others restore ARSystem databases from backups all the time without issue. Yes there are probably some records out of sync due to timing of the backups but for our purposes it is good enough. It sounds like you might be doing more than just restoring production to dev where consistency is a bit more critical. Jason On Thu, Apr 11, 2013 at 8:02 AM, Longwing, Lj llongw...@usgs.gov wrote: ** Yes, putting in admin mode would stop all non admin level traffic...but that kinda defeats the purpose of doing it 'online' On Thu, Apr 11, 2013 at 8:55 AM, Drew Shuller drew.shul...@gmail.com wrote: ** Wouldn't putting the AR Server in Admin Only mode stop any transactions to the db? No one would be able to use the system, but it would take less time that a reboot. Drew JTF-Bravo Honduras On Thu, Apr 11, 2013 at 7:19 AM, Longwing, Lj llongw...@usgs.gov wrote: ** The only thing that should be 'in flight' during a backup would be data, and that is going to happen any time an online backup is done, but the application structure is 'consistent' by the fact that you aren't actively making changes to it, so no concerns from that point. On Thu, Apr 11, 2013 at 6:51 AM, team.rem...@libero.it team.rem...@libero.it wrote: ** I know that I can take the DB backup even if the ARServer is running. This isn't my question (I'm also the DBA, I know that I can and I know how to do this ). The matter is if I can consider the ARServer application consistent because it's running. Messaggio originale Da: mayurbw...@gmail.com Data: 11-apr-2013 14.47 A: arslist@ARSLIST.ORG Ogg: Re: Taking a database backup with ARServer running. ** BTW its DB activity and not AR. Remedy does not have inbuilt mechanism to backup underlying DB. sent using Galaxy Nexus On Apr 11, 2013 6:12 PM, Mayuresh Wagh mayurbw...@gmail.com wrote: You should be able to do that. It would be transparent to AR. Online backup is possible. Check with DBA. sent using Galaxy Nexus On Apr 11, 2013 2:29 PM, team.rem...@libero.it team.rem...@libero.it wrote: Hi All, Is there a remedy command that place the ARServer in a consistent state so i can freely backup the underlying database throught database native tools without the need of shutting down the ARServer? The goal is to take a database backup with application consistency having the ARServer uprunning, minimizing the downtime. Is there any way? Thanks in advance, Ale. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the
Latest quote from gartner
The overlap between CMDB and asset management is more apparent in BMC's product suite than in any other vendor's ITAM offering. http://www.gartner.com/technology/reprints.do?id=1-1EW2TFXct=130403st=sb It's an interesting and fairly quick read. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Multiple Developers on Single Server
Hay Guys Hope everyone is well. Apologies if this has been discussed before and if so would appreciate a point in the right direction to find the information I am looking for. Basically, I wanted to know how you guys handle multiple remedy developers on a single development server. We have 4 developers that are constantly working on the system with object reservation activated. However, we do find that the system is performing slow during the day and at times, freezes and has to have the remedy services restarted. We are thinking of basically giving each developer now their own development area all tied to a central DB to see if that will eliminate the problem. How do you guys handle it? Any ideas or suggestions on how multiple developers on a single remedy application server (DB is on it's own separate server) Any advice would be appreciated. Keep well Cheers ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Multiple Developers on Single Server
One option is to use AR System Version Control: Object Reservation , to reserve objects by any one developer and release it after usage. On Thu, Apr 11, 2013 at 12:34 PM, BradRemedy bradrem...@gmail.com wrote: ** Hay Guys Hope everyone is well. Apologies if this has been discussed before and if so would appreciate a point in the right direction to find the information I am looking for. Basically, I wanted to know how you guys handle multiple remedy developers on a single development server. We have 4 developers that are constantly working on the system with object reservation activated. However, we do find that the system is performing slow during the day and at times, freezes and has to have the remedy services restarted. We are thinking of basically giving each developer now their own development area all tied to a central DB to see if that will eliminate the problem. How do you guys handle it? Any ideas or suggestions on how multiple developers on a single remedy application server (DB is on it's own separate server) Any advice would be appreciated. Keep well Cheers _ARSlist: Where the Answers Are and have been for 20 years_ -- Regards, Kiran Kodali Ph: 940-231-8524 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: [EXTERNAL] Multiple Developers on Single Server
Brad: We also have multiple developers on a single server in each environment (Dev, Qual, and Prod). Do you run custom Remedy apps on your server, or are you running something like ITSM? I can't speak to the performance issues you are having, but I think it would help the more technical folks on the List to know what kind of Remedy apps you are running, also your AR System Server version and ITSM and mid-tier versions (if applicable). Maybe also whether your DB is SQL or Oracle. Thanks, Natalie Stroud SAIC @ Sandia National Laboratories ARS-ITSM Reporting Specialist Albuquerque, NM USA nkst...@sandia.govmailto:nkst...@sandia.gov ITSM 7.6.04 SP2 - Windows 2003 - SQL Server 2008 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of BradRemedy Sent: Thursday, April 11, 2013 12:35 PM To: arslist@ARSLIST.ORG Subject: [EXTERNAL] Multiple Developers on Single Server ** Hay Guys Hope everyone is well. Apologies if this has been discussed before and if so would appreciate a point in the right direction to find the information I am looking for. Basically, I wanted to know how you guys handle multiple remedy developers on a single development server. We have 4 developers that are constantly working on the system with object reservation activated. However, we do find that the system is performing slow during the day and at times, freezes and has to have the remedy services restarted. We are thinking of basically giving each developer now their own development area all tied to a central DB to see if that will eliminate the problem. How do you guys handle it? Any ideas or suggestions on how multiple developers on a single remedy application server (DB is on it's own separate server) Any advice would be appreciated. Keep well Cheers _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Write permissions errors with read (floating) license
Hi Thad, Thank you, the new site has only been active fore 24 hours or so, so you did not have to stay away very long to have missed it ;-) Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11/12): * 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. Misi, I didn't think it had been that long since my last visit to your site; but at any rate, I like the new layout. Its seems more polished and readable. Good job. Cheers, Thad On Wed, Apr 10, 2013 at 2:00 AM, Misi Mladoniczky m...@rrr.se wrote: Hi, When installing a new server, I always compare the ar.cfg-files using RRR|ConfDiff to make sure nothing is missed. https://www.rrr.se/cgi/tools/main Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11/12): * 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. Well today was much more quiet than yesterday -- I got a few reports that some users were having the same results; other people let me know that they were no longer having the problem. However, by yesterday afternoon, I had already sent out an email explaining what was going on, so some of those affected may have decided that they did not need to report the errors. Now that you mention it, I'm not certain that this is a licensing issue. Thanks again, Joe On Tue, 9 Apr 2013 20:45:39 +0200, Misi Mladoniczky m...@rrr.se wrote: Hi, I would call that a Window-Open-Action, and that should not require a license, and the Submitter-group would not be involved in the receiving form. Or you might set your fields with a ACTL Set-Fields-Action from the server, in which case you should have no problem either. Are you sure this is a licensing issue? What happened today when more users came in? Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11/12): * 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 . ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Taking a database backup with ARServer running.
Bonus points to Terry for pointing out that the recovery solution is more important than the backup solution. I've seen so many situations where the recovery experience was far from optimal. A list of things to avoid: 1) A single (sometimes external) team is responsible for everyone's backups and is undermanned such that obtaining a backup to recover from takes significant time. 2) Not regularly verifying the backups are recoverable. (i.e. We had nightly backups but they didn't work) 3) Not testing your recovery process. (Initial recovery was easy, but then we had to apply 15 transaction logs) 4) Application administrators have no idea how to ask for a recovery once they determine one is necessary. (or no idea how long it takes, or no idea who to get in touch with as a getting started point) 5) Reliance on external vendors at any point in your backup/recovery process who don't have SLAs that match the response you need in a real disaster situation. This one applies to development environments as well. If you have 4 projects reliant on your development system being up and running and the fact that it's a development environment pushes the recovery SLA from 3 hours to 5 days, that's a huge risk. 6) No documented verification process to follow once a recovery has taken place. Just throwing my 2 cents in. Steve On Thu, Apr 11, 2013 at 11:02 AM, Terry Bootsma tboot...@objectpath.comwrote: ** ** Good database backups do two things; (a) Take a database backup (b) Take a transaction log backup during the time that the database backup was running (included in the backup) As I am sure you already know, this is one of the differences between a SQL database backup and an MS Access DB backup. The included transaction log backup allows the DBMS to restore a database so that it is consistent. So, your database should be consistent from a purely backup/restore basis and from a Remedy-application basis. However, if you need to restore the database from this backup at a later time, you may restore to a point where you were in a middle of some processing, reconciliation, etc. etc. when the database backup was executed so the data may not be completely recovered from a business application perspective. If that is the case, you will also need to schedule your periodic transaction log backups to get the db restore to a point where the business data is consistent. Better transaction log recovery tools allow you to restore to a specific transaction/point in time. Scheduling of your database and transaction log backups should take this into consideration. I hope this answers your question. Terry -- *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Jason Miller *Sent:* April-11-13 12:36 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Taking a database backup with ARServer running. ** Also other admin processes would continue to update the DB. Things like Escalations, Reconciliation Engine, Email Engine, Normalization, SLM. The only way to stop changes to the db is shut down the Remedy apps or put the db in a read-only mode but then the apps would most likely die. Can you specify what you concern is? Our organization and many others restore ARSystem databases from backups all the time without issue. Yes there are probably some records out of sync due to timing of the backups but for our purposes it is good enough. It sounds like you might be doing more than just restoring production to dev where consistency is a bit more critical. Jason On Thu, Apr 11, 2013 at 8:02 AM, Longwing, Lj llongw...@usgs.gov wrote: ** Yes, putting in admin mode would stop all non admin level traffic...but that kinda defeats the purpose of doing it 'online' On Thu, Apr 11, 2013 at 8:55 AM, Drew Shuller drew.shul...@gmail.comwrote: ** Wouldn't putting the AR Server in Admin Only mode stop any transactions to the db? No one would be able to use the system, but it would take less time that a reboot. Drew JTF-Bravo Honduras On Thu, Apr 11, 2013 at 7:19 AM, Longwing, Lj llongw...@usgs.govwrote: ** The only thing that should be 'in flight' during a backup would be data, and that is going to happen any time an online backup is done, but the application structure is 'consistent' by the fact that you aren't actively making changes to it, so no concerns from that point. On Thu, Apr 11, 2013 at 6:51 AM, team.rem...@libero.it team.rem...@libero.it wrote: ** I know that I can take the DB backup even if the ARServer is running. This isn't my question (I'm also the DBA, I know that I can and I know how to do this ). The matter is if I can consider the ARServer application consistent because it's running. Messaggio originale Da: mayurbw...@gmail.com Data: 11-apr-2013 14.47 A: arslist@ARSLIST.ORG Ogg: Re: Taking a database backup with ARServer running.
Re: Taking a database backup with ARServer running.
For 1 and 4 and 6 . What, You mean your backup group is not using the ARS system (so someone can request a recovery/restore) ;) Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Steve Kallestad Sent: Thursday, April 11, 2013 2:02 PM To: arslist@ARSLIST.ORG Subject: Re: Taking a database backup with ARServer running. ** Bonus points to Terry for pointing out that the recovery solution is more important than the backup solution. I've seen so many situations where the recovery experience was far from optimal. A list of things to avoid: 1) A single (sometimes external) team is responsible for everyone's backups and is undermanned such that obtaining a backup to recover from takes significant time. 2) Not regularly verifying the backups are recoverable. (i.e. We had nightly backups but they didn't work) 3) Not testing your recovery process. (Initial recovery was easy, but then we had to apply 15 transaction logs) 4) Application administrators have no idea how to ask for a recovery once they determine one is necessary. (or no idea how long it takes, or no idea who to get in touch with as a getting started point) 5) Reliance on external vendors at any point in your backup/recovery process who don't have SLAs that match the response you need in a real disaster situation. This one applies to development environments as well. If you have 4 projects reliant on your development system being up and running and the fact that it's a development environment pushes the recovery SLA from 3 hours to 5 days, that's a huge risk. 6) No documented verification process to follow once a recovery has taken place. Just throwing my 2 cents in. Steve -Original Message- On Thu, Apr 11, 2013 at 11:02 AM, Terry Bootsma wrote: ** Good database backups do two things; (a) Take a database backup (b) Take a transaction log backup during the time that the database backup was running (included in the backup) As I am sure you already know, this is one of the differences between a SQL database backup and an MS Access DB backup. The included transaction log backup allows the DBMS to restore a database so that it is consistent. So, your database should be consistent from a purely backup/restore basis and from a Remedy-application basis. However, if you need to restore the database from this backup at a later time, you may restore to a point where you were in a middle of some processing, reconciliation, etc. etc. when the database backup was executed so the data may not be completely recovered from a business application perspective. If that is the case, you will also need to schedule your periodic transaction log backups to get the db restore to a point where the business data is consistent. Better transaction log recovery tools allow you to restore to a specific transaction/point in time. Scheduling of your database and transaction log backups should take this into consideration. I hope this answers your question. Terry -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jason Miller Sent: April-11-13 12:36 PM To: arslist@ARSLIST.ORG Subject: Re: Taking a database backup with ARServer running. ** Also other admin processes would continue to update the DB. Things like Escalations, Reconciliation Engine, Email Engine, Normalization, SLM. The only way to stop changes to the db is shut down the Remedy apps or put the db in a read-only mode but then the apps would most likely die. Can you specify what you concern is? Our organization and many others restore ARSystem databases from backups all the time without issue. Yes there are probably some records out of sync due to timing of the backups but for our purposes it is good enough. It sounds like you might be doing more than just restoring production to dev where consistency is a bit more critical. Jason -Original Message- On Thu, Apr 11, 2013 at 8:02 AM, Longwing, Lj wrote: ** Yes, putting in admin mode would stop all non admin level traffic...but that kinda defeats the purpose of doing it 'online' -Original Message- On Thu, Apr 11, 2013 at 8:55 AM, Drew Shuller wrote: ** Wouldn't putting the AR Server in Admin Only mode stop any transactions to the db? No one would be able to use the system, but it would take less time that a reboot. Drew JTF-Bravo Honduras -Original Message- On Thu, Apr 11, 2013 at 7:19 AM, Longwing, Lj wrote: ** The only thing that should be 'in flight' during a backup would be data, and that is going to happen any time an online backup is done, but the application structure is 'consistent' by the fact that you aren't actively making changes to it, so no concerns from that point. -Original Message- On Thu, Apr 11, 2013 at 6:51 AM, team.remedy wrote: ** I know that I can
Re: [EXTERNAL] Multiple Developers on Single Server
You might also want to talk to your internal server teams to see if you need more RAM or CPU on the servers. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Stroud, Natalie K Sent: Thursday, April 11, 2013 11:55 AM To: arslist@ARSLIST.ORG Subject: Re: [EXTERNAL] Multiple Developers on Single Server ** Brad: We also have multiple developers on a single server in each environment (Dev, Qual, and Prod). Do you run custom Remedy apps on your server, or are you running something like ITSM? I can't speak to the performance issues you are having, but I think it would help the more technical folks on the List to know what kind of Remedy apps you are running, also your AR System Server version and ITSM and mid-tier versions (if applicable). Maybe also whether your DB is SQL or Oracle. Thanks, Natalie Stroud SAIC @ Sandia National Laboratories ARS-ITSM Reporting Specialist Albuquerque, NM USA nkst...@sandia.gov ITSM 7.6.04 SP2 - Windows 2003 - SQL Server 2008 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of BradRemedy Sent: Thursday, April 11, 2013 12:35 PM To: arslist@ARSLIST.ORG Subject: [EXTERNAL] Multiple Developers on Single Server ** Hay Guys Hope everyone is well. Apologies if this has been discussed before and if so would appreciate a point in the right direction to find the information I am looking for. Basically, I wanted to know how you guys handle multiple remedy developers on a single development server. We have 4 developers that are constantly working on the system with object reservation activated. However, we do find that the system is performing slow during the day and at times, freezes and has to have the remedy services restarted. We are thinking of basically giving each developer now their own development area all tied to a central DB to see if that will eliminate the problem. How do you guys handle it? Any ideas or suggestions on how multiple developers on a single remedy application server (DB is on it's own separate server) Any advice would be appreciated. Keep well Cheers _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Taking a database backup with ARServer running.
You can use any DB backup mechanism you have access to. The AR System does all work in a transactionally consistent way. The DB is ALWAYS in a stable state between transactions (OK, if you are in the middle of restructuring, we do have to commit the metadata changes at a separate time of the actual DB restructure operations so you do want to avoid doing a backup while you are creating or modifying form definitions – but that is an obvious restriction). As long as your on-line backup includes some form of transaction log capture for things in flight, you should be good to go. Now, the other comments about making sure the restore process works and is timely and the like are definitely key points you need to have all figured out for this to really work. Doug From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of team.rem...@libero.it Sent: Thursday, April 11, 2013 5:51 AM To: arslist@ARSLIST.ORG Subject: R: Re: Taking a database backup with ARServer running. ** I know that I can take the DB backup even if the ARServer is running. This isn't my question (I'm also the DBA, I know that I can and I know how to do this [cid:~WRD000.jpg] ). The matter is if I can consider the ARServer application consistent because it's running. Messaggio originale Da: mayurbw...@gmail.com Data: 11-apr-2013 14.47 A: arslist@ARSLIST.ORG Ogg: Re: Taking a database backup with ARServer running. ** BTW its DB activity and not AR. Remedy does not have inbuilt mechanism to backup underlying DB. sent using Galaxy Nexus On Apr 11, 2013 6:12 PM, Mayuresh Wagh mayurbw...@gmail.commailto:mayurbw...@gmail.com wrote: You should be able to do that. It would be transparent to AR. Online backup is possible. Check with DBA. sent using Galaxy Nexus On Apr 11, 2013 2:29 PM, team.rem...@libero.itmailto:team.rem...@libero.it team.rem...@libero.itmailto:team.rem...@libero.it wrote: Hi All, Is there a remedy command that place the ARServer in a consistent state so i can freely backup the underlying database throught database native tools without the need of shutting down the ARServer? The goal is to take a database backup with application consistency having the ARServer uprunning, minimizing the downtime. Is there any way? Thanks in advance, Ale. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.orghttp://www.arslist.org Where the Answers Are, and have been for 20 years _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years inline: ~WRD000.jpg
CMDB Graph API question(food for thought?..maybe)
Hi List, I am wondering if anyone has encountered this before or not. I was going through Javadoc of CMDB API and came across the class CMDBQueryQualifier which is one of the crucial classes involved in getting Graph API to work. CMDBQueryItem(CMDBClassNameKey classNameKey, java.lang.String id, CMDBQueryQualifier constraint, java.util.ArrayListjava.lang.String contentSelector) Now, Direct Known Subclasses of CMDBQueryQualifier are CMDBQueryQualifierAndOr, CMDBQueryQualifierOpNot, CMDBQueryQualifierSetOp, CMDBQueryQualifierSimpleOp and CMDBQueryQualifierAndOr has the followingDirect Known Subclasses: CMDBQueryQualifierOpAnd, CMDBQueryQualifierOpOr CMDBQueryQualifierOpAnd needs a right and left operand to work. CMDBQueryQualifierOpAnd(CMDBQueryQualifier leftOp, CMDBQueryQualifier rightOp) Constructs a CMDBQueryQualifierOpAnd object using the left and right operands.This is extremely tedious because for a simple query(like below) involving 2 operands, I have to do this e.g 'ABC'=5 AND 'PQR'=0 CMDBQueryQualifierSimpleOp cf1 = new CMDBQueryQualifierSimpleOp(CMDBQueryQualifierSimpleOp.CMDB_QUERY_QUAL_OP_EQUAL, ABC, new CMDBQueryQualifierValueTypeValue(new Value(5))); CMDBQueryQualifierSimpleOp cf2 = new CMDBQueryQualifierSimpleOp(CMDBQueryQualifierSimpleOp.CMDB_QUERY_QUAL_OP_EQUAL, DEF, new CMDBQueryQualifierValueTypeValue(new Value(0))); CMDBQueryQualifierOpAnd cf3 = new CMDBQueryQualifierOpAnd(cf1, cf2); CMDBQueryItem queryItem2 = new CMDBQueryItem(destination, destinationClassId, cf3, resultSetAttributes); What if key/value pairs in qualification increases? How do we deal with not going through pain of creating new objects every time qualification is changed? e.g. ('ABC'=5 AND 'PQR'=0) AND ( 'JKL'=8 AND 'RST'=10) Now, I need to create 4 more objects:1. simple query for JKL that does (JKL=8) 2. simple query for RST that does (RST=10) 3. QueryQualifier AND for representing left and right side (JKL=8 AND RST=10)4. To represent AND operation between #3 and (ABC=5 AND PQR=0)( variable cf3 in code above) Am I missing anything or not looking at correct place, because I cant find my way out of using CMDBQueryQualifier constraint. It would have been much easier if API would just accept a String as the constraint or maybe something like below: Constructor: CMDBQueryQualifierOpAnd(ArrayListCMDBQueryQualifierSimpleOp) The implementation of this constructor should automatically add AND between each SimpleOp object. Actually, core QualifierInfo object would have made the job much easier. QualifierInfo qualByQuery = context.parseQualification(..); Thoughts? How can we overcome this tedious behavior? I spent good amount of time looking at this, but hey, if anything is obvious and I missed it, please pardon me. ThanksChintan. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Multiple Developers on Single Server
The admin operations are single threaded. If you introduce multiple arsevers for development using a common database you are by passing the lock in the mechanism which could corrupt the code or metadata. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
DSO Return Filter
Was trying out Return Operation with DSO. I have a Server A and Server B. Server A is sort of Source. I did DSO Mapping and was able to move data from A-Form1 to B-Form1 in Data + Ownership Mode. When TRANSFER is done, as expected, for the record in question, Server B is has Master Flag set to YES. Now If I delete this record from Server B, it automatically gets deleted From Server A. So far so good. But If I modify the record on Server B, changes are not coming back to Server A, so I guess Return operation is not working correctly. Interestingly Filter which I have written for B-Form1, does not ask for DSO Mapping moment you choose Action-DSO-Type (Return). I am wondering how Server B figures out what mapping is to be used for Return Operation and how to make Return operation work? Enabling Filter Logs on Server B shows this error USER: Distributed Server Overlay-Group: 1 Note: Distributed Server cannot transfer or return unless overridden Log file for DSO reveals nothing. ~ Nathan ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years