Mass changes in repository - def file format?
Hello everyone, maybe you have a good idea on how to accomplish this: We need to update around 600 character fields (scattered in an app with 250+ forms) with a menu pattern. My first guess was to export forms to a def file (without the pattern), create the pattern and attach is and export form and dependant menu to see what happens. I wanted to learn about the changes in order to do them in a batch script and perform an in-place re-import afterwards. When doing a diff though, there are things that are obvious and other that are not. Especially, what happens to display-instance is odd to me. I think it has to do with the menubutton that appears after setting the pattern, but I just can't tell. - Has anyone of you had any experience with performing mass changes this way? - Is this a reasonable way at all? I could not get hold of any documentation regarding the exact structure and content of the def file. - Is there any other thinkable way of manipulating the data model this massively? Regards, Peter ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Mass changes in repository - def file format?
Peter, I would think that using the API would be an easier approach. I will assume the v7.1 Java API is acceptable as a staring point. Here is a overview of what you would need to do: ) Login to the ARS server as an Admin ) Get List of Schemas Make sure you restrict the list to the correct Field ID of interest. ( You did use a best practice an have used the same Field ID for this field right?) ) Loop over the Schemas that are returned and do a Get Field for the field ID on that form. ) Alter the field with the setFieldLimit(FieldLimit limit) method. I think it would be something like this... // assuming field is a com.bmc.arsys.api.Field field.setFieldLimit(((com.bmc.arsys.api.CharacterFieldLimit)field.getFieldLimit()).setPattern($MENU$)); ) then do not forget to save the change to the field object: // assuming context is a com.bmc.arsys.api.ARServerUser context.setField(field); ) Logout. Now if your field ID's are not the same then it just complicates how you have to find your field objects. But the same ideas should apply. ( And I would hope that someone at BMC would be able to help you get that simple Java application together in a mater of an hour or two.) HTH. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On Mon, Jun 2, 2008 at 3:58 AM, Schroff, Peter [EMAIL PROTECTED] wrote: Hello everyone, maybe you have a good idea on how to accomplish this: We need to update around 600 character fields (scattered in an app with 250+ forms) with a menu pattern. My first guess was to export forms to a def file (without the pattern), create the pattern and attach is and export form and dependant menu to see what happens. I wanted to learn about the changes in order to do them in a batch script and perform an in-place re-import afterwards. When doing a diff though, there are things that are obvious and other that are not. Especially, what happens to display-instance is odd to me. I think it has to do with the menubutton that appears after setting the pattern, but I just can't tell. - Has anyone of you had any experience with performing mass changes this way? - Is this a reasonable way at all? I could not get hold of any documentation regarding the exact structure and content of the def file. - Is there any other thinkable way of manipulating the data model this massively? Regards, Peter ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
BelArc and BelManage Itegrations
Has anyone ever done an integration with these products? I know they are currently used by many DoD departments but I cannot find any information on integration with BMC products. Any assistance is much appreciated! Maria C Delagarza AR System Specialist eluridesigns.com | [EMAIL PROTECTED] ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Test - please ignore.
Test - please ignore. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
ARERROR.LOG Entries
Hi All, We have multiple entries in our arerror.log file similiar to the one below: Mon Jun 2 07:27:59 2008 390620 : Failure during an attempt to perform an appli cation command (ARERR 4554) Mon Jun 2 07:27:59 2008 Application-Delete-Entry SYS:Action 0003506 Does anyone know what this means and how do correct it? We are running ARS 7.1 patch 001 and IM 7.0.03 patch 004. Thanks, Mike -- View this message in context: http://www.nabble.com/ARERROR.LOG-Entries-tp17601274p17601274.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Admin tool anomaly with two monitors.
Hello Listers, ARS 6.3 Patch 014 ARS Admin tool 6.3 Patch 017 I came across a strange anomaly in the admin tool and I am not sure if it is a bug or just a HW driver issue. I have a Dell Laptop (D610) as my primary workstation with the admin tool loaded. I use a docking station to get access to a second monitor. It's also a Dell. The strangeness occurs when I move the Admin tool to the second monitor. If I have a Notify action in a filter I can not access the Messages or Templates pages for email notifications. All I have to do is slide the admin tool back to the primary monitor and I can select those pages. Of course now I have to remember to do that and not think that my filter is corrupted. I can access all of the top pages ( Basic, If Action , Else Action, etc) from either monitor. Just wondering if anyone saw this before or if it happens on other HW or versions. Thanks in advance, John J. Reiser Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Admin tool anomaly with two monitors.
I have just reproduced this in the 7.1p2 Admin tool. IBM desktop with nVidia graphics. Clicking the two tabs when admin is open on the secondary monitor does nothing. Interesting. -- Tony Worthington Sr. Technical Analyst Kohl's Department Stores [EMAIL PROTECTED] 262-703-5911 Reiser, John J [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 06/02/2008 08:30 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Admin tool anomaly with two monitors. Hello Listers, ARS 6.3 Patch 014 ARS Admin tool 6.3 Patch 017 I came across a strange anomaly in the admin tool and I am not sure if it is a bug or just a HW driver issue. I have a Dell Laptop (D610) as my primary workstation with the admin tool loaded. I use a docking station to get access to a second monitor. It's also a Dell. The strangeness occurs when I move the Admin tool to the second monitor. If I have a Notify action in a filter I can not access the Messages or Templates pages for email notifications. All I have to do is slide the admin tool back to the primary monitor and I can select those pages. Of course now I have to remember to do that and not think that my filter is corrupted. I can access all of the top pages ( Basic, If Action , Else Action, etc) from either monitor. Just wondering if anyone saw this before or if it happens on other HW or versions. Thanks in advance, John J. Reiser Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are 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 by authorized Kohl's Associates at any time without any further consent. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Admin tool anomaly with two monitors.
I've seen weirdness with some other applications as well when on the 2nd display. I think if the application works, great, but if it doesn't then you need to just move it back to primary. Personally, most applications work well enough that I don't think its that big a problem. Ben Cantatore Remedy Manager (914) 457-6209 Emerging Health IT 3 Odell Plaza Yonkers, New York 10701 [EMAIL PROTECTED] 06/02/08 6:30 AM Hello Listers, ARS 6.3 Patch 014 ARS Admin tool 6.3 Patch 017 I came across a strange anomaly in the admin tool and I am not sure if it is a bug or just a HW driver issue. I have a Dell Laptop (D610) as my primary workstation with the admin tool loaded. I use a docking station to get access to a second monitor. It's also a Dell. The strangeness occurs when I move the Admin tool to the second monitor. If I have a Notify action in a filter I can not access the Messages or Templates pages for email notifications. All I have to do is slide the admin tool back to the primary monitor and I can select those pages. Of course now I have to remember to do that and not think that my filter is corrupted. I can access all of the top pages ( Basic, If Action , Else Action, etc) from either monitor. Just wondering if anyone saw this before or if it happens on other HW or versions. Thanks in advance, John J. Reiser Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
RES: Archive old data
Hi Paul and Shyam, We want to do something like these with our AR System App... We have tables/forms with records since year 2003... We want the data accessible (searchable) to the Archive Form. Our Archive Form will have only records with 'Status' = $Closed$ We are searching for solutions and/or suggestions to export a high quantity o records at the first time. Any tips? Thanks! Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br https://webmail.cinq.com.br/exchweb/bin/redir.asp?URL=http://www.cinq.com.br/ [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq - Confiabilidade, Inovação e Qualidade em T.I. De: Action Request System discussion list(ARSList) em nome de Shyam Attavar Enviada: sáb 31/5/2008 02:10 Para: arslist@ARSLIST.ORG Assunto: Re: Archive old data Paul, It depends whether you want the data accessible (searchable) or not. One of the things we have seen being done is to export the data into ARX files and the associated form definitions also and archived them on tapes for posterity. Another thing you can certainly do is to export the underlying DB tables (T, H and possibly B) as is (especially if you are on Oracle) and archive them on to tape. Not sure if this is exactly what you are looking for. HTH, -- Shyam - Original Message - From: ARSsytem [EMAIL PROTECTED] Newsgroups: gmane.comp.crm.arsystem.general To: arslist@ARSLIST.ORG Sent: Friday, May 30, 2008 2:31 PM Subject: Archive old data Hi Listers, We are holding more than 7 years of data in our archive data forms (which are only regular forms, not archive forms). We would like to move part of them off line. Has anyone done that? Is there any white paper for the best practice. Thanks! Regards Paul ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Admin tool anomaly with two monitors.
I have the same issue on a DELL830 On Mon, Jun 2, 2008 at 9:30 AM, Reiser, John J [EMAIL PROTECTED] wrote: Hello Listers, ARS 6.3 Patch 014 ARS Admin tool 6.3 Patch 017 I came across a strange anomaly in the admin tool and I am not sure if it is a bug or just a HW driver issue. I have a Dell Laptop (D610) as my primary workstation with the admin tool loaded. I use a docking station to get access to a second monitor. It's also a Dell. The strangeness occurs when I move the Admin tool to the second monitor. If I have a Notify action in a filter I can not access the Messages or Templates pages for email notifications. All I have to do is slide the admin tool back to the primary monitor and I can select those pages. Of course now I have to remember to do that and not think that my filter is corrupted. I can access all of the top pages ( Basic, If Action , Else Action, etc) from either monitor. Just wondering if anyone saw this before or if it happens on other HW or versions. Thanks in advance, John J. Reiser Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Incorrect format for a diary field (ARERR 339)
Dear Listers, We are getting following Incorrect format for a diary field (ARERR 339) during the DSO operation. This happens with some of the records. Could you please suggest any idea why these errors are coming? A part of log (arerror.log) copied below. Mon Jun 2 05:37:08 2008 Distrib : Incorrect format for a diary field (ARERR 339) Mon Jun 2 05:37:08 2008 Distrib : Pending distributed operation for this entry canceled due to error (ARDSNOTE 3003) Mon Jun 2 05:37:08 2008 1-1518488 - CTS:AssistanceRequest Mon Jun 2 05:59:19 2008 Distrib : Incorrect format for a diary field (ARERR 339) Mon Jun 2 05:59:19 2008 Distrib : Pending distributed operation for this entry canceled due to error (ARDSNOTE 3003) Mon Jun 2 05:59:19 2008 1-1518488 - CTS:AssistanceRequest Mon Jun 2 06:39:41 2008 Distrib : Incorrect format for a diary field (ARERR 339) Mon Jun 2 06:39:41 2008 Distrib : Pending distributed operation for this entry canceled due to error (ARDSNOTE 3003) Mon Jun 2 06:39:41 2008 1-1518488 - CTS:AssistanceRequest Mon Jun 2 06:47:46 2008 Distrib : Incorrect format for a diary field (ARERR 339) Mon Jun 2 06:47:46 2008 Distrib : Pending distributed operation for this entry canceled due to error (ARDSNOTE 3003) Mon Jun 2 06:47:46 2008 1-1518488 - CTS:AssistanceRequest Regards, Siraj P M ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Admin tool anomaly with two monitors.
ARS 6.3 patch 24 Admin 6.3 patch 24 Dell Optiplex GX260 I AM able to access notification and Templete on both monitors. Primary monitor is Dell Ultrasharp and secondary is an old Optiquest. Using 2 video cards vs 1 video with dual output. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Reiser, John J Sent: Monday, June 02, 2008 9:30 AM To: arslist@ARSLIST.ORG Subject: Admin tool anomaly with two monitors. Hello Listers, ARS 6.3 Patch 014 ARS Admin tool 6.3 Patch 017 I came across a strange anomaly in the admin tool and I am not sure if it is a bug or just a HW driver issue. I have a Dell Laptop (D610) as my primary workstation with the admin tool loaded. I use a docking station to get access to a second monitor. It's also a Dell. The strangeness occurs when I move the Admin tool to the second monitor. If I have a Notify action in a filter I can not access the Messages or Templates pages for email notifications. All I have to do is slide the admin tool back to the primary monitor and I can select those pages. Of course now I have to remember to do that and not think that my filter is corrupted. I can access all of the top pages ( Basic, If Action , Else Action, etc) from either monitor. Just wondering if anyone saw this before or if it happens on other HW or versions. Thanks in advance, John J. Reiser Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Admin tool anomaly with two monitors.
Thanks for all of the replies. Melvin, Maybe that is the answer. The extended desktop of my laptop is driven from the video output. And Ben, It can be a problem when you think you have a corrupt piece of workflow because everything else works. Now that I know about this I keep my admin tool on the Laptop screen. Thank again, John J. Reiser Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Cox, Melvin E. Sent: Monday, June 02, 2008 9:55 AM To: arslist@ARSLIST.ORG Subject: Re: Admin tool anomaly with two monitors. ARS 6.3 patch 24 Admin 6.3 patch 24 Dell Optiplex GX260 I AM able to access notification and Templete on both monitors. Primary monitor is Dell Ultrasharp and secondary is an old Optiquest. Using 2 video cards vs 1 video with dual output. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Reiser, John J Sent: Monday, June 02, 2008 9:30 AM To: arslist@ARSLIST.ORG Subject: Admin tool anomaly with two monitors. Hello Listers, ARS 6.3 Patch 014 ARS Admin tool 6.3 Patch 017 I came across a strange anomaly in the admin tool and I am not sure if it is a bug or just a HW driver issue. I have a Dell Laptop (D610) as my primary workstation with the admin tool loaded. I use a docking station to get access to a second monitor. It's also a Dell. The strangeness occurs when I move the Admin tool to the second monitor. If I have a Notify action in a filter I can not access the Messages or Templates pages for email notifications. All I have to do is slide the admin tool back to the primary monitor and I can select those pages. Of course now I have to remember to do that and not think that my filter is corrupted. I can access all of the top pages ( Basic, If Action , Else Action, etc) from either monitor. Just wondering if anyone saw this before or if it happens on other HW or versions. Thanks in advance, John J. Reiser Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Admin tool anomaly with two monitors.
John, I can appreciate that, I was going nuts with my crystal reports because it kept unexpectedly crashing till I figured out it was the fact it was on the 2nd display. Ben Cantatore Remedy Manager (914) 457-6209 Emerging Health IT 3 Odell Plaza Yonkers, New York 10701 [EMAIL PROTECTED] 06/02/08 7:02 AM Thanks for all of the replies. Melvin, Maybe that is the answer. The extended desktop of my laptop is driven from the video output. And Ben, It can be a problem when you think you have a corrupt piece of workflow because everything else works. Now that I know about this I keep my admin tool on the Laptop screen. Thank again, John J. Reiser Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Cox, Melvin E. Sent: Monday, June 02, 2008 9:55 AM To: arslist@ARSLIST.ORG Subject: Re: Admin tool anomaly with two monitors. ARS 6.3 patch 24 Admin 6.3 patch 24 Dell Optiplex GX260 I AM able to access notification and Templete on both monitors. Primary monitor is Dell Ultrasharp and secondary is an old Optiquest. Using 2 video cards vs 1 video with dual output. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Reiser, John J Sent: Monday, June 02, 2008 9:30 AM To: arslist@ARSLIST.ORG Subject: Admin tool anomaly with two monitors. Hello Listers, ARS 6.3 Patch 014 ARS Admin tool 6.3 Patch 017 I came across a strange anomaly in the admin tool and I am not sure if it is a bug or just a HW driver issue. I have a Dell Laptop (D610) as my primary workstation with the admin tool loaded. I use a docking station to get access to a second monitor. It's also a Dell. The strangeness occurs when I move the Admin tool to the second monitor. If I have a Notify action in a filter I can not access the Messages or Templates pages for email notifications. All I have to do is slide the admin tool back to the primary monitor and I can select those pages. Of course now I have to remember to do that and not think that my filter is corrupted. I can access all of the top pages ( Basic, If Action , Else Action, etc) from either monitor. Just wondering if anyone saw this before or if it happens on other HW or versions. Thanks in advance, John J. Reiser Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Archive old data
We selected a smaller time frame for the first time we turned on archiving. Just to see how long, how much impact it would have. So for the first pass, you might set the archive for to: Status = Closed AND 'status.history.time.closed' 01/01/2004 How many records? How long did it take? Then you can decide if you should continue to do them incrementally or go ahead an do all of the rest at once. Mark -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tadeu Augusto Dutra Pinto Sent: Monday, June 02, 2008 8:46 AM To: arslist@ARSLIST.ORG Subject: RES: Archive old data Hi Paul and Shyam, We want to do something like these with our AR System App... We have tables/forms with records since year 2003... We want the data accessible (searchable) to the Archive Form. Our Archive Form will have only records with 'Status' = $Closed$ We are searching for solutions and/or suggestions to export a high quantity o records at the first time. Any tips? Thanks! Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br https://webmail.cinq.com.br/exchweb/bin/redir.asp?URL=http://www.cinq.com.br/ [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq - Confiabilidade, Inovação e Qualidade em T.I. De: Action Request System discussion list(ARSList) em nome de Shyam Attavar Enviada: sáb 31/5/2008 02:10 Para: arslist@ARSLIST.ORG Assunto: Re: Archive old data Paul, It depends whether you want the data accessible (searchable) or not. One of the things we have seen being done is to export the data into ARX files and the associated form definitions also and archived them on tapes for posterity. Another thing you can certainly do is to export the underlying DB tables (T, H and possibly B) as is (especially if you are on Oracle) and archive them on to tape. Not sure if this is exactly what you are looking for. HTH, -- Shyam - Original Message - From: ARSsytem [EMAIL PROTECTED] Newsgroups: gmane.comp.crm.arsystem.general To: arslist@ARSLIST.ORG Sent: Friday, May 30, 2008 2:31 PM Subject: Archive old data Hi Listers, We are holding more than 7 years of data in our archive data forms (which are only regular forms, not archive forms). We would like to move part of them off line. Has anyone done that? Is there any white paper for the best practice. Thanks! Regards Paul ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: ARERROR.LOG Entries
An Active Link, Filter, or Escalation tried to run Application-Delete-Entry (Run Process or Set Fields with $PROCESS$). The process deletes a record from the database - form SYS:Action, Request ID 3506 in this case. 'Can't really determine the specific cause with only this info. It's possible that the record didn't exist, or that there's other workflow that prevents record delete. I'd start by identifying the workflow object that failed. Then figure out the why - did it run multiple times for the same record? If it was an Active Link or Filter, what was the user action? Mike White Office: 813-978-2192 E-mail: [EMAIL PROTECTED] versicle [EMAIL PROTECTED]To: arslist@ARSLIST.ORG cc: Sent by: Action Subject: ARERROR.LOG Entries Request System discussion list(ARSList) [EMAIL PROTECTED] ORG 06/02/2008 09:24 Please respond to arslist Hi All, We have multiple entries in our arerror.log file similiar to the one below: Mon Jun 2 07:27:59 2008 390620 : Failure during an attempt to perform an appli cation command (ARERR 4554) Mon Jun 2 07:27:59 2008 Application-Delete-Entry SYS:Action 0003506 Does anyone know what this means and how do correct it? We are running ARS 7.1 patch 001 and IM 7.0.03 patch 004. Thanks, Mike -- View this message in context: http://www.nabble.com/ARERROR.LOG-Entries-tp17601274p17601274.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are inline: graycol.gifinline: ecblank.gifinline: pic06146.gif
Re: ARERROR.LOG Entries
Basically some workflow is running application-delete-entry to delete rows in Sys:Action form .In this particular case Request ID 0003506. There should be more specific error message as well. Can you please forward that as well. Thanks Manjinder On Mon, Jun 2, 2008 at 9:24 AM, versicle [EMAIL PROTECTED] wrote: Hi All, We have multiple entries in our arerror.log file similiar to the one below: Mon Jun 2 07:27:59 2008 390620 : Failure during an attempt to perform an appli cation command (ARERR 4554) Mon Jun 2 07:27:59 2008 Application-Delete-Entry SYS:Action 0003506 Does anyone know what this means and how do correct it? We are running ARS 7.1 patch 001 and IM 7.0.03 patch 004. Thanks, Mike -- View this message in context: http://www.nabble.com/ARERROR.LOG-Entries-tp17601274p17601274.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are -- Manjinder Singh ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Admin tool anomaly with two monitors.
Hello Listers, Well I sort of resolved the issue. Or at least I can if I choose to. It seems that the Admin tool does not like it when the Primary screen is to the right of the secondary. If I swap the monitors and settings so my laptop is on the left the admin toll works fine in both windows. Sadly I don't have the room to keep it configured this way and permanently swapping the primary screen seems to confuse the poor laptop when it gets undocked. ( No task bar since it is the secondary monitor.) Oh well the next desk I get may be on the other side of the cube and then I will be able to position the laptop and monitor accordingly. Thanks, John J. Reiser Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Benedetto Cantatore Sent: Monday, June 02, 2008 10:12 AM To: arslist@ARSLIST.ORG Subject: Re: Admin tool anomaly with two monitors. ** John, I can appreciate that, I was going nuts with my crystal reports because it kept unexpectedly crashing till I figured out it was the fact it was on the 2nd display. Ben Cantatore Remedy Manager (914) 457-6209 Emerging Health IT 3 Odell Plaza Yonkers, New York 10701 [EMAIL PROTECTED] 06/02/08 7:02 AM Thanks for all of the replies. Melvin, Maybe that is the answer. The extended desktop of my laptop is driven from the video output. And Ben, It can be a problem when you think you have a corrupt piece of workflow because everything else works. Now that I know about this I keep my admin tool on the Laptop screen. Thank again, John J. Reiser Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Cox, Melvin E. Sent: Monday, June 02, 2008 9:55 AM To: arslist@ARSLIST.ORG Subject: Re: Admin tool anomaly with two monitors. ARS 6.3 patch 24 Admin 6.3 patch 24 Dell Optiplex GX260 I AM able to access notification and Templete on both monitors. Primary monitor is Dell Ultrasharp and secondary is an old Optiquest. Using 2 video cards vs 1 video with dual output. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Reiser, John J Sent: Monday, June 02, 2008 9:30 AM To: arslist@ARSLIST.ORG Subject: Admin tool anomaly with two monitors. Hello Listers, ARS 6.3 Patch 014 ARS Admin tool 6.3 Patch 017 I came across a strange anomaly in the admin tool and I am not sure if it is a bug or just a HW driver issue. I have a Dell Laptop (D610) as my primary workstation with the admin tool loaded. I use a docking station to get access to a second monitor. It's also a Dell. The strangeness occurs when I move the Admin tool to the second monitor. If I have a Notify action in a filter I can not access the Messages or Templates pages for email notifications. All I have to do is slide the admin tool back to the primary monitor and I can select those pages. Of course now I have to remember to do that and not think that my filter is corrupted. I can access all of the top pages ( Basic, If Action , Else Action, etc) from either monitor. Just wondering if anyone saw this before or if it happens on other HW or versions. Thanks in advance, John J. Reiser Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
SQL Stored procedures
ARS 7.0.1, SQL 2000 Let me start out by saying that as a SQL dba, I am quite the novice! I have written a simple stored procedure that does a Full Text Search against a SQL database that is NOT the Remedy database. This database is on a seperate server. The procedure lives on that seperate server in the target database (amcaslocal). Here is my issue. If I send the command: EXEC [baker].[amcaslocal].[dbo].[AA_Disadvantaged_WordSearch_01] @lineup_input_appl_id = 160240 From the query analyzer logged into my local (remedy) sql database. I get an answer! If however I send that same command in a set fields from either a filter or an Active link, the process times out and the whole thing dies Incidently, when I developed this process, the database I was searching on was on the local server. I have set up a linked server on the local box to connect to the remote. Any input would be most welcome! The procedure is as follows: SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS OFF GO /* Stored procedure used to find instances of special needs OR disadvantaged words. */ CREATE PROC AA_Disadvantaged_WordSearch_01 (@lineup_input_appl_id int) --SOMID AS DECLARE @ANSWER INT SELECT APPL_PERSON_ID, ESSAY INTO #ESSAY_TBL FROM DBO.ESSAY WHERE APPL_PERSON_ID = @lineup_input_appl_id AND CONTAINS(ESSAY, 'AMERICORP OR BATTERED OR GATES SCHOLAR OR GENOCIDE OR HABITAT OR HANDICAPPED OR HRSA OR IMMIGRANT OR NHSSSRAP OR PEACE CORPS OR PIPELINE OR POVERTY OR REFUGEE OR RESERVATION OR SHELTER OR SMDEP OR SOCIAL JUSTICE OR TRIBAL OR UDOC') -- SELECT APPL_PERSON_ID AS ESSAY_APPL_PERSON_ID -- FROM #ESSAY_TBL IF (SELECT COUNT (*) FROM #ESSAY_TBL) 0 BEGIN DROP TABLE #ESSAY_TBL SET @ANSWER = 1 -- SELECT @ANSWER AS iFeSSAYaNSWER GOTO finishline END ELSE BEGIN DROP TABLE #ESSAY_TBL SET @ANSWER = 0 -- SELECT @ANSWER AS eLSEeSSAYaNSWER SELECT APPL_PERSON_ID, ORG_NAME, EXP_TITLE, EXP_DESC, EXP_NAME INTO #EXPERIENCE_TBL FROM DBO.EXPERIENCE WHERE APPL_PERSON_ID = @lineup_input_appl_id AND ((CONTAINS(ORG_NAME, 'AMERICORP OR BATTERED OR GATES SCHOLAR OR GENOCIDE OR HABITAT OR HANDICAPPED OR HRSA OR IMMIGRANT OR NHSSSRAP OR PEACE CORPS OR PIPELINE OR POVERTY OR REFUGEE OR RESERVATION OR SHELTER OR SMDEP OR SOCIAL JUSTICE OR TRIBAL OR UDOC')) OR (CONTAINS(EXP_TITLE, 'AMERICORP OR BATTERED OR GATES SCHOLAR OR GENOCIDE OR HABITAT OR HANDICAPPED OR HRSA OR IMMIGRANT OR NHSSSRAP OR PEACE CORPS OR PIPELINE OR POVERTY OR REFUGEE OR RESERVATION OR SHELTER OR SMDEP OR SOCIAL JUSTICE OR TRIBAL OR UDOC')) OR (CONTAINS(EXP_DESC, 'AMERICORP OR BATTERED OR GATES SCHOLAR OR GENOCIDE OR HABITAT OR HANDICAPPED OR HRSA OR IMMIGRANT OR NHSSSRAP OR PEACE CORPS OR PIPELINE OR POVERTY OR REFUGEE OR RESERVATION OR SHELTER OR SMDEP OR SOCIAL JUSTICE OR TRIBAL OR UDOC')) OR (CONTAINS(EXP_NAME, 'AMERICORP OR BATTERED OR GATES SCHOLAR OR GENOCIDE OR HABITAT OR HANDICAPPED OR HRSA OR IMMIGRANT OR NHSSSRAP OR PEACE CORPS OR PIPELINE OR POVERTY OR REFUGEE OR RESERVATION OR SHELTER OR SMDEP OR SOCIAL JUSTICE OR TRIBAL OR UDOC'))) END -- SELECT APPL_PERSON_ID AS EXPERIENCE_APPL_PERSON_ID -- FROM #EXPERIENCE_TBL IF(SELECT COUNT (*) FROM #EXPERIENCE_TBL) 0 BEGIN DROP TABLE #EXPERIENCE_TBL SET @ANSWER = 1 -- SELECT @ANSWER AS EXPERIENCE_IF_ANSWER GOTO finishline END ELSE BEGIN DROP TABLE #EXPERIENCE_TBL SET @ANSWER = 0 -- SELECT @ANSWER AS EXPERIENCE_ELSE_ANSWER END finishline: SELECT @ANSWER AS ANSWER GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO -- Warren R. Baltimore II Remedy Developer UW Medicine IT Services School of Medicine University of Washington Box 358220 1325 Fourth Ave, Suite 2000 Seattle, WA 98101 The opinions expressed in this e-mail are in no way those of the University of Washington, or the State of Washington. They are my own. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Issue installing itsm patch 7
Good morning all, Has anyone seen the error Unable to build patch summary when runing itsm 7 patch 7? And if so any ideas on what could be going on? The apps are at 7.0.3 patch 6. Thanks, -- Howard Richter ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Issue installing itsm patch 7
Is this one of those patches that is trying to validate its prereqs and such before actually installing anything? I know that is a promised 7.5 function, and that they've been working in that direction even in 7.x, but I don't know if they're there yet. Rick On Mon, Jun 2, 2008 at 9:11 AM, Rune Sorlid [EMAIL PROTECTED] wrote: ** Got the same errormessage, only on VMWare Machines /Rune Sorlid 2008/6/2 Howard Richter [EMAIL PROTECTED]: ** Good morning all, Has anyone seen the error Unable to build patch summary when runing itsm 7 patch 7? And if so any ideas on what could be going on? The apps are at 7.0.3 patch 6. Thanks, -- Howard Richter __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Issue installing itsm patch 7
Ouch, so it looks like that system will need to stay at patch 6, unless someone has found a workaround. Thanks for the info, Howard On 6/2/08, Rick Cook [EMAIL PROTECTED] wrote: ** Is this one of those patches that is trying to validate its prereqs and such before actually installing anything? I know that is a promised 7.5 function, and that they've been working in that direction even in 7.x, but I don't know if they're there yet. Rick On Mon, Jun 2, 2008 at 9:11 AM, Rune Sorlid [EMAIL PROTECTED] wrote: ** Got the same errormessage, only on VMWare Machines /Rune Sorlid 2008/6/2 Howard Richter [EMAIL PROTECTED]: ** Good morning all, Has anyone seen the error Unable to build patch summary when runing itsm 7 patch 7? And if so any ideas on what could be going on? The apps are at 7.0.3 patch 6. Thanks, -- Howard Richter __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ -- Howard Richter Red Hat Certified Technician CompTIA Linux+ Certified ITIL Foundation Certified E-Mail = [EMAIL PROTECTED] Resume = http://www.richter-home.net/resume/ LinkedIn Profile = http://www.linkedin.com/in/hbr4270 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: ARERROR.LOG Entries
The only other error I see is: 390603 : Name parameter (or name field in parameter) is empty : 300427600 (ARERR 102) I've also done a search for AL and Escalations that access that form and there are no AL and just one Escalation which I don't think is causing this b/c its set to run every minute and the error doesn't happen that often. However, there are quite a few filters which touch this form. I guess I have to see which one is causing the error. Michael Ziniti DCO - ITAM San Francisco Direct: 925-974-5273 Cell: 516-729-8150 AIM: MikePZiniti From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Manjinder Singh Sent: Monday, June 02, 2008 8:23 AM To: arslist@ARSLIST.ORG Subject: Re: ARERROR.LOG Entries ** Basically some workflow is running application-delete-entry to delete rows in Sys:Action form .In this particular case Request ID 0003506. There should be more specific error message as well. Can you please forward that as well. Thanks Manjinder On Mon, Jun 2, 2008 at 9:24 AM, versicle [EMAIL PROTECTED] wrote: Hi All, We have multiple entries in our arerror.log file similiar to the one below: Mon Jun 2 07:27:59 2008 390620 : Failure during an attempt to perform an appli cation command (ARERR 4554) Mon Jun 2 07:27:59 2008 Application-Delete-Entry SYS:Action 0003506 Does anyone know what this means and how do correct it? We are running ARS 7.1 patch 001 and IM 7.0.03 patch 004. Thanks, Mike -- View this message in context: http://www.nabble.com/ARERROR.LOG-Entries-tp17601274p17601274.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are -- Manjinder Singh __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the email by you is prohibited. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Issue installing itsm patch 7
Got the same errormessage, only on VMWare Machines /Rune Sorlid 2008/6/2 Howard Richter [EMAIL PROTECTED]: ** Good morning all, Has anyone seen the error Unable to build patch summary when runing itsm 7 patch 7? And if so any ideas on what could be going on? The apps are at 7.0.3 patch 6. Thanks, -- Howard Richter __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: SQL Stored procedures
Warren, Did you check your Process Timeout parameter in Server Information? You can increase it's value if required. Regards, Tarun From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Warren Baltimore Sent: Monday, June 02, 2008 9:38 PM To: arslist@ARSLIST.ORG Subject: SQL Stored procedures ** ARS 7.0.1, SQL 2000 Let me start out by saying that as a SQL dba, I am quite the novice! I have written a simple stored procedure that does a Full Text Search against a SQL database that is NOT the Remedy database. This database is on a seperate server. The procedure lives on that seperate server in the target database (amcaslocal). Here is my issue. If I send the command: EXEC [baker].[amcaslocal].[dbo].[AA_Disadvantaged_WordSearch_01] @lineup_input_appl_id = 160240 From the query analyzer logged into my local (remedy) sql database. I get an answer! If however I send that same command in a set fields from either a filter or an Active link, the process times out and the whole thing dies Incidently, when I developed this process, the database I was searching on was on the local server. I have set up a linked server on the local box to connect to the remote. Any input would be most welcome! The procedure is as follows: SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS OFF GO /* Stored procedure used to find instances of special needs OR disadvantaged words. */ CREATE PROC AA_Disadvantaged_WordSearch_01 (@lineup_input_appl_id int) --SOMID AS DECLARE @ANSWER INT SELECT APPL_PERSON_ID, ESSAY INTO #ESSAY_TBL FROM DBO.ESSAY WHERE APPL_PERSON_ID = @lineup_input_appl_id AND CONTAINS(ESSAY, 'AMERICORP OR BATTERED OR GATES SCHOLAR OR GENOCIDE OR HABITAT OR HANDICAPPED OR HRSA OR IMMIGRANT OR NHSSSRAP OR PEACE CORPS OR PIPELINE OR POVERTY OR REFUGEE OR RESERVATION OR SHELTER OR SMDEP OR SOCIAL JUSTICE OR TRIBAL OR UDOC') -- SELECT APPL_PERSON_ID AS ESSAY_APPL_PERSON_ID -- FROM #ESSAY_TBL IF (SELECT COUNT (*) FROM #ESSAY_TBL) 0 BEGIN DROP TABLE #ESSAY_TBL SET @ANSWER = 1 -- SELECT @ANSWER AS iFeSSAYaNSWER GOTO finishline END ELSE BEGIN DROP TABLE #ESSAY_TBL SET @ANSWER = 0 -- SELECT @ANSWER AS eLSEeSSAYaNSWER SELECT APPL_PERSON_ID, ORG_NAME, EXP_TITLE, EXP_DESC, EXP_NAME INTO #EXPERIENCE_TBL FROM DBO.EXPERIENCE WHERE APPL_PERSON_ID = @lineup_input_appl_id AND ((CONTAINS(ORG_NAME, 'AMERICORP OR BATTERED OR GATES SCHOLAR OR GENOCIDE OR HABITAT OR HANDICAPPED OR HRSA OR IMMIGRANT OR NHSSSRAP OR PEACE CORPS OR PIPELINE OR POVERTY OR REFUGEE OR RESERVATION OR SHELTER OR SMDEP OR SOCIAL JUSTICE OR TRIBAL OR UDOC')) OR (CONTAINS(EXP_TITLE, 'AMERICORP OR BATTERED OR GATES SCHOLAR OR GENOCIDE OR HABITAT OR HANDICAPPED OR HRSA OR IMMIGRANT OR NHSSSRAP OR PEACE CORPS OR PIPELINE OR POVERTY OR REFUGEE OR RESERVATION OR SHELTER OR SMDEP OR SOCIAL JUSTICE OR TRIBAL OR UDOC')) OR (CONTAINS(EXP_DESC, 'AMERICORP OR BATTERED OR GATES SCHOLAR OR GENOCIDE OR HABITAT OR HANDICAPPED OR HRSA OR IMMIGRANT OR NHSSSRAP OR PEACE CORPS OR PIPELINE OR POVERTY OR REFUGEE OR RESERVATION OR SHELTER OR SMDEP OR SOCIAL JUSTICE OR TRIBAL OR UDOC')) OR (CONTAINS(EXP_NAME, 'AMERICORP OR BATTERED OR GATES SCHOLAR OR GENOCIDE OR HABITAT OR HANDICAPPED OR HRSA OR IMMIGRANT OR NHSSSRAP OR PEACE CORPS OR PIPELINE OR POVERTY OR REFUGEE OR RESERVATION OR SHELTER OR SMDEP OR SOCIAL JUSTICE OR TRIBAL OR UDOC'))) END -- SELECT APPL_PERSON_ID AS EXPERIENCE_APPL_PERSON_ID -- FROM #EXPERIENCE_TBL IF(SELECT COUNT (*) FROM #EXPERIENCE_TBL) 0 BEGIN DROP TABLE #EXPERIENCE_TBL SET @ANSWER = 1 -- SELECT @ANSWER AS EXPERIENCE_IF_ANSWER GOTO finishline END ELSE BEGIN DROP TABLE #EXPERIENCE_TBL SET @ANSWER = 0 -- SELECT @ANSWER AS EXPERIENCE_ELSE_ANSWER END finishline: SELECT @ANSWER AS ANSWER GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO -- Warren R. Baltimore II Remedy Developer UW Medicine IT Services School of Medicine University of Washington Box 358220 1325 Fourth Ave, Suite 2000 Seattle, WA 98101 The opinions expressed in this e-mail are in no way those of the University of Washington, or the State of Washington. They are my own. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Mass changes in repository - def file format?
Peter, The error messages that are displayed when a pattern doesn't match notoriously suck. You might consider creating a filter(s) to do your pattern checks, and then display a more user friendly error message. If, as Matt suggested, your field IDs are the same across all the forms, then you can share that filter(s) with the pertinent forms. Thad Esser Remedy Developer Argue for your limitations, and sure enough, they're yours.-- Richard Bach Schroff, Peter [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 06/02/2008 12:58 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Mass changes in repository - def file format? Hello everyone, maybe you have a good idea on how to accomplish this: We need to update around 600 character fields (scattered in an app with 250+ forms) with a menu pattern. My first guess was to export forms to a def file (without the pattern), create the pattern and attach is and export form and dependant menu to see what happens. I wanted to learn about the changes in order to do them in a batch script and perform an in-place re-import afterwards. When doing a diff though, there are things that are obvious and other that are not. Especially, what happens to display-instance is odd to me. I think it has to do with the menubutton that appears after setting the pattern, but I just can't tell. - Has anyone of you had any experience with performing mass changes this way? - Is this a reasonable way at all? I could not get hold of any documentation regarding the exact structure and content of the def file. - Is there any other thinkable way of manipulating the data model this massively? Regards, Peter ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ***IMPORTANT NOTICE: This communication, including any attachment, contains information that may be confidential or privileged, and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message is strictly prohibited. Nothing in this email, including any attachment, is intended to be a legally binding signature.*** ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: SQL Stored procedures
EXEC [baker].[amcaslocal].[dbo].[AA_Disadvantaged_WordSearch_01] @lineup_input_appl_id = $APPL_PERSON_ID$ I'm using the same syntax in all of my other procedure calls. The difference here being this is the only one that exists on a remote server. I've tested the syntax in query analyzer. I'm not sure what else it could be (syntax wise). Thanks for the help! Warren On 6/2/08, Dave Saville [EMAIL PROTECTED] wrote: Warren Are you sure you have the correct invocation syntax in Remedy? ISTR it is a bit picky. -- Regards Dave Saville ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are -- Warren R. Baltimore II Remedy Developer UW Medicine IT Services School of Medicine University of Washington Box 358220 1325 Fourth Ave, Suite 2000 Seattle, WA 98101 The opinions expressed in this e-mail are in no way those of the University of Washington, or the State of Washington. They are my own. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Crystal Reports Server XI for Web Reporting
We have installed a Crystal Reports Server XI with a 60 trial license and have followed all the installation/configuration procedures per the Remedy Mid Tier 7.0.01 install guide for Web Reporting but when we try to view a report from the MT we receive error below. I found one article on the BO support site that has you check to see if the key code used is configured for Concurrent users or for Named User. But it instructs you to go into the CMC which does not look like it was installed with CRS. Failed to process the request!! All of your system's 0 Concurrent Access Licenses are in use at this time or your system's license key has expired. Try again later or contact your administrator to obtain additional licenses. com.crystaldecisions.sdk.occa.report.lib.ReportSDKEnterpriseLogonException: All of your system's 0 Concurrent Access Licenses are in use at this time or your system's license key has expired. Try again later or contact your administrator to obtain additional licenses. Error code:-2147217397 Error code name:enterpriseLogonFailed Michael Bardsley ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Filter Guide Question
Hi All, I have a situation where the email addresses from the customer contact list is populated in the ticket and on open, update, close a notify filter is used to send an email to each contact. These contact lists have grown quite large. I started noticing email errors where the list was getting chopped at 255 characters. The field in the ticket is large enough and so is the To field in the AR System Email Messages form. On further investigation found that the User Name in the Notify has a 255 limit. So that is the bottleneck. Is there a way to sent up a filter guide, that walks through the list of email addresses (they are separated by a semi-colon), sending out individual emails rather than the one big blast currently used? ARS 6.3 patch 20 SunOS 5.9 Oracle 9.2 Thanks Mark Mark Brittain Remedy Developer NaviSite ESM Operations [EMAIL PROTECTED] This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: SQL Stored procedures
Warren Are you sure you have the correct invocation syntax in Remedy? ISTR it is a bit picky. -- Regards Dave Saville ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Crystal Reports Server XI for Web Reporting
My experience with Crystal Report Server XI was that you would be unable to access the CMC web interface if you tried to install Crystal to use the tomcat instance installed by mid-tier. If it is installed with its own tomcat, or on IIS using .NET, the CMC web interface is accessible for applying the license. Make sure that the mid-tier is configured with the CMS Machine Connection Details for BOXI authentication, NOT Crystal Report Server XI. That should allow you to connect the way mid-tier wants to - using un-named user accounts - versus the default for CRS XI which is named accounts. BO changed the default license behavior in XI to the opposite of what previous versions used, and what mid-tier expects. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Bardsley, Michael Sent: Monday, June 02, 2008 11:36 AM To: arslist@ARSLIST.ORG Subject: Crystal Reports Server XI for Web Reporting ** We have installed a Crystal Reports Server XI with a 60 trial license and have followed all the installation/configuration procedures per the Remedy Mid Tier 7.0.01 install guide for Web Reporting but when we try to view a report from the MT we receive error below. I found one article on the BO support site that has you check to see if the key code used is configured for Concurrent users or for Named User. But it instructs you to go into the CMC which does not look like it was installed with CRS. Failed to process the request!! All of your system's 0 Concurrent Access Licenses are in use at this time or your system's license key has expired. Try again later or contact your administrator to obtain additional licenses. com.crystaldecisions.sdk.occa.report.lib.ReportSDKEnterpriseLogonExcepti on: All of your system's 0 Concurrent Access Licenses are in use at this time or your system's license key has expired. Try again later or contact your administrator to obtain additional licenses. Error code:-2147217397 Error code name:enterpriseLogonFailed Michael Bardsley __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: SQL Stored procedures
James, Good suggestion, but when I use ARAdmin when I login to the query analyzer just so I can avoid that very issue. I've confirmed accounts on both servers ARAdmin is there... Thanks for the idea though! Warren On 6/2/08, James Van Sickle [EMAIL PROTECTED] wrote: Warren Have you checked to confirm that the Database user, typically ARAdmin, that the Remedy servers uses has access to this remote database? Your SP is most likely working in Query Analyzer because your personal login you are using has access to the DB. When you attempt to run it in Remedy, the system uses the user ARAdmin, which may not have the required access. (Embedded image moved to file: pic17589.gif)Countrywide James Van Sickle Remedy Developer II Enterprise Service Management 972-696-5779 Office 1000 Coit Road 92-540-5779Mail Stop: PCRD-2-19 Internal Plano, TX 75075 Warren Baltimore warrenbaltimore@ GMAIL.COM To Sent by: Action arslist@ARSLIST.ORG Request System cc discussion list(ARSList)Subject [EMAIL PROTECTED] [ARSLIST] SQL Stored procedures ORG 06/02/2008 11:08 AM Please respond to [EMAIL PROTECTED] RG ** ARS 7.0.1, SQL 2000 Let me start out by saying that as a SQL dba, I am quite the novice! I have written a simple stored procedure that does a Full Text Search against a SQL database that is NOT the Remedy database. This database is on a seperate server. The procedure lives on that seperate server in the target database (amcaslocal). Here is my issue. If I send the command: EXEC [baker].[amcaslocal].[dbo].[AA_Disadvantaged_WordSearch_01] @lineup_input_appl_id = 160240 From the query analyzer logged into my local (remedy) sql database. I get an answer! If however I send that same command in a set fields from either a filter or an Active link, the process times out and the whole thing dies Incidently, when I developed this process, the database I was searching on was on the local server. I have set up a linked server on the local box to connect to the remote. Any input would be most welcome! The procedure is as follows: SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS OFF GO /* Stored procedure used to find instances of special needs OR disadvantaged words. */ CREATE PROC AA_Disadvantaged_WordSearch_01 (@lineup_input_appl_id int) --SOMID AS DECLARE @ANSWER INT SELECT APPL_PERSON_ID, ESSAY INTO #ESSAY_TBL FROM DBO.ESSAY WHERE APPL_PERSON_ID = @lineup_input_appl_id AND CONTAINS(ESSAY, 'AMERICORP OR BATTERED OR GATES SCHOLAR OR GENOCIDE OR HABITAT OR HANDICAPPED OR HRSA OR IMMIGRANT OR NHSSSRAP OR PEACE CORPS OR PIPELINE OR POVERTY OR REFUGEE OR RESERVATION OR SHELTER OR SMDEP OR SOCIAL JUSTICE OR TRIBAL OR UDOC') -- SELECT APPL_PERSON_ID AS ESSAY_APPL_PERSON_ID -- FROM #ESSAY_TBL IF (SELECT COUNT (*) FROM #ESSAY_TBL) 0 BEGIN DROP TABLE #ESSAY_TBL SET @ANSWER = 1 -- SELECT @ANSWER AS iFeSSAYaNSWER GOTO finishline END ELSE BEGIN DROP TABLE #ESSAY_TBL SET @ANSWER = 0 -- SELECT @ANSWER AS eLSEeSSAYaNSWER SELECT APPL_PERSON_ID, ORG_NAME, EXP_TITLE, EXP_DESC, EXP_NAME INTO #EXPERIENCE_TBL FROM DBO.EXPERIENCE WHERE APPL_PERSON_ID = @lineup_input_appl_id AND ((CONTAINS(ORG_NAME, 'AMERICORP OR BATTERED OR GATES SCHOLAR OR GENOCIDE OR HABITAT OR HANDICAPPED OR HRSA OR IMMIGRANT OR NHSSSRAP OR PEACE CORPS OR PIPELINE OR POVERTY OR REFUGEE OR RESERVATION OR SHELTER OR SMDEP OR SOCIAL JUSTICE OR TRIBAL OR UDOC')) OR (CONTAINS(EXP_TITLE, 'AMERICORP OR BATTERED OR GATES SCHOLAR OR GENOCIDE OR HABITAT OR HANDICAPPED OR HRSA OR IMMIGRANT OR NHSSSRAP OR PEACE CORPS OR PIPELINE OR POVERTY OR REFUGEE OR RESERVATION OR SHELTER OR SMDEP OR SOCIAL JUSTICE OR TRIBAL OR UDOC')) OR (CONTAINS(EXP_DESC, 'AMERICORP OR BATTERED OR GATES SCHOLAR OR GENOCIDE OR HABITAT OR HANDICAPPED OR HRSA OR IMMIGRANT OR NHSSSRAP OR PEACE CORPS OR PIPELINE OR POVERTY OR REFUGEE OR RESERVATION OR SHELTER OR SMDEP OR SOCIAL JUSTICE OR TRIBAL OR UDOC')) OR (CONTAINS(EXP_NAME, 'AMERICORP OR BATTERED OR GATES SCHOLAR OR GENOCIDE OR HABITAT OR HANDICAPPED OR HRSA OR IMMIGRANT OR NHSSSRAP OR PEACE CORPS OR PIPELINE OR POVERTY OR REFUGEE OR RESERVATION OR SHELTER OR SMDEP OR SOCIAL JUSTICE OR TRIBAL OR UDOC'))) END -- SELECT APPL_PERSON_ID AS EXPERIENCE_APPL_PERSON_ID -- FROM #EXPERIENCE_TBL IF(SELECT COUNT (*) FROM #EXPERIENCE_TBL) 0 BEGIN DROP TABLE #EXPERIENCE_TBL SET @ANSWER = 1 -- SELECT @ANSWER AS EXPERIENCE_IF_ANSWER GOTO finishline END
Re: Stored Procedures
Have you confirmed that the ARAdmin user has execute permissions to the stored procedure? It would make sense that you would be able to execute the procedure since it would have been created under your account. ARAdmin, however, would have been denied access to the object by default. Have you tried connecting to the remote database server with the ARAdmin account via Query Analyser and executing the procedure that way? This is probably the easiest way of confirming that the account has permissions to the object. Another idea would be to fire up SQL Profiler to see what is happening with the statement. Profiler catches quite a bit of information from the server, so it might take a few minutes of tweaking some of the criteria to filter, but it should pay off. At the very least, it should show the statement being executed and any errors which might have crept up from the call. Just a few thoughts... Offered humbly... ** EXEC [baker].[amcaslocal].[dbo].[AA_Disadvantaged_WordSearch_01] @lineup_input_appl_id = $APPL_PERSON_ID$ I'm using the same syntax in all of my other procedure calls. The difference here being this is the only one that exists on a remote server. I've tested the syntax in query analyzer. I'm not sure what else it could be (syntax wise). Thanks for the help! Warren On 6/2/08, Dave Saville [EMAIL PROTECTED] wrote: Warren Are you sure you have the correct invocation syntax in Remedy? ISTR it is a bit picky. -- Regards Dave Saville _ __ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are -- Warren R. Baltimore II Remedy Developer UW Medicine IT Services School of Medicine University of Washington Box 358220 1325 Fourth Ave, Suite 2000 Seattle, WA 98101 The opinions expressed in this e-mail are in no way those of the University of Washington, or the State of Washington. They are my own. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
OT RUG: Mark your calendar for next MWRUG meeting 7/15/08
*Hi Everyone,* ** *We have a confirmed date at last for our next MWRUG (MIDWEST) in the Chicago area !! * ** *Misi Mladoniczky will be sharing with us information about his products. * ** *I am looking for additional agenda suggestions asap.* ** *It will be an all-day meeting including lunch provided.* ** *Please reply to [EMAIL PROTECTED] [EMAIL PROTECTED]* or go to **www.remedyusergroups.com* http://www.remedyusergroups.com/* and sign up for the MWRUG and the corresponding Mailing List, then send me a message with topic suggestions. * ** *More details will be sent out when available.* ** *Thanks,* *Susan Palmer* *ShopperTrak* [EMAIL PROTECTED] [EMAIL PROTECTED] *312-529-5325* ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Filter Guide Question
What I have done is create another form with all the email addresses on it(one email address per row) and then make your filter guide go through these records to email individually. Lisa -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Brittain, Mark Sent: Monday, June 02, 2008 12:28 PM To: arslist@ARSLIST.ORG Subject: Filter Guide Question Hi All, I have a situation where the email addresses from the customer contact list is populated in the ticket and on open, update, close a notify filter is used to send an email to each contact. These contact lists have grown quite large. I started noticing email errors where the list was getting chopped at 255 characters. The field in the ticket is large enough and so is the To field in the AR System Email Messages form. On further investigation found that the User Name in the Notify has a 255 limit. So that is the bottleneck. Is there a way to sent up a filter guide, that walks through the list of email addresses (they are separated by a semi-colon), sending out individual emails rather than the one big blast currently used? ARS 6.3 patch 20 SunOS 5.9 Oracle 9.2 Thanks Mark Mark Brittain Remedy Developer NaviSite ESM Operations [EMAIL PROTECTED] This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Filter Guide Question
Mark, Sure it can be done. The functions you will need are STRSTR and SUBSTR. You can read more about them in the admin tool Help menu or in the PDF's that come with the ARS product. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On Mon, Jun 2, 2008 at 12:28 PM, Brittain, Mark [EMAIL PROTECTED] wrote: Hi All, I have a situation where the email addresses from the customer contact list is populated in the ticket and on open, update, close a notify filter is used to send an email to each contact. These contact lists have grown quite large. I started noticing email errors where the list was getting chopped at 255 characters. The field in the ticket is large enough and so is the To field in the AR System Email Messages form. On further investigation found that the User Name in the Notify has a 255 limit. So that is the bottleneck. Is there a way to sent up a filter guide, that walks through the list of email addresses (they are separated by a semi-colon), sending out individual emails rather than the one big blast currently used? ARS 6.3 patch 20 SunOS 5.9 Oracle 9.2 Thanks Mark Mark Brittain Remedy Developer NaviSite ESM Operations [EMAIL PROTECTED] ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Stored Procedures
Thanks Willall good ideas, but I actually created the stored procedure as ARAdmin! It's the owner. I have not looked at the profiler though, I'll take a look and see if anything jumps out. Thanks! Warren On 6/2/08, Will Du Chene [EMAIL PROTECTED] wrote: ** Have you confirmed that the ARAdmin user has execute permissions to the stored procedure? It would make sense that you would be able to execute the procedure since it would have been created under your account. ARAdmin, however, would have been denied access to the object by default. Have you tried connecting to the remote database server with the ARAdmin account via Query Analyser and executing the procedure that way? This is probably the easiest way of confirming that the account has permissions to the object. Another idea would be to fire up SQL Profiler to see what is happening with the statement. Profiler catches quite a bit of information from the server, so it might take a few minutes of tweaking some of the criteria to filter, but it should pay off. At the very least, it should show the statement being executed and any errors which might have crept up from the call. Just a few thoughts... Offered humbly... ** EXEC [baker].[amcaslocal].[dbo].[AA_Disadvantaged_WordSearch_01] @lineup_input_appl_id = $APPL_PERSON_ID$ I'm using the same syntax in all of my other procedure calls. The difference here being this is the only one that exists on a remote server. I've tested the syntax in query analyzer. I'm not sure what else it could be (syntax wise). Thanks for the help! Warren On 6/2/08, Dave Saville [EMAIL PROTECTED]http://display_enter/?force_room=_MAIL_[EMAIL PROTECTED] wrote: Warren Are you sure you have the correct invocation syntax in Remedy? ISTR it is a bit picky. -- Regards Dave Saville ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are -- Warren R. Baltimore II Remedy Developer UW Medicine IT Services School of Medicine University of Washington Box 358220 1325 Fourth Ave, Suite 2000 Seattle, WA 98101 The opinions expressed in this e-mail are in no way those of the University of Washington, or the State of Washington. They are my own. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ -- Warren R. Baltimore II Remedy Developer UW Medicine IT Services School of Medicine University of Washington Box 358220 1325 Fourth Ave, Suite 2000 Seattle, WA 98101 The opinions expressed in this e-mail are in no way those of the University of Washington, or the State of Washington. They are my own. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: SQL Stored procedures
It's set for the maximum of 60 seconds On 6/2/08, Sharma, Tarun [EMAIL PROTECTED] wrote: ** Warren, Did you check your Process Timeout parameter in Server Information? You can increase it's value if required. Regards, Tarun -- *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Warren Baltimore *Sent:* Monday, June 02, 2008 9:38 PM *To:* arslist@ARSLIST.ORG *Subject:* SQL Stored procedures ** ARS 7.0.1, SQL 2000 Let me start out by saying that as a SQL dba, I am quite the novice! I have written a simple stored procedure that does a Full Text Search against a SQL database that is NOT the Remedy database. This database is on a seperate server. The procedure lives on that seperate server in the target database (amcaslocal). Here is my issue. If I send the command: EXEC [baker].[amcaslocal].[dbo].[AA_Disadvantaged_WordSearch_01] @lineup_input_appl_id = 160240 From the query analyzer logged into my local (remedy) sql database. I get an answer! If however I send that same command in a set fields from either a filter or an Active link, the process times out and the whole thing dies Incidently, when I developed this process, the database I was searching on was on the local server. I have set up a linked server on the local box to connect to the remote. Any input would be most welcome! The procedure is as follows: SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS OFF GO /* Stored procedure used to find instances of special needs OR disadvantaged words. */ CREATE PROC AA_Disadvantaged_WordSearch_01 (@lineup_input_appl_id int) --SOMID AS DECLARE @ANSWER INT SELECT APPL_PERSON_ID, ESSAY INTO #ESSAY_TBL FROM DBO.ESSAY WHERE APPL_PERSON_ID = @lineup_input_appl_id AND CONTAINS(ESSAY, 'AMERICORP OR BATTERED OR GATES SCHOLAR OR GENOCIDE OR HABITAT OR HANDICAPPED OR HRSA OR IMMIGRANT OR NHSSSRAP OR PEACE CORPS OR PIPELINE OR POVERTY OR REFUGEE OR RESERVATION OR SHELTER OR SMDEP OR SOCIAL JUSTICE OR TRIBAL OR UDOC') -- SELECT APPL_PERSON_ID AS ESSAY_APPL_PERSON_ID -- FROM #ESSAY_TBL IF (SELECT COUNT (*) FROM #ESSAY_TBL) 0 BEGIN DROP TABLE #ESSAY_TBL SET @ANSWER = 1 -- SELECT @ANSWER AS iFeSSAYaNSWER GOTO finishline END ELSE BEGIN DROP TABLE #ESSAY_TBL SET @ANSWER = 0 -- SELECT @ANSWER AS eLSEeSSAYaNSWER SELECT APPL_PERSON_ID, ORG_NAME, EXP_TITLE, EXP_DESC, EXP_NAME INTO #EXPERIENCE_TBL FROM DBO.EXPERIENCE WHERE APPL_PERSON_ID = @lineup_input_appl_id AND ((CONTAINS(ORG_NAME, 'AMERICORP OR BATTERED OR GATES SCHOLAR OR GENOCIDE OR HABITAT OR HANDICAPPED OR HRSA OR IMMIGRANT OR NHSSSRAP OR PEACE CORPS OR PIPELINE OR POVERTY OR REFUGEE OR RESERVATION OR SHELTER OR SMDEP OR SOCIAL JUSTICE OR TRIBAL OR UDOC')) OR (CONTAINS(EXP_TITLE, 'AMERICORP OR BATTERED OR GATES SCHOLAR OR GENOCIDE OR HABITAT OR HANDICAPPED OR HRSA OR IMMIGRANT OR NHSSSRAP OR PEACE CORPS OR PIPELINE OR POVERTY OR REFUGEE OR RESERVATION OR SHELTER OR SMDEP OR SOCIAL JUSTICE OR TRIBAL OR UDOC')) OR (CONTAINS(EXP_DESC, 'AMERICORP OR BATTERED OR GATES SCHOLAR OR GENOCIDE OR HABITAT OR HANDICAPPED OR HRSA OR IMMIGRANT OR NHSSSRAP OR PEACE CORPS OR PIPELINE OR POVERTY OR REFUGEE OR RESERVATION OR SHELTER OR SMDEP OR SOCIAL JUSTICE OR TRIBAL OR UDOC')) OR (CONTAINS(EXP_NAME, 'AMERICORP OR BATTERED OR GATES SCHOLAR OR GENOCIDE OR HABITAT OR HANDICAPPED OR HRSA OR IMMIGRANT OR NHSSSRAP OR PEACE CORPS OR PIPELINE OR POVERTY OR REFUGEE OR RESERVATION OR SHELTER OR SMDEP OR SOCIAL JUSTICE OR TRIBAL OR UDOC'))) END -- SELECT APPL_PERSON_ID AS EXPERIENCE_APPL_PERSON_ID -- FROM #EXPERIENCE_TBL IF(SELECT COUNT (*) FROM #EXPERIENCE_TBL) 0 BEGIN DROP TABLE #EXPERIENCE_TBL SET @ANSWER = 1 -- SELECT @ANSWER AS EXPERIENCE_IF_ANSWER GOTO finishline END ELSE BEGIN DROP TABLE #EXPERIENCE_TBL SET @ANSWER = 0 -- SELECT @ANSWER AS EXPERIENCE_ELSE_ANSWER END finishline: SELECT @ANSWER AS ANSWER GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO -- Warren R. Baltimore II Remedy Developer UW Medicine IT Services School of Medicine University of Washington Box 358220 1325 Fourth Ave, Suite 2000 Seattle, WA 98101 The opinions expressed in this e-mail are in no way those of the University of Washington, or the State of Washington. They are my own. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ -- Warren R. Baltimore II Remedy Developer UW Medicine IT Services School of Medicine University of Washington Box 358220 1325 Fourth Ave, Suite 2000 Seattle, WA 98101 The opinions expressed in this e-mail are in no way those of the University of Washington, or the State
Re: Crystal Reports Server XI for Web Reporting
So I am going to check of the Business Objects Enterprise XI radio button even though I have installed Crystal Reports Server XI? When I do that I get this error. Failed to process the request!! An unexpected error has occurred com.crystaldecisions.sdk.exception.SDKException$Unexpected: An unexpected error has occurred cause:java.io.IOException: CreateProcess: C:\Program Files\Business Objects\BusinessObjects Enterprise 11\win32_x86\plugins\desktop\CrystalEnterprise.Report\ReportAdd.exe -report C:\Program Files\AR System\Mid-Tier\reports\m11c23c11b16\676C737A168EFEA47E5CF37BFB82CD76\HPD5fDetail.rpt -newrpt -discard -version 1100 -thumbnail -outfile -token [EMAIL PROTECTED] FYI, we did install our own version of Tomcat beforehand. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of strauss Sent: Monday, June 02, 2008 12:49 PM To: arslist@ARSLIST.ORG Subject: Re: Crystal Reports Server XI for Web Reporting ** My experience with Crystal Report Server XI was that you would be unable to access the CMC web interface if you tried to install Crystal to use the tomcat instance installed by mid-tier. If it is installed with its own tomcat, or on IIS using .NET, the CMC web interface is accessible for applying the license. Make sure that the mid-tier is configured with the CMS Machine Connection Details for BOXI authentication, NOT Crystal Report Server XI. That should allow you to connect the way mid-tier wants to - using un-named user accounts - versus the default for CRS XI which is named accounts. BO changed the default license behavior in XI to the opposite of what previous versions used, and what mid-tier expects. 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:[EMAIL PROTECTED] On Behalf Of Bardsley, Michael Sent: Monday, June 02, 2008 11:36 AM To: arslist@ARSLIST.ORG Subject: Crystal Reports Server XI for Web Reporting ** We have installed a Crystal Reports Server XI with a 60 trial license and have followed all the installation/configuration procedures per the Remedy Mid Tier 7.0.01 install guide for Web Reporting but when we try to view a report from the MT we receive error below. I found one article on the BO support site that has you check to see if the key code used is configured for Concurrent users or for Named User. But it instructs you to go into the CMC which does not look like it was installed with CRS. Failed to process the request!! All of your system's 0 Concurrent Access Licenses are in use at this time or your system's license key has expired. Try again later or contact your administrator to obtain additional licenses. com.crystaldecisions.sdk.occa.report.lib.ReportSDKEnterpriseLogonException: All of your system's 0 Concurrent Access Licenses are in use at this time or your system's license key has expired. Try again later or contact your administrator to obtain additional licenses. Error code:-2147217397 Error code name:enterpriseLogonFailed Michael Bardsley __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ Please consider the environment before printing this e-mail. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Use of Roles in Deployable Application
Hi: I am trying to build a deployable application for the first time so I can migrate the application between test, development and production remedy servers. I read through the docs couple of times and still can't seem to understand the usage of roles. I know users are part of one or more group(s). A role can have one group when in Test and another group when in Production. Is that all: All roles does is provide access to the application to different set of users based on the deployable application state? So do the groups and roles have to exist on the destination arserver before exporting an imported application from my test server to the development arserver? Also looks like the advantage of using deployable application instead of local application is that it can be licensesed and tracked. Is that the only reason why someone would use deployable? TIA Ravi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Crystal Reports Server XI for Web Reporting
I believe that you have actually progressed from a licensing problem to a java or permissions issue (one that I have never seen) with the creation of the actual report file that mid-tier has to build. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Bardsley, Michael Sent: Monday, June 02, 2008 12:32 PM To: arslist@ARSLIST.ORG Subject: Re: Crystal Reports Server XI for Web Reporting ** So I am going to check of the Business Objects Enterprise XI radio button even though I have installed Crystal Reports Server XI? When I do that I get this error. Failed to process the request!! An unexpected error has occurred com.crystaldecisions.sdk.exception.SDKException$Unexpected: An unexpected error has occurred cause:java.io.IOException: CreateProcess: C:\Program Files\Business Objects\BusinessObjects Enterprise 11\win32_x86\plugins\desktop\CrystalEnterprise.Report\ReportAdd.exe -report C:\Program Files\AR System\Mid-Tier\reports\m11c23c11b16\676C737A168EFEA47E5CF37BFB82CD76\HP D5fDetail.rpt -newrpt -discard -version 1100 -thumbnail -outfile -token [EMAIL PROTECTED] jfkM2HRNT FYI, we did install our own version of Tomcat beforehand. _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of strauss Sent: Monday, June 02, 2008 12:49 PM To: arslist@ARSLIST.ORG Subject: Re: Crystal Reports Server XI for Web Reporting ** My experience with Crystal Report Server XI was that you would be unable to access the CMC web interface if you tried to install Crystal to use the tomcat instance installed by mid-tier. If it is installed with its own tomcat, or on IIS using .NET, the CMC web interface is accessible for applying the license. Make sure that the mid-tier is configured with the CMS Machine Connection Details for BOXI authentication, NOT Crystal Report Server XI. That should allow you to connect the way mid-tier wants to - using un-named user accounts - versus the default for CRS XI which is named accounts. BO changed the default license behavior in XI to the opposite of what previous versions used, and what mid-tier expects. 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:[EMAIL PROTECTED] On Behalf Of Bardsley, Michael Sent: Monday, June 02, 2008 11:36 AM To: arslist@ARSLIST.ORG Subject: Crystal Reports Server XI for Web Reporting ** We have installed a Crystal Reports Server XI with a 60 trial license and have followed all the installation/configuration procedures per the Remedy Mid Tier 7.0.01 install guide for Web Reporting but when we try to view a report from the MT we receive error below. I found one article on the BO support site that has you check to see if the key code used is configured for Concurrent users or for Named User. But it instructs you to go into the CMC which does not look like it was installed with CRS. Failed to process the request!! All of your system's 0 Concurrent Access Licenses are in use at this time or your system's license key has expired. Try again later or contact your administrator to obtain additional licenses. com.crystaldecisions.sdk.occa.report.lib.ReportSDKEnterpriseLogonExcepti on: All of your system's 0 Concurrent Access Licenses are in use at this time or your system's license key has expired. Try again later or contact your administrator to obtain additional licenses. Error code:-2147217397 Error code name:enterpriseLogonFailed Michael Bardsley __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ _ Please consider the environment before printing this e-mail. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Midtier Issues Turn Into Gross BMC Incompetence
Hello, I'm a little upset here, as I have received instructions from BMC, that had I carried them out blindly on my production server, would have completely wiped out any workflow and data I had not backed up, and with no warning from BMC. I would like to share these instructions here, and get opinions as to whether I am totally misunderstanding the instructions, or if I was given incomplete and dangerous instructions by an incompetent BMC tech. The problem was, originally, that when my form was called from the midtier via a table or results list, the browser would display the form as blank even though a specific request id was requested. So, double click the ticket, window opens, form is blank instead of filled in with that ticket's contents. All workflow works fine in the user client. So, after minor troubleshooting with BMC they finally request the .def file, I send it. They get back to me with the following instructions (object name replaced by FORM): 1. Go to the Admin tool and open that form FORM and Save as that form with the different name e.g. FORM-new 2. Rename original form FORM to FORM-old 3. Now rename FORM-new to FORM. 4. Delete the form FORM 5. Rename FORM-old to FORM 6. Verify all the Active Links/Filters point to FORM 7. Export the *.def file of FORM 8. Delete the form FORM 9. Create new form name it FORM 10. Verify all the Active Links/Filter point to FORM Now the issue with this, and thank goodness I did this on my development server first, is that at step 8, YOU DESTROY ALL YOUR DATA AND WORKFLOW. Making steps 9 and 10 irrelevant. Even given the fact that I could have implied that at step 7 I should have exported the entire workflow for that form, there is still no step that says back up your data, and there are no steps explaining importing back your workflow and data. Please give me your points of view on this situation because I am trying to not write a scathing email or make a hostile phone call right now. Paul Blasquez Senior Network Engineer/Remedy Developer | Desk - 408.360.5220 | Cell - 408.627.5714 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: SQL Stored procedures
Permissions are correct and confirmed! On 6/2/08, Joe DeSouza [EMAIL PROTECTED] wrote: ** Does the ARSystem database user aradmin have permissions to the store proceedure? Does aradmin have permissions to the DB link and any other resource that the stored proceedure may be using? Joe - Original Message From: Warren Baltimore [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, June 2, 2008 12:42:33 PM Subject: Re: SQL Stored procedures ** EXEC [baker].[amcaslocal].[dbo].[AA_Disadvantaged_WordSearch_01] @lineup_input_appl_id = $APPL_PERSON_ID$ I'm using the same syntax in all of my other procedure calls. The difference here being this is the only one that exists on a remote server. I've tested the syntax in query analyzer. I'm not sure what else it could be (syntax wise). Thanks for the help! Warren On 6/2/08, Dave Saville [EMAIL PROTECTED] wrote: Warren Are you sure you have the correct invocation syntax in Remedy? ISTR it is a bit picky. -- Regards Dave Saville ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are -- Warren R. Baltimore II Remedy Developer UW Medicine IT Services School of Medicine University of Washington Box 358220 1325 Fourth Ave, Suite 2000 Seattle, WA 98101 The opinions expressed in this e-mail are in no way those of the University of Washington, or the State of Washington. They are my own. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ -- Warren R. Baltimore II Remedy Developer UW Medicine IT Services School of Medicine University of Washington Box 358220 1325 Fourth Ave, Suite 2000 Seattle, WA 98101 The opinions expressed in this e-mail are in no way those of the University of Washington, or the State of Washington. They are my own. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: SQL Stored procedures
Thanks Pavel, I'll take a look I'm pretty sure that I can do this from both the AL and Filter (I've done this before), I think the key here is that it's a call to a remote server. We just discovered that remedy is truncating the call and dropping off the server name! That would screw it up for sure Should be: EXEC [baker].[amcaslocal].[dbo].[AA_Disadvantaged_WordSearch_01] @lineup_input_appl_id = 160240 But is being sent as: EXEC [amcaslocal].[dbo].[AA_Disadvantaged_WordSearch_01] @lineup_input_appl_id = 160240 And your English is quite good! Sure beats my spanish! Warren On 6/2/08, Pavel Guedez [EMAIL PROTECTED] wrote: ** Hi Warren, First, sorry for my english, I'm form Venezuela (spanish speaker), I don't know if on a Set Fields action from a filter o Active link you can call to a procedure, you have to call it from a Direct SQL action. But if so, I think you need to use an OUTPUT parameter, to get some answer from the procedure. I guess you try to use @ANSWER as an output parameter, but if I'm not wrong, you need to explicit declare it as an OUTPUT, and maybe beacuse of that the process times out waiting for an answer. Check this web page, for help about procedure on SQL http://msdn.microsoft.com/en-us/library/aa258259(SQL.80).aspx *Pavel Guédez* GSM +58 412 808.33.16 - Original Message From: Warren Baltimore [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, June 2, 2008 11:37:30 AM Subject: SQL Stored procedures ** ARS 7.0.1, SQL 2000 Let me start out by saying that as a SQL dba, I am quite the novice! I have written a simple stored procedure that does a Full Text Search against a SQL database that is NOT the Remedy database. This database is on a seperate server. The procedure lives on that seperate server in the target database (amcaslocal). Here is my issue. If I send the command: EXEC [baker].[amcaslocal].[dbo].[AA_Disadvantaged_WordSearch_01] @lineup_input_appl_id = 160240 From the query analyzer logged into my local (remedy) sql database. I get an answer! If however I send that same command in a set fields from either a filter or an Active link, the process times out and the whole thing dies Incidently, when I developed this process, the database I was searching on was on the local server. I have set up a linked server on the local box to connect to the remote. Any input would be most welcome! The procedure is as follows: SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS OFF GO /* Stored procedure used to find instances of special needs OR disadvantaged words. */ CREATE PROC AA_Disadvantaged_WordSearch_01 (@lineup_input_appl_id int) --SOMID AS DECLARE @ANSWER INT SELECT APPL_PERSON_ID, ESSAY INTO #ESSAY_TBL FROM DBO.ESSAY WHERE APPL_PERSON_ID = @lineup_input_appl_id AND CONTAINS(ESSAY, 'AMERICORP OR BATTERED OR GATES SCHOLAR OR GENOCIDE OR HABITAT OR HANDICAPPED OR HRSA OR IMMIGRANT OR NHSSSRAP OR PEACE CORPS OR PIPELINE OR POVERTY OR REFUGEE OR RESERVATION OR SHELTER OR SMDEP OR SOCIAL JUSTICE OR TRIBAL OR UDOC') -- SELECT APPL_PERSON_ID AS ESSAY_APPL_PERSON_ID -- FROM #ESSAY_TBL IF (SELECT COUNT (*) FROM #ESSAY_TBL) 0 BEGIN DROP TABLE #ESSAY_TBL SET @ANSWER = 1 -- SELECT @ANSWER AS iFeSSAYaNSWER GOTO finishline END ELSE BEGIN DROP TABLE #ESSAY_TBL SET @ANSWER = 0 -- SELECT @ANSWER AS eLSEeSSAYaNSWER SELECT APPL_PERSON_ID, ORG_NAME, EXP_TITLE, EXP_DESC, EXP_NAME INTO #EXPERIENCE_TBL FROM DBO.EXPERIENCE WHERE APPL_PERSON_ID = @lineup_input_appl_id AND ((CONTAINS(ORG_NAME, 'AMERICORP OR BATTERED OR GATES SCHOLAR OR GENOCIDE OR HABITAT OR HANDICAPPED OR HRSA OR IMMIGRANT OR NHSSSRAP OR PEACE CORPS OR PIPELINE OR POVERTY OR REFUGEE OR RESERVATION OR SHELTER OR SMDEP OR SOCIAL JUSTICE OR TRIBAL OR UDOC')) OR (CONTAINS(EXP_TITLE, 'AMERICORP OR BATTERED OR GATES SCHOLAR OR GENOCIDE OR HABITAT OR HANDICAPPED OR HRSA OR IMMIGRANT OR NHSSSRAP OR PEACE CORPS OR PIPELINE OR POVERTY OR REFUGEE OR RESERVATION OR SHELTER OR SMDEP OR SOCIAL JUSTICE OR TRIBAL OR UDOC')) OR (CONTAINS(EXP_DESC, 'AMERICORP OR BATTERED OR GATES SCHOLAR OR GENOCIDE OR HABITAT OR HANDICAPPED OR HRSA OR IMMIGRANT OR NHSSSRAP OR PEACE CORPS OR PIPELINE OR POVERTY OR REFUGEE OR RESERVATION OR SHELTER OR SMDEP OR SOCIAL JUSTICE OR TRIBAL OR UDOC')) OR (CONTAINS(EXP_NAME, 'AMERICORP OR BATTERED OR GATES SCHOLAR OR GENOCIDE OR HABITAT OR HANDICAPPED OR HRSA OR IMMIGRANT OR NHSSSRAP OR PEACE CORPS OR PIPELINE OR POVERTY OR REFUGEE OR RESERVATION OR SHELTER OR SMDEP OR SOCIAL JUSTICE OR TRIBAL OR UDOC'))) END -- SELECT APPL_PERSON_ID AS EXPERIENCE_APPL_PERSON_ID -- FROM #EXPERIENCE_TBL IF(SELECT COUNT (*) FROM #EXPERIENCE_TBL) 0 BEGIN DROP TABLE #EXPERIENCE_TBL SET @ANSWER = 1 -- SELECT @ANSWER AS EXPERIENCE_IF_ANSWER
Re: SQL Stored procedures
Hi Warren, First, sorry for my english, I'm form Venezuela (spanish speaker), I don't know if on a Set Fields action from a filter o Active link you can call to a procedure, you have to call it from a Direct SQL action. But if so, I think you need to use an OUTPUT parameter, to get some answer from the procedure. I guess you try to use @ANSWER as an output parameter, but if I'm not wrong, you need to explicit declare it as an OUTPUT, and maybe beacuse of that the process times out waiting for an answer. Check this web page, for help about procedure on SQL http://msdn.microsoft.com/en-us/library/aa258259(SQL.80).aspx Pavel Guédez GSM +58 412 808.33.16 - Original Message From: Warren Baltimore [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, June 2, 2008 11:37:30 AM Subject: SQL Stored procedures ** ARS 7.0.1, SQL 2000 Let me start out by saying that as a SQL dba, I am quite the novice! I have written a simple stored procedure that does a Full Text Search against a SQL database that is NOT the Remedy database. This database is on a seperate server. The procedure lives on that seperate server in the target database (amcaslocal). Here is my issue. If I send the command: EXEC [baker].[amcaslocal].[dbo].[AA_Disadvantaged_WordSearch_01] @lineup_input_appl_id = 160240 From the query analyzer logged into my local (remedy) sql database. I get an answer! If however I send that same command in a set fields from either a filter or an Active link, the process times out and the whole thing dies Incidently, when I developed this process, the database I was searching on was on the local server. I have set up a linked server on the local box to connect to the remote. Any input would be most welcome! The procedure is as follows: SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS OFF GO /* Stored procedure used to find instances of special needs OR disadvantaged words. */ CREATE PROC AA_Disadvantaged_WordSearch_01 (@lineup_input_appl_id int) --SOMID AS DECLARE @ANSWER INT SELECT APPL_PERSON_ID, ESSAY INTO #ESSAY_TBL FROM DBO.ESSAY WHERE APPL_PERSON_ID = @lineup_input_appl_id AND CONTAINS(ESSAY, 'AMERICORP OR BATTERED OR GATES SCHOLAR OR GENOCIDE OR HABITAT OR HANDICAPPED OR HRSA OR IMMIGRANT OR NHSSSRAP OR PEACE CORPS OR PIPELINE OR POVERTY OR REFUGEE OR RESERVATION OR SHELTER OR SMDEP OR SOCIAL JUSTICE OR TRIBAL OR UDOC') -- SELECT APPL_PERSON_ID AS ESSAY_APPL_PERSON_ID -- FROM #ESSAY_TBL IF (SELECT COUNT (*) FROM #ESSAY_TBL) 0 BEGIN DROP TABLE #ESSAY_TBL SET @ANSWER = 1 -- SELECT @ANSWER AS iFeSSAYaNSWER GOTO finishline END ELSE BEGIN DROP TABLE #ESSAY_TBL SET @ANSWER = 0 -- SELECT @ANSWER AS eLSEeSSAYaNSWER SELECT APPL_PERSON_ID, ORG_NAME, EXP_TITLE, EXP_DESC, EXP_NAME INTO #EXPERIENCE_TBL FROM DBO.EXPERIENCE WHERE APPL_PERSON_ID = @lineup_input_appl_id AND ((CONTAINS(ORG_NAME, 'AMERICORP OR BATTERED OR GATES SCHOLAR OR GENOCIDE OR HABITAT OR HANDICAPPED OR HRSA OR IMMIGRANT OR NHSSSRAP OR PEACE CORPS OR PIPELINE OR POVERTY OR REFUGEE OR RESERVATION OR SHELTER OR SMDEP OR SOCIAL JUSTICE OR TRIBAL OR UDOC')) OR (CONTAINS(EXP_TITLE, 'AMERICORP OR BATTERED OR GATES SCHOLAR OR GENOCIDE OR HABITAT OR HANDICAPPED OR HRSA OR IMMIGRANT OR NHSSSRAP OR PEACE CORPS OR PIPELINE OR POVERTY OR REFUGEE OR RESERVATION OR SHELTER OR SMDEP OR SOCIAL JUSTICE OR TRIBAL OR UDOC')) OR (CONTAINS(EXP_DESC, 'AMERICORP OR BATTERED OR GATES SCHOLAR OR GENOCIDE OR HABITAT OR HANDICAPPED OR HRSA OR IMMIGRANT OR NHSSSRAP OR PEACE CORPS OR PIPELINE OR POVERTY OR REFUGEE OR RESERVATION OR SHELTER OR SMDEP OR SOCIAL JUSTICE OR TRIBAL OR UDOC')) OR (CONTAINS(EXP_NAME, 'AMERICORP OR BATTERED OR GATES SCHOLAR OR GENOCIDE OR HABITAT OR HANDICAPPED OR HRSA OR IMMIGRANT OR NHSSSRAP OR PEACE CORPS OR PIPELINE OR POVERTY OR REFUGEE OR RESERVATION OR SHELTER OR SMDEP OR SOCIAL JUSTICE OR TRIBAL OR UDOC'))) END -- SELECT APPL_PERSON_ID AS EXPERIENCE_APPL_PERSON_ID -- FROM #EXPERIENCE_TBL IF(SELECT COUNT (*) FROM #EXPERIENCE_TBL) 0 BEGIN DROP TABLE #EXPERIENCE_TBL SET @ANSWER = 1 -- SELECT @ANSWER AS EXPERIENCE_IF_ANSWER GOTO finishline END ELSE BEGIN DROP TABLE #EXPERIENCE_TBL SET @ANSWER = 0 -- SELECT @ANSWER AS EXPERIENCE_ELSE_ANSWER END finishline: SELECT @ANSWER AS ANSWER GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO -- Warren R. Baltimore II Remedy Developer UW Medicine IT Services School of Medicine University of Washington Box 358220 1325 Fourth Ave, Suite 2000 Seattle, WA 98101 The opinions expressed in this e-mail are in no way those of the University of Washington, or the State of Washington. They are my own. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at
Re: SQL Stored procedures
Does the ARSystem database user aradmin have permissions to the store proceedure? Does aradmin have permissions to the DB link and any other resource that the stored proceedure may be using? Joe - Original Message From: Warren Baltimore [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, June 2, 2008 12:42:33 PM Subject: Re: SQL Stored procedures ** EXEC [baker].[amcaslocal].[dbo].[AA_Disadvantaged_WordSearch_01] @lineup_input_appl_id = $APPL_PERSON_ID$ I'm using the same syntax in all of my other procedure calls. The difference here being this is the only one that exists on a remote server. I've tested the syntax in query analyzer. I'm not sure what else it could be (syntax wise). Thanks for the help! Warren On 6/2/08, Dave Saville [EMAIL PROTECTED] wrote: Warren Are you sure you have the correct invocation syntax in Remedy? ISTR it is a bit picky. -- Regards Dave Saville ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are -- Warren R. Baltimore II Remedy Developer UW Medicine IT Services School of Medicine University of Washington Box 358220 1325 Fourth Ave, Suite 2000 Seattle, WA 98101 The opinions expressed in this e-mail are in no way those of the University of Washington, or the State of Washington. They are my own. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Use of Roles in Deployable Application
Additionally, Role ID's are specific to the application...which means that a deployable application can be dropped onto a new server, and have the roles mapped to existing groups on the new server without breaking anything. If it's a local application then the permissions are tied to a group id...if the group id that the application uses is already in use on the destination server...you are screwed...I believe that this architecture was setup so that Company A could sell an application to Company B without regard for if the group ID's the application was built on are already in use on the destination server -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ravi Sent: Monday, June 02, 2008 11:34 AM To: arslist@ARSLIST.ORG Subject: Use of Roles in Deployable Application Hi: I am trying to build a deployable application for the first time so I can migrate the application between test, development and production remedy servers. I read through the docs couple of times and still can't seem to understand the usage of roles. I know users are part of one or more group(s). A role can have one group when in Test and another group when in Production. Is that all: All roles does is provide access to the application to different set of users based on the deployable application state? So do the groups and roles have to exist on the destination arserver before exporting an imported application from my test server to the development arserver? Also looks like the advantage of using deployable application instead of local application is that it can be licensesed and tracked. Is that the only reason why someone would use deployable? TIA Ravi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Use of Roles in Deployable Application
Hi Ravi When you export a deployable application the Roles associated with it are exported as part of the definition file, so will be created on your new server during the import of the application. Separating Roles from specific permission groups means that you do not need to have the same permission groups on all servers - you can map different groups to the Roles and application states. You can even map the Role to a computed group for complete flexibility. You can also include data in your application export, so importing the application will also import the data you selected which can be useful. HTH David Sanders Remedy Solution Architect Enterprise Service Suite @ Work == ARS List Award Winner 2005 Best 3rd party Remedy Application See the ESS Concepts Guide tel +44 1494 468980 mobile +44 7710 377761 email [EMAIL PROTECTED] web http://www.westoverconsulting.co.uk -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ravi Sent: Monday, June 02, 2008 6:34 PM To: arslist@ARSLIST.ORG Subject: Use of Roles in Deployable Application Hi: I am trying to build a deployable application for the first time so I can migrate the application between test, development and production remedy servers. I read through the docs couple of times and still can't seem to understand the usage of roles. I know users are part of one or more group(s). A role can have one group when in Test and another group when in Production. Is that all: All roles does is provide access to the application to different set of users based on the deployable application state? So do the groups and roles have to exist on the destination arserver before exporting an imported application from my test server to the development arserver? Also looks like the advantage of using deployable application instead of local application is that it can be licensesed and tracked. Is that the only reason why someone would use deployable? TIA Ravi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Midtier Issues Turn Into Gross BMC Incompetence
They need a Step 4a: Make sure your company is equipped with a defibrillator, as you will need this for coming back from a heart attack from finding out that you've just deleted all your workflow Lisa -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Paul Blasquez Sent: Monday, June 02, 2008 2:37 PM To: arslist@ARSLIST.ORG Subject: Midtier Issues Turn Into Gross BMC Incompetence Hello, I'm a little upset here, as I have received instructions from BMC, that had I carried them out blindly on my production server, would have completely wiped out any workflow and data I had not backed up, and with no warning from BMC. I would like to share these instructions here, and get opinions as to whether I am totally misunderstanding the instructions, or if I was given incomplete and dangerous instructions by an incompetent BMC tech. The problem was, originally, that when my form was called from the midtier via a table or results list, the browser would display the form as blank even though a specific request id was requested. So, double click the ticket, window opens, form is blank instead of filled in with that ticket's contents. All workflow works fine in the user client. So, after minor troubleshooting with BMC they finally request the .def file, I send it. They get back to me with the following instructions (object name replaced by FORM): 1. Go to the Admin tool and open that form FORM and Save as that form with the different name e.g. FORM-new 2. Rename original form FORM to FORM-old 3. Now rename FORM-new to FORM. 4. Delete the form FORM 5. Rename FORM-old to FORM 6. Verify all the Active Links/Filters point to FORM 7. Export the *.def file of FORM 8. Delete the form FORM 9. Create new form name it FORM 10. Verify all the Active Links/Filter point to FORM Now the issue with this, and thank goodness I did this on my development server first, is that at step 8, YOU DESTROY ALL YOUR DATA AND WORKFLOW. Making steps 9 and 10 irrelevant. Even given the fact that I could have implied that at step 7 I should have exported the entire workflow for that form, there is still no step that says back up your data, and there are no steps explaining importing back your workflow and data. Please give me your points of view on this situation because I am trying to not write a scathing email or make a hostile phone call right now. Paul Blasquez Senior Network Engineer/Remedy Developer | Desk - 408.360.5220 | Cell - 408.627.5714 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Midtier Issues Turn Into Gross BMC Incompetence
I would like to know why steps 3 and 5 are in there. Why would one rename two different forms to the same form name, even if that were possible? Or am I misunderstanding the process? Rick On Mon, Jun 2, 2008 at 11:37 AM, Paul Blasquez [EMAIL PROTECTED] wrote: Hello, I'm a little upset here, as I have received instructions from BMC, that had I carried them out blindly on my production server, would have completely wiped out any workflow and data I had not backed up, and with no warning from BMC. I would like to share these instructions here, and get opinions as to whether I am totally misunderstanding the instructions, or if I was given incomplete and dangerous instructions by an incompetent BMC tech. The problem was, originally, that when my form was called from the midtier via a table or results list, the browser would display the form as blank even though a specific request id was requested. So, double click the ticket, window opens, form is blank instead of filled in with that ticket's contents. All workflow works fine in the user client. So, after minor troubleshooting with BMC they finally request the .def file, I send it. They get back to me with the following instructions (object name replaced by FORM): 1. Go to the Admin tool and open that form FORM and Save as that form with the different name e.g. FORM-new 2. Rename original form FORM to FORM-old 3. Now rename FORM-new to FORM. 4. Delete the form FORM 5. Rename FORM-old to FORM 6. Verify all the Active Links/Filters point to FORM 7. Export the *.def file of FORM 8. Delete the form FORM 9. Create new form name it FORM 10. Verify all the Active Links/Filter point to FORM Now the issue with this, and thank goodness I did this on my development server first, is that at step 8, YOU DESTROY ALL YOUR DATA AND WORKFLOW. Making steps 9 and 10 irrelevant. Even given the fact that I could have implied that at step 7 I should have exported the entire workflow for that form, there is still no step that says back up your data, and there are no steps explaining importing back your workflow and data. Please give me your points of view on this situation because I am trying to not write a scathing email or make a hostile phone call right now. Paul Blasquez Senior Network Engineer/Remedy Developer | Desk - 408.360.5220 | Cell - 408.627.5714 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Midtier Issues Turn Into Gross BMC Incompetence
Wow. This whole step by step procedure really has many issues: 1. Why are they asking you to create copies and remove and replace the form on the server when this sounds like a Mid Tier issue not a server issue since you don't have the problem with the User client? Wouldn't it have made sense to troubleshoot your issue with the mid tier cache or tomcat (or with whatever is hosting the web on your Mid Tier server)? 2. Why would you be creating a separate iteration of the form and backing up the original form and then in addition to renaming the separate iteration to the name of the original form you would delete the original form and create the form from scratch? It seems like they are having you do too many things at once. Shouldn't they have you test one thing (seeing if it is an issue with the formname itself) and then if that does work try creating a form with that name from scratch to see if that resolves the issue? Just not good advice to troubleshoot this issue (despite the fact that even the notion of troubleshooting a Mid Tier issue with rebuilding your form is crazy IMHO). I would definitely escalate that issue to your BMC rep about this. Thanks Peter Lammey ESPN MIT Technical Services Applications Management 860-766-4761 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Paul Blasquez Sent: Monday, June 02, 2008 2:37 PM To: arslist@ARSLIST.ORG Subject: Midtier Issues Turn Into Gross BMC Incompetence Hello, I'm a little upset here, as I have received instructions from BMC, that had I carried them out blindly on my production server, would have completely wiped out any workflow and data I had not backed up, and with no warning from BMC. I would like to share these instructions here, and get opinions as to whether I am totally misunderstanding the instructions, or if I was given incomplete and dangerous instructions by an incompetent BMC tech. The problem was, originally, that when my form was called from the midtier via a table or results list, the browser would display the form as blank even though a specific request id was requested. So, double click the ticket, window opens, form is blank instead of filled in with that ticket's contents. All workflow works fine in the user client. So, after minor troubleshooting with BMC they finally request the .def file, I send it. They get back to me with the following instructions (object name replaced by FORM): 1. Go to the Admin tool and open that form FORM and Save as that form with the different name e.g. FORM-new 2. Rename original form FORM to FORM-old 3. Now rename FORM-new to FORM. 4. Delete the form FORM 5. Rename FORM-old to FORM 6. Verify all the Active Links/Filters point to FORM 7. Export the *.def file of FORM 8. Delete the form FORM 9. Create new form name it FORM 10. Verify all the Active Links/Filter point to FORM Now the issue with this, and thank goodness I did this on my development server first, is that at step 8, YOU DESTROY ALL YOUR DATA AND WORKFLOW. Making steps 9 and 10 irrelevant. Even given the fact that I could have implied that at step 7 I should have exported the entire workflow for that form, there is still no step that says back up your data, and there are no steps explaining importing back your workflow and data. Please give me your points of view on this situation because I am trying to not write a scathing email or make a hostile phone call right now. Paul Blasquez Senior Network Engineer/Remedy Developer | Desk - 408.360.5220 | Cell - 408.627.5714 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are Please consider the environment before printing this e-mail. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: SQL Stored procedures
Yes, I did check that the user was correct (ARAdmin) and that it has permissions. In fact, the stored procedure was authored by ARAdmin! Warren When we first built this procedure, it was running on a db that was on the Local Remedy SQL Server. The difference now is that it is being called from a linked server. When it is called by ARAdmin in the query analyzer using the following syntax, it works fine: EXEC [baker].[amcaslocal].[dbo].[AA_Disadvantaged_WordSearch_01] @lineup_input_appl_id = 160240 I am calling this from the Local Remedy Server by the way. When Remedy calls it, we have found that the server name [baker] is being dropped from the call. Warren On 6/2/08, Pavel Guedez [EMAIL PROTECTED] wrote: ** Warren when you tested the syntax in query analyzer. Did you log in as ARADMIN?, that for check if you have the right permissions, check this out and if you have the permissions, verify the syntax on procedure (OUTPUT parameters) Pavel - Original Message From: Joe DeSouza [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, June 2, 2008 1:42:06 PM Subject: Re: SQL Stored procedures ** Does the ARSystem database user aradmin have permissions to the store proceedure? Does aradmin have permissions to the DB link and any other resource that the stored proceedure may be using? Joe - Original Message From: Warren Baltimore [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, June 2, 2008 12:42:33 PM Subject: Re: SQL Stored procedures ** EXEC [baker].[amcaslocal].[dbo].[AA_Disadvantaged_WordSearch_01] @lineup_input_appl_id = $APPL_PERSON_ID$ I'm using the same syntax in all of my other procedure calls. The difference here being this is the only one that exists on a remote server. I've tested the syntax in query analyzer. I'm not sure what else it could be (syntax wise). Thanks for the help! Warren On 6/2/08, Dave Saville [EMAIL PROTECTED] wrote: Warren Are you sure you have the correct invocation syntax in Remedy? ISTR it is a bit picky. -- Regards Dave Saville ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are -- Warren R. Baltimore II Remedy Developer UW Medicine IT Services School of Medicine University of Washington Box 358220 1325 Fourth Ave, Suite 2000 Seattle, WA 98101 The opinions expressed in this e-mail are in no way those of the University of Washington, or the State of Washington. They are my own. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ -- Warren R. Baltimore II Remedy Developer UW Medicine IT Services School of Medicine University of Washington Box 358220 1325 Fourth Ave, Suite 2000 Seattle, WA 98101 The opinions expressed in this e-mail are in no way those of the University of Washington, or the State of Washington. They are my own. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: SQL Stored procedures
Warren when you tested the syntax in query analyzer. Did you log in as ARADMIN?, that for check if you have the right permissions, check this out and if you have the permissions, verify the syntax on procedure (OUTPUT parameters) Pavel - Original Message From: Joe DeSouza [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, June 2, 2008 1:42:06 PM Subject: Re: SQL Stored procedures ** Does the ARSystem database user aradmin have permissions to the store proceedure? Does aradmin have permissions to the DB link and any other resource that the stored proceedure may be using? Joe - Original Message From: Warren Baltimore [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, June 2, 2008 12:42:33 PM Subject: Re: SQL Stored procedures ** EXEC [baker].[amcaslocal].[dbo].[AA_Disadvantaged_WordSearch_01] @lineup_input_appl_id = $APPL_PERSON_ID$ I'm using the same syntax in all of my other procedure calls. The difference here being this is the only one that exists on a remote server. I've tested the syntax in query analyzer. I'm not sure what else it could be (syntax wise). Thanks for the help! Warren On 6/2/08, Dave Saville [EMAIL PROTECTED] wrote: Warren Are you sure you have the correct invocation syntax in Remedy? ISTR it is a bit picky. -- Regards Dave Saville ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are -- Warren R. Baltimore II Remedy Developer UW Medicine IT Services School of Medicine University of Washington Box 358220 1325 Fourth Ave, Suite 2000 Seattle, WA 98101 The opinions expressed in this e-mail are in no way those of the University of Washington, or the State of Washington. They are my own. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Midtier Issues Turn Into Gross BMC Incompetence
Yea...I can understand up to point 6but after that is just weird and definitely shouldn't be done on a production server. 1. Go to the Admin tool and open that form FORM and Save as that form with the different name e.g. FORM-new 2. Rename original form FORM to FORM-old (This is your actual form...with data and stuff) 3. Now rename FORM-new to FORM. (this puts a blank form into place using the original form name) 4. Delete the form FORM (removing blank form) 5. Rename FORM-old to FORM (rename original form from its new name to its original name) 6. Verify all the Active Links/Filters point to FORM 7. Export the *.def file of FORM 8. Delete the form FORM 9. Create new form name it FORM 10. Verify all the Active Links/Filter point to FORM -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Paul Blasquez Sent: Monday, June 02, 2008 12:37 PM To: arslist@ARSLIST.ORG Subject: Midtier Issues Turn Into Gross BMC Incompetence Hello, I'm a little upset here, as I have received instructions from BMC, that had I carried them out blindly on my production server, would have completely wiped out any workflow and data I had not backed up, and with no warning from BMC. I would like to share these instructions here, and get opinions as to whether I am totally misunderstanding the instructions, or if I was given incomplete and dangerous instructions by an incompetent BMC tech. The problem was, originally, that when my form was called from the midtier via a table or results list, the browser would display the form as blank even though a specific request id was requested. So, double click the ticket, window opens, form is blank instead of filled in with that ticket's contents. All workflow works fine in the user client. So, after minor troubleshooting with BMC they finally request the .def file, I send it. They get back to me with the following instructions (object name replaced by FORM): 1. Go to the Admin tool and open that form FORM and Save as that form with the different name e.g. FORM-new 2. Rename original form FORM to FORM-old 3. Now rename FORM-new to FORM. 4. Delete the form FORM 5. Rename FORM-old to FORM 6. Verify all the Active Links/Filters point to FORM 7. Export the *.def file of FORM 8. Delete the form FORM 9. Create new form name it FORM 10. Verify all the Active Links/Filter point to FORM Now the issue with this, and thank goodness I did this on my development server first, is that at step 8, YOU DESTROY ALL YOUR DATA AND WORKFLOW. Making steps 9 and 10 irrelevant. Even given the fact that I could have implied that at step 7 I should have exported the entire workflow for that form, there is still no step that says back up your data, and there are no steps explaining importing back your workflow and data. Please give me your points of view on this situation because I am trying to not write a scathing email or make a hostile phone call right now. Paul Blasquez Senior Network Engineer/Remedy Developer | Desk - 408.360.5220 | Cell - 408.627.5714 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Midtier Issues Turn Into Gross BMC Incompetence
I agree your instructions are incomplete although it's a basic rule that when you delete a form all data goes with it. Perhaps the tech ass-u-me-d everyone knows this. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa Sent: Monday, June 02, 2008 12:08 PM To: arslist@ARSLIST.ORG Subject: Re: Midtier Issues Turn Into Gross BMC Incompetence They need a Step 4a: Make sure your company is equipped with a defibrillator, as you will need this for coming back from a heart attack from finding out that you've just deleted all your workflow Lisa -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Paul Blasquez Sent: Monday, June 02, 2008 2:37 PM To: arslist@ARSLIST.ORG Subject: Midtier Issues Turn Into Gross BMC Incompetence Hello, I'm a little upset here, as I have received instructions from BMC, that had I carried them out blindly on my production server, would have completely wiped out any workflow and data I had not backed up, and with no warning from BMC. I would like to share these instructions here, and get opinions as to whether I am totally misunderstanding the instructions, or if I was given incomplete and dangerous instructions by an incompetent BMC tech. The problem was, originally, that when my form was called from the midtier via a table or results list, the browser would display the form as blank even though a specific request id was requested. So, double click the ticket, window opens, form is blank instead of filled in with that ticket's contents. All workflow works fine in the user client. So, after minor troubleshooting with BMC they finally request the .def file, I send it. They get back to me with the following instructions (object name replaced by FORM): 1. Go to the Admin tool and open that form FORM and Save as that form with the different name e.g. FORM-new 2. Rename original form FORM to FORM-old 3. Now rename FORM-new to FORM. 4. Delete the form FORM 5. Rename FORM-old to FORM 6. Verify all the Active Links/Filters point to FORM 7. Export the *.def file of FORM 8. Delete the form FORM 9. Create new form name it FORM 10. Verify all the Active Links/Filter point to FORM Now the issue with this, and thank goodness I did this on my development server first, is that at step 8, YOU DESTROY ALL YOUR DATA AND WORKFLOW. Making steps 9 and 10 irrelevant. Even given the fact that I could have implied that at step 7 I should have exported the entire workflow for that form, there is still no step that says back up your data, and there are no steps explaining importing back your workflow and data. Please give me your points of view on this situation because I am trying to not write a scathing email or make a hostile phone call right now. Paul Blasquez Senior Network Engineer/Remedy Developer | Desk - 408.360.5220 | Cell - 408.627.5714 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: ARERROR.LOG Entries
Michael, I saw following filters running Application-Delete-Entry process for Sys:Action form SYS:ACT:DeleteOnSubmit_050 SYS:ACT:DeleteOnModify_050 SYS:ACT:DELETEENTRIES_400 To pinpoint the exact filter please enable your filter log and fix workflow accordingly. Hope this helps. Thanks Manjinder Singh On Mon, Jun 2, 2008 at 12:41 PM, Michael Ziniti [EMAIL PROTECTED] wrote: ** The only other error I see is: 390603 : Name parameter (or name field in parameter) is empty : 300427600 (ARERR 102) I've also done a search for AL and Escalations that access that form and there are no AL and just one Escalation which I don't think is causing this b/c its set to run every minute and the error doesn't happen that often. However, there are quite a few filters which touch this form. I guess I have to see which one is causing the error. Michael Ziniti DCO - ITAM San Francisco Direct: 925-974-5273 Cell: 516-729-8150 AIM: MikePZiniti -- *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Manjinder Singh *Sent:* Monday, June 02, 2008 8:23 AM *To:* arslist@ARSLIST.ORG *Subject:* Re: ARERROR.LOG Entries ** Basically some workflow is running application-delete-entry to delete rows in Sys:Action form .In this particular case Request ID 0003506. There should be more specific error message as well. Can you please forward that as well. Thanks Manjinder On Mon, Jun 2, 2008 at 9:24 AM, versicle [EMAIL PROTECTED] wrote: Hi All, We have multiple entries in our arerror.log file similiar to the one below: Mon Jun 2 07:27:59 2008 390620 : Failure during an attempt to perform an appli cation command (ARERR 4554) Mon Jun 2 07:27:59 2008 Application-Delete-Entry SYS:Action 0003506 Does anyone know what this means and how do correct it? We are running ARS 7.1 patch 001 and IM 7.0.03 patch 004. Thanks, Mike -- View this message in context: http://www.nabble.com/ARERROR.LOG-Entries-tp17601274p17601274.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are -- Manjinder Singh __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the email by you is prohibited. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ -- Manjinder Singh ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Midtier Issues Turn Into Gross BMC Incompetence
I have been having it out with support regularly this year, especially over idiotic recommendations and faulty fixes (often to code that never should have left the developer's workstation in the first place), some of which would have had significant unintended consequences had I been foolish enough to implement them in production. I too have trashed a development server with at least one of them. It is all part of the new improved BMC support structure, and is prevalent in _some_ support areas (SLM, DSL) or if you don't get past the first-line folks overseas. I am actually surprised that you got something so stupid on a mid-tier problem, but I may have been lucky on who got my tickets. I see wild variations between teams - ITSM 7 and RKM tickets have been getting immediate and accurate responses this year so far, as have the ARS / mid-tier / migratory issues so far. Some of the overseas techs have displayed remarkably little understanding of how data, workflow, and forms reside in the database structure when they propose a workaround, and that is probably what you got from someone. If you look at your notifications from support, most of them now include the direct email of the manager for that support team. Write them. If they do not respond, or if no manager reference is included in any of the transactions for your issue, only then could you consider a napalm-laden reply to the support tech. I guarantee that you will get attention with that - unwanted attention, perhaps, but attention. The current support situation will bring out the worst in the most patient person - and I have NEVER been accused of being a patient individual, especially when faced with gross incompetence. My advice is to get to the manager of the specific support person if you can; they need to take action to preclude similar instances of unwise recommendations in the future. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Paul Blasquez Sent: Monday, June 02, 2008 1:37 PM To: arslist@ARSLIST.ORG Subject: Midtier Issues Turn Into Gross BMC Incompetence Hello, I'm a little upset here, as I have received instructions from BMC, that had I carried them out blindly on my production server, would have completely wiped out any workflow and data I had not backed up, and with no warning from BMC. I would like to share these instructions here, and get opinions as to whether I am totally misunderstanding the instructions, or if I was given incomplete and dangerous instructions by an incompetent BMC tech. The problem was, originally, that when my form was called from the midtier via a table or results list, the browser would display the form as blank even though a specific request id was requested. So, double click the ticket, window opens, form is blank instead of filled in with that ticket's contents. All workflow works fine in the user client. So, after minor troubleshooting with BMC they finally request the .def file, I send it. They get back to me with the following instructions (object name replaced by FORM): 1. Go to the Admin tool and open that form FORM and Save as that form with the different name e.g. FORM-new 2. Rename original form FORM to FORM-old 3. Now rename FORM-new to FORM. 4. Delete the form FORM 5. Rename FORM-old to FORM 6. Verify all the Active Links/Filters point to FORM 7. Export the *.def file of FORM 8. Delete the form FORM 9. Create new form name it FORM 10. Verify all the Active Links/Filter point to FORM Now the issue with this, and thank goodness I did this on my development server first, is that at step 8, YOU DESTROY ALL YOUR DATA AND WORKFLOW. Making steps 9 and 10 irrelevant. Even given the fact that I could have implied that at step 7 I should have exported the entire workflow for that form, there is still no step that says back up your data, and there are no steps explaining importing back your workflow and data. Please give me your points of view on this situation because I am trying to not write a scathing email or make a hostile phone call right now. Paul Blasquez Senior Network Engineer/Remedy Developer | Desk - 408.360.5220 | Cell - 408.627.5714 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Midtier Issues Turn Into Gross BMC Incompetence
I'm assuming that all instances of FORM refer to the same form and form name. So why would he, in step 3, rename FORM.old to FORM if in step 4, FORM is just going to be deleted anyway? If that's true, and if this entire sequence has been accurately portrayed to us, it shows little thought or experience. I would deal with it at that level. Rick On Mon, Jun 2, 2008 at 12:15 PM, LJ Longwing [EMAIL PROTECTED] wrote: Yea...I can understand up to point 6but after that is just weird and definitely shouldn't be done on a production server. 1. Go to the Admin tool and open that form FORM and Save as that form with the different name e.g. FORM-new 2. Rename original form FORM to FORM-old (This is your actual form...with data and stuff) 3. Now rename FORM-new to FORM. (this puts a blank form into place using the original form name) 4. Delete the form FORM (removing blank form) 5. Rename FORM-old to FORM (rename original form from its new name to its original name) 6. Verify all the Active Links/Filters point to FORM 7. Export the *.def file of FORM 8. Delete the form FORM 9. Create new form name it FORM 10. Verify all the Active Links/Filter point to FORM -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Paul Blasquez Sent: Monday, June 02, 2008 12:37 PM To: arslist@ARSLIST.ORG Subject: Midtier Issues Turn Into Gross BMC Incompetence Hello, I'm a little upset here, as I have received instructions from BMC, that had I carried them out blindly on my production server, would have completely wiped out any workflow and data I had not backed up, and with no warning from BMC. I would like to share these instructions here, and get opinions as to whether I am totally misunderstanding the instructions, or if I was given incomplete and dangerous instructions by an incompetent BMC tech. The problem was, originally, that when my form was called from the midtier via a table or results list, the browser would display the form as blank even though a specific request id was requested. So, double click the ticket, window opens, form is blank instead of filled in with that ticket's contents. All workflow works fine in the user client. So, after minor troubleshooting with BMC they finally request the .def file, I send it. They get back to me with the following instructions (object name replaced by FORM): 1. Go to the Admin tool and open that form FORM and Save as that form with the different name e.g. FORM-new 2. Rename original form FORM to FORM-old 3. Now rename FORM-new to FORM. 4. Delete the form FORM 5. Rename FORM-old to FORM 6. Verify all the Active Links/Filters point to FORM 7. Export the *.def file of FORM 8. Delete the form FORM 9. Create new form name it FORM 10. Verify all the Active Links/Filter point to FORM Now the issue with this, and thank goodness I did this on my development server first, is that at step 8, YOU DESTROY ALL YOUR DATA AND WORKFLOW. Making steps 9 and 10 irrelevant. Even given the fact that I could have implied that at step 7 I should have exported the entire workflow for that form, there is still no step that says back up your data, and there are no steps explaining importing back your workflow and data. Please give me your points of view on this situation because I am trying to not write a scathing email or make a hostile phone call right now. Paul Blasquez Senior Network Engineer/Remedy Developer | Desk - 408.360.5220 | Cell - 408.627.5714 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: SQL Stored procedures
Try setting the [baker].[amcaslocal].[dbo] part to a field say $ServerTableOwner$ and then use EXEC $ServerTableOwner$.[AA_Disadvantaged_WordSearch_01] @lineup_input_appl_id = 160240 in your AL.. That may prevent the AR Server from removing the server name.. Joe - Original Message From: Warren Baltimore [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, June 2, 2008 2:59:12 PM Subject: Re: SQL Stored procedures ** Yes, I did check that the user was correct (ARAdmin) and that it has permissions. In fact, the stored procedure was authored by ARAdmin! Warren When we first built this procedure, it was running on a db that was on the Local Remedy SQL Server. The difference now is that it is being called from a linked server. When it is called by ARAdmin in the query analyzer using the following syntax, it works fine: EXEC [baker].[amcaslocal].[dbo].[AA_Disadvantaged_WordSearch_01] @lineup_input_appl_id = 160240 I am calling this from the Local Remedy Server by the way. When Remedy calls it, we have found that the server name [baker] is being dropped from the call. Warren On 6/2/08, Pavel Guedez [EMAIL PROTECTED] wrote: ** Warren when you tested the syntax in query analyzer. Did you log in as ARADMIN?, that for check if you have the right permissions, check this out and if you have the permissions, verify the syntax on procedure (OUTPUT parameters) Pavel - Original Message From: Joe DeSouza [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, June 2, 2008 1:42:06 PM Subject: Re: SQL Stored procedures ** Does the ARSystem database user aradmin have permissions to the store proceedure? Does aradmin have permissions to the DB link and any other resource that the stored proceedure may be using? Joe - Original Message From: Warren Baltimore [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, June 2, 2008 12:42:33 PM Subject: Re: SQL Stored procedures ** EXEC [baker].[amcaslocal].[dbo].[AA_Disadvantaged_WordSearch_01] @lineup_input_appl_id = $APPL_PERSON_ID$ I'm using the same syntax in all of my other procedure calls. The difference here being this is the only one that exists on a remote server. I've tested the syntax in query analyzer. I'm not sure what else it could be (syntax wise). Thanks for the help! Warren On 6/2/08, Dave Saville [EMAIL PROTECTED] wrote: Warren Are you sure you have the correct invocation syntax in Remedy? ISTR it is a bit picky. -- Regards Dave Saville ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are -- Warren R. Baltimore II Remedy Developer UW Medicine IT Services School of Medicine University of Washington Box 358220 1325 Fourth Ave, Suite 2000 Seattle, WA 98101 The opinions expressed in this e-mail are in no way those of the University of Washington, or the State of Washington. They are my own. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ -- Warren R. Baltimore II Remedy Developer UW Medicine IT Services School of Medicine University of Washington Box 358220 1325 Fourth Ave, Suite 2000 Seattle, WA 98101 The opinions expressed in this e-mail are in no way those of the University of Washington, or the State of Washington. They are my own. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Midtier Issues Turn Into Gross BMC Incompetence
It almost sounds like he could have saved you a lot of time by saying: 1) Export all active links, filters, menus, etc for FORM 2) Copy FORM to FORM-A 3) Delete FORM 4) Rename FORM-A to FORM 5) Re-import all active links, filters, menus, etc. Even with that said, below are some issues you might face: 1) Your new FORM will have a different schemaid, which would mess up any direct SQLs to that schema, as well as any DB Views you've created using it. 2) I think the WF would re-attach to the form if it has the same name, I don't think this goes off of schemaid, but I'm not really sure about that. 3) I still don't think this would solve the issue Thank goodness you did this on Dev first. Is the issue occurring in both dev and production? If so, check the name of the form to make sure there isn't an issue with it. Thanks, Gary Opela, Jr., RSP Remedy Engineer Leader Communications, Inc. http://www.5pointleader.com http://www.lcibest.com Best Product, Best People, Best PriceTM An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook Sent: Monday, June 02, 2008 2:28 PM To: arslist@ARSLIST.ORG Subject: Re: Midtier Issues Turn Into Gross BMC Incompetence ** I'm assuming that all instances of FORM refer to the same form and form name. So why would he, in step 3, rename FORM.old to FORM if in step 4, FORM is just going to be deleted anyway? If that's true, and if this entire sequence has been accurately portrayed to us, it shows little thought or experience. I would deal with it at that level. Rick On Mon, Jun 2, 2008 at 12:15 PM, LJ Longwing [EMAIL PROTECTED]mailto:[EMAIL PROTECTED] wrote: Yea...I can understand up to point 6but after that is just weird and definitely shouldn't be done on a production server. 1. Go to the Admin tool and open that form FORM and Save as that form with the different name e.g. FORM-new 2. Rename original form FORM to FORM-old (This is your actual form...with data and stuff) 3. Now rename FORM-new to FORM. (this puts a blank form into place using the original form name) 4. Delete the form FORM (removing blank form) 5. Rename FORM-old to FORM (rename original form from its new name to its original name) 6. Verify all the Active Links/Filters point to FORM 7. Export the *.def file of FORM 8. Delete the form FORM 9. Create new form name it FORM 10. Verify all the Active Links/Filter point to FORM -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of Paul Blasquez Sent: Monday, June 02, 2008 12:37 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Midtier Issues Turn Into Gross BMC Incompetence Hello, I'm a little upset here, as I have received instructions from BMC, that had I carried them out blindly on my production server, would have completely wiped out any workflow and data I had not backed up, and with no warning from BMC. I would like to share these instructions here, and get opinions as to whether I am totally misunderstanding the instructions, or if I was given incomplete and dangerous instructions by an incompetent BMC tech. The problem was, originally, that when my form was called from the midtier via a table or results list, the browser would display the form as blank even though a specific request id was requested. So, double click the ticket, window opens, form is blank instead of filled in with that ticket's contents. All workflow works fine in the user client. So, after minor troubleshooting with BMC they finally request the .def file, I send it. They get back to me with the following instructions (object name replaced by FORM): 1. Go to the Admin tool and open that form FORM and Save as that form with the different name e.g. FORM-new 2. Rename original form FORM to FORM-old 3. Now rename FORM-new to FORM. 4. Delete the form FORM 5. Rename FORM-old to FORM 6. Verify all the Active Links/Filters point to FORM 7. Export the *.def file of FORM 8. Delete the form FORM 9. Create new form name it FORM 10. Verify all the Active Links/Filter point to FORM Now the issue with this, and thank goodness I did this on my development server first, is that at step 8, YOU DESTROY ALL YOUR DATA AND WORKFLOW. Making steps 9 and 10 irrelevant. Even given the fact that I could have implied that at step 7 I should have exported the entire workflow for that form, there is still no step that says back up your data, and there are no steps explaining importing back your workflow and data. Please give me your points of view on this situation because I am trying to not write a scathing email or make a hostile phone call right now. Paul Blasquez Senior Network Engineer/Remedy Developer | Desk - 408.360.5220 | Cell - 408.627.5714
Re: Midtier Issues Turn Into Gross BMC Incompetence
Yes you are correct, except that he renamed FORM.new to FORM, then deleted it. I believe he was attempting to, for lack of a better term, shake things loose by running file writes on every conceivable storage location in the backend. The truly criminal step is step 8, as I said before. And yes, this is a direct copy-paste from his emails to me. Here is another (referencing the current solution): Did you tried the latest solution provided? it shouldn't cause any kind of losss. He states that because I had stated that it looked like I was going to lose data. I did not expect to also lose workflow. Thank you everyone who replied confirming my conclusions. I am currently escalating with the manager provided at the bottom of his email and our reseller. -Paul From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook Sent: Monday, June 02, 2008 12:28 PM To: arslist@ARSLIST.ORG Subject: Re: Midtier Issues Turn Into Gross BMC Incompetence ** I'm assuming that all instances of FORM refer to the same form and form name. So why would he, in step 3, rename FORM.old to FORM if in step 4, FORM is just going to be deleted anyway? If that's true, and if this entire sequence has been accurately portrayed to us, it shows little thought or experience. I would deal with it at that level. Rick On Mon, Jun 2, 2008 at 12:15 PM, LJ Longwing [EMAIL PROTECTED] wrote: Yea...I can understand up to point 6but after that is just weird and definitely shouldn't be done on a production server. 1. Go to the Admin tool and open that form FORM and Save as that form with the different name e.g. FORM-new 2. Rename original form FORM to FORM-old (This is your actual form...with data and stuff) 3. Now rename FORM-new to FORM. (this puts a blank form into place using the original form name) 4. Delete the form FORM (removing blank form) 5. Rename FORM-old to FORM (rename original form from its new name to its original name) 6. Verify all the Active Links/Filters point to FORM 7. Export the *.def file of FORM 8. Delete the form FORM 9. Create new form name it FORM 10. Verify all the Active Links/Filter point to FORM -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Paul Blasquez Sent: Monday, June 02, 2008 12:37 PM To: arslist@ARSLIST.ORG Subject: Midtier Issues Turn Into Gross BMC Incompetence Hello, I'm a little upset here, as I have received instructions from BMC, that had I carried them out blindly on my production server, would have completely wiped out any workflow and data I had not backed up, and with no warning from BMC. I would like to share these instructions here, and get opinions as to whether I am totally misunderstanding the instructions, or if I was given incomplete and dangerous instructions by an incompetent BMC tech. The problem was, originally, that when my form was called from the midtier via a table or results list, the browser would display the form as blank even though a specific request id was requested. So, double click the ticket, window opens, form is blank instead of filled in with that ticket's contents. All workflow works fine in the user client. So, after minor troubleshooting with BMC they finally request the .def file, I send it. They get back to me with the following instructions (object name replaced by FORM): 1. Go to the Admin tool and open that form FORM and Save as that form with the different name e.g. FORM-new 2. Rename original form FORM to FORM-old 3. Now rename FORM-new to FORM. 4. Delete the form FORM 5. Rename FORM-old to FORM 6. Verify all the Active Links/Filters point to FORM 7. Export the *.def file of FORM 8. Delete the form FORM 9. Create new form name it FORM 10. Verify all the Active Links/Filter point to FORM Now the issue with this, and thank goodness I did this on my development server first, is that at step 8, YOU DESTROY ALL YOUR DATA AND WORKFLOW. Making steps 9 and 10 irrelevant. Even given the fact that I could have implied that at step 7 I should have exported the entire workflow for that form, there is still no step that says back up your data, and there are no steps explaining importing back your workflow and data. Please give me your points of view on this situation because I
Re: Application-Delete-Query-Entry gives errors
Actually, I kind of did this sideways. I created a field in the TmpDelete form to hold the Form Name, and create one record for each Form that I might want to delete records from. The Escalation then fires on *'Status' = Active*, and runs *Application-Query-Delete-Entry $Form Name$ 'Status' = Sent* (which is good for both forms). Thanks again to all who helped me here, both on and offline. Rick On Fri, May 30, 2008 at 12:02 PM, Gary Opela (Corporate) [EMAIL PROTECTED] wrote: ** Rick, On this new form you created, add a field called Escalation Name, and have a Status values of Active and Inactive. This way, on your escalation, you can run it against this form where 'Escalation Name' = Name of the current escalation AND 'Status' = Active This allows you to use the form for multiple escalations in the future, and it also allows you to easily turn the escalation on and off without having to modify the escalation itself. Thanks, Gary Opela, Jr., RSP Remedy Engineer Leader Communications, Inc. http://www.5pointleader.com http://www.lcibest.com *Best Product, Best People, Best Price**TM* *An ISO 9001:2000 Certified, CMMI(R) Level 3 Rated Company*** -- *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Rick Cook *Sent:* Friday, May 30, 2008 1:49 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Application-Delete-Query-Entry gives errors ** RESOLVED. Thanks to all who contributed to my now-enhanced knowledge level. OK, here is what I've done to resolve this. I created a small form with just the core fields, and created one record in that form. I then restructured my escalation to go against that one-record form, running the Application-Query-Delete-Entry SHR:NotificationMessages ('Status' = Sent) from there. The escalation ran one time, and took 2.5 minutes to delete 62k records. No 302 errors. Yay! Rick On Fri, May 30, 2008 at 10:17 AM, Misi Mladoniczky [EMAIL PROTECTED] wrote: Hi, Does your escalation run on SHR:TmpMessages? I would run it on some scheduler form, and it should trigger once (one record). The normal way to find out what the problem is would be to turn on logging. What happens when you try to delete one record from the user tool? Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia: * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. * RRR|Translator - Manage and automate your language translations. Find these products, and many free tools and utilities, at http://rrr.se. We are running an escalation nightly that runs this command: *Application-Query-Delete-Entry SHR:TmpMessages (( 'Status' = Sent) AND ( 'Send Time' != $NULL$ ))*. The effect is to clear a form that contains records accumulated during the day, but which are no longer needed. Running this creates thousands of entries in the arerror.log file (roughly, but not exactly, equivalent to the number of records in the form) that say this: *Thu May 29 10:31:45 2008 390603 : Entry does not exist in database (ARERR 302)*. There are no errors that show up in the api or sql logs, and the records DO get deleted. Any idea why these errors appear? I'm kinda stumped as to where else to look for a cause. Rick ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are -- This message was scanned by ESVA and is believed to be clean. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Midtier Issues Turn Into Gross BMC Incompetence
Yes, that actually sounds much more sane, and I do not have anything built that is referencing schemaid. This is happening in both dev and production, trying versions 6.3 and 7.1 of Midtier. Both my dev and prod servers are: Solaris 9 Oracle 9iR2 Arsystem 6.3 patch 22 I guess there is no reason not to share the form name, it is: EQIX:SupportMain I have several other forms with the EQIX: prefix that do not suffer from this issue. -Paul From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Gary Opela (Corporate) Sent: Monday, June 02, 2008 12:46 PM To: arslist@ARSLIST.ORG Subject: Re: Midtier Issues Turn Into Gross BMC Incompetence ** It almost sounds like he could have saved you a lot of time by saying: 1) Export all active links, filters, menus, etc for FORM 2) Copy FORM to FORM-A 3) Delete FORM 4) Rename FORM-A to FORM 5) Re-import all active links, filters, menus, etc. Even with that said, below are some issues you might face: 1) Your new FORM will have a different schemaid, which would mess up any direct SQLs to that schema, as well as any DB Views you've created using it. 2) I think the WF would re-attach to the form if it has the same name, I don't think this goes off of schemaid, but I'm not really sure about that. 3) I still don't think this would solve the issue Thank goodness you did this on Dev first. Is the issue occurring in both dev and production? If so, check the name of the form to make sure there isn't an issue with it. Thanks, Gary Opela, Jr., RSP Remedy Engineer Leader Communications, Inc. http://www.5pointleader.com http://www.lcibest.com Best Product, Best People, Best PriceTM An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook Sent: Monday, June 02, 2008 2:28 PM To: arslist@ARSLIST.ORG Subject: Re: Midtier Issues Turn Into Gross BMC Incompetence ** I'm assuming that all instances of FORM refer to the same form and form name. So why would he, in step 3, rename FORM.old to FORM if in step 4, FORM is just going to be deleted anyway? If that's true, and if this entire sequence has been accurately portrayed to us, it shows little thought or experience. I would deal with it at that level. Rick On Mon, Jun 2, 2008 at 12:15 PM, LJ Longwing [EMAIL PROTECTED] wrote: Yea...I can understand up to point 6but after that is just weird and definitely shouldn't be done on a production server. 1. Go to the Admin tool and open that form FORM and Save as that form with the different name e.g. FORM-new 2. Rename original form FORM to FORM-old (This is your actual form...with data and stuff) 3. Now rename FORM-new to FORM. (this puts a blank form into place using the original form name) 4. Delete the form FORM (removing blank form) 5. Rename FORM-old to FORM (rename original form from its new name to its original name) 6. Verify all the Active Links/Filters point to FORM 7. Export the *.def file of FORM 8. Delete the form FORM 9. Create new form name it FORM 10. Verify all the Active Links/Filter point to FORM -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Paul Blasquez Sent: Monday, June 02, 2008 12:37 PM To: arslist@ARSLIST.ORG Subject: Midtier Issues Turn Into Gross BMC Incompetence Hello, I'm a little upset here, as I have received instructions from BMC, that had I carried them out blindly on my production server, would have completely wiped out any workflow and data I had not backed up, and with no warning from BMC. I would like to share these instructions here, and get opinions as to whether I am totally misunderstanding the instructions, or if I was given incomplete and dangerous instructions by an incompetent BMC tech. The problem was, originally, that when my form was called from the midtier via a table or results list, the browser would display the form as blank even though a specific request id was requested. So, double click the ticket, window opens, form is blank instead of filled in with that ticket's contents. All workflow works fine in the user client. So, after minor troubleshooting with BMC they finally request the .def file, I send it. They get back to me with the following instructions (object name replaced by FORM): 1. Go to the Admin tool and open that form FORM and Save as that form with the different name e.g. FORM-new 2. Rename original form FORM to FORM-old 3. Now rename FORM-new to FORM. 4. Delete the form FORM 5. Rename FORM-old to FORM 6. Verify all the Active Links/Filters point to FORM 7. Export the *.def file of FORM 8. Delete the form FORM 9. Create new form name it FORM 10. Verify all the Active Links/Filter point to FORM Now the issue with this, and thank
Re: SQL Stored procedures - RESOLVED!
OkAfter much struggle, I discovered the fix. Instead of using Linked Servers, I needed to set up Remote Servers for each server on the source and target servers. This allowed the sp to go through! Thanks for all the good thoughts everyone! Warren On 6/2/08, Joe DeSouza [EMAIL PROTECTED] wrote: ** Try setting the [baker].[amcaslocal].[dbo] part to a field say $ServerTableOwner$ and then use EXEC $ServerTableOwner$.[AA_Disadvantaged_WordSearch_01] @lineup_input_appl_id = 160240 in your AL.. That may prevent the AR Server from removing the server name.. Joe - Original Message From: Warren Baltimore [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, June 2, 2008 2:59:12 PM Subject: Re: SQL Stored procedures ** Yes, I did check that the user was correct (ARAdmin) and that it has permissions. In fact, the stored procedure was authored by ARAdmin! Warren When we first built this procedure, it was running on a db that was on the Local Remedy SQL Server. The difference now is that it is being called from a linked server. When it is called by ARAdmin in the query analyzer using the following syntax, it works fine: EXEC [baker].[amcaslocal].[dbo].[AA_Disadvantaged_WordSearch_01] @lineup_input_appl_id = 160240 I am calling this from the Local Remedy Server by the way. When Remedy calls it, we have found that the server name [baker] is being dropped from the call. Warren On 6/2/08, Pavel Guedez [EMAIL PROTECTED] wrote: ** Warren when you tested the syntax in query analyzer. Did you log in as ARADMIN?, that for check if you have the right permissions, check this out and if you have the permissions, verify the syntax on procedure (OUTPUT parameters) Pavel - Original Message From: Joe DeSouza [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, June 2, 2008 1:42:06 PM Subject: Re: SQL Stored procedures ** Does the ARSystem database user aradmin have permissions to the store proceedure? Does aradmin have permissions to the DB link and any other resource that the stored proceedure may be using? Joe - Original Message From: Warren Baltimore [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, June 2, 2008 12:42:33 PM Subject: Re: SQL Stored procedures ** EXEC [baker].[amcaslocal].[dbo].[AA_Disadvantaged_WordSearch_01] @lineup_input_appl_id = $APPL_PERSON_ID$ I'm using the same syntax in all of my other procedure calls. The difference here being this is the only one that exists on a remote server. I've tested the syntax in query analyzer. I'm not sure what else it could be (syntax wise). Thanks for the help! Warren On 6/2/08, Dave Saville [EMAIL PROTECTED] wrote: Warren Are you sure you have the correct invocation syntax in Remedy? ISTR it is a bit picky. -- Regards Dave Saville ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are -- Warren R. Baltimore II Remedy Developer UW Medicine IT Services School of Medicine University of Washington Box 358220 1325 Fourth Ave, Suite 2000 Seattle, WA 98101 The opinions expressed in this e-mail are in no way those of the University of Washington, or the State of Washington. They are my own. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ -- Warren R. Baltimore II Remedy Developer UW Medicine IT Services School of Medicine University of Washington Box 358220 1325 Fourth Ave, Suite 2000 Seattle, WA 98101 The opinions expressed in this e-mail are in no way those of the University of Washington, or the State of Washington. They are my own. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ -- Warren R. Baltimore II Remedy Developer UW Medicine IT Services School of Medicine University of Washington Box 358220 1325 Fourth Ave, Suite 2000 Seattle, WA 98101 The opinions expressed in this e-mail are in no way those of the University of Washington, or the State of Washington. They are my own. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Midtier Issues Turn Into Gross BMC Incompetence
I love a good rant against BMC Support as much as the next person, but I'd like to see your problem resolved too. Can you give us more information that might help determine what the problem is? To start, are you using the Drill Down on the Table Field, or are you trying to open that record with an Active Link? If it's via an Active Link, can you send us more information on the Open Window command? If I was in your shoes, I would run Active Link logs and try to reproduce it in both the User Tool and on the Mid Tier, then compare those log files and see what's happening. My guess would be that something potentially happens in one of those few areas where there is a difference in the two, such as how Display/Windows Loaded for the Execute On are different, or perhaps the timing works differently and some workflow that has a lower execution order takes longer and a later one does it's action first, or something weird. Still, it should be something you can figure out by looking at the logs from both. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Paul Blasquez Sent: Monday, June 02, 2008 1:37 PM To: arslist@ARSLIST.ORG Subject: Midtier Issues Turn Into Gross BMC Incompetence Hello, I'm a little upset here, as I have received instructions from BMC, that had I carried them out blindly on my production server, would have completely wiped out any workflow and data I had not backed up, and with no warning from BMC. I would like to share these instructions here, and get opinions as to whether I am totally misunderstanding the instructions, or if I was given incomplete and dangerous instructions by an incompetent BMC tech. The problem was, originally, that when my form was called from the midtier via a table or results list, the browser would display the form as blank even though a specific request id was requested. So, double click the ticket, window opens, form is blank instead of filled in with that ticket's contents. All workflow works fine in the user client. So, after minor troubleshooting with BMC they finally request the .def file, I send it. They get back to me with the following instructions (object name replaced by FORM): 1. Go to the Admin tool and open that form FORM and Save as that form with the different name e.g. FORM-new 2. Rename original form FORM to FORM-old 3. Now rename FORM-new to FORM. 4. Delete the form FORM 5. Rename FORM-old to FORM 6. Verify all the Active Links/Filters point to FORM 7. Export the *.def file of FORM 8. Delete the form FORM 9. Create new form name it FORM 10. Verify all the Active Links/Filter point to FORM Now the issue with this, and thank goodness I did this on my development server first, is that at step 8, YOU DESTROY ALL YOUR DATA AND WORKFLOW. Making steps 9 and 10 irrelevant. Even given the fact that I could have implied that at step 7 I should have exported the entire workflow for that form, there is still no step that says back up your data, and there are no steps explaining importing back your workflow and data. Please give me your points of view on this situation because I am trying to not write a scathing email or make a hostile phone call right now. Paul Blasquez Senior Network Engineer/Remedy Developer | Desk - 408.360.5220 | Cell - 408.627.5714 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are Private and confidential as detailed here: http://www.sug.com/disclaimers/default.htm#Mail . If you cannot access the link, please e-mail sender. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Midtier Issues Turn Into Gross BMC Incompetence
But if FORM has any records associated with it, copying FORM to FORM-A will copy the form's layout and field structure, but the underlying records won't go with it. Thus, once you perform step 3, you lose all your data. I think the bottom line is, deleting forms to rectify a Midtier problem is just plain dumb...it's like using a nuclear bomb when a bullet will do. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Gary Opela (Corporate) Sent: Monday, June 02, 2008 2:46 PM To: arslist@ARSLIST.ORG Subject: Re: Midtier Issues Turn Into Gross BMC Incompetence ** It almost sounds like he could have saved you a lot of time by saying: 1) Export all active links, filters, menus, etc for FORM 2) Copy FORM to FORM-A 3) Delete FORM 4) Rename FORM-A to FORM 5) Re-import all active links, filters, menus, etc. Even with that said, below are some issues you might face: 1) Your new FORM will have a different schemaid, which would mess up any direct SQLs to that schema, as well as any DB Views you've created using it. 2) I think the WF would re-attach to the form if it has the same name, I don't think this goes off of schemaid, but I'm not really sure about that. 3) I still don't think this would solve the issue Thank goodness you did this on Dev first. Is the issue occurring in both dev and production? If so, check the name of the form to make sure there isn't an issue with it. Thanks, Gary Opela, Jr., RSP Remedy Engineer Leader Communications, Inc. http://www.5pointleader.com http://www.lcibest.com Best Product, Best People, Best PriceTM An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook Sent: Monday, June 02, 2008 2:28 PM To: arslist@ARSLIST.ORG Subject: Re: Midtier Issues Turn Into Gross BMC Incompetence ** I'm assuming that all instances of FORM refer to the same form and form name. So why would he, in step 3, rename FORM.old to FORM if in step 4, FORM is just going to be deleted anyway? If that's true, and if this entire sequence has been accurately portrayed to us, it shows little thought or experience. I would deal with it at that level. Rick On Mon, Jun 2, 2008 at 12:15 PM, LJ Longwing [EMAIL PROTECTED] wrote: Yea...I can understand up to point 6but after that is just weird and definitely shouldn't be done on a production server. 1. Go to the Admin tool and open that form FORM and Save as that form with the different name e.g. FORM-new 2. Rename original form FORM to FORM-old (This is your actual form...with data and stuff) 3. Now rename FORM-new to FORM. (this puts a blank form into place using the original form name) 4. Delete the form FORM (removing blank form) 5. Rename FORM-old to FORM (rename original form from its new name to its original name) 6. Verify all the Active Links/Filters point to FORM 7. Export the *.def file of FORM 8. Delete the form FORM 9. Create new form name it FORM 10. Verify all the Active Links/Filter point to FORM -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Paul Blasquez Sent: Monday, June 02, 2008 12:37 PM To: arslist@ARSLIST.ORG Subject: Midtier Issues Turn Into Gross BMC Incompetence Hello, I'm a little upset here, as I have received instructions from BMC, that had I carried them out blindly on my production server, would have completely wiped out any workflow and data I had not backed up, and with no warning from BMC. I would like to share these instructions here, and get opinions as to whether I am totally misunderstanding the instructions, or if I was given incomplete and dangerous instructions by an incompetent BMC tech. The problem was, originally, that when my form was called from the midtier via a table or results list, the browser would display the form as blank even though a specific request id was requested. So, double click the ticket, window opens, form is blank instead of filled in with that ticket's contents. All workflow works fine in the user client. So, after minor troubleshooting with BMC they finally request the .def file, I send it. They get back to me with the following instructions (object name replaced by FORM): 1. Go to the Admin tool and open that form FORM and Save as that form with the different name e.g. FORM-new 2. Rename original form FORM to FORM-old 3. Now rename FORM-new to FORM. 4. Delete the form FORM 5. Rename FORM-old to FORM 6. Verify all the Active Links/Filters point to FORM 7. Export the *.def file of FORM 8. Delete the form FORM 9. Create new form name it FORM 10. Verify all the Active Links/Filter point to FORM Now the issue with this, and thank goodness I did this on my development server first, is that at step 8, YOU DESTROY ALL YOUR
Re: Midtier Issues Turn Into Gross BMC Incompetence
Thank you for the suggestions, unfortunately there is no smoking gun in the logs. It happens not only on a table drill down but also on a results list drill down. The only time it works as expected is when there is a results list on top of the form, as in a standard search. When you highlight a ticket there, it populates the form underneath. However, if you double-click the same ticket from the same results list, the new window fails to populate the data, and does not throw an error in either the server or midtier logs. BTW, I have finished importing my workflow and form back into development from production and the issue still exists. So, whatever write operations he hoped would clear the issue obviously did not work, as it has been blown away and restored and is still exhibiting the same behavior. -Paul -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Pierson, Shawn Sent: Monday, June 02, 2008 1:15 PM To: arslist@ARSLIST.ORG Subject: Re: Midtier Issues Turn Into Gross BMC Incompetence I love a good rant against BMC Support as much as the next person, but I'd like to see your problem resolved too. Can you give us more information that might help determine what the problem is? To start, are you using the Drill Down on the Table Field, or are you trying to open that record with an Active Link? If it's via an Active Link, can you send us more information on the Open Window command? If I was in your shoes, I would run Active Link logs and try to reproduce it in both the User Tool and on the Mid Tier, then compare those log files and see what's happening. My guess would be that something potentially happens in one of those few areas where there is a difference in the two, such as how Display/Windows Loaded for the Execute On are different, or perhaps the timing works differently and some workflow that has a lower execution order takes longer and a later one does it's action first, or something weird. Still, it should be something you can figure out by looking at the logs from both. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Paul Blasquez Sent: Monday, June 02, 2008 1:37 PM To: arslist@ARSLIST.ORG Subject: Midtier Issues Turn Into Gross BMC Incompetence Hello, I'm a little upset here, as I have received instructions from BMC, that had I carried them out blindly on my production server, would have completely wiped out any workflow and data I had not backed up, and with no warning from BMC. I would like to share these instructions here, and get opinions as to whether I am totally misunderstanding the instructions, or if I was given incomplete and dangerous instructions by an incompetent BMC tech. The problem was, originally, that when my form was called from the midtier via a table or results list, the browser would display the form as blank even though a specific request id was requested. So, double click the ticket, window opens, form is blank instead of filled in with that ticket's contents. All workflow works fine in the user client. So, after minor troubleshooting with BMC they finally request the .def file, I send it. They get back to me with the following instructions (object name replaced by FORM): 1. Go to the Admin tool and open that form FORM and Save as that form with the different name e.g. FORM-new 2. Rename original form FORM to FORM-old 3. Now rename FORM-new to FORM. 4. Delete the form FORM 5. Rename FORM-old to FORM 6. Verify all the Active Links/Filters point to FORM 7. Export the *.def file of FORM 8. Delete the form FORM 9. Create new form name it FORM 10. Verify all the Active Links/Filter point to FORM Now the issue with this, and thank goodness I did this on my development server first, is that at step 8, YOU DESTROY ALL YOUR DATA AND WORKFLOW. Making steps 9 and 10 irrelevant. Even given the fact that I could have implied that at step 7 I should have exported the entire workflow for that form, there is still no step that says back up your data, and there are no steps explaining importing back your workflow and data. Please give me your points of view on this situation because I am trying to not write a scathing email or make a hostile phone call right now. Paul Blasquez Senior Network Engineer/Remedy Developer | Desk - 408.360.5220 | Cell - 408.627.5714 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are Private and confidential as detailed here: http://www.sug.com/disclaimers/default.htm#Mail . If you cannot access the link, please e-mail sender. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the
Re: Midtier Issues Turn Into Gross BMC Incompetence
I hate those types of issues and wish you good luck. That sounds like a problem with the core functionality, and the BMC support rep should have involved Engineering by now. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Paul Blasquez Sent: Monday, June 02, 2008 3:38 PM To: arslist@ARSLIST.ORG Subject: Re: Midtier Issues Turn Into Gross BMC Incompetence Thank you for the suggestions, unfortunately there is no smoking gun in the logs. It happens not only on a table drill down but also on a results list drill down. The only time it works as expected is when there is a results list on top of the form, as in a standard search. When you highlight a ticket there, it populates the form underneath. However, if you double-click the same ticket from the same results list, the new window fails to populate the data, and does not throw an error in either the server or midtier logs. BTW, I have finished importing my workflow and form back into development from production and the issue still exists. So, whatever write operations he hoped would clear the issue obviously did not work, as it has been blown away and restored and is still exhibiting the same behavior. -Paul -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Pierson, Shawn Sent: Monday, June 02, 2008 1:15 PM To: arslist@ARSLIST.ORG Subject: Re: Midtier Issues Turn Into Gross BMC Incompetence I love a good rant against BMC Support as much as the next person, but I'd like to see your problem resolved too. Can you give us more information that might help determine what the problem is? To start, are you using the Drill Down on the Table Field, or are you trying to open that record with an Active Link? If it's via an Active Link, can you send us more information on the Open Window command? If I was in your shoes, I would run Active Link logs and try to reproduce it in both the User Tool and on the Mid Tier, then compare those log files and see what's happening. My guess would be that something potentially happens in one of those few areas where there is a difference in the two, such as how Display/Windows Loaded for the Execute On are different, or perhaps the timing works differently and some workflow that has a lower execution order takes longer and a later one does it's action first, or something weird. Still, it should be something you can figure out by looking at the logs from both. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Paul Blasquez Sent: Monday, June 02, 2008 1:37 PM To: arslist@ARSLIST.ORG Subject: Midtier Issues Turn Into Gross BMC Incompetence Hello, I'm a little upset here, as I have received instructions from BMC, that had I carried them out blindly on my production server, would have completely wiped out any workflow and data I had not backed up, and with no warning from BMC. I would like to share these instructions here, and get opinions as to whether I am totally misunderstanding the instructions, or if I was given incomplete and dangerous instructions by an incompetent BMC tech. The problem was, originally, that when my form was called from the midtier via a table or results list, the browser would display the form as blank even though a specific request id was requested. So, double click the ticket, window opens, form is blank instead of filled in with that ticket's contents. All workflow works fine in the user client. So, after minor troubleshooting with BMC they finally request the .def file, I send it. They get back to me with the following instructions (object name replaced by FORM): 1. Go to the Admin tool and open that form FORM and Save as that form with the different name e.g. FORM-new 2. Rename original form FORM to FORM-old 3. Now rename FORM-new to FORM. 4. Delete the form FORM 5. Rename FORM-old to FORM 6. Verify all the Active Links/Filters point to FORM 7. Export the *.def file of FORM 8. Delete the form FORM 9. Create new form name it FORM 10. Verify all the Active Links/Filter point to FORM Now the issue with this, and thank goodness I did this on my development server first, is that at step 8, YOU DESTROY ALL YOUR DATA AND WORKFLOW. Making steps 9 and 10 irrelevant. Even given the fact that I could have implied that at step 7 I should have exported the entire workflow for that form, there is still no step that says back up your data, and there are no steps explaining importing back your workflow and data. Please give me your points of view on this situation because I am trying to not write a scathing email or make a hostile phone call right now. Paul Blasquez Senior Network Engineer/Remedy Developer | Desk - 408.360.5220 | Cell - 408.627.5714 ___ UNSUBSCRIBE or access ARSlist Archives at
Re: Midtier Issues Turn Into Gross BMC Incompetence
I agree with Shawn, something deeper is amiss. It sounds like a permissions issue -- where the user has permission to the form, but none of the fields. Unfortunately for you, if this where the issue, then you wouldn't have a results list with any data, or a table with any data, so this obviously isn't the issue. Good luck with the fix, and PLEASE let us know what the issue was (even if it was something easy, then we all overlooked it). Thanks, Gary Opela, Jr., RSP Remedy Engineer Leader Communications, Inc. http://www.5pointleader.com http://www.lcibest.com Best Product, Best People, Best PriceTM An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Pierson, Shawn Sent: Monday, June 02, 2008 3:40 PM To: arslist@ARSLIST.ORG Subject: Re: Midtier Issues Turn Into Gross BMC Incompetence I hate those types of issues and wish you good luck. That sounds like a problem with the core functionality, and the BMC support rep should have involved Engineering by now. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Paul Blasquez Sent: Monday, June 02, 2008 3:38 PM To: arslist@ARSLIST.ORG Subject: Re: Midtier Issues Turn Into Gross BMC Incompetence Thank you for the suggestions, unfortunately there is no smoking gun in the logs. It happens not only on a table drill down but also on a results list drill down. The only time it works as expected is when there is a results list on top of the form, as in a standard search. When you highlight a ticket there, it populates the form underneath. However, if you double-click the same ticket from the same results list, the new window fails to populate the data, and does not throw an error in either the server or midtier logs. BTW, I have finished importing my workflow and form back into development from production and the issue still exists. So, whatever write operations he hoped would clear the issue obviously did not work, as it has been blown away and restored and is still exhibiting the same behavior. -Paul -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Pierson, Shawn Sent: Monday, June 02, 2008 1:15 PM To: arslist@ARSLIST.ORG Subject: Re: Midtier Issues Turn Into Gross BMC Incompetence I love a good rant against BMC Support as much as the next person, but I'd like to see your problem resolved too. Can you give us more information that might help determine what the problem is? To start, are you using the Drill Down on the Table Field, or are you trying to open that record with an Active Link? If it's via an Active Link, can you send us more information on the Open Window command? If I was in your shoes, I would run Active Link logs and try to reproduce it in both the User Tool and on the Mid Tier, then compare those log files and see what's happening. My guess would be that something potentially happens in one of those few areas where there is a difference in the two, such as how Display/Windows Loaded for the Execute On are different, or perhaps the timing works differently and some workflow that has a lower execution order takes longer and a later one does it's action first, or something weird. Still, it should be something you can figure out by looking at the logs from both. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Paul Blasquez Sent: Monday, June 02, 2008 1:37 PM To: arslist@ARSLIST.ORG Subject: Midtier Issues Turn Into Gross BMC Incompetence Hello, I'm a little upset here, as I have received instructions from BMC, that had I carried them out blindly on my production server, would have completely wiped out any workflow and data I had not backed up, and with no warning from BMC. I would like to share these instructions here, and get opinions as to whether I am totally misunderstanding the instructions, or if I was given incomplete and dangerous instructions by an incompetent BMC tech. The problem was, originally, that when my form was called from the midtier via a table or results list, the browser would display the form as blank even though a specific request id was requested. So, double click the ticket, window opens, form is blank instead of filled in with that ticket's contents. All workflow works fine in the user client. So, after minor troubleshooting with BMC they finally request the .def file, I send it. They get back to me with the following instructions (object name replaced by FORM): 1. Go to the Admin tool and open that form FORM and Save as that form with the different name e.g. FORM-new 2. Rename original form FORM to FORM-old 3. Now rename FORM-new to FORM. 4. Delete the form FORM 5. Rename FORM-old to FORM 6. Verify all the Active Links/Filters point to FORM 7. Export the *.def
Re: Issue installing itsm patch 7
You might want to check if you have enough space in the drive that holds your system Temp folder.. From the sound of it, it may be a packing list error - failure to build a packing list which happens if there isnt enough space in the temp folder. Joe - Original Message From: Howard Richter [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, June 2, 2008 12:24:37 PM Subject: Re: Issue installing itsm patch 7 ** Ouch, so it looks like that system will need to stay at patch 6, unless someone has found a workaround. Thanks for the info, Howard On 6/2/08, Rick Cook [EMAIL PROTECTED] wrote: ** Is this one of those patches that is trying to validate its prereqs and such before actually installing anything? I know that is a promised 7.5 function, and that they've been working in that direction even in 7.x, but I don't know if they're there yet. Rick On Mon, Jun 2, 2008 at 9:11 AM, Rune Sorlid [EMAIL PROTECTED] wrote: ** Got the same errormessage, only on VMWare Machines /Rune Sorlid 2008/6/2 Howard Richter [EMAIL PROTECTED]: ** Good morning all, Has anyone seen the error Unable to build patch summary when runing itsm 7 patch 7? And if so any ideas on what could be going on? The apps are at 7.0.3 patch 6. Thanks, -- Howard Richter __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ -- Howard Richter Red Hat Certified Technician CompTIA Linux+ Certified ITIL Foundation Certified E-Mail = [EMAIL PROTECTED] Resume = http://www.richter-home.net/resume/ LinkedIn Profile = http://www.linkedin.com/in/hbr4270 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Midtier Issues Turn Into Gross BMC Incompetence
Hello All, I am happy to report that within 5 minutes of getting a new support tech my issue is resolved! And it is so simple as to make my blood boil further from the previous help I received. The answer? Under Form-Current View-Properties-Advanced Results List Change No Selection to Select First, Fire Workflow. I don't know whether to be elated or tear out my hair or do the latter in a joyous fashion. :) -Paul -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Gary Opela (Corporate) Sent: Monday, June 02, 2008 1:48 PM To: arslist@ARSLIST.ORG Subject: Re: Midtier Issues Turn Into Gross BMC Incompetence I agree with Shawn, something deeper is amiss. It sounds like a permissions issue -- where the user has permission to the form, but none of the fields. Unfortunately for you, if this where the issue, then you wouldn't have a results list with any data, or a table with any data, so this obviously isn't the issue. Good luck with the fix, and PLEASE let us know what the issue was (even if it was something easy, then we all overlooked it). Thanks, Gary Opela, Jr., RSP Remedy Engineer Leader Communications, Inc. http://www.5pointleader.com http://www.lcibest.com Best Product, Best People, Best PriceTM An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Pierson, Shawn Sent: Monday, June 02, 2008 3:40 PM To: arslist@ARSLIST.ORG Subject: Re: Midtier Issues Turn Into Gross BMC Incompetence I hate those types of issues and wish you good luck. That sounds like a problem with the core functionality, and the BMC support rep should have involved Engineering by now. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Paul Blasquez Sent: Monday, June 02, 2008 3:38 PM To: arslist@ARSLIST.ORG Subject: Re: Midtier Issues Turn Into Gross BMC Incompetence Thank you for the suggestions, unfortunately there is no smoking gun in the logs. It happens not only on a table drill down but also on a results list drill down. The only time it works as expected is when there is a results list on top of the form, as in a standard search. When you highlight a ticket there, it populates the form underneath. However, if you double-click the same ticket from the same results list, the new window fails to populate the data, and does not throw an error in either the server or midtier logs. BTW, I have finished importing my workflow and form back into development from production and the issue still exists. So, whatever write operations he hoped would clear the issue obviously did not work, as it has been blown away and restored and is still exhibiting the same behavior. -Paul -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Pierson, Shawn Sent: Monday, June 02, 2008 1:15 PM To: arslist@ARSLIST.ORG Subject: Re: Midtier Issues Turn Into Gross BMC Incompetence I love a good rant against BMC Support as much as the next person, but I'd like to see your problem resolved too. Can you give us more information that might help determine what the problem is? To start, are you using the Drill Down on the Table Field, or are you trying to open that record with an Active Link? If it's via an Active Link, can you send us more information on the Open Window command? If I was in your shoes, I would run Active Link logs and try to reproduce it in both the User Tool and on the Mid Tier, then compare those log files and see what's happening. My guess would be that something potentially happens in one of those few areas where there is a difference in the two, such as how Display/Windows Loaded for the Execute On are different, or perhaps the timing works differently and some workflow that has a lower execution order takes longer and a later one does it's action first, or something weird. Still, it should be something you can figure out by looking at the logs from both. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Paul Blasquez Sent: Monday, June 02, 2008 1:37 PM To: arslist@ARSLIST.ORG Subject: Midtier Issues Turn Into Gross BMC Incompetence Hello, I'm a little upset here, as I have received instructions from BMC, that had I carried them out blindly on my production server, would have completely wiped out any workflow and data I had not backed up, and with no warning from BMC. I would like to share these instructions here, and get opinions as to whether I am totally misunderstanding the instructions, or if I was given incomplete and dangerous instructions by an incompetent BMC tech. The problem was, originally, that when my form was called from the midtier via a table or results list, the browser would display the form as
Re: Midtier Issues Turn Into Gross BMC Incompetence
Three cheers for new support tech for finding the simple solution! I'll do the first... Hip-Hip-Hooray! Thanks, Gary Opela, Jr., RSP Remedy Engineer Leader Communications, Inc. http://www.5pointleader.com http://www.lcibest.com Best Product, Best People, Best PriceTM An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Paul Blasquez Sent: Monday, June 02, 2008 4:07 PM To: arslist@ARSLIST.ORG Subject: Re: Midtier Issues Turn Into Gross BMC Incompetence Hello All, I am happy to report that within 5 minutes of getting a new support tech my issue is resolved! And it is so simple as to make my blood boil further from the previous help I received. The answer? Under Form-Current View-Properties-Advanced Results List Change No Selection to Select First, Fire Workflow. I don't know whether to be elated or tear out my hair or do the latter in a joyous fashion. :) -Paul -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Gary Opela (Corporate) Sent: Monday, June 02, 2008 1:48 PM To: arslist@ARSLIST.ORG Subject: Re: Midtier Issues Turn Into Gross BMC Incompetence I agree with Shawn, something deeper is amiss. It sounds like a permissions issue -- where the user has permission to the form, but none of the fields. Unfortunately for you, if this where the issue, then you wouldn't have a results list with any data, or a table with any data, so this obviously isn't the issue. Good luck with the fix, and PLEASE let us know what the issue was (even if it was something easy, then we all overlooked it). Thanks, Gary Opela, Jr., RSP Remedy Engineer Leader Communications, Inc. http://www.5pointleader.com http://www.lcibest.com Best Product, Best People, Best PriceTM An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Pierson, Shawn Sent: Monday, June 02, 2008 3:40 PM To: arslist@ARSLIST.ORG Subject: Re: Midtier Issues Turn Into Gross BMC Incompetence I hate those types of issues and wish you good luck. That sounds like a problem with the core functionality, and the BMC support rep should have involved Engineering by now. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Paul Blasquez Sent: Monday, June 02, 2008 3:38 PM To: arslist@ARSLIST.ORG Subject: Re: Midtier Issues Turn Into Gross BMC Incompetence Thank you for the suggestions, unfortunately there is no smoking gun in the logs. It happens not only on a table drill down but also on a results list drill down. The only time it works as expected is when there is a results list on top of the form, as in a standard search. When you highlight a ticket there, it populates the form underneath. However, if you double-click the same ticket from the same results list, the new window fails to populate the data, and does not throw an error in either the server or midtier logs. BTW, I have finished importing my workflow and form back into development from production and the issue still exists. So, whatever write operations he hoped would clear the issue obviously did not work, as it has been blown away and restored and is still exhibiting the same behavior. -Paul -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Pierson, Shawn Sent: Monday, June 02, 2008 1:15 PM To: arslist@ARSLIST.ORG Subject: Re: Midtier Issues Turn Into Gross BMC Incompetence I love a good rant against BMC Support as much as the next person, but I'd like to see your problem resolved too. Can you give us more information that might help determine what the problem is? To start, are you using the Drill Down on the Table Field, or are you trying to open that record with an Active Link? If it's via an Active Link, can you send us more information on the Open Window command? If I was in your shoes, I would run Active Link logs and try to reproduce it in both the User Tool and on the Mid Tier, then compare those log files and see what's happening. My guess would be that something potentially happens in one of those few areas where there is a difference in the two, such as how Display/Windows Loaded for the Execute On are different, or perhaps the timing works differently and some workflow that has a lower execution order takes longer and a later one does it's action first, or something weird. Still, it should be something you can figure out by looking at the logs from both. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Paul Blasquez Sent: Monday, June 02, 2008 1:37 PM To: arslist@ARSLIST.ORG Subject: Midtier Issues Turn Into Gross BMC Incompetence
Re: Use of Roles in Deployable Application
LJ, David: thanks for your response. What if the role already exists in the destination server? Wouldn't I run into the same issue. For example: Source Server has a deployable application (appA) and a role (roleA). Let'z say this roleA has a group called Testers. I export this application. Destination server already has a different application (appB) and a role (roleA). If I import the application here, wouldn't that mess up appB? TIA Ravi LJ Longwing wrote: Additionally, Role ID's are specific to the application...which means that a deployable application can be dropped onto a new server, and have the roles mapped to existing groups on the new server without breaking anything. If it's a local application then the permissions are tied to a group id...if the group id that the application uses is already in use on the destination server...you are screwed...I believe that this architecture was setup so that Company A could sell an application to Company B without regard for if the group ID's the application was built on are already in use on the destination server -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ravi Sent: Monday, June 02, 2008 11:34 AM To: arslist@ARSLIST.ORG Subject: Use of Roles in Deployable Application Hi: I am trying to build a deployable application for the first time so I can migrate the application between test, development and production remedy servers. I read through the docs couple of times and still can't seem to understand the usage of roles. I know users are part of one or more group(s). A role can have one group when in Test and another group when in Production. Is that all: All roles does is provide access to the application to different set of users based on the deployable application state? So do the groups and roles have to exist on the destination arserver before exporting an imported application from my test server to the development arserver? Also looks like the advantage of using deployable application instead of local application is that it can be licensesed and tracked. Is that the only reason why someone would use deployable? TIA Ravi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Help with run process on a filter and UNIX mailx
Does anyone know if this is possible to do with Pager Service Provider Configuration form? If so, what would the Run Process command and the Flag entries be? Mike -- View this message in context: http://www.nabble.com/Help-with-run-process-on-a-filter-and-UNIX-mailx-tp10803556p17610453.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Midtier Issues Turn Into Gross BMC Incompetence
Hi Paul Sounds like you're having fun... not. Having got the form restored and hopefully some sample data back in it, perhaps it's time to see whether particular objects are causing the problem. Try copying your main form View so you have a copy of your layout, then remove all fields and trim objects from your main view (except one field) and see if that will open up in the Mid-Tier. Remember to flush the MT cache. It that works, move blocks of fields back into the view you are using and test again until the problem recurs. That way you may at least be able to see what object is causing the Mid-Tier to choke. I have seen strange MT problems with images, navigation menus etc. In the past when I have found the offending object, deleting and recreating it has solved the issue. If it is a data field you will need to plan how to retain the data (by moving it into and from a temporary storage field?) HTH David Sanders Remedy Solution Architect Enterprise Service Suite @ Work == ARS List Award Winner 2005 Best 3rd party Remedy Application See the ESS Concepts Guide tel +44 1494 468980 mobile +44 7710 377761 email [EMAIL PROTECTED] web http://www.westoverconsulting.co.uk -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Paul Blasquez Sent: Monday, June 02, 2008 9:38 PM To: arslist@ARSLIST.ORG Subject: Re: Midtier Issues Turn Into Gross BMC Incompetence Thank you for the suggestions, unfortunately there is no smoking gun in the logs. It happens not only on a table drill down but also on a results list drill down. The only time it works as expected is when there is a results list on top of the form, as in a standard search. When you highlight a ticket there, it populates the form underneath. However, if you double-click the same ticket from the same results list, the new window fails to populate the data, and does not throw an error in either the server or midtier logs. BTW, I have finished importing my workflow and form back into development from production and the issue still exists. So, whatever write operations he hoped would clear the issue obviously did not work, as it has been blown away and restored and is still exhibiting the same behavior. -Paul -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Pierson, Shawn Sent: Monday, June 02, 2008 1:15 PM To: arslist@ARSLIST.ORG Subject: Re: Midtier Issues Turn Into Gross BMC Incompetence I love a good rant against BMC Support as much as the next person, but I'd like to see your problem resolved too. Can you give us more information that might help determine what the problem is? To start, are you using the Drill Down on the Table Field, or are you trying to open that record with an Active Link? If it's via an Active Link, can you send us more information on the Open Window command? If I was in your shoes, I would run Active Link logs and try to reproduce it in both the User Tool and on the Mid Tier, then compare those log files and see what's happening. My guess would be that something potentially happens in one of those few areas where there is a difference in the two, such as how Display/Windows Loaded for the Execute On are different, or perhaps the timing works differently and some workflow that has a lower execution order takes longer and a later one does it's action first, or something weird. Still, it should be something you can figure out by looking at the logs from both. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Paul Blasquez Sent: Monday, June 02, 2008 1:37 PM To: arslist@ARSLIST.ORG Subject: Midtier Issues Turn Into Gross BMC Incompetence Hello, I'm a little upset here, as I have received instructions from BMC, that had I carried them out blindly on my production server, would have completely wiped out any workflow and data I had not backed up, and with no warning from BMC. I would like to share these instructions here, and get opinions as to whether I am totally misunderstanding the instructions, or if I was given incomplete and dangerous instructions by an incompetent BMC tech. The problem was, originally, that when my form was called from the midtier via a table or results list, the browser would display the form as blank even though a specific request id was requested. So, double click the ticket, window opens, form is blank instead of filled in with that ticket's contents. All workflow works fine in the user client. So, after minor troubleshooting with BMC they finally request the .def file, I send it. They get back to me with the following instructions (object name replaced by FORM): 1. Go to the Admin tool and open that form FORM and Save as that form with the different name e.g. FORM-new 2. Rename original form FORM to FORM-old 3. Now rename FORM-new to FORM. 4.
Re: Help with run process on a filter and UNIX mailx
Ignore my last post. I forgot to include the thread. Does anyone know if this is possible to do with Pager Service Provider Configuration form? If so, what would the Run Process command and the Flag entries be? Howard Richter-2 wrote: Good morning all and happy Friday, I need a little help with the run process on a filter and UNIX mailx. I am trying to use mailx to send a e-mail to a pager. We have it almost working (that is we can get 54 charters to be passed to the pager) by using this /usr/bin/mailx -r [EMAIL PROTECTED] -s $Pager Message Alpha$ $E-mail Pager NT$. However I would like to try and get the full 128. The 54 charters limit is due to a limitation with the subject line in mailx. I have tried this (/usr/bin/mailx -r [EMAIL PROTECTED] -s test $E-mail Pager NT$ $Pager Message Alpha$) and this (/usr/bin/cat $Pager Message Alpha$ | /usr/bin/mailx -r [EMAIL PROTECTED] -s test $E-mail Pager NT$ ) with no luck. Any ideas on what to pass from the run process command line, to get this to work? Thank you in advance for any help and think about the quote by Albert Einstein below this Memorial Day We must be prepared to make heroic sacrifices for the cause of peace that we make ungrudgingly for the cause of war. There is no task that is more important or closer to my heart. -- Howard Richter Remedy ServiceDesk Manager Red Hat Certified Technician CompTIA Linux+ Certified CedarCrestone Managed Services Center [EMAIL PROTECTED] ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are -- View this message in context: http://www.nabble.com/Help-with-run-process-on-a-filter-and-UNIX-mailx-tp10803556p17610913.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Use of Roles in Deployable Application
Hi Ravi The Role name is not important - you could have a Role called Managers in AppA and AppB. The real identifier is the Role ID (negative number) and the Application Name which identifies what application it belongs to. HTH David Sanders Remedy Solution Architect Enterprise Service Suite @ Work == ARS List Award Winner 2005 Best 3rd party Remedy Application See the ESS Concepts Guide tel +44 1494 468980 mobile +44 7710 377761 email [EMAIL PROTECTED] web http://www.westoverconsulting.co.uk -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ravi Sent: Monday, June 02, 2008 9:54 PM To: arslist@ARSLIST.ORG Subject: Re: Use of Roles in Deployable Application LJ, David: thanks for your response. What if the role already exists in the destination server? Wouldn't I run into the same issue. For example: Source Server has a deployable application (appA) and a role (roleA). Let'z say this roleA has a group called Testers. I export this application. Destination server already has a different application (appB) and a role (roleA). If I import the application here, wouldn't that mess up appB? TIA Ravi LJ Longwing wrote: Additionally, Role ID's are specific to the application...which means that a deployable application can be dropped onto a new server, and have the roles mapped to existing groups on the new server without breaking anything. If it's a local application then the permissions are tied to a group id...if the group id that the application uses is already in use on the destination server...you are screwed...I believe that this architecture was setup so that Company A could sell an application to Company B without regard for if the group ID's the application was built on are already in use on the destination server -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ravi Sent: Monday, June 02, 2008 11:34 AM To: arslist@ARSLIST.ORG Subject: Use of Roles in Deployable Application Hi: I am trying to build a deployable application for the first time so I can migrate the application between test, development and production remedy servers. I read through the docs couple of times and still can't seem to understand the usage of roles. I know users are part of one or more group(s). A role can have one group when in Test and another group when in Production. Is that all: All roles does is provide access to the application to different set of users based on the deployable application state? So do the groups and roles have to exist on the destination arserver before exporting an imported application from my test server to the development arserver? Also looks like the advantage of using deployable application instead of local application is that it can be licensesed and tracked. Is that the only reason why someone would use deployable? TIA Ravi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Midtier Issues Turn Into Gross BMC Incompetence
Have you looked in the mid-tier logs at the time that the client doesn't show the window properly? And just for completeness sake...Server and Mid-Tier version and OS? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Paul Blasquez Sent: Monday, June 02, 2008 2:38 PM To: arslist@ARSLIST.ORG Subject: Re: Midtier Issues Turn Into Gross BMC Incompetence Thank you for the suggestions, unfortunately there is no smoking gun in the logs. It happens not only on a table drill down but also on a results list drill down. The only time it works as expected is when there is a results list on top of the form, as in a standard search. When you highlight a ticket there, it populates the form underneath. However, if you double-click the same ticket from the same results list, the new window fails to populate the data, and does not throw an error in either the server or midtier logs. BTW, I have finished importing my workflow and form back into development from production and the issue still exists. So, whatever write operations he hoped would clear the issue obviously did not work, as it has been blown away and restored and is still exhibiting the same behavior. -Paul -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Pierson, Shawn Sent: Monday, June 02, 2008 1:15 PM To: arslist@ARSLIST.ORG Subject: Re: Midtier Issues Turn Into Gross BMC Incompetence I love a good rant against BMC Support as much as the next person, but I'd like to see your problem resolved too. Can you give us more information that might help determine what the problem is? To start, are you using the Drill Down on the Table Field, or are you trying to open that record with an Active Link? If it's via an Active Link, can you send us more information on the Open Window command? If I was in your shoes, I would run Active Link logs and try to reproduce it in both the User Tool and on the Mid Tier, then compare those log files and see what's happening. My guess would be that something potentially happens in one of those few areas where there is a difference in the two, such as how Display/Windows Loaded for the Execute On are different, or perhaps the timing works differently and some workflow that has a lower execution order takes longer and a later one does it's action first, or something weird. Still, it should be something you can figure out by looking at the logs from both. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Paul Blasquez Sent: Monday, June 02, 2008 1:37 PM To: arslist@ARSLIST.ORG Subject: Midtier Issues Turn Into Gross BMC Incompetence Hello, I'm a little upset here, as I have received instructions from BMC, that had I carried them out blindly on my production server, would have completely wiped out any workflow and data I had not backed up, and with no warning from BMC. I would like to share these instructions here, and get opinions as to whether I am totally misunderstanding the instructions, or if I was given incomplete and dangerous instructions by an incompetent BMC tech. The problem was, originally, that when my form was called from the midtier via a table or results list, the browser would display the form as blank even though a specific request id was requested. So, double click the ticket, window opens, form is blank instead of filled in with that ticket's contents. All workflow works fine in the user client. So, after minor troubleshooting with BMC they finally request the .def file, I send it. They get back to me with the following instructions (object name replaced by FORM): 1. Go to the Admin tool and open that form FORM and Save as that form with the different name e.g. FORM-new 2. Rename original form FORM to FORM-old 3. Now rename FORM-new to FORM. 4. Delete the form FORM 5. Rename FORM-old to FORM 6. Verify all the Active Links/Filters point to FORM 7. Export the *.def file of FORM 8. Delete the form FORM 9. Create new form name it FORM 10. Verify all the Active Links/Filter point to FORM Now the issue with this, and thank goodness I did this on my development server first, is that at step 8, YOU DESTROY ALL YOUR DATA AND WORKFLOW. Making steps 9 and 10 irrelevant. Even given the fact that I could have implied that at step 7 I should have exported the entire workflow for that form, there is still no step that says back up your data, and there are no steps explaining importing back your workflow and data. Please give me your points of view on this situation because I am trying to not write a scathing email or make a hostile phone call right now. Paul Blasquez Senior Network Engineer/Remedy Developer | Desk - 408.360.5220 | Cell - 408.627.5714 ___ UNSUBSCRIBE or access ARSlist Archives at
Re: Use of Roles in Deployable Application
Nope...that's why I specified that role ID's are specific to their application...so role id -1234 in AppA does not conflict with role id -1234 in AppB...in fact I have a number of apps on my servers that have the same role id because I map them to the same group... -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ravi Sent: Monday, June 02, 2008 2:54 PM To: arslist@ARSLIST.ORG Subject: Re: Use of Roles in Deployable Application LJ, David: thanks for your response. What if the role already exists in the destination server? Wouldn't I run into the same issue. For example: Source Server has a deployable application (appA) and a role (roleA). Let'z say this roleA has a group called Testers. I export this application. Destination server already has a different application (appB) and a role (roleA). If I import the application here, wouldn't that mess up appB? TIA Ravi LJ Longwing wrote: Additionally, Role ID's are specific to the application...which means that a deployable application can be dropped onto a new server, and have the roles mapped to existing groups on the new server without breaking anything. If it's a local application then the permissions are tied to a group id...if the group id that the application uses is already in use on the destination server...you are screwed...I believe that this architecture was setup so that Company A could sell an application to Company B without regard for if the group ID's the application was built on are already in use on the destination server -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ravi Sent: Monday, June 02, 2008 11:34 AM To: arslist@ARSLIST.ORG Subject: Use of Roles in Deployable Application Hi: I am trying to build a deployable application for the first time so I can migrate the application between test, development and production remedy servers. I read through the docs couple of times and still can't seem to understand the usage of roles. I know users are part of one or more group(s). A role can have one group when in Test and another group when in Production. Is that all: All roles does is provide access to the application to different set of users based on the deployable application state? So do the groups and roles have to exist on the destination arserver before exporting an imported application from my test server to the development arserver? Also looks like the advantage of using deployable application instead of local application is that it can be licensesed and tracked. Is that the only reason why someone would use deployable? TIA Ravi __ __ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are __ _ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Issue installing itsm patch 7
Seems like there should be some install logs somewhere that tell you something about the problem. Anything there? Rick On Mon, Jun 2, 2008 at 1:57 PM, Joe DeSouza [EMAIL PROTECTED] wrote: ** You might want to check if you have enough space in the drive that holds your system Temp folder.. From the sound of it, it may be a packing list error - failure to build a packing list which happens if there isnt enough space in the temp folder. Joe - Original Message From: Howard Richter [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, June 2, 2008 12:24:37 PM Subject: Re: Issue installing itsm patch 7 ** Ouch, so it looks like that system will need to stay at patch 6, unless someone has found a workaround. Thanks for the info, Howard On 6/2/08, Rick Cook [EMAIL PROTECTED] wrote: ** Is this one of those patches that is trying to validate its prereqs and such before actually installing anything? I know that is a promised 7.5 function, and that they've been working in that direction even in 7.x, but I don't know if they're there yet. Rick On Mon, Jun 2, 2008 at 9:11 AM, Rune Sorlid [EMAIL PROTECTED] wrote: ** Got the same errormessage, only on VMWare Machines /Rune Sorlid 2008/6/2 Howard Richter [EMAIL PROTECTED]: ** Good morning all, Has anyone seen the error Unable to build patch summary when runing itsm 7 patch 7? And if so any ideas on what could be going on? The apps are at 7.0.3 patch 6. Thanks, -- Howard Richter __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ -- Howard Richter Red Hat Certified Technician CompTIA Linux+ Certified ITIL Foundation Certified E-Mail = [EMAIL PROTECTED] Resume = http://www.richter-home.net/resume/ LinkedIn Profile = http://www.linkedin.com/in/hbr4270 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
SQL help
I'm trying to do a query on 2 tables- SIT:Site and AST:ComputerSystem. I'm a bit rusty on my SQL. The error this gives is: Msg 102, Level 15, State 1, Line 3 Incorrect syntax near '='. Can anyone help? Thanks! Chris SELECT AST_ComputerSystem.Company AS 'Agency', AST_ComputerSystem.assetlifecyclestatus AS 'Status'= CASE AST_ComputerSystem.assetlifecyclestatus WHEN 0 THEN 'Ordered' WHEN 1 THEN 'Received' WHEN 2 THEN 'Being Assembled' WHEN 3 THEN 'Deployed' WHEN 4 THEN 'In Repair' WHEN 5 THEN 'Down' WHEN 6 THEN 'End of Life' WHEN 7 THEN 'Transferred' WHEN 8 THEN 'Delete' WHEN 9 THEN 'In Inventory' WHEN 10 THEN 'On Loan' WHEN 11 THEN 'Disposed' WHEN 12 THEN 'Reserved' WHEN 13 THEN 'Return to Vendor' END, AST_ComputerSystem.Name AS 'Instance Name', SIT_Site.Site, SIT_Site.Street AS 'Street', SIT_Site.City AS 'City', SIT_Site.State Province AS 'State', SIT_Site.Zip/Postal Code AS 'Zip', SIT_Site.Additional_Site_Details, snip: too long for the list FROM SIT_Site SIT_Site INNER JOIN AST_ComputerSystem AST_ComputerSystem ON SIT_Site.Site=AST_ComputerSystem.Building WHERE AST_ComputerSystem.assetlifecyclestatus 8 and AST_ComputerSystem.datasetid = 'BMC.ASSET' and AST_ComputerSystem.classid IN ('BMC_COMPUTERSYSTEM', 'BMC_VIRTUALSYSTEM', 'BMC_LPAR') AND AST_ComputerSystem.item in ('Intel','UNIX') order by 1, 2, 3 ; ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: SQL help
If you could tell me what output you are hoping for, I could check back once I go back to my hotel (with a brief descriptions of these tables as I do not have access to my system from the hotel today). I'll try to help you with the statement if I can.. Cheers Joe - Original Message From: Moore, Christopher Allen [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, June 2, 2008 9:01:35 PM Subject: SQL help ** I’m trying to do a query on 2 tables- SIT:Site and AST:ComputerSystem. I’m a bit rusty on my SQL. The error this gives is: Msg 102, Level 15, State 1, Line 3 Incorrect syntax near '='. Can anyone help? Thanks! Chris SELECT AST_ComputerSystem.Company AS 'Agency', AST_ComputerSystem.assetlifecyclestatus AS 'Status'= CASEAST_ComputerSystem.assetlifecyclestatus WHEN 0 THEN 'Ordered' WHEN 1 THEN 'Received' WHEN 2 THEN 'Being Assembled' WHEN 3 THEN 'Deployed' WHEN 4 THEN 'In Repair' WHEN 5 THEN 'Down' WHEN 6 THEN 'End of Life' WHEN 7 THEN 'Transferred' WHEN 8 THEN 'Delete' WHEN 9 THEN 'In Inventory' WHEN 10 THEN 'On Loan' WHEN 11 THEN 'Disposed' WHEN 12 THEN 'Reserved' WHEN 13 THEN 'Return to Vendor' END, AST_ComputerSystem.Name AS 'Instance Name', SIT_Site.Site, SIT_Site.Street AS 'Street', SIT_Site. C ity AS 'City', SIT_Site. State Province AS 'State', SIT_Site.Zip/Postal Code AS 'Zip', SIT_Site.Additional_Site_Details, snip: too long for the list FROM SIT_Site SIT_Site INNER JOIN AST_ComputerSystem AST_ComputerSystem ON SIT_Site.Site=AST_ComputerSystem.Building WHEREAST_ComputerSystem.assetlifecyclestatus 8 andAST_ComputerSystem.datasetid = 'BMC.ASSET' andAST_ComputerSystem.classid IN ('BMC_COMPUTERSYSTEM', 'BMC_VIRTUALSYSTEM', 'BMC_LPAR') AND AST_ComputerSystem.item in ('Intel','UNIX') order by 1, 2, 3 ; ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are