Re: Adding days to a Date field in a qualification doesn't work
I usually have to put the Date fields inside quotes when doing calculations 'my_date_field' ($DATE$ + 182) I've tried that. It doesn't work.I've entered 28.10.2020 into my date field, i.e. I'm saying in my AL RunIf qualification: 28.10.2020 ($DATE$ + 1), but the AL goes into else action. As this example shows it doesn't really matter it ARS sees date as second, days, week or even years. Year 2020 is so far in the future, that it should work anyway, but it doesn't. BTW, I'm on 6.3 Patch 24. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Adding days to a Date field in a qualification doesn't work
Hi Doug, 'my_date_field' ($DATE$ + 15724800) I've tried that. It doesn't work.I've entered 28.10.2020 into my date field, i.e. I'm saying in my AL RunIf qualification: 28.10.2020 ($DATE$ + 1), but the AL goes into else action. As this example shows it doesn't really matter it ARS sees date as second, days, week or even years. Year 2020 is so far in the future, that it should work anyway, but it doesn't. BTW, I'm on 6.3 Patch 24. Thanks Mark ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Adding days to a Date field in a qualification doesn't work
Hi Gary, Yeah, I think that doug is on to something here. The $DATE$ keyword is referring to seconds, I believe, and thus you need to add six months worth of seconds. Note, that $DATE$ calculates to midnight that day, so if you need to calculate six months from now, then you will likely need to use $TIMESTAMP$. Using $DATE$ will give you 6 months from the beginning of the current day. Also, as a good note, I would suggest adding the parenthesis, although they should not be required. I think it doesn't really matter, because it doesn't work in any of the casese. I've entered 28.10.2020 into my date field, i.e. I'm saying in my AL RunIf qualification: 28.10.2020 ($DATE$ + 1), but the AL goes into else action. As this example shows it doesn't really matter it ARS sees date as second, days, week or even years. Year 2020 is so far in the future, that it should work anyway, but it doesn't. BTW, I'm on 6.3 Patch 24. Mark ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Adding days to a Date field in a qualification doesn't work
An easy way to do this is to use the multipliers. You will also need to use $TIMESTAMP$ 'my_date_field' ($TIMESTAMP$ + (60*60*24*182)) $TIMESTAMP$ returns the number of seconds elapsed since midnight Coordinated Universal Time (UTC) of January 1, 1970. Guess what platform Remedy ARS was first built upon? That's right UNIX. There used to be 3 clients. Anyone know what they were? Note: Remedy ARS was built before there was a Public Internet. Come to think of it, there may have been 4 clients at one time, but there may not have been one for IBM OS/2. When you do it this way, you can substitute a $variable or a number whenever you like. I've tried that too, of course. When your my_date_field is a DATE field the example you're showing will n o t work. At least on my 6.3 patch 024 it just doesn't work. Thanks anyway! Mark ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Problems calling java api from filter.
Hi people I reply back with the final result. I indicated the correct instruction in a filter, in a Run Process Action: java -Dentorno=D remedyServer.Access new $field1$ password $field2$ $field3$ $field4$ $Description$ $field5$ $field6$ $field7$ J $field8$ $Field9$ $Field10$ It did not return an error, but the api did not do what it had to do. But if instead of launching it from a filter it was launched from an active link, the api worked correctly. So, I performed the actions to launch the filter in a Remedy User client in the server's computer, and surprisingly the api worked. From that moment, the api worked from any computer. It seems as the action of launching the filter in the server's computer unblocked the api. In fact I have no logical explanation for this. May be some of you have had an experiencie like this. Anyway the problem has been resolved. Thanks regards, Sergio Tomillero -- View this message in context: http://www.nabble.com/Problems-calling-java-api-from-filter.-tp20086003p20205056.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Data - For Server Events
John, Here is how I have learned to read these things... In ar.h the /* Server Event Types */ section defines the 'Event Type' values for the events. However for each value there are other blocks that define the 'Event Cause'. For each 'Event Type', 'Event Cause' the meaning of 'Event Details [123]' are defined. FWIW: In the PDF's I think this section will explain a lot Configuring-710.pdf: Appendix E: Working with the Server Events form (page 307-323) HTH. FWIW I took some time a few years ago and put together an ARS form with the bulk of the Server Event decoding (English string values for the coded numbers stuff even to the descriptions of the Event Details for each Type,Cause combo) information so that I could Join it with the Server Event form and read from a table field what the codes meant. (Not to mention being able to search on English strings too. :) However, BMC Remedy made some improvements in v7.1 that greatly depreciated the value of those things in my mind. So I doubt they will be of much help to others at this point. (And it was a pain for me to maintain since the v5 days. :( It really is to bad that BMC does not have a kind of Constants form with an arx file that they produce for use ARS Programmers. Instead of making us dig through the C API to get at all the good stuff.) -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On Mon, Oct 27, 2008 at 10:42 PM, John [EMAIL PROTECTED] wrote: ** OK -- so I finally looked into ar.h (per Axton) to figure out what the form 'server events' is telling me. However -- I still don't quite know how to interpret the info provided. Has anybody actually used the Server Events with success? And - what did you do? Here is what I have in my 'server events' table Event Type, Event Cause, Event Date, Event Details1 ,2,3 1,8,10/27/2008 11:36:49 AM, JDS-Test 1,8,10/27/2008 11:36:49 AM, JDS-Test 2,14,10/27/2008 11:36:53 AM, 536870913;Field1 2,14,10/27/2008 11:36:53 AM, 536870914;Field2 So -- oddly enough -- I have 2 entries for what appear to be modifying a form. Then 1 entry for each of the 2 fields I created. So -- parsing the first line -- I am assuming the 1,8,10/27/2008 11:36:49 AM, JDS-Test 1 = AR_SVR_EVENT_CHG_SCHEMA -- which is fine 8 = ??? Date is obvious JDS-Test -- the name of the table I created then the next interesting line 2,14,10/27/2008 11:36:53 AM, 536870913;Field1 2 = AR_SVR_EVENT_CHG_FIELD 14 = ??? Date is obvious 536870913;Field1 -- the field I created. So -- what is 'Event Cause' -- and does that info exist in ar.h -- I could not find it. Thanks in advance. -John #define AR_SVR_EVENT_CHG_SCHEMA1 #define AR_SVR_EVENT_CHG_FIELD 2 #define AR_SVR_EVENT_CHG_CHARMENU 3 #define AR_SVR_EVENT_CHG_FILTER4 #define AR_SVR_EVENT_CHG_IMPORT5 #define AR_SVR_EVENT_CHG_ACTLINK 6 #define AR_SVR_EVENT_CHG_ESCAL 7 #define AR_SVR_EVENT_CHG_VUI 8 #define AR_SVR_EVENT_CHG_CONTAINER 9 #define AR_SVR_EVENT_CHG_USERS 10 #define AR_SVR_EVENT_CHG_GROUPS11 #define AR_SVR_EVENT_CHG_SVR_SETTINGS 12 #define AR_SVR_EVENT_CHG_ALERT_USERS 13 #define AR_SVR_EVENT_ARCHIVE_DONE 14 #define AR_SVR_EVENT_SERVGROUP_ACTION 15 #define AR_SVR_EVENT_CHG_LICENSES 16 #define AR_SVR_EVENT_USER_ADDED0 #define AR_SVR_EVENT_USER_MODIFIED 1 #define AR_SVR_EVENT_USER_DELETED 2 #define AR_SVR_EVENT_GROUP_ADDED 0 #define AR_SVR_EVENT_GROUP_MODIFIED 1 #define AR_SVR_EVENT_GROUP_DELETED2 #define AR_SVR_EVENT_COMPGROUP_ADDED 3 #define AR_SVR_EVENT_COMPGROUP_MODIFIED 4 #define AR_SVR_EVENT_COMPGROUP_DELETED5 #define AR_SVR_EVENT_APPLICATION_ADDED6 #define AR_SVR_EVENT_APPLICATION_MODIFIED 7 #define AR_SVR_EVENT_APPLICATION_DELETED 8 #define AR_SVR_EVENT_ROLE_ADDED 9 #define AR_SVR_EVENT_ROLE_MODIFIED10 #define AR_SVR_EVENT_ROLE_DELETED 11 #define AR_SVR_EVENT_ARCHIVE_FORM 1 #define AR_SVR_EVENT_ARCHIVE_DELETE 2 #define AR_SVR_EVENT_ARCHIVE_FORM_DELETE 3 #define AR_SVR_EVENT_ARCHIVE_XML 4 #define AR_SVR_EVENT_ARCHIVE_ARX 5 #define AR_SVR_EVENT_SERVGROUP_FAILOVER 1 #define AR_SVR_EVENT_SERVGROUP_RELINQUISH 2 #define AR_SVR_EVENT_SERVGROUP_TAKEOVER 3 #define AR_SVR_EVENT_IMPORT_SET_OBJECT 0 #define AR_SVR_EVENT_IMPORT_CREATE_OBJECT 1 -- 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 [EMAIL PROTECTED] On Mar 27, 2008, at 1:52 PM, Axton wrote: ** http://arswiki.org/projects/arapi/browser/trunk/7.1/solaris/include/ar.h#L5095 Axton Grams On Thu, Mar 27, 2008 at 2:36 PM, Tanner, Doug [EMAIL PROTECTED] wrote: ** Does anyone have (and is willing to share)
Gary A Roach/K-CORP/KMT/KMT is out of the office.
I will be out of the office starting 10/28/2008 and will not return until 10/29/2008. I will be checking email / v-mail regularly. If you need to speak with someone immediately please call (or email) Kim Hawley at 724-539-6145 or Kathy Bangor at 724-539-5648. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Adding days to a Date field in a qualification doesn't work
A couple of questions... Is your field a Date/Time, Date Only, or Time Only field? Since it is an AL have you tried using the 7.1 Client to see if it does the same thing? If your field is a Date/Time field (even if it is set to only display the Date) you will need to use TIMESTAMP instead of DATE. i.e. October 28, 2020 in a Date/Time field is 1603861200. The same date in a Date Only field is 2459151. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mark Milke Sent: Tuesday, October 28, 2008 5:51 AM To: arslist@ARSLIST.ORG Subject: Re: Adding days to a Date field in a qualification doesn't work I usually have to put the Date fields inside quotes when doing calculations 'my_date_field' ($DATE$ + 182) I've tried that. It doesn't work.I've entered 28.10.2020 into my date field, i.e. I'm saying in my AL RunIf qualification: 28.10.2020 ($DATE$ + 1), but the AL goes into else action. As this example shows it doesn't really matter it ARS sees date as second, days, week or even years. Year 2020 is so far in the future, that it should work anyway, but it doesn't. BTW, I'm on 6.3 Patch 24. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Web Reporting
I attempted this post yesterday and did not see it on the list. I apologize if it is a repeat. We are looking at solutions for providing the ability to view, save to file and print Crystal Reports from the ARS 7.1 mid-tier (we do not currently use the mid-tier). I have received so much conflicting information and I was hoping someone would share their experiences. We have been told we need to spend anywhere from $600 to $100,000. We have a list of 6 - 8 products and versions that may or may not be workable. Obviously, we would like to spend as little money as possible. So, would anyone who has travelled this path be willing to share the details of their implementation including approximate costs and licensing requirements? I've contacted BMC support and of course was told to look at the product compatibility matrix. I have and I've looked at the mid-tier documentation. What it doesn't tell you is which supported application would be best suited to our implementation (small company with limited but growing reporting needs) and if there may be other un-supported apps that could do the trick. Of course, the vendors want to sell you the Cadillac when a Yugo would suffice. Thanks! ARS 7.1 (unpatched at present) on Windows Oracle 10.2 on Linux ARS 7.1 mid-tier on Linux Completely custom applications Bill Myers Remedy Developer Datacraft Solutions, Inc. [EMAIL PROTECTED] (p) 919-667-9804 (f) 919-682-5986 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Crystal Report Question
Greetings List!
Nor a Remedy question, but hopefully someone can help me anyway.
I'm trying to write a report to show all records created between Sunday 7pm
through Friday 7am between the hours of 7am and 7pm.
I've tried
Time({Form.Create Date})Time (18, 59, 59) or
Time({Form.Create Date})Time (7, 00, 00)) and
DayOfWeek({Form.Create Date})7
however, this gives me records created between Friday 7pm and Sunday 7am as
well, which need to be excluded.
I tried thinking of a way to exclude Sunday AM and Friday PM, but couldn't
think how to do this.
Ideally, I'd like to also group them by Sunday PM/Monday AM, Monday
PM/TuesdayAM, etc.
Does anyone have any ideas?
HUGE THX IN ADVANCE!!!
Shawn Stonequist
EMNS Inc.
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Adding days to a Date field in a qualification doesn't work
There was a native Macintosh client through version 3.2. It was one of the reasons we originally bought the product. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Meyer, Jennifer L Sent: Tuesday, October 28, 2008 8:22 AM To: arslist@ARSLIST.ORG Subject: Re: Adding days to a Date field in a qualification doesn't work Mark, I know there was a Unix Client and a Windows Client, I will have to guess on the 3rd client--Linux? Jennifer Meyer -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mark Milke Sent: Tuesday, October 28, 2008 6:56 AM To: arslist@ARSLIST.ORG Subject: Re: Adding days to a Date field in a qualification doesn't work An easy way to do this is to use the multipliers. You will also need to use $TIMESTAMP$ 'my_date_field' ($TIMESTAMP$ + (60*60*24*182)) $TIMESTAMP$ returns the number of seconds elapsed since midnight Coordinated Universal Time (UTC) of January 1, 1970. Guess what platform Remedy ARS was first built upon? That's right UNIX. There used to be 3 clients. Anyone know what they were? Note: Remedy ARS was built before there was a Public Internet. Come to think of it, there may have been 4 clients at one time, but there may not have been one for IBM OS/2. When you do it this way, you can substitute a $variable or a number whenever you like. I've tried that too, of course. When your my_date_field is a DATE field the example you're showing will n o t work. At least on my 6.3 patch 024 it just doesn't work. Thanks anyway! Mark ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: LOB Space Reclaim Issue
I have not had your exact issue but we were able to reclaim our db by running a script located in the RemedyAndOracleCLOBS.pdf document. It details how to reclaim space and gives an oracle stored procedure you can use to change all lob storage to In-Row from Out of Row. By running the procedure our db size was reduced from 43 gig to less than 8 gig successfully. We did not run into the same issues you are having. We are on Oracle 10g patch 10.2.0.3.0 64 bit. Thanks, Sean From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Do Duy Sent: Tuesday, October 28, 2008 1:10 AM To: arslist@ARSLIST.ORG Subject: LOB Space Reclaim Issue ** Hi, I just wanted to find out if anyone has had this problem and possibly how the issue was resolved. Details of the problem is below. Thank you in advance, Duy Do Broadcast Australia Database Version Database is on Oracle 10G 10.2.0.2.0 Standard Edition on Sun Solaris. Operation done Database is growing, so after the deletes in Development database, we tried Space reclaim of the tables containing LOB segments by running 'alter table table_name enable row movement' and 'alter table table_name shrink space cascade'. Space Reclaim was successful. Observed Problem But after that, the read access to the database Lobs gave ORA-1555 Snapshot too old error messsage. Patch Apply Found Applied Patch 5636728 which was to address FALSE ORA-1555 WHEN READING LOBS AFTER SHRINK, but it didn't help. Later Steps Finally, we had to restore the original Dev database from the backup. Fortunately this test was done on the Development database with the intention of doing it on Production later. Currently the DB is on Oracle 10.2.0.2.0, latest patchset 10.2.0.4 will be applied at some point in time as per the compatibility with the Application. But the patch 5636728, which was to address false Ora-1555 after LOB shrink, was applied successfully. But the ORA-1555 problem remained. Error showed up when Action Remedy application tried to access the data after the LOB space shrink. Even export gave the same error. The Original Dev database as per before the Space shrink was restored from the backup. Frequency of the error Consistently Impact to the Business Production database is growing and we need to be able to reclaim space We still have the problematic database copy with the LOBs shrunk, so any diagnostic scripts or actions as advised can be run there. *** IMPORTANT NOTICE This email and any attachments may be confidential and/or privileged, in which case neither is intended to be waived. If received in error, please contact us and delete all copies. Before opening or using attachments, check them for viruses and defects. Our liability is limited to resupplying any affected attachments. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Escalation Threads
I was wondering does anyone know what a good numbering is for the AR Escalation threads, min/max. We have a Large system, with about 100,000 incidents just to give you an idea. We have all applications, Service Desk, Change Management, CMDB, Asset, SLM etc... For some reason our escalations started to almost stop the other day and we looked and it was set to 1:1. Kevin Begosh, RSP ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Oracle Link problems
I am trying to work with EIE 5.1 with Oracle Link for AR 6.3. When I try to list the tables from the Oracle DB, I am getting nothing back. When I run rulehelper from the UNIX command line, I am getting Connection to Oracle database Failed yet, SQLPLUS can connect and TNSPING works. Ron Suwanski Remedy Administrator / Developer DeVry Inc. One Tower Lane Oakbrook Terrace, IL 60181 p: 630.472.2209 f: 630.706.3446 e: mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] www.devry.edu http://www.devry.com/ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are image001.jpg
Re: Web Reporting
Use BIRT. Open Source, works OK. You'll need to understand a whack of stuff about Web Reporting and (perhaps) write a one or two line Java class. We use it on this project in ITSM 7. Even easier for your own stuff. Cheers Ben Chernys _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Bill Myers Sent: October 28, 2008 2:56 PM To: arslist@ARSLIST.ORG Subject: Web Reporting ** I attempted this post yesterday and did not see it on the list. I apologize if it is a repeat. We are looking at solutions for providing the ability to view, save to file and print Crystal Reports from the ARS 7.1 mid-tier (we do not currently use the mid-tier). I have received so much conflicting information and I was hoping someone would share their experiences. We have been told we need to spend anywhere from $600 to $100,000. We have a list of 6 - 8 products and versions that may or may not be workable. Obviously, we would like to spend as little money as possible. So, would anyone who has travelled this path be willing to share the details of their implementation including approximate costs and licensing requirements? I've contacted BMC support and of course was told to look at the product compatibility matrix. I have and I've looked at the mid-tier documentation. What it doesn't tell you is which supported application would be best suited to our implementation (small company with limited but growing reporting needs) and if there may be other un-supported apps that could do the trick. Of course, the vendors want to sell you the Cadillac when a Yugo would suffice. Thanks! ARS 7.1 (unpatched at present) on Windows Oracle 10.2 on Linux ARS 7.1 mid-tier on Linux Completely custom applications Bill Myers Remedy Developer Datacraft Solutions, Inc. [EMAIL PROTECTED] (p) 919-667-9804 (f) 919-682-5986 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Web Reporting
We upgraded our Crystal Reports Professional copies to XI when 7.x came out, and are using the Crystal Reports Server XI that came bundled with it to serve up our reports for mid-tier. Before 7.x, we were using Crystal Reports Professional 9 with the bundled Crystal Enterprise 9 web server in exactly the same manner for the 5.1.2 and 6.3 mid-tiers. Version XI is where BO switched from providing 5 concurrent licenses with their bundled web server (all you needed to make mid-tier reporting work) to 5 named licenses, which does not work unless you tell mid-tier that it is talking to a BOXI server instead of a Crystal Reports Server. I am not sure what BO is shipping now, but in theory the web server bundled with Crystal Reports Professional should be all that you need to serve reports for the mid-tier, since we don't serve anything else (no one is accessing any crystal report natively, only those built into the ITSM application and available through the mid-tier). I'm not sure you will find anyone still working at BMC Remedy who understands this and can give you coherent advice. For many years we were told by support that Crystal Reports Professional was the correct low-cost answer since all you needed was the bundled web server with 5 concurrent licenses to serve up reports on the web; this was true using Crystal 8.5 and 9 with earlier versions of the mid-tier. You needed Crystal Reports Professional itself to edit any of the OOTB reports, or create custom ones for import into the application, so it was the perfect choice of products. When 7.x came out and required a 10 or XI level version of Crystal, whoever knew how that worked was already gone. It took me almost a year to convince support that the licensing had changed in XI and was causing problems for the mid-tier when using the settings they had specified in their documentation. They were working under the false assumption that everyone would have a full-blown, fully licensed version of Crystal Reports Server XI or BOXI available to them, and had not kept up with the web reporting server bundled with CR Professional. I would contend that CR Professional and its bundled web server should be the ONLY thing that you need to do reporting for mid-tier. It would be a gross imposition by BMC Remedy to expect that everyone must buy a more powerful (and expensive) version of the CR/BOXI web server than that just to serve up reports on the web. That function alone cannot justify the cost of a fully licensed BO web server, which is intended (and priced) for serving up complex, native crystal reports over its own interface, to users registered within its own security model. That's like using a .600 Nitro Express to hunt mice. You should investigate whatever BO is currently selling as Crystal Reports Professional and whatever web server is currently shipping with it. You may have to buy the current version but ask for an earlier version in order to get compatibility with ARS 7.x; I have not looked past the original distribution of XI. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Bill Myers Sent: Tuesday, October 28, 2008 8:56 AM To: arslist@ARSLIST.ORG Subject: Web Reporting ** I attempted this post yesterday and did not see it on the list. I apologize if it is a repeat. We are looking at solutions for providing the ability to view, save to file and print Crystal Reports from the ARS 7.1 mid-tier (we do not currently use the mid-tier). I have received so much conflicting information and I was hoping someone would share their experiences. We have been told we need to spend anywhere from $600 to $100,000. We have a list of 6 - 8 products and versions that may or may not be workable. Obviously, we would like to spend as little money as possible. So, would anyone who has travelled this path be willing to share the details of their implementation including approximate costs and licensing requirements? I've contacted BMC support and of course was told to look at the product compatibility matrix. I have and I've looked at the mid-tier documentation. What it doesn't tell you is which supported application would be best suited to our implementation (small company with limited but growing reporting needs) and if there may be other un-supported apps that could do the trick. Of course, the vendors want to sell you the Cadillac when a Yugo would suffice. Thanks! ARS 7.1 (unpatched at present) on Windows Oracle 10.2 on Linux ARS 7.1 mid-tier on Linux Completely custom applications Bill Myers Remedy Developer Datacraft Solutions, Inc. [EMAIL PROTECTED] (p) 919-667-9804 (f) 919-682-5986 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___
Re: Active Link Function in an Escalation???
Thanks Fred, that did the trick. I completely forgot about the LPAD command. Must be getting old. Christopher Pruitt EDS, an HP Company mailto: [EMAIL PROTECTED] We deliver on our commitments so you can deliver on yours. 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:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: Monday, October 27, 2008 4:42 PM To: arslist@ARSLIST.ORG Subject: Re: Active Link Function in an Escalation??? ** What kind of error are you getting using TIMESTAMP? I have used the DAY, MONTH, and YEAR functions in set fields before with no problems (Except having to use LPAD as well). Escalation_ + LPAD(YEAR($TIMESTAMP$),4,2000) + LPAD(MONTH($TIMESTAMP$),2,00) + LPAD(DAY($TIMESTAMP$),2,00) + .log Fred From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Pruitt, Christopher J Sent: Monday, October 27, 2008 4:00 PM To: arslist@ARSLIST.ORG Subject: Re: Active Link Function in an Escalation??? ** Yes, but it still does not get us to the MMDD format we need. We can get DDMMYY at best so far. Christopher Pruitt EDS, an HP Company mailto: [EMAIL PROTECTED] We deliver on our commitments so you can deliver on yours. 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:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Monday, October 27, 2008 3:49 PM To: arslist@ARSLIST.ORG Subject: Re: Active Link Function in an Escalation??? ** Chris, Have you tried replacing the invalid characters to either null or an underscore or something? Joe - Original Message From: Pruitt, Christopher J [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, October 27, 2008 2:13:37 PM Subject: Active Link Function in an Escalation??? Hello Fellow Listers, Does anyone know a way to mimic the Active Link functions within an Escalation? I am trying to find a way to do the following to create log entries, on a UNIX server, that have a unique timestamp. These logs turn on and off every day. These logs are created via a SET FIELDS action into the field 'escalationlogfile' on the AR System Administration: Server Information form. We are able to turn the log on and off at defined times. Currently we are using Escalation_ + REPLACE(DATE($DATE$), /, )) + .log and it crates a log file with the name Escalation_102708.log However, we would like to name the file Escalation_20081027.log so that it is in the format MMDD. We have tried this command but it does not work. Escalation_ + YEAR($TIMESTAMP$)) + MONTH($TIMESTAMP$)) + DAY($TIMESTAMP$) + .log I can't use $TIMESTAMP$ and that is not a valid UNIX file name, meaning the file name comes across as Escalation_10/27/288 12:00:00 PM.log, which is not valid. Any help would be appreciated.
Re: Escalation Threads
Not sure I can give you a good number, but definitely increasing it would be a good thing (and then changing the pool on each escalation to the corresponding thread). From: Action Request System discussion list(ARSList) on behalf of Begosh, Kevin Sent: Tue 10/28/2008 11:11 AM To: arslist@ARSLIST.ORG Subject: Escalation Threads ** I was wondering does anyone know what a good numbering is for the AR Escalation threads, min/max. We have a Large system, with about 100,000 incidents just to give you an idea. We have all applications, Service Desk, Change Management, CMDB, Asset, SLM etc... For some reason our escalations started to almost stop the other day and we looked and it was set to 1:1. Kevin Begosh, RSP __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Escalation Threads
Escalations by default run in 1 (pool/thread), if you have some long running escalations/escalations you want running concurrently you will need to increase the thread count to accommodate as many as you want to run simultaneously, and then edit the escalations to run in specific pools, this will define which thread they run in. _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Begosh, Kevin Sent: Tuesday, October 28, 2008 9:11 AM To: arslist@ARSLIST.ORG Subject: Escalation Threads ** I was wondering does anyone know what a good numbering is for the AR Escalation threads, min/max. We have a Large system, with about 100,000 incidents just to give you an idea. We have all applications, Service Desk, Change Management, CMDB, Asset, SLM etc... For some reason our escalations started to almost stop the other day and we looked and it was set to 1:1. Kevin Begosh, RSP __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Crystal Report Question
Hi Shawn,
A rather easier way of doing this would be to use Select Expert. Your
records probably need grouping via Day/Date. Once the records are grouped
you can use select expert to define the criteria for your report. Please
consider the following formula as an example.
[EMAIL PROTECTED] in Time (0, 00, 40) to Time (0, 20, 40) and
{Form.Date/Time} in DateTime (2008, 08, 13, 00, 06, 40) to DateTime (2008,
09, 07, 12, 32, 01)
In the above formula @Time is a variable that I created which basically
returns Time from DateTime field.
Hope this approach would help you.
Regards,
Mohtashim Abbasi
Remedy Consultant
Technosys UK Limited
DDI : +44208 429 5954
Main: +44208 429 5955
Mobile: +447590554781
Email: [EMAIL PROTECTED]
Web: http://www.technosysuk.com
204 - 226 Imperial Drive
Rayners Lane, Harrow
Middlesex HA2 7HH
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Shawn Stonequist
Sent: 28 October 2008 14:10
To: arslist@ARSLIST.ORG
Subject: Crystal Report Question
Greetings List!
Nor a Remedy question, but hopefully someone can help me anyway.
I'm trying to write a report to show all records created between Sunday 7pm
through Friday 7am between the hours of 7am and 7pm.
I've tried
Time({Form.Create Date})Time (18, 59, 59) or
Time({Form.Create Date})Time (7, 00, 00)) and
DayOfWeek({Form.Create Date})7
however, this gives me records created between Friday 7pm and Sunday 7am as
well, which need to be excluded.
I tried thinking of a way to exclude Sunday AM and Friday PM, but couldn't
think how to do this.
Ideally, I'd like to also group them by Sunday PM/Monday AM, Monday
PM/TuesdayAM, etc.
Does anyone have any ideas?
HUGE THX IN ADVANCE!!!
Shawn Stonequist
EMNS Inc.
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Mid-Tier Web Page is coming up blank
I ran across something similar a few weeks ago after an upgrade. This error will occur if there is a Active Link associated with the form being opened which contains a Open Window action of type Report and the Destination field in the Active Link contains a hard return control character. Look through your Active links and remove the hard return from the Destination field (Note that the hard return shows as a solid black bar in the AR System Administrator tool) to ensure that only a valid value remains. Ryan M. Mench Intelligent Software Solutions Remedy Developer - AS3, AOC WSI Lockheed Martin 9970 Federal Drive, MS 22C Colorado Springs, CO. 80921 (719) 277-4541 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] (WSI Email) [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] (ISS Email) [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Matthew Perrault Sent: Wednesday, October 15, 2008 1:22 PM To: arslist@ARSLIST.ORG Subject: Re: Mid-Tier Web Page is coming up blank ** Frank/Joe Yes there is source code behind the page. I copied it and dropped it into a html file on my local machine and it still showed up blank. I did go through the net and look for something similar to this and I did find something similar from back in 2005 and it was with 6.3 and it was the same thing. The lady said that it had to do with the extensions not being listed or blocked in IIS. Well I did check and correct that in IIS, yet the page still came up blank. With regards to the timezone, I changed my client pc timezone to GMT +10 Canberra, Melbourne, Sydney And when I hit the web page, this is what it is showing as the time zone: usertimezone=Antarctica%2FDumontDUrville For some odd reason, that just doesn't look correct Matt From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Frank Caruso Sent: Thursday, October 16, 2008 5:08 AM To: arslist@ARSLIST.ORG Subject: Re: Mid-Tier Web Page is coming up blank ** Is there source code behind the page? Or is there nothing coming back in teh for of JScript and HTML tags? I had this happen the other night. Upgraded MT, went to config page and all was well. Then tried opening the Home page and got a blank screen, but there was source code. After playing around for a few minutes I decided to close all my browsers and try again. The next time it worked and the home page came up. On Wed, Oct 15, 2008 at 2:35 PM, Joe DeSouza [EMAIL PROTECTED] wrote: ** On windows IIS, when all fails, restart the darn box :-) On a more serious note, do you see anything in the mid-tier logs or your IIS logs? Joe - Original Message From: Matthew Perrault [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Wednesday, October 15, 2008 1:51:28 PM Subject: Mid-Tier Web Page is coming up blank ** All, We recently installed Mid-Tier 7.1 Patch 3 on a box in Australia . I can log into the configuration page and that comes up fine. Yet when I try and go to an actual form, I get the little animated Loading... gif, then it says downloading item 10 of 16 (in the lower left corner of IE), it counts down to 1 of 16 then finishes. Then in the lower left corner it says Done. Yet the Web Page is blank. Nothing there, no errors, just a blank white web page. The strange thing is we have this same Mid-Tier version installed on other servers and all of them seem to work fine. The odd things about this server are with IIS. First it doesn't have the standard defaultWebSite it has something else. But that shouldn't matter as I've installed it under other Web Sites in IIS and gotten it to work. The other thing is, this has a specific IP specified in the Web Site identification. Yet I tried removing that and now luck either. At this point I don't know where else to look to try and figure out why this web page won't come up. ARS 7.0.1 Patch 4 Windows 2003 SQL Server Mid-Tier: 7.1 Patch 3 IIS 6 Apache/Tomcat 5.5 Any thoughts or suggestions on where to go from here with this issue would be appreciated. Thanks Matthew Perrault __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are attachment: image001.jpg
ARERR [286] Display only fields cannot be included in a query to the database
Dear List, We want to submit a form entry, and re-open it. In the process of being submitted the form creates some subfile form entries, so we can’t use “$LASTID$.” Instead we query the db for the “max(Request ID).” So in the Active Link, which runs “After Submit,” I set “display-only-field” equal to the value returned by the sql selection. Then it does a “Window Open” and brings up the form entry where “'Request ID' = $display-only-field$. This works in our test/development system, but in the live system I get: “ARERR [286] Display only fields cannot be included in a query to the database: 561000490,” and the window doesn’t open. (561000490 is the display-only-field id.) The error doesn’t appear in the Active Link (workflow.log), filter, or sql logs. I also tried the BMC KB with no luck. The Active Link log shows “display-only-field” being set to the correct value. By adding messages between the Active Link actions I see that the error happens on the “Window Open” command. I replaced “display-only-field” with a database field and that works. But I don’t like using data fields to store useless values. What is wrong with using a display-only field to select a record in an Open Window action? And why would it work OK in one system and not in another (supposedly identical) system? I’ll appreciate any suggestions. (ARS 7.1 patch 2, RH Linux server, Oracle 10.2 db) Dwayne Martin James Madison University
Re: ARERR [286] Display only fields cannot be included in a query to the database
Since you are using an After Submit AL you can do it much easier. Just do your Window Open action using: 'Request ID' = $Request ID$ The correct Request ID is available in an After Submit Active Link Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin Sent: Tuesday, October 28, 2008 11:57 AM To: arslist@ARSLIST.ORG Subject: ARERR [286] Display only fields cannot be included in a query to the database Dear List, We want to submit a form entry, and re-open it. In the process of being submitted the form creates some subfile form entries, so we can't use $LASTID$. Instead we query the db for the max(Request ID). So in the Active Link, which runs After Submit, I set display-only-field equal to the value returned by the sql selection. Then it does a Window Open and brings up the form entry where 'Request ID' = $display-only-field$. This works in our test/development system, but in the live system I get: ARERR [286] Display only fields cannot be included in a query to the database: 561000490, and the window doesn't open. (561000490 is the display-only-field id.) The error doesn't appear in the Active Link (workflow.log), filter, or sql logs. I also tried the BMC KB with no luck. The Active Link log shows display-only-field being set to the correct value. By adding messages between the Active Link actions I see that the error happens on the Window Open command. I replaced display-only-field with a database field and that works. But I don't like using data fields to store useless values. What is wrong with using a display-only field to select a record in an Open Window action? And why would it work OK in one system and not in another (supposedly identical) system? I'll appreciate any suggestions. (ARS 7.1 patch 2, RH Linux server, Oracle 10.2 db) Dwayne Martin James Madison University ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Dave Wallace is out of the office.
I will be out of the office starting 10/28/2008 and will not return until 10/30/2008. I will be OOO until 10.30. If you need immediate assistance then email SMT-ProdEng. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Where is the arsystem.lic?
Hi all!!! I have my server running on Suse Linux Enterprise Server 10. It is licensed without problem, I can export the lic file from the Arsystem administration console but now here is the question, where is in my server the arsystem.lic?.usually on a Linux server is in */etc/arsystem/server_name/arsystem.lic *In this diretory, I have only the files arsystem.tag.bak, armonitor.con.bk, armonitor.conf and arsystem.tag, but nothing else.I try to find it with the find command, but I have no idea where is it. Could somebody help me please?. Thanks a lot in advance. Alberto ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Where is the arsystem.lic?
Since AR System 7.1 the remedy licenses are no longer kept in files, but they are now in the database! You can access them from the AR System Administration console. Regards, -- Michiel Beijen Software Consultant +31 6 - 457 42 418 Bee Free IT + http://beefreeit.nl On Tue, Oct 28, 2008 at 6:41 PM, Al_Remedy [EMAIL PROTECTED] wrote: ** Hi all!!! I have my server running on Suse Linux Enterprise Server 10. It is licensed without problem, I can export the lic file from the Arsystem administration console but now here is the question, where is in my server the arsystem.lic?.usually on a Linux server is in /etc/arsystem/server_name/arsystem.lic In this diretory, I have only the files arsystem.tag.bak, armonitor.con.bk, armonitor.conf and arsystem.tag, but nothing else.I try to find it with the find command, but I have no idea where is it. Could somebody help me please?. Thanks a lot in advance. Alberto __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Where is the arsystem.lic?
It's ok, I can see them in my AR system administrador console, but do you know w the name of the table in which I could see them?. Thank you very much!!! 2008/10/28 Michiel Beijen [EMAIL PROTECTED] Since AR System 7.1 the remedy licenses are no longer kept in files, but they are now in the database! You can access them from the AR System Administration console. Regards, -- Michiel Beijen Software Consultant +31 6 - 457 42 418 Bee Free IT + http://beefreeit.nl On Tue, Oct 28, 2008 at 6:41 PM, Al_Remedy [EMAIL PROTECTED] wrote: ** Hi all!!! I have my server running on Suse Linux Enterprise Server 10. It is licensed without problem, I can export the lic file from the Arsystem administration console but now here is the question, where is in my server the arsystem.lic?.usually on a Linux server is in /etc/arsystem/server_name/arsystem.lic In this diretory, I have only the files arsystem.tag.bak, armonitor.con.bk, armonitor.conf and arsystem.tag, but nothing else.I try to find it with the find command, but I have no idea where is it. Could somebody help me please?. Thanks a lot in advance. Alberto __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Escalation Threads
We added a second thread and configured the primary notification engine escalation, SYS:NPC:IM1-TriggerGroupNTG, to use that thread. We have significant notification volume based on some standard Service Targets, and this escalation is on a one minute poll. Bottom line, identify your high intensity escalations and assign them to a separate pool to avoid having them impact the other escalations. -- Chris Danaceau This e-mail and its attachments are confidential and solely for the intended addressee(s). Do not share or use them without Fannie Mae's approval. If received in error, contact the sender and delete them. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Begosh, Kevin Sent: Tuesday, October 28, 2008 11:11 AM To: arslist@ARSLIST.ORG Subject: Escalation Threads ** I was wondering does anyone know what a good numbering is for the AR Escalation threads, min/max. We have a Large system, with about 100,000 incidents just to give you an idea. We have all applications, Service Desk, Change Management, CMDB, Asset, SLM etc... For some reason our escalations started to almost stop the other day and we looked and it was set to 1:1. Kevin Begosh, RSP __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Crystal Report Question
This is how I attacked the problem.
I created two formulas.
* DayOfWeek
oDayOfWeek ({HPD_HelpDesk.Create Time})
* Hour
oHour ({HPD_HelpDesk.Create Time})
I then used them in the Select Statement.
{HPD_HelpDesk.Create Time} in LastFullWeek and
(([EMAIL PROTECTED] = 1 AND [EMAIL PROTECTED] 19) OR
([EMAIL PROTECTED] = 2) OR
([EMAIL PROTECTED] = 3) OR
([EMAIL PROTECTED] = 4) OR
([EMAIL PROTECTED] = 5) OR
([EMAIL PROTECTED] = 6 AND [EMAIL PROTECTED] 19))
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Shawn Stonequist
Sent: Tuesday, October 28, 2008 9:10 AM
To: arslist@ARSLIST.ORG
Subject: Crystal Report Question
Greetings List!
Nor a Remedy question, but hopefully someone can help me anyway.
I'm trying to write a report to show all records created between Sunday
7pm
through Friday 7am between the hours of 7am and 7pm.
I've tried
Time({Form.Create Date})Time (18, 59, 59) or
Time({Form.Create Date})Time (7, 00, 00)) and
DayOfWeek({Form.Create Date})7
however, this gives me records created between Friday 7pm and Sunday 7am
as
well, which need to be excluded.
I tried thinking of a way to exclude Sunday AM and Friday PM, but
couldn't
think how to do this.
Ideally, I'd like to also group them by Sunday PM/Monday AM, Monday
PM/TuesdayAM, etc.
Does anyone have any ideas?
HUGE THX IN ADVANCE!!!
Shawn Stonequist
EMNS Inc.
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
*** Confidentiality Notice ***
This email, its electronic document attachments, and the contents of its
website linkages may contain confidential health information. This information
is intended solely for use by the individual or entity to whom it is addressed.
If you have received this information in error, please notify the sender
immediately and arrange for the prompt destruction of the material and any
accompanying attachments.
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Crystal Report Question
As far as grouping goes, You can create the first group on DayOfWeek and
create a formula for AM/PM and create a second group on that.
AM/PM formula
If [EMAIL PROTECTED] 12 Then AM Else
If [EMAIL PROTECTED] = 12 Then PM
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Shawn Stonequist
Sent: Tuesday, October 28, 2008 9:10 AM
To: arslist@ARSLIST.ORG
Subject: Crystal Report Question
Greetings List!
Nor a Remedy question, but hopefully someone can help me anyway.
I'm trying to write a report to show all records created between Sunday
7pm
through Friday 7am between the hours of 7am and 7pm.
I've tried
Time({Form.Create Date})Time (18, 59, 59) or
Time({Form.Create Date})Time (7, 00, 00)) and
DayOfWeek({Form.Create Date})7
however, this gives me records created between Friday 7pm and Sunday 7am
as
well, which need to be excluded.
I tried thinking of a way to exclude Sunday AM and Friday PM, but
couldn't
think how to do this.
Ideally, I'd like to also group them by Sunday PM/Monday AM, Monday
PM/TuesdayAM, etc.
Does anyone have any ideas?
HUGE THX IN ADVANCE!!!
Shawn Stonequist
EMNS Inc.
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
*** Confidentiality Notice ***
This email, its electronic document attachments, and the contents of its
website linkages may contain confidential health information. This information
is intended solely for use by the individual or entity to whom it is addressed.
If you have received this information in error, please notify the sender
immediately and arrange for the prompt destruction of the material and any
accompanying attachments.
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Crystal Report Question
Sorry, I realized after rereading your email that I missed a portion.
(([EMAIL PROTECTED] = 1 AND [EMAIL PROTECTED] 19) OR
([EMAIL PROTECTED] = 2) And [EMAIL PROTECTED] In [7,8, 9, 10, 11, 12, 13, 14,
15, 16,
17, 18] OR
([EMAIL PROTECTED] = 3) And [EMAIL PROTECTED] In [7,8, 9, 10, 11, 12, 13, 14,
15, 16,
17, 18] OR
([EMAIL PROTECTED] = 4) And [EMAIL PROTECTED] In [7,8, 9, 10, 11, 12, 13, 14,
15, 16,
17, 18] OR
([EMAIL PROTECTED] = 5) And [EMAIL PROTECTED] In [7,8, 9, 10, 11, 12, 13, 14,
15, 16,
17, 18] OR
([EMAIL PROTECTED] = 6) And [EMAIL PROTECTED] In [7,8, 9, 10, 11, 12, 13, 14,
15, 16,
17, 18]) and
{HPD_HelpDesk.Create Time} in LastFullWeek
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Shawn Stonequist
Sent: Tuesday, October 28, 2008 9:10 AM
To: arslist@ARSLIST.ORG
Subject: Crystal Report Question
Greetings List!
Nor a Remedy question, but hopefully someone can help me anyway.
I'm trying to write a report to show all records created between Sunday
7pm
through Friday 7am between the hours of 7am and 7pm.
I've tried
Time({Form.Create Date})Time (18, 59, 59) or
Time({Form.Create Date})Time (7, 00, 00)) and
DayOfWeek({Form.Create Date})7
however, this gives me records created between Friday 7pm and Sunday 7am
as
well, which need to be excluded.
I tried thinking of a way to exclude Sunday AM and Friday PM, but
couldn't
think how to do this.
Ideally, I'd like to also group them by Sunday PM/Monday AM, Monday
PM/TuesdayAM, etc.
Does anyone have any ideas?
HUGE THX IN ADVANCE!!!
Shawn Stonequist
EMNS Inc.
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
*** Confidentiality Notice ***
This email, its electronic document attachments, and the contents of its
website linkages may contain confidential health information. This information
is intended solely for use by the individual or entity to whom it is addressed.
If you have received this information in error, please notify the sender
immediately and arrange for the prompt destruction of the material and any
accompanying attachments.
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Remedy Position in Northern Virginia
Hello Listers We are looking for a experienced Remedy Developers with a secret clearance or the ability to be cleared for a project on Fort Belvoir, VA. Must have a at least 4-5 years experience in the developing of the BMC Remedy (ITSM) application. The candidate must have experience in installation, configuration and customization of Remedy 7 and the ability to customize the product as necessary Candidate should also have strong communication skills both oral and written. Salary: DOE MUST BE A US citizen to be considered for position Thank you in advance for your time. If interested please contact me at the following: Abdul Baytops [EMAIL PROTECTED] ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: LOB Space Reclaim Issue
Sean, I've checked on the support web site and developer network for the RemedyAndOracleCLOBS.pdf. Could you point me to where you found the document? Thanks, Dave From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Garrison, Sean (Norcross) Sent: Tuesday, October 28, 2008 10:49 AM To: arslist@ARSLIST.ORG Subject: Re: LOB Space Reclaim Issue ** I have not had your exact issue but we were able to reclaim our db by running a script located in the RemedyAndOracleCLOBS.pdf document. It details how to reclaim space and gives an oracle stored procedure you can use to change all lob storage to In-Row from Out of Row. By running the procedure our db size was reduced from 43 gig to less than 8 gig successfully. We did not run into the same issues you are having. We are on Oracle 10g patch 10.2.0.3.0 64 bit. Thanks, Sean From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Do Duy Sent: Tuesday, October 28, 2008 1:10 AM To: arslist@ARSLIST.ORG Subject: LOB Space Reclaim Issue ** Hi, I just wanted to find out if anyone has had this problem and possibly how the issue was resolved. Details of the problem is below. Thank you in advance, Duy Do Broadcast Australia Database Version Database is on Oracle 10G 10.2.0.2.0 Standard Edition on Sun Solaris. Operation done Database is growing, so after the deletes in Development database, we tried Space reclaim of the tables containing LOB segments by running 'alter table table_name enable row movement' and 'alter table table_name shrink space cascade'. Space Reclaim was successful. Observed Problem But after that, the read access to the database Lobs gave ORA-1555 Snapshot too old error messsage. Patch Apply Found Applied Patch 5636728 which was to address FALSE ORA-1555 WHEN READING LOBS AFTER SHRINK, but it didn't help. Later Steps Finally, we had to restore the original Dev database from the backup. Fortunately this test was done on the Development database with the intention of doing it on Production later. Currently the DB is on Oracle 10.2.0.2.0, latest patchset 10.2.0.4 will be applied at some point in time as per the compatibility with the Application. But the patch 5636728, which was to address false Ora-1555 after LOB shrink, was applied successfully. But the ORA-1555 problem remained. Error showed up when Action Remedy application tried to access the data after the LOB space shrink. Even export gave the same error. The Original Dev database as per before the Space shrink was restored from the backup. Frequency of the error Consistently Impact to the Business Production database is growing and we need to be able to reclaim space We still have the problematic database copy with the LOBs shrunk, so any diagnostic scripts or actions as advised can be run there. *** IMPORTANT NOTICE This email and any attachments may be confidential and/or privileged, in which case neither is intended to be waived. If received in error, please contact us and delete all copies. Before opening or using attachments, check them for viruses and defects. Our liability is limited to resupplying any affected attachments. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: ARERR [286] Display only fields cannot be included in a query to the database SOLVED
Thanks, Fred! That worked! Sometimes you have to do things the long cumbersome way before you see the simple and obvious. Or, as in this case, someone else points out the simple and obvious. I am still curious why the Open Window action wouldn't accept my display-only field as a qualifier. Dwayne Original message Date: Tue, 28 Oct 2008 12:19:50 -0500 From: Grooms, Frederick W [EMAIL PROTECTED] Subject: Re: ARERR [286] Display only fields cannot be included in a query to the database To: arslist@ARSLIST.ORG Since you are using an After Submit AL you can do it much easier. Just do your Window Open action using: 'Request ID' = $Request ID$ The correct Request ID is available in an After Submit Active Link Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin Sent: Tuesday, October 28, 2008 11:57 AM To: arslist@ARSLIST.ORG Subject: ARERR [286] Display only fields cannot be included in a query to the database Dear List, We want to submit a form entry, and re-open it. In the process of being submitted the form creates some subfile form entries, so we can't use $LASTID$. Instead we query the db for the max(Request ID). So in the Active Link, which runs After Submit, I set display-only-field equal to the value returned by the sql selection. Then it does a Window Open and brings up the form entry where 'Request ID' = $display-only-field$. This works in our test/development system, but in the live system I get: ARERR [286] Display only fields cannot be included in a query to the database: 561000490, and the window doesn't open. (561000490 is the display-only-field id.) The error doesn't appear in the Active Link (workflow.log), filter, or sql logs. I also tried the BMC KB with no luck. The Active Link log shows display-only-field being set to the correct value. By adding messages between the Active Link actions I see that the error happens on the Window Open command. I replaced display-only-field with a database field and that works. But I don't like using data fields to store useless values. What is wrong with using a display-only field to select a record in an Open Window action? And why would it work OK in one system and not in another (supposedly identical) system? I'll appreciate any suggestions. (ARS 7.1 patch 2, RH Linux server, Oracle 10.2 db) Dwayne Martin James Madison University ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Web Reporting
Email me off list with your questions. William Rentfrow Principal Consultant, StrataCom Inc. [EMAIL PROTECTED] 701-306-6157 C From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Bill Myers Sent: Tuesday, October 28, 2008 8:56 AM To: arslist@ARSLIST.ORG Subject: Web Reporting ** I attempted this post yesterday and did not see it on the list. I apologize if it is a repeat. We are looking at solutions for providing the ability to view, save to file and print Crystal Reports from the ARS 7.1 mid-tier (we do not currently use the mid-tier). I have received so much conflicting information and I was hoping someone would share their experiences. We have been told we need to spend anywhere from $600 to $100,000. We have a list of 6 - 8 products and versions that may or may not be workable. Obviously, we would like to spend as little money as possible. So, would anyone who has travelled this path be willing to share the details of their implementation including approximate costs and licensing requirements? I've contacted BMC support and of course was told to look at the product compatibility matrix. I have and I've looked at the mid-tier documentation. What it doesn't tell you is which supported application would be best suited to our implementation (small company with limited but growing reporting needs) and if there may be other un-supported apps that could do the trick. Of course, the vendors want to sell you the Cadillac when a Yugo would suffice. Thanks! ARS 7.1 (unpatched at present) on Windows Oracle 10.2 on Linux ARS 7.1 mid-tier on Linux Completely custom applications Bill Myers Remedy Developer Datacraft Solutions, Inc. [EMAIL PROTECTED] (p) 919-667-9804 (f) 919-682-5986 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
7.1 Shared Database Install
Migrating from a 6.3 database to 7.1p3. All home grown stuff with no OOB applications. Also migrating to brand new application hosts and database hosts. This will allow us to leave the entire production environment untouched while we do the upgrade. ARS is Solaris 9 with Sybase 12.5 on RHEL Abbreviated Steps: 1. Take a COLD copy of the production database and import to new database host. 2. Run 7.1 install on first server which will perform the necessary updates to the database. This will also include running email and flash boards install. 3. Run 7.1 install on second server and run as a shared install not upgrade. This will also include running email and flash boards install. Question: Step 3: All three installs appear to importing the same forms even though the first install took care of that. This step seems to take the longest, about 25 minutes. I'm talking about the Administrator, email and flash boards forms. A. Is is possible to run the shared install but have it not import anything but just install the necessary files on the host? B. If not, can I just copy the entire install directory from the first host to the second and make sure any host specific files are updated? I was able to actually do part B without any issues but wanted to get the communities take on doing an install that way. Thank you. Frank ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Java Version
ok... the new compatibility tool boggled my mind. We are installing the Right Answers KB on our production system. Well, they are hosting it, but I need to install the jdk-6u3-windows-i586-p.exe version of Java on the server. It is a different version than the one I have in production. Will it mess anything up in my production environment? ARS 6.3 Patch 18 HD 6.0 Oracle 10 w/9 libraries Oracle lives on a remote server Windows 2003 4 gig on app server and 8 gig on DB server Claire Sanford Information Systems Division Memorial Hermann Healthcare System Phone: 713 448 6035 [EMAIL PROTECTED] ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: 7.1 Shared Database Install
On UNIX, copying the directories should work.. but not right away... Tweak the system as described below.. The only changes you have to do is changing the server connect name in the ar.conf file, and the AR Server ID in the arsystem startup script, to whatever you want it to be on the other two servers, and then rename the directory under /etc/arystem to whatever your AR Server ID is. You will also have to edit the path to the armonitor.conf file in the arystem startup script to match the complete path /etc/arsystem/. where the armonitor.conf file is. Open up the armonitor.conf file and you will need to edit the server names there to match the name that the particular instance you are creating should use. This is pretty much the gist of what you would need to do. Good luck.. Cheers Joe From: Frank Caruso [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Tuesday, October 28, 2008 4:26:03 PM Subject: 7.1 Shared Database Install ** Migrating from a 6.3 database to 7.1p3. All home grown stuff with no OOB applications. Also migrating to brand new application hosts and database hosts. This will allow us to leave the entire production environment untouched while we do the upgrade. ARS is Solaris 9 with Sybase 12.5 on RHEL Abbreviated Steps: 1. Take a COLD copy of the production database and import to new database host. 2. Run 7.1 install on first server which will perform the necessary updates to the database. This will also include running email and flash boards install. 3. Run 7.1 install on second server and run as a shared install not upgrade. This will also include running email and flash boards install. Question: Step 3: All three installs appear to importing the same forms even though the first install took care of that. This step seems to take the longest, about 25 minutes. I'm talking about the Administrator, email and flash boards forms. A. Is is possible to run the shared install but have it not import anything but just install the necessary files on the host? B. If not, can I just copy the entire install directory from the first host to the second and make sure any host specific files are updated? I was able to actually do part B without any issues but wanted to get the communities take on doing an install that way. Thank you. Frank ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Where is the arsystem.lic?
If I recall right the name of the table begins with LICENSE or LIC.. You should easily find it with this query after logging into the database using the ARAdmin database user id.. select table_name from user_tables where table_name like 'L%'; Joe From: Al_Remedy [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Tuesday, October 28, 2008 1:52:03 PM Subject: Re: Where is the arsystem.lic? ** It's ok, I can see them in my AR system administrador console, but do you know w the name of the table in which I could see them?. Thank you very much!!! 2008/10/28 Michiel Beijen [EMAIL PROTECTED] Since AR System 7.1 the remedy licenses are no longer kept in files, but they are now in the database! You can access them from the AR System Administration console. Regards, -- Michiel Beijen Software Consultant +31 6 - 457 42 418 Bee Free IT + http://beefreeit.nl On Tue, Oct 28, 2008 at 6:41 PM, Al_Remedy [EMAIL PROTECTED] wrote: ** Hi all!!! I have my server running on Suse Linux Enterprise Server 10. It is licensed without problem, I can export the lic file from the Arsystem administration console but now here is the question, where is in my server the arsystem.lic?.usually on a Linux server is in /etc/arsystem/server_name/arsystem.lic In this diretory, I have only the files arsystem.tag.bak, armonitor.con.bk, armonitor.conf and arsystem.tag, but nothing else.I try to find it with the find command, but I have no idea where is it. Could somebody help me please?. Thanks a lot in advance. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: LOB Space Reclaim Issue
I'm wondering where you found that document too.. I don't think I came across such a document anywhere.. Joe From: Shellman, David [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Tuesday, October 28, 2008 3:38:44 PM Subject: Re: LOB Space Reclaim Issue ** Sean, I've checked on the support web site and developer network for the RemedyAndOracleCLOBS.pdf. Could you point me to where you found the document? Thanks, Dave From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Garrison, Sean (Norcross) Sent: Tuesday, October 28, 2008 10:49 AM To: arslist@ARSLIST.ORG Subject: Re: LOB Space Reclaim Issue ** I have not had your exact issue but we were able to reclaim our db by running a script located in the RemedyAndOracleCLOBS.pdf document. It details how to reclaim space and gives an oracle stored procedure you can use to change all lob storage to In-Row from Out of Row. By running the procedure our db size was reduced from 43 gig to less than 8 gig successfully. We did not run into the same issues you are having. We are on Oracle 10g patch 10.2.0.3.0 64 bit. Thanks, Sean From:Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Do Duy Sent: Tuesday, October 28, 2008 1:10 AM To: arslist@ARSLIST.ORG Subject: LOB Space Reclaim Issue ** Hi, I just wanted to find out if anyone has had this problem and possibly how the issue was resolved. Details of the problem is below. Thank you in advance, Duy Do Broadcast Australia Database Version Database is on Oracle 10G 10.2.0.2.0 Standard Edition on Sun Solaris. Operation done Database is growing, so after the deletes in Development database, we tried Space reclaim of the tables containing LOB segments by running 'alter table table_name enable row movement' and 'alter table table_name shrink space cascade'. Space Reclaim was successful. Observed Problem But after that, the read access to the database Lobs gave ORA-1555 Snapshot too old error messsage. Patch Apply Found Applied Patch 5636728 which was to address FALSE ORA-1555 WHEN READING LOBS AFTER SHRINK, but it didn't help. Later Steps Finally, we had to restore the original Dev database from the backup. Fortunately this test was done on the Development database with the intention of doing it on Production later. Currently the DB is on Oracle 10.2.0.2.0, latest patchset 10.2.0.4 will be applied at some point in time as per the compatibility with the Application. But the patch 5636728, which was to address false Ora-1555 after LOB shrink, was applied successfully. But the ORA-1555 problem remained. Error showed up when Action Remedy application tried to access the data after the LOB space shrink. Even export gave the same error. The Original Dev database as per before the Space shrink was restored from the backup. Frequency of the error Consistently Impact to the Business Production database is growing and we need to be able to reclaim space We still have the problematic database copy with the LOBs shrunk, so any diagnostic scripts or actions as advised can be run there. *** IMPORTANT NOTICE This email and any attachments may be confidential and/or privileged, in which case neither is intended to be waived. If received in error, please contact us and delete all copies. Before opening or using attachments, check them for viruses and defects. Our liability is limited to resupplying any affected attachments. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: 7.1 Shared Database Install
Are you using Unicode? I just checked my logs and on Solaris 10 (Oracle no Unicode) it did not do the import on the shared instance. You might check your install log and see if the installer accepted your input as shared. The log location is /usr/tmp/ar_install.log Fred From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Frank Caruso Sent: Tuesday, October 28, 2008 3:26 PM To: arslist@ARSLIST.ORG Subject: 7.1 Shared Database Install ** Migrating from a 6.3 database to 7.1p3. All home grown stuff with no OOB applications. Also migrating to brand new application hosts and database hosts. This will allow us to leave the entire production environment untouched while we do the upgrade. ARS is Solaris 9 with Sybase 12.5 on RHEL Abbreviated Steps: 1. Take a COLD copy of the production database and import to new database host. 2. Run 7.1 install on first server which will perform the necessary updates to the database. This will also include running email and flash boards install. 3. Run 7.1 install on second server and run as a shared install not upgrade. This will also include running email and flash boards install. Question: Step 3: All three installs appear to importing the same forms even though the first install took care of that. This step seems to take the longest, about 25 minutes. I'm talking about the Administrator, email and flash boards forms. A. Is is possible to run the shared install but have it not import anything but just install the necessary files on the host? B. If not, can I just copy the entire install directory from the first host to the second and make sure any host specific files are updated? I was able to actually do part B without any issues but wanted to get the communities take on doing an install that way. Thank you. Frank ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: LOB Space Reclaim Issue
The Using Oracle CLOBs with BMC Remedy Action Request System whitepaper is here; http://www.bmc.com/supportu/documents/96/63/89663/89663.pdf Mark From: Action Request System discussion list(ARSList) on behalf of Joe DeSouza Sent: Tue 28/10/2008 21:22 To: arslist@ARSLIST.ORG Subject: Re: LOB Space Reclaim Issue ** I'm wondering where you found that document too.. I don't think I came across such a document anywhere.. Joe From: Shellman, David [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Tuesday, October 28, 2008 3:38:44 PM Subject: Re: LOB Space Reclaim Issue ** Sean, I've checked on the support web site and developer network for the RemedyAndOracleCLOBS.pdf. Could you point me to where you found the document? Thanks, Dave From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Garrison, Sean (Norcross) Sent: Tuesday, October 28, 2008 10:49 AM To: arslist@ARSLIST.ORG Subject: Re: LOB Space Reclaim Issue ** I have not had your exact issue but we were able to reclaim our db by running a script located in the RemedyAndOracleCLOBS.pdf document. It details how to reclaim space and gives an oracle stored procedure you can use to change all lob storage to In-Row from Out of Row. By running the procedure our db size was reduced from 43 gig to less than 8 gig successfully. We did not run into the same issues you are having. We are on Oracle 10g patch 10.2.0.3.0 64 bit. Thanks, Sean From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Do Duy Sent: Tuesday, October 28, 2008 1:10 AM To: arslist@ARSLIST.ORG Subject: LOB Space Reclaim Issue ** Hi, I just wanted to find out if anyone has had this problem and possibly how the issue was resolved. Details of the problem is below. Thank you in advance, Duy Do Broadcast Australia Database Version Database is on Oracle 10G 10.2.0.2.0 Standard Edition on Sun Solaris. Operation done Database is growing, so after the deletes in Development database, we tried Space reclaim of the tables containing LOB segments by running 'alter table table_name enable row movement' and 'alter table table_name shrink space cascade'. Space Reclaim was successful. Observed Problem But after that, the read access to the database Lobs gave ORA-1555 Snapshot too old error messsage. Patch Apply Found Applied Patch 5636728 which was to address FALSE ORA-1555 WHEN READING LOBS AFTER SHRINK, but it didn't help. Later Steps Finally, we had to restore the original Dev database from the backup. Fortunately this test was done on the Development database with the intention of doing it on Production later. Currently the DB is on Oracle 10.2.0.2.0, latest patchset 10.2.0.4 will be applied at some point in time as per the compatibility with the Application. But the patch 5636728, which was to address false Ora-1555 after LOB shrink, was applied successfully. But the ORA-1555 problem remained. Error showed up when Action Remedy application tried to access the data after the LOB space shrink. Even export gave the same error. The Original Dev database as per before the Space shrink was restored from the backup. Frequency of the error Consistently Impact to the Business Production database is growing and we need to be able to reclaim space We still have the problematic database copy with the LOBs shrunk, so any diagnostic scripts or actions as advised can be run there. *** IMPORTANT NOTICE This email and any attachments may be confidential and/or privileged, in which case neither is intended to be waived. If received in error, please contact us and delete all copies. Before opening or using attachments, check them for viruses and defects. Our liability is limited to resupplying any affected attachments. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Best practice? Email engine with two Remedy servers on a single unix box
Can I do a single email engine to service two Remedy servers? Load isn't an issue as these are my DEV QA servers. My Informix DBs for both are remote. Remedy v7.1 on Solaris 10 Informix 10 Thanks in advance! ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Best practice? Email engine with two Remedy servers on a single unix box
This in my opinion may not be possible as the core configuration and data forms supporting the email engine have to reside on the AR Server that the Email Engine services. The Email Engine looks for these forms and I'm pretty sure if they are missing, it would complain about their absense. Joe From: Steve McDonald [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Tuesday, October 28, 2008 7:33:11 PM Subject: Best practice? Email engine with two Remedy servers on a single unix box ** Can I do a single email engine to service two Remedy servers? Load isn't an issue as these are my DEV QA servers. My Informix DBs for both are remote. Remedy v7.1 on Solaris 10 Informix 10 Thanks in advance! ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
DSO Help
I'm trying to get a DSO Return action to work and it seems to only work if I physically modify a ticket. Let me explain. On Server A, Form A upon submit it will DSO transfer data with ownership to Server B, Form B. We have that working now. On Server B, Form B we have filter workflow upon Merge that creates a ticket in Form C and then updates Form B with information. What I would like is when Form B is updated with Form C's information, to DSO Return that information back to Server A, Form A. I have a Filter (Modify Merge) for the DSO Return to send back data and ownership. Right now the DSO return only works if I physically make a modification to Form B on Server B, which will kick off the Filter and DSO Return. But it doesn't seem to work automatically which I thought would happen since I have the Filter also running on Merge. In the Filter logs I do see this note... Note: Distributed Server cannot transfer or return unless overridden I do have the Override option checked for Duplicate IDs. Anybody have any experience with DSO Returns that could help me out? Thanks, Corey ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: DSO Help
Corey, Set the Update Option in the DSO mapping to Immediately which will automatically update back to server A, form A whenever an update is made to server B, form B. Bruce Hyslop Unisys Bruce Hyslop | Remedy Developer | Remedy Support Unisys | 3199 Pilot Knob Road | Eagan, MN 55121 | (651)687-2726 (Net 545) [cid:image001.gif@01C9393F.0B3C64C0] THIS COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE PROPRIETARY MATERIAL and is thus for use only by the intended recipient. If you received this in error, please contact the sender and delete the e-mail and its attachments from all computers. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Wong, Corey A Sent: Tuesday, October 28, 2008 8:47 PM To: arslist@ARSLIST.ORG Subject: DSO Help I'm trying to get a DSO Return action to work and it seems to only work if I physically modify a ticket. Let me explain. On Server A, Form A upon submit it will DSO transfer data with ownership to Server B, Form B. We have that working now. On Server B, Form B we have filter workflow upon Merge that creates a ticket in Form C and then updates Form B with information. What I would like is when Form B is updated with Form C's information, to DSO Return that information back to Server A, Form A. I have a Filter (Modify Merge) for the DSO Return to send back data and ownership. Right now the DSO return only works if I physically make a modification to Form B on Server B, which will kick off the Filter and DSO Return. But it doesn't seem to work automatically which I thought would happen since I have the Filter also running on Merge. In the Filter logs I do see this note... Note: Distributed Server cannot transfer or return unless overridden I do have the Override option checked for Duplicate IDs. Anybody have any experience with DSO Returns that could help me out? Thanks, Corey __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are inline: image001.gif
DSO Question
Hi List, We have two ITSM 7 servers, each one used by different groups of users. However, we would like that when server A is unavailable, its users will be able to connect to server B. This way server B would hold server A data as well as its own data. Server A will just have server A data. In order to do that, we thought about using DSO. Has anyone configured DSO to synchronize ITSM 7.x servers? I know that a lot of mapping would need to be done in order to have the servers synched (Incident/Problem/Change/SLM/Foundation data). Is there any detailed documentation or mappings from BMC that can be used? I've found a white paper from BMC that describes how to configure ID prefixes to use DSO. However it is not detailed and a whole analysis will be required to know all the forms/fields that need to be mapped/synched. Is it feasible to synch Foundation data? (Remembering that IDs will be different in both servers, since server B is also used by another group of users). For instance, when an incident goes from server A to backup server B, if a field holds the support group ID, in server B the synched support group ID might be different. Or issued like this should not happen? Would DSO be the best approach to achieve this objective? Has anyone implemented another solution to achieve this kind of objective? Thanks, Rudolf ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
