Re: server crashing when consuming a web servie

2008-11-24 Thread Darshana Jivan [MTN Network Solutions]
Hi Mark,

 

Thank you for your response.

 

I have been using web services for the past 3 years now with no problems
and now I have created a new service I am having issues. Do you think
that the above issue has to do with the xml schema with the bindings?

 

Regards,

Darshana

 

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Walters, Mark
Sent: 21 November 2008 12:32 PM
To: arslist@ARSLIST.ORG
Subject: Re: server crashing when consuming a web servie

 

** 

Yes, the server is crashing .  The stack below matches that for arserver
defect SW00288690, which is fixed in 7.0.1 patch 8.

 

Mark Walters

 

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 support representative for BMC
Software, Inc.

 

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Darshana Jivan [MTN Network
Solutions]
Sent: 21 November 2008 08:10
To: arslist@ARSLIST.ORG
Subject: server crashing when consuming a web servie

 

** 

Hi,

 

Please can someone assist me in understanding what this error actually
means? I am trying to consume as web service and it seems that the
server is crashing when invoking the service.

 

Below is the error log.

 

 

NISDEV07 is failing with the following in the arerror.log:

 

Thu Nov 20 15:00:20 2008  390620 : AR System server terminated when a
signal/exception was received by the server (ARNOTE 20)

Thu Nov 20 15:00:20 2008 11

   Timestamp: Thu Nov 20 2008 15:00:20.6514

   Thread Id: 7

   Version: 7.0.01 Patch 004 200708141640 Aug 14 2007 17:11:18

   ServerName: nisdev07

   Database: SQL -- Oracle

   Hardware: sun4u

   OS: SunOS 5.10

   RPC Id: 10

   RPC Call: 2 (SE)

   RPC Queue: 390620

   Client: User ARAdmin from Remedy User (protocol 12) at IP address
209.212.109.147

   Form: MTNNS:EventLog New Layout

   Logging On:

 

Stacks:

/app/ar/nisdev07/system/bin/arserverd:DumpStackTrace+0x88

/app/ar/nisdev07/system/bin/arserverd:SignalTrapProc+0x160

/lib/libc.so.1:0xc5364

/lib/libc.so.1:0xb9e64

/app/ar/nisdev07/system/bin/libxerces-depdombmc.so.26.0:__1cLxercesc_2_6
MDocumentImplKimportNode6Mpn0AINodeImpl_b_3_+0x28 [ Signal 11 (SEGV)]

/app/ar/nisdev07/system/bin/libxerces-depdombmc.so.26.0:__1cLxercesc_2_6
MDOM_DocumentKimportNode6Mrkn0AIDOM_Node_b_2_+0x18

/app/ar/nisdev07/system/bin/arserverd:__1cRARXMLHandlerUtilsTBuildDOMTre
eFromStr6FrnLxercesc_2_6JDOMString_rn0BMDOM_Document_rn0BIDOM_Node__C_+0
xf0

/app/ar/nisdev07/system/bin/arserverd:__1cUARXMLComplexEntryGetOProcessE
lement6MrnLxercesc_2_6ODOM_TreeWalker_pnQARFieldValueList_rn0BJDOMString
_rn0BMDOM_Document_rn0BLDOM_Element__9B_+0x3c4

/app/ar/nisdev07/system/bin/arserverd:__1cUARXMLComplexEntryGetMProcessN
odes6MrnLxercesc_2_6ODOM_TreeWalker_pnQARFieldValueList_pnYARComplexEntr
yGetOutList_ipin0BJDOMString_rn0BMDOM_Document_rn0BLDOM_Element__v_+0x17
8

/app/ar/nisdev07/system/bin/arserverd:__1cUARXMLComplexEntryGetMProcessN
odes6MrnLxercesc_2_6ODOM_TreeWalker_pnQARFieldValueList_pnYARComplexEntr
yGetOutList_ipin0BJDOMString_rn0BMDOM_Document_rn0BLDOM_Element__v_+0x21
4

/app/ar/nisdev07/system/bin/arserverd:__1cUARXMLComplexEntryGetMProcessN
odes6MrnLxercesc_2_6ODOM_TreeWalker_pnQARFieldValueList_pnYARComplexEntr
yGetOutList_ipin0BJDOMString_rn0BMDOM_Document_rn0BLDOM_Element__v_+0x21
4

/app/ar/nisdev07/system/bin/arserverd:__1cUARXMLComplexEntryGetSProcessF
ormMapping6MrnLxercesc_2_6ODOM_TreeWalker_pnYARComplexEntryGetOutList_n0
BJDOMString_rn0BMDOM_Document_rn0BLDOM_Element__v_+0x424

/app/ar/nisdev07/system/bin/arserverd:__1cUARXMLComplexEntryGetMProcessN
odes6MrnLxercesc_2_6ODOM_TreeWalker_pnQARFieldValueList_pnYARComplexEntr
yGetOutList_ipin0BJDOMString_rn0BMDOM_Document_rn0BLDOM_Element__v_+0x40
4

/app/ar/nisdev07/system/bin/arserverd:__1cUARXMLComplexEntryGetQBuildXML
Document6MpcpnYARComplexEntryGetOutList_pnSARXMLValueInfoList_Cp1_v_+0x4
f4

/app/ar/nisdev07/system/bin/arserverd:GetComplexEntryGetToXML+0x6c

/app/ar/nisdev07/system/bin/arserverd:__1cbASubValueListForWebServices6F
pnOARSchemaStruct_pnNAREntryIdList_pnQARFieldValueList_CpnLARValueList_7
pnMARStatusList__i_+0xaf8

/app/ar/nisdev07/system/bin/arserverd:0x20a8fc

/app/ar/nisdev07/system/bin/arserverd:0x20b038

/app/ar/nisdev07/system/bin/arserverd:MergeFieldAssignList+0x18c

/app/ar/nisdev07/system/bin/arserverd:PerformFilterOps+0x1ac8

/app/ar/nisdev07/system/bin/arserverd:PrepareEntryContext+0x874

/app/ar/nisdev07/system/bin/arserverd:arsetentry_12_svc+0x5d8

/app/ar/nisdev07/system/bin/arserverd:HandleRPCs+0x134d0

/app/ar/nisdev07/system/bin/arserverd:WorkerThread+0x5f4

/app/ar/nisdev07/system/bin/arserverd:RestartableThreadMain+0x60

/app/ar/nisdev07/system/bin/arserverd:UnixThreadStartRoutine+0xe8

/lib/libc.so.1:0xc5238

 

Regards, 
Darshana Jivan 

Re: server crashing when consuming a web servie

2008-11-24 Thread Rakshit Bhandary
Hi,

It has nothing to do with which web service you are consuming. The server
doesnt crash for all webservices but only one or two. There is no clear
explanation as to why, but i assume it has to something with the threads. As
mentioned by Mark, applying the patch would fix the issue.

Rakshit

On Mon, Nov 24, 2008 at 4:25 PM, Darshana Jivan [MTN Network Solutions] 
[EMAIL PROTECTED] wrote:

 **

 Hi Mark,



 Thank you for your response.



 I have been using web services for the past 3 years now with no problems
 and now I have created a new service I am having issues. Do you think that
 the above issue has to do with the xml schema with the bindings?



 Regards,

 Darshana



 *From:* Action Request System discussion list(ARSList) [mailto:
 [EMAIL PROTECTED] *On Behalf Of *Walters, Mark
 *Sent:* 21 November 2008 12:32 PM
 *To:* arslist@ARSLIST.ORG
 *Subject:* Re: server crashing when consuming a web servie



 **

 Yes, the server is crashing .  The stack below matches that for arserver
 defect SW00288690, which is fixed in 7.0.1 patch 8.



 Mark Walters



 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 support representative for BMC Software, Inc.



 *From:* Action Request System discussion list(ARSList) [mailto:
 [EMAIL PROTECTED] *On Behalf Of *Darshana Jivan [MTN Network Solutions]
 *Sent:* 21 November 2008 08:10
 *To:* arslist@ARSLIST.ORG
 *Subject:* server crashing when consuming a web servie



 **

 Hi,



 Please can someone assist me in understanding what this error actually
 means? I am trying to consume as web service and it seems that the server is
 crashing when invoking the service.



 Below is the error log.





 NISDEV07 is failing with the following in the arerror.log:



 Thu Nov 20 15:00:20 2008  390620 : AR System server terminated when a
 signal/exception was received by the server (ARNOTE 20)

 Thu Nov 20 15:00:20 2008 11

Timestamp: Thu Nov 20 2008 15:00:20.6514

Thread Id: 7

Version: 7.0.01 Patch 004 200708141640 Aug 14 2007 17:11:18

ServerName: nisdev07

Database: SQL -- Oracle

Hardware: sun4u

OS: SunOS 5.10

RPC Id: 10

RPC Call: 2 (SE)

RPC Queue: 390620

Client: User ARAdmin from Remedy User (protocol 12) at IP address
 209.212.109.147

Form: MTNNS:EventLog New Layout

Logging On:



 Stacks:

 /app/ar/nisdev07/system/bin/arserverd:DumpStackTrace+0x88

 /app/ar/nisdev07/system/bin/arserverd:SignalTrapProc+0x160

 /lib/libc.so.1:0xc5364

 /lib/libc.so.1:0xb9e64

 /app/ar/nisdev07/system/bin/libxerces-depdombmc.so.26.0:__1cLxercesc_2_6MDocumentImplKimportNode6Mpn0AINodeImpl_b_3_+0x28
 [ Signal 11 (SEGV)]


 /app/ar/nisdev07/system/bin/libxerces-depdombmc.so.26.0:__1cLxercesc_2_6MDOM_DocumentKimportNode6Mrkn0AIDOM_Node_b_2_+0x18


 /app/ar/nisdev07/system/bin/arserverd:__1cRARXMLHandlerUtilsTBuildDOMTreeFromStr6FrnLxercesc_2_6JDOMString_rn0BMDOM_Document_rn0BIDOM_Node__C_+0xf0


 /app/ar/nisdev07/system/bin/arserverd:__1cUARXMLComplexEntryGetOProcessElement6MrnLxercesc_2_6ODOM_TreeWalker_pnQARFieldValueList_rn0BJDOMString_rn0BMDOM_Document_rn0BLDOM_Element__9B_+0x3c4


 /app/ar/nisdev07/system/bin/arserverd:__1cUARXMLComplexEntryGetMProcessNodes6MrnLxercesc_2_6ODOM_TreeWalker_pnQARFieldValueList_pnYARComplexEntryGetOutList_ipin0BJDOMString_rn0BMDOM_Document_rn0BLDOM_Element__v_+0x178


 /app/ar/nisdev07/system/bin/arserverd:__1cUARXMLComplexEntryGetMProcessNodes6MrnLxercesc_2_6ODOM_TreeWalker_pnQARFieldValueList_pnYARComplexEntryGetOutList_ipin0BJDOMString_rn0BMDOM_Document_rn0BLDOM_Element__v_+0x214


 /app/ar/nisdev07/system/bin/arserverd:__1cUARXMLComplexEntryGetMProcessNodes6MrnLxercesc_2_6ODOM_TreeWalker_pnQARFieldValueList_pnYARComplexEntryGetOutList_ipin0BJDOMString_rn0BMDOM_Document_rn0BLDOM_Element__v_+0x214


 /app/ar/nisdev07/system/bin/arserverd:__1cUARXMLComplexEntryGetSProcessFormMapping6MrnLxercesc_2_6ODOM_TreeWalker_pnYARComplexEntryGetOutList_n0BJDOMString_rn0BMDOM_Document_rn0BLDOM_Element__v_+0x424


 /app/ar/nisdev07/system/bin/arserverd:__1cUARXMLComplexEntryGetMProcessNodes6MrnLxercesc_2_6ODOM_TreeWalker_pnQARFieldValueList_pnYARComplexEntryGetOutList_ipin0BJDOMString_rn0BMDOM_Document_rn0BLDOM_Element__v_+0x404


 /app/ar/nisdev07/system/bin/arserverd:__1cUARXMLComplexEntryGetQBuildXMLDocument6MpcpnYARComplexEntryGetOutList_pnSARXMLValueInfoList_Cp1_v_+0x4f4

 /app/ar/nisdev07/system/bin/arserverd:GetComplexEntryGetToXML+0x6c


 /app/ar/nisdev07/system/bin/arserverd:__1cbASubValueListForWebServices6FpnOARSchemaStruct_pnNAREntryIdList_pnQARFieldValueList_CpnLARValueList_7pnMARStatusList__i_+0xaf8

 /app/ar/nisdev07/system/bin/arserverd:0x20a8fc

 /app/ar/nisdev07/system/bin/arserverd:0x20b038

 /app/ar/nisdev07/system/bin/arserverd:MergeFieldAssignList+0x18c

 

Re: Can’t resize form view SOLVED

2008-11-24 Thread Dwayne Martin
Thanks, Fred,

When I read your letter my first reaction was, Come now, the User tool doesn't 
expand to display all the fields.  I have fields off to the right of the 
display on all my forms.

BUT it turns out that a Dialog window DOES expand to include all the fields (at 
least in the User tool, but apparently not in Mid-Tier).  I had a display-only, 
hidden character field with no label that I couldn't even see in the Admin 
tool.  I got rid of it, and now the views display normally.

Thank you too, David, for your suggestion.

Gratefully yours,
Dwayne



 Original message 
Date: Fri, 21 Nov 2008 15:28:14 -0600
From: Grooms, Frederick W [EMAIL PROTECTED]  
Subject: Re: Can’t resize form view  
To: arslist@ARSLIST.ORG

Are there any fields at the right edge of those specific views?  I seem to 
remember the User tool automatically expanding a view when there were fields 
to display.

Fred

-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Dwayne Martin
Sent: Friday, November 21, 2008 3:26 PM
To: arslist@ARSLIST.ORG
Subject: Can’t resize form view

Dear List,

We have a Display-Only, Standard form that we use for dialogs.   It has 
several views, most of which appear normally in the User tool.  But two of the 
views (one is a copy of the other) are elongated horizontally.  And no matter 
how often we re-size them in the Admin tool, they stay elongated in the User 
tool.  But they display properly in Mid-Tier.

After editing, we save our view before opening a new view, and when we close 
the form and re-display it, the views show their new size in the Admin tool, 
but not in the User tool.  

I cleared out the cache on my own computer, and displayed the views on a 
virgin computer that had never had Remedy installed on it before, but they 
still appear elongated.

What am I missing?

Dwayne Martin
James Madison University

(ARS, User and Admin tool 7.1 patch 3, RH Linux server, Oracle 10.2 db)

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


Re: Plugin Crashing issue

2008-11-24 Thread Timothy Rondeau
Hi All,

Not sure why I did not think of this earlier, but we also have a test server.  
So I pointed our test server to the devdb server and the plugin crashes with 
same error below.  So this tells me something wrong with dev DB that is causing 
this to crash.



-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Chowdhury, Tauf
Sent: Sunday, November 23, 2008 7:27 PM
To: arslist@ARSLIST.ORG
Subject: Re: Plugin Crashing issue

I would try what Fred suggested about copying the file over from your other 
system. Remember you might have to manually unregister and register the new one.


-Original Message-
From: Action Request System discussion list(ARSList) on behalf of Timothy 
Rondeau
Sent: Sun 11/23/2008 5:21 PM
To: arslist@ARSLIST.ORG
Subject: Re: Plugin Crashing issue
 
Hi Fred,

 

No and we have been told no updates have been done on the machine, so we are at 
a loss on this one.

 

Tim

 



From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Grooms, Frederick W
Sent: Sunday, November 23, 2008 4:21 PM
To: arslist@ARSLIST.ORG
Subject: Re: Plugin Crashing issue

 

Since it is telling you the problem is in the file msvcr71.dll (MS Visual C 
Runtime 7.1) I would have to ask ... Was any other application installed or 
updated on Thursday night?

 

Compare that dll file (in your system32 directory) with the one on Production.  
If they are different you should be able to copy the one from your production 
server over to your dev server

 

Fred

 

From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Timothy Rondeau
Sent: Sunday, November 23, 2008 2:52 PM
To: arslist@ARSLIST.ORG
Subject: Plugin Crashing issue
Importance: High

 

Hi All, 

 

Basically this issue started Thursday night in our Dev system.  Users getting 
issue can not longer authenticate.  

 

Looking into further found the arplugin keeps crashing.   Restart the 
application and plugin comes up and then crashes:

 

Faulting application arplugin.exe, version 7.0.1.2, faulting module 
msvcr71.dll, version 7.10.7031.4, fault address 0xd587.

 

ARERR [8760] Cannot establish a network connection to the AR System Plug-In 
server

 

 

We added some fields on Thursday to the Requestor console, SRM request, 
HPD:helpdesk, Helpdesk_create form and then to 2 users forms.All these 
changes have since been rolled back.   Still no luck plugin will not stay 
running.  I have tried starting from command line and still crashes.

 

 

We are running   7.0.1 patch 2  windows 2003, SQL 2000.  This is also what we 
run production and have been running for over 1 ½.   Both servers are running 
off of the same LDAP server with the same user and password.

 

 

So any info to help would be great.

 

Thanks

 

Tim

 

 

 

 

__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 e-mail and its attachments may contain Forest Laboratories, Inc. 
proprietary information that is privileged, confidential or subject to 
copyright belonging to Forest Laboratories, Inc. This e-mail is intended solely 
for the use of the individual or entity to which it is addressed. If you are 
not the intended recipient of this e-mail, or the employee or agent responsible 
for delivering this e-mail to the intended recipient, you are hereby notified 
that any dissemination, distribution, copying or action taken in relation to 
the contents of and attachments to this e-mail is strictly prohibited and may 
be unlawful. If you have received this e-mail in error, please notify the 
sender immediately and permanently delete the original and any copy of this 
e-mail and any printout.

___
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


Reporting question - count of tickets open at a particular point in time

2008-11-24 Thread Julie L Kanakanui JLKANAKA
Hello,  Wondering if anyone might have suggestion for best way to obtain 
snapshot stats of # of Cases open at a particular time each week (say, 
midnight on Wednesdays). 

I can run a Query with a search like:

'Created' = 10/9/2008 AND ('Resolved'  10/9/2008 OR 'Status*'  
Resolved)

which selects Cases that were created up to and including 12:00am at 
midnight and that were either resolved after that point or are still not 
resolved at time of search.  But obviously this would need to be run once 
each week...

Trying to figure out if there's another way to do this where a date range 
could be entered and this stat collected for each week included.


This is not the first time I've been asked about getting snapshop-in-time 
stats for open tickets and I'm hoping others may suggestions.  We are 
currently on Remedy 6.x, but moving to 7.x, so solutions/suggestions in 
either would be welcome.

Thanks,
Julie


[EMAIL PROTECTED]

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

Re: SQL Reporing Services - making sense of Remedy Table structure

2008-11-24 Thread Gayford, Matthew C.
Neil,

I do all of our Remedy reports in SSRS. If you use the views, you should be 
able to query off of HPD:Help Desk and set the group parameter on the report to 
the assigned support group field, then do a count for each group. The 
assignment log form will show you all assignments, both past and present. 
You'll want to look at the help desk form for the current ones, unless you want 
to add some data parameters to the report if you stick with the assignment log.

HTH,

-Matt

Matthew C. Gayford
Application Developer  Remedy Administrator
University of North Carolina Wilmington 
(910) 962-7177


-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of npeterson
Sent: Sunday, November 23, 2008 5:32 PM
To: arslist@ARSLIST.ORG
Subject: Re: SQL Reporing Services - making sense of Remedy Table structure

Thanks both of you - this advice had gotten me almost to where I need to be.
One wierd thing I've noticed is that in the HPD_HelpDeskAssignmentLogJoin
table (the table I believe has what I need in it) , there are two rows for
each submitted incident. The difference is on the Request_ID - one will be
something like

INC5(HDA565)

and the second will be something like

INC5(HDA249)

This is causing all of my reports to some out double. I've tried to filter
this down using fields like actual duration second and while it did get the
numbers down thay were not acurate. Has any had to deal with something like
this before or have any advice?

Thanks

neilp


Drew Shuller wrote:
 
 npeterson, query the views instead. Or look for the Database Guide in the
 documentation.
 
 Drew
 ERCOT
 
 I am hoping to user SQL Reporting services to create some Remedy reports,
 however I can not make one bit of sense of the tables in this Database.
 We
 are using Remedy IT Service Management 7.0 - DB is on SQL server 2005. A
 sample report would just be

 count all tickets currently assigned to a specific support group.

 I can not find any reference to support groups, open incidents, support
 personnel, etc. Is there some secret or guide on what data is stored
 where?

 For the record I am not a remedy guy, I just happen to admin the system
 and
 have been given some reporting requirement that can not be met with the
 integrated reporting tools.

 Thanks
 --
 View this message in context:
 http://www.nabble.com/SQL-Reporing-Services---making-sense-of-Remedy-Table-structure-tp20626113p20626113.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

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

-- 
View this message in context: 
http://www.nabble.com/SQL-Reporing-Services---making-sense-of-Remedy-Table-structure-tp20626113p20651835.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

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


Re: Reporting question - count of tickets open at a particular point in time

2008-11-24 Thread Gayford, Matthew C.
Hi Julie,

Are you trying to do the report in Remedy or are you using another tool? If 
you're doing it in Remedy, you can have a macro simply run the query and use 
the $DATE$ keyword to get the results you wanted. If you're using SSRS, you can 
do the same thing and set up a subscription to the report that fires on 
Wednesday nights and emails the result.

-Matt

Matthew C. Gayford
Application Developer  Remedy Administrator
University of North Carolina Wilmington
(910) 962-7177

From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Julie L Kanakanui JLKANAKA
Sent: Monday, November 24, 2008 9:08 AM
To: arslist@ARSLIST.ORG
Subject: Reporting question - count of tickets open at a particular point in 
time

**
Hello,  Wondering if anyone might have suggestion for best way to obtain 
snapshot stats of # of Cases open at a particular time each week (say, midnight 
on Wednesdays).

I can run a Query with a search like:

'Created' = 10/9/2008 AND ('Resolved'  10/9/2008 OR 'Status*'  
Resolved)

which selects Cases that were created up to and including 12:00am at midnight 
and that were either resolved after that point or are still not resolved at 
time of search.  But obviously this would need to be run once each week...

Trying to figure out if there's another way to do this where a date range could 
be entered and this stat collected for each week included.


This is not the first time I've been asked about getting snapshop-in-time stats 
for open tickets and I'm hoping others may suggestions.  We are currently on 
Remedy 6.x, but moving to 7.x, so solutions/suggestions in either would be 
welcome.

Thanks,
Julie


[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


Re: Reporting question - count of tickets open at a particular point in time

2008-11-24 Thread Frank, Gordon M. (CMS/CTR)
One way to do this is to use an Escalation which runs every night during
off-hours. The setup is the following:

1.  Create an Integer field with Administrator only permissions - I
usually call it Days Open
2.  Setup an Escalation which performs Days Open = Days Open +1
every night on each record
3.  When you report, used the clause 'Status'  Resolved
4.  Use the Days Open count for further statistics after the Case is
Resolved.

 

The result is a count of number of days the case was open at a specific
time (using Create-date and Modified-Date in the query).

 

Another way to do this is to create an Audit Trail form which holds
status transactions. A query against this will give you what was open
during a specific past time. The form will get very large, so you will
have to come up with a good archive scenario. A good rule of thumb is on
average, each Case will have seven (7) modifications. Therefore your
Audit form will increase by 7 times for each Case. From an Archive
standpoint, calculate how often you report. If it is 30 days, hold 30
days before you archive. If its yearly, hold a year and so on! Over 30
days may require creativity on the backend by holding archives in .arx
files and reloading as you need them (something which can be automated).

 

You can also use Status-History for calculating open times.

 

Just some thoughts,

 

Gordon M. Frank

Lockheed Martin



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Julie L Kanakanui JLKANAKA
Sent: Monday, November 24, 2008 9:08 AM
To: arslist@ARSLIST.ORG
Subject: Reporting question - count of tickets open at a particular
point in time

 

** 
Hello,  Wondering if anyone might have suggestion for best way to obtain
snapshot stats of # of Cases open at a particular time each week (say,
midnight on Wednesdays).   

I can run a Query with a search like: 

'Created' = 10/9/2008 AND ('Resolved'  10/9/2008 OR 'Status*' 
Resolved) 

which selects Cases that were created up to and including 12:00am at
midnight and that were either resolved after that point or are still not
resolved at time of search.  But obviously this would need to be run
once each week... 

Trying to figure out if there's another way to do this where a date
range could be entered and this stat collected for each week included. 


This is not the first time I've been asked about getting
snapshop-in-time stats for open tickets and I'm hoping others may
suggestions.  We are currently on Remedy 6.x, but moving to 7.x, so
solutions/suggestions in either would be welcome. 

Thanks, 
Julie 


[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


Strange ARS 7.0.1 Patch 9 bug

2008-11-24 Thread Pierson, Shawn
Good morning,

I decided to try going from patch 6 to patch 9, and found a strange bug and 
wanted to see if anyone else ran into this before.

Basically, we use AD authentication for Remedy, but do store all permissions 
and such in ARS.  This has worked fine for my account in the past.  However, 
with this patch, despite having the same access rights, the fact that I am not 
storing the password in the User form seems to prevent me from having admin 
rights.  I was able to gain my admin rights back by storing a password in the 
User form.

Has anyone else encountered this, and if so, what is a workaround?

Thanks,

Shawn Pierson
Remedy Developer | Southern Union



Private and confidential as detailed here: 
http://www.sug.com/disclaimers/default.htm#Mail . If you cannot access the 
link, please e-mail sender.

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


Re: ARS for non Trouble Ticketing applications

2008-11-24 Thread Shellman, David
In addition to the Applications that Lisa noted, we also have a system that 
allocates Telecommunication charges to the appropriate departments.

If memory serves me correctly, a long time ago Kelly Deaver put together an 
application that could be used to track who was dating your teenager.

Dave

From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of sam appecherla
Sent: Friday, November 14, 2008 11:22 AM
To: arslist@ARSLIST.ORG
Subject: ARS for non Trouble Ticketing applications

** Hi List,

Just curious to know..

Apart from using Remedy for HelpDesk, Trouble Ticketing and the kinds, what 
else can we do with this workflow engine for? Does anyone have a custom built 
product/application built on ARS apart from Trouble Ticketing kinds that you 
would like to share?

Regards,
SriSamSri Appecherla
Mobile# +91 991 610 6008
__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: Indirect reference to form field value

2008-11-24 Thread L G Robinson

Hi Folks,

Sorry.. I may have committed a breach of etiquette
by not properly identifying myself:

Larry Robinson
NC State University
Office Of Information Technology
Remedy Administrator

On Nov 21, 2008, at 11:35 AM, L G Robinson wrote:


Hi Folks,

I am seeking some assistance in referencing the value of a form
field through an indirect reference.

I have a filter guide that contain a loop to process a number of
fields on the form. I am using this to detect which fields have
been modified and to build a diary entry containing the changes.
The field names of interest are stored in another form and I have
been successful in fetching the names and building a
qualification to detect the condition that I am interested in. I
used the EXTERNAL function in the qualification of the filter to
detect the conditions that I am interested in. This part works
fine.

The problem comes inside this filter. Now that I have determined
that one of the fields of interest has been modified, I need to
reference the current value of that field on the form. I want to
reference the field value as part of a Set Fields action
against the current transaction. The name of the field of
interest is contained in another field on the same form... lets
call it $field_name$. So the question is, how do I get the value
of the field whose name is in the field $field_name$, as part of a
Set Fields action in a filter? I do not see a way to use the
EXTERNAL operator in this context.

I have looked through all of the functions and processes and
none of them appear to provide the functionality that I need.
Any suggestions on how to accomplish this will be greatly
appreciated.

AR Server 5.1.2 patch 1313
Sybase DB

Thanks.
Larry


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


Intermittent, Spotty ARS Performance

2008-11-24 Thread Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE
Hi everyone:

 

This problem has me perplexed.

 

At a site I support, the Remedy server inexplicably stops responding to
requests.  It's very intermittent.  It runs fine for awhile, then
seemingly without warning, it just hangs.  Users attempting to log on
get stuck at the Setting server port dialog, which eventually times
out.

 

Other users who are already logged who try to pull up a ticket get stuck
at a blank screen that never comes back.

 

To resolve the issue, they have to bounce the Remedy server service.
The system works for awhile...until it hangs up again.

 

Any ideas what might be causing this?

 

-  I have monitored CPU utilization when this occurs, and the
CPU hums along at about 3% - 5% utilization

-  Network utilization is flat-lined whenever this occurs (i.e.,
no spike)

-  Memory utilization appears normal

-  CNET bandwidth tests resolve to better than dedicated T1
performance (for what that's worth)

 

Any thoughts are greatly appreciated.

 

The interesting thing is, we have the same exact Remedy apps running on
the same exact type of server in the same exact environment in four
other locations, and those four other locations never experience any
problems.

 

Norm

 

Remedy ARS 6.3

Microsoft SQL 2000 SP4

Microsoft Windows 2000 SP2

100% Custom Apps - No ITSM


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


Re: Intermittent, Spotty ARS Performance

2008-11-24 Thread Meyer, Jennifer L
What java version are you running?

Jennifer Meyer

From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE
Sent: Monday, November 24, 2008 12:03 PM
To: arslist@ARSLIST.ORG
Subject: Intermittent, Spotty ARS Performance

Hi everyone:

This problem has me perplexed.

At a site I support, the Remedy server inexplicably stops responding to 
requests.  It's very intermittent.  It runs fine for awhile, then seemingly 
without warning, it just hangs.  Users attempting to log on get stuck at the 
Setting server port dialog, which eventually times out.

Other users who are already logged who try to pull up a ticket get stuck at a 
blank screen that never comes back.

To resolve the issue, they have to bounce the Remedy server service.  The 
system works for awhile...until it hangs up again.

Any ideas what might be causing this?


-  I have monitored CPU utilization when this occurs, and the CPU hums 
along at about 3% - 5% utilization

-  Network utilization is flat-lined whenever this occurs (i.e., no 
spike)

-  Memory utilization appears normal

-  CNET bandwidth tests resolve to better than dedicated T1 performance 
(for what that's worth)

Any thoughts are greatly appreciated.

The interesting thing is, we have the same exact Remedy apps running on the 
same exact type of server in the same exact environment in four other 
locations, and those four other locations never experience any problems.

Norm

Remedy ARS 6.3
Microsoft SQL 2000 SP4
Microsoft Windows 2000 SP2
100% Custom Apps - No ITSM
__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: Reporting question - count of tickets open at a particular point in time

2008-11-24 Thread Brien Dieterle
Take a look at flashboard variables, I think that is the easiest thing to
setup.  Displaying more than a few flashboards requires a license, however,
the variables are free and there may be another way to query those without
using a flashboard.

Brien

On Mon, Nov 24, 2008 at 7:53 AM, Frank, Gordon M. (CMS/CTR) 
[EMAIL PROTECTED] wrote:

 **

 One way to do this is to use an Escalation which runs every night during
 off-hours. The setup is the following:

1. Create an Integer field with Administrator only permissions – I
usually call it Days Open
2. Setup an Escalation which performs Days Open = Days Open +1 every
night on each record
3. When you report, used the clause 'Status'  Resolved
4. Use the Days Open count for further statistics after the Case is
Resolved.



 The result is a count of number of days the case was open at a specific
 time (using Create-date and Modified-Date in the query).



 Another way to do this is to create an Audit Trail form which holds status
 transactions. A query against this will give you what was open during a
 specific past time. The form will get very large, so you will have to come
 up with a good archive scenario. A good rule of thumb is on average, each
 Case will have seven (7) modifications. Therefore your Audit form will
 increase by 7 times for each Case. From an Archive standpoint, calculate how
 often you report. If it is 30 days, hold 30 days before you archive. If its
 yearly, hold a year and so on! Over 30 days may require creativity on the
 backend by holding archives in .arx files and reloading as you need them
 (something which can be automated).



 You can also use Status-History for calculating open times.



 Just some thoughts,



 Gordon M. Frank

 Lockheed Martin
   --

 *From:* Action Request System discussion list(ARSList) [mailto:
 [EMAIL PROTECTED] *On Behalf Of *Julie L Kanakanui JLKANAKA
 *Sent:* Monday, November 24, 2008 9:08 AM
 *To:* arslist@ARSLIST.ORG
 *Subject:* Reporting question - count of tickets open at a particular
 point in time



 **
 Hello,  Wondering if anyone might have suggestion for best way to obtain
 snapshot stats of # of Cases open at a particular time each week (say,
 midnight on Wednesdays).

 I can run a Query with a search like:

 'Created' = 10/9/2008 AND ('Resolved'  10/9/2008 OR 'Status*' 
 Resolved)

 which selects Cases that were created up to and including 12:00am at
 midnight and that were either resolved after that point or are still not
 resolved at time of search.  But obviously this would need to be run once
 each week...

 Trying to figure out if there's another way to do this where a date range
 could be entered and this stat collected for each week included.


 This is not the first time I've been asked about getting snapshop-in-time
 stats for open tickets and I'm hoping others may suggestions.  We are
 currently on Remedy 6.x, but moving to 7.x, so solutions/suggestions in
 either would be welcome.

 Thanks,
 Julie


 [EMAIL PROTECTED] __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


Java API Question

2008-11-24 Thread Phil Murnane
I'm using the 7.1 Java API to create a new field on a form.  Be
All:

I'm using the 7.1 Java API to create a new field on a form.  Before creating 
the field, I'd like to make sure a field with the same Field ID does not 
already exist.  I found the isPresent() method of the Field object in the 
javadocs, but since a generic Field cannot be instantiated (must use 
CharacterField or IntegerField, etc), how do I use isPresent() to check for any 
type existing field with a given Field ID?  Do I have to first check for an 
AttachmentField, then check for an AttachmentPoolField, then check for a 
CharacterField, etc?

Sorry if this is a dumb question -- I'm new at this OO programming stuff.

TIA,
--Phil




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


Re: Intermittent, Spotty ARS Performance

2008-11-24 Thread LJ Longwing
I'm assuming there are no messages going into the arerror.log or anything
like that?  How about the armonitor.log?  Try turning on Thread logging
(very small output) and see if you can see anything happening with threads
at the time it hangs.

  _  

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC 96
CS/SCCE
Sent: Monday, November 24, 2008 10:03 AM
To: arslist@ARSLIST.ORG
Subject: Intermittent, Spotty ARS Performance


** 

Hi everyone:

 

This problem has me perplexed.

 

At a site I support, the Remedy server inexplicably stops responding to
requests.  It's very intermittent.  It runs fine for awhile, then seemingly
without warning, it just hangs.  Users attempting to log on get stuck at the
Setting server port dialog, which eventually times out.

 

Other users who are already logged who try to pull up a ticket get stuck at
a blank screen that never comes back.

 

To resolve the issue, they have to bounce the Remedy server service.  The
system works for awhile.until it hangs up again.

 

Any ideas what might be causing this?

 

-  I have monitored CPU utilization when this occurs, and the CPU
hums along at about 3% - 5% utilization

-  Network utilization is flat-lined whenever this occurs (i.e., no
spike)

-  Memory utilization appears normal

-  CNET bandwidth tests resolve to better than dedicated T1
performance (for what that's worth)

 

Any thoughts are greatly appreciated.

 

The interesting thing is, we have the same exact Remedy apps running on the
same exact type of server in the same exact environment in four other
locations, and those four other locations never experience any problems.

 

Norm

 

Remedy ARS 6.3

Microsoft SQL 2000 SP4

Microsoft Windows 2000 SP2

100% Custom Apps - No ITSM

__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: Intermittent, Spotty ARS Performance

2008-11-24 Thread Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE
1.4.2_14

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Meyer, Jennifer L
Sent: Monday, November 24, 2008 11:07 AM
To: arslist@ARSLIST.ORG
Subject: Re: Intermittent, Spotty ARS Performance

** 

What java version are you running?

 

Jennifer Meyer



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC
96 CS/SCCE
Sent: Monday, November 24, 2008 12:03 PM
To: arslist@ARSLIST.ORG
Subject: Intermittent, Spotty ARS Performance

 

Hi everyone:

 

This problem has me perplexed.

 

At a site I support, the Remedy server inexplicably stops responding to
requests.  It's very intermittent.  It runs fine for awhile, then
seemingly without warning, it just hangs.  Users attempting to log on
get stuck at the Setting server port dialog, which eventually times
out.

 

Other users who are already logged who try to pull up a ticket get stuck
at a blank screen that never comes back.

 

To resolve the issue, they have to bounce the Remedy server service.
The system works for awhile...until it hangs up again.

 

Any ideas what might be causing this?

 

-  I have monitored CPU utilization when this occurs, and the
CPU hums along at about 3% - 5% utilization

-  Network utilization is flat-lined whenever this occurs (i.e.,
no spike)

-  Memory utilization appears normal

-  CNET bandwidth tests resolve to better than dedicated T1
performance (for what that's worth)

 

Any thoughts are greatly appreciated.

 

The interesting thing is, we have the same exact Remedy apps running on
the same exact type of server in the same exact environment in four
other locations, and those four other locations never experience any
problems.

 

Norm

 

Remedy ARS 6.3

Microsoft SQL 2000 SP4

Microsoft Windows 2000 SP2

100% Custom Apps - No ITSM

__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


AW: Intermittent, Spotty ARS Performance

2008-11-24 Thread Martin, Conny
Hi Norm,
 
Can you log on with Remedy Administrator while the server ist not
responding?
 
Kind Regards Conny



Von: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Im Auftrag von LJ Longwing
Gesendet: Montag, 24. November 2008 18:15
An: arslist@ARSLIST.ORG
Betreff: Re: Intermittent, Spotty ARS Performance


** 
I'm assuming there are no messages going into the arerror.log or
anything like that?  How about the armonitor.log?  Try turning on Thread
logging (very small output) and see if you can see anything happening
with threads at the time it hangs.



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC
96 CS/SCCE
Sent: Monday, November 24, 2008 10:03 AM
To: arslist@ARSLIST.ORG
Subject: Intermittent, Spotty ARS Performance


** 

Hi everyone:

 

This problem has me perplexed.

 

At a site I support, the Remedy server inexplicably stops responding to
requests.  It's very intermittent.  It runs fine for awhile, then
seemingly without warning, it just hangs.  Users attempting to log on
get stuck at the Setting server port dialog, which eventually times
out.

 

Other users who are already logged who try to pull up a ticket get stuck
at a blank screen that never comes back.

 

To resolve the issue, they have to bounce the Remedy server service.
The system works for awhile...until it hangs up again.

 

Any ideas what might be causing this?

 

-  I have monitored CPU utilization when this occurs, and the
CPU hums along at about 3% - 5% utilization

-  Network utilization is flat-lined whenever this occurs (i.e.,
no spike)

-  Memory utilization appears normal

-  CNET bandwidth tests resolve to better than dedicated T1
performance (for what that's worth)

 

Any thoughts are greatly appreciated.

 

The interesting thing is, we have the same exact Remedy apps running on
the same exact type of server in the same exact environment in four
other locations, and those four other locations never experience any
problems.

 

Norm

 

Remedy ARS 6.3

Microsoft SQL 2000 SP4

Microsoft Windows 2000 SP2

100% Custom Apps - No ITSM

__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: Intermittent, Spotty ARS Performance (UNCLASSIFIED)

2008-11-24 Thread Michaud, Christopher W Mr CTR USA MEDCOM USAMITC
Classification:  UNCLASSIFIED 
Caveats: NONE

Norm,

You may want to look closer at the SQL side. Look for locks. Perhaps
someone querying a diary or un-indexed field. Also, are you using SQL
replication? In particular, are snapshots turned on?


Christopher Michaud

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC
96 CS/SCCE
Sent: Monday, November 24, 2008 11:03 AM
To: arslist@ARSLIST.ORG
Subject: Intermittent, Spotty ARS Performance

** 

Hi everyone:

 

This problem has me perplexed.

 

At a site I support, the Remedy server inexplicably stops responding to
requests.  It's very intermittent.  It runs fine for awhile, then
seemingly without warning, it just hangs.  Users attempting to log on
get stuck at the Setting server port dialog, which eventually times
out.

 

Other users who are already logged who try to pull up a ticket get stuck
at a blank screen that never comes back.

 

To resolve the issue, they have to bounce the Remedy server service.
The system works for awhile...until it hangs up again.

 

Any ideas what might be causing this?

 

-  I have monitored CPU utilization when this occurs, and the
CPU hums along at about 3% - 5% utilization

-  Network utilization is flat-lined whenever this occurs (i.e.,
no spike)

-  Memory utilization appears normal

-  CNET bandwidth tests resolve to better than dedicated T1
performance (for what that's worth)

 

Any thoughts are greatly appreciated.

 

The interesting thing is, we have the same exact Remedy apps running on
the same exact type of server in the same exact environment in four
other locations, and those four other locations never experience any
problems.

 

Norm

 

Remedy ARS 6.3

Microsoft SQL 2000 SP4

Microsoft Windows 2000 SP2

100% Custom Apps - No ITSM

__Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
html___ 
Classification:  UNCLASSIFIED 
Caveats: NONE

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


Re: Java API Question

2008-11-24 Thread Thilo Stapff
It is probably not necessary to check beforehand if a field with the 
same ID doesn't exist. If it does, the create function should fail and 
throw an exception (most likely ARERR 407, Duplicate field or VUI-ID in 
the definition), which your program then might catch and handle somehow.


Regards,
Thilo Stapff


Phil Murnane wrote:

I'm using the 7.1 Java API to create a new field on a form.  Be
All:

I'm using the 7.1 Java API to create a new field on a form.  Before creating 
the field, I'd like to make sure a field with the same Field ID does not 
already exist.  I found the isPresent() method of the Field object in the 
javadocs, but since a generic Field cannot be instantiated (must use 
CharacterField or IntegerField, etc), how do I use isPresent() to check for any 
type existing field with a given Field ID?  Do I have to first check for an 
AttachmentField, then check for an AttachmentPoolField, then check for a 
CharacterField, etc?

Sorry if this is a dumb question -- I'm new at this OO programming stuff.

TIA,
--Phil


  


___
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


API to Create Remedy Objects

2008-11-24 Thread Frank Caruso
I've been wondering, based on an earlier post, why you would used the Remedy
API to create Remedy objects such as forms, fields, alinks, etc?

Maybe some users could share me what they have built using the API in this
manner.

Thank you

Frank

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


Re: Java API Question

2008-11-24 Thread Carey Matthew Black
Phil,

I think your looking in the wrong class...

com.bmc.arsys.api.ARServerUser.getField(String form, int fieldId)

In this case I think you want the getField to throw an
com.bmc.arsys.api.ARException
 ( if object is not loaded) then you add the field you want in the
catch block. :)

HTH.

-- 
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 Mon, Nov 24, 2008 at 12:12 PM, Phil Murnane [EMAIL PROTECTED] wrote:
 I'm using the 7.1 Java API to create a new field on a form.  Be
 All:

 I'm using the 7.1 Java API to create a new field on a form.  Before creating 
 the field, I'd like to make sure a field with the same Field ID does not 
 already exist.  I found the isPresent() method of the Field object in the 
 javadocs, but since a generic Field cannot be instantiated (must use 
 CharacterField or IntegerField, etc), how do I use isPresent() to check for 
 any type existing field with a given Field ID?  Do I have to first check for 
 an AttachmentField, then check for an AttachmentPoolField, then check for a 
 CharacterField, etc?

 Sorry if this is a dumb question -- I'm new at this OO programming stuff.

 TIA,
 --Phil

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


Re: Java API Question

2008-11-24 Thread LJ Longwing
If you would like to get a list of existing Field ID's on a form you want to
look to your ARServerUser object and use the method getListField.  You would
want to use the form and the constant Constants.AR_FIELD_TYPE_ALL leaving
the 3rd parameter either non existent, or set it to 0 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Phil Murnane
Sent: Monday, November 24, 2008 10:12 AM
To: arslist@ARSLIST.ORG
Subject: Java API Question

I'm using the 7.1 Java API to create a new field on a form.  Be
All:

I'm using the 7.1 Java API to create a new field on a form.  Before creating
the field, I'd like to make sure a field with the same Field ID does not
already exist.  I found the isPresent() method of the Field object in the
javadocs, but since a generic Field cannot be instantiated (must use
CharacterField or IntegerField, etc), how do I use isPresent() to check for
any type existing field with a given Field ID?  Do I have to first check for
an AttachmentField, then check for an AttachmentPoolField, then check for a
CharacterField, etc?

Sorry if this is a dumb question -- I'm new at this OO programming stuff.

TIA,
--Phil


  


___
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: Intermittent, Spotty ARS Performance

2008-11-24 Thread Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE
Haven't tried logging on; however, when this happened last I
coincidentally had the Admin tool already opened, so I poked around and
was able to open objects (ALs, forms, etc.) without a problem.

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Martin, Conny
Sent: Monday, November 24, 2008 11:19 AM
To: arslist@ARSLIST.ORG
Subject: AW: Intermittent, Spotty ARS Performance

** 
Hi Norm,
 
Can you log on with Remedy Administrator while the server ist not
responding?
 
Kind Regards Conny



Von: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Im Auftrag von LJ Longwing
Gesendet: Montag, 24. November 2008 18:15
An: arslist@ARSLIST.ORG
Betreff: Re: Intermittent, Spotty ARS Performance


** 
I'm assuming there are no messages going into the arerror.log or
anything like that?  How about the armonitor.log?  Try turning on Thread
logging (very small output) and see if you can see anything happening
with threads at the time it hangs.



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC
96 CS/SCCE
Sent: Monday, November 24, 2008 10:03 AM
To: arslist@ARSLIST.ORG
Subject: Intermittent, Spotty ARS Performance


** 

Hi everyone:

 

This problem has me perplexed.

 

At a site I support, the Remedy server inexplicably stops responding to
requests.  It's very intermittent.  It runs fine for awhile, then
seemingly without warning, it just hangs.  Users attempting to log on
get stuck at the Setting server port dialog, which eventually times
out.

 

Other users who are already logged who try to pull up a ticket get stuck
at a blank screen that never comes back.

 

To resolve the issue, they have to bounce the Remedy server service.
The system works for awhile...until it hangs up again.

 

Any ideas what might be causing this?

 

-  I have monitored CPU utilization when this occurs, and the
CPU hums along at about 3% - 5% utilization

-  Network utilization is flat-lined whenever this occurs (i.e.,
no spike)

-  Memory utilization appears normal

-  CNET bandwidth tests resolve to better than dedicated T1
performance (for what that's worth)

 

Any thoughts are greatly appreciated.

 

The interesting thing is, we have the same exact Remedy apps running on
the same exact type of server in the same exact environment in four
other locations, and those four other locations never experience any
problems.

 

Norm

 

Remedy ARS 6.3

Microsoft SQL 2000 SP4

Microsoft Windows 2000 SP2

100% Custom Apps - No ITSM

__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: Intermittent, Spotty ARS Performance (UNCLASSIFIED)

2008-11-24 Thread Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE
Yes, that's my suspicion.  I have a big suspicion that people are
searching the worklog diary field.

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Michaud, Christopher W Mr CTR
USA MEDCOM USAMITC
Sent: Monday, November 24, 2008 11:20 AM
To: arslist@ARSLIST.ORG
Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED)

Classification:  UNCLASSIFIED 
Caveats: NONE

Norm,

You may want to look closer at the SQL side. Look for locks. Perhaps
someone querying a diary or un-indexed field. Also, are you using SQL
replication? In particular, are snapshots turned on?


Christopher Michaud

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC
96 CS/SCCE
Sent: Monday, November 24, 2008 11:03 AM
To: arslist@ARSLIST.ORG
Subject: Intermittent, Spotty ARS Performance

** 

Hi everyone:

 

This problem has me perplexed.

 

At a site I support, the Remedy server inexplicably stops responding to
requests.  It's very intermittent.  It runs fine for awhile, then
seemingly without warning, it just hangs.  Users attempting to log on
get stuck at the Setting server port dialog, which eventually times
out.

 

Other users who are already logged who try to pull up a ticket get stuck
at a blank screen that never comes back.

 

To resolve the issue, they have to bounce the Remedy server service.
The system works for awhile...until it hangs up again.

 

Any ideas what might be causing this?

 

-  I have monitored CPU utilization when this occurs, and the
CPU hums along at about 3% - 5% utilization

-  Network utilization is flat-lined whenever this occurs (i.e.,
no spike)

-  Memory utilization appears normal

-  CNET bandwidth tests resolve to better than dedicated T1
performance (for what that's worth)

 

Any thoughts are greatly appreciated.

 

The interesting thing is, we have the same exact Remedy apps running on
the same exact type of server in the same exact environment in four
other locations, and those four other locations never experience any
problems.

 

Norm

 

Remedy ARS 6.3

Microsoft SQL 2000 SP4

Microsoft Windows 2000 SP2

100% Custom Apps - No ITSM

__Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
html___ 
Classification:  UNCLASSIFIED 
Caveats: NONE


___
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


Resolved: Java API Question

2008-11-24 Thread Phil Murnane
Thanks, everyone, for your suggestions.  I think I'll go with trapping the 
error off a getField() call.

Thanks Again,
--Phil



- Original Message 
From: LJ Longwing [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Monday, November 24, 2008 10:54:27 AM
Subject: Re: Java API Question

If you would like to get a list of existing Field ID's on a form you want to
look to your ARServerUser object and use the method getListField.  You would
want to use the form and the constant Constants.AR_FIELD_TYPE_ALL leaving
the 3rd parameter either non existent, or set it to 0 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Phil Murnane
Sent: Monday, November 24, 2008 10:12 AM
To: arslist@ARSLIST.ORG
Subject: Java API Question

I'm using the 7.1 Java API to create a new field on a form.  Be
All:

I'm using the 7.1 Java API to create a new field on a form.  Before creating
the field, I'd like to make sure a field with the same Field ID does not
already exist.  I found the isPresent() method of the Field object in the
javadocs, but since a generic Field cannot be instantiated (must use
CharacterField or IntegerField, etc), how do I use isPresent() to check for
any type existing field with a given Field ID?  Do I have to first check for
an AttachmentField, then check for an AttachmentPoolField, then check for a
CharacterField, etc?

Sorry if this is a dumb question -- I'm new at this OO programming stuff.

TIA,
--Phil


      


___
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: API to Create Remedy Objects

2008-11-24 Thread Phil Murnane
Frank:

In my case, I need to add the same set of fields to all non-audit regular 
forms, which would be rather tedious via the Admin Tool in a fully loaded ITSM7 
server. :)  I've also used Java API to add many forms to a single Filter or 
Active Link, to set Auditing up a certain way on many forms ( on many 
fields).  Basically it's handy whenever you want to do the same thing over  
over.

FWIW,
--Phil





From: Frank Caruso [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Monday, November 24, 2008 10:44:18 AM
Subject: API to Create Remedy Objects

** I've been wondering, based on an earlier post, why you would used the Remedy 
API to create Remedy objects such as forms, fields, alinks, etc?

Maybe some users could share me what they have built using the API in this 
manner.

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

SRM - Customize DVF in main window

2008-11-24 Thread Mauricio M.
Hello everyone,

Has anyone managed to manipulate the DVF that contains the main window
and service catalogue funcionality in BMC Remedy SRM? Anyone would be
so gentle to provide some guidance on where to find the java code in
order to hide or disable the ADD TO CART button?

DVF functionality is powerful but it leaves you in very bad shape if
you are not familiar with external programming languages, needless to
say it is kind of odd that one cannot easily customize the application
and it is an AR System based application, you expect to have direct
full control of objects and workflow via Remedy Administrator.

Thank you,
BR,
-Mauricio

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


Hornsby, Tambre L is out of the office.

2008-11-24 Thread Tambre L Hornsby/AC/VCU
I will be out of the office starting  11/24/2008 and will not return until
12/01/2008.

I will respond to your message when I return.  If this is an urgent matter
please call the Help Desk at 828-2227.

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


Re: Can’t resize form view SOLVED

2008-11-24 Thread Dwayne Martin
I was wrong.  It wasn't a hidden field.  But it was Display as Text which 
explains why I couldn't see it in the Admin tool

Dwayne Martin
James Madison University

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

When I read your letter my first reaction was, Come now, the User tool doesn't 
expand to display all the fields.  I have fields off to the right of the 
display on all my forms.

BUT it turns out that a Dialog window DOES expand to include all the fields (at 
least in the User tool, but apparently not in Mid-Tier).  I had a display-only, 
hidden character field with no label that I couldn't even see in the Admin 
tool.  I got rid of it, and now the views display normally.

Thank you too, David, for your suggestion.

Gratefully yours,
Dwayne



 Original message 
Date: Fri, 21 Nov 2008 15:28:14 -0600
From: Grooms, Frederick W [EMAIL PROTECTED]  
Subject: Re: Can’t resize form view  
To: arslist@ARSLIST.ORG

Are there any fields at the right edge of those specific views?  I seem to 
remember the User tool automatically expanding a view when there were fields 
to display.

Fred

-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Dwayne Martin
Sent: Friday, November 21, 2008 3:26 PM
To: arslist@ARSLIST.ORG
Subject: Can’t resize form view

Dear List,

We have a Display-Only, Standard form that we use for dialogs.   It has 
several views, most of which appear normally in the User tool.  But two of the 
views (one is a copy of the other) are elongated horizontally.  And no matter 
how often we re-size them in the Admin tool, they stay elongated in the User 
tool.  But they display properly in Mid-Tier.

After editing, we save our view before opening a new view, and when we close 
the form and re-display it, the views show their new size in the Admin tool, 
but not in the User tool.  

I cleared out the cache on my own computer, and displayed the views on a 
virgin computer that had never had Remedy installed on it before, but they 
still appear elongated.

What am I missing?

Dwayne Martin
James Madison University

(ARS, User and Admin tool 7.1 patch 3, RH Linux server, Oracle 10.2 db)

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


Re: API to Create Remedy Objects

2008-11-24 Thread Carey Matthew Black
And...

You can walk existing objects to make sure permissions, labels,
field DB names, help text match for a given field ID too.

For all the same reasons you would write any program... you might want
to automate, simplify, document, log, track, anything done to develop
your ARS applications.

I have even spent sometime on a program to move objects from an ARS
Development server to Production. You know, so I can get some sleep at
night. :) And not have to use the monster, or spend the money on that
thing they call Migrator.

-- 
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 Mon, Nov 24, 2008 at 1:10 PM, Phil Murnane [EMAIL PROTECTED] wrote:
 **
 Frank:

 In my case, I need to add the same set of fields to all non-audit regular
 forms, which would be rather tedious via the Admin Tool in a fully loaded
 ITSM7 server. :)  I've also used Java API to add many forms to a single
 Filter or Active Link, to set Auditing up a certain way on many forms ( on
 many fields).  Basically it's handy whenever you want to do the same thing
 over  over.

 FWIW,
 --Phil

 
 From: Frank Caruso [EMAIL PROTECTED]
 To: arslist@ARSLIST.ORG
 Sent: Monday, November 24, 2008 10:44:18 AM
 Subject: API to Create Remedy Objects

 ** I've been wondering, based on an earlier post, why you would used the
 Remedy API to create Remedy objects such as forms, fields, alinks, etc?

 Maybe some users could share me what they have built using the API in this
 manner.

 Thank you

 Frank

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


Re: SQL Reporing Services - making sense of Remedy Table structure

2008-11-24 Thread RFrench
Welcome to the joy of reporting from Remedy :-

There is database documentation, IMHO its as good as some m/soft
documentation l have found.  If anyone understands it please let me know!

Well done for using the tables, the OBDC link that is supplied is unless to
say the least, in particular for advance reporting esp enterprise reporting.

Some banana skins, to be aware of

Date fields are epoch dates e.g. number of seconds after 01/01/1970 00:00:00
this can be solved using TSQL functions.

On the forms you will see a pull down list, the values stored in the field,
are a numeric value.  However you can use a function, to look up the value. 

I have TSQL functions for the above done in SQL 2005 if you want.

Some of the look up values between the tables are not obvious to the say the
least, the HPD_Help_Desk form and the SLA form springs to mind. I do not
have the details to hand at the moment as I'm at home.  This is particular
ITSM, where a number of the relationships as based on GUID number's.  I'm
sure its in the system somewhere however l have not found it yet.  Nor does
there seem to be any central point of information, be that website or
document.

When a form is created, a corresponding view with the same name is created.
So you will find a view called HPD_Help_Desk, which corresponds to the form
of  the same name.

From what l can see of your reporting requirements, l agree with Matthew
Gayford.

My job is reporting, at the moment l report from 3 versions of Remedy.  As l
say to date whilst l have resolved a number of challenges, there are gaps in
my knowledge which l would like to plug.  We also looking to use SSRS as
some point future to provide report for our customers.

Regards
Robert French
-- 
View this message in context: 
http://www.nabble.com/SQL-Reporing-Services---making-sense-of-Remedy-Table-structure-tp20626113p20668739.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


Searching Diaries WAS: Intermittent, Spotty ARS Performance

2008-11-24 Thread Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE
OK, I'm pretty confident the problem was being caused by users
constantly searching the worklog diary field on a form with 200,000+
tickets.  I was able to reproduce the behavior multiple times by doing a
diary search myself.

So...that leads me to wonder, how do the rest of the ARSListers handle
diary searches?

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Michaud, Christopher W Mr CTR
USA MEDCOM USAMITC
Sent: Monday, November 24, 2008 11:20 AM
To: arslist@ARSLIST.ORG
Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED)

Classification:  UNCLASSIFIED 
Caveats: NONE

Norm,

You may want to look closer at the SQL side. Look for locks. Perhaps
someone querying a diary or un-indexed field. Also, are you using SQL
replication? In particular, are snapshots turned on?


Christopher Michaud

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC
96 CS/SCCE
Sent: Monday, November 24, 2008 11:03 AM
To: arslist@ARSLIST.ORG
Subject: Intermittent, Spotty ARS Performance

** 

Hi everyone:

 

This problem has me perplexed.

 

At a site I support, the Remedy server inexplicably stops responding to
requests.  It's very intermittent.  It runs fine for awhile, then
seemingly without warning, it just hangs.  Users attempting to log on
get stuck at the Setting server port dialog, which eventually times
out.

 

Other users who are already logged who try to pull up a ticket get stuck
at a blank screen that never comes back.

 

To resolve the issue, they have to bounce the Remedy server service.
The system works for awhile...until it hangs up again.

 

Any ideas what might be causing this?

 

-  I have monitored CPU utilization when this occurs, and the
CPU hums along at about 3% - 5% utilization

-  Network utilization is flat-lined whenever this occurs (i.e.,
no spike)

-  Memory utilization appears normal

-  CNET bandwidth tests resolve to better than dedicated T1
performance (for what that's worth)

 

Any thoughts are greatly appreciated.

 

The interesting thing is, we have the same exact Remedy apps running on
the same exact type of server in the same exact environment in four
other locations, and those four other locations never experience any
problems.

 

Norm

 

Remedy ARS 6.3

Microsoft SQL 2000 SP4

Microsoft Windows 2000 SP2

100% Custom Apps - No ITSM

__Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
html___ 
Classification:  UNCLASSIFIED 
Caveats: NONE


___
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: Very Urgent: Need to show formatted worklog in report

2008-11-24 Thread RFrench
Your question is not clear.

What view and field are you looking, what value do you see in the form, and
what value do you see in the table?

Are you going direct to the tables, or using the OBDC link?
-- 
View this message in context: 
http://www.nabble.com/Very-Urgent%3A-Need-to-show-formatted-worklog-in-report-tp20656123p20668759.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


Re: ARS for non Trouble Ticketing applications

2008-11-24 Thread Shoemaker, Gary
We have a custom application that tracks corrective actions.


Gary
505-284-1481

However beautiful the strategy, you should occasionally look at the results.

Sir Winston Churchill





From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Shellman, David
Sent: Monday, November 24, 2008 8:52 AM
To: arslist@ARSLIST.ORG
Subject: Re: ARS for non Trouble Ticketing applications

**
In addition to the Applications that Lisa noted, we also have a system that 
allocates Telecommunication charges to the appropriate departments.

If memory serves me correctly, a long time ago Kelly Deaver put together an 
application that could be used to track who was dating your teenager.

Dave

From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of sam appecherla
Sent: Friday, November 14, 2008 11:22 AM
To: arslist@ARSLIST.ORG
Subject: ARS for non Trouble Ticketing applications

** Hi List,

Just curious to know..

Apart from using Remedy for HelpDesk, Trouble Ticketing and the kinds, what 
else can we do with this workflow engine for? Does anyone have a custom built 
product/application built on ARS apart from Trouble Ticketing kinds that you 
would like to share?

Regards,
SriSamSri Appecherla
Mobile# +91 991 610 6008
__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: Searching Diaries WAS: Intermittent, Spotty ARS Performance

2008-11-24 Thread Rootuja Ghatge
We prevent our users from searching the work log on production server via an 
active link firing on search.
It's a given performance killer. They have to use the reporting server to 
search the work log.

HTH,
Rootuja

_
Rootuja Ghatge
Senior Application Developer

CenterBeam, Inc.
30 Rio Robles
San Jose, CA 95134
Direct  (408) 750-0718
Fax (408) 750-0559
http://www.centerbeam.com


This email may contain confidential and privileged material for the sole use of 
the intended recipient. Any review or distribution by others is strictly 
prohibited. If you are not the intended recipient please contact the sender and 
delete all copies.



-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE
Sent: Monday, November 24, 2008 12:19 PM
To: arslist@ARSLIST.ORG
Subject: Searching Diaries WAS: Intermittent, Spotty ARS Performance

OK, I'm pretty confident the problem was being caused by users
constantly searching the worklog diary field on a form with 200,000+
tickets.  I was able to reproduce the behavior multiple times by doing a
diary search myself.

So...that leads me to wonder, how do the rest of the ARSListers handle
diary searches?

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Michaud, Christopher W Mr CTR
USA MEDCOM USAMITC
Sent: Monday, November 24, 2008 11:20 AM
To: arslist@ARSLIST.ORG
Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED)

Classification:  UNCLASSIFIED
Caveats: NONE

Norm,

You may want to look closer at the SQL side. Look for locks. Perhaps
someone querying a diary or un-indexed field. Also, are you using SQL
replication? In particular, are snapshots turned on?


Christopher Michaud

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC
96 CS/SCCE
Sent: Monday, November 24, 2008 11:03 AM
To: arslist@ARSLIST.ORG
Subject: Intermittent, Spotty ARS Performance

**

Hi everyone:



This problem has me perplexed.



At a site I support, the Remedy server inexplicably stops responding to
requests.  It's very intermittent.  It runs fine for awhile, then
seemingly without warning, it just hangs.  Users attempting to log on
get stuck at the Setting server port dialog, which eventually times
out.



Other users who are already logged who try to pull up a ticket get stuck
at a blank screen that never comes back.



To resolve the issue, they have to bounce the Remedy server service.
The system works for awhile...until it hangs up again.



Any ideas what might be causing this?



-  I have monitored CPU utilization when this occurs, and the
CPU hums along at about 3% - 5% utilization

-  Network utilization is flat-lined whenever this occurs (i.e.,
no spike)

-  Memory utilization appears normal

-  CNET bandwidth tests resolve to better than dedicated T1
performance (for what that's worth)



Any thoughts are greatly appreciated.



The interesting thing is, we have the same exact Remedy apps running on
the same exact type of server in the same exact environment in four
other locations, and those four other locations never experience any
problems.



Norm



Remedy ARS 6.3

Microsoft SQL 2000 SP4

Microsoft Windows 2000 SP2

100% Custom Apps - No ITSM

__Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
html___
Classification:  UNCLASSIFIED
Caveats: NONE


___
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: Searching Diaries WAS: Intermittent, Spotty ARS Performance

2008-11-24 Thread Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE
How do you block searches done on the Advanced Query Bar?

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Rootuja Ghatge
Sent: Monday, November 24, 2008 2:35 PM
To: arslist@ARSLIST.ORG
Subject: Re: Searching Diaries WAS: Intermittent, Spotty ARS Performance

We prevent our users from searching the work log on production server
via an active link firing on search.
It's a given performance killer. They have to use the reporting server
to search the work log.

HTH,
Rootuja

_
Rootuja Ghatge
Senior Application Developer

CenterBeam, Inc.
30 Rio Robles
San Jose, CA 95134
Direct  (408) 750-0718
Fax (408) 750-0559
http://www.centerbeam.com


This email may contain confidential and privileged material for the sole
use of the intended recipient. Any review or distribution by others is
strictly prohibited. If you are not the intended recipient please
contact the sender and delete all copies.



-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC
96 CS/SCCE
Sent: Monday, November 24, 2008 12:19 PM
To: arslist@ARSLIST.ORG
Subject: Searching Diaries WAS: Intermittent, Spotty ARS Performance

OK, I'm pretty confident the problem was being caused by users
constantly searching the worklog diary field on a form with 200,000+
tickets.  I was able to reproduce the behavior multiple times by doing a
diary search myself.

So...that leads me to wonder, how do the rest of the ARSListers handle
diary searches?

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Michaud, Christopher W Mr CTR
USA MEDCOM USAMITC
Sent: Monday, November 24, 2008 11:20 AM
To: arslist@ARSLIST.ORG
Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED)

Classification:  UNCLASSIFIED
Caveats: NONE

Norm,

You may want to look closer at the SQL side. Look for locks. Perhaps
someone querying a diary or un-indexed field. Also, are you using SQL
replication? In particular, are snapshots turned on?


Christopher Michaud

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC
96 CS/SCCE
Sent: Monday, November 24, 2008 11:03 AM
To: arslist@ARSLIST.ORG
Subject: Intermittent, Spotty ARS Performance

**

Hi everyone:



This problem has me perplexed.



At a site I support, the Remedy server inexplicably stops responding to
requests.  It's very intermittent.  It runs fine for awhile, then
seemingly without warning, it just hangs.  Users attempting to log on
get stuck at the Setting server port dialog, which eventually times
out.



Other users who are already logged who try to pull up a ticket get stuck
at a blank screen that never comes back.



To resolve the issue, they have to bounce the Remedy server service.
The system works for awhile...until it hangs up again.



Any ideas what might be causing this?



-  I have monitored CPU utilization when this occurs, and the
CPU hums along at about 3% - 5% utilization

-  Network utilization is flat-lined whenever this occurs (i.e.,
no spike)

-  Memory utilization appears normal

-  CNET bandwidth tests resolve to better than dedicated T1
performance (for what that's worth)



Any thoughts are greatly appreciated.



The interesting thing is, we have the same exact Remedy apps running on
the same exact type of server in the same exact environment in four
other locations, and those four other locations never experience any
problems.



Norm



Remedy ARS 6.3

Microsoft SQL 2000 SP4

Microsoft Windows 2000 SP2

100% Custom Apps - No ITSM

__Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
html___
Classification:  UNCLASSIFIED
Caveats: NONE


___
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

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


Re: Searching Diaries WAS: Intermittent, Spotty ARS Performance

2008-11-24 Thread Gayford, Matthew C.
Just turn off the advanced search option from the Form - Current View -  
Properties - Menu Access menu.

-Matt

Matthew C. Gayford
Application Developer  Remedy Administrator
University of North Carolina Wilmington 
(910) 962-7177


-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE
Sent: Monday, November 24, 2008 3:39 PM
To: arslist@ARSLIST.ORG
Subject: Re: Searching Diaries WAS: Intermittent, Spotty ARS Performance

How do you block searches done on the Advanced Query Bar?

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Rootuja Ghatge
Sent: Monday, November 24, 2008 2:35 PM
To: arslist@ARSLIST.ORG
Subject: Re: Searching Diaries WAS: Intermittent, Spotty ARS Performance

We prevent our users from searching the work log on production server
via an active link firing on search.
It's a given performance killer. They have to use the reporting server
to search the work log.

HTH,
Rootuja

_
Rootuja Ghatge
Senior Application Developer

CenterBeam, Inc.
30 Rio Robles
San Jose, CA 95134
Direct  (408) 750-0718
Fax (408) 750-0559
http://www.centerbeam.com


This email may contain confidential and privileged material for the sole
use of the intended recipient. Any review or distribution by others is
strictly prohibited. If you are not the intended recipient please
contact the sender and delete all copies.



-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC
96 CS/SCCE
Sent: Monday, November 24, 2008 12:19 PM
To: arslist@ARSLIST.ORG
Subject: Searching Diaries WAS: Intermittent, Spotty ARS Performance

OK, I'm pretty confident the problem was being caused by users
constantly searching the worklog diary field on a form with 200,000+
tickets.  I was able to reproduce the behavior multiple times by doing a
diary search myself.

So...that leads me to wonder, how do the rest of the ARSListers handle
diary searches?

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Michaud, Christopher W Mr CTR
USA MEDCOM USAMITC
Sent: Monday, November 24, 2008 11:20 AM
To: arslist@ARSLIST.ORG
Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED)

Classification:  UNCLASSIFIED
Caveats: NONE

Norm,

You may want to look closer at the SQL side. Look for locks. Perhaps
someone querying a diary or un-indexed field. Also, are you using SQL
replication? In particular, are snapshots turned on?


Christopher Michaud

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC
96 CS/SCCE
Sent: Monday, November 24, 2008 11:03 AM
To: arslist@ARSLIST.ORG
Subject: Intermittent, Spotty ARS Performance

**

Hi everyone:



This problem has me perplexed.



At a site I support, the Remedy server inexplicably stops responding to
requests.  It's very intermittent.  It runs fine for awhile, then
seemingly without warning, it just hangs.  Users attempting to log on
get stuck at the Setting server port dialog, which eventually times
out.



Other users who are already logged who try to pull up a ticket get stuck
at a blank screen that never comes back.



To resolve the issue, they have to bounce the Remedy server service.
The system works for awhile...until it hangs up again.



Any ideas what might be causing this?



-  I have monitored CPU utilization when this occurs, and the
CPU hums along at about 3% - 5% utilization

-  Network utilization is flat-lined whenever this occurs (i.e.,
no spike)

-  Memory utilization appears normal

-  CNET bandwidth tests resolve to better than dedicated T1
performance (for what that's worth)



Any thoughts are greatly appreciated.



The interesting thing is, we have the same exact Remedy apps running on
the same exact type of server in the same exact environment in four
other locations, and those four other locations never experience any
problems.



Norm



Remedy ARS 6.3

Microsoft SQL 2000 SP4

Microsoft Windows 2000 SP2

100% Custom Apps - No ITSM

__Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
html___
Classification:  UNCLASSIFIED
Caveats: NONE


___
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: Searching Diaries WAS: Intermittent, Spotty ARS Performance

2008-11-24 Thread Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE
No...can't do that.  Thanks for the suggestion, but that won't work.

Users still need to construct advanced searches.  I just need to block
them from skirting my AL that blocks them from searching the worklog.

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Gayford, Matthew C.
Sent: Monday, November 24, 2008 2:47 PM
To: arslist@ARSLIST.ORG
Subject: Re: Searching Diaries WAS: Intermittent, Spotty ARS Performance

Just turn off the advanced search option from the Form - Current View -
 Properties - Menu Access menu.

-Matt

Matthew C. Gayford
Application Developer  Remedy Administrator
University of North Carolina Wilmington 
(910) 962-7177


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC
96 CS/SCCE
Sent: Monday, November 24, 2008 3:39 PM
To: arslist@ARSLIST.ORG
Subject: Re: Searching Diaries WAS: Intermittent, Spotty ARS Performance

How do you block searches done on the Advanced Query Bar?

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Rootuja Ghatge
Sent: Monday, November 24, 2008 2:35 PM
To: arslist@ARSLIST.ORG
Subject: Re: Searching Diaries WAS: Intermittent, Spotty ARS Performance

We prevent our users from searching the work log on production server
via an active link firing on search.
It's a given performance killer. They have to use the reporting server
to search the work log.

HTH,
Rootuja

_
Rootuja Ghatge
Senior Application Developer

CenterBeam, Inc.
30 Rio Robles
San Jose, CA 95134
Direct  (408) 750-0718
Fax (408) 750-0559
http://www.centerbeam.com


This email may contain confidential and privileged material for the sole
use of the intended recipient. Any review or distribution by others is
strictly prohibited. If you are not the intended recipient please
contact the sender and delete all copies.



-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC
96 CS/SCCE
Sent: Monday, November 24, 2008 12:19 PM
To: arslist@ARSLIST.ORG
Subject: Searching Diaries WAS: Intermittent, Spotty ARS Performance

OK, I'm pretty confident the problem was being caused by users
constantly searching the worklog diary field on a form with 200,000+
tickets.  I was able to reproduce the behavior multiple times by doing a
diary search myself.

So...that leads me to wonder, how do the rest of the ARSListers handle
diary searches?

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Michaud, Christopher W Mr CTR
USA MEDCOM USAMITC
Sent: Monday, November 24, 2008 11:20 AM
To: arslist@ARSLIST.ORG
Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED)

Classification:  UNCLASSIFIED
Caveats: NONE

Norm,

You may want to look closer at the SQL side. Look for locks. Perhaps
someone querying a diary or un-indexed field. Also, are you using SQL
replication? In particular, are snapshots turned on?


Christopher Michaud

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC
96 CS/SCCE
Sent: Monday, November 24, 2008 11:03 AM
To: arslist@ARSLIST.ORG
Subject: Intermittent, Spotty ARS Performance

**

Hi everyone:



This problem has me perplexed.



At a site I support, the Remedy server inexplicably stops responding to
requests.  It's very intermittent.  It runs fine for awhile, then
seemingly without warning, it just hangs.  Users attempting to log on
get stuck at the Setting server port dialog, which eventually times
out.



Other users who are already logged who try to pull up a ticket get stuck
at a blank screen that never comes back.



To resolve the issue, they have to bounce the Remedy server service.
The system works for awhile...until it hangs up again.



Any ideas what might be causing this?



-  I have monitored CPU utilization when this occurs, and the
CPU hums along at about 3% - 5% utilization

-  Network utilization is flat-lined whenever this occurs (i.e.,
no spike)

-  Memory utilization appears normal

-  CNET bandwidth tests resolve to better than dedicated T1
performance (for what that's worth)



Any thoughts are greatly appreciated.



The interesting thing is, we have the same exact Remedy apps running on
the same exact type of server in the same exact environment in four
other locations, and those four other locations never experience any
problems.



Norm



Remedy ARS 6.3

Microsoft SQL 2000 SP4

Microsoft Windows 2000 SP2

100% Custom Apps - No ITSM

__Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
html___
Classification:  UNCLASSIFIED
Caveats: NONE


Re: Searching Diaries WAS: Intermittent, Spotty ARS Performance

2008-11-24 Thread Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE
Well, thanks to Gary Opela (who contacted me privately), I figured it
out.  I just had to search the Form Action Field Search Bar for
%Worklog%.

That did the trick!

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Gayford, Matthew C.
Sent: Monday, November 24, 2008 2:47 PM
To: arslist@ARSLIST.ORG
Subject: Re: Searching Diaries WAS: Intermittent, Spotty ARS Performance

Just turn off the advanced search option from the Form - Current View -
 Properties - Menu Access menu.

-Matt

Matthew C. Gayford
Application Developer  Remedy Administrator
University of North Carolina Wilmington 
(910) 962-7177


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC
96 CS/SCCE
Sent: Monday, November 24, 2008 3:39 PM
To: arslist@ARSLIST.ORG
Subject: Re: Searching Diaries WAS: Intermittent, Spotty ARS Performance

How do you block searches done on the Advanced Query Bar?

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Rootuja Ghatge
Sent: Monday, November 24, 2008 2:35 PM
To: arslist@ARSLIST.ORG
Subject: Re: Searching Diaries WAS: Intermittent, Spotty ARS Performance

We prevent our users from searching the work log on production server
via an active link firing on search.
It's a given performance killer. They have to use the reporting server
to search the work log.

HTH,
Rootuja

_
Rootuja Ghatge
Senior Application Developer

CenterBeam, Inc.
30 Rio Robles
San Jose, CA 95134
Direct  (408) 750-0718
Fax (408) 750-0559
http://www.centerbeam.com


This email may contain confidential and privileged material for the sole
use of the intended recipient. Any review or distribution by others is
strictly prohibited. If you are not the intended recipient please
contact the sender and delete all copies.



-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC
96 CS/SCCE
Sent: Monday, November 24, 2008 12:19 PM
To: arslist@ARSLIST.ORG
Subject: Searching Diaries WAS: Intermittent, Spotty ARS Performance

OK, I'm pretty confident the problem was being caused by users
constantly searching the worklog diary field on a form with 200,000+
tickets.  I was able to reproduce the behavior multiple times by doing a
diary search myself.

So...that leads me to wonder, how do the rest of the ARSListers handle
diary searches?

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Michaud, Christopher W Mr CTR
USA MEDCOM USAMITC
Sent: Monday, November 24, 2008 11:20 AM
To: arslist@ARSLIST.ORG
Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED)

Classification:  UNCLASSIFIED
Caveats: NONE

Norm,

You may want to look closer at the SQL side. Look for locks. Perhaps
someone querying a diary or un-indexed field. Also, are you using SQL
replication? In particular, are snapshots turned on?


Christopher Michaud

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC
96 CS/SCCE
Sent: Monday, November 24, 2008 11:03 AM
To: arslist@ARSLIST.ORG
Subject: Intermittent, Spotty ARS Performance

**

Hi everyone:



This problem has me perplexed.



At a site I support, the Remedy server inexplicably stops responding to
requests.  It's very intermittent.  It runs fine for awhile, then
seemingly without warning, it just hangs.  Users attempting to log on
get stuck at the Setting server port dialog, which eventually times
out.



Other users who are already logged who try to pull up a ticket get stuck
at a blank screen that never comes back.



To resolve the issue, they have to bounce the Remedy server service.
The system works for awhile...until it hangs up again.



Any ideas what might be causing this?



-  I have monitored CPU utilization when this occurs, and the
CPU hums along at about 3% - 5% utilization

-  Network utilization is flat-lined whenever this occurs (i.e.,
no spike)

-  Memory utilization appears normal

-  CNET bandwidth tests resolve to better than dedicated T1
performance (for what that's worth)



Any thoughts are greatly appreciated.



The interesting thing is, we have the same exact Remedy apps running on
the same exact type of server in the same exact environment in four
other locations, and those four other locations never experience any
problems.



Norm



Remedy ARS 6.3

Microsoft SQL 2000 SP4

Microsoft Windows 2000 SP2

100% Custom Apps - No ITSM

__Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
html___
Classification:  UNCLASSIFIED
Caveats: NONE


Re: Searching Diaries WAS: Intermittent, Spotty ARS Performance (UNCLASSIFIED)

2008-11-24 Thread Michaud, Christopher W Mr CTR USA MEDCOM USAMITC
Classification:  UNCLASSIFIED 
Caveats: NONE

Norm,

To prevent certain Advanced Query searches, you can drop the Reserved
Field (1005) on the form and use and AL to inspect the value (On
Search). Throw an error if the value contains the diary field name
('DIARYNAME'). This will allow you to exclude certain fields from being
used and even prevent use of LIKE statements.


Christopher Michaud
Remedy System Administrator/Developer
US Army Medical Information Technology Center (USAMITC)
Core Technology Division - Systems Engineering Branch
Office:  210.295.3589
DSN:  421-3589
 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC
96 CS/SCCE
Sent: Monday, November 24, 2008 2:49 PM
To: arslist@ARSLIST.ORG
Subject: Re: Searching Diaries WAS: Intermittent, Spotty ARS Performance

No...can't do that.  Thanks for the suggestion, but that won't work.

Users still need to construct advanced searches.  I just need to block
them from skirting my AL that blocks them from searching the worklog.

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Gayford, Matthew C.
Sent: Monday, November 24, 2008 2:47 PM
To: arslist@ARSLIST.ORG
Subject: Re: Searching Diaries WAS: Intermittent, Spotty ARS Performance

Just turn off the advanced search option from the Form - Current View -
 Properties - Menu Access menu.

-Matt

Matthew C. Gayford
Application Developer  Remedy Administrator
University of North Carolina Wilmington 
(910) 962-7177


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC
96 CS/SCCE
Sent: Monday, November 24, 2008 3:39 PM
To: arslist@ARSLIST.ORG
Subject: Re: Searching Diaries WAS: Intermittent, Spotty ARS Performance

How do you block searches done on the Advanced Query Bar?

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Rootuja Ghatge
Sent: Monday, November 24, 2008 2:35 PM
To: arslist@ARSLIST.ORG
Subject: Re: Searching Diaries WAS: Intermittent, Spotty ARS Performance

We prevent our users from searching the work log on production server
via an active link firing on search.
It's a given performance killer. They have to use the reporting server
to search the work log.

HTH,
Rootuja

_
Rootuja Ghatge
Senior Application Developer

CenterBeam, Inc.
30 Rio Robles
San Jose, CA 95134
Direct  (408) 750-0718
Fax (408) 750-0559
http://www.centerbeam.com


This email may contain confidential and privileged material for the sole
use of the intended recipient. Any review or distribution by others is
strictly prohibited. If you are not the intended recipient please
contact the sender and delete all copies.



-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC
96 CS/SCCE
Sent: Monday, November 24, 2008 12:19 PM
To: arslist@ARSLIST.ORG
Subject: Searching Diaries WAS: Intermittent, Spotty ARS Performance

OK, I'm pretty confident the problem was being caused by users
constantly searching the worklog diary field on a form with 200,000+
tickets.  I was able to reproduce the behavior multiple times by doing a
diary search myself.

So...that leads me to wonder, how do the rest of the ARSListers handle
diary searches?

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Michaud, Christopher W Mr CTR
USA MEDCOM USAMITC
Sent: Monday, November 24, 2008 11:20 AM
To: arslist@ARSLIST.ORG
Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED)

Classification:  UNCLASSIFIED
Caveats: NONE

Norm,

You may want to look closer at the SQL side. Look for locks. Perhaps
someone querying a diary or un-indexed field. Also, are you using SQL
replication? In particular, are snapshots turned on?


Christopher Michaud

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC
96 CS/SCCE
Sent: Monday, November 24, 2008 11:03 AM
To: arslist@ARSLIST.ORG
Subject: Intermittent, Spotty ARS Performance

**

Hi everyone:



This problem has me perplexed.



At a site I support, the Remedy server inexplicably stops responding to
requests.  It's very intermittent.  It runs fine for awhile, then
seemingly without warning, it just hangs.  Users attempting to log on
get stuck at the Setting server port dialog, which eventually times
out.



Other users who are already logged who try to pull up a ticket get stuck
at a blank screen that never comes back.



To resolve the issue, they have to bounce the Remedy server service.
The system works for awhile...until it hangs up again.



Any ideas 

Re: SQL Reporing Services - making sense of Remedy Table structure

2008-11-24 Thread LJ Longwing
One slight correction, Date/Time fields are Unix epoch of 1/1/1970.  Date
fields have a different epoch 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of RFrench
Sent: Monday, November 24, 2008 1:08 PM
To: arslist@ARSLIST.ORG
Subject: Re: SQL Reporing Services - making sense of Remedy Table structure

Welcome to the joy of reporting from Remedy :-

There is database documentation, IMHO its as good as some m/soft
documentation l have found.  If anyone understands it please let me know!

Well done for using the tables, the OBDC link that is supplied is unless to
say the least, in particular for advance reporting esp enterprise reporting.

Some banana skins, to be aware of

Date fields are epoch dates e.g. number of seconds after 01/01/1970 00:00:00
this can be solved using TSQL functions.

On the forms you will see a pull down list, the values stored in the field,
are a numeric value.  However you can use a function, to look up the value. 

I have TSQL functions for the above done in SQL 2005 if you want.

Some of the look up values between the tables are not obvious to the say the
least, the HPD_Help_Desk form and the SLA form springs to mind. I do not
have the details to hand at the moment as I'm at home.  This is particular
ITSM, where a number of the relationships as based on GUID number's.  I'm
sure its in the system somewhere however l have not found it yet.  Nor does
there seem to be any central point of information, be that website or
document.

When a form is created, a corresponding view with the same name is created.
So you will find a view called HPD_Help_Desk, which corresponds to the form
of  the same name.

From what l can see of your reporting requirements, l agree with Matthew
Gayford.

My job is reporting, at the moment l report from 3 versions of Remedy.  As l
say to date whilst l have resolved a number of challenges, there are gaps in
my knowledge which l would like to plug.  We also looking to use SSRS as
some point future to provide report for our customers.

Regards
Robert French
--
View this message in context:
http://www.nabble.com/SQL-Reporing-Services---making-sense-of-Remedy-Table-s
tructure-tp20626113p20668739.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

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


Is anyone running archiving in 7.x yet?

2008-11-24 Thread Meyer, Jennifer L
Listers,

We're running AR System 7.0.1 patch 5 with ITSM patch 7 and are planning to 
start archiving old records in HPD:Help Desk.  What effect is that going to 
have on all those records we have in HPD:WorkLog?

Will the archived incidents pull up work logs from the original Work Log 
entries, or will we need to create new workflow to access them?

Is 7.x smart enough to know if we archive HPD:Worklog and link archived 
incidents records to archived worklogs?

Do we just need to try this for ourselves and see what happens?

Thanks in advance for your input,

Jennifer Meyer
919-754-6543
[EMAIL PROTECTED]
http://its.state.nc.us

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


AIE Import Stops at 130000 Records

2008-11-24 Thread Peter Romain
Hi All,

I am testing the BMC Config Management integration to CMDB via AIE and am
running into an issue with the application and patch exchanges.

CM has ~60 applications but after importing ~13 the creation of
new CMDB CIs stops. The logs show that AIE is still attempting to create
CIs but that these fail because the CMDB Name field is being set to null.

The application exchange is running in its own AIE instance and has 12
threads allocated.

Could I be hitting a fundamental AIE process memory limit on Windows?

Has anyone else seen this issue?

Cheers

Peter
ARS 7.01 Patch 3
CMDB 2.01 Patch 7
AIE 7.1 Patch 4
Windows 2003 Server
SQLServer 2005

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


Re: SQL Reporing Services - making sense of Remedy Table structure

2008-11-24 Thread RFrench
Curious what is it then ?
-- 
View this message in context: 
http://www.nabble.com/SQL-Reporing-Services---making-sense-of-Remedy-Table-structure-tp20626113p20670813.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


Re: SQL Reporing Services - making sense of Remedy Table structure

2008-11-24 Thread Meyer, Jennifer L
January 1, 4713, BC.

Jennifer Meyer


-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of RFrench
Sent: Monday, November 24, 2008 5:03 PM
To: arslist@ARSLIST.ORG
Subject: Re: SQL Reporing Services - making sense of Remedy Table structure

Curious what is it then ?
--
View this message in context: 
http://www.nabble.com/SQL-Reporing-Services---making-sense-of-Remedy-Table-structure-tp20626113p20670813.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

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


DSL Data Update Rant

2008-11-24 Thread Peter Romain
Hi,

rant
I thought DSL stood for Definitive Software Library.

Why, then, when I update to DSL patch 9 from patch 8 do I get errors
because some manufacturer names have changed and more errors because some
software product names have changed?

It seems that 'definitive' means 'definitive until we change it' to the
DSL data suppliers.

Also, why, when I take the time to update the Tier 1-3 values in the DSL
does an update then put them back to the meaningless
software/application/third party value?

The DSL doesn't impress me much!

\rant

Cheers

Peter

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


Re: Searching Diaries WAS: Intermittent, Spotty ARS Performance

2008-11-24 Thread Stroud, Natalie K
Norm:

You'll have to pardon me because I'm not an actual Remedy developer, but I do 
work with our Remedy system every day as a tester, so while I can't give you an 
answer in nice Remedy developerese (and I may in fact say something completely 
nonsensical), I hope I can make enough sense for you to understand what I mean. 

I realize you've gotten an answer for your immediate question of excluding the 
Diary field from the Advanced Search Bar, but if you still want to know how we 
handle diary searches, we have separate forms on the same server for querying 
ticket data.  There are some queries our users can't currently run and would 
like to (such as how many tickets exist in the system for asset XYZ) and some 
fields that are difficult to extract data from on our existing form (of which 
Worklog is one) and so we send the Worklog entries to a separate diary field 
(I'm not 100% certain if that's the right control type, but I think it is) 
called Worklog for Reporting (WL4R) each time the Worklog gets updated.  Then 
we let folks query the WL4R via this other form when they want to run a search 
or create a report, and we also limit who can access the searchable/queryable 
form to people with some sort of leadership role on a team, such as a Tech 
Lead, Team Lead, or Ops Lead. 

We have a new form in the works that references data by its SQL name that will 
allow some very cool data to be extracted compared to what our users can 
currently get (such as the previously mentioned how many tickets exist in the 
system for asset XYZ) but we haven't pushed that to Production yet.

So, if your users start screaming now that you've nixed their ability to search 
the Worklog and you're of a mind to figure out an alternate way to let them do 
that, that's how we do it.  And speaking as a former tech in the field and user 
of our Remedy system, I can vouch that when I saw a problem I knew I'd seen 
before but had forgotten which customer had it or when I worked on it, my first 
thought was something along the lines of, Gee, this is that goofy Outlook 
problem involving recurring appointments...now how did I resolve that last 
time? And if guys like you give the average tech in the field the ability to 
search the place they entered the detail about the problem and its solution for 
a term like recurring appointment and get a hit that lets them quickly and 
easily get back to the end user with a solution, that makes the tech a hero in 
the end user's eyes and you a hero in the tech's.  So everybody wins.   

For whatever that's worth... ;]


Natalie Stroud 
Remedy/ESS Tester 
Science Applications International Corporation (SAIC), 
  contractor to Sandia National Labs 
Albuquerque, NM 
(505)844-7983 
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 
Remedy 7.1 Patch 003
SQL ???
Windows Server 2003

-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE
Sent: Monday, November 24, 2008 1:19 PM
To: arslist@ARSLIST.ORG
Subject: Searching Diaries WAS: Intermittent, Spotty ARS Performance

OK, I'm pretty confident the problem was being caused by users constantly 
searching the worklog diary field on a form with 200,000+ tickets.  I was able 
to reproduce the behavior multiple times by doing a diary search myself.

So...that leads me to wonder, how do the rest of the ARSListers handle diary 
searches?

-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Michaud, Christopher W Mr CTR USA MEDCOM USAMITC
Sent: Monday, November 24, 2008 11:20 AM
To: arslist@ARSLIST.ORG
Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED)

Classification:  UNCLASSIFIED
Caveats: NONE

Norm,

You may want to look closer at the SQL side. Look for locks. Perhaps someone 
querying a diary or un-indexed field. Also, are you using SQL replication? In 
particular, are snapshots turned on?


Christopher Michaud

-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Kaiser, Norm E CIV USAF AFMC
96 CS/SCCE
Sent: Monday, November 24, 2008 11:03 AM
To: arslist@ARSLIST.ORG
Subject: Intermittent, Spotty ARS Performance

** 

Hi everyone:

 

This problem has me perplexed.

 

At a site I support, the Remedy server inexplicably stops responding to 
requests.  It's very intermittent.  It runs fine for awhile, then seemingly 
without warning, it just hangs.  Users attempting to log on get stuck at the 
Setting server port dialog, which eventually times out.

 

Other users who are already logged who try to pull up a ticket get stuck at a 
blank screen that never comes back.

 

To resolve the issue, they have to bounce the Remedy server service.
The system works for awhile...until it hangs up again.

 

Any ideas what might be causing this?

 

-  I have monitored CPU utilization when this occurs, and the
CPU 

Remedy 4.0 or 4.5

2008-11-24 Thread Veanna Carr
Hi Everyone,
 
Does anyone know where I can get the files for v4.0 or v4.5?
 
I especially need the cleint tools - licensing tool.  We need to move a legacy 
system to a new location.
 
ARListening




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

libumem - performance increase on Solaris with ITSM 7.X

2008-11-24 Thread Terry Bootsma
Hello arslist:

We have been utilizing ARS 7.1 Patch 004 with ITSM 7.0.2 (latest patch for
Incident, Change, Config, and Problem) on a multi-CPU, high end Solaris box
running DB2.  We have had SIGNIFICANT performance issues under high load
running this configuration as a result of our load testing exercise.

However, after meeting with Remedy engineers yesterday, they suggested that
we replace the standard Solaris memory manager with a preloaded libumem
memory manager.  This has produced astonishing results and has resolved our
issue of performance under high load with the fact that libumem uses a
different memory allocation model that is more condusive to multi-cpu,
multi-threaded applications.

My question to the list is this.  Have any of you replaced your memory
manager in production with libumem and , if so, were there any side
affects of doing so?

Thanks for any feedback Terry

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


Re: SQL Reporing Services - making sense of Remedy Table structure

2008-11-24 Thread RFrench
Thanks for that, for me personally speaking it raises another issue where
%*% is all this information.  I have only been in my role for about 8
months, l have reached the conculsion that l am missing something.  There is
obviously plenty of information and experience regarding the backend
database, and some other issue, but finding it is another issue althogher. 
My experience so far, is find one bit of information here then another bit
somewhere else, yet very little is documented, in any meaning form.

Sorry for the rant Remedy is an excellent product however even in my short
experience there are things missing.  Not least of all documenation.  Guess
now l have managed to start posting l might be asking some more questions =)
-- 
View this message in context: 
http://www.nabble.com/SQL-Reporing-Services---making-sense-of-Remedy-Table-structure-tp20626113p20672036.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


Re: AIE Import Stops at 130000 Records

2008-11-24 Thread Janie
Peter,

One AIE instance can use up to 2GB of memory -- if it exceeds that, it will
crash.

Each active Data mapping used on a single AIE instance splits the 2GB
evenly.  So 2 data mappings on 1 instance will allow each data mapping 1GB
when it runs.

In each data mapping, one key field mapping uses 1.2kb times the number of
records in your AR target form.  Obviously, additional keys will increase
the memory used.



Is there legitimate data in the source that contains the 'Name' field -- any
possibility it's Null and thus returning Null?

Generally, I've found that if there is a process memory limit, AIE will
crash and the process will no longer be running... At all.  If AIE is
running and the exchange is pulling data, I've found that the source data is
usually the culprit when there is a problem -- especially when the majority
of items are coming through correctly.

HTH,
Janie



-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Peter Romain
Sent: Monday, November 24, 2008 2:01 PM
To: arslist@ARSLIST.ORG
Subject: AIE Import Stops at 13 Records

Hi All,

I am testing the BMC Config Management integration to CMDB via AIE and am
running into an issue with the application and patch exchanges.

CM has ~60 applications but after importing ~13 the creation of new
CMDB CIs stops. The logs show that AIE is still attempting to create CIs but
that these fail because the CMDB Name field is being set to null.

The application exchange is running in its own AIE instance and has 12
threads allocated.

Could I be hitting a fundamental AIE process memory limit on Windows?

Has anyone else seen this issue?

Cheers

Peter
ARS 7.01 Patch 3
CMDB 2.01 Patch 7
AIE 7.1 Patch 4
Windows 2003 Server
SQLServer 2005


___
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: Remedy 4.0 or 4.5

2008-11-24 Thread Joe DeSouza
Veanna,

These are old versions - more than 3 major versions old, so will no longer be 
available for download from the Remedy website. Remedy support, supports upto 3 
major releases so currently will support only upto 6.0 and in a few months upto 
6.3 after 7.5 is released.

Your best chances are trying to source them from your old backups of software. 
I think I have those two versions at home but am at home away from home at the 
moment in Connecticut and wont return to New Jersey where I currently reside 
till Thursday. If you can wait that long, I can look them up for you. I have 
the files necesasry for windows. Not sure if I have unix installers backed up 
to CD.

Joe




From: Veanna Carr [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Monday, November 24, 2008 6:06:52 PM
Subject: Remedy 4.0 or 4.5

** 
Hi Everyone,

Does anyone know where I can get the files for v4.0 or v4.5?

I especially need the cleint tools - licensing tool.  We need to move a legacy 
system to a new location.

ARListening 




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

Re: AIE Import Stops at 130000 Records

2008-11-24 Thread Joe DeSouza
Peter,

I highly doubt that.

With my experience with AIE, this often happens when your import options on AIE 
are not correctly set.

Could you take a snapshot of your import options (I forget the exact name of 
that tab) and send them across? I'll review them later this evening when time 
permits and let you know if I spot something.

Joe




From: Peter Romain [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Monday, November 24, 2008 5:01:11 PM
Subject: AIE Import Stops at 13 Records

Hi All,

I am testing the BMC Config Management integration to CMDB via AIE and am 
running into an issue with the application and patch exchanges.

CM has ~60 applications but after importing ~13 the creation of new 
CMDB CIs stops. The logs show that AIE is still attempting to create CIs but 
that these fail because the CMDB Name field is being set to null.

The application exchange is running in its own AIE instance and has 12 threads 
allocated.

Could I be hitting a fundamental AIE process memory limit on Windows?

Has anyone else seen this issue?

Cheers

Peter
ARS 7.01 Patch 3
CMDB 2.01 Patch 7
AIE 7.1 Patch 4
Windows 2003 Server
SQLServer 2005




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

Re: DSL Data Update Rant

2008-11-24 Thread Joe DeSouza
On the very early release of DSL, there were bugs that needed to be fixed 
manually (delete a record) before applying a patch.. Did you do that?

Joe





From: Peter Romain [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Monday, November 24, 2008 5:13:39 PM
Subject: DSL Data Update Rant

Hi,

rant
I thought DSL stood for Definitive Software Library.

Why, then, when I update to DSL patch 9 from patch 8 do I get errors because 
some manufacturer names have changed and more errors because some software 
product names have changed?

It seems that 'definitive' means 'definitive until we change it' to the DSL 
data suppliers.

Also, why, when I take the time to update the Tier 1-3 values in the DSL does 
an update then put them back to the meaningless software/application/third 
party value?

The DSL doesn't impress me much!

\rant

Cheers

Peter




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

Re: libumem - performance increase on Solaris with ITSM 7.X

2008-11-24 Thread Chintan Shah
Hi Terry,

We have libumem on our production system(all custom remedy apps..no ITSM)..but 
here's the deal..if you dont specify the Number of results returnedthere is 
possibility that arserverd will crash. We have tested this on couple of 
different machines with same configurations. However, if you set Number of 
records returned to 3000, it works fine.

We had an escalation scanning 40 million records that crashed arserverd in 
less than 4 minutes even though we were on libumem. Although it was bad code, 
instead of throwing any errors, it just crashed.

Another issue was with form which had 2 million records and  Results List had 
more than 15 fields. This also crashed server on Search.

We are on Solaris 5.10. 

Try the above scenarios. It might also be related to Hardware and all those 
fuzzy CPU utilization..but I am not sure..all I saw from remedy side was that 
it got crashed.

Thanks
Chintan.

--- On Mon, 11/24/08, Terry Bootsma [EMAIL PROTECTED] wrote:
From: Terry Bootsma [EMAIL PROTECTED]
Subject: libumem - performance increase on Solaris with ITSM 7.X
To: arslist@ARSLIST.ORG
Date: Monday, November 24, 2008, 3:08 PM

Hello arslist:

We have been utilizing ARS 7.1 Patch 004 with ITSM 7.0.2 (latest patch for
Incident, Change, Config, and Problem) on a multi-CPU, high end Solaris box
running DB2.  We have had SIGNIFICANT performance issues under high load
running this configuration as a result of our load testing exercise.

However, after meeting with Remedy engineers yesterday, they suggested that
we replace the standard Solaris memory manager with a preloaded
libumem
memory manager.  This has produced astonishing results and has resolved our
issue of performance under high load with the fact that libumem uses a
different memory allocation model that is more condusive to multi-cpu,
multi-threaded applications.

My question to the list is this.  Have any of you replaced your memory
manager in production with libumem and , if so, were there any side
affects of doing so?

Thanks for any feedback Terry

___
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: Remedy 4.0 or 4.5

2008-11-24 Thread Veanna Carr
Hi Joe,
 
Thanks for responding.  We have the ARSystem install, but not the client tools 
install.  We need the licensing tool, or the knowledge of how it was done back 
then.  BMC has been helpful and gave us a 5.1 licensing tool, it's supposed to 
be compatible, but we're getting an ARERR 91 RPC procedure unavailable.  Which 
makes me think it's a different way of licensing.  
 
We can wait until Thursday.  I have the new machine installed and we're testing 
it.  We had planned to move it tomorrow, but we'll wait until Monday.  
 
Veanna

--- On Mon, 11/24/08, Joe DeSouza [EMAIL PROTECTED] wrote:

From: Joe DeSouza [EMAIL PROTECTED]
Subject: Re: Remedy 4.0 or 4.5
To: arslist@ARSLIST.ORG
Date: Monday, November 24, 2008, 5:33 PM


** 




Veanna,
 
These are old versions - more than 3 major versions old, so will no longer be 
available for download from the Remedy website. Remedy support, supports upto 3 
major releases so currently will support only upto 6.0 and in a few months upto 
6.3 after 7.5 is released.
 
Your best chances are trying to source them from your old backups of software. 
I think I have those two versions at home but am at home away from home at the 
moment in Connecticut and wont return to New Jersey where I currently reside 
till Thursday. If you can wait that long, I can look them up for you. I have 
the files necesasry for windows. Not sure if I have unix installers backed up 
to CD.
 
Joe




From: Veanna Carr [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Monday, November 24, 2008 6:06:52 PM
Subject: Remedy 4.0 or 4.5

** 




Hi Everyone,
 
Does anyone know where I can get the files for v4.0 or v4.5?
 
I especially need the cleint tools - licensing tool.  We need to move a legacy 
system to a new location.
 
ARListening
__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 4.0 or 4.5

2008-11-24 Thread Roger Justice
The licensing tool was changed in 5 since it became part of the admin tool. 


-Original Message-
From: Veanna Carr [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Mon, 24 Nov 2008 7:18 pm
Subject: Re: Remedy 4.0 or 4.5


** 




Hi Joe,

?

Thanks for responding.? We have the ARSystem install, but not the client tools 
install.? We need the licensing tool, or the knowledge of how it was done back 
then.? BMC has been helpful and gave us a 5.1 licensing tool, it's supposed to 
be compatible, but we're getting an ARERR 91 RPC procedure unavailable.? Which 
makes me think it's a different way of licensing.? 

?

We can wait until Thursday.? I have the new machine installed and we're testing 
it.? We had planned to move it tomorrow, but we'll wait until Monday.? 

?

Veanna

--- On Mon, 11/24/08, Joe DeSouza [EMAIL PROTECTED] wrote:


From: Joe DeSouza [EMAIL PROTECTED]
Subject: Re: Remedy 4.0 or 4.5
To: arslist@ARSLIST.ORG
Date: Monday, November 24, 2008, 5:33 PM


** 



Veanna,

?

These are old versions - more than 3 major versions old, so will no longer be 
available for download from the Remedy website. Remedy support, supports upto 3 
major releases so currently will support only upto 6.0 and in a few months upto 
6.3?after 7.5 is released.

?

Your best chances are?trying to source them from your old backups of software. 
I think I have those two?versions at?home but?am at home away from home at the 
moment in Connecticut and wont return to New Jersey where I currently reside 
till Thursday. If you can wait that long, I can look them up for you. I have 
the files necesasry for windows. Not sure if I have unix installers backed up 
to CD.

?

Joe



From: Veanna Carr [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Monday, November 24, 2008 6:06:52 PM
Subject: Remedy 4.0 or 4.5

** 




Hi Everyone,

?

Does anyone know where I can get the files for v4.0 or v4.5?

?

I especially need the cleint tools - licensing tool.? We need to move a legacy 
system to a new location.

?

ARListening








__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 4.0 or 4.5

2008-11-24 Thread Veanna Carr
Hi Roger,
 
So how did it work in 4?
 
We have the trial licenses for moving, but don't know how to apply them.
 
Veanna


--- On Mon, 11/24/08, Roger Justice [EMAIL PROTECTED] wrote:

From: Roger Justice [EMAIL PROTECTED]
Subject: Re: Remedy 4.0 or 4.5
To: arslist@ARSLIST.ORG
Date: Monday, November 24, 2008, 6:26 PM


** The licensing tool was changed in 5 since it became part of the admin tool. 


-Original Message-
From: Veanna Carr [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Mon, 24 Nov 2008 7:18 pm
Subject: Re: Remedy 4.0 or 4.5


** 




Hi Joe,
 
Thanks for responding.  We have the ARSystem install, but not the client tools 
install.  We need the licensing tool, or the knowledge of how it was done back 
then.  BMC has been helpful and gave us a 5.1 licensing tool, it's supposed to 
be compatible, but we're getting an ARERR 91 RPC procedure unavailable.  Which 
makes me think it's a different way of licensing.  
 
We can wait until Thursday.  I have the new machine installed and we're testing 
it.  We had planned to move it tomorrow, but we'll wait until Monday.  
 
Veanna

--- On Mon, 11/24/08, Joe DeSouza [EMAIL PROTECTED] wrote:

From: Joe DeSouza [EMAIL PROTECTED]
Subject: Re: Remedy 4.0 or 4.5
To: arslist@ARSLIST.ORG
Date: Monday, November 24, 2008, 5:33 PM


** 
#yiv669605538 #AOLMsgPart_2_c91177eb-7672-4b28-abdf-bf0ab178f425 #yiv1716852523 
DIV {margin:0px;}



Veanna,
 
These are old versions - more than 3 major versions old, so will no longer be 
available for download from the Remedy website. Remedy support, supports upto 3 
major releases so currently will support only upto 6.0 and in a few months upto 
6.3 after 7.5 is released.
 
Your best chances are trying to source them from your old backups of software. 
I think I have those two versions at home but am at home away from home at the 
moment in Connecticut and wont return to New Jersey where I currently reside 
till Thursday. If you can wait that long, I can look them up for you. I have 
the files necesasry for windows. Not sure if I have unix installers backed up 
to CD.
 
Joe




From: Veanna Carr [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Monday, November 24, 2008 6:06:52 PM
Subject: Remedy 4.0 or 4.5

** 




Hi Everyone,
 
Does anyone know where I can get the files for v4.0 or v4.5?
 
I especially need the cleint tools - licensing tool.  We need to move a legacy 
system to a new location.
 
ARListening
__Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___
__Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ 



Traveling over the river or through the woods this holiday season? Get the 
MapQuest Toolbar. Directions, Traffic, Gas Prices  More! __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 4.0 or 4.5

2008-11-24 Thread Joe DeSouza
Veanna,

There used to be a licensing tool, that had to be opened on the server. If I 
remember right it had too he used directly on the server and not remotely. You 
didn't have to log on. All you needed to do was open the tool and that tool 
would use the information in the ar.cfg or ar.conf file in case the license 
file was stored at any other place other than the default location and then 
interpret the contents of the file and display it within the tool.

I think a version 3 tool is compatible with version 4 for licensing and as 
Roger pointed out the licensing structure changed in 5 so it will not support 4.

Joe





From: Veanna Carr [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Monday, November 24, 2008 7:57:19 PM
Subject: Re: Remedy 4.0 or 4.5

** 
Hi Roger,

So how did it work in 4?

We have the trial licenses for moving, but don't know how to apply them.

Veanna


--- On Mon, 11/24/08, Roger Justice [EMAIL PROTECTED] wrote:

From: Roger Justice [EMAIL PROTECTED]
Subject: Re: Remedy 4.0 or 4.5
To: arslist@ARSLIST.ORG
Date: Monday, November 24, 2008, 6:26 PM


** The licensing tool was changed in 5 since it became part of the admin tool. 


-Original Message-
From: Veanna Carr [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Mon, 24 Nov 2008 7:18 pm
Subject: Re: Remedy 4.0 or 4.5


** 
Hi Joe,

Thanks for responding.  We have the ARSystem install, but not the client tools 
install.  We need the licensing tool, or the knowledge of how it was done back 
then.  BMC has been helpful and gave us a 5.1 licensing tool, it's supposed to 
be compatible, but we're getting an ARERR 91 RPC procedure unavailable.  Which 
makes me think it's a different way of licensing.  

We can wait until Thursday.  I have the new machine installed and we're testing 
it.  We had planned to move it tomorrow, but we'll wait until Monday.  

Veanna

--- On Mon, 11/24/08, Joe DeSouza [EMAIL PROTECTED] wrote:

From: Joe DeSouza [EMAIL PROTECTED]
Subject: Re: Remedy 4.0 or 4.5
To: arslist@ARSLIST.ORG
Date: Monday, November 24, 2008, 5:33 PM


** 
Veanna,

These are old versions - more than 3 major versions old, so will no longer be 
available for download from the Remedy website. Remedy support, supports upto 3 
major releases so currently will support only upto 6.0 and in a few months upto 
6.3 after 7.5 is released.

Your best chances are trying to source them from your old backups of software. 
I think I have those two versions at home but am at home away from home at the 
moment in Connecticut and wont return to New Jersey where I currently reside 
till Thursday. If you can wait that long, I can look them up for you. I have 
the files necesasry for windows. Not sure if I have unix installers backed up 
to CD.

Joe




From: Veanna Carr [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Monday, November 24, 2008 6:06:52 PM
Subject: Remedy 4.0 or 4.5

** 
Hi Everyone,

Does anyone know where I can get the files for v4.0 or v4.5?

I especially need the cleint tools - licensing tool.  We need to move a legacy 
system to a new location.

ARListening   




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

Re: Remedy 4.0 or 4.5

2008-11-24 Thread Veanna Carr
Which accounts for the error message.  The 4.0 has a form: Remedy Software 
Licence, that has the key data, same type of stuff in the licensing tool.  But 
the fields are read only, and I don't know how to get the information into 
them.  We are on Solaris, not windows.  Any information is greatly appreciated.
 
Veanna

--- On Mon, 11/24/08, Joe DeSouza [EMAIL PROTECTED] wrote:

From: Joe DeSouza [EMAIL PROTECTED]
Subject: Re: Remedy 4.0 or 4.5
To: arslist@ARSLIST.ORG
Date: Monday, November 24, 2008, 7:18 PM


** 




Veanna,
 
There used to be a licensing tool, that had to be opened on the server. If I 
remember right it had too he used directly on the server and not remotely. You 
didn't have to log on. All you needed to do was open the tool and that tool 
would use the information in the ar.cfg or ar.conf file in case the license 
file was stored at any other place other than the default location and then 
interpret the contents of the file and display it within the tool.
 
I think a version 3 tool is compatible with version 4 for licensing and as 
Roger pointed out the licensing structure changed in 5 so it will not support 4.
 
Joe





From: Veanna Carr [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Monday, November 24, 2008 7:57:19 PM
Subject: Re: Remedy 4.0 or 4.5

** 




Hi Roger,
 
So how did it work in 4?
 
We have the trial licenses for moving, but don't know how to apply them.
 
Veanna


--- On Mon, 11/24/08, Roger Justice [EMAIL PROTECTED] wrote:

From: Roger Justice [EMAIL PROTECTED]
Subject: Re: Remedy 4.0 or 4.5
To: arslist@ARSLIST.ORG
Date: Monday, November 24, 2008, 6:26 PM


** The licensing tool was changed in 5 since it became part of the admin tool. 


-Original Message-
From: Veanna Carr [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Mon, 24 Nov 2008 7:18 pm
Subject: Re: Remedy 4.0 or 4.5


** 




Hi Joe,
 
Thanks for responding.  We have the ARSystem install, but not the client tools 
install.  We need the licensing tool, or the knowledge of how it was done back 
then.  BMC has been helpful and gave us a 5.1 licensing tool, it's supposed to 
be compatible, but we're getting an ARERR 91 RPC procedure unavailable.  Which 
makes me think it's a different way of licensing.  
 
We can wait until Thursday.  I have the new machine installed and we're testing 
it.  We had planned to move it tomorrow, but we'll wait until Monday.  
 
Veanna

--- On Mon, 11/24/08, Joe DeSouza [EMAIL PROTECTED] wrote:

From: Joe DeSouza [EMAIL PROTECTED]
Subject: Re: Remedy 4.0 or 4.5
To: arslist@ARSLIST.ORG
Date: Monday, November 24, 2008, 5:33 PM


** 
#yiv1329960463 #yiv669605538 #AOLMsgPart_2_c91177eb-7672-4b28-abdf-bf0ab178f425 
#yiv1716852523 DIV {margin:0px;}



Veanna,
 
These are old versions - more than 3 major versions old, so will no longer be 
available for download from the Remedy website. Remedy support, supports upto 3 
major releases so currently will support only upto 6.0 and in a few months upto 
6.3 after 7.5 is released.
 
Your best chances are trying to source them from your old backups of software. 
I think I have those two versions at home but am at home away from home at the 
moment in Connecticut and wont return to New Jersey where I currently reside 
till Thursday. If you can wait that long, I can look them up for you. I have 
the files necesasry for windows. Not sure if I have unix installers backed up 
to CD.
 
Joe




From: Veanna Carr [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Monday, November 24, 2008 6:06:52 PM
Subject: Remedy 4.0 or 4.5

** 




Hi Everyone,
 
Does anyone know where I can get the files for v4.0 or v4.5?
 
I especially need the cleint tools - licensing tool.  We need to move a legacy 
system to a new location.
 
ARListening
__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: libumem - performance increase on Solaris with ITSM 7.X

2008-11-24 Thread Joe DeSouza
When you say the Escalation was scanning 40 million records, are you saying it 
was processing that many records? Wasn't there a Run If condition that narrowed 
the set to a smaller subset? If so then that was one 'expensive' requirement to 
process 40 million records in an escalation. I do not think the Escalation 
thread can handle that many records in a single run. Escalations are usually 
designed to run over a much smaller subset of records and tipping over a 4 or a 
5 K mark I would think is begging for some trouble in the long run.

Joe





From: Chintan Shah [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Monday, November 24, 2008 6:47:47 PM
Subject: Re: libumem - performance increase on Solaris with ITSM 7.X

** 
Hi Terry,

We have libumem on our production system(all custom remedy apps..no ITSM)..but 
here's the deal..if you dont specify the Number of results returnedthere is 
possibility that arserverd will crash. We have tested this on couple of 
different machines with same configurations. However, if you set Number of 
records returned to 3000, it works fine.

We had an escalation scanning 40 million records that crashed arserverd in 
less than 4 minutes even though we were on libumem. Although it was bad code, 
instead of throwing any errors, it just crashed.

Another issue was with form which had 2 million records and  Results List had 
more than 15 fields. This also crashed server on Search.

We are on Solaris 5.10. 

Try the above scenarios. It might also be related to Hardware and all those 
fuzzy CPU utilization..but I am not sure..all I saw from remedy side was that 
it got crashed.

Thanks
Chintan.

--- On Mon, 11/24/08, Terry Bootsma [EMAIL PROTECTED] wrote:

From: Terry Bootsma [EMAIL PROTECTED]
Subject: libumem - performance increase on Solaris with ITSM 7.X
To: arslist@ARSLIST.ORG
Date: Monday, November 24, 2008, 3:08 PM


Hello arslist:

We have been utilizing ARS 7.1 Patch 004 with ITSM 7.0.2 (latest patch for
Incident, Change, Config, and Problem) on a multi-CPU, high end Solaris box
running DB2.  We have had SIGNIFICANT performance issues under high load
running this configuration as a result of our load testing exercise.

However, after meeting with Remedy engineers yesterday, they suggested that
we replace the standard Solaris memory manager with a   preloaded
libumem
memory manager.  This has produced astonishing results and has resolved our
issue of performance under high load with the fact that libumem uses a
different memory allocation model that is more condusive to multi-cpu,
multi-threaded applications.

My question to the list is this.  Have any of you replaced your memory
manager in production with libumem and , if so, were there any side
affects of doing so?

Thanks for any feedback Terry 




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

Re: Remedy 4.0 or 4.5

2008-11-24 Thread LJ Longwing
If I remember the 4.x days correctly, the license tool was either an
xwindows thing where you had to get into your server via an x client (if
your server was unix of course) and launch it that way...or if you server
was windows you could just look for license.exe in the server
directorywhat kind of host are these old servers on?

  _  

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Veanna Carr
Sent: Monday, November 24, 2008 5:18 PM
To: arslist@ARSLIST.ORG
Subject: Re: Remedy 4.0 or 4.5


** 

Hi Joe,
 
Thanks for responding.  We have the ARSystem install, but not the client
tools install.  We need the licensing tool, or the knowledge of how it was
done back then.  BMC has been helpful and gave us a 5.1 licensing tool, it's
supposed to be compatible, but we're getting an ARERR 91 RPC procedure
unavailable.  Which makes me think it's a different way of licensing.  
 
We can wait until Thursday.  I have the new machine installed and we're
testing it.  We had planned to move it tomorrow, but we'll wait until
Monday.  
 
Veanna

--- On Mon, 11/24/08, Joe DeSouza [EMAIL PROTECTED] wrote:


From: Joe DeSouza [EMAIL PROTECTED]
Subject: Re: Remedy 4.0 or 4.5
To: arslist@ARSLIST.ORG
Date: Monday, November 24, 2008, 5:33 PM


** 
Veanna,
 
These are old versions - more than 3 major versions old, so will no longer
be available for download from the Remedy website. Remedy support, supports
upto 3 major releases so currently will support only upto 6.0 and in a few
months upto 6.3 after 7.5 is released.
 
Your best chances are trying to source them from your old backups of
software. I think I have those two versions at home but am at home away from
home at the moment in Connecticut and wont return to New Jersey where I
currently reside till Thursday. If you can wait that long, I can look them
up for you. I have the files necesasry for windows. Not sure if I have unix
installers backed up to CD.
 
Joe


  _  

From: Veanna Carr [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Monday, November 24, 2008 6:06:52 PM
Subject: Remedy 4.0 or 4.5

** 

Hi Everyone,
 
Does anyone know where I can get the files for v4.0 or v4.5?
 
I especially need the cleint tools - licensing tool.  We need to move a
legacy system to a new location.
 
ARListening

__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: SQL Reporing Services - making sense of Remedy Table structure

2008-11-24 Thread LJ Longwing
RFrench,
You will find that the people in this forum likely have most, if not all of
the information that you are looking for.  If you provide the details of
your environment, and what you are looking for, where you have tried, and
maybe even where you looked to try to find the right informationthis
forum will likely bridge the gap of your inexperience and bring you up to
speed fairly quicklynow...to provide a bit of information to answer your
question...even though I'm sure it's not what you meanthere you go.

The information is stored mainly in the T tables, the H tables are used
strictly for Status History storage (unless you have that turned off that
is)...and the B tables store the binary data associated with the records in
T if you happen to have attachment fields on that form.

:) 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of RFrench
Sent: Monday, November 24, 2008 4:12 PM
To: arslist@ARSLIST.ORG
Subject: Re: SQL Reporing Services - making sense of Remedy Table structure

Thanks for that, for me personally speaking it raises another issue where
%*% is all this information.  I have only been in my role for about 8
months, l have reached the conculsion that l am missing something.  There is
obviously plenty of information and experience regarding the backend
database, and some other issue, but finding it is another issue althogher. 
My experience so far, is find one bit of information here then another bit
somewhere else, yet very little is documented, in any meaning form.

Sorry for the rant Remedy is an excellent product however even in my short
experience there are things missing.  Not least of all documenation.  Guess
now l have managed to start posting l might be asking some more questions =)
--
View this message in context:
http://www.nabble.com/SQL-Reporing-Services---making-sense-of-Remedy-Table-s
tructure-tp20626113p20672036.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

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


Re: Remedy 4.0 or 4.5

2008-11-24 Thread Joe DeSouza
Veanna,

4 didn't have a form? On version 4 licenses were stored on the disk. On Solaris 
(any unix system for that matter) the Remedy licenses were stored in the 
/etc/arsystem/servername/ folder in a .lic file.

This is a text file with the license stored in a particular format.

What do you want to do? Add? Remove? Delete a license?

You just might be able to do it bypassing the tool by doing it manually by 
editing this file. Its not rocket science really as the information isn't 
encrypted by the tool, its very much in a free text format.

After doing whatever you wish to do on the licnese file, you can run the 
arsignal -l AR Server Name:AR TCP Portnumber. The arsignal command will be 
found in the bin folder of the AR Server installation folder.

Its a sort of a backdoor towards doing what you might be looking to do, but I 
hope it helps.

Joe





From: Veanna Carr [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Monday, November 24, 2008 8:25:00 PM
Subject: Re: Remedy 4.0 or 4.5

** 
Which accounts for the error message.  The 4.0 has a form: Remedy Software 
Licence, that has the key data, same type of stuff in the licensing tool.  But 
the fields are read only, and I don't know how to get the information into 
them.  We are on Solaris, not windows.  Any information is greatly appreciated.

Veanna

--- On Mon, 11/24/08, Joe DeSouza [EMAIL PROTECTED] wrote:

From: Joe DeSouza [EMAIL PROTECTED]
Subject: Re: Remedy 4.0 or 4.5
To: arslist@ARSLIST.ORG
Date: Monday, November 24, 2008, 7:18 PM


** 
Veanna,

There used to be a licensing tool, that had to be opened on the server. If I 
remember right it had too he used directly on the server and not remotely. You 
didn't have to log on. All you needed to do was open the tool and that tool 
would use the information in the ar.cfg or ar.conf file in case the license 
file was stored at any other place other than the default location and then 
interpret the contents of the file and display it within the tool.

I think a version 3 tool is compatible with version 4 for licensing and as 
Roger pointed out the licensing structure changed in 5 so it will not support 4.

Joe





From: Veanna Carr [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Monday, November 24, 2008 7:57:19 PM
Subject: Re: Remedy 4.0 or 4.5

** 
Hi Roger,

So how did it work in 4?

We have the trial licenses for moving, but don't know how to apply them.

Veanna


--- On Mon, 11/24/08, Roger Justice [EMAIL PROTECTED] wrote:

From: Roger Justice [EMAIL PROTECTED]
Subject: Re: Remedy 4.0 or 4.5
To: arslist@ARSLIST.ORG
Date: Monday, November 24, 2008, 6:26 PM


** The licensing tool was changed in 5 since it became part of the admin tool. 


-Original Message-
From: Veanna Carr [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Mon, 24 Nov 2008 7:18 pm
Subject: Re: Remedy 4.0 or 4.5


** 
Hi Joe,

Thanks for responding.  We have the ARSystem install, but not the client tools 
install.  We need the licensing tool, or the knowledge of how it was done back 
then.  BMC has been helpful and gave us a 5.1 licensing tool, it's supposed to 
be compatible, but we're getting an ARERR 91 RPC procedure unavailable.  Which 
makes me think it's a different way of licensing.  

We can wait until Thursday.  I have the new machine installed and we're testing 
it.  We had planned to move it tomorrow, but we'll wait until Monday.  

Veanna

--- On Mon, 11/24/08, Joe DeSouza [EMAIL PROTECTED] wrote:

From: Joe DeSouza [EMAIL PROTECTED]
Subject: Re: Remedy 4.0 or 4.5
To: arslist@ARSLIST.ORG
Date: Monday, November 24, 2008, 5:33 PM


** 
Veanna,

These are old versions - more than 3 major versions old, so will no longer be 
available for download from the Remedy website. Remedy support, supports upto 3 
major releases so currently will support only upto 6.0 and in a few months upto 
6.3 after 7.5 is released.

Your best chances are trying to source them from your old backups of software. 
I think I have those two versions at home but am at home away from home at the 
moment in Connecticut and wont return to New Jersey where I currently reside 
till Thursday. If you can wait that long, I can look them up for you. I have 
the files necesasry for windows. Not sure if I have unix installers backed up 
to CD.

Joe




From: Veanna Carr [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Monday, November 24, 2008 6:06:52 PM
Subject: Remedy 4.0 or 4.5

** 
Hi Everyone,

Does anyone know where I can get the files for v4.0 or v4.5?

I especially need the cleint tools - licensing tool.  We need to move a legacy 
system to a new location.

ARListening




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

Re: Remedy 4.0 or 4.5

2008-11-24 Thread Joe DeSouza
Oh yea I nearly forgot about intializing xwindows on the terminal client if you 
wanted to run the license tool. That was needed to run the graphical tool.

Joe





From: LJ Longwing [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Monday, November 24, 2008 8:30:43 PM
Subject: Re: Remedy 4.0 or 4.5

** 
If I remember the 4.x days correctly, the license tool was either an xwindows 
thing where you had to get into your server via an x client (if your server was 
unix of course) and launch it that way...or if you server was windows you could 
just look for license.exe in the server directorywhat kind of host are 
these old servers on?



From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Veanna Carr
Sent: Monday, November 24, 2008 5:18 PM
To: arslist@ARSLIST.ORG
Subject: Re: Remedy 4.0 or 4.5

** 
Hi Joe,

Thanks for responding.  We have the ARSystem install, but not the client tools 
install.  We need the licensing tool, or the knowledge of how it was done back 
then.  BMC has been helpful and gave us a 5.1 licensing tool, it's supposed to 
be compatible, but we're getting an ARERR 91 RPC procedure unavailable.  Which 
makes me think it's a different way of licensing.  

We can wait until Thursday.  I have the new machine installed and we're testing 
it.  We had planned to move it tomorrow, but we'll wait until Monday.  

Veanna

--- On Mon, 11/24/08, Joe DeSouza [EMAIL PROTECTED] wrote:

From: Joe DeSouza [EMAIL PROTECTED]
Subject: Re: Remedy 4.0 or 4.5
To: arslist@ARSLIST.ORG
Date: Monday, November 24, 2008, 5:33 PM


** 
Veanna,

These are old versions - more than 3 major versions old, so will no longer be 
available for download from the Remedy website. Remedy support, supports upto 3 
major releases so currently will support only upto 6.0 and in a few months upto 
6.3 after 7.5 is released.

Your best chances are trying to source them from your old backups of software. 
I think I have those two versions at home but am at home away from home at the 
moment in Connecticut and wont return to New Jersey where I currently reside 
till Thursday. If you can wait that long, I can look them up for you. I have 
the files necesasry for windows. Not sure if I have unix installers backed up 
to CD.

Joe




From: Veanna Carr [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Monday, November 24, 2008 6:06:52 PM
Subject: Remedy 4.0 or 4.5

** 
Hi Everyone,

Does anyone know where I can get the files for v4.0 or v4.5?

I especially need the cleint tools - licensing tool.  We need to move a legacy 
system to a new location.

ARListening  




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

Re: Remedy 4.0 or 4.5

2008-11-24 Thread Veanna Carr
Our current server is Solaris/Unix, and the new server is Solaris/Unix.

--- On Mon, 11/24/08, LJ Longwing [EMAIL PROTECTED] wrote:

From: LJ Longwing [EMAIL PROTECTED]
Subject: Re: Remedy 4.0 or 4.5
To: arslist@ARSLIST.ORG
Date: Monday, November 24, 2008, 7:30 PM


** 
If I remember the 4.x days correctly, the license tool was either an xwindows 
thing where you had to get into your server via an x client (if your server was 
unix of course) and launch it that way...or if you server was windows you could 
just look for license.exe in the server directorywhat kind of host are 
these old servers on?



From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Veanna Carr
Sent: Monday, November 24, 2008 5:18 PM
To: arslist@ARSLIST.ORG
Subject: Re: Remedy 4.0 or 4.5


** 




Hi Joe,
 
Thanks for responding.  We have the ARSystem install, but not the client tools 
install.  We need the licensing tool, or the knowledge of how it was done back 
then.  BMC has been helpful and gave us a 5.1 licensing tool, it's supposed to 
be compatible, but we're getting an ARERR 91 RPC procedure unavailable.  Which 
makes me think it's a different way of licensing.  
 
We can wait until Thursday.  I have the new machine installed and we're testing 
it.  We had planned to move it tomorrow, but we'll wait until Monday.  
 
Veanna

--- On Mon, 11/24/08, Joe DeSouza [EMAIL PROTECTED] wrote:

From: Joe DeSouza [EMAIL PROTECTED]
Subject: Re: Remedy 4.0 or 4.5
To: arslist@ARSLIST.ORG
Date: Monday, November 24, 2008, 5:33 PM


** 
#yiv49962921 #yiv1716852523 DIV {
MARGIN:0px;}




Veanna,
 
These are old versions - more than 3 major versions old, so will no longer be 
available for download from the Remedy website. Remedy support, supports upto 3 
major releases so currently will support only upto 6.0 and in a few months upto 
6.3 after 7.5 is released.
 
Your best chances are trying to source them from your old backups of software. 
I think I have those two versions at home but am at home away from home at the 
moment in Connecticut and wont return to New Jersey where I currently reside 
till Thursday. If you can wait that long, I can look them up for you. I have 
the files necesasry for windows. Not sure if I have unix installers backed up 
to CD.
 
Joe




From: Veanna Carr [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Monday, November 24, 2008 6:06:52 PM
Subject: Remedy 4.0 or 4.5

** 




Hi Everyone,
 
Does anyone know where I can get the files for v4.0 or v4.5?
 
I especially need the cleint tools - licensing tool.  We need to move a legacy 
system to a new location.
 
ARListening
__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: Remedy 4.0 or 4.5

2008-11-24 Thread LJ Longwing
I only remember it because it was the only thing in the entire world I
needed exceed forand I was constantly being bugged by licensing about if
I really needed the license.

  _  

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza
Sent: Monday, November 24, 2008 6:38 PM
To: arslist@ARSLIST.ORG
Subject: Re: Remedy 4.0 or 4.5


** 
Oh yea I nearly forgot about intializing xwindows on the terminal client if
you wanted to run the license tool. That was needed to run the graphical
tool.
 
Joe


  _  

From: LJ Longwing [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Monday, November 24, 2008 8:30:43 PM
Subject: Re: Remedy 4.0 or 4.5

** 
If I remember the 4.x days correctly, the license tool was either an
xwindows thing where you had to get into your server via an x client (if
your server was unix of course) and launch it that way...or if you server
was windows you could just look for license.exe in the server
directorywhat kind of host are these old servers on?

  _  

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Veanna Carr
Sent: Monday, November 24, 2008 5:18 PM
To: arslist@ARSLIST.ORG
Subject: Re: Remedy 4.0 or 4.5


** 

Hi Joe,
 
Thanks for responding.  We have the ARSystem install, but not the client
tools install.  We need the licensing tool, or the knowledge of how it was
done back then.  BMC has been helpful and gave us a 5.1 licensing tool, it's
supposed to be compatible, but we're getting an ARERR 91 RPC procedure
unavailable.  Which makes me think it's a different way of licensing.  
 
We can wait until Thursday.  I have the new machine installed and we're
testing it.  We had planned to move it tomorrow, but we'll wait until
Monday.  
 
Veanna

--- On Mon, 11/24/08, Joe DeSouza [EMAIL PROTECTED] wrote:


From: Joe DeSouza [EMAIL PROTECTED]
Subject: Re: Remedy 4.0 or 4.5
To: arslist@ARSLIST.ORG
Date: Monday, November 24, 2008, 5:33 PM


** 
Veanna,
 
These are old versions - more than 3 major versions old, so will no longer
be available for download from the Remedy website. Remedy support, supports
upto 3 major releases so currently will support only upto 6.0 and in a few
months upto 6.3 after 7.5 is released.
 
Your best chances are trying to source them from your old backups of
software. I think I have those two versions at home but am at home away from
home at the moment in Connecticut and wont return to New Jersey where I
currently reside till Thursday. If you can wait that long, I can look them
up for you. I have the files necesasry for windows. Not sure if I have unix
installers backed up to CD.
 
Joe


  _  

From: Veanna Carr [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Monday, November 24, 2008 6:06:52 PM
Subject: Remedy 4.0 or 4.5

** 

Hi Everyone,
 
Does anyone know where I can get the files for v4.0 or v4.5?
 
I especially need the cleint tools - licensing tool.  We need to move a
legacy system to a new location.
 
ARListening


__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 4.0 or 4.5

2008-11-24 Thread LJ Longwing
Ok...look in your server bin dir and see if you have a binary named
'license'...that's the license client...but it's graphical...and can't be
run from the command line...if you can get an xserver and xclient together
on that box you should be able to do itor you could as suggested by
another poster, just edit the arsystem.lic file

  _  

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Veanna Carr
Sent: Monday, November 24, 2008 6:39 PM
To: arslist@ARSLIST.ORG
Subject: Re: Remedy 4.0 or 4.5


** 
Our current server is Solaris/Unix, and the new server is Solaris/Unix.

--- On Mon, 11/24/08, LJ Longwing [EMAIL PROTECTED] wrote:



From: LJ Longwing [EMAIL PROTECTED]
Subject: Re: Remedy 4.0 or 4.5
To: arslist@ARSLIST.ORG
Date: Monday, November 24, 2008, 7:30 PM


** 
If I remember the 4.x days correctly, the license tool was either an
xwindows thing where you had to get into your server via an x client (if
your server was unix of course) and launch it that way...or if you server
was windows you could just look for license.exe in the server
directorywhat kind of host are these old servers on?

  _  

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Veanna Carr
Sent: Monday, November 24, 2008 5:18 PM
To: arslist@ARSLIST.ORG
Subject: Re: Remedy 4.0 or 4.5


** 

Hi Joe,
 
Thanks for responding.  We have the ARSystem install, but not the client
tools install.  We need the licensing tool, or the knowledge of how it was
done back then.  BMC has been helpful and gave us a 5.1 licensing tool, it's
supposed to be compatible, but we're getting an ARERR 91 RPC procedure
unavailable.  Which makes me think it's a different way of licensing.  
 
We can wait until Thursday.  I have the new machine installed and we're
testing it.  We had planned to move it tomorrow, but we'll wait until
Monday.  
 
Veanna

--- On Mon, 11/24/08, Joe DeSouza [EMAIL PROTECTED] wrote:


From: Joe DeSouza [EMAIL PROTECTED]
Subject: Re: Remedy 4.0 or 4.5
To: arslist@ARSLIST.ORG
Date: Monday, November 24, 2008, 5:33 PM


** 
Veanna,
 
These are old versions - more than 3 major versions old, so will no longer
be available for download from the Remedy website. Remedy support, supports
upto 3 major releases so currently will support only upto 6.0 and in a few
months upto 6.3 after 7.5 is released.
 
Your best chances are trying to source them from your old backups of
software. I think I have those two versions at home but am at home away from
home at the moment in Connecticut and wont return to New Jersey where I
currently reside till Thursday. If you can wait that long, I can look them
up for you. I have the files necesasry for windows. Not sure if I have unix
installers backed up to CD.
 
Joe


  _  

From: Veanna Carr [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Monday, November 24, 2008 6:06:52 PM
Subject: Remedy 4.0 or 4.5

** 

Hi Everyone,
 
Does anyone know where I can get the files for v4.0 or v4.5?
 
I especially need the cleint tools - licensing tool.  We need to move a
legacy system to a new location.
 
ARListening

__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: Remedy 4.0 or 4.5

2008-11-24 Thread Veanna Carr
What we want to do:  Create a new server (done), move it to the new location, 
move the support team to the new server.  Move the current production server to 
the new location and use as the hot backup sysytem.
 
So both machines will need a new license.


--- On Mon, 11/24/08, Joe DeSouza [EMAIL PROTECTED] wrote:

From: Joe DeSouza [EMAIL PROTECTED]
Subject: Re: Remedy 4.0 or 4.5
To: arslist@ARSLIST.ORG
Date: Monday, November 24, 2008, 7:35 PM


** 




Veanna,
 
4 didn't have a form? On version 4 licenses were stored on the disk. On Solaris 
(any unix system for that matter) the Remedy licenses were stored in the 
/etc/arsystem/servername/ folder in a .lic file.
 
This is a text file with the license stored in a particular format.
 
What do you want to do? Add? Remove? Delete a license?
 
You just might be able to do it bypassing the tool by doing it manually by 
editing this file. Its not rocket science really as the information isn't 
encrypted by the tool, its very much in a free text format.
 
After doing whatever you wish to do on the licnese file, you can run the 
arsignal -l AR Server Name:AR TCP Portnumber. The arsignal command will be 
found in the bin folder of the AR Server installation folder.
 
Its a sort of a backdoor towards doing what you might be looking to do, but I 
hope it helps.
 
Joe





From: Veanna Carr [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Monday, November 24, 2008 8:25:00 PM
Subject: Re: Remedy 4.0 or 4.5

** 




Which accounts for the error message.  The 4.0 has a form: Remedy Software 
Licence, that has the key data, same type of stuff in the licensing tool.  But 
the fields are read only, and I don't know how to get the information into 
them.  We are on Solaris, not windows.  Any information is greatly appreciated.
 
Veanna

--- On Mon, 11/24/08, Joe DeSouza [EMAIL PROTECTED] wrote:

From: Joe DeSouza [EMAIL PROTECTED]
Subject: Re: Remedy 4.0 or 4.5
To: arslist@ARSLIST.ORG
Date: Monday, November 24, 2008, 7:18 PM


** 




Veanna,
 
There used to be a licensing tool, that had to be opened on the server. If I 
remember right it had too he used directly on the server and not remotely. You 
didn't have to log on. All you needed to do was open the tool and that tool 
would use the information in the ar.cfg or ar.conf file in case the license 
file was stored at any other place other than the default location and then 
interpret the contents of the file and display it within the tool.
 
I think a version 3 tool is compatible with version 4 for licensing and as 
Roger pointed out the licensing structure changed in 5 so it will not support 4.
 
Joe





From: Veanna Carr [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Monday, November 24, 2008 7:57:19 PM
Subject: Re: Remedy 4.0 or 4.5

** 




Hi Roger,
 
So how did it work in 4?
 
We have the trial licenses for moving, but don't know how to apply them.
 
Veanna


--- On Mon, 11/24/08, Roger Justice [EMAIL PROTECTED] wrote:

From: Roger Justice [EMAIL PROTECTED]
Subject: Re: Remedy 4.0 or 4.5
To: arslist@ARSLIST.ORG
Date: Monday, November 24, 2008, 6:26 PM


** The licensing tool was changed in 5 since it became part of the admin tool. 


-Original Message-
From: Veanna Carr [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Mon, 24 Nov 2008 7:18 pm
Subject: Re: Remedy 4.0 or 4.5


** 




Hi Joe,
 
Thanks for responding.  We have the ARSystem install, but not the client tools 
install.  We need the licensing tool, or the knowledge of how it was done back 
then.  BMC has been helpful and gave us a 5.1 licensing tool, it's supposed to 
be compatible, but we're getting an ARERR 91 RPC procedure unavailable.  Which 
makes me think it's a different way of licensing.  
 
We can wait until Thursday.  I have the new machine installed and we're testing 
it.  We had planned to move it tomorrow, but we'll wait until Monday.  
 
Veanna

--- On Mon, 11/24/08, Joe DeSouza [EMAIL PROTECTED] wrote:

From: Joe DeSouza [EMAIL PROTECTED]
Subject: Re: Remedy 4.0 or 4.5
To: arslist@ARSLIST.ORG
Date: Monday, November 24, 2008, 5:33 PM


** 
#yiv746731253 #yiv1329960463 #yiv669605538 
#AOLMsgPart_2_c91177eb-7672-4b28-abdf-bf0ab178f425 #yiv1716852523 DIV 
{margin:0px;}



Veanna,
 
These are old versions - more than 3 major versions old, so will no longer be 
available for download from the Remedy website. Remedy support, supports upto 3 
major releases so currently will support only upto 6.0 and in a few months upto 
6.3 after 7.5 is released.
 
Your best chances are trying to source them from your old backups of software. 
I think I have those two versions at home but am at home away from home at the 
moment in Connecticut and wont return to New Jersey where I currently reside 
till Thursday. If you can wait that long, I can look them up for you. I have 
the files necesasry for windows. Not sure if I have unix installers backed up 
to CD.
 
Joe




From: Veanna Carr [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Monday, November 24, 

Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED)

2008-11-24 Thread Joe DeSouza
Another thing could be your disk space getting full on the Remedy server. We 
had that issue recently when one of the operation some user would do would 
eventually timeout and would create a temp file on the servers Windows Temp 
directory that would grow and keep growing even if the user quit the user tool 
from the client. The disk would eventually be full and the AR Server would get 
extremely slow and eventually impossible to login.

Bouoncing the Remedy Service would kill that temp file and release all the used 
space..

Joe





From: Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Monday, November 24, 2008 12:58:53 PM
Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED)

Yes, that's my suspicion.  I have a big suspicion that people are searching the 
worklog diary field.

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Michaud, Christopher W Mr CTRUSA MEDCOM 
USAMITC
Sent: Monday, November 24, 2008 11:20 AM
To: arslist@ARSLIST.ORG
Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED)

Classification:  UNCLASSIFIED 
Caveats: NONE

Norm,

You may want to look closer at the SQL side. Look for locks. Perhaps someone 
querying a diary or un-indexed field. Also, are you using SQL replication? In 
particular, are snapshots turned on?


Christopher Michaud

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC96 CS/SCCE
Sent: Monday, November 24, 2008 11:03 AM
To: arslist@ARSLIST.ORG
Subject: Intermittent, Spotty ARS Performance

** 

Hi everyone:

This problem has me perplexed.

At a site I support, the Remedy server inexplicably stops responding to 
requests.  It's very intermittent.  It runs fine for awhile, then seemingly 
without warning, it just hangs.  Users attempting to log on get stuck at the 
Setting server port dialog, which eventually times out.

Other users who are already logged who try to pull up a ticket get stuck at a 
blank screen that never comes back.

To resolve the issue, they have to bounce the Remedy server service. The system 
works for awhile...until it hangs up again.

Any ideas what might be causing this?

-          I have monitored CPU utilization when this occurs, and the CPU hums 
along at about 3% - 5% utilization
-          Network utilization is flat-lined whenever this occurs (i.e., no 
spike)
-          Memory utilization appears normal
-          CNET bandwidth tests resolve to better than dedicated T1 performance 
(for what that's worth)

Any thoughts are greatly appreciated.

The interesting thing is, we have the same exact Remedy apps running on the 
same exact type of server in the same exact environment in four other 
locations, and those four other locations never experience any problems.

Norm

Remedy ARS 6.3
Microsoft SQL 2000 SP4
Microsoft Windows 2000 SP2
100% Custom Apps - No ITSM




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

Re: Remedy 4.0 or 4.5

2008-11-24 Thread Shellman, David
Veanna,

Joe and LJ are correct.  The license tool is a binary that is on the server 
when you install the software.  I used to have a SUN desktop sitting on my desk 
just to run the license tool on our Solaris server.

Don't ask me why but I still have 4.x client and admin installs (windows 
versions) saved on my laptop.  I have various patches.  Here is what I have:

12/16/1999  03:23 PM12,220,897 arswat403.exe
08/22/2000  10:45 AM12,986,078 arswat451.exe
02/14/2001  11:55 PM13,025,648 arswat452.exe
08/04/1999  11:55 AM13,149,200 arswut402.exe
12/21/1999  12:17 PM15,625,045 arswut403.exe
08/22/2000  10:53 AM26,387,297 arswut451.exe
02/27/2001  11:19 AM26,387,511 arswut451948.exe
02/14/2001  11:54 PM26,391,499 arswut452.exe
10/19/1999  04:22 PM13,123,771 arswut4812.exe

Let me know which ones you want and I will send them to you.

Dave

From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Veanna Carr
Sent: Monday, November 24, 2008 8:56 PM
To: arslist@ARSLIST.ORG
Subject: Re: Remedy 4.0 or 4.5

**
What we want to do:  Create a new server (done), move it to the new location, 
move the support team to the new server.  Move the current production server to 
the new location and use as the hot backup sysytem.

So both machines will need a new license.


--- On Mon, 11/24/08, Joe DeSouza [EMAIL PROTECTED] wrote:
From: Joe DeSouza [EMAIL PROTECTED]
Subject: Re: Remedy 4.0 or 4.5
To: arslist@ARSLIST.ORG
Date: Monday, November 24, 2008, 7:35 PM

**
Veanna,

4 didn't have a form? On version 4 licenses were stored on the disk. On Solaris 
(any unix system for that matter) the Remedy licenses were stored in the 
/etc/arsystem/servername/ folder in a .lic file.

This is a text file with the license stored in a particular format.

What do you want to do? Add? Remove? Delete a license?

You just might be able to do it bypassing the tool by doing it manually by 
editing this file. Its not rocket science really as the information isn't 
encrypted by the tool, its very much in a free text format.

After doing whatever you wish to do on the licnese file, you can run the 
arsignal -l AR Server Name:AR TCP Portnumber. The arsignal command will be 
found in the bin folder of the AR Server installation folder.

Its a sort of a backdoor towards doing what you might be looking to do, but I 
hope it helps.

Joe


From: Veanna Carr [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Monday, November 24, 2008 8:25:00 PM
Subject: Re: Remedy 4.0 or 4.5

**
Which accounts for the error message.  The 4.0 has a form: Remedy Software 
Licence, that has the key data, same type of stuff in the licensing tool.  But 
the fields are read only, and I don't know how to get the information into 
them.  We are on Solaris, not windows.  Any information is greatly appreciated.

Veanna

--- On Mon, 11/24/08, Joe DeSouza [EMAIL PROTECTED] wrote:
From: Joe DeSouza [EMAIL PROTECTED]
Subject: Re: Remedy 4.0 or 4.5
To: arslist@ARSLIST.ORG
Date: Monday, November 24, 2008, 7:18 PM

**
Veanna,

There used to be a licensing tool, that had to be opened on the server. If I 
remember right it had too he used directly on the server and not remotely. You 
didn't have to log on. All you needed to do was open the tool and that tool 
would use the information in the ar.cfg or ar.conf file in case the license 
file was stored at any other place other than the default location and then 
interpret the contents of the file and display it within the tool.

I think a version 3 tool is compatible with version 4 for licensing and as 
Roger pointed out the licensing structure changed in 5 so it will not support 4.

Joe


From: Veanna Carr [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Monday, November 24, 2008 7:57:19 PM
Subject: Re: Remedy 4.0 or 4.5

**
Hi Roger,

So how did it work in 4?

We have the trial licenses for moving, but don't know how to apply them.

Veanna


--- On Mon, 11/24/08, Roger Justice [EMAIL PROTECTED] wrote:
From: Roger Justice [EMAIL PROTECTED]
Subject: Re: Remedy 4.0 or 4.5
To: arslist@ARSLIST.ORG
Date: Monday, November 24, 2008, 6:26 PM

** The licensing tool was changed in 5 since it became part of the admin tool.


-Original Message-
From: Veanna Carr [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Mon, 24 Nov 2008 7:18 pm
Subject: Re: Remedy 4.0 or 4.5

**
Hi Joe,

Thanks for responding.  We have the ARSystem install, but not the client tools 
install.  We need the licensing tool, or the knowledge of how it was done back 
then.  BMC has been helpful and gave us a 5.1 licensing tool, it's supposed to 
be compatible, but we're getting an ARERR 91 RPC procedure unavailable.  Which 
makes me think it's a different way of licensing.

We can wait until Thursday.  I have the new machine installed and we're testing 
it.  We had planned to 

Re: SW00247290 - Death of the Plugin Server

2008-11-24 Thread Jase Brandon
ARS 7.1 Patch 002
 Mid-Tier 7.1 Patch 004
CMDB 2.1 Patch 6
ITSM Patch 8
Approval Server 7.0.06
Windows

Hello Listers:

Please see below error: I think I have isolated this problem by starting the
plugin.exe from the command line.
The plugin server shows that it's up and running when I start regularly or
from the command line, so I have been starting plugin.exe from the cmd line
to produce the below referenced errors.
I can't get the overview console, server admin console or anything for the
plugin server to work on our dev server.
The Server Admin Console works on prod, but not the Overview Console, which
makes this even more confusing.

From the home page, when selecting Overview or Server Admin Console,  I keep
getting ARERR [8755] The specified plug-in does not exist. :
REMEDY.ARDBC.SERVER.ADMINISTRATION, and
ARERR [8755] The specified plug-in does not exist. :
REMEDY.ARDBC.APPQUERY.
I have replaced .dlls, reinstalled arserver.exe, read logs and I can't find
where this password that the approval plugin wants is coming from.
I have upgraded from to ITSM 7 Unpatched to ITSM Patch 008, I have installed
Approval Server 7.0.1 Patch 7.
I changed the plugin timeout to 600 seconds, so the plugin bombs out after
ten mins with the below every time.
I can't find anything to lead me further down the path to resolution. the
plugin server is up, but not being recognized.
To overcome the initial error of arservdb directory does not exist, I added
the directory and the .lck file it was looking for 390606.lck.
Then when I ran arplugin.exe -i. -m from the command line, the plugin server
went one step further to the below.
Please see attached ar.cfg - Does anyone have any ideas on how to get this
to work? I am obviously stumped. :-)

Thanks in Advance to All.

Jase K Brandon
Quality Technology Services


ArError.Log
Mon Nov 24 22:14:46 2008  Approve : Authentication failed (ARERR 623)
Mon Nov 24 22:14:46 2008  Approve : Name parameter (or name field in a
parameter) is empty (ARERR 102)
Mon Nov 24 22:14:46 2008  Approve : Name parameter (or name field in a
parameter) is empty (ARERR 102)
Mon Nov 24 22:14:46 2008  Approve : Name parameter (or name field in a
parameter) is empty (ARERR 102)
Mon Nov 24 22:14:46 2008  Approve : Name parameter (or name field in a
parameter) is empty (ARERR 102)




On Thu, Nov 20, 2008 at 7:36 PM, Joe DeSouza [EMAIL PROTECTED] wrote:

 **
 Plugin-Filter-API-Threads: was the setting I was looking for this morning
 but couldn't remember.. FAIW, I got my numbers a little higher than what you
 got though.. something like min of 7 amd max of 15.

 Joe

  --
 *From:* Jase Brandon [EMAIL PROTECTED]
 *To:* arslist@ARSLIST.ORG
 *Sent:* Thursday, November 20, 2008 12:59:23 PM
 *Subject:* Re: SW00247290 - Death of the Plugin Server

 **
  here is the part that's perplexing me all, I can see in the armonitor.log
 that plugin.exe was started with success.
 I can see plugin.exe running in the task mgr, looks fine.
 But the server admin console keeps getting ARDBCAPPQUERY doesn't exist
 and the overview console keeps getting dbase timeout errors.
 I attached a copy of our dev ar.cfg file if anyone wants to take a peek.
 We reinstalled server.exe for 7.1 Patch 002 in hopes this would set
 arplugin.exe back to original config.
 After that didn't work, We have replaced .dlls for ardbcquery.dll in all
 the paths for asset/change/incident/cmdb with the .dlls from ITSM 7 Patch 8,
 We have ITSM 7 Patch 3 and support suggested those replacements, and it
 didn't work either.
 Joe mentioned the below on an old thread I found

 I added this line and got the plugins to work.





 Plugin-Filter-API-Threads: 2 6





 Where 2 represents minimum threads and 6 max.. You can set your min and max
 to whatever you might want to set it to till you get it working..
 Going to try this now in ar.cfg and see if that helps.

 Any ideas anyone? I am stumped..

 Thanks,

 Jase

   On Thu, Nov 20, 2008 at 11:22 AM, Jase Brandon [EMAIL PROTECTED]wrote:

   Joe,
 That would be great! Can you please send me the settings you used to fix
 this issue?

 Thanks In Advance,

 Jase

On Thu, Nov 20, 2008 at 10:39 AM, Joe DeSouza [EMAIL PROTECTED]wrote:

 **
  It could also mean you are running out of Filter-API threads.. I forget
 what the option to configure that is in the ar.cfg file, but I could get you
 that information in about an hour from the settings I have on my server that
 fixed a similar error for me.

 Cheers

 Joe

   --
 *From:* Axton [EMAIL PROTECTED]
 *To:* arslist@ARSLIST.ORG
 *Sent:* Thursday, November 20, 2008 10:16:40 AM

 *Subject:* Re: SW00247290 - Death of the Plugin Server

 This means the plugin server crashed.  I either generate a core file or
 attach a debugger to the plugin server to see what the stack trace is when
 it crashed, then report the results to bmc.  Not sure how/if you w/could do
 this on windows.  The plugin server logs may be revealing as 

Re: Very Urgent: Need to show formatted worklog in report

2008-11-24 Thread Manish SINGLA
Thanks Rfrench for the response,

Let me explain you in detail. I am reporting directly from Remedy DB from
table itself. 
Now need is to show 'worklog' formated at report level: 

Worklog reciving from DB is :

---
1227025800 YOANN DURAND Initial Description is : Dear all,
Is it possible to allocate temporary more space on this FS :
Filesystem kbytes used avail capacity Mounted on
nfsadd2:/add/export/stdf
667315863 619796365 44609217 94% /firms/import/stdf
I create a critical ticket because I think the oncall
team will be certainly impact tonight when the FS inscrease until 95%
Yoann DP 1227094792 BOUDRY Managed by system team
crx109
BR.
1227096348 DELSOLP Done yesterday by P. Desjouis

---

Worklog need to be shown is : 

---
11/19/2008 5:35:48 PM DELSOLP
Done yesterday by P. Desjouis

11/19/2008 5:09:52 PM BOUDRY
Managed by system team-- crx109
BR.


11/18/2008 10:00:00 PM YOANN DURAND
Initial Description is : Dear all,
Is it possible to allocate temporary more space on this FS :
Filesystemkbytesused   avail capacity  Mounted on
nfsadd2:/add/export/stdf
 667315863 619796365 4460921794%
/firms/import/stdf
I create a critical ticket because I think the on-call team will be
certainly impact tonight when the FS inscrease until 95%
Yoann DP


---

Here major emphesis is on Date field value.

I hope it clearifies.

Regards
Manish

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of RFrench
Sent: Tuesday, November 25, 2008 1:41 AM
To: arslist@ARSLIST.ORG
Subject: Re: Very Urgent: Need to show formatted worklog in report

Your question is not clear.

What view and field are you looking, what value do you see in the form, and
what value do you see in the table?

Are you going direct to the tables, or using the OBDC link?
--
View this message in context:
http://www.nabble.com/Very-Urgent%3A-Need-to-show-formatted-worklog-in-repor
t-tp20656123p20668759.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

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