Re: AR System server terminated when a signal/exception was received by the server
You should try and get BMC to provide you with a debug version of arserverd (arserver.exe). The debug version should perform a memory dump that contains all the symbols necessary for debugging. BMC should then be able to use your memory dump to isolate the issue. I could see valid justification in BMC asking you to update to the latest (debug) patch for this though. In the past, I've tracked these types of things down to specific form/field/workflow properties, and this will be an incremental step in attaining a fix from BMC. Something is happening, somewhere, that is causing this. Turn on the api logs with the overwrite option. Grab the last log after a crash and save a copy, it should point you to the right place to reproduce the issue. Axton Grams Heider, Stephen wrote: I periodically see these errors in the arerror.log file. ARS apparently restarts its NT service and continues functioning normally. There have been no error messages popping up on client computers. I have log files running but have not seen any correlation between workflow and this particular error. The error message below is the exact text each time. Because there has been no sign of any problems caused by this error I am not overly concerned. However, no errors are better than some errors. Has anyone seen this before and is there a known fix or workaround? Thread Id: 3660 Version: 6.03.00 patch 016 Jan 20 2006 23:48:41 Code: c005 Operation: read Access Addr: 0001 Stack Begin: Addr: 005D6D38 Addr: 093DCF78 Stack End: ARS 6.3 p16 Windows Server 2003 SQL Server 2000 Stephen ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Java ARServerUser method / How to specify a TCP Port
As of 6.3, this did not function properly. The util method was required instead. See Tim's message. Axton Grams Greg Elphick wrote: ** Hi Jack, I think you can just add the tcp port number on the end of the ArServerUser context as an integer ARServerUser context = new ARServerUser(user,password,locale,server, portnumber) then you would call context.login BTW Ive found that i havent needed to call the login that the initial context creation has already connected me to the arserver Greg Elphick Advisory System Engineer -- This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please notify the sender and delete the transmission. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. -- __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Special fields.
Log in as an admin user and a non-admin user and see what the behavior is under those two cases. You may be surprised. Axton Grams David Yearsley wrote: ** ARSystem 6.03.00 Patch 16. Solars 9 ITSM 6.0 no patch In our system we have two forms that have a 6 field (Dynamic group range). We are trying to get a menu qualification: 'Dynamic Group' = $6$ to work. This is returning no values to the menu even though there are multiple records in the second form. (Same problem if you use and Active Link.) In looking at the logs, what is happening is it looks at the other table using the text value on the screen not the underlying group id. i.e., instead of Select 11011; it has Select Name. Is there a way to force the menu or active link to use the group id as part of the query instead of the field text that is displayed? Thanks __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Last Login
If you are on 7.0, force the use of a preference server, then create a filter that fires on getentry where $USER$ = '2' on the ar system user preference form and set the date/time to a field you create. It's always important to post the version you are using. Axton Grams Scott Parrish wrote: James, Use the Init Form functionality. If I am not mistaken, it was introduced yet undocumented in ARS 4.5.1. You should be able to find information on how to use it in any of the 5.0 or above ARS guides. Basically, this is a background form that can execute workflow when a user logs into the system. Scott Parrish IT Prophets, LLC (770) 653-5203 http://www.itprophets.com -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of James Collins Sent: Friday, October 06, 2006 6:24 PM To: arslist@ARSLIST.ORG Subject: Re: Last Login Yes I did think of that but they really do not want that, the first problem, they want to see it, and since that is an admin thing it is not all that clean. But I am surprised that does not come out of the box on the remedy user form. Might be a good suggestion. James Collins Supervisor Client Services,IT Service Desk Vnet 331-6070 DD 914-881-6070 Fax 914 331 7318 DD 914-881-7318 www.verizonbusiness.com Verizon Business - global capability.personal accountability This email is strictly confidential and intended only for use by the addressee unless otherwise indicated. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick cook Sent: Friday, October 06, 2006 6:21 PM To: arslist@ARSLIST.ORG Subject: Re: Last Login How about using the Event logging or the User logs? That data is already tracked there. Rick -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of James Collins Sent: Friday, October 06, 2006 3:11 PM To: arslist@ARSLIST.ORG Subject: Last Login Hello all, Happy Friday. Next week I am going to have to set something up on the Remedy User Form that pushes back a last login timestamp to the user form. I am just wondering if any one has a best way to accomplish this, I am thinking of firing off of the start form. I have multiple users logging into multiple forms and not necessarily the same ones so I cannot work off of one common form. My management wants to know who logs in and who doesn't so any help would be helpful James Collins Supervisor Client Services,IT Service Desk Vnet 331-6070 DD 914-881-6070 Fax 914 331 7318 DD 914-881-7318 www.verizonbusiness.com Verizon Business - global capability.personal accountability This email is strictly confidential and intended only for use by the addressee unless otherwise indicated. ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Advantages/Disadvantages between platforms running Remedy
MSSQL Advantages: - Case insensitive MS OS Disadvantages: - When things break a reboot is in order, when things really break a rebuild is in order - c api development typically requires purchasing an MS compiler and learning an MS tool - Open software sometimes has trouble working properly/reliably and is subject to breaking with MS updates UNIX Advantages: - people proficient in unix/linux can actually investigate and resolve issues - Open software usually works UNIX Disadvantages: - expensive hardware Linux/MS Advantages: - cheap hardware Some questions to ask that I can't answer: - Is clustering more robust in unix/linux environment? Apart from a technological standpoint, there are other things to consider: - what skills are at your disposal in your organization? - what skills do your remedy people have? Axton Grams Scott Neeb wrote: We have an initiative at my work entitled Why Not Microsoft?. We're supposed to ask ourselves at critical application milestones if we should contemplate moving Remedy to the Windows platform. We currently reside on UNIX with an Oracle database, so Remedy is always being evaluated as a candidate for the move. They asked me today if there are any advantages/disadvantages between running Remedy on UNIX/Oracle as compared to Windows/SQL Server. I haven't seen any documentation or user comments anywhere on the internet, so I was wondering if any of you have any prior experience with this type of move, and if you've seen any advantages or disadvantages to this type of move as it relates to the ARSystem. Thanks in advance. ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: How do I get the Run Process to return a value and enter it into a field?
Use a set fields with $PROCESS$ instead of a run process action. Look up the PROCESS keyword for the details. Axton Grams Rob Backstrom wrote: ** ARS 6.3 I have a filter trigger a Run Process, I have seen statements that the workflow can wait for a value to return (in our case 1-2 seconds). And ideas on how I can retrieve this value? Thanks, Rob Be one of the first to try Windows Live Mail. http://ideas.live.com/programpage.aspx?versionId=5d21c51a-b161-4314-9b0e-4911fb2b2e6d__20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Break out Member List from AP:Role form (Approval Server)?
Be careful with the solutions provided because login names that are substrings of other login names will result in broken member lists. For example, consider the following member value: AGRAMS;AGRAMS2 Now, if you replage AGRAMS with '', you get the following: ;2 A safer approach is to add the delimiter to the beginning and end of the string using a set fields: ex., ;AGRAMS;AGRAMS2; Then replace the leading and trailing delimiter and value with the delimiter. i.e., replace ;AGRAMS; with ; The result following: ex., ;AGRAMS2; You can then proceed to trim the leading and trailing delimiters. Axton Grams Thad Esser wrote: ** I'm not a DBA, but can get around in SQL/Oracle fairly well. Can you clarify what you mean by: ...using pipes - | - instead of percent signs! I'm aware of double pipes that get used for concatenation, but I'm curious how you use them instead of percent signs? Thanks, *Thad*/ Perfection is achieved, not when there is nothing more to add, but when there is nothing left to take away.// /- Antoine de Saint-Exupéry *Rebecca Hammond [EMAIL PROTECTED]* Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 09/28/2006 03:28 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Break out Member List from AP:Role form (Approval Server)? ** This is great – although we’re in Prod. Code lockdown, so I can’t do this now ;-) However, I’m going to definitely save it and try to implement as an enhancement! Thank you! I did figure it out, in SQL*Plus, at least to find the affected records – if anyone’s interested, I can send you the query syntax (darn Oracle, and using pipes - | - instead of percent signs!) *From:* Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] *On Behalf Of *Thad Esser* Sent:* Thursday, September 28, 2006 1:44 PM* To:* [EMAIL PROTECTED] Subject:* Re: Break out Member List from AP:Role form (Approval Server)? ** Rebecca, It is what it would like in a set fields of a filter. For my setup, I have a filter guide on the SHR:People form that when triggered, goes through all the forms and deletes the users or updates records associated with them as appropriate. In the case of AP:Role, I push a value to a Command field (display only char field) on the AP:Role form, where a filter detects that and does the set fields below. Specifically: --- The Delete Person filter guide searches the AP:Role form for roles where the Login Name is the only value in the member list, and then displays an error if it finds any, --- Having passed the above, the next filter pushes to the AP:Role form: Push If: ( 'Member List' LIKE (( % + $Login Name$) + % )) AND ( 'Status' = Active) If none, take no action. If any, modify all. Command = REMOVE-USER-FROM-MEMBER-LIST + $Login Name$ Change History = (($Full Name$ + () + $Login Name$) + ) is being removed from Remedy and has been removed from the list of approvers for this role. Then over on the AP:Role form, I have the following filter on Modify: Run If: 'Command' LIKE REMOVE-USER-FROM-MEMBER-LIST % --- Action 1, Set Fields: Command = ( ; + REPLACE($Command$, REMOVE-USER-FROM-MEMBER-LIST , )) + ; Member List = ( ; + $Member List$) + ; (parses the login name out of the command field and adds semi-colons so we can avoid partial matches, e.g. jdoening matching when trying to remove jdoe) --- Action 2, Set Fields: Member List = REPLACE($Member List$, $Command$, ;) (pulls out the login name, replacing it with a semi-colon so that login names are still separated properly) --- Action 3, Set Fields: Member List = SUBSTR($Member List$, 1, LENGTH($Member List$) - 2) (cuts off the leading and trailing semi-colons that we added in action 1 to make our search easier) I hope that clarifies things for you. * Thad*/ Perfection is achieved, not when there is nothing more to add, but when there is nothing left to take away.// /- Antoine de Saint-Exupéry *Rebecca Hammond [EMAIL PROTECTED]* Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 09/28/2006 06:44 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Break out Member List from AP:Role form (Approval Server)? I may not have had enough coffee this morning...but this, below, is what it would look like in a piece of Remedy workflow, or a SQL command at the DB level (or both)? On Wed, 27 Sep 2006 10:36:40 -0700, Thad Esser [EMAIL PROTECTED] wrote: Try: REPLACE($Member List$, $Login Name$, ) followed by REPLACE($Member List$, ;;, ;) (you could combine them into one if you wanted) Thad
Re: Question: Password Change
Updates, inserts, and deletes performed by filters push/set field actions do not require a license. Only direct user interaction and active link push fields actions require the appropriate license. Axton Grams Ben Chernys wrote: You cannot MODIFY a record with a read license. You can create a new record so it is there that you can capture the date of the password change. I had to do this to introduce a password expiry scheme and retain a configurable number of password histories so that they could not be used again. So, issue a push to a new form with date and userid. That new form can DELETE any other records already extant for that same user (a history depth of 1 or just the date of last change. Deletions seem not to count as updates (a touch strange - that). To use the value, you'll have to do a set fields when you need to in the user form. Cheers Ben Chernys -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Candace DeCou Sent: September 14, 2006 4:44 PM To: arslist@ARSLIST.ORG Subject: Re: Question: Password Change I believe the field has to be in one of Remedy's reserved range. Look at the DB values of the fields in the User form and try to use one that is close but different than the others. You will have to rebuild your field for this to work. :) Candace -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tyrone Dee Sent: Thursday, September 14, 2006 7:42 AM To: arslist@ARSLIST.ORG Subject: Re: Question: Password Change Yes, but it is saying I don't have write permissions to this field. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Herb Partlow Sent: Thursday, September 14, 2006 10:15 AM To: arslist@ARSLIST.ORG Subject: Re: Question: Password Change Tyrone Did you check, Public and allow any one to submit Herb -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of T. Dee Sent: Thursday, September 14, 2006 7:03 AM To: arslist@ARSLIST.ORG Subject: Question: Password Change I have created my own password change form for the users - this works fine. The only question I have is there a way to capture the date they changed their password. I have created a field on the user form, but I when I try to push the date to this field I get a error when a user with Read Only rights tries to do this. Thanks. ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org - * This message contains information from Silicon Valley Bank, or from one of its affiliates, that may be confidential and privileged. If you are not an intended recipient, please refrain from any disclosure, copying, distribution or use of this information and note that such actions are prohibited. If you have received this transmission in error, please notify the sender immediately by telephone or by replying to this transmission. This message may include indicative rate information relating to one or more products offered through Silicon Valley Bank, or affiliated broker-dealer, SVB Securities. Rates and yields shown are provided for informational purposes only, are not guaranteed, and are subject to market conditions and availability. Nothing in this communication shall constitute a solicitation or recommendation to buy or sell a particular security. Columbia Cash Reserves, Columbia Treasury Reserves, Columbia Institutional Cash Reserves, SVB Securities Liquid Reserves, SVB Securities Institutional Liquid Reserves and SVB Securities Horizon Shares are offered through SVB Securities, a registered broker- dealer and non-bank affiliate of Silicon Valley Bank. Investments in these products require the involvement of a licensed representative of SVB Securities. Investment products offered through SVB Securities are not insured by the FDIC or any other Federal Government Agency, are not deposits of or guaranteed by Silicon Valley Bank or its affiliates, and may lose value. ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: ITSM 7 flashboards jar files
The FB installer is for the fb history collection daemon. All the files for the actual rendering of the flashboards is contained with the mid-tier installation. Axton Grams Den Fong wrote: ** Anybody else??? bueller? bueller? Tony Worthington [EMAIL PROTECTED] 9/13/2006 8:59 AM ** Oops... I just realized that the FB setup hasn't been run on this server. This might not be everything. Sorry about that. Maybe someone else can verify? Time for coffee... -- Tony Worthington [EMAIL PROTECTED] 262-703-6125 *Tony Worthington/Corp/Kohls* 09/13/2006 09:54 AM To arslist@ARSLIST.ORG cc Subject Re: ITSM 7 flashboards jar filesLink notes:///862571BD006CDF15/DABA975B9FB113EB852564B5001283EA/5309F845EC056722862571E8005049DB From a just installed version on Win2k3 -- jar's should be the same though. arapi70.jar arutil70.jar ARWebReportViewer.jar axis.jar blowfishj.jar cecore.jar celib.jar ceplugins.jar cereports.jar cesession.jar cmdbapi20.jar commons-discovery-0.2.jar commons-logging-1.0.4.jar Config.jar CorbaIDL.jar cos.jar ebus405.jar GraphPlugin.jar icu4j.jar jaxrpc.jar log4j.jar Logger.jar MetafileRenderer.jar MidTier.jar rasapp.jar rascore.jar ReportCommon.jar saaj.jar Serialization.jar Support.jar URIUtil.jar webreporting.jar websvc70.jar -- Tony Worthington [EMAIL PROTECTED] 262-703-6125 *Den Fong [EMAIL PROTECTED]* Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 09/13/2006 09:29 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject ITSM 7 flashboards jar files ** Can someone give me a listing of their jar files for mid-tier for ITSM7? I'm still having issues and most of the KB indicate that it might be a jar file missing from the mid-tier\WEB-INF\lib directory. TIA Den __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it_20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Your article on web re diary fields.
This is possible. In my current environment, we parse the diary fields into a table containing 4 columns for reporting purposes: - entryid - data - timestamp - user There are a series of special control characters (high bit ascii charactesr) used in diary fields to separate the user, timestamps, and actual data. You will have to mimic this format exactly to manipulate the data using direct sql. Be careful when doing this, as malformed entries can cause client instability (e.g., user tool crashes ungracefully). It would probably be safer to use an api to manipulate the data in diary fields unless you are extremely meticulous in the implementation of said feature. Axton Grams Koyb P. Liabt wrote: ** Hi Axton, I was surfing the web looking for info on how to write a direct SQL to a diary field. Is this possible. I created a custom diary field. When a user presses a button the SQL statement appends the info within a column in the database to the last entry. Is this possible? When I set the field with the SQL statement -- the user's data is not sent directly to the diary field. I came across your article on the web. Do you have any idea if a SQL can directly send info into the worklog/and append more info later. Re: Duplicate Entries in Diary Field http://www.opensubscriber.com/messages/[EMAIL PROTECTED]/384.html by Axton http://www.opensubscriber.com/profile.os?individual=1771507 Reply to author http://www.opensubscriber.com/sendEmail.os?individual=1771507 Reply to group http://www.opensubscriber.com/sendEmail.os?message=1771507 It is active links that read the contents of a diary back into the diary field when opened as a dialog. Subsequent saves cause the entire contents of the diary to be rewritten. Be careful with this becuase if the size of the text exceeds 1bm and the Oracle-Max-Text size (or whatever it is called) is not set to a value greated than 1mb, your server will crash. The workaround for this is to create a display only char field that is used for new diary entries and update the active links triggered when clicking the save button to push the char field contents to the diary instead of the old diary field contents. I have a bug open with Remedy on this, but no resolution will ever be provided for the current release of the apps. Axton __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Request for Enhancement (RFE) community discussion at BMC UserWorld - follow-up
Good to hear this from you. Wish I could have been involved in the discussion, but factors were not permitting. I would still like to see a discussion of the process with the general Remedy customer base and not limited to the people fortunate enough to attend BUW. Axton Grams Carey Matthew Black wrote: Axton, Before the meeting I shared your viewpoint of the old RFE process. It was made very clear during the meeting that the change that happened on Jan 1 2006 to the RFE process was NOT communicated to the customer base at that time. If we had been given the presentation in February then I bet they would have had even more RFE's coming in between the announcement and now. (Which might have made it a steeper up hill climb to get all the processing in place.) Like resubmitting older RFE's so that they can be evaluated instead of waiting until the backlog is processed. :) It was also stated during the meeting that BMC is actively trying to balance customer involvement with guarding against unpolished engineering notes reaching customers directly (paraphrased). As normal, techie people are not generally the best at say I get it, but no in a way that most customers would appreciate. :) No one wants to waste their time, and no one wants to cause any more ill will around this process. It was also made clear that under some responses (like the infamous as designed) from the RFE process that the story is not over. Rather such an RFE demands (from a customer service perspective) a quote from an existing manual, or a KB article explaining the reason why. Simply saying No, you do not get it. is just not enough for the money and time that customers are devoting to BMC. The general theme during the meeting is that RFE's are a great oppertunity for BMC to partner with their customers, and they have done a poor job of using that resource to it's fullest today. (for various reasons) However, I am personally confident that David Easter got the message during the meeting and is now activly doing the best he can inside BMC. However, BMC will need some time to make decisions and possibly reallocate some minor resources to try to address the issues that were raised. After the meeting, I can say that am hopeful for all new RFE's that are being submitted. And if even 10% of the suggested RFE enhancements are implemented in the RFE process then the RFE future is very bright indeed. David, I know I might be asking a bit much here, but can you comment on when you might know if any, or which suggestions, might be implemented? ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Request for Enhancement (RFE) community discussion at BMC UserWorld - follow-up
Dave: Any chance I can have those numbers run for my RFE's? jk... a little friday humor Axton Grams Easter, David wrote: Hello, Folks; As promised, I have attached the a zip file with the following: 1. The original presentation in MS Word format (PPT was too big) shown at BMC UserWorld during our discussion 2. An RFE template in MS Word format that can be used to best ensure that Product Management receives enough information to properly review an RFE 3. The meeting minutes / feedback in plain text format (to save space) Note that you will have to rename the file to have an extension of .zip. I changed the extension to .txt to better enable the file to reach folks whose organization does not allow executables or zip files to pass through the E-mail server. Thank you to all that participated in the discussion. It was great meeting you all in person and your comments and input were highly appreciated. For those that could not attend, please review the documents attached to see if your questions and/or concerns were covered in the presentation or meeting minutes. If not, feel free to respond to this posting or E-mail me directly at: [EMAIL PROTECTED] If there is a high enough need for it, I will organize a follow up meeting in virtual space (most likely through WebEx and a phone conference call system). Thanks! -David J. Easter Sr. Product Manager, Service Management Business Unit BMC Software, Inc. ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Request for Enhancement (RFE) community discussion at BMC UserWorld - follow-up
I'm liking what I see in the presentation, but it doesn't seem to reflect reality. For example: RFE7360 - opened 10/10/03 11:19:09 AM - has no disposition RFE7389 - opened 10/17/03 7:16:32 AM - has no disposition RFE7997 - opened 4/2/04 11:49:28 AM - has no disposition RFE7997 - opened 4/2/04 11:49:28 AM - has no disposition RFE8349 - opened 6/28/04 9:47:52 AM - has no disposition RFE8411 - opened 7/14/04 11:28:12 AM - has no disposition RFE8412 - opened 7/14/04 11:29:57 AM - has no disposition RFE8434 - opened 7/20/04 1:23:36 PM - has no disposition RFE8447 - opened 7/22/04 6:25:14 AM - has no disposition They pretty much all go on in this way (with the exception of a handful). All RFE's entered the twilight zone, never to be heard from again. Just an observation. Axton Grams Easter, David wrote: Hello, Folks; As promised, I have attached the a zip file with the following: 1. The original presentation in MS Word format (PPT was too big) shown at BMC UserWorld during our discussion 2. An RFE template in MS Word format that can be used to best ensure that Product Management receives enough information to properly review an RFE 3. The meeting minutes / feedback in plain text format (to save space) Note that you will have to rename the file to have an extension of .zip. I changed the extension to .txt to better enable the file to reach folks whose organization does not allow executables or zip files to pass through the E-mail server. Thank you to all that participated in the discussion. It was great meeting you all in person and your comments and input were highly appreciated. For those that could not attend, please review the documents attached to see if your questions and/or concerns were covered in the presentation or meeting minutes. If not, feel free to respond to this posting or E-mail me directly at: [EMAIL PROTECTED] If there is a high enough need for it, I will organize a follow up meeting in virtual space (most likely through WebEx and a phone conference call system). Thanks! -David J. Easter Sr. Product Manager, Service Management Business Unit BMC Software, Inc. ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Request for Enhancement (RFE) community discussion at BMC UserWorld - follow-up
To comment on this snippet: * Perhaps a “sandbox” AR System could be made available to the development community where trusted members of the community could log in to do application development or QA testing of enhancements o Internal BMC resources may not be available to manage such a system, but as the developer community continues to evolve, the idea will be kept in mind. If you provide the license(s) to do so, I'm sure the hosting/management can be arranged. Axton Grams Easter, David wrote: Hello, Folks; As promised, I have attached the a zip file with the following: 1. The original presentation in MS Word format (PPT was too big) shown at BMC UserWorld during our discussion 2. An RFE template in MS Word format that can be used to best ensure that Product Management receives enough information to properly review an RFE 3. The meeting minutes / feedback in plain text format (to save space) Note that you will have to rename the file to have an extension of .zip. I changed the extension to .txt to better enable the file to reach folks whose organization does not allow executables or zip files to pass through the E-mail server. Thank you to all that participated in the discussion. It was great meeting you all in person and your comments and input were highly appreciated. For those that could not attend, please review the documents attached to see if your questions and/or concerns were covered in the presentation or meeting minutes. If not, feel free to respond to this posting or E-mail me directly at: [EMAIL PROTECTED] If there is a high enough need for it, I will organize a follow up meeting in virtual space (most likely through WebEx and a phone conference call system). Thanks! -David J. Easter Sr. Product Manager, Service Management Business Unit BMC Software, Inc. ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Oracle 9-10
Ok to keep 9, Remedy does not use any features of 9i or 10g, so it is really a decision on what is easier to manage for your dba. You do have to upgrade the oracle client on the arserver host to 10g though. Axton Grams [EMAIL PROTECTED] wrote: Hi, suppose uppgrading from 6.3 to 7.01, advantages to upgrade Oracle to ver 10, or ok to keep 9i? (9.2.0 2.0)? TIA, L ars L ars Pettersson Vattenfall Business Services Nordic AB Action Request System Engineer (Tabasco) S-461 88 Trollhättan Sweden Phone +46 520 888 35 Mobil +46 70 608 99 95 e-mail: [EMAIL PROTECTED] ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Diary Field last entry
TR will give you the current diary entry (which is null if no changes to the diary field). If you want the last entry, you have to store it somewhere else (character field as you mentioned) or parse the diary field (which is tricky). I would make the char field 4k characters so it does not add a clob to the table (text for sql, not sure the cutoff in chars), then use the LEFTC function to only grab the first 4k chars of the diary entry. Axton Grams Sueli Kanegae wrote: Hi List, I need to know the last entry in a Diary field and was taking a look at old exchanged messages. I´ve found a solution below but couldn´t do the Set Field: Most Recent Action 'TR.Work Diary' I also tried '$TR.Work diary$', but it doesn´t work. Any other idea to save just the last entry (diary field)in a character field? (I don´t need odbc drivers or crystal as Carina does) Thanks in advance! Sueli On Tue, 15 Jun 2004 14:26:16 -0400, Tilton, Claire E. Ms. NGB-ARNG [EMAIL PROTECTED] wrote: Make a field called Most Recent Action (Field Size = 0 or whatever you feel is appropriate to catch the last diary entry). Create a filter that fires on 'TR.Work Diary' != $NULL$. Do a set fields Most Recent Action := 'TR.Work Diary'. Then you can report on that field instead of the work diary. Thanks, Claire -Original Message- From: Carina Burns [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 15, 2004 1:32 PM To: ARSLIST@ARSLIST.ORG Subject: Diary Field Question Listers, With the user preference form, you can set the diary field to display the most recent entry first. While this works through the forms (whether web or client,) it doesn't work when using the odbc drivers and crystal reports -despite using an id with the diary preference set. The first entry is displayed rather than the last entry. Has anyone out there found a way to retrieve only the last entry or to specify the display order of the diary entries within a crystal report? Much Appreciated, Carina Burns Database Admin Richardson ISD [EMAIL PROTECTED] ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Calendaring Utility
I'm thinking to replace their calendaring DV plugin with this http://simile.mit.edu/timeline/ It's very easy to use, the source is available under the BSD license (pretty much no restrictions to speak of), and it just works and looks a hell of a lot better. Axton Grams Rick cook wrote: The DV field has its own limitations, too. I asked some senior product people at RUG about whether it (the Change Calendar) was extendable to more than 7 days. The answer was that the Java Script upon which it was built was not built out to the point to make it extendable without changing the JS code, which would take one beyond Support. They also said that this first implementation of the DVF was more of a conceptual thing that they are looking forward to enhancing. Let's use things like this to direct BMC on how to enhance the functionality and capabilities of this new tool. Rick -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black Sent: Saturday, September 02, 2006 4:54 AM To: arslist@ARSLIST.ORG Subject: Re: Calendaring Utility Axton, I know that a DVF (Data Visualization Field) implementation would limit it to a v7 solution, but I think that is ultimately the way to go. Let me know if I could help with such an effort. :) It would be a great, generic, thing for the community. From what was talked about at BUG this year... this really should be a snap. ( It should take half a day to implement something cool. is a quote from the Engineer who presented one of the BEST sessions of the year. IMHO.) -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. Never ascribe to malice, that which can be explained by incompetence. On 8/29/06, Axton Grams [EMAIL PROTECTED] wrote: I found this little utility that lays out time line information. I think its far superior to the change management calendar viewer. It's available under the BSD license. Very cool stuff. http://simile.mit.edu/timeline/ I'm working on using this with Remedy for infrastructure change/task mapping. I'll post what I can put together. Axton Grams __ _ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Calendaring Utility
Even with the view fields on prior versions, drill downs are possible using the js installed with the user tool by calling an active link guide (this is what flashboards prior to v7 uses). With the new DV fields, it is possible to send events using these to/from mappings (see p179 of 7.0 'Integrating with Plug-ins and Third-Party Products' guide): - Signals from module client side to module mid tier - Signals from module client-side to parent AR System form - Signals from AR System form workflow to module - Drill down from client module to an AR System form The last signal can be used to do the drill downs. The verbatim text from the manual for that option reads: Generates code to perform the drill-down into an AR System form without being dependent on the module HTML being present within an AR System form. This allows the module code to generate HTML that can be just fragments in a portlet environment, while still providing the drill-down capability. The function call is EventDispatcher.drillDownToForm(server, form, view, qualification). Haven't gotten too heavily into it yet, but these are my first impressions. I would imagine that there are a series of js files with the user tool install that gives the functions and syntax for all the available calls that can be used. Axton Grams Rick cook wrote: Interesting...and I have to agree. How would you accomplish some sort of dynamic drilldown into approvals or CRs? Rick -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Grams Sent: Saturday, September 02, 2006 11:08 AM To: arslist@ARSLIST.ORG Subject: Re: Calendaring Utility I'm thinking to replace their calendaring DV plugin with this http://simile.mit.edu/timeline/ It's very easy to use, the source is available under the BSD license (pretty much no restrictions to speak of), and it just works and looks a hell of a lot better. Axton Grams Rick cook wrote: The DV field has its own limitations, too. I asked some senior product people at RUG about whether it (the Change Calendar) was extendable to more than 7 days. The answer was that the Java Script upon which it was built was not built out to the point to make it extendable without changing the JS code, which would take one beyond Support. They also said that this first implementation of the DVF was more of a conceptual thing that they are looking forward to enhancing. Let's use things like this to direct BMC on how to enhance the functionality and capabilities of this new tool. Rick -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black Sent: Saturday, September 02, 2006 4:54 AM To: arslist@ARSLIST.ORG Subject: Re: Calendaring Utility Axton, I know that a DVF (Data Visualization Field) implementation would limit it to a v7 solution, but I think that is ultimately the way to go. Let me know if I could help with such an effort. :) It would be a great, generic, thing for the community. From what was talked about at BUG this year... this really should be a snap. ( It should take half a day to implement something cool. is a quote from the Engineer who presented one of the BEST sessions of the year. IMHO.) -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. Never ascribe to malice, that which can be explained by incompetence. On 8/29/06, Axton Grams [EMAIL PROTECTED] wrote: I found this little utility that lays out time line information. I think its far superior to the change management calendar viewer. It's available under the BSD license. Very cool stuff. http://simile.mit.edu/timeline/ I'm working on using this with Remedy for infrastructure change/task mapping. I'll post what I can put together. Axton Grams _ _ _ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __ __ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __ _ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Error sending email
What MTA are you using (e.g., sendmail) and what is the from address configured in the AR System Email Mailbox Configuration form? Try to do a telnet session to your MTA using smtp (port 25) and see if you can send the message. See http://en.wikipedia.org/wiki/Simple_Mail_Transfer_Protocol for instructions on having a conversation with your smtp server. If you still receive the smtp 550 it's because relaying to address x (probably outside domains, most common configuration) is not allowed by your MTA. Axton Grams Rafael Bertolini wrote: Hi all!!! I've created a SLA that sends an email after sometime a incident is created. It also sends an alert. The SLA is working, since I've got the alert, but no email was sent. In the AR System Email Error Logs, I've got this message Invalid Addresses; nested exception is: class javax.mail.SendFailedException: 550 5.7.1 [EMAIL PROTECTED]... Relaying denied javax.mail.SendFailedException: Invalid Addresses; nested exception is: class javax.mail.SendFailedException: 550 5.7.1 [EMAIL PROTECTED]... Relaying denied at com.sun.mail.smtp.SMTPTransport.rcptTo(SMTPTransport.java:848) at com.sun.mail.smtp.SMTPTransport.sendMessage(SMTPTransport.java:323) at com.remedy.arsys.emaildaemon.SenderModule.sendMessage(SenderModule.java:74) at com.remedy.arsys.emaildaemon.CreatorModule.createMessage(CreatorModule.java:1468) at com.remedy.arsys.emaildaemon.CreatorModule.doWork(CreatorModule.java:360) at com.remedy.arsys.emaildaemon.ThreadBase.run(ThreadBase.java:268) at java.lang.Thread.run(Thread.java:534) It says invalid addresses, but the email [EMAIL PROTECTED] is correct (mine). What else could be? ARS 6.3 Solaris 8 TIA, Rafael Bertolini ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Setup Dev Server
What problem is there with using the same instance with different schemas? We have one server with 4 arsystem schemas in a single instance, not to mention that are dozens of other schemas in the instance not being used for Remedy. Using the same tablespace will be a problem if you try and do a fresh install because the arserver installer is flawed in the sense that it drops whatever tablespace you install arserver to and recreates it. Creating another instance has a lot of overhead associated with it (two sets of processes, two sga's, etc.) If the db server has enough hardware to fulfill the software's requests you should not have a problem sharing an instance. Axton Grams Grooms, Frederick W wrote: ** He said they were on 2 different servers *From:* Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] *On Behalf Of *McKenzie, James J C-E LCMC HQISEC/L3 *Sent:* Friday, September 01, 2006 1:41 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Setup Dev Server ** Fred: I think the problem may be that the production and dev servers are pointing to the same Oracle DB Instance and that they are installed in two different tablespaces. This can lead to disaster of major proportions. Solution: Have DBA create a second instance on the Oracle DB for development. Or install Oracle on a second server (this is LEGAL per Oracle.) James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: Friday, September 01, 2006 11:17 AM To: arslist@ARSLIST.ORG Subject: Re: Setup Dev Server Do you have the environment variables set up correctly? The 32 bit Oracle 9iR2 client in the path before your 64 bit Oracle 9iR2 client. ORACLE_HOME pointing to your 32 bit Oracle 9iR2 client. ORACLE_SID and TWO_TASK set for your dev database. TNS_ADMIN pointing to your tnsnames.ora file. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of John Kelley Sent: Friday, September 01, 2006 10:31 AM To: arslist@ARSLIST.ORG Subject: Setup Dev Server Hi List: First time emailer. Long time reader. I'm trying to setup our Dev Box(Windows 2003sp1) with AR 6.3. Having errors upgrading an existing DB. We took a copy of production DB, and placed it on a different oracle Server. Oracle 9.2.0.4.0 64bit. My tnsnames is set correctly to Dev Server and connection to remedb listener. The name of the DB is the same for Production and Dev. Which is OK. They are on different servers. When I'm setting up the Dev server running server.exe, Its asks for SID name and what type of install. Upgrade, Overwrite or Shared. I select Upgrade because the DB out there is an exact copy of the Production having all the Data - I want the data in tact just to install the Server. Here is the Error 15:40:39 An error was encountered during the upgrade of the AR System database. 15:40:39 Installation terminating ... Original database server is intact and accessible 15:40:39 Resolve the problem that causes the error (contact Technical Support, if necessary) 15:40:40 -[ShowMsg]: Setup is rolling back directories 15:40:40 Setup is rolling back the directories. 15:40:41 ServiceName not found. Using Default: Remedy Action Request System Server 15:40:41 -[ERROR]: AR System Database upgrade error. The original database is intact and accessible. Anyboby have something similar. Or suggestion. John Kelley Help Desk Analyst 130 Royall Street Canton, MA 02021 Mail Center 1W 781-737-3564 ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it_20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Error sending email
Yea, doing the conversations manually will tell you where the problem is, and the docs/google for whatever MTA is in use should tell you how to fix it. Axton McKenzie, James J C-E LCMC HQISEC/L3 wrote: ** Axton: You just about hit the nail on the head. However, I've seen mail servers (MTA) that are setup to allow local delivery only where this error (SMTP 550) happens. The fix is to reconfigure the MTA to allow delivery to a limited set of addresses only. Also, thanks for the wiki page for MTA conversations. It's filed away. James McKenzie L-3 GSI -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Grams Sent: Friday, September 01, 2006 12:12 PM To: arslist@ARSLIST.ORG Subject: Re: Error sending email What MTA are you using (e.g., sendmail) and what is the from address configured in the AR System Email Mailbox Configuration form? Try to do a telnet session to your MTA using smtp (port 25) and see if you can send the message. See http://en.wikipedia.org/wiki/Simple_Mail_Transfer_Protocol for instructions on having a conversation with your smtp server. If you still receive the smtp 550 it's because relaying to address x (probably outside domains, most common configuration) is not allowed by your MTA. Axton Grams Rafael Bertolini wrote: Hi all!!! I've created a SLA that sends an email after sometime a incident is created. It also sends an alert. The SLA is working, since I've got the alert, but no email was sent. In the AR System Email Error Logs, I've got this message Invalid Addresses; nested exception is: class javax.mail.SendFailedException: 550 5.7.1 [EMAIL PROTECTED]... Relaying denied javax.mail.SendFailedException: Invalid Addresses; nested exception is: class javax.mail.SendFailedException: 550 5.7.1 [EMAIL PROTECTED]... Relaying denied at com.sun.mail.smtp.SMTPTransport.rcptTo(SMTPTransport.java:848) at com.sun.mail.smtp.SMTPTransport.sendMessage(SMTPTransport.java:323) at com.remedy.arsys.emaildaemon.SenderModule.sendMessage(SenderModule.java:74) at com.remedy.arsys.emaildaemon.CreatorModule.createMessage(CreatorModule .java:1468) at com.remedy.arsys.emaildaemon.CreatorModule.doWork(CreatorModule.java:360) at com.remedy.arsys.emaildaemon.ThreadBase.run(ThreadBase.java:268) at java.lang.Thread.run(Thread.java:534) It says invalid addresses, but the email [EMAIL PROTECTED] is correct (mine). What else could be? ARS 6.3 Solaris 8 TIA, Rafael Bertolini __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Setup Dev Server
I duplicate databases infrequently. The metadata (actlink_open, email mailbox, etc.) are fairly easy to clean with pl/sql. Copying between different tablespaces is a little tricky due to LOB storage, but not impossible. You have to manually create the tables with modified DDL (specifying lob storage) that have LOBs prior to running the imp of the dmp file to ensure the LOBS go to the right tablespace during import. http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:378418239571#16075038165527 The main reason we do it this way is because this method puts the margin for error/reliability and the time required to complete are in our favor. Axton Grams McKenzie, James J C-E LCMC HQISEC/L3 wrote: ** Fred: (Wacking self on head). Thanks. Now the next question is how did they duplicate the database? There are variables in the Remedy metadata that will error out if they did a physical vice ARExport/ARImport move of data. This may be causing the problem. I tried a physical move from one tablespace to another on the same server and Oracle would not let me. James Mckenzie L-3 GSI *From:* Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] *On Behalf Of *Grooms, Frederick W *Sent:* Friday, September 01, 2006 12:12 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Setup Dev Server ** He said they were on 2 different servers *From:* Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] *On Behalf Of *McKenzie, James J C-E LCMC HQISEC/L3 *Sent:* Friday, September 01, 2006 1:41 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Setup Dev Server ** Fred: I think the problem may be that the production and dev servers are pointing to the same Oracle DB Instance and that they are installed in two different tablespaces. This can lead to disaster of major proportions. Solution: Have DBA create a second instance on the Oracle DB for development. Or install Oracle on a second server (this is LEGAL per Oracle.) James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: Friday, September 01, 2006 11:17 AM To: arslist@ARSLIST.ORG Subject: Re: Setup Dev Server Do you have the environment variables set up correctly? The 32 bit Oracle 9iR2 client in the path before your 64 bit Oracle 9iR2 client. ORACLE_HOME pointing to your 32 bit Oracle 9iR2 client. ORACLE_SID and TWO_TASK set for your dev database. TNS_ADMIN pointing to your tnsnames.ora file. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of John Kelley Sent: Friday, September 01, 2006 10:31 AM To: arslist@ARSLIST.ORG Subject: Setup Dev Server Hi List: First time emailer. Long time reader. I'm trying to setup our Dev Box(Windows 2003sp1) with AR 6.3. Having errors upgrading an existing DB. We took a copy of production DB, and placed it on a different oracle Server. Oracle 9.2.0.4.0 64bit. My tnsnames is set correctly to Dev Server and connection to remedb listener. The name of the DB is the same for Production and Dev. Which is OK. They are on different servers. When I'm setting up the Dev server running server.exe, Its asks for SID name and what type of install. Upgrade, Overwrite or Shared. I select Upgrade because the DB out there is an exact copy of the Production having all the Data - I want the data in tact just to install the Server. Here is the Error 15:40:39 An error was encountered during the upgrade of the AR System database. 15:40:39 Installation terminating ... Original database server is intact and accessible 15:40:39 Resolve the problem that causes the error (contact Technical Support, if necessary) 15:40:40 -[ShowMsg]: Setup is rolling back directories 15:40:40 Setup is rolling back the directories. 15:40:41 ServiceName not found. Using Default: Remedy Action Request System Server 15:40:41 -[ERROR]: AR System Database upgrade error. The original database is intact and accessible. Anyboby have something similar. Or suggestion. John Kelley Help Desk Analyst 130 Royall Street Canton, MA 02021 Mail Center 1W 781-737-3564 ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at http
Re: Setup Dev Server
That's why it's better to look up the schema ids and field ids in your workflow based on the form/field names, then use var substitution in your direct sql (e.g. select C$fieldid1$ from T$schemaid1$ where C$fieldid2$ = 'some literal value or field'). Axton Grams McKenzie, James J C-E LCMC HQISEC/L3 wrote: ** Axton: Definitely the way to copy a tablespace from one server to another. I had forgotten about copying the LOB space, too. I tend to use Export/Import from Remedy rather than do this at the DB level. However, this does not scale well if you are working with Direct SQL and reference tables by name. James McKenzie L-3 GSI -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Grams Sent: Friday, September 01, 2006 12:53 PM To: arslist@ARSLIST.ORG Subject: Re: Setup Dev Server I duplicate databases infrequently. The metadata (actlink_open, email mailbox, etc.) are fairly easy to clean with pl/sql. Copying between different tablespaces is a little tricky due to LOB storage, but not impossible. You have to manually create the tables with modified DDL (specifying lob storage) that have LOBs prior to running the imp of the dmp file to ensure the LOBS go to the right tablespace during import. http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:378418239571#16075038165527 The main reason we do it this way is because this method puts the margin for error/reliability and the time required to complete are in our favor. Axton Grams McKenzie, James J C-E LCMC HQISEC/L3 wrote: ** Fred: (Wacking self on head). Thanks. Now the next question is how did they duplicate the database? There are variables in the Remedy metadata that will error out if they did a physical vice ARExport/ARImport move of data. This may be causing the problem. I tried a physical move from one tablespace to another on the same server and Oracle would not let me. James Mckenzie L-3 GSI -- -- *From:* Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] *On Behalf Of *Grooms, Frederick W *Sent:* Friday, September 01, 2006 12:12 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Setup Dev Server ** He said they were on 2 different servers -- -- *From:* Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] *On Behalf Of *McKenzie, James J C-E LCMC HQISEC/L3 *Sent:* Friday, September 01, 2006 1:41 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Setup Dev Server ** Fred: I think the problem may be that the production and dev servers are pointing to the same Oracle DB Instance and that they are installed in two different tablespaces. This can lead to disaster of major proportions. Solution: Have DBA create a second instance on the Oracle DB for development. Or install Oracle on a second server (this is LEGAL per Oracle.) James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: Friday, September 01, 2006 11:17 AM To: arslist@ARSLIST.ORG Subject: Re: Setup Dev Server Do you have the environment variables set up correctly? The 32 bit Oracle 9iR2 client in the path before your 64 bit Oracle 9iR2 client. ORACLE_HOME pointing to your 32 bit Oracle 9iR2 client. ORACLE_SID and TWO_TASK set for your dev database. TNS_ADMIN pointing to your tnsnames.ora file. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of John Kelley Sent: Friday, September 01, 2006 10:31 AM To: arslist@ARSLIST.ORG Subject: Setup Dev Server Hi List: First time emailer. Long time reader. I'm trying to setup our Dev Box(Windows 2003sp1) with AR 6.3. Having errors upgrading an existing DB. We took a copy of production DB, and placed it on a different oracle Server. Oracle 9.2.0.4.0 64bit. My tnsnames is set correctly to Dev Server and connection to remedb listener. The name of the DB is the same for Production and Dev. Which is OK. They are on different servers. When I'm setting up the Dev server running server.exe, Its asks for SID name and what type of install. Upgrade, Overwrite or Shared. I select Upgrade because the DB out there is an exact copy of the Production having all the Data - I want the data in tact just to install the Server. Here is the Error 15:40:39 An error was encountered during the upgrade of the AR System database. 15:40:39 Installation terminating ... Original database server is intact and accessible 15:40:39 Resolve the problem that causes the error (contact Technical Support, if necessary) 15:40:40 -[ShowMsg]: Setup is rolling back directories 15:40:40 Setup
Re: Bulk remove users part II
Why not just have the escalation run the application-query-delete-entry against the form that holds that list of login names to delete? No join, no filters. Axton Grams [EMAIL PROTECTED] wrote: Mike, If you create a form to hold the variable submitter name, build workflow to create an entry in it which meets your requirements. i.e if thet are all in a certain group add a filter to SHR:People that checks if the user doing the submit is in that group and if they are push an entry to the new form. Set the push so it creates only one record. Then add a display only selection field to the SHR:People called Delete Entry with a single value of Yes. Build a inner join form between the SHR:People and the new form joining on the submitter field. Then build an escalation to run overnight on the join form with no qualification so that it finds all the records and do a set fields on the Delete Entry field. Finally build a filter on the SHR:People form to do the application delete when this field is set to Yes. If you are deleting people who may have entries in the user form you will need to extend the delete across to this form by again touching a similar delete record field causing another application delete on that form. Same goes for the SHR:Assignment form. I hope this helps Brian Bishop +44(0)7973 746832 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Michael LoSapio Sent: 31 August 2006 20:40 To: arslist@ARSLIST.ORG Subject: Bulk remove users part II All, So, I read what a bunch of you had posted and spoke with Remedy Support. The BEST thing I could come up with was an escalation to run on the SHR:People with the Run If qualification being something like 'Submitter'=Mike then run process Application-Delete-Entry SHR:People Request ID So, I was basically told me there was NO way to script the removal process to run nightly without ANY actual manual intervention. ie: we would need to change the RUN IF qualification manually in order to remove entries in the form. Is this in fact correct?... there is no way to run a nightly process which traverses through an imported list of Submitters and removes them all from the system?? Is there a way to create a variable in the escalation's RUN IF string... or can I execute it off a command line. I was pretty shocked to hear this too, being new to the AR system and reading all the documentation about how it is supposed to adapt to YOUR business needs and not adapt your business needs to the system. Any input would be greatly appreciated. -Mike ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Bulk remove users part II
To extend on this, if you use a character field for the control field, you can run any number of commands using that one field (e.g., delete, archive, etc.), having different filters for each operation qualifying on that field. Makes sharing the workflow easy. Axton Grams Heider, Stephen wrote: Mike, This is done all the time ??? One way is to add a display only radio button field that includes one option: Delete. A filter on your form is used to perform the actual delete with the Application-Delete-Entry command. The escalation will set this field to Delete for all matching records. If you want to extend this concept add one more selection to the said radio button called Ready to Delete. One or more processes and/or escalations would set this field to Ready to Delete. Then an escalation would run nightly (for example) that sets this field to Delete for all records that have the field set to Ready to Delete. This way, you have some time during the day (if you want) to review records that are flagged for deletion. To take this one step further, set the Field Id of the radio button field to a number that you normally won't use (within the range of user defined Id numbers). Then, you can simply copy this field to any other form (keeping the same field Id) and update the one filter that will handle any number of tables. Stephen -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Michael LoSapio Sent: Thursday, August 31, 2006 3:40 PM To: arslist@ARSLIST.ORG Subject: Bulk remove users part II All, So, I read what a bunch of you had posted and spoke with Remedy Support. The BEST thing I could come up with was an escalation to run on the SHR:People with the Run If qualification being something like 'Submitter'=Mike then run process Application-Delete-Entry SHR:People Request ID So, I was basically told me there was NO way to script the removal process to run nightly without ANY actual manual intervention. ie: we would need to change the RUN IF qualification manually in order to remove entries in the form. Is this in fact correct?... there is no way to run a nightly process which traverses through an imported list of Submitters and removes them all from the system?? Is there a way to create a variable in the escalation's RUN IF string... or can I execute it off a command line. I was pretty shocked to hear this too, being new to the AR system and reading all the documentation about how it is supposed to adapt to YOUR business needs and not adapt your business needs to the system. Any input would be greatly appreciated. -Mike ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Hellllloooooo!!!!
Rick: Do you think I could pass the RSP or RAC tests? Axton Grams ...couldn't resist a little Friday humor on a Thursday Rick cook wrote: ** Audrey, if the RSP class is like the RAC class, you'll need to demonstrate the ability to gather requirements from a customer, write a requirements doc., develop a system from a set of requirements, and present it to the customer. The application is significant, but isn't a rocket science type of thing. There's also a written test. And Pleasanton is a wonderful place to have a class. If you go, you HAVE to go to the old downtown. I just love it there. Rick *From:* Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] *On Behalf Of *McKenzie, James J C-E LCMC HQISEC/L3 *Sent:* Thursday, August 31, 2006 2:52 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Heloo ** Audrey: You want Lenny as your instructor if he teaches the course. I've heard that he is working on the other instructors trying to bring them up to and keeping them at his level. James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Audrey H Franklin Sent: Thursday, August 31, 2006 12:23 PM To: arslist@ARSLIST.ORG Subject: Re: Heloo James, I am not familiar with Pleasanton, CA. All Remedy Classes I attended were in Columbia, MD. However, I plan to take the RSP class in October, and would like to know if you have any pointers on the best way to prepare? My role and responsibilities at work does not give me any opportunity to develop, so I installed Remedy at home and am trying to build applications. All suggestions are welcome. Many Thanks, Audrey Franklin - Original Message - From: McKenzie, James J C-E LCMC HQISEC/L3 [EMAIL PROTECTED] Date: Thursday, August 31, 2006 3:08 pm Subject: Re: Heloo Audrey: Pleasanton, CA BMC training center. It is 'around the corner' from the old Remedy Training Center. James Mckenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Audrey H Franklin Sent: Thursday, August 31, 2006 12:01 PM To: arslist@ARSLIST.ORG Subject: Re: Heloo James, Where was this class held? Audrey - Original Message - From: McKenzie, James J C-E LCMC HQISEC/L3 [EMAIL PROTECTED] Date: Thursday, August 31, 2006 2:54 pm Subject: Re: Heloo Audrey: Yes there was the normal $500/day school charge. However, we got to do something special each day for lunch. The first day was a get together with Engineering. The second was a session with DOUG! The third was a get together with employees of BMC. It was definitely worth the monies as we got to ask questions and work with the fine folks at BMC. I walked away with a good deal of knowledge and a lot of walking (I stayed at the Larkspur and got to eat In-n-Out!) James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Audrey H Franklin Sent: Thursday, August 31, 2006 11:51 AM To: arslist@ARSLIST.ORG Subject: Re: Heloo James, Thanks, is there a charge/fee for this boot camp? Audrey - Original Message - From: McKenzie, James J C-E LCMC HQISEC/L3 [EMAIL PROTECTED] Date: Thursday, August 31, 2006 2:41 pm Subject: Re: Heloo Audrey: None of the non-attendees had access. I think that BMC wanted to hold a series of Boot Camps where the presentations would be run again. Unfortunately, this did not happen. I attended the Boot Camp at P'town in December of 2004. It was very informative and I would like to see this offered again for those of us who cannot attend BUW for one reason or another. James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Audrey H Franklin Sent: Thursday, August 31, 2006 11:25 AM To: arslist@ARSLIST.ORG Subject: Re: Heloo I am in the office as well. Been working with Remedy for 4 years, attendedone RUG, which was wonderful. Hoping that the presentations are made available to those who could not attend. Last year, I did not have access to a single presentation. Audrey Franklin - Original Message - From: Pickering, Christopher [EMAIL PROTECTED] Date: Thursday, August 31, 2006 2:11 pm Subject: Re: Heloo Not by a long shot. Chris Pickering -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: Thursday, August 31, 2006 2:08
Re: Hellllloooooo!!!!
Lenny is definitely the most knowledgeable/active instructor available. I was impressed by his level of knowledge. Axton Grams Audrey H Franklin wrote: James, That's a great suggestion, I will find out who is teaching the class in Naperville, Illinois in October. Audrey - Original Message - From: McKenzie, James J C-E LCMC HQISEC/L3 [EMAIL PROTECTED] Date: Thursday, August 31, 2006 5:52 pm Subject: Re: Heloo Audrey: You want Lenny as your instructor if he teaches the course. I've heard that he is working on the other instructors trying to bring them up to and keeping them at his level. James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Audrey H Franklin Sent: Thursday, August 31, 2006 12:23 PM To: arslist@ARSLIST.ORG Subject: Re: Heloo James, I am not familiar with Pleasanton, CA. All Remedy Classes I attended were in Columbia, MD. However, I plan to take the RSP class in October, and would like to know if you have any pointers on the best way to prepare? My role and responsibilities at work does not give me any opportunity to develop, so I installed Remedy at home and am trying to build applications. All suggestions are welcome. Many Thanks, Audrey Franklin - Original Message - From: McKenzie, James J C-E LCMC HQISEC/L3 [EMAIL PROTECTED] Date: Thursday, August 31, 2006 3:08 pm Subject: Re: Heloo Audrey: Pleasanton, CA BMC training center. It is 'around the corner' from the old Remedy Training Center. James Mckenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Audrey H Franklin Sent: Thursday, August 31, 2006 12:01 PM To: arslist@ARSLIST.ORG Subject: Re: Heloo James, Where was this class held? Audrey - Original Message - From: McKenzie, James J C-E LCMC HQISEC/L3 [EMAIL PROTECTED] Date: Thursday, August 31, 2006 2:54 pm Subject: Re: Heloo Audrey: Yes there was the normal $500/day school charge. However, we got to do something special each day for lunch. The first day was a get together with Engineering. The second was a session with DOUG! The third was a get together with employees of BMC. It was definitely worth the monies as we got to ask questions and work with the fine folks at BMC. I walked away with a good deal of knowledge and a lot of walking (I stayed at the Larkspur and got to eat In-n-Out!) James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Audrey H Franklin Sent: Thursday, August 31, 2006 11:51 AM To: arslist@ARSLIST.ORG Subject: Re: Heloo James, Thanks, is there a charge/fee for this boot camp? Audrey - Original Message - From: McKenzie, James J C-E LCMC HQISEC/L3 [EMAIL PROTECTED] Date: Thursday, August 31, 2006 2:41 pm Subject: Re: Heloo Audrey: None of the non-attendees had access. I think that BMC wanted to hold a series of Boot Camps where the presentations would be run again. Unfortunately, this did not happen. I attended the Boot Camp at P'town in December of 2004. It was very informative and I would like to see this offered again for those of us who cannot attend BUW for one reason or another. James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Audrey H Franklin Sent: Thursday, August 31, 2006 11:25 AM To: arslist@ARSLIST.ORG Subject: Re: Heloo I am in the office as well. Been working with Remedy for 4 years, attendedone RUG, which was wonderful. Hoping that the presentations are made available to those who could not attend. Last year, I did not have access to a single presentation. Audrey Franklin - Original Message - From: Pickering, Christopher [EMAIL PROTECTED] Date: Thursday, August 31, 2006 2:11 pm Subject: Re: Heloo Not by a long shot. Chris Pickering -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: Thursday, August 31, 2006 2:08 PM To: arslist@ARSLIST.ORG Subject: Re: Heloo You two are not alone. Axton On 8/31/06, McKenzie, James J C-E LCMC HQISEC/L3 [EMAIL PROTECTED] wrote: ** Fred: The people who normally post a lot are at BUW. You and I are at work enjoying ourselves... James McKenzie From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: Thursday, August 31, 2006 10:54 AM To: arslist@ARSLIST.ORG Subject: Re: Heloo To: arslist@ARSLIST.ORG Subject: Re: Heloo
Calendaring Utility
I found this little utility that lays out time line information. I think its far superior to the change management calendar viewer. It's available under the BSD license. Very cool stuff. http://simile.mit.edu/timeline/ I'm working on using this with Remedy for infrastructure change/task mapping. I'll post what I can put together. Axton Grams ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Request for Enhancement (RFE) community discussion at BMC UserWorld - open invitation
No offense Dave, but it seems like this should be made available to all paying customers, regardless of their ability to attend BUW. Axton Grams Easter, David wrote: Hello, ARSListers; How would you like to have a greater influence on new features and functionality in AR System and ITSM applications? My name is David J. Easter and I'm a Product Manager with BMC Remedy. I am hosting a Thursday lunch discussion at BMC UserWorld of the current Request For Enhancement (RFE) process for BMC Remedy enhancement requests. My goal for the meeting is to: - Educate attendees on the current RFE process - This includes both how customers see the process and a glimpse into the internal processing - Give some tips when submitting an RFE that will increase the chances of your enhancement being implemented - Brainstorm ways the community could better define, prioritize and manage the flow of RFEs into BMC Remedy The meeting will be on Thursday, 8/31. It will be in the Sutter Room on the 6th floor of the hotel and will begin at 12:00pm. Lunch will be provided (sandwich buffet). The room will hold 30 people comfortably, so come early if you want to ensure you get a seat. (Others will not be turned away - but it may be Standing Room Only.) This meeting is a grass roots effort by me to encourage more participation of the community in the general RFE process. However, solid suggestions that come out of this meeting will be folded into the official process if appropriate. Please come by if you have the time and desire. I look forward to meeting you all! -David J. Easter Sr. Product Manager, Service Management Business Unit BMC Software, Inc. ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: After all these years (10) confused about Licensing
Does the DO form have any tables fields, menus, active links that do set fields/push fields operations, etc. that would do things classified as a 'query'? Or is the license simply allocated when the form is opened (where no work flow is present)? Axton Grams L. J. Head wrote: ** But is opening of a dialog considered any of those 3? L. J. Head Software Engineer Remedy Approved Consultant *From:* Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] *On Behalf Of *Thomas Bean *Sent:* Friday, August 25, 2006 2:09 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: After all these years (10) confused about Licensing ** According to KM-5221 in SupportWeb, floating write tokens are issued to a user any time a Submit, Modify, or Query action takes place. --Thomas - Original Message - *From:* Geoff Endresen mailto:[EMAIL PROTECTED] *Newsgroups:* gmane.comp.crm.arsystem.general *Sent:* Friday, August 25, 2006 14:57 *Subject:* After all these years (10) confused about Licensing Riddle me this Batman or Wonder Woman, Why does the Remedy Server issue a floating write license when a user logs into the server and opens a dialog form. My understanding is that user would be issued a floating read license at the time of login and then would be issued a floating license until they modify a form entry. We have tested this via the User Tool and via the Mid-Tier and we have similar results. AR System 6.3 Patch 017 Oracle 10g with UTF-8 Red Hat Enterprise Linux release 3 (RHEL-3) Thanks, -Geoff Endresen Amazon.com __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: After all these years (10) confused about Licensing
How convenient for them. Axton Geoff Endresen wrote: So Can you conclude that simply using centralized preferences for all of your support-level users will cause them to start up with a Floating WRITE instead of a Floating READ license, or was this something unique to a custom form?? Since this display-only form has no workflow on open, no menus, only a couple character fields and one button, I do believe this to be strange but true. I wouldn't limit it to support-leve user. I'm concluding that it's any user with a floating license. Thanks, -Geoff -Original Message- From: strauss [EMAIL PROTECTED] Sent: Aug 25, 2006 5:53 PM To: arslist@ARSLIST.ORG Subject: Re: After all these years (10) confused about Licensing So Can you conclude that simply using centralized preferences for all of your support-level users will cause them to start up with a Floating WRITE instead of a Floating READ license, or was this something unique to a custom form?? Christopher Strauss, Ph.D. Remedy Database Administrator University of North Texas Computing Center http://remedy.unt.edu/helpdesk/ -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Geoff Endresen Sent: Friday, August 25, 2006 4:47 PM To: arslist@ARSLIST.ORG Subject: Re: After all these years (10) confused about Licensing I found more... (I sure like talking to myself) ;0) There WAS a ARGetListEntry API call to the AR User Preferences form for every user login that opens a display only form. So infact unknowingly the Preferences Server eats licenses. Chomp, Chomp. We deleted the AR User Preferences form and then the same login attempt as before opening a display-only form gives the expected Floating(Read) license. I'm not as confused, still a bit crazy, -Geoff ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Remedy 7 on CentOS?, other Linuxes
James: The patch is available on arswiki.org at: http://arswiki.org/wiki/index.php?title=ARS_7.0_Topics One issue I ran in to, though I think it specific to my server, is that no objects show in the admin tool. Haven't had time to rebuild/verify, so do post if you do or do not experience the same issue. If you do, we will find a solution. Axton Grams Doug Blair wrote: Axton - I was trying the same thing with the Fedora project Linux release. Aside from changing the name of the release and commenting out the section of the install script where it looks for the redhat AS (Advanced Server) version, did you need to make other significant changes in ar_install? Offlist is fine, I think, unless there are zillions of us ;-) Doug -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: Wednesday, August 16, 2006 8:21 AM To: arslist@ARSLIST.ORG Subject: Re: Remedy 7 on CentOS? I am toying with CentOS 4.3 and ARS 7.0p1. Not using it in a production environment though. The problems I had are: - the install script checks the rpm's to get the version/distribution of linux you are using. I can send a diff tonight of the changes I had to make to the install script to get it to install. The release in centos is centos-release instead of redhat-release. This causes the install script to not recognize the flavor of linux and exit. - once installed, when i log in with the admin tool, the object lists are all empty (no forms, active links, etc.) Axton Grams On 8/16/06, James Pifer [EMAIL PROTECTED] wrote: I'm going to be upgrading to Remedy 7 soon. At the same time I'm going to switch from Windows 2000 to Linux. For those running linux, is anyone running on CentOS? What version of CentOS OR Redhat Enterprise are people running? Any other linux flavors being run? Thanks, James __ _ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __ _ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: ARS API Instalation - Solaris
Unpack that puppy if you have it handy. If not wget http://arswiki.org/dist/ars/api/api_sol_en_700_000.tar.gz wget http://arswiki.org/dist/ars/api/api_sol_en_63_000.tar.gz wget http://arswiki.org/dist/ars/api/api_sol_en_601_1490.tar.gz depending on the version you need. Axton Grams Luke, Brian wrote: You can pull the entire api directory and samples from the installer package. 1.) Unzip untar the installer. 2.) cd arsystem 3.) cd solaris 4.) tar xf arsystem.tar 5.) The api directory is then available to be copied 6.) Just rezip the tar and delete the entire installer directory to recover the storage HTH, -Brian Luke ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: archgid for version 7?
should be available in the arserver install directory axton Watson, Matthew (Melbourne) wrote: ** Hi all, Has anyone seen or got a copy of the archgid utility for AR 7? I can't see one in the community downloads and the 6.3 version doesn't run under AR 7 (it detects that the database version is too high…). Thanks, *Matthew D Watson* Remedy Application Developer ITS KPMG 161 Collins Street Melbourne VIC 3000 Australia Tel +61 3 9288 5491 Fax +61 3 9288 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ** The information in this e-mail is confidential and may be legally privileged. It is intended solely for the addressee. Access to this e-mail by anyone else is unauthorised. If you have received this communication in error, please notify us immediately by return e-mail with the subject heading Received in error or telephone +61 2 93357000, then delete the email and destroy any copies of it. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Any opinions or advice contained in this e-mail are subject to the terms and conditions expressed in the governing KPMG client engagement letter. Opinions, conclusions and other information in this e-mail and any attachments that do not relate to the official business of the firm are neither given nor endorsed by it. KPMG cannot guarantee that e-mail communications are secure or error-free, as information could be intercepted, corrupted, amended, lost, destroyed, arrive late or incomplete, or contain viruses. KPMG, an Australian partnership, is part of the KPMG International network. KPMG International is a Swiss cooperative that serves as a coordinating entity for a network of independent firms operating under the KPMG name. KPMG International provides no services to clients. Each member firm of KPMG International is a legally distinct and separate entity and each describes itself as such. Liability limited by a scheme approved under Professional Standards Legislation. This footnote also confirms that this e-mail message has been swept by MIMEsweeper for the presence of computer viruses. See www.mimesweeper.com for more information. ** __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
ARServer 7.0p1/ARAdmin 7.0p1 - Objects not showing in Admin Tool
Has anyone else run into this? When I try to display the list of forms/active links on the server, no objects are shown in the admin tool. The api call to retrieve the list is never even seen in the server api logs. If I do a view by form in the admin tool, I can see it pass the api call to retrieve the list of forms and the list shows up in the dialog. I am able to reproduce this from multiple workstations for this server install. Server Information: [EMAIL PROTECTED] bin]$ uname -a Linux xyz 2.6.9-34.0.1.ELsmp #1 SMP Wed May 24 08:14:29 CDT 2006 i686 i686 i386 GNU/Linux Local Oracle 10g db Axton Grams ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Menu Window
I've seen this with the 6.0.1 and 7.0 user tool. Axton [EMAIL PROTECTED] wrote: Hi, very annoying, sometimes the window menu does not show all windows opened, only 'Cascade, Tile and Arrange', someone else seen this behaviour? L ars Pettersson Vattenfall Business Services Nordic AB Action Request System Engineer (Tabasco) S-461 88 Trollhättan Sweden Phone +46 520 888 35 Mobil +46 70 608 99 95 e-mail: [EMAIL PROTECTED] ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
ARSWiki: New Article
A new article is available on ARSWiki covering known, unaddressed security vulnerabilities in Remedy and Remedy related products. I have posted three vulnerabilities that I found first-hand. There is interest in the following types of vulnerabilities, if anyone can contribute: - XSS (cross-site scripting) vulnerabilities in Mid-Tier 6.0.1, 6.3, and 7.0 - DoS vulnerabilities via api calls. e.g., call x with parameter y causes ARS to crash http://arswiki.org/wiki/index.php?title=ARS_Vulnerabilities Thanks, Axton Grams ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Deleted Groups
This is a good point. The caching operation for the new group can take some time to complete. If the server is in development cache mode, all other operations wait for the recache to complete. Let it run for 2 hrs if needed. Turn on the api logging before importing and see what the last call is, and whether it returns an ok or fail message. Axton Heider, Stephen wrote: ** Kathy, I tested the emptying of the Group form and re-importing today. Both when deleting the Group records and when importing Group records it took a very long time. I had thought it locked up. I was able to get it to work by letting it have as much time as it needed - about 30 minutes. Is it possible that it just needs more time? Stephen *From:* Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] *On Behalf Of *Kathy Morris *Sent:* Thursday, July 27, 2006 2:42 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Deleted Groups ** Yes, I was able to successfully import the Group form from Prod to Dev. However when I try to import the group.arx into the group form, the application hangs. I am on 6.3 AR, patch 17. I use the default ports. I reinstalled an upgrade of AR Server 6.3. __20060125___This posting was submitted with HTML in it_20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Performance concern about table field off a database table view..
Oracle's semi-equivalent is called 'materialized views'; though I've only seen them commonly used for batch replication purposes. Axton Grams Joe DeSouza wrote: ** This is nice to know... I am on Oracle however so I guess I have one less consideration to think about.. Joe */Heider, Stephen [EMAIL PROTECTED]/* wrote: It depends upon the DBMS. SQL Server supports indexed views http://www.sqlteam.com/item.asp?ItemID=1015 Stephen -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black Sent: Friday, July 14, 2006 9:00 AM To: arslist@ARSLIST.ORG Subject: Re: Performance concern about table field off a database table view.. Joe, To my knowledge adding an index on a view is not possible. The view itself has no data in it to index. :) ( and your welcome. I am glad to try to help. :) -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. Never ascribe to malice, that which can be explained by incompetence. Do you Yahoo!? Everyone is raving about the all-new Yahoo! Mail Beta. http://us.rd.yahoo.com/evt=42297/*http://advision.webevents.yahoo.com/handraisers __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Solaris 10 and Oracle 9i
We are running 10g on Solaris 9. Only thing I can add is that 7.0 requires the 10g client. Axton Grams Christopher Pruitt wrote: Hello Fellow Listers, I would hear from any of you that has any experience with running Oracle 9i on Solaris 10. We are considering upgrading our servers to Solaris 10 and continue to run our Oracle 9i database but need to know if there are any issues, pitfall, show stoppers, or any other bugs, as well as successful implementations of this configuration. Any feedback would be appreciated. Christopher Pruitt Consultant Specialist EDS - Bank of America I3 Production Support Team Phone: +1-972-605-7702 (8-835) mailto:[EMAIL PROTECTED] ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: arplugin problems..... or is it.....
The debug binary will tell remedy the memory contents with the symbols translated, allowing them to see what is going on when you have this problem. I would definitely pursue this route. Axton Grams Stephen Earl wrote: ** we use a set of ardbc plugins to communicate with external dbs: mssql, mysql and postgres these have been stable for many months, and not caused any issues, all our workflow is bog standard stuff nothing 'funky' or special going on here really... the main thing we find 'odd' is that a nice clean reinstall sorts it out, not an overwrite but an app server install into a whole new directory, of course we don't do a whole new db, we just tell the installer to 's'hare the db, all is then ok again for a while until something requires the AR or arplugin server to be restarted, then there is no guarantee, it's not even consistent (would probably help if it was) I'm wondering if when the restart occurs if someone is doing something that access the plugins and they are magically doing something very specific it just causes 'something bad' to happen... BMC have said that 'You might need a debug binary for this' I won't repeat my response to that but I'm sure you can all guess the general tone ;-) Stephen On 11/07/06, *McKenzie, James J C-E LCMC HQISEC/L3* [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: ** Stephen: It sounds like it is time to YELL at BMC about this problem. Anything that takes down a production server is a 'BAD THING. I really don't have any other ideas as to why the plug-in server should be causing problem on a 'stock' installation. You don't have any special processes accessing the plug-in server? James McKenzie From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG] On Behalf Of Stephen Earl Sent: Tuesday, July 11, 2006 2:23 PM To: arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG Subject: Re: arplugin problems. or is it. ** James, We've been through the 'Plugn-Port' option in the ar.conf and specified in the AR Admin however still keep getting this, today we had it happen simultaneously on both our 'production' and 'hot backup' server this resulted in our app becoming totally unavailable... Again we ended up having to resort to a full blow reinstall to get one of the servers back into production again :( This is the first time I've ever seen anything like this happen to an AR Application server it's getting kinda worrying.. We do now have a server back in production and running fine, and I'm going to reinstall my Hot Backup server tomorrow and try to force it to break, although the problem only seems to turn up when we actually have users connected. Any further thoughts greatly appreciated... and yes we do have remedy support looking at this too.. but at the moment they appear to be as confused as I am :-) Stephen On 06/07/06, McKenzie, James J C-E LCMC HQISEC/L3 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: ** Stephen: Do so through the Admin process (Admin tool for ARS 6.3.) James McKenzie __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: ARERR 405 exporting Display Only form to .def file
The cause of this is that in prior versions (I want to say 5.0.1 and earlier), core fields were allowed on display only forms, but ARS was changed at some revision to disallow this. If you performed an upgrade installation, then any display only forms that contain certain core fields would generate this error when manipulated. Ran into this in the past but can't remember what exactly I did to correct the problem. Some potentials: - archgid utility - Export a def of the form from a server running an older version of ars, modify the def to not include the core fields and import on the newer server. (Think this is what I did, but this predated the archgid utility) - Delete the field - Delete the form and recreate it Axton Grams McKenzie, James J C-E LCMC HQISEC/L3 wrote: ** Fred: I might be able to test this in the near future. James McKenzie From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: Monday, July 10, 2006 1:58 PM To: arslist@ARSLIST.ORG Subject: Re: ARERR 405 exporting Display Only form to .def file ** I think you might be able to change from a core field to some other field. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3 Sent: Monday, July 10, 2006 3:53 PM To: arslist@ARSLIST.ORG Subject: Re: ARERR 405 exporting Display Only form to .def file ** Fred: Will this work with a core field? James McKenzie [Information on ARCHGID deleted] __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: help With API
Java JNI wrappers require the native c libs for each platform. Axton Grams McKenzie, James J C-E LCMC HQISEC/L3 wrote: ** Carey: You stated Java application...That means it should work on a Mac, Solaris, Windows, even my Java based phone. If it is not so, then it is technically not Java. James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black Sent: Thursday, July 06, 2006 2:04 PM To: arslist@ARSLIST.ORG Subject: Re: help With API James, As soon as Remedy publishes C API files for a Mac, then the Java Clients would work just fine. Unless some one wanted to go to the trouble of writing all of this stuff via a generic Web Service so that the MAC client could talk WS to the Mid-Tier server then talk ARS API back to the ARS server from there. (And it would require a Mid-Tier('ish) server for the config to work.) But that could be done too... -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. Never ascribe to malice, that which can be explained by incompetence. On 7/6/06, McKenzie, James J C-E LCMC HQISEC/L3 [EMAIL PROTECTED] wrote: ** Tim: Simple answer, Yes. How about making them Mac compatible too? (Strauss would love this.) James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tim Widowfield Sent: Thursday, July 06, 2006 1:57 PM To: arslist@ARSLIST.ORG Subject: Re: help With API Well... yes and no. The attempt to revive ESP's products has stalled, since I can't find any source later than 1999. Some of you may recall that I had written and maintained a freebie for creating entries on the command line, first for UWIP and then for cMango. That's part of Wipro's intellectual property now. Would anybody be interested in open-source, Java-based tools to create, modify, and delete entries (requests)? If so, I could build them put 'em out on my web site. Tim Widowfield [EMAIL PROTECTED] v: 937-878-9045 f: 937-878-9055 m: 937-369-7012 http://www.widowfield.com - Original Message From: McKenzie, James J C-E LCMC HQISEC/L3 To: arslist@ARSLIST.ORG Sent: Thursday, July 6, 2006 2:00:16 PM Subject: Re: [ARSLIST] help With API RE: help With API** Guillermo: What are you trying to do? Also, can you give the name of the product you received from ESP? There are folks out here who are working on the ESP product line. James Mckenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Guillermo Alfredo Torres Barron Sent: Thursday, July 06, 2006 10:48 AM To: arslist@ARSLIST.ORG Subject: help With API Importance: High H idear listers I need to API for create tickets in remedy version 6.3, I had an API that download it from elegant software but now the web page not exist =( Where I can download a API for Windows and Linux operating system?? Thanks in advance Greetings __ Atentamente Guillermo Alfredo Torres Barrón Proyectos ARS Remedy Grupo Financiero Banorte Calzada de Tlalpan #2980, Col. Ejidos de Santa Ursula Coapa, C.P. 04850 México, D.F. Tel Directo: 51746520, ext: 8505-2520 __20060125___This posting was submitted with HTML in it___ __ _ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: ARS 6.3 Install Issues
In versions past, I saw this problem if using SQL Server and mixing up the authentication mode for arserver/sql server. It would semi-create the db objects properly (owned by wrong user), then on restart during the install would not be able to reference those tables any more. Caused the user_x and group_x tables to be empty after the installer exited. Axton Grams Rick Cook wrote: I don't think this is a Remedy issue, Claire. Since you're trying to import data, I wonder if it's a DB error, not that it should be. Maybe something gateway-related between Import Tool and the DB? Rick -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sanford, Claire Sent: Thursday, July 06, 2006 2:31 PM To: arslist@ARSLIST.ORG Subject: ARS 6.3 Install Issues I have installed ARS 6.3 on my new server. It bombs when it comes time to import files Any idea what this message means? I have a ticket in with Remedy support, but I have not heard back from them yet. [ERROR][Thu Jul 06 16:02:50.825] VerifyControl- Unable to connect to the AR System Server. [ERROR][Thu Jul 06 16:02:50.825] VerifyControl- 90 Cannot open catalog; Message number = 90 DBREMEDY : RPC: Program not registered [ERROR][Thu Jul 06 16:02:50.825] rikMain- Problem with verification of user/pw/server information The Error log file is being closed [ERROR][Thu Jul 06 16:02:51.356] ImportDataFile- AR System Import Tool Thu Jul 06 16:02:51 2006 ARS 6.3 Oracle 10g2 (has the 9i libraries) Windows 2003 Enterprise Claire ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: ARS v7 and non-Unique user logins
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Carey Matthew Black wrote: All, Am I the only one who is _very_ disappointed to read the following? Ref: Release-Notes-700-Web.pdfpage: 18 Unique user logins In AR System 6.3, it was possible to have multiple users with the same user name but different passwords log in at the same time. AR System 7.0 does not allow multiple users with the same user name if you use the User form for authentication. If, however, you use external authentication, multiple users with the same user name can log in only if they belong to the same groups. (In the cache, only one session is created, and this session will be used for both users.) If you are upgrading to AR System 7.0 from a 6.3 system where you allow multiple users with the same user name but different passwords, the AR System upgrade scripts will fail and will generate a message suggesting that you correct the multiple user name problem. It sounds like they removed a very advanced (and very old) feature of ARS in the name of performance and at the cost of backwards compatibility. That is not a pattern that I would imagine most customers would value. I'm curious how you were using this feature. This is something I have never leveraged. When I needed an account that was shared (e.g., integrations), I used an admin account, where all programs used the same password. -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.3 (MingW32) iD8DBQFEZhgd2VxhVxhm8jIRAqvLAJ40pW4OsQyupxS6vX7bV1PlV4qgDgCfZN6h ZZKtj0lULZSprm+7DNzP1nI= =SrKK -END PGP SIGNATURE- ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Trouble with Custom Fields on AST:ComputerSystems Not Holding Data - ITSM 6.0
Candace DeCou wrote: Working on our upgrade from 5.0 to 6.0 ITSM and server upgrade from 5.1.0 to 6.3 Patch 16 on Windows 2003 with MS SQL 2000. At the last minute I discovered there were 8 custom fields on the old Asset form that had to be rebuilt in the new environment. I built those on BMC:BMC_ComputerSystem_ (Regular) form, then included those on the join BMC:BMC_Computer, then again included those on the join for AST:ComputerSystem. All fields display (with the DB name...yuck), but when I enter data into them and save, the data disappears. It is not hiding in any of the other underlying forms and I get no errors. Obviously I have done something wrong and I believe that this is salvageable, I am just not sure where I have gone wrong. Sorry, no courses in CMDB yet and we are live with this on Monday. I can manually input the data for these fields later, but need to figure this out. Appreciate any help from any of you who might know where I went wrong. Candace DeCou Applications Support Analyst Silicon Valley Bank Office: 408-654-6358 Email: [EMAIL PROTECTED] - * This message contains information from Silicon Valley Bank, or from one of its affiliates, that may be confidential and privileged. If you are not an intended recipient, please refrain from any disclosure, copying, distribution or use of this information and note that such actions are prohibited. If you have received this transmission in error, please notify the sender immediately by telephone or by replying to this transmission. This message may include indicative rate information relating to one or more products offered through Silicon Valley Bank, or affiliated broker-dealer, SVB Securities. Rates and yields shown are provided for informational purposes only, are not guaranteed, and are subject to market conditions and availability. Nothing in this communication shall constitute a solicitation or recommendation to buy or sell a particular security. Columbia Cash Reserves, Columbia Treasury Reserves, Columbia Institutional Cash Reserves, SVB Securities Liquid Reserves, SVB Securities Institutional Liquid Reserves and SVB Securities Horizon Shares are offered through SVB Securities, a registered broker- dealer and non-bank affiliate of Silicon Valley Bank. Investments in these products require the involvement of a licensed representative of SVB Securities. Investment products offered through SVB Securities are not insured by the FDIC or any other Federal Government Agency, are not deposits of or guaranteed by Silicon Valley Bank or its affiliates, and may lose value. ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org I don't have much practical experience with the CMDB, but shouldn't you use the class manager to add additional attributes? Won't this address adding the field to all the appropriate forms? Axton ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org