AREmail and performance questions
Hey ARSListers, Here is my understanding of the aremail engine: Data gets put into the AR System Email Engine The remedy e-mail process polls on a specified interval to see if there are any e-mails to be sent or recieved Remedy processes the e-mails at whatever chunk size you specify in the EmailDaemon.properties file. It is my understanding that this is a single thread for processing outgoing messages. I am trying to maximize the performance of the e-mail engine ... so here are my questions: Does setting the Alert thread do anything for the performance of the email engine or does that only affect Remedy Alerts? Does specifying more than one outgoing e-mail smtp server increase performance of the e-mail engine? Any other tweeks that might help in that arena? Our concern is the timliness in which e-mails are sent out from the system. Especially if you send a lot at once for a major outage. Thanks, Sean P.S. Please don't respond about alarm point, etc. We are aware of it and are looking into it ... I just want to know about the current design of the remedy e-mail engine. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Job Opportunity - Senior Remedy Developer-Atlanta,GA
For more information and to apply ... go here. http://jobview.monster.com/getjob.asp?JobID=57780056JobTitle=Software+Developer++-+Remedyq=Remedyjto=1sid=24brd=1cy=USvw=bAVSDM=2007-05-18+13%3a28%3a00 Thanks, Sean Garrison ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: ORA-00942: table or view does not exist
It looks like one of 2 things are going on 1you removed a field with id of 536870914 but it still exists in the view or 2 the view is referencing field 536870914 but does not exist in the underlying table. Either one true? Thanks, Sean Shellman, David [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 05/30/2007 07:16 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject ORA-00942: table or view does not exist ** I was updating a table last night with a def file. I ran into problems with some of the fields. Odd errors that didn't make sense like ORA-00904: C536870914: invalid identifier. Being a good admin, I exported the forms before I made the update. I'm still getting the invalid identifier errors but I'm also getting the ORA-00942 errors. It looks like with the update, the table was renamed to 140A as I would have expected but we ran out of temp space and the process didn't complete. We're stuck and can't update the form because it sort of doesn't exist from the admin tool perspective. I can see the form. I can open it. I can add or delete a field but the saves error because the view doesn't exist. Anyone run across this situation before? I think I understand what we need to do but It's been a long night so I need folks to look over my shoulder while support is pouring over the arerror and sql log files. Here's what I think we need to do: Shut down the app server. Back up the database. Rename the 140A table to 140. Reapply the definition files to back out the failed changes. Lack of sleep has made my brain fuzzy but does this sound like what needs to be done? Dave Dave Shellman Phone: (717) 810-3687 Fax:(717) 810-2124 email: [EMAIL PROTECTED] tyco/Electronics A tyco International LTD Company MS 161-043 PO Box 3608 Harrisburg, PA 17105-3607 __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Regular Expressions in AR 7.0.01
I have done this via several means ... one is via a arfilter api that is out there (I think it is called arfperl) ... the other is via a Run process command to a set fields action... Set Fields to a temp field @@:$PROCESS$ /pathtoperlscript/script.pl parameters There is also a java arfilter api out there that will let you do this. I have never tried it. Both are done at the filter level. Thanks, Sean ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Strange behavior on Table Refresh - 7.0.1 patch 1
Has anyone noticed this ... I have a form b that contains a table field table 1 that references form a. I have an active link on form b that does a push fields to form a on Return/Double Click and then does a table refresh on table 1. What I noticed happening is that the table is being refreshed before all of the filters on a are processed. Sometimes my updates do not show up and sometimes they do. Is there a way to force a wait on the table refresh until all of the filters have been processed? Thanks, Sean ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Hover text on Trim fields - Is it Possible? Any Takers?
Have you tried doing the same thing but using a Display-only character field
(instead of a text field)??? There is a checkbox on there to Display as
Text if you need it ...
Thanks,
Sean
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Lucero, Michelle - IST contractor
Sent: Friday, January 05, 2007 10:58 AM
To: arslist@ARSLIST.ORG
Subject: Hover text on Trim fields - Is it Possible? Any Takers?
Anyone?
_
From: Lucero, Michelle - IST contractor
Sent: Thursday, January 04, 2007 1:28 PM
To: 'arslist@ARSLIST.ORG'
Subject: Hover text on Trim fields - Is it Possible?
Hey, Y'all:
Environment:
Remedy ARS 6.3 P18 (Windows 2003, SQL Server 2000)
Mid-Tier 7.0.0 Patch 1 (IIS/Servlet Exec)
Mid-Tier 7.0.1 (IIS/Tomcat)
I was able to use a simple JavaScript command in a run process AL to
produce hover text over a character field. There is no need for a
JavaScript file. I like to avoid hard coded text wherever I can.
This fires on Window Loaded as a run process and works great on
character fields
//javascript:document.getElementById('arid536870998').title = 'My
text'; (without the slashes)
However, I would like to be able do the same thing over a Text Trim
field.
We have a psuedo navigation bar with subtitles. We would like to add
tooltips to these.
So far, nothing I've tried, including a hard-coded js file works on
Text Trim, nor buttons for that matter.
Has anyone ever been able to produce hover (aka alternative or
mouse-over) text on trim fields?
On a side note:
The good news is that in ARS 7.0.1 and Mid-Tier 7.0.1, buttons and
Flashboards now have an alternative text attribute accessible
through the Admin Tool.
Thanks in advance,
Michelle
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the
Answers Are
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the
Answers Are
Re: Hover text on Trim fields - Is it Possible? Any Takers?
Unfortunately there is nothing for mouse-over that I am aware of. The
closest thing is Lose Focus or Gain Focus. Workflow can fire when a
field has focus (i.e. the user clicks on the character field, box, button,
etc.). Or when the field has lost focus ...
Also ... If have added help text to a field there is an arrow with a
question mark on the user tool. If you click that and click on the field
all of the help text you enter on the field will show up in the user tool.
Good luck.
Thanks,
Sean
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Lucero, Michelle - IST contractor
Sent: Friday, January 05, 2007 12:27 PM
To: arslist@ARSLIST.ORG
Subject: Re: Hover text on Trim fields - Is it Possible? Any Takers?
Hi, Sean:
Thank you for responding.
Yep, I've tested that, too. It appears to work for fields that actually
have the white space for entering text, but not for fields that
display as text. It seems to behave just like the text trim fields so
it doesn't work. It only works when I don't display as text.
Also, in our case the text has to be a certain color, etc. I know I
have a couple of workarounds for that, too.
One of the workarounds I have for text color is to make the field label
dynamic, while making the data length 0.
I've only been able to hover over a field label using a call to a js
file.
My preference is to NOT use a file that has to be carried from server to
server. Or, where the actual text and field IDs have to be hard coded.
I would prefer to use a single run process statement that I can make a
little more dynamic.
So we're back to square one.
The text has to be a certain color and it has to allow hover text.
I may get desperate and use the hard-coded js file. However, it still
doesn't solve the problem on how to get the hover to work on trim
fields.
Thank you again for taking the time.
Michelle
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Sean Garrison
Sent: Friday, January 05, 2007 10:24 AM
To: arslist@ARSLIST.ORG
Subject: Re: Hover text on Trim fields - Is it Possible? Any Takers?
Have you tried doing the same thing but using a Display-only character
field
(instead of a text field)??? There is a checkbox on there to Display
as
Text if you need it ...
Thanks,
Sean
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Lucero, Michelle - IST
contractor
Sent: Friday, January 05, 2007 10:58 AM
To: arslist@ARSLIST.ORG
Subject: Hover text on Trim fields - Is it Possible? Any Takers?
Anyone?
_
From: Lucero, Michelle - IST contractor
Sent: Thursday, January 04, 2007 1:28 PM
To: 'arslist@ARSLIST.ORG'
Subject: Hover text on Trim fields - Is it Possible?
Hey, Y'all:
Environment:
Remedy ARS 6.3 P18 (Windows 2003, SQL Server 2000)
Mid-Tier 7.0.0 Patch 1 (IIS/Servlet Exec)
Mid-Tier 7.0.1 (IIS/Tomcat)
I was able to use a simple JavaScript command in a run process AL to
produce hover text over a character field. There is no need for a
JavaScript file. I like to avoid hard coded text wherever I can.
This fires on Window Loaded as a run process and works great on
character fields
//javascript:document.getElementById('arid536870998').title = 'My
text'; (without the slashes)
However, I would like to be able do the same thing over a Text Trim
field.
We have a psuedo navigation bar with subtitles. We would like to add
tooltips to these.
So far, nothing I've tried, including a hard-coded js file works on
Text Trim, nor buttons for that matter.
Has anyone ever been able to produce hover (aka alternative or
mouse-over) text on trim fields?
On a side note:
The good news is that in ARS 7.0.1 and Mid-Tier 7.0.1, buttons and
Flashboards now have an alternative text attribute accessible
through the Admin Tool.
Thanks in advance,
Michelle
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where
the
Answers Are
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where
the Answers Are
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the
Answers Are
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the
Answers Are
Updating worklog entries via SQL
I am trying to update a work log field via SQL. In looking at the database I can see that the entries look like this: date.username.work log entry ... but when I duplicate this via sql it doesn't seem to recognize the entry. It appears that it puts some special character at the end to terminate it. Anyone know what this is or how I can update diary entries via SQL? Example SQL I am trying: UPDATE WR_REQUESTOR SET DIARY_FIELD = DIARY_FIELD || (SELECT CREATE_DATE FROM WR_AM WHERE ENTRY_ID = $ENTRY_ID$) || '.$Submitter$.Note Type $Note Type$ Note Description $Note Description$' WHERE WORK_REQUEST = 'WR0001' Any ideas? Thanks, Sean ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Problem w/ SLB and Mid-Tier 6.3
We have a web server (1.1.1.1) which is behind an slb (2.2.2.2). We have configured it so that the web server (1.1.1.1) can communicate clear text over port 8080. On the SLB (2.2.2.2) we have set it so that it handle all ssl connectivity to web server 1.1.1.1. So that when you connect like this: https://2.2.2.2 you are actually connecting to http://1.1.1.1:8080. So here is the issue: Mid-Tier works if I connect to https://1.1.1.1 directly. It also works if I connect to http://1.1.1.1:8080 directly. If I connect to https://2.2.2.2 it doesn't work. If I remember right there was some sort of translation in Mid-Tier 5.1.2 that resolved this. Is there something similar in Mid-Tier 6.3 Thanks, Sean ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Color change on table row
You have a hidden radio field that contains the entries red, green , yellow ... whatever colors you want. In the admin tool you associate the colors with the radio field you just created. Form-CurrentView-Properties ... Results List Color Tab Then you generate workflow to set the colors to whatever you want based on conditions ... For example: Build an escalation that says if it is 15 mins before deadline ... set the radio button to red ... that should cause the color to change to red. Thanks, Sean -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sarah Lake Sent: Tuesday, November 28, 2006 10:55 AM To: arslist@ARSLIST.ORG Subject: Color change on table row Hi Listners, Can and how one can change color of table row depending upon coditions ? e.g. If 15 min left to target deadline make it Red color row in table. Thanks ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Wierd Problem
** Is he getting assigned a floating license? You could have run out of floating licenses on the server.. Thanks, Sean -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Anoop Sasidharan Sent: Monday, November 27, 2006 11:22 AM To: arslist@ARSLIST.ORG Subject: Wierd Problem Listers, I am facing a problem with one of the user. He connects to 2 Remedy server, thru one server he connects to the asset application and through the other he connects to the Helpdesk application. While Logging in he checks both the server. When he tries to reassign helpdesk tickets, he gets the error message saying that he doesn't have permission to reassign the tickets, However he has app-management permissions. I have checked with another user who has similar permission as this user and it works fine for him. I tried reinstalling Remedy user on his machine and it worked for few days before the problem started again.I have also tried to readd his account, but that too doesn't work. Any suggestions? Thanks Anoop _ Search from any Web page with powerful protection. Get the FREE Windows Live Toolbar Today! Try it now! http://toolbar.live.com/?mkt=en-in __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: [Soap Question] Problem with the = in a query resolved ... sort of
Ok ... the lt; worked. Thank you so much for your help. Now when I
actually get the search results the first row is missing ...
For example:
I am running this query in Soap:
('dt_Creation Date' = 09/01/2006 00:00:00 AM) AND ('rad_Severity' = 1.)
AND ('rad_Status' lt;= Pending)
It yields 6 results.
If I run the same query in Remedy:
('dt_Creation Date' = 09/01/2006 00:00:00 AM) AND ('rad_Severity' = 1.)
AND ('rad_Status' = Pending)
I get 7 results. The first row seems to be missing every time. So I have
assumed it was my code ...
so here is my soap code that prints out the values:
my $response = $soap-OpGetList($header,$inputData);
#Check for Errors
if (soapErrorCheck($response) == 0) {
# Process each of the records
foreach my $row($response-paramsout()) {
print($row-{'txt_Service_Event'}. );
print($row-{'txt_Description'}.\n);
}
}
Am I missing something?
Any input would be greatly appreciated.
Thanks,
Sean
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black
Sent: Monday, October 02, 2006 11:39 PM
To: arslist@ARSLIST.ORG
Subject: Re: [Soap Question] Problem with the = in a query
Sean,
I have not tested this...
But I think your first dealing with an XML issue.
lt; instead of
Now if ARS will understand that... well that might be a different problem.
:)
--
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 10/2/06, Sean Garrison [EMAIL PROTECTED] wrote:
Hello listers,
I have a quick question about Soap. We have a soap interface we are
running and when I pass in a qualification like this:
'rad_Status' = Pending I get an error:
Fault: org.xml.sax.SAXParseException: The content beginning = is not
legal markup. Perhaps the = (#3d;) character should be a letter.
Detail:
I have tried using the html equivalent:
'rad_Status'%3C%3D%20%22Pending%22
Which yields a Bad Qualification error. I have also tried escaping the
value:
'rad_Status' \= Pending
That didn't doesn't work either.
Anyone have any idea on how to get around this?
Thanks,
Sean
___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: [Soap Question] Problem with the = in a query resolved ... sort of
Thanks Carey for your help. Unfortunately this time it did not resolve the
issue. I'm beginning to think there is either a bug with the soap interface
(SOAP::Lite) or with web services.
Here is the code change:
if (soapErrorCheck($response) == 0) {
# add this to get a full array of the results
my @params = $response-paramsout;
# Process each of the records
foreach my $row(@params) {
print($row-{'txt_Service_Event'}. );
print($row-{'txt_Description'}.\n);
}
}
It still yields 6 results.
I am running this query in Soap:
('dt_Creation Date' = 09/01/2006 00:00:00 AM) AND ('rad_Severity' = 1.)
AND ('rad_Status' lt;= Pending)
It yields 6 results.
Txt_Service_Event rad_Status txt_Description
2 Pending
3 Re-Opened
4 Pending
5 Re-Opened
6 Pending
7 Pending
If I run the same query in Remedy:
('dt_Creation Date' = 09/01/2006 00:00:00 AM) AND ('rad_Severity' = 1.)
AND ('rad_Status' = Pending)
I get seven results:
Txt_Service_Event rad_Status txt_Description
1 Pending
2 Pending
3 Re-Opened
4 Pending
5 Re-Opened
6 Pending
7 Pending
I was wondering if anyone else had run into a similar issue I am
running ARS 6.3 patch 17 on solaris.
Thanks,
Sean
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black
Sent: Tuesday, October 03, 2006 12:38 PM
To: arslist@ARSLIST.ORG
Subject: Re: [Soap Question] Problem with the = in a query resolved ...
sort of
Sean,
That looks like Perl, SOAP::Lite to me... :) So forgive me if I have
made a bad assumption...
Reed up on the SOAP::Lite module...
IN/OUT, OUT PARAMETERS AND AUTOBINDING
SOAP::Lite gives you access to all parameters (both in/out and out)
and also does some additional work for you. Lets consider following
example:
mehodResponse
res1name1/res1
res2name2/res2
res3name3/res3
/mehodResponse
In that case:
$result = $r-result; # gives you 'name1'
$paramout1 = $r-paramsout; # gives you 'name2', because of
scalar context
$paramout1 = ($r-paramsout)[0]; # gives you 'name2' also
$paramout2 = ($r-paramsout)[1]; # gives you 'name3'
or
@paramsout = $r-paramsout; # gives you ARRAY of out parameters
$paramout1 = $paramsout[0]; # gives you 'res2', same as ($r-paramsout)[0]
$paramout2 = $paramsout[1]; # gives you 'res3', same as ($r-paramsout)[1]
So I think you should do this...
if (soapErrorCheck($response) == 0) {
# add this to get a full array of the results
@paramsout = $response-paramsout;
# Process each of the records
# foreach my $row($response-paramsout()) { # incorrect use of
--paramsout ?
foreach my $row(@paramsout) {
print($row-{'txt_Service_Event'}. );
print($row-{'txt_Description'}.\n);
}
}
Maybe there is a more compact syntax than the above, but the above
might also be clearer for the next person too.
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 10/3/06, Sean Garrison [EMAIL PROTECTED] wrote:
Ok ... the lt; worked. Thank you so much for your help. Now when I
actually get the search results the first row is missing ...
For example:
I am running this query in Soap:
('dt_Creation Date' = 09/01/2006 00:00:00 AM) AND ('rad_Severity' =
1.)
AND ('rad_Status' lt;= Pending)
It yields 6 results.
If I run the same query in Remedy:
('dt_Creation Date' = 09/01/2006 00:00:00 AM) AND ('rad_Severity' =
1.)
AND ('rad_Status' = Pending)
I get 7 results. The first row seems to be missing every time. So I have
assumed it was my code ...
so here is my soap code that prints out the values:
my $response = $soap-OpGetList($header,$inputData);
#Check for Errors
if (soapErrorCheck($response) == 0) {
# Process each of the records
foreach my $row($response-paramsout()) {
print($row-{'txt_Service_Event'}. );
print($row-{'txt_Description'}.\n);
}
}
Am I missing something?
Any input would be greatly appreciated.
Thanks,
Sean
___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: [Soap Question] Problem with the = in a query resolved ... sort of
To make it easier I've included the whole function:
sub soapGetList{
my $soap = shift;
my $user = shift;
my $pass = shift;
my $query = shift;
# Initialize the Header
my $header = SOAP::Header-name(
'AuthenticationInfo', { userName = $user, password = $pass , locale =
en_US, timezone = EST}
);
# Pass the Request_ID of the ticket
my $inputData = SOAP::Data-new(
name = 'Qualification',
value = $query,
type = 'xsd:string'
);
my $response = $soap-OpGetList($header,$inputData);
if (soapErrorCheck($response) == 0) {
# add this to get a full array of the results
my @params = $response-paramsout;
# Process each of the records
foreach my $row(@params) {
print($row-{'txt_Service_Event'}. );
print($row-{'txt_Description'}.\n);
}
}
return (0);
}
Actual Data:
Service Event+ Status Description Creation Date
SE01631976 Pending Desc1 9/5/2006 16:38
SE01634780 Pending Desc2 9/8/2006 11:35
SE01636647 Re-Opened Desc3 9/11/2006 9:32
SE01643964 Pending Desc4 9/18/2006 9:09
SE01644297 Re-Opened Desc5 9/18/2006 12:40
SE01650246 Pending Desc6 9/24/2006 12:05
SE01656135 Pending Desc7 10/1/2006 2:31
SE01658513 AcceptedDesc8 10/3/2006 15:26
The record that is not being returned is SE01631976.
The timezone really wouldn't matter because the earliest date from the
results is 9/5/2006 4:38:03 PM
Sean
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black
Sent: Tuesday, October 03, 2006 4:02 PM
To: arslist@ARSLIST.ORG
Subject: Re: [Soap Question] Problem with the = in a query resolved ...
sort of
Sean,
Ok... then my next guess would be it is a timezone issue. :)
Does your web Service client specify what timezone the client is in in
the header information?
Could it be that one less record is due to how 09/01/2006 00:00:00
AM is interpreted in the User Tool vs Web Services client?
Can you list the values from each client for the tickets involved and
see if they values agree?
--
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 10/3/06, Sean Garrison [EMAIL PROTECTED] wrote:
Thanks Carey for your help. Unfortunately this time it did not resolve
the
issue. I'm beginning to think there is either a bug with the soap
interface
(SOAP::Lite) or with web services.
Here is the code change:
if (soapErrorCheck($response) == 0) {
# add this to get a full array of the results
my @params = $response-paramsout;
# Process each of the records
foreach my $row(@params) {
print($row-{'txt_Service_Event'}. );
print($row-{'txt_Description'}.\n);
}
}
It still yields 6 results.
I am running this query in Soap:
('dt_Creation Date' = 09/01/2006 00:00:00 AM) AND ('rad_Severity' =
1.)
AND ('rad_Status' lt;= Pending)
It yields 6 results.
Txt_Service_Event rad_Status txt_Description
2 Pending
3 Re-Opened
4 Pending
5 Re-Opened
6 Pending
7 Pending
If I run the same query in Remedy:
('dt_Creation Date' = 09/01/2006 00:00:00 AM) AND ('rad_Severity' =
1.)
AND ('rad_Status' = Pending)
I get seven results:
Txt_Service_Event rad_Status txt_Description
1 Pending
2 Pending
3 Re-Opened
4 Pending
5 Re-Opened
6 Pending
7 Pending
I was wondering if anyone else had run into a similar issue I am
running ARS 6.3 patch 17 on solaris.
Thanks,
Sean
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black
Sent: Tuesday, October 03, 2006 12:38 PM
To: arslist@ARSLIST.ORG
Subject: Re: [Soap Question] Problem with the = in a query resolved ...
sort of
Sean,
That looks like Perl, SOAP::Lite to me... :) So forgive me if I have
made a bad assumption...
Reed up on the SOAP::Lite module...
IN/OUT, OUT PARAMETERS AND AUTOBINDING
SOAP::Lite gives you access to all parameters (both in/out and out)
and also does some additional work for you. Lets consider following
example:
mehodResponse
res1name1/res1
res2name2/res2
res3name3/res3
/mehodResponse
In that case:
$result = $r-result; # gives you 'name1'
$paramout1 = $r-paramsout
[Soap Question] Problem with the = in a query
Hello listers, I have a quick question about Soap. We have a soap interface we are running and when I pass in a qualification like this: 'rad_Status' = Pending I get an error: Fault: org.xml.sax.SAXParseException: The content beginning = is not legal markup. Perhaps the = (#3d;) character should be a letter. Detail: I have tried using the html equivalent: 'rad_Status'%3C%3D%20%22Pending%22 Which yields a Bad Qualification error. I have also tried escaping the value: 'rad_Status' \= Pending That didn't doesn't work either. Anyone have any idea on how to get around this? Thanks, Sean ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Increase Performance Remedy 6
I know they did some oracle specific settings to make it faster: Server-Side-Table-Chunk-Size: 1 Next-ID-Commit: T Oracle-Cursor-Sharing: FORCE Oracle-Search-On-Clob: T Oracle-Bulk-Fetch-Count: 100 Clustered-Index: T I am not sure about DB2 you will have to look at the Configuring AR System manual. Also you need to look at your workflow to make sure everything is running on an index. Remedy Developer plus can help with that. We no longer run help desk here but if I remember right not everything was indexed properly. Also you might want to encourage users to uncheck the Refresh Contents on Display this helps when refreshing tables when you click from record to record. In addition training users to build searches that are indexed helps a lot. Thanks, Sean -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of dcharters Sent: Wednesday, September 06, 2006 4:15 PM To: arslist@ARSLIST.ORG Subject: Re: Increase Performance Remedy 6 So what is your processor at? Is your RAM and Processor at 100% on the application or database server? On Wed, 6 Sep 2006 19:05:46 -, [EMAIL PROTECTED] wrote before to find out the other points you asked me well, It's a Unix Server AIX 5.3 Remedy 6 Help desk 6.3 Websphere 5.1 DB2 8.1 __ _ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org -- Open WebMail Project (http://openwebmail.org) ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
[AREmail] Constantly stopping and starting ....
We have an issue with AREmail constantly starting and stopping. Here are the errors in the error log: javax.mail.MessagingException: 421 rca.mail.pas.earthlink.net: SMTP command timeout - closing connection at com.sun.mail.smtp.SMTPTransport.issueCommand(SMTPTransport.java:923) at com.sun.mail.smtp.SMTPTransport.mailFrom(SMTPTransport.java:643) at com.sun.mail.smtp.SMTPTransport.sendMessage(SMTPTransport.java:322) at com.remedy.arsys.emaildaemon.SenderModule.sendMessage(SenderModule.java:74) at com.remedy.arsys.emaildaemon.CreatorModule.createMessage(CreatorModule.java: 1489) at com.remedy.arsys.emaildaemon.CreatorModule.doWork(CreatorModule.java:360) at com.remedy.arsys.emaildaemon.ThreadBase.run(ThreadBase.java:268) at java.lang.Thread.run(Thread.java:534) Aug 15, 2006 3:56:47 PM com.sun.mail.smtp.SMTPTransport sendCommand SEVERE: Can't send command to SMTP host; nested exception is: java.net.SocketException: Broken pipe javax.mail.MessagingException: Can't send command to SMTP host; nested exception is: java.net.SocketException: Broken pipe at com.sun.mail.smtp.SMTPTransport.sendCommand(SMTPTransport.java:953) at com.sun.mail.smtp.SMTPTransport.sendCommand(SMTPTransport.java:941) at com.sun.mail.smtp.SMTPTransport.issueCommand(SMTPTransport.java:918) at com.sun.mail.smtp.SMTPTransport.mailFrom(SMTPTransport.java:643) at com.sun.mail.smtp.SMTPTransport.sendMessage(SMTPTransport.java:322) at com.remedy.arsys.emaildaemon.SenderModule.sendMessage(SenderModule.java:74) at com.remedy.arsys.emaildaemon.CreatorModule.createMessage(CreatorModule.java: 1489) at com.remedy.arsys.emaildaemon.CreatorModule.doWork(CreatorModule.java:360) at com.remedy.arsys.emaildaemon.ThreadBase.run(ThreadBase.java:268) at java.lang.Thread.run(Thread.java:534) Aug 15, 2006 3:56:47 PM com.sun.mail.smtp.SMTPTransport sendCommand Any Hints at what the problem could be? Thanks, Sean ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Remedy Training - Atlanta
Restaurants Suggestions: Fogo De Chao (but only if you are a carnivore also only if you are on per diem :-) http://www.mapatlanta.com/atlanta_fogodechao.html Atlanta Fish Market If You like seafood:(also only if you are on per diem :-) http://www.buckheadrestaurants.com/afm.html And Mary Macs for some good southern cookin: http://www.marymacs.com/ Tamarind For Thai: http://atlanta.citysearch.com/profile/3001272 Figo for Pasta: http://atlanta.citysearch.com/profile/35196428/ And Kool Korners for the Best Cuban Sandwich anywhere ... http://atlanta.citysearch.com/profile/11555119/atlanta_ga/kool_korners_groce ry.html Sean -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ken LaPierre Sent: Wednesday, May 10, 2006 1:25 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy Training - Atlanta http://www.gladysandron.com/ - Original Message - From: Mayfield, Andy L. [EMAIL PROTECTED] Date: Wednesday, May 10, 2006 1:21 pm Subject: Re: Remedy Training - Atlanta To: arslist@ARSLIST.ORG Waffles and Chicken? I am not familiar with that one. Andy L. Mayfield System Operation Specialist Alabama Power Company Office: 8-226-1805 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ken LaPierre Sent: Wednesday, May 10, 2006 12:08 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy Training - Atlanta Make sure hit the local waffles and chicken. Ken - Original Message - From: Thomas Altamore [EMAIL PROTECTED] Date: Wednesday, May 10, 2006 12:21 pm Subject: Re: Remedy Training - Atlanta To: arslist@ARSLIST.ORG Hi Andy, Times like these it pays to explore options using Expedia.com. You'll get back a lot of listings with a variety of pricing. Don't forget to inquire with Remedy's Educational dept as they usually arrange for discounted prices on rooms at nearby hotels (usually very nice). As for food, I like to eat well, and I like to eat cheap. The best method is a very simple one. Check the net for cooking schools in Atlanta,Call them up and make an inquiry into inexpensive but quality eateries. I did this with San Francisco and was directed to a great restaurant that served a $15 3-course price fixed meal. It was great. Every city has gems and so far I've found that to be the best way to find them. Also the Food Network has a website and you can check the archives of the $40 A Day show that feaures where to get Breakfast, Lunch, and Dinner for $40/day. I believe Atlanta was a recent city featured.Hope this helps. Best Regards Thomas Altamore Remedy System Developer Emerging Health Information Technology 100 Corporate Drive Yonkers, N.Y. 10701 Office: 914-378-6689 [EMAIL PROTECTED] 05/10/06 11:57 AM Good Morning All: I am going to be attending a training class (ARS 6.X admin Part 2) at the new training center in Atlanta. I was wondering if anyone was familiar with the area and had any hotel/restaurant recommendations. The address of the training center is: BMC Software 1200 Abernathy Rd Suite 200 Thanks in advance for any feedback. Andy L. Mayfield System Operation Specialist Alabama Power Company Office: 8-226-1805 ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: ARF Perl PLugin
Plugin logging isn't going to tell you much never has btw because it is just like running perl from the shell. All it does is tell you if it ran or not. The way I did it was to do a Set Fields to a 'Script' field. Then I passed it into the ARFPerl filter. I could tell what I was passing in by looking at the filter logs. I could then run the script if I needed to by cutting the contents of 'Script' to a temp.pl file. Thanks, Sean -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jarl Grøneng Sent: Friday, May 05, 2006 12:44 PM To: arslist@ARSLIST.ORG Subject: Re: ARF Perl PLugin Have you tried to enable plugin logging? -- Jarl On 5/5/06, Grooms, Frederick W [EMAIL PROTECTED] wrote: The Perl code. I would like to be able to log the field values passed into the perl code (In the filter log I can see when I set the DO field of the actual perl code but not the values of the data passed in) -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jarl Grøneng Sent: Thursday, May 04, 2006 11:47 PM To: arslist@ARSLIST.ORG Subject: Re: ARF Perl PLugin Logging of the plugin-code or logging of the perl-code running trough the plugin? -- Jarl On 5/4/06, Grooms, Frederick W [EMAIL PROTECTED] wrote: Has anyone using the ARFPerl plugin added any logging to their perl code? Fred ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
