Re: ARS 7.x: No unique index on Group ID?

2008-01-10 Thread Misi Mladoniczky
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

Portuguese Localization for the Web

2008-01-10 Thread Kevin Shaffer
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

Re: Vertical nav bar HTML content 7 WUT on citix

2008-01-10 Thread whilec
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

ARERR [8939]

2008-01-10 Thread Ferreira, Frans F
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

Re: ARERR [8939]

2008-01-10 Thread Jiri Pospisil
++ 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

Delete Records of Alert Events

2008-01-10 Thread Tadeu Augusto Dutra Pinto
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

RES: Delete Records of Alert Events

2008-01-10 Thread Tadeu Augusto Dutra Pinto
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

Re: Delete Records of Alert Events

2008-01-10 Thread Heider, Stephen
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

Re: ARS 7.x: No unique index on Group ID?

2008-01-10 Thread Carey Matthew Black
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

RES: Delete Records of Alert Events

2008-01-10 Thread Tadeu Augusto Dutra Pinto
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

Re: Delete Records of Alert Events

2008-01-10 Thread Heider, Stephen
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

Python and Web Services

2008-01-10 Thread Frank Caruso
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

Remedy Administrator Mid Tier Forms

2008-01-10 Thread Rahul Takle
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

Re: Active Directory Users getting locked out

2008-01-10 Thread J.T. Shyman
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

Re: Active Directory Users getting locked out

2008-01-10 Thread Harry Pugh
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

Re: Active Directory Users getting locked out

2008-01-10 Thread Kaiser Norm E CIV USAF 96 CS/SCCE
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

How to Document Workflow?

2008-01-10 Thread Sokol, Brian
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

Re: Active Directory Users getting locked out

2008-01-10 Thread Harry Pugh
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

Re: Active Directory Users getting locked out

2008-01-10 Thread Kaiser Norm E CIV USAF 96 CS/SCCE
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

Re: Admin tool crashes when sync search database

2008-01-10 Thread Opela, Gary L Contr OC-ALC/ITMA
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

RES: Remedy Administrator Mid Tier Forms

2008-01-10 Thread Tadeu Augusto Dutra Pinto
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

Re: Remedy Administrator Mid Tier Forms

2008-01-10 Thread Russ Grant
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

Re: How to Document Workflow?

2008-01-10 Thread Rick Cook
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)

Re: NEED ADVICE - Setting up Remedy for incoming mail

2008-01-10 Thread tgaltamore
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

Re: Delete Records of Alert Events

2008-01-10 Thread Kendhammer, Mike
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

Re: How to Document Workflow?

2008-01-10 Thread LJ LongWing (Head)
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

Re: Remedy Administrator Mid Tier Forms

2008-01-10 Thread Pargeter, Christie
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

Re: How to Document Workflow?

2008-01-10 Thread Rick Cook
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

Incident: Total Time Spent Report

2008-01-10 Thread Ivan Runions
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

Re: Delete Records of Alert Events

2008-01-10 Thread Grooms, Frederick W
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

Re: How to Document Workflow?

2008-01-10 Thread Misi Mladoniczky
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:

Re: Remedy Administrator Mid Tier Forms

2008-01-10 Thread Carey Matthew Black
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

Re: Delete Records of Alert Events

2008-01-10 Thread Heider, Stephen
...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

Re: Delete Records of Alert Events

2008-01-10 Thread Robert Molenda
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

DSO connection errors

2008-01-10 Thread Zaheer Malik
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...

Re: How to Document Workflow?

2008-01-10 Thread Rick Cook
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

Re: How to Document Workflow?

2008-01-10 Thread Sokol, Brian
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

Re: DSO connection errors

2008-01-10 Thread Kaiser Norm E CIV USAF 96 CS/SCCE
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

CSV TO XLS via OLE

2008-01-10 Thread Mayfield, Andy L.
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

Re: CSV TO XLS via OLE

2008-01-10 Thread Heider, Stephen
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,

Remedy Performance Monitoring

2008-01-10 Thread Kathy Morris
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

Re: CSV TO XLS via OLE

2008-01-10 Thread Fariss, Ron
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

Re: How to Document Workflow?

2008-01-10 Thread Easter, David
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

Remedy Link for SQL Server (EIE) Function Syntax

2008-01-10 Thread [EMAIL PROTECTED]
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

Re: Remedy Link for SQL Server (EIE) Function Syntax

2008-01-10 Thread [EMAIL PROTECTED]
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

Activating an AR System to Vendor Data Exchange (EIE Again) via Workflow

2008-01-10 Thread [EMAIL PROTECTED]
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

Re: How to Document Workflow?

2008-01-10 Thread Sokol, Brian
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:

Re: Remedy Link for SQL Server (EIE) Function Syntax

2008-01-10 Thread Joe DeSouza
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

Re: Remedy Link for SQL Server (EIE) Function Syntax

2008-01-10 Thread Drew Shuller
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

Re: How to Document Workflow?

2008-01-10 Thread LJ LongWing (Head)
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

Re: How to Document Workflow?

2008-01-10 Thread Easter, David
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,

Licensing Issues

2008-01-10 Thread McManus Michael A SSgt HQ 754 ELSG/DOMH
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

Bar Code font on Crystal Reports on Mid-Tier

2008-01-10 Thread Dwayne Martin
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

Re: DSO connection errors

2008-01-10 Thread Hall Chad - chahal
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

Re: Remedy Performance Monitoring

2008-01-10 Thread john rosquist
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.

Re: Remedy Link for SQL Server (EIE) Function Syntax

2008-01-10 Thread Mike Wallick
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

Re: How to Document Workflow?

2008-01-10 Thread Anderson, Douglas W.
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

Re: Remedy Performance Monitoring

2008-01-10 Thread Jarl Grøneng
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

Re: How to Document Workflow?

2008-01-10 Thread Sokol, Brian
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

Re: Python and Web Services

2008-01-10 Thread Carlos Ungil
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

PERFORM-ACTION-SAVE-ATTACHMENT

2008-01-10 Thread Jack Samson
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

Re: PERFORM-ACTION-SAVE-ATTACHMENT

2008-01-10 Thread Leonard Neely - FOJ
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

Re: Licensing Issues

2008-01-10 Thread Julie Rockwood
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.

Get multiple windows returned at once with Application-Bus-Time2-Get-Next-Window??

2008-01-10 Thread Rabi Tripathi
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

What class to use for Merge operation in JAVA API

2008-01-10 Thread Chintan Shah
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.