webservice to consume sharepoint
Hi I'm looking to see if anyone has been successful creating a filter to consume an external webservice(sharepoint) that requires authentication. What we are doing - sending a few fields from a custom form into a Sharepoint calendar. I can run SOAP UI operation to the WSDL and can create an entry on the sharepoint website using the updatelistItem Operation. I had to use the Auth tab to put the user name and password to get it to work. So at this point I know the webservices work. My questions are with the Authentication. Remedy doesn't seem to send the right info out. I've created a staging form that holds the user name and password fields and other fields as well. Then I just map the usernametoken fields in the input mappings. After putting in the user name Sharepointdomain\myusername in a field on a staging form and the password which has all sorts of characters. P*ss-Wor! I get the following error when modifying entry on custom staging form. ARERR[9130] Error encountered while executing a Web Service: (401) Unauthorized The error seems to be a http error. Maybe formating the authentication differently. Do I have to put some additional code in the username and password fields to incude the domain? Where can I check the XML file being sent to sharepoint to see what is missing or incorrect? DO I need something like ![CDATA[shrpointdomain\username]] and ![CDATA[password]]? That doesn't work either. Does sharepoint look for html -Encoded fields? I guess once I get by the authentication error, I can start adding the fields. Thanks in advance JK ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Task Group Template automation with tasks
Hi Group Does any know if there is a way to add a Task Group Template with child tasks to a BULK load of Incidents. Yes DMT is a way but my challenge is the Tasks. Using DMT If I have 100 INC's being created and 1 Task group per incident, these will be fairly easy to fill in the spreadsheets at this point. Its when I fill in the tasks spread sheet, which is the blocker. There is no simple way to copy and paste the rows down in the sheet, because in my situation, there are 5 tasks per task group template. It would be easy if there was only one task. Because there are 5 child tasks per Task group, my challenge is the manual work to paste the Task group and the INC ID every 5 rows. See my point. So question goes out is there some other function or form I could use to automate adding task group templates to the incident. I know using DMT it will not allow you to promote those Task groups without tasks to associate with. That leads me to some other way, I was thinking Incident interface Create form. But I don't think that will allow for task group template creation there. Any others ideas. Thanks JK ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
All Approvers Drop Down
Hi List Its been a while. I've got a good one. Our DEV environment has an issue in CHG management when you click the approvers tab and see the pending approvals you see the approval no problem there, but if you want to look at all Approvers and select that option from the drop down, it shows nothing. We figured it was a data or workflow issue. So we refreshed our DEV env with a full of copy of production. Well when we went to test it, it still didn't work. So this leads me to a dll or in our case SO corruption, Or I'm thinking a configuration file somewhere. The ar.conf file seems to match our TEST env which works fine except there is a secondary plugin server over there (hence two conf files..) all entries seem to match. We moved the following Plugin: /app/remedy/approval/bin/arapprove.so Server-Plugin-Alias: ARSYS.ARDBC.PREVIEW ARSYS.ARDBC.PREVIEW dnsc:8020 references from the secondary plugin mechanism to the main ar.conf. My question is does anyone know what other configuration files I can look at or know what other binary file the approver query is using when you click the drop down (All approvers) for that table in CHG? Any help that would great. ITSM 7.5 patch6 ARS 7.6.1 JK ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
NOMail
___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Using != and LIKE in Approval Mappings
Doug is spot on.
A change in process or philosophy may be a better way here.
Maybe one question is why does the company ABC not need approvals?
At least if autoapprovals is on then auditing is one benefit. Unless they don't
need it.
Or Is it because of notifications that are causing more spam than anything?
If thats the case you can use the Ap:notifications additional qualification to
add a statement. NOT ('Company' = Acme) for the particular type of rule.
One side bar note ARS 7.5.: when editing the record for the additional
qualification in ap:notification, it may not modify the filter. There is an
Article on this, but ours is on a Server Group environment so the bug fix did
not work. We did however manually edited the filter. This could be another
Bug BMC needs to look at.
JK
- Original Message -
From: Ron Tavares ron.tava...@gmail.com
To: arslist@ARSLIST.ORG
Sent: Tuesday, July 19, 2011 2:50:03 PM
Subject: Re: Using != and LIKE in Approval Mappings
**
I did some research on this. Looks like this is configured in the
AP:Administration form. See the doc BMC Remedy Approval Server 7.1 Guide for
Users and Administrators
On Tue, Jul 19, 2011 at 2:10 PM, pritch pri...@ptd.net wrote:
I also would be interested in where these items are documented within the
wealth of BMC Remedy documentation.
- Original Message -
From: Ron Tavares ron.tava...@gmail.com
To: arslist@ARSLIST.ORG
Sent: Tuesday, July 19, 2011 1:57:53 PM
Subject: Re: Using != and LIKE in Approval Mappings
**
Hi Doug,
thank you for your response. You are correct in your assumptions of what I am
trying to do and I very much like the approach you are recommending. I believe
this will work for us.
So, I have two questions:
1) Are these approval rules, (Auto Approval, Self Approval, etc), available in
CM v7.1?
2) If so, where do I configure this? I'm assuming it is not in Change Mgm t
Approvals Approval Mappings
Thanks,
.ron
On Tue, Jul 19, 2011 at 12:15 PM, Mueller, Doug doug_muel...@bmc.com wrote:
**
Ron,
I thought I would respond to this message with not really an answer to the
specific question you are asking
but more of a discussion of a general best practice model for using the
approval system.
Reading into your question, I am assuming you have a requirement where you want
to run an approval
process but when there is some specific criteria met, you don't want that
process to run.
I am going to suggest that you should approach the problem differently. This
different approach has many
advantages:
-- It is more consistent
-- It is more auditable and trackable (makes things like Sarbox compliance
reviews much easier)
-- It makes the overall flow of execution and processing much easier and
less error prone (one path of
execution not several)
This approach is a generic philosophy.
If there is a need for approvals, you ALWAYS call the approval process for
EVERYONE. This is regardless of
whether there are special conditions or limits or it is sometimes needed or
anything. You ALWAYS call
the approval process.
Then, you use the rules of the approval process to control action and
operation.
So, let's look at your situation. You have a case where you want to have
approvals but to skip approvals
when the company is not Acme or when some group is specified. I am going to
suggest that you look at it
slightly differently.
You want approvals. When the company is not Acme or when some specific
group is specified, you want
the approval process to complete immediately with success without having a
person involved. If these
conditions are not met, you want to get explicit approvals.
The end result is the same, but it is much more managable and trackable to
think in the new terms (and it
is easy to do which is a nice bonus).
Within the approval process, there are a variety of rules you can configure.
One type of rule is an
Auto Approval rule. You can have any number of these rules for any process.
This type of rule is the first
type of rule run whenever an approval process starts and if the rule passes,
the approval process is
immediately approved, no individual approvals are needed, and the done or
completion rules are run to
update the process to move forward. If none of these rules are successfully
passed, then the approval
process continues on with other rules to assign things and go through the
process until that is approved
(or rejected) and then the completion rules are run.
So, in your case, you would just have the approval process called and you would
define one or more
Auto Approval rules that test the conditions you want to have the process
automatically approve with no
further action and you will be good to go.
Note that there are several other rules that can support you along
Re: ARERR [623] on Mid-tier only in User Form
This may help. I got that error once. I had to remove and readd the Server name and password from the midtier config tool. Don't forget to Restart the services. I also cleared the cache while I was in there. JK * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free.
OOB changes
Hi List Does anyone have a tool or know of a tool that does an audit of your Remedy Server that gives you all of the Out of the Box workflow that has been changed. ARS 7.1 patch 9 ITSM 7.0 patch 6 Oracle 10g JK * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free.
Re: Auto sending out word document from Remedy.
Try creating an email template with a template attachment. Bao, Hui-Qing h...@idirect.net Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 03/11/2010 10:23 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Auto sending out word document from Remedy. ** All, I am working on a requirement that whenever a user closes a Remedy ticket, system should automatically email customer a word document (content of the word document is coming from the Remedy ticket) I have some idea of auto generating word document: · create a word template · Use DDE to open, pass value, and close the file But I am not sure what is the best way to send out this file through email, have you ever worked on similar task before? If so, how did you do it? Thank you!! Huiqing _ This electronic message and any files transmitted with it contains information from iDirect, which may be privileged, proprietary and/or confidential. It is intended solely for the use of the individual or entity to whom they are addressed. If you are not the original recipient or the person responsible for delivering the email to the intended recipient, be advised that you have received this email in error, and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you received this email in error, please delete it and immediately notify the sender. _ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Change Manager - Change Implementor
List Just a conversation to understand Segregation of duties Can a Change Manager be a Change Implementor without breaking the rules? I guess the Manager could approve the request and implement that change. Is it morally right? The Change assignee is someone different so there is an other person involved. JK * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free.
Client fires different from Midtier.
Hi List I have a weird situation where on Open window a Date field is set correct through the client (4/1/2010) but not correct through the midtier (1/1/) Can someone tell me if my approach here is correct or sufggest ssomething different? What we are doing: On window open a field needs to be set 15 days later than today. dateplus15days = $DATE$+(((60*60)*24)*15) I cleared the Midtier cache. Still the same result. ARS 7.1 Patch6 JK * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free.
RESOLVED - Re: Client fires different from Midtier.
Thanks LJ I dug up a previous inquiry I found it was my own. duh! Finally just getting to fix it since DEC. JK LJ Longwing lj.longw...@gmail.com Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 03/17/2010 02:18 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Client fires different from Midtier. ** Documented numerous times that setting Date (not date/time) fields through $DATE$ isproblematic at best when doing mathematics on it :). Do it in two setfieldsfirst setting to $DATE$, then in the second setfield just do +15. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of John Kelley Sent: Wednesday, March 17, 2010 12:02 PM To: arslist@ARSLIST.ORG Subject: Client fires different from Midtier. Hi List I have a weird situation where on Open window a Date field is set correct through the client (4/1/2010) but not correct through the midtier (1/1/) Can someone tell me if my approach here is correct or sufggest ssomething different? What we are doing: On window open a field needs to be set 15 days later than today. dateplus15days = $DATE$+(((60*60)*24)*15) I cleared the Midtier cache. Still the same result. ARS 7.1 Patch6 JK * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free.
Re: Refreshing the DB for ITSM 7.1.0
We refresh our DEV and TEST environment frequently. We want our Test environment most like production to reduce issues, come time moving DEV customizations over it makes it more thorough. If they fail in TEST they will fail in production, or at least you can get your steps noted and mastered for the import to production. Here are the steps I take. Steps prior to a DB refresh 1: Export the Licenses to a file. 2: Note Email mailbox configurations and settings. (server user and password, etc) Steps after a DB refresh 1: Copy Production REMEDY DB to Server B on correct port (our Oracle DBA does this step) 2: Restart AR Service 3: Reimport the correct ARSYSTEM.LIC file from Backup License file done in Steps prior to a DB refresh. 4: Change the Server Name information on forms CAI Application Registry, CMS Configuration Management 5: Change AR system Email Mailbox Configuration ? Change the incoming configuration server user to correct Test or DEV mail user and password. Double check the Outgoing mailbox address to make sure it reflects the TEST email instead of PROD. 6: SYS:Attachments form ? Change the Survey Link to show correct server names. 7: AP:Notifications - Check any custom notifications with Server links.. 8: EIE:Applications Settings form 9: Restart all Services that are automatic. Don't forget Midtier 10: Log into the Midtier Configuration console and Flush Cache. Hopefully this helps. JK Pat Zandi remedy...@gmail.com Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 03/06/2010 07:36 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Refreshing the DB for ITSM 7.1.0 ** Good thing ur not using srm the only way we have found to move stuff is db level. Migrator and def files do not work. Pain pain pain Sent from my iPhone On Mar 6, 2010, at 1:49 AM, Joe D'Souza jdso...@shyle.net wrote: ** I meant it always helps (and not never helps) in my last significant paragraph in my previous mail.. Friday night.. that's my excuse.. Joe -Original Message- From: Joe D'Souza [mailto:jdso...@shyle.net] Sent: Saturday, March 06, 2010 1:43 AM To: ARS Discussion List Subject: RE: Refreshing the DB for ITSM 7.1.0 Shyam, There is no real formal list to such forms if you ask me. It really depends on what you got installed. I wish every application really did have that kind of a list *you would think that this should have been a part of admin documentation* but welcome to the real world. The real world is that there are some obvious areas you should be looking at, in terms of form data such as AIE configuration SRM configuration, etc. The rest is like fire fighting. Fire fighters do not get a documented list of steps you should be performing to complete their rescue operation. Its just enough to expect problems for a while - you can only hope that the precautions you have taken based on your knowledge and that of what others had to share so far have minimized the occurrences of those problems.. A similar thread this month listed some data forms.. That should be a good beginning point to reduce these problems by about 75 to 80%. Maybe 100.. But it never helps to screen definitions by taking def files and looking for hard coded server references even while you nail things down on application /configuration data. In my experience XML exports are ideal for this, as you can replace server references found with @ directly without really having to account for the string length. In fact I rely solely on XML exports ever since I realized with one of the team I have worked with in the past, that it is a really safe and ideal way of doing so.. Hope this helps Cheers Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Shyam Attavar Sent: Friday, March 05, 2010 9:40 PM To: arslist@ARSLIST.ORG Subject: Re: Refreshing the DB for ITSM 7.1.0 ** Chris, I would still be interested to know the LONG list of places to update that you refer to in your response. Would it be possible to share that information? Thanks, -- Shyam From: strauss stra...@unt.edu To: arslist@ARSLIST.ORG Sent: Fri, March 5, 2010 12:17:11 PM Subject: Re: Refreshing the DB for ITSM 7.1.0 ** Customizations to the app are best moved with Migrator. You can build a fresh test server, migrate the customizations to it from development or production, then apply a patch or run an upgrade to see how it affects those customizations. Then later you can apply the same patch (or upgrade, but good luck with that) to development or production and then migrate the customizations back over from test. Typically I refresh development from production by restoring the db from a backup of production. Then there is a LONG list of places you have to update the clone on development to remove server and mid-tier references to the production
Merge Computer System Owner to Asset
I need a little help merging the 'Owner name' as (ffrontline) from BMC.CORE:BMC_ComputerSystem to the Asset Computer System. I can't seem to find out how to merge the asset to the user (ffrontline) in the People form. Is there a reconciliation job that needs to be created for this? The people tab with a table of owners in the asset (Computer Systems). thats the relationship I'm trying to setup. Any suggestions ARS 7.1 Atrium CMDB2.1 * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free.
Delete entry
Hi All Brain cramp today Can someone confirm that this statement is true! I am performing a delete action in an escalation for deleting all items in a form 24 hours and beyond. Let me rephrase I want to leave items in the form for 24 hours from the submit date. 'Submit Date' ( $TIMESTAMP$ - 86400) Sys:Action ARS 7.1 Thanks JK * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free.
Re: Delete entry
If there were thousands of items in the form created every day then I would take another route. But I decided to set the escalation to run off hours so it shouldn't cause performance problems. Thanks for the thread's talk I forgot about that aspect. JK Hermann, John N Mr CTR USA TRADOC john.herma...@us.army.mil Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 01/21/2010 12:53 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Delete entry (UNCLASSIFIED) Classification: UNCLASSIFIED Caveats: NONE PS: Something tells me this is gonna be a long thread :-) Speaking as someone who has only just begun to venture into the rabbit hole that is ARS/Remedy... Good :-) This kind of discussion is invaluable and a wonderful insight into the inner workings of ARS. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe D'Souza Sent: Thursday, January 21, 2010 12:48 PM To: arslist@ARSLIST.ORG Subject: Re: Delete entry Lyle, They (filter actions triggered by escalations) do not hold the Escalation thread to ransom.. That's the simplest way to put it Even if there is a process time out, the escalation does what it has to do by setting fields and exits making the Escalation thread available for the next set of escalations to fire.. The filter would time out if there is a time out during the actual delete.. This doesn't cause the escalation to fail.. Even if there is an error during the delete, this error is handled by the Filter thread, and not by the Escalation. That's the whole purpose of using what's known as a 'data driven' Escalation. You let data drive what needs to be done.. Sometimes as in this case its not the best idea to let the Escalation directly do a 2nd or 3rd stage action but let data drive that action and have a modify filter triggered when $USER$ = AR_ESCALATOR perform that action. Joe PS: Something tells me this is gonna be a long thread :-) -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Lyle Taylor Sent: Thursday, January 21, 2010 12:30 PM To: arslist@ARSLIST.ORG Subject: Re: Delete entry Joe, Even though the different operations occur in different phases, won't the escalation thread still be held up until all phases have completed? So, even though the set fields can happen in phase 1, the thread won't be released until the filters fire and deletes the marked records. Lyle -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe D'Souza Sent: Thursday, January 21, 2010 10:25 AM To: arslist@ARSLIST.ORG Subject: Re: Delete entry Fred, You are right in that calculation-wise it will not really have any benefit. But doing a delete in an escalation is not the best way - Delete is a 2nd phase operation and is queued. You do not want to hold the escalation thread longer than it should for this queue to complete. So having a filter aid the escalation to actually do the delete and the escalation only to mark the record to be deleted is a better approach as set fields is a fast operation that happens on the first phase of the transaction.. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Grooms, Frederick W Sent: Thursday, January 21, 2010 12:16 PM To: arslist@ARSLIST.ORG Subject: Re: Delete entry Since it is on the right side of the equation and not using any fields from the form the Escalation should only do the calculation once. As for setting a field and having a Filter do the delete, that is my preferred method as well Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe D'Souza Sent: Thursday, January 21, 2010 10:51 AM To: arslist@ARSLIST.ORG Subject: Re: Delete entry ** John, Should work but I'd make the process a little more data driven.. Instead of having the escalation calculate all this and chocking an escalation thread, I'd set that delete time to a temp field at the time of submitting the record. For e.g.. create a temp field called ztmpDeleteTime. Set the time $TIMESTAMP$ + 86400 to it using a filter.. Then have the Escalation check 'ztmpDeleteTime' $TIMESTAMP$ and mark the record for deletion using another temp field that you have that escalation set say 'ztmpDelete' to Y.. Do not have the escalation delete it again for the purpose of not choking the escalation thread. Have a filter that performs that delete when the record is marked for deletion and the $USER$ is the escalation user. It would be more efficient especially over a large number of records.. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of John Kelley Sent: Thursday, January 21, 2010 11
Re: EIE Exchange field mapping
I set the field mapping to the constants for each of the 3 tiers to set hardware/personal computer/laptop That now populates the records with those tiers and somehow populates the field Model with BMC_UNKNOWN. So its not finding my configured Model within the Product Names. I'm mapping the VersionNumber from SMS as '', Value: '2008SBY' which is the actually the model # not the model name. I have the model name configured as the product name in the products form. It seems it cannot reverse look to find the Product name is actually a T60. This is how its coming over as Model BMC_UNKNOWN Manufacturer Lenovo Version 2008SBY SMS does not give us the model name as T60, it only gives us a model#, so I can't map that correctly that would be to easy. I was hoping remedy could do a reverse lookup for me without getting to deep into creating extra filters to do the work. Thanks for all the info so far. JK P Romain ARSlist p.romain.arsl...@parsolutions.co.uk Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 01/07/2010 03:34 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: EIE Exchange field mapping ** To get the benefit of the trusted dataset you?d need to map the tier 1-3 values to constants in your data exchange. This is what, for example, BMC Configuration Discovery does (all computer systems are Hardware, Processing Unit, Server). You may be able to add all possible computer systems, with appropriate tiering, to the product catalog. The product name/manufacturer combination should then fetch the correct tiering for each computer created. When a new type of computer is discovered the trusted dataset will allow a new product catalog entry to be created automatically and the computer will be saved without error. You could then monitor the product catalog for new entries with the default tiering and deal with these by changing the tier values and updating the computer CIs. Discovery returns only what it finds so you may need to take care of multiple different ways of referring to the same manufacturer (eg MS, Microsoft, Microsoft Inc, etc) and multiple ways of referring to the same computer model. The CMDB normalisation engine uses product and manufacturer aliases to deal with this. The addition of a few filters in CMDB 2.1 would allow you to do the same using the existing manufacture and product alias forms. Cheers Peter From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of John Kelley Sent: 07 January 2010 19:58 To: arslist@ARSLIST.ORG Subject: Re: EIE Exchange field mapping CMDB2.1 I added that Trusted Dataset and now when I exchange, it comes over to the BMC.CORE:BMC_ComputerSystem form with NULL values. Now I will try Peters Suggestion. I'll let you know. JK Thomas Worth two...@itprophets.com Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 01/07/2010 01:01 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: EIE Exchange field mapping Also, if it's CMDB 2.1 or earlier, you can make the dataset you're importing to a Trusted Dataset. This will automatically build the Product Catalog entries if it doesn't find an existing catalog record. To do this, just create a record in the Trusted Dataset form, adding your dataset. Thomas Worth IT Prophets, LLC -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Peter Romain Sent: Thursday, January 07, 2010 12:57 PM To: arslist@ARSLIST.ORG Subject: Re: EIE Exchange field mapping It would help to know the versions you have installed. Turn on filter logging and try and create an entry manually in the BMC.CORE:BMC_ComputerSystem form using some sample data you are getting from SMS. The logs will reveal where the problem is. I suspect that the model/manufacturer is being looked up in the PCT:ProductCatalog form and, because no value(s) exist for the computers coming from SMS, the tiering is being left null. This assumes you are on CMDB 2.1 or earlier. CMDB 7.5 uses the normalisation engine which you can configure to continue even if the categorisation isn't found. You must also be mapping the dataset value otherwise the import will fail. Cheers Peter Hi list Need a little help I am trying to run a single data exchange for computer system from SMS to CMDB and I have errors during the exchange. The Product Categorization Tiers, Product Name and Manufacturer combination is not valid. The fields I have mapped are the Domain, System Type, Manufacturer, Model, Name, NumberofProcessors, Owner Name and AssetLifeCyclestatus. I'm wandering if it does a reverse lookup on the model and then tries to populate their own tiers. Does anyone know how I can fix this data mapping? What I want is to bring in the Model
EIE Exchange field mapping
Hi list Need a little help I am trying to run a single data exchange for computer system from SMS to CMDB and I have errors during the exchange. The Product Categorization Tiers, Product Name and Manufacturer combination is not valid. The fields I have mapped are the Domain, System Type, Manufacturer, Model, Name, NumberofProcessors, Owner Name and AssetLifeCyclestatus. I'm wandering if it does a reverse lookup on the model and then tries to populate their own tiers. Does anyone know how I can fix this data mapping? What I want is to bring in the Model of the system and do a reverse lookup and have it populate the correct tiers for that model (to BMC.Core:BMC_ComputerSystem) once I get it there I can then bring it into the Asset. Has anyone done this? What is the best way to populate the tiers? JK * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free.
Re: EIE Exchange field mapping
CMDB2.1 I added that Trusted Dataset and now when I exchange, it comes over to the BMC.CORE:BMC_ComputerSystem form with NULL values. Now I will try Peters Suggestion. I'll let you know. JK Thomas Worth two...@itprophets.com Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 01/07/2010 01:01 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: EIE Exchange field mapping Also, if it's CMDB 2.1 or earlier, you can make the dataset you're importing to a Trusted Dataset. This will automatically build the Product Catalog entries if it doesn't find an existing catalog record. To do this, just create a record in the Trusted Dataset form, adding your dataset. Thomas Worth IT Prophets, LLC -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Peter Romain Sent: Thursday, January 07, 2010 12:57 PM To: arslist@ARSLIST.ORG Subject: Re: EIE Exchange field mapping It would help to know the versions you have installed. Turn on filter logging and try and create an entry manually in the BMC.CORE:BMC_ComputerSystem form using some sample data you are getting from SMS. The logs will reveal where the problem is. I suspect that the model/manufacturer is being looked up in the PCT:ProductCatalog form and, because no value(s) exist for the computers coming from SMS, the tiering is being left null. This assumes you are on CMDB 2.1 or earlier. CMDB 7.5 uses the normalisation engine which you can configure to continue even if the categorisation isn't found. You must also be mapping the dataset value otherwise the import will fail. Cheers Peter Hi list Need a little help I am trying to run a single data exchange for computer system from SMS to CMDB and I have errors during the exchange. The Product Categorization Tiers, Product Name and Manufacturer combination is not valid. The fields I have mapped are the Domain, System Type, Manufacturer, Model, Name, NumberofProcessors, Owner Name and AssetLifeCyclestatus. I'm wandering if it does a reverse lookup on the model and then tries to populate their own tiers. Does anyone know how I can fix this data mapping? What I want is to bring in the Model of the system and do a reverse lookup and have it populate the correct tiers for that model (to BMC.Core:BMC_ComputerSystem) once I get it there I can then bring it into the Asset. Has anyone done this? What is the best way to populate the tiers? JK * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free. ___ 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 * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free.
Removing a particular word in string
Hi List Does anyone know the Function for removing a particular word from a string? Can I use ltrim or substr to achieve my goal? Set: DomainA/jkelley computerx/administrator DomainA/jdoe computerx/administrator I need to remove anything that says DomainA to appear as: jkelley computerx/administrator jdoe computerx/administrator Thanks JK * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free.
Re: Removing a particular word in string
This is the function I ended up with, that worked. function|replace($UserName$,DomainA/, ) Thanks Kaiser, Norm E CIV USAF AFMC 96 CS/SCOKT norm.kai...@eglin.af.mil Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 12/22/2009 11:28 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Removing a particular word in string Just use the REPLACE function. It's exactly what you're looking for. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of John Kelley Sent: Tuesday, December 22, 2009 10:26 AM To: arslist@ARSLIST.ORG Subject: Removing a particular word in string Hi List Does anyone know the Function for removing a particular word from a string? Can I use ltrim or substr to achieve my goal? Set: DomainA/jkelley computerx/administrator DomainA/jdoe computerx/administrator I need to remove anything that says DomainA to appear as: jkelley computerx/administrator jdoe computerx/administrator Thanks JK * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free. * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free.
Date field viewed in Dialog form on midtier
Hi list Have a slight bug calculating a date field on a midtier page through a dialog form. Has anyone had this before and know if its a bug? I have a link that opens a form in a dialog view with a Date field that is supposed to set the date 15 days later than the DATE. My Qualification : $DATE$ + (((60 * 60) * 24) * 15) for the field on Open Window. The issue is, the midtier shows the date 1/1/. The weird thing is the date is calculated properly when opening the form throught the client. I flushed the cache many times and deleted local temps. Just wandering if there is a Midtier bug calculating Dates on an Open Window action in a dialog view ? Midtier 7.1 patch 6 ARS 7.1 Oracle 10g JK * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free.
Re: Date field viewed in Dialog form on midtier
Thanks LJ I guess it was created wrong in the first place. Its funny it worked for a while then stopped recently. I'll have to create another AL to do the set field on Window open. JK LJ Longwing lj.longw...@gmail.com Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 12/07/2009 01:51 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Date field viewed in Dialog form on midtier ** John, you need to be very careful when dealing with date vs date/time. Date stores the # of daysdate/time stores the # of seconds. What you are trying to do is add date/time (seconds in 15 days) to a purported date fieldyou may want to just try adding 15but be warned, there have been problems using calculation on date fields with $DATE$...so you might be better off setting your date field to $DATE$, then in a second setfield action (same AL works) do a $DateField$+15 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of John Kelley Sent: Monday, December 07, 2009 11:44 AM To: arslist@ARSLIST.ORG Subject: Date field viewed in Dialog form on midtier Hi list Have a slight bug calculating a date field on a midtier page through a dialog form. Has anyone had this before and know if its a bug? I have a link that opens a form in a dialog view with a Date field that is supposed to set the date 15 days later than the DATE. My Qualification : $DATE$ + (((60 * 60) * 24) * 15) for the field on Open Window. The issue is, the midtier shows the date 1/1/. The weird thing is the date is calculated properly when opening the form throught the client. I flushed the cache many times and deleted local temps. Just wandering if there is a Midtier bug calculating Dates on an Open Window action in a dialog view ? Midtier 7.1 patch 6 ARS 7.1 Oracle 10g JK * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free.
Re: CI TYPE FOR HUBS, SWITCHES ROUTERS
Hi We use also used the class Computer System with: Tier 1- Hardware Tier 2- Network Tier 3- Router Then the Product name is the type of router (Cisco) - Made sense for us. We separated Switches and Hubs in the tier 3 level as well. JK Luttmann, Michael W CTR USA michael.luttm...@us.army.mil Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 12/07/2009 02:17 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: CI TYPE FOR HUBS, SWITCHES ROUTERS We preferred to keep our switches/routers separate from all our other computer systems, so I made a custom class (with Computer System as the super class), called Network Device. It was a good exercise is custom class creation! Michael W. Luttmann Lead Remedy Developer Fort Carson NEC If you dislike change, you're going to dislike irrelevance even more. -- GEN Shinseki -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Chowdhury, Tauf Sent: Monday, December 07, 2009 7:03 AM To: arslist@ARSLIST.ORG Subject: Re: CI TYPE FOR HUBS, SWITCHES ROUTERS ** There's plenty of discussion on this, but I think it's safe to say the norm is to use Computer System and use CTI or the Primary Capability field to get specific on the type of hardware. Tauf Chowdhury | Forest Laboratories, Inc. Analyst, Service Management Mobile:646.483.2779 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Patel, Fazila Sent: Monday, December 07, 2009 8:50 AM To: arslist@ARSLIST.ORG Subject: CI TYPE FOR HUBS, SWITCHES ROUTERS ** Hi Can someone assist me? I would like to know what CI Type would hubs, switches and routers fall under on Asset Management. Kind regards Fazila Patel Siemens IT Solutions and Services (Pty) Ltd Remedy Administrator Local Production Centre Infrastructure Operations Siemens Southern Africa Tel: +27 11 652 7488 Fax : +27 11 652 7501 Cell : +27 82 922 2322 E-mail: fazila.pa...@siemens.com www.siemens.co.za blockedhttp://www.siemens.co.za/ Disclaimer and Confidentiality Note This e-mail communication, its attachments, if any, and any rights attaching to it are, unless the context clearly indicates otherwise, the property of Siemens Limited. It is confidential, private and intended for the addressee only. If you are not the intended recipient and receive this communication in error, you are hereby notified that any review, copying, use, discloser or distribution in any manner whatsoever is strictly prohibited. Please notify the sender immediately that you have received this e-mail in error and delete the e-mail and any copies of it. Views and opinions expressed in this e-mail are those of the sender unless clearly stated as those of Siemens Limited. Siemens Limited accepts no liability for any loss or damage whatsoever, and howsoever incurred or suffered resulting or arising from the use of this e-mail communication and/or its attachments. Siemens Limited does not warrant the integrity of this e-mail communication nor that it is free of errors, viruses, interception or interference. For more information about Siemens Limited, visit our website at www.siemens.com Siemens Limited Company Registration Number: 1923/007514/06 Registered Address: 300 Janadel Avenue, Halfway House 1685 VAT Registration Number: 4790104428 Chairman: Dr S Russwurm*; Deputy Chairman: Dr ATM Mokgokong Chief Executive Officer: SJ Clarkson; Chief Financial Officer: AD Hall Executive Directors: HA Hollier, AM Mathole Non-Executive Director: D Hoke*; Dr MI Surve; K Setzin Alternate Director: R Guntermann*; I Amod; Y Mahomed Company Secretary: V Reddy *German _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ This e-mail and its attachments may contain Forest Laboratories, Inc. proprietary information that is privileged, confidential or subject to copyright belonging to Forest Laboratories, Inc. This e-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this e-mail, or the employee or agent responsible for delivering this e-mail to the intended recipient, you are hereby notified that any dissemination, distribution, copying or action taken in relation to the contents of and attachments to this e-mail is strictly prohibited and may be unlawful. If you have received this e-mail in error, please notify the sender immediately and permanently delete the original and any copy of this e-mail and any printout. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives
Menu item for VP's
Hi List Need a Field or a Menu Item to show the VP of the Customer. Facts: 1: Customer and VP should have the same department in the CTM:People form. 2: VP may or may not be the manager of the requester either. When you select the user on the HPD:Helpdesk form and populate the customer information, it should find the requesters Department (Information Technology) and lookup all the other Informations Technology Departments and find the VP. Seems easy, but I can only get my menu to display all the VPs Any suggestions? do I need to use an EXTERNAL Operator. ARS 7.1 patch 6 Oracle 10g JK * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free.
Re: AR System Email Messages Form
I do have over 95,000 items in the email error logs form. Are you saying to delete those out and retry opening the email messages form. JK Chowdhury, Tauf tauf.chowdh...@frx.com Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 10/22/2009 06:18 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: AR System Email Messages Form ** What I?ve seen as the usual suspect is the Email Error Logs form . Depending on what level of logging you have turned on for E-mail messages, that 1 e-mail entry may have 20 entries associated within the error log form. (I may be exaggerating) Tauf Chowdhury Analyst, Service Management Office: 631.858.7765 Mobile:646.483.2779 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Frank Caruso Sent: Thursday, October 22, 2009 1:15 AM To: arslist@ARSLIST.ORG Subject: Re: AR System Email Messages Form ** Its probably not the search of that form but the refresh of several table fields that are on that form. On Wed, Oct 21, 2009 at 11:10 PM, John Kelley john.kel...@dunkinbrands.com wrote: Hi List Has anyone had issues loading the AR System Email Messages in search mode? It takes way to long to load. I deleted all but one entry in the messages form and if I refresh my search results, it takes over a minute to load the one entry. It is so slow. Any Suggestions? ARS 7.1 patch 6 Oracle 10G * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ This e-mail and its attachments may contain Forest Laboratories, Inc. proprietary information that is privileged, confidential or subject to copyright belonging to Forest Laboratories, Inc. This e-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this e-mail, or the employee or agent responsible for delivering this e-mail to the intended recipient, you are hereby notified that any dissemination, distribution, copying or action taken in relation to the contents of and attachments to this e-mail is strictly prohibited and may be unlawful. If you have received this e-mail in error, please notify the sender immediately and permanently delete the original and any copy of this e-mail and any printout. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: AR System Email Messages Form
I just deleted the error logs. I reopen my Messages form and it still takes over a minute to open the form in search mode to display only one item. Any other suggestions? Could it be thread settings for email? Here is what I have set. Private-RPC-Socket: 390601 1 1 Private-RPC-Socket: 390603 1 1 Private-RPC-Socket: 390620 4 10 Private-RPC-Socket: 390626 2 4 Private-RPC-Socket: 390627 4 4 Private-RPC-Socket: 390635 4 10 Private-RPC-Socket: 390650 4 6 Chowdhury, Tauf tauf.chowdh...@frx.com Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 10/22/2009 10:07 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: AR System Email Messages Form Yes... but make sure you don't need the logs. Is this a production system? If you are not sure, you may want to export them first to .arx. -Original Message- From: Action Request System discussion list(ARSList) on behalf of John Kelley Sent: Thu 10/22/2009 8:20 AM To: arslist@ARSLIST.ORG Subject: Re: AR System Email Messages Form I do have over 95,000 items in the email error logs form. Are you saying to delete those out and retry opening the email messages form. JK Chowdhury, Tauf tauf.chowdh...@frx.com Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 10/22/2009 06:18 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: AR System Email Messages Form ** What I?ve seen as the usual suspect is the Email Error Logs form . Depending on what level of logging you have turned on for E-mail messages, that 1 e-mail entry may have 20 entries associated within the error log form. (I may be exaggerating) Tauf Chowdhury Analyst, Service Management Office: 631.858.7765 Mobile:646.483.2779 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Frank Caruso Sent: Thursday, October 22, 2009 1:15 AM To: arslist@ARSLIST.ORG Subject: Re: AR System Email Messages Form ** Its probably not the search of that form but the refresh of several table fields that are on that form. On Wed, Oct 21, 2009 at 11:10 PM, John Kelley john.kel...@dunkinbrands.com wrote: Hi List Has anyone had issues loading the AR System Email Messages in search mode? It takes way to long to load. I deleted all but one entry in the messages form and if I refresh my search results, it takes over a minute to load the one entry. It is so slow. Any Suggestions? ARS 7.1 patch 6 Oracle 10G * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ This e-mail and its attachments may contain Forest Laboratories, Inc. proprietary information that is privileged, confidential or subject to copyright belonging to Forest Laboratories, Inc. This e-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this e-mail, or the employee or agent responsible for delivering this e-mail to the intended recipient, you are hereby notified that any dissemination, distribution, copying or action taken in relation to the contents of and attachments to this e-mail is strictly prohibited and may be unlawful. If you have received this e-mail in error, please notify the sender immediately and permanently delete the original and any copy of this e-mail and any printout. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers
Re: AR System Email Messages Form
Hi Axton Where do make the truncate setting? I do notice in the form Properties of Email messages form the following fields are Indexed, is there supposed to be that many fields being indexed? Mailbox ID Message Type Priority Send Message Parse Message Execute/Send At Thanks Axton axton.gr...@gmail.com Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 10/22/2009 10:32 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: AR System Email Messages Form ** Truncate the db tables that store the email error logs. Axton Grams On Thu, Oct 22, 2009 at 9:22 AM, John Kelley john.kel...@dunkinbrands.com wrote: I just deleted the error logs. I reopen my Messages form and it still takes over a minute to open the form in search mode to display only one item. Any other suggestions? Could it be thread settings for email? Here is what I have set. Private-RPC-Socket: 390601 1 1 Private-RPC-Socket: 390603 1 1 Private-RPC-Socket: 390620 4 10 Private-RPC-Socket: 390626 2 4 Private-RPC-Socket: 390627 4 4 Private-RPC-Socket: 390635 4 10 Private-RPC-Socket: 390650 4 6 Chowdhury, Tauf tauf.chowdh...@frx.com Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 10/22/2009 10:07 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: AR System Email Messages Form Yes... but make sure you don't need the logs. Is this a production system? If you are not sure, you may want to export them first to .arx. -Original Message- From: Action Request System discussion list(ARSList) on behalf of John Kelley Sent: Thu 10/22/2009 8:20 AM To: arslist@ARSLIST.ORG Subject: Re: AR System Email Messages Form I do have over 95,000 items in the email error logs form. Are you saying to delete those out and retry opening the email messages form. JK Chowdhury, Tauf tauf.chowdh...@frx.com Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 10/22/2009 06:18 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: AR System Email Messages Form ** What I?ve seen as the usual suspect is the Email Error Logs form . Depending on what level of logging you have turned on for E-mail messages, that 1 e-mail entry may have 20 entries associated within the error log form. (I may be exaggerating) Tauf Chowdhury Analyst, Service Management Office: 631.858.7765 Mobile:646.483.2779 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Frank Caruso Sent: Thursday, October 22, 2009 1:15 AM To: arslist@ARSLIST.ORG Subject: Re: AR System Email Messages Form ** Its probably not the search of that form but the refresh of several table fields that are on that form. On Wed, Oct 21, 2009 at 11:10 PM, John Kelley john.kel...@dunkinbrands.com wrote: Hi List Has anyone had issues loading the AR System Email Messages in search mode? It takes way to long to load. I deleted all but one entry in the messages form and if I refresh my search results, it takes over a minute to load the one entry. It is so slow. Any Suggestions? ARS 7.1 patch 6 Oracle 10G * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ This e-mail and its attachments may contain Forest Laboratories, Inc. proprietary information that is privileged, confidential or subject to copyright belonging to Forest Laboratories, Inc. This e-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this e-mail, or the employee or agent responsible for delivering this e-mail to the intended recipient, you are hereby notified that any dissemination, distribution, copying or action taken in relation to the contents of and attachments to this e-mail is strictly prohibited and may be unlawful. If you have received this e-mail in error, please notify the sender immediately and permanently delete the original and any copy of this e-mail and any printout. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ * This e-mail message, including any attachments, is for the sole use of the addressee(s
RESOLVED -Re: AR System Email Messages Form
Thanks Lyle Setting an Index on the 'Email ID' field on the Email Error Logs form was the solution. I do the same thing every month deleting 20k-30k items from the messages form. I should probably setup an archive. I wonder if ARS 7.5 has the fix for when you delete the message it deletes its associated error log entry. Thanks again all, for the suggestions. JK Lyle Taylor tayl...@ldschurch.org Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 10/22/2009 01:17 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: AR System Email Messages Form ** We had the exact same issue. The problem isn?t the number of errors associated with any given message, it?s the number of total errors in the error log form combined with the fact that 1) BMC didn?t add any indexes to the form (that?s an issue in several places), and 2) the form does not get cleaned up as e-mails get deleted (that is, BMC didn?t include workflow to delete error logs as the corresponding e-mail get deleted). The issue is that there is a table on the email messages form that references the error logs form, and when you view a message, it refreshes the table. Since the error logs form doesn?t have an index on it, it does a table scan in the database every time. To fix it, do at least the following: Add an index on the field ?Email ID? on the AR System Email Error Logs forms. That will significantly speed up viewing e-mails regardless of how many records are in the error logs form. Next, you can add a filter to AR System Email Messages that runs on Delete and performs a Run Process action with the following text: Application-Query-Delete-Entry AR System Email Error Logs '18023' = $Email ID$ This will remove errors from the error log as e-mails get deleted from the email messages form. That will keep your error logs from continuously growing out of control (assuming that you don?t keep all e-mails in your email messages form). Lastly, I would clean out all the current entries in the error logs form, unless you need them for some reason. If you really want to be clever, you can only clean out entries that don?t still have a corresponding e-mail in the e-mail messages form, but you?d probably have to either write program or write some workflow to determine if a given error entry has a corresponding e-mail. You don?t need to worry about deleting large amounts of data in the user tool. I?ve routinely deleted 5-20K records at a time in the User tools without causing any issues for other users on the system. It does take a long time, though. Doing all three of those things will keep viewing e-mails fast and keep your error logs cleaned up with only relevant data (it?s no longer relevant if the corresponding e-mail is no longer there). Good luck, Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of John Kelley Sent: Thursday, October 22, 2009 6:21 AM To: arslist@ARSLIST.ORG Subject: Re: AR System Email Messages Form ** I do have over 95,000 items in the email error logs form. Are you saying to delete those out and retry opening the email messages form. JK Chowdhury, Tauf tauf.chowdh...@frx.com Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 10/22/2009 06:18 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: AR System Email Messages Form ** What I?ve seen as the usual suspect is the Email Error Logs form . Depending on what level of logging you have turned on for E-mail messages, that 1 e-mail entry may have 20 entries associated within the error log form. (I may be exaggerating) Tauf Chowdhury Analyst, Service Management Office: 631.858.7765 Mobile:646.483.2779 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Frank Caruso Sent: Thursday, October 22, 2009 1:15 AM To: arslist@ARSLIST.ORG Subject: Re: AR System Email Messages Form ** Its probably not the search of that form but the refresh of several table fields that are on that form. On Wed, Oct 21, 2009 at 11:10 PM, John Kelley john.kel...@dunkinbrands.com wrote: Hi List Has anyone had issues loading the AR System Email Messages in search mode? It takes way to long to load. I deleted all but one entry in the messages form and if I refresh my search results, it takes over a minute to load the one entry. It is so slow. Any Suggestions? ARS 7.1 patch 6 Oracle 10G * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message
AR System Email Messages Form
Hi List Has anyone had issues loading the AR System Email Messages in search mode? It takes way to long to load. I deleted all but one entry in the messages form and if I refresh my search results, it takes over a minute to load the one entry. It is so slow. Any Suggestions? ARS 7.1 patch 6 Oracle 10G * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free.
Advanced Search Question
Hi List Is there any way to find out what the Average character count of the notes field in Incident Management tickets which have been submitted? What and can that be run in an Advanced search statement? Thanks ARS 7.1 patch 6 Oracle 10g JK * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free.
Prefetch File question
Does anyone know if a form needs to be cached in Every Application or can I just add the form once to the prefetch file? John * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free.
Justify a column in a Table - its value
Hi List ARS 7.1 patch 6 I have a table with two Columns and the value of the Access column I want to Left Justify. Role___|Access_ Admin| Yes Does anyone know of a way to accomplish this? Role__|Access__ Admin |Yes Thanks ahead of time JK * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free.
Alternate Approval notification
Has any setup a notification to the alternate approver if the approval hasn't been attended to in 24 hours. How and where can I configure that. Thanks JK * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free.
Re: Alternate Approval notification
Thanks Bryan The alternate gets the email now after a certain amount of time. But is there a way to change the approval to show in the Alternates Approval Central queue. Or does the alternate still have to go in and Act as alternate. Is that how it is designed. Thanks Again JK Bryan Waters bryancwat...@gmail.com Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 08/13/2009 11:40 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Alternate Approval notification ** Hello John, Open the approval process definition screen, use the Signature Escalations tab to setup a ?friendly? reminder. Also, make sure to create the following 2 notifications for your approval process. Thanks, Bryan Waters From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of John Kelley Sent: Thursday, August 13, 2009 10:13 AM To: arslist@ARSLIST.ORG Subject: Alternate Approval notification Has any setup a notification to the alternate approver if the approval hasn't been attended to in 24 hours. How and where can I configure that. Thanks JK * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Close dialog window without saving
Hi List I have a selection field on (form A) that opens a dialog window (form B) which does a lookup. I have two fields mapped on close to populate on the parent Form A when the item is selected. My selection works great and populates my Parent form. My question is how can I close out of the dialog window without setting the selection field on Form A and keeping the original item before I selected it. I set up an Active link with a close window action but it still picks up the item I selected from From A after the dialog window is closed. Any ideas. JK * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free.
Re: Close dialog window without saving
I don't have a commit changes action before the close window of that AL. There is a commit changes in one of my other active links that runs on a selection of an item from that Form B. JK Joe DeSouza joe_rem...@yahoo.com Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 07/15/2009 12:21 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Close dialog window without saving ** You do not 'Commit Changes' before closing. A 'Commit Changes' action before closing a dialog, populates the values from the Dialog to the Parent.. Joe From: John Kelley john.kel...@dunkinbrands.com To: arslist@ARSLIST.ORG Sent: Wednesday, July 15, 2009 11:01:24 AM Subject: Close dialog window without saving Hi List I have a selection field on (form A) that opens a dialog window (form B) which does a lookup. I have two fields mapped on close to populate on the parent Form A when the item is selected. My selection works great and populates my Parent form. My question is how can I close out of the dialog window without setting the selection field on Form A and keeping the original item before I selected it. I set up an Active link with a close window action but it still picks up the item I selected from From A after the dialog window is closed. Any ideas. JK _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free.
Re: Selection Menu Question
Hi Yes, search based on selection of the INC status is what I was looking for. The results, I would want to become available in a drop down, kind of like the Operational tiers, when you select first tier the second becomes available. John Joe DeSouza joe_rem...@yahoo.com Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 07/08/2009 02:10 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Selection Menu Question ** While I think I more or less understand what you want to do, what exactly do you mean by 'filter out attributes of a selection field' ?? Are you looking to perform a search Based on the selection of the INC Status? So if 'In Progress' is selected do you want the system to return results that contain records that have the App Status of 'Approoved', 'Scheduled' and 'BreakFix'?? If so depending on where you want that search result to be returned to, (Results List or Table Field) I do not think it is really hard to build an external qualification that does it? Wouldn't you be looking at creating an external qualificaton that could be used in the table field or results list that would build the qualication against the App Status on selection of the INC Status? I think its as simple as that.. Or have I understood what you want to do wrong? Sorry more questions than answers - so if I have understood you wrong please try and explain what exactly you are aiming for.. Cheers Joe From: John Kelley john.kel...@dunkinbrands.com To: arslist@ARSLIST.ORG Sent: Tuesday, July 7, 2009 4:14:41 PM Subject: Selection Menu Question Hi List Is it possible to setup an Active link to filter out attributes of a selection field drop down? Heres the story. I currently have on my Helpdesk form the INC Status field that has the normal status' and an APP Status field which has other Process status' for example. Approve, Scheduled, Awaiting release, Breakfix, Go-live, No-Go etc. I also have another form with APP Status and INC Status. I save entries of APP status with a particular INC status. For Ex. APP StatusINC Status ApproveIn Progress ScheduledIn Progress BreakFixIn Progress Awaiting relPending Go LiveResolved Now I'm trying to get the APP status on the Helpdesk form to filter out what matches to the INC status that is selected. Basically I should be able to select INC Status of In Progress and It should show me three items. I think the selection field is the problem, I may need a character field instead and then map a menu to it. Or continue with my AL somehow Any ideas. Thanks John ARS 7.1 patch 6 Apps 7.003 patch6 _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free.
Re: Selection Menu Question
Thats Exactly what I was looking for. Thankyou Kelly Now my only other issue, the original APPStatus field on the Helpdesk form is a selection field instead of a character field. Is there any way to convert the selection field to a character field so I can map out a menu to it? JK Kelly Gatewood kgatew...@itprophets.com Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 07/08/2009 11:02 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Selection Menu Question John, You could do something similar to this with the Menu: Create a regular form (DUN:HPD:INC:IncAppStatus) with the following fields in addition to the standard fields: Inc Status App Status Status ? Field change attributes to have values of enabled and disabled Input the following data into the form: INC Status APP Status In Progress Approve In Progress Scheduled In Progress BreakFix Pending Awaiting rel Resolved Go Live Create a menu Refresh ? On Open Menu Type ? Search Form Name ? DUN:HPD:INC:IncAppStatus Label Fields ? App Status Value Field ? App Status Sort On Label ? Checked Qualification ? ?Status? = Enabled And ?Inc Status? = $7$ Let me know if this helps. Kelly Gatewood Senior Solutions Architect IT Prophets Cell 615-830-5078 www.itprophets.com From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of John Kelley Sent: Wednesday, July 08, 2009 8:51 AM To: arslist@ARSLIST.ORG Subject: Re: Selection Menu Question Hi Yes, search based on selection of the INC status is what I was looking for. The results, I would want to become available in a drop down, kind of like the Operational tiers, when you select first tier the second becomes available. John Joe DeSouza joe_rem...@yahoo.com Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 07/08/2009 02:10 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Selection Menu Question ** While I think I more or less understand what you want to do, what exactly do you mean by 'filter out attributes of a selection field' ?? Are you looking to perform a search Based on the selection of the INC Status? So if 'In Progress' is selected do you want the system to return results that contain records that have the App Status of 'Approoved', 'Scheduled' and 'BreakFix'?? If so depending on where you want that search result to be returned to, (Results List or Table Field) I do not think it is really hard to build an external qualification that does it? Wouldn't you be looking at creating an external qualificaton that could be used in the table field or results list that would build the qualication against the App Status on selection of the INC Status? I think its as simple as that.. Or have I understood what you want to do wrong? Sorry more questions than answers - so if I have understood you wrong please try and explain what exactly you are aiming for.. Cheers Joe From: John Kelley john.kel...@dunkinbrands.com To: arslist@ARSLIST.ORG Sent: Tuesday, July 7, 2009 4:14:41 PM Subject: Selection Menu Question Hi List Is it possible to setup an Active link to filter out attributes of a selection field drop down? Heres the story. I currently have on my Helpdesk form the INC Status field that has the normal status' and an APP Status field which has other Process status' for example. Approve, Scheduled, Awaiting release, Breakfix, Go-live, No-Go etc. I also have another form with APP Status and INC Status. I save entries of APP status with a particular INC status. For Ex. APP StatusINC Status ApproveIn Progress ScheduledIn Progress BreakFixIn Progress Awaiting relPending Go LiveResolved Now I'm trying to get the APP status on the Helpdesk form to filter out what matches to the INC status that is selected. Basically I should be able to select INC Status of In Progress and It should show me three items. I think the selection field is the problem, I may need a character field instead and then map a menu to it. Or continue with my AL somehow Any ideas. Thanks John ARS 7.1 patch 6 Apps 7.003 patch6 _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail
Re: Selection Menu Question
Ah the Status Reason field. The field that is supposed to be Data driven in version 7.0 but not realy. Yes thats how I was planning it to work. I was trying to avoid hard coding in the attributes of the selection field and using the Data driven path, but I already have the field processing other workflow. Maybe Joe . suggestion on External Qualification in an AL is way to go. I need to look into how that works, I've only done it once before. JK Lyle Taylor tayl...@ldschurch.org Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 07/08/2009 12:46 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Selection Menu Question ** You bring up something that I?ve been wondering about. What?s the point in having the hidden selection field for Status Reason? What purpose does it serve that couldn?t be met by simply storing the status reason, or using a character field to store it?s Request ID, GUID, selection value, or whatever other unique key you want to use? That way, it would be completely configurable and would not require both configuration and customization to add or remove status reasons. Thanks, Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kelly Gatewood Sent: Wednesday, July 08, 2009 10:13 AM To: arslist@ARSLIST.ORG Subject: Re: Selection Menu Question ** John, A good example of this is how BMC handle the Status Reason field in ITSM 7.x. They have the standard selection field (but it is hidden) and then have a character field with a menu (which has the values that you filter). What happens, is when you choose the menu value, workflow then sets the appropriate value of the selection field. Thanks Kelly Gatewood Senior Solutions Architect IT Prophets Cell 615-830-5078 www.itprophets.com From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of John Kelley Sent: Wednesday, July 08, 2009 10:58 AM To: arslist@ARSLIST.ORG Subject: Re: Selection Menu Question ** Thats Exactly what I was looking for. Thankyou Kelly Now my only other issue, the original APPStatus field on the Helpdesk form is a selection field instead of a character field. Is there any way to convert the selection field to a character field so I can map out a menu to it? JK _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Selection Menu Question
Hi List Is it possible to setup an Active link to filter out attributes of a selection field drop down? Heres the story. I currently have on my Helpdesk form the INC Status field that has the normal status' and an APP Status field which has other Process status' for example. Approve, Scheduled, Awaiting release, Breakfix, Go-live, No-Go etc. I also have another form with APP Status and INC Status. I save entries of APP status with a particular INC status. For Ex. APP Status INC Status Approve In Progress Scheduled In Progress BreakFixIn Progress Awaiting rel Pending Go Live Resolved Now I'm trying to get the APP status on the Helpdesk form to filter out what matches to the INC status that is selected. Basically I should be able to select INC Status of In Progress and It should show me three items. I think the selection field is the problem, I may need a character field instead and then map a menu to it. Or continue with my AL somehow Any ideas. Thanks John ARS 7.1 patch 6 Apps 7.003 patch6 * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free.
Close window without saving
Hi List ARS 7.1 patch 6 App 7.03 patch 6 I have a custom form which opens in a dialog view. When a users name is populated in the form. It searches its CTM:people profile for an expiration date. I then have a message that pops up if the expiration date has expired please fill out a new request. I would want ideally to hit OK on the message and it automatically closes out of the form without saving data. But If I have to clear the fields That would be OK as well. I'm not sure how to close the window after the message. Anyone have any quick ideas. * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free.
Re: Close window without saving
I created a close window action but when they hit Ok it still brings them to the form with the users information in it. Not actually closing the window. LJ Longwing lj.longw...@gmail.com Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 05/28/2009 11:26 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Close window without saving ** In the same AL that pops up the message, add a 'Close Window' action after the message action, this will cause the window to close when they press ok From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of John Kelley Sent: Thursday, May 28, 2009 9:13 AM To: arslist@ARSLIST.ORG Subject: Close window without saving Hi List ARS 7.1 patch 6 App 7.03 patch 6 I have a custom form which opens in a dialog view. When a users name is populated in the form. It searches its CTM:people profile for an expiration date. I then have a message that pops up if the expiration date has expired please fill out a new request. I would want ideally to hit OK on the message and it automatically closes out of the form without saving data. But If I have to clear the fields That would be OK as well. I'm not sure how to close the window after the message. Anyone have any quick ideas. * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free.
Re: Close window without saving [RESOLVED}
It was an Error message I changed it to a warning and that worked Thank you Fred. Grooms, Frederick W frederick.w.gro...@xo.com Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 05/28/2009 11:49 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Close window without saving Is your message an Error, Warning, or Note? If it is an Error then the Close Window action you have after the Message action will not fire. Fred From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of John Kelley Sent: Thursday, May 28, 2009 10:37 AM To: arslist@ARSLIST.ORG Subject: Re: Close window without saving I created a close window action but when they hit Ok it still brings them to the form with the users information in it. Not actually closing the window. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of LJ Longwing Sent: Thursday, May 28, 2009 10:26 AM To: arslist@ARSLIST.ORG Subject: Re: Close window without saving In the same AL that pops up the message, add a 'Close Window' action after the message action, this will cause the window to close when they press ok From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of John Kelley Sent: Thursday, May 28, 2009 9:13 AM To: arslist@ARSLIST.ORG Subject: Close window without saving Hi List ARS 7.1 patch 6 App 7.03 patch 6 I have a custom form which opens in a dialog view. When a users name is populated in the form. It searches its CTM:people profile for an expiration date. I then have a message that pops up if the expiration date has expired please fill out a new request. I would want ideally to hit OK on the message and it automatically closes out of the form without saving data. But If I have to clear the fields That would be OK as well. I'm not sure how to close the window after the message. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free.
Heterogeneous services
Hi List Are there any oracle gurus out there that may be able to assist me. I'm setting up Heterogeneous Services to be able to access columns in an Access DB from within Remedy (Oracle DB 10g). I am trying to figure out how to start and stop a listener on my application server with Oracle 10g I can't find the Listener Utility. Is it part of the Oracle installer? When I type LSNRCTL start ... from the command line, it says 'lsnrctl' is not recognized as an internal or external command I do a search in the oracle directory and it is not there. Any ideas how to install it? What option in the Oracle installer installs the utility? Thanks JK * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free.
Re: Heterogeneous services
My Variable is set to C:\oracle\product\10.2.0\client_1\BIN That lsnrctl file is not in the Bin Folder. Do know how I can install it? John Kelley Sr IT Analyst 130 Royall Street Canton, MA 02021 Work: 781-737-3564 Cell: 781-915-9063 john.kel...@dunkinbrands.com Soria, Joe jso...@bresnan.com Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 05/28/2009 01:15 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Heterogeneous services John, Ensure you have your oracle environment variables properly set (ORACLE_HOME, ORACLE_BASE, ORACLE_NLS). The listener (lsnrctl) is located here: $ORACLE_HOME/bin. Hope that helps. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of John Kelley Sent: Thursday, May 28, 2009 11:02 AM To: arslist@ARSLIST.ORG Subject: Heterogeneous services Hi List Are there any oracle gurus out there that may be able to assist me. I'm setting up Heterogeneous Services to be able to access columns in an Access DB from within Remedy (Oracle DB 10g). I am trying to figure out how to start and stop a listener on my application server with Oracle 10g I can't find the Listener Utility. Is it part of the Oracle installer? When I type LSNRCTL start ... from the command line, it says 'lsnrctl' is not recognized as an internal or external command I do a search in the oracle directory and it is not there. Any ideas how to install it? What option in the Oracle installer installs the utility? Thanks JK * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free. * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free.
Qualification statement
Hi Can someone tell me why this statement fails? 'Will Expire Date' ($DATE$ + (((60 * 60) * 24) * 15)) Where this one does work. 'Will Expire Date' $DATE$ The Will Expire Date is a Date field which is an expiration date. A message pops up saying ' the expiration date is expired... when the record is accessed. What I wanted is to have another message come up if the Will Expire Date is 15 days more than today date. Then a message should say not expired yet... Anything within the 15 days should allow the other workflow. * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free.
Re: Qualification statement RESOLVED
I had to create a hidden Date field and on window open make the field value $DATE$ + (((60 * 60) * 24) * 15) Then I could do my normal calculation on that hidden field. Thankyou Shellman, David dave.shell...@tycoelectronics.com Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 04/27/2009 05:29 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Qualification statement ** Ahh yes. I knew that little voice was whispering some thing to me. It's been a long time since I setup the work flow in our time tracking control panel that retrieves records based on a Date field. It was the issue with $DATE$ that made me use a hidden Date field in my qualification statement. Dave From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of LJ Longwing Sent: Monday, April 27, 2009 4:41 PM To: arslist@ARSLIST.ORG Subject: Re: Qualification statement ** You may be having one of several problems...if 'Will Expire Date' is truly 'Date' not 'Date/Time'...then the values stored in there are 1 per day, not 86400 per day...so your qual would be $DATE$+15 if you are looking for 15 more days. Another issue you may be coming up against is that $DATE$ may be used for either Date or Date/Time fieldsand when you force an arithmetic calculation on it then you force it to choose either Date or Date/Time before it can figure out what type of field it's being compared about...so it may not be making it a Date value instead of a Date/Time value. If you run SQL logging on the two qualifications you have compared you will likely find that there is something VERY different that the field is being compared to...the best way I have found in the past to do this is take $DATE$, store it in a tmp Date field, then in a separate action add 15 to it...then compare the tmp field to your real field. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of John Kelley Sent: Monday, April 27, 2009 2:33 PM To: arslist@ARSLIST.ORG Subject: Qualification statement Hi Can someone tell me why this statement fails? 'Will Expire Date' ($DATE$ + (((60 * 60) * 24) * 15)) Where this one does work. 'Will Expire Date' $DATE$ The Will Expire Date is a Date field which is an expiration date. A message pops up saying ' the expiration date is expired... when the record is accessed. What I wanted is to have another message come up if the Will Expire Date is 15 days more than today date. Then a message should say not expired yet... Anything within the 15 days should allow the other workflow. * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free.
Re: SQL statement
Thanks
With my statement
SELECT * FROM OPENDATASOURCE ('Microsoft.jet.OLEDB.4.0',
'Data Source=h:\Shopinfo\shopdetail.mdb')...ShopDetail WHERE SHOP_PFCNTR =
$Shop Number$
The error I get is the following
ARERR [552] Failure during SQL operation to the database : ORA-00933: SQL
command not properly ended
The MDB does not have a passowrd. I think I'm missing a quote somewhere.
A question I had is, do I need to setup a System Data source on the server
to this Microsoft access db or can that be done on the client?
Ashton, Jim (JUS) jim.ash...@ontario.ca
Sent by: Action Request System discussion list(ARSList)
arslist@ARSLIST.ORG
04/17/2009 10:34 AM
Please respond to
arslist@ARSLIST.ORG
To
arslist@ARSLIST.ORG
cc
Subject
Re: SQL statement
**
The following works for SQL Server in a similar situation. Not sure what
the corollary to OPENDATASOURCE is for Oracle.
SELECT X.* FROM OPENDATASOURCE('Microsoft.jet.OLEDB.4.0',
'Data Source=\\usranfb\transfer\Shopinfo\shopdetail.mdb;
Jet OLEDB:Database Password=password;')...table name X
WHERE SHOP_PFCNTR = $Shop number$
password is an optional database level password - if there is no
database password on the .mdb file I think you can omit the entire Jet
OLEDB:Database Password=password; phrase.
table name is the name of the table containing the SHOP_PFCNTR field in
your Access database.
Hope this helps,
Jim.
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers
Are_
*
This e-mail message, including any attachments, is for the sole use of the
addressee(s) to whom it has been sent, and may contain information that is
confidential or legally protected. If you are not the intended recipient or
have received this message in error, you are not authorized to copy,
distribute, or otherwise use this message or its attachments. Please notify
the sender immediately by return e-mail and permanently delete this message and
any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is
error or virus free.
SQL statement
Need a little help with an SQL statement. I am trying to populate fields in INC management from an Access Database on a shared network drive. My set field SQL statement so far is : SELECT * FROM File: //usranfb/transfer/Shopinfo/shopdetail.mdb WHERE SHOP_PFCNTR = $Shop number$ When I populate the shop number in my INC I get the following error. ARERR [552] Failure during SQL operation to the database : ORA-00903: invalid table name I don't think it knows where the location is. Help * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free.
Vendor Tab
Does anyone have information on usage of the Vendor Tab on the Help desk form. Information on whether an amail can be sent to the vendor company when saved? Where can you configure the email address? Or will I have to go down the road of creating a filter on modify of the HPD:Helpdesk form qualif. 'Vendor Company' = Dell to Notify? I'm just trying to avoid hard coding the vendor company in a filter to notify them when an INC has been applied to them. Any clues Thanks JK * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free.
Word doc view
Hi All I have a view field that I would like to display a word doc. I created an active link with a Set field File://usranfb/transfer/RemedyTestforViewfield.doc. When the form opens it prompts me to open or save the doc. Is there a way to avoid the prompt. Also is there a way to center the doc in the view field? All I want to do is show some text with special formatting and color. Since text boxes do not have that capability, I went down the road of displaying a word doc. Any help or workarounds would be great! JK * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free.
Re: Survey Link in Email (UNCLASSIFIED)
Thanks Leonard I tried this and that works great to remove the link but it seems to be a global notification because it removes the link for all notifications on INC, TSK and CHG notifications which I need. I wander if there is a way to disable the web url for just the survey. Maybe we should go back to original thread from Rich Cook. John, its been awhile since I saw this, but I think the user has to have some permissions set up that aren't in the book. I'm not sure what permission? John ** John, I believe you will need to uncheck the ?Web URL? option on filter NTE:NTS:Email_200_SystemNT in order to get rid of that link. HTH Leonard Neely From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of John Kelley Sent: Tuesday, December 30, 2008 10:59 AM To: arslist@ARSLIST.ORG Subject: Re: Survey Link in Email (UNCLASSIFIED) Hi Michael. thanks. unfortunately that one is the one I need and that works. Its the one that precedes the email the first link below in example which I liked to remove. Here is an example of what comes in. http://dbusremweb1/arsys/servlet/ViewFormServlet?form=NTE%3aNotifierserver=dbusremapp1eid=NTS00263881 (This is the link that is preceding my Survey email body.) We value your feedback and are constantly looking for ways to improve our service to you. Please take a moment to complete the Service Desk Survey for INC00011413. Summary: Integrate Remedy Appworx for Notifications Click here: http://dbusremweb1/arsys/servlet/ViewFormServlet?form=SRM:Surveyview=RequesterAnswerserver=dbusremapp1eid=SRV1051 (this link comes from the SYS:attachments) Here is my text: We value your feedback and are constantly looking for ways to improve our service to you. Please take a moment to complete the Service Desk Survey for #Survey ID#. Summary: #Description# Click here: #Detailed Description# Thanks john __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free.image/jpeg
Re: Survey Link in Email
Thanks guys but this notification is the one that works. Seems every notification in the system has a link that gets created before your custom email message? Thats the one I need disabled for surveys. I'm thinking it may be the filter NTE:SHR:TranslateNotificationMessageSRV_180 with the set fields REPLACE($z1D Translation Text$, #Survey ID#, $Request ID02 Ticket$) REPLACE($z1D Translation Text$, #Detailed Description#, $Detailed Description$) EXIT GUIDE Maybe I'll try disabling this. I'll let you know. John Chowdhury, Tauf tauf.chowdh...@frx.com Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 12/29/2008 03:54 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Survey Link in Email John, Also, this filter is what sets the #Description# to the web URL: SRM:SRV:ModifySurvey_805_NotificationGenerator_PNPC`! If you go with my option, all you have to do is after Web Link: just enter the URL I gave below with your server info and it should be good to go. Tauf Chowdhury | Forest Laboratories, Inc. Sr. Analyst Office: 631.858.7765 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of John Kelley Sent: Monday, December 29, 2008 2:51 PM To: arslist@ARSLIST.ORG Subject: Survey Link in Email Hi List: ARS Server 7.01 I was wandering if anyone had an issue with the out of the Box link thats gets sent to the end user through email and when clicked ,user logs in they receive a warning No matching requests. (or Permission to requests) for qualification criteria.(ARWARN 9296) You hit OK but then it opens the Survey form with no data. I am using the SYS:NotificationsMessages form and there is no link within the body of this survey. It seems to be set in the system somewhere preceeding that form, I can't figure out how to disable this link for surveys. Here is the html if anyone sees the problem right away. http://dbusremwebtst/arsys/servlet/ViewFormServlet?form=NTE%3aNotifierserver=dbusremapptsteid=NTS00289800 thanks John * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free. This e-mail and its attachments may contain Forest Laboratories, Inc. proprietary information that is privileged, confidential or subject to copyright belonging to Forest Laboratories, Inc. This e-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this e-mail, or the employee or agent responsible for delivering this e-mail to the intended recipient, you are hereby notified that any dissemination, distribution, copying or action taken in relation to the contents of and attachments to this e-mail is strictly prohibited and may be unlawful. If you have received this e-mail in error, please notify the sender immediately and permanently delete the original and any copy of this e-mail and any printout. * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free.
Re: Survey Link in Email (UNCLASSIFIED)
Hi Michael. thanks. unfortunately that one is the one I need and that works. Its the one that precedes the email the first link below in example which I liked to remove. Here is an example of what comes in. http://dbusremweb1/arsys/servlet/ViewFormServlet?form=NTE%3aNotifierserver=dbusremapp1eid=NTS00263881 (This is the link that is preceding my Survey email body.) We value your feedback and are constantly looking for ways to improve our service to you. Please take a moment to complete the Service Desk Survey for INC00011413. Summary: Integrate Remedy Appworx for Notifications Click here: http://dbusremweb1/arsys/servlet/ViewFormServlet?form=SRM:Surveyview=RequesterAnswerserver=dbusremapp1eid=SRV1051 (this link comes from the SYS:attachments) Here is my text: We value your feedback and are constantly looking for ways to improve our service to you. Please take a moment to complete the Service Desk Survey for #Survey ID#. Summary: #Description# Click here: #Detailed Description# Thanks john Luttmann, Michael W CTR USA michael.luttm...@us.army.mil Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 12/30/2008 12:22 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Survey Link in Email (UNCLASSIFIED) Classification: UNCLASSIFIED Caveats: NONE John, If I understand your requirement correctly, you may need to look at the form SYS:Attachments, then find the record marked Survey. You can modify the URL field to redirect from the default survey link to any other URL (we have an Army survey we use instead of the ITSM survey form). Also, you can disable the survey link altogether in the resolved customer email by nulling out that field, or setting the record Offline (or even deleting it, if you want to get drastic). Is that what you were looking for? Michael W. Luttmann Lead Remedy Developer Fort Carson DOIM 719.524.0514 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of John Kelley Sent: Tuesday, December 30, 2008 9:58 AM To: arslist@ARSLIST.ORG Subject: Re: Survey Link in Email Thanks guys but this notification is the one that works. Seems every notification in the system has a link that gets created before your custom email message? Thats the one I need disabled for surveys. I'm thinking it may be the filter NTE:SHR:TranslateNotificationMessageSRV_180 with the set fields REPLACE($z1D Translation Text$, #Survey ID#, $Request ID02 Ticket$) REPLACE($z1D Translation Text$, #Detailed Description#, $Detailed Description$) EXIT GUIDE Maybe I'll try disabling this. I'll let you know. John Chowdhury, Tauf tauf.chowdh...@frx.com Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 12/29/2008 03:54 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Survey Link in Email John, Also, this filter is what sets the #Description# to the web URL: SRM:SRV:ModifySurvey_805_NotificationGenerator_PNPC`! If you go with my option, all you have to do is after Web Link: just enter the URL I gave below with your server info and it should be good to go. Tauf Chowdhury | Forest Laboratories, Inc. Sr. Analyst Office: 631.858.7765 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of John Kelley Sent: Monday, December 29, 2008 2:51 PM To: arslist@ARSLIST.ORG Subject: Survey Link in Email Hi List: ARS Server 7.01 I was wandering if anyone had an issue with the out of the Box link thats gets sent to the end user through email and when clicked ,user logs in they receive a warning No matching requests. (or Permission to requests) for qualification criteria.(ARWARN 9296) You hit OK but then it opens the Survey form with no data. I am using the SYS:NotificationsMessages form and there is no link within the body of this survey. It seems to be set in the system somewhere preceeding that form, I can't figure out how to disable this link for surveys. Here is the html if anyone sees the problem right away. http://dbusremwebtst/arsys/servlet/ViewFormServlet?form=NTE%3aNotifiers erver=dbusremapptsteid=NTS00289800 thanks John * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free. This e-mail and its attachments may contain Forest
Survey Link in Email
Hi List: ARS Server 7.01 I was wandering if anyone had an issue with the out of the Box link thats gets sent to the end user through email and when clicked ,user logs in they receive a warning No matching requests. (or Permission to requests) for qualification criteria.(ARWARN 9296) You hit OK but then it opens the Survey form with no data. I am using the SYS:NotificationsMessages form and there is no link within the body of this survey. It seems to be set in the system somewhere preceeding that form, I can't figure out how to disable this link for surveys. Here is the html if anyone sees the problem right away. http://dbusremwebtst/arsys/servlet/ViewFormServlet?form=NTE%3aNotifierserver=dbusremapptsteid=NTS00289800 thanks John * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free.
DataLoad Console
AR Server 7.01 patch 6 Has anyone experience Dataload Console Validate issues. (Data Management patch 9005) I run the convert , then import, it brings it into the staging form, but when validating it hangs on pending. It never validates. Things I've tried. Removing the entry in the DLD:ThreadMessage Check the private thread min 2 and max 2 390627. I renamed the installation directory for dataload and reinstalled ( 9005) and still after rebooting, stalls in pending validation. I'm only validating 89 records. The install log for the Dataload installer went through without errors. Any ideas? Thanks JK * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free.
Private incidents
Hi List ARS 7.01 Is there a way to set an Indicent request private to one particular group? Here is the reasoning: We have a risk management group that wants to open their own calls in incident management, which should NOT be seen by any other support group. Thanks * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free.
Midtier Question
Has anyone ever migrated one midteir to another? Here is my situation. I had my midtier on a Virtual environment. I had to migrate it to a physical box. After getting the physical box up and running and reinstalled service pack2. When I try to opening my http://(localhost)/arsys/home I get an error Service Unavailable. Has anyone experienced this before? I've reinstalled the Remedy 7.0 midtier software and applied the new Servlet patch. Rebooted same issue. Any help would be great Thanks ahead of time. JK * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free.
Worklog
Hi ARS 6.3 Is there any way to display the worklog in a form or table, without hitting the actual icon? * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free.
Canned reports 7.0
Hi List Does anyone out there have screen prints of the canned reports for ARS version 7.0 or a list. Having troubles finding a list of the canned reports. User guides don't give you any information. Thanks ahead of time. JK ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
List of out of Box reports
Hi all I need a list of Out of the box reports for Remedy ARS 7.0 and 6.3 We're comparing OTB reports. Can anyone direct to where I can find this information? Thanks ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Difference- User form and People form
Does anyone know why the members of users form has a different total # than the members in the people form? Unless its my workflow. Are they supposed to match? ARS 6.3 Thanks John ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
zsystem password reset every 90 days
I am trying to find out what other companies do if their companys password policy is set every 90 days, concerning systems using AREA LDAP configuration. Does anyone have an automated process for the password change for zsystem? Any thoughts or Suggestions. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
SLA Reporting Question
Does anyone out there have a standard SLA report that they run which Results in how a groups SLA are in regards to Priorty. The out of box reports for SLA are not that informative to us. Maybe I'm just stuck on the Qualifications. Any help would be great. Here is an example what we need Help Desk Low 80% SLA reached. Medium 75% SLA reaached. High 60% SLA reached. TelcomL M H Thanks JK ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Create a Button to Copy Details of Parent
** Thanks Jim for the long description ofthe AL in your requisition page.That sounds good, I may use that information in a future project, but there is realy only one field on the TASK form I would like taken from the Parent- The Description. Dan C. had a good idea of editing the Create new Task AL. This may be the route I would take but a button would be ideal as it would be an option for the helpdesk analyst to use. Most likely they would end up using the button though. I'm thinking of ztempreplacedescr. to hold HD parent details and then populate later but how to do it, is the question.Thanks JK__20060125___This posting was submitted with HTML in it___
Create a Button to Copy Details of Parent
ARS 6.0 Helpdesk 6.3 Needs some help on an active link to Create a button on a CHG:TSK form that copies the original HD descriptions details to the TSK Description. Out of Box -- Tasks only take either the predefined tasks description or a blank task description. I'm just trying to save time from doing a copy and paste. Thanks folks ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Table Field Qualification
Thanks Susan, that works great, now I just have to play with the Qualification to take out my calls assigned to me. Question for you: Is your Qualification looking in the Consolidated list form or the HPD:HelpDesk? JK Susan Palmer [EMAIL PROTECTED] L.COM To Sent by: Action arslist@ARSLIST.ORG Request System cc discussion list(ARSList)Subject [EMAIL PROTECTED] Re: Table Field Qualification ORG 11/01/2006 12:25 PM Please respond to [EMAIL PROTECTED] RG ** John, This is the qualification we use to show tickets assigned to the group you belong to, plus tickets assigned specifically for you. Idea is that if the unassigned tickets belong to you, you can easily see them and pick them up (somewhat against human nature in reality). (( 'Assigned To' = $USER$) OR (( 'Assigned To' = $NULL$ ) AND ( 'Assigned To Group+' != $NULL$ ) AND ($GROUPS$ LIKE (( % + 'Assigned To Group+') + % AND ((( 'zTmpKeyword' = MAINHELPDESK ) AND ( 'Status Integer' 4)) OR (( 'zTmpKeyword' = MAINCHANGE ) AND ( 'Status Integer' 6)) OR (( 'zTmpKeyword' = MAINTASK ) AND ( 'Status Integer' 4))) Now that brings up the question of how the table qualification above knows what group you are in. Logically I know that information should be setting on the form but a quick look through did not show it to me. This is an out of the box form that we have customized heavily. There's no 112 field, so it must be magic or some field is being used in an unexpected way. Sorry I couldn't be of more help on this part. hth, Susan Susan Palmer ShopperTrak 312-529-5325 On 10/31/06, John Kelley [EMAIL PROTECTED] wrote: Restated: If I log into remedy, as a support staff member of Help Desk. I should see a table of Calls that were Auto-Assigned to the Helpdesk with no particular assignee.Or another way to say it, is My groups unassigned calls I'm also not sure what form to grab from HPD:Heldesk or SHR:Consolatedlist Thanks JK Axton [EMAIL PROTECTED] L.COM To Sent by: Action arslist@ARSLIST.ORG Request System cc discussion list(ARSList)Subject [EMAIL PROTECTED] Re: Table Field Qualification ORG 10/31/2006 07:04 PM Please respond to [EMAIL PROTECTED] RG Can you restate the following? Then maybe we can help. shows Unassigned HPD and CHG requests, for only the person that is logged into Remedy User Observations: - an unassigned ticket is an unassigned ticket, regardless of who is looking at it - unassigned to a group? an individual? both? Axton Grams On 10/31/06, John Kelley [EMAIL PROTECTED] wrote: Hello all. AR Server 6.03 Helpdesk App 6.0 Having trouble with a Qualification: I'm trying to create a table on my support form that only shows Unassigned HPD and CHG requests, for only the person that is logged into Remedy User. Any suggestion? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers
Table Field Qualification
Hello all. AR Server 6.03 Helpdesk App 6.0 Having trouble with a Qualification: I'm trying to create a table on my support form that only shows Unassigned HPD and CHG requests, for only the person that is logged into Remedy User. Any suggestion? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Setup Dev Server (RESOLVED)
Hi James , Axton and everyone that responded. Thanks to all for the information. Here is what I ended up doing. During the setup of my DEV box. I selected the overwrite option Which would overwrite the DB. I Actually had a copy of the Original DB which later would replace the DB original install. Then reapply the license. FYI. The Dev DB is on B unix server with the same Table space name and same DB name as Production A server. As long as the TNSnames.ora file specifies the Instance correctly it will go to the proper spot. For eveyone, Please make sure tnsname is correct Thanks John Kelley * Axton: Definitely the way to copy a tablespace from one server to another. I had forgotten about copying the LOB space, too. I tend to use Export/Import from Remedy rather than do this at the DB level. However, this does not scale well if you are working with Direct SQL and reference tables by name. James McKenzie L-3 GSI -Original Message- From: Action Request System discussion list(ARSList) [ mailto:[EMAIL PROTECTED] On Behalf Of Axton Grams Sent: Friday, September 01, 2006 12:53 PM To: arslist@ARSLIST.ORG Subject: Re: Setup Dev Server I duplicate databases infrequently. The metadata (actlink_open, email mailbox, etc.) are fairly easy to clean with pl/sql. Copying between different tablespaces is a little tricky due to LOB storage, but not impossible. You have to manually create the tables with modified DDL (specifying lob storage) that have LOBs prior to running the imp of the dmp file to ensure the LOBS go to the right tablespace during import. http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:378418239571#16075038165527 The main reason we do it this way is because this method puts the margin for error/reliability and the time required to complete are in our favor. Axton Grams McKenzie, James J C-E LCMC HQISEC/L3 wrote: ** Fred: (Wacking self on head). Thanks. Now the next question is how did they duplicate the database? There are variables in the Remedy metadata that will error out if they did a physical vice ARExport/ARImport move of data. This may be causing the problem. I tried a physical move from one tablespace to another on the same server and Oracle would not let me. James Mckenzie L-3 GSI -- -- *From:* Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] *On Behalf Of *Grooms, Frederick W *Sent:* Friday, September 01, 2006 12:12 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Setup Dev Server ** He said they were on 2 different servers -- -- *From:* Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] *On Behalf Of *McKenzie, James J C-E LCMC HQISEC/L3 *Sent:* Friday, September 01, 2006 1:41 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Setup Dev Server ** Fred: I think the problem may be that the production and dev servers are pointing to the same Oracle DB Instance and that they are installed in two different tablespaces. This can lead to disaster of major proportions. Solution: Have DBA create a second instance on the Oracle DB for development. Or install Oracle on a second server (this is LEGAL per Oracle.) James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: Friday, September 01, 2006 11:17 AM To: arslist@ARSLIST.ORG Subject: Re: Setup Dev Server Do you have the environment variables set up correctly? The 32 bit Oracle 9iR2 client in the path before your 64 bit Oracle 9iR2 client. ORACLE_HOME pointing to your 32 bit Oracle 9iR2 client. ORACLE_SID and TWO_TASK set for your dev database. TNS_ADMIN pointing to your tnsnames.ora file. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of John Kelley Sent: Friday, September 01, 2006 10:31 AM To: arslist@ARSLIST.ORG Subject: Setup Dev Server Hi List: First time emailer. Long time reader. I'm trying to setup our Dev Box(Windows 2003sp1) with AR 6.3. Having errors upgrading an existing DB. We took a copy of production DB, and placed it on a different oracle Server. Oracle 9.2.0.4.0 64bit. My tnsnames is set correctly to Dev Server and connection to remedb listener. The name of the DB is the same for Production and Dev. Which is OK. They are on different servers. When I'm setting up the Dev server running server.exe, Its asks for SID name and what type of install. Upgrade, Overwrite or Shared. I select Upgrade because the DB out there is an exact copy of the Production having all the Data - I want the data in tact just to install the Server. Here is the Error 15:40:39 An error was encountered during the upgrade of the AR System database. 15:40:39
Setup Dev Server
Hi List: First time emailer. Long time reader. I'm trying to setup our Dev Box(Windows 2003sp1) with AR 6.3. Having errors upgrading an existing DB. We took a copy of production DB, and placed it on a different oracle Server. Oracle 9.2.0.4.0 64bit. My tnsnames is set correctly to Dev Server and connection to remedb listener. The name of the DB is the same for Production and Dev. Which is OK. They are on different servers. When I'm setting up the Dev server running server.exe, Its asks for SID name and what type of install. Upgrade, Overwrite or Shared. I select Upgrade because the DB out there is an exact copy of the Production having all the Data - I want the data in tact just to install the Server. Here is the Error 15:40:39 An error was encountered during the upgrade of the AR System database. 15:40:39 Installation terminating ... Original database server is intact and accessible 15:40:39 Resolve the problem that causes the error (contact Technical Support, if necessary) 15:40:40 -[ShowMsg]: Setup is rolling back directories 15:40:40 Setup is rolling back the directories. 15:40:41 ServiceName not found. Using Default: Remedy Action Request System Server 15:40:41 -[ERROR]: AR System Database upgrade error. The original database is intact and accessible. Anyboby have something similar. Or suggestion. John Kelley Help Desk Analyst 130 Royall Street Canton, MA 02021 Mail Center 1W 781-737-3564 ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Setup Dev Server
I can SQL plus on the Dev box to the DB. I log in as ARAdmin default password. Here is another catch. If I leave the tables space name the default (ARSYSTEM) it then goes to the Next Screen to Upgrade. I also tried to change the table space name to TABS and suprisingly it allows me to the next screen also. Shouldn't the DB only have one Tablespace name? Oh -- the Production server has the same version or Oracle. John Julie Rockwood [EMAIL PROTECTED] V To Sent by: Action arslist@ARSLIST.ORG Request System cc discussion list(ARSList)Subject [EMAIL PROTECTED] Re: Setup Dev Server ORG 09/01/2006 01:38 PM Please respond to [EMAIL PROTECTED] RG John, Did you also see: DLL function call crashed:UPORACL.UpgradeDatabaseOR ? I had exactly that problem when I upgraded from ARS 5.1.2 on a Windows 2000 box to ARS 6.3 on Windows 2003 box. The Oracle 9.2.0.4.0 64 bit was on an AIX box. Remedy Support was pretty sure that it had something to do with the Oracle client. Recently I noticed a note on the compatibility matrix that may provide a clue: Requires 32-bit Oracle 9iR2 database client for connecting to the Oracle database. I'm not sure what I have. I ended up upgrading the database from the old Win 2000 box, then connecting to the upgraded database from the 2003 box. I then tested everything and have now been in production with it since May with no problems. I do not know if I'll have a problem when it comes time to upgrade again, so I would love to hear if you find out what causes it. Julie At 09:30 AM 9/1/2006, you wrote: Hi List: First time emailer. Long time reader. I'm trying to setup our Dev Box(Windows 2003sp1) with AR 6.3. Having errors upgrading an existing DB. We took a copy of production DB, and placed it on a different oracle Server. Oracle 9.2.0.4.0 64bit. My tnsnames is set correctly to Dev Server and connection to remedb listener. The name of the DB is the same for Production and Dev. Which is OK. They are on different servers. When I'm setting up the Dev server running server.exe, Its asks for SID name and what type of install. Upgrade, Overwrite or Shared. I select Upgrade because the DB out there is an exact copy of the Production having all the Data - I want the data in tact just to install the Server. Here is the Error 15:40:39 An error was encountered during the upgrade of the AR System database. 15:40:39 Installation terminating ... Original database server is intact and accessible 15:40:39 Resolve the problem that causes the error (contact Technical Support, if necessary) 15:40:40 -[ShowMsg]: Setup is rolling back directories 15:40:40 Setup is rolling back the directories. 15:40:41 ServiceName not found. Using Default: Remedy Action Request System Server 15:40:41 -[ERROR]: AR System Database upgrade error. The original database is intact and accessible. Anyboby have something similar. Or suggestion. John Kelley Help Desk Analyst 130 Royall Street Canton, MA 02021 Mail Center 1W 781-737-3564 ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org --- Julie Rockwood Los Alamos National Laboratory IST-AUBAD Remedy Technical Lead (505) 667-9846 ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
