Re: server crashing when consuming a web servie
Hi Mark, Thank you for your response. I have been using web services for the past 3 years now with no problems and now I have created a new service I am having issues. Do you think that the above issue has to do with the xml schema with the bindings? Regards, Darshana From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Walters, Mark Sent: 21 November 2008 12:32 PM To: arslist@ARSLIST.ORG Subject: Re: server crashing when consuming a web servie ** Yes, the server is crashing . The stack below matches that for arserver defect SW00288690, which is fixed in 7.0.1 patch 8. Mark Walters 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 support representative for BMC Software, Inc. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Darshana Jivan [MTN Network Solutions] Sent: 21 November 2008 08:10 To: arslist@ARSLIST.ORG Subject: server crashing when consuming a web servie ** Hi, Please can someone assist me in understanding what this error actually means? I am trying to consume as web service and it seems that the server is crashing when invoking the service. Below is the error log. NISDEV07 is failing with the following in the arerror.log: Thu Nov 20 15:00:20 2008 390620 : AR System server terminated when a signal/exception was received by the server (ARNOTE 20) Thu Nov 20 15:00:20 2008 11 Timestamp: Thu Nov 20 2008 15:00:20.6514 Thread Id: 7 Version: 7.0.01 Patch 004 200708141640 Aug 14 2007 17:11:18 ServerName: nisdev07 Database: SQL -- Oracle Hardware: sun4u OS: SunOS 5.10 RPC Id: 10 RPC Call: 2 (SE) RPC Queue: 390620 Client: User ARAdmin from Remedy User (protocol 12) at IP address 209.212.109.147 Form: MTNNS:EventLog New Layout Logging On: Stacks: /app/ar/nisdev07/system/bin/arserverd:DumpStackTrace+0x88 /app/ar/nisdev07/system/bin/arserverd:SignalTrapProc+0x160 /lib/libc.so.1:0xc5364 /lib/libc.so.1:0xb9e64 /app/ar/nisdev07/system/bin/libxerces-depdombmc.so.26.0:__1cLxercesc_2_6 MDocumentImplKimportNode6Mpn0AINodeImpl_b_3_+0x28 [ Signal 11 (SEGV)] /app/ar/nisdev07/system/bin/libxerces-depdombmc.so.26.0:__1cLxercesc_2_6 MDOM_DocumentKimportNode6Mrkn0AIDOM_Node_b_2_+0x18 /app/ar/nisdev07/system/bin/arserverd:__1cRARXMLHandlerUtilsTBuildDOMTre eFromStr6FrnLxercesc_2_6JDOMString_rn0BMDOM_Document_rn0BIDOM_Node__C_+0 xf0 /app/ar/nisdev07/system/bin/arserverd:__1cUARXMLComplexEntryGetOProcessE lement6MrnLxercesc_2_6ODOM_TreeWalker_pnQARFieldValueList_rn0BJDOMString _rn0BMDOM_Document_rn0BLDOM_Element__9B_+0x3c4 /app/ar/nisdev07/system/bin/arserverd:__1cUARXMLComplexEntryGetMProcessN odes6MrnLxercesc_2_6ODOM_TreeWalker_pnQARFieldValueList_pnYARComplexEntr yGetOutList_ipin0BJDOMString_rn0BMDOM_Document_rn0BLDOM_Element__v_+0x17 8 /app/ar/nisdev07/system/bin/arserverd:__1cUARXMLComplexEntryGetMProcessN odes6MrnLxercesc_2_6ODOM_TreeWalker_pnQARFieldValueList_pnYARComplexEntr yGetOutList_ipin0BJDOMString_rn0BMDOM_Document_rn0BLDOM_Element__v_+0x21 4 /app/ar/nisdev07/system/bin/arserverd:__1cUARXMLComplexEntryGetMProcessN odes6MrnLxercesc_2_6ODOM_TreeWalker_pnQARFieldValueList_pnYARComplexEntr yGetOutList_ipin0BJDOMString_rn0BMDOM_Document_rn0BLDOM_Element__v_+0x21 4 /app/ar/nisdev07/system/bin/arserverd:__1cUARXMLComplexEntryGetSProcessF ormMapping6MrnLxercesc_2_6ODOM_TreeWalker_pnYARComplexEntryGetOutList_n0 BJDOMString_rn0BMDOM_Document_rn0BLDOM_Element__v_+0x424 /app/ar/nisdev07/system/bin/arserverd:__1cUARXMLComplexEntryGetMProcessN odes6MrnLxercesc_2_6ODOM_TreeWalker_pnQARFieldValueList_pnYARComplexEntr yGetOutList_ipin0BJDOMString_rn0BMDOM_Document_rn0BLDOM_Element__v_+0x40 4 /app/ar/nisdev07/system/bin/arserverd:__1cUARXMLComplexEntryGetQBuildXML Document6MpcpnYARComplexEntryGetOutList_pnSARXMLValueInfoList_Cp1_v_+0x4 f4 /app/ar/nisdev07/system/bin/arserverd:GetComplexEntryGetToXML+0x6c /app/ar/nisdev07/system/bin/arserverd:__1cbASubValueListForWebServices6F pnOARSchemaStruct_pnNAREntryIdList_pnQARFieldValueList_CpnLARValueList_7 pnMARStatusList__i_+0xaf8 /app/ar/nisdev07/system/bin/arserverd:0x20a8fc /app/ar/nisdev07/system/bin/arserverd:0x20b038 /app/ar/nisdev07/system/bin/arserverd:MergeFieldAssignList+0x18c /app/ar/nisdev07/system/bin/arserverd:PerformFilterOps+0x1ac8 /app/ar/nisdev07/system/bin/arserverd:PrepareEntryContext+0x874 /app/ar/nisdev07/system/bin/arserverd:arsetentry_12_svc+0x5d8 /app/ar/nisdev07/system/bin/arserverd:HandleRPCs+0x134d0 /app/ar/nisdev07/system/bin/arserverd:WorkerThread+0x5f4 /app/ar/nisdev07/system/bin/arserverd:RestartableThreadMain+0x60 /app/ar/nisdev07/system/bin/arserverd:UnixThreadStartRoutine+0xe8 /lib/libc.so.1:0xc5238 Regards, Darshana Jivan
Re: server crashing when consuming a web servie
Hi, It has nothing to do with which web service you are consuming. The server doesnt crash for all webservices but only one or two. There is no clear explanation as to why, but i assume it has to something with the threads. As mentioned by Mark, applying the patch would fix the issue. Rakshit On Mon, Nov 24, 2008 at 4:25 PM, Darshana Jivan [MTN Network Solutions] [EMAIL PROTECTED] wrote: ** Hi Mark, Thank you for your response. I have been using web services for the past 3 years now with no problems and now I have created a new service I am having issues. Do you think that the above issue has to do with the xml schema with the bindings? Regards, Darshana *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Walters, Mark *Sent:* 21 November 2008 12:32 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: server crashing when consuming a web servie ** Yes, the server is crashing . The stack below matches that for arserver defect SW00288690, which is fixed in 7.0.1 patch 8. Mark Walters 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 support representative for BMC Software, Inc. *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Darshana Jivan [MTN Network Solutions] *Sent:* 21 November 2008 08:10 *To:* arslist@ARSLIST.ORG *Subject:* server crashing when consuming a web servie ** Hi, Please can someone assist me in understanding what this error actually means? I am trying to consume as web service and it seems that the server is crashing when invoking the service. Below is the error log. NISDEV07 is failing with the following in the arerror.log: Thu Nov 20 15:00:20 2008 390620 : AR System server terminated when a signal/exception was received by the server (ARNOTE 20) Thu Nov 20 15:00:20 2008 11 Timestamp: Thu Nov 20 2008 15:00:20.6514 Thread Id: 7 Version: 7.0.01 Patch 004 200708141640 Aug 14 2007 17:11:18 ServerName: nisdev07 Database: SQL -- Oracle Hardware: sun4u OS: SunOS 5.10 RPC Id: 10 RPC Call: 2 (SE) RPC Queue: 390620 Client: User ARAdmin from Remedy User (protocol 12) at IP address 209.212.109.147 Form: MTNNS:EventLog New Layout Logging On: Stacks: /app/ar/nisdev07/system/bin/arserverd:DumpStackTrace+0x88 /app/ar/nisdev07/system/bin/arserverd:SignalTrapProc+0x160 /lib/libc.so.1:0xc5364 /lib/libc.so.1:0xb9e64 /app/ar/nisdev07/system/bin/libxerces-depdombmc.so.26.0:__1cLxercesc_2_6MDocumentImplKimportNode6Mpn0AINodeImpl_b_3_+0x28 [ Signal 11 (SEGV)] /app/ar/nisdev07/system/bin/libxerces-depdombmc.so.26.0:__1cLxercesc_2_6MDOM_DocumentKimportNode6Mrkn0AIDOM_Node_b_2_+0x18 /app/ar/nisdev07/system/bin/arserverd:__1cRARXMLHandlerUtilsTBuildDOMTreeFromStr6FrnLxercesc_2_6JDOMString_rn0BMDOM_Document_rn0BIDOM_Node__C_+0xf0 /app/ar/nisdev07/system/bin/arserverd:__1cUARXMLComplexEntryGetOProcessElement6MrnLxercesc_2_6ODOM_TreeWalker_pnQARFieldValueList_rn0BJDOMString_rn0BMDOM_Document_rn0BLDOM_Element__9B_+0x3c4 /app/ar/nisdev07/system/bin/arserverd:__1cUARXMLComplexEntryGetMProcessNodes6MrnLxercesc_2_6ODOM_TreeWalker_pnQARFieldValueList_pnYARComplexEntryGetOutList_ipin0BJDOMString_rn0BMDOM_Document_rn0BLDOM_Element__v_+0x178 /app/ar/nisdev07/system/bin/arserverd:__1cUARXMLComplexEntryGetMProcessNodes6MrnLxercesc_2_6ODOM_TreeWalker_pnQARFieldValueList_pnYARComplexEntryGetOutList_ipin0BJDOMString_rn0BMDOM_Document_rn0BLDOM_Element__v_+0x214 /app/ar/nisdev07/system/bin/arserverd:__1cUARXMLComplexEntryGetMProcessNodes6MrnLxercesc_2_6ODOM_TreeWalker_pnQARFieldValueList_pnYARComplexEntryGetOutList_ipin0BJDOMString_rn0BMDOM_Document_rn0BLDOM_Element__v_+0x214 /app/ar/nisdev07/system/bin/arserverd:__1cUARXMLComplexEntryGetSProcessFormMapping6MrnLxercesc_2_6ODOM_TreeWalker_pnYARComplexEntryGetOutList_n0BJDOMString_rn0BMDOM_Document_rn0BLDOM_Element__v_+0x424 /app/ar/nisdev07/system/bin/arserverd:__1cUARXMLComplexEntryGetMProcessNodes6MrnLxercesc_2_6ODOM_TreeWalker_pnQARFieldValueList_pnYARComplexEntryGetOutList_ipin0BJDOMString_rn0BMDOM_Document_rn0BLDOM_Element__v_+0x404 /app/ar/nisdev07/system/bin/arserverd:__1cUARXMLComplexEntryGetQBuildXMLDocument6MpcpnYARComplexEntryGetOutList_pnSARXMLValueInfoList_Cp1_v_+0x4f4 /app/ar/nisdev07/system/bin/arserverd:GetComplexEntryGetToXML+0x6c /app/ar/nisdev07/system/bin/arserverd:__1cbASubValueListForWebServices6FpnOARSchemaStruct_pnNAREntryIdList_pnQARFieldValueList_CpnLARValueList_7pnMARStatusList__i_+0xaf8 /app/ar/nisdev07/system/bin/arserverd:0x20a8fc /app/ar/nisdev07/system/bin/arserverd:0x20b038 /app/ar/nisdev07/system/bin/arserverd:MergeFieldAssignList+0x18c
Re: Can’t resize form view SOLVED
Thanks, Fred, When I read your letter my first reaction was, Come now, the User tool doesn't expand to display all the fields. I have fields off to the right of the display on all my forms. BUT it turns out that a Dialog window DOES expand to include all the fields (at least in the User tool, but apparently not in Mid-Tier). I had a display-only, hidden character field with no label that I couldn't even see in the Admin tool. I got rid of it, and now the views display normally. Thank you too, David, for your suggestion. Gratefully yours, Dwayne Original message Date: Fri, 21 Nov 2008 15:28:14 -0600 From: Grooms, Frederick W [EMAIL PROTECTED] Subject: Re: Can’t resize form view To: arslist@ARSLIST.ORG Are there any fields at the right edge of those specific views? I seem to remember the User tool automatically expanding a view when there were fields to display. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin Sent: Friday, November 21, 2008 3:26 PM To: arslist@ARSLIST.ORG Subject: Can’t resize form view Dear List, We have a Display-Only, Standard form that we use for dialogs. It has several views, most of which appear normally in the User tool. But two of the views (one is a copy of the other) are elongated horizontally. And no matter how often we re-size them in the Admin tool, they stay elongated in the User tool. But they display properly in Mid-Tier. After editing, we save our view before opening a new view, and when we close the form and re-display it, the views show their new size in the Admin tool, but not in the User tool. I cleared out the cache on my own computer, and displayed the views on a virgin computer that had never had Remedy installed on it before, but they still appear elongated. What am I missing? Dwayne Martin James Madison University (ARS, User and Admin tool 7.1 patch 3, RH Linux server, Oracle 10.2 db) ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Plugin Crashing issue
Hi All, Not sure why I did not think of this earlier, but we also have a test server. So I pointed our test server to the devdb server and the plugin crashes with same error below. So this tells me something wrong with dev DB that is causing this to crash. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Chowdhury, Tauf Sent: Sunday, November 23, 2008 7:27 PM To: arslist@ARSLIST.ORG Subject: Re: Plugin Crashing issue I would try what Fred suggested about copying the file over from your other system. Remember you might have to manually unregister and register the new one. -Original Message- From: Action Request System discussion list(ARSList) on behalf of Timothy Rondeau Sent: Sun 11/23/2008 5:21 PM To: arslist@ARSLIST.ORG Subject: Re: Plugin Crashing issue Hi Fred, No and we have been told no updates have been done on the machine, so we are at a loss on this one. Tim From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: Sunday, November 23, 2008 4:21 PM To: arslist@ARSLIST.ORG Subject: Re: Plugin Crashing issue Since it is telling you the problem is in the file msvcr71.dll (MS Visual C Runtime 7.1) I would have to ask ... Was any other application installed or updated on Thursday night? Compare that dll file (in your system32 directory) with the one on Production. If they are different you should be able to copy the one from your production server over to your dev server Fred From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Timothy Rondeau Sent: Sunday, November 23, 2008 2:52 PM To: arslist@ARSLIST.ORG Subject: Plugin Crashing issue Importance: High Hi All, Basically this issue started Thursday night in our Dev system. Users getting issue can not longer authenticate. Looking into further found the arplugin keeps crashing. Restart the application and plugin comes up and then crashes: Faulting application arplugin.exe, version 7.0.1.2, faulting module msvcr71.dll, version 7.10.7031.4, fault address 0xd587. ARERR [8760] Cannot establish a network connection to the AR System Plug-In server We added some fields on Thursday to the Requestor console, SRM request, HPD:helpdesk, Helpdesk_create form and then to 2 users forms.All these changes have since been rolled back. Still no luck plugin will not stay running. I have tried starting from command line and still crashes. We are running 7.0.1 patch 2 windows 2003, SQL 2000. This is also what we run production and have been running for over 1 ½. Both servers are running off of the same LDAP server with the same user and password. So any info to help would be great. Thanks Tim __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 ** This e-mail and its attachments may contain Forest Laboratories, Inc. proprietary information that is privileged, confidential or subject to copyright belonging to Forest Laboratories, Inc. This e-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this e-mail, or the employee or agent responsible for delivering this e-mail to the intended recipient, you are hereby notified that any dissemination, distribution, copying or action taken in relation to the contents of and attachments to this e-mail is strictly prohibited and may be unlawful. If you have received this e-mail in error, please notify the sender immediately and permanently delete the original and any copy of this e-mail and any printout. ___ 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
Reporting question - count of tickets open at a particular point in time
Hello, Wondering if anyone might have suggestion for best way to obtain snapshot stats of # of Cases open at a particular time each week (say, midnight on Wednesdays). I can run a Query with a search like: 'Created' = 10/9/2008 AND ('Resolved' 10/9/2008 OR 'Status*' Resolved) which selects Cases that were created up to and including 12:00am at midnight and that were either resolved after that point or are still not resolved at time of search. But obviously this would need to be run once each week... Trying to figure out if there's another way to do this where a date range could be entered and this stat collected for each week included. This is not the first time I've been asked about getting snapshop-in-time stats for open tickets and I'm hoping others may suggestions. We are currently on Remedy 6.x, but moving to 7.x, so solutions/suggestions in either would be welcome. Thanks, Julie [EMAIL PROTECTED] ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: SQL Reporing Services - making sense of Remedy Table structure
Neil, I do all of our Remedy reports in SSRS. If you use the views, you should be able to query off of HPD:Help Desk and set the group parameter on the report to the assigned support group field, then do a count for each group. The assignment log form will show you all assignments, both past and present. You'll want to look at the help desk form for the current ones, unless you want to add some data parameters to the report if you stick with the assignment log. HTH, -Matt Matthew C. Gayford Application Developer Remedy Administrator University of North Carolina Wilmington (910) 962-7177 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of npeterson Sent: Sunday, November 23, 2008 5:32 PM To: arslist@ARSLIST.ORG Subject: Re: SQL Reporing Services - making sense of Remedy Table structure Thanks both of you - this advice had gotten me almost to where I need to be. One wierd thing I've noticed is that in the HPD_HelpDeskAssignmentLogJoin table (the table I believe has what I need in it) , there are two rows for each submitted incident. The difference is on the Request_ID - one will be something like INC5(HDA565) and the second will be something like INC5(HDA249) This is causing all of my reports to some out double. I've tried to filter this down using fields like actual duration second and while it did get the numbers down thay were not acurate. Has any had to deal with something like this before or have any advice? Thanks neilp Drew Shuller wrote: npeterson, query the views instead. Or look for the Database Guide in the documentation. Drew ERCOT I am hoping to user SQL Reporting services to create some Remedy reports, however I can not make one bit of sense of the tables in this Database. We are using Remedy IT Service Management 7.0 - DB is on SQL server 2005. A sample report would just be count all tickets currently assigned to a specific support group. I can not find any reference to support groups, open incidents, support personnel, etc. Is there some secret or guide on what data is stored where? For the record I am not a remedy guy, I just happen to admin the system and have been given some reporting requirement that can not be met with the integrated reporting tools. Thanks -- View this message in context: http://www.nabble.com/SQL-Reporing-Services---making-sense-of-Remedy-Table-structure-tp20626113p20626113.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 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are -- View this message in context: http://www.nabble.com/SQL-Reporing-Services---making-sense-of-Remedy-Table-structure-tp20626113p20651835.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 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Reporting question - count of tickets open at a particular point in time
Hi Julie, Are you trying to do the report in Remedy or are you using another tool? If you're doing it in Remedy, you can have a macro simply run the query and use the $DATE$ keyword to get the results you wanted. If you're using SSRS, you can do the same thing and set up a subscription to the report that fires on Wednesday nights and emails the result. -Matt Matthew C. Gayford Application Developer Remedy Administrator University of North Carolina Wilmington (910) 962-7177 From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Julie L Kanakanui JLKANAKA Sent: Monday, November 24, 2008 9:08 AM To: arslist@ARSLIST.ORG Subject: Reporting question - count of tickets open at a particular point in time ** Hello, Wondering if anyone might have suggestion for best way to obtain snapshot stats of # of Cases open at a particular time each week (say, midnight on Wednesdays). I can run a Query with a search like: 'Created' = 10/9/2008 AND ('Resolved' 10/9/2008 OR 'Status*' Resolved) which selects Cases that were created up to and including 12:00am at midnight and that were either resolved after that point or are still not resolved at time of search. But obviously this would need to be run once each week... Trying to figure out if there's another way to do this where a date range could be entered and this stat collected for each week included. This is not the first time I've been asked about getting snapshop-in-time stats for open tickets and I'm hoping others may suggestions. We are currently on Remedy 6.x, but moving to 7.x, so solutions/suggestions in either would be welcome. Thanks, Julie [EMAIL PROTECTED] __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: Reporting question - count of tickets open at a particular point in time
One way to do this is to use an Escalation which runs every night during off-hours. The setup is the following: 1. Create an Integer field with Administrator only permissions - I usually call it Days Open 2. Setup an Escalation which performs Days Open = Days Open +1 every night on each record 3. When you report, used the clause 'Status' Resolved 4. Use the Days Open count for further statistics after the Case is Resolved. The result is a count of number of days the case was open at a specific time (using Create-date and Modified-Date in the query). Another way to do this is to create an Audit Trail form which holds status transactions. A query against this will give you what was open during a specific past time. The form will get very large, so you will have to come up with a good archive scenario. A good rule of thumb is on average, each Case will have seven (7) modifications. Therefore your Audit form will increase by 7 times for each Case. From an Archive standpoint, calculate how often you report. If it is 30 days, hold 30 days before you archive. If its yearly, hold a year and so on! Over 30 days may require creativity on the backend by holding archives in .arx files and reloading as you need them (something which can be automated). You can also use Status-History for calculating open times. Just some thoughts, Gordon M. Frank Lockheed Martin From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Julie L Kanakanui JLKANAKA Sent: Monday, November 24, 2008 9:08 AM To: arslist@ARSLIST.ORG Subject: Reporting question - count of tickets open at a particular point in time ** Hello, Wondering if anyone might have suggestion for best way to obtain snapshot stats of # of Cases open at a particular time each week (say, midnight on Wednesdays). I can run a Query with a search like: 'Created' = 10/9/2008 AND ('Resolved' 10/9/2008 OR 'Status*' Resolved) which selects Cases that were created up to and including 12:00am at midnight and that were either resolved after that point or are still not resolved at time of search. But obviously this would need to be run once each week... Trying to figure out if there's another way to do this where a date range could be entered and this stat collected for each week included. This is not the first time I've been asked about getting snapshop-in-time stats for open tickets and I'm hoping others may suggestions. We are currently on Remedy 6.x, but moving to 7.x, so solutions/suggestions in either would be welcome. Thanks, Julie [EMAIL PROTECTED] __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
Strange ARS 7.0.1 Patch 9 bug
Good morning, I decided to try going from patch 6 to patch 9, and found a strange bug and wanted to see if anyone else ran into this before. Basically, we use AD authentication for Remedy, but do store all permissions and such in ARS. This has worked fine for my account in the past. However, with this patch, despite having the same access rights, the fact that I am not storing the password in the User form seems to prevent me from having admin rights. I was able to gain my admin rights back by storing a password in the User form. Has anyone else encountered this, and if so, what is a workaround? Thanks, Shawn Pierson Remedy Developer | Southern Union 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
Re: ARS for non Trouble Ticketing applications
In addition to the Applications that Lisa noted, we also have a system that allocates Telecommunication charges to the appropriate departments. If memory serves me correctly, a long time ago Kelly Deaver put together an application that could be used to track who was dating your teenager. Dave From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of sam appecherla Sent: Friday, November 14, 2008 11:22 AM To: arslist@ARSLIST.ORG Subject: ARS for non Trouble Ticketing applications ** Hi List, Just curious to know.. Apart from using Remedy for HelpDesk, Trouble Ticketing and the kinds, what else can we do with this workflow engine for? Does anyone have a custom built product/application built on ARS apart from Trouble Ticketing kinds that you would like to share? Regards, SriSamSri Appecherla Mobile# +91 991 610 6008 __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: Indirect reference to form field value
Hi Folks, Sorry.. I may have committed a breach of etiquette by not properly identifying myself: Larry Robinson NC State University Office Of Information Technology Remedy Administrator On Nov 21, 2008, at 11:35 AM, L G Robinson wrote: Hi Folks, I am seeking some assistance in referencing the value of a form field through an indirect reference. I have a filter guide that contain a loop to process a number of fields on the form. I am using this to detect which fields have been modified and to build a diary entry containing the changes. The field names of interest are stored in another form and I have been successful in fetching the names and building a qualification to detect the condition that I am interested in. I used the EXTERNAL function in the qualification of the filter to detect the conditions that I am interested in. This part works fine. The problem comes inside this filter. Now that I have determined that one of the fields of interest has been modified, I need to reference the current value of that field on the form. I want to reference the field value as part of a Set Fields action against the current transaction. The name of the field of interest is contained in another field on the same form... lets call it $field_name$. So the question is, how do I get the value of the field whose name is in the field $field_name$, as part of a Set Fields action in a filter? I do not see a way to use the EXTERNAL operator in this context. I have looked through all of the functions and processes and none of them appear to provide the functionality that I need. Any suggestions on how to accomplish this will be greatly appreciated. AR Server 5.1.2 patch 1313 Sybase DB Thanks. Larry ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Intermittent, Spotty ARS Performance
Hi everyone: This problem has me perplexed. At a site I support, the Remedy server inexplicably stops responding to requests. It's very intermittent. It runs fine for awhile, then seemingly without warning, it just hangs. Users attempting to log on get stuck at the Setting server port dialog, which eventually times out. Other users who are already logged who try to pull up a ticket get stuck at a blank screen that never comes back. To resolve the issue, they have to bounce the Remedy server service. The system works for awhile...until it hangs up again. Any ideas what might be causing this? - I have monitored CPU utilization when this occurs, and the CPU hums along at about 3% - 5% utilization - Network utilization is flat-lined whenever this occurs (i.e., no spike) - Memory utilization appears normal - CNET bandwidth tests resolve to better than dedicated T1 performance (for what that's worth) Any thoughts are greatly appreciated. The interesting thing is, we have the same exact Remedy apps running on the same exact type of server in the same exact environment in four other locations, and those four other locations never experience any problems. Norm Remedy ARS 6.3 Microsoft SQL 2000 SP4 Microsoft Windows 2000 SP2 100% Custom Apps - No ITSM ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Intermittent, Spotty ARS Performance
What java version are you running? Jennifer Meyer From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE Sent: Monday, November 24, 2008 12:03 PM To: arslist@ARSLIST.ORG Subject: Intermittent, Spotty ARS Performance Hi everyone: This problem has me perplexed. At a site I support, the Remedy server inexplicably stops responding to requests. It's very intermittent. It runs fine for awhile, then seemingly without warning, it just hangs. Users attempting to log on get stuck at the Setting server port dialog, which eventually times out. Other users who are already logged who try to pull up a ticket get stuck at a blank screen that never comes back. To resolve the issue, they have to bounce the Remedy server service. The system works for awhile...until it hangs up again. Any ideas what might be causing this? - I have monitored CPU utilization when this occurs, and the CPU hums along at about 3% - 5% utilization - Network utilization is flat-lined whenever this occurs (i.e., no spike) - Memory utilization appears normal - CNET bandwidth tests resolve to better than dedicated T1 performance (for what that's worth) Any thoughts are greatly appreciated. The interesting thing is, we have the same exact Remedy apps running on the same exact type of server in the same exact environment in four other locations, and those four other locations never experience any problems. Norm Remedy ARS 6.3 Microsoft SQL 2000 SP4 Microsoft Windows 2000 SP2 100% Custom Apps - No ITSM __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: Reporting question - count of tickets open at a particular point in time
Take a look at flashboard variables, I think that is the easiest thing to setup. Displaying more than a few flashboards requires a license, however, the variables are free and there may be another way to query those without using a flashboard. Brien On Mon, Nov 24, 2008 at 7:53 AM, Frank, Gordon M. (CMS/CTR) [EMAIL PROTECTED] wrote: ** One way to do this is to use an Escalation which runs every night during off-hours. The setup is the following: 1. Create an Integer field with Administrator only permissions – I usually call it Days Open 2. Setup an Escalation which performs Days Open = Days Open +1 every night on each record 3. When you report, used the clause 'Status' Resolved 4. Use the Days Open count for further statistics after the Case is Resolved. The result is a count of number of days the case was open at a specific time (using Create-date and Modified-Date in the query). Another way to do this is to create an Audit Trail form which holds status transactions. A query against this will give you what was open during a specific past time. The form will get very large, so you will have to come up with a good archive scenario. A good rule of thumb is on average, each Case will have seven (7) modifications. Therefore your Audit form will increase by 7 times for each Case. From an Archive standpoint, calculate how often you report. If it is 30 days, hold 30 days before you archive. If its yearly, hold a year and so on! Over 30 days may require creativity on the backend by holding archives in .arx files and reloading as you need them (something which can be automated). You can also use Status-History for calculating open times. Just some thoughts, Gordon M. Frank Lockheed Martin -- *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Julie L Kanakanui JLKANAKA *Sent:* Monday, November 24, 2008 9:08 AM *To:* arslist@ARSLIST.ORG *Subject:* Reporting question - count of tickets open at a particular point in time ** Hello, Wondering if anyone might have suggestion for best way to obtain snapshot stats of # of Cases open at a particular time each week (say, midnight on Wednesdays). I can run a Query with a search like: 'Created' = 10/9/2008 AND ('Resolved' 10/9/2008 OR 'Status*' Resolved) which selects Cases that were created up to and including 12:00am at midnight and that were either resolved after that point or are still not resolved at time of search. But obviously this would need to be run once each week... Trying to figure out if there's another way to do this where a date range could be entered and this stat collected for each week included. This is not the first time I've been asked about getting snapshop-in-time stats for open tickets and I'm hoping others may suggestions. We are currently on Remedy 6.x, but moving to 7.x, so solutions/suggestions in either would be welcome. Thanks, Julie [EMAIL PROTECTED] __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
Java API Question
I'm using the 7.1 Java API to create a new field on a form. Be All: I'm using the 7.1 Java API to create a new field on a form. Before creating the field, I'd like to make sure a field with the same Field ID does not already exist. I found the isPresent() method of the Field object in the javadocs, but since a generic Field cannot be instantiated (must use CharacterField or IntegerField, etc), how do I use isPresent() to check for any type existing field with a given Field ID? Do I have to first check for an AttachmentField, then check for an AttachmentPoolField, then check for a CharacterField, etc? Sorry if this is a dumb question -- I'm new at this OO programming stuff. TIA, --Phil ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Intermittent, Spotty ARS Performance
I'm assuming there are no messages going into the arerror.log or anything like that? How about the armonitor.log? Try turning on Thread logging (very small output) and see if you can see anything happening with threads at the time it hangs. _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE Sent: Monday, November 24, 2008 10:03 AM To: arslist@ARSLIST.ORG Subject: Intermittent, Spotty ARS Performance ** Hi everyone: This problem has me perplexed. At a site I support, the Remedy server inexplicably stops responding to requests. It's very intermittent. It runs fine for awhile, then seemingly without warning, it just hangs. Users attempting to log on get stuck at the Setting server port dialog, which eventually times out. Other users who are already logged who try to pull up a ticket get stuck at a blank screen that never comes back. To resolve the issue, they have to bounce the Remedy server service. The system works for awhile.until it hangs up again. Any ideas what might be causing this? - I have monitored CPU utilization when this occurs, and the CPU hums along at about 3% - 5% utilization - Network utilization is flat-lined whenever this occurs (i.e., no spike) - Memory utilization appears normal - CNET bandwidth tests resolve to better than dedicated T1 performance (for what that's worth) Any thoughts are greatly appreciated. The interesting thing is, we have the same exact Remedy apps running on the same exact type of server in the same exact environment in four other locations, and those four other locations never experience any problems. Norm Remedy ARS 6.3 Microsoft SQL 2000 SP4 Microsoft Windows 2000 SP2 100% Custom Apps - No ITSM __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: Intermittent, Spotty ARS Performance
1.4.2_14 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Meyer, Jennifer L Sent: Monday, November 24, 2008 11:07 AM To: arslist@ARSLIST.ORG Subject: Re: Intermittent, Spotty ARS Performance ** What java version are you running? Jennifer Meyer From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE Sent: Monday, November 24, 2008 12:03 PM To: arslist@ARSLIST.ORG Subject: Intermittent, Spotty ARS Performance Hi everyone: This problem has me perplexed. At a site I support, the Remedy server inexplicably stops responding to requests. It's very intermittent. It runs fine for awhile, then seemingly without warning, it just hangs. Users attempting to log on get stuck at the Setting server port dialog, which eventually times out. Other users who are already logged who try to pull up a ticket get stuck at a blank screen that never comes back. To resolve the issue, they have to bounce the Remedy server service. The system works for awhile...until it hangs up again. Any ideas what might be causing this? - I have monitored CPU utilization when this occurs, and the CPU hums along at about 3% - 5% utilization - Network utilization is flat-lined whenever this occurs (i.e., no spike) - Memory utilization appears normal - CNET bandwidth tests resolve to better than dedicated T1 performance (for what that's worth) Any thoughts are greatly appreciated. The interesting thing is, we have the same exact Remedy apps running on the same exact type of server in the same exact environment in four other locations, and those four other locations never experience any problems. Norm Remedy ARS 6.3 Microsoft SQL 2000 SP4 Microsoft Windows 2000 SP2 100% Custom Apps - No ITSM __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
AW: Intermittent, Spotty ARS Performance
Hi Norm, Can you log on with Remedy Administrator while the server ist not responding? Kind Regards Conny Von: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Im Auftrag von LJ Longwing Gesendet: Montag, 24. November 2008 18:15 An: arslist@ARSLIST.ORG Betreff: Re: Intermittent, Spotty ARS Performance ** I'm assuming there are no messages going into the arerror.log or anything like that? How about the armonitor.log? Try turning on Thread logging (very small output) and see if you can see anything happening with threads at the time it hangs. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE Sent: Monday, November 24, 2008 10:03 AM To: arslist@ARSLIST.ORG Subject: Intermittent, Spotty ARS Performance ** Hi everyone: This problem has me perplexed. At a site I support, the Remedy server inexplicably stops responding to requests. It's very intermittent. It runs fine for awhile, then seemingly without warning, it just hangs. Users attempting to log on get stuck at the Setting server port dialog, which eventually times out. Other users who are already logged who try to pull up a ticket get stuck at a blank screen that never comes back. To resolve the issue, they have to bounce the Remedy server service. The system works for awhile...until it hangs up again. Any ideas what might be causing this? - I have monitored CPU utilization when this occurs, and the CPU hums along at about 3% - 5% utilization - Network utilization is flat-lined whenever this occurs (i.e., no spike) - Memory utilization appears normal - CNET bandwidth tests resolve to better than dedicated T1 performance (for what that's worth) Any thoughts are greatly appreciated. The interesting thing is, we have the same exact Remedy apps running on the same exact type of server in the same exact environment in four other locations, and those four other locations never experience any problems. Norm Remedy ARS 6.3 Microsoft SQL 2000 SP4 Microsoft Windows 2000 SP2 100% Custom Apps - No ITSM __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: Intermittent, Spotty ARS Performance (UNCLASSIFIED)
Classification: UNCLASSIFIED Caveats: NONE Norm, You may want to look closer at the SQL side. Look for locks. Perhaps someone querying a diary or un-indexed field. Also, are you using SQL replication? In particular, are snapshots turned on? Christopher Michaud -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE Sent: Monday, November 24, 2008 11:03 AM To: arslist@ARSLIST.ORG Subject: Intermittent, Spotty ARS Performance ** Hi everyone: This problem has me perplexed. At a site I support, the Remedy server inexplicably stops responding to requests. It's very intermittent. It runs fine for awhile, then seemingly without warning, it just hangs. Users attempting to log on get stuck at the Setting server port dialog, which eventually times out. Other users who are already logged who try to pull up a ticket get stuck at a blank screen that never comes back. To resolve the issue, they have to bounce the Remedy server service. The system works for awhile...until it hangs up again. Any ideas what might be causing this? - I have monitored CPU utilization when this occurs, and the CPU hums along at about 3% - 5% utilization - Network utilization is flat-lined whenever this occurs (i.e., no spike) - Memory utilization appears normal - CNET bandwidth tests resolve to better than dedicated T1 performance (for what that's worth) Any thoughts are greatly appreciated. The interesting thing is, we have the same exact Remedy apps running on the same exact type of server in the same exact environment in four other locations, and those four other locations never experience any problems. Norm Remedy ARS 6.3 Microsoft SQL 2000 SP4 Microsoft Windows 2000 SP2 100% Custom Apps - No ITSM __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ Classification: UNCLASSIFIED Caveats: NONE ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Java API Question
It is probably not necessary to check beforehand if a field with the same ID doesn't exist. If it does, the create function should fail and throw an exception (most likely ARERR 407, Duplicate field or VUI-ID in the definition), which your program then might catch and handle somehow. Regards, Thilo Stapff Phil Murnane wrote: I'm using the 7.1 Java API to create a new field on a form. Be All: I'm using the 7.1 Java API to create a new field on a form. Before creating the field, I'd like to make sure a field with the same Field ID does not already exist. I found the isPresent() method of the Field object in the javadocs, but since a generic Field cannot be instantiated (must use CharacterField or IntegerField, etc), how do I use isPresent() to check for any type existing field with a given Field ID? Do I have to first check for an AttachmentField, then check for an AttachmentPoolField, then check for a CharacterField, etc? Sorry if this is a dumb question -- I'm new at this OO programming stuff. TIA, --Phil ___ 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
API to Create Remedy Objects
I've been wondering, based on an earlier post, why you would used the Remedy API to create Remedy objects such as forms, fields, alinks, etc? Maybe some users could share me what they have built using the API in this manner. Thank you Frank ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Java API Question
Phil, I think your looking in the wrong class... com.bmc.arsys.api.ARServerUser.getField(String form, int fieldId) In this case I think you want the getField to throw an com.bmc.arsys.api.ARException ( if object is not loaded) then you add the field you want in the catch block. :) 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 Mon, Nov 24, 2008 at 12:12 PM, Phil Murnane [EMAIL PROTECTED] wrote: I'm using the 7.1 Java API to create a new field on a form. Be All: I'm using the 7.1 Java API to create a new field on a form. Before creating the field, I'd like to make sure a field with the same Field ID does not already exist. I found the isPresent() method of the Field object in the javadocs, but since a generic Field cannot be instantiated (must use CharacterField or IntegerField, etc), how do I use isPresent() to check for any type existing field with a given Field ID? Do I have to first check for an AttachmentField, then check for an AttachmentPoolField, then check for a CharacterField, etc? Sorry if this is a dumb question -- I'm new at this OO programming stuff. TIA, --Phil ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Java API Question
If you would like to get a list of existing Field ID's on a form you want to look to your ARServerUser object and use the method getListField. You would want to use the form and the constant Constants.AR_FIELD_TYPE_ALL leaving the 3rd parameter either non existent, or set it to 0 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Phil Murnane Sent: Monday, November 24, 2008 10:12 AM To: arslist@ARSLIST.ORG Subject: Java API Question I'm using the 7.1 Java API to create a new field on a form. Be All: I'm using the 7.1 Java API to create a new field on a form. Before creating the field, I'd like to make sure a field with the same Field ID does not already exist. I found the isPresent() method of the Field object in the javadocs, but since a generic Field cannot be instantiated (must use CharacterField or IntegerField, etc), how do I use isPresent() to check for any type existing field with a given Field ID? Do I have to first check for an AttachmentField, then check for an AttachmentPoolField, then check for a CharacterField, etc? Sorry if this is a dumb question -- I'm new at this OO programming stuff. TIA, --Phil ___ 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: Intermittent, Spotty ARS Performance
Haven't tried logging on; however, when this happened last I coincidentally had the Admin tool already opened, so I poked around and was able to open objects (ALs, forms, etc.) without a problem. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Martin, Conny Sent: Monday, November 24, 2008 11:19 AM To: arslist@ARSLIST.ORG Subject: AW: Intermittent, Spotty ARS Performance ** Hi Norm, Can you log on with Remedy Administrator while the server ist not responding? Kind Regards Conny Von: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Im Auftrag von LJ Longwing Gesendet: Montag, 24. November 2008 18:15 An: arslist@ARSLIST.ORG Betreff: Re: Intermittent, Spotty ARS Performance ** I'm assuming there are no messages going into the arerror.log or anything like that? How about the armonitor.log? Try turning on Thread logging (very small output) and see if you can see anything happening with threads at the time it hangs. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE Sent: Monday, November 24, 2008 10:03 AM To: arslist@ARSLIST.ORG Subject: Intermittent, Spotty ARS Performance ** Hi everyone: This problem has me perplexed. At a site I support, the Remedy server inexplicably stops responding to requests. It's very intermittent. It runs fine for awhile, then seemingly without warning, it just hangs. Users attempting to log on get stuck at the Setting server port dialog, which eventually times out. Other users who are already logged who try to pull up a ticket get stuck at a blank screen that never comes back. To resolve the issue, they have to bounce the Remedy server service. The system works for awhile...until it hangs up again. Any ideas what might be causing this? - I have monitored CPU utilization when this occurs, and the CPU hums along at about 3% - 5% utilization - Network utilization is flat-lined whenever this occurs (i.e., no spike) - Memory utilization appears normal - CNET bandwidth tests resolve to better than dedicated T1 performance (for what that's worth) Any thoughts are greatly appreciated. The interesting thing is, we have the same exact Remedy apps running on the same exact type of server in the same exact environment in four other locations, and those four other locations never experience any problems. Norm Remedy ARS 6.3 Microsoft SQL 2000 SP4 Microsoft Windows 2000 SP2 100% Custom Apps - No ITSM __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: Intermittent, Spotty ARS Performance (UNCLASSIFIED)
Yes, that's my suspicion. I have a big suspicion that people are searching the worklog diary field. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Michaud, Christopher W Mr CTR USA MEDCOM USAMITC Sent: Monday, November 24, 2008 11:20 AM To: arslist@ARSLIST.ORG Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED) Classification: UNCLASSIFIED Caveats: NONE Norm, You may want to look closer at the SQL side. Look for locks. Perhaps someone querying a diary or un-indexed field. Also, are you using SQL replication? In particular, are snapshots turned on? Christopher Michaud -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE Sent: Monday, November 24, 2008 11:03 AM To: arslist@ARSLIST.ORG Subject: Intermittent, Spotty ARS Performance ** Hi everyone: This problem has me perplexed. At a site I support, the Remedy server inexplicably stops responding to requests. It's very intermittent. It runs fine for awhile, then seemingly without warning, it just hangs. Users attempting to log on get stuck at the Setting server port dialog, which eventually times out. Other users who are already logged who try to pull up a ticket get stuck at a blank screen that never comes back. To resolve the issue, they have to bounce the Remedy server service. The system works for awhile...until it hangs up again. Any ideas what might be causing this? - I have monitored CPU utilization when this occurs, and the CPU hums along at about 3% - 5% utilization - Network utilization is flat-lined whenever this occurs (i.e., no spike) - Memory utilization appears normal - CNET bandwidth tests resolve to better than dedicated T1 performance (for what that's worth) Any thoughts are greatly appreciated. The interesting thing is, we have the same exact Remedy apps running on the same exact type of server in the same exact environment in four other locations, and those four other locations never experience any problems. Norm Remedy ARS 6.3 Microsoft SQL 2000 SP4 Microsoft Windows 2000 SP2 100% Custom Apps - No ITSM __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ Classification: UNCLASSIFIED Caveats: NONE ___ 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
Resolved: Java API Question
Thanks, everyone, for your suggestions. I think I'll go with trapping the error off a getField() call. Thanks Again, --Phil - Original Message From: LJ Longwing [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, November 24, 2008 10:54:27 AM Subject: Re: Java API Question If you would like to get a list of existing Field ID's on a form you want to look to your ARServerUser object and use the method getListField. You would want to use the form and the constant Constants.AR_FIELD_TYPE_ALL leaving the 3rd parameter either non existent, or set it to 0 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Phil Murnane Sent: Monday, November 24, 2008 10:12 AM To: arslist@ARSLIST.ORG Subject: Java API Question I'm using the 7.1 Java API to create a new field on a form. Be All: I'm using the 7.1 Java API to create a new field on a form. Before creating the field, I'd like to make sure a field with the same Field ID does not already exist. I found the isPresent() method of the Field object in the javadocs, but since a generic Field cannot be instantiated (must use CharacterField or IntegerField, etc), how do I use isPresent() to check for any type existing field with a given Field ID? Do I have to first check for an AttachmentField, then check for an AttachmentPoolField, then check for a CharacterField, etc? Sorry if this is a dumb question -- I'm new at this OO programming stuff. TIA, --Phil ___ 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: API to Create Remedy Objects
Frank: In my case, I need to add the same set of fields to all non-audit regular forms, which would be rather tedious via the Admin Tool in a fully loaded ITSM7 server. :) I've also used Java API to add many forms to a single Filter or Active Link, to set Auditing up a certain way on many forms ( on many fields). Basically it's handy whenever you want to do the same thing over over. FWIW, --Phil From: Frank Caruso [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, November 24, 2008 10:44:18 AM Subject: API to Create Remedy Objects ** I've been wondering, based on an earlier post, why you would used the Remedy API to create Remedy objects such as forms, fields, alinks, etc? Maybe some users could share me what they have built using the API in this manner. Thank you Frank __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
SRM - Customize DVF in main window
Hello everyone, Has anyone managed to manipulate the DVF that contains the main window and service catalogue funcionality in BMC Remedy SRM? Anyone would be so gentle to provide some guidance on where to find the java code in order to hide or disable the ADD TO CART button? DVF functionality is powerful but it leaves you in very bad shape if you are not familiar with external programming languages, needless to say it is kind of odd that one cannot easily customize the application and it is an AR System based application, you expect to have direct full control of objects and workflow via Remedy Administrator. Thank you, BR, -Mauricio ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Hornsby, Tambre L is out of the office.
I will be out of the office starting 11/24/2008 and will not return until 12/01/2008. I will respond to your message when I return. If this is an urgent matter please call the Help Desk at 828-2227. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Can’t resize form view SOLVED
I was wrong. It wasn't a hidden field. But it was Display as Text which explains why I couldn't see it in the Admin tool Dwayne Martin James Madison University ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ---BeginMessage--- Thanks, Fred, When I read your letter my first reaction was, Come now, the User tool doesn't expand to display all the fields. I have fields off to the right of the display on all my forms. BUT it turns out that a Dialog window DOES expand to include all the fields (at least in the User tool, but apparently not in Mid-Tier). I had a display-only, hidden character field with no label that I couldn't even see in the Admin tool. I got rid of it, and now the views display normally. Thank you too, David, for your suggestion. Gratefully yours, Dwayne Original message Date: Fri, 21 Nov 2008 15:28:14 -0600 From: Grooms, Frederick W [EMAIL PROTECTED] Subject: Re: Can’t resize form view To: arslist@ARSLIST.ORG Are there any fields at the right edge of those specific views? I seem to remember the User tool automatically expanding a view when there were fields to display. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin Sent: Friday, November 21, 2008 3:26 PM To: arslist@ARSLIST.ORG Subject: Can’t resize form view Dear List, We have a Display-Only, Standard form that we use for dialogs. It has several views, most of which appear normally in the User tool. But two of the views (one is a copy of the other) are elongated horizontally. And no matter how often we re-size them in the Admin tool, they stay elongated in the User tool. But they display properly in Mid-Tier. After editing, we save our view before opening a new view, and when we close the form and re-display it, the views show their new size in the Admin tool, but not in the User tool. I cleared out the cache on my own computer, and displayed the views on a virgin computer that had never had Remedy installed on it before, but they still appear elongated. What am I missing? Dwayne Martin James Madison University (ARS, User and Admin tool 7.1 patch 3, RH Linux server, Oracle 10.2 db) ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ---End Message---
Re: API to Create Remedy Objects
And... You can walk existing objects to make sure permissions, labels, field DB names, help text match for a given field ID too. For all the same reasons you would write any program... you might want to automate, simplify, document, log, track, anything done to develop your ARS applications. I have even spent sometime on a program to move objects from an ARS Development server to Production. You know, so I can get some sleep at night. :) And not have to use the monster, or spend the money on that thing they call Migrator. -- 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 Mon, Nov 24, 2008 at 1:10 PM, Phil Murnane [EMAIL PROTECTED] wrote: ** Frank: In my case, I need to add the same set of fields to all non-audit regular forms, which would be rather tedious via the Admin Tool in a fully loaded ITSM7 server. :) I've also used Java API to add many forms to a single Filter or Active Link, to set Auditing up a certain way on many forms ( on many fields). Basically it's handy whenever you want to do the same thing over over. FWIW, --Phil From: Frank Caruso [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, November 24, 2008 10:44:18 AM Subject: API to Create Remedy Objects ** I've been wondering, based on an earlier post, why you would used the Remedy API to create Remedy objects such as forms, fields, alinks, etc? Maybe some users could share me what they have built using the API in this manner. Thank you Frank ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: SQL Reporing Services - making sense of Remedy Table structure
Welcome to the joy of reporting from Remedy :- There is database documentation, IMHO its as good as some m/soft documentation l have found. If anyone understands it please let me know! Well done for using the tables, the OBDC link that is supplied is unless to say the least, in particular for advance reporting esp enterprise reporting. Some banana skins, to be aware of Date fields are epoch dates e.g. number of seconds after 01/01/1970 00:00:00 this can be solved using TSQL functions. On the forms you will see a pull down list, the values stored in the field, are a numeric value. However you can use a function, to look up the value. I have TSQL functions for the above done in SQL 2005 if you want. Some of the look up values between the tables are not obvious to the say the least, the HPD_Help_Desk form and the SLA form springs to mind. I do not have the details to hand at the moment as I'm at home. This is particular ITSM, where a number of the relationships as based on GUID number's. I'm sure its in the system somewhere however l have not found it yet. Nor does there seem to be any central point of information, be that website or document. When a form is created, a corresponding view with the same name is created. So you will find a view called HPD_Help_Desk, which corresponds to the form of the same name. From what l can see of your reporting requirements, l agree with Matthew Gayford. My job is reporting, at the moment l report from 3 versions of Remedy. As l say to date whilst l have resolved a number of challenges, there are gaps in my knowledge which l would like to plug. We also looking to use SSRS as some point future to provide report for our customers. Regards Robert French -- View this message in context: http://www.nabble.com/SQL-Reporing-Services---making-sense-of-Remedy-Table-structure-tp20626113p20668739.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
Searching Diaries WAS: Intermittent, Spotty ARS Performance
OK, I'm pretty confident the problem was being caused by users constantly searching the worklog diary field on a form with 200,000+ tickets. I was able to reproduce the behavior multiple times by doing a diary search myself. So...that leads me to wonder, how do the rest of the ARSListers handle diary searches? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Michaud, Christopher W Mr CTR USA MEDCOM USAMITC Sent: Monday, November 24, 2008 11:20 AM To: arslist@ARSLIST.ORG Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED) Classification: UNCLASSIFIED Caveats: NONE Norm, You may want to look closer at the SQL side. Look for locks. Perhaps someone querying a diary or un-indexed field. Also, are you using SQL replication? In particular, are snapshots turned on? Christopher Michaud -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE Sent: Monday, November 24, 2008 11:03 AM To: arslist@ARSLIST.ORG Subject: Intermittent, Spotty ARS Performance ** Hi everyone: This problem has me perplexed. At a site I support, the Remedy server inexplicably stops responding to requests. It's very intermittent. It runs fine for awhile, then seemingly without warning, it just hangs. Users attempting to log on get stuck at the Setting server port dialog, which eventually times out. Other users who are already logged who try to pull up a ticket get stuck at a blank screen that never comes back. To resolve the issue, they have to bounce the Remedy server service. The system works for awhile...until it hangs up again. Any ideas what might be causing this? - I have monitored CPU utilization when this occurs, and the CPU hums along at about 3% - 5% utilization - Network utilization is flat-lined whenever this occurs (i.e., no spike) - Memory utilization appears normal - CNET bandwidth tests resolve to better than dedicated T1 performance (for what that's worth) Any thoughts are greatly appreciated. The interesting thing is, we have the same exact Remedy apps running on the same exact type of server in the same exact environment in four other locations, and those four other locations never experience any problems. Norm Remedy ARS 6.3 Microsoft SQL 2000 SP4 Microsoft Windows 2000 SP2 100% Custom Apps - No ITSM __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ Classification: UNCLASSIFIED Caveats: NONE ___ 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: Very Urgent: Need to show formatted worklog in report
Your question is not clear. What view and field are you looking, what value do you see in the form, and what value do you see in the table? Are you going direct to the tables, or using the OBDC link? -- View this message in context: http://www.nabble.com/Very-Urgent%3A-Need-to-show-formatted-worklog-in-report-tp20656123p20668759.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: ARS for non Trouble Ticketing applications
We have a custom application that tracks corrective actions. Gary 505-284-1481 However beautiful the strategy, you should occasionally look at the results. Sir Winston Churchill From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Shellman, David Sent: Monday, November 24, 2008 8:52 AM To: arslist@ARSLIST.ORG Subject: Re: ARS for non Trouble Ticketing applications ** In addition to the Applications that Lisa noted, we also have a system that allocates Telecommunication charges to the appropriate departments. If memory serves me correctly, a long time ago Kelly Deaver put together an application that could be used to track who was dating your teenager. Dave From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of sam appecherla Sent: Friday, November 14, 2008 11:22 AM To: arslist@ARSLIST.ORG Subject: ARS for non Trouble Ticketing applications ** Hi List, Just curious to know.. Apart from using Remedy for HelpDesk, Trouble Ticketing and the kinds, what else can we do with this workflow engine for? Does anyone have a custom built product/application built on ARS apart from Trouble Ticketing kinds that you would like to share? Regards, SriSamSri Appecherla Mobile# +91 991 610 6008 __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: Searching Diaries WAS: Intermittent, Spotty ARS Performance
We prevent our users from searching the work log on production server via an active link firing on search. It's a given performance killer. They have to use the reporting server to search the work log. HTH, Rootuja _ Rootuja Ghatge Senior Application Developer CenterBeam, Inc. 30 Rio Robles San Jose, CA 95134 Direct (408) 750-0718 Fax (408) 750-0559 http://www.centerbeam.com This email may contain confidential and privileged material for the sole use of the intended recipient. Any review or distribution by others is strictly prohibited. If you are not the intended recipient please contact the sender and delete all copies. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE Sent: Monday, November 24, 2008 12:19 PM To: arslist@ARSLIST.ORG Subject: Searching Diaries WAS: Intermittent, Spotty ARS Performance OK, I'm pretty confident the problem was being caused by users constantly searching the worklog diary field on a form with 200,000+ tickets. I was able to reproduce the behavior multiple times by doing a diary search myself. So...that leads me to wonder, how do the rest of the ARSListers handle diary searches? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Michaud, Christopher W Mr CTR USA MEDCOM USAMITC Sent: Monday, November 24, 2008 11:20 AM To: arslist@ARSLIST.ORG Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED) Classification: UNCLASSIFIED Caveats: NONE Norm, You may want to look closer at the SQL side. Look for locks. Perhaps someone querying a diary or un-indexed field. Also, are you using SQL replication? In particular, are snapshots turned on? Christopher Michaud -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE Sent: Monday, November 24, 2008 11:03 AM To: arslist@ARSLIST.ORG Subject: Intermittent, Spotty ARS Performance ** Hi everyone: This problem has me perplexed. At a site I support, the Remedy server inexplicably stops responding to requests. It's very intermittent. It runs fine for awhile, then seemingly without warning, it just hangs. Users attempting to log on get stuck at the Setting server port dialog, which eventually times out. Other users who are already logged who try to pull up a ticket get stuck at a blank screen that never comes back. To resolve the issue, they have to bounce the Remedy server service. The system works for awhile...until it hangs up again. Any ideas what might be causing this? - I have monitored CPU utilization when this occurs, and the CPU hums along at about 3% - 5% utilization - Network utilization is flat-lined whenever this occurs (i.e., no spike) - Memory utilization appears normal - CNET bandwidth tests resolve to better than dedicated T1 performance (for what that's worth) Any thoughts are greatly appreciated. The interesting thing is, we have the same exact Remedy apps running on the same exact type of server in the same exact environment in four other locations, and those four other locations never experience any problems. Norm Remedy ARS 6.3 Microsoft SQL 2000 SP4 Microsoft Windows 2000 SP2 100% Custom Apps - No ITSM __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ Classification: UNCLASSIFIED Caveats: NONE ___ 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: Searching Diaries WAS: Intermittent, Spotty ARS Performance
How do you block searches done on the Advanced Query Bar? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rootuja Ghatge Sent: Monday, November 24, 2008 2:35 PM To: arslist@ARSLIST.ORG Subject: Re: Searching Diaries WAS: Intermittent, Spotty ARS Performance We prevent our users from searching the work log on production server via an active link firing on search. It's a given performance killer. They have to use the reporting server to search the work log. HTH, Rootuja _ Rootuja Ghatge Senior Application Developer CenterBeam, Inc. 30 Rio Robles San Jose, CA 95134 Direct (408) 750-0718 Fax (408) 750-0559 http://www.centerbeam.com This email may contain confidential and privileged material for the sole use of the intended recipient. Any review or distribution by others is strictly prohibited. If you are not the intended recipient please contact the sender and delete all copies. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE Sent: Monday, November 24, 2008 12:19 PM To: arslist@ARSLIST.ORG Subject: Searching Diaries WAS: Intermittent, Spotty ARS Performance OK, I'm pretty confident the problem was being caused by users constantly searching the worklog diary field on a form with 200,000+ tickets. I was able to reproduce the behavior multiple times by doing a diary search myself. So...that leads me to wonder, how do the rest of the ARSListers handle diary searches? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Michaud, Christopher W Mr CTR USA MEDCOM USAMITC Sent: Monday, November 24, 2008 11:20 AM To: arslist@ARSLIST.ORG Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED) Classification: UNCLASSIFIED Caveats: NONE Norm, You may want to look closer at the SQL side. Look for locks. Perhaps someone querying a diary or un-indexed field. Also, are you using SQL replication? In particular, are snapshots turned on? Christopher Michaud -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE Sent: Monday, November 24, 2008 11:03 AM To: arslist@ARSLIST.ORG Subject: Intermittent, Spotty ARS Performance ** Hi everyone: This problem has me perplexed. At a site I support, the Remedy server inexplicably stops responding to requests. It's very intermittent. It runs fine for awhile, then seemingly without warning, it just hangs. Users attempting to log on get stuck at the Setting server port dialog, which eventually times out. Other users who are already logged who try to pull up a ticket get stuck at a blank screen that never comes back. To resolve the issue, they have to bounce the Remedy server service. The system works for awhile...until it hangs up again. Any ideas what might be causing this? - I have monitored CPU utilization when this occurs, and the CPU hums along at about 3% - 5% utilization - Network utilization is flat-lined whenever this occurs (i.e., no spike) - Memory utilization appears normal - CNET bandwidth tests resolve to better than dedicated T1 performance (for what that's worth) Any thoughts are greatly appreciated. The interesting thing is, we have the same exact Remedy apps running on the same exact type of server in the same exact environment in four other locations, and those four other locations never experience any problems. Norm Remedy ARS 6.3 Microsoft SQL 2000 SP4 Microsoft Windows 2000 SP2 100% Custom Apps - No ITSM __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ Classification: UNCLASSIFIED Caveats: NONE ___ 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: Searching Diaries WAS: Intermittent, Spotty ARS Performance
Just turn off the advanced search option from the Form - Current View - Properties - Menu Access menu. -Matt Matthew C. Gayford Application Developer Remedy Administrator University of North Carolina Wilmington (910) 962-7177 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE Sent: Monday, November 24, 2008 3:39 PM To: arslist@ARSLIST.ORG Subject: Re: Searching Diaries WAS: Intermittent, Spotty ARS Performance How do you block searches done on the Advanced Query Bar? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rootuja Ghatge Sent: Monday, November 24, 2008 2:35 PM To: arslist@ARSLIST.ORG Subject: Re: Searching Diaries WAS: Intermittent, Spotty ARS Performance We prevent our users from searching the work log on production server via an active link firing on search. It's a given performance killer. They have to use the reporting server to search the work log. HTH, Rootuja _ Rootuja Ghatge Senior Application Developer CenterBeam, Inc. 30 Rio Robles San Jose, CA 95134 Direct (408) 750-0718 Fax (408) 750-0559 http://www.centerbeam.com This email may contain confidential and privileged material for the sole use of the intended recipient. Any review or distribution by others is strictly prohibited. If you are not the intended recipient please contact the sender and delete all copies. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE Sent: Monday, November 24, 2008 12:19 PM To: arslist@ARSLIST.ORG Subject: Searching Diaries WAS: Intermittent, Spotty ARS Performance OK, I'm pretty confident the problem was being caused by users constantly searching the worklog diary field on a form with 200,000+ tickets. I was able to reproduce the behavior multiple times by doing a diary search myself. So...that leads me to wonder, how do the rest of the ARSListers handle diary searches? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Michaud, Christopher W Mr CTR USA MEDCOM USAMITC Sent: Monday, November 24, 2008 11:20 AM To: arslist@ARSLIST.ORG Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED) Classification: UNCLASSIFIED Caveats: NONE Norm, You may want to look closer at the SQL side. Look for locks. Perhaps someone querying a diary or un-indexed field. Also, are you using SQL replication? In particular, are snapshots turned on? Christopher Michaud -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE Sent: Monday, November 24, 2008 11:03 AM To: arslist@ARSLIST.ORG Subject: Intermittent, Spotty ARS Performance ** Hi everyone: This problem has me perplexed. At a site I support, the Remedy server inexplicably stops responding to requests. It's very intermittent. It runs fine for awhile, then seemingly without warning, it just hangs. Users attempting to log on get stuck at the Setting server port dialog, which eventually times out. Other users who are already logged who try to pull up a ticket get stuck at a blank screen that never comes back. To resolve the issue, they have to bounce the Remedy server service. The system works for awhile...until it hangs up again. Any ideas what might be causing this? - I have monitored CPU utilization when this occurs, and the CPU hums along at about 3% - 5% utilization - Network utilization is flat-lined whenever this occurs (i.e., no spike) - Memory utilization appears normal - CNET bandwidth tests resolve to better than dedicated T1 performance (for what that's worth) Any thoughts are greatly appreciated. The interesting thing is, we have the same exact Remedy apps running on the same exact type of server in the same exact environment in four other locations, and those four other locations never experience any problems. Norm Remedy ARS 6.3 Microsoft SQL 2000 SP4 Microsoft Windows 2000 SP2 100% Custom Apps - No ITSM __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ Classification: UNCLASSIFIED Caveats: NONE ___ 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: Searching Diaries WAS: Intermittent, Spotty ARS Performance
No...can't do that. Thanks for the suggestion, but that won't work. Users still need to construct advanced searches. I just need to block them from skirting my AL that blocks them from searching the worklog. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Gayford, Matthew C. Sent: Monday, November 24, 2008 2:47 PM To: arslist@ARSLIST.ORG Subject: Re: Searching Diaries WAS: Intermittent, Spotty ARS Performance Just turn off the advanced search option from the Form - Current View - Properties - Menu Access menu. -Matt Matthew C. Gayford Application Developer Remedy Administrator University of North Carolina Wilmington (910) 962-7177 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE Sent: Monday, November 24, 2008 3:39 PM To: arslist@ARSLIST.ORG Subject: Re: Searching Diaries WAS: Intermittent, Spotty ARS Performance How do you block searches done on the Advanced Query Bar? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rootuja Ghatge Sent: Monday, November 24, 2008 2:35 PM To: arslist@ARSLIST.ORG Subject: Re: Searching Diaries WAS: Intermittent, Spotty ARS Performance We prevent our users from searching the work log on production server via an active link firing on search. It's a given performance killer. They have to use the reporting server to search the work log. HTH, Rootuja _ Rootuja Ghatge Senior Application Developer CenterBeam, Inc. 30 Rio Robles San Jose, CA 95134 Direct (408) 750-0718 Fax (408) 750-0559 http://www.centerbeam.com This email may contain confidential and privileged material for the sole use of the intended recipient. Any review or distribution by others is strictly prohibited. If you are not the intended recipient please contact the sender and delete all copies. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE Sent: Monday, November 24, 2008 12:19 PM To: arslist@ARSLIST.ORG Subject: Searching Diaries WAS: Intermittent, Spotty ARS Performance OK, I'm pretty confident the problem was being caused by users constantly searching the worklog diary field on a form with 200,000+ tickets. I was able to reproduce the behavior multiple times by doing a diary search myself. So...that leads me to wonder, how do the rest of the ARSListers handle diary searches? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Michaud, Christopher W Mr CTR USA MEDCOM USAMITC Sent: Monday, November 24, 2008 11:20 AM To: arslist@ARSLIST.ORG Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED) Classification: UNCLASSIFIED Caveats: NONE Norm, You may want to look closer at the SQL side. Look for locks. Perhaps someone querying a diary or un-indexed field. Also, are you using SQL replication? In particular, are snapshots turned on? Christopher Michaud -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE Sent: Monday, November 24, 2008 11:03 AM To: arslist@ARSLIST.ORG Subject: Intermittent, Spotty ARS Performance ** Hi everyone: This problem has me perplexed. At a site I support, the Remedy server inexplicably stops responding to requests. It's very intermittent. It runs fine for awhile, then seemingly without warning, it just hangs. Users attempting to log on get stuck at the Setting server port dialog, which eventually times out. Other users who are already logged who try to pull up a ticket get stuck at a blank screen that never comes back. To resolve the issue, they have to bounce the Remedy server service. The system works for awhile...until it hangs up again. Any ideas what might be causing this? - I have monitored CPU utilization when this occurs, and the CPU hums along at about 3% - 5% utilization - Network utilization is flat-lined whenever this occurs (i.e., no spike) - Memory utilization appears normal - CNET bandwidth tests resolve to better than dedicated T1 performance (for what that's worth) Any thoughts are greatly appreciated. The interesting thing is, we have the same exact Remedy apps running on the same exact type of server in the same exact environment in four other locations, and those four other locations never experience any problems. Norm Remedy ARS 6.3 Microsoft SQL 2000 SP4 Microsoft Windows 2000 SP2 100% Custom Apps - No ITSM __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ Classification: UNCLASSIFIED Caveats: NONE
Re: Searching Diaries WAS: Intermittent, Spotty ARS Performance
Well, thanks to Gary Opela (who contacted me privately), I figured it out. I just had to search the Form Action Field Search Bar for %Worklog%. That did the trick! -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Gayford, Matthew C. Sent: Monday, November 24, 2008 2:47 PM To: arslist@ARSLIST.ORG Subject: Re: Searching Diaries WAS: Intermittent, Spotty ARS Performance Just turn off the advanced search option from the Form - Current View - Properties - Menu Access menu. -Matt Matthew C. Gayford Application Developer Remedy Administrator University of North Carolina Wilmington (910) 962-7177 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE Sent: Monday, November 24, 2008 3:39 PM To: arslist@ARSLIST.ORG Subject: Re: Searching Diaries WAS: Intermittent, Spotty ARS Performance How do you block searches done on the Advanced Query Bar? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rootuja Ghatge Sent: Monday, November 24, 2008 2:35 PM To: arslist@ARSLIST.ORG Subject: Re: Searching Diaries WAS: Intermittent, Spotty ARS Performance We prevent our users from searching the work log on production server via an active link firing on search. It's a given performance killer. They have to use the reporting server to search the work log. HTH, Rootuja _ Rootuja Ghatge Senior Application Developer CenterBeam, Inc. 30 Rio Robles San Jose, CA 95134 Direct (408) 750-0718 Fax (408) 750-0559 http://www.centerbeam.com This email may contain confidential and privileged material for the sole use of the intended recipient. Any review or distribution by others is strictly prohibited. If you are not the intended recipient please contact the sender and delete all copies. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE Sent: Monday, November 24, 2008 12:19 PM To: arslist@ARSLIST.ORG Subject: Searching Diaries WAS: Intermittent, Spotty ARS Performance OK, I'm pretty confident the problem was being caused by users constantly searching the worklog diary field on a form with 200,000+ tickets. I was able to reproduce the behavior multiple times by doing a diary search myself. So...that leads me to wonder, how do the rest of the ARSListers handle diary searches? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Michaud, Christopher W Mr CTR USA MEDCOM USAMITC Sent: Monday, November 24, 2008 11:20 AM To: arslist@ARSLIST.ORG Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED) Classification: UNCLASSIFIED Caveats: NONE Norm, You may want to look closer at the SQL side. Look for locks. Perhaps someone querying a diary or un-indexed field. Also, are you using SQL replication? In particular, are snapshots turned on? Christopher Michaud -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE Sent: Monday, November 24, 2008 11:03 AM To: arslist@ARSLIST.ORG Subject: Intermittent, Spotty ARS Performance ** Hi everyone: This problem has me perplexed. At a site I support, the Remedy server inexplicably stops responding to requests. It's very intermittent. It runs fine for awhile, then seemingly without warning, it just hangs. Users attempting to log on get stuck at the Setting server port dialog, which eventually times out. Other users who are already logged who try to pull up a ticket get stuck at a blank screen that never comes back. To resolve the issue, they have to bounce the Remedy server service. The system works for awhile...until it hangs up again. Any ideas what might be causing this? - I have monitored CPU utilization when this occurs, and the CPU hums along at about 3% - 5% utilization - Network utilization is flat-lined whenever this occurs (i.e., no spike) - Memory utilization appears normal - CNET bandwidth tests resolve to better than dedicated T1 performance (for what that's worth) Any thoughts are greatly appreciated. The interesting thing is, we have the same exact Remedy apps running on the same exact type of server in the same exact environment in four other locations, and those four other locations never experience any problems. Norm Remedy ARS 6.3 Microsoft SQL 2000 SP4 Microsoft Windows 2000 SP2 100% Custom Apps - No ITSM __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ Classification: UNCLASSIFIED Caveats: NONE
Re: Searching Diaries WAS: Intermittent, Spotty ARS Performance (UNCLASSIFIED)
Classification: UNCLASSIFIED Caveats: NONE Norm, To prevent certain Advanced Query searches, you can drop the Reserved Field (1005) on the form and use and AL to inspect the value (On Search). Throw an error if the value contains the diary field name ('DIARYNAME'). This will allow you to exclude certain fields from being used and even prevent use of LIKE statements. Christopher Michaud Remedy System Administrator/Developer US Army Medical Information Technology Center (USAMITC) Core Technology Division - Systems Engineering Branch Office: 210.295.3589 DSN: 421-3589 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE Sent: Monday, November 24, 2008 2:49 PM To: arslist@ARSLIST.ORG Subject: Re: Searching Diaries WAS: Intermittent, Spotty ARS Performance No...can't do that. Thanks for the suggestion, but that won't work. Users still need to construct advanced searches. I just need to block them from skirting my AL that blocks them from searching the worklog. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Gayford, Matthew C. Sent: Monday, November 24, 2008 2:47 PM To: arslist@ARSLIST.ORG Subject: Re: Searching Diaries WAS: Intermittent, Spotty ARS Performance Just turn off the advanced search option from the Form - Current View - Properties - Menu Access menu. -Matt Matthew C. Gayford Application Developer Remedy Administrator University of North Carolina Wilmington (910) 962-7177 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE Sent: Monday, November 24, 2008 3:39 PM To: arslist@ARSLIST.ORG Subject: Re: Searching Diaries WAS: Intermittent, Spotty ARS Performance How do you block searches done on the Advanced Query Bar? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rootuja Ghatge Sent: Monday, November 24, 2008 2:35 PM To: arslist@ARSLIST.ORG Subject: Re: Searching Diaries WAS: Intermittent, Spotty ARS Performance We prevent our users from searching the work log on production server via an active link firing on search. It's a given performance killer. They have to use the reporting server to search the work log. HTH, Rootuja _ Rootuja Ghatge Senior Application Developer CenterBeam, Inc. 30 Rio Robles San Jose, CA 95134 Direct (408) 750-0718 Fax (408) 750-0559 http://www.centerbeam.com This email may contain confidential and privileged material for the sole use of the intended recipient. Any review or distribution by others is strictly prohibited. If you are not the intended recipient please contact the sender and delete all copies. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE Sent: Monday, November 24, 2008 12:19 PM To: arslist@ARSLIST.ORG Subject: Searching Diaries WAS: Intermittent, Spotty ARS Performance OK, I'm pretty confident the problem was being caused by users constantly searching the worklog diary field on a form with 200,000+ tickets. I was able to reproduce the behavior multiple times by doing a diary search myself. So...that leads me to wonder, how do the rest of the ARSListers handle diary searches? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Michaud, Christopher W Mr CTR USA MEDCOM USAMITC Sent: Monday, November 24, 2008 11:20 AM To: arslist@ARSLIST.ORG Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED) Classification: UNCLASSIFIED Caveats: NONE Norm, You may want to look closer at the SQL side. Look for locks. Perhaps someone querying a diary or un-indexed field. Also, are you using SQL replication? In particular, are snapshots turned on? Christopher Michaud -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE Sent: Monday, November 24, 2008 11:03 AM To: arslist@ARSLIST.ORG Subject: Intermittent, Spotty ARS Performance ** Hi everyone: This problem has me perplexed. At a site I support, the Remedy server inexplicably stops responding to requests. It's very intermittent. It runs fine for awhile, then seemingly without warning, it just hangs. Users attempting to log on get stuck at the Setting server port dialog, which eventually times out. Other users who are already logged who try to pull up a ticket get stuck at a blank screen that never comes back. To resolve the issue, they have to bounce the Remedy server service. The system works for awhile...until it hangs up again. Any ideas
Re: SQL Reporing Services - making sense of Remedy Table structure
One slight correction, Date/Time fields are Unix epoch of 1/1/1970. Date fields have a different epoch -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of RFrench Sent: Monday, November 24, 2008 1:08 PM To: arslist@ARSLIST.ORG Subject: Re: SQL Reporing Services - making sense of Remedy Table structure Welcome to the joy of reporting from Remedy :- There is database documentation, IMHO its as good as some m/soft documentation l have found. If anyone understands it please let me know! Well done for using the tables, the OBDC link that is supplied is unless to say the least, in particular for advance reporting esp enterprise reporting. Some banana skins, to be aware of Date fields are epoch dates e.g. number of seconds after 01/01/1970 00:00:00 this can be solved using TSQL functions. On the forms you will see a pull down list, the values stored in the field, are a numeric value. However you can use a function, to look up the value. I have TSQL functions for the above done in SQL 2005 if you want. Some of the look up values between the tables are not obvious to the say the least, the HPD_Help_Desk form and the SLA form springs to mind. I do not have the details to hand at the moment as I'm at home. This is particular ITSM, where a number of the relationships as based on GUID number's. I'm sure its in the system somewhere however l have not found it yet. Nor does there seem to be any central point of information, be that website or document. When a form is created, a corresponding view with the same name is created. So you will find a view called HPD_Help_Desk, which corresponds to the form of the same name. From what l can see of your reporting requirements, l agree with Matthew Gayford. My job is reporting, at the moment l report from 3 versions of Remedy. As l say to date whilst l have resolved a number of challenges, there are gaps in my knowledge which l would like to plug. We also looking to use SSRS as some point future to provide report for our customers. Regards Robert French -- View this message in context: http://www.nabble.com/SQL-Reporing-Services---making-sense-of-Remedy-Table-s tructure-tp20626113p20668739.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 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Is anyone running archiving in 7.x yet?
Listers, We're running AR System 7.0.1 patch 5 with ITSM patch 7 and are planning to start archiving old records in HPD:Help Desk. What effect is that going to have on all those records we have in HPD:WorkLog? Will the archived incidents pull up work logs from the original Work Log entries, or will we need to create new workflow to access them? Is 7.x smart enough to know if we archive HPD:Worklog and link archived incidents records to archived worklogs? Do we just need to try this for ourselves and see what happens? Thanks in advance for your input, Jennifer Meyer 919-754-6543 [EMAIL PROTECTED] http://its.state.nc.us ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
AIE Import Stops at 130000 Records
Hi All, I am testing the BMC Config Management integration to CMDB via AIE and am running into an issue with the application and patch exchanges. CM has ~60 applications but after importing ~13 the creation of new CMDB CIs stops. The logs show that AIE is still attempting to create CIs but that these fail because the CMDB Name field is being set to null. The application exchange is running in its own AIE instance and has 12 threads allocated. Could I be hitting a fundamental AIE process memory limit on Windows? Has anyone else seen this issue? Cheers Peter ARS 7.01 Patch 3 CMDB 2.01 Patch 7 AIE 7.1 Patch 4 Windows 2003 Server SQLServer 2005 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: SQL Reporing Services - making sense of Remedy Table structure
Curious what is it then ? -- View this message in context: http://www.nabble.com/SQL-Reporing-Services---making-sense-of-Remedy-Table-structure-tp20626113p20670813.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: SQL Reporing Services - making sense of Remedy Table structure
January 1, 4713, BC. Jennifer Meyer -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of RFrench Sent: Monday, November 24, 2008 5:03 PM To: arslist@ARSLIST.ORG Subject: Re: SQL Reporing Services - making sense of Remedy Table structure Curious what is it then ? -- View this message in context: http://www.nabble.com/SQL-Reporing-Services---making-sense-of-Remedy-Table-structure-tp20626113p20670813.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 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
DSL Data Update Rant
Hi, rant I thought DSL stood for Definitive Software Library. Why, then, when I update to DSL patch 9 from patch 8 do I get errors because some manufacturer names have changed and more errors because some software product names have changed? It seems that 'definitive' means 'definitive until we change it' to the DSL data suppliers. Also, why, when I take the time to update the Tier 1-3 values in the DSL does an update then put them back to the meaningless software/application/third party value? The DSL doesn't impress me much! \rant Cheers Peter ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Searching Diaries WAS: Intermittent, Spotty ARS Performance
Norm: You'll have to pardon me because I'm not an actual Remedy developer, but I do work with our Remedy system every day as a tester, so while I can't give you an answer in nice Remedy developerese (and I may in fact say something completely nonsensical), I hope I can make enough sense for you to understand what I mean. I realize you've gotten an answer for your immediate question of excluding the Diary field from the Advanced Search Bar, but if you still want to know how we handle diary searches, we have separate forms on the same server for querying ticket data. There are some queries our users can't currently run and would like to (such as how many tickets exist in the system for asset XYZ) and some fields that are difficult to extract data from on our existing form (of which Worklog is one) and so we send the Worklog entries to a separate diary field (I'm not 100% certain if that's the right control type, but I think it is) called Worklog for Reporting (WL4R) each time the Worklog gets updated. Then we let folks query the WL4R via this other form when they want to run a search or create a report, and we also limit who can access the searchable/queryable form to people with some sort of leadership role on a team, such as a Tech Lead, Team Lead, or Ops Lead. We have a new form in the works that references data by its SQL name that will allow some very cool data to be extracted compared to what our users can currently get (such as the previously mentioned how many tickets exist in the system for asset XYZ) but we haven't pushed that to Production yet. So, if your users start screaming now that you've nixed their ability to search the Worklog and you're of a mind to figure out an alternate way to let them do that, that's how we do it. And speaking as a former tech in the field and user of our Remedy system, I can vouch that when I saw a problem I knew I'd seen before but had forgotten which customer had it or when I worked on it, my first thought was something along the lines of, Gee, this is that goofy Outlook problem involving recurring appointments...now how did I resolve that last time? And if guys like you give the average tech in the field the ability to search the place they entered the detail about the problem and its solution for a term like recurring appointment and get a hit that lets them quickly and easily get back to the end user with a solution, that makes the tech a hero in the end user's eyes and you a hero in the tech's. So everybody wins. For whatever that's worth... ;] Natalie Stroud Remedy/ESS Tester Science Applications International Corporation (SAIC), contractor to Sandia National Labs Albuquerque, NM (505)844-7983 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Remedy 7.1 Patch 003 SQL ??? Windows Server 2003 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE Sent: Monday, November 24, 2008 1:19 PM To: arslist@ARSLIST.ORG Subject: Searching Diaries WAS: Intermittent, Spotty ARS Performance OK, I'm pretty confident the problem was being caused by users constantly searching the worklog diary field on a form with 200,000+ tickets. I was able to reproduce the behavior multiple times by doing a diary search myself. So...that leads me to wonder, how do the rest of the ARSListers handle diary searches? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Michaud, Christopher W Mr CTR USA MEDCOM USAMITC Sent: Monday, November 24, 2008 11:20 AM To: arslist@ARSLIST.ORG Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED) Classification: UNCLASSIFIED Caveats: NONE Norm, You may want to look closer at the SQL side. Look for locks. Perhaps someone querying a diary or un-indexed field. Also, are you using SQL replication? In particular, are snapshots turned on? Christopher Michaud -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE Sent: Monday, November 24, 2008 11:03 AM To: arslist@ARSLIST.ORG Subject: Intermittent, Spotty ARS Performance ** Hi everyone: This problem has me perplexed. At a site I support, the Remedy server inexplicably stops responding to requests. It's very intermittent. It runs fine for awhile, then seemingly without warning, it just hangs. Users attempting to log on get stuck at the Setting server port dialog, which eventually times out. Other users who are already logged who try to pull up a ticket get stuck at a blank screen that never comes back. To resolve the issue, they have to bounce the Remedy server service. The system works for awhile...until it hangs up again. Any ideas what might be causing this? - I have monitored CPU utilization when this occurs, and the CPU
Remedy 4.0 or 4.5
Hi Everyone, Does anyone know where I can get the files for v4.0 or v4.5? I especially need the cleint tools - licensing tool. We need to move a legacy system to a new location. ARListening ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
libumem - performance increase on Solaris with ITSM 7.X
Hello arslist: We have been utilizing ARS 7.1 Patch 004 with ITSM 7.0.2 (latest patch for Incident, Change, Config, and Problem) on a multi-CPU, high end Solaris box running DB2. We have had SIGNIFICANT performance issues under high load running this configuration as a result of our load testing exercise. However, after meeting with Remedy engineers yesterday, they suggested that we replace the standard Solaris memory manager with a preloaded libumem memory manager. This has produced astonishing results and has resolved our issue of performance under high load with the fact that libumem uses a different memory allocation model that is more condusive to multi-cpu, multi-threaded applications. My question to the list is this. Have any of you replaced your memory manager in production with libumem and , if so, were there any side affects of doing so? Thanks for any feedback Terry ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: SQL Reporing Services - making sense of Remedy Table structure
Thanks for that, for me personally speaking it raises another issue where %*% is all this information. I have only been in my role for about 8 months, l have reached the conculsion that l am missing something. There is obviously plenty of information and experience regarding the backend database, and some other issue, but finding it is another issue althogher. My experience so far, is find one bit of information here then another bit somewhere else, yet very little is documented, in any meaning form. Sorry for the rant Remedy is an excellent product however even in my short experience there are things missing. Not least of all documenation. Guess now l have managed to start posting l might be asking some more questions =) -- View this message in context: http://www.nabble.com/SQL-Reporing-Services---making-sense-of-Remedy-Table-structure-tp20626113p20672036.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: AIE Import Stops at 130000 Records
Peter, One AIE instance can use up to 2GB of memory -- if it exceeds that, it will crash. Each active Data mapping used on a single AIE instance splits the 2GB evenly. So 2 data mappings on 1 instance will allow each data mapping 1GB when it runs. In each data mapping, one key field mapping uses 1.2kb times the number of records in your AR target form. Obviously, additional keys will increase the memory used. Is there legitimate data in the source that contains the 'Name' field -- any possibility it's Null and thus returning Null? Generally, I've found that if there is a process memory limit, AIE will crash and the process will no longer be running... At all. If AIE is running and the exchange is pulling data, I've found that the source data is usually the culprit when there is a problem -- especially when the majority of items are coming through correctly. HTH, Janie -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Peter Romain Sent: Monday, November 24, 2008 2:01 PM To: arslist@ARSLIST.ORG Subject: AIE Import Stops at 13 Records Hi All, I am testing the BMC Config Management integration to CMDB via AIE and am running into an issue with the application and patch exchanges. CM has ~60 applications but after importing ~13 the creation of new CMDB CIs stops. The logs show that AIE is still attempting to create CIs but that these fail because the CMDB Name field is being set to null. The application exchange is running in its own AIE instance and has 12 threads allocated. Could I be hitting a fundamental AIE process memory limit on Windows? Has anyone else seen this issue? Cheers Peter ARS 7.01 Patch 3 CMDB 2.01 Patch 7 AIE 7.1 Patch 4 Windows 2003 Server SQLServer 2005 ___ 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: Remedy 4.0 or 4.5
Veanna, These are old versions - more than 3 major versions old, so will no longer be available for download from the Remedy website. Remedy support, supports upto 3 major releases so currently will support only upto 6.0 and in a few months upto 6.3 after 7.5 is released. Your best chances are trying to source them from your old backups of software. I think I have those two versions at home but am at home away from home at the moment in Connecticut and wont return to New Jersey where I currently reside till Thursday. If you can wait that long, I can look them up for you. I have the files necesasry for windows. Not sure if I have unix installers backed up to CD. Joe From: Veanna Carr [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, November 24, 2008 6:06:52 PM Subject: Remedy 4.0 or 4.5 ** Hi Everyone, Does anyone know where I can get the files for v4.0 or v4.5? I especially need the cleint tools - licensing tool. We need to move a legacy system to a new location. ARListening ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: AIE Import Stops at 130000 Records
Peter, I highly doubt that. With my experience with AIE, this often happens when your import options on AIE are not correctly set. Could you take a snapshot of your import options (I forget the exact name of that tab) and send them across? I'll review them later this evening when time permits and let you know if I spot something. Joe From: Peter Romain [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, November 24, 2008 5:01:11 PM Subject: AIE Import Stops at 13 Records Hi All, I am testing the BMC Config Management integration to CMDB via AIE and am running into an issue with the application and patch exchanges. CM has ~60 applications but after importing ~13 the creation of new CMDB CIs stops. The logs show that AIE is still attempting to create CIs but that these fail because the CMDB Name field is being set to null. The application exchange is running in its own AIE instance and has 12 threads allocated. Could I be hitting a fundamental AIE process memory limit on Windows? Has anyone else seen this issue? Cheers Peter ARS 7.01 Patch 3 CMDB 2.01 Patch 7 AIE 7.1 Patch 4 Windows 2003 Server SQLServer 2005 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: DSL Data Update Rant
On the very early release of DSL, there were bugs that needed to be fixed manually (delete a record) before applying a patch.. Did you do that? Joe From: Peter Romain [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, November 24, 2008 5:13:39 PM Subject: DSL Data Update Rant Hi, rant I thought DSL stood for Definitive Software Library. Why, then, when I update to DSL patch 9 from patch 8 do I get errors because some manufacturer names have changed and more errors because some software product names have changed? It seems that 'definitive' means 'definitive until we change it' to the DSL data suppliers. Also, why, when I take the time to update the Tier 1-3 values in the DSL does an update then put them back to the meaningless software/application/third party value? The DSL doesn't impress me much! \rant Cheers Peter ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: libumem - performance increase on Solaris with ITSM 7.X
Hi Terry, We have libumem on our production system(all custom remedy apps..no ITSM)..but here's the deal..if you dont specify the Number of results returnedthere is possibility that arserverd will crash. We have tested this on couple of different machines with same configurations. However, if you set Number of records returned to 3000, it works fine. We had an escalation scanning 40 million records that crashed arserverd in less than 4 minutes even though we were on libumem. Although it was bad code, instead of throwing any errors, it just crashed. Another issue was with form which had 2 million records and Results List had more than 15 fields. This also crashed server on Search. We are on Solaris 5.10. Try the above scenarios. It might also be related to Hardware and all those fuzzy CPU utilization..but I am not sure..all I saw from remedy side was that it got crashed. Thanks Chintan. --- On Mon, 11/24/08, Terry Bootsma [EMAIL PROTECTED] wrote: From: Terry Bootsma [EMAIL PROTECTED] Subject: libumem - performance increase on Solaris with ITSM 7.X To: arslist@ARSLIST.ORG Date: Monday, November 24, 2008, 3:08 PM Hello arslist: We have been utilizing ARS 7.1 Patch 004 with ITSM 7.0.2 (latest patch for Incident, Change, Config, and Problem) on a multi-CPU, high end Solaris box running DB2. We have had SIGNIFICANT performance issues under high load running this configuration as a result of our load testing exercise. However, after meeting with Remedy engineers yesterday, they suggested that we replace the standard Solaris memory manager with a preloaded libumem memory manager. This has produced astonishing results and has resolved our issue of performance under high load with the fact that libumem uses a different memory allocation model that is more condusive to multi-cpu, multi-threaded applications. My question to the list is this. Have any of you replaced your memory manager in production with libumem and , if so, were there any side affects of doing so? Thanks for any feedback Terry ___ 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: Remedy 4.0 or 4.5
Hi Joe, Thanks for responding. We have the ARSystem install, but not the client tools install. We need the licensing tool, or the knowledge of how it was done back then. BMC has been helpful and gave us a 5.1 licensing tool, it's supposed to be compatible, but we're getting an ARERR 91 RPC procedure unavailable. Which makes me think it's a different way of licensing. We can wait until Thursday. I have the new machine installed and we're testing it. We had planned to move it tomorrow, but we'll wait until Monday. Veanna --- On Mon, 11/24/08, Joe DeSouza [EMAIL PROTECTED] wrote: From: Joe DeSouza [EMAIL PROTECTED] Subject: Re: Remedy 4.0 or 4.5 To: arslist@ARSLIST.ORG Date: Monday, November 24, 2008, 5:33 PM ** Veanna, These are old versions - more than 3 major versions old, so will no longer be available for download from the Remedy website. Remedy support, supports upto 3 major releases so currently will support only upto 6.0 and in a few months upto 6.3 after 7.5 is released. Your best chances are trying to source them from your old backups of software. I think I have those two versions at home but am at home away from home at the moment in Connecticut and wont return to New Jersey where I currently reside till Thursday. If you can wait that long, I can look them up for you. I have the files necesasry for windows. Not sure if I have unix installers backed up to CD. Joe From: Veanna Carr [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, November 24, 2008 6:06:52 PM Subject: Remedy 4.0 or 4.5 ** Hi Everyone, Does anyone know where I can get the files for v4.0 or v4.5? I especially need the cleint tools - licensing tool. We need to move a legacy system to a new location. ARListening __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: Remedy 4.0 or 4.5
The licensing tool was changed in 5 since it became part of the admin tool. -Original Message- From: Veanna Carr [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Mon, 24 Nov 2008 7:18 pm Subject: Re: Remedy 4.0 or 4.5 ** Hi Joe, ? Thanks for responding.? We have the ARSystem install, but not the client tools install.? We need the licensing tool, or the knowledge of how it was done back then.? BMC has been helpful and gave us a 5.1 licensing tool, it's supposed to be compatible, but we're getting an ARERR 91 RPC procedure unavailable.? Which makes me think it's a different way of licensing.? ? We can wait until Thursday.? I have the new machine installed and we're testing it.? We had planned to move it tomorrow, but we'll wait until Monday.? ? Veanna --- On Mon, 11/24/08, Joe DeSouza [EMAIL PROTECTED] wrote: From: Joe DeSouza [EMAIL PROTECTED] Subject: Re: Remedy 4.0 or 4.5 To: arslist@ARSLIST.ORG Date: Monday, November 24, 2008, 5:33 PM ** Veanna, ? These are old versions - more than 3 major versions old, so will no longer be available for download from the Remedy website. Remedy support, supports upto 3 major releases so currently will support only upto 6.0 and in a few months upto 6.3?after 7.5 is released. ? Your best chances are?trying to source them from your old backups of software. I think I have those two?versions at?home but?am at home away from home at the moment in Connecticut and wont return to New Jersey where I currently reside till Thursday. If you can wait that long, I can look them up for you. I have the files necesasry for windows. Not sure if I have unix installers backed up to CD. ? Joe From: Veanna Carr [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, November 24, 2008 6:06:52 PM Subject: Remedy 4.0 or 4.5 ** Hi Everyone, ? Does anyone know where I can get the files for v4.0 or v4.5? ? I especially need the cleint tools - licensing tool.? We need to move a legacy system to a new location. ? ARListening __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: Remedy 4.0 or 4.5
Hi Roger, So how did it work in 4? We have the trial licenses for moving, but don't know how to apply them. Veanna --- On Mon, 11/24/08, Roger Justice [EMAIL PROTECTED] wrote: From: Roger Justice [EMAIL PROTECTED] Subject: Re: Remedy 4.0 or 4.5 To: arslist@ARSLIST.ORG Date: Monday, November 24, 2008, 6:26 PM ** The licensing tool was changed in 5 since it became part of the admin tool. -Original Message- From: Veanna Carr [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Mon, 24 Nov 2008 7:18 pm Subject: Re: Remedy 4.0 or 4.5 ** Hi Joe, Thanks for responding. We have the ARSystem install, but not the client tools install. We need the licensing tool, or the knowledge of how it was done back then. BMC has been helpful and gave us a 5.1 licensing tool, it's supposed to be compatible, but we're getting an ARERR 91 RPC procedure unavailable. Which makes me think it's a different way of licensing. We can wait until Thursday. I have the new machine installed and we're testing it. We had planned to move it tomorrow, but we'll wait until Monday. Veanna --- On Mon, 11/24/08, Joe DeSouza [EMAIL PROTECTED] wrote: From: Joe DeSouza [EMAIL PROTECTED] Subject: Re: Remedy 4.0 or 4.5 To: arslist@ARSLIST.ORG Date: Monday, November 24, 2008, 5:33 PM ** #yiv669605538 #AOLMsgPart_2_c91177eb-7672-4b28-abdf-bf0ab178f425 #yiv1716852523 DIV {margin:0px;} Veanna, These are old versions - more than 3 major versions old, so will no longer be available for download from the Remedy website. Remedy support, supports upto 3 major releases so currently will support only upto 6.0 and in a few months upto 6.3 after 7.5 is released. Your best chances are trying to source them from your old backups of software. I think I have those two versions at home but am at home away from home at the moment in Connecticut and wont return to New Jersey where I currently reside till Thursday. If you can wait that long, I can look them up for you. I have the files necesasry for windows. Not sure if I have unix installers backed up to CD. Joe From: Veanna Carr [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, November 24, 2008 6:06:52 PM Subject: Remedy 4.0 or 4.5 ** Hi Everyone, Does anyone know where I can get the files for v4.0 or v4.5? I especially need the cleint tools - licensing tool. We need to move a legacy system to a new location. ARListening __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ Traveling over the river or through the woods this holiday season? Get the MapQuest Toolbar. Directions, Traffic, Gas Prices More! __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: Remedy 4.0 or 4.5
Veanna, There used to be a licensing tool, that had to be opened on the server. If I remember right it had too he used directly on the server and not remotely. You didn't have to log on. All you needed to do was open the tool and that tool would use the information in the ar.cfg or ar.conf file in case the license file was stored at any other place other than the default location and then interpret the contents of the file and display it within the tool. I think a version 3 tool is compatible with version 4 for licensing and as Roger pointed out the licensing structure changed in 5 so it will not support 4. Joe From: Veanna Carr [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, November 24, 2008 7:57:19 PM Subject: Re: Remedy 4.0 or 4.5 ** Hi Roger, So how did it work in 4? We have the trial licenses for moving, but don't know how to apply them. Veanna --- On Mon, 11/24/08, Roger Justice [EMAIL PROTECTED] wrote: From: Roger Justice [EMAIL PROTECTED] Subject: Re: Remedy 4.0 or 4.5 To: arslist@ARSLIST.ORG Date: Monday, November 24, 2008, 6:26 PM ** The licensing tool was changed in 5 since it became part of the admin tool. -Original Message- From: Veanna Carr [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Mon, 24 Nov 2008 7:18 pm Subject: Re: Remedy 4.0 or 4.5 ** Hi Joe, Thanks for responding. We have the ARSystem install, but not the client tools install. We need the licensing tool, or the knowledge of how it was done back then. BMC has been helpful and gave us a 5.1 licensing tool, it's supposed to be compatible, but we're getting an ARERR 91 RPC procedure unavailable. Which makes me think it's a different way of licensing. We can wait until Thursday. I have the new machine installed and we're testing it. We had planned to move it tomorrow, but we'll wait until Monday. Veanna --- On Mon, 11/24/08, Joe DeSouza [EMAIL PROTECTED] wrote: From: Joe DeSouza [EMAIL PROTECTED] Subject: Re: Remedy 4.0 or 4.5 To: arslist@ARSLIST.ORG Date: Monday, November 24, 2008, 5:33 PM ** Veanna, These are old versions - more than 3 major versions old, so will no longer be available for download from the Remedy website. Remedy support, supports upto 3 major releases so currently will support only upto 6.0 and in a few months upto 6.3 after 7.5 is released. Your best chances are trying to source them from your old backups of software. I think I have those two versions at home but am at home away from home at the moment in Connecticut and wont return to New Jersey where I currently reside till Thursday. If you can wait that long, I can look them up for you. I have the files necesasry for windows. Not sure if I have unix installers backed up to CD. Joe From: Veanna Carr [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, November 24, 2008 6:06:52 PM Subject: Remedy 4.0 or 4.5 ** Hi Everyone, Does anyone know where I can get the files for v4.0 or v4.5? I especially need the cleint tools - licensing tool. We need to move a legacy system to a new location. ARListening ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Remedy 4.0 or 4.5
Which accounts for the error message. The 4.0 has a form: Remedy Software Licence, that has the key data, same type of stuff in the licensing tool. But the fields are read only, and I don't know how to get the information into them. We are on Solaris, not windows. Any information is greatly appreciated. Veanna --- On Mon, 11/24/08, Joe DeSouza [EMAIL PROTECTED] wrote: From: Joe DeSouza [EMAIL PROTECTED] Subject: Re: Remedy 4.0 or 4.5 To: arslist@ARSLIST.ORG Date: Monday, November 24, 2008, 7:18 PM ** Veanna, There used to be a licensing tool, that had to be opened on the server. If I remember right it had too he used directly on the server and not remotely. You didn't have to log on. All you needed to do was open the tool and that tool would use the information in the ar.cfg or ar.conf file in case the license file was stored at any other place other than the default location and then interpret the contents of the file and display it within the tool. I think a version 3 tool is compatible with version 4 for licensing and as Roger pointed out the licensing structure changed in 5 so it will not support 4. Joe From: Veanna Carr [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, November 24, 2008 7:57:19 PM Subject: Re: Remedy 4.0 or 4.5 ** Hi Roger, So how did it work in 4? We have the trial licenses for moving, but don't know how to apply them. Veanna --- On Mon, 11/24/08, Roger Justice [EMAIL PROTECTED] wrote: From: Roger Justice [EMAIL PROTECTED] Subject: Re: Remedy 4.0 or 4.5 To: arslist@ARSLIST.ORG Date: Monday, November 24, 2008, 6:26 PM ** The licensing tool was changed in 5 since it became part of the admin tool. -Original Message- From: Veanna Carr [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Mon, 24 Nov 2008 7:18 pm Subject: Re: Remedy 4.0 or 4.5 ** Hi Joe, Thanks for responding. We have the ARSystem install, but not the client tools install. We need the licensing tool, or the knowledge of how it was done back then. BMC has been helpful and gave us a 5.1 licensing tool, it's supposed to be compatible, but we're getting an ARERR 91 RPC procedure unavailable. Which makes me think it's a different way of licensing. We can wait until Thursday. I have the new machine installed and we're testing it. We had planned to move it tomorrow, but we'll wait until Monday. Veanna --- On Mon, 11/24/08, Joe DeSouza [EMAIL PROTECTED] wrote: From: Joe DeSouza [EMAIL PROTECTED] Subject: Re: Remedy 4.0 or 4.5 To: arslist@ARSLIST.ORG Date: Monday, November 24, 2008, 5:33 PM ** #yiv1329960463 #yiv669605538 #AOLMsgPart_2_c91177eb-7672-4b28-abdf-bf0ab178f425 #yiv1716852523 DIV {margin:0px;} Veanna, These are old versions - more than 3 major versions old, so will no longer be available for download from the Remedy website. Remedy support, supports upto 3 major releases so currently will support only upto 6.0 and in a few months upto 6.3 after 7.5 is released. Your best chances are trying to source them from your old backups of software. I think I have those two versions at home but am at home away from home at the moment in Connecticut and wont return to New Jersey where I currently reside till Thursday. If you can wait that long, I can look them up for you. I have the files necesasry for windows. Not sure if I have unix installers backed up to CD. Joe From: Veanna Carr [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, November 24, 2008 6:06:52 PM Subject: Remedy 4.0 or 4.5 ** Hi Everyone, Does anyone know where I can get the files for v4.0 or v4.5? I especially need the cleint tools - licensing tool. We need to move a legacy system to a new location. ARListening __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: libumem - performance increase on Solaris with ITSM 7.X
When you say the Escalation was scanning 40 million records, are you saying it was processing that many records? Wasn't there a Run If condition that narrowed the set to a smaller subset? If so then that was one 'expensive' requirement to process 40 million records in an escalation. I do not think the Escalation thread can handle that many records in a single run. Escalations are usually designed to run over a much smaller subset of records and tipping over a 4 or a 5 K mark I would think is begging for some trouble in the long run. Joe From: Chintan Shah [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, November 24, 2008 6:47:47 PM Subject: Re: libumem - performance increase on Solaris with ITSM 7.X ** Hi Terry, We have libumem on our production system(all custom remedy apps..no ITSM)..but here's the deal..if you dont specify the Number of results returnedthere is possibility that arserverd will crash. We have tested this on couple of different machines with same configurations. However, if you set Number of records returned to 3000, it works fine. We had an escalation scanning 40 million records that crashed arserverd in less than 4 minutes even though we were on libumem. Although it was bad code, instead of throwing any errors, it just crashed. Another issue was with form which had 2 million records and Results List had more than 15 fields. This also crashed server on Search. We are on Solaris 5.10. Try the above scenarios. It might also be related to Hardware and all those fuzzy CPU utilization..but I am not sure..all I saw from remedy side was that it got crashed. Thanks Chintan. --- On Mon, 11/24/08, Terry Bootsma [EMAIL PROTECTED] wrote: From: Terry Bootsma [EMAIL PROTECTED] Subject: libumem - performance increase on Solaris with ITSM 7.X To: arslist@ARSLIST.ORG Date: Monday, November 24, 2008, 3:08 PM Hello arslist: We have been utilizing ARS 7.1 Patch 004 with ITSM 7.0.2 (latest patch for Incident, Change, Config, and Problem) on a multi-CPU, high end Solaris box running DB2. We have had SIGNIFICANT performance issues under high load running this configuration as a result of our load testing exercise. However, after meeting with Remedy engineers yesterday, they suggested that we replace the standard Solaris memory manager with a preloaded libumem memory manager. This has produced astonishing results and has resolved our issue of performance under high load with the fact that libumem uses a different memory allocation model that is more condusive to multi-cpu, multi-threaded applications. My question to the list is this. Have any of you replaced your memory manager in production with libumem and , if so, were there any side affects of doing so? Thanks for any feedback Terry ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Remedy 4.0 or 4.5
If I remember the 4.x days correctly, the license tool was either an xwindows thing where you had to get into your server via an x client (if your server was unix of course) and launch it that way...or if you server was windows you could just look for license.exe in the server directorywhat kind of host are these old servers on? _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Veanna Carr Sent: Monday, November 24, 2008 5:18 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy 4.0 or 4.5 ** Hi Joe, Thanks for responding. We have the ARSystem install, but not the client tools install. We need the licensing tool, or the knowledge of how it was done back then. BMC has been helpful and gave us a 5.1 licensing tool, it's supposed to be compatible, but we're getting an ARERR 91 RPC procedure unavailable. Which makes me think it's a different way of licensing. We can wait until Thursday. I have the new machine installed and we're testing it. We had planned to move it tomorrow, but we'll wait until Monday. Veanna --- On Mon, 11/24/08, Joe DeSouza [EMAIL PROTECTED] wrote: From: Joe DeSouza [EMAIL PROTECTED] Subject: Re: Remedy 4.0 or 4.5 To: arslist@ARSLIST.ORG Date: Monday, November 24, 2008, 5:33 PM ** Veanna, These are old versions - more than 3 major versions old, so will no longer be available for download from the Remedy website. Remedy support, supports upto 3 major releases so currently will support only upto 6.0 and in a few months upto 6.3 after 7.5 is released. Your best chances are trying to source them from your old backups of software. I think I have those two versions at home but am at home away from home at the moment in Connecticut and wont return to New Jersey where I currently reside till Thursday. If you can wait that long, I can look them up for you. I have the files necesasry for windows. Not sure if I have unix installers backed up to CD. Joe _ From: Veanna Carr [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, November 24, 2008 6:06:52 PM Subject: Remedy 4.0 or 4.5 ** Hi Everyone, Does anyone know where I can get the files for v4.0 or v4.5? I especially need the cleint tools - licensing tool. We need to move a legacy system to a new location. ARListening __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: SQL Reporing Services - making sense of Remedy Table structure
RFrench, You will find that the people in this forum likely have most, if not all of the information that you are looking for. If you provide the details of your environment, and what you are looking for, where you have tried, and maybe even where you looked to try to find the right informationthis forum will likely bridge the gap of your inexperience and bring you up to speed fairly quicklynow...to provide a bit of information to answer your question...even though I'm sure it's not what you meanthere you go. The information is stored mainly in the T tables, the H tables are used strictly for Status History storage (unless you have that turned off that is)...and the B tables store the binary data associated with the records in T if you happen to have attachment fields on that form. :) -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of RFrench Sent: Monday, November 24, 2008 4:12 PM To: arslist@ARSLIST.ORG Subject: Re: SQL Reporing Services - making sense of Remedy Table structure Thanks for that, for me personally speaking it raises another issue where %*% is all this information. I have only been in my role for about 8 months, l have reached the conculsion that l am missing something. There is obviously plenty of information and experience regarding the backend database, and some other issue, but finding it is another issue althogher. My experience so far, is find one bit of information here then another bit somewhere else, yet very little is documented, in any meaning form. Sorry for the rant Remedy is an excellent product however even in my short experience there are things missing. Not least of all documenation. Guess now l have managed to start posting l might be asking some more questions =) -- View this message in context: http://www.nabble.com/SQL-Reporing-Services---making-sense-of-Remedy-Table-s tructure-tp20626113p20672036.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 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Remedy 4.0 or 4.5
Veanna, 4 didn't have a form? On version 4 licenses were stored on the disk. On Solaris (any unix system for that matter) the Remedy licenses were stored in the /etc/arsystem/servername/ folder in a .lic file. This is a text file with the license stored in a particular format. What do you want to do? Add? Remove? Delete a license? You just might be able to do it bypassing the tool by doing it manually by editing this file. Its not rocket science really as the information isn't encrypted by the tool, its very much in a free text format. After doing whatever you wish to do on the licnese file, you can run the arsignal -l AR Server Name:AR TCP Portnumber. The arsignal command will be found in the bin folder of the AR Server installation folder. Its a sort of a backdoor towards doing what you might be looking to do, but I hope it helps. Joe From: Veanna Carr [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, November 24, 2008 8:25:00 PM Subject: Re: Remedy 4.0 or 4.5 ** Which accounts for the error message. The 4.0 has a form: Remedy Software Licence, that has the key data, same type of stuff in the licensing tool. But the fields are read only, and I don't know how to get the information into them. We are on Solaris, not windows. Any information is greatly appreciated. Veanna --- On Mon, 11/24/08, Joe DeSouza [EMAIL PROTECTED] wrote: From: Joe DeSouza [EMAIL PROTECTED] Subject: Re: Remedy 4.0 or 4.5 To: arslist@ARSLIST.ORG Date: Monday, November 24, 2008, 7:18 PM ** Veanna, There used to be a licensing tool, that had to be opened on the server. If I remember right it had too he used directly on the server and not remotely. You didn't have to log on. All you needed to do was open the tool and that tool would use the information in the ar.cfg or ar.conf file in case the license file was stored at any other place other than the default location and then interpret the contents of the file and display it within the tool. I think a version 3 tool is compatible with version 4 for licensing and as Roger pointed out the licensing structure changed in 5 so it will not support 4. Joe From: Veanna Carr [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, November 24, 2008 7:57:19 PM Subject: Re: Remedy 4.0 or 4.5 ** Hi Roger, So how did it work in 4? We have the trial licenses for moving, but don't know how to apply them. Veanna --- On Mon, 11/24/08, Roger Justice [EMAIL PROTECTED] wrote: From: Roger Justice [EMAIL PROTECTED] Subject: Re: Remedy 4.0 or 4.5 To: arslist@ARSLIST.ORG Date: Monday, November 24, 2008, 6:26 PM ** The licensing tool was changed in 5 since it became part of the admin tool. -Original Message- From: Veanna Carr [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Mon, 24 Nov 2008 7:18 pm Subject: Re: Remedy 4.0 or 4.5 ** Hi Joe, Thanks for responding. We have the ARSystem install, but not the client tools install. We need the licensing tool, or the knowledge of how it was done back then. BMC has been helpful and gave us a 5.1 licensing tool, it's supposed to be compatible, but we're getting an ARERR 91 RPC procedure unavailable. Which makes me think it's a different way of licensing. We can wait until Thursday. I have the new machine installed and we're testing it. We had planned to move it tomorrow, but we'll wait until Monday. Veanna --- On Mon, 11/24/08, Joe DeSouza [EMAIL PROTECTED] wrote: From: Joe DeSouza [EMAIL PROTECTED] Subject: Re: Remedy 4.0 or 4.5 To: arslist@ARSLIST.ORG Date: Monday, November 24, 2008, 5:33 PM ** Veanna, These are old versions - more than 3 major versions old, so will no longer be available for download from the Remedy website. Remedy support, supports upto 3 major releases so currently will support only upto 6.0 and in a few months upto 6.3 after 7.5 is released. Your best chances are trying to source them from your old backups of software. I think I have those two versions at home but am at home away from home at the moment in Connecticut and wont return to New Jersey where I currently reside till Thursday. If you can wait that long, I can look them up for you. I have the files necesasry for windows. Not sure if I have unix installers backed up to CD. Joe From: Veanna Carr [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, November 24, 2008 6:06:52 PM Subject: Remedy 4.0 or 4.5 ** Hi Everyone, Does anyone know where I can get the files for v4.0 or v4.5? I especially need the cleint tools - licensing tool. We need to move a legacy system to a new location. ARListening ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Remedy 4.0 or 4.5
Oh yea I nearly forgot about intializing xwindows on the terminal client if you wanted to run the license tool. That was needed to run the graphical tool. Joe From: LJ Longwing [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, November 24, 2008 8:30:43 PM Subject: Re: Remedy 4.0 or 4.5 ** If I remember the 4.x days correctly, the license tool was either an xwindows thing where you had to get into your server via an x client (if your server was unix of course) and launch it that way...or if you server was windows you could just look for license.exe in the server directorywhat kind of host are these old servers on? From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Veanna Carr Sent: Monday, November 24, 2008 5:18 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy 4.0 or 4.5 ** Hi Joe, Thanks for responding. We have the ARSystem install, but not the client tools install. We need the licensing tool, or the knowledge of how it was done back then. BMC has been helpful and gave us a 5.1 licensing tool, it's supposed to be compatible, but we're getting an ARERR 91 RPC procedure unavailable. Which makes me think it's a different way of licensing. We can wait until Thursday. I have the new machine installed and we're testing it. We had planned to move it tomorrow, but we'll wait until Monday. Veanna --- On Mon, 11/24/08, Joe DeSouza [EMAIL PROTECTED] wrote: From: Joe DeSouza [EMAIL PROTECTED] Subject: Re: Remedy 4.0 or 4.5 To: arslist@ARSLIST.ORG Date: Monday, November 24, 2008, 5:33 PM ** Veanna, These are old versions - more than 3 major versions old, so will no longer be available for download from the Remedy website. Remedy support, supports upto 3 major releases so currently will support only upto 6.0 and in a few months upto 6.3 after 7.5 is released. Your best chances are trying to source them from your old backups of software. I think I have those two versions at home but am at home away from home at the moment in Connecticut and wont return to New Jersey where I currently reside till Thursday. If you can wait that long, I can look them up for you. I have the files necesasry for windows. Not sure if I have unix installers backed up to CD. Joe From: Veanna Carr [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, November 24, 2008 6:06:52 PM Subject: Remedy 4.0 or 4.5 ** Hi Everyone, Does anyone know where I can get the files for v4.0 or v4.5? I especially need the cleint tools - licensing tool. We need to move a legacy system to a new location. ARListening ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Remedy 4.0 or 4.5
Our current server is Solaris/Unix, and the new server is Solaris/Unix. --- On Mon, 11/24/08, LJ Longwing [EMAIL PROTECTED] wrote: From: LJ Longwing [EMAIL PROTECTED] Subject: Re: Remedy 4.0 or 4.5 To: arslist@ARSLIST.ORG Date: Monday, November 24, 2008, 7:30 PM ** If I remember the 4.x days correctly, the license tool was either an xwindows thing where you had to get into your server via an x client (if your server was unix of course) and launch it that way...or if you server was windows you could just look for license.exe in the server directorywhat kind of host are these old servers on? From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Veanna Carr Sent: Monday, November 24, 2008 5:18 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy 4.0 or 4.5 ** Hi Joe, Thanks for responding. We have the ARSystem install, but not the client tools install. We need the licensing tool, or the knowledge of how it was done back then. BMC has been helpful and gave us a 5.1 licensing tool, it's supposed to be compatible, but we're getting an ARERR 91 RPC procedure unavailable. Which makes me think it's a different way of licensing. We can wait until Thursday. I have the new machine installed and we're testing it. We had planned to move it tomorrow, but we'll wait until Monday. Veanna --- On Mon, 11/24/08, Joe DeSouza [EMAIL PROTECTED] wrote: From: Joe DeSouza [EMAIL PROTECTED] Subject: Re: Remedy 4.0 or 4.5 To: arslist@ARSLIST.ORG Date: Monday, November 24, 2008, 5:33 PM ** #yiv49962921 #yiv1716852523 DIV { MARGIN:0px;} Veanna, These are old versions - more than 3 major versions old, so will no longer be available for download from the Remedy website. Remedy support, supports upto 3 major releases so currently will support only upto 6.0 and in a few months upto 6.3 after 7.5 is released. Your best chances are trying to source them from your old backups of software. I think I have those two versions at home but am at home away from home at the moment in Connecticut and wont return to New Jersey where I currently reside till Thursday. If you can wait that long, I can look them up for you. I have the files necesasry for windows. Not sure if I have unix installers backed up to CD. Joe From: Veanna Carr [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, November 24, 2008 6:06:52 PM Subject: Remedy 4.0 or 4.5 ** Hi Everyone, Does anyone know where I can get the files for v4.0 or v4.5? I especially need the cleint tools - licensing tool. We need to move a legacy system to a new location. ARListening __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: Remedy 4.0 or 4.5
I only remember it because it was the only thing in the entire world I needed exceed forand I was constantly being bugged by licensing about if I really needed the license. _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Monday, November 24, 2008 6:38 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy 4.0 or 4.5 ** Oh yea I nearly forgot about intializing xwindows on the terminal client if you wanted to run the license tool. That was needed to run the graphical tool. Joe _ From: LJ Longwing [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, November 24, 2008 8:30:43 PM Subject: Re: Remedy 4.0 or 4.5 ** If I remember the 4.x days correctly, the license tool was either an xwindows thing where you had to get into your server via an x client (if your server was unix of course) and launch it that way...or if you server was windows you could just look for license.exe in the server directorywhat kind of host are these old servers on? _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Veanna Carr Sent: Monday, November 24, 2008 5:18 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy 4.0 or 4.5 ** Hi Joe, Thanks for responding. We have the ARSystem install, but not the client tools install. We need the licensing tool, or the knowledge of how it was done back then. BMC has been helpful and gave us a 5.1 licensing tool, it's supposed to be compatible, but we're getting an ARERR 91 RPC procedure unavailable. Which makes me think it's a different way of licensing. We can wait until Thursday. I have the new machine installed and we're testing it. We had planned to move it tomorrow, but we'll wait until Monday. Veanna --- On Mon, 11/24/08, Joe DeSouza [EMAIL PROTECTED] wrote: From: Joe DeSouza [EMAIL PROTECTED] Subject: Re: Remedy 4.0 or 4.5 To: arslist@ARSLIST.ORG Date: Monday, November 24, 2008, 5:33 PM ** Veanna, These are old versions - more than 3 major versions old, so will no longer be available for download from the Remedy website. Remedy support, supports upto 3 major releases so currently will support only upto 6.0 and in a few months upto 6.3 after 7.5 is released. Your best chances are trying to source them from your old backups of software. I think I have those two versions at home but am at home away from home at the moment in Connecticut and wont return to New Jersey where I currently reside till Thursday. If you can wait that long, I can look them up for you. I have the files necesasry for windows. Not sure if I have unix installers backed up to CD. Joe _ From: Veanna Carr [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, November 24, 2008 6:06:52 PM Subject: Remedy 4.0 or 4.5 ** Hi Everyone, Does anyone know where I can get the files for v4.0 or v4.5? I especially need the cleint tools - licensing tool. We need to move a legacy system to a new location. ARListening __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: Remedy 4.0 or 4.5
Ok...look in your server bin dir and see if you have a binary named 'license'...that's the license client...but it's graphical...and can't be run from the command line...if you can get an xserver and xclient together on that box you should be able to do itor you could as suggested by another poster, just edit the arsystem.lic file _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Veanna Carr Sent: Monday, November 24, 2008 6:39 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy 4.0 or 4.5 ** Our current server is Solaris/Unix, and the new server is Solaris/Unix. --- On Mon, 11/24/08, LJ Longwing [EMAIL PROTECTED] wrote: From: LJ Longwing [EMAIL PROTECTED] Subject: Re: Remedy 4.0 or 4.5 To: arslist@ARSLIST.ORG Date: Monday, November 24, 2008, 7:30 PM ** If I remember the 4.x days correctly, the license tool was either an xwindows thing where you had to get into your server via an x client (if your server was unix of course) and launch it that way...or if you server was windows you could just look for license.exe in the server directorywhat kind of host are these old servers on? _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Veanna Carr Sent: Monday, November 24, 2008 5:18 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy 4.0 or 4.5 ** Hi Joe, Thanks for responding. We have the ARSystem install, but not the client tools install. We need the licensing tool, or the knowledge of how it was done back then. BMC has been helpful and gave us a 5.1 licensing tool, it's supposed to be compatible, but we're getting an ARERR 91 RPC procedure unavailable. Which makes me think it's a different way of licensing. We can wait until Thursday. I have the new machine installed and we're testing it. We had planned to move it tomorrow, but we'll wait until Monday. Veanna --- On Mon, 11/24/08, Joe DeSouza [EMAIL PROTECTED] wrote: From: Joe DeSouza [EMAIL PROTECTED] Subject: Re: Remedy 4.0 or 4.5 To: arslist@ARSLIST.ORG Date: Monday, November 24, 2008, 5:33 PM ** Veanna, These are old versions - more than 3 major versions old, so will no longer be available for download from the Remedy website. Remedy support, supports upto 3 major releases so currently will support only upto 6.0 and in a few months upto 6.3 after 7.5 is released. Your best chances are trying to source them from your old backups of software. I think I have those two versions at home but am at home away from home at the moment in Connecticut and wont return to New Jersey where I currently reside till Thursday. If you can wait that long, I can look them up for you. I have the files necesasry for windows. Not sure if I have unix installers backed up to CD. Joe _ From: Veanna Carr [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, November 24, 2008 6:06:52 PM Subject: Remedy 4.0 or 4.5 ** Hi Everyone, Does anyone know where I can get the files for v4.0 or v4.5? I especially need the cleint tools - licensing tool. We need to move a legacy system to a new location. ARListening __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: Remedy 4.0 or 4.5
What we want to do: Create a new server (done), move it to the new location, move the support team to the new server. Move the current production server to the new location and use as the hot backup sysytem. So both machines will need a new license. --- On Mon, 11/24/08, Joe DeSouza [EMAIL PROTECTED] wrote: From: Joe DeSouza [EMAIL PROTECTED] Subject: Re: Remedy 4.0 or 4.5 To: arslist@ARSLIST.ORG Date: Monday, November 24, 2008, 7:35 PM ** Veanna, 4 didn't have a form? On version 4 licenses were stored on the disk. On Solaris (any unix system for that matter) the Remedy licenses were stored in the /etc/arsystem/servername/ folder in a .lic file. This is a text file with the license stored in a particular format. What do you want to do? Add? Remove? Delete a license? You just might be able to do it bypassing the tool by doing it manually by editing this file. Its not rocket science really as the information isn't encrypted by the tool, its very much in a free text format. After doing whatever you wish to do on the licnese file, you can run the arsignal -l AR Server Name:AR TCP Portnumber. The arsignal command will be found in the bin folder of the AR Server installation folder. Its a sort of a backdoor towards doing what you might be looking to do, but I hope it helps. Joe From: Veanna Carr [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, November 24, 2008 8:25:00 PM Subject: Re: Remedy 4.0 or 4.5 ** Which accounts for the error message. The 4.0 has a form: Remedy Software Licence, that has the key data, same type of stuff in the licensing tool. But the fields are read only, and I don't know how to get the information into them. We are on Solaris, not windows. Any information is greatly appreciated. Veanna --- On Mon, 11/24/08, Joe DeSouza [EMAIL PROTECTED] wrote: From: Joe DeSouza [EMAIL PROTECTED] Subject: Re: Remedy 4.0 or 4.5 To: arslist@ARSLIST.ORG Date: Monday, November 24, 2008, 7:18 PM ** Veanna, There used to be a licensing tool, that had to be opened on the server. If I remember right it had too he used directly on the server and not remotely. You didn't have to log on. All you needed to do was open the tool and that tool would use the information in the ar.cfg or ar.conf file in case the license file was stored at any other place other than the default location and then interpret the contents of the file and display it within the tool. I think a version 3 tool is compatible with version 4 for licensing and as Roger pointed out the licensing structure changed in 5 so it will not support 4. Joe From: Veanna Carr [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, November 24, 2008 7:57:19 PM Subject: Re: Remedy 4.0 or 4.5 ** Hi Roger, So how did it work in 4? We have the trial licenses for moving, but don't know how to apply them. Veanna --- On Mon, 11/24/08, Roger Justice [EMAIL PROTECTED] wrote: From: Roger Justice [EMAIL PROTECTED] Subject: Re: Remedy 4.0 or 4.5 To: arslist@ARSLIST.ORG Date: Monday, November 24, 2008, 6:26 PM ** The licensing tool was changed in 5 since it became part of the admin tool. -Original Message- From: Veanna Carr [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Mon, 24 Nov 2008 7:18 pm Subject: Re: Remedy 4.0 or 4.5 ** Hi Joe, Thanks for responding. We have the ARSystem install, but not the client tools install. We need the licensing tool, or the knowledge of how it was done back then. BMC has been helpful and gave us a 5.1 licensing tool, it's supposed to be compatible, but we're getting an ARERR 91 RPC procedure unavailable. Which makes me think it's a different way of licensing. We can wait until Thursday. I have the new machine installed and we're testing it. We had planned to move it tomorrow, but we'll wait until Monday. Veanna --- On Mon, 11/24/08, Joe DeSouza [EMAIL PROTECTED] wrote: From: Joe DeSouza [EMAIL PROTECTED] Subject: Re: Remedy 4.0 or 4.5 To: arslist@ARSLIST.ORG Date: Monday, November 24, 2008, 5:33 PM ** #yiv746731253 #yiv1329960463 #yiv669605538 #AOLMsgPart_2_c91177eb-7672-4b28-abdf-bf0ab178f425 #yiv1716852523 DIV {margin:0px;} Veanna, These are old versions - more than 3 major versions old, so will no longer be available for download from the Remedy website. Remedy support, supports upto 3 major releases so currently will support only upto 6.0 and in a few months upto 6.3 after 7.5 is released. Your best chances are trying to source them from your old backups of software. I think I have those two versions at home but am at home away from home at the moment in Connecticut and wont return to New Jersey where I currently reside till Thursday. If you can wait that long, I can look them up for you. I have the files necesasry for windows. Not sure if I have unix installers backed up to CD. Joe From: Veanna Carr [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, November 24,
Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED)
Another thing could be your disk space getting full on the Remedy server. We had that issue recently when one of the operation some user would do would eventually timeout and would create a temp file on the servers Windows Temp directory that would grow and keep growing even if the user quit the user tool from the client. The disk would eventually be full and the AR Server would get extremely slow and eventually impossible to login. Bouoncing the Remedy Service would kill that temp file and release all the used space.. Joe From: Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, November 24, 2008 12:58:53 PM Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED) Yes, that's my suspicion. I have a big suspicion that people are searching the worklog diary field. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Michaud, Christopher W Mr CTRUSA MEDCOM USAMITC Sent: Monday, November 24, 2008 11:20 AM To: arslist@ARSLIST.ORG Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED) Classification: UNCLASSIFIED Caveats: NONE Norm, You may want to look closer at the SQL side. Look for locks. Perhaps someone querying a diary or un-indexed field. Also, are you using SQL replication? In particular, are snapshots turned on? Christopher Michaud -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC96 CS/SCCE Sent: Monday, November 24, 2008 11:03 AM To: arslist@ARSLIST.ORG Subject: Intermittent, Spotty ARS Performance ** Hi everyone: This problem has me perplexed. At a site I support, the Remedy server inexplicably stops responding to requests. It's very intermittent. It runs fine for awhile, then seemingly without warning, it just hangs. Users attempting to log on get stuck at the Setting server port dialog, which eventually times out. Other users who are already logged who try to pull up a ticket get stuck at a blank screen that never comes back. To resolve the issue, they have to bounce the Remedy server service. The system works for awhile...until it hangs up again. Any ideas what might be causing this? - I have monitored CPU utilization when this occurs, and the CPU hums along at about 3% - 5% utilization - Network utilization is flat-lined whenever this occurs (i.e., no spike) - Memory utilization appears normal - CNET bandwidth tests resolve to better than dedicated T1 performance (for what that's worth) Any thoughts are greatly appreciated. The interesting thing is, we have the same exact Remedy apps running on the same exact type of server in the same exact environment in four other locations, and those four other locations never experience any problems. Norm Remedy ARS 6.3 Microsoft SQL 2000 SP4 Microsoft Windows 2000 SP2 100% Custom Apps - No ITSM ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Remedy 4.0 or 4.5
Veanna, Joe and LJ are correct. The license tool is a binary that is on the server when you install the software. I used to have a SUN desktop sitting on my desk just to run the license tool on our Solaris server. Don't ask me why but I still have 4.x client and admin installs (windows versions) saved on my laptop. I have various patches. Here is what I have: 12/16/1999 03:23 PM12,220,897 arswat403.exe 08/22/2000 10:45 AM12,986,078 arswat451.exe 02/14/2001 11:55 PM13,025,648 arswat452.exe 08/04/1999 11:55 AM13,149,200 arswut402.exe 12/21/1999 12:17 PM15,625,045 arswut403.exe 08/22/2000 10:53 AM26,387,297 arswut451.exe 02/27/2001 11:19 AM26,387,511 arswut451948.exe 02/14/2001 11:54 PM26,391,499 arswut452.exe 10/19/1999 04:22 PM13,123,771 arswut4812.exe Let me know which ones you want and I will send them to you. Dave From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Veanna Carr Sent: Monday, November 24, 2008 8:56 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy 4.0 or 4.5 ** What we want to do: Create a new server (done), move it to the new location, move the support team to the new server. Move the current production server to the new location and use as the hot backup sysytem. So both machines will need a new license. --- On Mon, 11/24/08, Joe DeSouza [EMAIL PROTECTED] wrote: From: Joe DeSouza [EMAIL PROTECTED] Subject: Re: Remedy 4.0 or 4.5 To: arslist@ARSLIST.ORG Date: Monday, November 24, 2008, 7:35 PM ** Veanna, 4 didn't have a form? On version 4 licenses were stored on the disk. On Solaris (any unix system for that matter) the Remedy licenses were stored in the /etc/arsystem/servername/ folder in a .lic file. This is a text file with the license stored in a particular format. What do you want to do? Add? Remove? Delete a license? You just might be able to do it bypassing the tool by doing it manually by editing this file. Its not rocket science really as the information isn't encrypted by the tool, its very much in a free text format. After doing whatever you wish to do on the licnese file, you can run the arsignal -l AR Server Name:AR TCP Portnumber. The arsignal command will be found in the bin folder of the AR Server installation folder. Its a sort of a backdoor towards doing what you might be looking to do, but I hope it helps. Joe From: Veanna Carr [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, November 24, 2008 8:25:00 PM Subject: Re: Remedy 4.0 or 4.5 ** Which accounts for the error message. The 4.0 has a form: Remedy Software Licence, that has the key data, same type of stuff in the licensing tool. But the fields are read only, and I don't know how to get the information into them. We are on Solaris, not windows. Any information is greatly appreciated. Veanna --- On Mon, 11/24/08, Joe DeSouza [EMAIL PROTECTED] wrote: From: Joe DeSouza [EMAIL PROTECTED] Subject: Re: Remedy 4.0 or 4.5 To: arslist@ARSLIST.ORG Date: Monday, November 24, 2008, 7:18 PM ** Veanna, There used to be a licensing tool, that had to be opened on the server. If I remember right it had too he used directly on the server and not remotely. You didn't have to log on. All you needed to do was open the tool and that tool would use the information in the ar.cfg or ar.conf file in case the license file was stored at any other place other than the default location and then interpret the contents of the file and display it within the tool. I think a version 3 tool is compatible with version 4 for licensing and as Roger pointed out the licensing structure changed in 5 so it will not support 4. Joe From: Veanna Carr [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, November 24, 2008 7:57:19 PM Subject: Re: Remedy 4.0 or 4.5 ** Hi Roger, So how did it work in 4? We have the trial licenses for moving, but don't know how to apply them. Veanna --- On Mon, 11/24/08, Roger Justice [EMAIL PROTECTED] wrote: From: Roger Justice [EMAIL PROTECTED] Subject: Re: Remedy 4.0 or 4.5 To: arslist@ARSLIST.ORG Date: Monday, November 24, 2008, 6:26 PM ** The licensing tool was changed in 5 since it became part of the admin tool. -Original Message- From: Veanna Carr [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Mon, 24 Nov 2008 7:18 pm Subject: Re: Remedy 4.0 or 4.5 ** Hi Joe, Thanks for responding. We have the ARSystem install, but not the client tools install. We need the licensing tool, or the knowledge of how it was done back then. BMC has been helpful and gave us a 5.1 licensing tool, it's supposed to be compatible, but we're getting an ARERR 91 RPC procedure unavailable. Which makes me think it's a different way of licensing. We can wait until Thursday. I have the new machine installed and we're testing it. We had planned to
Re: SW00247290 - Death of the Plugin Server
ARS 7.1 Patch 002 Mid-Tier 7.1 Patch 004 CMDB 2.1 Patch 6 ITSM Patch 8 Approval Server 7.0.06 Windows Hello Listers: Please see below error: I think I have isolated this problem by starting the plugin.exe from the command line. The plugin server shows that it's up and running when I start regularly or from the command line, so I have been starting plugin.exe from the cmd line to produce the below referenced errors. I can't get the overview console, server admin console or anything for the plugin server to work on our dev server. The Server Admin Console works on prod, but not the Overview Console, which makes this even more confusing. From the home page, when selecting Overview or Server Admin Console, I keep getting ARERR [8755] The specified plug-in does not exist. : REMEDY.ARDBC.SERVER.ADMINISTRATION, and ARERR [8755] The specified plug-in does not exist. : REMEDY.ARDBC.APPQUERY. I have replaced .dlls, reinstalled arserver.exe, read logs and I can't find where this password that the approval plugin wants is coming from. I have upgraded from to ITSM 7 Unpatched to ITSM Patch 008, I have installed Approval Server 7.0.1 Patch 7. I changed the plugin timeout to 600 seconds, so the plugin bombs out after ten mins with the below every time. I can't find anything to lead me further down the path to resolution. the plugin server is up, but not being recognized. To overcome the initial error of arservdb directory does not exist, I added the directory and the .lck file it was looking for 390606.lck. Then when I ran arplugin.exe -i. -m from the command line, the plugin server went one step further to the below. Please see attached ar.cfg - Does anyone have any ideas on how to get this to work? I am obviously stumped. :-) Thanks in Advance to All. Jase K Brandon Quality Technology Services ArError.Log Mon Nov 24 22:14:46 2008 Approve : Authentication failed (ARERR 623) Mon Nov 24 22:14:46 2008 Approve : Name parameter (or name field in a parameter) is empty (ARERR 102) Mon Nov 24 22:14:46 2008 Approve : Name parameter (or name field in a parameter) is empty (ARERR 102) Mon Nov 24 22:14:46 2008 Approve : Name parameter (or name field in a parameter) is empty (ARERR 102) Mon Nov 24 22:14:46 2008 Approve : Name parameter (or name field in a parameter) is empty (ARERR 102) On Thu, Nov 20, 2008 at 7:36 PM, Joe DeSouza [EMAIL PROTECTED] wrote: ** Plugin-Filter-API-Threads: was the setting I was looking for this morning but couldn't remember.. FAIW, I got my numbers a little higher than what you got though.. something like min of 7 amd max of 15. Joe -- *From:* Jase Brandon [EMAIL PROTECTED] *To:* arslist@ARSLIST.ORG *Sent:* Thursday, November 20, 2008 12:59:23 PM *Subject:* Re: SW00247290 - Death of the Plugin Server ** here is the part that's perplexing me all, I can see in the armonitor.log that plugin.exe was started with success. I can see plugin.exe running in the task mgr, looks fine. But the server admin console keeps getting ARDBCAPPQUERY doesn't exist and the overview console keeps getting dbase timeout errors. I attached a copy of our dev ar.cfg file if anyone wants to take a peek. We reinstalled server.exe for 7.1 Patch 002 in hopes this would set arplugin.exe back to original config. After that didn't work, We have replaced .dlls for ardbcquery.dll in all the paths for asset/change/incident/cmdb with the .dlls from ITSM 7 Patch 8, We have ITSM 7 Patch 3 and support suggested those replacements, and it didn't work either. Joe mentioned the below on an old thread I found I added this line and got the plugins to work. Plugin-Filter-API-Threads: 2 6 Where 2 represents minimum threads and 6 max.. You can set your min and max to whatever you might want to set it to till you get it working.. Going to try this now in ar.cfg and see if that helps. Any ideas anyone? I am stumped.. Thanks, Jase On Thu, Nov 20, 2008 at 11:22 AM, Jase Brandon [EMAIL PROTECTED]wrote: Joe, That would be great! Can you please send me the settings you used to fix this issue? Thanks In Advance, Jase On Thu, Nov 20, 2008 at 10:39 AM, Joe DeSouza [EMAIL PROTECTED]wrote: ** It could also mean you are running out of Filter-API threads.. I forget what the option to configure that is in the ar.cfg file, but I could get you that information in about an hour from the settings I have on my server that fixed a similar error for me. Cheers Joe -- *From:* Axton [EMAIL PROTECTED] *To:* arslist@ARSLIST.ORG *Sent:* Thursday, November 20, 2008 10:16:40 AM *Subject:* Re: SW00247290 - Death of the Plugin Server This means the plugin server crashed. I either generate a core file or attach a debugger to the plugin server to see what the stack trace is when it crashed, then report the results to bmc. Not sure how/if you w/could do this on windows. The plugin server logs may be revealing as
Re: Very Urgent: Need to show formatted worklog in report
Thanks Rfrench for the response, Let me explain you in detail. I am reporting directly from Remedy DB from table itself. Now need is to show 'worklog' formated at report level: Worklog reciving from DB is : --- 1227025800 YOANN DURAND Initial Description is : Dear all, Is it possible to allocate temporary more space on this FS : Filesystem kbytes used avail capacity Mounted on nfsadd2:/add/export/stdf 667315863 619796365 44609217 94% /firms/import/stdf I create a critical ticket because I think the oncall team will be certainly impact tonight when the FS inscrease until 95% Yoann DP 1227094792 BOUDRY Managed by system team crx109 BR. 1227096348 DELSOLP Done yesterday by P. Desjouis --- Worklog need to be shown is : --- 11/19/2008 5:35:48 PM DELSOLP Done yesterday by P. Desjouis 11/19/2008 5:09:52 PM BOUDRY Managed by system team-- crx109 BR. 11/18/2008 10:00:00 PM YOANN DURAND Initial Description is : Dear all, Is it possible to allocate temporary more space on this FS : Filesystemkbytesused avail capacity Mounted on nfsadd2:/add/export/stdf 667315863 619796365 4460921794% /firms/import/stdf I create a critical ticket because I think the on-call team will be certainly impact tonight when the FS inscrease until 95% Yoann DP --- Here major emphesis is on Date field value. I hope it clearifies. Regards Manish -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of RFrench Sent: Tuesday, November 25, 2008 1:41 AM To: arslist@ARSLIST.ORG Subject: Re: Very Urgent: Need to show formatted worklog in report Your question is not clear. What view and field are you looking, what value do you see in the form, and what value do you see in the table? Are you going direct to the tables, or using the OBDC link? -- View this message in context: http://www.nabble.com/Very-Urgent%3A-Need-to-show-formatted-worklog-in-repor t-tp20656123p20668759.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 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are