Re: How to upgrade AR system ITSM apps from 6.x to 7.x
Hi Rick, Thanks for the heads-up J I understood as to how we'll do the workflow migration. I'm curious to know, § For these kind of activities, do we use Migrator tool or you have any suggestions to this? § Say in scenarios, we have to move the data to the latest version, then do we have some tool to accomplish the bulk data load? Best Regards, Ramya From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook Sent: Wednesday, April 09, 2008 8:41 PM To: arslist@ARSLIST.ORG Subject: Re: How to upgrade AR system ITSM apps from 6.x to 7.x ** I'll make this short and simple. You do not upgrade. The differences between v6 and v7 of the applications are as night and day. To migrate from v6 to v7, you need to install v7 fresh on a new server, and then figure out whether you want to migrate your existing customizations and code over. Once you get to that point, there are many here with the experience to help you over the bumps. Rick On Wed, Apr 9, 2008 at 3:14 AM, Rajagopal, Ramya [EMAIL PROTECTED] wrote: ** Hi All, I'm new to this ARList community. I was looking for steps/procedures for upgrading AR system ITSM apps from 6.x to 7.x. can anyone share documents which can be a helping hand. Thanks in advance Thanks, Ramya __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ *** The information in this email is confidential and may be legally privileged. Access to this email by anyone other than the intended addressee is unauthorized. If you are not the intended recipient of this message, any review, disclosure, copying, distribution, retention, or any action taken or omitted to be taken in reliance on it is prohibited and may be unlawful. If you are not the intended recipient, please reply to or forward a copy of this message to the sender and delete the message, any attachments, and any copies thereof from your system. *** ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
arserverd 'hangs' (AR 7.0.1 patch 5 - Sol 10 - Ora 10g2)
Hey guys, We're getting a strange issue (seemingly intermittent) with the arserverd where it just seems to 'hang'. All existing and new clients receive a TimeOut error, but yet when you check : -the processes at the o/s -the error logs -db sessions there is no evidence that there is an issue. (i.e. all processes running, you get timeouts appearing due to Brie / SLM engine not being able to connect and db sessions are not 'locked' or taking an extensive amount of time to process). It seems that the only way to fix this is to do a restart of the AR Server. I was just wondering if anyone else has experienced anything remotely similar to this? Thanks. George (AR 7.0.1 patch 5 - Sol 10 - Ora 10g2) ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Bulk Data import in ITSM 7
Thanks, Rick~ Can I use this in any production environment? Or will it harm my clients in future for licensing? Please clarify. Regards, Thivagar Sankaran Remedy Developer ITIL - Foundation Certified _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook Sent: Wednesday, April 09, 2008 8:44 PM To: arslist@ARSLIST.ORG Subject: Re: Bulk Data import in ITSM 7 ** Effective Technologies' DataLink tool will do all of those - with the free basic version. http://www.effect-tech.com. Rick On Wed, Apr 9, 2008 at 12:24 AM, Saravanan Palaniappan [EMAIL PROTECTED] wrote: ** Do you have the dataload sheet and the bat file associated with it? Thanks Regards Saravanan Palaniappan ITSM To teach and to learn, to laugh and make others laugh. This is my purpose. Any day I don't do this was not worth the time it took to get through it. _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Thivagar Sankaran Sent: Wednesday, April 09, 2008 12:50 PM To: arslist@ARSLIST.ORG Subject: Bulk Data import in ITSM 7 Hi List, Could you please guide how to do the bulk import for the following? 1. Company Data 2. Organization Data 3. Location Data 4. Support Group Data 5. People Data Thanks in advance, Thivagar Sankaran Remedy Developer ITIL - Foundation Certified __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ - This message, including any attachments, contains confidential information intended for a specific individual and purpose, and is intended for the addressee only. Any unauthorized disclosure, use, dissemination, copying, or distribution of this message or any of its attachments or the information contained in this e-mail, or the taking of any action based on it, is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return e-mail and delete this message. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are smime.p7s Description: S/MIME cryptographic signature
How can I have ARS Remedy 6.3 Demo?
Hi everyone, I ask you if there is the possibility to have the ARS Remedy 6.3 with a trial license to evaluate it for a possible future projects. Or initially, how can I do to have this software with related license without purchase order? Can someone help me? kind regards Caterina Carotenuto -- View this message in context: http://www.nabble.com/How-can-I-have-ARS-Remedy-6.3-Demo--tp16607746p16607746.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Bulk Data import in ITSM 7
Look at the Dataload Ùtility which is released as Patch 9003 for ITSM 7. And yes, you can use it in a production environment. If you want you can use AIE or EIE to populate the data load forms instead of the batch file and the MS Excel sheets. http://developer.bmc.com/jiveProd/ann.jspa?annID=20 Kind Regards, Michiel On Thu, Apr 10, 2008 at 11:07 AM, Thivagar Sankaran [EMAIL PROTECTED] wrote: ** Thanks, Rick~ Can I use this in any production environment? Or will it harm my clients in future for licensing? Please clarify. Regards, Thivagar Sankaran Remedy Developer ITIL – Foundation Certified -- *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Rick Cook *Sent:* Wednesday, April 09, 2008 8:44 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Bulk Data import in ITSM 7 ** Effective Technologies' DataLink tool will do all of those - with the free basic version. http://www.effect-tech.com. Rick On Wed, Apr 9, 2008 at 12:24 AM, Saravanan Palaniappan [EMAIL PROTECTED] wrote: ** Do you have the dataload sheet and the bat file associated with it? Thanks Regards Saravanan Palaniappan ITSM To teach and to learn, to laugh and make others laugh. This is my purpose. Any day I don't do this was not worth the time it took to get through it. -- *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Thivagar Sankaran *Sent:* Wednesday, April 09, 2008 12:50 PM *To:* arslist@ARSLIST.ORG *Subject:* Bulk Data import in ITSM 7 Hi List, Could you please guide how to do the bulk import for the following? 1. Company Data 2. Organization Data 3. Location Data 4. Support Group Data 5. People Data Thanks in advance, Thivagar Sankaran Remedy Developer ITIL – Foundation Certified __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ - This message, including any attachments, contains confidential information intended for a specific individual and purpose, and is intended for the addressee only. Any unauthorized disclosure, use, dissemination, copying, or distribution of this message or any of its attachments or the information contained in this e-mail, or the taking of any action based on it, is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return e-mail and delete this message. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___
Re: How can I have ARS Remedy 6.3 Demo?
You can download the software and get temp licenses from the support web site. The request for temp licenses may only be good for 7.x though. Dave - [EMAIL PROTECTED] (Wireless) - Original Message - From: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG To: arslist@ARSLIST.ORG arslist@ARSLIST.ORG Sent: Thu Apr 10 06:50:24 2008 Subject: How can I have ARS Remedy 6.3 Demo? Hi everyone, I ask you if there is the possibility to have the ARS Remedy 6.3 with a trial license to evaluate it for a possible future projects. Or initially, how can I do to have this software with related license without purchase order? Can someone help me? kind regards Caterina Carotenuto -- View this message in context: http://www.nabble.com/How-can-I-have-ARS-Remedy-6.3-Demo--tp16607746p16607746.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Replacing test data with live
Dear List, We have two separate Remedy systems each with its own database, one a test/development system and the other a live/production system. We try to keep them in sync, but don’t always succeed. Our dba is suggesting simply replacing the data in the test database with data from the live database. Are there any pitfalls that we should be aware of? (ARS 7.1, RH Linux server, Oracle 10.2 db) Dwayne Martin James Madison University
Re: Replacing test data with live
We do this often in our systems. The only thing I am aware of that is an issue is server references in the different databases. We have scripts that we execute to replace embedded server references. I might also add that I am in a SQL environment. HTH, Roger A. Nall Manager, OSSNMS Remedy T-Mobile, USA Desk: 813-348-2556 Cell: 973-652-6723 FAX: 813-348-2565 sf49fanv AIM IM RogerNall Yahoo IM -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin Sent: Thursday, April 10, 2008 8:03 AM To: arslist@ARSLIST.ORG Subject: Replacing test data with live Dear List, We have two separate Remedy systems each with its own database, one a test/development system and the other a live/production system. We try to keep them in sync, but don't always succeed. Our dba is suggesting simply replacing the data in the test database with data from the live database. Are there any pitfalls that we should be aware of? (ARS 7.1, RH Linux server, Oracle 10.2 db) Dwayne Martin James Madison University ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Replacing test data with live
Could you please share those scripts? I am having problems after I updated my DR server from the Prod DB. Embedded server references are not something I thought about. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Nall, Roger Sent: Thursday, April 10, 2008 8:09 AM To: arslist@ARSLIST.ORG Subject: Re: Replacing test data with live We do this often in our systems. The only thing I am aware of that is an issue is server references in the different databases. We have scripts that we execute to replace embedded server references. I might also add that I am in a SQL environment. HTH, Roger A. Nall Manager, OSSNMS Remedy T-Mobile, USA Desk: 813-348-2556 Cell: 973-652-6723 FAX: 813-348-2565 sf49fanv AIM IM RogerNall Yahoo IM -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin Sent: Thursday, April 10, 2008 8:03 AM To: arslist@ARSLIST.ORG Subject: Replacing test data with live Dear List, We have two separate Remedy systems each with its own database, one a test/development system and the other a live/production system. We try to keep them in sync, but don't always succeed. Our dba is suggesting simply replacing the data in the test database with data from the live database. Are there any pitfalls that we should be aware of? (ARS 7.1, RH Linux server, Oracle 10.2 db) Dwayne Martin James Madison University ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are STATEMENT OF CONFIDENTIALITY: The information contained in this message or any attachments to this message are intended only for the person(s) or entity to which it is addressed and may contain confidential and/or privileged material as well as being protected from disclosure. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is strictly prohibited. If you received this in error, please contact us immediately and delete the material from any computer. Thank You. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Replacing test data with live
Remember to stop the Email Engine before you restore the database and disable the mailbox configuration(or replace them with you test mailboxes) before you start the emailengine again.. /Rune Sorlid 2008/4/10, Randy Simon [EMAIL PROTECTED]: Could you please share those scripts? I am having problems after I updated my DR server from the Prod DB. Embedded server references are not something I thought about. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Nall, Roger Sent: Thursday, April 10, 2008 8:09 AM To: arslist@ARSLIST.ORG Subject: Re: Replacing test data with live We do this often in our systems. The only thing I am aware of that is an issue is server references in the different databases. We have scripts that we execute to replace embedded server references. I might also add that I am in a SQL environment. HTH, Roger A. Nall Manager, OSSNMS Remedy T-Mobile, USA Desk: 813-348-2556 Cell: 973-652-6723 FAX: 813-348-2565 sf49fanv AIM IM RogerNall Yahoo IM -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin Sent: Thursday, April 10, 2008 8:03 AM To: arslist@ARSLIST.ORG Subject: Replacing test data with live Dear List, We have two separate Remedy systems each with its own database, one a test/development system and the other a live/production system. We try to keep them in sync, but don't always succeed. Our dba is suggesting simply replacing the data in the test database with data from the live database. Are there any pitfalls that we should be aware of? (ARS 7.1, RH Linux server, Oracle 10.2 db) Dwayne Martin James Madison University ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are STATEMENT OF CONFIDENTIALITY: The information contained in this message or any attachments to this message are intended only for the person(s) or entity to which it is addressed and may contain confidential and/or privileged material as well as being protected from disclosure. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is strictly prohibited. If you received this in error, please contact us immediately and delete the material from any computer. Thank You. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
RES: Escalation will not run?
Have you already tried to change your Run If Qualification for: (1=1) OR ('Status' != $NULL$) Att, Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq - Confiabilidade, Inovação e Qualidade em T.I. De: Action Request System discussion list(ARSList) em nome de Sokol, Brian Enviada: qua 9/4/2008 12:39 Para: arslist@ARSLIST.ORG Assunto: Escalation will not run? ** I have an escalation that is normally disabled. I enable it whenever I need it to run. It is very simple and updates two fields in a table. I had nothing in the Run If field and it always worked. Now today it will not run. The escalation log shows Failed Qualification? I tried changing the run if line to things that I know will work (1=1 or $STATUS$ != $NULL$) and same error message. Anyone have an idea why this is failing it's qualification? Brian Sokol Manager, Desktop Services Scholastic Inc. 557 Broadway NY, NY 10012 (212) 343-6494 http://www.Scholastic.com http://www.scholastic.com/ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: arserverd 'hangs' (AR 7.0.1 patch 5 - Sol 10 - Ora 10g2)
Is your database local or remote? Thanks, Gary Opela, Jr., RSP Remedy Engineer Leader Communications, Inc. Best Product, Best People, Best PriceTM An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of George Jungle Sent: Thursday, April 10, 2008 2:45 AM To: arslist@ARSLIST.ORG Subject: arserverd 'hangs' (AR 7.0.1 patch 5 - Sol 10 - Ora 10g2) ** Hey guys, We're getting a strange issue (seemingly intermittent) with the arserverd where it just seems to 'hang'. All existing and new clients receive a TimeOut error, but yet when you check : -the processes at the o/s -the error logs -db sessions there is no evidence that there is an issue. (i.e. all processes running, you get timeouts appearing due to Brie / SLM engine not being able to connect and db sessions are not 'locked' or taking an extensive amount of time to process). It seems that the only way to fix this is to do a restart of the AR Server. I was just wondering if anyone else has experienced anything remotely similar to this? Thanks. George (AR 7.0.1 patch 5 - Sol 10 - Ora 10g2) __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: arserverd 'hangs' (AR 7.0.1 patch 5 - Sol 10 - Ora 10g2)
If you are on a unix server check the number of open files being used by the process. Maybe it has hit the max and locked up your server (why you aren't seeing anything in the logs). type in ulimit -a to tell you the limits you have pfiles process id to tell the number of open files used by the process. Thanks, Sean From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Gary Opela (Corporate) Sent: Thursday, April 10, 2008 9:23 AM To: arslist@ARSLIST.ORG Subject: Re: arserverd 'hangs' (AR 7.0.1 patch 5 - Sol 10 - Ora 10g2) ** Is your database local or remote? Thanks, Gary Opela, Jr., RSP Remedy Engineer Leader Communications, Inc. Best Product, Best People, Best PriceTM An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of George Jungle Sent: Thursday, April 10, 2008 2:45 AM To: arslist@ARSLIST.ORG Subject: arserverd 'hangs' (AR 7.0.1 patch 5 - Sol 10 - Ora 10g2) ** Hey guys, We're getting a strange issue (seemingly intermittent) with the arserverd where it just seems to 'hang'. All existing and new clients receive a TimeOut error, but yet when you check : -the processes at the o/s -the error logs -db sessions there is no evidence that there is an issue. (i.e. all processes running, you get timeouts appearing due to Brie / SLM engine not being able to connect and db sessions are not 'locked' or taking an extensive amount of time to process). It seems that the only way to fix this is to do a restart of the AR Server. I was just wondering if anyone else has experienced anything remotely similar to this? Thanks. George (AR 7.0.1 patch 5 - Sol 10 - Ora 10g2) __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Configuring Multiple AR Email Engine
Hi Amey, Below is a snippet I have regarding Email Engine performance tuning. It is not possible to set up multiple email engines connected to one single AR Server but you can run the email engine on another host that the AR Server. Also there are several options for tuning the email engine. The amount of email you specify should not pose problems. Regards, Michiel Beijen. - There are several things you can do to speed up emails. We have tuned ours so that it can send between 300-500 per minute. We reach those levels several times a day. We can get 1000 per minute if server load is low and the emails do not contain ARTask attachments. Here are a few things you can do: - Use multiple private threads 1. Setup a private RPC queue. Set max threads to the total number of incoming and outgoing mailboxes you have. 2. Specify this RPC number in emaildaemon.properties like this: com.remedy.arsys.emaildaemon.yourserver.RPC=390630 - Configure multiple outgoing mailboxes 1. If you have access to multiple SMTP servers, create one mailbox for each SMTP server. You won't see much gain from using a single SMTP server and aliasing it to allow creation of multiple Remedy mailboxes. A one-for-one on mail servers to mailboxes seems to be a functional limit. But if you have 2 SMTP servers with 2 mailboxes you can double your throughput. 2. If you have an Exchange server, create one for an Outlook profile. (Consider creating multiple Outlook profiles and MAPI mailboxes if you really need more throughput). MAPI tends to be much faster than SMTP but is prone to issues with Exchange connectivity, the Outlook profile, etc. 3. Setup workflow on AR System Email Messages using Set Fields to specify the outgoing mailbox so that it uses a round robin approach. - Increase number of threads per mailbox (7.0.x only) 1. This is a 7.0.x feature I haven't been able to use since I'm on 6.3. But Support has achieved some outrageous improvements with these settings in their test lab. If you're on 7.0.x, add these to your emaildaemon.properties file. (Note: increasing these settings to higher numbers won't yield higher throughput for some reason) com.remedy.arsys.emaildaemon.NumberOfSenderThreads=4 com.remedy.arsys.emaildaemon.OutgoingMessagesQueueSize=2000 - Dedicated Email Engine server 1. Setup a separate server that does nothing but run the Email Engine service. Search the BMC KB for instructions on changing the registry so that the Email Engine service is not dependent on the local AR Server service. This will allow you to run the Email Engine without running AR Server. Configure the emaildaemon.properties to connect to your actual AR Server. This will really help if your AR Server gets high CPU usage. - Increase the Java heap size 1. Search for this in the BMC KB. Increase the max heap size to 512 MB or 1 GB and you could see a big improvement if Java is using a lot of memory. - Turn off group and user caching 1. Set this line in emaildaemon.properties so the Email Engine won't cache all of your groups and users when it starts up. It will only cache them as needed. It rarely actually needs that info and it uses a lot of memory. This will also make the Email Engine service start much faster. com.remedy.arsys.emaildaemon.FetchUserGroupInfoOnDemand=true - Add additional indexes 1. With SQL analysis we found some email engine queries that could benefit from more indexes when you have quite a bit of history on your email engine forms. Back on 5.1.1 these (and a few others BMC finally added as standard) doubled my outgoing throughput. These include: AR System Email Association 1. Destination ID (improves performance) AR System Email Error Logs 1. Email ID (makes display of AR System Email Messages records faster) 2. Create Date (makes troubleshooting easier) AR System Email Messages 1. Send Message (improves performance) 2. Date Sent (makes troubleshooting easier) 3. Create Date (makes troubleshooting easier) - Reduce the sent item history 1. You can completely eliminate this by setting 'Delete Outgoing Notification Messages' = Yes in each outgoing mailbox, or by setting com.remedy.arsys.emaildaemon.SaveSentItem=False in your emaildaemon.properties file. 2. You can retain a few days worth of history by setting up an escalation to delete records older than a few days from AR System Email Messages, AR System Email Attachments, and AR System Email Association. - Set polling interval below 1 minute 1. If 1 minute is not fast enough for you, and you have a low enough volume for the server to handle frequent polls, set this in emaildaemon.properties so it interprets your polling interval as a number of seconds instead of minutes. You probably don't want to go below 15 seconds on this or it would never really
Licensing Error Message - Production Down
Good Morning All, I hope someone has seen this before or can help me trouble shoot this issue. We lost some network connectivity in our datacenter due a software bug last night and our network team needed applied a code upgrade to the core devices. Once the network crashed we recieved the following entries in the arerror.log, Wed Apr 09 20:12:40 2008 [DBNETLIB][ConnectionRead (recv ()).]General network error. Check your network documentation. (SQL Server 11) Wed Apr 09 20:13:59 2008 390635 : Failure while trying to connect to the SQL database. Please ensure the SQL database is running or contact the Database Administrator for help (ARERR 550) Wed Apr 09 20:13:59 2008 Wed Apr 09 20:13:59 2008 390635 : Cannot initialize contact with SQL database (ARERR 551) Wed Apr 09 20:13:59 2008 Stop server Wed Apr 09 20:13:59 2008 390635 : AR System server terminated -- fatal error encountered (ARNOTE 21) Wed Apr 09 20:14:01 2008 390600 : This version of the Action Request System (R) is ready for use or evaluation without purchasing or activating an authorization key. For unlimited capabilities, contact your sales representative. (ARNOTE 27) We can log into our system but we get licensing error messages when trying to select any of the application consoles, The application is not licensed : BMC:Atrium CMDB (ARERR 9858) The preceding message occurred during the execution of active link CHG:SHR:Set_DatasetName_Default -- action 1. (ARNOTE 1101). I've tried removing the multilicense file but that didn't help. We are running AR applications v 7.0.01 patch 006 in a windows shop, Server 2003 SQL 2005. The application and database are on seporate servers. I've logged a call with BMC support, but it's been an hour and half with no update. Thanks, Lou ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Replacing test data with live
Hi, When I do this, I use RRR|Chive. This allows for differences in the actual application/definitions. This sample script would sync your production server to the test server with the exception of some forms: source_server= prod source_user = Demo source_password = target_server= test target_user = Demo target_password = target_disabledeletefltr = YES target_disablemergefltr = YES multipleforms= * skipforms= \ Application Pending, \ Application Statistics, \ Application Statistics Configuration, \ AR System User Preference, \ AR System User Central File, \ AR System Administrator Preference, \ AR System Email Mailbox Configuration, \ Report, \ Server Events, \ Server Statistics, \ User qual = SPLITAUTO transfertype = SYNCTOTARGET logfile = rrrchive.log loglevel = NOTICE progressbar = YES Download and configure at: https://www.rrr.se/cgi/rrrchive/main Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia: * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. * RRR|Translator - Manage and automate your language translations. Find these products, and many free tools and utilities, at http://rrr.se. Dear List, We have two separate Remedy systems each with its own database, one a test/development system and the other a live/production system. We try to keep them in sync, but donât always succeed. Our dba is suggesting simply replacing the data in the test database with data from the live database. Are there any pitfalls that we should be aware of? (ARS 7.1, RH Linux server, Oracle 10.2 db) Dwayne Martin James Madison University -- This message was scanned by ESVA and is believed to be clean. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Licensing Error Message - Production Down
Has the MAC address changed on the server or, if there are 2 network cards is it now picking a different one than before. You can check this out via the licence tool by trying to add a new license. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Louis Cobuccio Sent: 10 April 2008 14:56 To: arslist@ARSLIST.ORG Subject: Licensing Error Message - Production Down Importance: High Good Morning All, I hope someone has seen this before or can help me trouble shoot this issue. We lost some network connectivity in our datacenter due a software bug last night and our network team needed applied a code upgrade to the core devices. Once the network crashed we recieved the following entries in the arerror.log, Wed Apr 09 20:12:40 2008 [DBNETLIB][ConnectionRead (recv ()).]General network error. Check your network documentation. (SQL Server 11) Wed Apr 09 20:13:59 2008 390635 : Failure while trying to connect to the SQL database. Please ensure the SQL database is running or contact the Database Administrator for help (ARERR 550) Wed Apr 09 20:13:59 2008 Wed Apr 09 20:13:59 2008 390635 : Cannot initialize contact with SQL database (ARERR 551) Wed Apr 09 20:13:59 2008 Stop server Wed Apr 09 20:13:59 2008 390635 : AR System server terminated -- fatal error encountered (ARNOTE 21) Wed Apr 09 20:14:01 2008 390600 : This version of the Action Request System (R) is ready for use or evaluation without purchasing or activating an authorization key. For unlimited capabilities, contact your sales representative. (ARNOTE 27) We can log into our system but we get licensing error messages when trying to select any of the application consoles, The application is not licensed : BMC:Atrium CMDB (ARERR 9858) The preceding message occurred during the execution of active link CHG:SHR:Set_DatasetName_Default -- action 1. (ARNOTE 1101). I've tried removing the multilicense file but that didn't help. We are running AR applications v 7.0.01 patch 006 in a windows shop, Server 2003 SQL 2005. The application and database are on seporate servers. I've logged a call with BMC support, but it's been an hour and half with no update. Thanks, Lou ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Bulk Data import in ITSM 7
Both of these utilities are available to users, without additional licensing (best of my knowledge). Please see previous threads on both of these items—each behaves with significant functional limitations which may or may not satisfy your needs. Don W. McClure, P.E. Data Administrator System Engineer Computing IT Center, Call Tracking Administration University of North Texas, Denton dwmac_at_unt.edu That which counts cannot necessarily be counted: that which can be counted will not always count. -- Albert Einstein From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Michiel Beijen Sent: Thursday, April 10, 2008 5:01 AM To: arslist@ARSLIST.ORG Subject: Re: Bulk Data import in ITSM 7 Look at the Dataload Ùtility which is released as Patch 9003 for ITSM 7. And yes, you can use it in a production environment. If you want you can use AIE or EIE to populate the data load forms instead of the batch file and the MS Excel sheets. http://developer.bmc.com/jiveProd/ann.jspa?annID=20 Kind Regards, Michiel On Thu, Apr 10, 2008 at 11:07 AM, Thivagar Sankaran [EMAIL PROTECTED]mailto:[EMAIL PROTECTED] wrote: ** Thanks, Rick~ Can I use this in any production environment? Or will it harm my clients in future for licensing? Please clarify. Regards, Thivagar Sankaran Remedy Developer ITIL – Foundation Certified From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of Rick Cook Sent: Wednesday, April 09, 2008 8:44 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: Bulk Data import in ITSM 7 ** Effective Technologies' DataLink tool will do all of those - with the free basic version. http://www.effect-tech.com. Rick On Wed, Apr 9, 2008 at 12:24 AM, Saravanan Palaniappan [EMAIL PROTECTED]mailto:[EMAIL PROTECTED] wrote: ** Do you have the dataload sheet and the bat file associated with it? Thanks Regards Saravanan Palaniappan ITSM To teach and to learn, to laugh and make others laugh. This is my purpose. Any day I don't do this was not worth the time it took to get through it. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of Thivagar Sankaran Sent: Wednesday, April 09, 2008 12:50 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Bulk Data import in ITSM 7 Hi List, Could you please guide how to do the bulk import for the following? 1. Company Data 2. Organization Data 3. Location Data 4. Support Group Data 5. People Data Thanks in advance, Thivagar Sankaran Remedy Developer ITIL – Foundation Certified __Platinum Sponsor: www.rmsportal.comhttp://www.rmsportal.com ARSlist: Where the Answers Are html___ - This message, including any attachments, contains confidential information intended for a specific individual and purpose, and is intended for the addressee only. Any unauthorized disclosure, use, dissemination, copying, or distribution of this message or any of its attachments or the information contained in this e-mail, or the taking of any action based on it, is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return e-mail and delete this message. __Platinum Sponsor: www.rmsportal.comhttp://www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.comhttp://www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.comhttp://www.rmsportal.com ARSlist: Where the Answers Are html___
Re: Bulk Data import in ITSM 7
The AIE requires a license under the license rules from BMC The AIE license is granted to people who have a CMDB license. If you're using any of the OOB applications you need to install/license the CMDB and you own a license for both already - consequently you are good to go. Just a bit of trivia. William Rentfrow Principal Consultant, StrataCom [EMAIL PROTECTED] O 952-432-0227 C 701-306-6157 From: Action Request System discussion list(ARSList) on behalf of McClure, Don Sent: Thu 4/10/2008 9:19 AM To: arslist@ARSLIST.ORG Subject: Re: Bulk Data import in ITSM 7 Both of these utilities are available to users, without additional licensing (best of my knowledge). Please see previous threads on both of these items-each behaves with significant functional limitations which may or may not satisfy your needs. Don W. McClure, P.E. Data Administrator System Engineer Computing IT Center, Call Tracking Administration University of North Texas, Denton dwmac_at_unt.edu That which counts cannot necessarily be counted: that which can be counted will not always count. -- Albert Einstein From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Michiel Beijen Sent: Thursday, April 10, 2008 5:01 AM To: arslist@ARSLIST.ORG Subject: Re: Bulk Data import in ITSM 7 Look at the Dataload Ùtility which is released as Patch 9003 for ITSM 7. And yes, you can use it in a production environment. If you want you can use AIE or EIE to populate the data load forms instead of the batch file and the MS Excel sheets. http://developer.bmc.com/jiveProd/ann.jspa?annID=20 Kind Regards, Michiel On Thu, Apr 10, 2008 at 11:07 AM, Thivagar Sankaran [EMAIL PROTECTED] wrote: ** Thanks, Rick~ Can I use this in any production environment? Or will it harm my clients in future for licensing? Please clarify. Regards, Thivagar Sankaran Remedy Developer ITIL - Foundation Certified From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook Sent: Wednesday, April 09, 2008 8:44 PM To: arslist@ARSLIST.ORG Subject: Re: Bulk Data import in ITSM 7 ** Effective Technologies' DataLink tool will do all of those - with the free basic version. http://www.effect-tech.com http://www.effect-tech.com/ . Rick On Wed, Apr 9, 2008 at 12:24 AM, Saravanan Palaniappan [EMAIL PROTECTED] wrote: ** Do you have the dataload sheet and the bat file associated with it? Thanks Regards Saravanan Palaniappan ITSM To teach and to learn, to laugh and make others laugh. This is my purpose. Any day I don't do this was not worth the time it took to get through it. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Thivagar Sankaran Sent: Wednesday, April 09, 2008 12:50 PM To: arslist@ARSLIST.ORG Subject: Bulk Data import in ITSM 7 Hi List, Could you please guide how to do the bulk import for the following? 1. Company Data 2. Organization Data 3. Location Data 4. Support Group Data 5. People Data Thanks in advance, Thivagar Sankaran Remedy Developer ITIL - Foundation Certified __Platinum Sponsor: www.rmsportal.com http://www.rmsportal.com/ ARSlist: Where the Answers Are html___ - This message, including any attachments, contains confidential information intended for a specific individual and purpose, and is intended for the addressee only. Any unauthorized disclosure, use, dissemination, copying, or distribution of this message or any of its attachments or the information contained in this e-mail, or the taking of any action based on it, is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return e-mail and delete this message. __Platinum Sponsor: www.rmsportal.com http://www.rmsportal.com/ ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com http://www.rmsportal.com/ ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com http://www.rmsportal.com/ ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
OT: ITSM 7 - Task - Status Reason (Spelt Wrong)
Not sure if anyone has seen this or reported it to Remedy, but the Status Reason in Task Canceled is spelt wrong - should be Cancelled. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: arserverd 'hangs' (AR 7.0.1 patch 5 - Sol 10 - Ora 10g2)
George, I have seen this behavior in a situation we had where AR System was actually restarting. There is no indication in any of the logs that the server crashed or was manually stopped. You can detect this by having server side SQL logging on when this occurs. If you see lots of SQL transactions with no identified user associated to them, then the server process is starting up. This doesn't help identify the root cause but the question changes from Why does the server 'hang'? to Why is the server restarting? HTH Roger From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of George Jungle Sent: Thursday, April 10, 2008 2:45 AM To: arslist@ARSLIST.ORG Subject: arserverd 'hangs' (AR 7.0.1 patch 5 - Sol 10 - Ora 10g2) ** Hey guys, We're getting a strange issue (seemingly intermittent) with the arserverd where it just seems to 'hang'. All existing and new clients receive a TimeOut error, but yet when you check : -the processes at the o/s -the error logs -db sessions there is no evidence that there is an issue. (i.e. all processes running, you get timeouts appearing due to Brie / SLM engine not being able to connect and db sessions are not 'locked' or taking an extensive amount of time to process). It seems that the only way to fix this is to do a restart of the AR Server. I was just wondering if anyone else has experienced anything remotely similar to this? Thanks. George (AR 7.0.1 patch 5 - Sol 10 - Ora 10g2) __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Database cursor sharing
Both systems were set to force in the init.ora file to answer the original question. William Rentfrow Principal Consultant, StrataCom [EMAIL PROTECTED] O 952-432-0227 C 701-306-6157 From: Action Request System discussion list(ARSList) on behalf of Tony Worthington Sent: Wed 4/9/2008 2:09 PM To: arslist@ARSLIST.ORG Subject: Re: Database cursor sharing ** Sorry -- I usually reference my source. :-) Guess I wasn't thinking rtfm... lol White Paper Oracle's Cursor Sharing for BMC® Remedy® Products January 2007 *67831* -- Tony Worthington Sr. Technical Analyst Kohl's Department Stores [EMAIL PROTECTED] 262-703-5911 William Rentfrow [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 04/09/2008 01:50 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Database cursor sharing ** I'm checking this...what document is this from? The server config guide? From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tony Worthington Sent: Wednesday, April 09, 2008 1:24 PM To: arslist@ARSLIST.ORG Subject: Re: Database cursor sharing ** Strange that it would alter to both exact and force when having the system set to force in one operation. Are you seeing the alter sessions right next to each other or are there various inserts in between? Exact is used when inserting into long raw. Have you verified that both of your awr reports are reporting the same values in the init.ora section? I know you mention you've checked a gazillion times ... but it might be in the spfile and not be recognized by the db. We've also had cursor sharing changes not stick over db restarts. init.ora Parameters Parameter NameBegin value End value (if different) - - -- cursor_sharingFORCE Inserts into a Long Raw column while cursor_sharing is enabled can cause the BMC Remedy Action Request System® (AR System®) server thread to hang. Such inserts are commonly done as part of the Email Engine activity when attachments are included in email messages. To avoid any impact from this issue, AR System server code explicitly disables cursor_sharing (that is, sets it to exact) when doing such an insert into a Long Raw column. However, it first needs to know that the current setting is not already exact. To get the current setting, the AR System server looks in the ar.conf file, where the cursor_sharing setting must be set to reflect the init.ora settings from Oracle. If the ar.conf file does not reflect the init.ora settings, then the AR System server assumes the value is already exact and, therefore, will not reset it when doing inserts into Long Raw columns. -- Tony Worthington Sr. Technical Analyst Kohl's Department Stores [EMAIL PROTECTED] 262-703-5911 William Rentfrow [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 04/09/2008 01:15 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Database cursor sharing We have two systems - both on Solaris logical servers, both on the same box. Both have remote Oracle databases. (7.1 001 for Solaris w/Oracle, IM 7.03) Dev = faster response time (saving an Incident takes 9 seconds) QA = very slow response time (saving an Incident takes 65 seconds). These two systems are - as far as we know - identical. However, when debugging the system we have found that the fast (dev) system is executing the following oracle server side parameters during a save: ALTER SESSION set CURSOR_SHARING = EXACT ALTER SESSION set CURSOR_SHARING = FORCE This is NOT happening on the QA server. Both servers have the Oracle-Cursor-Sharing: FORCE parameter set in the ar.conf file and the corresponding appropriate setting is established in Oracle (and we've checked these like 9000 times). Anyone know what setting/config would make Remedy do this to Oracle? William Rentfrow, Principal Consultant [EMAIL PROTECTED] C 701-306-6157 O 952-432-0227 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Open Ticket from AL
Andy, I really wish there was a way to tell what version of the ARS object(s) the User tool/Mid-Tier is using. ( Like even showing the Last Modified Date for the form would be helpful.) I suspect that the reason your first test failed is that the client did not in fact have the most recent version and was instead using a local cached copy of the object that was a previous version of the active link. I hate to say it, but there are times that I really wish, for development purposes, that I could tell the ARS client (User Tool , or Mid-Tier) that it should always to get the objects a fresh and NOT use any local cache. When testing/developing caches are often a blind spot. HTH -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On Wed, Apr 9, 2008 at 6:48 PM, Mayfield, Andy L. [EMAIL PROTECTED] wrote: OK, Maybe I jumped the gun. After testing with admin privileges and having it work, I went back and tried again with the users ID and it worked OK. Not sure what happened on my first test. I will continue to test for a while, but it appears this may have it. For some reason I never see the forest for the trees. Andy L. Mayfield Sr. System Operation Specialist Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 snip -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: Wednesday, April 09, 2008 5:29 PM To: arslist@ARSLIST.ORG Subject: Re: Open Ticket from AL-Resolved I think So you are doing this on a button press after submit? If it is on a Modify you can use $1$ = '1' Fred snip -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mayfield, Andy L. Sent: Wednesday, April 09, 2008 6:05 PM To: arslist@ARSLIST.ORG Subject: Open Ticket from AL How can I have a window open in different view on a button press? I have created an AL that does an open window on the button press, but I am having problems with the qualification for the window to be opened. I want it to open the window and pull up the current transaction, but it will not be the last ID. I thought it might be the CURRENTWIND keyword, but I cant get it to work. Thanks, Andy L. Mayfield Sr. System Operation Specialist Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Licensing Error Message - Production Down
Thanks J.T. and Gary. I am checking with the server team. I did just try to add a new license and I do get a different Host ID. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of J.T. Shyman Sent: Thursday, April 10, 2008 10:00 AM To: arslist@ARSLIST.ORG Subject: Re: Licensing Error Message - Production Down Is the AR Server multihomed? That is, does it have multiple network cards? If so it may have picked up the wrong card and now your server has a different Host ID. You can verify this by going into the add licenses screen and trying to add a new license. Verify the host ID matches the existing licenses. If not, that is your cause. I may have some suggestions from there. --- J.T. Shyman -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Louis Cobuccio Sent: Thursday, April 10, 2008 9:56 AM To: arslist@ARSLIST.ORG Subject: Licensing Error Message - Production Down Importance: High Good Morning All, I hope someone has seen this before or can help me trouble shoot this issue. We lost some network connectivity in our datacenter due a software bug last night and our network team needed applied a code upgrade to the core devices. Once the network crashed we recieved the following entries in the arerror.log, Wed Apr 09 20:12:40 2008 [DBNETLIB][ConnectionRead (recv ()).]General network error. Check your network documentation. (SQL Server 11) Wed Apr 09 20:13:59 2008 390635 : Failure while trying to connect to the SQL database. Please ensure the SQL database is running or contact the Database Administrator for help (ARERR 550) Wed Apr 09 20:13:59 2008 Wed Apr 09 20:13:59 2008 390635 : Cannot initialize contact with SQL database (ARERR 551) Wed Apr 09 20:13:59 2008 Stop server Wed Apr 09 20:13:59 2008 390635 : AR System server terminated -- fatal error encountered (ARNOTE 21) Wed Apr 09 20:14:01 2008 390600 : This version of the Action Request System (R) is ready for use or evaluation without purchasing or activating an authorization key. For unlimited capabilities, contact your sales representative. (ARNOTE 27) We can log into our system but we get licensing error messages when trying to select any of the application consoles, The application is not licensed : BMC:Atrium CMDB (ARERR 9858) The preceding message occurred during the execution of active link CHG:SHR:Set_DatasetName_Default -- action 1. (ARNOTE 1101). I've tried removing the multilicense file but that didn't help. We are running AR applications v 7.0.01 patch 006 in a windows shop, Server 2003 SQL 2005. The application and database are on seporate servers. I've logged a call with BMC support, but it's been an hour and half with no update. Thanks, Lou ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
RES: arserverd 'hangs' (AR 7.0.1 patch 5 - Sol 10 - Ora 10g2)
one question how many records does your AR System Email Messages has??? De: Action Request System discussion list(ARSList) em nome de Roger Medsker Enviada: qui 10/4/2008 11:45 Para: arslist@ARSLIST.ORG Assunto: Re: arserverd 'hangs' (AR 7.0.1 patch 5 - Sol 10 - Ora 10g2) ** George, I have seen this behavior in a situation we had where AR System was actually restarting. There is no indication in any of the logs that the server crashed or was manually stopped. You can detect this by having server side SQL logging on when this occurs. If you see lots of SQL transactions with no identified user associated to them, then the server process is starting up. This doesn't help identify the root cause but the question changes from Why does the server 'hang'? to Why is the server restarting? HTH Roger From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of George Jungle Sent: Thursday, April 10, 2008 2:45 AM To: arslist@ARSLIST.ORG Subject: arserverd 'hangs' (AR 7.0.1 patch 5 - Sol 10 - Ora 10g2) ** Hey guys, We're getting a strange issue (seemingly intermittent) with the arserverd where it just seems to 'hang'. All existing and new clients receive a TimeOut error, but yet when you check : -the processes at the o/s -the error logs -db sessions there is no evidence that there is an issue. (i.e. all processes running, you get timeouts appearing due to Brie / SLM engine not being able to connect and db sessions are not 'locked' or taking an extensive amount of time to process). It seems that the only way to fix this is to do a restart of the AR Server. I was just wondering if anyone else has experienced anything remotely similar to this? Thanks. George (AR 7.0.1 patch 5 - Sol 10 - Ora 10g2) __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: ITSM 7 - Task - Status Reason (Spelt Wrong)
Actually, there are two accepted spellings of the word Cancelled and either Canceled or Cancelled is appropriate. v. can.celed also can.celled, can.cel.ing also can.cel.ling, can.cels also can.cels Scott Parrish IT Prophets, LLC (770) 653-5203 www.itprophets.com -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of T. Dee Sent: Thursday, April 10, 2008 10:44 AM To: arslist@ARSLIST.ORG Subject: OT: ITSM 7 - Task - Status Reason (Spelt Wrong) Not sure if anyone has seen this or reported it to Remedy, but the Status Reason in Task Canceled is spelt wrong - should be Cancelled. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: ITSM 7 - Task - Status Reason (Spelt Wrong)
If I'm not mistaken, both spellings are correct, one is the British version, the other the American English... -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of T. Dee Sent: Thursday, April 10, 2008 8:44 AM To: arslist@ARSLIST.ORG Subject: OT: ITSM 7 - Task - Status Reason (Spelt Wrong) Not sure if anyone has seen this or reported it to Remedy, but the Status Reason in Task Canceled is spelt wrong - should be Cancelled. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: ITSM 7 - Task - Status Reason (Spelt Wrong)
It can be spelled both ways. Canceled is the more American way. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of T. Dee Sent: Thursday, April 10, 2008 10:44 AM To: arslist@ARSLIST.ORG Subject: OT: ITSM 7 - Task - Status Reason (Spelt Wrong) Not sure if anyone has seen this or reported it to Remedy, but the Status Reason in Task Canceled is spelt wrong - should be Cancelled. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are STATEMENT OF CONFIDENTIALITY: The information contained in this message or any attachments to this message are intended only for the person(s) or entity to which it is addressed and may contain confidential and/or privileged material as well as being protected from disclosure. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is strictly prohibited. If you received this in error, please contact us immediately and delete the material from any computer. Thank You. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Replacing test data with live
Here you go: exec sp_changedbowner 'sa' exec sp_dropuser 'ARAdmin' exec sp_changedbowner 'ARAdmin' exec sp_defaultdb 'ARAdmin', 'ARSystem' update field_table set tfServer = '@' update actlink_open set serverName = '@' update char_menu_query set server = '@' update char_menu_sql set server = '@' Roger A. Nall Manager, OSSNMS Remedy T-Mobile, USA Desk: 813-348-2556 Cell: 973-652-6723 FAX: 813-348-2565 sf49fanv AIM IM RogerNall Yahoo IM -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Randy Simon Sent: Thursday, April 10, 2008 8:31 AM To: arslist@ARSLIST.ORG Subject: Re: Replacing test data with live Could you please share those scripts? I am having problems after I updated my DR server from the Prod DB. Embedded server references are not something I thought about. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Nall, Roger Sent: Thursday, April 10, 2008 8:09 AM To: arslist@ARSLIST.ORG Subject: Re: Replacing test data with live We do this often in our systems. The only thing I am aware of that is an issue is server references in the different databases. We have scripts that we execute to replace embedded server references. I might also add that I am in a SQL environment. HTH, Roger A. Nall Manager, OSSNMS Remedy T-Mobile, USA Desk: 813-348-2556 Cell: 973-652-6723 FAX: 813-348-2565 sf49fanv AIM IM RogerNall Yahoo IM -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin Sent: Thursday, April 10, 2008 8:03 AM To: arslist@ARSLIST.ORG Subject: Replacing test data with live Dear List, We have two separate Remedy systems each with its own database, one a test/development system and the other a live/production system. We try to keep them in sync, but don't always succeed. Our dba is suggesting simply replacing the data in the test database with data from the live database. Are there any pitfalls that we should be aware of? (ARS 7.1, RH Linux server, Oracle 10.2 db) Dwayne Martin James Madison University ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are STATEMENT OF CONFIDENTIALITY: The information contained in this message or any attachments to this message are intended only for the person(s) or entity to which it is addressed and may contain confidential and/or privileged material as well as being protected from disclosure. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is strictly prohibited. If you received this in error, please contact us immediately and delete the material from any computer. Thank You. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: ITSM 7 - Task - Status Reason (Spelt Wrong)
Good point. Remedy should pick one spelling and stick with it. Change and Incident has it spelt as Cancelled. Ty On 4/10/08, Scott Parrish [EMAIL PROTECTED] wrote: Actually, there are two accepted spellings of the word Cancelled and either Canceled or Cancelled is appropriate. v. can.celed also can.celled, can.cel.ing also can.cel.ling, can.cels also can.cels Scott Parrish IT Prophets, LLC (770) 653-5203 www.itprophets.com -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of T. Dee Sent: Thursday, April 10, 2008 10:44 AM To: arslist@ARSLIST.ORG Subject: OT: ITSM 7 - Task - Status Reason (Spelt Wrong) Not sure if anyone has seen this or reported it to Remedy, but the Status Reason in Task Canceled is spelt wrong - should be Cancelled. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Form sql view not found, again
Dear List, I am suffering a recurrence of a problem I sent in back in February. I have a form with no sql view. If I change the db name of a field I get “Creation of one of the SQL views for the form failed within the SQL database. Operation completed successfully, but the SQL view is not in place. (ARWARN 69).” The last time the problem turned out to be “ISLONG” character fields, but I ran the same selection statement and found no such fields. In fact, there are no fields 255 chars in the form. If I run an sql log I see: /CREATE VIEW LA_SILab (Request_ID,Submitter,Create_Date,Assigned_To,Last_Modified_By,Modified_Date,Status,Lab_Name,Software_title,Computer _type,What_to_do_,Work_Log,Others_still_In_Progress,Install_number,Valid_Through,Last_modified_by_person_Date,Attachment_Field4,Attachment_Field5,Attachment_F ield6) AS SELECT T426.C1,C2,C3,C4,C5,C6,C7,C8,C536870916,C536870917,C536870918,C536870919,C536870921,C540003300,C56069,C563000663,CO14||';'||CC100 004||';'||C14,CO15||';'||CC15||';'||C15,CO16||';'||CC16||';'||C16 FROM T426, B426 WHERE T426.C1 = B426.C1,T426C536870919 WHERE T426.C1 = T426C536870919.entryId SQL TID: 0023399328 RPC ID: 001601 Queue: Admin Client-RPC: 390600USER: martinrd /* Thu Apr 10 2008 10:41:57.5490 */*** ERROR *** ORA-00933: SQL command not properly ended *** If I run this statement in TOAD I get “ORA-00933: SQL command not properly ended” and it hi-lites the next to last “C1”. The form name is “LA:SILab”. I checked for fields with names the same as Oracle keywords. I have no problem updating other forms. So if all you good people who came to my aid last time would like to try again I will be very glad for your help. (ARS 7.1, RH Linux server, Oracle 10.2 db) Dwayne Martin James Madison University
Re: ITSM 7 - Task - Status Reason (Spelt Wrong)
That's always bugged me, as has the following: Canceled vs. Cancelled Requestor vs. Requester Implementor vs. Implementer (I see that Implementor isn't a word, but, then, why is Requestor? To me, the -or sounds correct). I favor the Cancelled myself, and I'm not British. I've always favored Favour, Colour, Armour also, but maybe I'm just different... Thanks, Gary Opela, Jr., RSP Remedy Engineer Leader Communications, Inc. Best Product, Best People, Best PriceTM An ISO 9001:2000 Certified, CMMI® Level 3 Rated Company -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of T. Dee Sent: Thursday, April 10, 2008 10:16 AM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7 - Task - Status Reason (Spelt Wrong) Good point. Remedy should pick one spelling and stick with it. Change and Incident has it spelt as Cancelled. Ty On 4/10/08, Scott Parrish [EMAIL PROTECTED] wrote: Actually, there are two accepted spellings of the word Cancelled and either Canceled or Cancelled is appropriate. v. can.celed also can.celled, can.cel.ing also can.cel.ling, can.cels also can.cels Scott Parrish IT Prophets, LLC (770) 653-5203 www.itprophets.com -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of T. Dee Sent: Thursday, April 10, 2008 10:44 AM To: arslist@ARSLIST.ORG Subject: OT: ITSM 7 - Task - Status Reason (Spelt Wrong) Not sure if anyone has seen this or reported it to Remedy, but the Status Reason in Task Canceled is spelt wrong - should be Cancelled. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Licensing Error Message - Production Down
J.T. Gary, I guess our server team enabled NIC Teaming. Once this was disabled we restarted the services and the system came back clean. Thank you both very much! I owe you both a drink if you are ever up in Boston! Lou -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of J.T. Shyman Sent: Thursday, April 10, 2008 10:00 AM To: arslist@ARSLIST.ORG Subject: Re: Licensing Error Message - Production Down Is the AR Server multihomed? That is, does it have multiple network cards? If so it may have picked up the wrong card and now your server has a different Host ID. You can verify this by going into the add licenses screen and trying to add a new license. Verify the host ID matches the existing licenses. If not, that is your cause. I may have some suggestions from there. --- J.T. Shyman -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Louis Cobuccio Sent: Thursday, April 10, 2008 9:56 AM To: arslist@ARSLIST.ORG Subject: Licensing Error Message - Production Down Importance: High Good Morning All, I hope someone has seen this before or can help me trouble shoot this issue. We lost some network connectivity in our datacenter due a software bug last night and our network team needed applied a code upgrade to the core devices. Once the network crashed we recieved the following entries in the arerror.log, Wed Apr 09 20:12:40 2008 [DBNETLIB][ConnectionRead (recv ()).]General network error. Check your network documentation. (SQL Server 11) Wed Apr 09 20:13:59 2008 390635 : Failure while trying to connect to the SQL database. Please ensure the SQL database is running or contact the Database Administrator for help (ARERR 550) Wed Apr 09 20:13:59 2008 Wed Apr 09 20:13:59 2008 390635 : Cannot initialize contact with SQL database (ARERR 551) Wed Apr 09 20:13:59 2008 Stop server Wed Apr 09 20:13:59 2008 390635 : AR System server terminated -- fatal error encountered (ARNOTE 21) Wed Apr 09 20:14:01 2008 390600 : This version of the Action Request System (R) is ready for use or evaluation without purchasing or activating an authorization key. For unlimited capabilities, contact your sales representative. (ARNOTE 27) We can log into our system but we get licensing error messages when trying to select any of the application consoles, The application is not licensed : BMC:Atrium CMDB (ARERR 9858) The preceding message occurred during the execution of active link CHG:SHR:Set_DatasetName_Default -- action 1. (ARNOTE 1101). I've tried removing the multilicense file but that didn't help. We are running AR applications v 7.0.01 patch 006 in a windows shop, Server 2003 SQL 2005. The application and database are on seporate servers. I've logged a call with BMC support, but it's been an hour and half with no update. Thanks, Lou ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Replacing test data with live
That isn't complete enough for ITSM 7.0 though. There are some tables (I don't have a complete list off the top of my head) that contain server references too. For example, one is the CAI Application Registry form which has the server name for each app installed. What I've done is develop a script to do a search and replace across my entire database, excluding tables like HPD_Help_Desk, CHG_Infrastructure_Change and BMC_Core_BaseElement so I don't mess up any real data. Shawn Pierson -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Nall, Roger Sent: Thursday, April 10, 2008 10:15 AM To: arslist@ARSLIST.ORG Subject: Re: Replacing test data with live Here you go: exec sp_changedbowner 'sa' exec sp_dropuser 'ARAdmin' exec sp_changedbowner 'ARAdmin' exec sp_defaultdb 'ARAdmin', 'ARSystem' update field_table set tfServer = '@' update actlink_open set serverName = '@' update char_menu_query set server = '@' update char_menu_sql set server = '@' Roger A. Nall Manager, OSSNMS Remedy T-Mobile, USA Desk: 813-348-2556 Cell: 973-652-6723 FAX: 813-348-2565 sf49fanv AIM IM RogerNall Yahoo IM -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Randy Simon Sent: Thursday, April 10, 2008 8:31 AM To: arslist@ARSLIST.ORG Subject: Re: Replacing test data with live Could you please share those scripts? I am having problems after I updated my DR server from the Prod DB. Embedded server references are not something I thought about. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Nall, Roger Sent: Thursday, April 10, 2008 8:09 AM To: arslist@ARSLIST.ORG Subject: Re: Replacing test data with live We do this often in our systems. The only thing I am aware of that is an issue is server references in the different databases. We have scripts that we execute to replace embedded server references. I might also add that I am in a SQL environment. HTH, Roger A. Nall Manager, OSSNMS Remedy T-Mobile, USA Desk: 813-348-2556 Cell: 973-652-6723 FAX: 813-348-2565 sf49fanv AIM IM RogerNall Yahoo IM -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin Sent: Thursday, April 10, 2008 8:03 AM To: arslist@ARSLIST.ORG Subject: Replacing test data with live Dear List, We have two separate Remedy systems each with its own database, one a test/development system and the other a live/production system. We try to keep them in sync, but don't always succeed. Our dba is suggesting simply replacing the data in the test database with data from the live database. Are there any pitfalls that we should be aware of? (ARS 7.1, RH Linux server, Oracle 10.2 db) Dwayne Martin James Madison University ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are STATEMENT OF CONFIDENTIALITY: The information contained in this message or any attachments to this message are intended only for the person(s) or entity to which it is addressed and may contain confidential and/or privileged material as well as being protected from disclosure. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is strictly prohibited. If you received this in error, please contact us immediately and delete the material from any computer. Thank You. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are Private and confidential as detailed here: http://www.sug.com/disclaimers/default.htm#Mail . If you cannot access the link, please e-mail sender. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Error log display question....
We're new to installing the ITSM software and notice that there are a ton of log files that are created. Is there any type of utility - other than notepad - that can make reading the logs easier or a little more meaningful rather than having to wade through crowded files for that gem of information in case of an error condition? Thanks. Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
DSL Import
Listers, When we did our application installs we didn't want, and didn't think we'd need the DSL. But now we've changed our minds and would like to install it. According to the ITSM install guide, if you uncheck it during the app installs, it still installs the workflow, just not the data. With that in mind, if we follow the steps in the ITSM Config guide for importing vendor data, will that give us what we need? If not, is there a way to install the DSL without reinstalling one of the apps? ARS 7.1 ITSM 7.0.3 SQL Server 2005 Thanks! Brian ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: ITSM 7 - Task - Status Reason (Spelt Wrong)
pun Different? Oh, you are. /pun :) --- J.T. Shyman -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Gary Opela (Corporate) Sent: Thursday, April 10, 2008 11:24 AM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7 - Task - Status Reason (Spelt Wrong) That's always bugged me, as has the following: Canceled vs. Cancelled Requestor vs. Requester Implementor vs. Implementer (I see that Implementor isn't a word, but, then, why is Requestor? To me, the -or sounds correct). I favor the Cancelled myself, and I'm not British. I've always favored Favour, Colour, Armour also, but maybe I'm just different... Thanks, Gary Opela, Jr., RSP Remedy Engineer Leader Communications, Inc. Best Product, Best People, Best PriceTM An ISO 9001:2000 Certified, CMMI® Level 3 Rated Company -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of T. Dee Sent: Thursday, April 10, 2008 10:16 AM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7 - Task - Status Reason (Spelt Wrong) Good point. Remedy should pick one spelling and stick with it. Change and Incident has it spelt as Cancelled. Ty On 4/10/08, Scott Parrish [EMAIL PROTECTED] wrote: Actually, there are two accepted spellings of the word Cancelled and either Canceled or Cancelled is appropriate. v. can.celed also can.celled, can.cel.ing also can.cel.ling, can.cels also can.cels Scott Parrish IT Prophets, LLC (770) 653-5203 www.itprophets.com -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of T. Dee Sent: Thursday, April 10, 2008 10:44 AM To: arslist@ARSLIST.ORG Subject: OT: ITSM 7 - Task - Status Reason (Spelt Wrong) Not sure if anyone has seen this or reported it to Remedy, but the Status Reason in Task Canceled is spelt wrong - should be Cancelled. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: ITSM 7 - Task - Status Reason (Spelt Wrong)
:-) On 4/10/08, J.T. Shyman [EMAIL PROTECTED] wrote: pun Different? Oh, you are. /pun :) --- J.T. Shyman -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Gary Opela (Corporate) Sent: Thursday, April 10, 2008 11:24 AM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7 - Task - Status Reason (Spelt Wrong) That's always bugged me, as has the following: Canceled vs. Cancelled Requestor vs. Requester Implementor vs. Implementer (I see that Implementor isn't a word, but, then, why is Requestor? To me, the -or sounds correct). I favor the Cancelled myself, and I'm not British. I've always favored Favour, Colour, Armour also, but maybe I'm just different... Thanks, Gary Opela, Jr., RSP Remedy Engineer Leader Communications, Inc. Best Product, Best People, Best PriceTM An ISO 9001:2000 Certified, CMMI(R) Level 3 Rated Company -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of T. Dee Sent: Thursday, April 10, 2008 10:16 AM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7 - Task - Status Reason (Spelt Wrong) Good point. Remedy should pick one spelling and stick with it. Change and Incident has it spelt as Cancelled. Ty On 4/10/08, Scott Parrish [EMAIL PROTECTED] wrote: Actually, there are two accepted spellings of the word Cancelled and either Canceled or Cancelled is appropriate. v. can.celed also can.celled, can.cel.ing also can.cel.ling, can.cels also can.cels Scott Parrish IT Prophets, LLC (770) 653-5203 www.itprophets.com -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of T. Dee Sent: Thursday, April 10, 2008 10:44 AM To: arslist@ARSLIST.ORG Subject: OT: ITSM 7 - Task - Status Reason (Spelt Wrong) Not sure if anyone has seen this or reported it to Remedy, but the Status Reason in Task Canceled is spelt wrong - should be Cancelled. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Error log display question....
Each application install has a logs folder that has HTML output. Ex: C:\Program Files\AR System Applications\server\BMC Atrium CMDB\Logs\BMCAtriumCMDB.html They are pretty easy to read. HTH, Brian From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Richard Copits Sent: Thursday, April 10, 2008 8:33 AM To: arslist@ARSLIST.ORG Subject: Error log display question ** We're new to installing the ITSM software and notice that there are a ton of log files that are created. Is there any type of utility - other than notepad - that can make reading the logs easier or a little more meaningful rather than having to wade through crowded files for that gem of information in case of an error condition? Thanks. Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Connecting to Remedy Server Throught Java API
Hi List, I am trying to connect to the Remedy Server through Java API. I get an Error 90 Saying RPC Bind Failure.Authentication Error. Can any one let me know what is the reason for this error? I tried checking the login Id it works fine. Please help. Sriram ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Connecting to Remedy Server Throught Java API
What does your connection string look like? _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of sriram pm Sent: Thursday, April 10, 2008 10:19 AM To: arslist@ARSLIST.ORG Subject: Connecting to Remedy Server Throught Java API ** Hi List, I am trying to connect to the Remedy Server through Java API. I get an Error 90 Saying RPC Bind Failure.Authentication Error. Can any one let me know what is the reason for this error? I tried checking the login Id it works fine. Please help. Sriram __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Connecting to Remedy Server Throught Java API
Below the the connection string... ARSystemUser(Login id, Password,English,Server Name,int port) On Fri, Apr 11, 2008 at 12:24 AM, LJ Longwing [EMAIL PROTECTED] wrote: ** What does your connection string look like? -- *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *sriram pm *Sent:* Thursday, April 10, 2008 10:19 AM *To:* arslist@ARSLIST.ORG *Subject:* Connecting to Remedy Server Throught Java API ** Hi List, I am trying to connect to the Remedy Server through Java API. I get an Error 90 Saying RPC Bind Failure.Authentication Error. Can any one let me know what is the reason for this error? I tried checking the login Id it works fine. Please help. Sriram __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Form sql view not found, again SOLVED AGAIN
Once again, Doug Mueller came thru with the answer. It was a variation on the previous problem, only this time it was a Diary field instead of a Character. When I did: select fieldId, isLong from field_diary where schemaId = 426 I got: FIELDID: 536870919, ISLONG: 1. Fortunately, we no longer use this field and so we can delete it. I asked Doug what somebody should do if they still needed the field and he said he didn't know, but support would. Thanks, Doug! Dwayne ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ---BeginMessage--- Dear List, I am suffering a recurrence of a problem I sent in back in February. I have a form with no sql view. If I change the db name of a field I get “Creation of one of the SQL views for the form failed within the SQL database. Operation completed successfully, but the SQL view is not in place. (ARWARN 69).” The last time the problem turned out to be “ISLONG” character fields, but I ran the same selection statement and found no such fields. In fact, there are no fields 255 chars in the form. If I run an sql log I see: /CREATE VIEW LA_SILab (Request_ID,Submitter,Create_Date,Assigned_To,Last_Modified_By,Modified_Date,Status,Lab_Name,Software_title,Computer _type,What_to_do_,Work_Log,Others_still_In_Progress,Install_number,Valid_Through,Last_modified_by_person_Date,Attachment_Field4,Attachment_Field5,Attachment_F ield6) AS SELECT T426.C1,C2,C3,C4,C5,C6,C7,C8,C536870916,C536870917,C536870918,C536870919,C536870921,C540003300,C56069,C563000663,CO14||';'||CC100 004||';'||C14,CO15||';'||CC15||';'||C15,CO16||';'||CC16||';'||C16 FROM T426, B426 WHERE T426.C1 = B426.C1,T426C536870919 WHERE T426.C1 = T426C536870919.entryId SQL TID: 0023399328 RPC ID: 001601 Queue: Admin Client-RPC: 390600USER: martinrd /* Thu Apr 10 2008 10:41:57.5490 */*** ERROR *** ORA-00933: SQL command not properly ended *** If I run this statement in TOAD I get “ORA-00933: SQL command not properly ended” and it hi-lites the next to last “C1”. The form name is “LA:SILab”. I checked for fields with names the same as Oracle keywords. I have no problem updating other forms. So if all you good people who came to my aid last time would like to try again I will be very glad for your help. (ARS 7.1, RH Linux server, Oracle 10.2 db) Dwayne Martin James Madison University ---End Message---
Re: How can I have ARS Remedy 6.3 Demo?
You can request a 6.3 trial license through the website. However, since 6.3 is nearing the end of its support lifecycle, I would recommend that you evaluate AR System 7.1.00 instead - especially if you're evaluating this for future projects. You will need a Support ID to download the software and obtain a license. You can contact your local BMC sales representative to get a temporary Support ID if you do not already have one. Also note that AR System will operate without a license key - but you will be limited to 3 fixed users and 2000 records per form. -David J. Easter Sr. Product Manager, Service Management Business Unit 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:[EMAIL PROTECTED] On Behalf Of Shellman, David Sent: Thursday, April 10, 2008 4:48 AM To: arslist@ARSLIST.ORG Subject: Re: How can I have ARS Remedy 6.3 Demo? You can download the software and get temp licenses from the support web site. The request for temp licenses may only be good for 7.x though. Dave - [EMAIL PROTECTED] (Wireless) - Original Message - From: Action Request System discussion list(ARSList) ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Connecting to Remedy Server Throught Java API
Is your server localized to English? If not you may want to include a blank string instead of English, see if that helps _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of sriram pm Sent: Thursday, April 10, 2008 10:38 AM To: arslist@ARSLIST.ORG Subject: Re: Connecting to Remedy Server Throught Java API ** Below the the connection string... ARSystemUser(Login id, Password,English,Server Name,int port) On Fri, Apr 11, 2008 at 12:24 AM, LJ Longwing [EMAIL PROTECTED] wrote: ** What does your connection string look like? _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of sriram pm Sent: Thursday, April 10, 2008 10:19 AM To: arslist@ARSLIST.ORG Subject: Connecting to Remedy Server Throught Java API ** Hi List, I am trying to connect to the Remedy Server through Java API. I get an Error 90 Saying RPC Bind Failure.Authentication Error. Can any one let me know what is the reason for this error? I tried checking the login Id it works fine. Please help. Sriram __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
ARDBC Plugin crashing ARPLugin service after first search
Hi!, We have a Vendor form from where if a login other than aradmin is used, the second search on that form crashes the ARPLugin service. This is bizarre:confused:. Has anyone come across this kind of a problem? aradmin is the User for the ARS installation. Any pointers? Please help. Thanks, AJ -- View this message in context: http://www.nabble.com/ARDBC-Plugin-crashing-ARPLugin-service-after-first-search-tp16610496p16610496.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
ARDBC PLugin crashes ARPlugin service
Hi!, We have a Vendor form from where if a login is used which is other than the user that the ARS Installation runs on, the second search on that form crashes the ARPLugin service. This is bizarre. Has anyone come across this kind of a problem? Any pointers? Please help. Thanks, AJ -- View this message in context: http://www.nabble.com/ARDBC-PLugin-crashes-ARPlugin-service-tp16610712p16610712.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
ARDBC Plugin crashes AR Plugin service
Hi!, We have a Vendor form from where if a login is used which is other than the user that the ARS Installation runs on, the second search on that form crashes the ARPLugin service. This is bizarre. Has anyone come across this kind of a problem? Any pointers? Please help. Thanks, AJ -- View this message in context: http://www.nabble.com/ARDBC-Plugin-crashes-AR-Plugin-service-tp16610723p16610723.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: ARDBC Plugin crashes AR Plugin service
What platform are you using? Axton On Thu, Apr 10, 2008 at 1:46 PM, arthurj [EMAIL PROTECTED] wrote: Hi!, We have a Vendor form from where if a login is used which is other than the user that the ARS Installation runs on, the second search on that form crashes the ARPLugin service. This is bizarre. Has anyone come across this kind of a problem? Any pointers? Please help. Thanks, AJ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: ARDBC Plugin crashes AR Plugin service
ARS6.3 p 23 on Solaris 10 with users using User 5.1.2 Thanks, Arthur On 4/10/08, Axton [EMAIL PROTECTED] wrote: What platform are you using? Axton On Thu, Apr 10, 2008 at 1:46 PM, arthurj [EMAIL PROTECTED] wrote: Hi!, We have a Vendor form from where if a login is used which is other than the user that the ARS Installation runs on, the second search on that form crashes the ARPLugin service. This is bizarre. Has anyone come across this kind of a problem? Any pointers? Please help. Thanks, AJ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: ARDBC Plugin crashes AR Plugin service
My question exactly... I have seen this on RH Linux with ARS 6.3 (earlier patches, say p3-11 or so). We were doing LDAP searches against AD. I found that it help using the global catalog. Just put the port number (3268) in your Vendor Form table name field. Unfortunately the CG did not return all of the attributes we were looking for. Here is a link for info on the AD Global Catalog. http://www.microsoft.com/technet/prodtechnol/windows2000serv/reskit/distrib/dsbc_nar_bsad.mspx?mfr=true Jason On Thu, Apr 10, 2008 at 10:56 AM, Axton [EMAIL PROTECTED] wrote: What platform are you using? Axton On Thu, Apr 10, 2008 at 1:46 PM, arthurj [EMAIL PROTECTED] wrote: Hi!, We have a Vendor form from where if a login is used which is other than the user that the ARS Installation runs on, the second search on that form crashes the ARPLugin service. This is bizarre. Has anyone come across this kind of a problem? Any pointers? Please help. Thanks, AJ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: ARDBC Plugin crashes AR Plugin service
Generate a core file and see what the stack is when it crashes or attach a debugger to the arplugin process and catch the signal (11, I'm assuming). Do you have the source for the plugin? If you have the source, you will actually be able to fix the problem. man dbx read on the following dbx commands: check -leaks check -memuse check -access Axton Grams On Thu, Apr 10, 2008 at 2:05 PM, Arthur Johnson [EMAIL PROTECTED] wrote: ** ARS6.3 p 23 on Solaris 10 with users using User 5.1.2 Thanks, Arthur On 4/10/08, Axton [EMAIL PROTECTED] wrote: What platform are you using? Axton On Thu, Apr 10, 2008 at 1:46 PM, arthurj [EMAIL PROTECTED] wrote: Hi!, We have a Vendor form from where if a login is used which is other than the user that the ARS Installation runs on, the second search on that form crashes the ARPLugin service. This is bizarre. Has anyone come across this kind of a problem? Any pointers? Please help. Thanks, AJ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: ITSM 7 - Task - Status Reason (Spelt Wrong)
It is time to trash our whole spelling system and start over from scratch, with each letter representing one phoneme. (Excuse me for using the ARSList to push one of my many totally hopeless causes.) Dwayne Martin James Madison University Original message Date: Thu, 10 Apr 2008 10:23:31 -0500 From: Gary Opela (Corporate) [EMAIL PROTECTED] Subject: Re: ITSM 7 - Task - Status Reason (Spelt Wrong) To: arslist@ARSLIST.ORG That's always bugged me, as has the following: Canceled vs. Cancelled Requestor vs. Requester Implementor vs. Implementer (I see that Implementor isn't a word, but, then, why is Requestor? To me, the -or sounds correct). I favor the Cancelled myself, and I'm not British. I've always favored Favour, Colour, Armour also, but maybe I'm just different... Thanks, Gary Opela, Jr., RSP Remedy Engineer Leader Communications, Inc. Best Product, Best People, Best PriceTM An ISO 9001:2000 Certified, CMMI® Level 3 Rated Company -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of T. Dee Sent: Thursday, April 10, 2008 10:16 AM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7 - Task - Status Reason (Spelt Wrong) Good point. Remedy should pick one spelling and stick with it. Change and Incident has it spelt as Cancelled. Ty On 4/10/08, Scott Parrish [EMAIL PROTECTED] wrote: Actually, there are two accepted spellings of the word Cancelled and either Canceled or Cancelled is appropriate. v. can.celed also can.celled, can.cel.ing also can.cel.ling, can.cels also can.cels Scott Parrish IT Prophets, LLC (770) 653-5203 www.itprophets.com -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of T. Dee Sent: Thursday, April 10, 2008 10:44 AM To: arslist@ARSLIST.ORG Subject: OT: ITSM 7 - Task - Status Reason (Spelt Wrong) Not sure if anyone has seen this or reported it to Remedy, but the Status Reason in Task Canceled is spelt wrong - should be Cancelled. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
OT:RE: ITSM 7 - Task - Status Reason (Spelt Wrong)
If this plan ever comes to fruition you can expect the teenagers of the day to immediately destroy it. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin Sent: Thursday, April 10, 2008 1:18 PM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7 - Task - Status Reason (Spelt Wrong) It is time to trash our whole spelling system and start over from scratch, with each letter representing one phoneme. (Excuse me for using the ARSList to push one of my many totally hopeless causes.) Dwayne Martin James Madison University Original message Date: Thu, 10 Apr 2008 10:23:31 -0500 From: Gary Opela (Corporate) [EMAIL PROTECTED] Subject: Re: ITSM 7 - Task - Status Reason (Spelt Wrong) To: arslist@ARSLIST.ORG That's always bugged me, as has the following: Canceled vs. Cancelled Requestor vs. Requester Implementor vs. Implementer (I see that Implementor isn't a word, but, then, why is Requestor? To me, the -or sounds correct). I favor the Cancelled myself, and I'm not British. I've always favored Favour, Colour, Armour also, but maybe I'm just different... Thanks, Gary Opela, Jr., RSP Remedy Engineer Leader Communications, Inc. Best Product, Best People, Best PriceTM An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of T. Dee Sent: Thursday, April 10, 2008 10:16 AM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7 - Task - Status Reason (Spelt Wrong) Good point. Remedy should pick one spelling and stick with it. Change and Incident has it spelt as Cancelled. Ty On 4/10/08, Scott Parrish [EMAIL PROTECTED] wrote: Actually, there are two accepted spellings of the word Cancelled and either Canceled or Cancelled is appropriate. v. can.celed also can.celled, can.cel.ing also can.cel.ling, can.cels also can.cels Scott Parrish IT Prophets, LLC (770) 653-5203 www.itprophets.com -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of T. Dee Sent: Thursday, April 10, 2008 10:44 AM To: arslist@ARSLIST.ORG Subject: OT: ITSM 7 - Task - Status Reason (Spelt Wrong) Not sure if anyone has seen this or reported it to Remedy, but the Status Reason in Task Canceled is spelt wrong - should be Cancelled. _ ___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are _ __ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: DSL Import
You can run any of the DSL DATA patches (don't even THINK of running any of the DSL application patches) and they will load the latest data set into your staging forms. Then you can import the data one set at a time from the DSL import console (PDL:ESIDImportConsole). The DSL DATA Patch 005 contains the latest data - version 110.7.0.1. This is the exact same process as an upgrade of the data set - I updated the data in my staging forms before ever importing it into the live application. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Brian Gillock Sent: Thursday, April 10, 2008 10:26 AM To: arslist@ARSLIST.ORG Subject: DSL Import ** Listers, When we did our application installs we didn't want, and didn't think we'd need the DSL. But now we've changed our minds and would like to install it. According to the ITSM install guide, if you uncheck it during the app installs, it still installs the workflow, just not the data. With that in mind, if we follow the steps in the ITSM Config guide for importing vendor data, will that give us what we need? If not, is there a way to install the DSL without reinstalling one of the apps? ARS 7.1 ITSM 7.0.3 SQL Server 2005 Thanks! Brian __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
RESOLVED: Mid-Tier help
Update: I got it working by doing the following: Uninstall MT, Uninstall Tomcat. Download tomcat 5.5. from apache.org. Install tomcat 5.5 manually Install mid-tier (without tomcat) Reboot Works like a charm. Something about remedy installing tomcat wasn't working. Thanks so much to all who helped! Thanks, Gary Opela, Jr., RSP Remedy Engineer Leader Communications, Inc. Best Product, Best People, Best PriceTM An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of J.T. Shyman Sent: Tuesday, April 08, 2008 5:05 PM To: arslist@ARSLIST.ORG Subject: Re: Mid-Tier help ** Sorry we couldn't find an answer for you. Please do let us all know what the final solution is. You've got me curious now. J --- J.T. Shyman From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Gary Opela (Corporate) Sent: Tuesday, April 08, 2008 5:46 PM To: arslist@ARSLIST.ORG Subject: Re: Mid-Tier help Yeah, I did that, it still doesn't work. I have support engaged now, I've used enough of you guys' time. Thanks a ton for all of your help! Thanks, Gary Opela, Jr., RSP Remedy Engineer Leader Communications, Inc. Best Product, Best People, Best PriceTM An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of J.T. Shyman Sent: Tuesday, April 08, 2008 4:27 PM To: arslist@ARSLIST.ORG Subject: Re: Mid-Tier help ** Now that you have the right version of Java it might make sense to reinstall the mid-tier --- J.T. Shyman From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Gary Opela (Corporate) Sent: Tuesday, April 08, 2008 4:20 PM To: arslist@ARSLIST.ORG Subject: Re: Mid-Tier help Yeah, thanks a lot J I saw in my Mid-Tier log files the following line if it helps anyone: Apr 8, 2008 3:13:42 PM - SEVERE (com.remedy.log) : BMC Remedy Mid Tier version 7.1.00 Build 200708221849 Apr 8, 2008 3:13:45 PM - WARNING (com.remedy.log.SERVLET) : No File Entries were found in server - server Thanks, Gary Opela, Jr., RSP Remedy Engineer Leader Communications, Inc. Best Product, Best People, Best PriceTM An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company =__ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: ARDBC Plugin crashes AR Plugin service
From the plugin logs I was able to pinpoint the error. I am using libxml2 to parse the xml to send to the external service and also to parse the response from the external service and expose as rows in ARS. I have attached the code which is in question. When the second search is done the logs show - After len - 769 and after that the crash occurs since I don't see After doc. So the line 44 in the attached file is where the problem is. Arthur On 4/10/08, Axton [EMAIL PROTECTED] wrote: Generate a core file and see what the stack is when it crashes or attach a debugger to the arplugin process and catch the signal (11, I'm assuming). Do you have the source for the plugin? If you have the source, you will actually be able to fix the problem. man dbx read on the following dbx commands: check -leaks check -memuse check -access Axton Grams On Thu, Apr 10, 2008 at 2:05 PM, Arthur Johnson [EMAIL PROTECTED] wrote: ** ARS6.3 p 23 on Solaris 10 with users using User 5.1.2 Thanks, Arthur On 4/10/08, Axton [EMAIL PROTECTED] wrote: What platform are you using? Axton On Thu, Apr 10, 2008 at 1:46 PM, arthurj [EMAIL PROTECTED] wrote: Hi!, We have a Vendor form from where if a login is used which is other than the user that the ARS Installation runs on, the second search on that form crashes the ARPLugin service. This is bizarre. Has anyone come across this kind of a problem? Any pointers? Please help. Thanks, AJ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are //Allocate mem for valueOperandPtr-u.value.u.charVal - //which holds an XML string to be sent out to the external service sdiRequest=(char *)malloc(strlen(valueOperandPtr-u.value.u.charVal)+1); /* NOTE : Had to add in front of the XML value sent in from the form as the value of the search since Remedy strips the leading . Most likely thinking it was an operator*/ sprintf(sdiRequest,%s,valueOperandPtr-u.value.u.charVal); len=strlen(sdiRequest); sdiRequestDoc = xmlReadMemory(sdiRequest, len, noname0.xml, NULL, 0); if (doc == NULL) { free(sdiRequest); return AddErrorMessage(status, AR_RETURN_ERROR, PLUGIN_ERROR_GENERIC, Request sent in is not a well formed XML); } Request(); iInitRun=0; sdiRequest=talker(sdiRequest); Release(); ARPluginLogging(AR_PLUGIN_LOG_INFO, Eval); if (sdiRequest == NULL) { free(sdiRequest); return AddErrorMessage(status, AR_RETURN_ERROR, PLUGIN_ERROR_GENERIC, No Output from SDI); } /* * The document being in memory, it has no base per RFC 2396, * and the argument - noname.xml will serve as its base. */ len = strlen(sdiRequest); xmlFreeDoc(sdiRequestDoc); ARPluginLogging(AR_PLUGIN_LOG_INFO, After len - %d\n,len); doc = xmlReadMemory(sdiRequest, len, noname1.xml, NULL, 0); ARPluginLogging(AR_PLUGIN_LOG_INFO, After doc\n);
Re: ARDBC Plugin crashes AR Plugin service
Best bet is to hook a debugger up to it. The checks dbx provides will tell you what the program is doing that it shouldn't be doing. Axton Grams On Thu, Apr 10, 2008 at 3:09 PM, Arthur Johnson [EMAIL PROTECTED] wrote: ** From the plugin logs I was able to pinpoint the error. I am using libxml2 to parse the xml to send to the external service and also to parse the response from the external service and expose as rows in ARS. I have attached the code which is in question. When the second search is done the logs show - After len - 769 and after that the crash occurs since I don't see After doc. So the line 44 in the attached file is where the problem is. Arthur On 4/10/08, Axton [EMAIL PROTECTED] wrote: Generate a core file and see what the stack is when it crashes or attach a debugger to the arplugin process and catch the signal (11, I'm assuming). Do you have the source for the plugin? If you have the source, you will actually be able to fix the problem. man dbx read on the following dbx commands: check -leaks check -memuse check -access Axton Grams On Thu, Apr 10, 2008 at 2:05 PM, Arthur Johnson [EMAIL PROTECTED] wrote: ** ARS6.3 p 23 on Solaris 10 with users using User 5.1.2 Thanks, Arthur On 4/10/08, Axton [EMAIL PROTECTED] wrote: What platform are you using? Axton On Thu, Apr 10, 2008 at 1:46 PM, arthurj [EMAIL PROTECTED] wrote: Hi!, We have a Vendor form from where if a login is used which is other than the user that the ARS Installation runs on, the second search on that form crashes the ARPLugin service. This is bizarre. Has anyone come across this kind of a problem? Any pointers? Please help. Thanks, AJ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: ITSM 7 - Task - Status Reason (Spelt Wrong)
I thought by now some joker would have said, Spelt is spelled wrong. --Tim - Original Message From: Thad K Esser [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Thursday, April 10, 2008 2:34:06 PM Subject: Re: [ARSLIST] ITSM 7 - Task - Status Reason (Spelt Wrong) ** u may B ryt. I tnk w'v a gud *t W txt msgN. (You may be right. I think we have a good start with text messaging.) http://www.lingo2word.com/translate.php Is it Friday yet? Thad Esser Remedy Developer Argue for your limitations, and sure enough, they're yours.-- Richard Bach Dwayne Martin [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 04/10/2008 11:18 AMPlease respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: ITSM 7 - Task - Status Reason (Spelt Wrong) It is time to trash our whole spelling system and start over from scratch, with each letter representing one phoneme. (Excuse me for using the ARSList to push one of my many totally hopeless causes.) Dwayne Martin James Madison University Original message Date: Thu, 10 Apr 2008 10:23:31 -0500 From: Gary Opela (Corporate) [EMAIL PROTECTED] Subject: Re: ITSM 7 - Task - Status Reason (Spelt Wrong) To: arslist@ARSLIST.ORG That's always bugged me, as has the following: Canceled vs. Cancelled Requestor vs. Requester Implementor vs. Implementer (I see that Implementor isn't a word, but, then, why is Requestor? To me, the -or sounds correct). I favor the Cancelled myself, and I'm not British. I've always favored Favour, Colour, Armour also, but maybe I'm just different... Thanks, Gary Opela, Jr., RSP Remedy Engineer Leader Communications, Inc. Best Product, Best People, Best PriceTM An ISO 9001:2000 Certified, CMMI® Level 3 Rated Company -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of T. Dee Sent: Thursday, April 10, 2008 10:16 AM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7 - Task - Status Reason (Spelt Wrong) Good point. Remedy should pick one spelling and stick with it. Change and Incident has it spelt as Cancelled. Ty On 4/10/08, Scott Parrish [EMAIL PROTECTED] wrote: Actually, there are two accepted spellings of the word Cancelled and either Canceled or Cancelled is appropriate. v. can.celed also can.celled, can.cel.ing also can.cel.ling, can.cels also can.cels Scott Parrish IT Prophets, LLC (770) 653-5203 www.itprophets.com -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of T. Dee Sent: Thursday, April 10, 2008 10:44 AM To: arslist@ARSLIST.ORG Subject: OT: ITSM 7 - Task - Status Reason (Spelt Wrong) Not sure if anyone has seen this or reported it to Remedy, but the Status Reason in Task Canceled is spelt wrong - should be Cancelled. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ***IMPORTANT NOTICE: This communication, including any attachment, contains information that may be confidential or privileged, and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message is strictly prohibited. Nothing in this email, including any attachment, is intended to be a legally binding signature.*** __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: ITSM 7 - Task - Status Reason (Spelt Wrong)
Not in Kanada -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tim Widowfield Sent: Thursday, April 10, 2008 12:49 PM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7 - Task - Status Reason (Spelt Wrong) I thought by now some joker would have said, Spelt is spelled wrong. --Tim - Original Message From: Thad K Esser [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Thursday, April 10, 2008 2:34:06 PM Subject: Re: [ARSLIST] ITSM 7 - Task - Status Reason (Spelt Wrong) ** u may B ryt. I tnk w'v a gud *t W txt msgN. (You may be right. I think we have a good start with text messaging.) http://www.lingo2word.com/translate.php Is it Friday yet? Thad Esser Remedy Developer Argue for your limitations, and sure enough, they're yours.-- Richard Bach Dwayne Martin [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 04/10/2008 11:18 AMPlease respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: ITSM 7 - Task - Status Reason (Spelt Wrong) It is time to trash our whole spelling system and start over from scratch, with each letter representing one phoneme. (Excuse me for using the ARSList to push one of my many totally hopeless causes.) Dwayne Martin James Madison University Original message Date: Thu, 10 Apr 2008 10:23:31 -0500 From: Gary Opela (Corporate) [EMAIL PROTECTED] Subject: Re: ITSM 7 - Task - Status Reason (Spelt Wrong) To: arslist@ARSLIST.ORG That's always bugged me, as has the following: Canceled vs. Cancelled Requestor vs. Requester Implementor vs. Implementer (I see that Implementor isn't a word, but, then, why is Requestor? To me, the -or sounds correct). I favor the Cancelled myself, and I'm not British. I've always favored Favour, Colour, Armour also, but maybe I'm just different... Thanks, Gary Opela, Jr., RSP Remedy Engineer Leader Communications, Inc. Best Product, Best People, Best PriceTM An ISO 9001:2000 Certified, CMMIR Level 3 Rated Company -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of T. Dee Sent: Thursday, April 10, 2008 10:16 AM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7 - Task - Status Reason (Spelt Wrong)Good point. Remedy should pick one spelling and stick with it. Change and Incident has it spelt as Cancelled. Ty On 4/10/08, Scott Parrish [EMAIL PROTECTED] wrote: Actually, there are two accepted spellings of the word Cancelled and either Canceled or Cancelled is appropriate. v. can.celed also can.celled, can.cel.ing also can.cel.ling, can.cels also can.cels Scott Parrish IT Prophets, LLC (770) 653-5203 www.itprophets.com -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of T. Dee Sent: Thursday, April 10, 2008 10:44 AM To: arslist@ARSLIST.ORG Subject: OT: ITSM 7 - Task - Status Reason (Spelt Wrong) Not sure if anyone has seen this or reported it to Remedy, but the Status Reason in Task Canceled is spelt wrong - should be Cancelled. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ***IMPORTANT NOTICE: This communication, including any attachment, contains information that may be confidential or privileged, and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message is strictly prohibited. Nothing in this email, including any attachment, is intended to be a legally binding signature.*** __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE
Application-Delete-Entry on the Alert List
Hi all, I am using Remedy Alert for user notifications and I'm opening the Alert List on the web. I have added a delete button on the Alert List form so my users can delete entries as they deem necessary. The workflow I'm using is an Active Link that executes on this button and my If Action has the following Run Process action @@:Application-Delete-Entry Alert Events $Request ID$. This doesn't work because the Request ID field is always null. What I'm finding is that the Alert List form has a table with field ID 706. This Remedy table lists some some of the fields from the Alert Events form and these values are available. It does not however list the Request ID field. If I try to use it, it's null. The easiest thing would be to add the Request ID field to the table but there doesn't seem to be a way to add it. Does nayone have any ideas? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: date field and SQL
So is there a way to convert 2454436 to dd/mm/? From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: Thursday, April 10, 2008 4:59 PM To: arslist@ARSLIST.ORG Subject: Re: date field and SQL Date fields are not stored in seconds (You are thinking of DateTime or Time fields). Date fields are stored as the number of days since January 1, 4713 B.C. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Moore, Christopher Allen Sent: Thursday, April 10, 2008 4:44 PM To: arslist@ARSLIST.ORG Subject: date field and SQL Hey everyone, I added a date field to a form and when we are trying to get the value out in SQL we're not getting what we expect. If I just do a select of the field, I get a 7 digit number (2454436). If I try and run the same conversion against it that is run against the date/time fields: convert (varchar(10),dateadd(second, Invoicemonth, '1 January 1970'), 101) 'Invoice Month 1' we get 1/28/1970. I'm no SQL expert- how can I get the value of that field in a MM/DD/ format? Thanks! Chris __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: date field and SQL
2440588 = days from Jan 1, 4713 BC to Jan 1, 1970 So it would be something like convert (varchar(10),dateadd(day, Invoicemonth-2440587, '1 January 1970'), 101) 'Invoice Month 1' From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Moore, Christopher Allen Sent: Thursday, April 10, 2008 5:01 PM To: arslist@ARSLIST.ORG Subject: Re: date field and SQL ** So is there a way to convert 2454436 to dd/mm/? From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: Thursday, April 10, 2008 4:59 PM To: arslist@ARSLIST.ORG Subject: Re: date field and SQL Date fields are not stored in seconds (You are thinking of DateTime or Time fields). Date fields are stored as the number of days since January 1, 4713 B.C. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Moore, Christopher Allen Sent: Thursday, April 10, 2008 4:44 PM To: arslist@ARSLIST.ORG Subject: date field and SQL Hey everyone, I added a date field to a form and when we are trying to get the value out in SQL we're not getting what we expect. If I just do a select of the field, I get a 7 digit number (2454436). If I try and run the same conversion against it that is run against the date/time fields: convert (varchar(10),dateadd(second, Invoicemonth, '1 January 1970'), 101) 'Invoice Month 1' we get 1/28/1970. I'm no SQL expert- how can I get the value of that field in a MM/DD/ format? Thanks! Chris __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: RESOLVED: Mid-Tier help
A side note: I had a similar issue trying to get Tomcat to install during the MT install and it turned out that Tomcat didn't like that my TEMP folder has spaces in it. I changed my TEMP to c:\temp and it worked fine. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Gary Opela (Corporate) Sent: Thursday, April 10, 2008 11:55 AM To: arslist@ARSLIST.ORG Subject: RESOLVED: Mid-Tier help ** Update: I got it working by doing the following: Uninstall MT, Uninstall Tomcat. Download tomcat 5.5. from apache.org. Install tomcat 5.5 manually Install mid-tier (without tomcat) Reboot Works like a charm. Something about remedy installing tomcat wasn't working. Thanks so much to all who helped! Thanks, Gary Opela, Jr., RSP Remedy Engineer Leader Communications, Inc. Best Product, Best People, Best PriceTM An ISO 9001:2000 Certified, CMMIR Level 3 Rated Company From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of J.T. Shyman Sent: Tuesday, April 08, 2008 5:05 PM To: arslist@ARSLIST.ORG Subject: Re: Mid-Tier help ** Sorry we couldn't find an answer for you. Please do let us all know what the final solution is. You've got me curious now. J --- J.T. Shyman _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Gary Opela (Corporate) Sent: Tuesday, April 08, 2008 5:46 PM To: arslist@ARSLIST.ORG Subject: Re: Mid-Tier help Yeah, I did that, it still doesn't work. I have support engaged now, I've used enough of you guys' time. Thanks a ton for all of your help! Thanks, Gary Opela, Jr., RSP Remedy Engineer Leader Communications, Inc. Best Product, Best People, Best PriceTM An ISO 9001:2000 Certified, CMMIR Level 3 Rated Company From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of J.T. Shyman Sent: Tuesday, April 08, 2008 4:27 PM To: arslist@ARSLIST.ORG Subject: Re: Mid-Tier help ** Now that you have the right version of Java it might make sense to reinstall the mid-tier --- J.T. Shyman _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Gary Opela (Corporate) Sent: Tuesday, April 08, 2008 4:20 PM To: arslist@ARSLIST.ORG Subject: Re: Mid-Tier help Yeah, thanks a lot J I saw in my Mid-Tier log files the following line if it helps anyone: Apr 8, 2008 3:13:42 PM - SEVERE (com.remedy.log) : BMC Remedy Mid Tier version 7.1.00 Build 200708221849 Apr 8, 2008 3:13:45 PM - WARNING (com.remedy.log.SERVLET) : No File Entries were found in server - server Thanks, Gary Opela, Jr., RSP Remedy Engineer Leader Communications, Inc. Best Product, Best People, Best PriceTM An ISO 9001:2000 Certified, CMMIR Level 3 Rated Company =__ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: arserverd 'hangs' (AR 7.0.1 patch 5 - Sol 10 - Ora 10g2)
Thanks for all the replies guys. I've answered some of your questions 1. Gary Opela (Corporate) [EMAIL PROTECTED] Is your database local or remote? Local 2. Garrison, Sean (Norcross) [EMAIL PROTECTED] If you are on a unix server check the number of open files being used by the process. Maybe it has hit the max and locked up your server (why you aren't seeing anything in the logs). type in ulimit -a to tell you the limits you have pfiles process id to tell the number of open files used by the process. Thanks Sean, will try this out. currently ulimit says : XX $ ulimit -a core file size(blocks, -c) unlimited data seg size (kbytes, -d) unlimited file size (blocks, -f) unlimited open files(-n) 256 pipe size (512 bytes, -p) 10 stack size(kbytes, -s) 8192 cpu time (seconds, -t) unlimited max user processes(-u) 29995 virtual memory(kbytes, -v) unlimited 3. Roger Medsker [EMAIL PROTECTED] I have seen this behavior in a situation we had where AR System was actually restarting. There is no indication in any of the logs that the server crashed or was manually stopped. You can detect this by having server side SQL logging on when this occurs. If you see lots of SQL transactions with no identified user associated to them, then the server process is starting up. This doesn't help identify the root cause but the question changes from Why does the server 'hang'? to Why is the server restarting? Ok. Thanks Roger. will give that a go next time it hangs... only prob is it's intermittent and we really can't have SQL logging on all the time will figure something out. 4. Tadeu Augusto Dutra Pinto [EMAIL PROTECTED] one question how many records does your AR System Email Messages has??? 2,063,253 records... Delete Outgoing Messages is set to No. Will have to get that changed! Does this sound like a lot of rows to you? George On 4/11/08, Tadeu Augusto Dutra Pinto [EMAIL PROTECTED] wrote: one question how many records does your AR System Email Messages has??? De: Action Request System discussion list(ARSList) em nome de Roger Medsker Enviada: qui 10/4/2008 11:45 Para: arslist@ARSLIST.ORG Assunto: Re: arserverd 'hangs' (AR 7.0.1 patch 5 - Sol 10 - Ora 10g2) ** George, I have seen this behavior in a situation we had where AR System was actually restarting. There is no indication in any of the logs that the server crashed or was manually stopped. You can detect this by having server side SQL logging on when this occurs. If you see lots of SQL transactions with no identified user associated to them, then the server process is starting up. This doesn't help identify the root cause but the question changes from Why does the server 'hang'? to Why is the server restarting? HTH Roger From: Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] On Behalf Of George Jungle Sent: Thursday, April 10, 2008 2:45 AM To: arslist@ARSLIST.ORG Subject: arserverd 'hangs' (AR 7.0.1 patch 5 - Sol 10 - Ora 10g2) ** Hey guys, We're getting a strange issue (seemingly intermittent) with the arserverd where it just seems to 'hang'. All existing and new clients receive a TimeOut error, but yet when you check : -the processes at the o/s -the error logs -db sessions there is no evidence that there is an issue. (i.e. all processes running, you get timeouts appearing due to Brie / SLM engine not being able to connect and db sessions are not 'locked' or taking an extensive amount of time to process). It seems that the only way to fix this is to do a restart of the AR Server. I was just wondering if anyone else has experienced anything remotely similar to this? Thanks. George (AR 7.0.1 patch 5 - Sol 10 - Ora 10g2) __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Importing an incident record with attachment in Remedy 6.3
Hello All, I want to import an incident and Change Requests records having attachments using the import tool provided by Remedy. However I don't know the path where I have to store the attachment fields and to which I have to set the Attachment 1 field. It's giving me error: Incorrect field value for field Attachment 1 Regards Sanjana ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are