Re: driver.exe, row counts...
I am TARDY for the PARTY but Yeah Danny you are correct: select * from some_table where rownum = (some number you specify goes here) Thanks For Letting Me Speak, Mike Date: Fri, 31 Aug 2012 18:29:17 +0200 From: danny.kell...@strategicworkflow.com Subject: Re: driver.exe, row counts... To: arslist@ARSLIST.ORG Does it use rownum? I think that's how you do it via SQL if I remember correctly On 30 Aug 2012, at 17:04, Longwing, LJ CTR MDA/IC lj.longwing@mda.mil wrote: Yes...SQL...I'm curious how it handles the same situation in Oracle... -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Thursday, August 30, 2012 8:26 AM To: arslist@ARSLIST.ORG Subject: Re: driver.exe, row counts... One thing to remember ... Oracle does not support TOP, so I didn't think Remedy would be using it. (Is your example from the SQL log on the server?) Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Longwing, LJ CTR MDA/IC Sent: Thursday, August 30, 2012 7:50 AM To: arslist@ARSLIST.ORG Subject: Re: driver.exe, row counts... Misi, I tend to agree with you, but in the last several years I found MANY things that the Remedy server does poorly...I'll give you an example. You need to get the sum of a particular table column via filter with the default server side table chunk of 1000, and you have 200,000 records in the table. Issuing a SELECT SUM(COLUMN) FROM TABLE WHERE QUALIFICATION returns the result in sub second. If you however do a set-field COLSUM(COLUMN), it's interesting to watch the Remedy server do its thing and how it does itaccording to the docs, the server side table chunk size is used to manage memory, but in this situation it actually causes NO memory savings, and causes the entire process to take WAYYY T long...basically what it does is SELECT TOP 1001 C1, C2, C3, etc FROM TABLE WHERE QUALIFICATION Where C1-x are the columns in the table. Then it determines that there are more records than that, so it adds 1000 to the select SELECT TOP 2001 C1, C2, C3, etc FROM TABLE WHERE QUALIFICATION Again, determining that it needs more records Etc It continues issuing queries until the 'top' is high enough to select all of the records, each subsequent select taking more time than the last. I have seen this process take over 10 minutes with a single transaction in a custom system I was working on at the time. Converting COLSUM set-field calls to SELECT SUM calls greatly enhanced the performance and scalability of the process. I agree with you that things should be done 'inside' the Remedy framework where that doesn't significantly impact performance of the process, but I have come across countless situations in the last several years that pushed Remedy beyond its boundaries and needed 'help' from other methods of doing things to get them done properly. In fact I'm presenting one of those @ RUG this year :) -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent: Wednesday, August 29, 2012 10:14 PM To: arslist@ARSLIST.ORG Subject: Re: driver.exe, row counts... Hi, Well, this particular code might very well work across databases. The other main concern with Direct SQL is that it is untraceable by the AR System. The AR System does not understand what you are doing, and you can not use AR tools to trace and analyze it in the same way as other workflow. Then we have the issue of going straight at the T-tables, and other things related to datatype-conversion for timestamps, enum-values You will also be bypassing permissions. I am convinced that using the ARAPI and the provided AR-workflow-actions is worth some effort in lieu of direct SQL. Even if it would mean some small performance hit. In this specific case, it much depends on the nomber of records in the table. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. -Original Message- It might be faster, but it is direct SQL and may not work on any database... select count(*) from HPD_Help_Desk Does Remedy support a database where the above ANSI SQL won't work? I suppose if ARS implements view names for their tables differently in another database, it would not be HPD_Help_Desk, but does anyone know of which
Re: New Install of 7.6.03
Rob - I don't see your screen capture. Date: Tue, 4 Sep 2012 18:02:39 -0400 From: lrguar...@yahoo.com Subject: Re: New Install of 7.6.03 To: arslist@ARSLIST.ORG ** So you are saying you haven't entered the host name? P On Sep 3, 2012, at 1:40 AM, Robert Gajic robert.ga...@lmal.com.au wrote: ** Hi everyone! I am building a brand new instance of Remedy 7.6.03 (as this is our current production version) and I am getting an error very early on when installing AR 7.6.03. Oh some versions first; Windows server 2008 R2 Enterprise Database is SQL 2008 but irrelevant because I haven’t got that far yet. So the error I get (there has been no user input here besides naming a directory to install too, accepting licence agreement, custom setup, installing all components except mid-tier and full text image001.png Remember though I haven’t had a chance to enter any of the info in the error message.. Any thoughts? Regards Rob Gajic Lockheed Martin This message is intended only for the use of the intended recipient(s) If you are not an intended recipient, you are hereby notified that any use, dissemination, disclosure or copying of this communication is strictly prohibited. If you have received this communication in error please destroy all copies of this message and its attachments and notify the sender immediately _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: OT: Apache Tomcat
Roger - What are your tomcat stderr logs looking like? You care to post the exception stacks that you may have seen during the time of the crash? Look for out of memory errors and class def not found errors in particular. Although I think the classdef errors are not likely unless you're calling a jar/war/class file that does not exist and it is not a major part of the overall initialization and function of Tomcat in and of itself. I know your original question is from a couple days ago but I tend to be late for the show when it comes to arslist and answering questions. Call it a good indicator of me being gainfully employed and therefore too busy to do so - it's what I tell myself. Date: Tue, 14 Aug 2012 15:10:02 + From: matthew.perra...@genmills.com Subject: Re: OT: Apache Tomcat To: arslist@ARSLIST.ORG ** Roger, Both. Of course you probably know this, But you should usually do your utmost to keep the Server and Mid-tier at the same version and Patch level. We’ve been burned by having them on different versions, as well as same version but a different Patch levels. And BMC did give us some DLL’s at the Server level to try, and they did help. It reduced the crashing from twice a day to about what you are seeing (every 3 to 4 weeks). So you may want to bump your ARS version to 7.6 and see if that fixes your issue. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Nall, Roger Sent: Tuesday, August 14, 2012 8:47 AM To: arslist@ARSLIST.ORG Subject: Re: OT: Apache Tomcat ** Matt, Thanks for the information. When you say upgrade are you talking about ARS, Apache or both? Regards, Roger Nall Manager, SA Business Objects/Remedy Desk: 972-464-3712 PCS: 973-652-6723 SA_Intake SA Portal From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Matthew Perrault Sent: Monday, August 13, 2012 2:17 PM To: arslist@ARSLIST.ORG Subject: Re: OT: Apache Tomcat ** Roger, I hate to break this to you but we’ve been having that issue for over 3 years. 3/5/2009 We did have an open Support Ticket with BMC, and they could not solve it. ISS03409598 SW00371854 SW00325104 Tried several patches that they provided to no success. They basically told us we have to upgrade as they could not solve it. We did set out Java Memory Settings to 1024, 1024 Granted our environment is a little different than yours ARS 7.1 Patch 8 (soon to be Patch 11) Mid-Tier 7.1 Patch 8 (soon to be Patch 11) MS SQL 2005 Windows Server 2003 Good luck, Let me know if you figure anything out. Thanks Matt P. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Nall, Roger Sent: Monday, August 13, 2012 10:37 AM To: arslist@ARSLIST.ORG Subject: OT: Apache Tomcat ** ARS 7.1 Patch 4 (Application) Mid Tier – 7.6.4 Patch 2 SQL 2000 Windows 2003 (Application) Windows 2008 (Mid Tier) We have been having to restart Apache Tomcat 6.0 service just about once every 3 – 4 weeks for the last couple of months. I am wondering if anyone can suggest what I can look to determine what may be wrong. Thanks, Roger Nall Manager, SA Business Objects/Remedy Desk: 972-464-3712 PCS: 973-652-6723 SA_Intake SA Portal _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: BMC Remedy Action Request System Wikipedia page is set to be deleted
Honestly, I have never used the wiki page myself. With that said, it doesn't
mean that others haven't. I had nothing constructive to say, so I'm done. I'll
leave now.
Date: Thu, 31 May 2012 16:36:52 -0400
From: nti...@umich.edu
Subject: Re: BMC Remedy Action Request System Wikipedia page is set to be
deleted
To: arslist@ARSLIST.ORG
**
At the bottom of the Wiki you can rate the page… giving a rating is proving
that somebody is looking at it at least.
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Easter, David
Sent: Thursday, May 31, 2012 4:34 PM
To: arslist@ARSLIST.ORG
Subject: Re: BMC Remedy Action Request System Wikipedia page is set to be
deleted
** One of the things I’d thought of that could be done would be to enter some
of the information presented at the last WWRUG keynote in terms of history. I
notice that the Remedy Corp page is not at risk and it’s mainly just history –
so perhaps updating the AR System page with additional content like that would
be enough. If a WWRUG owner could do that, I think it’d go a long way.
-David J. Easter
Manager of Product Management, AR SystemBSM Atrium Solutions Management
BMC Software, Inc.
The opinions, statements, and/or suggested courses of action expressed in this
E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary
participation in this forum is not intended to convey a role as a spokesperson,
liaison or public relations representative for BMC Software, Inc.
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza
Sent: Thursday, May 31, 2012 1:30 PM
To: arslist@ARSLIST.ORG
Subject: Re: BMC Remedy Action Request System Wikipedia page is set to be
deleted
** I just added a couple of things after creating a new wiki account.. Wiki is
one of the SN sites I had stayed away from... nothing significantly important
but I modified the AR object list section with menus, web services and
flashboard objects...
What are they really looking for to keep the page alive??
Joe
From: matt.laurenc...@gmail.com
Sent: Thursday, May 31, 2012 4:21 PM
Newsgroups: public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
Subject: Re: OT: BMC Remedy Action Request System Wikipedia page is set to be
deleted
** ** Thanks all for the heads up.
Competition can mess up such pages if the community doesn't stand up.
Who *outside of BMC* could please update this Wikipedia page with a couple of
facts, so that it is not deleted?
Thanks,
~ Matt Laurenceau
Sr Community Ambassador, BMC Communities
http://bit.ly/MattProfiles
Skype: matt.laurenceau- Reply message -
From: Pat Zandi remedy...@gmail.com
To: arslist@ARSLIST.ORG
Subject: OT: BMC Remedy Action Request System Wikipedia page is set to be
deleted
Date: Thu, May 31, 2012 20:04 Wikipedia is managed by people who want you to
think like them and money talks as well as when it fits my way of thinking
Sent from my iPhone
On May 31, 2012, at 12:50, Jason Miller jason.mil...@gmail.com wrote:
** I was playing with Google BBS terminal and landed on the ARS Wikipedia page.
I was surprised to see a warning that the page will be deleted on June 5th.
Also interesting on Dec 27 2011 Removed ARSList because it is obsolete.
http://en.wikipedia.org/wiki/BMC_Remedy_Action_Request_System
It is proposed that this article be deleted because of the following concern:
No attempt since June 2011 to demonstrate the notability or remove the pure
promo content of this article about obscure software.
If you can address this concern by improving, copyediting, sourcing, renaming
or merging the page, please edit this page and do so. You may remove this
message if you improve the article or otherwise object to deletion for any
reason. However, please explain why you object to the deletion, either in your
edit summary or on the talk page. If this template is removed, it should not be
replaced.
The article may be deleted if this message remains in place for seven days,
i.e., after 02:51 on 5 June.
If you created the article, please don't be offended. Instead, consider
improving the article so that it is acceptable according to the deletion policy.
Notify author/project: {{subst:proposed deletion notify|BMC Remedy Action
Request System|concern=No attempt since June 2011 to demonstrate the notability
or remove the pure promo content of this article about obscure software.}}
Timestamp: 20120529025121
This article appears to be written like an advertisement. Please help improve
it by rewriting promotional content from a neutral point of viewand removing
any inappropriate external links. (June 2011)
The topic of this article may not meet Wikipedia's general notability
guideline. Please help to establish notability by adding reliable, secondary
sources about the topic. If notability cannot be established, the article is
likely to be merged, redirected, or
Re: RE-POST DUE TO FORMAT ERRORS: ARSFAQ! ARSFAQ! - Stackoverflow(ish) clone for Remedy QA - BETA
Nah, just figured it wouldn't hurt since no one has joined and therefore this would not impact your already existing obligations to ARSLIST.ORG. LOL! Date: Mon, 30 Apr 2012 16:18:48 -0600 From: lj.longw...@gmail.com Subject: Re: RE-POST DUE TO FORMAT ERRORS: ARSFAQ! ARSFAQ! - Stackoverflow(ish) clone for Remedy QA - BETA To: arslist@ARSLIST.ORG ** That desperate huh J From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Michael Latham Sent: Monday, April 30, 2012 3:06 PM To: arslist@ARSLIST.ORG Subject: Re: RE-POST DUE TO FORMAT ERRORS: ARSFAQ! ARSFAQ! - Stackoverflow(ish) clone for Remedy QA - BETA ** LJ you're a moderator now. Way to step up to the plate! Date: Fri, 27 Apr 2012 12:06:51 -0600 From: lj.longw...@gmail.com Subject: Re: RE-POST DUE TO FORMAT ERRORS: ARSFAQ! ARSFAQ! - Stackoverflow(ish) clone for Remedy QA - BETA To: arslist@ARSLIST.ORG ** You can’t back down from critical mass…it’s not possible…that’s what’s CRITICAL about it…there is NO GOING BACK….oh well…now we must wait for an ACTUAL second question to see if it truly is critical mass J From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Michael Latham Sent: Friday, April 27, 2012 11:29 AM To: arslist@ARSLIST.ORG Subject: Re: RE-POST DUE TO FORMAT ERRORS: ARSFAQ! ARSFAQ! - Stackoverflow(ish) clone for Remedy QA - BETA ** LOL - Yes weee, NO we didn't! You know what's messed up about that question? It's spam. You know what's messed up about it being spam? I put a lot of effort into writing scripts to flag and capture that stuff. You know what's messed...ahhh you get it. The question has been deleted, of course. Date: Thu, 26 Apr 2012 15:01:35 -0600 From: lj.longw...@gmail.com Subject: Re: RE-POST DUE TO FORMAT ERRORS: ARSFAQ! ARSFAQ! - Stackoverflow(ish) clone for Remedy QA - BETA To: arslist@ARSLIST.ORG ** Michael,We have reached critical mass2012/4/20 Nau, Michael m@ing-diba.de** I’ve got my browser set to auto-refresh and am waiting for question no.2 to be posted. I think this will be the critical mass. Hey, it’s Friday ;-)Good luck with the site! RegardsMichael From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Michael Latham Sent: Monday, April 16, 2012 3:18 AM To: arslist@ARSLIST.ORG Subject: Re: RE-POST DUE TO FORMAT ERRORS: ARSFAQ! ARSFAQ! - Stackoverflow(ish) clone for Remedy QA - BETA ** POLITICAL ANSWER:The idea is to present exclusivity and a sense of community in regards to the Remedy folks that is not an appendage of yet another conglomeration of tech sites.MY ANSWER: I just wanted to provide something I thought was cool to other cool people like myself. You know those individuals who would like to feel more interaction and gain more credit for their knowledge with Remedy and all associated technologies. I also felt like it was an easier interface to collaborate on when it comes to Q A but at the same time providing a forum atmosphere without the forum look. TLDR Version: I just wanted to do something exclusive but familiar to those who share my passion of Remedy...or not. Date: Fri, 13 Apr 2012 09:53:37 -0400 From: jon.sla...@amway.com Subject: Re: RE-POST DUE TO FORMAT ERRORS: ARSFAQ! ARSFAQ! - Stackoverflow(ish) clone for Remedy QA - BETA To: arslist@ARSLIST.ORG I was going to say Why not just create a stack exchange site proposal? AFAIK they're free, you just have to prove you have enough users to make it worthwile ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are_attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ING-DiBa AG, Frankfurt am Main. Registernummer HRB 7727, Handelsregister Amtsgericht Frankfurt am Main. Vorstand: Roland Boekhout (Vorsitzender), Herbert Willius (stellv. Vorsitzender), Bas Brouwers, Bernd Geilen, Katharina Herrmann, Martin Krebs. Aufsichtsrat: Ben Tellings (Vorsitzender) Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist nicht gestattet. This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList
Re: RE-POST DUE TO FORMAT ERRORS: ARSFAQ! ARSFAQ! - Stackoverflow(ish) clone for Remedy QA - BETA
LJ you're a moderator now. Way to step up to the plate! Date: Fri, 27 Apr 2012 12:06:51 -0600 From: lj.longw...@gmail.com Subject: Re: RE-POST DUE TO FORMAT ERRORS: ARSFAQ! ARSFAQ! - Stackoverflow(ish) clone for Remedy QA - BETA To: arslist@ARSLIST.ORG ** You can’t back down from critical mass…it’s not possible…that’s what’s CRITICAL about it…there is NO GOING BACK….oh well…now we must wait for an ACTUAL second question to see if it truly is critical mass J From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Michael Latham Sent: Friday, April 27, 2012 11:29 AM To: arslist@ARSLIST.ORG Subject: Re: RE-POST DUE TO FORMAT ERRORS: ARSFAQ! ARSFAQ! - Stackoverflow(ish) clone for Remedy QA - BETA ** LOL - Yes weee, NO we didn't! You know what's messed up about that question? It's spam. You know what's messed up about it being spam? I put a lot of effort into writing scripts to flag and capture that stuff. You know what's messed...ahhh you get it. The question has been deleted, of course. Date: Thu, 26 Apr 2012 15:01:35 -0600 From: lj.longw...@gmail.com Subject: Re: RE-POST DUE TO FORMAT ERRORS: ARSFAQ! ARSFAQ! - Stackoverflow(ish) clone for Remedy QA - BETA To: arslist@ARSLIST.ORG ** Michael,We have reached critical mass2012/4/20 Nau, Michael m@ing-diba.de** I’ve got my browser set to auto-refresh and am waiting for question no.2 to be posted. I think this will be the critical mass. Hey, it’s Friday ;-)Good luck with the site! RegardsMichael From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Michael Latham Sent: Monday, April 16, 2012 3:18 AM To: arslist@ARSLIST.ORG Subject: Re: RE-POST DUE TO FORMAT ERRORS: ARSFAQ! ARSFAQ! - Stackoverflow(ish) clone for Remedy QA - BETA ** POLITICAL ANSWER:The idea is to present exclusivity and a sense of community in regards to the Remedy folks that is not an appendage of yet another conglomeration of tech sites.MY ANSWER: I just wanted to provide something I thought was cool to other cool people like myself. You know those individuals who would like to feel more interaction and gain more credit for their knowledge with Remedy and all associated technologies. I also felt like it was an easier interface to collaborate on when it comes to Q A but at the same time providing a forum atmosphere without the forum look. TLDR Version: I just wanted to do something exclusive but familiar to those who share my passion of Remedy...or not. Date: Fri, 13 Apr 2012 09:53:37 -0400 From: jon.sla...@amway.com Subject: Re: RE-POST DUE TO FORMAT ERRORS: ARSFAQ! ARSFAQ! - Stackoverflow(ish) clone for Remedy QA - BETA To: arslist@ARSLIST.ORG I was going to say Why not just create a stack exchange site proposal? AFAIK they're free, you just have to prove you have enough users to make it worthwile ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are_attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ING-DiBa AG, Frankfurt am Main. Registernummer HRB 7727, Handelsregister Amtsgericht Frankfurt am Main. Vorstand: Roland Boekhout (Vorsitzender), Herbert Willius (stellv. Vorsitzender), Bas Brouwers, Bernd Geilen, Katharina Herrmann, Martin Krebs. Aufsichtsrat: Ben Tellings (Vorsitzender) Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist nicht gestattet. This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are__attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: RE-POST DUE TO FORMAT ERRORS: ARSFAQ! ARSFAQ! - Stackoverflow(ish) clone for Remedy QA - BETA
LOL - Yes weee, NO we didn't! You know what's messed up about that question? It's spam. You know what's messed up about it being spam? I put a lot of effort into writing scripts to flag and capture that stuff. You know what's messed...ahhh you get it. The question has been deleted, of course. Date: Thu, 26 Apr 2012 15:01:35 -0600 From: lj.longw...@gmail.com Subject: Re: RE-POST DUE TO FORMAT ERRORS: ARSFAQ! ARSFAQ! - Stackoverflow(ish) clone for Remedy QA - BETA To: arslist@ARSLIST.ORG ** Michael,We have reached critical mass 2012/4/20 Nau, Michael m@ing-diba.de ** I’ve got my browser set to auto-refresh and am waiting for question no.2 to be posted. I think this will be the critical mass. Hey, it’s Friday ;-) Good luck with the site! RegardsMichael From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Michael Latham Sent: Monday, April 16, 2012 3:18 AM To: arslist@ARSLIST.ORG Subject: Re: RE-POST DUE TO FORMAT ERRORS: ARSFAQ! ARSFAQ! - Stackoverflow(ish) clone for Remedy QA - BETA ** POLITICAL ANSWER: The idea is to present exclusivity and a sense of community in regards to the Remedy folks that is not an appendage of yet another conglomeration of tech sites. MY ANSWER: I just wanted to provide something I thought was cool to other cool people like myself. You know those individuals who would like to feel more interaction and gain more credit for their knowledge with Remedy and all associated technologies. I also felt like it was an easier interface to collaborate on when it comes to Q A but at the same time providing a forum atmosphere without the forum look. TLDR Version: I just wanted to do something exclusive but familiar to those who share my passion of Remedy...or not. Date: Fri, 13 Apr 2012 09:53:37 -0400 From: jon.sla...@amway.com Subject: Re: RE-POST DUE TO FORMAT ERRORS: ARSFAQ! ARSFAQ! - Stackoverflow(ish) clone for Remedy QA - BETA To: arslist@ARSLIST.ORG I was going to say Why not just create a stack exchange site proposal? AFAIK they're free, you just have to prove you have enough users to make it worthwile ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ING-DiBa AG, Frankfurt am Main. Registernummer HRB 7727, Handelsregister Amtsgericht Frankfurt am Main. Vorstand: Roland Boekhout (Vorsitzender), Herbert Willius (stellv. Vorsitzender), Bas Brouwers, Bernd Geilen, Katharina Herrmann, Martin Krebs. Aufsichtsrat: Ben Tellings (Vorsitzender) Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist nicht gestattet. This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Working with ENCRYPT() function...
that involved more development than customization. I had stayed away from ITSM kind of projects for the longest time, until I realized that if I kept staying away from it, I might soon have to start looking at an alternative solution to work with. I've had very brief opportunities to work with some complimentary products, but stayed with the mainstream Remedy products mostly. As you may have figured out from some of my recent posts, I am currently working on an integration effort between Remedy and OIM (Oracle Identity Management) using their SPML (web services). I had a sticky pitch for a while, but it turned out it was because of some configuration settings from the OIM side. They (OIM admins) still haven’t figured out what that discrepancy might be but I’ve asked them to investigate the difference between a now working instance and the older non working one. This I figure would be useful information to have later while building the other production and training environments at this site.. Anyways getting back on topic, I’m yet to determine what length I may need to hold my encrypted string that holds the OIM configuration password... I have currently set it to 120 and for now will resort to the good old trial and error method, in the absence of the exact formula to use to determine it. OIM allows passwords of no more than length 8 and I have noticed that using an encryption key of length 38, a GUID, returns outputs of length averaging in between 75 to 80.. So I created a field of length 120 to store that, hoping it would not cross that value. Cheers Joe From: Michael Latham Sent: Monday, April 23, 2012 9:48 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Working with ENCRYPT() function... ** I have been good Joe. Just doing the usual Remedy consultant thing. And you? I see you are an arslist superstar by looking at your post history. Cool that you stay involved with the community so much. I wish I had the time! Take care man and stay in touch! Mike Date: Fri, 20 Apr 2012 18:06:38 -0400 From: jdso...@shyle.net Subject: Re: Working with ENCRYPT() function... To: arslist@ARSLIST.ORG ** Yes I was interested in the character count as if I encrypted the input, I’d need to consider enough room for storage. I was tempted to build a 254 character field to store it, but then curiosity got the better of me and I wanted to know if there was an algorithm to calculate the expected length of the encrypted text.. Yes I do remember you from Nomura. How have you been. Thank you for the info.. something that I can digest over the weekend.. Joe From: Michael Latham Sent: Friday, April 20, 2012 5:47 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Working with ENCRYPT() function... ** Hey Joe - How have things been since Nomura - if you remember me from that project and you are in fact the same Joe De'Souza. To move along, encryption algorithms vary. If I am not mistaken Remedy ARS uses DES block-cipher encryption in the ENCRYPT function.DES in and of itself is symmetric from an algorithm standpoint. It uses one 64-bit key to encrypt a block of plaintext that is 64-bits into ciphered text. It has one parity bit for each byte of the provided key which generates a key strength which is only 56-bits. Per BMC Documentation: The output is limited to the size of the field used for output, including the base-64 encoding. Therefore, you are limited to encrypting a string that is 3/4 the size of the output field. Using the passphrase method as a way to generate the encrypted text is achieved using, most probably, a key derivation and salt combination. In order to decrypt ciphered text you would need to code an external DES ciphering utility in your language of choice that would encrypt the plain text based on the key provided or decrypt the ciphered text using the key provided. As long as you have the key you can go back and forth with the encryption/decryption. By the way, why do you need to know the length of the output string? I am assuming when you say length you mean character count or something similar. Mike Date: Fri, 20 Apr 2012 13:48:37 -0400 From: jdso...@shyle.net Subject: Working with ENCRYPT() function... To: arslist@ARSLIST.ORG ** Is there a known algorithm to calculate the length of the output results of ENCRYPT based on the length of the input string and the encryption key parameters? I vaguely remember that the length is 120. Or is that only the length of the encrypted value in Field 123? Also how would one decrypt the contents of Field 123 if that is used for storing a password that is used for authenticating into an external app or wsdl? Joe _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_
Re: Working with ENCRYPT() function...
@ARSLIST.ORG ** Good to hear from you too Michael.. I’m back in the downtown area these days – haven’t worked in this area since we last worked together at Nomura about 7 years ago. Time flies eh? I’m about 2 or 3 blocks away from there and even intend to take lunch at some of those restaurants from that area when the weather gets a little more forgiving.. I’m still into Remedy work a bit of consulting and some developing. I kind of miss some of the older work we used to get that involved more development than customization. I had stayed away from ITSM kind of projects for the longest time, until I realized that if I kept staying away from it, I might soon have to start looking at an alternative solution to work with. I've had very brief opportunities to work with some complimentary products, but stayed with the mainstream Remedy products mostly. As you may have figured out from some of my recent posts, I am currently working on an integration effort between Remedy and OIM (Oracle Identity Management) using their SPML (web services). I had a sticky pitch for a while, but it turned out it was because of some configuration settings from the OIM side. They (OIM admins) still haven’t figured out what that discrepancy might be but I’ve asked them to investigate the difference between a now working instance and the older non working one. This I figure would be useful information to have later while building the other production and training environments at this site.. Anyways getting back on topic, I’m yet to determine what length I may need to hold my encrypted string that holds the OIM configuration password... I have currently set it to 120 and for now will resort to the good old trial and error method, in the absence of the exact formula to use to determine it. OIM allows passwords of no more than length 8 and I have noticed that using an encryption key of length 38, a GUID, returns outputs of length averaging in between 75 to 80.. So I created a field of length 120 to store that, hoping it would not cross that value. Cheers Joe From: Michael Latham Sent: Monday, April 23, 2012 9:48 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Working with ENCRYPT() function... ** I have been good Joe. Just doing the usual Remedy consultant thing. And you? I see you are an arslist superstar by looking at your post history. Cool that you stay involved with the community so much. I wish I had the time! Take care man and stay in touch! Mike Date: Fri, 20 Apr 2012 18:06:38 -0400 From: jdso...@shyle.net Subject: Re: Working with ENCRYPT() function... To: arslist@ARSLIST.ORG ** Yes I was interested in the character count as if I encrypted the input, I’d need to consider enough room for storage. I was tempted to build a 254 character field to store it, but then curiosity got the better of me and I wanted to know if there was an algorithm to calculate the expected length of the encrypted text.. Yes I do remember you from Nomura. How have you been. Thank you for the info.. something that I can digest over the weekend.. Joe From: Michael Latham Sent: Friday, April 20, 2012 5:47 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Working with ENCRYPT() function... ** Hey Joe - How have things been since Nomura - if you remember me from that project and you are in fact the same Joe De'Souza. To move along, encryption algorithms vary. If I am not mistaken Remedy ARS uses DES block-cipher encryption in the ENCRYPT function.DES in and of itself is symmetric from an algorithm standpoint. It uses one 64-bit key to encrypt a block of plaintext that is 64-bits into ciphered text. It has one parity bit for each byte of the provided key which generates a key strength which is only 56-bits. Per BMC Documentation: The output is limited to the size of the field used for output, including the base-64 encoding. Therefore, you are limited to encrypting a string that is 3/4 the size of the output field. Using the passphrase method as a way to generate the encrypted text is achieved using, most probably, a key derivation and salt combination. In order to decrypt ciphered text you would need to code an external DES ciphering utility in your language of choice that would encrypt the plain text based on the key provided or decrypt the ciphered text using the key provided. As long as you have the key you can go back and forth with the encryption/decryption. By the way, why do you need to know the length of the output string? I am assuming when you say length you mean character count or something similar. Mike Date: Fri, 20 Apr 2012 13:48:37 -0400 From: jdso...@shyle.net Subject: Working with ENCRYPT() function... To: arslist@ARSLIST.ORG ** Is there a known algorithm to calculate the length of the output results of ENCRYPT
Re: Working with ENCRYPT() function...
I have been good Joe. Just doing the usual Remedy consultant thing. And you? I see you are an arslist superstar by looking at your post history. Cool that you stay involved with the community so much. I wish I had the time! Take care man and stay in touch! Mike Date: Fri, 20 Apr 2012 18:06:38 -0400 From: jdso...@shyle.net Subject: Re: Working with ENCRYPT() function... To: arslist@ARSLIST.ORG ** Yes I was interested in the character count as if I encrypted the input, I’d need to consider enough room for storage. I was tempted to build a 254 character field to store it, but then curiosity got the better of me and I wanted to know if there was an algorithm to calculate the expected length of the encrypted text.. Yes I do remember you from Nomura. How have you been. Thank you for the info.. something that I can digest over the weekend.. Joe From: Michael Latham Sent: Friday, April 20, 2012 5:47 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Working with ENCRYPT() function... ** Hey Joe - How have things been since Nomura - if you remember me from that project and you are in fact the same Joe De'Souza. To move along, encryption algorithms vary. If I am not mistaken Remedy ARS uses DES block-cipher encryption in the ENCRYPT function.DES in and of itself is symmetric from an algorithm standpoint. It uses one 64-bit key to encrypt a block of plaintext that is 64-bits into ciphered text. It has one parity bit for each byte of the provided key which generates a key strength which is only 56-bits. Per BMC Documentation: The output is limited to the size of the field used for output, including the base-64 encoding. Therefore, you are limited to encrypting a string that is 3/4 the size of the output field. Using the passphrase method as a way to generate the encrypted text is achieved using, most probably, a key derivation and salt combination. In order to decrypt ciphered text you would need to code an external DES ciphering utility in your language of choice that would encrypt the plain text based on the key provided or decrypt the ciphered text using the key provided. As long as you have the key you can go back and forth with the encryption/decryption. By the way, why do you need to know the length of the output string? I am assuming when you say length you mean character count or something similar. Mike Date: Fri, 20 Apr 2012 13:48:37 -0400 From: jdso...@shyle.net Subject: Working with ENCRYPT() function... To: arslist@ARSLIST.ORG ** Is there a known algorithm to calculate the length of the output results of ENCRYPT based on the length of the input string and the encryption key parameters? I vaguely remember that the length is 120. Or is that only the length of the encrypted value in Field 123? Also how would one decrypt the contents of Field 123 if that is used for storing a password that is used for authenticating into an external app or wsdl? Joe_attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are__attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Working with ENCRYPT() function...
In general - a character in the English language is represented by 1 byte for ASCII and 2 bytes per character for Unicode. A lot of encoding in the various languages is done using Unicode. So 1 Byte contains 8-16 bits depending on whether it is ASCII or Unicode. Excuse me for a moment, I need to get caught up on what you are currently doing or what your actual issue is. You take a value which you input yourself and use the ENCRYPT function to cipher that value? You then want to get the length of the encrypted value? Date: Mon, 23 Apr 2012 11:17:02 -0400 From: jdso...@shyle.net Subject: Re: Working with ENCRYPT() function... To: arslist@ARSLIST.ORG ** Good to hear from you too Michael.. I’m back in the downtown area these days – haven’t worked in this area since we last worked together at Nomura about 7 years ago. Time flies eh? I’m about 2 or 3 blocks away from there and even intend to take lunch at some of those restaurants from that area when the weather gets a little more forgiving.. I’m still into Remedy work a bit of consulting and some developing. I kind of miss some of the older work we used to get that involved more development than customization. I had stayed away from ITSM kind of projects for the longest time, until I realized that if I kept staying away from it, I might soon have to start looking at an alternative solution to work with. I've had very brief opportunities to work with some complimentary products, but stayed with the mainstream Remedy products mostly. As you may have figured out from some of my recent posts, I am currently working on an integration effort between Remedy and OIM (Oracle Identity Management) using their SPML (web services). I had a sticky pitch for a while, but it turned out it was because of some configuration settings from the OIM side. They (OIM admins) still haven’t figured out what that discrepancy might be but I’ve asked them to investigate the difference between a now working instance and the older non working one. This I figure would be useful information to have later while building the other production and training environments at this site.. Anyways getting back on topic, I’m yet to determine what length I may need to hold my encrypted string that holds the OIM configuration password... I have currently set it to 120 and for now will resort to the good old trial and error method, in the absence of the exact formula to use to determine it. OIM allows passwords of no more than length 8 and I have noticed that using an encryption key of length 38, a GUID, returns outputs of length averaging in between 75 to 80.. So I created a field of length 120 to store that, hoping it would not cross that value. Cheers Joe From: Michael Latham Sent: Monday, April 23, 2012 9:48 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Working with ENCRYPT() function... ** I have been good Joe. Just doing the usual Remedy consultant thing. And you? I see you are an arslist superstar by looking at your post history. Cool that you stay involved with the community so much. I wish I had the time! Take care man and stay in touch! Mike Date: Fri, 20 Apr 2012 18:06:38 -0400 From: jdso...@shyle.net Subject: Re: Working with ENCRYPT() function... To: arslist@ARSLIST.ORG ** Yes I was interested in the character count as if I encrypted the input, I’d need to consider enough room for storage. I was tempted to build a 254 character field to store it, but then curiosity got the better of me and I wanted to know if there was an algorithm to calculate the expected length of the encrypted text.. Yes I do remember you from Nomura. How have you been. Thank you for the info.. something that I can digest over the weekend.. Joe From: Michael Latham Sent: Friday, April 20, 2012 5:47 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Working with ENCRYPT() function... ** Hey Joe - How have things been since Nomura - if you remember me from that project and you are in fact the same Joe De'Souza. To move along, encryption algorithms vary. If I am not mistaken Remedy ARS uses DES block-cipher encryption in the ENCRYPT function.DES in and of itself is symmetric from an algorithm standpoint. It uses one 64-bit key to encrypt a block of plaintext that is 64-bits into ciphered text. It has one parity bit for each byte of the provided key which generates a key strength which is only 56-bits. Per BMC Documentation: The output is limited to the size of the field used for output, including the base-64 encoding. Therefore, you are limited to encrypting a string that is 3/4 the size of the output field. Using the passphrase method as a way to generate the encrypted text is achieved using, most probably, a key derivation and salt combination. In order to decrypt ciphered text you would need
Re: Working with ENCRYPT() function...
Hey Joe - How have things been since Nomura - if you remember me from that project and you are in fact the same Joe De'Souza. To move along, encryption algorithms vary. If I am not mistaken Remedy ARS uses DES block-cipher encryption in the ENCRYPT function.DES in and of itself is symmetric from an algorithm standpoint. It uses one 64-bit key to encrypt a block of plaintext that is 64-bits into ciphered text. It has one parity bit for each byte of the provided key which generates a key strength which is only 56-bits. Per BMC Documentation: The output is limited to the size of the field used for output, including the base-64 encoding.Therefore, you are limited to encrypting a string that is 3/4 the size of the output field. Using the passphrase method as a way to generate the encrypted text is achieved using, most probably, a key derivation and salt combination. In order to decrypt ciphered text you would need to code an external DES ciphering utility in your language of choice that would encrypt the plain text based on the key provided or decrypt the ciphered text using the key provided. As long as you have the key you can go back and forth with the encryption/decryption. By the way, why do you need to know the length of the output string? I am assuming when you say length you mean character count or something similar. Mike Date: Fri, 20 Apr 2012 13:48:37 -0400 From: jdso...@shyle.net Subject: Working with ENCRYPT() function... To: arslist@ARSLIST.ORG ** Is there a known algorithm to calculate the length of the output results of ENCRYPT based on the length of the input string and the encryption key parameters? I vaguely remember that the length is 120. Or is that only the length of the encrypted value in Field 123? Also how would one decrypt the contents of Field 123 if that is used for storing a password that is used for authenticating into an external app or wsdl? Joe _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: RE-POST DUE TO FORMAT ERRORS: ARSFAQ! ARSFAQ! - Stackoverflow(ish) clone for Remedy QA - BETA
LOL - I almost inhaled my coffee. Thanks Mike! Date: Fri, 20 Apr 2012 11:03:43 +0200 From: m@ing-diba.de Subject: Re: RE-POST DUE TO FORMAT ERRORS: ARSFAQ! ARSFAQ! - Stackoverflow(ish) clone for Remedy QA - BETA To: arslist@ARSLIST.ORG ** I’ve got my browser set to auto-refresh and am waiting for question no.2 to be posted. I think this will be the critical mass. Hey, it’s Friday ;-)Good luck with the site! RegardsMichael From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Michael Latham Sent: Monday, April 16, 2012 3:18 AM To: arslist@ARSLIST.ORG Subject: Re: RE-POST DUE TO FORMAT ERRORS: ARSFAQ! ARSFAQ! - Stackoverflow(ish) clone for Remedy QA - BETA ** POLITICAL ANSWER:The idea is to present exclusivity and a sense of community in regards to the Remedy folks that is not an appendage of yet another conglomeration of tech sites.MY ANSWER: I just wanted to provide something I thought was cool to other cool people like myself. You know those individuals who would like to feel more interaction and gain more credit for their knowledge with Remedy and all associated technologies. I also felt like it was an easier interface to collaborate on when it comes to Q A but at the same time providing a forum atmosphere without the forum look. TLDR Version: I just wanted to do something exclusive but familiar to those who share my passion of Remedy...or not. Date: Fri, 13 Apr 2012 09:53:37 -0400 From: jon.sla...@amway.com Subject: Re: RE-POST DUE TO FORMAT ERRORS: ARSFAQ! ARSFAQ! - Stackoverflow(ish) clone for Remedy QA - BETA To: arslist@ARSLIST.ORG I was going to say Why not just create a stack exchange site proposal? AFAIK they're free, you just have to prove you have enough users to make it worthwile ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are_attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ING-DiBa AG, Frankfurt am Main. Registernummer HRB 7727, Handelsregister Amtsgericht Frankfurt am Main. Vorstand: Roland Boekhout (Vorsitzender), Herbert Willius (stellv. Vorsitzender), Bas Brouwers, Bernd Geilen, Katharina Herrmann, Martin Krebs. Aufsichtsrat: Ben Tellings (Vorsitzender) Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist nicht gestattet. This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Working with ENCRYPT() function...
Also check out this stackoverflow.com question: http://stackoverflow.com/questions/457193/length-of-encrypted-string I think it may be relevant to your question in a general sense. Date: Fri, 20 Apr 2012 13:48:37 -0400 From: jdso...@shyle.net Subject: Working with ENCRYPT() function... To: arslist@ARSLIST.ORG ** Is there a known algorithm to calculate the length of the output results of ENCRYPT based on the length of the input string and the encryption key parameters? I vaguely remember that the length is 120. Or is that only the length of the encrypted value in Field 123? Also how would one decrypt the contents of Field 123 if that is used for storing a password that is used for authenticating into an external app or wsdl? Joe _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Question about .NET APIs and currency fields
Are you saying this is happening from the .NET side or the is it happening from the API side when the entry is created? I am thinking that you are referring to the latter. Can you provide the/a debug dump? Cheers! Mike L. Date: Tue, 17 Apr 2012 08:56:51 +0200 From: fa259...@skynet.be Subject: Question about .NET APIs and currency fields To: arslist@ARSLIST.ORG ** Hi Listers, I am currently using .NET APIs to move data from one form to another one.I perform a query and obtain a list of entryIds, select some fieldIds and obtain values from ARServer thruserver.GetEntry(schemaName, entryId, fieldIds)Later, I copy the unmodified values to the target form thru_server.CreateEntry(targetSchemaName, fieldIds) Surprisingly, currency values are multiplied by a factor 100 (1 followed by 10 zeroes)Is this normal? Does anyone already faced that? Thanks André _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: RE-POST DUE TO FORMAT ERRORS: ARSFAQ! ARSFAQ! - Stackoverflow(ish) clone for Remedy QA - BETA
POLITICAL ANSWER:The idea is to present exclusivity and a sense of community in regards to the Remedy folks that is not an appendage of yet another conglomeration of tech sites. MY ANSWER: I just wanted to provide something I thought was cool to other cool people like myself. You know those individuals who would like to feel more interaction and gain more credit for their knowledge with Remedy and all associated technologies. I also felt like it was an easier interface to collaborate on when it comes to Q A but at the same time providing a forum atmosphere without the forum look. TLDR Version: I just wanted to do something exclusive but familiar to those who share my passion of Remedy...or not. Date: Fri, 13 Apr 2012 09:53:37 -0400 From: jon.sla...@amway.com Subject: Re: RE-POST DUE TO FORMAT ERRORS: ARSFAQ! ARSFAQ! - Stackoverflow(ish) clone for Remedy QA - BETA To: arslist@ARSLIST.ORG I was going to say Why not just create a stack exchange site proposal? AFAIK they're free, you just have to prove you have enough users to make it worthwile ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
ARSFAQ! ARSFAQ! - Stackoverflow(ish) clone for Remedy QA - BETA
Hello Fellow ARServants(?): I know, I know why do we need yet another Remedy QA site, right? Well I could answer that in various ways but either way it goes it will be my opinion so I won't answer it. I will let you answer that questions for yourself. Who do you trust more than yourself? Exactly! Take a dive and find the bugs-just don't eat them. I don't know what that means so I digress. Please feel free to visit arsfaq.com and play around until you break something. Upfront here are the things I have not enabled: 1. Facebook Integration! - You ask why not, I ask WHY? If it is totally necessary that it be enabled I will go ahead and do so, for now we are in beta and I just don't see the point of it at the moment. Doesn't Facebook know enough about you already? I kid, I kid. 2. Twitter Integration! - You ask why not, I say SEE item 1 in this list. 3. I think MyOpenID works - I don't know for sure because everything works for the admin - I need the user to tell me the truth. Yes, I can handle the truth! Get it? No? Okay, never mind. I am doing this as a pilot so if the feedback, responses, and/or criticisms are minimal I will have to cancel the show, err, I mean site. Have a go and tell me what you think. I can be reached at mlat...@arsfaq.com if you need to shout at me, curse me, or give me accolades. I prefer the latter. Have a beneficial life but for now just work on having a beneficial today! Yes I know it can be pronounced either mistakenly or on purpose as ARSE-FAQ! Enough already! :D ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
RE-POST DUE TO FORMAT ERRORS: ARSFAQ! ARSFAQ! - Stackoverflow(ish) clone for Remedy QA - BETA
I have re-posted this because the html version didn't seem to format correctly and it may have been a chore for most to read the content-it was for me. Hello Fellow ARServants(?): I know, I know why do we need yet another Remedy QA site, right? Well I could answer that in various ways but either way it goes it will be my opinion so I won't answer it. I will let you answer that questions for yourself. Who do you trust more than yourself? Exactly! Take a dive and find the bugs-just don't eat them. I don't know what that means so I digress. Please feel free to visit arsfaq.com and play around until you break something. Upfront here are the things I have not enabled: 1. Facebook Integration! - You ask why not, I ask WHY? If it is totally necessary that it be enabled I will go ahead and do so, for now we are in beta and I just don't see the point of it at the moment. Doesn't Facebook know enough about you already? I kid, I kid. 2. Twitter Integration! - You ask why not, I say SEE item 1 in this list. 3. I think MyOpenID works - I don't know for sure because everything works for the admin - I need the user to tell me the truth. Yes, I can handle the truth! Get it? No? Okay, never mind. I am doing this as a pilot so if the feedback, responses, and/or criticisms are minimal I will have to cancel the show, err, I mean site. Have a go and tell me what you think. I can be reached at mlat...@arsfaq.com if you need to shout at me, curse me, or give me accolades. I prefer the latter. Have a beneficial life but for now just work on having a beneficial today! Yes I know it can be pronounced either mistakenly or on purpose as ARSE-FAQ! Enough already! :D ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: RE-POST DUE TO FORMAT ERRORS: ARSFAQ! ARSFAQ! - Stackoverflow(ish) clone for Remedy QA - BETA
In all actuality, I have not. It's a pilot for other ventures I intend to take to be honest. The thing has been parked in BETA for like 6 months or so. I was too lazy to deploy it. I pressed the go button and said oh well what the heck, no loss no foul (I didn't really say that). Date: Thu, 12 Apr 2012 15:26:12 -0400 From: arsl...@danielbloom.ca Subject: Re: RE-POST DUE TO FORMAT ERRORS: ARSFAQ! ARSFAQ! - Stackoverflow(ish) clone for Remedy QA - BETA To: arslist@ARSLIST.ORG JARS: Just Another Remedy Site Michael, I take it you haven't searched to see how many similar sites already exist? Here I was hoping someone had started the WIKI Book. Daniel -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Michael Latham Sent: April 12, 2012 3:16 PM To: arslist@ARSLIST.ORG Subject: RE-POST DUE TO FORMAT ERRORS: ARSFAQ! ARSFAQ! - Stackoverflow(ish) clone for Remedy QA - BETA I have re-posted this because the html version didn't seem to format correctly and it may have been a chore for most to read the content-it was for me. Hello Fellow ARServants(?): I know, I know why do we need yet another Remedy QA site, right? Well I could answer that in various ways but either way it goes it will be my opinion so I won't answer it. I will let you answer that questions for yourself. Who do you trust more than yourself? Exactly! Take a dive and find the bugs-just don't eat them. I don't know what that means so I digress. Please feel free to visit arsfaq.com and play around until you break something. Upfront here are the things I have not enabled: 1. Facebook Integration! - You ask why not, I ask WHY? If it is totally necessary that it be enabled I will go ahead and do so, for now we are in beta and I just don't see the point of it at the moment. Doesn't Facebook know enough about you already? I kid, I kid. 2. Twitter Integration! - You ask why not, I say SEE item 1 in this list. 3. I think MyOpenID works - I don't know for sure because everything works for the admin - I need the user to tell me the truth. Yes, I can handle the truth! Get it? No? Okay, never mind. I am doing this as a pilot so if the feedback, responses, and/or criticisms are minimal I will have to cancel the show, err, I mean site. Have a go and tell me what you think. I can be reached at mlat...@arsfaq.com if you need to shout at me, curse me, or give me accolades. I prefer the latter. Have a beneficial life but for now just work on having a beneficial today! Yes I know it can be pronounced either mistakenly or on purpose as ARSE-FAQ! Enough already! :D ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Load Balancers and how?
** The LB itself should be able to determine that if it is configured correctly. In particular on Apache you would use mod_proxy and mod_proxy_balancer modules simultaneously with some ProxyPass directives defined. Any of your web server admins should have a very good idea of what I am talking about. If I were not typing this from my obnoxious touchscreen I would go into more detail. In any case if you need more precise help reply stating so and I will be happy to help on e I get to my desk.Cheerios!Sent from my Windows Phone From: LJ LongWingSent: Friday, December 10, 2010 10:49 AMTo: arslist@ARSLIST.ORGSubject: Load Balancers and how? Ok..I'm going down a road that I KNOW some of you have travelled before, I need your travel tips. We are setting up a server group on 7.5 Windows and we are putting a load balancer in front of it. How do you all tell if a node is up? There are 4 types of probes that I'm being told are available. PING HTTP TCP Script Ping - Obviously doesn't tell you anything other than the host OS is up HTTP - Won't work for telling if a remedy service is up TCP - My instincts are telling me that this one simply does something similar to a telnet to a given port, if the port allows you 'in', then the service is considered up. I don't consider this one viable because it doesn't 'test' much and I expect that my remedy server could respond to the port request without actually being functional Script - This one is the most promising in my mind, but I know nothing about the scripting language of TCL. How does the rest of the remedy world 'verify' that their remedy instance is online so that their load balancer can know to route traffic to it or not. I just this week finished a java servlet that allows the mid tier load balancer to know if an individual node is working properly, but the same can't be said yet for Remedy..any and all help is appreciated ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_
Re: Recommendations for Load Balancers and Mid-Tier Servers
** If you are using Apache then I recommend, Apache+Tomcat configuration. Other than that there are a plethora of options out there under both open and "closed" source licenses.Sent from my Windows Phone From: Pruitt, Christopher (Bank of America Account)Sent: Friday, December 10, 2010 11:25 AMTo: arslist@ARSLIST.ORGSubject: Recommendations for Load Balancers and Mid-Tier Servers Hello All, We are in the discovery process for setting up some new mid-tier servers. We are looking at standing up some HP ProLiant DL380 G6 Servers and am seeking some recommendations for Load Balancers. Anyone have some suggestions for some good load balancers for these servers? Christopher Pruitt Business Consulting III HP Enterprises Services christopher.pru...@hp.com www.hp.comhttp://www.hp.com/ [cid:image003.png@01CB9854.80347F30] Confidentiality Notice: This message and any files transmitted with it are intended for the sole use of the entity or individual to whom it is addressed, and may contain information that is confidential, privileged, and exempt from disclosure under applicable law. If you are not the intended addressee for this e-mail, you are hereby notified that any copying, distribution, or dissemination of this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately destroy, erase, or discard this message. Please notify the sender immediately by return e-mail if you have received this e-mail by mistake. _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_
Re: Recommendations for Load Balancers and Mid-Tier Servers
** Apache does a very excellent job as long as it is properly configured alongside Tomcat and as well setup on scalable hardware. Apache is just as corporate as any other software option and it is not the most widely used web server because it can't perform, right :-D?? Going cheap is just one of the benefits of using Apache and not one of the caveats. Apache does an amazing job dealing with large scale connections from end clients. We easily handle 1000+ concurrent connections in our environment. Due diligence is the key.Sent from my Windows Phone From: Gard, Richard JSent: Friday, December 10, 2010 11:49 AMTo: arslist@ARSLIST.ORGSubject: Re: Recommendations for Load Balancers and Mid-Tier Servers In a corporate environment, use the corporate load balancer. I would only use the Apache LB if I were trying to do it on the cheap and did not have something like ACE or LD. Best regards, Rich 謝 謝 你 。 GIS-ISS-SEM Service Technology Development Manager ITIL Practisioner Certified: Support and Restore Information Classification: Limited Access From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Michael Latham Sent: Friday, December 10, 2010 11:41 AM To: arslist@ARSLIST.ORG Subject: Re: Recommendations for Load Balancers and Mid-Tier Servers ** If you are using Apache then I recommend, Apache+Tomcat configuration. Other than that there are a plethora of options out there under both open and closed source licenses. Sent from my Windows Phone From: Pruitt, Christopher (Bank of America Account) Sent: Friday, December 10, 2010 11:25 AM To: arslist@ARSLIST.ORG Subject: Recommendations for Load Balancers and Mid-Tier Servers Hello All, We are in the discovery process for setting up some new mid-tier servers. We are looking at standing up some HP ProLiant DL380 G6 Servers and am seeking some recommendations for Load Balancers. Anyone have some suggestions for some good load balancers for these servers? Christopher Pruitt Business Consulting III HP Enterprises Services christopher.pru...@hp.com www.hp.comhttp://www.hp.com/ [cid:image003.png@01CB9854.80347F30] Confidentiality Notice: This message and any files transmitted with it are intended for the sole use of the entity or individual to whom it is addressed, and may contain information that is confidential, privileged, and exempt from disclosure under applicable law. If you are not the intended addressee for this e-mail, you are hereby notified that any copying, distribution, or dissemination of this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately destroy, erase, or discard this message. Please notify the sender immediately by return e-mail if you have received this e-mail by mistake. _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_
Re: Change Mgmt 7.0.03
In general if the AL does fire in search mode you can set it so that it does not execute on submit. Sent from my Windows Phone -Original Message- From: Martinez, Marcelo A Sent: Tuesday, December 07, 2010 6:22 PM To: arslist@ARSLIST.ORG Subject: Change Mgmt 7.0.03 Anybody running ITSM 7.0.03, can you verify a couple of items for me: Does Active Link CHG:CRQ:Risk_OnChangeRisk_LevelSetUserSpecified exists? Does the above AL fires in Search mode? The reason I ask is because it was brought to my attention that when users were searching for change tickets - say Risk Level 3 tickets - they would get a significantly lower number than what actually was out there. My reason/response to this was because when you perform a search by selecting Risk Level 3 from the drop-down, the AL fires which sets a hidden field. Therefore your search criteria includes the value of the hidden field set by the AL . Last question, why does the above active link fire on Search mode, if not really needed??? TIA, Marcelo ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Midtier error not allowing records to be saved.
** Check your web logs for redirects. Navigation messages are typical of a redirect occurring. Also the messages can show when workflow calls a close window action. You can monitor _javascript_ activity in Chrome or Firefox (via firebug for instance) on top of enabling workflow logging. That should give you a good snapshot of what's going on.Sent from my Windows Phone From: Rick CookSent: Monday, December 06, 2010 1:00 PMTo: arslist@ARSLIST.ORGSubject: Midtier error not allowing records to be saved. We are seeing something on our CM 7.5 application that we haven't seen before. After creating an RFC, any attempt to save it displays a dialog asking if we are sure we want to navigate away from this page. Essentially, from that point no changes can be saved, and only closing the Change with the X can bypass the popup. We have successfully run through this scenario many times before, so I don't think its workflow. Any ideas on what it might be? Tomcat on 7.5 MT, browser is IIS 7. Rick ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_
Re: 7.1.0 P7 Install problems
Hey Lyle, Actually he mentioned Error 1064 but maybe you made a typo, happens to the best of us : P. It is a general sql error that can occur in oracle, mssql server, or mysql. I am not quite sure but there is probably some type of database related authentication issue here. Would have to delve a little deeper into my notes for 7.* installs I have done over the past few years. Just so you know I recently did a successful install of patch 7 in VirtualPC environment. All ITSM apps, Atrium Core, and the related engines on MSSQL2005 and Win2003Server. Now I cannot get the service to start. So we are both looking at something similar here I suppose. The only difference I have service startup issue after completing a successful install. Well actually not complete cause I stopped the change management install due to lag on my box. I am sure I broke something. I am about to go fresh again and see what happens. I will keep you updated! Cheerios! Mike Latham - Some Remedy Developer Guy From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor Sent: Wednesday, August 26, 2009 1:48 PM To: arslist@ARSLIST.ORG Subject: Re: 7.1.0 P7 Install problems ** I just tried Googling Windows error 1604. Looks like it's a common MySQL error. Are you sure you're using SQL Server and not MySQL? ;-) Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Rick Cook Sent: Wednesday, August 26, 2009 11:26 AM To: arslist@ARSLIST.ORG Subject: Re: 7.1.0 P7 Install problems ** Just to eliminate that as a potential issue, we did bump up the RAM to 3 GB. Still the same problem. Windows error 1064. Rick On Wed, Aug 26, 2009 at 6:54 AM, Rick Cook remedyr...@gmail.com wrote: ** 2 GB. AR System should at least install with that, since there is nothing else but the OS running on the VM. The DB is remote. Agree? Rick _ From: copits.rich...@bwc.state.oh.us Date: Wed, 26 Aug 2009 07:41:40 -0400 To: arslist@ARSLIST.ORG Subject: Re: 7.1.0 P7 Install problems Check the amount of memory that you have allocated in your VM From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Rick Cook Sent: Tuesday, August 25, 2009 6:13 PM To: arslist@ARSLIST.ORG Subject: 7.1.0 P7 Install problems ** I have been trying for two days to install AR Server 7.1.0 Patch 7 on a Win2k3/SQL2k5 VM. I have done this a dozen times in other places without significant problems, but this one just will not install. I get an arcane Windows error (1064), there are almost no logs created, and while the DB and the metatables are created, the service will not start, meaning that no forms or workflow can be imported. We tried starting the service in debug mode, but that didn't work at all. The problem seems to be that the service just will not start. It doesn't reference any authentication or logon error in the Event Viewer, just a mystery application error that leads pretty much nowhere. We tried both SQL (sa) and Windows (admin) authentication, though the Windows account used wasn't a full domain admin. It was a local admin that also had admin privileges on the shared SQL server. My next step is to try installing patch 6 instead of 7, to remove that from the list of potential remaining issues. The server install is a direct download from Support just yesterday. Has anyone seen this before? I am about out of ideas for new things to try, and Support so far has only asked for files I don't have to give. Rick _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: mid tier error
Sounds like you are accessing a page in a directory that does not have the proper permissions applied for the authenticated user that you logged in with. Like a user who has public access is trying to access a private directory. Directory permissions are always an annoyance when it comes to web apps. Give the whole URL and I can probably tell you what is going on. Are you using Tomcat per chance? Anyway try this: *Open IIS Manager by typing inetmgr in run dialog box *Right click on your web site directory and select properties *Go to the directory security tab and click on the edit button under the anonymous access and authentication section *Check the chekcbox to enable anonymous access or provide the correct account name and password Mike Latham - Some Remedy Developer Guy -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Raj Sent: Wednesday, August 26, 2009 1:58 PM To: arslist@ARSLIST.ORG Subject: mid tier error Hello All, I am getting the following error message when trying to access remedy through web. What could be the problem? Thanks, Raj You are not authorized to view this page You do not have permission to view this directory or page using the credentials that you supplied. Please try the following: Contact the Web site administrator if you believe you should be able to view this directory or page. Click the Refresh button to try again with different credentials. HTTP Error 401.1 - Unauthorized: Access is denied due to invalid credentials. Internet Information Services (IIS) Technical Information (for support personnel) Go to Microsoft Product Support Services and perform a title search for the words HTTP and 401. Open IIS Help, which is accessible in IIS Manager (inetmgr), and search for topics titled Authentication, Access Control, and About Custom Error Messages. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: 7.1.0 P7 Install problems
Hey Christopher, You have a Ph.D. and you work with Remedy? What gives? LOL, makes me believe that you do have to be a rocket scientist to be a Remedy Professional, as if I didn't know already. I am sure it is in the Computer Science field. I send a belated Congratulations for your accomplishment of such a prestigious title! If I need some real computer science help(working on another BS degree in Computer Science) I will give you a shout, ; ). Mike L From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of strauss Sent: Wednesday, August 26, 2009 2:22 PM To: arslist@ARSLIST.ORG Subject: Re: 7.1.0 P7 Install problems ** Can I assume that you are running the installer while logged in to the server with the same domain or local account (with sufficient permissions) that the Remedy AR System service is going to be running under?? I have always found that to be an essential step in successfully installing 7.x servers. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Rick Cook Sent: Wednesday, August 26, 2009 1:17 PM To: arslist@ARSLIST.ORG Subject: Re: 7.1.0 P7 Install problems ** I am just trying to install a brand new 7.1.0 patch 6 or 7 (I have tried both) on a Win2k3/SQL2k5 VM. 3 GB RAM and appropriate patches. Lyle's response shows how little data there is out there on this problem. The installer does create the DB, so DB authentication isn't the issue. The issue is that the Remedy AR System service simply will not start after the DB is created but before the forms and workflow are imported by the installer. This same set of conditions occurs no matter what we try during or after the installation. We get the service-specific error code 1064 error code when we try. I have looked up that error code everywhere I can, including the BMCDN. Some 7.5 users are reporting this on install, but I appear to be the first to encounter it on a 7.1.0 install. There doesn't seem to be an answer that anyone has found yet. I hate to admit it, but I am well and truly stumped. Since the same behaviors occur with two different patches and with multiple install options, it seems like an environmental issue, but I can see nothing wrong with the environment. We have a Webex with Support in about an hour - we'll see if they can find something no one has so far. I will, of course, share any solutions that work. Rick On Wed, Aug 26, 2009 at 11:01 AM, Michael Latham mlatha...@hotmail.com wrote: ** Hey Lyle, Actually he mentioned Error 1064 but maybe you made a typo, happens to the best of us : P. It is a general sql error that can occur in oracle, mssql server, or mysql. I am not quite sure but there is probably some type of database related authentication issue here. Would have to delve a little deeper into my notes for 7.* installs I have done over the past few years. Just so you know I recently did a successful install of patch 7 in VirtualPC environment. All ITSM apps, Atrium Core, and the related engines on MSSQL2005 and Win2003Server. Now I cannot get the service to start. So we are both looking at something similar here I suppose. The only difference I have service startup issue after completing a successful install. Well actually not complete cause I stopped the change management install due to lag on my box. I am sure I broke something. I am about to go fresh again and see what happens. I will keep you updated! Cheerios! Mike Latham - Some Remedy Developer Guy From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor Sent: Wednesday, August 26, 2009 1:48 PM To: arslist@ARSLIST.ORG Subject: Re: 7.1.0 P7 Install problems ** I just tried Googling Windows error 1604. Looks like it's a common MySQL error. Are you sure you're using SQL Server and not MySQL? ;-) Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Rick Cook Sent: Wednesday, August 26, 2009 11:26 AM To: arslist@ARSLIST.ORG Subject: Re: 7.1.0 P7 Install problems ** Just to eliminate that as a potential issue, we did bump up the RAM to 3 GB. Still the same problem. Windows error 1064. Rick On Wed, Aug 26, 2009 at 6:54 AM, Rick Cook remedyr...@gmail.com wrote: ** 2 GB. AR System should at least install with that, since there is nothing else but the OS running on the VM. The DB is remote. Agree? Rick _ From: copits.rich...@bwc.state.oh.us Date: Wed, 26 Aug 2009 07:41:40 -0400 To: arslist@ARSLIST.ORG Subject: Re: 7.1.0 P7 Install problems Check the amount of memory that you have allocated in your VM From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Rick Cook Sent: Tuesday, August 25
Re: mid tier error
It truly appears to be that your tomcat service isn't running. Go to Program Files/apache install directory/Tomcat directory/bin/ and run the startup.bat script. You can do this easily from the command line. You can use the script below to restart tomcat when needed. /SCRiPT START/ @echo off set wait=0 :check tasklist /fi windowtitle eq Tomcat /fo csv /nh 2 nul | find /i java.exe nul if %errorlevel% equ 1 goto start if %wait% equ 0 goto stop goto check :stop start Stop Tomcat /min cmd /c %CATALINA_HOME%/bin/shutdown.bat set wait=1 goto check :start set JPDA_ADDRESS=8001 set JPDA_TRANSPORT=dt_socket %CATALINA_HOME%/bin/catalina.bat jpda start /SCRiPT END/ -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Raj Sent: Wednesday, August 26, 2009 3:00 PM To: arslist@ARSLIST.ORG Subject: Re: mid tier error http://servername:8080/ getting page cannot be displayed. http://servername/ same original error. On Aug 26, 12:55 pm, Lyle Taylor tayl...@ldschurch.org wrote: Is that error coming from Tomcat or your browser? That's not a type of error I'd expect Tomcat to return. Silly question: are you sure the Tomcat service is started? You could verify that by going to http://servername:8080/ If you're using the default Tomcat install, you'll see a Tomcat welcome screen. If you get the same error, the service may not be started correctly. Lyle -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Raj Sent: Wednesday, August 26, 2009 12:49 PM To: arsl...@arslist.org Subject: Re: mid tier error http://servername:8080/arsys/home when i try this i am getting error like : OOPS THIS IS LINK APPEARS TO BE BROKEN when I tryhttp://webservername/arsys/shared/login.jsp?/arsys/home I get the same error as original error : You are not authorized to view this page .. On Aug 26, 12:42 pm, Lyle Taylor tayl...@ldschurch.org wrote: It almost looks like you may not have the ISAPI redirector configured properly (or at all). What happens if you go to http://servername:8080/arsys/home That will send it straight to Tomcat. Lyle -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Raj Sent: Wednesday, August 26, 2009 12:38 PM To: arsl...@arslist.org Subject: Re: mid tier error Thank you Michael . Yes, I am running tomcat on IIS. Also, the steps you mentioned, these were already completed. Still no success. Please note : I am using URLhttp://servername/arsys/home still getting the same error. On Aug 26, 12:10 pm, Michael Latham mlatha...@hotmail.com wrote: Sounds like you are accessing a page in a directory that does not have the proper permissions applied for the authenticated user that you logged in with. Like a user who has public access is trying to access a private directory. Directory permissions are always an annoyance when it comes to web apps. Give the whole URL and I can probably tell you what is going on. Are you using Tomcat per chance? Anyway try this: *Open IIS Manager by typing inetmgr in run dialog box *Right click on your web site directory and select properties *Go to the directory security tab and click on the edit button under the anonymous access and authentication section *Check the chekcbox to enable anonymous access or provide the correct account name and password Mike Latham - Some Remedy Developer Guy -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Raj Sent: Wednesday, August 26, 2009 1:58 PM To: arsl...@arslist.org Subject: mid tier error Hello All, I am getting the following error message when trying to access remedy through web. What could be the problem? Thanks, Raj You are not authorized to view this page You do not have permission to view this directory or page using the credentials that you supplied. --- - Please try the following: Contact the Web site administrator if you believe you should be able to view this directory or page. Click the Refresh button to try again with different credentials. HTTP Error 401.1 - Unauthorized: Access is denied due to invalid credentials. Internet Information Services (IIS) --- - Technical Information (for support personnel) Go to Microsoft Product Support Services and perform a title search for the words HTTP and 401. Open IIS Help, which is accessible in IIS Manager (inetmgr), and search for topics titled Authentication, Access Control, and About Custom Error Messages
