Re: ARS 7.5 Patch 002 crash
May be the problem is in number of threads ? What is your threads settings ? -- Best regards! Alexander V. Doronin doro...@jet.msk.su 26.10.2009, в 20:09, John Sundberg написал(а): ** Any suggestions? (I know Mid-tier (tomcat) was being restarted) Wondering -- how to interpret this. Is the ARS log saying that it crashed and the last thing it was trying to do was an appadmin Mid-tier logging in? Or -- was that it the last successful thing it did. -John Solaris: Mon Oct 26 10:39:00 2009 390635 : AR System server terminated when a signal/exception was received by the server (ARNOTE 20) Mon Oct 26 10:39:00 2009 11 Timestamp: 1256571540.5126 Thread Id: 40 Version: 7.5.00 Patch 002 200906100308 Jun 10 2009 04:13:52 ServerName: xx84 Database: SQL -- Oracle Hardware: sun4v OS: SunOS 5.10 RPC Id: 1434702 RPC Call: 61 (EXEC) RPC Queue: 390635 Client: User appadmin from Mid-tier (protocol 14) at IP address 192.123.114.26 Form: Logging On: Stacks: /usr/remedy/ARSystem/bin/arserverd:DumpStackTrace+0x110 /usr/remedy/ARSystem/bin/arserverd:SignalTrapProc+0x228 /lib/sparcv9/libc.so.1:0xd614c /lib/sparcv9/libc.so.1:0xc9ce8 /lib/sparcv9/libc.so.1:0xc9ee0 /usr/remedy/ARSystem/bin/arserverd:ShowARValueStruct+0xcd4 [ Signal 11 (SEGV)] /usr/remedy/ARSystem/bin/arserverd:ShowARAssignStruct+0xd4 /usr/remedy/ARSystem/bin/arserverd:ShowARArithOpAssignStruct+0x208 /usr/remedy/ARSystem/bin/arserverd:ShowARAssignStruct+0x380 /usr/remedy/ARSystem/bin/arserverd:GetValueForParseCommand+0x20a0 /usr/remedy/ARSystem/bin/arserverd:arexecuteprocess_14_svc+0xca0 /usr/remedy/ARSystem/bin/arserverd:HandleRPCs+0x2c2f4 /usr/remedy/ARSystem/bin/arserverd:WorkerThread+0xcb0 /usr/remedy/ARSystem/bin/arserverd:RestartableThreadMain+0x88 /usr/remedy/ARSystem/bin/arserverd:UnixThreadStartRoutine+0x17c /lib/sparcv9/libc.so.1:0xd6020 Mon Oct 26 10:39:02 2009 : Action Request System(R) Server Version 7.5.00 Patch 002 200906100308 (c) Copyright 1991-2009 BMC Software, Inc. -- John David Sundberg 235 East 6th Street, Suite 400B St. Paul, MN 55101 (651) 556-0930-work (651) 247-6766-cell (651) 695-8577-fax john.sundb...@kineticdata.com _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Re : AIE 7.1 data conversion - RESOLVED
Wish it was that simple:) The object I am in fact puuling the data from are views and not physical tables. I do not have access to the views at the remote end, and to ask anyone to rebuild the veiws and change the data column would be asking for trouble :) Please let me know if you meant something else. Thanks for your thoughts. --- En date de : Lun 26.10.09, Sabyson Fernandes sebyr...@yahoo.com a écrit : De: Sabyson Fernandes sebyr...@yahoo.com Objet: Re: Re : AIE 7.1 data conversion - RESOLVED À: arslist@ARSLIST.ORG Date: Lundi 26 Octobre 2009, 16h43 ** I faced similar issues with data imports using AIE. To get around limitations of AIE, I create SQL views and perform data manipulation using SQL functions such as convert, dateadd etc. Once the view is created, simply point the AIE job to the view and perform simple field and sql column mappings. Hope this helps. From: Frex Popo frexp...@yahoo.fr To: arslist@ARSLIST.ORG Sent: Mon, October 26, 2009 11:16:13 AM Subject: Re: Re : AIE 7.1 data conversion - RESOLVED ** Good question :) All I did was use funtion|substr which did work but should not have worked, I mean loaded the data but I am still getting warnings, stating data type conflict which I am working on. Thanks --- En date de : Lun 26.10.09, jham36 jha...@gmail.com a écrit : De: jham36 jha...@gmail.com Objet: Re: Re : AIE 7.1 data conversion - RESOLVED À: arslist@ARSLIST.ORG Date: Lundi 26 Octobre 2009, 15h47 What was the solution? On Oct 26, 9:43 am, Frex Popo frexp...@yahoo.fr wrote: Thanks --- En date de : Lun 26.10.09, Frex Popo frexp...@yahoo.fr a écrit : De: Frex Popo frexp...@yahoo.fr Objet: AIE 7.1 data conversion À: arsl...@arslist.org Date: Lundi 26 Octobre 2009, 14h20 Hello everyone, I have a table on a remote database (SQL Server 2005) whose data we are reading to a local form in Remedy. One of the columns in the remote table is of type INTEGER. The target column in the remedy form is of type character. I need to be able to convert the INTEGER data to charaters within the AIE mapping. I am trying to avoid adding a filter to the form to the do the conversion. I looked at the AIE manual but did not see a function to do this. I have perhaps missed something but the only one I could see is the SQL| and the targetSQL| statements... Any thoughts? Many thanks frex ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
AW: AW: Password for Demo Account ? Reset.
this works at least for 7.1 arcache -d -Ua -e001 -n tmp_admin -lw 1 -g '1;' Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Howard Richter Gesendet: Montag, 26. Oktober 2009 18:36 An: arslist@ARSLIST.ORG Betreff: Re: AW: Password for Demo Account ? Reset. ** Is that string for 7.x ? Sent from Howard Richter's iPhone On Oct 26, 2009, at 1:11 PM, Conny Martin conny.mar...@t-systems.com wrote: ** you can add a new user with arcache arcache -d -Ua -e001 -n tmp_admin -lw 1 -g '1;' -s localhost this will add a user tmp_admin with an empty password. If you're on ARS version 6.3 you must ommit -s localhost HTH Kind Regards Conny Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Arbot Drone Gesendet: Montag, 26. Oktober 2009 18:06 An: mailto:arslist@ARSLIST.ORG arslist@ARSLIST.ORG Betreff: Re: Password for Demo Account ? Reset. ** Not comfortable posting the EXACT string to the list. But the external utility used for this purpose is ARCACHE.EXE. Instructions for ARCACHE.EXE usage can be found in the ARSystem Configuring document. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Howard Richter Sent: Monday, October 26, 2009 11:31 AM To: mailto:arslist@ARSLIST.ORG arslist@ARSLIST.ORG Subject: Re: Password for Demo Account ? Reset. ** There use to be a startup string that would reset the Demo account. That is something toggle you could put at that start of the arserver. Its been a long time and in my old age I have forgotten it. Maybe some one has that string. Howard On Mon, Oct 26, 2009 at 11:19 AM, Raj mailto:ravi6...@gmail.com ravi6...@gmail.com wrote: Hello All, By default I know there is no password for Demo, since lot of people in our team has started logging in using Demo. I tried changing it by going into user form. Now, unable to login through Demo / and the new password created in the user form. Is there a way to reset the password for Demo.Tried logging in through other accounts AppAdmin , etc but can't view user form through those accounts . Please advise, Raj ___ UNSUBSCRIBE or access ARSlist Archives at http://www.arslist.org/ www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net mailto:sponsor%3armisoluti...@verizon.net ARSlist: Where the Answers Are -- Howard Richter Red Hat Certified Technician CompTIA Linux+ Certified ITIL Foundation Certified E-Mail = mailto:hbr4...@gmail.com hbr4...@gmail.com LinkedIn Profile = http://www.linkedin.com/in/hbr4270 http://www.linkedin.com/in/hbr4270 _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Re : AIE 7.1 data conversion - RESOLVED
What I mean by I do not have access to the object at the other end is, I can only read the data, I can not change it let alone drop and recreate the views. --- En date de : Mar 27.10.09, Frex Popo frexp...@yahoo.fr a écrit : De: Frex Popo frexp...@yahoo.fr Objet: Re: Re : AIE 7.1 data conversion - RESOLVED À: arslist@ARSLIST.ORG Date: Mardi 27 Octobre 2009, 8h28 Wish it was that simple:) The object I am in fact puuling the data from are views and not physical tables. I do not have access to the views at the remote end, and to ask anyone to rebuild the veiws and change the data column would be asking for trouble :) Please let me know if you meant something else. Thanks for your thoughts. --- En date de : Lun 26.10.09, Sabyson Fernandes sebyr...@yahoo.com a écrit : De: Sabyson Fernandes sebyr...@yahoo.com Objet: Re: Re : AIE 7.1 data conversion - RESOLVED À: arslist@ARSLIST.ORG Date: Lundi 26 Octobre 2009, 16h43 ** I faced similar issues with data imports using AIE. To get around limitations of AIE, I create SQL views and perform data manipulation using SQL functions such as convert, dateadd etc. Once the view is created, simply point the AIE job to the view and perform simple field and sql column mappings. Hope this helps. From: Frex Popo frexp...@yahoo.fr To: arslist@ARSLIST.ORG Sent: Mon, October 26, 2009 11:16:13 AM Subject: Re: Re : AIE 7.1 data conversion - RESOLVED ** Good question :) All I did was use funtion|substr which did work but should not have worked, I mean loaded the data but I am still getting warnings, stating data type conflict which I am working on. Thanks --- En date de : Lun 26.10.09, jham36 jha...@gmail.com a écrit : De: jham36 jha...@gmail.com Objet: Re: Re : AIE 7.1 data conversion - RESOLVED À: arslist@ARSLIST.ORG Date: Lundi 26 Octobre 2009, 15h47 What was the solution? On Oct 26, 9:43 am, Frex Popo frexp...@yahoo.fr wrote: Thanks --- En date de : Lun 26.10.09, Frex Popo frexp...@yahoo.fr a écrit : De: Frex Popo frexp...@yahoo.fr Objet: AIE 7.1 data conversion À: arsl...@arslist.org Date: Lundi 26 Octobre 2009, 14h20 Hello everyone, I have a table on a remote database (SQL Server 2005) whose data we are reading to a local form in Remedy. One of the columns in the remote table is of type INTEGER. The target column in the remedy form is of type character. I need to be able to convert the INTEGER data to charaters within the AIE mapping. I am trying to avoid adding a filter to the form to the do the conversion. I looked at the AIE manual but did not see a function to do this. I have perhaps missed something but the only one I could see is the SQL| and the targetSQL| statements... Any thoughts? Many thanks frex ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: ARS 7.5 Patch 002 crash
Is it a new installation? Check if your old '/usr/lib/locale/C/LC_MESSAGES/arsystem.cat' was replaced with the new one from 7.5. We have seen DSO crashing while logs turned on and the reason turned out to be old arsystem.cat file. On Oct 26, 10:09 am, John Sundberg john.sundb...@kineticdata.com wrote: Any suggestions? (I know Mid-tier (tomcat) was being restarted) Wondering -- how to interpret this. Is the ARS log saying that it crashed and the last thing it was trying to do was an appadmin Mid-tier logging in? Or -- was that it the last successful thing it did. -John Solaris: Mon Oct 26 10:39:00 2009 390635 : AR System server terminated when a signal/exception was received by the server (ARNOTE 20) Mon Oct 26 10:39:00 2009 11 Timestamp: 1256571540.5126 Thread Id: 40 Version: 7.5.00 Patch 002 200906100308 Jun 10 2009 04:13:52 ServerName: xx84 Database: SQL -- Oracle Hardware: sun4v OS: SunOS 5.10 RPC Id: 1434702 RPC Call: 61 (EXEC) RPC Queue: 390635 Client: User appadmin from Mid-tier (protocol 14) at IP address 192.123.114.26 Form: Logging On: Stacks: /usr/remedy/ARSystem/bin/arserverd:DumpStackTrace+0x110 /usr/remedy/ARSystem/bin/arserverd:SignalTrapProc+0x228 /lib/sparcv9/libc.so.1:0xd614c /lib/sparcv9/libc.so.1:0xc9ce8 /lib/sparcv9/libc.so.1:0xc9ee0 /usr/remedy/ARSystem/bin/arserverd:ShowARValueStruct+0xcd4 [ Signal 11 (SEGV)] /usr/remedy/ARSystem/bin/arserverd:ShowARAssignStruct+0xd4 /usr/remedy/ARSystem/bin/arserverd:ShowARArithOpAssignStruct+0x208 /usr/remedy/ARSystem/bin/arserverd:ShowARAssignStruct+0x380 /usr/remedy/ARSystem/bin/arserverd:GetValueForParseCommand+0x20a0 /usr/remedy/ARSystem/bin/arserverd:arexecuteprocess_14_svc+0xca0 /usr/remedy/ARSystem/bin/arserverd:HandleRPCs+0x2c2f4 /usr/remedy/ARSystem/bin/arserverd:WorkerThread+0xcb0 /usr/remedy/ARSystem/bin/arserverd:RestartableThreadMain+0x88 /usr/remedy/ARSystem/bin/arserverd:UnixThreadStartRoutine+0x17c /lib/sparcv9/libc.so.1:0xd6020 Mon Oct 26 10:39:02 2009 : Action Request System(R) Server Version 7.5.00 Patch 002 200906100308 (c) Copyright 1991-2009 BMC Software, Inc. -- John David Sundberg 235 East 6th Street, Suite 400B St. Paul, MN 55101 (651) 556-0930-work (651) 247-6766-cell (651) 695-8577-fax john.sundb...@kineticdata.com ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Need help in AR Import
Hi All, I am trying to import the RSD values to people form through AR Import but am not able to assign the license type. Please help. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
How to write the value of an editable column into the database using a filter guide?
Hi Listers, I'm on ARS 6.3. I have a Table Field with one editable column. While the user is saving the main record, I do a filter loop on it and try to push the values of the column into the base form. This isn't working however. To track the problem down, I've build a message into the filter inside of the Filter Guide and the filter shows that the value of the editable columns is null. The message show correct values of the non- editable columns though. Is it possible to use a filter guide to write the values of an editable column into the database? Mark ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: How to write the value of an editable column into the database using a filter guide?
Good Morning Mark, I have not tried to do this with a filter but have with an active link where I can change the Status. In my case I simple execute on a lose focus, set field where $Column2 $='Request ID' AND $Column5$ != 'Status'. I would think it would work just as well on modify. Since what you are doing is a little more complex you might have to use an active link guide to walk the table. Mark -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Mark Milke Sent: Tuesday, October 27, 2009 6:00 AM To: arslist@ARSLIST.ORG Subject: How to write the value of an editable column into the database using a filter guide? Hi Listers, I'm on ARS 6.3. I have a Table Field with one editable column. While the user is saving the main record, I do a filter loop on it and try to push the values of the column into the base form. This isn't working however. To track the problem down, I've build a message into the filter inside of the Filter Guide and the filter shows that the value of the editable columns is null. The message show correct values of the non- editable columns though. Is it possible to use a filter guide to write the values of an editable column into the database? Mark ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Task Flow bugs corrected
Hi Chuck, Thanks for this info. We have ITSM 7.0 installed, patch 8 and the tasks are a serious problem for us. Busy making your recommended changes to our dev environment so that we can test. Kind Regards, Basil Webster Remedy Developer Siemens Southern Africa IT Solutions and Services (Pty) Ltd Infrastructure Operations 300 Janadel Avenue, Halfway House, 1685 T : +27 11 652 7523 F : +27 86 506 2883 M : +27 82 452 9389 basil.webs...@siemens.com mailto:basil.webs...@siemens.com www.siemens.co.za From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Charles Baldi Sent: Monday, October 26, 2009 5:32 PM To: arslist@ARSLIST.ORG Subject: Task Flow bugs corrected ** All, For anyone who is using the Task Flow engine in Change Management in more than a trivial way, you may have encountered bugs that prevent a built flow from behaving as expected. We did. After several unhelpful and time-wasting discussions with BMC support, we tracked-down and fixed a handful of bugs in the Task Flow engine. Context: ITSM 7.0.03, patch 008. Hoping this may be useful to others, here are the corrections that we made and why. 1. Filter TMS:TAS:Bypassed_MarkFlowTo_NotFollowed The If Action - Push Fields was setting the Flow Status to Flow Followed rather than Flow Not Followed as its name says. This was causing a flow that should be bypassed appear as if it was still active. The correction was to modify the Push Fields to set Status = Flow Not Followed == This was the principle bug we found. Fixing this caused the bypass of Task Groups to function properly. 2. Filter TMS:FLW:Bypassed_TaskEvaluate`! The Run If qualification was looking for Status = Flow Followed to check for bypassed rather than Flow Not Followed. No doubt this bug was hidden because of the first one above (or created because the first one could not be found.) The correction was to change the Run If condition to check for Status = Flow Not Followed. 3. Filter TMS:TGR:Bypassed`! This filter was not properly setting the DO variable zTmpInternal when a Task Group within another Task Group was being bypassed. When this happened the change of Status to Bypassed was being interpreted as a user input change which caused the filter TMS:SHR:Inactive_StatusLock to generate an error. This caused all pending flow updates to roll back leaving the flow unusable. The correction was to add zTmpInternal = Yes to the third Push Fields If Action. 4. Filter TMS:FLW:CheckForOtherFailedFlows I consider this a defect. In a merged flow (i.e., a Task with multiple input flows) if ANY input flow was bypassed, this filter caused the task and all downstream flows to also be bypassed. This is not the behavior I expect. When I have Flow To Successor when = All Complete (in the flow definition) I consider a bypassed input flow to be a completed flow. Therefore if any input is closed normally, then the multiple-input task should be activated normally. The multiple-input task should only be bypassed if ALL inputs are bypassed. This is important because using Any Complete in the flow is not an adequate solution. I want the multi-input task to activate only when all inputs are completed or bypassed. Setting the flow to Any Complete would allow the task to fire prematurely. The correction was to DISABLE the filter. 5. Filter TMS:SHR:varSetNameAsSourceForLabel. Despite what its help text says, this was only setting the source field for a data label if the data variable was an OUTPUT. We need the labels to be set when they are INPUT as well. My correction was to copy the filter and add the opposite condition, in this case ('zTmpVariableID' != $NULL) I hope this saves someone some time and pain. Regards, Chuck Baldi _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ Disclaimer and Confidentiality Note This e-mail communication, its attachments, if any, and any rights attaching to it are, unless the context clearly indicates otherwise, the property of Siemens Limited. It is confidential, private and intended for the addressee only. If you are not the intended recipient and receive this communication in error, you are hereby notified that any review, copying, use, discloser or distribution in any manner whatsoever is strictly prohibited. Please notify the sender immediately that you have received this e-mail in error and delete the e-mail and any copies of it. Views and opinions expressed in this e-mail are those of the sender unless clearly stated as those of Siemens Limited. Siemens Limited accepts no liability for any loss or damage whatsoever, and howsoever incurred or suffered resulting or arising from the use of this e-mail communication and/or its attachments. Siemens Limited does not warrant the integrity
Re: Looking for ways to validate or lock down and then audit foundation data changes
Meta-Update will allow you to validate the foundation data (not lock it down). You would simply generate a report of the foundation data on two different servers and then do a diff between these reports. In fact with Meta-Update, there is no need to lock down foundation data. Foundation data elements can be merged from one server to another by functional groups irrespective of guids, request ids, and all other hidden fields within the foundation data schema set. Contact me off-list for more information. Cheers Ben Chernys Senior Software Architect Software Tool House Inc. Canada / Deutschland / Germany Mobile: +49 171 380 2329GMT + 1 + [ DST ] Email:mailto:ben.cher...@softwaretoolhouse.com mailto:ben.cher...@softwaretoolhouse.com Web: http://www.softwaretoolhouse.com/ http://www.softwaretoolhouse.com A free notepad for Diary fields: http://www.softwaretoolhouse.com/downloads/DiaryFieldEditor.htm http://www.softwaretoolhouse.com/downloads/DiaryFieldEditor.htm An ARS API scripting tool used for migrations, integrations, imports, reports, extracts, batch jobs: http://www.softwaretoolhouse.com/products/SthMupd http://www.softwaretoolhouse.com _ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Howard Richter Sent: October 26, 2009 9:33 PM To: arslist@ARSLIST.ORG Subject: Re: Looking for ways to validate or lock down and then audit foundation data changes ** Joe, Thanks just checking that I did not miss anythig. Take care, Howard On Mon, Oct 26, 2009 at 4:29 PM, Joe DeSouza joe_rem...@yahoo.com wrote: ** Howard, There is nothing currently that would let you do that within the framework of the application as it comes out of the box. Even the Audit function available with the ARS Server post version 6.3, will not really do what you want. What you require calls for customization. Since you say you want to validate foundation data change, you would probably need to build another front-end and a duplicate respository to every piece of foundation data you want to validate before updating. The data you want to update could be set up as a ticket in this duplicate repository, which could be reviewed by some sort of a approval team, and given the green flag commited to the actual foundation form that it belongs to. The repository containing suggested updates to the foundation data could then hold the audit information as it would contain information of what that record was updated to over time.. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Howard Richter Sent: Monday, October 26, 2009 4:00 PM To: arslist@ARSLIST.ORG Subject: Looking for ways to validate or lock down and then audit foundation data changes ** Good morning, afternoon and evening all, Here is a question posed to BMC with no response so far. As we know all of the ITSM 7 foundation data has been placed in a number of different forms with no way of placing this data some type of lock down or good audit trail (other then the last one who modified the record). So my question to the greatest and most intelligent group of Remedy programmers that exists in this world or any world (if you believe that there is Remedy in other worlds), is How to audit and validate changes to all foundation data and where is all of the data stored? That is if an audit of all changes to all foundation data is requested, how could anyone provide that information, without modifying the system? I was asked the question and had some programming ideas, but the customer is trying to stay out of the box. As always thanks, , -- Howard Richter Red Hat Certified Technician CompTIA Linux+ Certified ITIL Foundation Certified E-Mail = hbr4...@gmail.com LinkedIn Profile = http://www.linkedin.com/in/hbr4270 _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ -- Howard Richter Red Hat Certified Technician CompTIA Linux+ Certified ITIL Foundation Certified E-Mail = hbr4...@gmail.com LinkedIn Profile = http://www.linkedin.com/in/hbr4270 _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Submitter of an Ad-Hoc Approval Record
CM 7.5 I have a need to identify who created an ad-hoc approval record when an ad-hoc approval record is added to a change record. The ad-hoc approval records are created using the Application-Command Approval Add-Sig command. The submitter of the approval record (AP:Signature) is always showing Remedy Application Service in the Submitter field. Is there another place that stores who actually submitted the approval record or will I need to customize to capture $USER$. Steps to Reproduce: 1. Open an existing change 2. Click on Approvers Tab 3. Click the Add button 4. Populate the Individual/Group 5. Click Save. Goal: I want to report on the user that clicked the Add button (submitted the approval record). I hope I am just missing something obvious here. TIA Kevin ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: How to write the value of an editable column into the database using a filter guide?
I would agree with Mark. I've always considered editable table fields a 'client' thingI wouldn't personally expect them to be available to filters. I would recommend an AL Guide instead. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Mark Milke Sent: Tuesday, October 27, 2009 4:00 AM To: arslist@ARSLIST.ORG Subject: How to write the value of an editable column into the database using a filter guide? Hi Listers, I'm on ARS 6.3. I have a Table Field with one editable column. While the user is saving the main record, I do a filter loop on it and try to push the values of the column into the base form. This isn't working however. To track the problem down, I've build a message into the filter inside of the Filter Guide and the filter shows that the value of the editable columns is null. The message show correct values of the non- editable columns though. Is it possible to use a filter guide to write the values of an editable column into the database? Mark ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: How to write the value of an editable column into the database using a filter guide?
Mark, This cannot be done through a Filter Guide. You will need to use an Active Link guide. The value in an edited column only exists on the client until some action is taken to push the value to the database. Since the value in the edited column only exists on the client, then this action must come from an active link. Scott Parrish IT Prophets (770) 653-5203 www.itprophets.com -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Mark Milke Sent: Tuesday, October 27, 2009 6:00 AM To: arslist@ARSLIST.ORG Subject: How to write the value of an editable column into the database using a filter guide? Hi Listers, I'm on ARS 6.3. I have a Table Field with one editable column. While the user is saving the main record, I do a filter loop on it and try to push the values of the column into the base form. This isn't working however. To track the problem down, I've build a message into the filter inside of the Filter Guide and the filter shows that the value of the editable columns is null. The message show correct values of the non- editable columns though. Is it possible to use a filter guide to write the values of an editable column into the database? Mark ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Submitter of an Ad-Hoc Approval Record
The submitter of the new approval will always be Remedy Application Server, that is why you can use the Approval Engine to modify records (through approval engine process') without the need to have a licensed user. You will have to add a field and capture $USER$. Question is where do you put the field? The Approval Central and out-of-Box approval table field in the Approvals tab (specifically on a CRQ form) point to the three-way join. If you build the new field on AP:Signature then you will have to need to run arjoinfix.exe to sync the new field and then add it to the three-way join in order to display the data. If you are just running a report instead of presenting a viewable column then you can just add it AP:Signature and create a report. Nice and simple huh? The Approval Engine is a beast but once you really get into it you can use it to do some neat things without a need for new licenses. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kevin Shaffer Sent: Tuesday, October 27, 2009 7:51 AM To: arslist@ARSLIST.ORG Subject: Submitter of an Ad-Hoc Approval Record ** CM 7.5 I have a need to identify who created an ad-hoc approval record when an ad-hoc approval record is added to a change record. The ad-hoc approval records are created using the Application-Command Approval Add-Sig command. The submitter of the approval record (AP:Signature) is always showing Remedy Application Service in the Submitter field. Is there another place that stores who actually submitted the approval record or will I need to customize to capture $USER$. Steps to Reproduce: 1. Open an existing change 2. Click on Approvers Tab 3. Click the Add button 4. Populate the Individual/Group 5. Click Save. Goal: I want to report on the user that clicked the Add button (submitted the approval record). I hope I am just missing something obvious here. TIA Kevin _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: How to write the value of an editable column into the database using a filter guide?
That explains why editable table fields do not work with in Remedy User 7.5 patch 2. I'm not sure if they work in patch 1 but the client does not recognize any value in an editable column. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Scott Parrish Sent: Tuesday, October 27, 2009 8:32 AM To: arslist@ARSLIST.ORG Subject: Re: How to write the value of an editable column into the database using a filter guide? Mark, This cannot be done through a Filter Guide. You will need to use an Active Link guide. The value in an edited column only exists on the client until some action is taken to push the value to the database. Since the value in the edited column only exists on the client, then this action must come from an active link. Scott Parrish IT Prophets (770) 653-5203 www.itprophets.com -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Mark Milke Sent: Tuesday, October 27, 2009 6:00 AM To: arslist@ARSLIST.ORG Subject: How to write the value of an editable column into the database using a filter guide? Hi Listers, I'm on ARS 6.3. I have a Table Field with one editable column. While the user is saving the main record, I do a filter loop on it and try to push the values of the column into the base form. This isn't working however. To track the problem down, I've build a message into the filter inside of the Filter Guide and the filter shows that the value of the editable columns is null. The message show correct values of the non- editable columns though. Is it possible to use a filter guide to write the values of an editable column into the database? Mark ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Server Crash - Event requires attention Permission Denied
Hi Everyone, We added more memory to our server this past weekend. Since then the server keeps crashing at odd moments. What we found in the arerror.log was this: Stacks: Mon Oct 26 20:30:35 2009 : Action Request System(R) Server Version 7.1.00 Patch 007 200904160530 (c) Copyright 1991-2007 BMC Software, Inc. Mon Oct 26 20:30:53 2009 Dispatch : Cannot establish a network connection to the AR System server ( : RPC: Miscellaneous tli error - event requires attentionPermission denied) ARERR - 90 I know that the Misc. tli error can refer to a firewall issue, but the Permission denied is what we can't figure out. Has anyone seen this error before? I tried the BMC KB and that did not help at all. We are on AIX, Remedy v71., and Oracle 10g R3. Any help would be appreciated. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Re : AIE 7.1 data conversion - RESOLVED
I think what he was saying is he creates views in the local Remedy DB pointing to the remote tables/views and does the conversion in his local views. I do the same type of thing here. i.e. I have a local view in my Remedy database that points to a remote table/view. This way I reference everything in Remedy as just the local database and the database view handles the remote info. This came in real handy when the DBA's went and moved (with a domain rename) the remote db. All I had to do was update the local database view and Remedy did not have to change at all. Fred From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Frex Popo Sent: Tuesday, October 27, 2009 2:32 AM To: arslist@ARSLIST.ORG Subject: Re: Re : AIE 7.1 data conversion - RESOLVED ** What I mean by I do not have access to the object at the other end is, I can only read the data, I can not change it let alone drop and recreate the views. --- En date de : Mar 27.10.09, Frex Popo frexp...@yahoo.fr a écrit : De: Frex Popo frexp...@yahoo.fr Objet: Re: Re : AIE 7.1 data conversion - RESOLVED À: arslist@ARSLIST.ORG Date: Mardi 27 Octobre 2009, 8h28 Wish it was that simple:) The object I am in fact puuling the data from are views and not physical tables. I do not have access to the views at the remote end, and to ask anyone to rebuild the views and change the data column would be asking for trouble :) Please let me know if you meant something else. Thanks for your thoughts. --- En date de : Lun 26.10.09, Sabyson Fernandes sebyr...@yahoo.com a écrit : De: Sabyson Fernandes sebyr...@yahoo.com Objet: Re: Re : AIE 7.1 data conversion - RESOLVED À: arslist@ARSLIST.ORG Date: Lundi 26 Octobre 2009, 16h43 ** I faced similar issues with data imports using AIE. To get around limitations of AIE, I create SQL views and perform data manipulation using SQL functions such as convert, dateadd etc. Once the view is created, simply point the AIE job to the view and perform simple field and sql column mappings. Hope this helps. From: Frex Popo frexp...@yahoo.fr To: arslist@ARSLIST.ORG Sent: Mon, October 26, 2009 11:16:13 AM Subject: Re: Re : AIE 7.1 data conversion - RESOLVED ** Good question :) All I did was use funtion|substr which did work but should not have worked, I mean loaded the data but I am still getting warnings, stating data type conflict which I am working on. Thanks --- En date de : Lun 26.10.09, jham36 jha...@gmail.com a écrit : De: jham36 jha...@gmail.com Objet: Re: Re : AIE 7.1 data conversion - RESOLVED À: arslist@ARSLIST.ORG Date: Lundi 26 Octobre 2009, 15h47 What was the solution? On Oct 26, 9:43 am, Frex Popo frexp...@yahoo.fr wrote: Thanks --- En date de : Lun 26.10.09, Frex Popo frexp...@yahoo.fr a écrit : De: Frex Popo frexp...@yahoo.fr Objet: AIE 7.1 data conversion À: arsl...@arslist.org Date: Lundi 26 Octobre 2009, 14h20 Hello everyone, I have a table on a remote database (SQL Server 2005) whose data we are reading to a local form in Remedy. One of the columns in the remote table is of type INTEGER. The target column in the remedy form is of type character. I need to be able to convert the INTEGER data to charaters within the AIE mapping. I am trying to avoid adding a filter to the form to the do the conversion. I looked at the AIE manual but did not see a function to do this. I have perhaps missed something but the only one I could see is the SQL| and the targetSQL| statements... Any thoughts? Many thanks frex ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Java API for ARS - How to obtain a Run-If line from an Active Link (for example)
Hi ARSListers, I have been looking at the Java API but am stumped by Qualifiers. String name1 = Demo; String swd = etno; String sname = dclha002; Integer tcpport = 8001; Integer rpcnum = 0; ARServerUser context=new ARServerUser(name1,swd,,sname, tcpport); // Check and verify user login: try { // If User Pass/Acct name is wrong, this gens an error. context.login(); } catch( ARException e ) { System.out.println( Login Error : + Possible Bad password or acct name. ); //This return ends all further processing and exits... return; } ListActiveLink aLinkObjs=context.getListActiveLinkObjects(AST:WorkLog); int x = 0; for (int i = 0; i aLinkObjs.size(); i++) { System.out.format(\n%20s%60s\n\n, i, aLinkObjs.get(i).getName()); //ActiveLink alink = aLinkObjs.get(x); try{ QualifierInfo encryptedQual = aLinkObjs.get(i).getQualifier(); System.out.println(encryptedQual.toString() ); RelationalOperationInfo qualEnglish = encryptedQual.getRelationalOperationInfo(); System.out.println(Qual : + qualEnglish.toString()); } catch (Exception e){ System.out.println(no Qualification\n); } if (aLinkObjs.get(i).toString().contentEquals(ASI:AWL:Close_100) ) { x = i ; // System.out.println(x); } } context.logout(); } I can get the names of the Active links associated with the named form (in this example I used AST:WorkLog) But I cannot seem to decode the Qualifier. All I get from the output is :- 1 SHR:SHR:Help_003_CheckOnlineHelpInstall_E [Operation=4,Operand Left=[Operation=2,Operand Left=[Operand Type=[type=2],Operand=$LASTCOUNT$],Operand Right=[Operand Type=[type=2],Operand=0]],Operand Right=null] Qual : [Operation=2,Operand Left=[Operand Type=[type=2],Operand=$LASTCOUNT$],Operand Right=[Operand Type=[type=2],Operand=0]] I just need some help in decoding the Qualifier. Anyone got any ideas? Thanks in advance!! David Morgan Senior Technical Consultant Tiberone Technologies Limited Golden Cross House 8 Duncannon Street London WC2N 4JF Ph: +44 (0) 207 484 5069 Fax: +44 (0) 870 8310 381 Mob: +44 (0) 7876 450102 www.tiberone.com http://www.tiberone.com/ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
LDAP/AD Integration Tool
A while back I saw a post about a tool that assists with LDAP/AD integration with Remedy. I cannot seem to find it anymore. If anyone is aware of this or any other add-on tool I would appreciate your assistance. Thanks, Mark ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Java API for ARS - How to obtain a Run-If line from an Active Link (for example)
Wow...ask a tough oneoktook me FOREVER to figure out Qualifiersbut here is basically what you need to do. A QualifierInfo object has three main parts, LeftOperand, Operation, and RightOperand. To explain these parts I will give you an example ('Status' = Fixed) AND ('Create Date' $DATE$) Ok, if that is your QualifierInfo object, here are your pieces LeftOperand = ('Status' = Fixed) Operation = AND RightOperand = ('Create Date' $DATE$) So, what I have done in several programs now is to write an iterative subroutine, if you check the operation to determine if it is a relational operation ( = != etc). If it's not, I throw RightOperand back into the sub till it is, If it is then you know you are down to a single operand, and then you can parse the field/value on left and right for what you want to check/test for. Please let me know if this helps anyit's still a bit fuzzy in my head, but I understand it well enough as it is to do what I need to do. _ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of David Morgan Sent: Tuesday, October 27, 2009 8:33 AM To: arslist@ARSLIST.ORG Subject: Java API for ARS - How to obtain a Run-If line from an Active Link (for example) ** Hi ARSListers, I have been looking at the Java API but am stumped by Qualifiers. String name1 = Demo; String swd = etno; String sname = dclha002; Integer tcpport = 8001; Integer rpcnum = 0; ARServerUser context=new ARServerUser(name1,swd,,sname, tcpport); // Check and verify user login: try { // If User Pass/Acct name is wrong, this gens an error. context.login(); } catch( ARException e ) { System.out.println( Login Error : + Possible Bad password or acct name. ); //This return ends all further processing and exits... return; } ListActiveLink aLinkObjs=context.getListActiveLinkObjects(AST:WorkLog); int x = 0; for (int i = 0; i aLinkObjs.size(); i++) { System.out.format(\n%20s%60s\n\n, i, aLinkObjs.get(i).getName()); //ActiveLink alink = aLinkObjs.get(x); try{ QualifierInfo encryptedQual = aLinkObjs.get(i).getQualifier(); System.out.println(encryptedQual.toString() ); RelationalOperationInfo qualEnglish = encryptedQual.getRelationalOperationInfo(); System.out.println(Qual : + qualEnglish.toString()); } catch (Exception e){ System.out.println(no Qualification\n); } if (aLinkObjs.get(i).toString().contentEquals(ASI:AWL:Close_100) ) { x = i ; // System.out.println(x); } } context.logout(); } I can get the names of the Active links associated with the named form (in this example I used AST:WorkLog) But I cannot seem to decode the Qualifier. All I get from the output is :- 1 SHR:SHR:Help_003_CheckOnlineHelpInstall_E [Operation=4,Operand Left=[Operation=2,Operand Left=[Operand Type=[type=2],Operand=$LASTCOUNT$],Operand Right=[Operand Type=[type=2],Operand=0]],Operand Right=null] Qual : [Operation=2,Operand Left=[Operand Type=[type=2],Operand=$LASTCOUNT$],Operand Right=[Operand Type=[type=2],Operand=0]] I just need some help in decoding the Qualifier. Anyone got any ideas? Thanks in advance!! David Morgan Senior Technical Consultant Tiberone Technologies Limited Golden Cross House 8 Duncannon Street London WC2N 4JF Ph: +44 (0) 207 484 5069 Fax: +44 (0) 870 8310 381 Mob: +44 (0) 7876 450102 http://www.tiberone.com/ www.tiberone.com _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
JOBS: Mid-Level and Senior-Level Remedy ITSM Consultants
Windward IT Solutions is a premier operational management consulting and systems engineering firm that has helped over 200 corporations and government agencies move in the right direction since 1997. Windward is a private company headquartered in Herndon, Virginia and has staff and offices throughout the United States. We are currently looking to add to our team of Mid-Level and Senior-Level Remedy Consultants, located in the Washington, DC area. Please note the Security Clearance requirements. Windward will sponsor likely candidates to obtain a clearance. FTE employment is contingent on either having and existing or receiving an interim security clearance. These positions are not eligible for remote work. Position Summary: A Mid-Level BMC/ITSM/Remedy consultant will have the ability to take detailed customer requirements and implement those requirements on ITSM 7 systems with some direction or guidance. The consultant would also have the ability to lend technical assistance during the analysis, design and implementation of BMC Remedy Service Management applications, for large Federal, enterprise and service provider clients. The developer must have some experience and knowledge in deploying core functionality in an out of box ITSM system; this includes the ability to install the system on at least one server platform and one database. The characteristics of this position include: a working command of technology and architectural concepts; the ability to perform an analysis of client processes; ability to document and develop workflows for system functionality and customization. The successful candidate will work as part of a team on client engagements with some direct supervision. Essential Job Functions: - Provide application support for the configuration, customization, and administration of the ITSM Remedy 7 application in close coordination with the customer staff - Must have a good working knowledge of Service Desk (incident and problem management) - Must have development experience with BMC Remedy version 7.x AR System * Must have BMC Remedy IT Service Management Suite experience on two of the ITSM modules, such as: * BMC Remedy Service Desk * BMC Remedy Asset Management * BMC Remedy Change Management * BMC Remedy Service Level Management * BMC Service Management * Familiarity and experience with BMC Atrium CMDB is preferred, as well as an understanding of Definitive Software Library and its function within the CMDB desirable. * Familiarity and experience with other BMC tools, such as TD/FD is a plus. * Experience and a good working knowledge of the UNIX/Linux operating system is a plus * Experience with scripting languages such as Bourne shell, C shell and Perl is a plus * Experience with Java and XML is a plus * Familiarity with network/application operation and definition within the OSI model including IP, TCP, UDP and ICMP -Work with client management and staff to integrate the client's business objectives, current technical infrastructure and state of the art technologies into enterprise-wide solutions. - Design and/or assess operational processes for effective enterprise wide network and systems technology management. - Apply interpersonal skills to communicate with both technical and business oriented individuals. Education and Prior Experience Requirements * Degree in CS, EE or related MIS field preferred. * Certifications on the BMC Remedy application are preferred. * Training BMC Remedy application or on the core Action Request System are preferred * Minimum of 4 years experience with any version of the Remedy Action Request System as a system administer or programmer * Minimum of 3 years of hands-on Service Desk, to include Remedy experience required (1 year on ITSM 7.x) * A high degree of interpersonal skill in working with various levels of technical and business oriented individuals is required. * Prior experience in a consulting environment is preferred. * DoD Secret Clearance required, Top Secret preferred Position Summary: The Senior BMC/Remedy consultant will take a technical position in the analysis, design and implementation of BMC Remedy Service Management applications for large Federal, enterprise and service provider clients. The developer must have experience and knowledge in deploying core service functionality such as Service Desk. The characteristics of this position include: a superior command of technology and architectural concepts; perform analysis of client processes; ability to develop workflows for system functionality and customization, and provide high quality consulting expertise to clients. The successful candidate will work independently on client engagements with minimal direct supervision and may be required to oversee the work of others. Essential
Re: Re : AIE 7.1 data conversion - RESOLVED
Many thanks Fred for pointing that out. One thing I should have mentioned is that I am not creating any new mappings or exchanges as such ... I am only modifying some existing ones (which have been working fine using AIE) by adding a column(s) to the existing mapping(s).. Your idea sounds good, but I will have to recreate more views locally just to to fix the one or two column(s) issue? I am thinking what's the point then of me having the AIE at all if I can recreate all the views locally, may be little bit later when we already have few exchanges pulling data from different places? The only small issue that I have now left is the warning which I get in one the Debug logs when the AIE starts reading the mapping and validating the data types on both sides when the exchange fires, but apart from that, the data looks correct at the database level and the client as well. Should I worry about the warning? :-) Regards frex --- En date de : Mar 27.10.09, Grooms, Frederick W frederick.w.gro...@xo.com a écrit : De: Grooms, Frederick W frederick.w.gro...@xo.com Objet: Re: Re : AIE 7.1 data conversion - RESOLVED À: arslist@ARSLIST.ORG Date: Mardi 27 Octobre 2009, 15h13 I think what he was saying is he creates views in the local Remedy DB pointing to the remote tables/views and does the conversion in his local views. I do the same type of thing here. i.e. I have a local view in my Remedy database that points to a remote table/view. This way I reference everything in Remedy as just the local database and the database view handles the remote info. This came in real handy when the DBA's went and moved (with a domain rename) the remote db. All I had to do was update the local database view and Remedy did not have to change at all. Fred From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Frex Popo Sent: Tuesday, October 27, 2009 2:32 AM To: arslist@ARSLIST.ORG Subject: Re: Re : AIE 7.1 data conversion - RESOLVED ** What I mean by I do not have access to the object at the other end is, I can only read the data, I can not change it let alone drop and recreate the views. --- En date de : Mar 27.10.09, Frex Popo frexp...@yahoo.fr a écrit : De: Frex Popo frexp...@yahoo.fr Objet: Re: Re : AIE 7.1 data conversion - RESOLVED À: arslist@ARSLIST.ORG Date: Mardi 27 Octobre 2009, 8h28 Wish it was that simple:) The object I am in fact puuling the data from are views and not physical tables. I do not have access to the views at the remote end, and to ask anyone to rebuild the views and change the data column would be asking for trouble :) Please let me know if you meant something else. Thanks for your thoughts. --- En date de : Lun 26.10.09, Sabyson Fernandes sebyr...@yahoo.com a écrit : De: Sabyson Fernandes sebyr...@yahoo.com Objet: Re: Re : AIE 7.1 data conversion - RESOLVED À: arslist@ARSLIST.ORG Date: Lundi 26 Octobre 2009, 16h43 ** I faced similar issues with data imports using AIE. To get around limitations of AIE, I create SQL views and perform data manipulation using SQL functions such as convert, dateadd etc. Once the view is created, simply point the AIE job to the view and perform simple field and sql column mappings. Hope this helps. From: Frex Popo frexp...@yahoo.fr To: arslist@ARSLIST.ORG Sent: Mon, October 26, 2009 11:16:13 AM Subject: Re: Re : AIE 7.1 data conversion - RESOLVED ** Good question :) All I did was use funtion|substr which did work but should not have worked, I mean loaded the data but I am still getting warnings, stating data type conflict which I am working on. Thanks --- En date de : Lun 26.10.09, jham36 jha...@gmail.com a écrit : De: jham36 jha...@gmail.com Objet: Re: Re : AIE 7.1 data conversion - RESOLVED À: arslist@ARSLIST.ORG Date: Lundi 26 Octobre 2009, 15h47 What was the solution? On Oct 26, 9:43 am, Frex Popo frexp...@yahoo.fr wrote: Thanks --- En date de : Lun 26.10.09, Frex Popo frexp...@yahoo.fr a écrit : De: Frex Popo frexp...@yahoo.fr Objet: AIE 7.1 data conversion À: arsl...@arslist.org Date: Lundi 26 Octobre 2009, 14h20 Hello everyone, I have a table on a remote database (SQL Server 2005) whose data we are reading to a local form in Remedy. One of the columns in the remote table is of type INTEGER. The target column in the remedy form is of type character. I need to be able to convert the INTEGER data to charaters within the AIE mapping. I am trying to avoid adding a filter to the form to the do the conversion. I looked at the AIE manual but did not see a function to do this. I have perhaps missed something but the only one I could see is the SQL| and the targetSQL| statements... Any thoughts? Many thanks frex ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist:
DMLAdmin, DMLDataAdmin and other Permission groups ?
Hello All, After a fresh installation of ARS 7.5 P 2 and ITSM 7.5.01. When I looked in the user form there are two users DMLAdmin and DMLDataAdmin who has been allotted fixed licenses. May I know why DMLAdmin and DMLDataAdmin are there ? Are these important for configuring ITSM ? We are only using Service Desk (Incident and Problem Management Modules ) , nothing else from ITSM. Where can I find about the permissions, what permissions needs to be given for specific tasks in ARS and ITSM. Is there a document by BMC where I can look up more information on permissions and permissions groups. Thanks, Raj ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Server Crash - Event requires attention Permission Denied
What's in the log before the Stacks: line? That's the point of the crash. Then you have the version string output from the server restarting and the ARERR 90 from the Dispatch (arsvcdsp) because it is not able to connect to the server. The RPC error is from the dispatch service and is the result of the server crashing, not the cause. Mark From: Action Request System discussion list(ARSList) [arsl...@arslist.org] On Behalf Of jaimie [jaimie...@gmail.com] Sent: 27 October 2009 13:43 To: arslist@ARSLIST.ORG Subject: Server Crash - Event requires attention Permission Denied Hi Everyone, We added more memory to our server this past weekend. Since then the server keeps crashing at odd moments. What we found in the arerror.log was this: Stacks: Mon Oct 26 20:30:35 2009 : Action Request System(R) Server Version 7.1.00 Patch 007 200904160530 (c) Copyright 1991-2007 BMC Software, Inc. Mon Oct 26 20:30:53 2009 Dispatch : Cannot establish a network connection to the AR System server ( : RPC: Miscellaneous tli error - event requires attentionPermission denied) ARERR - 90 I know that the Misc. tli error can refer to a firewall issue, but the Permission denied is what we can't figure out. Has anyone seen this error before? I tried the BMC KB and that did not help at all. We are on AIX, Remedy v71., and Oracle 10g R3. Any help would be appreciated. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: SRM Co-ordinator in ars 7.5
Kiran, When creating the SRD, you will need to specify the Coordinator Group on the Service Request tab in the lower section. Thanks Kelly Gatewood Senior Solutions Architect IT Prophets Cell 615-830-5078 www.itprophets.comhttp://www.itprophets.com From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of kiran Sent: Tuesday, October 27, 2009 11:22 AM To: arslist@ARSLIST.ORG Subject: SRM Co-ordinator in ars 7.5 ** Hi Listers, Can anyone suggest me how to configure SRM co-ordinator in ars 7.5 I have given all the required privileges but no tickets are visible in my co-ordinator console Can anyone please help me Regards, kiran _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Looking for ways to validate or lock down and then audit foundation data changes
Perhaps not exactly what you want but Panacea Workflow Studio allows you to snapshot or archive your server, including foundation data, within a Workflow Studio cache and have one or many snapshots available for browsing, comparing, exporting..etc at a given time. You can then compare foundation data over time using the data comparison functionality (based on any primary key), providing a way of auditing changes. Although you would still have to setup/specify which of the forms holding the foundation data you were interested in within ITSM To do this select your server - specify the Foundation data (with/out subsets) you want to store and the cache will be created for you automatically. You can also incrementally update the cache (and foundation data) either through the gui or from a scheduled job. Once in the cache you can browse/compare the data from the tool as though it were a 'live' server. Thanks and Regards, Deepak Thohan '+44 0 1784 497 047 ( +44 0 7875 009 519 / +44 0 1784 497 048 7 deepak.tho...@pws-europe.com Skype: deepak.thohan web: www.pws-europe.com On Tue, Oct 27, 2009 at 12:49 PM, Ben Chernys ben.cher...@softwaretoolhouse.com wrote: ** Meta-Update will allow you to validate the foundation data (not lock it down). You would simply generate a report of the foundation data on two different servers and then do a diff between these reports. In fact with Meta-Update, there is no need to lock down foundation data. Foundation data elements can be merged from one server to another by functional groups irrespective of guids, request ids, and all other hidden fields within the foundation data schema set. Contact me off-list for more information. Cheers Ben Chernys Senior Software Architect Software Tool House Inc. Canada / Deutschland / Germany Mobile: +49 171 380 2329GMT + 1 + [ DST ] Email: mailto:ben.cher...@softwaretoolhouse.com Web: http://www.softwaretoolhouse.com A free notepad for Diary fields: http://www.softwaretoolhouse.com/downloads/DiaryFieldEditor.htm An ARS API scripting tool used for migrations, integrations, imports, reports, extracts, batch jobs: http://www.softwaretoolhouse.com From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Howard Richter Sent: October 26, 2009 9:33 PM To: arslist@ARSLIST.ORG Subject: Re: Looking for ways to validate or lock down and then audit foundation data changes ** Joe, Thanks just checking that I did not miss anythig. Take care, Howard ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are image001.gif
CMDB Class Id
Hi, Can you help me resolve this error that I get when creating a CI instance in a custom class in CMDB 7.5? Could not find a class with ClassId : OB005056983d094NLlSgIC99KAg34Q The API/Filter log has: +WFFAPI ARIWfFilterAPI -- Service name BMC.FILTERAPI.NORM.ENGINE FLTR TID: 1095362880 RPC ID: 006772 Queue: Fast Client-RPC: 390620USER: radhika -WFFAPIFAIL FLTR TID: 1095362880 RPC ID: 006772 Queue: Fast Client-RPC: 390620USER: radhika Application-Invoke-External-Filter bmc.cmdb.cmdbEngine PHASE=1 CLIENTTYPE=3 FLTR TID: 1095362880 RPC ID: 006772 Queue: Fast Client-RPC: 390620USER: radhika Exit code: 1 Value: FLTR TID: 1095362880 RPC ID: 006772 Queue: Fast Client-RPC: 390620USER: radhika Could not find a class with ClassId : OB005056983d094NLlSgIC99KAg34Q FLTR TID: 1095362880 RPC ID: 006772 Queue: Fast Client-RPC: 390620USER: radhika Error while performing filter action: Error 120527 FLTR TID: 1095362880 RPC ID: 006772 Queue: Fast Client-RPC: 390620USER: radhika Filter CMDB:Instance:InvokeCMDBEngine01: No enabled error handler Thanks Radhika Ph: +44 118 965 0344 _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ Please help Logica to respect the environment by not printing this email / Pour contribuer comme Logica au respect de l'environnement, merci de ne pas imprimer ce mail / Bitte drucken Sie diese Nachricht nicht aus und helfen Sie so Logica dabei, die Umwelt zu schützen. / Por favor ajude a Logica a respeitar o ambiente nao imprimindo este correio electronico. This e-mail and any attachment is for authorised use by the intended recipient(s) only. It may contain proprietary material, confidential information and/or be subject to legal privilege. It should not be copied, disclosed to, retained or used by, any other party. If you are not an intended recipient then please promptly delete this e-mail and any attachment and all copies and inform the sender. Thank you. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Looking for ways to validate or lock down and then audit foundation data changes
In Oracle 11g, you can use a new feature called Flashback Data Archive. The good thing is that you don't need to develop anything or configuring anything in Remedy, it's all done at the database level To know more about this feature, go here: http://www.databasejournal.com/features/oracle/article.php/3786956/article.htm Guillaume -Original Message- From: Action Request System discussion list(ARSList) on behalf of Howard Richter Sent: Mon 10/26/09 3:59 PM To: arslist@ARSLIST.ORG Subject: Looking for ways to validate or lock down and then audit foundation data changes Good morning, afternoon and evening all, Here is a question posed to BMC with no response so far. As we know all of the ITSM 7 foundation data has been placed in a number of different forms with no way of placing this data some type of lock down or good audit trail (other then the last one who modified the record). So my question to the greatest and most intelligent group of Remedy programmers that exists in this world or any world (if you believe that there is Remedy in other worlds), is How to audit and validate changes to all foundation data and where is all of the data stored? That is if an audit of all changes to all foundation data is requested, how could anyone provide that information, without modifying the system? I was asked the question and had some programming ideas, but the customer is trying to stay out of the box. As always thanks, , -- Howard Richter Red Hat Certified Technician CompTIA Linux+ Certified ITIL Foundation Certified E-Mail = hbr4...@gmail.com LinkedIn Profile = http://www.linkedin.com/in/hbr4270 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Hint, to create Remedy Report
Hi list i just try to create a report with a button. i check the workflow, when in a incident we print the report work log. But im not able to create mine, i just want to create a new button in help Desk, and when the user will press the button this will sort the report of an incident. Any hint for me 6 thanks Le pr?sent message est destin? uniquement aux personnes indiqu?es dans l'en-t?te. Il contient des informations confidentielles qui peuvent ?tre divulgu?es ? des tiers sans que l'exp?diteur ait pr?alablement accord? son consentement ? cet ?gard. Si vous n'?tes pas un des destinataires concern?s par cette communication ou une des personne autoris?es ? la recevoir, veuillez en aviser l'exp?diteur par courriel et d?truire toutes copies qui peuvent exister. This message is intended solely for the individual or entity to whom it is adresses. It contains privileged and confidential information which is not to be disclosed without the sender's express consent. If you are not the intended recipient of this message or an authorized representative thereof, please notify the sender by email and then destroy this message as well as all other existing copies. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Incident IDs in 7.5 (and I assume 7.6)
Howard Look under FoundationAdvanced OptionsSystem Settings. I believe it uses the abbreviation on the Company form. Matt From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Howard Richter Sent: 27 October 2009 5:21 PM To: arslist@ARSLIST.ORG Subject: Incident IDs in 7.5 (and I assume 7.6) ** Good morning, afternoon and evening all, I was playing with my 7.5 install and found some incidents IDs that are INC_CAL_116 and not the normal INC0021. I assume that the CAL are the first three letters in the company name Calbro Services.. If I am correct, then is this a new setting and if so how? Take care, Howard -- Howard Richter Red Hat Certified Technician CompTIA Linux+ Certified ITIL Foundation Certified E-Mail = hbr4...@gmail.com LinkedIn Profile = http://www.linkedin.com/in/hbr4270 _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Submitter of an Ad-Hoc Approval Record
** We have the exact same customization request, but for ITSM 7.0.3. The only active link or filter in the entire system that does an Add-Sig (in 7.0.3 anyway) run-process is INT:APRCHG:CSG:SaveNextApprover_RefreshFields_217_Close. So with that in mind, the two options we're considering are: 1. Modify the Application Command Add-Sig in the above active link to include the -l option, and pass in $USER$. The -l option is intended to support multi-tenancy and will set field id 112 on AP:Signature. You can only get away with this if you aren't using multi-tenancy. We'd then put a filter on ap:signature (on submit) to move the value to either the Submitter field or a field we add. Of course, field 112 would need to be set back to it should be. 2. Create a form to use as a control. In the above active link add a push to this form that pushes change id and $USER$ (and maybe approvers list?). Then create a filter on submit of ap:signature that reads the submitter value from that form. And then, of course delete the record on the control form. Keep in mind, that's just a high-level description. Neither of those options seem real great to me, and we haven't actually tried either of them yet, so take it for what its worth. Let me know if you come up with a better way. Thad Esser Remedy Developer Now... Just where did I put that cheese...? From: Kevin Shaffer kevin_l_shaf...@hotmail.com To: arslist@ARSLIST.ORG Date: 10/27/2009 05:51 AM Subject: Submitter of an Ad-Hoc Approval Record Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG ** CM 7.5 I have a need to identify who created an ad-hoc approval record when an ad-hoc approval record is added to a change record. The ad-hoc approval records are created using the Application-Command Approval Add-Sig command. The submitter of the approval record (AP:Signature) is always showing Remedy Application Service in the Submitter field. Is there another place that stores who actually submitted the approval record or will I need to customize to capture $USER$. Steps to Reproduce: 1. Open an existing change 2. Click on Approvers Tab 3. Click the Add button 4. Populate the Individual/Group 5. Click Save. Goal: I want to report on the user that clicked the Add button (submitted the approval record). I hope I am just missing something obvious here. TIA Kevin _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ *IMPORTANT NOTICE: This communication, including any attachment, contains information that may be confidential or privileged, and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message is strictly prohibited. Nothing in this email, including any attachment, is intended to be a legally binding signature. * _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_
Re: Submitter of an Ad-Hoc Approval Record
I believe that you will have problems with pushing $USER$ to the submitter field unless all of your users including approvers are licensed ITSM users. Even if you are licensing all of your approvers though, you could get caught when someone sets and alternate approver and that alternate does not have a license. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Thad K Esser Sent: Tuesday, October 27, 2009 1:06 PM To: arslist@ARSLIST.ORG Subject: Re: Submitter of an Ad-Hoc Approval Record ** We have the exact same customization request, but for ITSM 7.0.3. The only active link or filter in the entire system that does an Add-Sig (in 7.0.3 anyway) run-process is INT:APRCHG:CSG:SaveNextApprover_RefreshFields_217_Close. So with that in mind, the two options we're considering are: 1. Modify the Application Command Add-Sig in the above active link to include the -l option, and pass in $USER$. The -l option is intended to support multi-tenancy and will set field id 112 on AP:Signature. You can only get away with this if you aren't using multi-tenancy. We'd then put a filter on ap:signature (on submit) to move the value to either the Submitter field or a field we add. Of course, field 112 would need to be set back to it should be. 2. Create a form to use as a control. In the above active link add a push to this form that pushes change id and $USER$ (and maybe approvers list?). Then create a filter on submit of ap:signature that reads the submitter value from that form. And then, of course delete the record on the control form. Keep in mind, that's just a high-level description. Neither of those options seem real great to me, and we haven't actually tried either of them yet, so take it for what its worth. Let me know if you come up with a better way. Thad Esser Remedy Developer Now... Just where did I put that cheese...? From: Kevin Shaffer kevin_l_shaf...@hotmail.com To: arslist@ARSLIST.ORG Date: 10/27/2009 05:51 AM Subject: Submitter of an Ad-Hoc Approval Record Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG ** CM 7.5 I have a need to identify who created an ad-hoc approval record when an ad-hoc approval record is added to a change record. The ad-hoc approval records are created using the Application-Command Approval Add-Sig command. The submitter of the approval record (AP:Signature) is always showing Remedy Application Service in the Submitter field. Is there another place that stores who actually submitted the approval record or will I need to customize to capture $USER$. Steps to Reproduce: 1. Open an existing change 2. Click on Approvers Tab 3. Click the Add button 4. Populate the Individual/Group 5. Click Save. Goal: I want to report on the user that clicked the Add button (submitted the approval record). I hope I am just missing something obvious here. TIA Kevin _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ *IMPORTANT NOTICE: This communication, including any attachment, contains information that may be confidential or privileged, and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message is strictly prohibited. Nothing in this email, including any attachment, is intended to be a legally binding signature. * _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Email Engine Unicode?
We have people that create tickets by creating an email and sending to our system. i.e (this is just a portion). I've X'd out the sensitive info…. Schema: Log Call Server: XXX.com Login: XXX Password: X Action: Submit Call Type !536870992!: REQUEST Priority !630100050!: PR6 Network ID* !630100045!: US052825 Building !536870943!: 161 Details !630100060!: Test for Unicode. 泰科电子资讯系统联络人 When they send this to our system, the AR System Email Messages INBOUND email message shows the Chinese Characters, but when the data is pushed over into the Log Call form, the Chinese Characters are turned into ??'s. Is this something that we can fix? It seems like it's breaking down when they email is getting parsed and moved into the Log Call form. Lisa Kemes AR System Developer Tyco Electronics 717-810-2408 tel 717-810-2124 fax lisa.ke...@tycoelectronics.com
Re: company field for new from control access
It's good information and I just tried the assignee field workflow on one of our forms in development and so far, it works like a charm! Lisa -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Chuscazo Sent: Thursday, October 22, 2009 5:51 AM To: arslist@ARSLIST.ORG Subject: Re: company field for new from control access I found the solutions in BMC Remedy IT Service Management 7.0 Guide to Multi-Tenancy.pdf and BMC Remedy Action Request System 7.1.00 Form and Application Objects.pdf All about fiel 112 and Assignee Group permision. Thanks all. bb Chuscazo wrote: Hi, I´m a noob in ars 7.1. I try to create a new form with multi-tenancy access control. I think that the control access is automatic if i create a company field but this dont work. Can you help me with a small scheme? Thanks. -- View this message in context: http://www.nabble.com/company-field-for-new-from-control-access-tp25996658p26007244.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Assigned license issue
Hi Bruce. I am amplifying on Chris Strauss' remarks (his office is across the hall from mine!). The subject random functional failure occurs in our situation just often enough to be very irritating to both support-staffers and the admins trying to fix it. My corrective action has usually taken one of two forms: first-rebuild the permissions list as noted. Second-assign user a fixed license, save CTM:People, then revert the license back to Floating(of course, this does not work if user has fixed license initially-but I have *never* seen this issue occur with a fixed-license account!!). The subject failure has been infrequent enough to elude definitive analysis-but frequent enough to raise users' ire. I would be surprised to see this malady completely disappear in ARS/ITSM7.6or 8.0. HTH... Don W. McClure, P.E. Applications Manager, Call Tracking Administration University of North Texas dwmac (at) unt (dot) edu From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of strauss Sent: Wednesday, October 21, 2009 10:35 PM To: arslist@ARSLIST.ORG Subject: Re: Assigned license issue ** We have seen this many, many times in the last year and a half with ITSM 7.0.02/03 on ARS 7.1, and the cure always seems to be what you had to do. We see it mostly with support staff (who are not using LDAP authentication), but we have actually had a few on customer accounts that lose their company access (and those are all LDAP authenticated). It has something to do with the combination of data in the CTM:People + User + CTM:People Permission Groups forms and how it is cached (or not). Usually all of the group memberships look just fine in all of the forms, and in even the user_cache, but they are not taking effect when the user logs in. It is an annoying defect. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Moore,Bruce Sent: Wednesday, October 21, 2009 2:10 PM To: arslist@ARSLIST.ORG Subject: Re: Assigned license issue ** Thanks for the replies. I've had similar problems as everyone described with guest and upper case before, but that's not the case in this example. No LDAP or Orcale here, we're exclusively Windows in our Remedy environment. Last time I had this issue I ended up deleting the user and recreating the account, I was just trying to prevent from going that route again. *Fix* I ended up deleting all the group and license information in both the People and User form for the user. Once that was done, I set the account back up and had the user test. He was immediately able to login with a floating license, much faster than recreating his entire account. Thanks for the suggestion Sean. -Bruce From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Begosh, Kevin Sent: Wednesday, October 21, 2009 1:18 PM To: arslist@ARSLIST.ORG Subject: Re: Assigned license issue ** I have had this as well where the user says they are logged in as username but when you check the logged in users under license review they were logged in as Username and we allow guest users so it was assigned them to a read licenses as a quest. Kevin Begosh, RSP Remedy Development ACE-IT ISGS Defense 301-791-3540 Phone 240-291-2467 Cell kevin.beg...@lmco.com From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Garrison, Sean (Norcross) Sent: Wednesday, October 21, 2009 10:58 AM To: arslist@ARSLIST.ORG Subject: Re: Assigned license issue ** Are you running Oracle and LDAP? The funny thing is Oracle is case sensitive but LDAP is not. So when a user logs in as Jsmith vs jsmith they may get a read license because Remedy/oracle can't resolve Jsmith. (Assuming his user record is jsmith). Another thing to check is the .multilicense file. If you are running unix remove it from the /etc/arsystem directory (note: it's a hidden file) and restart the server. In addition check to see if you are allowing guest users. He may be misspelling his user id and the system is letting him in any way as a guest user. The last thing I would do is check his CTM:People record vs. what is actually in his User record. Sometimes you have to go back and remove/add permissions again to get the User record corrected. Thanks, Sean From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Moore,Bruce Sent: Wednesday, October 21, 2009 11:12 AM To: arslist@ARSLIST.ORG Subject: Assigned license issue ** I'm having a hard time tracking down a really odd problem I'm having. It's only affecting one or two users, but up to this point BMC has been little help. * AR Server 7.0.1 Patch 006 * Mid-Tier 7.0.1 Patch 006 * ITSM 7.0.1 I have a user that has had a