Re: Trying to build a view form to a Remote Oracle DB from a Remedy SQL DB
Hi Gary, Jean-Louis is correct. If my memory serves me well, I have also had to do it like that in the past. Unfortunately, if you want to do this on DB level, the only other alternative in this case, would be to duplicate the data using, for example, a stored procedure, but that is not ideal nor recommended. Best Regards, Theo Sent from my Black/Silver Personal Computer Try not to become a person of success, but a person of value. - Albert Einstein -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Gary Dries Sent: 06 March 2012 20:23 To: arslist@ARSLIST.ORG Subject: Re: Trying to build a view form to a Remote Oracle DB from a Remedy SQL DB Thanks for the insight, this is definitely an option. The main concern with this solution is that I am not the SQL DBA and do not have and admin access to the DB or application servers, so I am now dependant on 3 parties to help support this process (myself, Oracle DBA, SQL DBA), plus it adds another point of failure. My main goal was to control as much of the process at the application level and let ARS do what it is designed to do. I have built a dblink and a view form from remedy to a remote db in the past, about 6 years ago, but in a different configuration ARS on Oracle and the external db on SQL and that worked with any issues at all. The difference was not only the order of the db servers but I also had full Server Admin rights, where I am at now, I do not have the elevated privileges. On 3/6/12, Reiser, John J john.j.rei...@lmco.com wrote: Gary, Jean-Louis is correct. I am trying the same thing on ARS 7.6.03. Had the DBA create a Linked Server on MS SQL using DTS. I created a view in the ARSystem database using MS SQL Server management Studio. SELECT CAST(CONTROL_UNIQUE_ID AS int) AS UNIQUE_ID, CAST(CONTROL_NUM AS varchar) AS Control_Num, CAST(PLANT_CODE AS varchar) AS Plant_Code FROM LINKNAME..DATABASENAME.TABLENAME AS TABLENAME_1 I could then create an ARSystem View Form but that is as far as I got. I can query either view in MS SQL Studio and get results but not from the WUT running a search on the View Form. I even tried a Direct SQL set fields action with no luck. I'll post more if I get something working. --- John J. Reiser Remedy Developer/Administrator Senior Software Development Analyst Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Halleux, Jean-Louis Sent: Tuesday, March 06, 2012 11:04 AM To: arslist@ARSLIST.ORG Subject: EXTERNAL: Re: Trying to build a view form to a Remote Oracle DB from a Remedy SQL DB Hi Gary, According to my experience, creating a view form on a db link does not work well. What I usually do in that case is creating an SQL view, in the DB direclty, that will use the db link; and then create the view form on the SQL view. Best regards, Jean-Louis Halleux -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Gary Dries Sent: mardi 6 mars 2012 16:44 To: arslist@ARSLIST.ORG Subject: Trying to build a view form to a Remote Oracle DB from a Remedy SQL DB I have a need to build a view form to a table on a Remote Oracle DB 10g from our ARS 7.1.06 running sql 2005 DB server Has anyone been sucessful doing this? We created the DBlink between the 2 dbs and we are able to connect from the sql server via other tools like odbc or sql plus and see the table on oracle db. ARAdmin is the oracle table owner and has read/write access, (I am still scptical) attempted to create the view using the parameter LINK.DATABASE.TABLEOWNER.TABLE and I always recieve the error in the Admin tool Failure during SQL operation to the database : CMS_TEST.CMSTEST.ARADMIN.REMEDY_CASES (ARERR 552) SQL Log posts this error *** ERROR *** Invalid use of schema or catalog for OLE DB provider MSDASQL for linked server CMS_TEST. A four-part name was supplied, but the provider does not expose the necessary interfaces to use a catalog or schema. (SQL Server 7312) I have worked with BMC Support and they back up all of our configuration and settings in the ar.cfg file, and all other system settings. Any Ideas? -- Gary Dries OSSNMS / Sr. Remedy Developer T-Mobile USA Office (972) 464-3235 __ __ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are __ _ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Re: Trying to build a view form to a Remote Oracle DB from a Remedy SQL DB
Hi Gary, How do you do the db-link, are you using linked servers going from SQL to the remote oracle table? Regards Francois -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Theo Fondse Sent: 07 March 2012 10:33 AM To: arslist@ARSLIST.ORG Subject: Re: Trying to build a view form to a Remote Oracle DB from a Remedy SQL DB Hi Gary, Jean-Louis is correct. If my memory serves me well, I have also had to do it like that in the past. Unfortunately, if you want to do this on DB level, the only other alternative in this case, would be to duplicate the data using, for example, a stored procedure, but that is not ideal nor recommended. Best Regards, Theo Sent from my Black/Silver Personal Computer Try not to become a person of success, but a person of value. - Albert Einstein -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Gary Dries Sent: 06 March 2012 20:23 To: arslist@ARSLIST.ORG Subject: Re: Trying to build a view form to a Remote Oracle DB from a Remedy SQL DB Thanks for the insight, this is definitely an option. The main concern with this solution is that I am not the SQL DBA and do not have and admin access to the DB or application servers, so I am now dependant on 3 parties to help support this process (myself, Oracle DBA, SQL DBA), plus it adds another point of failure. My main goal was to control as much of the process at the application level and let ARS do what it is designed to do. I have built a dblink and a view form from remedy to a remote db in the past, about 6 years ago, but in a different configuration ARS on Oracle and the external db on SQL and that worked with any issues at all. The difference was not only the order of the db servers but I also had full Server Admin rights, where I am at now, I do not have the elevated privileges. On 3/6/12, Reiser, John J john.j.rei...@lmco.com wrote: Gary, Jean-Louis is correct. I am trying the same thing on ARS 7.6.03. Had the DBA create a Linked Server on MS SQL using DTS. I created a view in the ARSystem database using MS SQL Server management Studio. SELECT CAST(CONTROL_UNIQUE_ID AS int) AS UNIQUE_ID, CAST(CONTROL_NUM AS varchar) AS Control_Num, CAST(PLANT_CODE AS varchar) AS Plant_Code FROM LINKNAME..DATABASENAME.TABLENAME AS TABLENAME_1 I could then create an ARSystem View Form but that is as far as I got. I can query either view in MS SQL Studio and get results but not from the WUT running a search on the View Form. I even tried a Direct SQL set fields action with no luck. I'll post more if I get something working. --- John J. Reiser Remedy Developer/Administrator Senior Software Development Analyst Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Halleux, Jean-Louis Sent: Tuesday, March 06, 2012 11:04 AM To: arslist@ARSLIST.ORG Subject: EXTERNAL: Re: Trying to build a view form to a Remote Oracle DB from a Remedy SQL DB Hi Gary, According to my experience, creating a view form on a db link does not work well. What I usually do in that case is creating an SQL view, in the DB direclty, that will use the db link; and then create the view form on the SQL view. Best regards, Jean-Louis Halleux -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Gary Dries Sent: mardi 6 mars 2012 16:44 To: arslist@ARSLIST.ORG Subject: Trying to build a view form to a Remote Oracle DB from a Remedy SQL DB I have a need to build a view form to a table on a Remote Oracle DB 10g from our ARS 7.1.06 running sql 2005 DB server Has anyone been sucessful doing this? We created the DBlink between the 2 dbs and we are able to connect from the sql server via other tools like odbc or sql plus and see the table on oracle db. ARAdmin is the oracle table owner and has read/write access, (I am still scptical) attempted to create the view using the parameter LINK.DATABASE.TABLEOWNER.TABLE and I always recieve the error in the Admin tool Failure during SQL operation to the database : CMS_TEST.CMSTEST.ARADMIN.REMEDY_CASES (ARERR 552) SQL Log posts this error *** ERROR *** Invalid use of schema or catalog for OLE DB provider MSDASQL for linked server CMS_TEST. A four-part name was supplied, but the provider does not expose the necessary interfaces to use a catalog or schema. (SQL Server 7312) I have worked with BMC Support and they back up all of our configuration and settings in the ar.cfg file, and all other system settings. Any Ideas? -- Gary Dries OSSNMS / Sr. Remedy Developer T-Mobile USA
Fixed/Floating Licenses, chg after upgrade?
Hello all, Over spring break I will be upgrading to ARS 7.1 patch 11. I've looked thru the docs, white papers, etc, but I've not found the answer I'm looking for in the mounds of information available. I want to know if licenses will be handled differently in ARS 7.1. We're currently on ARS 7.01. The reason I ask is we have an inquiry form for users and it logs in with a fixed license that's shared across the school district. We obviously don't have enough coin to buy a license for everyone for a form that's infrequently used. I've set up the form to log out the shared user id and even with the mac address tracking, it works well nearly all of the time. I'm not anxious to have to find another solution. Also, are there any show stoppers I should watch out for going from ARS 7.01 to 7.1? I've tested on a puny development box with 3 fixed licenses and so far so good. But, I figured I should tap the collective knowledge here before I impact the whole district. The production backend is Ora10g on linux and a Windows 2003 server running Apache Tomcat 5.0.27 and Crystal XI for the application server. Thanks! Carina ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Fixed/Floating Licenses, chg after upgrade?
To correct way to share a license between a lot of users that use it infrequently is to use floating licenses. Jose M. Huerta Project Manager** Movil: 661 665 088 Telf.: 971 75 03 24 Fax: 971 75 07 94 http://www.sm2baleares.es/ SM2 Baleares S.A. C/Rita Levi Edificio SM2 Parc Bit 07121 Palma de Mallorca http://es-es.facebook.com/pages/SM2-Baleares/158608627954 http://twitter.com/#!/SM2Baleares http://www.linkedin.com/company/sm2-baleares La información contenida en este mensaje de correo electrónico es confidencial. La misma, es enviada con la intención de que únicamente sea leída por la persona(s) a la(s) que va dirigida. El acceso a este mensaje por otras personas no está autorizado, por lo que en tal caso, le rogamos que nos lo comunique por la misma vía, se abstenga de realizar copias del mensaje o remitirlo o entregarlo a otra persona y proceda a borrarlo de inmediato. P Por favor, no imprima este mensaje ni sus documentos adjuntos si no es necesario. On Wed, Mar 7, 2012 at 15:03, Carina Burns carina.bu...@risd.org wrote: Hello all, Over spring break I will be upgrading to ARS 7.1 patch 11. I've looked thru the docs, white papers, etc, but I've not found the answer I'm looking for in the mounds of information available. I want to know if licenses will be handled differently in ARS 7.1. We're currently on ARS 7.01. The reason I ask is we have an inquiry form for users and it logs in with a fixed license that's shared across the school district. We obviously don't have enough coin to buy a license for everyone for a form that's infrequently used. I've set up the form to log out the shared user id and even with the mac address tracking, it works well nearly all of the time. I'm not anxious to have to find another solution. Also, are there any show stoppers I should watch out for going from ARS 7.01 to 7.1? I've tested on a puny development box with 3 fixed licenses and so far so good. But, I figured I should tap the collective knowledge here before I impact the whole district. The production backend is Ora10g on linux and a Windows 2003 server running Apache Tomcat 5.0.27 and Crystal XI for the application server. Thanks! Carina ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are image002.jpgimage004.jpgimage001.jpgimage003.jpg
Re: Fixed/Floating Licenses, chg after upgrade?
Carina, I'm not sure what you mean by 'handled differently'I know at some point around that area of versions licenses started being stored in the DB instead of in a file on the file systemand while it didn't change the need to buy licenses, it changed by the fact that you no longer need a license KEY for anything other than the Server itself. Regarding your usage...as you know, Fixed licenses (other than admin), can't be logged on from more than one machine at a time...so unless you process is making modifications, you could turn that process into a read-restricted license, which doesn't suffer from the same problemor you could even allocate a single Floating license to a pool, grant only these users access to that pool, and give them all their own ID's, but only one could make changes to the system at a time (that would allow for better tracking than mac id) But in short...I don't know of any changes between those two versions that would stop your current efforts. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Carina Burns Sent: Wednesday, March 07, 2012 7:04 AM To: arslist@ARSLIST.ORG Subject: Fixed/Floating Licenses, chg after upgrade? Hello all, Over spring break I will be upgrading to ARS 7.1 patch 11. I've looked thru the docs, white papers, etc, but I've not found the answer I'm looking for in the mounds of information available. I want to know if licenses will be handled differently in ARS 7.1. We're currently on ARS 7.01. The reason I ask is we have an inquiry form for users and it logs in with a fixed license that's shared across the school district. We obviously don't have enough coin to buy a license for everyone for a form that's infrequently used. I've set up the form to log out the shared user id and even with the mac address tracking, it works well nearly all of the time. I'm not anxious to have to find another solution. Also, are there any show stoppers I should watch out for going from ARS 7.01 to 7.1? I've tested on a puny development box with 3 fixed licenses and so far so good. But, I figured I should tap the collective knowledge here before I impact the whole district. The production backend is Ora10g on linux and a Windows 2003 server running Apache Tomcat 5.0.27 and Crystal XI for the application server. Thanks! Carina ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Trying to build a view form to a Remote Oracle DB from a Remedy SQL DB
Also make sure all your pre-requisites are met. If I recall right, if there is no character field that is between 5 to 15 characters in length, that is uniquely identifiable, the creation of a view form fails.. Joe -Original Message- From: Francois Seegers Sent: Wednesday, March 07, 2012 3:44 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Trying to build a view form to a Remote Oracle DB from a Remedy SQL DB Hi Gary, How do you do the db-link, are you using linked servers going from SQL to the remote oracle table? Regards Francois -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Theo Fondse Sent: 07 March 2012 10:33 AM To: arslist@ARSLIST.ORG Subject: Re: Trying to build a view form to a Remote Oracle DB from a Remedy SQL DB Hi Gary, Jean-Louis is correct. If my memory serves me well, I have also had to do it like that in the past. Unfortunately, if you want to do this on DB level, the only other alternative in this case, would be to duplicate the data using, for example, a stored procedure, but that is not ideal nor recommended. Best Regards, Theo Sent from my Black/Silver Personal Computer Try not to become a person of success, but a person of value. - Albert Einstein -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Gary Dries Sent: 06 March 2012 20:23 To: arslist@ARSLIST.ORG Subject: Re: Trying to build a view form to a Remote Oracle DB from a Remedy SQL DB Thanks for the insight, this is definitely an option. The main concern with this solution is that I am not the SQL DBA and do not have and admin access to the DB or application servers, so I am now dependant on 3 parties to help support this process (myself, Oracle DBA, SQL DBA), plus it adds another point of failure. My main goal was to control as much of the process at the application level and let ARS do what it is designed to do. I have built a dblink and a view form from remedy to a remote db in the past, about 6 years ago, but in a different configuration ARS on Oracle and the external db on SQL and that worked with any issues at all. The difference was not only the order of the db servers but I also had full Server Admin rights, where I am at now, I do not have the elevated privileges. On 3/6/12, Reiser, John J john.j.rei...@lmco.com wrote: Gary, Jean-Louis is correct. I am trying the same thing on ARS 7.6.03. Had the DBA create a Linked Server on MS SQL using DTS. I created a view in the ARSystem database using MS SQL Server management Studio. SELECT CAST(CONTROL_UNIQUE_ID AS int) AS UNIQUE_ID, CAST(CONTROL_NUM AS varchar) AS Control_Num, CAST(PLANT_CODE AS varchar) AS Plant_Code FROM LINKNAME..DATABASENAME.TABLENAME AS TABLENAME_1 I could then create an ARSystem View Form but that is as far as I got. I can query either view in MS SQL Studio and get results but not from the WUT running a search on the View Form. I even tried a Direct SQL set fields action with no luck. I'll post more if I get something working. --- John J. Reiser Remedy Developer/Administrator Senior Software Development Analyst Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Halleux, Jean-Louis Sent: Tuesday, March 06, 2012 11:04 AM To: arslist@ARSLIST.ORG Subject: EXTERNAL: Re: Trying to build a view form to a Remote Oracle DB from a Remedy SQL DB Hi Gary, According to my experience, creating a view form on a db link does not work well. What I usually do in that case is creating an SQL view, in the DB direclty, that will use the db link; and then create the view form on the SQL view. Best regards, Jean-Louis Halleux -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Gary Dries Sent: mardi 6 mars 2012 16:44 To: arslist@ARSLIST.ORG Subject: Trying to build a view form to a Remote Oracle DB from a Remedy SQL DB I have a need to build a view form to a table on a Remote Oracle DB 10g from our ARS 7.1.06 running sql 2005 DB server Has anyone been sucessful doing this? We created the DBlink between the 2 dbs and we are able to connect from the sql server via other tools like odbc or sql plus and see the table on oracle db. ARAdmin is the oracle table owner and has read/write access, (I am still scptical) attempted to create the view using the parameter LINK.DATABASE.TABLEOWNER.TABLE and I always recieve the error in the Admin tool Failure during SQL operation to the database : CMS_TEST.CMSTEST.ARADMIN.REMEDY_CASES (ARERR 552) SQL Log posts this error *** ERROR *** Invalid use of
Re: Fixed/Floating Licenses, chg after upgrade?
Carina, What you really should be doing is setting up the server to allow guest users. Depending on how the permissions on the form/fields are set, they should be able to at a minimum search their own tickets. When permissions are set correctly on the forms, a guest user can create a record with a read license. If the server is set to Submitter Mode Locked and the field permissions are set correctly, the submitter can also update fields with just a read license. With your process, is it really a Fixed or is it a Read Restricted? If it's a Fixed it's a violation of the license agreement. Dave -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Carina Burns Sent: Wednesday, March 07, 2012 9:04 AM To: arslist@ARSLIST.ORG Subject: Fixed/Floating Licenses, chg after upgrade? Hello all, Over spring break I will be upgrading to ARS 7.1 patch 11. I've looked thru the docs, white papers, etc, but I've not found the answer I'm looking for in the mounds of information available. I want to know if licenses will be handled differently in ARS 7.1. We're currently on ARS 7.01. The reason I ask is we have an inquiry form for users and it logs in with a fixed license that's shared across the school district. We obviously don't have enough coin to buy a license for everyone for a form that's infrequently used. I've set up the form to log out the shared user id and even with the mac address tracking, it works well nearly all of the time. I'm not anxious to have to find another solution. Also, are there any show stoppers I should watch out for going from ARS 7.01 to 7.1? I've tested on a puny development box with 3 fixed licenses and so far so good. But, I figured I should tap the collective knowledge here before I impact the whole district. The production backend is Ora10g on linux and a Windows 2003 server running Apache Tomcat 5.0.27 and Crystal XI for the application server. Thanks! Carina ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Signal 11 error
Hi all, We just had this error message on our AR Server and I have a few question about it if anyone can help please. 1. Is this a memory error that has caused arserverd to crash as I cannot find any core dumps? 2. Is Signal 11 an application generated error, on an AIX error? 3. What is the relevance of the Form:TMS:Task value 4. We had API/FILTER/SQL logging on at the time, what should I be looking for to point me to the cause? Wed Mar 7 13:09:18 2012: AR System server terminated when a signal/exception was received by the server (ARNOTE 20) Signal: 11 Thread Id: 8759 Version: 7.6.04 SP1 201104191058 Apr 27 2011 20:10:00 ServerName: Database: SQL -- Oracle Hardware: 00F6282E4C00 OS: AIX 6.1 RPC Id: 460531 RPC Call: 73 (GLEWF) RPC Queue: 390635 Client: User dan.henry from Mid-tier (protocol 18) at IP address 10.161.64.162 Form: TMS:Task Logging On: Alert API Escalation Filter SQL User FTIndexer Thread ServerGroup Stacks: Stacks: I have discussed this with BMC and one possible cause is our Filter-Max-Stack is set to '1'. They have asked us to reduce it to '25'. does anyone know if it will have an adverse effect on ITSM (I assume 25 is the recommended settings). AIX 6.1 ITSM 7.6.04 SP1 AR 7.6.04 SP1 Oracle 11g Thanks, Mike Worts. This email, its content and any files transmitted with it are for the personal attention of the addressee only, any other usage or access is unauthorised. It may contain information which could be confidential or privileged. If you are not the intended addressee you may not copy, disclose, circulate or use it. If you have received this email in error, please destroy it and notify the sender by email. Any representations or commitments expressed in this email are subject to contract. Although we use reasonable endeavours to virus scan all sent emails, it is the responsibility of the recipient to ensure that they are virus free and we advise you to carry out your own virus check before opening any attachments. We cannot accept liability for any damage sustained as a result of software viruses. We reserve the right to monitor email communications through our networks. Arqiva Limited. Registered office: Crawley Court, Winchester, Hampshire SO21 2QA United Kingdom Registered in England and Wales number 2487597 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Adv.: Doesn't an integrated project portfolio mgt. system make more sense?
Good morning, It has been what seems like a very long time since we have advertised ActionProgram Manager Plus, our Remedy-based process and project portfolio management system, on the ARSList and felt it was time to bring you up to date on all the work we have been doing. The answer is a lot. APM Plus has a great deal of functionality. It can run standalone but when its complete project life-cycle functionality is added onto a typical ITSM implementation (or home-grown applications - it doesn't matter to us), the result is a completely integrated demand management system. This is the easiest, fastest, and least expensive way to get to a demand management system because the need for the costly and time-consuming integration project is eliminated. APM Plus has also been added to Change Management for a more complete change management application. APM Plus can be used for managing all types of projects: application development projects and operations projects, bug reporting and scheduled and unscheduled asset outages, cyber projects that are launched automatically from an event management system and projects that are launched from your service catalog. It gives you a central repository of work and approval processes, and both proposed projects and active projects. Because it runs on the AR System, projects can be launched from changes, and changes can be launched from project tasks. Projects can be launched from Asset Management or the Service Catalog. With APM Plus's bi-directional interface with MS Project, project plans can be created in MS Project and imported into APM Plus. Or you can go the other way too. APM Plus's unique detailed resource management charts are based on real project schedules. Because you are starting with a project plan and have the dates when each task is supposed to occur, when resources are assigned to the tasks, you can see how busy they are at the time. As things occur during the project, the dates are automatically recalculated and the user assignments are moved automatically. Because it includes true project management functionality, the charts (including Gantt charts) and reports give management the metrics they need to actually manage projects. Because it includes time tracking and expense tracking functionality against all Remedy tasks, management can see the cost of each service request. APM Plus is a really robust application which fills a lot of gaps. If anyone is interested in seeing a web demo or learning more about APM Plus, please contact me off the ARSList so we can schedule a time. We like showing it. If you would like to check out our most recent white papers and other marketing documents, please check out our home page at www.projectremedies.com. Thanks. Stan Feinstein w. 310-230-1722. c. 310-428-5748. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Signal 11 error
Mike, They are probably on the wrong track. 25 used to be the recommended max a few versions ago. 1 on the current version and recommended configurations, is not a very high number. Is there anything written to the System or Application Event log at the time of that error? Joe From: Mike Worts Sent: Wednesday, March 07, 2012 9:29 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Signal 11 error ** Hi all, We just had this error message on our AR Server and I have a few question about it if anyone can help please. 1. Is this a memory error that has caused arserverd to crash as I cannot find any core dumps? 2. Is Signal 11 an application generated error, on an AIX error? 3. What is the relevance of the Form:TMS:Task value 4. We had API/FILTER/SQL logging on at the time, what should I be looking for to point me to the cause? Wed Mar 7 13:09:18 2012: AR System server terminated when a signal/exception was received by the server (ARNOTE 20) Signal: 11 Thread Id: 8759 Version: 7.6.04 SP1 201104191058 Apr 27 2011 20:10:00 ServerName: Database: SQL -- Oracle Hardware: 00F6282E4C00 OS: AIX 6.1 RPC Id: 460531 RPC Call: 73 (GLEWF) RPC Queue: 390635 Client: User dan.henry from Mid-tier (protocol 18) at IP address 10.161.64.162 Form: TMS:Task Logging On: Alert API Escalation Filter SQL User FTIndexer Thread ServerGroup Stacks: Stacks: I have discussed this with BMC and one possible cause is our Filter-Max-Stack is set to '1'. They have asked us to reduce it to '25'. does anyone know if it will have an adverse effect on ITSM (I assume 25 is the recommended settings). AIX 6.1 ITSM 7.6.04 SP1 AR 7.6.04 SP1 Oracle 11g Thanks, Mike Worts. This email, its content and any files transmitted with it are for the personal attention of the addressee only, any other usage or access is unauthorised. It may contain information which could be confidential or privileged. If you are not the intended addressee you may not copy, disclose, circulate or use it. If you have received this email in error, please destroy it and notify the sender by email. Any representations or commitments expressed in this email are subject to contract. Although we use reasonable endeavours to virus scan all sent emails, it is the responsibility of the recipient to ensure that they are virus free and we advise you to carry out your own virus check before opening any attachments. We cannot accept liability for any damage sustained as a result of software viruses. We reserve the right to monitor email communications through our networks. Arqiva Limited. Registered office: Crawley Court, Winchester, Hampshire SO21 2QA United Kingdom Registered in England and Wales number 2487597 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Signal 11 error
Is it the Maximum Filters for an Operation that is at 1 or Max Stack of Filters they want changed? Both are at the top of the Advanced tab in the Server Information of the AR System Administration Console. The ar.conf entries are (From the 7.6.04 doc) Filter-Max-Stack Maximum number of recursion levels allowed for an operation. The data modification performed by an AR_FILTER_ACTION_FIELDP filter action might trigger a second set, or level, of filters, one of which might trigger a third level of filters and so on. This option limits the number of times such recursion can happen, preventing the server crash that would occur if the recursion continued indefinitely. The default value is 25. Filter-Max-Total Maximum number of filters that the server executes for a given operation. The default value is 1. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Wednesday, March 07, 2012 8:47 AM To: arslist@ARSLIST.ORG Subject: Re: Signal 11 error ** Mike, They are probably on the wrong track. 25 used to be the recommended max a few versions ago. 1 on the current version and recommended configurations, is not a very high number. Is there anything written to the System or Application Event log at the time of that error? Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mike Worts Sent: Wednesday, March 07, 2012 8:29 AM To: arslist@ARSLIST.ORG Subject: Signal 11 error ** Hi all, We just had this error message on our AR Server and I have a few question about it if anyone can help please. 1. Is this a memory error that has caused arserverd to crash as I cannot find any core dumps? 2. Is Signal 11 an application generated error, on an AIX error? 3. What is the relevance of the Form:TMS:Task value 4. We had API/FILTER/SQL logging on at the time, what should I be looking for to point me to the cause? Wed Mar 7 13:09:18 2012: AR System server terminated when a signal/exception was received by the server (ARNOTE 20) Signal: 11 Thread Id: 8759 Version: 7.6.04 SP1 201104191058 Apr 27 2011 20:10:00 ServerName: Database: SQL -- Oracle Hardware: 00F6282E4C00 OS: AIX 6.1 RPC Id: 460531 RPC Call: 73 (GLEWF) RPC Queue: 390635 Client: User dan.henry from Mid-tier (protocol 18) at IP address 10.161.64.162 Form: TMS:Task Logging On: Alert API Escalation Filter SQL User FTIndexer Thread ServerGroup Stacks: Stacks: I have discussed this with BMC and one possible cause is our Filter-Max-Stack is set to '1'. They have asked us to reduce it to '25'. does anyone know if it will have an adverse effect on ITSM (I assume 25 is the recommended settings). AIX 6.1 ITSM 7.6.04 SP1 AR 7.6.04 SP1 Oracle 11g Thanks, Mike Worts. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Fixed/Floating Licenses, chg after upgrade?
Dave Shellman is correct. Fixed licenses are for use by the same human being across a site. If two different human beings are sharing the same purchased fixed license, that is a violation of the license agreement. I'd suggest correcting that. Floating licenses can be shared by multiple human beings on a particular instance (i.e. a server or server group). They are not site licenses, however, so floating licenses need to be purchased uniquely for each instance. In other words, if you have two instances in your environment and John Doe needs to log into both instances as a floating user, you'd need to purchase two floating licenses - one for each instance. If John Doe wasn't currently logged in, though, another person could use those licenses. There's no limit to the number of folks that can share a license - but obviously if someone's using it, others can't use it at the same time so you need to purchase enough to handle your expected concurrent load at the high-point in your day. If all the licenses are in use and an additional person logs in, they'd get a read license instead of a floating license. For fixed licenses, the license is linked with John Doe. If you have two instances in your environment and John Doe needs to log in as a fixed user, you'd only need to purchase one fixed license and could enter that license into both instances. However, no-one but John Doe could ever use that purchased license. If another person wanted to log in as a fixed user, you'd need to purchase another fixed license. Since only one person can be linked to that fixed license, they'll never have to worry about not getting a license when they log in - it is not shared and can't be used by anyone else. -David J. Easter Manager of Product Management, Remedy Platform BMC Software, Inc. The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Shellman, David Sent: Wednesday, March 07, 2012 6:29 AM To: arslist@ARSLIST.ORG Subject: Re: Fixed/Floating Licenses, chg after upgrade? Carina, What you really should be doing is setting up the server to allow guest users. Depending on how the permissions on the form/fields are set, they should be able to at a minimum search their own tickets. When permissions are set correctly on the forms, a guest user can create a record with a read license. If the server is set to Submitter Mode Locked and the field permissions are set correctly, the submitter can also update fields with just a read license. With your process, is it really a Fixed or is it a Read Restricted? If it's a Fixed it's a violation of the license agreement. Dave -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Carina Burns Sent: Wednesday, March 07, 2012 9:04 AM To: arslist@ARSLIST.ORG Subject: Fixed/Floating Licenses, chg after upgrade? Hello all, Over spring break I will be upgrading to ARS 7.1 patch 11. I've looked thru the docs, white papers, etc, but I've not found the answer I'm looking for in the mounds of information available. I want to know if licenses will be handled differently in ARS 7.1. We're currently on ARS 7.01. The reason I ask is we have an inquiry form for users and it logs in with a fixed license that's shared across the school district. We obviously don't have enough coin to buy a license for everyone for a form that's infrequently used. I've set up the form to log out the shared user id and even with the mac address tracking, it works well nearly all of the time. I'm not anxious to have to find another solution. Also, are there any show stoppers I should watch out for going from ARS 7.01 to 7.1? I've tested on a puny development box with 3 fixed licenses and so far so good. But, I figured I should tap the collective knowledge here before I impact the whole district. The production backend is Ora10g on linux and a Windows 2003 server running Apache Tomcat 5.0.27 and Crystal XI for the application server. Thanks! Carina ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com
Re: Signal 11 error
Signal 11 is a segmentation fault (man signal.h). From http://en.wikipedia.org/wiki/SIGSEGV: *Computer programs may throw SIGSEGV for improper memory handling (see segmentation fault). The operating system may inform the application of the nature of the error using the signal stack, which developers can use to debug their programs or handle errors.* * * *The default action for a program upon receiving SIGSEGV is abnormal termination. This action will end the process, but may generate a core file to aid debugging, or perform some other platform-dependent action. For example, Linux systems using the grsecurity patch may log SIGSEGV signals in order to monitor for possible intrusion attempts using buffer overflows.* * * *SIGSEGV can be caught; that is, applications can request what action they want to occur in place of the default. Examples of such action might be ignoring it, calling a function, or restoring the default action. In some circumstances, ignoring SIGSEGV results in undefined behavior.[2]* * * *An example of an application that might handle SIGSEGV is a debugger, which might check the signal stack and inform the developer of what happened, and where the program terminated.* * * *SIGSEGV is usually generated by the operating system, but users with appropriate permissions can use the kill system call or kill command (a userland program, or sometimes a shell builtin) to send the signal to a process at will.* If you have all the logs up to the crash, look in those logs for the user, RPC Queue, RPC ID, and Thread Id in the logs. The log lines will contain those identifiers. Thread Id: 8759 RPC Id: 460531 RPC Queue: 390635 Client: User dan.henry from Mid-tier (protocol 18) at IP address 10.161.64.162 You should be able to tell the OS to generate a core file when the process exits with this signal. If you can get a core file, you can look at the stack trace to get a better idea of the cause of the segmentation fault. Working with support in the past, I was informed that exhausting the stack can result in a SIGSEGV. The max stack size is typically controlled by user limits (man ulimit). $ ulimit -s 8192 $ ulimit -Hs unlimited Those numbers are in kilobytes. Axton Grams On Wed, Mar 7, 2012 at 8:29 AM, Mike Worts mike.wo...@arqiva.com wrote: ** Hi all, We just had this error message on our AR Server and I have a few question about it if anyone can help please. 1. Is this a memory error that has caused arserverd to crash as I cannot find any core dumps? 2. Is Signal 11 an application generated error, on an AIX error? 3. What is the relevance of the Form:TMS:Task value 4. We had API/FILTER/SQL logging on at the time, what should I be looking for to point me to the cause? Wed Mar 7 13:09:18 2012: AR System server terminated when a signal/exception was received by the server (ARNOTE 20) Signal: 11 Thread Id: 8759 Version: 7.6.04 SP1 201104191058 Apr 27 2011 20:10:00 ServerName: Database: SQL -- Oracle Hardware: 00F6282E4C00 OS: AIX 6.1 RPC Id: 460531 RPC Call: 73 (GLEWF) RPC Queue: 390635 Client: User dan.henry from Mid-tier (protocol 18) at IP address 10.161.64.162 Form: TMS:Task Logging On: Alert API Escalation Filter SQL User FTIndexer Thread ServerGroup Stacks: Stacks: I have discussed this with BMC and one possible cause is our Filter-Max-Stack is set to '1'. They have asked us to reduce it to '25'. does anyone know if it will have an adverse effect on ITSM (I assume 25 is the recommended settings). AIX 6.1 ITSM 7.6.04 SP1 AR 7.6.04 SP1 Oracle 11g Thanks, Mike Worts. This email, its content and any files transmitted with it are for the personal attention of the addressee only, any other usage or access is unauthorised. It may contain information which could be confidential or privileged. If you are not the intended addressee you may not copy, disclose, circulate or use it. If you have received this email in error, please destroy it and notify the sender by email. Any representations or commitments expressed in this email are subject to contract. Although we use reasonable endeavours to virus scan all sent emails, it is the responsibility of the recipient to ensure that they are virus free and we advise you to carry out your own virus check before opening any attachments. We cannot accept liability for any damage sustained as a result of software viruses. We reserve the right to monitor email communications through our networks. Arqiva Limited. Registered office: Crawley Court, Winchester, Hampshire SO21 2QA United Kingdom Registered in England and Wales number 2487597 _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Plug-In Server ARERR 8760
Hi All - we recently installed ARS SP2 on our 7.6.4 dev server but after a reboot I am getting the following errors in my ARError.log. I know that I am having some CMDB issues since I can't create a Service and was hoping that they are related any ideas would be appreciated. Wed Mar 07 07:59:16 2012 390635 : Cannot establish a network connection to the AR System Plug-In server (ARERR 8760) Wed Mar 07 07:59:16 2012 SECCMGMTDEV1V ARSYS.ARDBC.CONFIGFILE : RPC: Program not registered Wed Mar 07 07:59:16 2012 390635 : Cannot establish a network connection to the AR System Plug-In server (ARERR 8760) Wed Mar 07 07:59:16 2012 SECCMGMTDEV1V ARSYS.ARDBC.CONFIGFILE : RPC: Program not registered ARS 7.6.4 SP 2 ITSM 7.6.4 RKM 7.6.4 SLM 7.6.4 Window 2008 - 64 Bit MS SQ 2005 IIS/Tomcat MidTier 7.6.4 SP 2 Hot Fix 12/2/11 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Fixed/Floating Licenses, chg after upgrade?
Hi, It has never been allowed to share a Fixed license between different users, but a technological limitation was added at some point. Possibly 7.1. Why not try the test version of RRR|License. It can tell you exactly how many Fixed and Floating licenses you will need for your site. The typical savings potential is about 30% of your floating licenses. You can enter the test version at: https://www.rrr.se/cgi/rrrlic/main ADV: Don't forget that RRR|License won the Best Return On Investment award at WWRUG both 2010 and 2011 :-) Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Hello all, Over spring break I will be upgrading to ARS 7.1 patch 11. I've looked thru the docs, white papers, etc, but I've not found the answer I'm looking for in the mounds of information available. I want to know if licenses will be handled differently in ARS 7.1. We're currently on ARS 7.01. The reason I ask is we have an inquiry form for users and it logs in with a fixed license that's shared across the school district. We obviously don't have enough coin to buy a license for everyone for a form that's infrequently used. I've set up the form to log out the shared user id and even with the mac address tracking, it works well nearly all of the time. I'm not anxious to have to find another solution. Also, are there any show stoppers I should watch out for going from ARS 7.01 to 7.1? I've tested on a puny development box with 3 fixed licenses and so far so good. But, I figured I should tap the collective knowledge here before I impact the whole district. The production backend is Ora10g on linux and a Windows 2003 server running Apache Tomcat 5.0.27 and Crystal XI for the application server. Thanks! Carina ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Signal 11 error
They are recommending a Filter-Max-Stack of 25 since our Filter Levels are not exceeding 14 (based on output of workflow log files), so, I am not sure if this will resolve the Signal 11 problem. Our ulimit settings are as follows: time(seconds)unlimited file(blocks) unlimited data(kbytes) unlimited stack(kbytes)4194304 memory(kbytes) 32768 coredump(blocks) 2097151 nofiles(descriptors) 2000 threads(per process) unlimited processes(per user) unlimited Mike. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: 07 March 2012 15:25 To: arslist@ARSLIST.ORG Subject: Re: Signal 11 error Is it the Maximum Filters for an Operation that is at 1 or Max Stack of Filters they want changed? Both are at the top of the Advanced tab in the Server Information of the AR System Administration Console. The ar.conf entries are (From the 7.6.04 doc) Filter-Max-Stack Maximum number of recursion levels allowed for an operation. The data modification performed by an AR_FILTER_ACTION_FIELDP filter action might trigger a second set, or level, of filters, one of which might trigger a third level of filters and so on. This option limits the number of times such recursion can happen, preventing the server crash that would occur if the recursion continued indefinitely. The default value is 25. Filter-Max-Total Maximum number of filters that the server executes for a given operation. The default value is 1. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Wednesday, March 07, 2012 8:47 AM To: arslist@ARSLIST.ORG Subject: Re: Signal 11 error ** Mike, They are probably on the wrong track. 25 used to be the recommended max a few versions ago. 1 on the current version and recommended configurations, is not a very high number. Is there anything written to the System or Application Event log at the time of that error? Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mike Worts Sent: Wednesday, March 07, 2012 8:29 AM To: arslist@ARSLIST.ORG Subject: Signal 11 error ** Hi all, We just had this error message on our AR Server and I have a few question about it if anyone can help please. 1. Is this a memory error that has caused arserverd to crash as I cannot find any core dumps? 2. Is Signal 11 an application generated error, on an AIX error? 3. What is the relevance of the Form:TMS:Task value 4. We had API/FILTER/SQL logging on at the time, what should I be looking for to point me to the cause? Wed Mar 7 13:09:18 2012: AR System server terminated when a signal/exception was received by the server (ARNOTE 20) Signal: 11 Thread Id: 8759 Version: 7.6.04 SP1 201104191058 Apr 27 2011 20:10:00 ServerName: Database: SQL -- Oracle Hardware: 00F6282E4C00 OS: AIX 6.1 RPC Id: 460531 RPC Call: 73 (GLEWF) RPC Queue: 390635 Client: User dan.henry from Mid-tier (protocol 18) at IP address 10.161.64.162 Form: TMS:Task Logging On: Alert API Escalation Filter SQL User FTIndexer Thread ServerGroup Stacks: Stacks: I have discussed this with BMC and one possible cause is our Filter-Max-Stack is set to '1'. They have asked us to reduce it to '25'. does anyone know if it will have an adverse effect on ITSM (I assume 25 is the recommended settings). AIX 6.1 ITSM 7.6.04 SP1 AR 7.6.04 SP1 Oracle 11g Thanks, Mike Worts. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are This email, its content and any files transmitted with it are for the personal attention of the addressee only, any other usage or access is unauthorised. It may contain information which could be confidential or privileged. If you are not the intended addressee you may not copy, disclose, circulate or use it. If you have received this email in error, please destroy it and notify the sender by email. Any representations or commitments expressed in this email are subject to contract. Although we use reasonable endeavours to virus scan all sent emails, it is the responsibility of the recipient to ensure that they are virus free and we advise you to carry out your own virus check before opening any attachments. We cannot accept liability for any damage sustained as a result of software viruses. We reserve the right to monitor email communications through our networks. Arqiva Limited. Registered office: Crawley Court, Winchester, Hampshire SO21 2QA United Kingdom Registered in England and Wales number 2487597 ___ UNSUBSCRIBE or access
Re: Plug-In Server ARERR 8760
Check to see if your plugin process is running – usually ‘Program not registered’ means that a service or program has not started.. Joe From: Pargeter, Christie :CO IS Sent: Wednesday, March 07, 2012 11:55 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Plug-In Server ARERR 8760 ** Hi All – we recently installed ARS SP2 on our 7.6.4 dev server but after a reboot I am getting the following errors in my ARError.log. I know that I am having some CMDB issues since I can’t create a Service and was hoping that they are related any ideas would be appreciated. Wed Mar 07 07:59:16 2012 390635 : Cannot establish a network connection to the AR System Plug-In server (ARERR 8760) Wed Mar 07 07:59:16 2012 SECCMGMTDEV1V ARSYS.ARDBC.CONFIGFILE : RPC: Program not registered Wed Mar 07 07:59:16 2012 390635 : Cannot establish a network connection to the AR System Plug-In server (ARERR 8760) Wed Mar 07 07:59:16 2012 SECCMGMTDEV1V ARSYS.ARDBC.CONFIGFILE : RPC: Program not registered ARS 7.6.4 SP 2 ITSM 7.6.4 RKM 7.6.4 SLM 7.6.4 Window 2008 – 64 Bit MS SQ 2005 IIS/Tomcat MidTier 7.6.4 SP 2 Hot Fix 12/2/11 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Very Soon: BMC RD proactively Sharing and openly Interacting
I missed the first one. Is a recording available? Also how do we register for the next sessions? Ken. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Matt Laurenceau Sent: Thursday, March 01, 2012 4:38 PM To: arslist@ARSLIST.ORG Subject: Re: Very Soon: BMC RD proactively Sharing and openly Interacting Phil, Jason, Jose, all, This 1-hour monthly WebEx will indeed enable convo between you and experts. It doesn't prevent online conversations that happen almost 24x7, it enables live+interactive demos/explanations (from RD and/or you). We sure want to post the recordings. There are many people to credit for this initiative, you'll meet them during these meetings. Can't wait for the first session. Looking forward to interacting with you (before F2Fing for WWRUG12), ~ Matt Laurenceau Senior Community Ambassador, BMC Communities matthieu_laurenc...@bmc.com Follow me @Matt_L Skype: matt.laurenceau On 1 mars 2012, at 20:04, bullcreek.com bauti...@bullcreek.com wrote: I think BMC should host a one hour radio show where listeners could call in with their questions about AR System, Mid Tier, Workflow, Apps, Integrations, etc. with Doug Mueller and perhaps David Easter, Matt Laurenceau, or perhaps Lisa K (who did a great job on the 7.7 Beta calls), host the show kind of like a BMC Remedy version of Car Talk. Interestingly, this was brought up to me years ago but I wasn't sure I had the bandwidth for it. Now I am certain that I don't! :-) Phil Bautista President / CEO Bull Creek Data Corporation www.bullcreek.com Remedy Approved Consultant (RAC) 512-731-0304 -Original message- From: Jason Miller jason.mil...@gmail.com Date: Thu, 1 Mar 2012 12:25:16 -0500 To: arslist@ARSLIST.ORG Subject: Re: Very Soon: BMC RD proactively Sharing and openly Interacting This is awesome Matt! Jose, I definitely see your point. My thought is having it in a phone call format will provide a bit more of a dynamic interaction. For example I can post a discussion in the BMC Communities and there is a good chance I will get a reply from somebody at BMC. A response isn't guaranteed though. Now BMC obviously has the right to not answer a question on the phone but the expectation is you have their time right then and there and somebody will respond. If it will be anything at like the beta calls have been a BMC employee will take the task of following up on (appropriate) questions that could not be answers right then an there. In the Communities your question could go without a response. Aside from that it seems to me that text on a web page can't cover a topic quite as thoroughly as a voice conversation. It is great for listing step by step instructions but does not work quite as well for working out conceptual topics. Maybe the call can be recorded and posted to the Communities? Jason On Wed, Feb 29, 2012 at 8:41 AM, Jose Huerta jose.hue...@sm2baleares.eswr ote: ** Just to contribute, I like the idea. But I would prefer to hold it at the communities in a forum format. Thus, it can be readed by other professionals later. Jose M. Huerta Project Manager** Movil: 661 665 088 Telf.: 971 75 03 24 Fax: 971 75 07 94 http://www.sm2baleares.es/ SM2 Baleares S.A. C/Rita Levi Edificio SM2 Parc Bit 07121 Palma de Mallorca http://es-es.facebook.com/pages/SM2-Baleares/158608627954 http://twitter.com/#!/SM2Baleares http://www.linkedin.com/company/sm2-baleares La informaci�n contenida en este mensaje de correo electr�nico es confidencial. La misma, es enviada con la intenci�n de que �nicamente sea le�da por la persona(s) a la(s) que va dirigida. El acceso a este mensa je por otras personas no est� autorizado, por lo que en tal caso, le rogam os que nos lo comunique por la misma v�a, se abstenga de realizar copias d el mensaje o remitirlo o entregarlo a otra persona y proceda a borrarlo de inmediato. P Por favor, no imprima este mensaje ni sus documentos adjuntos si no es necesario. On Wed, Feb 29, 2012 at 16:35, Matt Laurenceau matt.laurenc...@gmail.com wrote: ** BMC is launching a monthly *BMC Atrium Ask the Experts* series to discuss Best Practices and to answer your architecture and implementatio n questions. The format is informal and simple. BMC product managers and architects will start the call with a short discussion on a select BMC Atrium topic, then open up the forum for YOUR questions. All Atrium-related topics are fair game. We will have *Architects, Product Managers Product Marketing* on the phone to answer your questions. We ask that product specific support questions be routed thro ugh normal channels. To register for the first call happening on March 6th 2012 at 8am PST, please register at http://tinyurl.com/AtriumRSVP. Looking forward to
Resolved: ARERR 514: Contents of the Status-History field in the flat file database are missing or invalid
Thank you Doug for your response, again. To further share with LIST, This error ARERR 514: Contents of the Status-History field in the flat file database are missing or invalid was a result of exporting production schema without stopping the production database. (we can't stop production for test/qa environment). The Status-History on 15 records in Service mngt (incident form) were being updated at the time of export. So, once we imported to qa_environment, this error start to occurred on Escalations (aresc.log showed errno=514), Filter (arfilter.log showed USER: AR_ESCALATOR 514), arerror.log ( ARERR 514: Contents of the Status-History field in the flat file database are missing or invalid) and POP-UP in WUT/MT (ARERR [514] Contents of the Status-History field in the flat file database are missing or invalid). Since qa, I found to records and deleted. If this is production move, then we would have taken the outage and stop db and export schema appropriately. -- View this message in context: http://ars-action-request-system.1093659.n2.nabble.com/ARERR-514-Contents-of-the-Status-History-field-in-the-flat-file-database-are-missing-or-invalid-tp7334519p7352747.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Signal 11 error
You will note my earlier post about the fact that a Get Multiple Entries sometimes returned a field id of 0 with a value of NULL for a display only field set (only sometimes) by a Get filter on the TMS:Task form. I was seeing this behaviour on ITSM 7.6 or ARS 7.5. Is the SIGSEGV a manifestation of the underlying code problem? I am now having to check all returns from the API for completeness and generating NULL values for incomplete records. This is the only form that I have seen this happen on, so it seems like an excessive overhead to correct a behaviour problem in the API. There has been very little response to my earlier post - other than to contact support - for what may be a significant code problem. See if you can isolate and repeat the problem. You're only hope for a SIGSEGV is that a fix is supplied or perhaps by changing your logic you do not hit the area of bad code. Perhaps, a fix to the Get Fields filter to set the DO field to NULL if the associated enum field is also NULL may be a work-around. (If indeed your problem is related to the same thing that I saw). Cheers Ben -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mike Worts Sent: March-07-12 18:01 To: arslist@ARSLIST.ORG Subject: Re: Signal 11 error They are recommending a Filter-Max-Stack of 25 since our Filter Levels are not exceeding 14 (based on output of workflow log files), so, I am not sure if this will resolve the Signal 11 problem. Our ulimit settings are as follows: time(seconds)unlimited file(blocks) unlimited data(kbytes) unlimited stack(kbytes)4194304 memory(kbytes) 32768 coredump(blocks) 2097151 nofiles(descriptors) 2000 threads(per process) unlimited processes(per user) unlimited Mike. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: 07 March 2012 15:25 To: arslist@ARSLIST.ORG Subject: Re: Signal 11 error Is it the Maximum Filters for an Operation that is at 1 or Max Stack of Filters they want changed? Both are at the top of the Advanced tab in the Server Information of the AR System Administration Console. The ar.conf entries are (From the 7.6.04 doc) Filter-Max-Stack Maximum number of recursion levels allowed for an operation. The data modification performed by an AR_FILTER_ACTION_FIELDP filter action might trigger a second set, or level, of filters, one of which might trigger a third level of filters and so on. This option limits the number of times such recursion can happen, preventing the server crash that would occur if the recursion continued indefinitely. The default value is 25. Filter-Max-Total Maximum number of filters that the server executes for a given operation. The default value is 1. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Wednesday, March 07, 2012 8:47 AM To: arslist@ARSLIST.ORG Subject: Re: Signal 11 error ** Mike, They are probably on the wrong track. 25 used to be the recommended max a few versions ago. 1 on the current version and recommended configurations, is not a very high number. Is there anything written to the System or Application Event log at the time of that error? Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mike Worts Sent: Wednesday, March 07, 2012 8:29 AM To: arslist@ARSLIST.ORG Subject: Signal 11 error ** Hi all, We just had this error message on our AR Server and I have a few question about it if anyone can help please. 1. Is this a memory error that has caused arserverd to crash as I cannot find any core dumps? 2. Is Signal 11 an application generated error, on an AIX error? 3. What is the relevance of the Form:TMS:Task value 4. We had API/FILTER/SQL logging on at the time, what should I be looking for to point me to the cause? Wed Mar 7 13:09:18 2012: AR System server terminated when a signal/exception was received by the server (ARNOTE 20) Signal: 11 Thread Id: 8759 Version: 7.6.04 SP1 201104191058 Apr 27 2011 20:10:00 ServerName: Database: SQL -- Oracle Hardware: 00F6282E4C00 OS: AIX 6.1 RPC Id: 460531 RPC Call: 73 (GLEWF) RPC Queue: 390635 Client: User dan.henry from Mid-tier (protocol 18) at IP address 10.161.64.162 Form: TMS:Task Logging On: Alert API Escalation Filter SQL User FTIndexer Thread ServerGroup Stacks: Stacks: I have discussed this with BMC and one possible cause is our Filter-Max-Stack is set to '1'. They have asked us to reduce it to '25'. does anyone know if it will have an adverse effect on ITSM (I assume 25 is the recommended settings). AIX 6.1 ITSM 7.6.04 SP1 AR 7.6.04 SP1 Oracle 11g Thanks, Mike Worts.
User Login ID Server not being set at login ITSM 7.6.04
Has anyone seen this error? I can't find anything related to this error. When I search the ARSList the search times out. Setup - ARS 7.6.04 with ITSM 7.6.04 patch 1, Web only Access (Internet Explorer) I have one user that logs in to the system, however the Internet Explorer Status bar shows $USER$ | $SERVER$ It should show jdoe | myarserver The problem is when the user is selecting a Task from the IT Home Page Overview Console they get an error - A server name must be supplied in the control record (ARERR 150) I've done all the standard stuff, clear cache, restart computer, etc. The odd thing is this happens sporadically. sometimes the $USER$ and $SERVER$ are set properly, sometimes not. This is only occurring to one user. Thanks, Andre ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: User Login ID Server not being set at login ITSM 7.6.04
That error typically used to happen when someone came into mid-tier 7.1 using a book mark for the login page, which meant that they did not go through the server:port/arsys/home link which sets the server information. I cannot say that I have seen this error in 7.6.04.01, but it might depend on your web server (we use pure tomcat). The login page in 7.6.04 is different from that in 7.1, and in my experience leads to a normal login with server specified. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Andre Hughes Sent: Wednesday, March 07, 2012 1:45 PM To: arslist@ARSLIST.ORG Subject: User Login ID Server not being set at login ITSM 7.6.04 Has anyone seen this error? I can't find anything related to this error. When I search the ARSList the search times out. Setup - ARS 7.6.04 with ITSM 7.6.04 patch 1, Web only Access (Internet Explorer) I have one user that logs in to the system, however the Internet Explorer Status bar shows $USER$ | $SERVER$ It should show jdoe | myarserver The problem is when the user is selecting a Task from the IT Home Page Overview Console they get an error - A server name must be supplied in the control record (ARERR 150) I've done all the standard stuff, clear cache, restart computer, etc. The odd thing is this happens sporadically. sometimes the $USER$ and $SERVER$ are set properly, sometimes not. This is only occurring to one user. Thanks, Andre ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Plug-In Server ARERR 8760
Anytime there are issues with plugin, somethings to check in the first place are: 1.ar.conf file and see if all the plugin paths, plugin lines, port numbers are present? 2. Please add extra lines for any server aliases, FQDN, restart the server and see if it would fix. 3. Try with port mapper registers and see if it makes any difference and you could disable it later if that is a security concern. 4.Check C, java plugin config files and verify the plugins you expect to see there are exist along with proper port numbers. 5. Some times increasing the plugin timeouts/threads would resolve issues related to plugins. 6. Also check armonitor.conf file and see relavant plugin lines are there to get initialized. There are a few detailed article in BMC Knowledgebase, try searching there for any relavent information. In you case you can start with items 1, 2 from above specifically for ardbc plugin related lines. On Wednesday, March 7, 2012 10:55:37 AM UTC-6, Pargeter, Christie :CO IS wrote: ** Hi All – we recently installed ARS SP2 on our 7.6.4 dev server but after a reboot I am getting the following errors in my ARError.log. I know that I am having some CMDB issues since I can’t create a Service and was hoping that they are related any ideas would be appreciated. Wed Mar 07 07:59:16 2012 390635 : Cannot establish a network connection to the AR System Plug-In server (ARERR 8760) Wed Mar 07 07:59:16 2012 SECCMGMTDEV1V ARSYS.ARDBC.CONFIGFILE : RPC: Program not registered Wed Mar 07 07:59:16 2012 390635 : Cannot establish a network connection to the AR System Plug-In server (ARERR 8760) Wed Mar 07 07:59:16 2012 SECCMGMTDEV1V ARSYS.ARDBC.CONFIGFILE : RPC: Program not registered ARS 7.6.4 SP 2 ITSM 7.6.4 RKM 7.6.4 SLM 7.6.4 Window 2008 – 64 Bit MS SQ 2005 IIS/Tomcat MidTier 7.6.4 SP 2 Hot Fix 12/2/11 _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Query Cache Question. Where is it happening?
There was a question posed during a meeting today based on some new servers we are setting up. When we perform a query on a form for the first time it takes a long time to run. We then perform the exact same query again and it runs much, much faster. The question was posed. It the Oracle database doing the query caching or is the AR System Server doing the caching or is it a combination of both? Server: HP-UX Initium DB: Oracle 10g AR System Server 7.1 Patch 11 Christopher Pruitt HP Enterprise Services Bank of America Account | CIA - Integrated Applications | IW Infrastructure Team +1.972.605.7702 office | christopher.pru...@hp.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Query Cache Question. Where is it happening?
Yes.. its Oracles MRU and LRU queues. There is a lot of info on this available online that you should find but to get you started take a look at this article.. http://www.adp-gmbh.ch/ora/concepts/cache.html Joe -Original Message- From: Pruitt, Christopher (Bank of America Account) Sent: Wednesday, March 07, 2012 3:54 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Query Cache Question. Where is it happening? There was a question posed during a meeting today based on some new servers we are setting up. When we perform a query on a form for the first time it takes a long time to run. We then perform the exact same query again and it runs much, much faster. The question was posed. It the Oracle database doing the query caching or is the AR System Server doing the caching or is it a combination of both? Server: HP-UX Initium DB: Oracle 10g AR System Server 7.1 Patch 11 Christopher Pruitt HP Enterprise Services Bank of America Account | CIA - Integrated Applications | IW Infrastructure Team +1.972.605.7702 office | christopher.pru...@hp.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Query Cache Question. Where is it happening?
For sure oracle does caching as long as the query is performed with same variables, values could be different. This is something called bind variables in oracle. As long as they are same oracle does not have to parse and calculate the execution plan again. Also I guess it stores the data in cache for some time so the same query second time would get results faster. For ARS other than forms/workflow it would not cache any data. On Wednesday, March 7, 2012 2:54:39 PM UTC-6, Pruitt, Christopher (Bank of America Account) wrote: There was a question posed during a meeting today based on some new servers we are setting up. When we perform a query on a form for the first time it takes a long time to run. We then perform the exact same query again and it runs much, much faster. The question was posed. It the Oracle database doing the query caching or is the AR System Server doing the caching or is it a combination of both? Server: HP-UX Initium DB: Oracle 10g AR System Server 7.1 Patch 11 Christopher Pruitt HP Enterprise Services Bank of America Account | CIA - Integrated Applications | IW Infrastructure Team +1.972.605.7702 office | christopher.pru...@hp.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Query Cache Question. Where is it happening?
Thanks all, I have the answer I needed. Christopher Pruitt Business Consulting III HP Enterprises Services christopher.pru...@hp.com www.hp.comhttp://www.hp.com/ [cid:image001.png@01CCFC76.007611A0] Confidentiality Notice: This message and any files transmitted with it are intended for the sole use of the entity or individual to whom it is addressed, and may contain information that is confidential, privileged, and exempt from disclosure under applicable law. If you are not the intended addressee for this e-mail, you are hereby notified that any copying, distribution, or dissemination of this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately destroy, erase, or discard this message. Please notify the sender immediately by return e-mail if you have received this e-mail by mistake. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of patchsk Sent: Wednesday, March 07, 2012 3:01 PM To: arslist@ARSLIST.ORG Subject: Re: Query Cache Question. Where is it happening? ** For sure oracle does caching as long as the query is performed with same variables, values could be different. This is something called bind variables in oracle. As long as they are same oracle does not have to parse and calculate the execution plan again. Also I guess it stores the data in cache for some time so the same query second time would get results faster. For ARS other than forms/workflow it would not cache any data. On Wednesday, March 7, 2012 2:54:39 PM UTC-6, Pruitt, Christopher (Bank of America Account) wrote: There was a question posed during a meeting today based on some new servers we are setting up. When we perform a query on a form for the first time it takes a long time to run. We then perform the exact same query again and it runs much, much faster. The question was posed. It the Oracle database doing the query caching or is the AR System Server doing the caching or is it a combination of both? Server: HP-UX Initium DB: Oracle 10g AR System Server 7.1 Patch 11 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.orghttp://www.arslist.org attend wwrug12 www.wwrug12.comhttp://www.wwrug12.com ARSList: Where the Answers Are _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are inline: image001.png
Outgoing Email Error: Not Connected on Some Emails Not All
Hi All, I have Arsystem 7.5 email engine installed with a 7.5 ARSystem server. I have multiple outgoing email mailboxes sending emails through one of two exchange smtp servers. Most of the emails go through ok but not a small percentage error out with the following error: Not connected java.lang.IllegalStateException: Not connected at com.sun.mail.smtp.SMTPTransport.checkConnected(SMTPTransport.java:1511) at com.sun.mail.smtp.SMTPTransport.sendMessage(SMTPTransport.java:548) at com.remedy.arsys.emaildaemon.SenderModule.sendMessage(SenderModule.java:365) at com.remedy.arsys.emaildaemon.SenderModule.doWork(SenderModule.java:220) at com.remedy.arsys.emaildaemon.ThreadBase.run(ThreadBase.java:268) at java.lang.Thread.run(Unknown Source) Obviously this is not a simple port issue as the majority of emails do go out. There is no common denominator as far as which emails go out and which don't, it happens with both exchange servers, multiple email accounts, at all hours of day and night, out of the box notifications and custom, html templates and plain text. As you can imagine this is causing major issues so any ideas would be gratefully received. Thanks, Sharon ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Client getting RPC Error (90) When Logging into DR Server
I installed AR System Server on a server that we are using as a DR Server. It is pointing to the same DB server as our Prod Server (luckily this prod server is actually not in production yet). Prod App Server Services are turned on and everything is working. When I tried to turn on the AR Services on the DR server, I'm getting this in our arerror.log file. The first 4 lines are to be expected because the DR server has not been licensed yet. The next 2 lines I've heard that we can just ignore, but the lines about the Distributed Server Option is what I'm thinking is causing me problems. I'm trying to log into the DR Server with my Client (to get the host ID to get a license key for it) and I keep getting the RPC Error (90). So I stopped the services on our Prod Server and restarted the services on our DR Server and I'm still getting the RPC Error and these errors are still appearing on the arerror.log file. I know the APP server is talking to the DB Server or those types of errors would come up in the arerror.log file. Plus I was able to successfully install the AR System sofware on the DR server. Is there anything else I can check? Yes, the network is working and my client is working and the ports are open and I can ping the DR server from my PC. Prod server is working just fine AR System 7.6.04 SP2 Oracle 11g Windows 2008 Server Windows 7 PC --- Wed Mar 07 14:32:45 2012 : Action Request System(R) Server x64 Version 7.6.04 SP2 201110080614 (c) Copyright 1991-2011 BMC Software, Inc. Wed Mar 07 14:32:46 2012 390600 : This COPY of the Action Request System(R) does not have authorization key set, but is ready for use or evaluation. For unlimited capabilities, contact your sales representative. (ARNOTE 27) Wed Mar 07 14:39:31 2012 390600 : Could not find or read the optional license tags file. (ARNOTE 452) Wed Mar 07 14:39:31 2012 C:\Program Files\Common Files\AR System\Licenses\USW04AP004\arsystem.tag Wed Mar 07 14:43:31 2012 Distrib : This AR System is not licensed for the Distributed Server Option (ARDSERR 3100) Wed Mar 07 14:43:31 2012 Distrib : AR System Distributed Server terminated -- fatal error encountered (ARDSERR 3001) Wed Mar 07 14:43:33 2012 Distrib : This AR System is not licensed for the Distributed Server Option (ARDSERR 3100) Wed Mar 07 14:43:33 2012 Distrib : AR System Distributed Server terminated -- fatal error encountered (ARDSERR 3001) Wed Mar 07 14:43:34 2012 Distrib : This AR System is not licensed for the Distributed Server Option (ARDSERR 3100) Wed Mar 07 14:43:34 2012 Distrib : AR System Distributed Server terminated -- fatal error encountered (ARDSERR 3001) Wed Mar 07 14:43:34 2012 Distrib : This AR System is not licensed for the Distributed Server Option (ARDSERR 3100) Wed Mar 07 14:43:34 2012 Distrib : AR System Distributed Server terminated -- fatal error encountered (ARDSERR 3001) Wed Mar 07 14:43:34 2012 Distrib : This AR System is not licensed for the Distributed Server Option (ARDSERR 3100) Wed Mar 07 14:43:34 2012 Distrib : AR System Distributed Server terminated -- fatal error encountered (ARDSERR 3001) Lisa Kemes AR System Developer TEIS - USA +1 717 810 2408 tel +1 717 602 9460 mobile lisa.ke...@te.commailto:lisa.ke...@te.com 100 Amp Drive Harrisburg, PA 17112 [http://www.te.com/images/socialmedia/smallTElogo.gif]http://www.te.com/ www.te.comhttp://www.te.com/ [http://www.te.com/images/socialmedia/twitter.png]http://twitter.com/teconnectivity [http://www.te.com/images/socialmedia/facebook.png] http://www.facebook.com/teconnectivity [http://www.te.com/images/socialmedia/flickr.png] http://www.flickr.com/photos/teconnectivity/ [http://www.te.com/images/socialmedia/linkedin.png] http://www.linkedin.com/groups?gid=1591657 [http://www.te.com/images/socialmedia/youtube.png] http://www.youtube.com/teconnectivity ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Client getting RPC Error (90) When Logging into DR Server
Check your armonitor file. My best guess is that it must be set to start the DSO. Comment that line with a # at the beginning of that line.. Then attempt to start the services.. Joe From: Kemes, Lisa Sent: Wednesday, March 07, 2012 4:53 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Client getting RPC Error (90) When Logging into DR Server ** I installed AR System Server on a server that we are using as a DR Server. It is pointing to the same DB server as our Prod Server (luckily this prod server is actually not in production yet). Prod App Server Services are turned on and everything is working. When I tried to turn on the AR Services on the DR server, I'm getting this in our arerror.log file. The first 4 lines are to be expected because the DR server has not been licensed yet. The next 2 lines I've heard that we can just ignore, but the lines about the Distributed Server Option is what I'm thinking is causing me problems. I'm trying to log into the DR Server with my Client (to get the host ID to get a license key for it) and I keep getting the RPC Error (90). So I stopped the services on our Prod Server and restarted the services on our DR Server and I'm still getting the RPC Error and these errors are still appearing on the arerror.log file. I know the APP server is talking to the DB Server or those types of errors would come up in the arerror.log file. Plus I was able to successfully install the AR System sofware on the DR server. Is there anything else I can check? Yes, the network is working and my client is working and the ports are open and I can ping the DR server from my PC. Prod server is working just fine AR System 7.6.04 SP2 Oracle 11g Windows 2008 Server Windows 7 PC --- Wed Mar 07 14:32:45 2012 : Action Request System(R) Server x64 Version 7.6.04 SP2 201110080614 (c) Copyright 1991-2011 BMC Software, Inc. Wed Mar 07 14:32:46 2012 390600 : This COPY of the Action Request System(R) does not have authorization key set, but is ready for use or evaluation. For unlimited capabilities, contact your sales representative. (ARNOTE 27) Wed Mar 07 14:39:31 2012 390600 : Could not find or read the optional license tags file. (ARNOTE 452) Wed Mar 07 14:39:31 2012 C:\Program Files\Common Files\AR System\Licenses\USW04AP004\arsystem.tag Wed Mar 07 14:43:31 2012 Distrib : This AR System is not licensed for the Distributed Server Option (ARDSERR 3100) Wed Mar 07 14:43:31 2012 Distrib : AR System Distributed Server terminated -- fatal error encountered (ARDSERR 3001) Wed Mar 07 14:43:33 2012 Distrib : This AR System is not licensed for the Distributed Server Option (ARDSERR 3100) Wed Mar 07 14:43:33 2012 Distrib : AR System Distributed Server terminated -- fatal error encountered (ARDSERR 3001) Wed Mar 07 14:43:34 2012 Distrib : This AR System is not licensed for the Distributed Server Option (ARDSERR 3100) Wed Mar 07 14:43:34 2012 Distrib : AR System Distributed Server terminated -- fatal error encountered (ARDSERR 3001) Wed Mar 07 14:43:34 2012 Distrib : This AR System is not licensed for the Distributed Server Option (ARDSERR 3100) Wed Mar 07 14:43:34 2012 Distrib : AR System Distributed Server terminated -- fatal error encountered (ARDSERR 3001) Wed Mar 07 14:43:34 2012 Distrib : This AR System is not licensed for the Distributed Server Option (ARDSERR 3100) Wed Mar 07 14:43:34 2012 Distrib : AR System Distributed Server terminated -- fatal error encountered (ARDSERR 3001) Lisa Kemes AR System Developer TEIS - USA +1 717 810 2408 tel +1 717 602 9460 mobile lisa.ke...@te.com 100 Amp Drive Harrisburg, PA 17112 www.te.com _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Client getting RPC Error (90) When Logging into DR Server
DSO will not run on an unlicensed server. You probably want to comment it out in your armonitor.cfg file until you get the license. FYI: To get rid of the tag error create an empty file C:\Program Files\Common Files\AR System\Licenses\USW04AP004\arsystem.tag Fred From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa Sent: Wednesday, March 07, 2012 3:54 PM To: arslist@ARSLIST.ORG Subject: Client getting RPC Error (90) When Logging into DR Server ** I installed AR System Server on a server that we are using as a DR Server. It is pointing to the same DB server as our Prod Server (luckily this prod server is actually not in production yet). Prod App Server Services are turned on and everything is working. When I tried to turn on the AR Services on the DR server, I'm getting this in our arerror.log file. The first 4 lines are to be expected because the DR server has not been licensed yet. The next 2 lines I've heard that we can just ignore, but the lines about the Distributed Server Option is what I'm thinking is causing me problems. I'm trying to log into the DR Server with my Client (to get the host ID to get a license key for it) and I keep getting the RPC Error (90). So I stopped the services on our Prod Server and restarted the services on our DR Server and I'm still getting the RPC Error and these errors are still appearing on the arerror.log file. I know the APP server is talking to the DB Server or those types of errors would come up in the arerror.log file. Plus I was able to successfully install the AR System sofware on the DR server. Is there anything else I can check? Yes, the network is working and my client is working and the ports are open and I can ping the DR server from my PC. Prod server is working just fine AR System 7.6.04 SP2 Oracle 11g Windows 2008 Server Windows 7 PC --- Wed Mar 07 14:32:45 2012 : Action Request System(R) Server x64 Version 7.6.04 SP2 201110080614 (c) Copyright 1991-2011 BMC Software, Inc. Wed Mar 07 14:32:46 2012 390600 : This COPY of the Action Request System(R) does not have authorization key set, but is ready for use or evaluation. For unlimited capabilities, contact your sales representative. (ARNOTE 27) Wed Mar 07 14:39:31 2012 390600 : Could not find or read the optional license tags file. (ARNOTE 452) Wed Mar 07 14:39:31 2012 C:\Program Files\Common Files\AR System\Licenses\USW04AP004\arsystem.tag Wed Mar 07 14:43:31 2012 Distrib : This AR System is not licensed for the Distributed Server Option (ARDSERR 3100) Wed Mar 07 14:43:31 2012 Distrib : AR System Distributed Server terminated -- fatal error encountered (ARDSERR 3001) Wed Mar 07 14:43:33 2012 Distrib : This AR System is not licensed for the Distributed Server Option (ARDSERR 3100) Wed Mar 07 14:43:33 2012 Distrib : AR System Distributed Server terminated -- fatal error encountered (ARDSERR 3001) Wed Mar 07 14:43:34 2012 Distrib : This AR System is not licensed for the Distributed Server Option (ARDSERR 3100) Wed Mar 07 14:43:34 2012 Distrib : AR System Distributed Server terminated -- fatal error encountered (ARDSERR 3001) Wed Mar 07 14:43:34 2012 Distrib : This AR System is not licensed for the Distributed Server Option (ARDSERR 3100) Wed Mar 07 14:43:34 2012 Distrib : AR System Distributed Server terminated -- fatal error encountered (ARDSERR 3001) Wed Mar 07 14:43:34 2012 Distrib : This AR System is not licensed for the Distributed Server Option (ARDSERR 3100) Wed Mar 07 14:43:34 2012 Distrib : AR System Distributed Server terminated -- fatal error encountered (ARDSERR 3001) Lisa Kemes AR System Developer TEIS - USA +1 717 810 2408 tel +1 717 602 9460 mobile lisa.ke...@te.commailto:lisa.ke...@te.com 100 Amp Drive Harrisburg, PA 17112 [http://www.te.com/images/socialmedia/smallTElogo.gif]http://www.te.com/ www.te.comhttp://www.te.com/ [http://www.te.com/images/socialmedia/twitter.png]http://twitter.com/teconnectivity[http://www.te.com/images/socialmedia/facebook.png]http://www.facebook.com/teconnectivity[http://www.te.com/images/socialmedia/flickr.png]http://www.flickr.com/photos/teconnectivity/[http://www.te.com/images/socialmedia/linkedin.png]http://www.linkedin.com/groups?gid=1591657[http://www.te.com/images/socialmedia/youtube.png]http://www.youtube.com/teconnectivity ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Client getting RPC Error (90) When Logging into DR Server
There could be more than just the DSO is failing. Since you mentioned the production is working and dr is using the same database, please compare both ar.conf and armonitor.conf b/n prod and dr and you may find something there. Make sure they are very similar as much as possible.(Same kind of ports,threads,timeouts, logging options etc...) during the troubleshooting. That would eliminate lot of unknowns. Also you are on a windows server so try installing user tool on the server itself and try login from there. Turn on API, SQL, User logs at server level and see if your login attempts are displayed in the logs. If they are it will atleast confirm that atleast server is receiving packets from client. You could also use the driver program that is installed along with arserver to initiate api calls for troubleshooting. On Wednesday, March 7, 2012 3:53:37 PM UTC-6, Kemes, Lisa wrote: ** I installed AR System Server on a server that we are using as a DR Server. It is pointing to the same DB server as our Prod Server (luckily this prod server is actually not in production yet). Prod App Server Services are turned on and everything is working. When I tried to turn on the AR Services on the DR server, I'm getting this in our arerror.log file. The first 4 lines are to be expected because the DR server has not been licensed yet. The next 2 lines I've heard that we can just ignore, but the lines about the Distributed Server Option is what I'm thinking is causing me problems. I'm trying to log into the DR Server with my Client (to get the host ID to get a license key for it) and I keep getting the RPC Error (90). So I stopped the services on our Prod Server and restarted the services on our DR Server and I'm still getting the RPC Error and these errors are still appearing on the arerror.log file. I know the APP server is talking to the DB Server or those types of errors would come up in the arerror.log file. Plus I was able to successfully install the AR System sofware on the DR server. Is there anything else I can check? Yes, the network is working and my client is working and the ports are open and I can ping the DR server from my PC. Prod server is working just fine AR System 7.6.04 SP2 Oracle 11g Windows 2008 Server Windows 7 PC --- Wed Mar 07 14:32:45 2012 : Action Request System(R) Server x64 Version 7.6.04 SP2 201110080614 (c) Copyright 1991-2011 BMC Software, Inc. Wed Mar 07 14:32:46 2012 390600 : This COPY of the Action Request System(R) does not have authorization key set, but is ready for use or evaluation. For unlimited capabilities, contact your sales representative. (ARNOTE 27) Wed Mar 07 14:39:31 2012 390600 : Could not find or read the optional license tags file. (ARNOTE 452) Wed Mar 07 14:39:31 2012 C:\Program Files\Common Files\AR System\Licenses\USW04AP004\arsystem.tag Wed Mar 07 14:43:31 2012 Distrib : This AR System is not licensed for the Distributed Server Option (ARDSERR 3100) Wed Mar 07 14:43:31 2012 Distrib : AR System Distributed Server terminated -- fatal error encountered (ARDSERR 3001) Wed Mar 07 14:43:33 2012 Distrib : This AR System is not licensed for the Distributed Server Option (ARDSERR 3100) Wed Mar 07 14:43:33 2012 Distrib : AR System Distributed Server terminated -- fatal error encountered (ARDSERR 3001) Wed Mar 07 14:43:34 2012 Distrib : This AR System is not licensed for the Distributed Server Option (ARDSERR 3100) Wed Mar 07 14:43:34 2012 Distrib : AR System Distributed Server terminated -- fatal error encountered (ARDSERR 3001) Wed Mar 07 14:43:34 2012 Distrib : This AR System is not licensed for the Distributed Server Option (ARDSERR 3100) Wed Mar 07 14:43:34 2012 Distrib : AR System Distributed Server terminated -- fatal error encountered (ARDSERR 3001) Wed Mar 07 14:43:34 2012 Distrib : This AR System is not licensed for the Distributed Server Option (ARDSERR 3100) Wed Mar 07 14:43:34 2012 Distrib : AR System Distributed Server terminated -- fatal error encountered (ARDSERR 3001) *Lisa Kemes* AR System Developer TEIS - USA +1 717 810 2408 tel +1 717 602 9460 mobile *lisa.ke...@te.com* 100 Amp Drive Harrisburg, PA 17112 http://www.te.com/ www.te.com http://twitter.com/teconnectivity http://www.facebook.com/teconnectivity http://www.flickr.com/photos/teconnectivity/ http://www.linkedin.com/groups?gid=1591657 http://www.youtube.com/teconnectivity _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Slightly OT: Anyone tried running Oracle Client (SQL Plus) 10.2.0.1.0 on Windows 7 Home Premium edition??
I know this isn’t the forum to be asking Oracle related questions so forgive me for posting what may be an off topic question here on this list.. Do you get a problem where when you try to login into SQL Plus client version 10.2.0.1.0 on Windows 7 Home Premium Edition, wherein the session terminates even before you see the SQL prompt? I just noticed this problems after installing the 32bit version of the client, and didn’t have the time to look around for things like logs or errors but will do so tomorrow when I need to use this again.. Joe ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
CI Type Reassignment Question?
We have some assets that were assigned to the wrong CI Type, does anyone know how to reassign an assests' CI Type? Thanks, -Mike ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: CI Type Reassignment Question?
Each CI Type is stored in a different form. So you need to copy the data from one form to another (in fact more than one form to another since CI data is spread among several forms). Maybe If no relationships exist between these assets and other elements (like incidents for instance), then you must copy and create new ones (AIE can help). If these relationships exist, then it's a bit harder. Don't know if there is any wizard that allow to move the data from one CI type to another. Jose M. Huerta Project Manager** Movil: 661 665 088 Telf.: 971 75 03 24 Fax: 971 75 07 94 http://www.sm2baleares.es/ SM2 Baleares S.A. C/Rita Levi Edificio SM2 Parc Bit 07121 Palma de Mallorca http://es-es.facebook.com/pages/SM2-Baleares/158608627954 http://twitter.com/#!/SM2Baleares http://www.linkedin.com/company/sm2-baleares La información contenida en este mensaje de correo electrónico es confidencial. La misma, es enviada con la intención de que únicamente sea leída por la persona(s) a la(s) que va dirigida. El acceso a este mensaje por otras personas no está autorizado, por lo que en tal caso, le rogamos que nos lo comunique por la misma vía, se abstenga de realizar copias del mensaje o remitirlo o entregarlo a otra persona y proceda a borrarlo de inmediato. P Por favor, no imprima este mensaje ni sus documentos adjuntos si no es necesario. On Thu, Mar 8, 2012 at 00:34, Mike Hocks mike.ho...@state.mn.us wrote: We have some assets that were assigned to the wrong CI Type, does anyone know how to reassign an assests' CI Type? Thanks, -Mike ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are image003.jpgimage001.jpgimage004.jpgimage002.jpg
Re: CI Type Reassignment Question?
You need to export the entries and import them to the proper CI type through the AST join form. -Original Message- From: Mike Hocks mike.ho...@state.mn.us To: arslist arslist@ARSLIST.ORG Sent: Wed, Mar 7, 2012 6:34 pm Subject: CI Type Reassignment Question? We have some assets that were assigned to the wrong CI Type, does anyone know ow to reassign an assests' CI Type? Thanks, Mike ___ NSUBSCRIBE or access ARSlist Archives at www.arslist.org ttend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: User Login Alias
** Did you try putting the "special network login ID " in field 117? This should make Remedy Login ID basically be a label. We have a customer that uses their AD login in field 117 but their login is (displays) their email address. That works. Kelly DeaverUnisys Corporation kdea...@kellydeaver.com (ARSlist mail)kelly.dea...@unisys.com(Business mail) Original Message Subject: User Login AliasFrom: Frank Caruso caruso.fr...@gmail.comDate: Fri, February 24, 2012 8:02 amTo: arslist@ARSLIST.ORGITSM 7.6.04 sp2 Oracle RedHat WebLogicCurrent customer would like users to authenticate in Remedy using a special network login ID but then have their full name be used when creating/updating records. I trie using the special field Authentication Alias (117) on the User Form would provide this functionality but it provides ths opposite of what is required. According to BMC the functionality we are looking for is not possible unless we do some custom coding in the midtier. I think they are talking about an SSO solution but am looking for other possible solutions.Thank youFrank Caruso___UNSUBSCRIBE or access ARSlist Archives at www.arslist.orgattend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_
Re: CI Type Reassignment Question?
I wrote a single Meta-Update script for a customer who had 20,000 Computer Systems that needed to be moved into many different classes and had been worked for a year. That meant that they were in relationships, and associated to Incidents, Problems, Changes, had maintenance, support contracts, work logs etc applied. Total effort: 2 days writing the script; 2 days on-site; 2 days support. Problem solved. 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.com Web: 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/ -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mike Hocks Sent: March-08-12 00:34 To: arslist@ARSLIST.ORG Subject: CI Type Reassignment Question? We have some assets that were assigned to the wrong CI Type, does anyone know how to reassign an assests' CI Type? Thanks, -Mike ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Possible bug:Application-Copy-Field-Value
Hi all, So we ran into an issue where this command doesnt work on column IDs of a table. It returns NULL value. Googling about this issue I found this thread https://communities.bmc.com/communities/thread/60582 Workflow objects guide says this Application-Copy-Field-Value target_field_ID source_field_ID Copies a field on the current form to another field on the current form. Returns one of the following integers: 1—Indicates that the assignment failed. 0—Indicates that the assignment occurred. However, I dont see anything being mentioned there about not using Column ID as source field id. The workaround that Misi provided on the link above does work, however should this be considered as a bug? A bug where Application-Copy-field-Value does not treat column ID as a field ID in translating a value. Furthermore it returns exit code value of 0 which is an indication of successful copying! Thanks Chintan. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
How to tell if client=API program
Hello everyone, Is there a way to get the type of client that is signing to AR System? I would like to implement something like this: if the client that is trying to access AR Server is a custom API program (client is not Mid Tier / AR User) then the system should not allow the program to sign in. There is probably an offending API program that is executing large queries and causing performance problems, so we would like to detect which is the client that is causing this behaviour Thank you and Regards, Mauricio ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Accelerating the test environment
Hi, I have a doubt. If I create some workflow that is time dependent I need to wait ta complete time period to do a complete unitary test. For instance, I've programmed an invoice creator from SLM that considers the results of SLA's and generates the invoice monthly. If I want to perform a complete unitary test I need to wait one complete month to see the results. Also theoretically If I want to check several scenarios, I need to wait several months. At other tools I played with the OS clock to simulate travelling through time. But not sure about if I can do this on ARS... Something I'm missing? Regards, Jose M. Huerta Project Manager** Movil: 661 665 088 Telf.: 971 75 03 24 Fax: 971 75 07 94 http://www.sm2baleares.es/ SM2 Baleares S.A. C/Rita Levi Edificio SM2 Parc Bit 07121 Palma de Mallorca http://es-es.facebook.com/pages/SM2-Baleares/158608627954 http://twitter.com/#!/SM2Baleares http://www.linkedin.com/company/sm2-baleares La información contenida en este mensaje de correo electrónico es confidencial. La misma, es enviada con la intención de que únicamente sea leída por la persona(s) a la(s) que va dirigida. El acceso a este mensaje por otras personas no está autorizado, por lo que en tal caso, le rogamos que nos lo comunique por la misma vía, se abstenga de realizar copias del mensaje o remitirlo o entregarlo a otra persona y proceda a borrarlo de inmediato. P Por favor, no imprima este mensaje ni sus documentos adjuntos si no es necesario. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are image002.jpgimage001.jpgimage004.jpgimage003.jpg
Re: Accelerating the test environment
Hi, I see no show-stopper for accelerating the time on your system. The main thing should be to: 1. Make sure your clients (Mid-Tier is only one machine) have the same system time as the server 2. Make sure that your escalations run more frequently. I don't know if the escalation sime-to-run is recalculated each time any escalations is run in that thread. If that is the case, it will be easier. Almost all time based stuff is done on a less/more-than basis, which will make it hard to break. For example ('SLM-Target-Date' $TIMETAMP$). Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Hi, I have a doubt. If I create some workflow that is time dependent I need to wait ta complete time period to do a complete unitary test. For instance, I've programmed an invoice creator from SLM that considers the results of SLA's and generates the invoice monthly. If I want to perform a complete unitary test I need to wait one complete month to see the results. Also theoretically If I want to check several scenarios, I need to wait several months. At other tools I played with the OS clock to simulate travelling through time. But not sure about if I can do this on ARS... Something I'm missing? Regards, Jose M. Huerta Project Manager** Movil: 661 665 088 Telf.: 971 75 03 24 Fax: 971 75 07 94 http://www.sm2baleares.es/ SM2 Baleares S.A. C/Rita Levi Edificio SM2 Parc Bit 07121 Palma de Mallorca http://es-es.facebook.com/pages/SM2-Baleares/158608627954 http://twitter.com/#!/SM2Baleares http://www.linkedin.com/company/sm2-baleares La información contenida en este mensaje de correo electrónico es confidencial. La misma, es enviada con la intención de que únicamente sea leída por la persona(s) a la(s) que va dirigida. El acceso a este mensaje por otras personas no está autorizado, por lo que en tal caso, le rogamos que nos lo comunique por la misma vía, se abstenga de realizar copias del mensaje o remitirlo o entregarlo a otra persona y proceda a borrarlo de inmediato. P Por favor, no imprima este mensaje ni sus documentos adjuntos si no es necesario. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: How to tell if client=API program
Hi, You can check the $CLIENT-TYPE$, but in theory you can set this to any number you like when you build your API-program. For example RRR|Chive uses $CLIENT-TYPE$= to make it easier to do special filter handling for that API-program. If you turn on API/ESCL/FLTR/SQL-logging into the same file, you should be able to find the bulky queries easy enough. I find that the user name is the easiest way to work from in these cases. You will also see IP-addresses of the calling system. Find the user, and talk to that person. Remedy is not really designed to prevent bad queries when users do ad-hoc searching. It is hard to do both in the normal client and in an API-program. As a general rule, I always design my applications to allow access from any type of client. Be that Mid-Tier, AR User, Web-Services or any API-program. It should be impossible to break your system. But on the other hand, bad searches are hard to prevent... Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Hello everyone, Is there a way to get the type of client that is signing to AR System? I would like to implement something like this: if the client that is trying to access AR Server is a custom API program (client is not Mid Tier / AR User) then the system should not allow the program to sign in. There is probably an offending API program that is executing large queries and causing performance problems, so we would like to detect which is the client that is causing this behaviour Thank you and Regards, Mauricio ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are