Re: ARERR 9387

2009-03-17 Thread Kelly Heikkila

ErrorMessages71.pdf:
9387
Error Request timeout. Please try opening the report again.
A request to open a Crystal report through the web timed out.

-Kelly

Kelly Heikkila
:coderow
ke...@coderow.com
www.coderow.com

On Mar 17, 2009, at 2:12 PM, William Rentfrow wrote:


**
Anyone know what this error is?  I can't find it on BMC's website or  
in the documentation anywhere.  I receive this when running larger  
reports over the web via BOXI/AR Web Report Viewer.


Also - and you know who you are - the person with the phone # in  
their signature that ends in 9387 - you make it VERY hard to search  
for things :)


William Rentfrow
Principal Consultant, StrataCom Inc.
wrentf...@stratacominc.com
Corporate Website, www.stratacominc.com
715-410-8156 C

__Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are  
html___









___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are


Re: ARERR 9387

2009-03-17 Thread Kelly Heikkila
I've seen similar problems when a report is running against a large  
dataset and has subreports on the details (meaning the subreport runs  
once/more for each record found).  So, if you had a report that ran  
against 10,000 rows, you'd have at least 10,001 queries.


-Kelly

On Mar 17, 2009, at 2:15 PM, William Rentfrow wrote:


**
Let me try that again - the error actually means the Crystal report  
request has timed out - but there's no indication WHY it timed out.


The actual BMC docs say This error occurs when a request is sent to  
open a Crystal report through the web has timed out.


I already knew that...

William Rentfrow
Principal Consultant, StrataCom Inc.
wrentf...@stratacominc.com
Corporate Website, www.stratacominc.com
715-410-8156 C


From: William Rentfrow
Sent: Tuesday, March 17, 2009 2:13 PM
To: arslist@ARSLIST.ORG
Subject: ARERR 9387

Anyone know what this error is?  I can't find it on BMC's website or  
in the documentation anywhere.  I receive this when running larger  
reports over the web via BOXI/AR Web Report Viewer.


Also - and you know who you are - the person with the phone # in  
their signature that ends in 9387 - you make it VERY hard to search  
for things :)


William Rentfrow
Principal Consultant, StrataCom Inc.
wrentf...@stratacominc.com
Corporate Website, www.stratacominc.com
715-410-8156 C

__Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are  
html___








___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are


DVF Applications

2009-03-10 Thread Kelly Heikkila
I was curious whether anyone has written their own custom applications/ 
widgets using Data Visualization Fields?  I've never written a DVF  
app, but they seem like a good solution to include enhanced  
functionality without the pain other types of customizations can  
cause, namely upgrades.  You obviously need to have a Java/Web  
skillset, but there are a lot of people out there who do.  However, I  
don't hear many people talking about DVF, beyond what is included in  
the OOB apps.


I know a while back, the DVF Framework (code to make it easier to  
write DVF apps that interact with forms, integrate security, etc),  
that BMC distributed had some restrictive licensing language.  On the  
arswiki, there is some discussion of these licensing issues, but  
nothing current.   Is this part of the reason?


-Kelly

Kelly Heikkila
:coderow
ke...@coderow.com
www.coderow.com






___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are


Re: Implementing data driven notifications

2009-02-27 Thread Kelly Heikkila
We did something similar to this for the Kinetic Request and Kinetic  
Survey applications when I was at Kinetic Data.  It lets any  
authorized user via a Remedy User interface create message templates  
on their own.   The emails were typically to fill out a survey or  
respond to a service request.  Templates are just Remedy records  
stored in a Kinetic Message Template form.  The message template  
authors put field placeholders in the email text via some drop downs  
based on the form they chose.  We had options such as Plain Text vs.  
HTML, subject lines, reply-to, special link creation and other  
features, as well.


These templates then get triggered via rules-based events. When the  
email is to go out, a filter pushes the record ID, and template ID and  
some other info to a Kinetic Message form.  Some pretty complicated  
string substitution/SQL goes through and puts the field values from  
the specified record into the email.  It works really well and is  
quite powerful.  It then uses the Email Engine for the actual message  
delivery.


Although I'm no longer at Kinetic, I'm still a big fan of their  
products:  You could probably pick up a copy of Kinetic Survey and use  
just the email templating for less than it would cost you to build  
just this piece!


-Kelly

Kelly Heikkila
:coderow
ke...@coderow.com
www.coderow.com

On Feb 27, 2009, at 12:05 PM, patchsk wrote:


Hi Shyam,
Yes, I am thinking of  more towards multidimensional matrix. And
possibly independent of any particualr app, like a separate module.
So user can specify the form,  filtering condition could be any
combination of fields and values...to get notified, more data driven.
Will contact you once we start implementation, right now I am just
gathering some ideas.
Thanks

On Feb 26, 10:51 pm, Shyam Attavar atta...@sbcglobal.net wrote:

Vamsi,

One of the developers I worked with had built something similar on  
AR System
5.1.2 many years ago. It was a subscription mechanism where users  
could
subscribe to the tickets based on certain categorization values. I  
had to
maintaining the code for a little bit, but don't recall much of how  
it was
built. I'll describe what I do remember and if you have further  
questions,

email me offline and we can take this further.
The whole mechanism was built as data driven architecture.

There was a subscription dialog which users would launch and  
subscribe to
get notified on based on the various categorization available in  
the system.
The records for each user would be stored in a back-end form. When  
the
subscription was saved a record was added to another back-end form,  
where
the list of users that need to be notified for a given set of  
categorization
and for a specific status value (ex: New, WIP, Resolved). When a  
record was
either created or went to one of the states, the list of users  
would get
notified. So, this design took into account the a categorization  
and status

value combination (which makes a two way matrix for building the
notification list). The notifications were only for one form, so  
this is not
exactly what you are asking for, but we could extend the design  
further to
allow for notifications from multiple forms. The one caveat that I  
would

watch for is one would have to create a multi-dimensional matrix, so
generating the list of users to be notified would be more complex.

I know my description is a bit sketchy, but I hope this helps you  
move in

the right direction with your design.

Cheers,
--
Shyam



- Original Message -
From: SriVamsi Patchipulusu vamsi...@gmail.com

Newsgroups: gmane.comp.crm.arsystem.general
To: arsl...@arslist.org
Sent: Thursday, February 26, 2009 9:40 AM
Subject: Implementing data driven notifications


All,
I know the following is not something that can't be done.
Just would like to know what are some of the best practices people  
are

using
for notifications
in custom built applications ( not ITSM)  with little to none  
admin code

changes for future maintainance.


Currently we have several Notify filters spread across several  
forms in

our
custom built apps,
Some are having hard coded groups,user names and some are data  
driven to

that particular form/app.
We would like to streamline this and make it generic as much as  
possible

with mostly data driven.



Anyone implemented notifications that covers  all the apps?
Something  like triggering notifications from external form (not  
part of

apps) as a blackbox with
 Subject , To , body , subscribing/removing users or groups are data
driven.
End users can create new notifications them self, with their own
To,Subject,
Body  without remedy code changes.



Thanks,
Vamsi


___ 
 

UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are-  
Hide quoted text -


- Show quoted text

Re: Long shot, but I'll ask anyway

2009-02-06 Thread Kelly Heikkila
You could  write some javascript that fires on load to create an  
IFRAME on the fly pointing to the sub-form.  As it's in the same  
session, it shouldn't ask for re-authentication.


-Kelly

Kelly Heikkila
:coderow
ke...@coderow.com
www.coderow.com

On Feb 6, 2009, at 12:40 PM, Mark Lev wrote:

It would be sweet if there was a way to pull up a remedy form in the  
data visualization control.


I'll keep looking, if anyone else has ideas or knowledge, it would  
be greatly appreciated.


ARS 7.1
ITSM 7.0.3
Windows
MS SQL

All patched to latest and greatest.

Thanks,
Mark



From: Action Request System discussion list(ARSList) on behalf of  
Carey Matthew Black

Sent: Fri 2/6/2009 1:31 PM
To: arslist@ARSLIST.ORG
Subject: Re: Long shot, but I'll ask anyway



Mark,

What ARS version?

I think this can be done in ARS v7.1 or higher with a Data
Visualization. I have not done it, but it seems like it should be
possible.

--
Carey Matthew Black
BMC Remedy AR System Skilled Professional (BRSP)
ARS = Action Request System(Remedy)

Love, then teach
Solution = People + Process + Tools
Fast, Accurate, Cheap Pick two.



On Fri, Feb 6, 2009 at 11:38 AM, Mark Lev mark@rightstarsystems.com 
 wrote:
This is likely something that cannot be done, but what the heck,  
can't hurt to ask.


Anyone know how to embed a form within a form in the client without  
use of web?  Perhaps some API or control or other mechanism exists  
to do this.


An alternative is if someone can show me how to securely pass  
authentication from client to a web view so use doesn't have to  
reauthenticate, that may work.  Again, not sure if this can be  
done...  I need to pass parameters also, but that should not be as  
big an obstacle.


Thanks,
Mark


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are



___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are



___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are








___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are


Re: Hiding the Authentication Field on Mid Tier 7.1

2009-01-30 Thread Kelly Heikkila

Hi Brian-
I don't have the 7.1 login JSP in front of me, but do make sure you  
are commenting out the entire HTML table row (tr to /tr tags)  
versus just the table cells (td tags).  Otherwise you will have  
malformed HTML that could cause problems with some scripts, such as  
setting focus.


-Kelly

Kelly Heikkila
:coderow
612-216-0028
ke...@coderow.com
www.coderow.com

On Jan 30, 2009, at 12:51 PM, Sokol, Brian wrote:


**
I need to hide the Authentication field for our Mid Tier 7.1 server.  
I commented out the following section in the login.jsp file:


label for=auth-id 
%=MessageTranslation.getLocalizedText(locale,Authentication)%/ 
label

/td
 
tdinput type=text NAME=%=Params.AUTHENTICATION_STRING%  
id=auth-id maxlength=%=Params.AUTHENTICATION_STRING_LENGTH%  
class=loginfield size=30


/td

This seems to work with one minor problem. When I comment out this  
section and the Mid Tier login screen loads, my cursor is no longer  
focused on the User name field. So no a user will have to click in  
the field before typing. Anyone have a fix for this?


Brian Sokol
Manager, Desktop Services
Scholastic Inc.
557 Broadway
NY, NY 10012
(212) 343-6494
http://www.Scholastic.com

__Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are  
html___









___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are


Re: Hiding the Authentication Field on Mid Tier 7.1

2009-01-30 Thread Kelly Heikkila

Brian-
It looks like you'll also need to comment out two lines of JavaScript  
that works against that field.  Christopher also has this commented  
out on his form.


Search for these two lines:
//this.document.loginForm.auth.value=;

//this.document.loginForm.auth.onkeypress = doSubmit;

The two slashes are how JavaScript code is commented.   Yours won't  
have them.


Kelly

On Jan 30, 2009, at 1:42 PM, strauss wrote:


**
You must have a problem with the way login.jsp includes the  
login_common.jsp file, anyway – the code for placing the cursor is  
in login_common.jsp:


function setInitialFocus() {
// set focus to user input field
document.loginForm.username.focus();
document.loginForm.username.select();
}

Christopher Strauss, Ph.D.
Call Tracking Administration Manager
University of North Texas Computing  IT Center
http://itsm.unt.edu/
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG 
] On Behalf Of Sokol, Brian

Sent: Friday, January 30, 2009 1:28 PM
To: arslist@ARSLIST.ORG
Subject: Re: Hiding the Authentication Field on Mid Tier 7.1

**
Hi Kelly,

I tried both td and tr and the results are the same. I also noticed  
a warning icon on the bottom of the browser now. If I open the  
warning it states:

'this.document.loginForm.auth' is null or not an object

Any ideas?

From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG 
] On Behalf Of Kelly Heikkila

Sent: Friday, January 30, 2009 2:07 PM
To: arslist@ARSLIST.ORG
Subject: Re: Hiding the Authentication Field on Mid Tier 7.1
** Hi Brian-
I don't have the 7.1 login JSP in front of me, but do make sure you  
are commenting out the entire HTML table row (tr to /tr tags)  
versus just the table cells (td tags).  Otherwise you will have  
malformed HTML that could cause problems with some scripts, such as  
setting focus.


-Kelly

Kelly Heikkila
:coderow
612-216-0028
ke...@coderow.com
www.coderow.com

On Jan 30, 2009, at 12:51 PM, Sokol, Brian wrote:


**
I need to hide the Authentication field for our Mid Tier 7.1 server.  
I commented out the following section in the login.jsp file:


label for=auth-id 
%=MessageTranslation.getLocalizedText(locale,Authentication)%/ 
label

/td
 
tdinput type=text NAME=%=Params.AUTHENTICATION_STRING%  
id=auth-id maxlength=%=Params.AUTHENTICATION_STRING_LENGTH%  
class=loginfield size=30


/td

This seems to work with one minor problem. When I comment out this  
section and the Mid Tier login screen loads, my cursor is no longer  
focused on the User name field. So no a user will have to click in  
the field before typing. Anyone have a fix for this?


Brian Sokol
Manager, Desktop Services
Scholastic Inc.
557 Broadway
NY, NY 10012
(212) 343-6494
http://www.Scholastic.com

__Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are  
html___








__Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are  
html___
__Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are  
html___
__Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are  
html___


Kelly Heikkila
:coderow
612-216-0028
ke...@coderow.com
www.coderow.com






___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are


OT: Contractor Available

2008-12-22 Thread Kelly Heikkila

Hello Listers-

I'm wanted to let everyone know I'm available for contract work in the  
coming year.  For those of you who haven't met me, I was with Kinetic  
Data for 8 years and was the architect and lead developer for  
Kinetic's outstanding suite of apps including Kinetic Request, Kinetic  
Survey, and Kinetic Calendar (get in contact with John Sundberg at  
Kinetic if you'd like a reference).  I left Kinetic in November to  
form my own company called :coderow, doing consulting and building  
custom browser-based business applications.


I have been doing Remedy for 8 years, Java for 5, Ruby/Rails for 2,  
and HTML/JavaScript/CSS for over 10 years.


I am most  interested in Remedy or Remedy-related projects including:
-Customizations
-Integrations
-Application Architecture/Design  Reviews
-Team Lead for a specific project/duration
-Kinetic app implementations/consulting

However, I'm avoiding ITSM 7 implementations or long-term engagements.

I am available for travel for an interesting project.  Send me an  
email directly or give me a call if you'd like to discuss a project.


Kelly Heikkila
:coderow
612-216-0028
ke...@coderow.com
www.coderow.com






___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


Re: Need a v 6.0 DLL file...

2008-07-22 Thread Kelly Heikkila
If this DLL is for use with the API, I'd get all the DLLs and Jars  
together (from Axton's site) versus just getting the one you're  
looking for. We've run into some interesting to track down issues,  
when the dll/jar patches don't match up together.


Kelly Heikkila
Kinetic Data


On Jul 22, 2008, at 1:14 PM, Axton wrote:


The 6.0.1 windows api includes this file.

http://arswiki.org/wiki/Remedy_API_Downloads

Axton Grams

On Tue, Jul 22, 2008 at 12:52 PM, William Rentfrow
[EMAIL PROTECTED] wrote:

**
I need the 6.0 version of this file:

arjni60.dll

If anyone has it and can zip it/email it to me I'd appreciate it.

William Rentfrow, Principal Consultant
[EMAIL PROTECTED]
C 701-306-6157
O 952-432-0227

__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: Archiving Stopped?

2008-06-23 Thread Kelly Heikkila
Have you added any real data fields to your form recently?  We have  
found that when the base form and the archiving form are not in sync,  
archiving stops without any errors/warnings.  We are now adding Help  
fields to some of our admin/config areas in our products to show when  
the last archiving took place and how many records have been archived  
to help spot these problems easier.


Kelly Heikkila
Kinetic Data, Inc.

On Jun 23, 2008, at 9:19 AM, Reiser, John J wrote:


**
Mark,

Have you recently added an escalation that may be updating the  
tickets? Even Closed ones?
That would prevent the Modified Date from ever getting close to your  
qualification.
Maybe you could change it to Status-History.Closed-Cancelled.TIME in  
place of the Modified Date.

Just a thought.
John J. Reiser
Software Development Analyst
Remedy Administrator/Developer
Lockheed Martin - MS2
The star that burns twice as bright burns half as long.
Pay close attention and be illuminated by its brilliance. -  
paraphrased by me





From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG 
] On Behalf Of Brittain, Mark

Sent: Monday, June 23, 2008 9:35 AM
To: arslist@ARSLIST.ORG
Subject: Re: Archiving Stopped?

**
HI Chintan,

Here is the qualification. I will look at the filter logs as you  
have suggested.


( 'Status' = Closed-Cancelled) AND ( 'Modified-date' = ($DATE$ -  
(((60 * 60) * 24) * 325)))


Thanks
Mark

From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG 
] On Behalf Of Chintan Shah

Sent: Friday, June 20, 2008 5:06 PM
To: arslist@ARSLIST.ORG
Subject: Re: Archiving Stopped?

** If you have enabled filter logging, you can see AR_ARCHIVOR entry  
in the filter logs when archiving starts. So, filter logs might  
help. What is qualification criteria for the archiving?


Thanks
Chintan.

Brittain, Mark [EMAIL PROTECTED] wrote:
Hi All  TGIF,

I noticed the other day that archiving has stopped on one of my forms.
The archiving (copy  delete from source)had been performing well
months. The archiving runs at 11:00PM.

I turned on threads logging and have not found anything there. I had
hoped to get something from the arerror.log but there has not been an
update since April 15th.

Anybody have any ideas or suggestions?

ARS 6.3 patch 20
SunOS 5.9
Oracle 9.2

Thanks
Mark

Mark Brittain
Remedy Developer
NaviSite ESM Operations
315-453-2912 x5418 (Office)
315-317-2897 (Cell)


This e-mail is the property of NaviSite, Inc. It is intended only
for the person or entity to which it is addressed and may contain
information that is privileged, confidential, or otherwise protected
from disclosure. Distribution or copying of this e-mail, or the
information contained herein, to anyone other than the intended
recipient is prohibited.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are

  __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers  
Are html___



This e-mail is the property of NaviSite, Inc. It is intended only  
for the person or entity to which it is addressed and may contain  
information that is privileged, confidential, or otherwise protected  
from disclosure. Distribution or copying of this e-mail, or the  
information contained herein, to anyone other than the intended  
recipient is prohibited.
__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


JOB: Remedy Developer at Kinetic Data

2007-11-09 Thread Kelly Heikkila
Kinetic Data is hiring for a Remedy Developer/Implementer for our own
product implementations and product development efforts...

What:  Build interesting products and help excited customers implement them
Who:  A great Remedy developer who has the knowledge and self confidence to
build on Remedy with their eyes closed, offer new ideas, and manage their
own projects.  JavaScript/CSS/HTML or Java experience a big plus
Where:  Need to be based in the Twin Cities-MN
Travel: Roughly 25%
Salary/Benefits:  Like everything-dependent on experience
About Us:  Kinetic Data is a developer-centric company building great
products on the Remedy platform (Kinetic Survey, Request, Calendar and
others).  We thrive on pushing the envelope on what can be done in/outside
Remedy for the benefit of our customers and our developers.  Kinetic
Data--where Remedy development is fun again.

Please send me an email directly if you have any questions or are interested
in the position.

Thanks!

-Kelly
-- 
Kelly Heikkila
Kinetic Data, Inc.
651-556-0932
[EMAIL PROTECTED]

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


ITSM 7 in submitter mode changeable?

2007-06-20 Thread Kelly Heikkila

We have always, in general, suggested clients use Submitter Mode Locked for
the flexibility it brings.  However, I've heard anecdotes that parts of ITSM
7 required submitter mode changeable.  However, I can't see anything in the
guides to confirm  or deny this.  The only item I see is in the Config Guide
discussing guest users for the Requester Console, which states that
submitter mode locked should be used if submitters need to cancel
requests.

Is anyone running ITSM 7 in submitter mode changeable?  Is there a specific
reason you are?

Thanks for the help-

Kelly Heikkila
Kinetic Data, Inc.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers 
Are


Java API - ARServerUser method

2007-04-17 Thread Kelly Heikkila

ARServerUser.setOverridePrevIP(int)

Anyone know what this method does/what is the previous IP flag?  The Java
API docs only say:

Set the override previous IP flag (Helpful)

Using ARS 6.3

Thanks-

Kelly Heikkila
Kinetic Data

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers 
Are


Re: ARS Report Creator's time problem on queries

2007-04-03 Thread Kelly Heikkila
We have the same issue when running reports.  This started happening at a 
client site after the time zone patch was installed (we believe--or agents were 
paying more attention, as you mentioned).  This has not yet been resolved that 
I am aware of.

ARS 6.3
Oracle

Kelly Heikkila
Kinetic Data

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 03, 2007 10:42 AM
To: arslist@ARSLIST.ORG
Cc: Whilden, Mark D.
Subject: ARS Report Creator's time problem on queries


Listers,
After we applied the Daylight Saving time patches, we started to pay
more attention to time zone issues.  Note, I don't think the DST patch
caused this, but caused us to look into time fields more closely.  We
found that for report run from Report Creator form, any queries against
date fields weren't adjusted for difference between our zone (EST) and
GMT.  The Report Creator form is used for running Crystal Reports
within ARS, or running ARS reports and Crystal Reports thru the
MidTier.  Whither we ran Crystal Reports or ARS reports from the web,
or Crystal Reports from the client; we got the same results.  If I ran
the same query in User tool the query ran correctly.  All the tools
display the dates correctly in the reports or on the forms.

To investigate this, I turned on SQL logging and repeated the same
queries from the Report Creator and from User search.  The Select
statements vary within the where clause in the constant used against
the date column.  The difference is 14400 seconds or 4 hours.  That is
the difference between us and GMT.

Our systems people are looking into time zone on the server, but I am
doubtful this is the problem.  However, I don't have a good culprit to
pursue.  Anyone seen this before or have a clue as to where to look to
resolve this.

Mark Whilden
MITRE Corp
[EMAIL PROTECTED]
(571)252-4023

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the 
Answers Are

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the 
Answers Are


Re: Approval Server issues

2007-03-23 Thread Kelly Heikkila
Not sure if this is related, but might help...

In some situations the AR System tries to find special forms using a field ID 
(versus the name of the form) which is believed to be only found on a single 
form.  I believe this was because some people were renaming forms like Group, 
User, and Report.  However, when you create a join against one of these forms 
(we created a join against Report), all of a sudden things stop working.  The 
reporting process found two forms (our join and Report) and because our was 
first alphabetically, no reports worked.   

I'm not sure if the Approval engine does something simiilar (it was a core API 
method that had this functionality in it). 

Kelly Heikkila

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED]
Sent: Friday, March 23, 2007 9:39 AM
To: arslist@ARSLIST.ORG
Cc: Jim Thwaite
Subject: Approval Server issues


We're at the end of our ropes here, hopefully someone can help.
Environment, Remedy 6.3 (just upgraded for DST remediation)
HP Unix
5.0 Apps

We have 4 server environtments
Development
Function Test
Unit Test
Production

After the recent upgrade to 6.3 the Approval engine ceased to function on
our production, Unit Test and development environments, but worked fine on
our functional test environment.

We found that the Approval server in the other environments was suddenly
referencing a joing which was similar to the AP Detail Signature join but
had been created for reporting.

In development we removed these joins and ran arjoinfix.  This fixed the
issue in dev.  We did the same in function test (although there was no
problem, just for consistency) and it was fine.  Now we have done it in Unit
test and it still does not work.  Specifically the approval server logs are
showing an error stating * No Entry-Detail-Signature join form to send
notifications to

We're open to all suggestions and ideas at this point.
Remedy has of course suggested upgrading the approval server to 6.3 but
noone thus far has been able to confirm this wont cause issues with the 5.0
apps.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the 
Answers Are

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the 
Answers Are


Re: how should look like the XML file to import data in Remedy

2007-01-16 Thread Kelly Heikkila
The xml format needed for the import tool can be difficult to create,
particularly if you are taking an existing XML document and transforming
it via a stylesheet.  The import tool relies on the ordering of field
values tied to the metadata about the form in the instance node.
Certainly not impossible, but can be difficult.  Not sure your exact
specifics, but if your source application creates XML it may have a web
service capability, which you could publish from your ARServer.  Another
option would be to use a different tool (besides the import tool) to
create your records.  There is an open source/free tool from Kinetic
Data (where I work) called KLINK which takes a formatted XML document
and creates Remedy records (among other things).  You can find info
here:  http://www.kineticdata.com/link.html.  There are also a bunch of
other XML tools with tons of postings on the list if you search around.
 
Kelly Heikkila
Kinetic Data
 

   -Original Message-
   From: Action Request System discussion list(ARSList)
   [mailto:[EMAIL PROTECTED]
   Sent: Tuesday, January 16, 2007 8:39 AM
   To: arslist@ARSLIST.ORG
   Cc: Michael Worts
   Subject: Re: how should look like the XML file to import data in
   Remedy
   
   

   ** 
   Best thing to do would be to export a data file from the Remedy User
   tool into an XML format (as opposed to ARX). If you export data from
   the form that you are trying to import into, you should get the exact
   format you need. 
   
   Mike. 
   
   Michael Worts
   Remedy Specialist
   IGS, Business Consulting Services
   ITIL Service Manager Certified
   Tel: +44 (0)1962 822273   Mob: +44 (0)7801 755346   Internet:
   [EMAIL PROTECTED] 
   
   
   
Serouche Rahimpour [EMAIL PROTECTED] 
Sent by: Action Request System discussion list(ARSList)
arslist@ARSLIST.ORG 

16/01/2007 14:36 
   Please respond to
  arslist@ARSLIST.ORG


  To
arslist@ARSLIST.ORG 
  cc
 Subject
how should look like the XML file to import data in Remedy

   




   dear listers,
   
   we have an application which produced an XML file.
   We'd like to import the data contained in that file into Remedy.
   I tried with the Import tool. It doesn't even read the file.
   So I am wondering whether somebody could specify here how the XML
   file 
   should look like.
   Thank you.
   Serouche
   
   ARS server 6.00.01
   
   _
   __
   UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
   ARSlist:Where the Answers Are
   
   __20060125___This posting was submitted with HTML
   in it___



___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the 
Answers Are


Re: Does anyone know the compression format for file attachments

2006-08-21 Thread Kelly Heikkila
Our open source project, Kinetic Link (Klink), can handle this request from 
almost any language..  Klink is a web-based framework for interacting with your 
Remedy data/metadata via HTTP Requests.

The request would look something like this:
http://myKlinkWebServer/klink/attachment/MyArServer/KS_ACC_Attachment/001/70001

The last two parameters on the URL are the request ID and the Field ID.  You 
wouldthen get an XML doc back with the attachment base64 encoded, which should 
be fairly easy to decode in most languages.

If you don't have the request ID, you can do a Klink call to get records that 
match a qualification and then iterate through using the above URL.

Authentication can also be passed in via the URL.

To find out more about Klink (currently in beta):

http://www.kineticdata.com/products/klink/

Kelly Heikkila
Kinetic Data

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED]
Sent: Monday, August 21, 2006 4:18 PM
To: arslist@ARSLIST.ORG
Cc: arslist
Subject: Re: Does anyone know the compression format for file
attachments


I believe that it's a gzip variant... I don't know what the settings are
in terms of a compression dictionary or block size, so your going to need
to tweak those... If you're on Windows, check the installation directory.
I believe that there is a DLL in there that has zip or gzip in the title.
It's been quite a while since I have worked on Windows with this, so your
milage might vary from the posted norms.

Probably the best advice that I could give on it would be to use the API.
It's not that bad, and would simplify the development. There are also
things that you can do to speed up queries, etc. For example, specifying
the entry id, rather than querying for it.



On Mon, August 21, 2006 15:57, Doug Wood wrote:
 Hey guys,
 I was wondering if there was anyway to get file attachments from Remedy
 without using the API, but using C# or Perl. I know that the Remedy API
 compresses files before they are saved. Is it absolutely necessary to use
 their API to view these files ? Or does anyone know which compression
 format they use to save these files? Thanks!


 _
 __
 UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org


Re: ? New Hires/Terminations/Moves solution

2006-08-17 Thread Kelly Heikkila
Carol-
We've had a number of companies use our product, Kinetic Survey 
(http://www.kineticdata.com/products/survey/index.htm) for managing the front 
end of this process, namely publishing your forms out to your customers in a 
very easy to use, customer-friendly way.  Kinetic Survey then captures the form 
data and can then direct other forms to an approver if needed.  From there, our 
application can then create a Help Desk, Change Mgmt or any other ticket for 
the actual fulfillment process.  Kinetic Survey is built on Remedy (BMC Remedy 
Action Request System, for any BMC'ers listening), so integrating the 
application with any OOB or Homegrown app is easy. 

Having our data in Remedy can also cut down on those customizations:  You can 
ask all the questions you want (without adding new fields to your form), and 
then reference the collected data from your Help Desk or other app through 
table fields, reports or related items.
 
In addition, you get a great app ideal for those other tasks you'd someday like 
to get to but never can (like that Customer Satisfaction Survey or Office Party 
Registration System).  
 
So, you say, what do surveys have to do with forms management?  Kinetic Survey 
is what we like to call an Enteprise Feedback Management (EFM) app.  Besides a 
nice acronym, this means that we can handle all types of feedback, whether 
surveys, forms, call scripting, data validation and many other situations.
 
Please let me know if you'd like more info-
 
Kelly Heikkila
[EMAIL PROTECTED]
Kinetic Data

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED]
Sent: Thursday, August 17, 2006 2:04 PM
To: arslist@ARSLIST.ORG
Cc: Carol Carnevali
Subject: ? New Hires/Terminations/Moves solution


We want to begin using Remedy to track the process of 
hiring/terminating/moving employees and consultants and I was wondering 
what other companies are using to do this.  Is there an off-the-shelf 
Remedy application that handles this well or is it better to custom-build 
something? Basically, the process goes something like this:

HR initiates the request and creates an Employee record
Hiring manager needs to fill in the requirements
Facilities needs to provide a workspace
Voice Comm needs to set up a phone
PC Help Desk needs to provide a PC or Laptop, cabling, and needs to know 
what software is required.
Security needs to provide access to the building
Data Security needs to provide access to the network, etc.
User setup on various software (such as Remedy) needs to take place

- For terminations, the reverse needs to take place.
- For consultants, the process may be slightly different and there needs 
to be a termination date.
- For associates who move, another process needs to take place.

And the $99,000 question is:  What is the best name to call this process?  
There must be an industry name for it, right?

Thanks for your replies.

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org


Re: OT: Entity Relationship

2006-07-19 Thread Kelly Heikkila
DBDesigner4 from FabForce (open source) is great if you want to create a new ER 
diagram from scratch.  It was designed for MySQL, but the diagrams are 
appropriate for any DB.  However, if you are looking to model (auto-created)an 
existing DB, this may not be the tool.   

More info:
http://www.fabforce.net/dbdesigner4/

Kelly Heikkila
Kinetic Data, Inc.



-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 19, 2006 8:28 AM
To: arslist@ARSLIST.ORG
Cc: T. Dee
Subject: OT: Entity Relationship


We are looking for a software package that can build an Entity Relationship 
diagram.

Does anyone have any suggestions?

Thanks!

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org