Mid Tier Timestamp
Hi Listers, I have my mid tier in one geographical location and my AR Servers in different geographical locations. I have two AR Servers configured in that particular mid tier. These AR Servers are located in two different geographical locations with different time zone. When I view an existing ticket through web, I see the time stamp based on the mid tiers location. But when I view it from a client, it gives me the time stamp based on the locale I configure. I want to view the AR Servers time stamp from the web when I am viewing an existing ticket. Is there any way to configure the preferred time stamp in mid tier? I am using: AR Server: 5.1.2 Mid Tier: 6.3 IIS: 5 Remedy client: 5.1.2 Thanks, Suddha ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Mid Tier Timestamp
Hello Sudha, actually the displayed time when viewing a request at the Midtier should be calculated against the time setting of the local PC, right ? (pretty much as with the timezone of the user client ... if nothing is selected, the PC time should be used - with the Midtier you perhaps have to make sure that no one used a preference and selected a different timezone over there :-) Anyway... we have an international environment over here as well and maybe facing something similiar to you as well ... the Midtier Server in question is located in GMT+1. Users from other countries get their time converted at the web, based on the local PC setting. So far so good ... however we have an issue with a) some users at the CST zone, or b) maybe with CST in general. What is happening there is, that the timezone of the webserver is displayed at the web. The user client works normally, like you said. Atm I think that is a bug. Maybe related to Midtier 6.3p20 (we're using a 6.3p20 server). Have not yet opened a ticket with Remedy (suppose it would not make that much sense) and want to trigger some further testing (like what happens when they use a 7 midtier, and is it really everyone from CST or just some and so one). Good luck, Robert Mit freundlichen Grüssen Robert Kern Siemens AG GIO IT SHS SBA Sodener Str. 9 65824 Schwalbach, Germany Tel.: +49 6196 87-2546 Fax: +49 6196 87-792546 Mobil: +49 170-8522515 mailto:[EMAIL PROTECTED] Siemens Aktiengesellschaft: Vorsitzender des Aufsichtsrats: Heinrich v. Pierer; Vorstand: Klaus Kleinfeld, Vorsitzender; Johannes Feldmayer, Joe Kaeser, Rudi Lamprecht, Eduardo Montes, Jürgen Radomski, Erich R. Reinhardt, Hermann Requardt, Uriel J. Sharef, Klaus Wucherer Sitz der Gesellschaft: Berlin und München Registergericht: Berlin Charlottenburg, HRB 12300, München, HRB 6684 WEEE-Reg.-Nr. DE 23691322 Wichtiger Hinweis: Diese E-Mail und etwaige Anlagen können Betriebs- und Geschäftsgeheimnisse, dem Anwaltsgeheimnisunterliegende oder sonstige vertrauliche Informationen enthalten. Sollten Sie diese E-Mail irrtümlich erhalten haben, ist Ihnen der Status dieser E-Mail bekannt. Bitte benachrichtigen Sie uns in diesem Falle sofort durch Antwort-Mail und löschen Sie diese E-Mail nebst etwaigen Anlagen aus Ihrem System. Ebenso dürfen Sie diese E-Mail oder ihre Anlagen nicht kopieren oder an Dritte weitergeben. Vielen Dank! Important Note: This e-mail and any attachments are confidential, may contain trade secrets and may well also be legally privileged or otherwise protected from disclosure. If you have received it in error, you are on notice of its status. Please notify us immediately by reply e-mail and then delete this e-mail and any attachment from your system. If you are not the intended recipient please understand that you must not copy this e-mail or any attachments or disclose the contents to any other person. Thank you. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Suddhasil sircar Sent: Wednesday, February 07, 2007 12:03 PM To: arslist@ARSLIST.ORG Subject: Mid Tier Timestamp Hi Listers, I have my mid tier in one geographical location and my AR Servers in different geographical locations. I have two AR Servers configured in that particular mid tier. These AR Servers are located in two different geographical locations with different time zone. When I view an existing ticket through web, I see the time stamp based on the mid tiers location. But when I view it from a client, it gives me the time stamp based on the locale I configure. I want to view the AR Servers time stamp from the web when I am viewing an existing ticket. Is there any way to configure the preferred time stamp in mid tier? I am using: AR Server: 5.1.2 Mid Tier: 6.3 IIS: 5 Remedy client: 5.1.2 Thanks, Suddha ___ 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
AR Email Engin return Not connected error
Hi All, We had some problems with our email engine. After upgrading to patch 1 of 7.0.1 we now receive the following error Not connected java.lang.IllegalStateException: Not connected at com.sun.mail.smtp.SMTPTransport.checkConnected(SMTPTransport.java:1398) at com.sun.mail.smtp.SMTPTransport.sendMessage(SMTPTransport.java:489) at com.remedy.arsys.emaildaemon.SenderModule.sendMessage(SenderModule.java:359) at com.remedy.arsys.emaildaemon.SenderModule.doWork(SenderModule.java:211) at com.remedy.arsys.emaildaemon.ThreadBase.run(ThreadBase.java:268) at java.lang.Thread.run(Unknown Source) Can anyone help us on this one please? Cheers Francois ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Mid Tier Timestamp
I haven't tested this, but you can try this: Make sure the Mid-Tier has a preference server set. Login using the usertool while using the same preference server. Set the timezone using the tools-options-locale tab of the user tool settings. That should have created a prefrence record for the user. Now log on to the Mid-Tier using the same user. If designed correctly, the timezone setting will be picked up from the preference setting and the timestamp conversions will be ok. Rationale why this should work: the user tool can get the timezone setting (and locale) from the OS settings, even if nothing is configured. A web client however does not send it's timezone offset to the webserver. So without any preference set the Mid-Tier can never determine the users timezone offset and it falls back to the default timezone, which is the timezone of the Mid-Tier server. Please try it and let us know :) Hugo On 2/7/07, Kern, Robert SBA [EMAIL PROTECTED] wrote: Hello Sudha, actually the displayed time when viewing a request at the Midtier should be calculated against the time setting of the local PC, right ? (pretty much as with the timezone of the user client ... if nothing is selected, the PC time should be used - with the Midtier you perhaps have to make sure that no one used a preference and selected a different timezone over there :-) Anyway... we have an international environment over here as well and maybe facing something similiar to you as well ... the Midtier Server in question is located in GMT+1. Users from other countries get their time converted at the web, based on the local PC setting. So far so good ... however we have an issue with a) some users at the CST zone, or b) maybe with CST in general. What is happening there is, that the timezone of the webserver is displayed at the web. The user client works normally, like you said. Atm I think that is a bug. Maybe related to Midtier 6.3p20 (we're using a 6.3p20 server). Have not yet opened a ticket with Remedy (suppose it would not make that much sense) and want to trigger some further testing (like what happens when they use a 7 midtier, and is it really everyone from CST or just some and so one). Good luck, Robert Mit freundlichen Grüssen Robert Kern Siemens AG GIO IT SHS SBA Sodener Str. 9 65824 Schwalbach, Germany Tel.: +49 6196 87-2546 Fax: +49 6196 87-792546 Mobil: +49 170-8522515 mailto:[EMAIL PROTECTED] Siemens Aktiengesellschaft: Vorsitzender des Aufsichtsrats: Heinrich v. Pierer; Vorstand: Klaus Kleinfeld, Vorsitzender; Johannes Feldmayer, Joe Kaeser, Rudi Lamprecht, Eduardo Montes, Jürgen Radomski, Erich R. Reinhardt, Hermann Requardt, Uriel J. Sharef, Klaus Wucherer Sitz der Gesellschaft: Berlin und München Registergericht: Berlin Charlottenburg, HRB 12300, München, HRB 6684 WEEE-Reg.-Nr. DE 23691322 Wichtiger Hinweis: Diese E-Mail und etwaige Anlagen können Betriebs- und Geschäftsgeheimnisse, dem Anwaltsgeheimnisunterliegende oder sonstige vertrauliche Informationen enthalten. Sollten Sie diese E-Mail irrtümlich erhalten haben, ist Ihnen der Status dieser E-Mail bekannt. Bitte benachrichtigen Sie uns in diesem Falle sofort durch Antwort-Mail und löschen Sie diese E-Mail nebst etwaigen Anlagen aus Ihrem System. Ebenso dürfen Sie diese E-Mail oder ihre Anlagen nicht kopieren oder an Dritte weitergeben. Vielen Dank! Important Note: This e-mail and any attachments are confidential, may contain trade secrets and may well also be legally privileged or otherwise protected from disclosure. If you have received it in error, you are on notice of its status. Please notify us immediately by reply e-mail and then delete this e-mail and any attachment from your system. If you are not the intended recipient please understand that you must not copy this e-mail or any attachments or disclose the contents to any other person. Thank you. -Original Message- From: Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] On Behalf Of Suddhasil sircar Sent: Wednesday, February 07, 2007 12:03 PM To: arslist@ARSLIST.ORG Subject: Mid Tier Timestamp Hi Listers, I have my mid tier in one geographical location and my AR Servers in different geographical locations. I have two AR Servers configured in that particular mid tier. These AR Servers are located in two different geographical locations with different time zone. When I view an existing ticket through web, I see the time stamp based on the mid tiers location. But when I view it from a client, it gives me the time stamp based on the locale I configure. I want to view the AR Servers time stamp from the web when I am viewing an existing ticket. Is there any way to configure the preferred time stamp in mid tier? I am using: AR Server: 5.1.2 Mid Tier: 6.3 IIS: 5 Remedy client: 5.1.2 Thanks, Suddha ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: AR Report upgraded from V5.5 to V7
David thanks very much. You are a star! shafqat David Yearsley [EMAIL PROTECTED] wrote: ** Yes I have seen this. You have to manually fix the active link by selecting Report from the menu and then save. We had to do this to all of our active links. Shafqat Ayaz [EMAIL PROTECTED] Feb 06, 2007 8:08 AM ** Hi All has anyone seen this before? ARS 5.5 report running off a button. report is in AR format and NOT Crystal! Action is Window Open, type Report Report Type ARSystem Report Name: report1 Action : Run Target Screen Embedded report runs fine. bring the report to V7 The report type is changed to 1 instead of ARSystem the report runs fine. Change the numerical 1 to ARSystem report fails Error Message: The system is unable to find the report, Error Type Crystal disabled the active link, created a new active link with the same data as V5, does not run!! the same error, but if i change the report type to 1, it runs fine! ARS V7.01 SQL 2000 User Tool V7.01 Shafqat Ayaz You really shouldn't say 'I love you' unless you mean it. But if you mean it, you should say it a lot. People forget. - 8:00? 8:25? 8:40? Find a flick in no time with theYahoo! Search movie showtime shortcut. __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ Shafqat Ayaz You really shouldn't say 'I love you' unless you mean it. But if you mean it, you should say it a lot. People forget. - Check out the all-new Yahoo! Mail beta - Fire up a more powerful email and get things done faster. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Problems connecting to Oracle following 10g client install...
Brian, Upgrading Oracle in General is not a good idea, you would probably do better to do an export of your data, install Oracle 10G (if remedy supports it) and pull your data back in. I am not sure of the differences between 5 and 7 with 9.2 but the differences between 9 and 10 are numerous. John Mosco W01/GS-11 IT Coordinator Customer Support Manager PNG JFHQ J6 'We the people' From: Action Request System discussion list(ARSList) on behalf of [EMAIL PROTECTED] Sent: Tue 2/6/2007 7:05 AM To: arslist@ARSLIST.ORG Subject: Re: Problems connecting to Oracle following 10g client install... Rick, I tried upgrading an oracle 9.2 database from version 5.1.2 to 7.0.1 on my laptop. I installed the Oracle 10g client and used this as instructed. I could never get the service to start. It would always time out. I watched what Remedy was up to through Enterprise Manager and could see it talking to the database, presumably trying to build its cache. It would keep starting more and more connections. It was driving me crazy until I was advised by a colleague that you cannot upgrade from 5.1.2 to 7.0.1. You have to go through version 7.0.0 first. I don't know what the problem is though. I have now done an install of 7.0.0 over my 7.0.1 and it starts ok. I have yet to upgrade this to 7.0.1 though through lack of free time. I also want to restore the database back to 5.1.2 and try the upgrade to 7.0.0 and then 7.0.1 to see what the result is. But have yet to find the time! Brian Bishop -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Phillips Sent: 05 February 2007 17:59 To: arslist@ARSLIST.ORG Subject: Re: Problems connecting to Oracle following 10g client install... Thanks for the quick reply. I pasted a copy of tnsnames.ora in the new 10g \Network\Admin folder, but am still getting the same error. tnsping shows the correct use of sqlnet.ora and tnsnames.ora, so that looks good. Not sure what to try next. rp On Feb 5, 12:13 pm, Grooms, Frederick W [EMAIL PROTECTED] wrote: Usually each client has it's own tnsnames.ora file. Check the client install folder\Network\Admin for a tnsnames.ora file. You may need to copy the 9i one into the 10g folder. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Phillips Sent: Monday, February 05, 2007 11:03 AM To: [EMAIL PROTECTED] Subject: Problems connecting to Oracle following 10g client install... Hello all, Windows 2000 AS Ora 9i ARS 5.1.2 upgraded to 7.0.1 I installed the 10g client, but am unable to start arserver following the 7.0.1 upgrade. Found no errors in the install log, but found the following in the arerror.log Mon Feb 05 11:13:38 2007 ORA-06401: NETCMN: invalid driver designator Mon Feb 05 11:13:38 2007 390600 : Cannot initialize contact with SQL database (ARERR 551) Mon Feb 05 11:13:38 2007 Stop server Mon Feb 05 11:13:38 2007 390600 : AR System server terminated -- fatal error encountered (ARNOTE 21) I can connect via SQL Plus as ARAdmin. I have my old 9i client installed, and tnsnames.ora is in the 9i path. Was the 10g client installation supposed to create a new or modify the old tnsnames.ora file? Tia, Rick ___- UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:Where the Answers Are- Hide quoted text - - Show quoted text - ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are _ __ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Thoughts on Asset Management
Good Morning List, We are gearing up to implement CMDB 2.0 and are considering bringing on Asset Management as well. I would like to get some feedback on the Asset product. What experiences you have encountered, (good or bad), how well does it work with CMDB 2.0 and whether or not you recommend it. Thanks, .ron ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Remedy and Control-M Integration
I believe our Control-M system generates an email to our Remedy mailbox, which is then picked up by the email engine and submits at ticket. Chad Hall (501) 342-2650 From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sokol, Brian Sent: Tuesday, February 06, 2007 3:07 PM To: arslist@ARSLIST.ORG Subject: Remedy and Control-M Integration Has anyone integrated Control-M with Remedy? I would like to automatically create a ticket in the Help Desk if a job fails on Control-M. Brian Sokol Manager, Desktop Services Scholastic Inc. 557 Broadway NY, NY 10012 (212) 343-6494 http://www.Scholastic.com http://www.Scholastic.com __20060125___This posting was submitted with HTML in it___ *** 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. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Thoughts on Asset Management
I have implemented Asset 6 and am in the process of implementing Asset 7. If your company wants a strong Asset Managemnt application with the ability to bring in data from multiple resources and use the CMDB Reconciliation Engine to compare and update the data is very useful. The extras in Asset that provide relationship building for both users and dependecies can provide the CI viewer with the map of the whole network. You also have the ability of tracking contracts and using the purchasing module. if you have Change Management being able to do a full Change process that a discovery tool confirms the change was made to close it can be very useful. You can always get the sales pitch from BMC if you need more justification. -Original Message- From: [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Wed, 7 Feb 2007 9:40 AM Subject: Thoughts on Asset Management ** Good Morning List, We are gearing up to implement CMDB 2.0 and are considering bringing on Asset Management as well. I would like to get some feedback on the Asset product. What experiences you have encountered, (good or bad), how well does it work with CMDB 2.0 and whether or not you recommend it. Thanks, .ron __20060125___This posting was submitted with HTML in it___ 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
MT not acting like client
Guys, I have a web view of Help Desk 6 that is acting differently from the client, and I can't figure out why. I have added a Save New button, which does a PERFORM-ACTION-APPLY to save the ticket, NULLs out a few fields, and then sets the focus to the field at the top of the form to allow the user to enter another ticket. The workflow runs perfectly in the v7 UT, but closes the window immediately after the PERFORM-ACTION-APPLY in the MT. I've flushed cache, cleared temp files, etc., but nothing seems to help. Any ideas to try? -- Rick Cook Cook Enterprises 253-278-4112 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Why not to change Status values?
I have a few important users who are suggesting that my organization should change our status values. Does anyone know of some compelling documentation that say why not to do this? I have many reasons of my own such as the workflow, records, and updating issues this would cause, but I was looking for something official if it exists. Thanks Kyle -- Kyle Whitley IT System Support Professional Office of Information and Instructional Technology (OIIT) Board of Regents of the University System of Georgia ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Anybody able to use Knowledge Base search lately?
Axton, I have bmc.com as a trusted site...in my IE. I don't see many people complaining. Can somebody tell me if they are consistently able to use any of the features (KB, downloads, documents) and, if you are, what operating system, browser/version/patch jre version are you using? Also, if you are connecting throught VPN or not. One time yesterday everything was working perfectly for mefor a brief period. It was like magic. Only changes I had made was that instead of connecting through VPN I had a direct connection and I had removed JRE/JDK 1.5.x and left only 1.4.2.x. Everything worked perfectly on IE on the support site. Little later, it stopped working (can't remember anything I might have done). Today the same story. I am back to square one. VPN/No VPN seems to make no difference and my JRE version remains at 1.4.2.x. I have Win XP pro sp2, IE 6.0, Fireforx 1.5.0.9, Netscape 7.2. Everybody can't be having such issues and remaining quiet. Or are you? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Tally NetCensus Integration
Hi all, The Remedy Concepts Guide for 6.3 says that Tally NetCensus can integrate with Asset Management using third-party tools. Does anyone know of any of these tools that integrate these two systems? Any help would be greatly appreciated. Thanks! Greg Donalson ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Tally NetCensus Integration
Greg, I have integrated Tally TSCensus (now from Novell named Zen Asset Management). Is Tally NetCensus a different version of TSCensus? Stephen From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Greg Donalson Sent: Wednesday, February 07, 2007 10:40 AM To: arslist@ARSLIST.ORG Subject: Tally NetCensus Integration Hi all, The Remedy Concepts Guide for 6.3 says that Tally NetCensus can integrate with Asset Management using third-party tools. Does anyone know of any of these tools that integrate these two systems? Any help would be greatly appreciated. Thanks! Greg Donalson __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: AR Email Engin return Not connected error
What version of java is the email engine using? Try and telnet from the remedy server to the smtp server using the hostname/port you have specified in the Email Mailbox Configuration form. Axton Grams On 2/7/07, Francois - BTT [EMAIL PROTECTED] wrote: ** Hi All, We had some problems with our email engine. After upgrading to patch 1 of 7.0.1 we now receive the following error Not connected java.lang.IllegalStateException: Not connected at com.sun.mail.smtp.SMTPTransport.checkConnected(SMTPTransport.java:1398) at com.sun.mail.smtp.SMTPTransport.sendMessage(SMTPTransport.java:489) at com.remedy.arsys.emaildaemon.SenderModule.sendMessage(SenderModule.java :359) at com.remedy.arsys.emaildaemon.SenderModule.doWork(SenderModule.java:211) at com.remedy.arsys.emaildaemon.ThreadBase.run(ThreadBase.java:268) at java.lang.Thread.run(Unknown Source) Can anyone help us on this one please? Cheers Francois __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Anyone run ITSM 5.5 against ARS 7.0.1?
Kyle - Are you planning to upgrade from ITSM 5.5 directly to ITSM 7.X? Just asking because my experience with upgrading to ITSM 6.0 after upgrading to ARS 7.0 was not pretty. The CMBD didn't install correctly, and I got errors that wouldn't go away until I ripped everything out and started over, installing ITSM 6.0 on ARS 6.3. Fortunately, this was my dev environment. That said, I can't imagine why ITSM 5.5 wouldn't run on ARS 7.0.1 just fine. Thanks, Ron Tools Admin -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kyle Whitley Sent: Wednesday, January 24, 2007 6:27 AM To: arslist@ARSLIST.ORG Subject: Re: Anyone run ITSM 5.5 against ARS 7.0.1? Anyone using this or have seen this work. Thanks Kyle Kyle Whitley wrote: Just wondering if anyone has ran the ITSM 5.5 applications on ARS 7.0.1? We plan on upgrading the apps, but this would happen after the ARS is upgrade across all our servers. Thanks Kyle -- Kyle Whitley IT System Support Professional Office of Information and Instructional Technology (OIIT) Board of Regents of the University System of Georgia ___ 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: Tally NetCensus Integration
Stephen, They are actually using version 7 on ZenWorks and are thinking of upgrading to 7.5. Had any success with this? Greg Donalson Remedy Approved Consultant Entaq, Inc. w# - 281-893-1800 c# - 832-689-2344 www.entaq.com From: Heider, Stephen Sent: Wed 2/7/2007 9:47 AM To: arslist@ARSLIST.ORG Subject: Re: Tally NetCensus Integration ** Greg, I have integrated Tally TSCensus (now from Novell named Zen Asset Management). Is Tally NetCensus a different version of TSCensus? Stephen From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Greg Donalson Sent: Wednesday, February 07, 2007 10:40 AM To: arslist@ARSLIST.ORG Subject: Tally NetCensus Integration Hi all, The Remedy Concepts Guide for 6.3 says that Tally NetCensus can integrate with Asset Management using third-party tools. Does anyone know of any of these tools that integrate these two systems? Any help would be greatly appreciated. Thanks! Greg Donalson __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
Mid Tier Installation 7.0.1 Patch 001 JDK error....
Hey Listers, Just installed Mid Tier and Tomcat on our Windows 2003 server and of course it is not working. When I started the installation, it gave me the error that JDK is not installed. I installed the latest JDK (jdk-1_5_0_11-windows-i586-p.exe) and even tried to reinstall it (says that it's already installed). I checked the KB on the BMC site and this error came up, but said that it was due to installing the j2sdkee version (j2skdee is the Java 2 SDK, Enterprise Edition.) This version will not be recognized by the Mid-Tier installer. I'm pretty sure I have the correct version. I'm not even sure that this is causing the problem, but I thought I would start there Lisa ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Display Group List in Names
We were trying this for over 3 hours, can't figure out how this can be done. We want to display all the groups that a support person is a member of, on windows open of a form. In User form, the group list stores group IDs in the database, I was trying to convert the IDs to names, using replace, substr functions, and direct SQL didn't work. Remedy User tool can display group names when User form is opened; nothing was captured in workflow logging on how remedy convert group name from group ID. Can someone shed lights? Tia, Jason Niu Sr. Remedy System Engineer Remedy System Operation GETS - Enterprise Systems Management Email:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 135 W 50th Street, NYC,NY,10020 - The information contained in this transmission may be privileged and confidential and is intended only for the use of the person(s) named above. If you are not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you are not the intended recipient, please contact the sender immediately by reply e-mail and destroy all copies of the original message. Please note that we do not accept account orders and/or instructions by e-mail, and therefore will not be responsible for carrying out such orders and/or instructions. If you, as the intended recipient of this message, the purpose of which is to inform and update our clients, prospects and consultants of developments relating to our services and products, would not like to receive further e-mail correspondence from the sender, please reply to the sender indicating your wishes. In the U.S.: 1345 Avenue of the Americas, New York, NY 10105. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Areattachment: Pie_Charts_Bkgrd.JPG
use of ' in sql calls
Situation: We have a field containing department names (called UnitName
in the sql call below). Some of these names have an apostrophe (') in
the name.
We have an Active link that does an sql call
SELECT MAX(zDepCount) FROM FS_AuditCashDeposit_Main WHERE '$UnitName$'
= UnitName AND '$DepartmentNumber$' = DepartmentNumber AND '$RequestID$'
!= RequestID
This SELECT statement worked fine under ARS 6.3, going to an Oracle 9i
database (accessed via Oracle 9 client libraries).
We have just upgraded our server to ARS 7.0.00 patch 2, going to an
Oracle 9i database (access via Oracle 10 client libraries), and we now
get errored out on these calls with the error:
Arerr [552] Failure during SQL Operation to the database ORA-01756
Quoting string not properly terminated.
The error only occurs when the Unitname contains an apostrophe, and
obviously, it is mucking up the sql statement.
Does anyone have any thoughts/pointers, as
a) how to work around this
b) whether it's the ARS upgrade or the Oracle 10 client library change)
that might be causing this
Actually, I only need help with (b) if I can't determine how to do (a).
thanks
-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
Re: use of ' in sql calls
On a related note (and perhaps this should be a new subject line), but
in ARS 6.3 we use the Dev_AR_Apps_Basic_English and
Dev_AR_Apps_Adv_English pdf's all the time.
In ARS 7.0 I do not see the logical upgraded replacement for these
documents (so I'm still going to the 6.3 ones).
Am I missing finding these somewhere?
tia
-ivan-
Ivan Runions wrote:
Situation: We have a field containing department names (called
UnitName in the sql call below). Some of these names have an
apostrophe (') in the name.
We have an Active link that does an sql call
SELECT MAX(zDepCount) FROM FS_AuditCashDeposit_Main WHERE '$UnitName$'
= UnitName AND '$DepartmentNumber$' = DepartmentNumber AND
'$RequestID$' != RequestID
This SELECT statement worked fine under ARS 6.3, going to an Oracle 9i
database (accessed via Oracle 9 client libraries).
We have just upgraded our server to ARS 7.0.00 patch 2, going to an
Oracle 9i database (access via Oracle 10 client libraries), and we now
get errored out on these calls with the error:
Arerr [552] Failure during SQL Operation to the database ORA-01756
Quoting string not properly terminated.
The error only occurs when the Unitname contains an apostrophe, and
obviously, it is mucking up the sql statement.
Does anyone have any thoughts/pointers, as
a) how to work around this
b) whether it's the ARS upgrade or the Oracle 10 client library
change) that might be causing this
Actually, I only need help with (b) if I can't determine how to do (a).
thanks
-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
Re: use of ' in sql calls
Ivan,
Apostrophes are something that will need to planned for anytime you make
calls to a SQL database directly. But, it's quick to do.
In a Set Fields, replace the single ' with two '' using the Remedy
REPLACE() function. Store the result in a tmp field. Then use the tmp
field in your SQL statement.
Stephen
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Ivan Runions
Sent: Wednesday, February 07, 2007 11:28 AM
To: arslist@ARSLIST.ORG
Subject: use of ' in sql calls
Situation: We have a field containing department names (called UnitName
in the sql call below). Some of these names have an apostrophe (') in
the name.
We have an Active link that does an sql call
SELECT MAX(zDepCount) FROM FS_AuditCashDeposit_Main WHERE '$UnitName$'
= UnitName AND '$DepartmentNumber$' = DepartmentNumber AND '$RequestID$'
!= RequestID
This SELECT statement worked fine under ARS 6.3, going to an Oracle 9i
database (accessed via Oracle 9 client libraries).
We have just upgraded our server to ARS 7.0.00 patch 2, going to an
Oracle 9i database (access via Oracle 10 client libraries), and we now
get errored out on these calls with the error:
Arerr [552] Failure during SQL Operation to the database ORA-01756
Quoting string not properly terminated.
The error only occurs when the Unitname contains an apostrophe, and
obviously, it is mucking up the sql statement.
Does anyone have any thoughts/pointers, as
a) how to work around this
b) whether it's the ARS upgrade or the Oracle 10 client library change)
that might be causing this
Actually, I only need help with (b) if I can't determine how to do (a).
thanks
-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: Display Group List in Names
I have a field called Submitters Group. On submit it sets field Submitters Group=$GROUP$ I think that is what you are looking for. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Niu, Jason Sent: Wednesday, February 07, 2007 11:28 AM To: arslist@ARSLIST.ORG Subject: Display Group List in Names ** We were trying this for over 3 hours, can't figure out how this can be done. We want to display all the groups that a support person is a member of, on windows open of a form. In User form, the group list stores group IDs in the database, I was trying to convert the IDs to names, using replace, substr functions, and direct SQL didn't work. Remedy User tool can display group names when User form is opened; nothing was captured in workflow logging on how remedy convert group name from group ID. Can someone shed lights? Tia, Jason Niu Sr. Remedy System Engineer Remedy System Operation GETS - Enterprise Systems Management Email: mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] 135 W 50th Street, NYC,NY,10020 - The information contained in this transmission may be privileged and confidential and is intended only for the use of the person(s) named above. If you are not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you are not the intended recipient, please contact the sender immediately by reply e-mail and destroy all copies of the original message. Please note that we do not accept account orders and/or instructions by e-mail, and therefore will not be responsible for carrying out such orders and/or instructions. If you, as the intended recipient of this message, the purpose of which is to inform and update our clients, prospects and consultants of developments relating to our services and products, would not like to receive further e-mail correspondence from the sender, please reply to the sender indicating your wishes. In the U.S.: 1345 Avenue of the Americas, New York, NY 10105. __20060125___This posting was submitted with HTML in it___ STATEMENT OF CONFIDENTIALITY: The information contained in this message or any attachments to this message are intended only for the person(s) or entity to which it is addressed and may contain confidential and/or privileged material as well as being protected from disclosure. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is strictly prohibited. If you received this in error, please contact us immediately and delete the material from any computer. Thank You. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Areattachment: Pie_Charts_Bkgrd.JPG
Re: Anyone run ITSM 5.5 against ARS 7.0.1?
I would recommend a new ITSM 7 install and then re-create workflow where needed by either doing def file exports and imports or creating new on 7. I am presently doing a 5.5 to 7 and it has been easy so far. -Original Message- From: [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Wed, 7 Feb 2007 11:05 AM Subject: Re: Anyone run ITSM 5.5 against ARS 7.0.1? Kyle - Are you planning to upgrade from ITSM 5.5 directly to ITSM 7.X? Just asking because my experience with upgrading to ITSM 6.0 after upgrading to ARS 7.0 was not pretty. The CMBD didn't install correctly, and I got errors that wouldn't go away until I ripped everything out and started over, installing ITSM 6.0 on ARS 6.3. Fortunately, this was my dev environment. That said, I can't imagine why ITSM 5.5 wouldn't run on ARS 7.0.1 just fine. Thanks, Ron Tools Admin -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kyle Whitley Sent: Wednesday, January 24, 2007 6:27 AM To: arslist@ARSLIST.ORG Subject: Re: Anyone run ITSM 5.5 against ARS 7.0.1? Anyone using this or have seen this work. Thanks Kyle Kyle Whitley wrote: Just wondering if anyone has ran the ITSM 5.5 applications on ARS 7.0.1? We plan on upgrading the apps, but this would happen after the ARS is upgrade across all our servers. Thanks Kyle -- Kyle Whitley IT System Support Professional Office of Information and Instructional Technology (OIIT) Board of Regents of the University System of Georgia ___ 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 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: Mid Tier Installation 7.0.1 Patch 001 JDK error....
Just out of curiosity does anyone know why the New Atlanta ServletEXEC is no longer included in the installation scripts? Christopher P. Gillman Senior Consultant generationE Technologies 847.902.2972 [EMAIL PROTECTED] -Original Message- From: Kemes, Lisa [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: 2/7/07 10:27 AM Subject: Mid Tier Installation 7.0.1 Patch 001 JDK error Hey Listers, Just installed Mid Tier and Tomcat on our Windows 2003 server and of course it is not working. When I started the installation, it gave me the error that JDK is not installed. I installed the latest JDK (jdk-1_5_0_11-windows-i586-p.exe) and even tried to reinstall it (says that it's already installed). I checked the KB on the BMC site and this error came up, but said that it was due to installing the j2sdkee version (j2skdee is the Java 2 SDK, Enterprise Edition.) This version will not be recognized by the Mid-Tier installer. I'm pretty sure I have the correct version. I'm not even sure that this is causing the problem, but I thought I would start there Lisa ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Display Group List in Names
Put in an active link that runs on window open that has an If Action of Message (Note) that says: User is a group of: $GROUPS$ This will give you the English names of the groups. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Niu, Jason Sent: Wednesday, February 07, 2007 10:28 AM To: arslist@ARSLIST.ORG Subject: Display Group List in Names We were trying this for over 3 hours, can't figure out how this can be done. We want to display all the groups that a support person is a member of, on windows open of a form. In User form, the group list stores group IDs in the database, I was trying to convert the IDs to names, using replace, substr functions, and direct SQL didn't work. Remedy User tool can display group names when User form is opened; nothing was captured in workflow logging on how remedy convert group name from group ID. Can someone shed lights? Tia, Jason Niu Sr. Remedy System Engineer Remedy System Operation GETS - Enterprise Systems Management Email:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 135 W 50th Street, NYC,NY,10020 - The information contained in this transmission may be privileged and confidential and is intended only for the use of the person(s) named above. If you are not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you are not the intended recipient, please contact the sender immediately by reply e-mail and destroy all copies of the original message. Please note that we do not accept account orders and/or instructions by e-mail, and therefore will not be responsible for carrying out such orders and/or instructions. If you, as the intended recipient of this message, the purpose of which is to inform and update our clients, prospects and consultants of developments relating to our services and products, would not like to receive further e-mail correspondence from the sender, please reply to the sender indicating your wishes. In the U.S.: 1345 Avenue of the Americas, New York, NY 10105. __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: Mid Tier Installation 7.0.1 Patch 001 JDK error....
Lisa, I don't think the 1.5 version of Java is supported at any level of ARS at the moment. The latest 1.4 should work just fine. Rick On 2/7/07, Kemes, Lisa [EMAIL PROTECTED] wrote: ** Hey Listers, Just installed Mid Tier and Tomcat on our Windows 2003 server and of course it is not working. When I started the installation, it gave me the error that JDK is not installed. I installed the latest JDK (jdk-1_5_0_11-windows-i586-p.exe) and even tried to reinstall it (says that it's already installed). I checked the KB on the BMC site and this error came up, but said that it was due to installing the j2sdkee version (j2skdee is the Java 2 SDK, Enterprise Edition.) This version will not be recognized by the Mid-Tier installer. I'm pretty sure I have the correct version. I'm not even sure that this is causing the problem, but I thought I would start there Lisa ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Mid Tier Installation 7.0.1 Patch 001 JDK error....
The matrix for Remedy Mid Tier says 1.4.2 or 5.0 (which is really 1.5.11) From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook Sent: Wednesday, February 07, 2007 11:40 AM To: arslist@ARSLIST.ORG Subject: Re: Mid Tier Installation 7.0.1 Patch 001 JDK error ** Lisa, I don't think the 1.5 version of Java is supported at any level of ARS at the moment. The latest 1.4 should work just fine. Rick On 2/7/07, Kemes, Lisa [EMAIL PROTECTED] wrote: ** Hey Listers, Just installed Mid Tier and Tomcat on our Windows 2003 server and of course it is not working. When I started the installation, it gave me the error that JDK is not installed. I installed the latest JDK (jdk-1_5_0_11-windows-i586-p.exe) and even tried to reinstall it (says that it's already installed). I checked the KB on the BMC site and this error came up, but said that it was due to installing the j2sdkee version (j2skdee is the Java 2 SDK, Enterprise Edition.) This version will not be recognized by the Mid-Tier installer. I'm pretty sure I have the correct version. I'm not even sure that this is causing the problem, but I thought I would start there Lisa __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Anyone run ITSM 5.5 against ARS 7.0.1?
I concur with Ron's assessment. My own most recent upgrade of this type was done on a new server (i.e. not the current production server), so the errors were not critically impacting, but it did require some re-installs and such. Also know that you get an unpatched CMDB with ITSM 6 - you'll have to factor in upgrading that to at least 1.1 patch 3, unless you want to listen to Support constantly telling you that you need to do that. All that being said, we have Help Desk and Change 6.0 running fine on ARS 7.0 patch 2 now. Rick On 2/7/07, Ron Legters [EMAIL PROTECTED] wrote: Kyle - Are you planning to upgrade from ITSM 5.5 directly to ITSM 7.X? Just asking because my experience with upgrading to ITSM 6.0 after upgrading to ARS 7.0 was not pretty. The CMBD didn't install correctly, and I got errors that wouldn't go away until I ripped everything out and started over, installing ITSM 6.0 on ARS 6.3. Fortunately, this was my dev environment. That said, I can't imagine why ITSM 5.5 wouldn't run on ARS 7.0.1 just fine. Thanks, Ron Tools Admin -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kyle Whitley Sent: Wednesday, January 24, 2007 6:27 AM To: arslist@ARSLIST.ORG Subject: Re: Anyone run ITSM 5.5 against ARS 7.0.1? Anyone using this or have seen this work. Thanks Kyle Kyle Whitley wrote: Just wondering if anyone has ran the ITSM 5.5 applications on ARS 7.0.1? We plan on upgrading the apps, but this would happen after the ARS is upgrade across all our servers. Thanks Kyle -- Kyle Whitley IT System Support Professional Office of Information and Instructional Technology (OIIT) Board of Regents of the University System of Georgia ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Mid Tier Installation 7.0.1 Patch 001 JDK error....
BMC released a statement of direction white paper regarding the future of Servlet Exec and the ARS. It is avaliable in the documentation section of the Support website. Basically, BMC's contract with New Atlanta expired and they decided to use Tomcat instead. Kyle Christopher P. Gillman wrote: Just out of curiosity does anyone know why the New Atlanta ServletEXEC is no longer included in the installation scripts? Christopher P. Gillman Senior Consultant generationE Technologies 847.902.2972 [EMAIL PROTECTED] -Original Message- From: Kemes, Lisa [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: 2/7/07 10:27 AM Subject: Mid Tier Installation 7.0.1 Patch 001 JDK error Hey Listers, Just installed Mid Tier and Tomcat on our Windows 2003 server and of course it is not working. When I started the installation, it gave me the error that JDK is not installed. I installed the latest JDK (jdk-1_5_0_11-windows-i586-p.exe) and even tried to reinstall it (says that it's already installed). I checked the KB on the BMC site and this error came up, but said that it was due to installing the j2sdkee version (j2skdee is the Java 2 SDK, Enterprise Edition.) This version will not be recognized by the Mid-Tier installer. I'm pretty sure I have the correct version. I'm not even sure that this is causing the problem, but I thought I would start there Lisa ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are -- Kyle Whitley IT System Support Professional Office of Information and Instructional Technology (OIIT) Board of Regents of the University System of Georgia ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Display Group List in Names
Did you use the $GROUPS$ variable? You could also look at the Active Link that runs when, on the Group form, you click the Show Members button/link. Rick On 2/7/07, Niu, Jason [EMAIL PROTECTED] wrote: ** We were trying this for over 3 hours, can't figure out how this can be done. We want to display all the groups that a support person is a member of, on windows open of a form. In User form, the group list stores group IDs in the database, I was trying to convert the IDs to names, using replace, substr functions, and direct SQL didn't work. Remedy User tool can display group names when User form is opened; nothing was captured in workflow logging on how remedy convert group name from group ID. Can someone shed lights? Tia, *Jason Niu* *Sr. Remedy System Engineer* Remedy System Operation GETS - Enterprise Systems Management *Email:[EMAIL PROTECTED] *135 W 50th Street, NYC,NY,10020* ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: use of ' in sql calls
Ivan, inquire from support about the following defect:
SW00256669 Server not escaping single quotes in Direct SQL
This is from the 7.0.1 p001 release notes. I would have imagined the same
were addressed in 7.0p002 since the release times were close.
Axton Grams
On 2/7/07, Heider, Stephen [EMAIL PROTECTED] wrote:
Ivan,
Apostrophes are something that will need to planned for anytime you make
calls to a SQL database directly. But, it's quick to do.
In a Set Fields, replace the single ' with two '' using the Remedy
REPLACE() function. Store the result in a tmp field. Then use the tmp
field in your SQL statement.
Stephen
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Ivan Runions
Sent: Wednesday, February 07, 2007 11:28 AM
To: arslist@ARSLIST.ORG
Subject: use of ' in sql calls
Situation: We have a field containing department names (called UnitName
in the sql call below). Some of these names have an apostrophe (') in
the name.
We have an Active link that does an sql call
SELECT MAX(zDepCount) FROM FS_AuditCashDeposit_Main WHERE '$UnitName$'
= UnitName AND '$DepartmentNumber$' = DepartmentNumber AND '$RequestID$'
!= RequestID
This SELECT statement worked fine under ARS 6.3, going to an Oracle 9i
database (accessed via Oracle 9 client libraries).
We have just upgraded our server to ARS 7.0.00 patch 2, going to an
Oracle 9i database (access via Oracle 10 client libraries), and we now
get errored out on these calls with the error:
Arerr [552] Failure during SQL Operation to the database ORA-01756
Quoting string not properly terminated.
The error only occurs when the Unitname contains an apostrophe, and
obviously, it is mucking up the sql statement.
Does anyone have any thoughts/pointers, as
a) how to work around this
b) whether it's the ARS upgrade or the Oracle 10 client library change)
that might be causing this
Actually, I only need help with (b) if I can't determine how to do (a).
thanks
-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
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers
Are
Re: use of ' in sql calls
Stephen,
Is this a change for ARS 7? I'm on 6.3 and the system automatically
replaces the single ' with 2 singles if it is in a field inside if
single quotes (like in his example). The only time I have to do the
Replace myself is if my single is in hard coded text of the statement.
i.e. Select SchemaID from ARSchema Where Name = '$NAME$'
If my $NAME$ field contains My Account's the sql log on 6.3 shows
Select SchemaID from ARSchema Where Name = 'My Account''s'
If I had hard coded a string into the SQL like
Select SchemaID from ARSchema Where Name like '%Maint''s%'
then I have to do the 2 quotes myself.
Fred
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen
Sent: Wednesday, February 07, 2007 10:32 AM
To: arslist@ARSLIST.ORG
Subject: Re: use of ' in sql calls
Ivan,
Apostrophes are something that will need to planned for anytime you make
calls to a SQL database directly. But, it's quick to do.
In a Set Fields, replace the single ' with two '' using the Remedy
REPLACE() function. Store the result in a tmp field. Then use the tmp
field in your SQL statement.
Stephen
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Ivan Runions
Sent: Wednesday, February 07, 2007 11:28 AM
To: arslist@ARSLIST.ORG
Subject: use of ' in sql calls
Situation: We have a field containing department names (called UnitName
in the sql call below). Some of these names have an apostrophe (') in
the name.
We have an Active link that does an sql call SELECT MAX(zDepCount) FROM
FS_AuditCashDeposit_Main WHERE '$UnitName$'
= UnitName AND '$DepartmentNumber$' = DepartmentNumber AND '$RequestID$'
!= RequestID
This SELECT statement worked fine under ARS 6.3, going to an Oracle 9i
database (accessed via Oracle 9 client libraries).
We have just upgraded our server to ARS 7.0.00 patch 2, going to an
Oracle 9i database (access via Oracle 10 client libraries), and we now
get errored out on these calls with the error:
Arerr [552] Failure during SQL Operation to the database ORA-01756
Quoting string not properly terminated.
The error only occurs when the Unitname contains an apostrophe, and
obviously, it is mucking up the sql statement.
Does anyone have any thoughts/pointers, as
a) how to work around this
b) whether it's the ARS upgrade or the Oracle 10 client library change)
that might be causing this
Actually, I only need help with (b) if I can't determine how to do (a).
thanks
-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
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the
Answers Are
Re: Mid Tier Installation 7.0.1 Patch 001 JDK error....
Specifically, it can be found at: http://www.bmc.com/products/documents/66/48/66648/66648.pdf Why is this change happening? The contractual relationship between New Atlanta and BMC has expired. For business reasons, the companies have mutually agreed not to extend the contract. Why include a servlet engine at all? BMC feels that it is important to provide a continued solution for those customers running IIS who do not have another servlet engine solution available. -David J. Easter 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 Kyle Whitley Sent: Wednesday, February 07, 2007 8:46 AM To: arslist@ARSLIST.ORG Subject: Re: Mid Tier Installation 7.0.1 Patch 001 JDK error BMC released a statement of direction white paper regarding the future of Servlet Exec and the ARS. It is avaliable in the documentation section of the Support website. Basically, BMC's contract with New Atlanta expired and they decided to use Tomcat instead. Kyle Christopher P. Gillman wrote: Just out of curiosity does anyone know why the New Atlanta ServletEXEC is no longer included in the installation scripts? Christopher P. Gillman Senior Consultant generationE Technologies 847.902.2972 [EMAIL PROTECTED] -Original Message- From: Kemes, Lisa [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: 2/7/07 10:27 AM Subject: Mid Tier Installation 7.0.1 Patch 001 JDK error Hey Listers, Just installed Mid Tier and Tomcat on our Windows 2003 server and of course it is not working. When I started the installation, it gave me the error that JDK is not installed. I installed the latest JDK (jdk-1_5_0_11-windows-i586-p.exe) and even tried to reinstall it (says that it's already installed). I checked the KB on the BMC site and this error came up, but said that it was due to installing the j2sdkee version (j2skdee is the Java 2 SDK, Enterprise Edition.) This version will not be recognized by the Mid-Tier installer. I'm pretty sure I have the correct version. I'm not even sure that this is causing the problem, but I thought I would start there Lisa __ _ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are -- Kyle Whitley IT System Support Professional Office of Information and Instructional Technology (OIIT) Board of Regents of the University System of Georgia ___ 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: use of ' in sql calls
Axton... I got this just after I had hit send ... figures
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Axton
Sent: Wednesday, February 07, 2007 10:49 AM
To: arslist@ARSLIST.ORG
Subject: Re: use of ' in sql calls
**
Ivan, inquire from support about the following defect:
SW00256669 Server not escaping single quotes in Direct SQL
This is from the 7.0.1 p001 release notes. I would have imagined the
same were addressed in 7.0p002 since the release times were close.
Axton Grams
On 2/7/07, Heider, Stephen [EMAIL PROTECTED] wrote:
Ivan,
Apostrophes are something that will need to planned for anytime
you make
calls to a SQL database directly. But, it's quick to do.
In a Set Fields, replace the single ' with two '' using the
Remedy
REPLACE() function. Store the result in a tmp field. Then use
the tmp
field in your SQL statement.
Stephen
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Ivan Runions
Sent: Wednesday, February 07, 2007 11:28 AM
To: arslist@ARSLIST.ORG
Subject: use of ' in sql calls
Situation: We have a field containing department names (called
UnitName
in the sql call below). Some of these names have an apostrophe
(') in
the name.
We have an Active link that does an sql call
SELECT MAX(zDepCount) FROM FS_AuditCashDeposit_Main WHERE
'$UnitName$'
= UnitName AND '$DepartmentNumber$' = DepartmentNumber AND
'$RequestID$'
!= RequestID
This SELECT statement worked fine under ARS 6.3, going to an
Oracle 9i
database (accessed via Oracle 9 client libraries).
We have just upgraded our server to ARS 7.0.00 patch 2, going to
an
Oracle 9i database (access via Oracle 10 client libraries), and
we now
get errored out on these calls with the error:
Arerr [552] Failure during SQL Operation to the database
ORA-01756
Quoting string not properly terminated.
The error only occurs when the Unitname contains an apostrophe,
and
obviously, it is mucking up the sql statement.
Does anyone have any thoughts/pointers, as
a) how to work around this
b) whether it's the ARS upgrade or the Oracle 10 client library
change)
that might be causing this
Actually, I only need help with (b) if I can't determine how to
do (a).
thanks
-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
__20060125___This posting was submitted with HTML in
it___
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the
Answers Are
Re: Display Group List in Names
Translate the group list (id's) into an external qual; point a table field to SHR:ApplicationGroups using your external qual. You then have a table field that lists all the groups. Makes user selection, walking, and other types of manipulation a breeze. Axton Grams On 2/7/07, Opela, Gary L Contr OC-ALC/ITMA [EMAIL PROTECTED] wrote: ** Put in an active link that runs on window open that has an If Action of Message (Note) that says: User is a group of: $GROUPS$ This will give you the English names of the groups. -- *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Niu, Jason *Sent:* Wednesday, February 07, 2007 10:28 AM *To:* arslist@ARSLIST.ORG *Subject:* Display Group List in Names We were trying this for over 3 hours, can't figure out how this can be done. We want to display all the groups that a support person is a member of, on windows open of a form. In User form, the group list stores group IDs in the database, I was trying to convert the IDs to names, using replace, substr functions, and direct SQL didn't work. Remedy User tool can display group names when User form is opened; nothing was captured in workflow logging on how remedy convert group name from group ID. Can someone shed lights? Tia, *Jason Niu* *Sr. Remedy System Engineer* Remedy System Operation GETS - Enterprise Systems Management *Email:[EMAIL PROTECTED] *135 W 50th Street**, NYC,NY,10020* - The information contained in this transmission may be privileged and confidential and is intended only for the use of the person(s) named above. If you are not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you are not the intended recipient, please contact the sender immediately by reply e-mail and destroy all copies of the original message. Please note that we do not accept account orders and/or instructions by e-mail, and therefore will not be responsible for carrying out such orders and/or instructions. If you, as the intended recipient of this message, the purpose of which is to inform and update our clients, prospects and consultants of developments relating to our services and products, would not like to receive further e-mail correspondence from the sender, please reply to the sender indicating your wishes. In the U.S .: 1345 Avenue of the Americas, New York, NY 10105. __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: use of ' in sql calls
This was a change of behavior in Version 7. We had to correct code in
6.3 to get it to work under 7.
Richard
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W
Sent: Wednesday, February 07, 2007 10:51 AM
To: arslist@ARSLIST.ORG
Subject: Re: use of ' in sql calls
Stephen,
Is this a change for ARS 7? I'm on 6.3 and the system automatically
replaces the single ' with 2 singles if it is in a field inside if
single quotes (like in his example). The only time I have to do the
Replace myself is if my single is in hard coded text of the statement.
i.e. Select SchemaID from ARSchema Where Name = '$NAME$'
If my $NAME$ field contains My Account's the sql log on 6.3 shows
Select SchemaID from ARSchema Where Name = 'My Account''s'
If I had hard coded a string into the SQL like
Select SchemaID from ARSchema Where Name like '%Maint''s%'
then I have to do the 2 quotes myself.
Fred
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen
Sent: Wednesday, February 07, 2007 10:32 AM
To: arslist@ARSLIST.ORG
Subject: Re: use of ' in sql calls
Ivan,
Apostrophes are something that will need to planned for anytime you make
calls to a SQL database directly. But, it's quick to do.
In a Set Fields, replace the single ' with two '' using the Remedy
REPLACE() function. Store the result in a tmp field. Then use the tmp
field in your SQL statement.
Stephen
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Ivan Runions
Sent: Wednesday, February 07, 2007 11:28 AM
To: arslist@ARSLIST.ORG
Subject: use of ' in sql calls
Situation: We have a field containing department names (called UnitName
in the sql call below). Some of these names have an apostrophe (') in
the name.
We have an Active link that does an sql call SELECT MAX(zDepCount) FROM
FS_AuditCashDeposit_Main WHERE '$UnitName$'
= UnitName AND '$DepartmentNumber$' = DepartmentNumber AND '$RequestID$'
!= RequestID
This SELECT statement worked fine under ARS 6.3, going to an Oracle 9i
database (accessed via Oracle 9 client libraries).
We have just upgraded our server to ARS 7.0.00 patch 2, going to an
Oracle 9i database (access via Oracle 10 client libraries), and we now
get errored out on these calls with the error:
Arerr [552] Failure during SQL Operation to the database ORA-01756
Quoting string not properly terminated.
The error only occurs when the Unitname contains an apostrophe, and
obviously, it is mucking up the sql statement.
Does anyone have any thoughts/pointers, as
a) how to work around this
b) whether it's the ARS upgrade or the Oracle 10 client library change)
that might be causing this
Actually, I only need help with (b) if I can't determine how to do (a).
thanks
-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
___
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 Installation 7.0.1 Patch 001 JDK error....
I''ve used the 5.0/1.5 jdk with tomcat/mid-tier without any issues. Axton Grams On 2/7/07, Rick Cook [EMAIL PROTECTED] wrote: ** Lisa, I don't think the 1.5 version of Java is supported at any level of ARS at the moment. The latest 1.4 should work just fine. Rick On 2/7/07, Kemes, Lisa [EMAIL PROTECTED] wrote: ** Hey Listers, Just installed Mid Tier and Tomcat on our Windows 2003 server and of course it is not working. When I started the installation, it gave me the error that JDK is not installed. I installed the latest JDK (jdk-1_5_0_11-windows-i586-p.exe) and even tried to reinstall it (says that it's already installed). I checked the KB on the BMC site and this error came up, but said that it was due to installing the j2sdkee version (j2skdee is the Java 2 SDK, Enterprise Edition.) This version will not be recognized by the Mid-Tier installer. I'm pretty sure I have the correct version. I'm not even sure that this is causing the problem, but I thought I would start there Lisa __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 Installation 7.0.1 Patch 001 JDK error....
Because there are better, free alternatives available. Axton Grams On 2/7/07, Christopher P. Gillman [EMAIL PROTECTED] wrote: Just out of curiosity does anyone know why the New Atlanta ServletEXEC is no longer included in the installation scripts? Christopher P. Gillman Senior Consultant generationE Technologies 847.902.2972 [EMAIL PROTECTED] -Original Message- From: Kemes, Lisa [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: 2/7/07 10:27 AM Subject: Mid Tier Installation 7.0.1 Patch 001 JDK error Hey Listers, Just installed Mid Tier and Tomcat on our Windows 2003 server and of course it is not working. When I started the installation, it gave me the error that JDK is not installed. I installed the latest JDK (jdk-1_5_0_11-windows-i586-p.exe) and even tried to reinstall it (says that it's already installed). I checked the KB on the BMC site and this error came up, but said that it was due to installing the j2sdkee version (j2skdee is the Java 2 SDK, Enterprise Edition.) This version will not be recognized by the Mid-Tier installer. I'm pretty sure I have the correct version. I'm not even sure that this is causing the problem, but I thought I would start there Lisa ___ 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: use of ' in sql calls
This may be a [welcome] change to 7.0. My redesign project for 7.0 is
on hold for other projects I haven't done much dev work in 7.x yet.
Stephen
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Richard Brooks
Sent: Wednesday, February 07, 2007 11:54 AM
To: arslist@ARSLIST.ORG
Subject: Re: use of ' in sql calls
This was a change of behavior in Version 7. We had to correct code in
6.3 to get it to work under 7.
Richard
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W
Sent: Wednesday, February 07, 2007 10:51 AM
To: arslist@ARSLIST.ORG
Subject: Re: use of ' in sql calls
Stephen,
Is this a change for ARS 7? I'm on 6.3 and the system automatically
replaces the single ' with 2 singles if it is in a field inside if
single quotes (like in his example). The only time I have to do the
Replace myself is if my single is in hard coded text of the statement.
i.e. Select SchemaID from ARSchema Where Name = '$NAME$'
If my $NAME$ field contains My Account's the sql log on 6.3 shows
Select SchemaID from ARSchema Where Name = 'My Account''s'
If I had hard coded a string into the SQL like
Select SchemaID from ARSchema Where Name like '%Maint''s%'
then I have to do the 2 quotes myself.
Fred
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen
Sent: Wednesday, February 07, 2007 10:32 AM
To: arslist@ARSLIST.ORG
Subject: Re: use of ' in sql calls
Ivan,
Apostrophes are something that will need to planned for anytime you make
calls to a SQL database directly. But, it's quick to do.
In a Set Fields, replace the single ' with two '' using the Remedy
REPLACE() function. Store the result in a tmp field. Then use the tmp
field in your SQL statement.
Stephen
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Ivan Runions
Sent: Wednesday, February 07, 2007 11:28 AM
To: arslist@ARSLIST.ORG
Subject: use of ' in sql calls
Situation: We have a field containing department names (called UnitName
in the sql call below). Some of these names have an apostrophe (') in
the name.
We have an Active link that does an sql call SELECT MAX(zDepCount) FROM
FS_AuditCashDeposit_Main WHERE '$UnitName$'
= UnitName AND '$DepartmentNumber$' = DepartmentNumber AND '$RequestID$'
!= RequestID
This SELECT statement worked fine under ARS 6.3, going to an Oracle 9i
database (accessed via Oracle 9 client libraries).
We have just upgraded our server to ARS 7.0.00 patch 2, going to an
Oracle 9i database (access via Oracle 10 client libraries), and we now
get errored out on these calls with the error:
Arerr [552] Failure during SQL Operation to the database ORA-01756
Quoting string not properly terminated.
The error only occurs when the Unitname contains an apostrophe, and
obviously, it is mucking up the sql statement.
Does anyone have any thoughts/pointers, as
a) how to work around this
b) whether it's the ARS upgrade or the Oracle 10 client library change)
that might be causing this
Actually, I only need help with (b) if I can't determine how to do (a).
thanks
-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
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where
the Answers Are
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where
the Answers Are
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the
Answers Are
Re: Anyone run ITSM 5.5 against ARS 7.0.1?
I am running the 5.6 apps against a 7.0.1 server without any issues. There were some issues getting the approval server to work properly; the correction involved adding the new fields on AP:Detail and AP:Signature to the change/approval joins. Axton Grams On 1/23/07, Kyle Whitley [EMAIL PROTECTED] wrote: Just wondering if anyone has ran the ITSM 5.5 applications on ARS 7.0.1? We plan on upgrading the apps, but this would happen after the ARS is upgrade across all our servers. Thanks Kyle -- Kyle Whitley IT System Support Professional Office of Information and Instructional Technology (OIIT) Board of Regents of the University System of Georgia ___ 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 Installation 7.0.1 Patch 001 JDK error....
Axton, Did you do a new install or an upgrade? (with Java) Lisa From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: Wednesday, February 07, 2007 11:55 AM To: arslist@ARSLIST.ORG Subject: Re: Mid Tier Installation 7.0.1 Patch 001 JDK error ** I''ve used the 5.0/1.5 jdk with tomcat/mid-tier without any issues. Axton Grams On 2/7/07, Rick Cook [EMAIL PROTECTED] wrote: ** Lisa, I don't think the 1.5 version of Java is supported at any level of ARS at the moment. The latest 1.4 should work just fine. Rick On 2/7/07, Kemes, Lisa [EMAIL PROTECTED] wrote: ** Hey Listers, Just installed Mid Tier and Tomcat on our Windows 2003 server and of course it is not working. When I started the installation, it gave me the error that JDK is not installed. I installed the latest JDK (jdk-1_5_0_11-windows-i586-p.exe) and even tried to reinstall it (says that it's already installed). I checked the KB on the BMC site and this error came up, but said that it was due to installing the j2sdkee version (j2skdee is the Java 2 SDK, Enterprise Edition.) This version will not be recognized by the Mid-Tier installer. I'm pretty sure I have the correct version. I'm not even sure that this is causing the problem, but I thought I would start there Lisa __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 Installation 7.0.1 Patch 001 JDK error....
Has anyone received this error even though they have the correct JDK installed? Did you have to do anything different? Lisa ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Tally NetCensus Integration
Greg, We have ZAM 7.5. I am not sure if we upgraded from TS Census to ZAM 7.5 directly, or to ZAM 7.0 then 7.5 (another dept). However, as I recall I did not have to change any of my code to make it work with ZAM. The method I choose took a while but has worked fine for about 2 years. It's fast and automatic. Here's how I did it in case it may give you some ideas in implementing a solution in your environment: Created several SQL Views (SQL Server 2000) that extracted the data I wanted in the format that we needed to see in Remedy. Created two tables, one for the computers (ie name, ip address, office, user) and one for the computer details (ie. hardware items, software programs, hotfixes). Created Stored Procedures that would extract any computers that had changed data. The Stored Procedures would update the two tables accordingly with the changed data. Created a SQL Job that fires every 5 minutes during business hours and runs these stored procedures. Setup Transactional (real-time) Replication between ZAM and Remedy, only for the two tables. Created Remedy View forms into the two replicated tables that reside on the Remedy server. Remedy workflow retrieves and displays the data from the Remedy View form. Since the data is local to the Remedy server, access time is very fast (the ZAM server and the Remedy server are about 1000 miles apart). A few notes: The huge data diagram pdf - the one with all the lines drawn - was what I used to figure out how ZAM pieces everything together. Printing it out on paper was helpful (it's about 3 feet x 5 feet in size). To reduce stress on the Remedy server the Replication process was setup on the ZAM server and data is Pushed to the Remedy server. To reduce stress on the ZAM server I run the stored procedures two ways. The job that runs every 5 minutes only checks for data that changed within the last 6 minutes. The result sets are relatively small. To make sure nothing is missed, early every morning I run the stored procedures with a parameter that causes all computers to be checked to see if anything changed. Here are a couple extra items that are not required for ZAM integration: On screens where computers are displayed I added the option for users to manually initiate a rescan of a computer by clicking a button. A filter then runs a ZAM command line utility with the selected computer's guid, which causes ZAM to rescan the selected computer. The new scan data appears in Remedy within 10 minutes. Depending upon how your ZAM system is configured a computer could be linked to a non-employee's account. For example, in our system a computer could be linked to an employee named Administrator because the admin was on the computer when it was built or last scanned. To make it easy for users to link a computer to an actual employee I added the option to update ZAM from Remedy by selecting the employee and clicking a button. HTH Stephen From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Greg Donalson Sent: Wednesday, February 07, 2007 11:20 AM To: arslist@ARSLIST.ORG Subject: Re: Tally NetCensus Integration Stephen, They are actually using version 7 on ZenWorks and are thinking of upgrading to 7.5. Had any success with this? Greg Donalson Remedy Approved Consultant Entaq, Inc. w# - 281-893-1800 c# - 832-689-2344 www.entaq.com From: Heider, Stephen Sent: Wed 2/7/2007 9:47 AM To: arslist@ARSLIST.ORG Subject: Re: Tally NetCensus Integration ** Greg, I have integrated Tally TSCensus (now from Novell named Zen Asset Management). Is Tally NetCensus a different version of TSCensus? Stephen From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Greg Donalson Sent: Wednesday, February 07, 2007 10:40 AM To: arslist@ARSLIST.ORG Subject: Tally NetCensus Integration Hi all, The Remedy Concepts Guide for 6.3 says that Tally NetCensus can integrate with Asset Management using third-party tools. Does anyone know of any of these tools that integrate these two systems? Any help would be greatly appreciated. Thanks! Greg Donalson __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: Mid Tier Installation 7.0.1 Patch 001 JDK error....
This was a new install of all. Installed java for the sole purpose of use by JBoss, installed JBoss and pointed it to that jdk, then copied the mid-tier war to the autodeploy directory. This was a few months back, exact versions follow: OS-System: SunOS 5.9,sparc Java HotSpot(TM) Server VM 1.5.0_08-b03 JBoss 4.0.4.GA Axton Grams On 2/7/07, Kemes, Lisa [EMAIL PROTECTED] wrote: ** Axton, Did you do a new install or an upgrade? (with Java) Lisa -- *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Axton *Sent:* Wednesday, February 07, 2007 11:55 AM *To:* arslist@ARSLIST.ORG *Subject:* Re: Mid Tier Installation 7.0.1 Patch 001 JDK error ** I''ve used the 5.0/1.5 jdk with tomcat/mid-tier without any issues. Axton Grams On 2/7/07, Rick Cook [EMAIL PROTECTED] wrote: ** Lisa, I don't think the 1.5 version of Java is supported at any level of ARS at the moment. The latest 1.4 should work just fine. Rick On 2/7/07, Kemes, Lisa [EMAIL PROTECTED] wrote: ** Hey Listers, Just installed Mid Tier and Tomcat on our Windows 2003 server and of course it is not working. When I started the installation, it gave me the error that JDK is not installed. I installed the latest JDK (jdk-1_5_0_11- windows-i586-p.exe) and even tried to reinstall it (says that it's already installed). I checked the KB on the BMC site and this error came up, but said that it was due to installing the j2sdkee version (j2skdee is the Java 2 SDK, Enterprise Edition.) This version will not be recognized by the Mid-Tier installer. I'm pretty sure I have the correct version. I'm not even sure that this is causing the problem, but I thought I would start there Lisa __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: AR Email Engin return Not connected error
If this is the case, you may want to check the server/email detail logs for failed def/xml imports to see what else failed. Axton Grams On 2/7/07, Richard Brooks [EMAIL PROTECTED] wrote: ** I had a similar issue when we upgraded form 6.3 to 7.0 patch 1. To resolve I had to delete the email forms, restart the server so Remedy would reload the forms and then redo the configuration. It worked fine after that. It appeared the upgrade did not like the forms there with data in them already. Richard Brooks -- *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Axton *Sent:* Wednesday, February 07, 2007 10:05 AM *To:* arslist@ARSLIST.ORG *Subject:* Re: AR Email Engin return Not connected error ** What version of java is the email engine using? Try and telnet from the remedy server to the smtp server using the hostname/port you have specified in the Email Mailbox Configuration form. Axton Grams On 2/7/07, *Francois - BTT* [EMAIL PROTECTED] wrote: ** Hi All, We had some problems with our email engine. After upgrading to patch 1 of 7.0.1 we now receive the following error Not connected java.lang.IllegalStateException: Not connected at com.sun.mail.smtp.SMTPTransport.checkConnected(SMTPTransport.java:1398) at com.sun.mail.smtp.SMTPTransport.sendMessage(SMTPTransport.java:489) at com.remedy.arsys.emaildaemon.SenderModule.sendMessage(SenderModule.java :359) at com.remedy.arsys.emaildaemon.SenderModule.doWork(SenderModule.java:211) at com.remedy.arsys.emaildaemon.ThreadBase.run(ThreadBase.java:268) at java.lang.Thread.run(Unknown Source) Can anyone help us on this one please? Cheers Francois __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: Mid Tier Installation 7.0.1 Patch 001 JDK error....
We use 1.5 (almost) across the board... Email, ARS, RKM, Mid-Tier (tomcat), etc. and have no issues. The exception is SLM which points at 1.4.2 Not sure of a solution to your problem Lisa... we used jdk-1_5_0_08-windows-i586-p-iftw.exe and jre-1_5_0_08-windows-i586-p-iftw.exe and didn't have an issue. :-/ (Yes, we have both installed) -- Tony Worthington [EMAIL PROTECTED] 262-703-5911 Kemes, Lisa [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 02/07/2007 10:43 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Mid Tier Installation 7.0.1 Patch 001 JDK error ** The matrix for Remedy Mid Tier says 1.4.2 or 5.0 (which is really 1.5.11) From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook Sent: Wednesday, February 07, 2007 11:40 AM To: arslist@ARSLIST.ORG Subject: Re: Mid Tier Installation 7.0.1 Patch 001 JDK error ** Lisa, I don't think the 1.5 version of Java is supported at any level of ARS at the moment. The latest 1.4 should work just fine. Rick On 2/7/07, Kemes, Lisa [EMAIL PROTECTED] wrote: ** Hey Listers, Just installed Mid Tier and Tomcat on our Windows 2003 server and of course it is not working. When I started the installation, it gave me the error that JDK is not installed. I installed the latest JDK (jdk-1_5_0_11-windows-i586-p.exe) and even tried to reinstall it (says that it's already installed). I checked the KB on the BMC site and this error came up, but said that it was due to installing the j2sdkee version (j2skdee is the Java 2 SDK, Enterprise Edition.) This version will not be recognized by the Mid-Tier installer. I'm pretty sure I have the correct version. I'm not even sure that this is causing the problem, but I thought I would start there Lisa __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ CONFIDENTIALITY NOTICE: This is a transmission from Kohl's Department Stores, Inc. and may contain information which is confidential and proprietary. If you are not the addressee, any disclosure, copying or distribution or use of the contents of this message is expressly prohibited. If you have received this transmission in error, please destroy it and notify us immediately at 262-703-7000. CAUTION: Internet and e-mail communications are Kohl's property and Kohl's reserves the right to retrieve and read any message created, sent and received. Kohl's reserves the right to monitor messages to or from authorized Kohl's Associates at any time without any further consent. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Mid Tier Installation 7.0.1 Patch 001 JDK error....
Update... I uninstalled Java 5 and installed Java 1.4.2 and started up the Mid Tier installation again and I'm no longer getting this error message, but I still can't get to the mid tier configuration site. I did a new install of IIS 6, Java, Mid Tier and Tomcat on our Windows 2003 server. Weird, you would think it would work. I'm sending a ticket to Remedy Support. thanks! Lisa From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa Sent: Wednesday, February 07, 2007 12:04 PM To: arslist@ARSLIST.ORG Subject: Re: Mid Tier Installation 7.0.1 Patch 001 JDK error ** Has anyone received this error even though they have the correct JDK installed? Did you have to do anything different? Lisa __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: use of ' in sql calls
Thanks for this info... I'll check this out.
-ivan-
Axton wrote:
**
Ivan, inquire from support about the following defect:
SW00256669 Server not escaping single quotes in Direct SQL
This is from the 7.0.1 p001 release notes. I would have imagined the
same were addressed in 7.0p002 since the release times were close.
Axton Grams
On 2/7/07, *Heider, Stephen* [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED] wrote:
Ivan,
Apostrophes are something that will need to planned for anytime
you make
calls to a SQL database directly. But, it's quick to do.
In a Set Fields, replace the single ' with two '' using the Remedy
REPLACE() function. Store the result in a tmp field. Then use the tmp
field in your SQL statement.
Stephen
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG] On
Behalf Of Ivan Runions
Sent: Wednesday, February 07, 2007 11:28 AM
To: arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG
Subject: use of ' in sql calls
Situation: We have a field containing department names (called
UnitName
in the sql call below). Some of these names have an apostrophe
(') in
the name.
We have an Active link that does an sql call
SELECT MAX(zDepCount) FROM FS_AuditCashDeposit_Main WHERE '$UnitName$'
= UnitName AND '$DepartmentNumber$' = DepartmentNumber AND
'$RequestID$'
!= RequestID
This SELECT statement worked fine under ARS 6.3, going to an Oracle 9i
database (accessed via Oracle 9 client libraries).
We have just upgraded our server to ARS 7.0.00 patch 2, going to an
Oracle 9i database (access via Oracle 10 client libraries), and we now
get errored out on these calls with the error:
Arerr [552] Failure during SQL Operation to the database ORA-01756
Quoting string not properly terminated.
The error only occurs when the Unitname contains an apostrophe, and
obviously, it is mucking up the sql statement.
Does anyone have any thoughts/pointers, as
a) how to work around this
b) whether it's the ARS upgrade or the Oracle 10 client library
change)
that might be causing this
Actually, I only need help with (b) if I can't determine how to do
(a).
thanks
-ivan-
--
Ivan Runions
Information Technologies
University of Calgary
Calgary Alberta Canada
(403) 220-4437
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
http://www.arslist.org ARSlist:Where
the Answers Are
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
http://www.arslist.org ARSlist:Where the Answers Are
__20060125___This posting was submitted with HTML
in it___
--
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
Re: Mid Tier Installation 7.0.1 Patch 001 JDK error....
Support told me they are recommending JBOSS instead of Tomcat ? it is faster and better to work with... Ask them about that as well.. On 2/7/07, Kemes, Lisa [EMAIL PROTECTED] wrote: ** Update... I uninstalled Java 5 and installed Java 1.4.2 and started up the Mid Tier installation again and I'm no longer getting this error message, but I still can't get to the mid tier configuration site. I did a new install of IIS 6, Java, Mid Tier and Tomcat on our Windows 2003 server. Weird, you would think it would work. I'm sending a ticket to Remedy Support. thanks! Lisa -- *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Kemes, Lisa *Sent:* Wednesday, February 07, 2007 12:04 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Mid Tier Installation 7.0.1 Patch 001 JDK error ** Has anyone received this error even though they have the correct JDK installed? Did you have to do anything different? Lisa __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: Mid Tier Installation 7.0.1 Patch 001 JDK error....
Boy I wish they'd make up their mind =) -- Tony Worthington [EMAIL PROTECTED] 262-703-5911 patrick zandi [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 02/07/2007 12:29 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Mid Tier Installation 7.0.1 Patch 001 JDK error ** Support told me they are recommending JBOSS instead of Tomcat ? it is faster and better to work with... Ask them about that as well.. On 2/7/07, Kemes, Lisa [EMAIL PROTECTED] wrote: ** Update... I uninstalled Java 5 and installed Java 1.4.2 and started up the Mid Tier installation again and I'm no longer getting this error message, but I still can't get to the mid tier configuration site. I did a new install of IIS 6, Java, Mid Tier and Tomcat on our Windows 2003 server. Weird, you would think it would work. I'm sending a ticket to Remedy Support. thanks! Lisa From: Action Request System discussion list(ARSList) [mailto: ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Remedy 6.3 Slow Searches
We use Remedy 6.3 and have close to 65,000 tickets in the database. These are spread over thousands of users with most users having 10-15 tickets. However, we use a generic user account to login tickets that don¹t belong to a particular user. This account has accumulated about 15,000 of the 65,000 tickets and it makes searching for tickets that involve that account go rather slowly. Instead of immediate response from the system while going down search results for a particular user, it stalls for 5-30 seconds when the search results are generated on that generic user. We are wondering what we can do to speed up these searches (if it is at all possible) short of archiving the tickets for that user or creating a new generic username. Any help would be appreciated. Gene geneushinsky OIT - Service Desks Support Manager [EMAIL PROTECTED] | MB 161A | 801.422.2716 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Remedy 6.3 Slow Searches
Gene, Most of this issue is caused by the Requesters Cases (Table). You may wish to exclude that User Requester from the table field refresh. Or change it to something like the below Doug Tanner Senior Developer Remedy Skilled Professional (RSP) Former RAC (704) 328-3178 [EMAIL PROTECTED] From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Gene Ushinsky Sent: Wednesday, February 07, 2007 1:41 PM To: arslist@ARSLIST.ORG Subject: Remedy 6.3 Slow Searches We use Remedy 6.3 and have close to 65,000 tickets in the database. These are spread over thousands of users with most users having 10-15 tickets. However, we use a generic user account to login tickets that don't belong to a particular user. This account has accumulated about 15,000 of the 65,000 tickets and it makes searching for tickets that involve that account go rather slowly. Instead of immediate response from the system while going down search results for a particular user, it stalls for 5-30 seconds when the search results are generated on that generic user. We are wondering what we can do to speed up these searches (if it is at all possible) short of archiving the tickets for that user or creating a new generic username. Any help would be appreciated. Gene geneushinsky OIT - Service Desks Support Manager [EMAIL PROTECTED] | MB 161A | 801.422.2716 __20060125___This posting was submitted with HTML in it___ DISCLAIMER Important! This message is intended for the above named person(s) only and is CONFIDENTIAL AND PROPRIETARY. If you are not the intended recipient of this e-mail and have received it in error, please immediately notify the sender by return email and then delete it from your mailbox. This message may be protected by the attorney-client privilege and/or work product doctrine. Accessing, copying, disseminating or re-using any of the information contained in this e-mail by anyone other than the intended recipient is strictly prohibited. Finally, you should check this email and any attachments for the presence of viruses, as the sender accepts no liability for any damage caused by any virus transmitted by this email. Thank you. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are attachment: image001.jpg
Re: ARS+Oracle InstantClient information
Axton.. Me and Tony were just discussing this.. Hopefully Tony will figure this out.. but he has just figured out it works with one scenario, but not another.. So I am guessing.. Configuration issues are too mind boggling.. and thus we (remedy) just decided .. Fat client only... I will wait for Tony's Answeres.. FYI On 2/1/07, Axton [EMAIL PROTECTED] wrote: ** I don't see why it would not be supported. It's the specific portion of the Oracle client that Remedy uses - the OCI api. Axton Grams On 2/1/07, Tony Worthington [EMAIL PROTECTED] wrote: I don't know if BMC supports it. They should, as it's an official Oracle client. No matches in the knowledge-base (shocker.) and the Compat Matrix isn't clear on clients except for saying Requires 32-bit Oracle 10gR2 database client for connecting to the Oracle database, Oracle RAC supported -- InstantClient is a 32 bit 10gR2 client which supports TAF+RAC And the (7x) installer runs just fine with no TWO_TASK for a remote DB. As does SLM, and everything else. -tony -- Tony Worthington [EMAIL PROTECTED] 262-703-5911 patrick zandi [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 02/01/2007 11:59 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: ARS+Oracle InstantClient information ** Is this supported ? the documentation says to use the Two_task, and say remote DB.. your example does not ? I am just asking.. On 2/1/07, Tony Worthington [EMAIL PROTECTED] wrote: Size. 600+MB vs 25. Plus there's no crummy slow java based install needed. And updates are a snap. Just replace the files. -- Tony Worthington [EMAIL PROTECTED] 262-703-5911 Bruce Scott [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 02/01/2007 11:37 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: ARS+Oracle InstantClient information Tony, What is the advantage of using InstantClient over the standard client installation? I'm new to the Oracle DB side of Remedy, as my last position was using SQL 2000/2003. Thanks, Bruce -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tony Worthington Sent: Thursday, February 01, 2007 10:35 AM To: arslist@ARSLIST.ORG Subject: ARS+Oracle InstantClient information I can't remember if I posted anything on this topic before, but I figured I'd share what I've figured out with my testing of ARS+InstantClient. For those not familiar InstantClient is a stripped down (libs only) version of the client. Our install 10.2.0.3 with sqlplus component is only 25MB and lives in a single directory (no subdirs.) All you need to do to have ARS use InstantClient is set TNS_ADMIN to the location of the tnsnames/sqlnet.ora. No ORACLE_HOME, no TWOTASK, etc. That's it! -tony P.S. InstantClient is at http://www.oracle.com/technology/tech/oci/instantclient/instantclient.ht ml -- Tony Worthington [EMAIL PROTECTED] 262-703-5911 CONFIDENTIALITY NOTICE: This is a transmission from Kohl's Department Stores, Inc. and may contain information which is confidential and proprietary. If you are not the addressee, any disclosure, copying or distribution or use of the contents of this message is expressly prohibited. If you have received this transmission in error, please destroy it and notify us immediately at 262-703-7000. CAUTION: Internet and e-mail communications are Kohl's property and Kohl's reserves the right to retrieve and read any message created, sent and received. Kohl's reserves the right to monitor messages to or from authorized Kohl's Associates at any time without any further consent. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are # The information contained in this electronic mail message, including attachments, if any, is PetSmart confidential information. It is intended only for the use of the person(s) named above. If the reader of this message is not the intended recipient, or has received this message in error, you are hereby notified that any review, dissemination, distribution or copying of this communication is strictly prohibited. If you are not the intended recipient or have received this message in error, please notify the sender via e-mail and promptly delete the original message. # ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are CONFIDENTIALITY NOTICE: This is a
Re: Remedy 6.3 Slow Searches
Indexes could be either out of date (forcing a full) or your query is inefficient.. I would never show all tickets (15K) unless very specifically asked.. I would show users ticket within 30 days, and another tab showing every ticket with a warning.. but that is just a bad idea in the first place.. Just an Idea.. On 2/7/07, Tanner, Doug [EMAIL PROTECTED] wrote: ** Gene, Most of this issue is caused by the Requesters Cases (Table). You may wish to exclude that User Requester from the table field refresh. Or change it to something like the below Doug Tanner Senior Developer Remedy Skilled Professional (RSP) Former RAC (704) 328-3178 [EMAIL PROTECTED] -- *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Gene Ushinsky *Sent:* Wednesday, February 07, 2007 1:41 PM *To:* arslist@ARSLIST.ORG *Subject:* Remedy 6.3 Slow Searches We use Remedy 6.3 and have close to 65,000 tickets in the database. These are spread over thousands of users with most users having 10-15 tickets. However, we use a generic user account to login tickets that don't belong to a particular user. This account has accumulated about 15,000 of the 65,000 tickets and it makes searching for tickets that involve that account go rather slowly. Instead of immediate response from the system while going down search results for a particular user, it stalls for 5-30 seconds when the search results are generated on that generic user. We are wondering what we can do to speed up these searches (if it is at all possible) short of archiving the tickets for that user or creating a new generic username. Any help would be appreciated. Gene * gene**ushinsky *OIT - Service Desks Support Manager [EMAIL PROTECTED] | MB 161A | 801.422.2716 DISCLAIMER Important! This message is intended for the above named person(s) only and is CONFIDENTIAL AND PROPRIETARY. If you are not the intended recipient of this e-mail and have received it in error, please immediately notify the sender by return email and then delete it from your mailbox. This message may be protected by the attorney-client privilege and/or work product doctrine. Accessing, copying, disseminating or re-using any of the information contained in this e-mail by anyone other than the intended recipient is strictly prohibited. Finally, you should check this email and any attachments for the presence of viruses, as the sender accepts no liability for any damage caused by any virus transmitted by this email. Thank you. __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 attachment: image001.jpg
Re: Mid Tier Installation 7.0.1 Patch 001 JDK error....
They had better not be changing horses again - we have already had to start getting up to speed on a new japp server and web server that we have no prior experience with (Tomcat and the Tomcat web), since switching to Tomcat on IIS actually runs _worse_ than ServletExec (response times are actually slower). Jboss is even less well known - not used at all here, and we have refused to install the SLM collector until it runs on either Tomcat or ServletExec, as was promised at UserWorld (and still undelivered). BMC would be ill advised to try to switch us to yet another japp server in the middle of the whole 7.x conversion process; it would indicate very poor decision-making processes on their part. That (poor decision-making) is already evident enough in their decisions to start selling their applications without the three fixed user licenses they have always provided to configure/administer the app. Would you buy a new car that came with no wheels and tires? 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 patrick zandi Sent: Wednesday, February 07, 2007 12:30 PM To: arslist@ARSLIST.ORG Subject: Re: Mid Tier Installation 7.0.1 Patch 001 JDK error ** Support told me they are recommending JBOSS instead of Tomcat ? it is faster and better to work with... Ask them about that as well.. On 2/7/07, Kemes, Lisa [EMAIL PROTECTED] wrote: ** Update... I uninstalled Java 5 and installed Java 1.4.2 and started up the Mid Tier installation again and I'm no longer getting this error message, but I still can't get to the mid tier configuration site. I did a new install of IIS 6, Java, Mid Tier and Tomcat on our Windows 2003 server. Weird, you would think it would work. I'm sending a ticket to Remedy Support. thanks! Lisa _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG ] On Behalf Of Kemes, Lisa Sent: Wednesday, February 07, 2007 12:04 PM To: arslist@ARSLIST.ORG Subject: Re: Mid Tier Installation 7.0.1 Patch 001 JDK error ** Has anyone received this error even though they have the correct JDK installed? Did you have to do anything different? Lisa __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
Elapsed Time field
Hi All...I'd like to enter some time data into a single field. so if something takes 3 minutes and 22 seconds i'd like to enter 3:22 into a field. It seems like a time field will not work, since the i would have to put 3:22 AM or PM in there. I am also going to have to do some calculations on the field such as total and meanso I don't think i can use a Character field. Does anyone have a suggestion on how I could format that field, or add workflow, so this could be done? Thanks! John ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Remedy 6.3 Slow Searches
Also we do not auto refresh the tables (Refresh on Entry Change). We use Active Links to populate a table only when a User selects the tab it is on. Fred From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of patrick zandi Sent: Wednesday, February 07, 2007 1:07 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy 6.3 Slow Searches ** Indexes could be either out of date (forcing a full) or your query is inefficient.. I would never show all tickets (15K) unless very specifically asked.. I would show users ticket within 30 days, and another tab showing every ticket with a warning.. but that is just a bad idea in the first place.. Just an Idea.. On 2/7/07, Tanner, Doug [EMAIL PROTECTED] wrote: ** Gene, Most of this issue is caused by the Requesters Cases (Table). You may wish to exclude that User Requester from the table field refresh. Or change it to something like the below Doug Tanner Senior Developer Remedy Skilled Professional (RSP) Former RAC (704) 328-3178 [EMAIL PROTECTED] From: Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] On Behalf Of Gene Ushinsky Sent: Wednesday, February 07, 2007 1:41 PM To: arslist@ARSLIST.ORG Subject: Remedy 6.3 Slow Searches We use Remedy 6.3 and have close to 65,000 tickets in the database. These are spread over thousands of users with most users having 10-15 tickets. However, we use a generic user account to login tickets that don't belong to a particular user. This account has accumulated about 15,000 of the 65,000 tickets and it makes searching for tickets that involve that account go rather slowly. Instead of immediate response from the system while going down search results for a particular user, it stalls for 5-30 seconds when the search results are generated on that generic user. We are wondering what we can do to speed up these searches (if it is at all possible) short of archiving the tickets for that user or creating a new generic username. Any help would be appreciated. Gene gene ushinsky OIT - Service Desks Support Manager [EMAIL PROTECTED] | MB 161A | 801.422.2716 DISCLAIMER Important! This message is intended for the above named person(s) only and is CONFIDENTIAL AND PROPRIETARY. If you are not the intended recipient of this e-mail and have received it in error, please immediately notify the sender by return email and then delete it from your mailbox. This message may be protected by the attorney-client privilege and/or work product doctrine. Accessing, copying, disseminating or re-using any of the information contained in this e-mail by anyone other than the intended recipient is strictly prohibited. Finally, you should check this email and any attachments for the presence of viruses, as the sender accepts no liability for any damage caused by any virus transmitted by this email. Thank you. __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 attachment: image001.jpg
Re: ARS+Oracle InstantClient information
you would still have to DST patch the oracle Client as well .. though. have you looked at the INSANE documentation from Oracle on the DST patch.. I think it is ridiculous On 2/7/07, Tony Worthington [EMAIL PROTECTED] wrote: Well... the quick version is... We use 10.2.0.3.0 instantclient to connect to 9.2.0.7.0 instance no problemo. Our Remedy server is running with this now. I can't get same 10.2.0.3.0 instantclient to connect to 10.2.0.1.0 RAC cluster, but the 10.2.0.1.0 fat client works. I wonder if there is an old 10.2.0.1.0 instanclient... This is an Oracle thing, not a Remedy thing. -t -- Tony Worthington [EMAIL PROTECTED] 262-703-5911 patrick zandi [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 02/07/2007 01:01 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: ARS+Oracle InstantClient information ** Axton.. Me and Tony were just discussing this.. Hopefully Tony will figure this out.. but he has just figured out it works with one scenario, but not another.. So I am guessing.. Configuration issues are too mind boggling.. and thus we (remedy) just decided .. Fat client only... I will wait for Tony's Answeres.. FYI On 2/1/07, Axton [EMAIL PROTECTED] wrote: ** I don't see why it would not be supported. It's the specific portion of the Oracle client that Remedy uses - the OCI api. Axton Grams On 2/1/07, Tony Worthington [EMAIL PROTECTED] wrote: I don't know if BMC supports it. They should, as it's an official Oracle client. No matches in the knowledge-base (shocker.) and the Compat Matrix isn't clear on clients except for saying Requires 32-bit Oracle 10gR2 database client for connecting to the Oracle database, Oracle RAC supported -- InstantClient is a 32 bit 10gR2 client which supports TAF+RAC And the (7x) installer runs just fine with no TWO_TASK for a remote DB. As does SLM, and everything else. -tony -- Tony Worthington [EMAIL PROTECTED] 262-703-5911 patrick zandi [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 02/01/2007 11:59 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: ARS+Oracle InstantClient information ** Is this supported ? the documentation says to use the Two_task, and say remote DB.. your example does not ? I am just asking.. On 2/1/07, Tony Worthington [EMAIL PROTECTED] wrote: Size. 600+MB vs 25. Plus there's no crummy slow java based install needed. And updates are a snap. Just replace the files. -- Tony Worthington [EMAIL PROTECTED] 262-703-5911 Bruce Scott [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 02/01/2007 11:37 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: ARS+Oracle InstantClient information Tony, What is the advantage of using InstantClient over the standard client installation? I'm new to the Oracle DB side of Remedy, as my last position was using SQL 2000/2003. Thanks, Bruce -Original Message- From: Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] On Behalf Of Tony Worthington Sent: Thursday, February 01, 2007 10:35 AM To: arslist@ARSLIST.ORG Subject: ARS+Oracle InstantClient information I can't remember if I posted anything on this topic before, but I figured I'd share what I've figured out with my testing of ARS+InstantClient. For those not familiar InstantClient is a stripped down (libs only) version of the client. Our install 10.2.0.3 with sqlplus component is only 25MB and lives in a single directory (no subdirs.) All you need to do to have ARS use InstantClient is set TNS_ADMIN to the location of the tnsnames/sqlnet.ora. No ORACLE_HOME, no TWOTASK, etc. That's it! -tony P.S. InstantClient is at http://www.oracle.com/technology/tech/oci/instantclient/instantclient.ht ml -- Tony Worthington [EMAIL PROTECTED] 262-703-5911 CONFIDENTIALITY NOTICE: This is a transmission from Kohl's Department Stores, Inc. and may contain information which is confidential and proprietary. If you are not the addressee, any disclosure, copying or distribution or use of the contents of this message is expressly prohibited. If you have received this transmission in error, please destroy it and notify us immediately at 262-703-7000. CAUTION: Internet and e-mail communications are Kohl's property and Kohl's reserves the right to retrieve and read any message created, sent and received. Kohl's reserves the right to monitor messages to or from authorized Kohl's Associates at any time without any further consent. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are # The information contained in this electronic mail message, including
Re: Mid Tier Installation 7.0.1 Patch 001 JDK error....
Support told me they are recommending JBOSS instead of Tomcat ? If such a statement was made by a support representative, it probably represents a personal opinion and not an official position of BMC. BMC does not recommend one servlet engine over another. The choice of servlet engine, where a choice is available, is left to the customer. SLM is an example where there currently is not a choice, but for AR System in general, customers may choose to use any of the supported servlet engines. Note that even though ServletExec is not distributed by BMC anymore, customers may still continue to use ServletExec as it is completely supported. In no way did the replacement of ServletExec with Tomcat within the distribution represent any recommendation of removing ServletExec and replacing it with Tomcat in existing or future planned environments. The FAQ in the statement of direction explains this as well. If ServletExec works better in your environment, you can continue using it and still maintain support from BMC for that configuration. 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, February 07, 2007 11:19 AM To: arslist@ARSLIST.ORG Subject: Re: Mid Tier Installation 7.0.1 Patch 001 JDK error ** They had better not be changing horses again - we have already had to start getting up to speed on a new japp server and web server that we have no prior experience with (Tomcat and the Tomcat web), since switching to Tomcat on IIS actually runs _worse_ than ServletExec (response times are actually slower). Jboss is even less well known - not used at all here, and we have refused to install the SLM collector until it runs on either Tomcat or ServletExec, as was promised at UserWorld (and still undelivered). BMC would be ill advised to try to switch us to yet another japp server in the middle of the whole 7.x conversion process; it would indicate very poor decision-making processes on their part. That (poor decision-making) is already evident enough in their decisions to start selling their applications without the three fixed user licenses they have always provided to configure/administer the app. Would you buy a new car that came with no wheels and tires? 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 patrick zandi Sent: Wednesday, February 07, 2007 12:30 PM To: arslist@ARSLIST.ORG Subject: Re: Mid Tier Installation 7.0.1 Patch 001 JDK error ** Support told me they are recommending JBOSS instead of Tomcat ? it is faster and better to work with... Ask them about that as well.. On 2/7/07, Kemes, Lisa [EMAIL PROTECTED] wrote: ** Update... I uninstalled Java 5 and installed Java 1.4.2 and started up the Mid Tier installation again and I'm no longer getting this error message, but I still can't get to the mid tier configuration site. I did a new install of IIS 6, Java, Mid Tier and Tomcat on our Windows 2003 server. Weird, you would think it would work. I'm sending a ticket to Remedy Support. thanks! Lisa From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG ] On Behalf Of Kemes, Lisa Sent: Wednesday, February 07, 2007 12:04 PM To: arslist@ARSLIST.ORG Subject: Re: Mid Tier Installation 7.0.1 Patch 001 JDK error ** Has anyone received this error even though they have the correct JDK installed? Did you have to do anything different? Lisa __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___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Elapsed Time field
I would say use 3 integer fields. Min's Seconds Storage Min's would hold the number of min's Seconds Storage would store (via filter) min's*60+seconds You can use your storage field to do all of your calculations on Then for display you can update min's to be storage/60 And seconds would be storage%60 (yes that's a %...it gives you the remainder of a division problem) I think that would work for what you are trying to do...if Hours are needed then you can just add it to the mix -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of adamucci Sent: Wednesday, February 07, 2007 12:23 PM To: arslist@ARSLIST.ORG Subject: Elapsed Time field Hi All...I'd like to enter some time data into a single field. so if something takes 3 minutes and 22 seconds i'd like to enter 3:22 into a field. It seems like a time field will not work, since the i would have to put 3:22 AM or PM in there. I am also going to have to do some calculations on the field such as total and meanso I don't think i can use a Character field. Does anyone have a suggestion on how I could format that field, or add workflow, so this could be done? Thanks! John ___ 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
Alerts 3.6 Netcool form
Hi All! Has anyone had any success with using the Netcool Alerts 3.6 form to insert a ticket into Incident Management 7.0.1 patch 3 app? Here's the scenario. If we manually create a ticket (or even do it automatically from Netcool) in the Alerts 3.6 form, there is some workflow associated to push a record into the Incident Interface Create form which then uses the OOB Remedy workflow to push the data into the Incident Management form. The ticket is getting inserted into the Incident Management form successfully; however when you open the ticket, attempt to modify it and save it the ARSystem crashes and then restarts itself. The errors we're getting in the arerror.log are: Mon Feb 5 09:44:45 2007 Dispatch : Cannot establish a network connection to the AR System server (SERVERNAME (0) : RPC: Miscellaneous tli error - System error (Connection refused)) ARERR - 90 Mon Feb 5 09:45:45 2007 AssignEng : Cannot establish a network connection to the AR System server (SERVERNAME (0) : RPC: Miscellaneous tli error - System error (Connection refused)) ARERR - 90 Mon Feb 5 09:45:45 2007 AssignEng : A user name must be supplied in the control record () ARERR - 149 Mon Feb 5 09:45:45 2007 AssignEng : A user name must be supplied in the control record () ARERR - 149 If I manually enter a ticket in the Incident Interface Create form, the ticket successfully pushes into the Incident management application and can be modified. The problem is occurring if we start with the Alerts 3.6 form, push to the Incident Interface Create form, and then into the Inc Mgmt app... Thanks in advance!! :) Mary Dollus ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Remedy 6.3 Slow Searches
Also I should note that if you do add indexes for the query you need to ensure that table statistics are updated for the Query Optimizer to recognize and utilize the new index tables. Thanks Peter Lammey ESPN MIT Technical Services Applications Management 860-766-4761 From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of patrick zandi Sent: Wednesday, February 07, 2007 2:07 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy 6.3 Slow Searches ** Indexes could be either out of date (forcing a full) or your query is inefficient.. I would never show all tickets (15K) unless very specifically asked.. I would show users ticket within 30 days, and another tab showing every ticket with a warning.. but that is just a bad idea in the first place.. Just an Idea.. On 2/7/07, Tanner, Doug [EMAIL PROTECTED] wrote: ** Gene, Most of this issue is caused by the Requesters Cases (Table). You may wish to exclude that User Requester from the table field refresh. Or change it to something like the below Doug Tanner Senior Developer Remedy Skilled Professional (RSP) Former RAC (704) 328-3178 [EMAIL PROTECTED] From: Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] On Behalf Of Gene Ushinsky Sent: Wednesday, February 07, 2007 1:41 PM To: arslist@ARSLIST.ORG Subject: Remedy 6.3 Slow Searches We use Remedy 6.3 and have close to 65,000 tickets in the database. These are spread over thousands of users with most users having 10-15 tickets. However, we use a generic user account to login tickets that don't belong to a particular user. This account has accumulated about 15,000 of the 65,000 tickets and it makes searching for tickets that involve that account go rather slowly. Instead of immediate response from the system while going down search results for a particular user, it stalls for 5-30 seconds when the search results are generated on that generic user. We are wondering what we can do to speed up these searches (if it is at all possible) short of archiving the tickets for that user or creating a new generic username. Any help would be appreciated. Gene gene ushinsky OIT - Service Desks Support Manager [EMAIL PROTECTED] | MB 161A | 801.422.2716 DISCLAIMER Important! This message is intended for the above named person(s) only and is CONFIDENTIAL AND PROPRIETARY. If you are not the intended recipient of this e-mail and have received it in error, please immediately notify the sender by return email and then delete it from your mailbox. This message may be protected by the attorney-client privilege and/or work product doctrine. Accessing, copying, disseminating or re-using any of the information contained in this e-mail by anyone other than the intended recipient is strictly prohibited. Finally, you should check this email and any attachments for the presence of viruses, as the sender accepts no liability for any damage caused by any virus transmitted by this email. Thank you. __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 attachment: image001.jpg
Re: Mid Tier Installation 7.0.1 Patch 001 JDK error....
Thanks.. So what the list is stating .. is correct.. Some are saying .. hey, for me this one is faster .. others .. we don't know that app.. (then don't use it).. you are supporting them all.. I don't know JBOSS - I was using Serverletexec.. on Solaris.. Thanks again.. David.. I was waiting for a Chime in.. I did see in the KB search .. Fix actions for Serverletexec and Jbos as recent as JAN 2007.. thanks. again.. . On 2/7/07, Easter, David [EMAIL PROTECTED] wrote: ** Support told me they are recommending JBOSS instead of Tomcat ? If such a statement was made by a support representative, it probably represents a personal opinion and not an official position of BMC. BMC does not recommend one servlet engine over another. The choice of servlet engine, where a choice is available, is left to the customer. SLM is an example where there currently is not a choice, but for AR System in general, customers may choose to use any of the supported servlet engines. Note that even though ServletExec is not distributed by BMC anymore, customers may still continue to use ServletExec as it is completely supported. In no way did the replacement of ServletExec with Tomcat within the distribution represent any recommendation of removing ServletExec and replacing it with Tomcat in existing or future planned environments. The FAQ in the statement of direction explains this as well. If ServletExec works better in your environment, you can continue using it and still maintain support from BMC for that configuration. 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, February 07, 2007 11:19 AM *To:* arslist@ARSLIST.ORG *Subject:* Re: Mid Tier Installation 7.0.1 Patch 001 JDK error ** They had better not be changing horses again - we have already had to start getting up to speed on a new japp server and web server that we have no prior experience with (Tomcat and the Tomcat web), since switching to Tomcat on IIS actually runs _worse_ than ServletExec (response times are actually slower). Jboss is even less well known - not used at all here, and we have refused to install the SLM collector until it runs on either Tomcat or ServletExec, as was promised at UserWorld (and still undelivered). BMC would be ill advised to try to switch us to yet another japp server in the middle of the whole 7.x conversion process; it would indicate very poor decision-making processes on their part. That (poor decision-making) is already evident enough in their decisions to start selling their applications without the three fixed user licenses they have always provided to configure/administer the app. Would you buy a new car that came with no wheels and tires? 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 *patrick zandi *Sent:* Wednesday, February 07, 2007 12:30 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Mid Tier Installation 7.0.1 Patch 001 JDK error ** Support told me they are recommending JBOSS instead of Tomcat ? it is faster and better to work with... Ask them about that as well.. On 2/7/07, Kemes, Lisa [EMAIL PROTECTED] wrote: ** Update... I uninstalled Java 5 and installed Java 1.4.2 and started up the Mid Tier installation again and I'm no longer getting this error message, but I still can't get to the mid tier configuration site. I did a new install of IIS 6, Java, Mid Tier and Tomcat on our Windows 2003 server. Weird, you would think it would work. I'm sending a ticket to Remedy Support. thanks! Lisa -- *From:* Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG ] *On Behalf Of *Kemes, Lisa *Sent:* Wednesday, February 07, 2007 12:04 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Mid Tier Installation 7.0.1 Patch 001 JDK error ** Has anyone received this error even though they have the correct JDK installed? Did you have to do anything different? Lisa __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___ __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: Compatibility Matrix with Oracle 32-bit Client under a Linux 64-bit OS
Am I crazy or does Oracle's answers seem contradictory? The answer to a is in conflict with point 2 and point 4 of the note. The answer to c is confusing. Isn't Linux x86-64 a 64 bit O/S (the 32 bit version is just Linux x86)? Fred From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Easter, David Sent: Wednesday, February 07, 2007 2:08 PM To: arslist@ARSLIST.ORG Subject: Re: Compatibility Matrix with Oracle 32-bit Client under a Linux 64-bit OS ** Hi All, This is the information that I've received from our partner representative at Oracle. a) Does Oracle support a 32-bit Oracle client communicating with a 64-bit database? Yes, provided that the 32bit Oracle client resides on a 32bit OS b) Does Oracle support a 32-bit Oracle client communicating with a 64-bit database on Linux x86_64? Yes, provided that the 32bit Oracle client resides on a 32bit OS and the 64bit database runs on a 64bit OS c) Does Oracle support a 32-bit database on Linux x86_64? Yes, Oracle 32-bit database running on Linux x86-64 with a 32-bit OS is supported. Running Oracle 32-bit on Linux x86-64 with 64-bit OS is not supported. A 32bit database requires a 32bit OS if running on AMD64 or EM64T hardware, 32bit databases are not supported on Itaninun --- see metalink certify information d) Does Oracle support a 32-bit Oracle client communicating with a 32-bit database on Linux x86_64? Yes, provided that the 32bit Oracle client resides on a 32bit OS, 32bit database on AMD64 or EM64T require a 32bit OS oracle metalink note 32/64 bit information 182999.1 * All Server and O/S versions without 64-bit notations indicate 32-bit versions. * The 64-bit O/S is capable of running programs that were compiled on a 32-bit O/S and 64-bit O/S. * The 32-bit O/S runs only programs that were compiled on a 32-bit O/S. This is called Binary Compatible. * A 32-bit application will work on both a 32-bit and 64-bit O/S, whereas a 64-bit application will only work on a 64-bit O/S. * Note, however, that relinking must occur on the O/S version that the application was compiled, as this affects patch sets. * Note: One caveat, if the Server product is 64-bit then 64-bit hardware (processors) is required. * Note: These statements do not necessarily apply to Oracle on Windows O/S's, Itanium or AMD64/EM64T based Platforms. See Certify for specific information Thanks, -David J. Easter Sr. Product Manager, Service Management Business Unit BMC Software, Inc. From: Easter, David Sent: Tuesday, February 06, 2007 7:54 AM To: 'arslist@ARSLIST.ORG' Subject: RE: Compatibility Matrix with Oracle 32-bit Client under a Linux 64-bit OS We are going to contact Oracle for clarification but, as the information you have has come from them, I suspect we already have the answer. Actually, Oracle is checking this for BMC and the documentation provided by Oracle may have been a mis-interpretation (Oracle's words). I'll post more when a definitive answer is received. 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 Mike James Sent: Tuesday, February 06, 2007 1:49 AM To: arslist@ARSLIST.ORG Subject: AW: Compatibility Matrix with Oracle 32-bit Client under a Linux 64-bit OS ** Hallo Fred, thanks for the Link. Here the Statement we received from BMC. The is no version of ARS that will run with 64-bit database connectivity. Remedy is a 32-bit application that requires the Oracle 32-bit client software. Future versions of ARS will support 64-bit connectibity but this will be in a future major release. It is not going to happen in a patch to the current versions. The information received from our product management team so far suggests that Oracle supported the 32-bit client on x86_64 Linux at the time the compatibilty matrix was created, but that they no longer support this combination. We are going to contact Oracle for clarification but, as the information you have has come from them, I suspect we already have the answer. Therefore, the options for your customer are; * use the 32-bit version of Linux * use the 64-bit version of Linux and the 32-bit Oracle client. This may not be supported by Oracle but this does not necessarily mean it will not work. This combination was used to develop and test ARS on the 64-bit Linux platform by BMC and it has passed our QA procedure. * wait for a 64-bit version of ARS. I have no information on when this may be available but you should not expect it in the near future. Regards Mike Von: Action Request System
Re: Compatibility Matrix with Oracle 32-bit Client under a Linux 64-bit OS
I think Linux x86-64 is in reference to 64 bit hardware, running 32 bit OS + 32 bit DB -- Tony Worthington [EMAIL PROTECTED] 262-703-5911 Grooms, Frederick W [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 02/07/2007 02:17 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Compatibility Matrix with Oracle 32-bit Client under a Linux 64-bit OS ** Am I crazy or does Oracle's answers seem contradictory? The answer to a is in conflict with point 2 and point 4 of the note. The answer to c is confusing. Isn't Linux x86-64 a 64 bit O/S (the 32 bit version is just Linux x86)? Fred From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Easter, David Sent: Wednesday, February 07, 2007 2:08 PM To: arslist@ARSLIST.ORG Subject: Re: Compatibility Matrix with Oracle 32-bit Client under a Linux 64-bit OS ** Hi All, This is the information that I've received from our partner representative at Oracle. a) Does Oracle support a 32-bit Oracle client communicating with a 64-bit database? Yes, provided that the 32bit Oracle client resides on a 32bit OS b) Does Oracle support a 32-bit Oracle client communicating with a 64-bit database on Linux x86_64? Yes, provided that the 32bit Oracle client resides on a 32bit OS and the 64bit database runs on a 64bit OS c) Does Oracle support a 32-bit database on Linux x86_64? Yes, Oracle 32-bit database running on Linux x86-64 with a 32-bit OS is supported. Running Oracle 32-bit on Linux x86-64 with 64-bit OS is not supported. A 32bit database requires a 32bit OS if running on AMD64 or EM64T hardware, 32bit databases are not supported on Itaninun --- see metalink certify information d) Does Oracle support a 32-bit Oracle client communicating with a 32-bit database on Linux x86_64? Yes, provided that the 32bit Oracle client resides on a 32bit OS, 32bit database on AMD64 or EM64T require a 32bit OS oracle metalink note 32/64 bit information 182999.1 All Server and O/S versions without 64-bit notations indicate 32-bit versions. The 64-bit O/S is capable of running programs that were compiled on a 32-bit O/S and 64-bit O/S. The 32-bit O/S runs only programs that were compiled on a 32-bit O/S. This is called Binary Compatible. A 32-bit application will work on both a 32-bit and 64-bit O/S, whereas a 64-bit application will only work on a 64-bit O/S. Note, however, that relinking must occur on the O/S version that the application was compiled, as this affects patch sets. Note: One caveat, if the Server product is 64-bit then 64-bit hardware (processors) is required. Note: These statements do not necessarily apply to Oracle on Windows O/S's, Itanium or AMD64/EM64T based Platforms. See Certify for specific information Thanks, -David J. Easter Sr. Product Manager, Service Management Business Unit BMC Software, Inc. From: Easter, David Sent: Tuesday, February 06, 2007 7:54 AM To: 'arslist@ARSLIST.ORG' Subject: RE: Compatibility Matrix with Oracle 32-bit Client under a Linux 64-bit OS We are going to contact Oracle for clarification but, as the information you have has come from them, I suspect we already have the answer. Actually, Oracle is checking this for BMC and the documentation provided by Oracle may have been a mis-interpretation (Oracle's words). I'll post more when a definitive answer is received. 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 Mike James Sent: Tuesday, February 06, 2007 1:49 AM To: arslist@ARSLIST.ORG Subject: AW: Compatibility Matrix with Oracle 32-bit Client under a Linux 64-bit OS ** Hallo Fred, thanks for the Link. Here the Statement we received from BMC. The is no version of ARS that will run with 64-bit database connectivity. Remedy is a 32-bit application that requires the Oracle 32-bit client software. Future versions of ARS will support 64-bit connectibity but this will be in a future major release. It is not going to happen in a patch to the current versions. The information received from our product management team so far suggests that Oracle supported the 32-bit client on x86_64 Linux at the time the compatibilty matrix was created, but that they no longer support this combination. We are going to contact Oracle for clarification but, as the information you have has come from them, I suspect we already have the answer. Therefore, the options for your customer are; * use the 32-bit version of Linux * use the 64-bit version of Linux and the 32-bit Oracle client. This may not be supported by Oracle but this does not necessarily mean it will not work. This combination was used to develop and test ARS on the 64-bit Linux platform by BMC and it has passed our QA procedure. *
Re: Compatibility Matrix with Oracle 32-bit Client under a Linux 64-bit OS
You have to remember that 64-bit kernels are capable of running both 32-bit and 64-bit binaries. Maybe when they say '32-bit OS', they mean a kernel with the supporting libraries capable of running both 32-bit and 64-bit apps? Axton Grams On 2/7/07, Tony Worthington [EMAIL PROTECTED] wrote: I think Linux x86-64 is in reference to 64 bit hardware, running 32 bit OS + 32 bit DB -- Tony Worthington [EMAIL PROTECTED] 262-703-5911 Grooms, Frederick W [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 02/07/2007 02:17 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Compatibility Matrix with Oracle 32-bit Client under a Linux 64-bit OS ** Am I crazy or does Oracle's answers seem contradictory? The answer to a is in conflict with point 2 and point 4 of the note. The answer to c is confusing. Isn't Linux x86-64 a 64 bit O/S (the 32 bit version is just Linux x86)? Fred From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Easter, David Sent: Wednesday, February 07, 2007 2:08 PM To: arslist@ARSLIST.ORG Subject: Re: Compatibility Matrix with Oracle 32-bit Client under a Linux 64-bit OS ** Hi All, This is the information that I've received from our partner representative at Oracle. a) Does Oracle support a 32-bit Oracle client communicating with a 64-bit database? Yes, provided that the 32bit Oracle client resides on a 32bit OS b) Does Oracle support a 32-bit Oracle client communicating with a 64-bit database on Linux x86_64? Yes, provided that the 32bit Oracle client resides on a 32bit OS and the 64bit database runs on a 64bit OS c) Does Oracle support a 32-bit database on Linux x86_64? Yes, Oracle 32-bit database running on Linux x86-64 with a 32-bit OS is supported. Running Oracle 32-bit on Linux x86-64 with 64-bit OS is not supported. A 32bit database requires a 32bit OS if running on AMD64 or EM64T hardware, 32bit databases are not supported on Itaninun --- see metalink certify information d) Does Oracle support a 32-bit Oracle client communicating with a 32-bit database on Linux x86_64? Yes, provided that the 32bit Oracle client resides on a 32bit OS, 32bit database on AMD64 or EM64T require a 32bit OS oracle metalink note 32/64 bit information 182999.1 All Server and O/S versions without 64-bit notations indicate 32-bit versions. The 64-bit O/S is capable of running programs that were compiled on a 32-bit O/S and 64-bit O/S. The 32-bit O/S runs only programs that were compiled on a 32-bit O/S. This is called Binary Compatible. A 32-bit application will work on both a 32-bit and 64-bit O/S, whereas a 64-bit application will only work on a 64-bit O/S. Note, however, that relinking must occur on the O/S version that the application was compiled, as this affects patch sets. Note: One caveat, if the Server product is 64-bit then 64-bit hardware (processors) is required. Note: These statements do not necessarily apply to Oracle on Windows O/S's, Itanium or AMD64/EM64T based Platforms. See Certify for specific information Thanks, -David J. Easter Sr. Product Manager, Service Management Business Unit BMC Software, Inc. From: Easter, David Sent: Tuesday, February 06, 2007 7:54 AM To: 'arslist@ARSLIST.ORG' Subject: RE: Compatibility Matrix with Oracle 32-bit Client under a Linux 64-bit OS We are going to contact Oracle for clarification but, as the information you have has come from them, I suspect we already have the answer. Actually, Oracle is checking this for BMC and the documentation provided by Oracle may have been a mis-interpretation (Oracle's words). I'll post more when a definitive answer is received. 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 Mike James Sent: Tuesday, February 06, 2007 1:49 AM To: arslist@ARSLIST.ORG Subject: AW: Compatibility Matrix with Oracle 32-bit Client under a Linux 64-bit OS ** Hallo Fred, thanks for the Link. Here the Statement we received from BMC. The is no version of ARS that will run with 64-bit database connectivity. Remedy is a 32-bit application that requires the Oracle 32-bit client software. Future versions of ARS will support 64-bit connectibity but this will be in a future major release. It is not going to happen in a patch to the current versions. The information received from our product management team so far suggests that Oracle supported the 32-bit client on x86_64 Linux at the time the compatibilty matrix was created, but that they no longer support this combination. We are going to contact Oracle for clarification but, as the information you have has come from them, I suspect we already have the answer. Therefore, the options for your customer are; * use the 32-bit version of Linux * use the 64-bit version of Linux and the 32-bit Oracle
Remedy Education site
For all the complaining we have done about the Support site (including why it tells me that my session has timed out, and when I try to refresh it then tells me that I'm logged on somewhere else, which I'm not), I just took a look at the Education site, and there have been a number of nice improvements since last week. - More details about each class. - A master class schedule, so that you can see on one screen what is currently available for all classes and all locations. - A breakdown of how class time will be structured, with a high level outline of the class objectives. - A placement test (was that there before?) - New ways to find the classes. Nice job, whoever did that! -- Rick Cook Cook Enterprises 253-278-4112 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Remedy Education site
Hi Rick, Some of it has a new look, most of the info is about the same. The placement test isn't for Remedy products from what I could see. It does look different from just 2 weeks ago, so there have been changes! Susan On 2/7/07, Rick Cook [EMAIL PROTECTED] wrote: ** For all the complaining we have done about the Support site (including why it tells me that my session has timed out, and when I try to refresh it then tells me that I'm logged on somewhere else, which I'm not), I just took a look at the Education site, and there have been a number of nice improvements since last week. - More details about each class. - A master class schedule, so that you can see on one screen what is currently available for all classes and all locations. - A breakdown of how class time will be structured, with a high level outline of the class objectives. - A placement test (was that there before?) - New ways to find the classes. Nice job, whoever did that! -- Rick Cook Cook Enterprises 253-278-4112 __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
LIST OWNER
I have received an email from a friend/new remedy adminstrator that has been trying to subscribe to the list. He has emailed a few times but does not think his email is getting through. Please contact him at: Jerry Cahill [EMAIL PROTECTED] Thanks, Brandi -Original Message- From: Jerry Cahill [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 07, 2007 4:50 PM To: Barbour, Brandi CTR Subject: Can you do me a favor? If you can - could you send an email to ARS List - I have still not heard from them at all - I signed up and then sent an email for support because I hadn't heard anything - and still nada - so I'm not sure if it has anything to do with my email address or not - curious to see if you get any kind of response ...if you get an opportunity. ;) Jerry Cahill ARS Support [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Desk: 913.312.4773 Cell: 913.217.8815 Fax: 913.312.4701 * Cellnet Technologies, Inc 11146 Thompson Ave. Lenexa, KS 66219 http://www.cellnet.com http://www.cellnet.com/ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Need Help With Run Process Special Commands
Bueller?... Bueller?... Bueller? j/k I actually made a typo here... I'm doing this on a value I'm pulling from the QueryShort column from the actlink_push table. QueryShort should really be AssignShort. Btw, our higher ups dropped the ball on renewing our Remedy support contract so I can't submit this into support yet. Thanks again for any help or clues. From: LAU, DARREN (ASI) Sent: Monday, February 05, 2007 5:07 PM To: 'arslist@ARSLIST.ORG' Subject: Need Help With Run Process Special Commands I did a search on this but didn't even get one hit. Anyways here are the commands I'm using. Application-Parse-Val-SField form1 field form2 assignment_statement Application-Format-Val-SField form1 field form2 internal_assignment I'm doing this on a value I'm pulling from the QueryShort column from the actlink_push table. [EMAIL PROTECTED]@ \32\ES-AccountAdministrationRequests\1\98\0\4\6\ My question is what do I put in the field parameter? Is that supposed to be the field that is being set? One thing to note is that the field 98 no longer exists on the form referenced above. So far with all my attempts I haven't been able to convert that into something human readable. TIA for any help. Darren Lau ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Helpdesk 6 Weird Notification
I have a notification that is sent out to the manager of a group when a ticket has not been responded to by the assignee. It has no subject line and I can't find the workflow that sends it out. I have used ARUtilities to look at the notifiucations and there is nothing there that shows the text that is in the message. Does this look familiar to any of you!? From: Remedy Sent: Wed 1/31/2007 3:57 PM To: Sanford, Claire Subject: Help Desk case HD001236329 has not been responded to by Claire Sanford. Please follow up on this issue. This issue is from Claire Sanford regarding: TEST TICKET HD 6 SLA 6 loaded but not in use other than the canned one's that come with the system. ARS 6.3 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Migration from Serviceware to RKM
Has anybody done a migration from Serviceware to Remedy Knowledge Management? I have been tasked with transitioning the data that has been entered and maintained in SW to RKM. I have never used Serviceware so I do not know any of the tools or of its architecture. Are there any tools for exporting the data or is it possible to export directly from the database (not sure what DBMS it is using) and import into RKM? Thanks, Jason ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
RANT: Diary fields in a dialog box....
Wonder why is it Remedy has never addressed to the issue that if you open up a dialog box that contains a diary field, and there is a set field action that brings in values from a record on open of the dialog, the Diary field doesn't behave like its should have behaved. There is no uneditable historical part for the field and an editable one. Everything from history gets set to the editable part so if you want to edit its contents it adds all this plus what you add during the transaction, to the diary for each transaction Any idea as to whether or not this issue will ever be addressed to?? Joe Never miss an email again! Yahoo! Toolbar alerts you the instant new Mail arrives. http://tools.search.yahoo.com/toolbar/features/mail/ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Helpdesk 6 Weird Notification
Are you checking escalations or filters? It seems time based, so should be an escalation... John -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sanford, Claire Sent: Wednesday, February 07, 2007 2:18 PM To: arslist@ARSLIST.ORG Subject: Helpdesk 6 Weird Notification I have a notification that is sent out to the manager of a group when a ticket has not been responded to by the assignee. It has no subject line and I can't find the workflow that sends it out. I have used ARUtilities to look at the notifiucations and there is nothing there that shows the text that is in the message. Does this look familiar to any of you!? From: Remedy Sent: Wed 1/31/2007 3:57 PM To: Sanford, Claire Subject: Help Desk case HD001236329 has not been responded to by Claire Sanford. Please follow up on this issue. This issue is from Claire Sanford regarding: TEST TICKET HD 6 SLA 6 loaded but not in use other than the canned one's that come with the system. ARS 6.3 ___ 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: Helpdesk 6 Weird Notification
Claire - I recognize this message. It's from the SLA's that come with Help Desk. On my system, one of the filters that sends this is called zSLAGen:SLA00010_1010_Escalate to Manager after 75%_BR_Filter1. On looking closer, there are several that send a message like this, but they all (at least the ones I've found) have 'Escalate to Manager after...' in the filter name. As I recall SLA generates these filters as SLAs are created, so yours may have different names, but maybe not since these are OTB. Hope this helps, Thanks, Ron Legters Tools Administrator Data Systems Services Univar USA Inc. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sanford, Claire Sent: Wednesday, February 07, 2007 2:18 PM To: arslist@ARSLIST.ORG Subject: Helpdesk 6 Weird Notification I have a notification that is sent out to the manager of a group when a ticket has not been responded to by the assignee. It has no subject line and I can't find the workflow that sends it out. I have used ARUtilities to look at the notifiucations and there is nothing there that shows the text that is in the message. Does this look familiar to any of you!? From: Remedy Sent: Wed 1/31/2007 3:57 PM To: Sanford, Claire Subject: Help Desk case HD001236329 has not been responded to by Claire Sanford. Please follow up on this issue. This issue is from Claire Sanford regarding: TEST TICKET HD 6 SLA 6 loaded but not in use other than the canned one's that come with the system. ARS 6.3 ___ 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: RANT: Diary fields in a dialog box....
I believe that is the correct workflow for the system to do. You are doing a Set Fields to the diary field. That always puts that data into the editable portion. Why should it work differently on a Dialog than it would on a regular form? How would the system know if you were wanting the data to be the historical data or just pre-populating data for the user to add to? Personally if I am doing something like that I put the historical data into a display only (read only) character field. Fred From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Wednesday, February 07, 2007 5:38 PM To: arslist@ARSLIST.ORG Subject: RANT: Diary fields in a dialog box ** Wonder why is it Remedy has never addressed to the issue that if you open up a dialog box that contains a diary field, and there is a set field action that brings in values from a record on open of the dialog, the Diary field doesn't behave like its should have behaved. There is no uneditable historical part for the field and an editable one. Everything from history gets set to the editable part so if you want to edit its contents it adds all this plus what you add during the transaction, to the diary for each transaction Any idea as to whether or not this issue will ever be addressed to?? Joe ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: RANT: Diary fields in a dialog box....
Agreed, but it does tend to be a bit of a pain if you are doing something like viewing a record in a dialog box, and that record has diary fields, and you need to edit that diary field from the dialog box... What then without any workarounds such as setting the historical part into a read only field and having a display only field editable to push the new content... Maybe I didn't really word my original post properly.. When this dialog box is opened, it would be nice if the set field happens like it does for any other field, I'm not contesting that.. But diary fields in the dialog should have been able to recognize the historical part and open it in a histry box below the editable part just like it does when you open the record in a Modify mode... Joe - Original Message From: Grooms, Frederick W [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Wednesday, February 7, 2007 7:36:23 PM Subject: Re: RANT: Diary fields in a dialog box ** I believe that is the correct workflow for the system to do. You are doing a Set Fields to the diary field. That always puts that data into the editable portion. Why should it work differently on a Dialog than it would on a regular form? How would the system know if you were wanting the data to be the historical data or just pre-populating data for the user to add to? Personally if I am doing something like that I put the historical data into a display only (read only) character field. Fred From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Wednesday, February 07, 2007 5:38 PM To: arslist@ARSLIST.ORG Subject: RANT: Diary fields in a dialog box ** Wonder why is it Remedy has never addressed to the issue that if you open up a dialog box that contains a diary field, and there is a set field action that brings in values from a record on open of the dialog, the Diary field doesn't behave like its should have behaved. There is no uneditable historical part for the field and an editable one. Everything from history gets set to the editable part so if you want to edit its contents it adds all this plus what you add during the transaction, to the diary for each transaction Any idea as to whether or not this issue will ever be addressed to?? Joe TV dinner still cooling? Check out Tonight's Picks on Yahoo! TV. http://tv.yahoo.com/ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: RANT: Diary fields in a dialog box....
Joe, In my opinion this would go into the RFE bucket. Maybe worth a shot, since BMC/Remedy uses diary fields in their OOB applications. -- Shyam - Original Message - From: Joe DeSouza Newsgroups: gmane.comp.crm.arsystem.general To: arslist@ARSLIST.ORG Sent: Wednesday, February 07, 2007 4:51 PM Subject: Re: RANT: Diary fields in a dialog box ** Agreed, but it does tend to be a bit of a pain if you are doing something like viewing a record in a dialog box, and that record has diary fields, and you need to edit that diary field from the dialog box... What then without any workarounds such as setting the historical part into a read only field and having a display only field editable to push the new content... Maybe I didn't really word my original post properly.. When this dialog box is opened, it would be nice if the set field happens like it does for any other field, I'm not contesting that.. But diary fields in the dialog should have been able to recognize the historical part and open it in a histry box below the editable part just like it does when you open the record in a Modify mode... Joe - Original Message From: Grooms, Frederick W [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Wednesday, February 7, 2007 7:36:23 PM Subject: Re: RANT: Diary fields in a dialog box ** I believe that is the correct workflow for the system to do. You are doing a Set Fields to the diary field. That always puts that data into the editable portion. Why should it work differently on a Dialog than it would on a regular form? How would the system know if you were wanting the data to be the historical data or just pre-populating data for the user to add to? Personally if I am doing something like that I put the historical data into a display only (read only) character field. Fred -- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Wednesday, February 07, 2007 5:38 PM To: arslist@ARSLIST.ORG Subject: RANT: Diary fields in a dialog box ** Wonder why is it Remedy has never addressed to the issue that if you open up a dialog box that contains a diary field, and there is a set field action that brings in values from a record on open of the dialog, the Diary field doesn't behave like its should have behaved. There is no uneditable historical part for the field and an editable one. Everything from history gets set to the editable part so if you want to edit its contents it adds all this plus what you add during the transaction, to the diary for each transaction Any idea as to whether or not this issue will ever be addressed to?? Joe -- Bored stiff? Loosen up... Download and play hundreds of games for free on Yahoo! Games. __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Patch 20 - Install Issues
We got AR Server patch 20 to work using the manual file replacement. But we didn't put all the files in the same folder. That may be your issue. Its not documented in the readme but we figured we needed to do the track down all the originals before copying the new files. Here's where I put the files: areahub.dll - c:\program files\ar system\plugins\areahub\winnt ardbcconf.dll - c:\program files\ar system\plugins\conf\winnt ssoldap.dll - c:\program files\ar systsem\plugins\ssoldap\winnt all others - c:\program files\ar system Chad Hall 501-342-2650 From: Action Request System discussion list(ARSList) on behalf of Dudley, Joelie Sent: Mon 1/22/2007 7:29 AM To: arslist@ARSLIST.ORG Subject: Patch 20 - Install Issues Anyone have any issues with installing Patch 20 on Windows 2003, ARS 6.3 Patch 17 with ITSM installed (All apps), MS SQL 2000? First, I cannot find four files to replace: Arfjavascr63.dll, ardlib.dll, Flahboard.dll, upmssql.dll After I replace all the other files which can be found and I try to start the server, the server terminates and this is in the error log: Mon Jan 22 08:23:45 2007 390695 : An error has occurred while loading a plug-in. (ARERR 8756) Mon Jan 22 08:23:45 2007 arealdap.dll: The specified module could not be found. Mon Jan 22 08:23:45 2007 390695 : An error has occurred while loading a plug-in. (ARERR 8756) Mon Jan 22 08:23:45 2007 ardbcldap.dll: The specified module could not be found. Any ideas??? Any help/assistance is appreciated Joelie Dudley Application Developer 555 Walnut Street 7th Floor, Forum Place Harrisburg, PA 17110 Phone: (717) 772-8143 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are * 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. * ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: RANT: Diary fields in a dialog box....
Just don't use diary fields. In the case of the packaged apps, create a display only character field and allow updates to that field. Unfortunate side effect is that you can not use matching id's in one of 2 actions (on open/set or save/push). Axton On 2/7/07, Shyam Attavar [EMAIL PROTECTED] wrote: ** Joe, In my opinion this would go into the RFE bucket. Maybe worth a shot, since BMC/Remedy uses diary fields in their OOB applications. -- Shyam - Original Message - *From:* Joe DeSouza [EMAIL PROTECTED] *Newsgroups:* gmane.comp.crm.arsystem.general *To:* arslist@ARSLIST.ORG *Sent:* Wednesday, February 07, 2007 4:51 PM *Subject:* Re: RANT: Diary fields in a dialog box ** Agreed, but it does tend to be a bit of a pain if you are doing something like viewing a record in a dialog box, and that record has diary fields, and you need to edit that diary field from the dialog box... What then without any workarounds such as setting the historical part into a read only field and having a display only field editable to push the new content... Maybe I didn't really word my original post properly.. When this dialog box is opened, it would be nice if the set field happens like it does for any other field, I'm not contesting that.. But diary fields in the dialog should have been able to recognize the historical part and open it in a histry box below the editable part just like it does when you open the record in a Modify mode... Joe - Original Message From: Grooms, Frederick W [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Wednesday, February 7, 2007 7:36:23 PM Subject: Re: RANT: Diary fields in a dialog box ** I believe that is the correct workflow for the system to do. You are doing a Set Fields to the diary field. That always puts that data into the editable portion. Why should it work differently on a Dialog than it would on a regular form? How would the system know if you were wanting the data to be the historical data or just pre-populating data for the user to add to? Personally if I am doing something like that I put the historical data into a display only (read only) character field. Fred -- *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Joe DeSouza *Sent:* Wednesday, February 07, 2007 5:38 PM *To:* arslist@ARSLIST.ORG *Subject:* RANT: Diary fields in a dialog box ** Wonder why is it Remedy has never addressed to the issue that if you open up a dialog box that contains a diary field, and there is a set field action that brings in values from a record on open of the dialog, the Diary field doesn't behave like its should have behaved. There is no uneditable historical part for the field and an editable one. Everything from history gets set to the editable part so if you want to edit its contents it adds all this plus what you add during the transaction, to the diary for each transaction Any idea as to whether or not this issue will ever be addressed to?? Joe -- Bored stiff? http://us.rd.yahoo.com/evt=49935/*http://games.yahoo.comLoosen up... Download and play hundreds of games for freehttp://us.rd.yahoo.com/evt=49935/*http://games.yahoo.comon Yahoo! Games. __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: Need Help With Run Process Special Commands
Darren, The field ID = 98 is a special field. It is in the reserved range and this is how a Push by matching field IDs action is recorded. So... I think that part of the push action is a kind of magic variable that the ARS server expands to an intersection of the field ID's between the two listed forms. ( Ref arstruct.h line: 39 #define AR_LIKE_ID98 /* Reserved for Push/Set Like Field id */ ) However to try to talk to how I think Application-Parse-Val-SField would work First understand what the docs say: Application-Parse-Val-SField form1 field form2 assignment_statement Converts a Set Fields or Push Fields filter assignment statement into an internal representation. See Syntax exception—Special commands with qualifications on page 617. Then read up on this function over here. :) Application-Format-Qual-SField form1 form2 internal_qualifier Converts an internal representation of a qualifier from a Set Fields or Push Fields filter action into a qualification string. See Syntax exception—Special commands with qualifications on page 617. Note: What internal representation is never really explained. :) If your pulling data from the DB and you want to convert it to Human readable then you want to use Format to decode the value you find in the meta data. :) But there is some more work to be done here too. Example time: I will pick on the sample application from v6.3. ( If you did not load it, then do so and you can see what I see too.) I will work with the following Active link: Sample:Enroll05(PushFields) . It does not to a push by matching ID's, but I think once you get the hang of this example the other condition will make sense too. So first lets get some parts together. :) select actlinkId,name from actlink where name='Sample:Enroll05(PushFields)' -- actlinkId = 228 (for me, your value will be different) -- name = 'Sample:Enroll05(PushFields)' ( no surprise there. :) ) We also need: select actlinkId, name from actlink_mapping a, arschema b where a.actlinkId=228 and b.schemaId = a.schemaId -- name='Sample:ClassCentral' select actlinkId,actionIndex,fieldId,sampleSchema, assignShort from actlink_push where actlinkId = 228 You will see 8 rows that match that search. I will deal with the row for the fieldId = 536870921. (Since the others are fairly boring. :) That returns (of most interest) -- assignShort = '[EMAIL PROTECTED]:Enrollments\1\536870921\4\1\2\2\1\2\2\0\4\6\102\1\*\1\*\1\536870940\0\1\4\' So now how to use this stuff with Application-Format-Qual-SField you ask? Application-Format-Qual-SField form1 = Sample:ClassCentral form2 = Sample:Enrollments internal_qualifier = 4\1\2\2\1\2\2\0\4\6\102\1\*\1\*\1\536870940\0\1\4\ [ Note that the value you send to this function is not the full assignShort value. You have to strip the leading headers that tell the active link the server and form2 values to get data from and the field on form1 where the results should be returned too. (AKA: '[EMAIL PROTECTED]:Enrollments\1\536870921\') ] When used in a Filter Set Field $PROCESS$ action the return value is: 1 = 0 [ Which is what the Push field Qualification is in that active link. :) ] We can reverse the process by making use of the Application-Parse-Val-SField function: Application-Parse-Val-SField form1 = Sample:ClassCentral field = 536870921 form2 = Sample:Enrollments assignment_statement = 1=0 Which works [er... does not return an error] for me, but the returned results a very strange value via an Active Link $PROCESS$ (When run on the server via the @: notation) to the screen. So maybe that function does not work that way? But the Format function did... shrug) BTW: a sample value assignShort for a push by matching ID looks like the following: [EMAIL PROTECTED]@[EMAIL PROTECTED] HTH. P.S. Get that support contract renewed... you never know when you are going to need support. :) P.S.S. Sorry for the slow response, but I wanted to document the function in enough detail that you could try to follow. (And these functions are not the most straight forward. :) -- 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 2/5/07, LAU, DARREN (ASI) [EMAIL PROTECTED] wrote: ** I did a search on this but didn't even get one hit. Anyways here are the commands I'm using. Application-Parse-Val-SField form1 field form2 assignment_statement Application-Format-Val-SField form1 field form2 internal_assignment I'm doing this on a value I'm pulling from the QueryShort column from the actlink_push table. [EMAIL PROTECTED]@\32\ES-AccountAdministrationRequests\1\98\0\4\6\ My question is what do I put in the field parameter? Is that supposed to be the field that is being set? One thing to note is that the field 98 no longer exists on the form referenced above. So far with all my attempts I haven't been able to convert that
