Running SQL Server on Non Standard port
Hello all,, Can someone please let me how we can configure to run SQL Server 2008 on some non standard port. Thanks. Wirasat ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: AIE. Annoying message every minute in log file
Have you checked the AsyncInterval and ConfigInterval in aie.cfg file? You may want to bump it up to see if the frequency of message goes down. Thanks, Wirasat -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Sergio Tomillero Sent: Friday, October 07, 2011 4:22 AM To: arslist@ARSLIST.ORG Subject: AIE. Annoying message every minute in log file Hi, I have configured Atrium Integration Engine 7.6.00 Patch 002 and Data Exchanges are working correctly. I have configured them to be executed as 'event driven'. However, every minute is appearing the next annoying message on each DataExchanges log file: TimedEventDrivenExchange: No event-driven requests ready to process in async queue Is there any way to avoid this message? In aie.cfg I have set DebugOn to Yes, because for each data exchange I need to get a log with the result. Also In data exchanges advanced settings I just have ennabled debug logging to Yes and the rest of debug level options (tread based, api, sql and so.. ) unmarked. Kind regards, Sergio Tomillero -- View this message in context: http://ars-action-request-system.1093659.n2.nabble.com/AIE-Annoying-message-every-minute-in-log-file-tp6868536p6868536.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: CRITICAL - ARS Does not start
Do you guys do the database and Application server back up. You may want to consider restoring from the backup if it is in place. Thanks, Wirasat From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Hyunkel v2.0 Sent: Tuesday, October 04, 2011 9:46 AM To: arslist@ARSLIST.ORG Subject: Re: CRITICAL - ARS Does not start ** I've already checked that, even once the upgrade ended, I used the old ar.cfg file to start up the services, but just the same result. Hugo Ruesga Software Development Advisor US 972.577.7000 x 332.3868 MX +52 (33) 3332.3868 P Please consider the environment before printing this email The information contained in and transferred with this electronic message is intended only for the recipient(s) designated above, it is protected by law and it may contain information which is privileged and confidential. If you are not the intended recipient, please do not read, copy, or use it, and do not disclose it to others. Please notify the sender of the delivery error by replying to this message, and then delete it from your system. Thank you. Date: Tue, 4 Oct 2011 09:16:20 -0400 From: remedy...@gmail.com Subject: Re: CRITICAL - ARS Does not start To: arslist@ARSLIST.ORG ** go to the backup folder and look for the ar.conf, find the ldap section and replace.. Hope that helps.. when installing it does make a copy.. nice... On Mon, Oct 3, 2011 at 7:06 PM, Hyunkel v2.0 lord_dyna...@hotmail.commailto:lord_dyna...@hotmail.com wrote: ** Now After running an installer with upgrade option service is up (previous set JAVA_HOME to a previous version of Java) It's a Win 2003 server with Oracle 10g (remote), now I'm having an issue while connecting to LDAP server: ARERR [8922] The authentication service is not responding. Cannot connect to the system at this time. Contact your AR System Administrator for assistance. Hugo Ruesga Software Development Advisor US 972.577.7000 x 332.3868 MX +52 (33) 3332.3868 P Please consider the environment before printing this email The information contained in and transferred with this electronic message is intended only for the recipient(s) designated above, it is protected by law and it may contain information which is privileged and confidential. If you are not the intended recipient, please do not read, copy, or use it, and do not disclose it to others. Please notify the sender of the delivery error by replying to this message, and then delete it from your system. Thank you. Date: Mon, 3 Oct 2011 18:21:55 -0400 From: jdso...@shyle.netmailto:jdso...@shyle.net Subject: Re: CRITICAL - ARS Does not start To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG ** Hugo, An incompatible version of Java may do a lot of other things but cannot prevent the AR System from starting. The AR System Server itself does not depend on JRE or JDK, its sub systems such as web services, mid tier, email engine etc do.. So somehow I doubt the update of Java has caused that problem. Its something else. If its UNIX, have you changed the environment or the .profile of the user that starts the AR System in any way? I am assuming you are on windows because you said you updated only the ar.cfg file upon updating Java.. On UNIX you would have needed to update that in the server startup script too. What OS are you dealing with? What's the version of the AR System and its database? Have you tried starting the server in a debug mode? Joe From: Hyunkel v2.0mailto:lord_dyna...@hotmail.com Sent: Monday, October 03, 2011 5:39 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: CRITICAL - ARS Does not start ** Listers; I'm having one of those issues that everyone loves on your production environment. ARS doesn't start up, the error log only displays the startup message but armonitor indicates a timeout every 900 seconds; this came from a Java update, I ran the patch 11 installer just to try Remedy to pick up the new java version. I've tried to point the OS and the ar.cfg file to a latest java version but no luck, does anyone has seen this before? Thanks Hugo Ruesga Software Development Advisor US 972.577.7000 x 332.3868 MX +52 (33) 3332.3868 P Please consider the environment before printing this email The information contained in and transferred with this electronic message is intended only for the recipient(s) designated above, it is protected by law and it may contain information which is privileged and confidential. If you are not the intended recipient, please do not read, copy, or use it, and do not disclose it to others. Please notify the sender of the delivery error by replying to this message, and then delete it from your system. Thank you. _attend WWRUG11 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG11 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the
Re: Ports
Correct. If you want to use specific port and not use port mapper, make sure that port is available. You can check port availability using netstat command in Windows system. Thanks, Wirasat From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Ben Chernys Sent: Friday, September 23, 2011 1:47 PM To: arslist@ARSLIST.ORG Subject: Re: Ports ** 1521 is the standard port for databases. Remedy has no standard port. Port mapper allows your clients to not set a port. If you want a port, just pick one, staying away from the lower numbers reserved for other services. Cheers Ben Chernys Senior Software Architect Software Tool House Inc. Canada / Deutschland / Germany Mobile: +49 171 380 2329GMT + 1 + [ DST ] Email: Ben.Chernys _AT_ softwaretoolhouse.commailto:ben.cher...@softwaretoolhouse.com Web: www.softwaretoolhouse.comhttp://www.softwaretoolhouse.com Check out Software Tool House's free Diary Editor. Meta-Update, our premium ARS Data tool, lets you automate your imports, migrations, in no time at all, without programming, without staging forms, without merge workflow. http://www.softwaretoolhouse.com/ Ben From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kathy Morris Sent: September-23-11 17:10 To: arslist@ARSLIST.ORG Subject: Ports ** Hi, Is there a standard port to use for AR System on 7.6.4 install. I thought before it was 1521 _attend WWRUG11 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Getting errors when creating a View Form
I did that too. It is much simpler way to handle view forms. Thanks, Wirasat From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Monday, September 12, 2011 12:15 PM To: arslist@ARSLIST.ORG Subject: Re: Getting errors when creating a View Form ** With all Remote databases I try to create a local database view of the remote table. This way the ARS system doesn't have to deal with the fact that it is remote (which is a plus when you have a Dev/Test/Prod environment setup and you need to move your code between environments). In ARS you simply create a View form against the local view of the remote data. Fred From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Marc Burick Sent: Monday, September 12, 2011 11:00 AM To: arslist@ARSLIST.ORG Subject: Getting errors when creating a View Form ** ARServer 7.1, patch 1 Admin Tool,, 7.1 patch 11 SQL 2008 We are attempting to create our first View Form, SQL database to a Oracle database, but we can not create the form. I am pretty sure our problem is the syntax of the table that I am putting in the field before I press Load. The Admin Tool appears to be looking for sysobjects, instead of the Linked Server. The examples in the documentation are poor. Admin Tool error message: Failure during SQL operation to the database : PAEHOWUD351.ASSETCENTER.AC_REMEDY_ASSETLOOKUP_VIEW (ARERR 552). SQL log error message: SQL TID: 003088 RPC ID: 002030 Queue: Admin Client-RPC: 390600USER: D065879 /* Mon Sep 12 2011 11:57:52.7910 */SELECT id from PAEHOWUD351.dbo.sysobjects where name = N'AC_REMEDY_ASSETLOOKUP_VIEW' SQL TID: 003088 RPC ID: 002030 Queue: Admin Client-RPC: 390600USER: D065879 /* Mon Sep 12 2011 11:57:52.7910 */*** ERROR *** Invalid object name 'PAEHOWUD351.dbo.sysobjects'. (SQL Server 208) We are able to query the Linked Server from SQL Studio. I am able to create a view on the SQL server that looks at the Linked Server and create the View Form using that view, but when I run a selection from the View Form, it takes 50+ seconds. Can anyone provide the syntax that should be put in as the table we want to be pointing to? Again, the documentation is not very clear. Thank you in advance. Marc _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Web service issue on calling HTTPS URL
I am trying to load a HTTPS URL suing filter set field. We have loaded the certificate in Java JRE directory on the server. When I try to click the load button, I am getting following error message. Any help would be appreciated. We are running AR Server Patch 6 on Windows 2003 environment. -- RROR: URI not found URL Additional Details: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target com.bmc.arsys.ws.util.ARWSException: URI not found URL at com.bmc.arsys.ws.util.WsdlUtil.validateWSDL(WsdlUtil.java:187) at com.bmc.arsys.ws.util.WsdlUtil.newDocument(WsdlUtil.java:230) at com.bmc.arsys.ws.wsdl.WsdlParser.init(WsdlParser.java:104) at com.bmc.arsys.ws.util.WsdlAdminInterface.parseWsdl(WsdlAdminInterface.java:406) at com.bmc.arsys.ws.util.WsdlAdminInterface.parseWSDLIntoMappingString(WsdlAdminInterface.java:213) Thanks, Wirasat K. Siddiqi Remedy Development Team Email: wirasat.sidd...@occ.treas.gov Office: 202-471-3576 Cell: 703-732-9495 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Incident Owner
Apart from the assignment configuration, incident owner depends upon the role of the support group too. It is well explained in Incident Management user guide on page 62 Thanks, Wirasat From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Andrew C Goodall Sent: Monday, April 25, 2011 1:40 PM To: arslist@ARSLIST.ORG Subject: Re: Incident Owner ** Yep, Strauss is right - you have to define a -global- assignment rule for Incident Owner Regards, Andrew Goodall Software Engineer 2 | Development Services | jcpenney . www.jcp.com http://www.jcp.com/ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of strauss Sent: Monday, April 25, 2011 12:28 PM To: arslist@ARSLIST.ORG Subject: Re: Incident Owner We don't use the assignment engine either, but we do have an ownership rule set up for every assignment rule in order to deal with our multi-tenancy configuration (dozens of operational companies and over 80 support groups). Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Cook Sent: Monday, April 25, 2011 12:26 PM To: arslist@ARSLIST.ORG Subject: Re: Incident Owner ** Hmmm...we are currently using an all manual process for assignment - the Assignment engine isn't configured at all. Perhaps that's part of the problem. Rick On Mon, Apr 25, 2011 at 10:19 AM, Danny Kellett danny.kell...@strategicworkflow.commailto:danny.kell...@strategicworkflow.com wrote: ** This is part of the assignment rules and is data driven. In my experience, I set this to the service desk group. Kind regards Danny From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of Rick Cook Sent: 25 April 2011 18:17 To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Incident Owner ** I am seeing something I am not sure I believe. In IM 7.5, the Incident Owner fields appear to be pre-populating with the information from the initial Assignee. According to ITIL, this should be the Submitter at the Service Desk (assuming that isn't the End User). Am I missing something? Rick _attend WWRUG11 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG11 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If the reader of this message is not the intended recipient, you are hereby notified that your access is unauthorized, and any review, dissemination, distribution or copying of this message including any attachments is strictly prohibited. If you are not the intended recipient, please contact the sender and delete the material from any computer. _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Group Notifications
Check the NTE:CFG-Notification Events form for following values. You need to have this setting for incident assignment messages to go out. Notification Event Type= System Default Module Name=Incident Notification Event=Assignment Remedy Notification Method=Email Group Notification=Yes Thanks, Wirasat From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Wilhelm, Chad E Sent: Friday, October 08, 2010 10:12 AM To: arslist@ARSLIST.ORG Subject: Re: Group Notifications ** Are there any notifications in the NTE:SYS-NT Process Control? If there are then it maybe a escalation thread issue. Thank You, Chad Wilhelm Purdue University IT Customer Relations - Remedy Administrator From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Sabyson Fernandes Sent: Friday, October 08, 2010 9:58 AM To: arslist@ARSLIST.ORG Subject: Re: Group Notifications ** Check that escalations are running on the server. The group notifications are expanded to the group members by an escalation that created the records in the NTE notification form for members of the group. Sometimes escalations are disabled at the server configuration level when you do an install/upgrade and forget to re-enable them. Regards, Saby --- On Fri, 10/8/10, Tommy Morris tommy.mor...@radioshack.com wrote: From: Tommy Morris tommy.mor...@radioshack.com Subject: Group Notifications To: arslist@ARSLIST.ORG Date: Friday, October 8, 2010, 3:34 AM ** ARS 7.5p3 ITSM 7.6p1 Just rolled this version out live for the company and group notifications for incident records are not triggering. Notifications are not being sent when an Incident is assigned to a Group. Notifications are sent when an Incident is assigned to an individual. Notifications are sent for Tasks and Changes being assigned to a group but I cannot find a configuration to ensure that Group Notifications fire for incidents. Amazingly this is a major issue. _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Ramdom Performance issue.
You can turn on SQL, Filter and Escalation log from server side and give the file same name. That way, you may be able to figure out what filter or escalation is generating this query. Thanks, Wirasat From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mueller, Doug Sent: Monday, January 24, 2011 10:00 AM To: arslist@ARSLIST.ORG Subject: Re: Ramdom Performance issue. ** Viki, As Axton noted, although it looks BIG, ignore the C112 clauses in any WHERE clause when looking at AR System logs. This also includes any C60xxx fields. All of these clauses will be at the end of the query. They may be large (if you are in a lot of groups). They do not affect the overall performance of the system. So, you get down in this case to the very simply query Axton has indicated. This is an UNQUALIFIED search of the given table (T28). First, do you have disallow unqualified queries server option set. This command would indicate you do not have this set. It is recommended that you do to control this type of unqualified query from accidentally happening. If you turn on SQL logging at the AR System level, it will tell you a lot of information. What login issued the command When From what type of client (the client type can tell you it came from the mid-tier or a specific utility or if 0, it generally means from a custom API program) If you turn on various types of logs, one might include the IP address too and then you can see the user and the IP address and track back to the machine the command is coming from. All this can help track the problem. But, setting the option to disallow unqualified queries may go a long way toward helping to either stop accidents or to cause someone to come and ask you why their unqualified search stopped working Note you have a little bit of a clue about the user. They are not an Administrator and they are in all the groups that show up in the query below that field 112 is being searched for. I hope this helps, Doug Mueller From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Axton Sent: Monday, January 24, 2011 6:45 AM To: arslist@ARSLIST.ORG Subject: Re: Ramdom Performance issue. ** What is table T28? select name from arschema where schemaid = 28 / The C112 parts of the query have to do with the row level locking that is set up on T28. Also, what method are you using to identify this as a cause or indicator of your performance problem? Axton On Mon, Jan 24, 2011 at 3:13 AM, Viki_kulkarni vk0073...@techmahindra.commailto:vk0073...@techmahindra.com wrote: hi all, since couple of weeks we are facing a strange issue. The AR Server just peaks at 100% and hangs. We see that there is a heavy query running on DB which looks like this SELECT T28.C1,C600011000,C536870984,C536870913,C900106001,C901050057,C536871019,C900200400,C536870958,C536870950,C900170325,C536870935,C90013,C536870929,C536870931,C536870914,C536871018,C536870938,C65000,C536870952,C536871025,C536871038,C53690,C536870912,C7,C900040206,C901092014,C900110076,C536870987,C901170021,C536870957 FROM T28 WHERE (((T28.C112 LIKE :SYS_B_00) OR ((T28.C112 LIKE :SYS_B_01) OR ((T28.C112 LIKE :SYS_B_02) OR ((T28.C112 LIKE :SYS_B_03) OR ((T28.C112 LIKE :SYS_B_04) OR ((T28.C112 LIKE :SYS_B_05) OR ((T28.C112 LIKE :SYS_B_06) OR ((T28.C112 LIKE :SYS_B_07) OR ((T28.C112 LIKE :SYS_B_08) OR ((T28.C112 LIKE :SYS_B_09) OR ((T28.C112 LIKE :SYS_B_10) OR ((T28.C112 LIKE :SYS_B_11) OR ((T28.C112 LIKE :SYS_B_12) OR ((T28.C112 LIKE :SYS_B_13) OR ((T28.C112 LIKE :SYS_B_14) OR ((T28.C112 LIKE :SYS_B_15) OR ((T28.C112 LIKE :SYS_B_16) OR ((T28.C112 LIKE :SYS_B_17) OR ((T28.C112 LIKE :SYS_B_18) OR ((T28.C112 LIKE :SYS_B_19) OR ((T28.C112 LIKE :SYS_B_20) OR ((T28.C112 LIKE :SYS_B_21) OR ((T28.C112 LIKE :SYS_B_22) OR ((T28.C112 LIKE :SYS_B_23) OR ((T28.C112 LIKE :SYS_B_24) OR ((T28.C112 LIKE :SYS_B_25) OR ((T28.C112 LIKE :SYS_B_26) OR ((T28.C112 LIKE :SYS_B_27) OR ((T28.C112 LIKE :SYS_B_28) OR ((T28.C112 LIKE :SYS_B_29) OR ((T28.C112 LIKE :SYS_B_30) OR ((T28.C112 LIKE :SYS_B_31) OR ((T28.C112 LIKE :SYS_B_32) OR ((T28.C112 LIKE :SYS_B_33) OR ((T28.C112 LIKE :SYS_B_34) OR ((T28.C112 LIKE :SYS_B_35) OR ((T28.C112 LIKE :SYS_B_36) OR ((T28.C112 LIKE :SYS_B_37) OR ((T28.C112 LIKE :SYS_B_38) OR ((T28.C112 LIKE :SYS_B_39) OR ((T28.C112 LIKE :SYS_B_40) OR ((T28.C112 LIKE :SYS_B_41) OR ((T28.C112 LIKE :SYS_B_42) OR ((T28.C112 LIKE :SYS_B_43) OR ((T28.C112 LIKE :SYS_B_44) OR ((T28.C112 LIKE :SYS_B_45) OR ((T28.C112 LIKE :SYS_B_46) OR ((T28.C112 LIKE :SYS_B_47) OR ((T28.C112 LIKE :SYS_B_48) OR ((T28.C112 LIKE :SYS_B_49) OR ((T28.C112 LIKE :SYS_B_50) OR ((T28.C112 LIKE :SYS_B_51) OR ((T28.C112 LIKE :SYS_B_52) OR ((T28.C112 LIKE :SYS_B_53) OR ((T28.C112 LIKE :SYS_B_54) OR ((T28.C112 LIKE :SYS_B_55) OR ((T28.C112 LIKE :SYS_B_56) OR ((T28.C112 LIKE
Re: External Database for people record creation.
If you want to import the people record for just once, Data Management Tool would be a better option. But, if the people records to needs to be populated on some kind of scheduled basis, you should be doing it using remedy workflow. That would involve bringing the data from Oracle database to some staging form using AIE and then validating the data. Once the data is validated, you can push it to CTM:People form. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of John Doe Sent: Thursday, October 07, 2010 12:04 PM To: arslist@ARSLIST.ORG Subject: External Database for people record creation. ** Looking for advice. I have an external oracle database. Which is a distillation of our active directory database. I'd like to connect to this database and create people and user records from it. What is the best way to go about this. My thoughts go to AIE to the CTM:LoadPeople form or possibly use the data mgmt tool. Thank you in advance for the help. _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: 4.6 million records in people form
I think SQL Server allows 8KB per row. So, space should not be a big issue. However, you need to check with your DBA. If 4.6 million are customers and not the user, I would suggest creating a separate table for them instead of storing them in CTM:People form. Because, CTM:people is referenced with so many tables and workflow and that might create the performance issue. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe Martin D'Souza Sent: Thursday, October 07, 2010 12:44 PM To: arslist@ARSLIST.ORG Subject: Re: 4.6 million records in people form ** In ITSM 7.1 I have come across no known bugs with querying the CTM:People form from anywhere within the application, either through workflow, or other queries designed... So the question is more about any customization that you may have done that may retrieve information from the CTM:People form to be set somewhere. Make sure that the searches that are issued on such customization, are using appropriate indexes, and if not, rebuild those qualifications if possible around existing indexes, or create new indexes as appropriate to support those queries.. Respect this one cardinal rule, and you should be ok.. Joe From: Mr. Teemailto:mrtee...@gmail.com Sent: Thursday, October 07, 2010 4:47 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: 4.6 million records in people form ** Hi ARSLIST, I am thinking about importing all customers (4.6 million) into Remedy (ITSM 7.1). The customers should not be users but only people. There will only be about 300 users and that is no problem. The Remedy applications and database is running on separate servers. The DB server is MS SQL 2005. Do anybody have any experience about setup and performance with this amount of records in the people form ? Lookup in ITSM applications (Customer on incident form, Requester on Change form etc) ? Thanks in advance. Kind regards Mr. Tee _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Working lists disappearing
We are using ARS 7.5 Patch 6 and BMC Remedy Developer Studio Version: 7.5.00 Patch 003. We don't have issues with working lists. Thanks, Wirasat From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe Martin D'Souza Sent: Friday, September 24, 2010 10:58 AM To: arslist@ARSLIST.ORG Subject: Re: Working lists disappearing ** Anne, If it doesn't list the patch number, it is probably the first shipping version of 7.5. That version had lots of bugs, although I do think the Working List did work.. I have seen a lot of problems of the previous versions resolved by Patch 6. I am pretty sure it may have introduced new problems but I'd suggest go with the latest and the greatest. Joe From: Ramey, Annemailto:anne.ra...@nc.gov Sent: Friday, September 24, 2010 9:07 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: Working lists disappearing ** Well, I have admin priviledges on my box, my developer tool is local, and I hadn't even logged out and back in when they went away. I'm using 7.5, it doesn't list a patch number. I can upgrade of course, but I think I'm going to keep a separate list of what was in my working list elsewhere as well. It sounds inherently unreliable. Anne Ramey *** E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and may be disclosed to third parties only by an authorized State Official. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe Martin D'Souza Sent: Thursday, September 23, 2010 6:08 PM To: arslist@ARSLIST.ORG Subject: Re: Working lists disappearing ** Get into the habit to store the XML file that has the work list information on a flash drive. I do that so even if the network drive that it is stored on crashes, you still can have it with you.. I keep a modified copy of the XML file every time I make a change to the work list.. Never hurts.. Joe From: Pierson, Shawnmailto:shawn.pier...@sug.com Sent: Thursday, September 23, 2010 5:46 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: Working lists disappearing ** This happens to me too, but I suspect that it is related to my working lists being stored in a directory that is part of my roaming profile on the network. It causes lots of issues, so I just assumed that the issue with my working lists was related and moved on. It's a shame too, because it would be great to have the same working lists available on any machine I log in to. Thanks, Shawn Pierson Remedy Developer | Southern Union From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Ramey, Anne Sent: Thursday, September 23, 2010 3:31 PM To: arslist@ARSLIST.ORG Subject: Working lists disappearing ** I've seen someone had this issue, but no fix was listed. I added a new server to my login list, logged into it, then logged back into server A and all of my working lists were gone! Is this normal behavior? Can you not rely on the working lists to remain? Anne Ramey *** E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and may be disclosed to third parties only by an authorized State Official. _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: AR System Email server
You may want to check stderr.log file under AREmail/logs directory as well. Wirasat From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kathy Morris Sent: Tuesday, September 14, 2010 12:37 PM To: arslist@ARSLIST.ORG Subject: AR System Email server ** Hi, If an email shows as SENT in the AR System Email Messages, and I do not see an error in the Email error forms, is it safe to assume the email was sent? I have a user stating they did not receive an email from Remedy. _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Operational Categorization setup
Check your company access in people form. If you have unrestricted access, try to add the company that is related to Change Management Operational Categorization and see if it makes any difference. Thanks, Wirasat From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Rick Cook Sent: Thursday, August 19, 2010 10:44 AM To: arslist@ARSLIST.ORG Subject: Operational Categorization setup ** I am pulling what's left of my hair out on this one. We are on ARS/ITSM 7.5, patched up. There are some Operational Categorizations that were imported for Incident Management, and I want to enable some of the same ones to be visible in Change Management. I should be able to search for those records in the Operational Catalog Relationship form, ensure I have the correct Company and that the records are enabled, check the box for Change Management, and have them show up, right? Am I missing something? It doesn't seem to have any effect. Rick _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Hammingbird SearchServer Installation
We have installed Hummingbird server on appserver on Windows 2003 appserver with no problems. Also, on other installations, we have installed RKM and Hummingbird sever on mid-tier on a different environment. So,its really up to you where you want to install it. Thanks, Wirasat -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Moe Abdelaziz Sent: Sunday, August 15, 2010 12:34 PM To: arslist@ARSLIST.ORG Subject: Hammingbird SearchServer Installation Are there any installation documenatations for the Hammingbird SearchServer 6.1? Current environment: Win2k3 SP2 Appserver Win2k3 SP2 SQL 2005 DBserver Win2k3 SP2 with Tomcat 6.0 Webserver mid-tier Should hammingbird be installed on the webserver or the appserver? I am planning on installing RKM and SRM on the webserver mid-tier environment. Please if you have any installation docs or steps to follow to properly install Hammingbird, let me know. Thanks. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Join Form Question
Yes. Join form is just a view of Regular forms. It does not store any data. Regards, Wirasat -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Sanford, Claire Sent: Thursday, August 05, 2010 12:13 PM To: arslist@ARSLIST.ORG Subject: Join Form Question Silly Newbie Type Question... My brain is fried! If I delete a Join form, my data in the regular forms is still intact and ok Right? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: disable auto assignement
Go to Application Administration Console - Custom Configuration - Problem Management - Advanced option - Rules Disable the Assignment Engine Integration. Thanks, Wirasat From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Pavan Kumar Sent: Wednesday, August 04, 2010 8:49 AM To: arslist@ARSLIST.ORG Subject: disable auto assignement ** Hi Remedy Experts, In my problem management if I left the assignee empty it's picking random name from the support group, can anyone please help me to disable this auto assignement. Thanks Regards, Pavan Kumar CONFIDENTIALITY CAUTION/DISCLAIMER Transmission of this email is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any action in reliance upon this information by the person or entity other than the intended recipient is prohibited and would be at their risk and responsibility. While Adea takes adequate protection against viruses, neither the sender of this mail nor Adea accepts any responsibility or liability for interception, corruption, delay or any virus introduced by this e-mail or any attachment. If you are not the intended recipient or if you have received this in error, please delete this email with attachments, if any, and inform the sender. Thank you for your understanding and co-operation _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: disable auto assignement
This is only going to disable in problem Management. Change and Incident have their own settings for Assignment Engine Integration. You may want to verify their settings as well. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Pavan Kumar Sent: Wednesday, August 04, 2010 9:21 AM To: arslist@ARSLIST.ORG Subject: Re: disable auto assignement ** Thanks for the response, will this just disable auto assignee, or will it disable some thing else. Because we have this enabled for change incidents as well, but the system never picked some one randomly and assigned to support assignee. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Siddiqi, Wirasat (Contractor) Sent: Wednesday, August 04, 2010 6:33 PM To: arslist@ARSLIST.ORG Subject: Re: disable auto assignement Go to Application Administration Console - Custom Configuration - Problem Management - Advanced option - Rules Disable the Assignment Engine Integration. Thanks, Wirasat From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Pavan Kumar Sent: Wednesday, August 04, 2010 8:49 AM To: arslist@ARSLIST.ORG Subject: disable auto assignement ** Hi Remedy Experts, In my problem management if I left the assignee empty it's picking random name from the support group, can anyone please help me to disable this auto assignement. Thanks Regards, Pavan Kumar CONFIDENTIALITY CAUTION/DISCLAIMER Transmission of this email is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any action in reliance upon this information by the person or entity other than the intended recipient is prohibited and would be at their risk and responsibility. While Adea takes adequate protection against viruses, neither the sender of this mail nor Adea accepts any responsibility or liability for interception, corruption, delay or any virus introduced by this e-mail or any attachment. If you are not the intended recipient or if you have received this in error, please delete this email with attachments, if any, and inform the sender. Thank you for your understanding and co-operation _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ CONFIDENTIALITY CAUTION/DISCLAIMER Transmission of this email is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any action in reliance upon this information by the person or entity other than the intended recipient is prohibited and would be at their risk and responsibility. While Adea takes adequate protection against viruses, neither the sender of this mail nor Adea accepts any responsibility or liability for interception, corruption, delay or any virus introduced by this e-mail or any attachment. If you are not the intended recipient or if you have received this in error, please delete this email with attachments, if any, and inform the sender. Thank you for your understanding and co-operation _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are