Re: Importing an incident record with attachment in Remedy 6.3

2008-04-11 Thread Meenakshinathan
Did you try the import of .arx or any other format. When you take an export of data, all the attachments are stored in a separate folder. make sure your .arx file and the folder is in the same path. Now the import tool automatically maps the attachement field. We usually import like this.. Hope

Re: Importing an incident record with attachment in Remedy 6.3

2008-04-11 Thread Sanjana AGARWAL
Hi Meenakshi, Thanks I have already done this and this worked. Regards Sanjana -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Meenakshinathan Sent: Friday, April 11, 2008 1:03 PM To: arslist@ARSLIST.ORG Subject: Re:

Re: remove

2008-04-11 Thread Shellman, David
Gary, What are you removing? Dave - [EMAIL PROTECTED] (Wireless) - Original Message - From: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG To: arslist@ARSLIST.ORG arslist@ARSLIST.ORG Sent: Fri Apr 11 07:23:44 2008 Subject: remove Gary K.

remove

2008-04-11 Thread Conway, Gary
Gary K. Conway Manager of Technology Support Office of Library Technology, I.T. Grand Army Plaza Brooklyn, NY 11238 V: 718.230.2766F: 718.230.6770 [EMAIL PROTECTED] ___ UNSUBSCRIBE or access ARSlist

Re: Difference between NULL and

2008-04-11 Thread Grooms, Frederick W
Null is defined by the ISO SQL standard as different from both an empty string or the numerical value 0. Null indicates the absence of any value, the empty string and numerical zero both represent actual values. From: http://en.wikipedia.org/wiki/Null_(SQL) Fred

Re: Difference between NULL and

2008-04-11 Thread Ganga Prasad
Thanks Fred It should behave equally in the native application in Remedy and the external interface. As it can be seen before I start *My Approch* the system was behaving differently for the native and external application. Not able to get here ?? :( -- Thanks and Regards, Ganga Prasad

Re: Issues with building a view over a DB Link

2008-04-11 Thread Gary Dries
Patrick, I did what you suggested and I was am able to run any select statement from the link and get valid returns. But, when I try to create the View form in ARS I am getting the ORA-00904 Invalid Identifier on the key field. I have verified that the Key field on the SQL table is set up

Re: SQL view only showing recent records

2008-04-11 Thread Grooms, Frederick W
If I remember correctly your view joined a couple of tables. Are there corresponding rows in the joined (H and/or B) tables? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin Sent: Friday, April 11, 2008 11:16 AM

Re: Difference between NULL and

2008-04-11 Thread Joe D'Souza
Just as an FYI, If you use $NULL$ in REPLACE or functions like REPLACE to do something like REPLACE($field$, XYZ, $NULL$) it wont work. What works is REPLACE($field$, XYZ, ) Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf

Midtier special character error in form name using Apache/Tomcat/Mod_JK

2008-04-11 Thread Lin, Jason
Greeting, Hope someone on the list can offer some helps on our midtier problem. Problem: When using Mid-Tier with Apache/Tomcat, forms names that include unique characters (like a plus sign) generated errors: ARERR [303] Forms does not exist on the server. For example: +HPD:HelpDeskArchive

Re: SQL view only showing recent records

2008-04-11 Thread Brian Goralczyk
There is a way to check the database's definition for the view to make sure how the view was created. I am not positive of the syntax, but I am sure you can either google it or talk to you DBAs. If the view is not showing everything that is in the table then it has to be in the qualification of

Re: SQL view only showing recent records SOLVED sort of

2008-04-11 Thread Dwayne Martin
I think I tracked down the problem. I just don't know what to do about it. The sql log for creating the view says: CREATE VIEW LA_SI_Lab. . . AS SELECT T426.C1,C2. . . WHERE T426.C1 = B426.C1. B426 is the table defining the attachment pool, which we created fairly recently, probably November

Re: Midtier special character error in form name using Apache/Tomcat/Mod_JK

2008-04-11 Thread William Rentfrow
I encountered this problem with Websphere/IBM HTTP server. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Lin, Jason Sent: Friday, April 11, 2008 11:34 AM To: arslist@ARSLIST.ORG Subject: Midtier special character error in

Re: SQL view only showing recent records SOLVED sort of

2008-04-11 Thread Grooms, Frederick W
Run This Insert into B426 (C1) (Select C1 from T426 Where (Select C1 from B426 Where T426.C1 = B426.C1) Is NULL); Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin Sent: Friday, April 11, 2008 11:51

Re: SQL view only showing recent records SOLVED sort of

2008-04-11 Thread Grooms, Frederick W
Oh yes ... Commit afterwards ;) -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: Friday, April 11, 2008 11:59 AM To: arslist@ARSLIST.ORG Subject: Re: SQL view only showing recent records SOLVED sort

Re: SQL view only showing recent records SOLVED sort of

2008-04-11 Thread Brian Goralczyk
Actually, that is pretty easy to fix. Just create a row in the B table for each request id in the t table that isn't in the b table. Insert into b426 (c1) select c1 from t426 where c1 not in (select c1 from b426) I am not positive that will work off the top of my head, but it gives you the

Re: Midtier special character error in form name using Apache/Tomcat/Mod_JK

2008-04-11 Thread Grooms, Frederick W
Your error message is saying mod_jk doesn't understand the option. What version mod_jk do you have? The first line in the Apache error_log should tell you. My log shows: [notice] Apache/2.0.59 (Unix) mod_jk/1.2.21 configured -- resuming normal operations - - - - - - - - - From a

Re: SQL view only showing recent records SOLVED sort of

2008-04-11 Thread Mike Wallick
I ran into this a while back, and yes, inserting records into the corresponding B table will fix the problem. On 4/11/08, Brian Goralczyk [EMAIL PROTECTED] wrote: ** Actually, that is pretty easy to fix. Just create a row in the B table for each request id in the t table that isn't in the b

Re: Difference between NULL and

2008-04-11 Thread Mueller, Doug
Joe, When did you try this??? Why do I ask? Because this did indeed not work for a while -- releases after REPLACE was introduced through either 6.0 or 6.3 did not work with NULL as the target value, but releases 7.0 and later SHOULD work with NULL as the target value (and maybe 6.3 works I

Getting Attachment Size

2008-04-11 Thread Frank Caruso
Is there anyway to get the size of a file in an attachment field? I would like to check the size of the file to ensure that it will fit before the user clicks Save. Thank you ___ UNSUBSCRIBE or access ARSlist Archives at

Re: Difference between NULL and

2008-04-11 Thread Joe D'Souza
Doug, Version 7.1 unpatched.. I could have bet it used to work before too but I wasn't too sure and had no means to cross verify except maybe ask on here or call Remedy Support. I chose to do neither to save me some time, which is why I used instead of $NULL$.. So maybe its a bug in 7.1? I am

Re: Open Ticket from AL

2008-04-11 Thread Brian Goralczyk
You know, it is kinda hokey, but there is a way of doing that. Just delete your cache files when you close the form before you reopen it. I know your looking for a simple switch, or setting, but it does work. You can just create a batch to delete the files and run that. On Thu, Apr 10, 2008 at

OT: RFE - Procedure Change

2008-04-11 Thread T. Dee
Just an FYI. I opened an issue with Remedy and was told it was not a defect. I requested an RFE be opened. I was told that Remedy has changed their procedures / policies that if you want an RFE you must fill out the RFE Form. Thought you might be interested.

Re: OT: RFE - Procedure Change

2008-04-11 Thread Rick Cook
Yup - just did one yesterday. It only takes a few minutes. I'd rather do that than have it misunderstood by Engineering due to a communications issue between me and Support, and get it not implemented. If I fill out the form, I can only blame myself for not being clear enough on what I need vs.

Printing Incidents

2008-04-11 Thread strauss
As we get closer (we thought) to full implementation of ITSM 7.0.02/3.007 on ARS 7.1.00.002, we now have users testing the application and clicking on everything. We learned today that clicking the Print button on the bottom of an Incident form and Change Request not only does not print the ticket

Patch 006, CMDB, Custom Form, Permissions

2008-04-11 Thread Louis Cobuccio
Good Afternoon everyone, We've are a Windows shop, Server 2003, MS SQL 2005, AR applications v 7.0.01 Patch 006. I've got an issue regrading a custom form which isn't working correctly since we've patch our system. We use Asset Inventory and the CMDB. We I have users that were able write

Re: Printing Incidents

2008-04-11 Thread William Rentfrow
Do you have the ODBC uses underscores option set? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of strauss Sent: Friday, April 11, 2008 2:05 PM To: arslist@ARSLIST.ORG Subject: Printing Incidents As we get closer (we thought)

Re: Printing Incidents

2008-04-11 Thread strauss
Yes - it is also in all of the user preferences. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf

Re: Printing Incidents

2008-04-11 Thread William Rentfrow
I presume you are using the user tool from your previous comments. How was it installed? When it installs the AR ODBC connector is installed (as you well know). I've heard of flakiness before when people used SMS, etc, to install the user tool. This is rare but has happened. Have you tried

Re: Printing Incidents

2008-04-11 Thread strauss
I have tried this from about six different XP machines Including Parallels on Mac), two Vista machines, and patch 1 and 2 of the 7.1 user tool, against three 7.1 patch 1 or 2 servers with either patch 6 or 7 of the ITSM application. We just had a webex and they could not figure it out at support

Re: Patch 006, CMDB, Custom Form, Permissions

2008-04-11 Thread Rick Cook
What sort of patch are you talking about? OS, AR System, or Application? Which patch(es)? Rick On Fri, Apr 11, 2008 at 12:06 PM, Louis Cobuccio [EMAIL PROTECTED] wrote: Good Afternoon everyone, We've are a Windows shop, Server 2003, MS SQL 2005, AR applications v 7.0.01 Patch 006. I've

Re: Printing Incidents

2008-04-11 Thread Thad K Esser
We are on 6.3, so this may not apply, but we have a button that runs a report to print tickets as well. If the user specifies a preference server when logging in, they will get an error when they try to run this report. Its almost always a 1658 error though, not a time-out issue. If you

Re: Printing Incidents

2008-04-11 Thread Benedetto Cantatore
Ok I had a weird one like that myself and server was set to a specific TCP port. So in tools\options Advance tab in the Report section; I had to specifically reference the server and the TCP port. That fixed the problem I was having, perhaps that applies to you as well. Ben [EMAIL

Re: Printing Incidents

2008-04-11 Thread Lammey, Peter A.
I have experienced the same thing. Whenever the RPC errors started to occur when the user attempts to run a Crystal report (either from a Print Ticket or from the report console) it was always because they did not have the Report Server and TCP port set to the same server name and TCP port

Re: Patch 006, CMDB, Custom Form, Permissions

2008-04-11 Thread Louis Cobuccio
Sorry. We applied the 006 patch to AR System, ITSM, Approval, Mid-Tier, Email Engine, Flashboards, Migrator, AR User and AR Admin. Thanks, Lou From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook Sent: Friday, April 11, 2008 3:28 PM To:

Data dictionary? forms and field definitions, ITSM 7

2008-04-11 Thread Julie L Kanakanui JLKANAKA
Are there docs available that have ITSM 7 forms/fields definitions? Thanks, Julie [EMAIL PROTECTED] ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the

Re: Patch 006, CMDB, Custom Form, Permissions

2008-04-11 Thread Rick Cook
You mentioned that the perms on your form hadn't changed - how about that of the users accessing it? Remedy's patches sometimes do strange things. Rick On Fri, Apr 11, 2008 at 12:53 PM, Louis Cobuccio [EMAIL PROTECTED] wrote: ** Sorry. We applied the 006 patch to AR System, ITSM,

Re: Patch 006, CMDB, Custom Form, Permissions

2008-04-11 Thread Louis Cobuccio
Nope users prevs stayed the same too. Lou Sent from my Verizon Wireless Blackberry - Original Message - From: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG To: arslist@ARSLIST.ORG arslist@ARSLIST.ORG Sent: Fri Apr 11 15:58:56 2008 Subject: Re: Patch 006, CMDB, Custom

Re: Printing Incidents

2008-04-11 Thread strauss
Report server is set in User preferences for support staff to: itsm7.ars.unt.edu;22700;; (on pre-production - different server on development) The accounts which we use constantly across dev, pre-production, and even the failover server may have had those settings corrupted since we are

Re: Active Link and Modify All

2008-04-11 Thread Brian Goralczyk
Chris, Often times I run into this issue if I have the FQDN set for the server. It seems that for some reason the system uses short names only when your doing pushes. If I log out and log in with the short name only, then the problem goes away. You might want to give that a shot. As for

Active Link Run process

2008-04-11 Thread Steven Pataray
I'm having problems running an Active Link Run process with PERFORM-ACTION-ACTIVE-LINK 1 1002. This should press the Search button, but it doesn't do anything. From the logs it is firing on the field: ACTL Checking BOH:HPD-Admin.Menu.cmd.Search.CaseID.Execute (20) ACTL - Passed qualification

Re: Admin Tool Connection Problems - RESOLVED

2008-04-11 Thread Robert Halstead
I've seen it where an escalation that is taking a long time to run will hang the admin thread as well. You can reproduce this where you have a long running escalation and then try to update a filter or the same escalation with the admin tool. The arserverd process peeks at around 65% of the cpu

Re: Active Link Run process

2008-04-11 Thread Robert Halstead
Not sure why the button wouldn't trigger the search, but as a work around could you use a PERFORM-ACTION-ACTIVE-LINK 1024 as well? On Fri, Apr 11, 2008 at 2:42 PM, Steven Pataray [EMAIL PROTECTED] wrote: ** I'm having problems running an Active Link Run process with PERFORM-ACTION-ACTIVE-LINK

Re: Active Link Run process

2008-04-11 Thread Robert Halstead
or that would work as well =) On Fri, Apr 11, 2008 at 2:48 PM, Grooms, Frederick W [EMAIL PROTECTED] wrote: ** I think the docs state that the PERFORM_ACTION_ACTIVE_LINK Runprocess Actions do not actually do the Search or Save. They only cause the system to execute the code that is set to

Re: Active Link Run process - RESOLVED

2008-04-11 Thread Steven Pataray
Thanks guys, I tried both and the PERFORM-ACTION-APPLY was the only one that worked. Funny I didn't even see that Process command in the docs till you mentioned it. Thanks Steve On 4/11/08, Robert Halstead [EMAIL PROTECTED] wrote: ** or that would work as well =) On Fri, Apr 11, 2008 at

RES: arserverd 'hangs' (AR 7.0.1 patch 5 - Sol 10 - Ora 10g2)

2008-04-11 Thread Tadeu Augusto Dutra Pinto
Jorge... I think that 2,063,253 of records is really a lot of rows in the table AR System Email Messages... Recently, these week, we had problems with server crash ... and we've noticed that sql statements in this table were contributing for crash in our server ... and our AR System Email

Re: How can I have ARS Remedy 6.3 Demo?

2008-04-11 Thread John Sundberg
David, Just wondering -- can a partner (me) -- give the software to a known BMC customer? Or - do they have to get it from BMC? -John On Thu, Apr 10, 2008 at 11:46 AM, Easter, David [EMAIL PROTECTED] wrote: You can request a 6.3 trial license through the website. However, since 6.3 is

Re: arserverd 'hangs' (AR 7.0.1 patch 5 - Sol 10 - Ora 10g2)

2008-04-11 Thread Darrell Reading
We set up an escalation that deletes old tickets. We only keep 2 to 10 thousand records in there at any given time depending on how many transactions we have that day. I can't imagine having that many rows in that form. :S Darrell Reading Systems Engineer Phone 479.204.5739 [EMAIL

RES: arserverd 'hangs' (AR 7.0.1 patch 5 - Sol 10 - Ora 10g2)

2008-04-11 Thread Tadeu Augusto Dutra Pinto
That's it Darrel.. I forgot to say... After you truncate your table enable an escalation to delete records from this table ... one escalation that clear all records that are more than one week on databse, for example... Att, Tadeu Augusto Dutra Pinto

Admin Tool 7.1.0 p002 and Web Services - JRE error

2008-04-11 Thread David Sanders
Hi All Has anyone found the correct version of JRE to enable the Admin Tool v7.1.0 p002 to create filters to consume web services? Every JRE version I've tried is showing 'Failed to initialize JRE and internal java module (ARERR 7017)' as soon as you try to load the web service url.. With

Re: Data dictionary? forms and field definitions, ITSM 7

2008-04-11 Thread Davin Lindner-Green
Yes, BMC has one for download, although it is not an exhaustive description of every form and field, it is still important for understanding some of the conceptual data relationships. On the BMC support site, under Product Documentation, then for the BMC Remedy Service Desk 7.0.3 application,

Re: How can I have ARS Remedy 6.3 Demo?

2008-04-11 Thread Easter, David
All known BMC customers have access to the software via the Electronic Product Distribution site: https://webapps.bmc.com/epd/ That is the best way for any customer to obtain the software. Since all one needs to access the EPD is a valid support ID, it should be convenient for any known BMC