Maximo integration
Hello, Does Maximo support Java Messaging Services? Can it publish changes to a topic/queue? John ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Imort Locations
Hello all, I want to import the locations (which includes sites, countries etc) when setting up a new company. As I have seen there are a lot of forms regular or joined, which take part in the procedure and I guess I should import data to all of them. Has anyone done this procedure before,are there any steps which I have to follow? Thnx in advanced, Antonis -- View this message in context: http://www.nabble.com/Imort-Locations-tp25971281p25971281.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
problem importing form
Hi listers, I have a customer that has a problem importing a form from a .def file. After importing the form in the production environment, they don’t see it although they get the message: “Import Complete” as it were successfully completed. As workaround they have exported/imported the form in xml format, and everything works. Has anyone seen this strange behaviour? Thanks in advance, José Rodríguez Version: ARS 7.0.1 patch 009 on Windows ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: SLA time Calculations
Hi Mark, You will need to do the following. 1. Create a date time field to hold the d/t a call is placed into Pending 2. Create a date time field to hold the d/t a call is taken out of Pending 3. Create an integer field to hold the time a call is in pending in seconds 4. Create an integer field to hold the time a call has been worked on in seconds 5. Build workflow that calculates the amount of time a call has been in pending, in seconds, when it is removed from pending and place the result in field at 3. Adding it to what is already there. 6. Create a date time field to hold the d/t a call moves into WIP the first time if you don't have one 7. Create as 6. Above for when call is Closed 8. Create a char field to hold epoch time a call has been worked on 9. Create workflow to calculate the time between a call going into WIP and going to Closed and place the result in field created at4. 10. Create workflow to take the pending seconds from the work seconds and convert the result to hours and mins and place the result in the field created at 8. The field holding hrs and mins is used for display purposes and the field holding the time in seconds allows you to work out average fix times. If you work a 9 to 5 day don't forget to you business time to calculate time differences. This should give you an idea of where to go if you don't have the SLA module. Brian Bishop Goldstag Consultants Ltd +44(0)7973 746832 -Original Message- From: Brittain, Mark mbritt...@navisite.com Date: Mon, 19 Oct 2009 14:17:27 To: arslist@ARSLIST.ORG Subject: SLA time Calculations Hi All, Does anyone have a good way of tracking the work time of an issue? In my case the issue could be in a Status of Work in Progress, Pending or Closed. What I need to be able to determine is Closed-time minus Create Date minus Pending-time = Time-worked Status History does not work because the Status could go back and forth between Work in Progress and Pending several times during the life of the issue. Suspect this will get complicated but would like to keep this as simple as possible. ARS 6.3 patch 20 Thanks Mark Mark Brittain Remedy Developer NaviSite mbritt...@navisite.commailto:mbritt...@navisite.com (315) 453-2912 x5418 (Phone) (315) 317.2897 (Cell) Reduce Cost of IT with Managed Hosting and Application Services from NaviSite. Visit www.NaviSite.com Today. This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: AIE
FYI - According to BMC support the Export AIE Config feature was designed for them to help customers and cannot be used without modification to migrate from one server to another. Not only do the server names on the instances have to be changed, as mentioned below, but there is one form's data that has to be removed entirely. I haven't received the specifics on this, but wanted to relay what I do know. I have done the import and made it work, but it required some manual mucking about. That said, it should work fine if your server names are the same and you have the same number of Instances. Hope this helps without adding any confusion. Cheers, Brian Ahire, Anand wrote: Hi, AIE 7.5 has out of the box support for exporting and importing data exchanges from one machine to another. -Original Message- From: Garrison, Sean (Norcross) [mailto:sean.garri...@fiserv.com] Sent: Monday, October 19, 2009 7:56 AM Subject: Re: AIE Here is a script I use when migrating from prod to another region: #Replace servername and portnumber with whatever makes sense #In some instances the server name may be upper case (pretty much everywhere) except where HOST='servername' or AR_SERVER='servername' UPDATE EIE_DATAEXCHANGE SET ZTMPINSTANCEALIAS = '[servername] Instance 1', AR_SERVER='servername',EIE_DATAEXCHANGE.INSTANCE_NAME = 'ARS_servername(portnumber)_EIE_servername_Inst_001'; UPDATE EIE_APPLICATIONSETTINGS SET APPLICATION_PATH = 'directory where aie is installed'; UPDATE EIE_BackupLoadFlag SET HOST='servername',INTERNAL_INSTANCE_NAME = 'ARS_servername(portnumber)_EIE_servername_Inst_001',INSTANCENAME = '[servername] Instance 1'; Use at your own risk :-) Thanks, Sean -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Atul Vohra Sent: Wednesday, October 14, 2009 9:17 PM To: arslist@ARSLIST.ORG Subject: AIE All, We refreshed the dev DB with production DB and am having issues with AIE jobs. Have found that on the Instance Console it shows host as to be the production server. Question: How do I change that to dev server? Also besides changing references in connections is there any other place that I need to check. Regards ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Imort Locations
Antonis, The best way I've found to do this is using the Data Load Console in the Data Management Tool. I believe this is patch 9005, though I can't remember for certain. We have imported data into the load forms that get installed with this tool; either through the import tool or AIE depending on where the data resides. Then you simply Validate and Promote the data and the DMT takes care of the rest. Cheers, Brian ant_mpi wrote: Hello all, I want to import the locations (which includes sites, countries etc) when setting up a new company. As I have seen there are a lot of forms regular or joined, which take part in the procedure and I guess I should import data to all of them. Has anyone done this procedure before,are there any steps which I have to follow? Thnx in advanced, Antonis ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Maximo integration
We have a customer who uses Maximo and we interface with it to our AR System. However, we don't have a direct connection to Maximo. What we do is interface via Java using the Remedy API to a Interface system on our network. That Interface system talks to our customer's BizTalk Interface system and the customer's BizTalk Interface system talks to Maximo. The reason we do it this way is because there is at least 6 firewalls between the two Interface Systems. In addition, having these Interface systems in place allows them to hold traffic in the case where either Maximo or Remedy system go down. Christopher Pruitt Business Consulting III HP Enterprises Services 972.605.7702 office | christopher.pru...@hp.commailto:mary.jo...@hp.com www.hp.comhttp://www.hp.com/ [cid:image001.jpg@01CA5166.376C7810] Confidentiality Notice: This message and any files transmitted with it are intended for the sole use of the entity or individual to whom it is addressed, and may contain information that is confidential, privileged, and exempt from disclosure under applicable law. If you are not the intended addressee for this e-mail, you are hereby notified that any copying, distribution, or dissemination of this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately destroy, erase, or discard this message. Please notify the sender immediately by return e-mail if you have received this e-mail by mistake. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of John Sundberg Sent: Monday, October 19, 2009 7:12 PM To: arslist@ARSLIST.ORG Subject: Maximo integration ** Have you integrated with Maximo -- if so -- what did you connect to? and how did you do it? I am interested to find out how many companies are interacting with Maximo. Thanks in advance. -John -- John David Sundberg 235 East 6th Street, Suite 400B St. Paul, MN 55101 (651) 556-0930-work (651) 247-6766-cell (651) 695-8577-fax john.sundb...@kineticdata.commailto:john.sundb...@kineticdata.com _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are inline: image001.jpg
Re: Maximo integration
John, I just came across this . thought it might be relevant! http://www.mail-archive.com/arslist@arslist.org/msg45322.html Regards Satish == From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of John Sundberg Sent: Monday, October 19, 2009 7:12 PM To: arslist@ARSLIST.ORG Subject: Maximo integration ** Have you integrated with Maximo -- if so -- what did you connect to? and how did you do it? I am interested to find out how many companies are interacting with Maximo. Thanks in advance. -John -- John David Sundberg 235 East 6th Street, Suite 400B St. Paul, MN 55101 (651) 556-0930-work (651) 247-6766-cell (651) 695-8577-fax john.sundb...@kineticdata.com _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _ Hotmail: Trusted email with powerful SPAM protection. http://clk.atdmt.com/GBL/go/177141665/direct/01/ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are attachment: image001.jpg
Re: Developer Studio Filter Qualification Question
From the demos on using Dev Studio that BMC put out it sounded like I would have to turn something on to get the relationships to work. Do you know what it is? From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Rod Harris Sent: Monday, October 19, 2009 9:17 PM To: arslist@ARSLIST.ORG Subject: Re: Developer Studio Filter Qualification Question ** Not sure if others have the same issues or not. The big issues for me are that the syntax checker in dev studio doesn't seem to like search menus that reference fields on the current form in the qualification. I have to revert back to the admin tool for that. Another issue is that it often won't let me add new forms to an application. Sometimes it takes a couple of attempts to get set/push fields editing to take. On the whole I'm finding some of the new features really beneficial. Being able to edit lots of table columns (or other fields) in one go is a time saver. The show relationships function is brilliant. Just find a field that you know is referenced by a bit of workflow you're looking for and up it comes. The outline view is nice. I use the list view if I know a field's name or number but not where it is, the hierarchical view if I know where a field is but not its name. The map by name or id feature when defining set fields or push fields is fantastic. As I've got used to it I'm finding it better and better. There are still a few too many little bugs for my liking but at least we have the admin tool to fall back on when needed. It would be nice if I could move workflow between active link and filter or vice versa via a save as. On the whole I'm happy with the direction the dev studio is taking. Rod On 20/10/2009, Jason Miller jason.mil...@gmail.com wrote: ** From what we have seen the Dev Studio is not too compatible with pre 7.5 servers (sure most things that will work). The filer list will not even load against our 7.1 server (I haven't tried with patch 3 yet). One thing that I have noticed a few times with the Dev Studio is that making changes right in the Run If box doesn't seem to work as well as if you open the Expression Editor dialog window and make the change there. I have had a few instances where I would get an error if I change the Run If without opening the Expression Editor. When I opened the Expression Editor the same change worked fine. It almost seems as if the error/syntax checking works better in the dialog window that pops up. On the other hand there have been two times when I was not able to enter a qualification that I knew was good using either method. I opened the workflow in the Admin Tool and copy and paste my qualification from the Dev Studio and the workflow saved without any issue in the Admin Tool. Jason On Mon, Oct 19, 2009 at 3:57 PM, Pargeter, Christie :CO IS cparg...@lhs.org wrote: ** Hi All - I just installed the Dev Studio on my PC and am trying it against my 7.1 server. I tried to create a filter today with the Main Run If Qualification of ((('Cable' = NOLHS) AND ('Client Type' = Office-Based Employee)) AND ('Corporate ID' != $NULL$)) AND ('Profile Status' = Enabled) When I use this qualification in the Admin Tool press save no issues. But in Dev Studio I am getting Data types are not appropriate for relational operation, 313, LHS:AST:PH:VerifyEmp What do I have wrong? I have doubled check my spelling on this screen. ARS 7.1 p 6 ITSM 7.0.3 p 9 Window 2003 MS SQ 2005 IIS/Tomcat RKM 7.2 p 2 MidTier 7.1 p 6 Christie Pargeter Legacy Health IS - Programming SR Technical Analyst cparge...@lhs.org 1120 Building tel: 503-415-5149 _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Developer Studio Filter Qualification Question
You have to turn on Record Object Relationships from the Server Information window (Configuration Tab). Then restart your AR Service. I would NOT do this on a production system and even recommend that you do this after hours on a dev system. AR will have to go through each object and record which can take some time to do. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Pargeter, Christie :CO IS Sent: Tuesday, October 20, 2009 9:58 AM To: arslist@ARSLIST.ORG Subject: Re: Developer Studio Filter Qualification Question ** From the demos on using Dev Studio that BMC put out it sounded like I would have to turn something on to get the relationships to work. Do you know what it is? From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Rod Harris Sent: Monday, October 19, 2009 9:17 PM To: arslist@ARSLIST.ORG Subject: Re: Developer Studio Filter Qualification Question ** Not sure if others have the same issues or not. The big issues for me are that the syntax checker in dev studio doesn't seem to like search menus that reference fields on the current form in the qualification. I have to revert back to the admin tool for that. Another issue is that it often won't let me add new forms to an application. Sometimes it takes a couple of attempts to get set/push fields editing to take. On the whole I'm finding some of the new features really beneficial. Being able to edit lots of table columns (or other fields) in one go is a time saver. The show relationships function is brilliant. Just find a field that you know is referenced by a bit of workflow you're looking for and up it comes. The outline view is nice. I use the list view if I know a field's name or number but not where it is, the hierarchical view if I know where a field is but not its name. The map by name or id feature when defining set fields or push fields is fantastic. As I've got used to it I'm finding it better and better. There are still a few too many little bugs for my liking but at least we have the admin tool to fall back on when needed. It would be nice if I could move workflow between active link and filter or vice versa via a save as. On the whole I'm happy with the direction the dev studio is taking. Rod On 20/10/2009, Jason Miller jason.mil...@gmail.com wrote: ** From what we have seen the Dev Studio is not too compatible with pre 7.5 servers (sure most things that will work). The filer list will not even load against our 7.1 server (I haven't tried with patch 3 yet). One thing that I have noticed a few times with the Dev Studio is that making changes right in the Run If box doesn't seem to work as well as if you open the Expression Editor dialog window and make the change there. I have had a few instances where I would get an error if I change the Run If without opening the Expression Editor. When I opened the Expression Editor the same change worked fine. It almost seems as if the error/syntax checking works better in the dialog window that pops up. On the other hand there have been two times when I was not able to enter a qualification that I knew was good using either method. I opened the workflow in the Admin Tool and copy and paste my qualification from the Dev Studio and the workflow saved without any issue in the Admin Tool. Jason On Mon, Oct 19, 2009 at 3:57 PM, Pargeter, Christie :CO IS cparg...@lhs.org wrote: ** Hi All - I just installed the Dev Studio on my PC and am trying it against my 7.1 server. I tried to create a filter today with the Main Run If Qualification of ((('Cable' = NOLHS) AND ('Client Type' = Office-Based Employee)) AND ('Corporate ID' != $NULL$)) AND ('Profile Status' = Enabled) When I use this qualification in the Admin Tool press save no issues. But in Dev Studio I am getting Data types are not appropriate for relational operation, 313, LHS:AST:PH:VerifyEmp What do I have wrong? I have doubled check my spelling on this screen. ARS 7.1 p 6 ITSM 7.0.3 p 9 Window 2003 MS SQ 2005 IIS/Tomcat RKM 7.2 p 2 MidTier 7.1 p 6 Christie Pargeter Legacy Health IS - Programming SR Technical Analyst cparge...@lhs.org 1120 Building tel: 503-415-5149 _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Qualifications in AR Reports - RESOLVED
I was able to answer my own question so I thought I would share with the group. I understand that to run an AR Report with qualification requires an Active Link to call it. What bugged me was that the Report Console and ReportSelection forms *do* have Active Links that call the reports. Examining these shows that they will indeed run the report with a qualification. The problem is in both cases that when the report is selected, there is no workflow that reads the qualification from the report definition. The solution involves two-and a half Active Links. For the ReportSelection form, the addition of the following Active Link will properly load the report qualification. Name: myprefix:ReportSelection:LoadQualification_5 Execute Order: 5 Form Name: ReportSelection Execute On: Menu/Row/Level Choice: ReportList Run If: ('Start Command' != $NULL$) AND ('Start Command' != ) AND ('Report Type' = AR System) If Action: Set Fields Read Value From: ReportCreator Set Field If: $Report Name$ = 'Report Name' If No Match: Set to $NULL$ If Multiple Match: Display a List Fields Query = $Qualification Ids$ Else Action: Set Fields Read Value From: CURRENT SCREEN Fields Query = $NULL$ For the Report Console fix , the Active Link definition is almost the same. Name: myprefix:RRC:SPO:GetReportQualification_011 Execute Order: 11 Form Name: RRC:Reporting Execute On: Menu/Row/Level Choice: Report Name Run If: ('Report Request ID' != $NULL$) AND ('Report Type' = AR System) If Action: Set Fields Read Value From: ReportCreator Set Field If: $Report Name$ = 'Report Name' If No Match: Set to $NULL$ If Multiple Match: Display a List Fields zTmpAdvancedQualification = $Qualification Ids$ The half AL was to change the execute order of the out of box AL RRC:SPO:GetReportInformation_011 from 11 to 12. This was necessary to squeeze in the custom one before this ran. It seemed like the least impact to out of box workflow. After this, I can create an AR Report on the ReportCreator form that has a qualification and then run the report from either the ReportSelection form or the Report Console. Note, to run it from the Report Console you need to find the record in the Report form and give it Categories (menu hierarchy). Again, we are using ITSM 7.0.3 p8 on ARS 7.1 p7 Hope this is useful to someone. Regards, Chuck Baldi On Wed, Oct 7, 2009 at 11:54 AM, Charles Baldi cba...@ieee.org wrote: Hello all, I am trying to do is build an AR Report using the ReportCreator form and have the user run it from the Reports console (accessed from the ITSM apps) or from the ReportSelection form. I have created a report OK and specified a qualification, but whenever I run the report the qualification is ignored and it attempts to return all rows--not what I want. Do you know what I need to do to get the qualification to be recognized? I have confirmed that the qual is good, and messed with the Query Override in Report setting on the Report form. No joy. I'm hoping to avoid having to specify an external Crystal Report for something that should be simple. ARS 7.1 P5 ITSM 7.0.3 P8 Suggestions? Thanks in advance, Chuck Baldi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Convert Date/Time
Hello All, ARS 7.1 patch4 SQL2K WIN2003 I have recently implemented archiving for a new application. The problem I have is how to let users search by date from a view form. The view form points to my archive table in a reporting database. Because the date values in Remedy are UNIX time the field on the view form pointing to the Create Date column is integer not date/time. This makes searching by date pretty hard. I am sure that someone must have come across this and has an easy solution they would not mind sharing. One thought I had would be to create a Date/Time field on the view form that the users could populate than translate the date in that field to an integer and use that to search by. The problem I have is how to convert 1/1/09 to UNIX time. Thanks in advance for any help. Roger Nall Manager, SA Remedy Desk Phone: 972-464-3712 Mobile: 973-652-6723 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Selection Field usage vs Character menu performance
Hello Listers, ARS 7.1 MS SQL2005 Does anyone have any insight in just when it is best to choose a selection field over a character field? The character field would have a menu and the display type would be Drop-Down List. I am asking because time and again I get customers would never want to change the value in the menu/selection field BUT always ask for and addition, removal, reorder or change of a value. Anymore I am inclined to only use character fields with menus and reserve the selection fields for things like Inactive/Active, No/Yes, False/True, etc. Is there a big performance hit using menus? Is it even an issue anymore? Thanks, --- John J. Reiser Senior Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Convert Date/Time
On your View form create a Date/Time field and on the Database tab of that field put the field name in the View Information Name field. (You can then delete your integer field(s) as needed). Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Nall, Roger Sent: Tuesday, October 20, 2009 10:31 AM To: arslist@ARSLIST.ORG Subject: Convert Date/Time ** Hello All, ARS 7.1 patch4 SQL2K WIN2003 I have recently implemented archiving for a new application. The problem I have is how to let users search by date from a view form. The view form points to my archive table in a reporting database. Because the date values in Remedy are UNIX time the field on the view form pointing to the Create Date column is integer not date/time. This makes searching by date pretty hard. I am sure that someone must have come across this and has an easy solution they would not mind sharing. One thought I had would be to create a Date/Time field on the view form that the users could populate than translate the date in that field to an integer and use that to search by. The problem I have is how to convert 1/1/09 to UNIX time. Thanks in advance for any help. Roger Nall Manager, SA Remedy Desk Phone: 972-464-3712 Mobile: 973-652-6723 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Strored procedures in Sybase vs Oracle
Hi Folks, I am in the early stages of a migration from Sybase to Oracle and I am struggling with stored procedures. One of the nice things about Sybase is the ease with which one could return data to the ARS system using stored procedures. I am finding this much more difficult in the Oracle environment. When using a SetFields operation in an Active Link, one can invoke a Sybase stored procedure that includes a SELECT statement and the results of the select are presented back to ARS as $1$, $2$, etc. If multiple rows are returned, you can display them and let the user choose the record they want. Simple. In Oracle, I have discovered that stored procedures do not return anything. However, Oracle Functions return one thing. The thing can be a singe value or something more complex such as a row or a table or some other user-defined Oracle object. The trouble I am having is understanding how to define the Oracle thing that I want to return so that it behaves the same way that it does with Sybase. Is it a RECORD, an OBJECT or an array or a table? Or something else? I know my way around Sybase pretty well, but this is my first exposure to Oracle. If anyone has any experience in this area and could nudge me in the right direction, I would greatly appreciate it. I am willing to put in the time to learn whatever I need to learn... I just need some direction. References to helpful documentation or a working example would be most helpful. ARS 5.1.2 Sybase 12.5.2 Oracle 10.2.0.4.0 Thanks. Larry ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Convert Date/Time
Well that was just too easy. Thanks for the help, Fred. Roger Nall Manager, SA Remedy Desk Phone: 972-464-3712 Mobile: 973-652-6723 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Tuesday, October 20, 2009 10:53 AM To: arslist@ARSLIST.ORG Subject: Re: Convert Date/Time On your View form create a Date/Time field and on the Database tab of that field put the field name in the View Information Name field. (You can then delete your integer field(s) as needed). Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Nall, Roger Sent: Tuesday, October 20, 2009 10:31 AM To: arslist@ARSLIST.ORG Subject: Convert Date/Time ** Hello All, ARS 7.1 patch4 SQL2K WIN2003 I have recently implemented archiving for a new application. The problem I have is how to let users search by date from a view form. The view form points to my archive table in a reporting database. Because the date values in Remedy are UNIX time the field on the view form pointing to the Create Date column is integer not date/time. This makes searching by date pretty hard. I am sure that someone must have come across this and has an easy solution they would not mind sharing. One thought I had would be to create a Date/Time field on the view form that the users could populate than translate the date in that field to an integer and use that to search by. The problem I have is how to convert 1/1/09 to UNIX time. Thanks in advance for any help. Roger Nall Manager, SA Remedy Desk Phone: 972-464-3712 Mobile: 973-652-6723 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Discovering UNIX Server Serial Numbers
Can someone tell me if this is a BUG in Remedy. We are being told that discovering UNIX Serial Numbers is a BUG in Remedy, and the UNIX bios/chassis serial number can not be discovered. Is this true? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Developer Studio Filter Qualification Question
Great thanks!! From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Tommy Morris Sent: Tuesday, October 20, 2009 8:04 AM To: arslist@ARSLIST.ORG Subject: Re: Developer Studio Filter Qualification Question ** You have to turn on Record Object Relationships from the Server Information window (Configuration Tab). Then restart your AR Service. I would NOT do this on a production system and even recommend that you do this after hours on a dev system. AR will have to go through each object and record which can take some time to do. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Pargeter, Christie :CO IS Sent: Tuesday, October 20, 2009 9:58 AM To: arslist@ARSLIST.ORG Subject: Re: Developer Studio Filter Qualification Question ** From the demos on using Dev Studio that BMC put out it sounded like I would have to turn something on to get the relationships to work. Do you know what it is? From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Rod Harris Sent: Monday, October 19, 2009 9:17 PM To: arslist@ARSLIST.ORG Subject: Re: Developer Studio Filter Qualification Question ** Not sure if others have the same issues or not. The big issues for me are that the syntax checker in dev studio doesn't seem to like search menus that reference fields on the current form in the qualification. I have to revert back to the admin tool for that. Another issue is that it often won't let me add new forms to an application. Sometimes it takes a couple of attempts to get set/push fields editing to take. On the whole I'm finding some of the new features really beneficial. Being able to edit lots of table columns (or other fields) in one go is a time saver. The show relationships function is brilliant. Just find a field that you know is referenced by a bit of workflow you're looking for and up it comes. The outline view is nice. I use the list view if I know a field's name or number but not where it is, the hierarchical view if I know where a field is but not its name. The map by name or id feature when defining set fields or push fields is fantastic. As I've got used to it I'm finding it better and better. There are still a few too many little bugs for my liking but at least we have the admin tool to fall back on when needed. It would be nice if I could move workflow between active link and filter or vice versa via a save as. On the whole I'm happy with the direction the dev studio is taking. Rod On 20/10/2009, Jason Miller jason.mil...@gmail.com wrote: ** From what we have seen the Dev Studio is not too compatible with pre 7.5 servers (sure most things that will work). The filer list will not even load against our 7.1 server (I haven't tried with patch 3 yet). One thing that I have noticed a few times with the Dev Studio is that making changes right in the Run If box doesn't seem to work as well as if you open the Expression Editor dialog window and make the change there. I have had a few instances where I would get an error if I change the Run If without opening the Expression Editor. When I opened the Expression Editor the same change worked fine. It almost seems as if the error/syntax checking works better in the dialog window that pops up. On the other hand there have been two times when I was not able to enter a qualification that I knew was good using either method. I opened the workflow in the Admin Tool and copy and paste my qualification from the Dev Studio and the workflow saved without any issue in the Admin Tool. Jason On Mon, Oct 19, 2009 at 3:57 PM, Pargeter, Christie :CO IS cparg...@lhs.org wrote: ** Hi All - I just installed the Dev Studio on my PC and am trying it against my 7.1 server. I tried to create a filter today with the Main Run If Qualification of ((('Cable' = NOLHS) AND ('Client Type' = Office-Based Employee)) AND ('Corporate ID' != $NULL$)) AND ('Profile Status' = Enabled) When I use this qualification in the Admin Tool press save no issues. But in Dev Studio I am getting Data types are not appropriate for relational operation, 313, LHS:AST:PH:VerifyEmp What do I have wrong? I have doubled check my spelling on this screen. ARS 7.1 p 6 ITSM 7.0.3 p 9 Window 2003 MS SQ 2005 IIS/Tomcat RKM 7.2 p 2 MidTier 7.1 p 6 Christie Pargeter Legacy Health IS - Programming SR Technical Analyst cparge...@lhs.org 1120 Building tel: 503-415-5149 _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum
Re: Selection Field usage vs Character menu performance
Hi, It is allways better for performance to use selection-fields. The problem is, as you stated, to reorder the content. Before we got the possibility to set our own integer-values it was also a problem to insert values. If you join the two tools ARInside (workflow) with RRR|SelectionChange (data), you can handle the changes without too much of a problem. http://arinside.org https://www.rrr.se/cgi/tools/main#rrrSelectionChange The only thing that is simpler in selection-fields is to rename something. If the values are constantly changing (more than once a year or so), I would suggest that you use something other than selection-values. Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia: * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. * RRR|Translator - Manage and automate your language translations. Find these products, and many free tools and utilities, at http://rrr.se. Hello Listers, ARS 7.1 MS SQL2005 Does anyone have any insight in just when it is best to choose a selection field over a character field? The character field would have a menu and the display type would be Drop-Down List. I am asking because time and again I get customers would never want to change the value in the menu/selection field BUT always ask for and addition, removal, reorder or change of a value. Anymore I am inclined to only use character fields with menus and reserve the selection fields for things like Inactive/Active, No/Yes, False/True, etc. Is there a big performance hit using menus? Is it even an issue anymore? Thanks, --- John J. Reiser Senior Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are -- This message was scanned by ESVA and is believed to be clean. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Discovering UNIX Server Serial Numbers
Remedy ARS is not a discovery tool are you referring to BMC's Foundation or Topology Discovery? Guillaume -Original Message- From: Action Request System discussion list(ARSList) on behalf of Kathy Morris Sent: Tue 10/20/09 1:00 PM To: arslist@ARSLIST.ORG Subject: Discovering UNIX Server Serial Numbers Can someone tell me if this is a BUG in Remedy. We are being told that discovering UNIX Serial Numbers is a BUG in Remedy, and the UNIX bios/chassis serial number can not be discovered. Is this true? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Remedy Email Engine Errors: java.lang.IllegalStateException: Folder is not Open
Hey, Listers: I hope all of you are doing well. In 2007 Jackie Morris sent a request to the ARSLIST regarding the same issue on the Remedy Email Engine, but it appears no one responded. Or at least they didn't respond to the list. Has anyone ever found the root cause to this error? We have now experiencing the same error. The error immediately below repeats about 100 times within the same second and is then followed by Out of Memory errors. Oct 20, 2009 7:05:26 AM com.sun.mail.pop3.POP3Folder checkOpen SEVERE: Folder is not Open java.lang.IllegalStateException: Folder is not Open at com.sun.mail.pop3.POP3Folder.checkOpen(POP3Folder.java:397) at com.sun.mail.pop3.POP3Folder.getProtocol(POP3Folder.java:424) at com.sun.mail.pop3.POP3Message.loadHeaders(POP3Message.java:430) at com.sun.mail.pop3.POP3Message.getHeader(POP3Message.java:255) at javax.mail.internet.MimeMessage.getMessageID(MimeMessage.java:1162) at com.remedy.arsys.emaildaemon.ReceiverModule.checkAndSkipStoredMessages(R eceiverModule.java:373) at com.remedy.arsys.emaildaemon.ReceiverModule.doWork(ReceiverModule.java:2 51) at com.remedy.arsys.emaildaemon.ThreadBase.run(ThreadBase.java:268) at java.lang.Thread.run(Unknown Source) java.lang.OutOfMemoryError java.lang.OutOfMemoryError java.lang.OutOfMemoryError java.lang.OutOfMemoryError java.lang.OutOfMemoryError java.lang.OutOfMemoryError java.lang.OutOfMemoryError java.lang.OutOfMemoryError java.lang.OutOfMemoryError I have Googled and made a frustrating attempt to review the BMC Knowledge Base (ugh!). I did find some reference to the Inbox of the POP3 mailbox not being available. The problem is that we have multiple POP3 mailboxes and they all stop working when this error presents itself. Outgoing notifications sent FROM Remedy via SMTP continues to work during this time. However, a restart of the Remedy Email engine is required to start the polling on the Pop3 mailboxes again. Thank you for any information you can provide. This server environment is on ARS 6.3 Patch 20, Remedy Email Engine 6.3 patch 23. java max is set to 512MB Windows 2003 server SQL server 2000 Thank you in advance, Michelle ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Discovering UNIX Server Serial Numbers
Kathy, some env would help. product, version, os, -- do you have logins to the servers with sudo privaledge? -- do you have root access with your login? On Tue, Oct 20, 2009 at 1:00 PM, Kathy Morris kathymorris...@aol.comwrote: ** Can someone tell me if this is a BUG in Remedy. We are being told that discovering UNIX Serial Numbers is a BUG in Remedy, and the UNIX bios/chassis serial number can not be discovered. Is this true? _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ -- Patrick Zandi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Discovering UNIX Server Serial Numbers
Yes I am referring to BMC Foundation 1.6, Patch 1, AR 7.5, Windows OS. We are not able to discover Solaris UNIX systems. We have no issue discovering Linux. I found a Sun tool called SNEEP that is reads the Bios Serial #/Chassis Serial # from NEW Unix hardware. However for older systems, we have to manually enter text into a file (1 X), load this into SNEEP, and then SNEEP loads the info into the EEPROM, and from that point we can retrieve the serial number. The problem is when you have 1000 servers, this is a huge manual effort, and we are trying to avoid errors.. In a message dated 10/20/2009 1:38:14 P.M. Eastern Daylight Time, guilla...@dcshq.com writes: ** Remedy ARS is not a discovery tool are you referring to BMC's Foundation or Topology Discovery? Guillaume -Original Message- From: Action Request System discussion list(ARSList) on behalf of Kathy Morris Sent: Tue 10/20/09 1:00 PM To: arslist@ARSLIST.ORG Subject: Discovering UNIX Server Serial Numbers Can someone tell me if this is a BUG in Remedy. We are being told that discovering UNIX Serial Numbers is a BUG in Remedy, and the UNIX bios/chassis serial number can not be discovered. Is this true? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Discovering UNIX Server Serial Numbers
Kathy, do not know what sneep is, how are you accessing the server? 1. ssh -- with a login? onto the box? does it have sudo? 2. do you have wrappers on and you cannot login to the box? 3. are you getting errors on the scan? --- need additional information. On Tue, Oct 20, 2009 at 1:46 PM, Kathy Morris kathymorris...@aol.comwrote: ** Yes I am referring to BMC Foundation 1.6, Patch 1, AR 7.5, Windows OS. We are not able to discover Solaris UNIX systems. We have no issue discovering Linux. I found a Sun tool called SNEEP that is reads the Bios Serial #/Chassis Serial # from NEW Unix hardware. However for older systems, we have to manually enter text into a file (1 X), load this into SNEEP, and then SNEEP loads the info into the EEPROM, and from that point we can retrieve the serial number. The problem is when you have 1000 servers, this is a huge manual effort, and we are trying to avoid errors.. In a message dated 10/20/2009 1:38:14 P.M. Eastern Daylight Time, guilla...@dcshq.com writes: ** Remedy ARS is not a discovery tool are you referring to BMC's Foundation or Topology Discovery? Guillaume -Original Message- From: Action Request System discussion list(ARSList) on behalf of Kathy Morris Sent: Tue 10/20/09 1:00 PM To: arslist@ARSLIST.ORG Subject: Discovering UNIX Server Serial Numbers Can someone tell me if this is a BUG in Remedy. We are being told that discovering UNIX Serial Numbers is a BUG in Remedy, and the UNIX bios/chassis serial number can not be discovered. Is this true? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.netsponsor%3armisoluti...@verizon.netARSlist: Where the Answers Are _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ -- Patrick Zandi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Can we restore a Database to another Database ?
Hello All, We have two systems namely : Test ( Database Instance : ARSystem1) (Application Server : ARSystem 7.5 Patch 001, ITSM 7.5.01) Production(Database Instance : ARSystem2) (Application Server : ARSystem 7.5 Patch 002, ITSM 7.5.01) Both these database instances are on the same database server. Encountered ARERR 2 on production system when tried doing the Data Promotion using Data Management Tool. This error has not been listed in the documents, and I posted this before but not much help. http://communities.bmc.com/communities/message/108976#108976 http://groups.google.com/group/arslist/browse_thread/thread/a37f8345d1ee7596?hl=en now, trying to do a workaround , can I restore the test database instance to production database. If yes, how can i do that and what changes do I need to make on Remedy Side, like configuration files,etc and what changes do I need to make on database side to make it successful. Please Advise, Thanks, Raj ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Discovering UNIX Server Serial Numbers
Hi, Yes we have sudo, and I can logon to the box. I am not sure what wrappers are. We run the discovery, everything shows up EXCEPT the serial number of the Unix box with the Solaris operating system. We do not get errors on the scan. Also sneep is a Solaris utility below: _http://wikis.sun.com/display/sneep/SNEEP+FAQ_ (http://wikis.sun.com/display/sneep/SNEEP+FAQ) . _http://www.sunsolarisadmin.com/hardware/find-chasis-serial-number-using-sne ep/_ (http://www.sunsolarisadmin.com/hardware/find-chasis-serial-number-using-sneep/) In a message dated 10/20/2009 1:52:31 P.M. Eastern Daylight Time, remedy...@gmail.com writes: ** Kathy, do not know what sneep is, how are you accessing the server? 1. ssh -- with a login? onto the box? does it have sudo? 2. do you have wrappers on and you cannot login to the box? 3. are you getting errors on the scan? --- need additional information. On Tue, Oct 20, 2009 at 1:46 PM, Kathy Morris _kathymorris...@aol.com_ (mailto:kathymorris...@aol.com) wrote: ** Yes I am referring to BMC Foundation 1.6, Patch 1, AR 7.5, Windows OS. We are not able to discover Solaris UNIX systems. We have no issue discovering Linux. I found a Sun tool called SNEEP that is reads the Bios Serial #/Chassis Serial # from NEW Unix hardware. However for older systems, we have to manually enter text into a file (1 X), load this into SNEEP, and then SNEEP loads the info into the EEPROM, and from that point we can retrieve the serial number. The problem is when you have 1000 servers, this is a huge manual effort, and we are trying to avoid errors.. In a message dated 10/20/2009 1:38:14 P.M. Eastern Daylight Time, _guilla...@dcshq.com_ (mailto:guilla...@dcshq.com) writes: ** Remedy ARS is not a discovery tool are you referring to BMC's Foundation or Topology Discovery? Guillaume -Original Message- From: Action Request System discussion list(ARSList) on behalf of Kathy Morris Sent: Tue 10/20/09 1:00 PM To: _arsl...@arslist.org_ (mailto:arslist@ARSLIST.ORG) Subject: Discovering UNIX Server Serial Numbers Can someone tell me if this is a BUG in Remedy. We are being told that discovering UNIX Serial Numbers is a BUG in Remedy, and the UNIX bios/chassis serial number can not be discovered. Is this true? ___ UNSUBSCRIBE or access ARSlist Archives at _www.arslist.org_ (http://www.arslist.org/) Platinum _Sponsor:rmisoluti...@verizon.net_ (mailto:Sponsor:rmisoluti...@verizon.net) ARSlist: Where the Answers Are _Platinum Sponsor: _rmisoluti...@verizon.net_ (mailto:rmisoluti...@verizon.net) ARSlist: Where the Answers Are_ _Platinum Sponsor: _rmisoluti...@verizon.net_ (mailto:rmisoluti...@verizon.net) ARSlist: Where the Answers Are_ -- Patrick Zandi _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Discovering UNIX Server Serial Numbers
I don't know that it's a bug in Remedy so much as an issue with the hardware. We saw the same thing. Most Linux hardware was OK, most Solaris hardware was not. The fact that you have to actually load the serial number into the EEPROM on older servers shows this is not a bug. If the discovery doesn't work on newer hardware that does have the serial number in the EEPROM, then it may just be a matter of BMC updating (i.e., enhancing) discovery so that it knows how to do it. Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kathy Morris Sent: Tuesday, October 20, 2009 11:00 AM To: arslist@ARSLIST.ORG Subject: Discovering UNIX Server Serial Numbers ** Can someone tell me if this is a BUG in Remedy. We are being told that discovering UNIX Serial Numbers is a BUG in Remedy, and the UNIX bios/chassis serial number can not be discovered. Is this true? _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Discovering UNIX Server Serial Numbers
I found this helpful http://communities.bmc.com/communities/docs/DOC-2745 I have seen BIOS out of date on boxes and giving a - .. I did have it working once, however our direction has changed.. hope that helps.. not sure of a bug... but I believe there is another patch or 2 above 1.6 001 but now everything is going to the new discovery, and from what I have been complaining, and complaining about might actually be in the new one.. SNMP V3, and Java newer than 1.4.2... I heard 1st quarter, but now with the aquision, I wonder if it will be longer.. On Tue, Oct 20, 2009 at 2:13 PM, Kathy Morris kathymorris...@aol.comwrote: ** Hi, Yes we have sudo, and I can logon to the box. I am not sure what wrappers are. We run the discovery, everything shows up EXCEPT the serial number of the Unix box with the Solaris operating system. We do not get errors on the scan. Also sneep is a Solaris utility below: http://wikis.sun.com/display/sneep/SNEEP+FAQ . http://www.sunsolarisadmin.com/hardware/find-chasis-serial-number-using-sneep/ In a message dated 10/20/2009 1:52:31 P.M. Eastern Daylight Time, remedy...@gmail.com writes: ** Kathy, do not know what sneep is, how are you accessing the server? 1. ssh -- with a login? onto the box? does it have sudo? 2. do you have wrappers on and you cannot login to the box? 3. are you getting errors on the scan? --- need additional information. On Tue, Oct 20, 2009 at 1:46 PM, Kathy Morris kathymorris...@aol.comwrote: ** Yes I am referring to BMC Foundation 1.6, Patch 1, AR 7.5, Windows OS. We are not able to discover Solaris UNIX systems. We have no issue discovering Linux. I found a Sun tool called SNEEP that is reads the Bios Serial #/Chassis Serial # from NEW Unix hardware. However for older systems, we have to manually enter text into a file (1 X), load this into SNEEP, and then SNEEP loads the info into the EEPROM, and from that point we can retrieve the serial number. The problem is when you have 1000 servers, this is a huge manual effort, and we are trying to avoid errors.. In a message dated 10/20/2009 1:38:14 P.M. Eastern Daylight Time, guilla...@dcshq.com writes: ** Remedy ARS is not a discovery tool are you referring to BMC's Foundation or Topology Discovery? Guillaume -Original Message- From: Action Request System discussion list(ARSList) on behalf of Kathy Morris Sent: Tue 10/20/09 1:00 PM To: arslist@ARSLIST.ORG Subject: Discovering UNIX Server Serial Numbers Can someone tell me if this is a BUG in Remedy. We are being told that discovering UNIX Serial Numbers is a BUG in Remedy, and the UNIX bios/chassis serial number can not be discovered. Is this true? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.netsponsor%3armisoluti...@verizon.netARSlist: Where the Answers Are _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ -- Patrick Zandi _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ -- Patrick Zandi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Stored procedures in Sybase vs Oracle
Sorry... I forgot my sig. Larry Robinson n...@ncsu.edu Remedy Developer/Admin Office of Information Technology NC State University 919-515-5432 Voice Raleigh, NC 27695-7109 919-513-1893 FAX On Oct 20, 2009, at 12:16 PM, L G Robinson wrote: Hi Folks, I am in the early stages of a migration from Sybase to Oracle and I am struggling with stored procedures. One of the nice things about Sybase is the ease with which one could return data to the ARS system using stored procedures. I am finding this much more difficult in the Oracle environment. When using a SetFields operation in an Active Link, one can invoke a Sybase stored procedure that includes a SELECT statement and the results of the select are presented back to ARS as $1$, $2$, etc. If multiple rows are returned, you can display them and let the user choose the record they want. Simple. In Oracle, I have discovered that stored procedures do not return anything. However, Oracle Functions return one thing. The thing can be a singe value or something more complex such as a row or a table or some other user-defined Oracle object. The trouble I am having is understanding how to define the Oracle thing that I want to return so that it behaves the same way that it does with Sybase. Is it a RECORD, an OBJECT or an array or a table? Or something else? I know my way around Sybase pretty well, but this is my first exposure to Oracle. If anyone has any experience in this area and could nudge me in the right direction, I would greatly appreciate it. I am willing to put in the time to learn whatever I need to learn... I just need some direction. References to helpful documentation or a working example would be most helpful. ARS 5.1.2 Sybase 12.5.2 Oracle 10.2.0.4.0 Thanks. Larry ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Discovering UNIX Server Serial Numbers
Yes - thank you this is very helpful. I do not believe this is a Remedy bug. I am wondering if anyone else has not been able to obtain the serial number for Unix/Solaris servers - or if our company was the only ones in the universe experiencing this issue? In a message dated 10/20/2009 2:22:00 P.M. Eastern Daylight Time, remedy...@gmail.com writes: ** I found this helpful _http://communities.bmc.com/communities/docs/DOC-2745_ (http://communities.bmc.com/communities/docs/DOC-2745) I have seen BIOS out of date on boxes and giving a - .. I did have it working once, however our direction has changed.. hope that helps.. not sure of a bug... but I believe there is another patch or 2 above 1.6 001 but now everything is going to the new discovery, and from what I have been complaining, and complaining about might actually be in the new one.. SNMP V3, and Java newer than 1.4.2... I heard 1st quarter, but now with the aquision, I wonder if it will be longer.. On Tue, Oct 20, 2009 at 2:13 PM, Kathy Morris _kathymorris...@aol.com_ (mailto:kathymorris...@aol.com) wrote: ** Hi, Yes we have sudo, and I can logon to the box. I am not sure what wrappers are. We run the discovery, everything shows up EXCEPT the serial number of the Unix box with the Solaris operating system. We do not get errors on the scan. Also sneep is a Solaris utility below: _http://wikis.sun.com/display/sneep/SNEEP+FAQ_ (http://wikis.sun.com/display/sneep/SNEEP+FAQ) . _http://www.sunsolarisadmin.com/hardware/find-chasis-serial-number-using-sne ep/_ (http://www.sunsolarisadmin.com/hardware/find-chasis-serial-number-using-sneep/) In a message dated 10/20/2009 1:52:31 P.M. Eastern Daylight Time, _remedy...@gmail.com_ (mailto:remedy...@gmail.com) writes: ** Kathy, do not know what sneep is, how are you accessing the server? 1. ssh -- with a login? onto the box? does it have sudo? 2. do you have wrappers on and you cannot login to the box? 3. are you getting errors on the scan? --- need additional information. On Tue, Oct 20, 2009 at 1:46 PM, Kathy Morris _kathymorris...@aol.com_ (mailto:kathymorris...@aol.com) wrote: ** Yes I am referring to BMC Foundation 1.6, Patch 1, AR 7.5, Windows OS. We are not able to discover Solaris UNIX systems. We have no issue discovering Linux. I found a Sun tool called SNEEP that is reads the Bios Serial #/Chassis Serial # from NEW Unix hardware. However for older systems, we have to manually enter text into a file (1 X), load this into SNEEP, and then SNEEP loads the info into the EEPROM, and from that point we can retrieve the serial number. The problem is when you have 1000 servers, this is a huge manual effort, and we are trying to avoid errors.. In a message dated 10/20/2009 1:38:14 P.M. Eastern Daylight Time, _guilla...@dcshq.com_ (mailto:guilla...@dcshq.com) writes: ** Remedy ARS is not a discovery tool are you referring to BMC's Foundation or Topology Discovery? Guillaume -Original Message- From: Action Request System discussion list(ARSList) on behalf of Kathy Morris Sent: Tue 10/20/09 1:00 PM To: _arsl...@arslist.org_ (mailto:arslist@ARSLIST.ORG) Subject: Discovering UNIX Server Serial Numbers Can someone tell me if this is a BUG in Remedy. We are being told that discovering UNIX Serial Numbers is a BUG in Remedy, and the UNIX bios/chassis serial number can not be discovered. Is this true? ___ UNSUBSCRIBE or access ARSlist Archives at _www.arslist.org_ (http://www.arslist.org/) Platinum _Sponsor:rmisoluti...@verizon.net_ (mailto:Sponsor:rmisoluti...@verizon.net) ARSlist: Where the Answers Are _Platinum Sponsor: _rmisoluti...@verizon.net_ (mailto:rmisoluti...@verizon.net) ARSlist: Where the Answers Are_ _Platinum Sponsor: _rmisoluti...@verizon.net_ (mailto:rmisoluti...@verizon.net) ARSlist: Where the Answers Are_ -- Patrick Zandi _Platinum Sponsor: _rmisoluti...@verizon.net_ (mailto:rmisoluti...@verizon.net) ARSlist: Where the Answers Are_ _Platinum Sponsor: _rmisoluti...@verizon.net_ (mailto:rmisoluti...@verizon.net) ARSlist: Where the Answers Are_ -- Patrick Zandi _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Discovering UNIX Server Serial Numbers
We had the same issue. What we did in the end was just give in to the fact that we weren't going to be able to discover SNs for everything and wrote our recon rules so that new CIs used the discovered SN, but an SN on a CI was never overwritten by discovery (since it couldn't be trusted). We then updated CIs on an as needed basis as we found machines that had incorrect SN info. Note that we generally didn't actively look for these CIs, they were just uncovered as we went about our usual business in the CMDB. Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kathy Morris Sent: Tuesday, October 20, 2009 1:15 PM To: arslist@ARSLIST.ORG Subject: Re: Discovering UNIX Server Serial Numbers ** Yes - thank you this is very helpful. I do not believe this is a Remedy bug. I am wondering if anyone else has not been able to obtain the serial number for Unix/Solaris servers - or if our company was the only ones in the universe experiencing this issue? In a message dated 10/20/2009 2:22:00 P.M. Eastern Daylight Time, remedy...@gmail.com writes: ** I found this helpful http://communities.bmc.com/communities/docs/DOC-2745 I have seen BIOS out of date on boxes and giving a - .. I did have it working once, however our direction has changed.. hope that helps.. not sure of a bug... but I believe there is another patch or 2 above 1.6 001 but now everything is going to the new discovery, and from what I have been complaining, and complaining about might actually be in the new one.. SNMP V3, and Java newer than 1.4.2... I heard 1st quarter, but now with the aquision, I wonder if it will be longer.. On Tue, Oct 20, 2009 at 2:13 PM, Kathy Morris kathymorris...@aol.commailto:kathymorris...@aol.com wrote: ** Hi, Yes we have sudo, and I can logon to the box. I am not sure what wrappers are. We run the discovery, everything shows up EXCEPT the serial number of the Unix box with the Solaris operating system. We do not get errors on the scan. Also sneep is a Solaris utility below: http://wikis.sun.com/display/sneep/SNEEP+FAQ . http://www.sunsolarisadmin.com/hardware/find-chasis-serial-number-using-sneep/ In a message dated 10/20/2009 1:52:31 P.M. Eastern Daylight Time, remedy...@gmail.commailto:remedy...@gmail.com writes: ** Kathy, do not know what sneep is, how are you accessing the server? 1. ssh -- with a login? onto the box? does it have sudo? 2. do you have wrappers on and you cannot login to the box? 3. are you getting errors on the scan? --- need additional information. On Tue, Oct 20, 2009 at 1:46 PM, Kathy Morris kathymorris...@aol.commailto:kathymorris...@aol.com wrote: ** Yes I am referring to BMC Foundation 1.6, Patch 1, AR 7.5, Windows OS. We are not able to discover Solaris UNIX systems. We have no issue discovering Linux. I found a Sun tool called SNEEP that is reads the Bios Serial #/Chassis Serial # from NEW Unix hardware. However for older systems, we have to manually enter text into a file (1 X), load this into SNEEP, and then SNEEP loads the info into the EEPROM, and from that point we can retrieve the serial number. The problem is when you have 1000 servers, this is a huge manual effort, and we are trying to avoid errors.. In a message dated 10/20/2009 1:38:14 P.M. Eastern Daylight Time, guilla...@dcshq.commailto:guilla...@dcshq.com writes: ** Remedy ARS is not a discovery tool are you referring to BMC's Foundation or Topology Discovery? Guillaume -Original Message- From: Action Request System discussion list(ARSList) on behalf of Kathy Morris Sent: Tue 10/20/09 1:00 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Discovering UNIX Server Serial Numbers Can someone tell me if this is a BUG in Remedy. We are being told that discovering UNIX Serial Numbers is a BUG in Remedy, and the UNIX bios/chassis serial number can not be discovered. Is this true? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.orghttp://www.arslist.org/ Platinum Sponsor:rmisoluti...@verizon.netmailto:sponsor%3armisoluti...@verizon.net ARSlist: Where the Answers Are _Platinum Sponsor: rmisoluti...@verizon.netmailto:rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.netmailto:rmisoluti...@verizon.net ARSlist: Where the Answers Are_ -- Patrick Zandi _Platinum Sponsor: rmisoluti...@verizon.netmailto:rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.netmailto:rmisoluti...@verizon.net ARSlist: Where the Answers Are_ -- Patrick Zandi _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged
Re: Stored procedures in Sybase vs Oracle
Hi Larry, check the Oracle function DUAL there are references in past arslist tips using this to build menus and/or select data and present it as a list to user. -Original Message- From: n...@ncsu.edu Sent: Tue, 20 Oct 2009 14:40:59 -0400 To: arslist@arslist.org Subject: Re: Stored procedures in Sybase vs Oracle Sorry... I forgot my sig. Larry Robinson n...@ncsu.edu Remedy Developer/Admin Office of Information Technology NC State University 919-515-5432 Voice Raleigh, NC 27695-7109 919-513-1893 FAX On Oct 20, 2009, at 12:16 PM, L G Robinson wrote: Hi Folks, I am in the early stages of a migration from Sybase to Oracle and I am struggling with stored procedures. One of the nice things about Sybase is the ease with which one could return data to the ARS system using stored procedures. I am finding this much more difficult in the Oracle environment. When using a SetFields operation in an Active Link, one can invoke a Sybase stored procedure that includes a SELECT statement and the results of the select are presented back to ARS as $1$, $2$, etc. If multiple rows are returned, you can display them and let the user choose the record they want. Simple. In Oracle, I have discovered that stored procedures do not return anything. However, Oracle Functions return one thing. The thing can be a singe value or something more complex such as a row or a table or some other user-defined Oracle object. The trouble I am having is understanding how to define the Oracle thing that I want to return so that it behaves the same way that it does with Sybase. Is it a RECORD, an OBJECT or an array or a table? Or something else? I know my way around Sybase pretty well, but this is my first exposure to Oracle. If anyone has any experience in this area and could nudge me in the right direction, I would greatly appreciate it. I am willing to put in the time to learn whatever I need to learn... I just need some direction. References to helpful documentation or a working example would be most helpful. ARS 5.1.2 Sybase 12.5.2 Oracle 10.2.0.4.0 Thanks. Larry ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are Receive Notifications of Incoming Messages Easily monitor multiple email accounts access them with a click. Visit http://www.inbox.com/notifier and check it out! ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Can we restore a Database to another Database ?
You can make a change in the ar.conf file to point to the test instance. Oracle-Two-Task: ProdDB change to Oracle-Two-Task: TestDB. Incase if the db and arserver are in the same box then you have to change Oracle-SID. I am not sure what the parameter to change for SQL server. On Oct 20, 11:04 am, Raj ravi6...@gmail.com wrote: Hello All, We have two systems namely : Test ( Database Instance : ARSystem1) (Application Server : ARSystem 7.5 Patch 001, ITSM 7.5.01) Production(Database Instance : ARSystem2) (Application Server : ARSystem 7.5 Patch 002, ITSM 7.5.01) Both these database instances are on the same database server. Encountered ARERR 2 on production system when tried doing the Data Promotion using Data Management Tool. This error has not been listed in the documents, and I posted this before but not much help. http://communities.bmc.com/communities/message/108976#108976 http://groups.google.com/group/arslist/browse_thread/thread/a37f8345d... now, trying to do a workaround , can I restore the test database instance to production database. If yes, how can i do that and what changes do I need to make on Remedy Side, like configuration files,etc and what changes do I need to make on database side to make it successful. Please Advise, Thanks, Raj ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Can we restore a Database to another Database ?
DB is SQL Server 2005. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of patchsk Sent: Tuesday, October 20, 2009 6:37 PM To: arslist@ARSLIST.ORG Subject: Re: Can we restore a Database to another Database ? You can make a change in the ar.conf file to point to the test instance. Oracle-Two-Task: ProdDB change to Oracle-Two-Task: TestDB. Incase if the db and arserver are in the same box then you have to change Oracle-SID. I am not sure what the parameter to change for SQL server. On Oct 20, 11:04 am, Raj ravi6...@gmail.com wrote: Hello All, We have two systems namely : Test ( Database Instance : ARSystem1) (Application Server : ARSystem 7.5 Patch 001, ITSM 7.5.01) Production(Database Instance : ARSystem2) (Application Server : ARSystem 7.5 Patch 002, ITSM 7.5.01) Both these database instances are on the same database server. Encountered ARERR 2 on production system when tried doing the Data Promotion using Data Management Tool. This error has not been listed in the documents, and I posted this before but not much help. http://communities.bmc.com/communities/message/108976#108976 http://groups.google.com/group/arslist/browse_thread/thread/a37f8345d... now, trying to do a workaround , can I restore the test database instance to production database. If yes, how can i do that and what changes do I need to make on Remedy Side, like configuration files,etc and what changes do I need to make on database side to make it successful. Please Advise, Thanks, Raj __ _ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are