date:20060915

DSO follow-the-sun examples

2006-09-15 Thread arslist

Hi James, Alexander, and L. J. Head,

Thanks for your responses, I appreciate it.

Nevertheless, does someone knows about some concrete example of sites where DSO 
works with several servers in a follow-the-sun
mode? Which ones?

If I have some examples it's easier to convince the person.

I would be frustrated if they choose another tool than DSO for this ...
I am just consultant and we are not saling licenses, but just consultancy.
I don't want to have to implement something else than DSO...to make replication 
between ARS servers it would be an aberration in
my point of view.

Thanks again.

Ilidio Moreira da Silva
SILOGIS

"Alexander G. Zinoviev" a écrit :

> Hi,
>
> If you have wide DSO private thread (I have up to 16 threads), you have to 
> make some calculations.
> DSO speed depends mostly of remote response time.
>
> I have response time (ping xxx.xxx.xxx.xxx) less then 10 ms (same subnet) and 
> my DSO speed is 300-500 requests per a minute.
>
> Best regards,
> Alexander Zinoviev
> 
>
> ïÔ: Action Request System discussion list(ARSList) ÏÔ ÉÍÅÎÉ arslist
> ïÔÐÒÁ×ÌÅÎÏ: þÔ, 14.09.2006 13:08
> ëÏÍÕ: arslist@ARSLIST.ORG
> ôÅÍÁ: DSO performances
>
> Hi Dear ARS experts,
>
> I have a customer who is fearing about the DSO performances: he never
> saw it yet but someone told him some things like this...a competitor
> surely...
>
> The target is to make different ticketing servers repilcating submit,
> changes and deletions in a "follow the sun mode" all around the world
> (about 4 or 5 servers in different continents).
>
> Does someone of you know one or more similar examples of implementations
> that are running fine in a "follow the sun" mode?
> I would appreciate that.
> I beleive DSO is the best solution for him but I need to convince him.
>
> He asked me also about a product called "Golden Gate"...?!
> Does someone have an experience with this tool?
>
> Kind Regards.
>
> Ilidio Moreira da Silva
>
> ___
> 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

Webservcies GetListOutputMap/GetListInputMap

2006-09-15 Thread Gerold Glaser

Dear Listeners!

I'm playing with webservices and Remedy 6.3 and tried to test the examples
mentioned in the knowledgebase. Especially the examples about a java client
with apache axis. In this exampels they are always mention the classes
GetListOutputMap/GetListInputMap. But I can't find the implementation.

Can you please send me the java source for this two classes or tell me where
I can get them.

Best regards,

Gerry

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

Re: How to capture workflow errors in Filters

2006-09-15 Thread Misi Mladoniczky

Hi!

It all depends on what you mean by "capture".

1. If you are programming an API-program, you can will get the error
message, and can code according to the message list returned.

2. You can capture errors in logfiles. Any failed API-calls will have the
text FAIL attached to the ending API-row in the logfile. Put filters/sql
in the same logfile, and you will be able to see what happened.

3. You can send ERROR-messages to ARUser, to prompt the user to fix a
problem and re-save

4. Errors occuring in Filters can usually be circumvented by doing some
tests by creating additional filters. Instead of an ERROR-message, you can
do separate actions that can handle the situation.

Best Regards - Misi, RRR AB, http://www.rrr.se

> Hi,
>
>
>
> All of the my workflows are written in filters..the problem is all
> filters are rolling back when there is any error occurred in any one of
> the filter..
>
> Could you please help me on how to capture errors occurred in filter..
>
>
>
> Any tips would be appreciated.
>
>
>
> Thanks and Regards,
>
> Gopala Krishna.Peela
>
>
>
>
>
>
>
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
>

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

Re: How to capture workflow errors in Filters

2006-09-15 Thread Carlos Ungil

Hello,

you can also send a mail notification just before signaling the error
(I find this very useful to know when users are doing something
they're not supossed to do).

To avoid the notification being deferred to a later phase (which will
never come), you have to change the name of the filter so it ends with
"`!" ( back quote + exclamation mark )

See "Overriding filter processing phasing" in the Basic Guide.

Cheers,

Carlos

On 9/15/06, Misi Mladoniczky <[EMAIL PROTECTED]> wrote:

Hi!

It all depends on what you mean by "capture".

1. If you are programming an API-program, you can will get the error
message, and can code according to the message list returned.

2. You can capture errors in logfiles. Any failed API-calls will have the
text FAIL attached to the ending API-row in the logfile. Put filters/sql
in the same logfile, and you will be able to see what happened.

3. You can send ERROR-messages to ARUser, to prompt the user to fix a
problem and re-save

4. Errors occuring in Filters can usually be circumvented by doing some
tests by creating additional filters. Instead of an ERROR-message, you can
do separate actions that can handle the situation.

Best Regards - Misi, RRR AB, http://www.rrr.se

> Hi,
>
>
>
> All of the my workflows are written in filters..the problem is all
> filters are rolling back when there is any error occurred in any one of
> the filter..
>
> Could you please help me on how to capture errors occurred in filter..
>
>
>
> Any tips would be appreciated.
>
>
>
> Thanks and Regards,
>
> Gopala Krishna.Peela
>
>
>
>
>
>
>
>
> 
___
> 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: How to capture workflow errors in Filters

2006-09-15 Thread Gopala Krishna Peela

Hi,

Many Thanks for your immediate reply..

Could you please explain me on 4th point you mentioned below...

Thanks and Regards,
 
Gopala Krishna.Peela
 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Misi Mladoniczky
Sent: Friday, September 15, 2006 2:01 PM
To: arslist@ARSLIST.ORG
Subject: Re: How to capture workflow errors in Filters

Hi!

It all depends on what you mean by "capture".

1. If you are programming an API-program, you can will get the error
message, and can code according to the message list returned.

2. You can capture errors in logfiles. Any failed API-calls will have
the
text FAIL attached to the ending API-row in the logfile. Put filters/sql
in the same logfile, and you will be able to see what happened.

3. You can send ERROR-messages to ARUser, to prompt the user to fix a
problem and re-save

4. Errors occuring in Filters can usually be circumvented by doing some
tests by creating additional filters. Instead of an ERROR-message, you
can
do separate actions that can handle the situation.

Best Regards - Misi, RRR AB, http://www.rrr.se

> Hi,
>
>
>
> All of the my workflows are written in filters..the problem is all
> filters are rolling back when there is any error occurred in any one
of
> the filter..
>
> Could you please help me on how to capture errors occurred in filter..
>
>
>
> Any tips would be appreciated.
>
>
>
> Thanks and Regards,
>
> Gopala Krishna.Peela
>
>
>
>
>
>
>
>
>

___
> 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: How to capture workflow errors in Filters

2006-09-15 Thread Misi Mladoniczky

Hi Gopala,

A typical scenario could be that you do a Push-Fields from a filter, but
the ticket can not be created because i.e. one field contains an invalid
value.

The trick would be to verify this value before the Push-Fields and refrain
from doing the Push-Fields in the case of an invalid value.

The original ticket would still be submitted/modified.

Best Regards - Misi, RRR AB, http://www.rrr.se

> Hi,
>
> Many Thanks for your immediate reply..
>
> Could you please explain me on 4th point you mentioned below...
>
> Thanks and Regards,
>
> Gopala Krishna.Peela
>
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:[EMAIL PROTECTED] On Behalf Of Misi Mladoniczky
> Sent: Friday, September 15, 2006 2:01 PM
> To: arslist@ARSLIST.ORG
> Subject: Re: How to capture workflow errors in Filters
>
> Hi!
>
> It all depends on what you mean by "capture".
>
> 1. If you are programming an API-program, you can will get the error
> message, and can code according to the message list returned.
>
> 2. You can capture errors in logfiles. Any failed API-calls will have
> the
> text FAIL attached to the ending API-row in the logfile. Put filters/sql
> in the same logfile, and you will be able to see what happened.
>
> 3. You can send ERROR-messages to ARUser, to prompt the user to fix a
> problem and re-save
>
> 4. Errors occuring in Filters can usually be circumvented by doing some
> tests by creating additional filters. Instead of an ERROR-message, you
> can
> do separate actions that can handle the situation.
>
> Best Regards - Misi, RRR AB, http://www.rrr.se
>
>> Hi,
>>
>>
>>
>> All of the my workflows are written in filters..the problem is all
>> filters are rolling back when there is any error occurred in any one
> of
>> the filter..
>>
>> Could you please help me on how to capture errors occurred in filter..
>>
>>
>>
>> Any tips would be appreciated.
>>
>>
>>
>> Thanks and Regards,
>>
>> Gopala Krishna.Peela
>>
>>
>>
>>
>>
>>
>>
>>
>>
> 
> ___
>> 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: Syncing passwords between two servers

2006-09-15 Thread Misi Mladoniczky

Hi,

Unfortunately, the C-API aproach does not work in this case. You can not
export/import password fields with the API. You must use runmacro/ARUser
and arimportcmd/ARImport to transfer password data.

I discussed this with R&D during BUW, and we agreed that there were no
real reason that the encryption/decryption algorithm within
ARUser/runmacro/ARImport/arimportcmd should not be integrated within the
API.

I do not think that BMC will change this behaviour though...

Best Regards - Misi, RRR AB, http://www.rrr.se

> Dear Rmdy_Buckeye, (Go Bucks!)
>
> I would think about this approach. It might work. (Please test.)
>
> When a password change event happens ( I will leave it up to you to
> figure out how to detect/identify that ) Run (via a Filter Run Process
> action) an batch/shell script on the ARS server. This script should
> call the runmacro(.exe) to export the selected Request ID record to an
> ARX format file. Then call the runmacro again to "import" the data
> back to the target server. Hopefully the password encryption formats
> will work between the two ARS server versions listed. ( I think it
> will, but I have not explicitly tested it.)
>
>
> Sure you should be able to do this via an API that you write too. But
> why bother writing something new if existing command line tools work?
>
> 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 9/14/06, Rmdy_Buckeye <[EMAIL PROTECTED]> wrote:
>> At our installation, we have two servers, one running Remedy 6 and the
>> other running Remedy 5. We have some users that have accounts on both
>> servers. Sometimes the use has to call our helpdesk to reset password
>> on Remedy 6 server. The helpdesk cannot reset the password on the 5
>> server. I am trying to develop logic that will automatically sync the
>> paswords when they are changes on 6 server. I have developed an active
>> link that will sync passwords on both servers if the user logs into
>> both servers with old password. However this won't work if they change
>> their password on the 5 server first.
>>
>> Basically, I need to know, is there a way i can call remedy 5 server
>> and have it set the new password from the 6 server. Perhaps through a
>> run process command, or some kind of api?
>>
>> Any help would be appreciated
>>
>> Thanks
>>
>> ___
>> UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
>>
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
>

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

Re: Syncing passwords between two servers

2006-09-15 Thread Misi Mladoniczky

Hi,

The code to handle 6.3-passwords does not exist in the 5.1-tools (runmacro
etc). That is why you need to use a 6.3-arimportcmd to be able to import a
password to a 6.3-server.

I older versions, you could not do a filter-run-if like ('TR.Password' !=
$NULL$), as this was a protected field. This could make it hard to trap
password changes.

To solve this problem, I would suggest that you create a
password-change-dialog which does two Active-Link-Push-Fields to both
servers. Create a password-change-date-field and push a value into that
field.

Make sure that the Submitter-field on the User-record is the same as the
Login Name, to allow for Read-users to change their password.

You can change the Submitter-field by exporting the Login Name and Request
ID to an ARX-file and then import it using ARImport into the
Submitter-field (update old record with new record data).

Best Regards - Misi, RRR AB, http://www.rrr.se

> James,
>
> Unfortunately it appears based on his input this far that the 6.x server
> is
> primary and the 5.x server is somewhat secondary (not always connected to
> both).  I think Carey's suggestion of storing the value into a
> non-encrypted
> field and using API to set it is the only way to manage this because it
> appears that once a 6.x server encrypts the password that a 5.x server
> will
> not be able to use it.  AL's can do push to multiple servers but filters
> cannot...so you must move outside of Rem into a shell of some sorts.  If
> he
> can manage to intercept the password value he can even use something as
> simple as the ESPSetfield executable to update the 5.x server
>
>
> L. J. Head
> Software Engineer
> Remedy Approved Consultant
>
>
>
>   _
>
> From: Action Request System discussion list(ARSList)
> [mailto:[EMAIL PROTECTED] On Behalf Of McKenzie, James J C-E LCMC
> HQISEC/L3
> Sent: Thursday, September 14, 2006 2:35 PM
> To: arslist@ARSLIST.ORG
> Subject: Re: Syncing passwords between two servers
>
>
> **
> LJ:
>
> Possible solution for the original poster:
>
> Have the user log into the 5.1.2 server and change their password.  Once
> the
> password is set, have a filter run the runmacro to export from the 5.1.2
> server and arimportcmd to do the import to the 6.3 server.  Popup a
> message
> to have the user logout when the new password is set on the 6.3 server.
> Otherwise, the user will be locked out of the 6.3 server and this creates
> major problems.  Of course, the 6.3 server will have to have a filter that
> checks for changes in the password field ON MERGE to make the popup work.
> Also, I am assuming that the user logs into both servers at the same time.
>
> James McKenzie
> L-3 GSI
>
>
>   _
>
> From: Action Request System discussion list(ARSList)
> [mailto:[EMAIL PROTECTED] On Behalf Of L. J. Head
> Sent: Thursday, September 14, 2006 1:25 PM
> To: arslist@ARSLIST.ORG
> Subject: Re: Syncing passwords between two servers
>
>
> **
> Yes...export from 5.1.2 using runmacro and import with arimport from 6.3
> does in fact work
>
>
> L. J. Head
> Software Engineer
> Remedy Approved Consultant
>
>
>
>   _
>
> From: Action Request System discussion list(ARSList)
> [mailto:[EMAIL PROTECTED] On Behalf Of McKenzie, James J C-E LCMC
> HQISEC/L3
> Sent: Thursday, September 14, 2006 2:08 PM
> To: arslist@ARSLIST.ORG
> Subject: Re: Syncing passwords between two servers
>
>
> **
>
> LJ:
>
> How about trying the reverse (5.1.2 to 6.3), since you have the 5.1.2
> server
> setup before destroying it?
>
> James McKenzie
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:[EMAIL PROTECTED] On Behalf Of L. J. Head
> Sent: Thursday, September 14, 2006 1:06 PM
> To: arslist@ARSLIST.ORG
> Subject: Re: Syncing passwords between two servers
>
> Ok...just to put this baby to bed I installed a 5.1.2 server on my dev
> box...here are the results.  As Axton suggested I ran the 5.x runmacro
> command to do an export with command line of
>
> runmacro -x <6.3 Server> -a  -U  -P  -o
> test
> -f User -q "'Login Name' = ""
> This produced an arx file of my user off of my 6.3 Remedy server.  I then
> used the import tool to get this user onto my 5.1.2 server.  I cannot log
> onto the 5.x server with my newly imported user account, I keep getting a
> bad password error.  If I however change my password from within the user
> tool and log back on I can now use that user account.  Now I admittedly
> used
> the 6.3 import tool to do the import...but I'm not sure if that should
> matter.  I tried it again with the 6.3 runmacro and noticed that the
> password hash is different but still doesn't work when doing the import.
>
>
> L. J. Head
> Software Engineer
> Remedy Approved Consultant
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black
> Sent: Thursday, September 14, 2006 1:34 PM
> To: arslist@ARSLIST.ORG
> Subject: Re: Syncing passwords between t

Re: Webservcies GetListOutputMap/GetListInputMap

2006-09-15 Thread Carey Matthew Black


Gerry,

I am not sure what instructions your looking at, but those classes are
normally generated by a wsdl2Java program that you would run against
the target wsdl file. The class will be different for every WebSerivce
that you want to use.

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 9/15/06, Gerold Glaser <[EMAIL PROTECTED]> wrote:

Dear Listeners!

I'm playing with webservices and Remedy 6.3 and tried to test the examples
mentioned in the knowledgebase. Especially the examples about a java client
with apache axis. In this exampels they are always mention the classes
GetListOutputMap/GetListInputMap. But I can't find the implementation.

Can you please send me the java source for this two classes or tell me where
I can get them.

Best regards,

Gerry

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



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

request crashing user tool - malloc failed

2006-09-15 Thread Raido Oja

Hello,

I have discovered 2 requests so far on a regular form, that cause the user
tool to crash with 'malloc failed on server' error msg. I can see the
requests through a table on some other form, but when searching for them
the user tool crashes.

When trying to export data the export process hangs when it reaches these
requests, as does runmacro.exe when exporting from the command line.

As I have to save the data I am thinking of exporting on the database
level, deleting the data and creating a new request afterwards. Or can
anyone suggest another way of salvaging these requests?

My system:

ARS 5.01.02 patch 1357
Windows 2000
Oracle 9.2.0.3.0

Thanks for any ideas,

Raido



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

Re: request crashing user tool - malloc failed

2006-09-15 Thread Nyall McCavitt

Hi,

I have a similar situation with my system:

ARS Server V6.00.01 patch 1497
Solaris 5.9
Oracle 9.2.0.7.0

Each access to the affected ticket causes 100MB of ram to be used by the
arserverd process. When a certain amount of ram has been used arserverd crashes
and armonitor restarts.

SQL trace logs don't show anything but api logging does show an error. In many
cases it is only the values of the Query List that are returned. No values for
any other fields are displayed. Initially this was showing up as an RPC
error/timeout.

I have a ticket open with Remedy Support for 2 weeks now but nothing that we
have tried has traced the problem. We have even exported the production
database and re-imported it into a different Oracle server and pointed our
development Remedy Server at this copied database. The problem is apparent on
both the production and development servers and it is reproducible 100% of the
time.

If anyone has any ideas I would be grateful.

Thanks.

Nyall

Quoting Raido Oja <[EMAIL PROTECTED]>:

> Hello,
>
> I have discovered 2 requests so far on a regular form, that cause the user
> tool to crash with 'malloc failed on server' error msg. I can see the
> requests through a table on some other form, but when searching for them
> the user tool crashes.
>
> When trying to export data the export process hangs when it reaches these
> requests, as does runmacro.exe when exporting from the command line.
>
> As I have to save the data I am thinking of exporting on the database
> level, deleting the data and creating a new request afterwards. Or can
> anyone suggest another way of salvaging these requests?
>
> My system:
>
> ARS 5.01.02 patch 1357
> Windows 2000
> Oracle 9.2.0.3.0
>
> Thanks for any ideas,
>
> Raido
>
>
>
>
___
> UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
>

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

Re: Mid-Tier 7.0 Installation Problem

2006-09-15 Thread Mark Blankenship

**




You may be better served having a second AL check for whatever 'Else' 
conditions you are looking for.
BUT
In looking at your qualification, it appears that their might be some overlap 
in the conditions.
('Status' != $NULL$ AND 'Case ID+' != $NULL$)  would evaluate TRUE 
even if;  Status=New AND CaseID = HD.AND, I believe( 'Status' != 
"New" AND 'Case ID+' != "HD" ) would evaluate TRUE even if; Status = NULL AND 
CaseID = NULLSo it looks like your run-if would rarely evaluate 
false/else.Maybe:Status = New AND CaseID = NULLStatus = 
NULL AND CaseID = HD
If you want, give us a little more insight in to what you are trying to 
accomplish, maybe we can help.
Mark
 
"Kohli, Himanshu" <[EMAIL PROTECTED]> wrote in message news: 
<[EMAIL PROTECTED]>...
Hey List
I know its going to be very simple but now since I have tried all my 
combination (i.e. using braces ) I would like to seek your help.
I want my ACTL to execute its 'Else Action' for the below mentioned 'Run If ' 
condition
( 'Status' != "New" AND 'Case ID+' != "HD" ) OR ('Status' != $NULL$ AND 'Case 
ID+' != $NULL$)
every things works as desired when I use just one of them but with an OR when 
try to have both the condition in my Run If ... I fail
Note : I do not want to make use of any other parameter other than the Status 
& 'Case ID
Thanks for your quick help
Himanshu Kohli
Remedy Developer / Administrator
 
___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
 
--
__20060125___This posting was submitted with HTML in it___

Re: request crashing user tool - malloc failed

2006-09-15 Thread Carey Matthew Black

My first guess.. and this is just a WAG...

Check the T, H and B(if you have them) tables and find where there is
a missing record for the Request ID (field 1) values. A mismatch in
these tables has caused issues like this before.  I have never seen
the ARS server freak out that badly, but I have seen the User tool
crash due to this type of thing in the past.

Good luck.

--
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 9/15/06, Nyall McCavitt <[EMAIL PROTECTED]> wrote:

Hi,

I have a similar situation with my system:

ARS Server V6.00.01 patch 1497
Solaris 5.9
Oracle 9.2.0.7.0

Each access to the affected ticket causes 100MB of ram to be used by the
arserverd process. When a certain amount of ram has been used arserverd crashes
and armonitor restarts.

SQL trace logs don't show anything but api logging does show an error. In many
cases it is only the values of the Query List that are returned. No values for
any other fields are displayed. Initially this was showing up as an RPC
error/timeout.

I have a ticket open with Remedy Support for 2 weeks now but nothing that we
have tried has traced the problem. We have even exported the production
database and re-imported it into a different Oracle server and pointed our
development Remedy Server at this copied database. The problem is apparent on
both the production and development servers and it is reproducible 100% of the
time.

If anyone has any ideas I would be grateful.

Thanks.

Nyall

Quoting Raido Oja <[EMAIL PROTECTED]>:

> Hello,
>
> I have discovered 2 requests so far on a regular form, that cause the user
> tool to crash with 'malloc failed on server' error msg. I can see the
> requests through a table on some other form, but when searching for them
> the user tool crashes.
>
> When trying to export data the export process hangs when it reaches these
> requests, as does runmacro.exe when exporting from the command line.
>
> As I have to save the data I am thinking of exporting on the database
> level, deleting the data and creating a new request afterwards. Or can
> anyone suggest another way of salvaging these requests?
>
> My system:
>
> ARS 5.01.02 patch 1357
> Windows 2000
> Oracle 9.2.0.3.0
>
> Thanks for any ideas,
>
> Raido
>
>
>
>
___
> 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: Outraged (continued)

2006-09-15 Thread Moore Jr., Donald B.

I agree, Remedy tech support has always been top-notch.  I had an
interesting experience the other day when I called in a problem. I was
transferred to a tech guy who seemed anoyed with my question.  (Sorry, I'm
not as Windows savy as I should be, I was raised in the UNIX world).
Anyway, he said he'd e-mail me a brief synopsis of what to do and then call
me back.  I never received anything, not even a ticket number.  This is the
first time this has ever happened to me with Remedy support.  I guess
nothing lasts forever.

  Don Moore
  SAIC-HCC  Rockville

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

Re: request crashing user tool - malloc failed

2006-09-15 Thread McKenzie, James J C-E LCMC HQISEC/L3

Title: RE: request crashing user tool - malloc failed
**





Nyall and Raido:


I'm willing to state that the affected action has a very large diary or attachment associated with it.  If you attempt to export the record from your database, Oracle can handle the data collection, but Remedy cannot.  Thus, you see a large increase in memory usage and then the crash.  If you care to explore, you can look at the CLOB storage for that record and find the record is very large.  Don't know how this happens as the limit for a diary field under Oracle is 1MB of text.

If you need help, I think that I can provide a little bit of it.


James McKenzie
L-3 GSI
 


-Original Message-
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Nyall McCavitt
Sent: Friday, September 15, 2006 5:55 AM
To: arslist@ARSLIST.ORG
Subject: Re: request crashing user tool - malloc failed


Hi,


I have a similar situation with my system:


ARS Server V6.00.01 patch 1497
Solaris 5.9
Oracle 9.2.0.7.0


Each access to the affected ticket causes 100MB of ram to be used by the arserverd process. When a certain amount of ram has been used arserverd crashes and armonitor restarts.

SQL trace logs don't show anything but api logging does show an error. In many cases it is only the values of the Query List that are returned. No values for any other fields are displayed. Initially this was showing up as an RPC error/timeout.

I have a ticket open with Remedy Support for 2 weeks now but nothing that we have tried has traced the problem. We have even exported the production database and re-imported it into a different Oracle server and pointed our development Remedy Server at this copied database. The problem is apparent on both the production and development servers and it is reproducible 100% of the time.

If anyone has any ideas I would be grateful.


Thanks.


Nyall


Quoting Raido Oja <[EMAIL PROTECTED]>:


> Hello,
>
> I have discovered 2 requests so far on a regular form, that cause the 
> user tool to crash with 'malloc failed on server' error msg. I can see 
> the requests through a table on some other form, but when searching 
> for them the user tool crashes.
>
> When trying to export data the export process hangs when it reaches 
> these requests, as does runmacro.exe when exporting from the command line.
>
> As I have to save the data I am thinking of exporting on the database 
> level, deleting the data and creating a new request afterwards. Or can 
> anyone suggest another way of salvaging these requests?
>
> My system:
>
> ARS 5.01.02 patch 1357
> Windows 2000
> Oracle 9.2.0.3.0
>
> Thanks for any ideas,
>
> Raido
>
>
>
>
___
> UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
>


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




__20060125___This posting was submitted with HTML in it___

Re: request crashing user tool - malloc failed

2006-09-15 Thread lars . j . pettersson

Title: RE: request crashing user tool - malloc failed
**

We had
similar problem some years ago when importing arx files, crasch related to
attachments. The workaround was to import without attachments, and add
thoses later separate with the use of 'Update record'. Never got any
further explaination, not a problem anymore as we now can migrate with data in
the forms.

-Original Message-From: Action Request System
discussion list(ARSList) [mailto:[EMAIL PROTECTED]On Behalf Of
McKenzie, James J C-E LCMC HQISEC/L3Sent: Friday, September 15,
2006 3:42 PMTo: arslist@ARSLIST.ORGSubject: Re: request
crashing user tool - malloc failed**

Nyall and Raido:
I'm willing to state that the affected action has a very large
diary or attachment associated with it. If you attempt to export the
record from your database, Oracle can handle the data collection, but Remedy
cannot. Thus, you see a large increase in memory usage and then the
crash. If you care to explore, you can look at the CLOB storage for that
record and find the record is very large. Don't know how this happens as
the limit for a diary field under Oracle is 1MB of text.
If you need help, I think that I can provide a little bit of
it.
James McKenzie L-3 GSI
-Original Message- From:
Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of
Nyall McCavitt Sent: Friday, September 15, 2006 5:55
AM To: arslist@ARSLIST.ORG Subject: Re: request crashing user tool - malloc failed
Hi,
I have a similar situation with my system:
ARS Server V6.00.01 patch 1497 Solaris
5.9 Oracle 9.2.0.7.0
Each access to the affected ticket causes 100MB of ram to be
used by the arserverd process. When a certain amount of ram has been used
arserverd crashes and armonitor restarts.
SQL trace logs don't show anything but api logging does show
an error. In many cases it is only the values of the Query List that are
returned. No values for any other fields are displayed. Initially this was
showing up as an RPC error/timeout.
I have a ticket open with Remedy Support for 2 weeks now but
nothing that we have tried has traced the problem. We have even exported the
production database and re-imported it into a different Oracle server and
pointed our development Remedy Server at this copied database. The problem is
apparent on both the production and development servers and it is reproducible
100% of the time.
If anyone has any ideas I would be grateful.
Thanks.
Nyall
Quoting Raido Oja <[EMAIL PROTECTED]>:
> Hello, > > I have discovered 2 requests so far on a regular form, that cause
the > user tool to crash with 'malloc failed on
server' error msg. I can see > the requests through
a table on some other form, but when searching >
for them the user tool crashes. > > When trying to export data the export process hangs when it
reaches > these requests, as does runmacro.exe when
exporting from the command line. > > As I have to save the data I am thinking of exporting on the
database > level, deleting the data and creating a
new request afterwards. Or can > anyone suggest
another way of salvaging these requests? >
> My system: > > ARS 5.01.02 patch 1357 > Windows
2000 > Oracle 9.2.0.3.0 > > Thanks for any ideas,
> > Raido > > >
> ___
> UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
>
___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
__20060125___This posting was submitted with HTML in
it___
__20060125___This posting was submitted with HTML in it___

Re: request crashing user tool - malloc failed

2006-09-15 Thread Raido Oja

Thanks for the feedback. There's no attachment fields on my form, but 
there is quite a large diary field (but considerably less than 1mb). 
Anyway.. I'm also going to check the tables for a missing record, my 
problem is only with the user-tool crashing, it does not affect the 
server. I'll post back how it turns out.

[EMAIL PROTECTED] wrote:

**
We had similar problem some years ago when importing arx files, crasch 
related to attachments. The workaround was to import without 
attachments, and add thoses later separate with the use of 'Update 
record'. Never got any further explaination, not a problem anymore as 
we now can migrate with data in the forms.

-Original Message-
*From:* Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of *McKenzie, James J C-E
LCMC HQISEC/L3
*Sent:* Friday, September 15, 2006 3:42 PM
*To:* arslist@ARSLIST.ORG
*Subject:* Re: request crashing user tool - malloc failed

**

Nyall and Raido:

I'm willing to state that the affected action has a very large
diary or attachment associated with it.  If you attempt to export
the record from your database, Oracle can handle the data
collection, but Remedy cannot.  Thus, you see a large increase in
memory usage and then the crash.  If you care to explore, you can
look at the CLOB storage for that record and find the record is
very large.  Don't know how this happens as the limit for a diary
field under Oracle is 1MB of text.

If you need help, I think that I can provide a little bit of it.

James McKenzie
L-3 GSI

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Nyall McCavitt
Sent: Friday, September 15, 2006 5:55 AM
To: arslist@ARSLIST.ORG
Subject: Re: request crashing user tool - malloc failed

Hi,

I have a similar situation with my system:

ARS Server V6.00.01 patch 1497
Solaris 5.9
Oracle 9.2.0.7.0

Each access to the affected ticket causes 100MB of ram to be used
by the arserverd process. When a certain amount of ram has been
used arserverd crashes and armonitor restarts.

SQL trace logs don't show anything but api logging does show an
error. In many cases it is only the values of the Query List that
are returned. No values for any other fields are displayed.
Initially this was showing up as an RPC error/timeout.

I have a ticket open with Remedy Support for 2 weeks now but
nothing that we have tried has traced the problem. We have even
exported the production database and re-imported it into a
different Oracle server and pointed our development Remedy Server
at this copied database. The problem is apparent on both the
production and development servers and it is reproducible 100% of
the time.

If anyone has any ideas I would be grateful.

Thanks.

Nyall

Quoting Raido Oja <[EMAIL PROTECTED]>:

> Hello,
>
> I have discovered 2 requests so far on a regular form, that
cause the
> user tool to crash with 'malloc failed on server' error msg. I
can see
> the requests through a table on some other form, but when searching
> for them the user tool crashes.
>
> When trying to export data the export process hangs when it reaches
> these requests, as does runmacro.exe when exporting from the
command line.
>
> As I have to save the data I am thinking of exporting on the
database
> level, deleting the data and creating a new request afterwards.
Or can
> anyone suggest another way of salvaging these requests?
>
> My system:
>
> ARS 5.01.02 patch 1357
> Windows 2000
> Oracle 9.2.0.3.0
>
> Thanks for any ideas,
>
> Raido
>
>
>
>

___

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

___

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

__20060125___This posting was submitted with
HTML in it___

__20060125___This posting was submitted with HTML 
in it___ 

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

Re: request crashing user tool - malloc failed

2006-09-15 Thread McKenzie, James J C-E LCMC HQISEC/L3

Title: RE: request crashing user tool - malloc failed
**





Raido:


Suggestion:


Get with your Oracle DBA and do the following:


Log into SQL*Plus as the Remedy login, usually aradmin with the default password being ar#admin#.
Select schemaid from arschema where name ='';
Select count (c1) from t;
Select count (c1) from h;
Select count (e1) from b;


If I remembered the column names correctly, the last may be c1, these numbers should match. If they do not, you have a missing entry in one of the tables.  I had a missing entry in the H or status history table once.  The result is that particular entry could not be displayed, not a malloc error.

I would suggest exporting the 'large' diary entry and if possible, remove it to a file, or trimming it using a Diary Editor.  I actually had someone dump a directory table into a diary entry.  The result was constant malloc errors and a diary field of over 3MB.

James McKenzie
 


-Original Message-
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Raido Oja
Sent: Friday, September 15, 2006 7:07 AM
To: arslist@ARSLIST.ORG
Subject: Re: request crashing user tool - malloc failed


Thanks for the feedback. There's no attachment fields on my form, but there is quite a large diary field (but considerably less than 1mb). 

Anyway.. I'm also going to check the tables for a missing record, my problem is only with the user-tool crashing, it does not affect the server. I'll post back how it turns out.

[EMAIL PROTECTED] wrote:
> **
> We had similar problem some years ago when importing arx files, crasch 
> related to attachments. The workaround was to import without 
> attachments, and add thoses later separate with the use of 'Update 
> record'. Never got any further explaination, not a problem anymore as 
> we now can migrate with data in the forms.
>
> -Original Message-
> *From:* Action Request System discussion list(ARSList)
> [mailto:arslist@ARSLIST.ORG]*On Behalf Of *McKenzie, James J C-E
> LCMC HQISEC/L3
> *Sent:* Friday, September 15, 2006 3:42 PM
> *To:* arslist@ARSLIST.ORG
> *Subject:* Re: request crashing user tool - malloc failed
>
> **
>
> Nyall and Raido:
>
> I'm willing to state that the affected action has a very large
> diary or attachment associated with it.  If you attempt to export
> the record from your database, Oracle can handle the data
> collection, but Remedy cannot.  Thus, you see a large increase in
> memory usage and then the crash.  If you care to explore, you can
> look at the CLOB storage for that record and find the record is
> very large.  Don't know how this happens as the limit for a diary
> field under Oracle is 1MB of text.
>
> If you need help, I think that I can provide a little bit of it.
>
> James McKenzie
> L-3 GSI
>  
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:arslist@ARSLIST.ORG] On Behalf Of Nyall McCavitt
> Sent: Friday, September 15, 2006 5:55 AM
> To: arslist@ARSLIST.ORG
> Subject: Re: request crashing user tool - malloc failed
>
> Hi,
>
> I have a similar situation with my system:
>
> ARS Server V6.00.01 patch 1497
> Solaris 5.9
> Oracle 9.2.0.7.0
>
> Each access to the affected ticket causes 100MB of ram to be used
> by the arserverd process. When a certain amount of ram has been
> used arserverd crashes and armonitor restarts.
>
> SQL trace logs don't show anything but api logging does show an
> error. In many cases it is only the values of the Query List that
> are returned. No values for any other fields are displayed.
> Initially this was showing up as an RPC error/timeout.
>
> I have a ticket open with Remedy Support for 2 weeks now but
> nothing that we have tried has traced the problem. We have even
> exported the production database and re-imported it into a
> different Oracle server and pointed our development Remedy Server
> at this copied database. The problem is apparent on both the
> production and development servers and it is reproducible 100% of
> the time.
>
> If anyone has any ideas I would be grateful.
>
> Thanks.
>
> Nyall
>
> Quoting Raido Oja <[EMAIL PROTECTED]>:
>
> > Hello,
> >
> > I have discovered 2 requests so far on a regular form, that
> cause the
> > user tool to crash with 'malloc failed on server' error msg. I
> can see
> > the requests through a table on some other form, but when searching
> > for them the user tool crashes.
> >
> > When trying to export data the export process hangs when it reaches
> > these requests, as does runmacro.exe when exporting from the
> command line.
> >
> > As I have to save the data I am thinking of exporting on the
> database
> > level, deleting the data and creating a new request after

Re: request crashing user tool - malloc failed

2006-09-15 Thread Frank Caruso

**
Can you select the same data from a SQL prompt - directly from the database?Maybe there is a bad database block.On 9/15/06, McKenzie, James J C-E LCMC HQISEC/L3
 <[EMAIL PROTECTED]> wrote:
**

Raido:

Suggestion:

Get with your Oracle DBA and do the following:

Log into SQL*Plus as the Remedy login, usually aradmin with the default password being ar#admin#.
Select schemaid from arschema where name ='';
Select count (c1) from t;
Select count (c1) from h;
Select count (e1) from b;

If I remembered the column names correctly, the last may be c1, these numbers should match. If they do not, you have a missing entry in one of the tables.  I had a missing entry in the H or status history table once.  The result is that particular entry could not be displayed, not a malloc error.

I would suggest exporting the 'large' diary entry and if possible, remove it to a file, or trimming it using a Diary Editor.  I actually had someone dump a directory table into a diary entry.  The result was constant malloc errors and a diary field of over 3MB.

James McKenzie

-Original Message-
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Raido Oja

Sent: Friday, September 15, 2006 7:07 AM
To: arslist@ARSLIST.ORG
Subject: Re: request crashing user tool - malloc failed

Thanks for the feedback. There's no attachment fields on my form, but there is quite a large diary field (but considerably less than 1mb). 

Anyway.. I'm also going to check the tables for a missing record, my problem is only with the user-tool crashing, it does not affect the server. I'll post back how it turns out.

[EMAIL PROTECTED] wrote:
> **
> We had similar problem some years ago when importing arx files, crasch 
> related to attachments. The workaround was to import without 
> attachments, and add thoses later separate with the use of 'Update 
> record'. Never got any further explaination, not a problem anymore as 
> we now can migrate with data in the forms.
>
> -Original Message-
> *From:* Action Request System discussion list(ARSList)
> [mailto:arslist@ARSLIST.ORG]*On Behalf Of *McKenzie, James J C-E
> LCMC HQISEC/L3
> *Sent:* Friday, September 15, 2006 3:42 PM
> *To:* arslist@ARSLIST.ORG
> *Subject:* Re: request crashing user tool - malloc failed
>
> **
>
> Nyall and Raido:
>
> I'm willing to state that the affected action has a very large
> diary or attachment associated with it.  If you attempt to export
> the record from your database, Oracle can handle the data
> collection, but Remedy cannot.  Thus, you see a large increase in
> memory usage and then the crash.  If you care to explore, you can
> look at the CLOB storage for that record and find the record is
> very large.  Don't know how this happens as the limit for a diary
> field under Oracle is 1MB of text.
>
> If you need help, I think that I can provide a little bit of it.
>
> James McKenzie
> L-3 GSI
>  
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
__20060125___This posting was submitted with HTML in it___

Sql process and hanging ARServer

2006-09-15 Thread Piotr Polewczak

Hi,

i've got problem with hanging arserver, problem appears when one sql process
(connection from arserver) starts to lock other processes.

Command in blocking process is : sp_cursorclose;1 
Resources locked by process are : ARSystem.dbo.servgrp_userlic,
ARSystem.dbo.user_cache, ARSystem.dbo.T10 (User)

after several minutes almost all arserver processes are locked by first
process and arserver hangs, in logs there is info :
Dispatch : Timeout during data retrieval due to busy server -- retry the
operation (server)  ARERR – 93

Problem appears in the high load of the system and when all licences are taken.

Enviroment :
2 x ARS 6.3 patch 18 (server group)
MSSQL2000
Windows 2003

Thanks for any help,
Peter

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

Re: Two different Condition 's in Run If

2006-09-15 Thread Kohli, Himanshu

Hi Fred 
 
No even what you have suggested this time didn't worked  :(
 
1) First options of yours fail for both the scenario's i.e. CREATE & QUERY
2) Second option i.e. by making a swap by using a NOT works only for the first 
condition ( i.e. Query or Create ..which ever is mentioned before the OR )
 
(NOT (($OPERATION$ = "CREATE") AND ('Case ID+' = "HD")) OR(($OPERATION$ = 
"QUERY") AND ('Case ID+' = $NULL$)))  ==>  Works for CREATE
 
(NOT (($OPERATION$ = "QUERY") AND ('Case ID+' = $NULL$)) OR (($OPERATION$ = 
"CREATE") AND ('Case ID+' = "HD")))  ==>  Works for QUERY
 
 
Looking forward to crack this simple :( stuff with your Help & Info
 
Himanshu 
 



From: Action Request System discussion list(ARSList) on behalf of Grooms, 
Frederick W
Sent: Thu 9/14/2006 7:25 PM
To: arslist@ARSLIST.ORG
Subject: Re: Two different Condition 's in Run If



You want the error for these 2 conditions (and the error is in the
else).
 1) On Query when he has no Case Id selected or searched (i.e. Case ID =
Null )
 2) On Create when his Case ID has a default value ( Case ID = HD)

So those conditions would be:
 1. ($OPERATION$ = "QUERY") AND ('Case ID' = $NULL$)
 2. ($OPERATION$ = "CREATE") AND ('Case ID' = "HD")

So putting them together would be (This will give you the error in the
If):
 (($OPERATION$ = "QUERY") AND ('Case ID' = $NULL$)) OR
 (($OPERATION$ = "CREATE") AND ('Case ID' = "HD"))

You can either swap the actions or NOT the entire criteria:
 (NOT (($OPERATION$ = "QUERY") AND ('Case ID' = $NULL$))
  OR (($OPERATION$ = "CREATE") AND ('Case ID' = "HD")))

Fred


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kohli, Himanshu
Sent: Thursday, September 14, 2006 3:11 PM
To: arslist@ARSLIST.ORG
Subject: Re: Two different Condition 's in Run If

James

It so simple but making me really crazy about it ...

ok let me try to explain you briefly

I want to block a user action on a Button Click to open a new Window and
to include both the condition's in a single ACTL's Run If

1) On Query when he has no Case Id selected or searched (i.e. Case ID =
Null )
2) On Create when his Case ID has a default value ( Case ID = HD)

Now I am trying that

Run If  ==>  ('Case ID' != $NULL$)  OR ('Case ID' != "HD")

If  Action ==>  Open the Window

Else If==>  Error Msg


Result : If I use only one of each condition in the Run If ..it works as
desired but fails when I try to use both with "OR"

I beleive its somthing to relate with the execution of an ACTL at two
different Operation's CREATE & QUERY on Help Desk form.

I am having

ARS 6.3 , Windows 2k with MS SQL 2K

I hope you will be able to pull me out of this ...

Thanks & Regards
Himanshu Kohli
Remedy Developer / Administrator

PS : It looks so simple but has made me sound like 



From: Action Request System discussion list(ARSList) on behalf of
McKenzie, James J C-E LCMC HQISEC/L3
Sent: Thu 9/14/2006 3:14 PM
To: arslist@ARSLIST.ORG
Subject: Re: Two different Condition 's in Run If

Himanshu:
 
What EXACTLY are you trying to do?  Your Run-if qualification is leading
me to ask the question.
 
Thank you for changing the Subject:
 
James McKenzie
L-3 GSI



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kohli, Himanshu
Sent: Thursday, September 14, 2006 12:06 PM
To: arslist@ARSLIST.ORG
Subject: Re: Two different Condition 's in Run If

Eric
 
No even this is not working ...
 
Frederick
 
My ACTL executes on a Button on Help Desk form and runs for both CREATE
& QUERY operations but only Status field is a Required Field so idealy
this should not make my Run If condition fail..


Once again If I am using just one of the condition without using 'OR'
all works as desired...
 
plz help me to get out of this puzzel...
 
List : plz excuse me for not using a new subject in my initial post
. that was a mistake :(
 
Thanks & Regards
Himanshu Kohli
Remedy Developer / Administrator



From: Eric Roys [mailto:[EMAIL PROTECTED]
Sent: Thu 9/14/2006 11:21 AM
To: Kohli, Himanshu
Subject: RE: Mid-Tier 7.0 Installation Problem



 Try:
(( 'Status'  != "New") AND   ('Case ID+' !=  "HD"  ))   OR
(('Status'
!= $NULL$)  AND ('Case ID+' != $NULL$))

The additional parenthesis are needed to distinguish one OR from the
other.


Eric Roys
Sr. Software Engineer
Verizon Business
Email:  [EMAIL PROTECTED]

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kohli, Himanshu
Sent: Thursday, September 14, 2006 10:15 AM
To: arslist@ARSLIST.ORG
Subject: Re: Mid-Tier 7.0 Installation Problem

Hey List

I know its going to be very simple but now since I have tried all my
combination (i.e. using braces ) I would like to seek your help.

I want my ACTL to execute its 'Else Action' for the below mentio

Re: Two different Condition 's in Run If

2006-09-15 Thread Grooms, Frederick W

It looks like it's missing some parenthesis 

(NOT ((($OPERATION$ = "CREATE") AND ('Case ID+' = "HD")) OR 
  (($OPERATION$ = "QUERY") AND ('Case ID+' = $NULL$

Without an extra ( after the NOT and ) at the end, the NOT is only
working on the 1st condition.

I should have layed it out in my normal method, sorry about that... 

  (NOT ( 
 (($OPERATION$ = "CREATE") AND ('Case ID+' = "HD")) 
   OR 
 (($OPERATION$ = "QUERY") AND ('Case ID+' = $NULL$)) 
   ) 
  ) 


Fred


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kohli, Himanshu
Sent: Friday, September 15, 2006 9:43 AM
To: arslist@ARSLIST.ORG
Subject: Re: Two different Condition 's in Run If

Hi Fred 
 
No even what you have suggested this time didn't worked  :(
 
1) First options of yours fail for both the scenario's i.e. CREATE &
QUERY
2) Second option i.e. by making a swap by using a NOT works only for the
first condition ( i.e. Query or Create ..which ever is mentioned before
the OR )
 
(NOT (($OPERATION$ = "CREATE") AND ('Case ID+' = "HD")) OR(($OPERATION$
= "QUERY") AND ('Case ID+' = $NULL$)))  ==>  Works for CREATE
 
(NOT (($OPERATION$ = "QUERY") AND ('Case ID+' = $NULL$)) OR
(($OPERATION$ = "CREATE") AND ('Case ID+' = "HD")))  ==>  Works for
QUERY
 
 
Looking forward to crack this simple :( stuff with your Help & Info
 
Himanshu 
 



From: Action Request System discussion list(ARSList) on behalf of
Grooms, Frederick W
Sent: Thu 9/14/2006 7:25 PM
To: arslist@ARSLIST.ORG
Subject: Re: Two different Condition 's in Run If



You want the error for these 2 conditions (and the error is in the
else).
 1) On Query when he has no Case Id selected or searched (i.e. Case ID =
Null )
 2) On Create when his Case ID has a default value ( Case ID = HD)

So those conditions would be:
 1. ($OPERATION$ = "QUERY") AND ('Case ID' = $NULL$)  2. ($OPERATION$ =
"CREATE") AND ('Case ID' = "HD")

So putting them together would be (This will give you the error in the
If):
 (($OPERATION$ = "QUERY") AND ('Case ID' = $NULL$)) OR  (($OPERATION$ =
"CREATE") AND ('Case ID' = "HD"))

You can either swap the actions or NOT the entire criteria:
 (NOT (($OPERATION$ = "QUERY") AND ('Case ID' = $NULL$))
  OR (($OPERATION$ = "CREATE") AND ('Case ID' = "HD")))

Fred


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kohli, Himanshu
Sent: Thursday, September 14, 2006 3:11 PM
To: arslist@ARSLIST.ORG
Subject: Re: Two different Condition 's in Run If

James

It so simple but making me really crazy about it ...

ok let me try to explain you briefly

I want to block a user action on a Button Click to open a new Window and
to include both the condition's in a single ACTL's Run If

1) On Query when he has no Case Id selected or searched (i.e. Case ID =
Null )
2) On Create when his Case ID has a default value ( Case ID = HD)

Now I am trying that

Run If  ==>  ('Case ID' != $NULL$)  OR ('Case ID' != "HD")

If  Action ==>  Open the Window

Else If==>  Error Msg


Result : If I use only one of each condition in the Run If ..it works as
desired but fails when I try to use both with "OR"

I beleive its somthing to relate with the execution of an ACTL at two
different Operation's CREATE & QUERY on Help Desk form.

I am having

ARS 6.3 , Windows 2k with MS SQL 2K

I hope you will be able to pull me out of this ...

Thanks & Regards
Himanshu Kohli
Remedy Developer / Administrator

PS : It looks so simple but has made me sound like 



From: Action Request System discussion list(ARSList) on behalf of
McKenzie, James J C-E LCMC HQISEC/L3
Sent: Thu 9/14/2006 3:14 PM
To: arslist@ARSLIST.ORG
Subject: Re: Two different Condition 's in Run If

Himanshu:
 
What EXACTLY are you trying to do?  Your Run-if qualification is leading
me to ask the question.
 
Thank you for changing the Subject:
 
James McKenzie
L-3 GSI



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kohli, Himanshu
Sent: Thursday, September 14, 2006 12:06 PM
To: arslist@ARSLIST.ORG
Subject: Re: Two different Condition 's in Run If

Eric
 
No even this is not working ...
 
Frederick
 
My ACTL executes on a Button on Help Desk form and runs for both CREATE
& QUERY operations but only Status field is a Required Field so idealy
this should not make my Run If condition fail..


Once again If I am using just one of the condition without using 'OR'
all works as desired...
 
plz help me to get out of this puzzel...
 
List : plz excuse me for not using a new subject in my initial post
. that was a mistake :(
 
Thanks & Regards
Himanshu Kohli
Remedy Developer / Administrator



From: Eric Roys [mailto:[EMAIL PROTECTED]
Sent: Thu 9/14/2006 11:21 AM
To: Kohli, Himanshu
Subject: RE: Mid-Tier 7.0 Installa

Re: Two different Condition 's in Run If

2006-09-15 Thread Charu Mahajan

Hi there,

How r u?

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kohli, Himanshu
Sent: Friday, September 15, 2006 8:13 PM
To: arslist@ARSLIST.ORG
Subject: Re: Two different Condition 's in Run If

Hi Fred 

No even what you have suggested this time didn't worked  :(

1) First options of yours fail for both the scenario's i.e. CREATE &
QUERY
2) Second option i.e. by making a swap by using a NOT works only for the
first condition ( i.e. Query or Create ..which ever is mentioned before
the OR )

(NOT (($OPERATION$ = "CREATE") AND ('Case ID+' = "HD")) OR(($OPERATION$
= "QUERY") AND ('Case ID+' = $NULL$)))  ==>  Works for CREATE

(NOT (($OPERATION$ = "QUERY") AND ('Case ID+' = $NULL$)) OR
(($OPERATION$ = "CREATE") AND ('Case ID+' = "HD")))  ==>  Works for
QUERY

Looking forward to crack this simple :( stuff with your Help & Info

Himanshu 

From: Action Request System discussion list(ARSList) on behalf of
Grooms, Frederick W
Sent: Thu 9/14/2006 7:25 PM
To: arslist@ARSLIST.ORG
Subject: Re: Two different Condition 's in Run If

You want the error for these 2 conditions (and the error is in the
else).
 1) On Query when he has no Case Id selected or searched (i.e. Case ID =
Null )
 2) On Create when his Case ID has a default value ( Case ID = HD)

So those conditions would be:
 1. ($OPERATION$ = "QUERY") AND ('Case ID' = $NULL$)
 2. ($OPERATION$ = "CREATE") AND ('Case ID' = "HD")

So putting them together would be (This will give you the error in the
If):
 (($OPERATION$ = "QUERY") AND ('Case ID' = $NULL$)) OR
 (($OPERATION$ = "CREATE") AND ('Case ID' = "HD"))

You can either swap the actions or NOT the entire criteria:
 (NOT (($OPERATION$ = "QUERY") AND ('Case ID' = $NULL$))
  OR (($OPERATION$ = "CREATE") AND ('Case ID' = "HD")))

Fred

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kohli, Himanshu
Sent: Thursday, September 14, 2006 3:11 PM
To: arslist@ARSLIST.ORG
Subject: Re: Two different Condition 's in Run If

James

It so simple but making me really crazy about it ...

ok let me try to explain you briefly

I want to block a user action on a Button Click to open a new Window and
to include both the condition's in a single ACTL's Run If

1) On Query when he has no Case Id selected or searched (i.e. Case ID =
Null )
2) On Create when his Case ID has a default value ( Case ID = HD)

Now I am trying that

Run If  ==>  ('Case ID' != $NULL$)  OR ('Case ID' != "HD")

If  Action ==>  Open the Window

Else If==>  Error Msg

Result : If I use only one of each condition in the Run If ..it works as
desired but fails when I try to use both with "OR"

I beleive its somthing to relate with the execution of an ACTL at two
different Operation's CREATE & QUERY on Help Desk form.

I am having

ARS 6.3 , Windows 2k with MS SQL 2K

I hope you will be able to pull me out of this ...

Thanks & Regards
Himanshu Kohli
Remedy Developer / Administrator

PS : It looks so simple but has made me sound like 

From: Action Request System discussion list(ARSList) on behalf of
McKenzie, James J C-E LCMC HQISEC/L3
Sent: Thu 9/14/2006 3:14 PM
To: arslist@ARSLIST.ORG
Subject: Re: Two different Condition 's in Run If

Himanshu:

What EXACTLY are you trying to do?  Your Run-if qualification is leading
me to ask the question.

Thank you for changing the Subject:

James McKenzie
L-3 GSI

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kohli, Himanshu
Sent: Thursday, September 14, 2006 12:06 PM
To: arslist@ARSLIST.ORG
Subject: Re: Two different Condition 's in Run If

Eric

No even this is not working ...

Frederick

My ACTL executes on a Button on Help Desk form and runs for both CREATE
& QUERY operations but only Status field is a Required Field so idealy
this should not make my Run If condition fail..

Once again If I am using just one of the condition without using 'OR'
all works as desired...

plz help me to get out of this puzzel...

List : plz excuse me for not using a new subject in my initial post
. that was a mistake :(

Thanks & Regards
Himanshu Kohli
Remedy Developer / Administrator

From: Eric Roys [mailto:[EMAIL PROTECTED]
Sent: Thu 9/14/2006 11:21 AM
To: Kohli, Himanshu
Subject: RE: Mid-Tier 7.0 Installation Problem

 Try:
(( 'Status'  != "New") AND   ('Case ID+' !=  "HD"  ))   OR
(('Status'
!= $NULL$)  AND ('Case ID+' != $NULL$))

The additional parenthesis are needed to distinguish one OR from the
other.

Eric Roys
Sr. Software Engineer
Verizon Business
Email:  [EMAIL PROTECTED]

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kohli, Himanshu
Sent: Thursday, September 14, 2006 10:15 AM
To: arslist@A

Recall: Two different Condition 's in Run If

2006-09-15 Thread Charu Mahajan

Title: Recall: Two different Condition 's in  Run If
**






Charu Mahajan would like to recall the message, "Two different Condition 's in  Run If".




DISCLAIMER:
---

The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only. 
It shall not attach any liability on the originator or HCL or its affiliates. Any views or opinions presented in 
this email are solely those of the author and may not necessarily reflect the opinions of HCL or its affiliates. 
Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of 
this message without the prior written consent of the author of this e-mail is strictly prohibited. If you have 
received this email in error please delete it and notify the sender immediately. Before opening any mail and 
attachments please check them for viruses and defect.

---

__20060125___This posting was submitted with HTML in it___

Re: Approvals

2006-09-15 Thread Dylan Thomas

They don't exist at all. Just to double check I exported the form to def and
opened it in notepad and searched for the field by name and by ID, zilch on both

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

Re: Two different Condition 's in Run If OT:ADM no recall

2006-09-15 Thread Daniel Bloom

Hi, I'm doing pretty good.
Hope most on the list are,
but with over 3000 of us I am sure
there are a few that can complain.

Just a reminder to everyone, once you have posted to the ARSlist, there is 
currently no such thing as a recall, so be carefull to recheck what you 
are sending, and the TO: field to make sure it is going to the individual 
or the list, and that whichever it is it is the one you wanted.

Amongst other things, since I have the mail system nicely tuned with 100 
threads or so, in the time it would take me to log in and delete a post, 
it would already have been sent world wide.

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

Re: request crashing user tool - malloc failed

2006-09-15 Thread Nyall McCavitt


Hi,

Thanks for the hint. I will investigate further.

Nyall

Carey Matthew Black wrote:

My first guess.. and this is just a WAG...

Check the T, H and B(if you have them) tables and find where there is
a missing record for the Request ID (field 1) values. A mismatch in
these tables has caused issues like this before.  I have never seen
the ARS server freak out that badly, but I have seen the User tool
crash due to this type of thing in the past.

Good luck.



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

Re: Down Loading Presentations from BMC User World

2006-09-15 Thread Easter, David

Hi All,

  I wanted to pass on an official statement from our UserWorld staff
about this issue.  "Not shooting the messenger" rules apply. ;-)

"The BMC Software UserWorld 2006 presentations posted on
https://www.bmcuserworld.com/scheduler/login.do are only to be accessed
by UserWorld attendees with their ID and personal password and are not
to be publicly posted to any other site without the express permission
of BMC Software.  These presentations are for the time being available
only to UserWorld 2006 attendees.  In the coming weeks there will be
made available audio files of a few of the most popular sessions on
www.bmc.com/userworld2006 on a rotating basis.  If you have any
questions, please contact the UserWorld Conference Manager at
[EMAIL PROTECTED]" 

Thanks,

-David J. Easter
Sr. Product Manager, Service Management Business Unit
BMC Software, Inc.

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Rick Parry
Sent: Thursday, September 14, 2006 12:02 PM
To: arslist@ARSLIST.ORG
Subject: Re: Down Loading Presentations from BMC User World

It is a sad time when we can't share our knowledge. Everyone knows that
you don't get everything from a slide show. If they had video recorded
the sessions that would be another issue. Screen shots without
discussion should be treated just like Remedy Manuals. If you have a
support contract you should be able to get the slide shows.

Just my 2 cents.

Rick Parry

** 

Rick Parry
Application Engineer
[EMAIL PROTECTED]
801-861-1747

>>> "McKenzie, James J C-E LCMC HQISEC/L3"
<[EMAIL PROTECTED]> 9/14/2006 8:35 AM >>>

Herb: 

For now, yes sadly. 

James McKenzie 

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Herb Partlow
Sent: Tuesday, September 12, 2006 4:40 PM
To: arslist@ARSLIST.ORG
Subject: Re: Down Loading Presentations from BMC User World 

**
What about the folks that did not have the ability to make it, Are we
left out in the cold? 

Herb  

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Pedro Cardoso
Sent: Tuesday, September 12, 2006 4:03 PM
To: arslist@ARSLIST.ORG
Subject: [Norton AntiSpam] Re: Down Loading Presentations from BMC User
World 

** 
Hi to All!. 

I just received an email announcing the availability of the
presentations. 

...Looking for presentations? 
Only UserWorld attendees may access the online version of the
presentation slides from the conference. You may view these
presentations at: www.bmcuserworld.com/scheduler/login.do
 . Once you are logged
in click on Session Catalog on the home page or on the left navigation.
>From the session catalog you can search for sessions based on various
attributes. You will need the User Name and Password that you created
when you logged into the UserWorld 2006 registration system. 

... 

There are a few presentations files without contents, but are the less. 

Pedro Cardoso R. 
MEXICO 

On 9/12/06, Pruitt, Christopher J <[EMAIL PROTECTED]> wrote: 
** 
I asked this same question of BMC UserWorld support and this was their
reply: 

From: BMC UserWorld 2006 [mailto:[EMAIL PROTECTED] 
Sent: Friday, September 08, 2006 1:42 PM 
To: Pruitt, Christopher J 
Subject: [Ticket#: 2006090810068985] Location of Presentations 

Thank you for your request. 
These will be available to download by Sunday in the scheduler. 

Please let us know if you have any further questions. 

Regards, 

BMC UserWorld 2006 
[EMAIL PROTECTED]  

However, I just checked and they are still not there. 
Christopher Pruitt 
Consultant Specialist 
EDS - Bank of America 
I3-Inventory IW Infrastructure Team 
Phone: +1-972-605-7702 (8-835)  
mailto: [EMAIL PROTECTED]

Confidentiality Notice: This message and any files transmitted with it
are intended for the sole use of the entity or individual to whom it is
addressed, and may contain information that is confidential, privileged,
and exempt from disclosure under applicable law. If you are not the
intended addressee for this e-mail, you are hereby notified that any
copying, distribution, or dissemination of this e-mail is strictly
prohibited. If you have received this e-mail in error, please
immediately destroy, erase, or discard this message. Please notify the
sender immediately by return e-mail if you have received this e-mail by
mistake. 

From: Action Request System discussion list(ARSList) 

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

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

Re: Down Loading Presentations from BMC User World

2006-09-15 Thread McKenzie, James J C-E LCMC HQISEC/L3

Title: RE: Down Loading Presentations from BMC User World
**





Since Mr. Easter is actively monitoring this list and I was not able to attend BUW do to reasons way beyond my control:


Mr. Easter:


I attended the Remedy Boot Camp in Pleasanton, CA in December of 2004.  This brought out the technical sessions that were offered at the Remedy User's Group for that year and also allowed those of us that were unable to attend the RUG for one reason or another to see and meet the technical leads to include Mr. Doug Mueller.  I would like to suggest that BMC investigate reintroducing something like this for those of us who were unable to attend the BUW.  I definitely would request to attend this.  I recommend that at least three of these Boot Camps be organized.  One that the Pleasanton, CA location, one at BMC headquarters in Houston, TX and finally the last at the Columbia, MD location.  These Boot Camps should cover the most popular (I recommend at least two sessions per) six topics at BUW.  Also, a meet-and-greet session with the technical leads, such as the UNIX server lead, Mr. Mueller (time permitting) and possibly a continuation of the RFE process discussion.

This is not to substitute for the BUW, which I think is a good idea given its audience.


James McKenzie
This is not the opinion of my employer, L-3 GSI, the United States Army nor any subdepartment of either organization, but my opinion on this subject.


-Original Message-
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Easter, David
Sent: Friday, September 15, 2006 8:20 AM
To: arslist@ARSLIST.ORG
Subject: Re: Down Loading Presentations from BMC User World


Hi All,


  I wanted to pass on an official statement from our UserWorld staff about this issue.  "Not shooting the messenger" rules apply. ;-)

"The BMC Software UserWorld 2006 presentations posted on https://www.bmcuserworld.com/scheduler/login.do are only to be accessed by UserWorld attendees with their ID and personal password and are not to be publicly posted to any other site without the express permission of BMC Software.  These presentations are for the time being available only to UserWorld 2006 attendees.  In the coming weeks there will be made available audio files of a few of the most popular sessions on

www.bmc.com/userworld2006 on a rotating basis.  If you have any questions, please contact the UserWorld Conference Manager at [EMAIL PROTECTED]" 

Thanks,


-David J. Easter
Sr. Product Manager, Service Management Business Unit BMC Software, Inc.


-Original Message-
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Parry
Sent: Thursday, September 14, 2006 12:02 PM
To: arslist@ARSLIST.ORG
Subject: Re: Down Loading Presentations from BMC User World


It is a sad time when we can't share our knowledge. Everyone knows that you don't get everything from a slide show. If they had video recorded the sessions that would be another issue. Screen shots without discussion should be treated just like Remedy Manuals. If you have a support contract you should be able to get the slide shows.

Just my 2 cents.


Rick Parry


** 


Rick Parry
Application Engineer
[EMAIL PROTECTED]
801-861-1747




>>> "McKenzie, James J C-E LCMC HQISEC/L3"
<[EMAIL PROTECTED]> 9/14/2006 8:35 AM >>>


Herb: 
  
For now, yes sadly. 
  
James McKenzie 
  

From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Herb Partlow
Sent: Tuesday, September 12, 2006 4:40 PM
To: arslist@ARSLIST.ORG
Subject: Re: Down Loading Presentations from BMC User World 



**
What about the folks that did not have the ability to make it, Are we left out in the cold? 
 
Herb  
 
-Original Message-
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Pedro Cardoso
Sent: Tuesday, September 12, 2006 4:03 PM
To: arslist@ARSLIST.ORG
Subject: [Norton AntiSpam] Re: Down Loading Presentations from BMC User World 
 
**
Hi to All!. 
 
I just received an email announcing the availability of the presentations. 
 
...Looking for presentations? 
Only UserWorld attendees may access the online version of the presentation slides from the conference. You may view these presentations at: www.bmcuserworld.com/scheduler/login.do

 . Once you are logged in click on Session Catalog on the home page or on the left navigation.

From the session catalog you can search for sessions based on various attributes. You will need the User Name and Password that you created when you logged into the UserWorld 2006 registration system. 

 
... 
 
There are a few presentations files without contents, but are the less. 
 
Pedro Cardoso R. 
MEXICO 
 
 
 
 




 
On 9/12/06, Pruitt, Christopher J <[EMAIL PROTECTED]> wrote: 
**
I asked this same question of BMC UserWorld support and this was the

Re: Two different Condition 's in Run If

2006-09-15 Thread Eric Roys

Himanshu, others.. 

Perhaps I missed something or haven't had enough coffee, but.. 

Why not just: 

(($OPERATION$ = "CREATE")) OR (($OPERATION$ = $QUERY$) AND ('Case ID+' =
$NULL$))

>From Matt's previous post, the reason for the other criteria is based on
"default values" which may or may not exist. So this will work for either
without depending on values that may default or may be cleared with Ctrl-E,
etc. 

-E


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kohli, Himanshu
Sent: Friday, September 15, 2006 9:43 AM
To: arslist@ARSLIST.ORG
Subject: Re: Two different Condition 's in Run If

Hi Fred 
 
No even what you have suggested this time didn't worked  :(
 
1) First options of yours fail for both the scenario's i.e. CREATE & QUERY
2) Second option i.e. by making a swap by using a NOT works only for the
first condition ( i.e. Query or Create ..which ever is mentioned before the
OR )
 
(NOT (($OPERATION$ = "CREATE") AND ('Case ID+' = "HD")) OR(($OPERATION$ =
"QUERY") AND ('Case ID+' = $NULL$)))  ==>  Works for CREATE
 
(NOT (($OPERATION$ = "QUERY") AND ('Case ID+' = $NULL$)) OR (($OPERATION$ =
"CREATE") AND ('Case ID+' = "HD")))  ==>  Works for QUERY
 
 
Looking forward to crack this simple :( stuff with your Help & Info
 
Himanshu 
 



From: Action Request System discussion list(ARSList) on behalf of Grooms,
Frederick W
Sent: Thu 9/14/2006 7:25 PM
To: arslist@ARSLIST.ORG
Subject: Re: Two different Condition 's in Run If



You want the error for these 2 conditions (and the error is in the else).
 1) On Query when he has no Case Id selected or searched (i.e. Case ID =
Null )
 2) On Create when his Case ID has a default value ( Case ID = HD)

So those conditions would be:
 1. ($OPERATION$ = "QUERY") AND ('Case ID' = $NULL$)  2. ($OPERATION$ =
"CREATE") AND ('Case ID' = "HD")

So putting them together would be (This will give you the error in the
If):
 (($OPERATION$ = "QUERY") AND ('Case ID' = $NULL$)) OR  (($OPERATION$ =
"CREATE") AND ('Case ID' = "HD"))

You can either swap the actions or NOT the entire criteria:
 (NOT (($OPERATION$ = "QUERY") AND ('Case ID' = $NULL$))
  OR (($OPERATION$ = "CREATE") AND ('Case ID' = "HD")))

Fred


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kohli, Himanshu
Sent: Thursday, September 14, 2006 3:11 PM
To: arslist@ARSLIST.ORG
Subject: Re: Two different Condition 's in Run If

James

It so simple but making me really crazy about it ...

ok let me try to explain you briefly

I want to block a user action on a Button Click to open a new Window and to
include both the condition's in a single ACTL's Run If

1) On Query when he has no Case Id selected or searched (i.e. Case ID = Null
)
2) On Create when his Case ID has a default value ( Case ID = HD)

Now I am trying that

Run If  ==>  ('Case ID' != $NULL$)  OR ('Case ID' != "HD")

If  Action ==>  Open the Window

Else If==>  Error Msg


Result : If I use only one of each condition in the Run If ..it works as
desired but fails when I try to use both with "OR"

I beleive its somthing to relate with the execution of an ACTL at two
different Operation's CREATE & QUERY on Help Desk form.

I am having

ARS 6.3 , Windows 2k with MS SQL 2K

I hope you will be able to pull me out of this ...

Thanks & Regards
Himanshu Kohli
Remedy Developer / Administrator

PS : It looks so simple but has made me sound like 



From: Action Request System discussion list(ARSList) on behalf of McKenzie,
James J C-E LCMC HQISEC/L3
Sent: Thu 9/14/2006 3:14 PM
To: arslist@ARSLIST.ORG
Subject: Re: Two different Condition 's in Run If

Himanshu:
 
What EXACTLY are you trying to do?  Your Run-if qualification is leading me
to ask the question.
 
Thank you for changing the Subject:
 
James McKenzie
L-3 GSI



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kohli, Himanshu
Sent: Thursday, September 14, 2006 12:06 PM
To: arslist@ARSLIST.ORG
Subject: Re: Two different Condition 's in Run If

Eric
 
No even this is not working ...
 
Frederick
 
My ACTL executes on a Button on Help Desk form and runs for both CREATE &
QUERY operations but only Status field is a Required Field so idealy this
should not make my Run If condition fail..


Once again If I am using just one of the condition without using 'OR'
all works as desired...
 
plz help me to get out of this puzzel...
 
List : plz excuse me for not using a new subject in my initial post .
that was a mistake :(
 
Thanks & Regards
Himanshu Kohli
Remedy Developer / Administrator



From: Eric Roys [mailto:[EMAIL PROTECTED]
Sent: Thu 9/14/2006 11:21 AM
To: Kohli, Himanshu
Subject: RE: Mid-Tier 7.0 Installation Problem



 Try:
(( 'Status'  != "New") AND   ('Case ID+' !=  "HD"  ))   O

Re: request crashing user tool - malloc failed

2006-09-15 Thread Nyall McCavitt

Title: RE: request crashing user tool - malloc failed
**




Hi,

I think that you are along the correct lines here except that I don't
expect that for these particular entries that there would be any large
diary entries but as I am rusty on SQL then I am not sure of the exact
Oracle commands required to verify the size of the relevant fields. Any
pointers would be gratefully received.

I have checked that the relevant T,H and B tables are consistent with
the number of entries in each.

Thanks.

Nyall

McKenzie, James J C-E LCMC HQISEC/L3 wrote:
**
  
  
  
  Nyall and Raido:
  
  I'm willing to state that the affected action has a
very large diary or attachment associated with it.  If you attempt to
export the record from your database, Oracle can handle the data
collection, but Remedy cannot.  Thus, you see a large increase in
memory usage and then the crash.  If you care to explore, you can look
at the CLOB storage for that record and find the record is very large. 
Don't know how this happens as the limit for a diary field under Oracle
is 1MB of text.
  If you need help, I think that I can provide a
little bit of it.
  




__20060125___This posting was submitted with HTML in it___

Re: request crashing user tool - malloc failed

2006-09-15 Thread McKenzie, James J C-E LCMC HQISEC/L3

Title: RE: request crashing user tool - malloc failed
**



Nyall:
 
I would have to look into this, but we did this at one 
place that I worked at because we did have diary problems.  I think it took 
a stored procedure and then calling that procedure and then sorting the top 
ten.  We would run this and get the results as a mail message with 
them.  We sent it to a local mailbox on a UNIX system.
 
James Mckenzie
 


From: Action Request System discussion 
list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Nyall 
McCavittSent: Friday, September 15, 2006 8:38 AMTo: 
arslist@ARSLIST.ORGSubject: Re: request crashing user tool - malloc 
failed
** Hi,I think that you are along the correct lines here 
except that I don't expect that for these particular entries that there would be 
any large diary entries but as I am rusty on SQL then I am not sure of the exact 
Oracle commands required to verify the size of the relevant fields. Any pointers 
would be gratefully received.I have checked that the relevant T,H and B 
tables are consistent with the number of entries in 
each.Thanks.NyallMcKenzie, James J C-E LCMC HQISEC/L3 
wrote: 
** 
  
  Nyall and Raido: 
  I'm willing to state that the affected action has a very large 
  diary or attachment associated with it.  If you attempt to export the 
  record from your database, Oracle can handle the data collection, but Remedy 
  cannot.  Thus, you see a large increase in memory usage and then the 
  crash.  If you care to explore, you can look at the CLOB storage for that 
  record and find the record is very large.  Don't know how this happens as 
  the limit for a diary field under Oracle is 1MB of text.
  If you need help, I think that I can provide a little bit of 
  it. __20060125___This posting 
was submitted with HTML in it___ 
__20060125___This posting was submitted with HTML in it___

Re: Two different Condition 's in Run If

2006-09-15 Thread Kohli, Himanshu

Oh yeah at last this worked as desired  yup with an extra ' ( ' made things 
look good for both the condition's
 
Thanks a lot Fred , James & Carey & others too
 
Now I can say I will have a nice weekend :)  as my intention to save system 
from creating two ACTL's has been succesful 
 
 even though I am still trying to guess why without using a 'NOT' clause I am 
having problem
 
 
Okay for all, the other way it worked was by creating two diff ACTL's and only 
making use of If Action in both of them ( so no messing up with Else If )
 
 
 
1) IMF:HPD:OpenLandownForm02 ==> Execution Order = 0 , Execute On = Button
 Run IF = (($OPERATION$ =  "CREATE" ) AND ( 'Case ID+' =  "HD" )) OR 
(($OPERATION$ =  "QUERY" ) AND ( 'Case ID+' =  $NULL$ ))
 If Action  = Msg
 
 
2) IMF:HPD:OpenLandownForm03 ==> Execution Order = 1 , Execute On = Button
Run IF =  No condition ...as I need to execute this all the time other 
than my above covered 2 condition's
If Action  = Open Window 
 
So this was a another simple way in which I was able to get my desired Result 
but I was required to have 2 ACTL's ,,,which was not making me feel good
 
 
Wishing you all a Wonderful Weekend ...
 
Himanshu Kohli
Remedy Developer / Administrator
 
PS : Just to share that from my persoal exp till date ... I found my solutions 
for my Problems more quickly with you all in the AR List than from the Support  
 
 
 



From: Action Request System discussion list(ARSList) on behalf of Grooms, 
Frederick W
Sent: Fri 9/15/2006 10:58 AM
To: arslist@ARSLIST.ORG
Subject: Re: Two different Condition 's in Run If



It looks like it's missing some parenthesis

(NOT ((($OPERATION$ = "CREATE") AND ('Case ID+' = "HD")) OR
  (($OPERATION$ = "QUERY") AND ('Case ID+' = $NULL$

Without an extra ( after the NOT and ) at the end, the NOT is only
working on the 1st condition.

I should have layed it out in my normal method, sorry about that...

  (NOT (
 (($OPERATION$ = "CREATE") AND ('Case ID+' = "HD"))
   OR
 (($OPERATION$ = "QUERY") AND ('Case ID+' = $NULL$))
   )
  )


Fred


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kohli, Himanshu
Sent: Friday, September 15, 2006 9:43 AM
To: arslist@ARSLIST.ORG
Subject: Re: Two different Condition 's in Run If

Hi Fred

No even what you have suggested this time didn't worked  :(

1) First options of yours fail for both the scenario's i.e. CREATE &
QUERY
2) Second option i.e. by making a swap by using a NOT works only for the
first condition ( i.e. Query or Create ..which ever is mentioned before
the OR )

(NOT (($OPERATION$ = "CREATE") AND ('Case ID+' = "HD")) OR(($OPERATION$
= "QUERY") AND ('Case ID+' = $NULL$)))  ==>  Works for CREATE

(NOT (($OPERATION$ = "QUERY") AND ('Case ID+' = $NULL$)) OR
(($OPERATION$ = "CREATE") AND ('Case ID+' = "HD")))  ==>  Works for
QUERY


Looking forward to crack this simple :( stuff with your Help & Info

Himanshu




From: Action Request System discussion list(ARSList) on behalf of
Grooms, Frederick W
Sent: Thu 9/14/2006 7:25 PM
To: arslist@ARSLIST.ORG
Subject: Re: Two different Condition 's in Run If



You want the error for these 2 conditions (and the error is in the
else).
 1) On Query when he has no Case Id selected or searched (i.e. Case ID =
Null )
 2) On Create when his Case ID has a default value ( Case ID = HD)

So those conditions would be:
 1. ($OPERATION$ = "QUERY") AND ('Case ID' = $NULL$)  2. ($OPERATION$ =
"CREATE") AND ('Case ID' = "HD")

So putting them together would be (This will give you the error in the
If):
 (($OPERATION$ = "QUERY") AND ('Case ID' = $NULL$)) OR  (($OPERATION$ =
"CREATE") AND ('Case ID' = "HD"))

You can either swap the actions or NOT the entire criteria:
 (NOT (($OPERATION$ = "QUERY") AND ('Case ID' = $NULL$))
  OR (($OPERATION$ = "CREATE") AND ('Case ID' = "HD")))

Fred


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kohli, Himanshu
Sent: Thursday, September 14, 2006 3:11 PM
To: arslist@ARSLIST.ORG
Subject: Re: Two different Condition 's in Run If

James

It so simple but making me really crazy about it ...

ok let me try to explain you briefly

I want to block a user action on a Button Click to open a new Window and
to include both the condition's in a single ACTL's Run If

1) On Query when he has no Case Id selected or searched (i.e. Case ID =
Null )
2) On Create when his Case ID has a default value ( Case ID = HD)

Now I am trying that

Run If  ==>  ('Case ID' != $NULL$)  OR ('Case ID' != "HD")

If  Action ==>  Open the Window

Else If==>  Error Msg


Result : If I use only one of each condition in the Run If ..it works as
desired but fails when I try to use both with "OR"

I beleive its somthing to relate with the execution of an ACTL at two
different Operation'

Re: Two different Condition 's in Run If

2006-09-15 Thread McKenzie, James J C-E LCMC HQISEC/L3

Title: RE: Two different Condition 's in  Run If
**





Himanshu:


Maybe I can make this simple.  You were checking if a condition(s) did NOT exist.  Thus, if the condition existed, you wanted a message as an ELSE condition.  I would do the reverse and make the condition when I seen the message and the else condition would open the window, and you would have only one Active Link (you almost did this below with an AL that fired on Seq # 1 with no condition.)  It is very hard to think in a NOT state for most people and that is why there are very few ELSE condition actions.

James McKenzie
L-3 GSI
 


-Original Message-
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kohli, Himanshu
Sent: Friday, September 15, 2006 8:51 AM
To: arslist@ARSLIST.ORG
Subject: Re: Two different Condition 's in Run If


Oh yeah at last this worked as desired  yup with an extra ' ( ' made things look good for both the condition's
 
Thanks a lot Fred , James & Carey & others too
 
Now I can say I will have a nice weekend :)  as my intention to save system from creating two ACTL's has been succesful 

 
 even though I am still trying to guess why without using a 'NOT' clause I am having problem
 
 
Okay for all, the other way it worked was by creating two diff ACTL's and only making use of If Action in both of them ( so no messing up with Else If )

 
 
 
1) IMF:HPD:OpenLandownForm02 ==> Execution Order = 0 , Execute On = Button
 Run IF = (($OPERATION$ =  "CREATE" ) AND ( 'Case ID+' =  "HD" )) OR (($OPERATION$ =  "QUERY" ) AND ( 'Case ID+' =  $NULL$ ))

 If Action  = Msg
 
 
2) IMF:HPD:OpenLandownForm03 ==> Execution Order = 1 , Execute On = Button
    Run IF =  No condition ...as I need to execute this all the time other than my above covered 2 condition's
    If Action  = Open Window 
 
So this was a another simple way in which I was able to get my desired Result but I was required to have 2 ACTL's ,,,which was not making me feel good

 
 
Wishing you all a Wonderful Weekend ...
 
Himanshu Kohli
Remedy Developer / Administrator
 
PS : Just to share that from my persoal exp till date ... I found my solutions for my Problems more quickly with you all in the AR List than from the Support  

 
 
 





From: Action Request System discussion list(ARSList) on behalf of Grooms, Frederick W
Sent: Fri 9/15/2006 10:58 AM
To: arslist@ARSLIST.ORG
Subject: Re: Two different Condition 's in Run If




It looks like it's missing some parenthesis


(NOT ((($OPERATION$ = "CREATE") AND ('Case ID+' = "HD")) OR
  (($OPERATION$ = "QUERY") AND ('Case ID+' = $NULL$


Without an extra ( after the NOT and ) at the end, the NOT is only working on the 1st condition.


I should have layed it out in my normal method, sorry about that...


  (NOT (
 (($OPERATION$ = "CREATE") AND ('Case ID+' = "HD"))
   OR
 (($OPERATION$ = "QUERY") AND ('Case ID+' = $NULL$))
   )
  )



Fred



-Original Message-
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kohli, Himanshu
Sent: Friday, September 15, 2006 9:43 AM
To: arslist@ARSLIST.ORG
Subject: Re: Two different Condition 's in Run If


Hi Fred


No even what you have suggested this time didn't worked  :(


1) First options of yours fail for both the scenario's i.e. CREATE & QUERY
2) Second option i.e. by making a swap by using a NOT works only for the first condition ( i.e. Query or Create ..which ever is mentioned before the OR )

(NOT (($OPERATION$ = "CREATE") AND ('Case ID+' = "HD")) OR(($OPERATION$ = "QUERY") AND ('Case ID+' = $NULL$)))  ==>  Works for CREATE

(NOT (($OPERATION$ = "QUERY") AND ('Case ID+' = $NULL$)) OR (($OPERATION$ = "CREATE") AND ('Case ID+' = "HD")))  ==>  Works for QUERY


Looking forward to crack this simple :( stuff with your Help & Info


Himanshu






From: Action Request System discussion list(ARSList) on behalf of Grooms, Frederick W
Sent: Thu 9/14/2006 7:25 PM
To: arslist@ARSLIST.ORG
Subject: Re: Two different Condition 's in Run If




You want the error for these 2 conditions (and the error is in the else).
 1) On Query when he has no Case Id selected or searched (i.e. Case ID = Null )
 2) On Create when his Case ID has a default value ( Case ID = HD)


So those conditions would be:
 1. ($OPERATION$ = "QUERY") AND ('Case ID' = $NULL$)  2. ($OPERATION$ =
"CREATE") AND ('Case ID' = "HD")


So putting them together would be (This will give you the error in the
If):
 (($OPERATION$ = "QUERY") AND ('Case ID' = $NULL$)) OR  (($OPERATION$ =
"CREATE") AND ('Case ID' = "HD"))


You can either swap the actions or NOT the entire criteria:
 (NOT (($OPERATION$ = "QUERY") AND ('Case ID' = $NULL$))
  OR (($OPERATION$ = "CREATE") AND ('Case ID' = "HD")))


Fred



-Original Message-
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG]

email engine - template question

2006-09-15 Thread Anthony Caressimo

Hi All

I am working with the email engine (6.3 p18) using templates.
It is an html template and have one graphic in the template.

I currently reference this in the html 
I have the template saved in the AR Email Template form with the pic.gif 
file saved as an attachment for the template.

My question: is there any special way to reference the attached graphic in 
the html?
I get the notification but the pic has an x where it should be.

thanks all.

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

Re: email engine - template question

2006-09-15 Thread Dan Caissie

When I create a template I just enter it like this.

When it's entered into Remedy it will change it for you.

Works for me.


Dan Caissie
Remedy Administrator / Developer
United Natural Foods, Inc
260 Lake rd
Dayville, CT 06241
(860) 779-2800
Ext: 32380

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Anthony Caressimo
Sent: Friday, September 15, 2006 12:15 PM
To: arslist@ARSLIST.ORG
Subject: email engine - template question

Hi All

I am working with the email engine (6.3 p18) using templates.
It is an html template and have one graphic in the template.

I currently reference this in the html 
I have the template saved in the AR Email Template form with the pic.gif

file saved as an attachment for the template.

My question: is there any special way to reference the attached graphic
in 
the html?
I get the notification but the pic has an x where it should be.

thanks all.


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

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

Re: request crashing user tool - malloc failed

2006-09-15 Thread Axton


This can happen if you have a large diary/unlimited text field.  If
you are using Oracle, there are some configuration parameters you need
to set to handle large clobs.  the same is true of attachments, but
you have stated there are none.

Use this select statement to find the size of the diary field values:

select length(audit_trail)
from hpd_helpdesk
where audit_trail is not null
order by length(audit_trail) desc

substituting your db view/columns, of course.

In the ar.conf file, check for the presense of these values:
Db-Max-Text-Size
Db-Max-Attach-Size (if you had been using attachments)

Pulling  values that exceed these config parameters (or the default
value for the parameter) will cause arserverd to crash.

Axton Grams

On 9/15/06, McKenzie, James J C-E LCMC HQISEC/L3
<[EMAIL PROTECTED]> wrote:

**
Nyall:

I would have to look into this, but we did this at one place that I worked
at because we did have diary problems.  I think it took a stored procedure
and then calling that procedure and then sorting the top ten.  We would run
this and get the results as a mail message with them.  We sent it to a local
mailbox on a UNIX system.

James Mckenzie


From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Nyall McCavitt
Sent: Friday, September 15, 2006 8:38 AM

To: arslist@ARSLIST.ORG
Subject: Re: request crashing user tool - malloc failed


To: arslist@ARSLIST.ORG
Subject: Re: request crashing user tool - malloc failed


** Hi,

I think that you are along the correct lines here except that I don't expect
that for these particular entries that there would be any large diary
entries but as I am rusty on SQL then I am not sure of the exact Oracle
commands required to verify the size of the relevant fields. Any pointers
would be gratefully received.

I have checked that the relevant T,H and B tables are consistent with the
number of entries in each.

Thanks.

Nyall

McKenzie, James J C-E LCMC HQISEC/L3 wrote:
**

Nyall and Raido:

I'm willing to state that the affected action has a very large diary or
attachment associated with it.  If you attempt to export the record from
your database, Oracle can handle the data collection, but Remedy cannot.
Thus, you see a large increase in memory usage and then the crash.  If you
care to explore, you can look at the CLOB storage for that record and find
the record is very large.  Don't know how this happens as the limit for a
diary field under Oracle is 1MB of text.

If you need help, I think that I can provide a little bit of it.
__20060125___This posting was submitted
with HTML in it___
__20060125___This posting was submitted
with HTML in it___


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

Re: request crashing user tool - malloc failed

2006-09-15 Thread McKenzie, James J C-E LCMC HQISEC/L3

Title: RE: request crashing user tool - malloc failed
**





Axton:


Thank you for the Oracle code.  I was banging my head against the wall trying to figure this one out.


I hope that the writing of a diary/unlimited text field LARGER than either the default or set parameter is fixed.  It was not in 4.0.3 nor 4.5.2.  This led to a major effort to check tickets on a daily basis to trim the Diary type field data of those actions that were getting close to or had exceeded this value.  BTW, administrator type logins did not get the malloc error but non-administrator logins did.

James Mckenzie
 


-Original Message-
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Axton
Sent: Friday, September 15, 2006 10:53 AM
To: arslist@ARSLIST.ORG
Subject: Re: request crashing user tool - malloc failed


This can happen if you have a large diary/unlimited text field.  If you are using Oracle, there are some configuration parameters you need to set to handle large clobs.  the same is true of attachments, but you have stated there are none.

Use this select statement to find the size of the diary field values:


select length(audit_trail)
from hpd_helpdesk
where audit_trail is not null
order by length(audit_trail) desc


substituting your db view/columns, of course.


In the ar.conf file, check for the presense of these values:
Db-Max-Text-Size
Db-Max-Attach-Size (if you had been using attachments)


Pulling  values that exceed these config parameters (or the default value for the parameter) will cause arserverd to crash.

Axton Grams


On 9/15/06, McKenzie, James J C-E LCMC HQISEC/L3 <[EMAIL PROTECTED]> wrote:
> **
> Nyall:
>
> I would have to look into this, but we did this at one place that I 
> worked at because we did have diary problems.  I think it took a 
> stored procedure and then calling that procedure and then sorting the 
> top ten.  We would run this and get the results as a mail message with 
> them.  We sent it to a local mailbox on a UNIX system.
>
> James Mckenzie
>
> 
> From: Action Request System discussion list(ARSList) 
> [mailto:arslist@ARSLIST.ORG] On Behalf Of Nyall McCavitt
> Sent: Friday, September 15, 2006 8:38 AM
>
> To: arslist@ARSLIST.ORG
> Subject: Re: request crashing user tool - malloc failed
>
>
> To: arslist@ARSLIST.ORG
> Subject: Re: request crashing user tool - malloc failed
>
>
> ** Hi,
>
> I think that you are along the correct lines here except that I don't 
> expect that for these particular entries that there would be any large 
> diary entries but as I am rusty on SQL then I am not sure of the exact 
> Oracle commands required to verify the size of the relevant fields. 
> Any pointers would be gratefully received.
>
> I have checked that the relevant T,H and B tables are consistent with 
> the number of entries in each.
>
> Thanks.
>
> Nyall
>
> McKenzie, James J C-E LCMC HQISEC/L3 wrote:
> **
>
> Nyall and Raido:
>
> I'm willing to state that the affected action has a very large diary 
> or attachment associated with it.  If you attempt to export the record 
> from your database, Oracle can handle the data collection, but Remedy cannot.
> Thus, you see a large increase in memory usage and then the crash.  If 
> you care to explore, you can look at the CLOB storage for that record 
> and find the record is very large.  Don't know how this happens as the 
> limit for a diary field under Oracle is 1MB of text.
>
> If you need help, I think that I can provide a little bit of it.
> __20060125___This posting was submitted with HTML 
> in it___ __20060125___This posting was submitted 
> with HTML in it___


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




__20060125___This posting was submitted with HTML in it___

Re: Sql process and hanging ARServer

2006-09-15 Thread Axton


Post the sql statemenst for the first two threads that enter the deadlock.

Read up:
http://www.mssqlcity.com/Articles/Adm/SQL70Locks.htm
http://support.microsoft.com/?kbid=832524

Axton Grams

On 9/15/06, Piotr Polewczak <[EMAIL PROTECTED]> wrote:

Hi,

i've got problem with hanging arserver, problem appears when one sql process
(connection from arserver) starts to lock other processes.

Command in blocking process is : sp_cursorclose;1
Resources locked by process are : ARSystem.dbo.servgrp_userlic,
ARSystem.dbo.user_cache, ARSystem.dbo.T10 (User)

after several minutes almost all arserver processes are locked by first
process and arserver hangs, in logs there is info :
Dispatch : Timeout during data retrieval due to busy server -- retry the
operation (server)  ARERR – 93

Problem appears in the high load of the system and when all licences are taken.

Enviroment :
2 x ARS 6.3 patch 18 (server group)
MSSQL2000
Windows 2003

Thanks for any help,
Peter

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



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

Re: DSO follow-the-sun examples

2006-09-15 Thread Thomas J. Mutaffis


Hi,

I did exactly this at Lucent Technologies and it work fine. We had three 
servers, one in England, another in Malvern, PA and a third in Sunnyvale, 
CA. Our purpose was exactly as what you've stated, to allow the tickets to 
"follow-the-sun" which in essence gave us coverage for 18 hours while only 
running one shift at each location. Each "shift" retained ownership of the 
ticket during their normal working day. At the end of the working day 
ownership was transferred to the next in line and so on. This worked out 
very well and all were satisfied with the results.


Hope this helps...

Tom




- Original Message - 
From: "arslist" <[EMAIL PROTECTED]>

Newsgroups: public.remedy.arsystem.general
To: 
Sent: Friday, September 15, 2006 3:17 AM
Subject: DSO follow-the-sun examples


Hi James, Alexander, and L. J. Head,

Thanks for your responses, I appreciate it.

Nevertheless, does someone knows about some concrete example of sites where 
DSO works with several servers in a follow-the-sun

mode? Which ones?

If I have some examples it's easier to convince the person.

I would be frustrated if they choose another tool than DSO for this ...
I am just consultant and we are not saling licenses, but just consultancy.
I don't want to have to implement something else than DSO...to make 
replication between ARS servers it would be an aberration in

my point of view.

Thanks again.

Ilidio Moreira da Silva
SILOGIS

"Alexander G. Zinoviev" a écrit :


Hi,

If you have wide DSO private thread (I have up to 16 threads), you have to 
make some calculations.

DSO speed depends mostly of remote response time.

I have response time (ping xxx.xxx.xxx.xxx) less then 10 ms (same subnet) 
and my DSO speed is 300-500 requests per a minute.


Best regards,
Alexander Zinoviev


ïÔ: Action Request System discussion list(ARSList) ÏÔ ÉÍÅÎÉ arslist
ïÔÐÒÁ×ÌÅÎÏ: þÔ, 14.09.2006 13:08
ëÏÍÕ: arslist@ARSLIST.ORG
ôÅÍÁ: DSO performances

Hi Dear ARS experts,

I have a customer who is fearing about the DSO performances: he never
saw it yet but someone told him some things like this...a competitor
surely...

The target is to make different ticketing servers repilcating submit,
changes and deletions in a "follow the sun mode" all around the world
(about 4 or 5 servers in different continents).

Does someone of you know one or more similar examples of implementations
that are running fine in a "follow the sun" mode?
I would appreciate that.
I beleive DSO is the best solution for him but I need to convince him.

He asked me also about a product called "Golden Gate"...?!
Does someone have an experience with this tool?

Kind Regards.

Ilidio Moreira da Silva

___
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: DSO follow-the-sun examples

2006-09-15 Thread McKenzie, James J C-E LCMC HQISEC/L3

Title: RE: DSO follow-the-sun examples
**





Tom:


HOW?  If you can release details.


James McKenzie
L-3 GSI
 


-Original Message-
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Thomas J. Mutaffis
Sent: Friday, September 15, 2006 11:05 AM
To: arslist@ARSLIST.ORG
Subject: Re: DSO follow-the-sun examples


Hi,


I did exactly this at Lucent Technologies and it work fine. We had three servers, one in England, another in Malvern, PA and a third in Sunnyvale, CA. Our purpose was exactly as what you've stated, to allow the tickets to "follow-the-sun" which in essence gave us coverage for 18 hours while only running one shift at each location. Each "shift" retained ownership of the ticket during their normal working day. At the end of the working day ownership was transferred to the next in line and so on. This worked out very well and all were satisfied with the results.

Hope this helps...


Tom





- Original Message -
From: "arslist" <[EMAIL PROTECTED]>
Newsgroups: public.remedy.arsystem.general
To: 
Sent: Friday, September 15, 2006 3:17 AM
Subject: DSO follow-the-sun examples



Hi James, Alexander, and L. J. Head,


Thanks for your responses, I appreciate it.


Nevertheless, does someone knows about some concrete example of sites where 
DSO works with several servers in a follow-the-sun
mode? Which ones?


If I have some examples it's easier to convince the person.


I would be frustrated if they choose another tool than DSO for this ...
I am just consultant and we are not saling licenses, but just consultancy.
I don't want to have to implement something else than DSO...to make 
replication between ARS servers it would be an aberration in
my point of view.


Thanks again.


Ilidio Moreira da Silva
SILOGIS


"Alexander G. Zinoviev" a écrit :


> Hi,
>
> If you have wide DSO private thread (I have up to 16 threads), you have to 
> make some calculations.
> DSO speed depends mostly of remote response time.
>
> I have response time (ping xxx.xxx.xxx.xxx) less then 10 ms (same subnet) 
> and my DSO speed is 300-500 requests per a minute.
>
> Best regards,
> Alexander Zinoviev
> 
>
> ïÔ: Action Request System discussion list(ARSList) ÏÔ ÉÍÅÎÉ arslist
> ïÔÐÒÁ×ÌÅÎÏ: þÔ, 14.09.2006 13:08
> ëÏÍÕ: arslist@ARSLIST.ORG
> ôÅÍÁ: DSO performances
>
> Hi Dear ARS experts,
>
> I have a customer who is fearing about the DSO performances: he never
> saw it yet but someone told him some things like this...a competitor
> surely...
>
> The target is to make different ticketing servers repilcating submit,
> changes and deletions in a "follow the sun mode" all around the world
> (about 4 or 5 servers in different continents).
>
> Does someone of you know one or more similar examples of implementations
> that are running fine in a "follow the sun" mode?
> I would appreciate that.
> I beleive DSO is the best solution for him but I need to convince him.
>
> He asked me also about a product called "Golden Gate"...?!
> Does someone have an experience with this tool?
>
> Kind Regards.
>
> Ilidio Moreira da Silva
>
> ___
> 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




__20060125___This posting was submitted with HTML in it___

Forms overlaying

2006-09-15 Thread L Feulner

ARS 6.3 hd 6 oracle 9i windows 2003 

I open a display only form from a link on the management console, then 
open the Solutions form by double clicking a value in the tablefield in 
this display only form.  The Solutions form opens and the data is 
correct.  The problem is the Solutions form is underneath the display only 
form.  I have to close the display only form to see the Solutions form.  I 
have tried opening the Solutions form in an active link as a Dialog window 
type and also as a Modify window type.  What do I need to look at/change 
to get the Solutions form to appear on top of the display only form?

Liz 

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

Re: Forms overlaying

2006-09-15 Thread Grooms, Frederick W

Is your Display Only form being opened as a Dialog? 

Fred

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of L Feulner
Sent: Friday, September 15, 2006 2:26 PM
To: arslist@ARSLIST.ORG
Subject: Forms overlaying

ARS 6.3 hd 6 oracle 9i windows 2003 

I open a display only form from a link on the management console, then
open the Solutions form by double clicking a value in the tablefield in
this display only form.  The Solutions form opens and the data is
correct.  The problem is the Solutions form is underneath the display
only form.  I have to close the display only form to see the Solutions
form.  I have tried opening the Solutions form in an active link as a
Dialog window type and also as a Modify window type.  What do I need to
look at/change to get the Solutions form to appear on top of the display
only form?

Liz 

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

43 matches

Mail list logo