Re: ARS 7.x: No unique index on Group ID?
Hi, In earlier versions you could even have two users with the same login name but different passwords. I think to recall that this feature was removed in one of the recent versions. I typically put unique indexes on these fields too in the User and Group forms. Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia: * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. * RRR|Translator - Manage and automate your language translations. Find these products, and many free tools and utilities, at http://rrr.se. Michael, I have wondered that aloud too.. Its always been that way.. Even the Login Name does not have a unique index on it in the user form... At least they put a simple index on it.. If I remember right, version 6.x didn't even have that simple index on it.. causing applications like customer support crawl on user form searches if you had close to a million customers.. I asked support about it once and didn't get a good answer as to why an index is missing on that form.. now it looks like they have an index on the Login Name for version 7 but its not unique.. In my experience it doesn't hurt to put those indexes yourself. I've always done it (both on the group and user form) with no negative effects - in fact it helped one of my customers quite a bit on the performance side after introducing those indexes as required.. Some parts of their system was virtually unusable before doing that.. Cheers Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Durrant, Michael M. - ITSD Sent: Wednesday, January 09, 2008 4:11 PM To: arslist@ARSLIST.ORG Subject: ARS 7.x: No unique index on Group ID? ** I did an application export/import from development to production and it replicated our existing Group IDs. Why is there no unique index on Group ID? I can't fathom a situation where I would want differently named groups with the same ID. Am I totally off-base on this or ??? Thanks, Michael No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.516 / Virus Database: 269.19.0/1216 - Release Date: 1/9/2008 10:16 AM ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are -- This message was scanned by ESVA and is believed to be clean. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Portuguese Localization for the Web
Has anyone created a LocalizedMessage_pt.js or LocalizedMessages_pt.properties file they would be willing to share? Am trying to save myself time from translating this into Portuguese? Thanks ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Vertical nav bar HTML content 7 WUT on citix
Hi, We have just had this issue this AM. Installed usertool P 003 and everything is fine again :) Thanks Chris Greg Elphick wrote: ** Hi All nbsp; I am having a spot of problem with the user tool version 7 installed on a citrix server I get the ie error 'path' is undefined when clicking on the buttons. nbsp; I have a feeling its something to do with a temp directory permission problem. nbsp; Has any one had this issue yet? nbsp; Greg nbsp; nbsp;Greg Elphick Advisory Systems Engineer ? [EMAIL PROTECTED] lt; mailto:[EMAIL PROTECTED] gt; É Tel +61 (0)7 3303-3827 Ê Fax +61 (0)7 3364-9777 Mincom. lt; http://www.mincom.com/ gt; The People. The Experience. The Vision. This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise nbsp; __20060125___This posting was submitted with HTML in it___ -- View this message in context: http://www.nabble.com/Vertical-nav-bar-HTML-content-7-WUT-on-citix-tp8727913p14731044.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
ARERR [8939]
Good 2008 for All I get the following error when launching the Overview Console ARERR [8939] The AR System Plug-In server is not responding. Cannot connect to the system at this time. Contact your AR System Administrator for assistance. : RPC: Timed out Any suggestions? Frans Ferreira __ Standard Bank Disclaimer and Confidentiality Note This e-mail, its attachments and any rights attaching hereto are, unless the context clearly indicates otherwise, the property of Standard Bank Group Limited and/or its subsidiaries (the Group). It is confidential, private and intended for the addressee only. Should you not be the addressee and receive this e-mail by mistake, kindly notify the sender, and delete this e-mail, immediately and do not disclose or use same in any manner whatsoever. Views and opinions expressed in this e-mail are those of the sender unless clearly stated as those of the Group. The Group accepts no liability whatsoever for any loss or damages whatsoever and howsoever incurred, or suffered, resulting, or arising, from the use of this email or its attachments. The Group does not warrant the integrity of this e-mail nor that it is free of errors, viruses, interception or interference. Licensed divisions of the Standard Bank Group are authorised financial services providers in terms of the Financial Advisory and Intermediary Services Act, No 37 of 2002 (FAIS). For information about the Standard Bank Group Limited visit our website http://www.standardbank.co.za ___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: ARERR [8939]
++ Please Read The Disclaimer At The Bottom Of This Email ++ This happens when the plugin process on the server hangs or died. You should be able to go to the server and kill the arplugin process. Remedy server service/process should then restart the arplugin automatically and all should work again. If not, you perhaps need to start investigating further and have a look at arplugin log file. Regards Jiri Pospisil LCH.Clearnet -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Ferreira, Frans F Sent: 10 January 2008 11:51 To: arslist@ARSLIST.ORG Subject: ARERR [8939] ** Good 2008 for All I get the following error when launching the Overview Console ARERR [8939] The AR System Plug-In server is not responding. Cannot connect to the system at this time. Contact your AR System Administrator for assistance. : RPC: Timed out Any suggestions? Frans Ferreira __ Standard Bank Disclaimer and Confidentiality Note This e-mail, its attachments and any rights attaching hereto are, unless the context clearly indicates otherwise, the property of Standard Bank Group Limited and/or its subsidiaries (the Group). It is confidential, private and intended for the addressee only. Should you not be the addressee and receive this e-mail by mistake, kindly notify the sender, and delete this e-mail, immediately and do not disclose or use same in any manner whatsoever. Views and opinions expressed in this e-mail are those of the sender unless clearly stated as those of the Group. The Group accepts no liability whatsoever for any loss or damages whatsoever and howsoever incurred, or suffered, resulting, or arising, from the use of this email or its attachments. The Group does not warrant the integrity of this e-mail nor that it is free of errors, viruses, interception or interference. Licensed divisions of the Standard Bank Group are authorised financial services providers in terms of the Financial Advisory and Intermediary Services Act, No 37 of 2002 (FAIS). For information about the Standard Bank Group Limited visit our website http://www.standardbank.co.za http://www.standardbank.co.za __ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ * This email is intended for the named recipient(s) only. Its contents are confidential and may only be retained by the named recipient(s) and may only be copied or disclosed with the consent of LCH.Clearnet Limited. If you are not an intended recipient please delete this e-mail and notify [EMAIL PROTECTED] The contents of this email are subject to contract in all cases, and LCH.Clearnet Limited makes no contractual commitment save where confirmed by hard copy. LCH.Clearnet Limited accepts no liability, including liability for negligence, in respect of any statement in this email. LCH.Clearnet Limited, Registered Office: Aldgate House, 33 Aldgate High Street, London EC3N 1EA.Recognised as a Clearing House under the Financial Services Markets Act 2000. Reg in England No.25932 Telephone: +44 20 7426 7000 Internet: http://www.lchclearnet.com * ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Delete Records of Alert Events
Hello for all, How can I clean up records from a table that growths abnormaly?? I'm facin' a serious problem with Alert Events table. Since 2004 it's been growing without control... Nowadays, this table has around 7 GB... I want to know if have a way that I can delete all records of this table with a security mode (not crashing the server)... Could it be with Escalations? If Yes, how? With Application-Delete-Entry? Application-Query-Delete-Entry?? I thought in a way to delete records based in a range of date... Like taking the date of First record saved in this table and going to deleting month by month (in a range of a month/day)... Is it possible?? Gimme your suggestions, please! Thankx-in-advance... Regards... P.S.1: I have knowledge tha exists the Escalation CleanUpAlertEvents but I think that this way will crash my ARS server if I runs it... P.S.2: I have another tables like that... but Alert Events is the greater... Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq Fone: 41 2107-5736 - HSBC Outsourcing - Confiabilidade, Inovação e Qualidade em T.I. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
RES: Delete Records of Alert Events
Complementing... I'm using: ARS Server: ARS 7.0.01 Patch 004 - Operational System: AIX 5.3 ARS User: ARS 7.0.00 Patch 001 - Operation System: Windows XP Database: Oracle 9i De: Action Request System discussion list(ARSList) em nome de Tadeu Augusto Dutra Pinto Enviada: qui 10/1/2008 10:59 Para: arslist@ARSLIST.ORG Assunto: Delete Records of Alert Events ** Hello for all, How can I clean up records from a table that growths abnormaly?? I'm facin' a serious problem with Alert Events table. Since 2004 it's been growing without control... Nowadays, this table has around 7 GB... I want to know if have a way that I can delete all records of this table with a security mode (not crashing the server)... Could it be with Escalations? If Yes, how? With Application-Delete-Entry? Application-Query-Delete-Entry?? I thought in a way to delete records based in a range of date... Like taking the date of First record saved in this table and going to deleting month by month (in a range of a month/day)... Is it possible?? Gimme your suggestions, please! Thankx-in-advance... Regards... P.S.1: I have knowledge tha exists the Escalation CleanUpAlertEvents but I think that this way will crash my ARS server if I runs it... P.S.2: I have another tables like that... but Alert Events is the greater... Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq Fone: 41 2107-5736 - HSBC Outsourcing - Confiabilidade, Inovação e Qualidade em T.I. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Delete Records of Alert Events
Tadeu, I dealt with this very thing yesterday. Here is what I did, and it did not affect the server. Deleting all these entries from a Remedy client will take forever and may not even complete. Use the TRUNCATE TABLE command (SQL Server) to instantly clear out all entries for this form. To do so, find out the table names that comprise the Remedy form. Run the following command to get the schema number. SELECT schemaId FROM ARSchema WHERE name = 'Alert Events' On my system it is 6. Then run these three commands to clear out all entries (substitute the number 6 for the number on your system). TRUNCATE TABLE T6 TRUNCATE TABLE H6 TRUNCATE TABLE B6 Now that the form is clear add workflow to automatically maintain the form size. Add a display-only radio button field to the form named something like 'Delete This Record'. Add a filter that runs on Modify when this field = 0. The filter will use a Run Process with the command Application-Delete-Entry $SCHEMA$ $1$ to delete the record. Create an escalation that runs once a night which sets the value of 0 to the 'Delete This Record' field when 'Create Date' ($TIMESTAMP$ - (86400 * 21)) This will keep only that last 21 days of entries in this form. Stephen Remedy Skilled Professional From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tadeu Augusto Dutra Pinto Sent: Thursday, January 10, 2008 8:00 AM To: arslist@ARSLIST.ORG Subject: Delete Records of Alert Events Hello for all, How can I clean up records from a table that growths abnormaly?? I'm facin' a serious problem with Alert Events table. Since 2004 it's been growing without control... Nowadays, this table has around 7 GB... I want to know if have a way that I can delete all records of this table with a security mode (not crashing the server)... Could it be with Escalations? If Yes, how? With Application-Delete-Entry? Application-Query-Delete-Entry?? I thought in a way to delete records based in a range of date... Like taking the date of First record saved in this table and going to deleting month by month (in a range of a month/day)... Is it possible?? Gimme your suggestions, please! Thankx-in-advance... Regards... P.S.1: I have knowledge tha exists the Escalation CleanUpAlertEvents but I think that this way will crash my ARS server if I runs it... P.S.2: I have another tables like that... but Alert Events is the greater... Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq Fone: 41 2107-5736 - HSBC Outsourcing - Confiabilidade, Inovação e Qualidade em T.I. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: ARS 7.x: No unique index on Group ID?
Michael,
Actually I think there is at least one good reason for why ARS
supports (or maybe supported is a better phrase) this feature.
The idea is a group alias. ( Two Group form entries with the same
'Group ID' value but different 'Group Name' values.) This is a
designed feature from the old days. Ref: v4.0 admin_vol1.pdf pg
1-26: This is part of a table Table 1-3 Key Fields in Group Form:
Group ID
Integer ID that is the recognized identity of the group. For groups
that you create, the ID should be greater than 10. If you use the same
ID with multiple group names, you must keep the Group type the same
for each because you are creating aliases for the same group.
and a parallel v6.3 doc segment has this to say:
BasicGuide-63.pdf page 114
If you use the same ID with multiple group names, you must keep the
Group type the same for each because you are creating aliases
for the same group.
To make sure that you do not create duplicate Group IDs, use Remedy
Administrator to build a unique index on the Group ID field in the
Group form. (For more information, see Defining indexes on page
210.)
However at the lowest level these values are used for one of two
reasons: Access Controls or Notifications. And the point of the alias
has to do with the latter use not the former.
Over time it is possible (and likely) for your groups to be
organizationally merged. For example: Helpdesk HR(1) and
Helpdesk Technical(10005) might become Service Desk(10005). In the
case of Notification actions in workflow these values are held as
strings('Group Name', 'Login Name', hard coded Email Addresses or
lists of combinations of those things) in the object definitions.
So when groups merge into a new name (or into one existing name) you
need to maintain that 'Group Name' that still has notifications going
to it, or pick through your entire application and replace the old
value(s) with the new value(s). The alias values allow you to solve
this normal change with a data change in one ARS form. ( You can
change the group ID values to now be Helpdesk HR(10005) and Helpdesk
Technical(10005).) This would allow you to not have to change your
application and notification actions sent to Helpdesk HR would now
be routed to the 10005 'Group List' members instead. (Yes you likely
need to move all users in 1 into 10005 in the 'Group List' too. So
that 1 can be total abandoned.)
Keep in mind that if the 'Group ID' is used as an Access Control then
those references are NOT removed by changing data in the Group form.
So if you ever reuse that value later(1) then those places that
this Access Control is used will still be there and will spring back
into life as soon as that group is defined again in the Group Form.
Also if your application allows your users to type (manually) in a
value then that muscle memory of entering Helpdesk HR will also not
go away anytime soon. So you may want to support users still using
that value (for a period of time) to again, not break your existing
processes during changes like this. ( The group alias feature allows
for this.)
So... I think the point was to allow an easier transition under normal
and expected business org changes. However, there may be other good
reasons too.
--
Carey Matthew Black
Remedy Skilled Professional (RSP)
ARS = Action Request System(Remedy)
Love, then teach
Solution = People + Process + Tools
Fast, Accurate, Cheap Pick two.
On Jan 9, 2008 4:10 PM, Durrant, Michael M. - ITSD
[EMAIL PROTECTED] wrote:
**
I did an application export/import from development to production and it
replicated our existing Group IDs. Why is there no unique index on Group
ID? I can't fathom a situation where I would want differently named groups
with the same ID. Am I totally off-base on this or ???
Thanks,
Michael
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
RES: Delete Records of Alert Events
Hi Stephen, Thank you very much for your post... I did the test on my 'test server'... that I have only 2000 records it's runs very well... But, it's safe to execute this command in my 'production server'?? Alert Events on this server has 35.626.325 records... How many records did you delete from your system when you did it? Around 35 million, too?? Thankx-in-advance, again... Regards, Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq Fone: 41 2107-5736 - HSBC Outsourcing - Confiabilidade, Inovação e Qualidade em T.I. De: Action Request System discussion list(ARSList) em nome de Heider, Stephen Enviada: qui 10/1/2008 11:17 Para: arslist@ARSLIST.ORG Assunto: Re: Delete Records of Alert Events ** Tadeu, I dealt with this very thing yesterday. Here is what I did, and it did not affect the server. Deleting all these entries from a Remedy client will take forever and may not even complete. Use the TRUNCATE TABLE command (SQL Server) to instantly clear out all entries for this form. To do so, find out the table names that comprise the Remedy form. Run the following command to get the schema number. SELECT schemaId FROM ARSchema WHERE name = 'Alert Events' On my system it is 6. Then run these three commands to clear out all entries (substitute the number 6 for the number on your system). TRUNCATE TABLE T6 TRUNCATE TABLE H6 TRUNCATE TABLE B6 Now that the form is clear add workflow to automatically maintain the form size. Add a display-only radio button field to the form named something like 'Delete This Record'. Add a filter that runs on Modify when this field = 0. The filter will use a Run Process with the command Application-Delete-Entry $SCHEMA$ $1$ to delete the record. Create an escalation that runs once a night which sets the value of 0 to the 'Delete This Record' field when 'Create Date' ($TIMESTAMP$ - (86400 * 21)) This will keep only that last 21 days of entries in this form. Stephen Remedy Skilled Professional From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tadeu Augusto Dutra Pinto Sent: Thursday, January 10, 2008 8:00 AM To: arslist@ARSLIST.ORG Subject: Delete Records of Alert Events Hello for all, How can I clean up records from a table that growths abnormaly?? I'm facin' a serious problem with Alert Events table. Since 2004 it's been growing without control... Nowadays, this table has around 7 GB... I want to know if have a way that I can delete all records of this table with a security mode (not crashing the server)... Could it be with Escalations? If Yes, how? With Application-Delete-Entry? Application-Query-Delete-Entry?? I thought in a way to delete records based in a range of date... Like taking the date of First record saved in this table and going to deleting month by month (in a range of a month/day)... Is it possible?? Gimme your suggestions, please! Thankx-in-advance... Regards... P.S.1: I have knowledge tha exists the Escalation CleanUpAlertEvents but I think that this way will crash my ARS server if I runs it... P.S.2: I have another tables like that... but Alert Events is the greater... Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq Fone: 41 2107-5736 - HSBC Outsourcing - Confiabilidade, Inovação e Qualidade em T.I. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Delete Records of Alert Events
Tadeu, The form on my server had 500,000 records. However, with the TRUNCATE TABLE command the RDBMS handles the deletions differently than a DELETE FROM command (which is what the Remedy clients use). The DELETE FROM command updates the Transaction Log so in the event of an error it can Rollback the deletions. When you want to completely empty a table then you certainly would not want to use the DELETE FROM. You could end up with a 7GB increase in the size of the Transaction Log and it would take forever because, in your situation, it would need to re-write all 35 million records to the log. The TRUNCATE TABLE command wipes out every record in a table instantly and discards all the data in one command. The Transaction Log is not updated which is why it runs so quickly. I have no reservations at all with running this command in a production environment - so long as you get the table names correct :) However, this is your environment not mine. If you are a little unsure of performing this operation during regular hours (although it should not matter with this command on this particular Remedy form) then you could clear out these entries off-hours after performing a backup of the database. HTH Stephen Remedy Skilled Professional -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tadeu Augusto Dutra Pinto Sent: Thursday, January 10, 2008 8:46 AM To: arslist@ARSLIST.ORG Subject: RES: Delete Records of Alert Events Hi Stephen, Thank you very much for your post... I did the test on my 'test server'... that I have only 2000 records it's runs very well... But, it's safe to execute this command in my 'production server'?? Alert Events on this server has 35.626.325 records... How many records did you delete from your system when you did it? Around 35 million, too?? Thankx-in-advance, again... Regards, Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq Fone: 41 2107-5736 - HSBC Outsourcing - Confiabilidade, Inovação e Qualidade em T.I. De: Action Request System discussion list(ARSList) em nome de Heider, Stephen Enviada: qui 10/1/2008 11:17 Para: arslist@ARSLIST.ORG Assunto: Re: Delete Records of Alert Events ** Tadeu, I dealt with this very thing yesterday. Here is what I did, and it did not affect the server. Deleting all these entries from a Remedy client will take forever and may not even complete. Use the TRUNCATE TABLE command (SQL Server) to instantly clear out all entries for this form. To do so, find out the table names that comprise the Remedy form. Run the following command to get the schema number. SELECT schemaId FROM ARSchema WHERE name = 'Alert Events' On my system it is 6. Then run these three commands to clear out all entries (substitute the number 6 for the number on your system). TRUNCATE TABLE T6 TRUNCATE TABLE H6 TRUNCATE TABLE B6 Now that the form is clear add workflow to automatically maintain the form size. Add a display-only radio button field to the form named something like 'Delete This Record'. Add a filter that runs on Modify when this field = 0. The filter will use a Run Process with the command Application-Delete-Entry $SCHEMA$ $1$ to delete the record. Create an escalation that runs once a night which sets the value of 0 to the 'Delete This Record' field when 'Create Date' ($TIMESTAMP$ - (86400 * 21)) This will keep only that last 21 days of entries in this form. Stephen Remedy Skilled Professional From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tadeu Augusto Dutra Pinto Sent: Thursday, January 10, 2008 8:00 AM To: arslist@ARSLIST.ORG Subject: Delete Records of Alert Events Hello for all, How can I clean up records from a table that growths abnormaly?? I'm facin' a serious problem with Alert Events table. Since 2004 it's been growing without control... Nowadays, this table has around 7 GB... I want to know if have a way that I can delete all records of this table with a security mode (not crashing the server)... Could it be with Escalations? If Yes, how? With Application-Delete-Entry? Application-Query-Delete-Entry?? I thought in a way to delete records based in a range of date... Like taking the date of First record saved in this table and going to deleting month by month (in a range of a month/day)... Is it possible?? Gimme your suggestions, please! Thankx-in-advance... Regards... P.S.1: I have knowledge tha exists the Escalation CleanUpAlertEvents but I think that this way will crash
Python and Web Services
Has anyone written any Python code to call a Remedy web service that they would be willing to share? Thank you Frank ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Remedy Administrator Mid Tier Forms
Hi, I have made changes to the user interface of a form in Remedy Administrator. Do I need to modify the .java or .jsp files on the mid tier to reflect those changes or will the mid tier itself point to the same form in Remedy Administrator and pick it up and will I be able to see the modified form in the Mid Tier. Please let me know. Thanks Rahul ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Active Directory Users getting locked out
Have you tried resetting the user's password to something simple (i.e all lowercase and not symbols, if you're AD allows that) and then have them try logging in to Remedy? I'm wondering if something in the case of the password or perhaps in a symbol could be causing this. J.T. Shyman Column Technologies -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Harry Pugh Sent: Thursday, January 10, 2008 9:53 AM To: arslist@ARSLIST.ORG Subject: Re: Active Directory Users getting locked out The other day when I was watching the user login, they did not mistype their password - which is part of what makes this so strange! :) Mike Pugh Software Engineer AMERICAN SYSTEMS 13990 Parkeast Circle Chantilly, VA 20151 www.AmericanSystems.com phone: (703) 968-5265 mobile: (203) 434-5082 [EMAIL PROTECTED] Contractor of the Year - 5th Annual Greater Washington Government Contractor Awards -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96 CS/SCCE Sent: Thursday, January 10, 2008 9:50 AM To: arslist@ARSLIST.ORG Subject: Re: Active Directory Users getting locked out This may already have been mentioned, so forgive me if I'm being redundant. The old 5.1.2 client (unpatched) did the same very thing you're describing...but only if the user mistyped his/her password. With this issue, if the user mistyped his password just *once*, boom, his account was locked out. I hope that BMC did not reintroduce this bug (or one that's similar) when they released the newer client. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Harry Pugh Sent: Thursday, January 10, 2008 8:37 AM To: arslist@ARSLIST.ORG Subject: Re: Active Directory Users getting locked out ** We have our AREA LDAP configured. The problem is very strange. American Systems Logo Mike Pugh Software Engineer 13990 Parkeast Circle Chantilly, VA 20151 www.AmericanSystems.com http://www.americansystems.com/ phone: (703) 968-5265 mobile: (203) 434-5082 [EMAIL PROTECTED] Contractor of the Year - 5th Annual Greater Washington Government Contractor Awards LEGAL DISCLAIMER: The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Arner, Todd Sent: Wednesday, January 09, 2008 10:10 PM To: arslist@ARSLIST.ORG Subject: Re: Active Directory Users getting locked out ** We had this problem back when we were on ARS 6.3. At that time we were just cross referencing blank password and did not have AREA LDAP configured. Once we configured AREA LDAP, the issue went away. HTH, Todd Arner Great Lakes __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Active Directory Users getting locked out
The other day when I was watching the user login, they did not mistype their password - which is part of what makes this so strange! :) Mike Pugh Software Engineer AMERICAN SYSTEMS 13990 Parkeast Circle Chantilly, VA 20151 www.AmericanSystems.com phone: (703) 968-5265 mobile: (203) 434-5082 [EMAIL PROTECTED] Contractor of the Year - 5th Annual Greater Washington Government Contractor Awards -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96 CS/SCCE Sent: Thursday, January 10, 2008 9:50 AM To: arslist@ARSLIST.ORG Subject: Re: Active Directory Users getting locked out This may already have been mentioned, so forgive me if I'm being redundant. The old 5.1.2 client (unpatched) did the same very thing you're describing...but only if the user mistyped his/her password. With this issue, if the user mistyped his password just *once*, boom, his account was locked out. I hope that BMC did not reintroduce this bug (or one that's similar) when they released the newer client. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Harry Pugh Sent: Thursday, January 10, 2008 8:37 AM To: arslist@ARSLIST.ORG Subject: Re: Active Directory Users getting locked out ** We have our AREA LDAP configured. The problem is very strange. American Systems Logo Mike Pugh Software Engineer 13990 Parkeast Circle Chantilly, VA 20151 www.AmericanSystems.com http://www.americansystems.com/ phone: (703) 968-5265 mobile: (203) 434-5082 [EMAIL PROTECTED] Contractor of the Year - 5th Annual Greater Washington Government Contractor Awards LEGAL DISCLAIMER: The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Arner, Todd Sent: Wednesday, January 09, 2008 10:10 PM To: arslist@ARSLIST.ORG Subject: Re: Active Directory Users getting locked out ** We had this problem back when we were on ARS 6.3. At that time we were just cross referencing blank password and did not have AREA LDAP configured. Once we configured AREA LDAP, the issue went away. HTH, Todd Arner Great Lakes __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Active Directory Users getting locked out
This may already have been mentioned, so forgive me if I'm being redundant. The old 5.1.2 client (unpatched) did the same very thing you're describing...but only if the user mistyped his/her password. With this issue, if the user mistyped his password just *once*, boom, his account was locked out. I hope that BMC did not reintroduce this bug (or one that's similar) when they released the newer client. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Harry Pugh Sent: Thursday, January 10, 2008 8:37 AM To: arslist@ARSLIST.ORG Subject: Re: Active Directory Users getting locked out ** We have our AREA LDAP configured. The problem is very strange. American Systems Logo Mike Pugh Software Engineer 13990 Parkeast Circle Chantilly, VA 20151 www.AmericanSystems.com http://www.americansystems.com/ phone: (703) 968-5265 mobile: (203) 434-5082 [EMAIL PROTECTED] Contractor of the Year - 5th Annual Greater Washington Government Contractor Awards LEGAL DISCLAIMER: The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Arner, Todd Sent: Wednesday, January 09, 2008 10:10 PM To: arslist@ARSLIST.ORG Subject: Re: Active Directory Users getting locked out ** We had this problem back when we were on ARS 6.3. At that time we were just cross referencing blank password and did not have AREA LDAP configured. Once we configured AREA LDAP, the issue went away. HTH, Todd Arner Great Lakes __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
How to Document Workflow?
Are there any tools for documenting specific Remedy workflow? Brian Sokol Manager, Desktop Services Scholastic Inc. 557 Broadway NY, NY 10012 (212) 343-6494 http://www.Scholastic.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Active Directory Users getting locked out
We have our AREA LDAP configured. The problem is very strange. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Arner, Todd Sent: Wednesday, January 09, 2008 10:10 PM To: arslist@ARSLIST.ORG Subject: Re: Active Directory Users getting locked out ** We had this problem back when we were on ARS 6.3. At that time we were just cross referencing blank password and did not have AREA LDAP configured. Once we configured AREA LDAP, the issue went away. HTH, Todd Arner Great Lakes __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ Mike Pugh Software Engineer AMERICAN SYSTEMS 13990 Parkeast Circle Chantilly, VA 20151 www.AmericanSystems.com phone: (703) 968-5265 mobile: (203) 434-5082 [EMAIL PROTECTED] Contractor of the Year - 5th Annual Greater Washington Government Contractor Awards -- LEGAL DISCLAIMER: The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. -- ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are inline: logo.gif
Re: Active Directory Users getting locked out
Yeah...I remember you mentioning that, which throws a monkey wrench into my theory. That really is weird. If it were a strange special character or something causing the problem, you'd think the domain controller would deny access... -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Harry Pugh Sent: Thursday, January 10, 2008 8:53 AM To: arslist@ARSLIST.ORG Subject: Re: Active Directory Users getting locked out The other day when I was watching the user login, they did not mistype their password - which is part of what makes this so strange! :) Mike Pugh Software Engineer AMERICAN SYSTEMS 13990 Parkeast Circle Chantilly, VA 20151 www.AmericanSystems.com phone: (703) 968-5265 mobile: (203) 434-5082 [EMAIL PROTECTED] Contractor of the Year - 5th Annual Greater Washington Government Contractor Awards -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96 CS/SCCE Sent: Thursday, January 10, 2008 9:50 AM To: arslist@ARSLIST.ORG Subject: Re: Active Directory Users getting locked out This may already have been mentioned, so forgive me if I'm being redundant. The old 5.1.2 client (unpatched) did the same very thing you're describing...but only if the user mistyped his/her password. With this issue, if the user mistyped his password just *once*, boom, his account was locked out. I hope that BMC did not reintroduce this bug (or one that's similar) when they released the newer client. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Harry Pugh Sent: Thursday, January 10, 2008 8:37 AM To: arslist@ARSLIST.ORG Subject: Re: Active Directory Users getting locked out ** We have our AREA LDAP configured. The problem is very strange. American Systems Logo Mike Pugh Software Engineer 13990 Parkeast Circle Chantilly, VA 20151 www.AmericanSystems.com http://www.americansystems.com/ phone: (703) 968-5265 mobile: (203) 434-5082 [EMAIL PROTECTED] Contractor of the Year - 5th Annual Greater Washington Government Contractor Awards LEGAL DISCLAIMER: The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Arner, Todd Sent: Wednesday, January 09, 2008 10:10 PM To: arslist@ARSLIST.ORG Subject: Re: Active Directory Users getting locked out ** We had this problem back when we were on ARS 6.3. At that time we were just cross referencing blank password and did not have AREA LDAP configured. Once we configured AREA LDAP, the issue went away. HTH, Todd Arner Great Lakes __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Admin tool crashes when sync search database
Thanks for all the responses guys, we will definitely review them and try some out. Thanks, Gary Opela, Jr Sr. Remedy Developer Leader Communications, Inc. 405 736 3211 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Wednesday, January 09, 2008 11:40 PM To: arslist@ARSLIST.ORG Subject: Re: Admin tool crashes when sync search database ** Gary, Start on a clean slate like someone suggested, by either dropping all the data in the object ref and object details forms.. Run the sync operation and check the contents of the arxref.MMDD-hhmmAM/PM.log file (e.g. arxref.20071226-1116PM.log) generated at the time you run the sync and it fails.. This file is written to only after the operation is complete so do not bother looking at it during the operation. This file may give you an idea of at what point it failed and something to work on to find out the reason why it failed... This file is auto generated in the Admin tool installation directory. Everytime you run the sync operation, a new file is generated.. Post this file to the list.. maybe someone on here may spot something.. Hope this helps.. Cheers Joe (((PS: Incidentally I've faced this problem too, found no obvious cause.. I've faced even problems wherein the Sync process appears to have completed successfully and even resets the admin run flag to 0, but it has actually failed in between, with no errors written to the above file.. I have a ticket open with Remedy Support regarding both these problems on 2 different servers at 2 different client sites..))) -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Payne, George Sent: Wednesday, January 09, 2008 2:38 PM To: arslist@ARSLIST.ORG Subject: Re: Admin tool crashes when sync search database The hardware and O/S are something I would give a look at. I had a sub-admin once with a beefy 64-bit workstation that caused all sorts of problems with the ADMIN tool on 6.3. My poor little 32-bit Windows XP Pro box just ran circles around him. Gp George Payne Corporate Applications Developer Electric Reliability Council of Texas (512) 248-3940 [EMAIL PROTECTED] -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of J.T. Shyman Sent: Wednesday, January 09, 2008 10:10 AM To: arslist@ARSLIST.ORG Subject: Re: Admin tool crashes when sync search database Hmmm. Bad RAM: Maybe, maybe not. Depending on how the RAM is accessed it may only appear at certain times. You're probably right, though. Still, I'd suggest downloading a memory test software such as DocMemory http://www.simmtester.com/page/products/doc/docinfo.asp (bypass the free compulsory registration using www.bugmenot.com ) and run it overnight. Never know. Bad .dll: As you said I'm thinking maybe a support .dll that isn't part of the AR Admin Tool install could be flaking out. Hard to find. Do you and he have the same hardware? The reason I ask is I have seen network card drivers cause crashes in applications on occasion. When it crashes there is an error box that pops up. There should be a more information or something like that. Sometimes looking through that may shed some light on the issue. Also, check the event logs on his system for the previous crashes and see if they point to a file that can't be read or a registry entry that can't be opened or something like that. Sorry for the shotgun approach but chasing down transient errors is one of the more difficult tasks in IT J.T. Shyman Column Technologies -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Opela, Gary L Contr OC-ALC/ITMA Sent: Wednesday, January 09, 2008 10:57 AM To: arslist@ARSLIST.ORG Subject: Re: Admin tool crashes when sync search database He has tried admin tool 6.3 base, and 6.3 patched to v 23. Both seem to do it. He's tried different installs to make sure there aren't issues with the install file. They are the standard install files from remedy, and the same one s I'm using as well. If it were bad RAM, I would expect to be getting memory errors random other times. He and I have the same software, so that shouldn't be an issue. It could be a bad .dll, but then a reinstall should permanently fix that, right? I'm thinking that you are on the right track, a bad file or something somewhere. The issue might not be with remedy though, but with some other files that are shared .dlls or something that remedy uses whenever he tries to sync his search database. Thanks, Gary Opela, Jr Sr. Remedy Developer Leader Communications, Inc. 405 736 3211 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of J.T. Shyman Sent: Wednesday, January 09, 2008 9:54 AM To: arslist@ARSLIST.ORG Subject: Re: Admin tool
RES: Remedy Administrator Mid Tier Forms
Rahul, rs When you make changes for a view from a form in Remedy Admin you need to update de mid tier cache... (i.e. you need to flush the mid tier cache in order to see the change on the web) Enter in Mid Tier Configuration Tool (http://localhost/arsys/shared/config/config.jsp, I think that it is), go to Cache Settings menu and click at Flush Cache button. P.S.: Click Help button for more information about the mid tier cache and the settings. Att, Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq Fone: 41 2107-5736 - HSBC Outsourcing - Confiabilidade, Inovação e Qualidade em T.I. De: Action Request System discussion list(ARSList) em nome de Rahul Takle Enviada: qui 10/1/2008 12:55 Para: arslist@ARSLIST.ORG Assunto: Remedy Administrator Mid Tier Forms ** Hi, I have made changes to the user interface of a form in Remedy Administrator. Do I need to modify the .java or .jsp files on the mid tier to reflect those changes or will the mid tier itself point to the same form in Remedy Administrator and pick it up and will I be able to see the modified form in the Mid Tier. Please let me know. Thanks Rahul __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Remedy Administrator Mid Tier Forms
Rahul, What version of ARS are you using? If you are on ARS 6 or greater you shouldn't have to touch any of the java files. If you want to see the changes you made immediately then you need to log into the Mid-Tier admin page and clear the cache files. Hope that helps. Russ Date: Thu, 10 Jan 2008 09:55:52 -0500 From: [EMAIL PROTECTED] Subject: Remedy Administrator Mid Tier Forms To: arslist@ARSLIST.ORG ** Hi, I have made changes to the user interface of a form in Remedy Administrator. Do I need to modify the .java or .jsp files on the mid tier to reflect those changes or will the mid tier itself point to the same form in Remedy Administrator and pick it up and will I be able to see the modified form in the Mid Tier. Please let me know. Thanks Rahul __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: How to Document Workflow?
What kind of documentation are you trying to achieve? Manual or automated? Rick On 1/10/08, Sokol, Brian [EMAIL PROTECTED] wrote: ** Are there any tools for documenting specific Remedy workflow? Brian Sokol Manager, Desktop Services Scholastic Inc. 557 Broadway NY, NY 10012 (212) 343-6494 *http://www.Scholastic.com* http://www.scholastic.com/ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: NEED ADVICE - Setting up Remedy for incoming mail
Thanks Matt, I was good to go and set up the filters I needed. They worked fine, I guess I thought it would be harder to do then it was. Best Regards, Tom - Original Message - From: Gayford, Matthew C. Date: Wednesday, January 9, 2008 12:43 pm Subject: Re: NEED ADVICE - Setting up Remedy for incoming mail To: arslist@ARSLIST.ORG Check out the email engine documentation. There's a whole section in there on setting up the mailbox to do that. Regards, Matt Matthew C. Gayford Technology Research Development Information Technology Systems Division University of North Carolina Wilmington (910) 962-7177 From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, January 09, 2008 11:33 AM To: arslist@ARSLIST.ORG Subject: Re: NEED ADVICE - Setting up Remedy for incoming mail ** ok I probably misspoke... I already have an incoming mailbox that is setup, it receives emails. But now I want it to modify a ticket based on the reply. Can I simply just create the filters or is there anything I am missing that I may need to do first? Best Regards, Tom Altamore - Original Message - From: Rick Cook Date: Wednesday, January 9, 2008 10:14 am Subject: Re: NEED ADVICE - Setting up Remedy for incoming mail To: arslist@ARSLIST.ORG Not trying to be flip, Tom, but read the install manual - and follow it TO THE LETTER, assuming nothing. Most failed email installs and setups happen because something was not done exactly as the book said it was to be done. Do that, and I'm sure that you will be successful, and you will learn a few things along the way. Rick On 1/9/08, [EMAIL PROTECTED] wrote: ** Hi Listers, I currently have an incoming mail box for Remedy, but it has to date been unused. What else do I need to have this set up properly, on this I am a total novice. Best Regards, Tom Altamore [EMAIL PROTECTED] 914-378-6689 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Delete Records of Alert Events
Tadeu, You could schedule an Archive on the Server Event form and just delete records without putting them into an Archive form. Since you have a large number of records, you could do this in batches to delete smaller chunks at a time and this also could be done after hours... Mike -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tadeu Augusto Dutra Pinto Sent: Thursday, January 10, 2008 7:13 AM To: arslist@ARSLIST.ORG Subject: RES: Delete Records of Alert Events Complementing... I'm using: ARS Server: ARS 7.0.01 Patch 004 - Operational System: AIX 5.3 ARS User: ARS 7.0.00 Patch 001 - Operation System: Windows XP Database: Oracle 9i De: Action Request System discussion list(ARSList) em nome de Tadeu Augusto Dutra Pinto Enviada: qui 10/1/2008 10:59 Para: arslist@ARSLIST.ORG Assunto: Delete Records of Alert Events ** Hello for all, How can I clean up records from a table that growths abnormaly?? I'm facin' a serious problem with Alert Events table. Since 2004 it's been growing without control... Nowadays, this table has around 7 GB... I want to know if have a way that I can delete all records of this table with a security mode (not crashing the server)... Could it be with Escalations? If Yes, how? With Application-Delete-Entry? Application-Query-Delete-Entry?? I thought in a way to delete records based in a range of date... Like taking the date of First record saved in this table and going to deleting month by month (in a range of a month/day)... Is it possible?? Gimme your suggestions, please! Thankx-in-advance... Regards... P.S.1: I have knowledge tha exists the Escalation CleanUpAlertEvents but I think that this way will crash my ARS server if I runs it... P.S.2: I have another tables like that... but Alert Events is the greater... Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq Fone: 41 2107-5736 - HSBC Outsourcing - Confiabilidade, Inovação e Qualidade em T.I. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: How to Document Workflow?
ARInside is my favorite tool at the moment _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sokol, Brian Sent: Thursday, January 10, 2008 7:49 AM To: arslist@ARSLIST.ORG Subject: How to Document Workflow? ** Are there any tools for documenting specific Remedy workflow? Brian Sokol Manager, Desktop Services Scholastic Inc. 557 Broadway NY, NY 10012 (212) 343-6494 http://www.Scholastic.com http://www.Scholastic.com __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Remedy Administrator Mid Tier Forms
If you are on ars 6.3 you will just need to refresh the cache in the MidTier Config tool. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rahul Takle Sent: Thursday, January 10, 2008 6:56 AM To: arslist@ARSLIST.ORG Subject: Remedy Administrator Mid Tier Forms ** Hi, I have made changes to the user interface of a form in Remedy Administrator. Do I need to modify the .java or .jsp files on the mid tier to reflect those changes or will the mid tier itself point to the same form in Remedy Administrator and pick it up and will I be able to see the modified form in the Mid Tier. Please let me know. Thanks Rahul __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: How to Document Workflow?
One thing I did is create a small application that uses server events to track creation and changes in workflow. It still needs some polish and debugging or I'd share it. You could probably build it yourself in a few days. Rick On 1/10/08, Misi Mladoniczky [EMAIL PROTECTED] wrote: Hi, My current favourite for automated documentation is the free ARInside by Stefan Nerlisch. Unfortunately his web page has been hijacked, and I do not know where to find him. The latest release I know of are available at Matt Reinfeldts web site: http://www.mattreinfeldt.com/site/component/option,com_docman/task,cat_view/gid,35/Itemid,28/ Automated documentation is usually pretty dependent on good help-texts on the workflow objects. You can use our free RRR|HelpText editor to highly speed up the process of getting your help texts up to date. Screen Shot: http://rrr.se/c/online/s/rrrhelptext.png Documentation: https://www.rrr.se/c/doc/RRR_HelpText.pdf Download: https://www.rrr.se/cgi/helptext/main Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia: * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. * RRR|Translator - Manage and automate your language translations. Find these products, and many free tools and utilities, at http://rrr.se. What kind of documentation are you trying to achieve? Manual or automated? Rick On 1/10/08, Sokol, Brian [EMAIL PROTECTED] wrote: ** Are there any tools for documenting specific Remedy workflow? Brian Sokol Manager, Desktop Services Scholastic Inc. 557 Broadway NY, NY 10012 (212) 343-6494 *http://www.Scholastic.com* http://www.scholastic.com/ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are -- This message was scanned by ESVA and is believed to be clean. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Incident: Total Time Spent Report
I need a report that gives the Total Time Spent on a set of Incidents. Before I reinvent the wheel here, I'm wondering if anyone else has wandered down this path before me (I suspect this must be a fairly common metric). Because Incident 7.0 collects individual time records in the HPD:Help Desk Assignment Log form, this appears to require a Crystal Report on the Incident form with a sub-report on the HPD:Help Desk Assignment Log form. Any advice from those ahead of me on this path? -ivan- -- Ivan Runions Information Technologies University of Calgary Calgary Alberta Canada (403) 220-4437 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Delete Records of Alert Events
I think my 6.3 install had an escalation to delete the records. The Escalation
ran daily so the daily delete was small.
It had a Run-If something like:
('Create Date' = ($TIMESTAMP$ - (30 * 86400))) OR (( 'Create Date' =
($TIMESTAMP$ - (4 * 86400))) AND ( 'Read' = X))
It did something like:
Application-Delete-Entry $SCHEMA$ $Request ID$
So if the user has not read the alert within 30 days or of it has been 4 days
since they read the alert it would do a delete.
Your problem is just the initial cleanup and you could truncate the T, H, and B
tables for Alert Events as an intial cleanup. You might do an export of the
records that should remain and then import them back after the truncates are
done.
Fred
-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED]
On Behalf Of Kendhammer, Mike
Sent: Thursday, January 10, 2008 9:01 AM
To: arslist@ARSLIST.ORG
Subject: Re: Delete Records of Alert Events
Tadeu,
You could schedule an Archive on the Server Event form and just delete records
without putting them into an Archive form.
Since you have a large number of records, you could do this in batches to
delete smaller chunks at a time and this also could be done after hours...
Mike
-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED]
On Behalf Of Tadeu Augusto Dutra Pinto
Sent: Thursday, January 10, 2008 7:13 AM
To: arslist@ARSLIST.ORG
Subject: RES: Delete Records of Alert Events
Complementing...
I'm using:
ARS Server: ARS 7.0.01 Patch 004 - Operational System: AIX 5.3 ARS User: ARS
7.0.00 Patch 001 - Operation System: Windows XP
Database: Oracle 9i
De: Action Request System discussion list(ARSList) em nome de Tadeu Augusto
Dutra Pinto
Enviada: qui 10/1/2008 10:59
Para: arslist@ARSLIST.ORG
Assunto: Delete Records of Alert Events
**
Hello for all,
How can I clean up records from a table that growths abnormaly??
I'm facin' a serious problem with Alert Events table.
Since 2004 it's been growing without control... Nowadays, this table has around
7 GB...
I want to know if have a way that I can delete all records of this table with a
security mode (not crashing the server)...
Could it be with Escalations?
If Yes, how? With Application-Delete-Entry? Application-Query-Delete-Entry??
I thought in a way to delete records based in a range of date... Like taking
the date of First record saved in this table and going to deleting month by
month (in a range of a month/day)...
Is it possible??
Gimme your suggestions, please!
Thankx-in-advance...
Regards...
P.S.1: I have knowledge tha exists the Escalation CleanUpAlertEvents but I
think that this way will crash my ARS server if I runs it...
P.S.2: I have another tables like that... but Alert Events is the greater...
Tadeu Augusto Dutra Pinto
-
IT Web Services ATM
Cinq Technologies
http://www.cinq.com.br
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
Fone: 41 3018-2833 - Cinq
Fone: 41 2107-5736 - HSBC Outsourcing
-
Confiabilidade, Inovação e Qualidade em T.I.
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: How to Document Workflow?
Hi, My current favourite for automated documentation is the free ARInside by Stefan Nerlisch. Unfortunately his web page has been hijacked, and I do not know where to find him. The latest release I know of are available at Matt Reinfeldts web site: http://www.mattreinfeldt.com/site/component/option,com_docman/task,cat_view/gid,35/Itemid,28/ Automated documentation is usually pretty dependent on good help-texts on the workflow objects. You can use our free RRR|HelpText editor to highly speed up the process of getting your help texts up to date. Screen Shot: http://rrr.se/c/online/s/rrrhelptext.png Documentation: https://www.rrr.se/c/doc/RRR_HelpText.pdf Download: https://www.rrr.se/cgi/helptext/main Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia: * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. * RRR|Translator - Manage and automate your language translations. Find these products, and many free tools and utilities, at http://rrr.se. What kind of documentation are you trying to achieve? Manual or automated? Rick On 1/10/08, Sokol, Brian [EMAIL PROTECTED] wrote: ** Are there any tools for documenting specific Remedy workflow? Brian Sokol Manager, Desktop Services Scholastic Inc. 557 Broadway NY, NY 10012 (212) 343-6494 *http://www.Scholastic.com* http://www.scholastic.com/ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are -- This message was scanned by ESVA and is believed to be clean. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Remedy Administrator Mid Tier Forms
Or just wait until the Mid-Tier automatically re caches. (Depending on Mid-Tier .../config/config.jsp settings.) No Mid-tier(jsp/servelet/etc) file changes should be needed for any ARS Admin tool change. Well, I guess you could add a View Field that points at a URL that requires you to create a file on your web server. However the View field addition is not the part the requires the file change. Just the need to have the file that it is pointed at. :) I hope that makes sense. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On Jan 10, 2008 10:09 AM, Pargeter, Christie [EMAIL PROTECTED] wrote: ** If you are on ars 6.3 you will just need to refresh the cache in the MidTier Config tool. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rahul Takle Sent: Thursday, January 10, 2008 6:56 AM To: arslist@ARSLIST.ORG Subject: Remedy Administrator Mid Tier Forms ** Hi, I have made changes to the user interface of a form in Remedy Administrator. Do I need to modify the .java or .jsp files on the mid tier to reflect those changes or will the mid tier itself point to the same form in Remedy Administrator and pick it up and will I be able to see the modified form in the Mid Tier. Please let me know. Thanks Rahul ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Delete Records of Alert Events
...this got me thinking. It would be useful to see the number of records in each of Remedy's data forms. I just created the attached SQL Server View that lists row counts of just the data tables (T, H, B) and their corresponding form names. To see this inside of Remedy, create a Remedy View form of this SQL View. HTH Stephen Remedy Skilled Professional -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen Sent: Thursday, January 10, 2008 8:59 AM To: arslist@ARSLIST.ORG Subject: Re: Delete Records of Alert Events Tadeu, The form on my server had 500,000 records. However, with the TRUNCATE TABLE command the RDBMS handles the deletions differently than a DELETE FROM command (which is what the Remedy clients use). The DELETE FROM command updates the Transaction Log so in the event of an error it can Rollback the deletions. When you want to completely empty a table then you certainly would not want to use the DELETE FROM. You could end up with a 7GB increase in the size of the Transaction Log and it would take forever because, in your situation, it would need to re-write all 35 million records to the log. The TRUNCATE TABLE command wipes out every record in a table instantly and discards all the data in one command. The Transaction Log is not updated which is why it runs so quickly. I have no reservations at all with running this command in a production environment - so long as you get the table names correct :) However, this is your environment not mine. If you are a little unsure of performing this operation during regular hours (although it should not matter with this command on this particular Remedy form) then you could clear out these entries off-hours after performing a backup of the database. HTH Stephen Remedy Skilled Professional -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tadeu Augusto Dutra Pinto Sent: Thursday, January 10, 2008 8:46 AM To: arslist@ARSLIST.ORG Subject: RES: Delete Records of Alert Events Hi Stephen, Thank you very much for your post... I did the test on my 'test server'... that I have only 2000 records it's runs very well... But, it's safe to execute this command in my 'production server'?? Alert Events on this server has 35.626.325 records... How many records did you delete from your system when you did it? Around 35 million, too?? Thankx-in-advance, again... Regards, Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq Fone: 41 2107-5736 - HSBC Outsourcing - Confiabilidade, Inovação e Qualidade em T.I. De: Action Request System discussion list(ARSList) em nome de Heider, Stephen Enviada: qui 10/1/2008 11:17 Para: arslist@ARSLIST.ORG Assunto: Re: Delete Records of Alert Events ** Tadeu, I dealt with this very thing yesterday. Here is what I did, and it did not affect the server. Deleting all these entries from a Remedy client will take forever and may not even complete. Use the TRUNCATE TABLE command (SQL Server) to instantly clear out all entries for this form. To do so, find out the table names that comprise the Remedy form. Run the following command to get the schema number. SELECT schemaId FROM ARSchema WHERE name = 'Alert Events' On my system it is 6. Then run these three commands to clear out all entries (substitute the number 6 for the number on your system). TRUNCATE TABLE T6 TRUNCATE TABLE H6 TRUNCATE TABLE B6 Now that the form is clear add workflow to automatically maintain the form size. Add a display-only radio button field to the form named something like 'Delete This Record'. Add a filter that runs on Modify when this field = 0. The filter will use a Run Process with the command Application-Delete-Entry $SCHEMA$ $1$ to delete the record. Create an escalation that runs once a night which sets the value of 0 to the 'Delete This Record' field when 'Create Date' ($TIMESTAMP$ - (86400 * 21)) This will keep only that last 21 days of entries in this form. Stephen Remedy Skilled Professional From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tadeu Augusto Dutra Pinto Sent: Thursday, January 10, 2008 8:00 AM To: arslist@ARSLIST.ORG Subject: Delete Records of Alert Events Hello for all, How can I clean up records from a table that growths abnormaly?? I'm facin' a serious problem with Alert Events table. Since 2004 it's been growing without control... Nowadays, this table has around 7 GB... I want to know if have a
Re: Delete Records of Alert Events
One suggestion on the TRUNCATE TABLES, ensure that ARServer is SHUTDOWN because of the possibility that it will be creating records in that particular table while you are executing the sql commands. You do not want to crash your server (possibly) or your user tool/alert tool errors because of Missing H or B table records We have used the Truncate Table many times without any issues, however, also take a backup of your DB prior to execution. Also use the four eyes (two people) to validate there are no typo's in the table_number (the schema ID returned from ARSchema). You would hate to truncate a wrong table... On Jan 10, 2008 8:19 AM, Heider, Stephen [EMAIL PROTECTED] wrote: ...this got me thinking. It would be useful to see the number of records in each of Remedy's data forms. I just created the attached SQL Server View that lists row counts of just the data tables (T, H, B) and their corresponding form names. To see this inside of Remedy, create a Remedy View form of this SQL View. HTH Stephen Remedy Skilled Professional -Original Message- From: Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] On Behalf Of Heider, Stephen Sent: Thursday, January 10, 2008 8:59 AM To: arslist@ARSLIST.ORG Subject: Re: Delete Records of Alert Events Tadeu, The form on my server had 500,000 records. However, with the TRUNCATE TABLE command the RDBMS handles the deletions differently than a DELETE FROM command (which is what the Remedy clients use). The DELETE FROM command updates the Transaction Log so in the event of an error it can Rollback the deletions. When you want to completely empty a table then you certainly would not want to use the DELETE FROM. You could end up with a 7GB increase in the size of the Transaction Log and it would take forever because, in your situation, it would need to re-write all 35 million records to the log. The TRUNCATE TABLE command wipes out every record in a table instantly and discards all the data in one command. The Transaction Log is not updated which is why it runs so quickly. I have no reservations at all with running this command in a production environment - so long as you get the table names correct :) However, this is your environment not mine. If you are a little unsure of performing this operation during regular hours (although it should not matter with this command on this particular Remedy form) then you could clear out these entries off-hours after performing a backup of the database. HTH Stephen Remedy Skilled Professional -Original Message- From: Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] On Behalf Of Tadeu Augusto Dutra Pinto Sent: Thursday, January 10, 2008 8:46 AM To: arslist@ARSLIST.ORG Subject: RES: Delete Records of Alert Events Hi Stephen, Thank you very much for your post... I did the test on my 'test server'... that I have only 2000 records it's runs very well... But, it's safe to execute this command in my 'production server'?? Alert Events on this server has 35.626.325 records... How many records did you delete from your system when you did it? Around 35 million, too?? Thankx-in-advance, again... Regards, Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq Fone: 41 2107-5736 - HSBC Outsourcing - Confiabilidade, Inovação e Qualidade em T.I. De: Action Request System discussion list(ARSList) em nome de Heider, Stephen Enviada: qui 10/1/2008 11:17 Para: arslist@ARSLIST.ORG Assunto: Re: Delete Records of Alert Events ** Tadeu, I dealt with this very thing yesterday. Here is what I did, and it did not affect the server. Deleting all these entries from a Remedy client will take forever and may not even complete. Use the TRUNCATE TABLE command (SQL Server) to instantly clear out all entries for this form. To do so, find out the table names that comprise the Remedy form. Run the following command to get the schema number. SELECT schemaId FROM ARSchema WHERE name = 'Alert Events' On my system it is 6. Then run these three commands to clear out all entries (substitute the number 6 for the number on your system). TRUNCATE TABLE T6 TRUNCATE TABLE H6 TRUNCATE TABLE B6 Now that the form is clear add workflow to automatically maintain the form size. Add a display-only radio button field to the form named something like 'Delete This Record'. Add a filter that runs on Modify when this field = 0. The filter will use a Run Process with the command Application-Delete-Entry $SCHEMA$ $1$ to delete the record. Create an escalation that runs once a night which sets the value of 0
DSO connection errors
Hi all we seem to have pending tickets on our DSO with the following error message. checked the the usual conf/ firewall setting and all seems to be working fine.also I can successfully telnet to the target machine can any one please shed some light on what could be causing this error... thanks ... DIST Get a list of items to process (Thu Jan 10 2008 09:14:37.0006) DIST 2 new item(s) found DIST Processing item number 0 (Thu Jan 10 2008 09:14:37.0063) DIST Pending type -- 1 DIST Source Form -- FUJ:AOL_ITSM:DSO:Data DIST Source ID -- 247 DIST Pending Other -- DIST -m mapping_ftel_to_itsm DIST Get source structure DIST Using EXISTING cache definition for FUJ:AOL_ITSM:DSO:Data DIST Have source structure details, get entry DIST Have entry details, get mapping DIST Filter-specified mapping -- mapping_ftel_to_itsm DIST Mapping name -- mapping_ftel_to_itsm DIST Target form -- AOL_ITSM:DSO_FTELHoldingForm DIST Target server -- ukarsdevfe01.websys.aol.com DIST Get target structure DIST * Access problem trying to get target form definition, retry later... DIST Sleeping for 1:00 minutes ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: How to Document Workflow?
Brian, if you have an application of any size, even if a Word doc could hold all of those cross references, you wouldn't be able to read it due to the massive size. Sync Search DB is probably your best option for now, unless ARInside works better for you. I am hopeful that the new admin tool will allow for some new and creative options, but those would probably be just for application subsets, due again to the volume of data therein. If ARSPerl is ported to a version of ARS that you are using, you might consider using ARSDoc - it worked pretty well back in the day. Apart from that, I wonder if the DB tables produced by the SSD could be displayed in some other way? Rick On 1/10/08, Sokol, Brian [EMAIL PROTECTED] wrote: ** Hi Rick, Manual would be ok. I want to take all the AL and filters for an app (based on a prefix) and output that info to a doc(word, html, pdf). I want to see what triggers all the workflow and all it's actions. -- *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Rick Cook *Sent:* Thursday, January 10, 2008 10:17 AM *To:* arslist@ARSLIST.ORG *Subject:* Re: How to Document Workflow? ** What kind of documentation are you trying to achieve? Manual or automated? Rick On 1/10/08, Sokol, Brian [EMAIL PROTECTED] wrote: ** Are there any tools for documenting specific Remedy workflow? Brian Sokol Manager, Desktop Services Scholastic Inc. 557 Broadway NY, NY 10012 (212) 343-6494 *http://www.Scholastic.com* http://www.scholastic.com/ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: How to Document Workflow?
Hi Rick, Manual would be ok. I want to take all the AL and filters for an app (based on a prefix) and output that info to a doc(word, html, pdf). I want to see what triggers all the workflow and all it's actions. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook Sent: Thursday, January 10, 2008 10:17 AM To: arslist@ARSLIST.ORG Subject: Re: How to Document Workflow? ** What kind of documentation are you trying to achieve? Manual or automated? Rick On 1/10/08, Sokol, Brian [EMAIL PROTECTED] wrote: ** Are there any tools for documenting specific Remedy workflow? Brian Sokol Manager, Desktop Services Scholastic Inc. 557 Broadway NY, NY 10012 (212) 343-6494 http://www.Scholastic.com http://www.scholastic.com/ __Platinum Sponsor: www.rmsportal.com http://www.rmsportal.com/ ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: DSO connection errors
What TCP/IP server port are you using on the source and destination servers? Telnet typically uses port 23, which is not likely the port you have set for your Remedy servers to use (and should not be). The point is, just because you can Telnet to the target machine does not mean the port Remedy wants to use is open at the firewall. That's one thing to check. Norm -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Zaheer Malik Sent: Thursday, January 10, 2008 10:44 AM To: arslist@ARSLIST.ORG Subject: DSO connection errors Importance: High ** Hi all we seem to have pending tickets on our DSO with the following error message. checked the the usual conf/ firewall setting and all seems to be working fine. also I can successfully telnet to the target machine can any one please shed some light on what could be causing this error... thanks ... DIST Get a list of items to process (Thu Jan 10 2008 09:14:37.0006) DIST 2 new item(s) found DIST Processing item number 0 (Thu Jan 10 2008 09:14:37.0063) DIST Pending type -- 1 DIST Source Form -- FUJ:AOL_ITSM:DSO:Data DIST Source ID -- 247 DIST Pending Other -- DIST -m mapping_ftel_to_itsm DIST Get source structure DIST Using EXISTING cache definition for FUJ:AOL_ITSM:DSO:Data DIST Have source structure details, get entry DIST Have entry details, get mapping DIST Filter-specified mapping -- mapping_ftel_to_itsm DIST Mapping name -- mapping_ftel_to_itsm DIST Target form -- AOL_ITSM:DSO_FTELHoldingForm DIST Target server -- ukarsdevfe01.websys.aol.com DIST Get target structure DIST * Access problem trying to get target form definition, retry later... DIST Sleeping for 1:00 minutes mailto:[EMAIL PROTECTED] __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
CSV TO XLS via OLE
Has anyone out there ever tried to utilize OLE to convert .csv files to .xls files? I've been trying to use the example on Gidd's website, but I think I have something wrong. I can get it to convert the .csv file to an .xls file, but it basically seems to be putting all the data in a single cell with the data being separated by a comma. I would have expected it to display the data as it would have the original .csv file, with all the data separated into the rows and columns. Does anyone have any pointers for me on this? I'm open to any suggestions. I just need to be able to have Remedy generate a report and save it in the .xls format. I really don't care about the field formatting or anything like that. Just has to be an .xls file. Thanks, Andy L. Mayfield Sr. System Operation Specialist Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: CSV TO XLS via OLE
Andy, There is a thread from Nov 19 entitled Export Form Data to Excel on Button Action that may help. Stephen Remedy Skilled Professional -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mayfield, Andy L. Sent: Thursday, January 10, 2008 12:39 PM To: arslist@ARSLIST.ORG Subject: CSV TO XLS via OLE Has anyone out there ever tried to utilize OLE to convert .csv files to .xls files? I've been trying to use the example on Gidd's website, but I think I have something wrong. I can get it to convert the .csv file to an .xls file, but it basically seems to be putting all the data in a single cell with the data being separated by a comma. I would have expected it to display the data as it would have the original .csv file, with all the data separated into the rows and columns. Does anyone have any pointers for me on this? I'm open to any suggestions. I just need to be able to have Remedy generate a report and save it in the .xls format. I really don't care about the field formatting or anything like that. Just has to be an .xls file. Thanks, Andy L. Mayfield Sr. System Operation Specialist Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Remedy Performance Monitoring
Hi, I was curious what other people are doing to measure performance. We are having some performance issues. I know we can run Remedy logging (SQL, etc.). Is there a tool that we can use to capture these performance issues. Also do most people use a separate Reporting Server to run reports? **Start the year off right. Easy ways to stay in shape. http://body.aol.com/fitness/winter-exercise?NCID=aolcmp0030002489 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: CSV TO XLS via OLE
Andy, The following is the content of my dde.ini file for sending data to Excel. Please note that the Path statement needs to point to your Excel.exe file (not mine). My dde.ini file is located in: C:\Program Files\AR System\Home. Yours may need to be placed in a different directory. Almost every time we load a new client this location ends up changing. [Xfer-Excel-File] Path=C:\Program Files\Microsoft Office\Office10\EXCEL.EXE Application=Excel Topic=system Format=TAB XFRDATA=File Command1=[OPEN(%f)] Also, please note that any column that Excel determines to be Numerical will lose all leading zeros (i.e. Request ID). There are several ways to resolve this issue, but that would be a different post. I hope this helps. Ron Fariss AIG Global Services Service Desk Automation 713-831-2365 (Office) 281-782-0979 (Mobile) -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mayfield, Andy L. Sent: Thursday, January 10, 2008 11:39 AM To: arslist@ARSLIST.ORG Subject: CSV TO XLS via OLE Has anyone out there ever tried to utilize OLE to convert .csv files to .xls files? I've been trying to use the example on Gidd's website, but I think I have something wrong. I can get it to convert the .csv file to an .xls file, but it basically seems to be putting all the data in a single cell with the data being separated by a comma. I would have expected it to display the data as it would have the original .csv file, with all the data separated into the rows and columns. Does anyone have any pointers for me on this? I'm open to any suggestions. I just need to be able to have Remedy generate a report and save it in the .xls format. I really don't care about the field formatting or anything like that. Just has to be an .xls file. Thanks, Andy L. Mayfield Sr. System Operation Specialist Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: How to Document Workflow?
You may also wish to look at the Analyser product from Abydos. http://www.abydos-workflow.com/Products/AbydosAnalyser/tabid/59/Default. aspx In addition, there is the Remedy Developer Plus product from BMC. http://www.bmc.com/products/proddocview/0,2832,19052_0_43060253_107176,0 0.html -David J. Easter Sr. Product Manager, Service Management Business Unit 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. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sokol, Brian Sent: Thursday, January 10, 2008 6:49 AM To: arslist@ARSLIST.ORG Subject: How to Document Workflow? Are there any tools for documenting specific Remedy workflow? Brian Sokol Manager, Desktop Services Scholastic Inc. 557 Broadway NY, NY 10012 (212) 343-6494 http://www.Scholastic.com http://www.Scholastic.com __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Remedy Link for SQL Server (EIE) Function Syntax
Quick question since the EIE admin guide isn't any help. What's the syntax for using EIE functions in data mappings? I have the Last Modified By field on SHARE:Contact mapped to a field in my external vendor database and the column in my vendor database is limited to 20 characters, so I want to use the LEFT() function to truncate the value coming from Remedy. I inserted the left function using the rules dialog on the EIE:DataMapping form, which resulted in a mapping of function|left(Last Modified By, 20) However, EIE doesn't like this. Here's from the data exchange debug log: [10:33:42,01/10/08] - SqlServer.Initialize: Verifying configuration parameters [10:33:42,01/10/08] - Scheduled Only mode [10:33:42,01/10/08] - CONNECT eFO, USER scc_super_reader (Native Database) [10:33:42,01/10/08] - SET CONCAT_NULL_YIELDS_NULL OFF [10:33:42,01/10/08] - StartDataHandlers: Connection established to both AR/CMDB and vendor application. [10:33:42,01/10/08] - AR System Rules: [10:33:55,01/10/08] - Rules in RuleSet: 'eFO Person Update' [10:33:55,01/10/08] - Rule 1: Street (id: 41300) Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 2: Street 2 (id: 41400) Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 3: Alert (id: 97027) Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 4: Modified Date (id: 6) Set to data type: 7 (Date/Time) [10:33:55,01/10/08] - Rule 5: City (id: 41100) Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 6: Comments (id: 97030) Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 7: Country (id: 40200) Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 8: Primary Email (id: 44000) Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 9: First Name (id: 47300) Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 10: System Status (id: 300317500) Set to data type: 6 (Enum) [10:33:55,01/10/08] - Rule 11: Reference Contact? (id: 536870932) Set to data type: 6 (Enum) [10:33:55,01/10/08] - Rule 12: Job Level (id: 97040) Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 13: No Mailings? (id: 97036) Set to data type: 6 (Enum) [10:33:55,01/10/08] - Rule 14: Reports To (id: 97037) Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 15: Skill Level (id: 536870931) Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 16: State/Province Code (id: 40800) Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 17: Job Title (id: 400022600) Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 18: Postal Code (id: 41200) Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 19: constant|0 Set to data type: 2 (Integer) [10:33:55,01/10/08] - Rule 20: Last Name (id: 47500) Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 21: Pager Number (id: 400097400) Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 22: EFO Org_ID (id: 536870929) Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 23: Primary Phone (id: 400084400) Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 24: function|left(Last Modified By, 20) Set to data type: 4 (Character) [10:33:55,01/10/08] - *** Field Mapping error for Rule 24 *** [10:33:55,01/10/08] - -- ValidateParmType: 2 required parameters not supplied for function LEFT(). [10:33:55,01/10/08] - *** Field Mapping Error for function|left(Last Modified By, 20) *** [10:33:55,01/10/08] - -- ValidateParmType: 2 required parameters not supplied for function LEFT(). [10:33:55,01/10/08] - Key Rule 1: EFO Per_ID (id: 60085) Set to data type: 4 (Character) [10:33:55,01/10/08] - Delete Rule 1: constant|-3 Set to data type: 2 (Integer) [10:33:55,01/10/08] - AR System Keys: [10:33:56,01/10/08] - Key field: 'EFO Per_ID (id: 60085)' [10:33:56,01/10/08] - AR System Query: [10:33:56,01/10/08] - No query defined. All entries will be processed. [10:33:56,01/10/08] - Vendor Rules: What's wrong with the syntax I have above? Should I be putting $ around the AR field name? Thanks. Mike ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Remedy Link for SQL Server (EIE) Function Syntax
Oops. Forgot this. ARS 7.0.1 patch 6 Remedy Link for SQL Server 7.0.1 patch 5 Windows 2003 SP2 SQL Server 2000 SP4 (separate hardware) Mike On Jan 10, 12:32 pm, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Quick question since the EIE admin guide isn't any help. What's the syntax for using EIE functions in data mappings? I have the Last Modified By field on SHARE:Contact mapped to a field in my external vendor database and the column in my vendor database is limited to 20 characters, so I want to use the LEFT() function to truncate the value coming from Remedy. I inserted the left function using the rules dialog on the EIE:DataMapping form, which resulted in a mapping of function|left(Last Modified By, 20) However, EIE doesn't like this. Here's from the data exchange debug log: [10:33:42,01/10/08] - SqlServer.Initialize: Verifying configuration parameters [10:33:42,01/10/08] - Scheduled Only mode [10:33:42,01/10/08] - CONNECT eFO, USER scc_super_reader (Native Database) [10:33:42,01/10/08] - SET CONCAT_NULL_YIELDS_NULL OFF [10:33:42,01/10/08] - StartDataHandlers: Connection established to both AR/CMDB and vendor application. [10:33:42,01/10/08] - AR System Rules: [10:33:55,01/10/08] - Rules in RuleSet: 'eFO Person Update' [10:33:55,01/10/08] - Rule 1: Street (id: 41300) Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 2: Street 2 (id: 41400) Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 3: Alert (id: 97027) Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 4: Modified Date (id: 6) Set to data type: 7 (Date/Time) [10:33:55,01/10/08] - Rule 5: City (id: 41100) Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 6: Comments (id: 97030) Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 7: Country (id: 40200) Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 8: Primary Email (id: 44000) Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 9: First Name (id: 47300) Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 10: System Status (id: 300317500) Set to data type: 6 (Enum) [10:33:55,01/10/08] - Rule 11: Reference Contact? (id: 536870932) Set to data type: 6 (Enum) [10:33:55,01/10/08] - Rule 12: Job Level (id: 97040) Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 13: No Mailings? (id: 97036) Set to data type: 6 (Enum) [10:33:55,01/10/08] - Rule 14: Reports To (id: 97037) Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 15: Skill Level (id: 536870931) Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 16: State/Province Code (id: 40800) Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 17: Job Title (id: 400022600) Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 18: Postal Code (id: 41200) Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 19: constant|0 Set to data type: 2 (Integer) [10:33:55,01/10/08] - Rule 20: Last Name (id: 47500) Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 21: Pager Number (id: 400097400) Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 22: EFO Org_ID (id: 536870929) Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 23: Primary Phone (id: 400084400) Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 24: function|left(Last Modified By, 20) Set to data type: 4 (Character) [10:33:55,01/10/08] - *** Field Mapping error for Rule 24 *** [10:33:55,01/10/08] - -- ValidateParmType: 2 required parameters not supplied for function LEFT(). [10:33:55,01/10/08] - *** Field Mapping Error for function|left(Last Modified By, 20) *** [10:33:55,01/10/08] - -- ValidateParmType: 2 required parameters not supplied for function LEFT(). [10:33:55,01/10/08] - Key Rule 1: EFO Per_ID (id: 60085) Set to data type: 4 (Character) [10:33:55,01/10/08] - Delete Rule 1: constant|-3 Set to data type: 2 (Integer) [10:33:55,01/10/08] - AR System Keys: [10:33:56,01/10/08] - Key field: 'EFO Per_ID (id: 60085)' [10:33:56,01/10/08] - AR System Query: [10:33:56,01/10/08] - No query defined. All entries will be processed. [10:33:56,01/10/08] - Vendor Rules: What's wrong with the syntax I have above? Should I be putting $ around the AR field name? Thanks. Mike ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org Platinum Sponsor:www.rmsportal.comARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Activating an AR System to Vendor Data Exchange (EIE Again) via Workflow
ARS 7.0.1 patch 6 Remedy Link for SQL Server 7.0.1 patch 5 (EIE service on another Win 2K3 box) Windows 2003 SP2 SQL Server 2000 SP4 (separate hardware) So in reading the EIE admin guide, it tells me that I can trigger an AR System to Vendor data exchange by creating a new record in the Application Pending form. Very cool, this is what I've been looking for now that I've been able to upgrade Remedy Link for SQL Server to 7.0.1. The guide tells me to create a record in the Application pending form like this (quoting): In the Other Short field, type the key or the AR System request ID for the record that you want to include in the data exchange, or invoke all records configured for a data exchange using one or more of the parameters inTable 6-1. So to test this, I created a new record in the Application Pending form with -r 0213688|0213232 in the Other Short field (quotes added for readability). I waited patiently for the request to get picked up, and in watching the data exchange's debug log, a bulk exchange was triggered instead of the single record I thought I specified. So I stopped the EIE service and deleted this AP record. So to see what else might be needed, I used eiexfer.exe to create an Application Pending record for the same request ID for the same data exchange. The AP record that was created had a few more fields filled out. Category = EIE Command = the name of the data exchange Form = the instance name of the EIE service Source ID = New Tag = On Scheduled Interval Other Short = same as above When this request was picked up, it also activated a bulk data exchange, so I stopped EIE and deleted this AP record. Next (and this is all I've done so far), I manually created an AP record with all of the data immediately above, but I added -s exchange name (again, quotes for readability) to the Other Short field, since the EIE admin guide specified that the -s option is required for single records. This AP record also triggered a bulk exchange. I have submitted a ticket with BMC, but I usually get better answers here anyway. Thanks, everyone. Mike ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: How to Document Workflow?
David I am on ars 7.1 and have Developer Plus. My understanding is that it will not run against a 7.1 server? From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Easter, David Sent: Thursday, January 10, 2008 1:04 PM To: arslist@ARSLIST.ORG Subject: Re: How to Document Workflow? ** You may also wish to look at the Analyser product from Abydos. http://www.abydos-workflow.com/Products/AbydosAnalyser/tabid/59/Default. aspx In addition, there is the Remedy Developer Plus product from BMC. http://www.bmc.com/products/proddocview/0,2832,19052_0_43060253_107176,0 0.html -David J. Easter Sr. Product Manager, Service Management Business Unit 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. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sokol, Brian Sent: Thursday, January 10, 2008 6:49 AM To: arslist@ARSLIST.ORG Subject: How to Document Workflow? Are there any tools for documenting specific Remedy workflow? Brian Sokol Manager, Desktop Services Scholastic Inc. 557 Broadway NY, NY 10012 (212) 343-6494 http://www.Scholastic.com http://www.Scholastic.com __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Remedy Link for SQL Server (EIE) Function Syntax
Mike, Yes you are missing the $ signs.. I'd also like to warn you that the link to SQL keeps open SQL connections as many times as the number of times you have the schedules run so do not be surprised to find a number of open SQL connections used by EIE open in the SQL process list... As a workaround, recycle the EIE service that runs that EIE mapping to the given SQL server.. Do this using a batch file and using net start service name in a batch file thats scheduled to run just before the start of the schedule, and net stop service name in another batch file that is scheduled to run a while after you anticipate the schedule to have completed its run time.. Cheers Joe - Original Message From: [EMAIL PROTECTED] [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Thursday, January 10, 2008 12:34:31 PM Subject: Re: Remedy Link for SQL Server (EIE) Function Syntax Oops. Forgot this. ARS 7.0.1 patch 6 Remedy Link for SQL Server 7.0.1 patch 5 Windows 2003 SP2 SQL Server 2000 SP4 (separate hardware) Mike On Jan 10, 12:32 pm, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Quick question since the EIE admin guide isn't any help. What's the syntax for using EIE functions in data mappings? I have the Last Modified By field on SHARE:Contact mapped to a field in my external vendor database and the column in my vendor database is limited to 20 characters, so I want to use the LEFT() function to truncate the value coming from Remedy. I inserted the left function using the rules dialog on the EIE:DataMapping form, which resulted in a mapping of function|left(Last Modified By, 20) However, EIE doesn't like this. Here's from the data exchange debug log: [10:33:42,01/10/08] - SqlServer.Initialize: Verifying configuration parameters [10:33:42,01/10/08] - Scheduled Only mode [10:33:42,01/10/08] - CONNECT eFO, USER scc_super_reader (Native Database) [10:33:42,01/10/08] - SET CONCAT_NULL_YIELDS_NULL OFF [10:33:42,01/10/08] - StartDataHandlers: Connection established to both AR/CMDB and vendor application. [10:33:42,01/10/08] - AR System Rules: [10:33:55,01/10/08] - Rules in RuleSet: 'eFO Person Update' [10:33:55,01/10/08] - Rule 1: Street (id: 41300) Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 2: Street 2 (id: 41400) Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 3: Alert (id: 97027) Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 4: Modified Date (id: 6) Set to data type: 7 (Date/Time) [10:33:55,01/10/08] - Rule 5: City (id: 41100) Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 6: Comments (id: 97030) Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 7: Country (id: 40200) Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 8: Primary Email (id: 44000) Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 9: First Name (id: 47300) Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 10: System Status (id: 300317500) Set to data type: 6 (Enum) [10:33:55,01/10/08] - Rule 11: Reference Contact? (id: 536870932) Set to data type: 6 (Enum) [10:33:55,01/10/08] - Rule 12: Job Level (id: 97040) Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 13: No Mailings? (id: 97036) Set to data type: 6 (Enum) [10:33:55,01/10/08] - Rule 14: Reports To (id: 97037) Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 15: Skill Level (id: 536870931) Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 16: State/Province Code (id: 40800) Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 17: Job Title (id: 400022600) Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 18: Postal Code (id: 41200) Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 19: constant|0 Set to data type: 2 (Integer) [10:33:55,01/10/08] - Rule 20: Last Name (id: 47500) Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 21: Pager Number (id: 400097400) Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 22: EFO Org_ID (id: 536870929) Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 23: Primary Phone (id: 400084400) Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 24: function|left(Last Modified By, 20) Set to data type: 4 (Character) [10:33:55,01/10/08] - *** Field Mapping error for Rule 24 *** [10:33:55,01/10/08] - -- ValidateParmType: 2 required parameters not supplied for function LEFT(). [10:33:55,01/10/08] - *** Field Mapping Error for function|left(Last Modified By, 20) *** [10:33:55,01/10/08] - -- ValidateParmType: 2 required parameters not supplied for function LEFT(). [10:33:55,01/10/08] - Key Rule 1: EFO Per_ID (id: 60085) Set to data type: 4 (Character) [10:33:55,01/10/08] - Delete Rule 1: constant|-3 Set to data type: 2 (Integer) [10:33:55,01/10/08] - AR System Keys: [10:33:56,01/10/08] - Key field: 'EFO Per_ID (id: 60085)' [10:33:56,01/10/08]
Re: Remedy Link for SQL Server (EIE) Function Syntax
Mike, yes, try the dollar signs. Also, delete the space between your comma and the number 20. This is a WAG. Drew ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: How to Document Workflow?
Wellthat's certainly interesting if true. _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sokol, Brian Sent: Thursday, January 10, 2008 12:21 PM To: arslist@ARSLIST.ORG Subject: Re: How to Document Workflow? ** David I am on ars 7.1 and have Developer Plus. My understanding is that it will not run against a 7.1 server? _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Easter, David Sent: Thursday, January 10, 2008 1:04 PM To: arslist@ARSLIST.ORG Subject: Re: How to Document Workflow? ** You may also wish to look at the Analyser product from Abydos. http://www.abydos-workflow.com/Products/AbydosAnalyser/tabid/59/Default.aspx In addition, there is the Remedy Developer Plus product from BMC. http://www.bmc.com/products/proddocview/0,2832,19052_0_43060253_107176,00.ht ml -David J. Easter Sr. Product Manager, Service Management Business Unit 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. _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sokol, Brian Sent: Thursday, January 10, 2008 6:49 AM To: arslist@ARSLIST.ORG Subject: How to Document Workflow? Are there any tools for documenting specific Remedy workflow? Brian Sokol Manager, Desktop Services Scholastic Inc. 557 Broadway NY, NY 10012 (212) 343-6494 http://www.Scholastic.com http://www.Scholastic.com __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: How to Document Workflow?
Incorrect. It will run. Please refer to the compatibility matrix. http://www.bmc.com/support/bmcremedycomp/AR_System_7_1_00_Compatibility_ Matrix_v1_0_2.pdf Thanks, -David J. Easter Sr. Product Manager, Service Management Business Unit 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. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sokol, Brian Sent: Thursday, January 10, 2008 11:21 AM To: arslist@ARSLIST.ORG Subject: Re: How to Document Workflow? David I am on ars 7.1 and have Developer Plus. My understanding is that it will not run against a 7.1 server? From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Easter, David Sent: Thursday, January 10, 2008 1:04 PM To: arslist@ARSLIST.ORG Subject: Re: How to Document Workflow? ** You may also wish to look at the Analyser product from Abydos. http://www.abydos-workflow.com/Products/AbydosAnalyser/tabid/59/Default. aspx In addition, there is the Remedy Developer Plus product from BMC. http://www.bmc.com/products/proddocview/0,2832,19052_0_43060253_107176,0 0.html -David J. Easter Sr. Product Manager, Service Management Business Unit 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. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sokol, Brian Sent: Thursday, January 10, 2008 6:49 AM To: arslist@ARSLIST.ORG Subject: How to Document Workflow? Are there any tools for documenting specific Remedy workflow? Brian Sokol Manager, Desktop Services Scholastic Inc. 557 Broadway NY, NY 10012 (212) 343-6494 http://www.Scholastic.com http://www.Scholastic.com __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Licensing Issues
Hey all, We're in the process of upgrading to 7.0 and implementing a server group and I'm running into a few problems with licensing. I've been on and off the phone with BMC licensing to no avail. We have two new servers that I was going to set up as a server group and a third server that we're using as the database. I grabbed a copy of the 5.1.2 database from our production server, installed 5.1.2 server on one of the new server group servers and did a restore. Got 5.1.2 up and running and then upgraded to a working version of 7.0 after some issues were resolved. Anyhow, long story short, both servers now have 7.0, the database has been upgraded, and they're both sharing it. I contacted support and was issued two new licenses, but when I try to apply them via the admin tool, I get an [ARERR 466] Invalid or pre 6.0 AR Server license file (In fact, I get the error when I select Add/Remove licenses from the admin tool). Support has been unable to assist up to this point, so I figured I'd try here and see if any of you had run into an issue like this before. Any ideas? Thanks much, Michael A. McManus, SSgt, USAF Remedy Developer HQ 754 ELSG/DOMH ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Bar Code font on Crystal Reports on Mid-Tier
Hello everyone, We have a Crystal Report in which the call Entry ID appears as a bar code. (For those unfamiliar with bar codes, they are simply fonts in which characters appear as a bunch of lines of various thicknesses, so this is basically a font issue.) We have the font and the Remedy WUT installed on the server, and if we run the report from the WUT we do see the bar code. But from Mid-Tier we just see the Entry ID in plain old numbers and letters. What do we have to do to get Crystal Reports on the web to recognize bar code (or any other) font? (Mid Tier 7.1, no patch, on Win 2003 server, IIS 6 web server, Crystal XI) Dwayne Martin James Madison University ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: DSO connection errors
I've also seen this when you specify an RPC number on your target server connection settings that isn't configured on that target server. But usually it was when our target server was unreachable (network issue) or hung up. Chad Hall (501) 342-2650 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96 CS/SCCE Sent: Thursday, January 10, 2008 11:32 AM To: arslist@ARSLIST.ORG Subject: Re: DSO connection errors What TCP/IP server port are you using on the source and destination servers? Telnet typically uses port 23, which is not likely the port you have set for your Remedy servers to use (and should not be). The point is, just because you can Telnet to the target machine does not mean the port Remedy wants to use is open at the firewall. That's one thing to check. Norm -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Zaheer Malik Sent: Thursday, January 10, 2008 10:44 AM To: arslist@ARSLIST.ORG Subject: DSO connection errors Importance: High ** Hi all we seem to have pending tickets on our DSO with the following error message. checked the the usual conf/ firewall setting and all seems to be working fine. also I can successfully telnet to the target machine can any one please shed some light on what could be causing this error... thanks ... DIST Get a list of items to process (Thu Jan 10 2008 09:14:37.0006) DIST 2 new item(s) found DIST Processing item number 0 (Thu Jan 10 2008 09:14:37.0063) DIST Pending type -- 1 DIST Source Form -- FUJ:AOL_ITSM:DSO:Data DIST Source ID -- 247 DIST Pending Other -- DIST -m mapping_ftel_to_itsm DIST Get source structure DIST Using EXISTING cache definition for FUJ:AOL_ITSM:DSO:Data DIST Have source structure details, get entry DIST Have entry details, get mapping DIST Filter-specified mapping -- mapping_ftel_to_itsm DIST Mapping name -- mapping_ftel_to_itsm DIST Target form -- AOL_ITSM:DSO_FTELHoldingForm DIST Target server -- ukarsdevfe01.websys.aol.com DIST Get target structure DIST * Access problem trying to get target form definition, retry later... DIST Sleeping for 1:00 minutes mailto:[EMAIL PROTECTED] __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are *** The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please resend this communication to the sender and delete the original message or any copy of it from your computer system. Thank You. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Remedy Performance Monitoring
Kathy, Look into RRR|Log. Other ways involve measuring database performance and ar server performance thus indirectly ARS performance. Use the windows tool for this. If you are on unix there are similar, but better, tools. You can disect the api log for this information, but it is painful. John Rosquist Windward - Original Message From: Kathy Morris [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Thursday, January 10, 2008 12:43:08 PM Subject: Remedy Performance Monitoring ** Hi, I was curious what other people are doing to measure performance. We are having some performance issues. I know we can run Remedy logging (SQL, etc.). Is there a tool that we can use to capture these performance issues. Also do most people use a separate Reporting Server to run reports? Start the year off right. Easy ways to stay in shape in the new year. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ Looking for last minute shopping deals? Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Remedy Link for SQL Server (EIE) Function Syntax
Thanks to the both of you. The dollar signs are what took care of it. On 1/10/08, Drew Shuller [EMAIL PROTECTED] wrote: Mike, yes, try the dollar signs. Also, delete the space between your comma and the number 20. This is a WAG. Drew ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: How to Document Workflow?
Brian, You might want to check into the capabilities of Panacea Workflow Studio from Panacea Workflow Systems, http://pws-europe.com/ Works for me, Doug Anderson Original message: Date: Thu, 10 Jan 2008 09:48:31 -0500 From: Sokol, Brian [EMAIL PROTECTED] Subject: How to Document Workflow? Are there any tools for documenting specific Remedy workflow? Brian Sokol Manager, Desktop Services Scholastic Inc. 557 Broadway NY, NY 10012 (212) 343-6494 http://www.Scholastic.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Remedy Performance Monitoring
SQL logs does not always tell you the truth. Instead the API logs are better, they can tell you how long an operation takes. RRRLogs is a very good tools for examine perfromance, and it do show you the API transaction time. (but also a lot of other nice stuff) Example: You create a record, the there is a lot of workflow trigger. Ie: notify a group of users. The SQL logs can show you that no SQL command takes longer than 0.010 seconds, but the API log shows that the create record took 5 seconds. And it spend much of the time creating records in AR System Email Messages form to notify all the users in the group. -- Jarl On Jan 10, 2008 6:43 PM, Kathy Morris [EMAIL PROTECTED] wrote: ** Hi, I was curious what other people are doing to measure performance. We are having some performance issues. I know we can run Remedy logging (SQL, etc.). Is there a tool that we can use to capture these performance issues. Also do most people use a separate Reporting Server to run reports? Start the year off right. Easy ways to stay in shape in the new year. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: How to Document Workflow?
When I try to install it I get an error that there is no 6.x Admin tool. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Easter, David Sent: Thursday, January 10, 2008 3:10 PM To: arslist@ARSLIST.ORG Subject: Re: How to Document Workflow? ** Incorrect. It will run. Please refer to the compatibility matrix. http://www.bmc.com/support/bmcremedycomp/AR_System_7_1_00_Compatibility_ Matrix_v1_0_2.pdf Thanks, -David J. Easter Sr. Product Manager, Service Management Business Unit 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. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sokol, Brian Sent: Thursday, January 10, 2008 11:21 AM To: arslist@ARSLIST.ORG Subject: Re: How to Document Workflow? David I am on ars 7.1 and have Developer Plus. My understanding is that it will not run against a 7.1 server? From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Easter, David Sent: Thursday, January 10, 2008 1:04 PM To: arslist@ARSLIST.ORG Subject: Re: How to Document Workflow? ** You may also wish to look at the Analyser product from Abydos. http://www.abydos-workflow.com/Products/AbydosAnalyser/tabid/59/Default. aspx In addition, there is the Remedy Developer Plus product from BMC. http://www.bmc.com/products/proddocview/0,2832,19052_0_43060253_107176,0 0.html -David J. Easter Sr. Product Manager, Service Management Business Unit 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. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sokol, Brian Sent: Thursday, January 10, 2008 6:49 AM To: arslist@ARSLIST.ORG Subject: How to Document Workflow? Are there any tools for documenting specific Remedy workflow? Brian Sokol Manager, Desktop Services Scholastic Inc. 557 Broadway NY, NY 10012 (212) 343-6494 http://www.Scholastic.com http://www.Scholastic.com __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Python and Web Services
On Jan 10, 2008 3:55 PM, Frank Caruso [EMAIL PROTECTED] wrote:
** Has anyone written any Python code to call a Remedy web service that they
would be willing to share?
The following code might be useful as a starting point (of course you
need to replace the XXX, YYY, ZZZ with the actual details of your
system and make other changes as needed), in this script the OpGetList
operation retrieves the details of a particular ticket (selected using
the Case_ID field).
Cheers,
Carlos
from SOAPpy import *
caseid=0001
username=XXX
password=XXX
namespace = urn:ZZZ
url = https://XXX/arsys/services/ARService?server=YYYwebService=ZZZ;
header =
headerType(data={AuthenticationInfo:{username:username,password:password}})
server = SOAPProxy(url,namespace)._hd(header)
for entry in server.OpGetList(Case_ID=caseid):
for k in entry._keys():
print k, : , entry.__getitem__( k )
print
Thank you
Frank
__Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
html___
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
PERFORM-ACTION-SAVE-ATTACHMENT
All, ARS 6.3 Patch 22 SQL Server 2000 I am trying save a file that is saved in an attachment field to the OS and am having an issue. I have attempted to run the following command in a Filter Set Fields: PROCESS$ PERFORM-ACTION-SAVE-ATTACHMENT 536870921 D:\temp\File1.txt 536870921 (This is an attachment field) (I am testing this in the User Tool which is on the same patch level as the server) The filter runs and does not error out and shows an exit code of Exit 0 in the Filter Log. I have tried taking the file name out and have tried to do the same thing using a Run Process without the $PROCESS$ and I still am not able to save the attachment to the OS. Has anyone had an issue with this? Maybe I am doing something wrong? Any help would be appreciated. Regards, Jackson _ Get the power of Windows + Web with the new Windows Live. http://www.windowslive.com?ocid=TXT_TAGHM_Wave2_powerofwindows_012008 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: PERFORM-ACTION-SAVE-ATTACHMENT
Jack, Is your goal to save the attachment on the server, or on the client machine? If running this from within a filter or escalation, the file would be stored in the specified path on the server. Leonard _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jack Samson Sent: Thursday, January 10, 2008 2:06 PM To: arslist@ARSLIST.ORG Subject: PERFORM-ACTION-SAVE-ATTACHMENT All, ARS 6.3 Patch 22 SQL Server 2000 I am trying save a file that is saved in an attachment field to the OS and am having an issue. I have attempted to run the following command in a Filter Set Fields: PROCESS$ PERFORM-ACTION-SAVE-ATTACHMENT 536870921 D:\temp\File1.txt 536870921 (This is an attachment field) (I am testing this in the User Tool which is on the same patch level as the server) The filter runs and does not error out and shows an exit code of Exit 0 in the Filter Log. I have tried taking the file name out and have tried to do the same thing using a Run Process without the $PROCESS$ and I still am not able to save the attachment to the OS. Has anyone had an issue with this? Maybe I am doing something wrong? Any help would be appreciated. Regards, Jackson _ Get the power of Windows + Web with the new Windows Live. Get it now! http://www.windowslive.com?ocid=TXT_TAGHM_Wave2_powerofwindows_012008 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Licensing Issues
Hi Michael, There used to be a page on the support web site where you could upload your 5.x license file and they would email you the upgraded license file. I should think that now you could delete all the data in your license file (after backing it up), then apply your new license keys. Julie Rockwood At 01:17 PM 1/10/2008, you wrote: ** Hey all, We're in the process of upgrading to 7.0 and implementing a server group and I'm running into a few problems with licensing. I've been on and off the phone with BMC licensing to no avail. We have two new servers that I was going to set up as a server group and a third server that we're using as the database. I grabbed a copy of the 5.1.2 database from our production server, installed 5.1.2 server on one of the new server group servers and did a restore. Got 5.1.2 up and running and then upgraded to a working version of 7.0 after some issues were resolved. Anyhow, long story short, both servers now have 7.0, the database has been upgraded, and they're both sharing it. I contacted support and was issued two new licenses, but when I try to apply them via the admin tool, I get an [ARERR 466] Invalid or pre 6.0 AR Server license file (In fact, I get the error when I select Add/Remove licenses from the admin tool). Support has been unable to assist up to this point, so I figured I'd try here and see if any of you had run into an issue like this before. Any ideas? Thanks much, Michael A. McManus, SSgt, USAF Remedy Developer HQ 754 ELSG/DOMH __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Get multiple windows returned at once with Application-Bus-Time2-Get-Next-Window??
Hi all, I'm trying to use this Business Time 2 command to get next available window from a recurring available segment defined in Business Time Segment. Application-Bus-Time2-Get-Next-Window This command works fine to return one available window... ...but when I try to get all the windows returned at once, by changing the 1 bit of the 4th parameter... ...as described in ARS 7.0 Config guide, page 402... ...I get nothing back. Anybody seen this? The syntax is below: Application-Bus-Time2-Get-Next-Window StartTimeRange EndTimeRange [Duration] [WindowFlag] [BusinessTimeSegmentName1 BusinessTimeSegmentName2 ] My command is: Application-Bus-Time2-Assoc-Get-Next-Window 1/10/2008 5/1/2008 7220 01 ID0014A51A4C9EomyGRw4FBxCAkmAA returns this value fine: 1199941200 Then I change the 4th parameter, 01, to 11, expecting semicolon separated values... Application-Bus-Time2-Assoc-Get-Next-Window 1/10/2008 5/1/2008 7220 11 ID0014A51A4C9EomyGRw4FBxCAkmAA Nothing comes back! The only way I have been able to get all windows returned at once as claimed is when the segment referred to in the last parameter is an unavailable recurring one. Never works with available recurring one. Ok, that was a mouthful, but that's the issue I have. I hate to have to loop around and issue this command each time to get all windows in the recurring range. It might take 10 times as long for the code to go thru. Why isn't it working as advertised? Any tips? Known bug? I'm using ARS 7.0.1. Wondering if 7.1 works any differently. Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
What class to use for Merge operation in JAVA API
Hi all, Does anyone have an idea on what is the class name for MERGE operation in JAVA 7.1 API. Thanks in Advance. Regards, Chintan. - Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
