Need Date fields in View Form
Hi, The date fields are not coming in view form when I am trying to create view form for the external db table. Is there any work around for this..? Any help would be appreciated. Thanks and Regards, Gopala Krishna.Peela, Virtusa India Pvt Ltd. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Mid tier behaviour for sorting table
Hi All, I need to sort the contents of the table in a form based on the individual columns; I could get this solved when logged in Remedy user tool. But when logged through mid tier, I am getting the below error. Please help me in resolving the issue. Database error: ORA-00923: FROM keyword not found where expected while trying to execute SQL statement; SELECT TO_CHAR (QDB_QUOTE_ID) as prikey. A.QDB_QUOTE_ID as COL0, A.ORGANISATION_NAME as COL1, A.ORGANISATION_REF as COL2, A.CREATED_USER_ID a (ARERR 10502) Thanks and Regards, Rakesh Kiruba Virtusa (India) Pvt Ltd ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Need Date fields in View Form
Gopala, Using a VIEW form you can't add the date/time (or date ) field directly. This is what you need to do.. 1)Manually, create a data/time field on the view form, after you have pulled the other field 2)Go to the database tab and under view information, where it says Name ..enter the actual name on the database(like create_date), save the form. This would work. Thanks Anoop Date: Wed, 6 Dec 2006 15:39:48 +0530From: [EMAIL PROTECTED]: Need Date fields in View FormTo: [EMAIL PROTECTED] Hi, The date fields are not coming in view form when I am trying to create view form for the external db table. Is there any work around for this..? Any help would be appreciated. Thanks and Regards, Gopala Krishna.Peela, Virtusa India Pvt Ltd. __20060125___This posting was submitted with HTML in it___ _ Search from any Web page with powerful protection. Get the FREE Windows Live Toolbar Today! http://toolbar.live.com/?mkt=en-in ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Need Date fields in View Form
Hi Anoop, I have tried your steps as follows 1. Created date time field in view form after getting all other fields 2. I have given name of the dbcolumn in Name box of database tab of created date time field properties dialog box as follows 3. I am getting following error on clicking on Save Please let me know if am doing any thing wrong Thanks and Regards, Gopala Krishna.Peela Virtusa India Pvt Ltd. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are attachment: image001.jpg
Re: Need Date fields in View Form
Are you sure, you are giving a DB name? Date: Wed, 6 Dec 2006 17:09:34 +0530From: [EMAIL PROTECTED]: Need Date fields in View FormTo: [EMAIL PROTECTED] Hi Anoop, I have tried your steps as follows 1. Created date time field in view form after getting all other fields 2. I have given name of the dbcolumn in Name box of database tab of created date time field properties dialog box as follows 3. I am getting following error on clicking on Save Please let me know if am doing any thing wrong Thanks and Regards, Gopala Krishna.Peela Virtusa India Pvt Ltd. __20060125___This posting was submitted with HTML in it___ _ Check out some new online services at Windows Live Ideas—so new they haven’t even been officially released yet. http://www.msnspecials.in/windowslive/ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are attachment: image001.jpg
Re: Need Date fields in View Form
Yes Anoop..i giving db column name of external table which is accessed from aradmin through dblink. Thanks and Regards, Gopala Krishna.Peela SHOP - Team / Ext: 3217 From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Anoop Sasidharan Sent: Wednesday, December 06, 2006 5:41 PM To: arslist@ARSLIST.ORG Subject: Re: Need Date fields in View Form Are you sure, you are giving a DB name? Date: Wed, 6 Dec 2006 17:09:34 +0530 From: [EMAIL PROTECTED] Subject: Need Date fields in View Form To: arslist@ARSLIST.ORG ** Hi Anoop, I have tried your steps as follows 1. Created date time field in view form after getting all other fields 2. I have given name of the dbcolumn in Name box of database tab of created date time field properties dialog box as follows 3. I am getting following error on clicking on Save Please let me know if am doing any thing wrong Thanks and Regards, Gopala Krishna.Peela Virtusa India Pvt Ltd. __20060125___This posting was submitted with HTML in it___ Check out some new online services at Windows Live Ideas-so new they haven't even been officially released yet. Try it! http://www.msnspecials.in/windowslive/ __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are attachment: image001.jpg
Re: Need Date fields in View Form
I am talking about the Label and Database name. Give some name, before saving the form Date: Wed, 6 Dec 2006 17:50:23 +0530From: [EMAIL PROTECTED]: Re: Need Date fields in View FormTo: [EMAIL PROTECTED] Yes Anoop..i giving db column name of external table which is accessed from aradmin through dblink. Thanks and Regards, Gopala Krishna.Peela SHOP - Team / Ext: 3217 From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Anoop SasidharanSent: Wednesday, December 06, 2006 5:41 PMTo: [EMAIL PROTECTED]: Re: Need Date fields in View Form Are you sure, you are giving a DB name? Date: Wed, 6 Dec 2006 17:09:34 +0530From: [EMAIL PROTECTED]: Need Date fields in View FormTo: [EMAIL PROTECTED] Hi Anoop, I have tried your steps as follows 1. Created date time field in view form after getting all other fields 2. I have given name of the dbcolumn in Name box of database tab of created date time field properties dialog box as follows 3. I am getting following error on clicking on Save Please let me know if am doing any thing wrong Thanks and Regards, Gopala Krishna.Peela Virtusa India Pvt Ltd. __20060125___This posting was submitted with HTML in it___ Check out some new online services at Windows Live Ideas—so new they haven’t even been officially released yet. Try it!__20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ _ Windows Live Spaces is here! It’s easy to create your own personal Web site. http://spaces.live.com/?mkt=en-in ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are attachment: image001.jpg
Re: Migrator 7.02 error 2004
Well, I think you're in the minority, Fred. I know that many problems people have with Migrator have their basis in insufficient configuration of the product, but many of us have seen instances, in multiple versions of Migrator, where items were specified for migration but were not moved, where objects were said to be different when none were apparent even on close examination, of the diff report, etc. I do not believe that a product's failure to consistently accomplish its core functionality falls into the category of quirks. To me, that falls into the category of broken. I have been using it since it was in Beta, and it has never shaken the look of a utility trying to be an application. It's long past time for Remedy Engineering to transform this puppet into a real boy its customers can trust to do its job perfectly EVERY time. Rick _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: Tuesday, December 05, 2006 11:17 PM To: arslist@ARSLIST.ORG Subject: Re: Migrator 7.02 error 2004 ** We have been using Migrator since v3 and have not had any major problems. Yes there are quirks with any product, but it does what we need here. We use it to migrate our code (completely custom code here) from Dev to Test and from Test to Production. I think Error 2004 relates to running out of memory during the migration. Fred _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of patrick zandi Sent: Tuesday, December 05, 2006 10:29 AM To: arslist@ARSLIST.ORG Subject: Re: Migrator 7.02 error 2004 ** IT is Patch 003 as well. soo .. no help there.. On 12/5/06, patrick zandi [EMAIL PROTECTED] wrote: I am trying to migrate some AL's -- Migrator is still acting wierd.. (this is the Story of the Life of this product) -- Error is as follows:: Thread error Number: 2004 Message: an unknown error occurred within the thread. What in the World is that ? Anyone See this ? -- Patrick Zandi __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: COM Automation
I am using AR System .NET and COM API http://www.bmc.com/arsystem/dev_community To interact with ARS server. There is no need for Remedy User Daniel From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Hall Chad - chahal Sent: Wednesday, December 06, 2006 1:13 AM To: arslist@ARSLIST.ORG Subject: COM Automation Has anyone had any luck using Remedy User's COM automation to properly control an instance of Remedy User? I'm using a VBA scripting app (Compuware TestPartner) to create regression testing scripts of our Remedy applications. I'm having two main problems: 1. Issuing a click on buttons. I can usually get around this by using a SendKeys command to send an Enter command after setting focus to a field. But this only seems to work sporadically. 2. Triggering Menu/Row Choice workflow on selection of Selection or Character menus. I can set a text value to these fields, but that doesn't trigger Menu/Row Choice workflow. I can't get any SendKeys commands to open the menu at all, so I really have no workaround for this one. I've also been tinkering with controlling Internet Explorer for Mid Tier regression testing. Although that too is quirky. For instance, the browser window will split in half (one half the form, the other half entirely blank) when clicking on drop down buttons. There are a few other oddities as well. I'm not a VBA expert or an automation expert. So any advice you can give would really be appreciated. I know BMC does similar regression testing using Silk, but I have yet to get answers on how they handle these limitations. Thanks, Chad Hall CHAD HALL ACXIOM Remedy Software Developer Information Systems Development Reporting (ISDR) (501) 342-2650 * The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please resend this communication to the sender and delete the original message or any copy of it from your computer system. Thank you. * __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are -- *DISCLAIMER* The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorized to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking action in reliance of the contents of this information is strictly prohibited and may be unlawful. Orange Romania S.A. is neither liable for the proper, complete transmission of the information contained in this communication nor any delay in its receipt. *END OF DISCLAIMER* ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: best method for migration
If you are a Partner go throught the 7.X Installation and Configuration Class. If you are a Customer it is highly recommended to engage a Partner to do an in place Upgrade. There are many gotchas. -Original Message- From: [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Tue, 5 Dec 2006 11:46 AM Subject: best method for migration All, I'm looking to install a new set of servers, in the midst of this we are undertaking an ARS upgrade too (fun!) but what I want to know is what is the fastest way to get the DB copied from old DB server to new DB server should I do: a) install ars 6.3, copy the db across from old server to new at db level, then upgrade to 7.0 b) install 7.0, copy db across Which would be best? and are there any gotchas. Current platform: Oracle 9.2 Solaris 9 ARS 6.3 patch 18 New platform: Oracle 10gR2 Solaris 9 ARS 7.0.1 Comments and suggestions greatfully recieved. Thanks Stephen ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are Check out the new AOL. Most comprehensive set of free safety and security tools, free access to millions of high-quality videos from across the web, free AOL Mail and more. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: best method for migration
I don't think they need that for just an ARS upgrade, Roger. For ITSM, I would agree totally. Stephen, I think either of your scenarios would probably be ok, but would think it safer to do the upgrade first on your non-production box (i.e. option A), where you can do it multiple times if necessary before making it go live. Work out the glitches and gremlins someplace where the users aren't impacted. I would pay careful attention to the version/patch level of ARS 7 as well. I know that many have reported problems with 7.0.1. Rick _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Roger Justice Sent: Wednesday, December 06, 2006 8:55 AM To: arslist@ARSLIST.ORG Subject: Re: best method for migration ** If you are a Partner go throught the 7.X Installation and Configuration Class. If you are a Customer it is highly recommended to engage a Partner to do an in place Upgrade. There are many gotchas. -Original Message- From: [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Tue, 5 Dec 2006 11:46 AM Subject: best method for migration All, I'm looking to install a new set of servers, in the midst of this we are undertaking an ARS upgrade too (fun!) but what I want to know is what is the fastest way to get the DB copied from old DB server to new DB server should I do: a) install ars 6.3, copy the db across from old server to new at db level, then upgrade to 7.0 b) install 7.0, copy db across Which would be best? and are there any gotchas. Current platform: Oracle 9.2 Solaris 9 ARS 6.3 patch 18 New platform: Oracle 10gR2 Solaris 9 ARS 7.0.1 Comments and suggestions greatfully recieved. Thanks Stephen ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org http://www.arslist.org/ ARSlist:Where the Answers Are _ http://pr.atwola.com/promoclk/1615326657x4311227241x4298082137/aol?redir=ht tp%3A%2F%2Fwww%2Eaol%2Ecom%2Fnewaol Check out the new AOL. Most comprehensive set of free safety and security tools, free access to millions of high-quality videos from across the web, free AOL Mail and more. __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Database
You can also change the collation sequence at the procedure level. Case sensitivity doesn't seem to be maintained across linked servers between procedures and tables. We had it enabled at the table level and it maintained case sensitivity when the procedure was on the same server-it didn't maintain case sensitivity when the stored procedure/function was on a different server from the table. We implemented case-sensitivity within the stored procedure/function to work around that problem. The bottom line is you can make SQL Server case-sensitive at several levels. By default, our server is case-insensitive and we enable it as needed where needed. CRAIG J. CARTER _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Michiel Beijen Sent: Wednesday, December 06, 2006 12:08 AM To: arslist@ARSLIST.ORG Subject: Re: Database ** You can select the case sensitivity by changing the collation. You can change the collation of the entire database or only of a certain table. See http://msdn2.microsoft.com/en-US/library/ms144250.aspx http://msdn2.microsoft.com/en-US/library/ms144250.aspx http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=60020 http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=60020SiteID=1 SiteID=1 -- Michiel On 12/5/06, Rick Cook [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: ** I can't even remember seeing an option to install MS SQL as case-insensitve for at least a couple of versions. When it was there, it was still tied to Sybase (i.e. v6), where you simply selected a dataset that fit your needs, and selected your case sensitivity once and for all at that time. What version of SQL are you using? Rick On 12/5/06, CONDREA, Daniel mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] wrote: ** Is MSSQL really case insensitive? It depends how it installed. Here is case sensitive _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG ] On Behalf Of Axton Sent: 05 December 2006 17:10 To: arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG Subject: Re: Database ** Is MSSQL really case insensitive? Yes We have several stored procedures in ORACLE. How flexible is MSSQL when it comes to stored procedures? The stored procedures are very capable, but the code does not transport between the two RMDBS systems you referenced. You will have to rewrite the sp's. I have heard many say the Windows is not as stable as UNIX. How stable is MSSQL? My personal experience has been that, on MS, the more you install, the less stable the system becomes. In corp/institutional environments, this roughly translates to, the more groups you have involved in managing your servers, the less stable they are. In the shops where my group managed the servers from the wall out, windows was rock solid. In the shops where there was a storage group, an OS group, a security group, a hardware group, a network group, an hp group, an oracle group, and many other groups involved in the management of the system, the thing continually falls apart. Axton Grams On 12/5/06, David Yearsley [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: ** Our current environment has included a ORACLE database more than 6 years. Our hardware is reaching the end of its life and because of Price and the Case Sensitivity of ORACLE we are looking at possibly replacing ORACLE with Microsoft SQL. As we investigate this change there are several questions I would like to ask. Is MSSQL really case insensitive? We have several stored procedures in ORACLE. How flexible is MSSQL when it comes to stored procedures? I have heard many say the Windows is not as stable as UNIX. How stable is MSSQL? Has anyone made the switch from ORACLE to MSSQL? If so, do you have any advice? Any information we are overlooking? __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ -- *DISCLAIMER* The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorized to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking action in reliance of the contents of this information is strictly prohibited and may be unlawful. Orange Romania S.A. is neither liable for the proper, complete transmission of the information contained in this communication nor any delay in its receipt. *END OF DISCLAIMER* ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Re: COM Automation
We want to fully simulate the end user experience. So all the point and clicks need to be tested. Using an API approach will bypass the Mid Tier or Remedy User clients and go straight to the server. That's great for stress testing or for testing of filters, but we need to make sure all our active links, buttons, fields, etc are also tested exactly as the end user would interact with them. Is there some way to do this through the .NET API? Chad Hall (501) 342-2650 From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of CONDREA, Daniel Sent: Wednesday, December 06, 2006 7:15 AM To: arslist@ARSLIST.ORG Subject: Re: COM Automation I am using AR System .NET and COM API http://www.bmc.com/arsystem/dev_community To interact with ARS server. There is no need for Remedy User Daniel From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Hall Chad - chahal Sent: Wednesday, December 06, 2006 1:13 AM To: arslist@ARSLIST.ORG Subject: COM Automation Has anyone had any luck using Remedy User's COM automation to properly control an instance of Remedy User? I'm using a VBA scripting app (Compuware TestPartner) to create regression testing scripts of our Remedy applications. I'm having two main problems: 1. Issuing a click on buttons. I can usually get around this by using a SendKeys command to send an Enter command after setting focus to a field. But this only seems to work sporadically. 2. Triggering Menu/Row Choice workflow on selection of Selection or Character menus. I can set a text value to these fields, but that doesn't trigger Menu/Row Choice workflow. I can't get any SendKeys commands to open the menu at all, so I really have no workaround for this one. I've also been tinkering with controlling Internet Explorer for Mid Tier regression testing. Although that too is quirky. For instance, the browser window will split in half (one half the form, the other half entirely blank) when clicking on drop down buttons. There are a few other oddities as well. I'm not a VBA expert or an automation expert. So any advice you can give would really be appreciated. I know BMC does similar regression testing using Silk, but I have yet to get answers on how they handle these limitations. Thanks, Chad Hall CHAD HALL ACXIOM Remedy Software Developer Information Systems Development Reporting (ISDR) (501) 342-2650 * The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please resend this communication to the sender and delete the original message or any copy of it from your computer system. Thank you. * __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: best method for migration
I have a quick question: If you follow this method, ARS 5.12 ~~ ARS 6.01 ~~ ARS 6.3 ~~ ARS 7.0 After each upgrade check applications, to see if they are working correctly.. etc. Then just upgrade to the next one in a Row. Would there be any Gotcha's with Licensing or if you had the ARS 7.0 and you just pushed from ARS 5.12 ~~ 7 then installed the licenses.. Recommendations ? On 12/6/06, Rick cook [EMAIL PROTECTED] wrote: ** I don't think they need that for just an ARS upgrade, Roger. For ITSM, I would agree totally. Stephen, I think either of your scenarios would probably be ok, but would think it safer to do the upgrade first on your non-production box (i.e. option A), where you can do it multiple times if necessary before making it go live. Work out the glitches and gremlins someplace where the users aren't impacted. I would pay careful attention to the version/patch level of ARS 7 as well. I know that many have reported problems with 7.0.1. *Rick* -- *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Roger Justice *Sent:* Wednesday, December 06, 2006 8:55 AM *To:* arslist@ARSLIST.ORG *Subject:* Re: best method for migration ** If you are a Partner go throught the 7.X Installation and Configuration Class. If you are a Customer it is highly recommended to engage a Partner to do an in place Upgrade. There are many gotchas. -Original Message- From: [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Tue, 5 Dec 2006 11:46 AM Subject: best method for migration All, I'm looking to install a new set of servers, in the midst of this we are undertaking an ARS upgrade too (fun!) but what I want to know is what is the fastest way to get the DB copied from old DB server to new DB server should I do: a) install ars 6.3, copy the db across from old server to new at db level, then upgrade to 7.0 b) install 7.0, copy db across Which would be best? and are there any gotchas. Current platform: Oracle 9.2 Solaris 9 ARS 6.3 patch 18 New platform: Oracle 10gR2 Solaris 9 ARS 7.0.1 Comments and suggestions greatfully recieved. Thanks Stephen ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are -- *Check out the new AOL*http://pr.atwola.com/promoclk/1615326657x4311227241x4298082137/aol?redir=http%3A%2F%2Fwww%2Eaol%2Ecom%2Fnewaol. Most comprehensive set of free safety and security tools, free access to millions of high-quality videos from across the web, free AOL Mail and more. __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ -- Patrick Zandi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: COM Automation
Is there some way to do this through the .NET API? No. Maybe someone can sugest a testing tool. In my opinion this approach is more human. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Hall Chad - chahal Sent: Wednesday, December 06, 2006 4:37 PM To: arslist@ARSLIST.ORG Subject: Re: COM Automation We want to fully simulate the end user experience. So all the point and clicks need to be tested. Using an API approach will bypass the Mid Tier or Remedy User clients and go straight to the server. That's great for stress testing or for testing of filters, but we need to make sure all our active links, buttons, fields, etc are also tested exactly as the end user would interact with them. Is there some way to do this through the .NET API? Chad Hall (501) 342-2650 From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of CONDREA, Daniel Sent: Wednesday, December 06, 2006 7:15 AM To: arslist@ARSLIST.ORG Subject: Re: COM Automation I am using AR System .NET and COM API http://www.bmc.com/arsystem/dev_community To interact with ARS server. There is no need for Remedy User Daniel From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Hall Chad - chahal Sent: Wednesday, December 06, 2006 1:13 AM To: arslist@ARSLIST.ORG Subject: COM Automation Has anyone had any luck using Remedy User's COM automation to properly control an instance of Remedy User? I'm using a VBA scripting app (Compuware TestPartner) to create regression testing scripts of our Remedy applications. I'm having two main problems: 1. Issuing a click on buttons. I can usually get around this by using a SendKeys command to send an Enter command after setting focus to a field. But this only seems to work sporadically. 2. Triggering Menu/Row Choice workflow on selection of Selection or Character menus. I can set a text value to these fields, but that doesn't trigger Menu/Row Choice workflow. I can't get any SendKeys commands to open the menu at all, so I really have no workaround for this one. I've also been tinkering with controlling Internet Explorer for Mid Tier regression testing. Although that too is quirky. For instance, the browser window will split in half (one half the form, the other half entirely blank) when clicking on drop down buttons. There are a few other oddities as well. I'm not a VBA expert or an automation expert. So any advice you can give would really be appreciated. I know BMC does similar regression testing using Silk, but I have yet to get answers on how they handle these limitations. Thanks, Chad Hall CHAD HALL ACXIOM Remedy Software Developer Information Systems Development Reporting (ISDR) (501) 342-2650 * The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please resend this communication to the sender and delete the original message or any copy of it from your computer system. Thank you. * __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are -- *DISCLAIMER* The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorized to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking action in reliance of the contents of this information is strictly prohibited and may be unlawful. Orange Romania S.A. is neither liable for the proper, complete transmission of the information contained in this communication nor any delay in its receipt. *END OF DISCLAIMER* ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: best method for migration
Absolutely there would be a few gotchas, Pat. For instance, with ITSM 7, you have to have the app. licenses in place before you install the apps. I wouldn't take either path without a thorough review of the release notes and installation guides, and having Support bless my approach prior to implementation. Rick _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of patrick zandi Sent: Wednesday, December 06, 2006 9:38 AM To: arslist@ARSLIST.ORG Subject: Re: best method for migration ** I have a quick question: If you follow this method, ARS 5.12 ~~ ARS 6.01 ~~ ARS 6.3 ~~ ARS 7.0 After each upgrade check applications, to see if they are working correctly.. etc. Then just upgrade to the next one in a Row. Would there be any Gotcha's with Licensing or if you had the ARS 7.0 and you just pushed from ARS 5.12 ~~ 7 then installed the licenses.. Recommendations ? On 12/6/06, Rick cook [EMAIL PROTECTED] wrote: ** I don't think they need that for just an ARS upgrade, Roger. For ITSM, I would agree totally. Stephen, I think either of your scenarios would probably be ok, but would think it safer to do the upgrade first on your non-production box (i.e. option A), where you can do it multiple times if necessary before making it go live. Work out the glitches and gremlins someplace where the users aren't impacted. I would pay careful attention to the version/patch level of ARS 7 as well. I know that many have reported problems with 7.0.1. Rick _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Roger Justice Sent: Wednesday, December 06, 2006 8:55 AM To: arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG Subject: Re: best method for migration ** If you are a Partner go throught the 7.X Installation and Configuration Class. If you are a Customer it is highly recommended to engage a Partner to do an in place Upgrade. There are many gotchas. -Original Message- From: [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Tue, 5 Dec 2006 11:46 AM Subject: best method for migration All, I'm looking to install a new set of servers, in the midst of this we are undertaking an ARS upgrade too (fun!) but what I want to know is what is the fastest way to get the DB copied from old DB server to new DB server should I do: a) install ars 6.3, copy the db across from old server to new at db level, then upgrade to 7.0 b) install 7.0, copy db across Which would be best? and are there any gotchas. Current platform: Oracle 9.2 Solaris 9 ARS 6.3 patch 18 New platform: Oracle 10gR2 Solaris 9 ARS 7.0.1 Comments and suggestions greatfully recieved. Thanks Stephen ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org http://www.arslist.org/ ARSlist:Where the Answers Are _ http://pr.atwola.com/promoclk/1615326657x4311227241x4298082137/aol?redir=ht tp%3A%2F%2Fwww%2Eaol%2Ecom%2Fnewaol Check out the new AOL . Most comprehensive set of free safety and security tools, free access to millions of high-quality videos from across the web, free AOL Mail and more. __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ -- Patrick Zandi __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Fwd: Question: SQL
I think you may need one more set of brackets. It appears that the query
always returns 1 because Request_ID = '$Request ID$' is always true and at
least one of the OR conditions is true somewhere in the
IPVPN_IPACT_Overview table.
Put another set of brackets around everything following the AND (as shown
below) which will result in both that particular request and at least one
of the OR conditions needing to be true to return a value.
SELECT COUNT (Request_ID) FROM dbo.IPVPN_IPACT_Overview WHERE (Request_ID =
'$Request ID$') AND ( ((PATINDEX('%SOW%', UPPER(Scope_of_Work)) 0) OR
(PATINDEX('%IPDP%', UPPER(Scope_of_Work)) 0) OR (PATINDEX('%MACD%',
UPPER(Scope_of_Work)) 0)) )
Cheers,
Jim.
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the
Answers Are
Re: best method for migration
I thought so.. Was absolute with that licensing issue ? thanks. On 12/6/06, Rick cook [EMAIL PROTECTED] wrote: ** Absolutely there would be a few gotchas, Pat. For instance, with ITSM 7, you have to have the app. licenses in place before you install the apps. I wouldn't take either path without a thorough review of the release notes and installation guides, and having Support bless my approach prior to implementation. *Rick* -- *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *patrick zandi *Sent:* Wednesday, December 06, 2006 9:38 AM *To:* arslist@ARSLIST.ORG *Subject:* Re: best method for migration ** I have a quick question: If you follow this method, ARS 5.12 ~~ ARS 6.01 ~~ ARS 6.3 ~~ ARS 7.0 After each upgrade check applications, to see if they are working correctly.. etc. Then just upgrade to the next one in a Row. Would there be any Gotcha's with Licensing or if you had the ARS 7.0 and you just pushed from ARS 5.12 ~~ 7 then installed the licenses.. Recommendations ? On 12/6/06, Rick cook [EMAIL PROTECTED] wrote: ** I don't think they need that for just an ARS upgrade, Roger. For ITSM, I would agree totally. Stephen, I think either of your scenarios would probably be ok, but would think it safer to do the upgrade first on your non-production box ( i.e. option A), where you can do it multiple times if necessary before making it go live. Work out the glitches and gremlins someplace where the users aren't impacted. I would pay careful attention to the version/patch level of ARS 7 as well. I know that many have reported problems with 7.0.1. *Rick* -- *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Roger Justice *Sent:* Wednesday, December 06, 2006 8:55 AM *To:* arslist@ARSLIST.ORG *Subject:* Re: best method for migration ** If you are a Partner go throught the 7.X Installation and Configuration Class. If you are a Customer it is highly recommended to engage a Partner to do an in place Upgrade. There are many gotchas. -Original Message- From: [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Tue, 5 Dec 2006 11:46 AM Subject: best method for migration All, I'm looking to install a new set of servers, in the midst of this we are undertaking an ARS upgrade too (fun!) but what I want to know is what is the fastest way to get the DB copied from old DB server to new DB server should I do: a) install ars 6.3, copy the db across from old server to new at db level, then upgrade to 7.0 b) install 7.0, copy db across Which would be best? and are there any gotchas. Current platform: Oracle 9.2 Solaris 9 ARS 6.3 patch 18 New platform: Oracle 10gR2 Solaris 9 ARS 7.0.1 Comments and suggestions greatfully recieved. Thanks Stephen ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are -- *Check out the new AOL* http://pr.atwola.com/promoclk/1615326657x4311227241x4298082137/aol?redir=http%3A%2F%2Fwww%2Eaol%2Ecom%2Fnewaol. Most comprehensive set of free safety and security tools, free access to millions of high-quality videos from across the web, free AOL Mail and more. __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ -- Patrick Zandi __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ -- Patrick Zandi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Estimation for Remedy development
Hi All, If anybody has developed a remedy estimation model or are aware of one that already exists, please share the same with me. I need this for one of the Remedy developments that we are currently undertaking. Thanks Jason ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Estimation for Remedy development
I did one several years ago for the Air Force, but I don't have a copy of the definition files. Mark, do you guys still use that Function-Point Analysis tool we built over there at AFWA? Essentially what we did was treat Remedy as a fourth-generation software development language, then perform function-point analysis, where we assigned a difficulty level to each requirement. Each requirement was broken down into the pieces of workflow required: Active Links, Filters, Forms, etc. Since some pieces of workflow are more complex than others, they're given a modifier with a higher number, e.g. forms are far more complex than filters, thus forms might get an 8 modifier, and filters might get a 2. Then each individual filter will be assessed as to how difficult it was based on number of actions, qualifications, etc, on a scale of 1 to 10. Finally, the skill of the developer is taken into account, and the project is given a third modifier. We pulled the formulas from a couple of textbooks on software development and function-point analysis and built the whole thing in Remedy. We even managed to tie it to our salaries and project the time it would take to complete future projects. The best part is that since Remedy is so efficient, compared to a second or third-generation development language like C, we look like GODS, coding millions of lines per year. Good luck with your efforts. Jennifer Meyer Remedy Support Engineer Strategic Technologies Inc. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jason McDonald Sent: Wednesday, December 06, 2006 10:37 AM To: arslist@ARSLIST.ORG Subject: Estimation for Remedy development ** Hi All, If anybody has developed a remedy estimation model or are aware of one that already exists, please share the same with me. I need this for one of the Remedy developments that we are currently undertaking. Thanks Jason __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: COM Automation
When pushing buttons with COM Automation, I've found that the U
Chad,
When pushing buttons with COM Automation, I've found that the User tool isn't
always ready to receive the next command when it gets the instruction from the
script. Specifically, when you issue the command to change focus to the
button, followed by either a carriage return or space character, you can't
count on the interface to wait until focus on the button. So I normally issue
a short sleep command in between SendKeys calls. Here's an example snippet in
JScript:
var app, sess, form;
var VISIBLE = 1, INVISIBLE = 2;
var AR_SUBMIT = 1, AR_QUERY = 2;
var AR_DISPLAY = 3, AR_MODIFY = 4;
app = new ActiveXObject(Remedy.User);
wsh = new ActiveXObject(WScript.Shell);
sess = app.Login(Demo, , VISIBLE);
form = app.OpenForm(sess,localhost, TAW:Dog, AR_SUBMIT, true)
form.GiveFieldFocusById(606084201);
WScript.Sleep(1000);
wsh.SendKeys(%{DOWN});
WScript.Sleep(1000);
wsh.SendKeys({DOWN});
WScript.Sleep(1000);
wsh.SendKeys({ENTER});
I think Alt+Down Arrow (%{DOWN}) should open a menu.
Tim Widowfield
[EMAIL PROTECTED]
http://www.widowfield.com
- Original Message
From: Hall Chad - chahal [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Tuesday, December 5, 2006 6:12:54 PM
Subject: [ARSLIST] COM Automation
**
Has anyone had any luck using Remedy User’s COM automation to properly control
an instance of Remedy User? I’m using a VBA scripting app (Compuware
TestPartner) to create regression testing scripts of our Remedy applications.
I’m having two main problems:
Issuing a “click” on buttons. I can usually get around this by using a SendKeys
command to send an Enter command after setting focus to a field. But this only
seems to work sporadically.
Triggering “Menu/Row Choice” workflow on selection of Selection or Character
menus. I can set a text value to these fields, but that doesn’t trigger
Menu/Row Choice workflow. I can’t get any SendKeys commands to open the menu at
all, so I really have no workaround for this one.
I’ve also been tinkering with controlling Internet Explorer for Mid Tier
regression testing. Although that too is quirky. For instance, the browser
window will split in half (one half the form, the other half entirely blank)
when clicking on drop down buttons. There are a few other oddities as well.
I’m not a VBA expert or an automation expert. So any advice you can give would
really be appreciated. I know BMC does similar regression testing using Silk,
but I have yet to get answers on how they handle these limitations.
Thanks,
Chad Hall
CHAD HALL
ACXIOM
Remedy Software Developer
Information Systems Development Reporting (ISDR)
(501) 342-2650
*
The information contained in this communication is confidential, is
intended only for the use of the recipient named above, and may be
legally privileged.
If the reader of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or copying of this
communication is strictly prohibited.
If you have received this communication in error, please resend this
communication to the sender and delete the original message or any copy
of it from your computer system.
Thank you.
*
__20060125___This posting was submitted with HTML in it___
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the
Answers Are
Mid-Tier config question
All, Have a question on mid-tier setup. We're running ARS 5.1.2 on SQL server, and (according to the system info), the mid tier is running v 6.3 patch 010. For the most part the mid tier is workable, but one area doesn't appear correctly - at the top you have the search mode and the search/advanced search buttons attempting to appear (and doing a sucky job of it), this is running on either IE6, IE7 or Firefox 2. Is there any way to force these to not display, just to tidy up the interface a little? Regards Dave ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: SLM 7.0.01- Share:Application Properties shows wrong version
Thanks for the replies. After I posted this, I remembered Christopher's previous post that the ITSM 7.0.01 is actually the same code as 7.0, it's just a different install version, so I guess it doesn't matter. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Mid-Tier config question
Personally I think the MidTier dispay of the tool bar is pretty nice. However, if you do not want to see it then using the 6.0 Admin tool, open the form, goto Form | Current View | Properties and then click on the Menu Access tab and uncheck the Toolbar item. On 12/6/06, Dave Barber [EMAIL PROTECTED] wrote: ** All, Have a question on mid-tier setup. We're running ARS 5.1.2 on SQL server, and (according to the system info), the mid tier is running v 6.3 patch 010. For the most part the mid tier is workable, but one area doesn't appear correctly - at the top you have the search mode and the search/advanced search buttons attempting to appear (and doing a sucky job of it), this is running on either IE6, IE7 or Firefox 2. Is there any way to force these to not display, just to tidy up the interface a little? Regards Dave __20060125___This posting was submitted with HTML in it___ -- Frank Caruso Specific Integration, Inc. Senior Remedy Engineer, ITIL Foundation Certified www.specificintegration.com 703-376-1249 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Mid-Tier config question
You may want to consider going to patch 13 or better for your 6.3 mid-tier because caching problems (not all fields would display) were corrected. Pete -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Frank Caruso Sent: Wednesday, December 06, 2006 11:32 AM To: arslist@ARSLIST.ORG Subject: Re: Mid-Tier config question ** Personally I think the MidTier dispay of the tool bar is pretty nice. However, if you do not want to see it then using the 6.0 Admin tool, open the form, goto Form | Current View | Properties and then click on the Menu Access tab and uncheck the Toolbar item. On 12/6/06, Dave Barber [EMAIL PROTECTED] wrote: ** All, Have a question on mid-tier setup. We're running ARS 5.1.2 on SQL server, and (according to the system info), the mid tier is running v 6.3 patch 010. For the most part the mid tier is workable, but one area doesn't appear correctly - at the top you have the search mode and the search/advanced search buttons attempting to appear (and doing a sucky job of it), this is running on either IE6, IE7 or Firefox 2. Is there any way to force these to not display, just to tidy up the interface a little? Regards Dave __20060125___This posting was submitted with HTML in it___ -- Frank Caruso Specific Integration, Inc. Senior Remedy Engineer, ITIL Foundation Certified www.specificintegration.com 703-376-1249 __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
LDAP 14 Character Bind hard limit
I have found that the BIND on the LDAP is a 14 Character Hard Limit- This might be due to using LM or NTLM for encryptions Vice NTLMv2. Can anyone Enlighten me a little more in this area.. ARS 5.12 // ARS 6.01 ? / ARS 6.3 ? / ARS 7.0 ? Will test ARS 7.0 soon. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Mid-Tier config question
Frank, Thanks for that, but it doesn't work. I'm pretty sure that something is seriously wrong with parts of our mid-tier. Turns out that the Toolbar option was already un-checked. I've checked it, flushed the cache, tried it, unchecked it, flushed the cache, tried it again, and it makes no difference to the status. Thing is that the server is running 5.1.2, but the mid tier config says 6.3. The problem is that it doesn't display correctly You get something like : v Current mode : *Search* I I Advanced searchI I (partial text) I (partial text) I (partial text) It doesn't display the lower lines correctly. Clicking the v minimises the section, but its still there. Would be great if it could be switched off, but it doesn't appear possible. Regards Dave On 06/12/06, Frank Caruso [EMAIL PROTECTED] wrote: ** Personally I think the MidTier dispay of the tool bar is pretty nice. However, if you do not want to see it then using the 6.0 Admin tool, open the form, goto Form | Current View | Properties and then click on the Menu Access tab and uncheck the Toolbar item. On 12/6/06, Dave Barber [EMAIL PROTECTED] wrote: ** All, Have a question on mid-tier setup. We're running ARS 5.1.2 on SQL server, and (according to the system info), the mid tier is running v 6.3 patch 010. For the most part the mid tier is workable, but one area doesn't appear correctly - at the top you have the search mode and the search/advanced search buttons attempting to appear (and doing a sucky job of it), this is running on either IE6, IE7 or Firefox 2. Is there any way to force these to not display, just to tidy up the interface a little? Regards Dave __20060125___This posting was submitted with HTML in it___ -- Frank Caruso Specific Integration, Inc. Senior Remedy Engineer, ITIL Foundation Certified www.specificintegration.com 703-376-1249 __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Mid-Tier config question
The actual option to hide this bar from mid-tier is in Form | Current View | Properties | Click Appearence tab | Bottom left has webtool bar dropdown, set this to hidden. Cheers, Curtis Gallant From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dave Barber Sent: Wednesday, December 06, 2006 11:58 AM To: arslist@ARSLIST.ORG Subject: Re: Mid-Tier config question ** Frank, Thanks for that, but it doesn't work. I'm pretty sure that something is seriously wrong with parts of our mid-tier. Turns out that the Toolbar option was already un-checked. I've checked it, flushed the cache, tried it, unchecked it, flushed the cache, tried it again, and it makes no difference to the status. Thing is that the server is running 5.1.2, but the mid tier config says 6.3. The problem is that it doesn't display correctly You get something like : v Current mode : Search I I Advanced searchI I (partial text) I (partial text) I (partial text) It doesn't display the lower lines correctly. Clicking the v minimises the section, but its still there. Would be great if it could be switched off, but it doesn't appear possible. Regards Dave On 06/12/06, Frank Caruso [EMAIL PROTECTED] wrote: ** Personally I think the MidTier dispay of the tool bar is pretty nice. However, if you do not want to see it then using the 6.0 Admin tool, open the form, goto Form | Current View | Properties and then click on the Menu Access tab and uncheck the Toolbar item. On 12/6/06, Dave Barber [EMAIL PROTECTED] wrote: ** All, Have a question on mid-tier setup. We're running ARS 5.1.2 on SQL server, and (according to the system info), the mid tier is running v 6.3 patch 010. For the most part the mid tier is workable, but one area doesn't appear correctly - at the top you have the search mode and the search/advanced search buttons attempting to appear (and doing a sucky job of it), this is running on either IE6, IE7 or Firefox 2. Is there any way to force these to not display, just to tidy up the interface a little? Regards Dave __20060125___This posting was submitted with HTML in it___ -- Frank Caruso Specific Integration, Inc. Senior Remedy Engineer, ITIL Foundation Certified www.specificintegration.com http://www.specificintegration.com/ 703-376-1249 __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Mid-Tier config question
We are running the same ARS server version but with MidTier Version 6.03.00patch 015. Maybe that would fix it. Good luck. On 12/6/06, Dave Barber [EMAIL PROTECTED] wrote: ** Frank, Thanks for that, but it doesn't work. I'm pretty sure that something is seriously wrong with parts of our mid-tier. Turns out that the Toolbar option was already un-checked. I've checked it, flushed the cache, tried it, unchecked it, flushed the cache, tried it again, and it makes no difference to the status. Thing is that the server is running 5.1.2, but the mid tier config says 6.3. The problem is that it doesn't display correctly You get something like : v Current mode : *Search* I I Advanced searchI I (partial text) I (partial text) I (partial text) It doesn't display the lower lines correctly. Clicking the v minimises the section, but its still there. Would be great if it could be switched off, but it doesn't appear possible. Regards Dave On 06/12/06, Frank Caruso [EMAIL PROTECTED] wrote: ** Personally I think the MidTier dispay of the tool bar is pretty nice. However, if you do not want to see it then using the 6.0 Admin tool, open the form, goto Form | Current View | Properties and then click on the Menu Access tab and uncheck the Toolbar item. On 12/6/06, Dave Barber [EMAIL PROTECTED] wrote: ** All, Have a question on mid-tier setup. We're running ARS 5.1.2 on SQL server, and (according to the system info), the mid tier is running v 6.3 patch 010. For the most part the mid tier is workable, but one area doesn't appear correctly - at the top you have the search mode and the search/advanced search buttons attempting to appear (and doing a sucky job of it), this is running on either IE6, IE7 or Firefox 2. Is there any way to force these to not display, just to tidy up the interface a little? Regards Dave __20060125___This posting was submitted with HTML in it___ -- Frank Caruso Specific Integration, Inc. Senior Remedy Engineer, ITIL Foundation Certified www.specificintegration.com 703-376-1249 __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ -- Frank Caruso Specific Integration, Inc. Senior Remedy Engineer, ITIL Foundation Certified www.specificintegration.com 703-376-1249 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
just upgraded to ARS 7.0, curious behavior questoin
We've just upgraded our Test server from ARS 6.3 to ARS 7.0... no real problems in the upgrade itself. However, if I open the User form in the Admin tool and tweak something (ie. move a field left then back right where it belongs) and try to save the form, it asks me to confirm that I want to delete the fields: Modify, New Request, New Search, Query, Submit These appear to be buttons that one would use in a web view, but they are not in the one and only Default Admin View of the User form. Perhaps even more curious, if I put them in the view, you never really see them... I can find them by using the Find Field, and see their properties, but you never really see them on the form. This is curious enough that perhaps it's covered in one of the Admin 7.0 training classes, but I've never needed retraining before when doing ARS upgrades. Can someone point me in the right direction on this? I do need to tweak the User form, but am uncomfortable about deleting fields I don't understand. -ivan- -- Ivan Runions Information Technologies University of Calgary Calgary Alberta Canada (403) 220-4437 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
what do I need to use a Palm?
Hi ARS System: 6.3 Mid-Tier 6 My question is, I need any special software from BMC software to enable my clients use their PDA in this case Palm? If yes, what it is? if no, what i need then? best regards ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: COM Automation
Thanks Tim. I'll try adding a sleep statement.
I've tried both ALT+Down (%{DOWN}) and ALT+Up (%{UP}), but neither one
does anything at all.
Chad Hall
(501) 342-2650
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Tim Widowfield
Sent: Wednesday, December 06, 2006 10:03 AM
To: arslist@ARSLIST.ORG
Subject: Re: COM Automation
When pushing buttons with COM Automation, I've found that the U
Chad,
When pushing buttons with COM Automation, I've found that the User tool
isn't always ready to receive the next command when it gets the
instruction from the script. Specifically, when you issue the command
to change focus to the button, followed by either a carriage return or
space character, you can't count on the interface to wait until focus on
the button. So I normally issue a short sleep command in between
SendKeys calls. Here's an example snippet in JScript:
var app, sess, form;
var VISIBLE = 1, INVISIBLE = 2;
var AR_SUBMIT = 1, AR_QUERY = 2;
var AR_DISPLAY = 3, AR_MODIFY = 4;
app = new ActiveXObject(Remedy.User);
wsh = new ActiveXObject(WScript.Shell);
sess = app.Login(Demo, , VISIBLE);
form = app.OpenForm(sess,localhost, TAW:Dog, AR_SUBMIT, true)
form.GiveFieldFocusById(606084201);
WScript.Sleep(1000);
wsh.SendKeys(%{DOWN});
WScript.Sleep(1000);
wsh.SendKeys({DOWN});
WScript.Sleep(1000);
wsh.SendKeys({ENTER});
I think Alt+Down Arrow (%{DOWN}) should open a menu.
Tim Widowfield
[EMAIL PROTECTED]
http://www.widowfield.com
- Original Message
From: Hall Chad - chahal [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Tuesday, December 5, 2006 6:12:54 PM
Subject: [ARSLIST] COM Automation
**
Has anyone had any luck using Remedy User's COM automation to properly
control an instance of Remedy User? I'm using a VBA scripting app
(Compuware TestPartner) to create regression testing scripts of our
Remedy applications. I'm having two main problems:
Issuing a click on buttons. I can usually get around this by using a
SendKeys command to send an Enter command after setting focus to a
field. But this only seems to work sporadically.
Triggering Menu/Row Choice workflow on selection of Selection or
Character menus. I can set a text value to these fields, but that
doesn't trigger Menu/Row Choice workflow. I can't get any SendKeys
commands to open the menu at all, so I really have no workaround for
this one.
I've also been tinkering with controlling Internet Explorer for Mid Tier
regression testing. Although that too is quirky. For instance, the
browser window will split in half (one half the form, the other half
entirely blank) when clicking on drop down buttons. There are a few
other oddities as well.
I'm not a VBA expert or an automation expert. So any advice you can give
would really be appreciated. I know BMC does similar regression testing
using Silk, but I have yet to get answers on how they handle these
limitations.
Thanks,
Chad Hall
CHAD HALL
ACXIOM
Remedy Software Developer
Information Systems Development Reporting (ISDR)
(501) 342-2650
*
The information contained in this communication is confidential, is
intended only for the use of the recipient named above, and may be
legally privileged.
If the reader of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or copying of this
communication is strictly prohibited.
If you have received this communication in error, please resend this
communication to the sender and delete the original message or any copy
of it from your computer system.
Thank you.
*
__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
ARServer 7.0.01 Memory Leaks
Does anyone have ARS 7.0.01 in a production environment on Solaris 9 under a semi-heavy load (~200 concurrent users peak)? We are seeing some major issues with memory consumption. At startup, the arserverd process has ~400mb of memory allocated. After 2 days, this jumped to 1.8gb. On day 3 (today), it has ~2.4gb of memory allocated. Thanks, Axton Grams ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Daylight savings time again
Folks, In case you are not aware of this page http://www.bmc.com/info_center_support/overview/0,,19097_0_68222529,00.html I am not impressed of this. I have submitted my question a month ago. The reply from BMC was At this time we are not aware of the need for any patch. It is not much time left for testing and rolling out the patch before March. In fact, we have started inputting the change records for next year. Regards PC -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Alfred Differ Sent: Tuesday, December 05, 2006 1:01 PM To: arslist@ARSLIST.ORG Subject: Re: Daylight savings time again I have my answer. Thanks! On 12/5/06, Alfred Differ [EMAIL PROTECTED] wrote: Hi all, Can anyone answer if there is an ARS 6.3 patch that is certified daylight savings time safe for next March? I know 7.0x is supposed to be OK, but there is a chance we won't be there in time for the zone shift. I'm on Solaris and Oracle here at Cal ISO. I have ARS 6.3 patch 14 running right now. -- -al -- -al ___ 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: what do I need to use a Palm?
Check to Aeroprise or Vaultus for complete mobile solutions. ---Original Message--- From: Rick Cook Date: 12/6/2006 9:33:50 AM To: arslist@ARSLIST.ORG Subject: Re: what do I need to use a Palm? ** If your Palms have a web browser, then they can just use a web view. If not, they'll need to have something that translates ARS to their device. There are many vendors of such interfaces out there. Rick On 12/6/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hi ARS System: 6.3 Mid-Tier 6 My question is, I need any special software from BMC software to enable My clients use their PDA in this case Palm? If yes, what it is? If no, what I need then? Best regards _ _ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Fwd: Question: SQL
Jim - thanks for your email.
I decided to go back a bit and try just looking for SOW in the filename -
here is the SQL Statement:
SELECT COUNT (Request_ID) FROM dbo.IPVPN_IPACT_Overview WHERE (Request_ID =
'$Request ID$') AND
((PATINDEX('%SOW%',UPPER(Scope_of_Work)) 0) )
It is returning 0 when I add the attachment and 1 when I delete the
attachment.
Suggestions?
Ty
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Jim Ashton
Sent: Wednesday, December 06, 2006 10:02 AM
To: arslist@ARSLIST.ORG
Subject: Re: Fwd: Question: SQL
I think you may need one more set of brackets. It appears that the query
always returns 1 because Request_ID = '$Request ID$' is always true and at
least one of the OR conditions is true somewhere in the
IPVPN_IPACT_Overview table.
Put another set of brackets around everything following the AND (as shown
below) which will result in both that particular request and at least one
of the OR conditions needing to be true to return a value.
SELECT COUNT (Request_ID) FROM dbo.IPVPN_IPACT_Overview WHERE (Request_ID =
'$Request ID$') AND ( ((PATINDEX('%SOW%', UPPER(Scope_of_Work)) 0) OR
(PATINDEX('%IPDP%', UPPER(Scope_of_Work)) 0) OR (PATINDEX('%MACD%',
UPPER(Scope_of_Work)) 0)) )
Cheers,
Jim.
___
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: ARServer 7.0.01 Memory Leaks
Axton, I remember something about a memory leak with 7.0.1 uni-code server and older clients. At this moment I don't remember the specifics but maybe this will trigger a memory synapse in others. Dave From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: Wednesday, December 06, 2006 12:53 PM To: arslist@ARSLIST.ORG Subject: ARServer 7.0.01 Memory Leaks ** Does anyone have ARS 7.0.01 in a production environment on Solaris 9 under a semi-heavy load (~200 concurrent users peak)? We are seeing some major issues with memory consumption. At startup, the arserverd process has ~400mb of memory allocated. After 2 days, this jumped to 1.8gb. On day 3 (today), it has ~2.4gb of memory allocated. Thanks, Axton Grams __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Daylight savings time again
Hopefully there will be a patch for 5.1.2 as well - there is a Planned Resolution Date of 1/15/2007 listed for that version. There is no way that my current production 5.1.2 hardware will run either 6.3 or 7.x adequately so upgrading is not an option, and at the rate our ITSM 7 build has been going we probably won't be in production on 7 by March. Christopher Strauss, Ph.D. Remedy Database Administrator University of North Texas Computing Center http://remedy.unt.edu/helpdesk/ _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook Sent: Wednesday, December 06, 2006 12:14 PM To: arslist@ARSLIST.ORG Subject: Re: Daylight savings time again ** David Easter posted here last week that a 6.3 DST patch would be out sometime in January. Rick On 12/6/06, PC Wai [EMAIL PROTECTED] wrote: Folks, In case you are not aware of this page http://www.bmc.com/info_center_support/overview/0,,19097_0_68222529,00.h tml I am not impressed of this. I have submitted my question a month ago. The reply from BMC was At this time we are not aware of the need for any patch. It is not much time left for testing and rolling out the patch before March. In fact, we have started inputting the change records for next year. Regards PC -Original Message- From: Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] On Behalf Of Alfred Differ Sent: Tuesday, December 05, 2006 1:01 PM To: arslist@ARSLIST.ORG Subject: Re: Daylight savings time again I have my answer. Thanks! On 12/5/06, Alfred Differ [EMAIL PROTECTED] wrote: Hi all, Can anyone answer if there is an ARS 6.3 patch that is certified daylight savings time safe for next March? I know 7.0x is supposed to be OK, but there is a chance we won't be there in time for the zone shift. I'm on Solaris and Oracle here at Cal ISO. I have ARS 6.3 patch 14 running right now. -- -al -- -al __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
API ARExport
Env: ARS Server 6.03 on Solaris/Sybase From Windows attempting to make an ARExport call using the C API in Visual Studio. Trying to export 1 Filter. My code compiles without issue but I keeping get the error Malloc failed on server. A snippet of the code: ARExport(control,structItems,NULL,AR_VUI_TYPE_NONE,NULL,returnStr,status) Any ideas? Anyone whose used this APIcall willing to share some code? Thank you. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Help please: IIS hangs using Mid-Tier 5.1.2 patch 1282
We've been using MidTier 5.1.2 patch 1282 for several years and would occasionally have to restart the IIS service, maybe once every 2-3 months. Now it's happening several times a week. We're upgrading to ARS 7.x in February but I'm hoping there's something that can be done now to stabilize our current environment. We are using the web for a new application but it didn't add many new users. All suggestions are welcome. Thanks. Windows 2000 MS SQL 2000 ARS Server 5.1 ARS Mid-tier 5.1.2 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: just upgraded to ARS 7.0, curious behavior questoin
The upgrade to 7.0 removes the web views on system forms. I confirmed that I still have a web fixed view of the User form on my 6.3 install but in my 7.0 that was upgraded from 6.3 the view no longer exists. I too have the orphaned buttons. My $.20 is to let them be deleted. If I remember correctly there is no workflow related to them, they are just Form Action Fields that are now useless on a 7.x Mid-Tier (anybody seen anything I may have missed in my logic?). Here is a snippet from Release-Notes-700-ESD.pdf on page 22. Changes to web views for system forms Web views for system forms have been removed because standard forms can now be displayed through the mid tier. Jason -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ivan Runions Sent: Wednesday, December 06, 2006 9:17 AM To: arslist@ARSLIST.ORG Subject: just upgraded to ARS 7.0, curious behavior questoin We've just upgraded our Test server from ARS 6.3 to ARS 7.0... no real problems in the upgrade itself. However, if I open the User form in the Admin tool and tweak something (ie. move a field left then back right where it belongs) and try to save the form, it asks me to confirm that I want to delete the fields: Modify, New Request, New Search, Query, Submit These appear to be buttons that one would use in a web view, but they are not in the one and only Default Admin View of the User form. Perhaps even more curious, if I put them in the view, you never really see them... I can find them by using the Find Field, and see their properties, but you never really see them on the form. This is curious enough that perhaps it's covered in one of the Admin 7.0 training classes, but I've never needed retraining before when doing ARS upgrades. Can someone point me in the right direction on this? I do need to tweak the User form, but am uncomfortable about deleting fields I don't understand. -ivan- -- Ivan Runions Information Technologies University of Calgary Calgary Alberta Canada (403) 220-4437 ___ 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: API ARExport
Hi Frank,
That was a very short snippet...
Here is a couple of lines from rrrChive for the version 5.1.2:
ARStructItemList exportobjects;
exportobjects.numItems = 1;
exportobjects.structItemList = (ARStructItemStruct *) m_calloc(1,
sizeof(ARStructItemStruct));
exportobjects.structItemList[0].type = AR_STRUCT_ITEM_SCHEMA;
strncpy(exportobjects.structItemList[0].name, target_form,
sizeof(ARNameType));
exportobjects.structItemList[0].selectedElements.numItems = 0;
exportobjects.structItemList[0].selectedElements.nameList = NULL;
char *exportbuf = NULL;
msglevel = ARExport(target, exportobjects, NULL, 0, exportbuf, status);
if(msglevel AR_RETURN_WARNING || status.numItems)
mlog-Log(__FILE__, __LINE__, LOG_TYPE_ARS, msglevel, 0,
ARExport(server=%s, form=%s)\n%s, target-server, target_form,
sp.Print(status, msglevel));
FreeARStatusList(status, FALSE);
if(msglevel AR_RETURN_WARNING)
{
// Is this a bug? I cant free the export buffer without crashing
// if(exportbuf)
// free(exportbuf);
m_free(exportobjects.structItemList);
return;
}
Best Regards - Misi, RRR AB, http://www.rrr.se
Env: ARS Server 6.03 on Solaris/Sybase
From Windows attempting to make an ARExport call using the C API in
Visual
Studio. Trying to export 1 Filter. My code compiles without issue but I
keeping get the error Malloc failed on server.
A snippet of the code:
ARExport(control,structItems,NULL,AR_VUI_TYPE_NONE,NULL,returnStr,status)
Any ideas?
Anyone whose used this APIcall willing to share some code?
Thank you.
___
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: Fwd: Question: SQL
Yes
-Original Message-
From: Ashton, Jim (JUS) [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 06, 2006 2:20 PM
To: Tyrone Dee; arslist@ARSLIST.ORG
Subject: RE: Fwd: Question: SQL
Does the statement work properly if you run it with a known sample value for
$Request ID$ in Query Analyzer?
-Original Message-
From: Tyrone Dee [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 06, 2006 1:37 PM
To: arslist@ARSLIST.ORG
Subject: RE: Fwd: Question: SQL
Jim - thanks for your email.
I decided to go back a bit and try just looking for SOW in the filename -
here is the SQL Statement:
SELECT COUNT (Request_ID) FROM dbo.IPVPN_IPACT_Overview WHERE (Request_ID =
'$Request ID$') AND
((PATINDEX('%SOW%',UPPER(Scope_of_Work)) 0) )
It is returning 0 when I add the attachment and 1 when I delete the
attachment.
Suggestions?
Ty
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Jim Ashton
Sent: Wednesday, December 06, 2006 10:02 AM
To: arslist@ARSLIST.ORG
Subject: Re: Fwd: Question: SQL
I think you may need one more set of brackets. It appears that the query
always returns 1 because Request_ID = '$Request ID$' is always true and at
least one of the OR conditions is true somewhere in the
IPVPN_IPACT_Overview table.
Put another set of brackets around everything following the AND (as shown
below) which will result in both that particular request and at least one
of the OR conditions needing to be true to return a value.
SELECT COUNT (Request_ID) FROM dbo.IPVPN_IPACT_Overview WHERE (Request_ID =
'$Request ID$') AND ( ((PATINDEX('%SOW%', UPPER(Scope_of_Work)) 0) OR
(PATINDEX('%IPDP%', UPPER(Scope_of_Work)) 0) OR (PATINDEX('%MACD%',
UPPER(Scope_of_Work)) 0)) )
Cheers,
Jim.
___
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: Mid Tier Login
I am going to piggy back on this one How can this be changed Currently we have the following: The word help gets directed to: http://servername/arsys/forms/servername/Remedy+Requester/Requester/ Which in turn gets redirected to the login.jsp page. Naturally our users then bookmark the login.jsp page and that will cause issues... K. O'Reilly Information Technology Midway Games From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Veanna Carr Sent: Tuesday, December 05, 2006 2:14 PM To: arslist@ARSLIST.ORG Subject: Re: Mid Tier Login ** Yes. If you use the login.jsp, you have to log on twice. If you only use the home, it works correctly. From: Action Request System discussion list(ARSList) ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Fwd: Question: SQL
Filter is firing at 500 - should I change it to 999 ?
Will that make a difference?
-Original Message-
From: Ashton, Jim (JUS) [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 06, 2006 3:27 PM
To: Tyrone Dee; arslist@ARSLIST.ORG
Subject: RE: Fwd: Question: SQL
Sounds like your filter is running before your attachment is saved. Does it
return 1 if you add a second attachment (which would actually be recognition
of the existence of the first attachment)?
-Original Message-
From: Tyrone Dee [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 06, 2006 2:29 PM
To: Ashton, Jim (JUS); arslist@ARSLIST.ORG
Subject: RE: Fwd: Question: SQL
Yes
-Original Message-
From: Ashton, Jim (JUS) [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 06, 2006 2:20 PM
To: Tyrone Dee; arslist@ARSLIST.ORG
Subject: RE: Fwd: Question: SQL
Does the statement work properly if you run it with a known sample value for
$Request ID$ in Query Analyzer?
-Original Message-
From: Tyrone Dee [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 06, 2006 1:37 PM
To: arslist@ARSLIST.ORG
Subject: RE: Fwd: Question: SQL
Jim - thanks for your email.
I decided to go back a bit and try just looking for SOW in the filename -
here is the SQL Statement:
SELECT COUNT (Request_ID) FROM dbo.IPVPN_IPACT_Overview WHERE (Request_ID =
'$Request ID$') AND
((PATINDEX('%SOW%',UPPER(Scope_of_Work)) 0) )
It is returning 0 when I add the attachment and 1 when I delete the
attachment.
Suggestions?
Ty
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Jim Ashton
Sent: Wednesday, December 06, 2006 10:02 AM
To: arslist@ARSLIST.ORG
Subject: Re: Fwd: Question: SQL
I think you may need one more set of brackets. It appears that the query
always returns 1 because Request_ID = '$Request ID$' is always true and at
least one of the OR conditions is true somewhere in the
IPVPN_IPACT_Overview table.
Put another set of brackets around everything following the AND (as shown
below) which will result in both that particular request and at least one
of the OR conditions needing to be true to return a value.
SELECT COUNT (Request_ID) FROM dbo.IPVPN_IPACT_Overview WHERE (Request_ID =
'$Request ID$') AND ( ((PATINDEX('%SOW%', UPPER(Scope_of_Work)) 0) OR
(PATINDEX('%IPDP%', UPPER(Scope_of_Work)) 0) OR (PATINDEX('%MACD%',
UPPER(Scope_of_Work)) 0)) )
Cheers,
Jim.
___
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: ARServer 7.0.01 Memory Leaks
Oh dear, I'm going to upgrade mine to ARS 7.0.01, ITSM 7.0 however in Windows Server 2003. Have not done that yet. Pending for my engineer to so some hardening on the server box first. Anyone has the same setting using windows Server 2003 and SQL2K? _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: Thursday, 07 December, 2006 01:53 To: arslist@ARSLIST.ORG Subject: ARServer 7.0.01 Memory Leaks ** Does anyone have ARS 7.0.01 in a production environment on Solaris 9 under a semi-heavy load (~200 concurrent users peak)? We are seeing some major issues with memory consumption. At startup, the arserverd process has ~400mb of memory allocated. After 2 days, this jumped to 1.8gb. On day 3 (today), it has ~2.4gb of memory allocated. Thanks, Axton Grams __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Fwd: Question: SQL
Sounds like your filter is running before your attachment is saved. Does it
return 1 if you add a second attachment (which would actually be recognition of
the existence of the first attachment)?
-Original Message-
From: Tyrone Dee [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 06, 2006 2:29 PM
To: Ashton, Jim (JUS); arslist@ARSLIST.ORG
Subject: RE: Fwd: Question: SQL
Yes
-Original Message-
From: Ashton, Jim (JUS) [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 06, 2006 2:20 PM
To: Tyrone Dee; arslist@ARSLIST.ORG
Subject: RE: Fwd: Question: SQL
Does the statement work properly if you run it with a known sample value for
$Request ID$ in Query Analyzer?
-Original Message-
From: Tyrone Dee [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 06, 2006 1:37 PM
To: arslist@ARSLIST.ORG
Subject: RE: Fwd: Question: SQL
Jim - thanks for your email.
I decided to go back a bit and try just looking for SOW in the filename -
here is the SQL Statement:
SELECT COUNT (Request_ID) FROM dbo.IPVPN_IPACT_Overview WHERE (Request_ID =
'$Request ID$') AND
((PATINDEX('%SOW%',UPPER(Scope_of_Work)) 0) )
It is returning 0 when I add the attachment and 1 when I delete the
attachment.
Suggestions?
Ty
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Jim Ashton
Sent: Wednesday, December 06, 2006 10:02 AM
To: arslist@ARSLIST.ORG
Subject: Re: Fwd: Question: SQL
I think you may need one more set of brackets. It appears that the query
always returns 1 because Request_ID = '$Request ID$' is always true and at
least one of the OR conditions is true somewhere in the
IPVPN_IPACT_Overview table.
Put another set of brackets around everything following the AND (as shown
below) which will result in both that particular request and at least one
of the OR conditions needing to be true to return a value.
SELECT COUNT (Request_ID) FROM dbo.IPVPN_IPACT_Overview WHERE (Request_ID =
'$Request ID$') AND ( ((PATINDEX('%SOW%', UPPER(Scope_of_Work)) 0) OR
(PATINDEX('%IPDP%', UPPER(Scope_of_Work)) 0) OR (PATINDEX('%MACD%',
UPPER(Scope_of_Work)) 0)) )
Cheers,
Jim.
___
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: Fwd: Question: SQL
Does the statement work properly if you run it with a known sample value for
$Request ID$ in Query Analyzer?
-Original Message-
From: Tyrone Dee [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 06, 2006 1:37 PM
To: arslist@ARSLIST.ORG
Subject: RE: Fwd: Question: SQL
Jim - thanks for your email.
I decided to go back a bit and try just looking for SOW in the filename -
here is the SQL Statement:
SELECT COUNT (Request_ID) FROM dbo.IPVPN_IPACT_Overview WHERE (Request_ID =
'$Request ID$') AND
((PATINDEX('%SOW%',UPPER(Scope_of_Work)) 0) )
It is returning 0 when I add the attachment and 1 when I delete the
attachment.
Suggestions?
Ty
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Jim Ashton
Sent: Wednesday, December 06, 2006 10:02 AM
To: arslist@ARSLIST.ORG
Subject: Re: Fwd: Question: SQL
I think you may need one more set of brackets. It appears that the query
always returns 1 because Request_ID = '$Request ID$' is always true and at
least one of the OR conditions is true somewhere in the
IPVPN_IPACT_Overview table.
Put another set of brackets around everything following the AND (as shown
below) which will result in both that particular request and at least one
of the OR conditions needing to be true to return a value.
SELECT COUNT (Request_ID) FROM dbo.IPVPN_IPACT_Overview WHERE (Request_ID =
'$Request ID$') AND ( ((PATINDEX('%SOW%', UPPER(Scope_of_Work)) 0) OR
(PATINDEX('%IPDP%', UPPER(Scope_of_Work)) 0) OR (PATINDEX('%MACD%',
UPPER(Scope_of_Work)) 0)) )
Cheers,
Jim.
___
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: ARServer 7.0.01 Memory Leaks
I received confirmation from another person that there is a memory leak on the RHEL using ARS 7.0.01 caused by older clients. Axton Grams On 12/6/06, Siti Hawa Bee SHAIK FARID [EMAIL PROTECTED] wrote: ** Oh dear, I'm going to upgrade mine to ARS 7.0.01, ITSM 7.0 however in Windows Server 2003. Have not done that yet. Pending for my engineer to so some hardening on the server box first. Anyone has the same setting using windows Server 2003 and SQL2K? -- *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Axton *Sent:* Thursday, 07 December, 2006 01:53 *To:* arslist@ARSLIST.ORG *Subject:* ARServer 7.0.01 Memory Leaks ** Does anyone have ARS 7.0.01 in a production environment on Solaris 9 under a semi-heavy load (~200 concurrent users peak)? We are seeing some major issues with memory consumption. At startup, the arserverd process has ~400mb of memory allocated. After 2 days, this jumped to 1.8gb. On day 3 (today), it has ~2.4gb of memory allocated. Thanks, Axton Grams __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Query regarding *.data file created in Session swap folder.
Hi, Check out this post on NewAtlantas site. http://www.newatlanta.com/c/products/servletexec/self_help/archiveSearch/det ail?page=1messageId=186267 Looks like it is the same issue you're having in your environment. Boris. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: ARServer 7.0.01 Memory Leaks
Hi Axton, pardon me pls but what is RHEL? And what do you mean by older clients? - Are you referring to the OS of those client's workstation pc user AR User Tools? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: Thursday, 07 December, 2006 09:50 To: arslist@ARSLIST.ORG Subject: Re: ARServer 7.0.01 Memory Leaks ** I received confirmation from another person that there is a memory leak on the RHEL using ARS 7.0.01 caused by older clients. Axton Grams On 12/6/06, Siti Hawa Bee SHAIK FARID [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: ** Oh dear, I'm going to upgrade mine to ARS 7.0.01, ITSM 7.0 however in Windows Server 2003. Have not done that yet. Pending for my engineer to so some hardening on the server box first. Anyone has the same setting using windows Server 2003 and SQL2K? _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG ] On Behalf Of Axton Sent: Thursday, 07 December, 2006 01:53 To: arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG Subject: ARServer 7.0.01 Memory Leaks ** Does anyone have ARS 7.0.01 in a production environment on Solaris 9 under a semi-heavy load (~200 concurrent users peak)? We are seeing some major issues with memory consumption. At startup, the arserverd process has ~400mb of memory allocated. After 2 days, this jumped to 1.8gb. On day 3 (today), it has ~2.4gb of memory allocated. Thanks, Axton Grams __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: SLM 7.0.01- Share:Application Properties shows wrong version
Once you install SLM patch 003, the Share:Application Properties will show that you have SLM version 7.0.01. Cheryl Young Sr. Product Manager, Service Management Business Unit BMC Software, Inc. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mary C. Sent: Wednesday, December 06, 2006 8:26 AM To: arslist@ARSLIST.ORG Subject: Re: SLM 7.0.01- Share:Application Properties shows wrong version Thanks for the replies. After I posted this, I remembered Christopher's previous post that the ITSM 7.0.01 is actually the same code as 7.0, it's just a different install version, so I guess it doesn't matter. ___ 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: Daylight savings time again
AR System 5.1.2 is unsupported and there are no plans to patch AR System 5.1.2 for DST issues. If you look at the chart, the resolution is: Install AR system 6.03 with Patch 20, or 7.0.01. Follow instructions for those AR releases. The reason it says 1/15/2007 for the resolution date is because that is when the Patch 20 for AR System 6.03 will be available. Note that, as posted by me earlier, that 7.0.01 will also require patch 001 which should be out by end of this month. The chart will be updated with this information shortly. Thanks, -David J. Easter Sr. Product Manager, Service Management Business Unit BMC Software, Inc. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of strauss Sent: Wednesday, December 06, 2006 10:47 AM To: arslist@ARSLIST.ORG Subject: Re: Daylight savings time again ** Hopefully there will be a patch for 5.1.2 as well - there is a Planned Resolution Date of 1/15/2007 listed for that version. There is no way that my current production 5.1.2 hardware will run either 6.3 or 7.x adequately so upgrading is not an option, and at the rate our ITSM 7 build has been going we probably won't be in production on 7 by March. Christopher Strauss, Ph.D. Remedy Database Administrator University of North Texas Computing Center http://remedy.unt.edu/helpdesk/ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook Sent: Wednesday, December 06, 2006 12:14 PM To: arslist@ARSLIST.ORG Subject: Re: Daylight savings time again ** David Easter posted here last week that a 6.3 DST patch would be out sometime in January. Rick On 12/6/06, PC Wai [EMAIL PROTECTED] wrote: Folks, In case you are not aware of this page http://www.bmc.com/info_center_support/overview/0,,19097_0_68222529,00.h tml I am not impressed of this. I have submitted my question a month ago. The reply from BMC was At this time we are not aware of the need for any patch. It is not much time left for testing and rolling out the patch before March. In fact, we have started inputting the change records for next year. Regards PC -Original Message- From: Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] On Behalf Of Alfred Differ Sent: Tuesday, December 05, 2006 1:01 PM To: arslist@ARSLIST.ORG Subject: Re: Daylight savings time again I have my answer. Thanks! On 12/5/06, Alfred Differ [EMAIL PROTECTED] wrote: Hi all, Can anyone answer if there is an ARS 6.3 patch that is certified daylight savings time safe for next March? I know 7.0x is supposed to be OK, but there is a chance we won't be there in time for the zone shift. I'm on Solaris and Oracle here at Cal ISO. I have ARS 6.3 patch 14 running right now. -- -al -- -al __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: what do I need to use a Palm?
hi All I need is a web browser? with that I can have access to request (Help Desk) for example? regards Rick Cook wrote: If your Palms have a web browser, then they can just use a web view. If not, they'll need to have something that translates ARS to their device. There are many vendors of such interfaces out there. Rick On 12/6/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hi ARS System: 6.3 Mid-Tier 6 My question is, I need any special software from BMC software to enable my clients use their PDA in this case Palm? If yes, what it is? if no, what i need then? best regards ___ 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 --=_Part_24825_23766385.1165425937782 Content-Type: text/html; charset=ISO-8859-1 X-Google-AttachSize: 1187 ** divIf your Palms have a web browser, then they can just use a web view.nbsp; If not, they'll need to have something that translates ARS to their device.nbsp; There are many vendors of such interfaces out there./div divnbsp;/div divRickbrnbsp;/div divspan class=gmail_quoteOn 12/6/06, b class=gmail_sendernamea href=mailto:[EMAIL PROTECTED][EMAIL PROTECTED]/a/b lt;a href=mailto:[EMAIL PROTECTED][EMAIL PROTECTED]/agt; wrote:/span blockquote class=gmail_quote style=PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solidHibrbrARS System: 6.3brMid-Tier 6brbrMy question is, I need any special software from BMC software to enable brmy clients use their PDA in this case Palm?brbrIf yes, what it is?brbrif no, what i need then?brbrbrbest regardsbrbr___br UNSUBSCRIBE or access ARSlist Archives at a href=http://www.arslist.org;www.arslist.org/a ARSlist:quot;Where the Answers Arequot;/blockquote/div __20060125___This posting was submitted with HTML in it___ --=_Part_24825_23766385.1165425937782-- ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: ARServer 7.0.01 Memory Leaks
I believe that the memory leak still exists in 7.0.x version of the server when connecting from any clients (API) version 6.x or lower/earlier. I did get a confirmation from BMC Support that the memory leak is in Red Hat Enterprise Linux (RHEL). However, I have heard from other sources that this might exist on other platforms as well. Not sure if this is going to be addressed soon. I am hoping that there will be a patch, but I won't hold my breath. HTH -- Shyam - Original Message - From: Siti Hawa Bee SHAIK FARID Newsgroups: gmane.comp.crm.arsystem.general Sent: Wednesday, December 06, 2006 5:03 PM Subject: Re: ARServer 7.0.01 Memory Leaks ** Oh dear, I'm going to upgrade mine to ARS 7.0.01, ITSM 7.0 however in Windows Server 2003. Have not done that yet. Pending for my engineer to so some hardening on the server box first. Anyone has the same setting using windows Server 2003 and SQL2K? -- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: Thursday, 07 December, 2006 01:53 To: arslist@ARSLIST.ORG Subject: ARServer 7.0.01 Memory Leaks ** Does anyone have ARS 7.0.01 in a production environment on Solaris 9 under a semi-heavy load (~200 concurrent users peak)? We are seeing some major issues with memory consumption. At startup, the arserverd process has ~400mb of memory allocated. After 2 days, this jumped to 1.8gb. On day 3 (today), it has ~2.4gb of memory allocated. Thanks, Axton Grams __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: what do I need to use a Palm?
You should be able to view a Remedy form that is made available via a Mid-tier server and appropriate Web Server software. Keep in mind that you'll probably be well-served to format a particular view of the form(s) to fit the screen format and memory limitations of the Palm. Application providers like Aeroprise take care of a lot of those things for you, or give you easy to use configuration tools to do so. Rick -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, December 06, 2006 4:02 PM To: arslist@ARSLIST.ORG Subject: Re: what do I need to use a Palm? hi All I need is a web browser? with that I can have access to request (Help Desk) for example? regards Rick Cook wrote: If your Palms have a web browser, then they can just use a web view. If not, they'll need to have something that translates ARS to their device. There are many vendors of such interfaces out there. Rick On 12/6/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hi ARS System: 6.3 Mid-Tier 6 My question is, I need any special software from BMC software to enable my clients use their PDA in this case Palm? If yes, what it is? if no, what i need then? best regards ___ 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 --=_Part_24825_23766385.1165425937782 Content-Type: text/html; charset=ISO-8859-1 X-Google-AttachSize: 1187 ** divIf your Palms have a web browser, then they can just use a web view.nbsp; If not, they'll need to have something that translates ARS to their device.nbsp; There are many vendors of such interfaces out there./div divnbsp;/div divRickbrnbsp;/div divspan class=gmail_quoteOn 12/6/06, b class=gmail_sendernamea href=mailto:[EMAIL PROTECTED][EMAIL PROTECTED]/a/b lt;a href=mailto:[EMAIL PROTECTED][EMAIL PROTECTED]/agt; wrote:/span blockquote class=gmail_quote style=PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solidHibrbrARS System: 6.3brMid-Tier 6brbrMy question is, I need any special software from BMC software to enable brmy clients use their PDA in this case Palm?brbrIf yes, what it is?brbrif no, what i need then?brbrbrbest regardsbrbr___ br UNSUBSCRIBE or access ARSlist Archives at a href=http://www.arslist.org;www.arslist.org/a ARSlist:quot;Where the Answers Arequot;/blockquote/div __20060125___This posting was submitted with HTML in it___ --=_Part_24825_23766385.1165425937782-- ___ 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: COM Automation
I would actually advocate a different approach...
Now that the Active Links have just about 100% functionality with that
a user can do. I would suggest that you build a test harness in the
form of Active Link guides. You could create a special ARS group that
would grant your test users access to these guides so that all users
are not weighted down by the objects. Then from the outside of the
User tool you would Call the guide and then check the expected
results after the action is done. (So have your guides submit one or
more records to a status form when they are done and you should be
able to make this fairly standardized.)
Remedy/BMC just did not expose enough of the right handles to remotely
control the User Tool via OLE/COM. ( I in fact think you would have
better luck trying to automate the Mid-Tier than the User Tool. But
that would likely take different tools.)
--
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 12/6/06, Hall Chad - chahal [EMAIL PROTECTED] wrote:
Thanks Tim. I'll try adding a sleep statement.
I've tried both ALT+Down (%{DOWN}) and ALT+Up (%{UP}), but neither one
does anything at all.
Chad Hall
(501) 342-2650
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers
Are
Re: Daylight savings time again
Since those are not viable options here, we will be forced to remain in production with a product with a known time error. Hopefully the impact of the DST change will be soaked up by the OS and barely visible to the ITSM 5.5 application - it doesn't make very sophisticated use of time as I recall. The BMC web page provides only thin speculation on what the effects might be. I certainly don't have time to test it, or re-purpose hardware assets to upgrade it to an ARS level we haven't tested yet unless I abandon our current effort to implement ITSM 7. RANT From what I have seen and experienced with the 7.0/7.0.01 ARS and ITSM installers and code for the last three months, there is no way this thing will be production-ready before March. We never seem to quite get to the point of configuring the applications (which will be a HUGE endeavor with IM, PM, CM, and SLM using multi-tenancy and back-end customer data imports) to where we can seriously test all of the functionality before we uncover yet another fundamental infrastructure problem that takes several more weeks to resolve (Crystal Reports Server integration since the very beginning and still broken; several weeks ago it was the CMDB 2.0.1 installer until I gave up and rebuilt the entire server, then a slew of issues with RKM, and now it's the AREA LDAP integration which is _very_ fundamental). In fact, the lack of working AREA integration to LDAP means that I could not migrate the existing 5.5 application to a 7.0.01 server anyway; it doesn't work, or at least not right now! Some of this may turn out to be on us, or because of our environment or the x64 AR servers, but so far that has seldom been the case except where I strongly objected to running SQL Server authentication for one thing or another that couldn't/wouldn't do Windows authentication. A real time-killer has been that every time support tells me to revert to an earlier db backup to re-try an installation, I lose any configuration data that I have stored while waiting on some sort of resolution, so I have given up on doing that for now. My application administrator keeps experimenting with configuration on a test installation that we know we will have to rebuild from scratch, but it will have to be manually recreated on the dev system I keep rebuilding. At this point I wish that the application code and the application configuration data were stored in separate databases so we that could save or migrate the configuration independent of the code. Eventually we will beat this crap into submission, but at this rate it will not be before March, and probably not with version 7.0.01. /RANT I certainly do not want to implement ITSM 7 half-baked and full of known problems or limitations - that would just give ammunition to those parties here that already want to switch call-tracking vendors. On the other hand, if there is a serious problem with the 5.5 application on ARS 5.1.2 once March rolls around, we may have to do just that and take the hits. What are the rest of you in similar situations thinking??? Christopher Strauss, Ph.D. Remedy Database Administrator University of North Texas Computing Center http://remedy.unt.edu/ _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Easter, David Sent: Wednesday, December 06, 2006 3:37 PM To: arslist@ARSLIST.ORG Subject: Re: Daylight savings time again ** AR System 5.1.2 is unsupported and there are no plans to patch AR System 5.1.2 for DST issues. If you look at the chart, the resolution is: Install AR system 6.03 with Patch 20, or 7.0.01. Follow instructions for those AR releases. The reason it says 1/15/2007 for the resolution date is because that is when the Patch 20 for AR System 6.03 will be available. Note that, as posted by me earlier, that 7.0.01 will also require patch 001 which should be out by end of this month. The chart will be updated with this information shortly. Thanks, -David J. Easter Sr. Product Manager, Service Management Business Unit BMC Software, Inc. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Remedy Issue
Pls give more details about the table. It seems from your query that it might be accessing data from an external table/view form where there is an error in the SQL... - Murtuza. _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Saravanan Palaniappan Sent: Wednesday, December 06, 2006 11:25 AM To: arslist@ARSLIST.ORG Subject: FW: Remedy Issue ** With Regards PL.Saravanan BTGS EXPEDIO FM | Team Virtusa (Chennai ATC) | Ph: +44-42002700 Extn: 3279 | Mobile : 99404-08691 .Email: [EMAIL PROTECTED] _ From: Rakesh Kiruba Sent: 06 December 2006 12:27 To: Remedy Team Subject: Remedy Issue Hi Team, When trying to sort the records in a table in Form (By clicking on Column name), I am getting this error when accessing through web. But sorting is possible from user side. Can any one help me on this? Thanks and Regards, Rakesh Kiruba Virtusa (India) Pvt Ltd | Ph (off): +91 - 44 - 42002700 Ext: 3120 | Mobile: +91 - 99949 37242 | __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are attachment: image001.jpg
Re: Estimation for Remedy development
Thanks Jennifer, that's exactly what I needed. Mark, Would it be possible for you to share with me a copy of the tool? Thanks On 12/6/06, Meyer, Jennifer [EMAIL PROTECTED] wrote: I did one several years ago for the Air Force, but I don't have a copy of the definition files. Mark, do you guys still use that Function-Point Analysis tool we built over there at AFWA? Essentially what we did was treat Remedy as a fourth-generation software development language, then perform function-point analysis, where we assigned a difficulty level to each requirement. Each requirement was broken down into the pieces of workflow required: Active Links, Filters, Forms, etc. Since some pieces of workflow are more complex than others, they're given a modifier with a higher number, e.g. forms are far more complex than filters, thus forms might get an 8 modifier, and filters might get a 2. Then each individual filter will be assessed as to how difficult it was based on number of actions, qualifications, etc, on a scale of 1 to 10. Finally, the skill of the developer is taken into account, and the project is given a third modifier. We pulled the formulas from a couple of textbooks on software development and function-point analysis and built the whole thing in Remedy. We even managed to tie it to our salaries and project the time it would take to complete future projects. The best part is that since Remedy is so efficient, compared to a second or third-generation development language like C, we look like GODS, coding millions of lines per year. Good luck with your efforts. Jennifer Meyer Remedy Support Engineer Strategic Technologies Inc. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jason McDonald Sent: Wednesday, December 06, 2006 10:37 AM To: arslist@ARSLIST.ORG Subject: Estimation for Remedy development ** Hi All, If anybody has developed a remedy estimation model or are aware of one that already exists, please share the same with me. I need this for one of the Remedy developments that we are currently undertaking. Thanks Jason __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
