Remedy 7 on AIX platform
Hello Listers, Can you share your Remedy 7.x experience on AIX platform? with or without ITSM 7 suite. How is the performance in general? What AIX OS version, RAM, CPU power you have on your AIX platform? We would like to know if our server is setup with appropriate resources by comparison. We are new to AIX for two month now and has been running into some sluggish performance issues. Following are our environment: ARS 7.1 Patch 5 AIX P5 Micro-partition with 1.0 CPU and 6G Memory assigned Oracle 10G on a remote AIX P5 Micro-partition ITSM 7 200 concurrent users Thank you very much in advance, Jason Lin UCSF ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
User Tool 7.1 Hiccup
Hi Lister, We recently upgraded from ARS 6.3/ITSM 6 to ARS 7.1/ITSM 7 and migrated our Remedy to AIX server as well. However we have been noticed there is a hiccup on Remedy user tool after the tool is on idle (not using the tool) for like 20 minutes or more. It seems like it's taking time to reconnect to the Remedy server. After the 15-30 second wait (some users said taking up to 2 mins), then the performance is fine until the user tool put on idle again. Have anyone experienced similar behavior? We are on following environment: Remedy: ARS 7.1 Patch 05 Application: ITSM 7.0.3 Patch 08 Remedy and database servers: AIX 5.3 Database: Oracle 10G user Tool: ARS 7.1 Patch 04 or 06 Thanks in advance, Jason Lin Programmer Analyst UCSF - OAAIS - Application Services - Remedy 1855 Folsom Street San Francisco, CA 94143 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Open ITSM 6 SHR:People form Using 7.1 Client Tool
Joe, I will look for the workflow populating the global field. Thanks for the suggestion. However it is rare that we don' t have any problem opening the SHR:People form using the ARS 6.3 user tool regardless its first time or second time. Opening SHR:People form is always quick with 6.3 User tool. Thanks for your help. Jason From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe DeSouza Sent: Wednesday, March 25, 2009 1:12 PM To: arslist@ARSLIST.ORG Subject: Re: Open ITSM 6 SHR:People form Using 7.1 Client Tool ** Jason, Is there any workflow (customized or otherwise) firing on window open that may be setting a Global field when the SHR:People form is opened that may be setting a value to a Global field the first time it is opened? And the consecutive times since the field already has a value it must be bypassing this??? If this is the case, check and make sure that whatever is being set if being searched, the search is optimized and is being searched on indexed fields. If these are not indexed, go ahead and create those indexes from the Admin tool.. I would also suggest taking a workflow (active link log) when opening the form for the first time and see whats going on. Joe From: "Lin, Jason" To: arslist@ARSLIST.ORG Sent: Wednesday, March 25, 2009 2:16:28 PM Subject: Open ITSM 6 SHR:People form Using 7.1 Client Tool Greeting, Have anyone experience long access time (about 1-2 minutes) when opening the SHR:People form in the ITSM 6 application using ARS 7.1 client tool. After the SHR:People form opened for the first time, re-opening the SHR:People form is quick (within seconds) on the second, third times, etc. Then the long access time will return when opening the form for the first time again after Remedy re-login. This happen to all our users using ARS 7.1 client tool. No problem with other ITSM 6 forms with ARS 7.1 client tool and no problem opening the SHR:People form with ARS 6.3 client tool. We reported the incident to the BMC Remedy Support and its now documented as a defect - SW00308724. We wait for more than 4 months but no fix yet. Does anyone here see this issue before and have a work around? ARS 6.3 Patch 22 (Remedy server) Solaris/Oracle 10 ARS 7.1 Patch 6 (Client tool) Thank you. Jason Lin Programmer Analyst UCSF __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
Open ITSM 6 SHR:People form Using 7.1 Client Tool
Greeting, Have anyone experience long access time (about 1-2 minutes) when opening the SHR:People form in the ITSM 6 application using ARS 7.1 client tool. After the SHR:People form opened for the first time, re-opening the SHR:People form is quick (within seconds) on the second, third times, etc. Then the long access time will return when opening the form for the first time again after Remedy re-login. This happen to all our users using ARS 7.1 client tool. No problem with other ITSM 6 forms with ARS 7.1 client tool and no problem opening the SHR:People form with ARS 6.3 client tool. We reported the incident to the BMC Remedy Support and its now documented as a defect - SW00308724. We wait for more than 4 months but no fix yet. Does anyone here see this issue before and have a work around? ARS 6.3 Patch 22 (Remedy server) Solaris/Oracle 10 ARS 7.1 Patch 6 (Client tool) Thank you. Jason Lin Programmer Analyst UCSF ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
Re: No available columns when creating a view form from SQL
Jason, since you are using SQL 2005, try to use row_number() function in your select query. This function will generate sequential row numbers for each record and in return you may use it in request id field. Hope this will work because I never tried it in SQL 2005. In oracle I often use rownum function to trick the Remedy. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jason Tricky Sent: Friday, May 23, 2008 8:21 AM To: arslist@ARSLIST.ORG Subject: Re: No available columns when creating a view form from SQL ** When I hit load nothing shows up on the available columns list. The reason for that according to the manual is because the database view must contain an integer or character field that enforces no null value and unique to act as the request ID field and I don't have a column(field) that meets that requirement on my database view. I do have a field that is unique that I can use how do I change the type of that field to enforce the no null value? From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kevin Pulsen Sent: Friday, May 23, 2008 8:12 AM To: arslist@ARSLIST.ORG Subject: Re: No available columns when creating a view form from SQL ** Here is a screen shot. You will need to select one of the columns as a designated Key field. Kevin P. __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"
Midtier special character error in form name using Apache/Tomcat/Mod_JK
Greeting, Hope someone on the list can offer some helps on our midtier problem. Problem: When using Mid-Tier with Apache/Tomcat, forms names that include unique characters (like a plus sign) generated errors: ARERR [303] Forms does not exist on the server. For example: +HPD:HelpDeskArchive Environment: Solaris 9 Apache 2.0.59 Tomcat 5.5.26 Mod_Jk Java 1.4.2 ARS 6.3 patch 22 Miditer 6.3 Patch 13 (we will update it to patch 22) Remedy explained the problem is due to the mod_jk connector trying to decode the Url before sending the URL to tomcat and then Tomcat also try to decode the URL again. Support suggested us to add the following line to apache httpd.conf which tell mod_jk connector to forward the URL to tomcat with doing any decode. JkOptions +ForwardURICompatUnparsed After adding the JkOptions we received apache syntax errors: # ../bin/apachectl configtest Syntax error on line 234 of /usr/local/apache2/conf/httpd.conf: Invalid command 'JkOptions', perhaps mis-spelled or defined by a module not included in the server configuration Has anyone here encounter this problem with apache/tomcat? Thank you. Jason Lin UCSF ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Job: Lead Remedy Developer at University of California, San Francisco
Greeting, We are hiring a Remedy Programmer Lead here at University of California, San Francisco. For more details, please visit http://ucsfhr.ucsf.edu/careers/ and search for job req number "25579BR". Please submit your resume/CV at http://ucsfhr.ucsf.edu/careers/. Do not send your resume/CV to me. Thanks, Jason Req Number 25579BR Job Title Lead Remedy Programmer Title 0738: PROGRAMMER/ANALYST IV LocationFolsom Street, San Francisco, California Department Name OAAIS Work Days Mon - Fri Shift Length8 Hours Position Type Full Time Preferred QualificationsN/A License/Certification N/A Job Summary The incumbent is the lead systems analyst/programmer for Remedy ARS, an enterprise-class system used by the Medical Center, OAAIS and departmental IT units to manage service requests. The incumbent analyzes business requirements, translates them to technical specifications and oversees change management, programming, testing, implementation, troubleshooting and documentation for associated web interfaces, mid-tier applications and databases. The incumbent is also responsible for planning and coordinating upgrades of supporting servers, operating systems, application development environments and databases; and other duties as assigned. Required Qualifications This position requires expert knowledge of all Remedy application modules, including their operation and integration. In addition, because Remedy works in conjunction with Oracle databases, the position requires advanced database design experience, as well as knowledge of database maintenance and tuning. Knowledge in these areas is obtained through both experience and extensive training. Because database technologies, the Remedy product itself, and UCSF business requirements continue to evolve, training and professional growth are an on-going job requirement. Future development of Remedy and its successor - ITSM 7 - requires an understanding of the ITIL service management framework. Note: This is a critical position; fingerprinting and background check are required prior to hire. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Field ID is not related to this form....
Check/open all table fields on the form where you are receiving errors. There maybe a table field column reference the field you deleted (536870993). -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96 CS/SCCE Sent: Tuesday, August 28, 2007 12:29 PM To: arslist@ARSLIST.ORG Subject: Re: Field ID is not related to this form How about turning on the SQL log? Have you tried that? That will probably help. I'd set the WUT up to just before executing the search, turn on the log, run the search, then immediately turn off the log. Then do a search of the log for 536870993 and it might very well give you an indication of what it's trying to do and failing. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa Sent: Tuesday, August 28, 2007 2:24 PM To: arslist@ARSLIST.ORG Subject: Re: Field ID is not related to this form Flushed the cache and it's still not giving me the error message like it does on the WUT.weird... -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96 CS/SCCE Sent: Tuesday, August 28, 2007 3:00 PM To: arslist@ARSLIST.ORG Subject: Re: Field ID is not related to this form Have you flushed your Midtier cache since you deleted the workflow? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa Sent: Tuesday, August 28, 2007 1:56 PM To: arslist@ARSLIST.ORG Subject: Field ID is not related to this form ** I receive an error: ARERR[311] Field ID is not related to this form: 536870993 when I try to do a search on my form in the Windows User Tool. I started receiving this error message when I deleted this field and all workflow attached to it. I created a def file of everything that was attached to this form and there is no 536870993. I don't get this error when I do a search on the Mid Tier. I checked my workflow logs and I don't see anything that tries to refer/change/or set this field. Did I do anything wrong? How do I get rid of this error? User Tool: 7.0.01 Patch 003 Server: 6.3 Mid Tier: 7.0.01 Patch 003 Lisa __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: Oracle SQL SELECT statement to find field LABEL
Someone on the list posted the following query a while back and I found it really useful. Can't remember the lister's name (kudo). You might have to tweak it a little bit for your own use... Make sure to replace the schemaid in the query select vuiname, fieldName, SUBSTR(SUBSTR(SUBSTR(propshort,INSTR(propshort, '\20\4\')+6), INSTR(SUBSTR(propshort,INSTR(propshort, '\20\4\')+6),'\')+1),0, SUBSTR(SUBSTR(propshort,INSTR(propshort, '\20\4\')+6),0, INSTR(SUBSTR(propshort,INSTR(propshort, '\20\4\')+6),'\')-1)) "FIELDLABEL", a.fieldid, decode(datatype,2,'Integer',3,'RealNum',4,'Char', 5,'Diary',6,'RadioBtn',7,'Date/Time',10,'Decimal', 11,'Attachment',12,'Currency',13,'Date',14,'Time',31,'Trim',33,'Table',3 4,'Column',35,'Page', 36,'Page Holder',37,'AttachPool',42,'View',43,'Flashboards') from field a, field_dispprop b, vui c where a.schemaId = 255 and a.schemaid = b.schemaid and b.schemaid = c.schemaid and a.fieldid=b.fieldid and c.vuiid = b.vuiid and datatype != 32 and proplong is null UNION select vuiname, fieldName, SUBSTR(SUBSTR(SUBSTR(dbms_lob.substr(proplong,4000,1), INSTR(dbms_lob.substr(proplong,4000,1), '\20\4\')+6),INSTR(SUBSTR(dbms_lob.substr(proplong,4000,1), INSTR(dbms_lob.substr(proplong,4000,1), '\20\4\')+6),'\')+1),0, SUBSTR(SUBSTR(dbms_lob.substr(proplong,4000,1), INSTR(dbms_lob.substr(proplong,4000,1), '\20\4\')+6),0, INSTR(SUBSTR(dbms_lob.substr(proplong,4000,1), INSTR(dbms_lob.substr(proplong,4000,1), '\20\4\')+6),'\')-1)) "FIELDLABEL", a.fieldid, decode(datatype,2,'Integer',3,'RealNum',4,'Char', 5,'Diary', 6,'RadioBtn',7,'Date/Time',10,'Decimal',11,'Attachment',12,'Currency',13 ,'Date',14,'Time', 31,'Trim',33,'Table',34,'Column',35,'Page',36,'Page Holder',37,'AttachPool',42,'View', 43,'Flashboards') from field a, field_dispprop b, vui c where a.schemaId = 255 and a.schemaid = b.schemaid and b.schemaid = c.schemaid and a.fieldid=b.fieldid and c.vuiid = b.vuiid and datatype != 32 and propshort is null UNION select vuiname, fieldName,SUBSTR(SUBSTR(SUBSTR(propshort,INSTR(propshort, '\110\4\')+7), INSTR(SUBSTR(propshort,INSTR(propshort, '\110\4\')+7),'\')+1),0, SUBSTR(SUBSTR(propshort,INSTR(propshort, '\110\4\')+7),0, INSTR(SUBSTR(propshort,INSTR(propshort, '\110\4\')+7),'\')-1)) "Field Label", a.fieldid, 'Button' from field a, field_dispprop b, vui c where a.schemaId = 255 and a.schemaid = b.schemaid and b.schemaid = c.schemaid and a.fieldid=b.fieldid and c.vuiid = b.vuiid and datatype=32 and proplong is null UNION select vuiname, fieldName, SUBSTR(SUBSTR(SUBSTR(dbms_lob.substr(proplong,4000,1), INSTR(dbms_lob.substr(proplong,4000,1), '\110\4\')+7), INSTR(SUBSTR(dbms_lob.substr(proplong,4000,1), INSTR(dbms_lob.substr(proplong,4000,1), '\110\4\')+7),'\')+1),0, SUBSTR(SUBSTR(dbms_lob.substr(proplong,4000,1), INSTR(dbms_lob.substr(proplong,4000,1), '\110\4\')+7),0, INSTR(SUBSTR(dbms_lob.substr(proplong,4000,1), INSTR(dbms_lob.substr(proplong,4000,1), '\110\4\')+7),'\')-1)) "Field Label", a.fieldid, 'Button' from field a, field_dispprop b, vui c where a.schemaId = 255 and a.schemaid = b.schemaid and b.schemaid = c.schemaid and a.fieldid=b.fieldid and c.vuiid = b.vuiid and datatype=32 and propshort is null order by 1 Hope it help. Jason Lin Programmer Analyst UCSF - OAAIS - Remedy 1855 Folsom Street San Francisco, CA 94143 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kirk Sent: Wednesday, December 20, 2006 5:35 AM To: arslist@ARSLIST.ORG Subject: Oracle SQL SELECT statement to find field LABEL Hello ARLIST, I'm customizing the AR Message Catalog schema to allow select users to update the Help details for schema fields. I'm at the stage where I've added a SQL statement to present the user with the english db field name and a char field to update the help text. However since sometimes the db field name is not the same as the field LABEL that the user would normally see I need to find that in the db tables. I've looked through the AR DatabaseRefGuide doc but can't determine the proper table/column where this info is stored. Does anyone know what the SELECT statement would be or what db table this would reside in? Thx in advance, Kirk ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"