Re: Mid-Tier 7.0 Installation Problem
SunOS != Solaris The operating system is SunOS, and Solaris is the package with operating system plus windowing system plus extra software Ie: Solaris 2.0 contain SunOS 5.0, Solaris 10 contain SunOS 5.10 -- Jarl On 9/14/06, Rick cook [EMAIL PROTECTED] wrote: ** I figured as much, since that's what they did with the Solaris version numbers a few years back. Went from 2.5 to 6.0, which was also 2.6. Thanks, David. Rick From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Easter, David Sent: Thursday, September 14, 2006 8:40 AM To: arslist@ARSLIST.ORG Subject: Re: Mid-Tier 7.0 Installation Problem To: arslist@ARSLIST.ORG Subject: Re: Mid-Tier 7.0 Installation Problem ** Sun Microsystems Refers to Java 1.5 as 5.0. See http://java.sun.com/j2se/j2se-namechange.html for more details. That's why the matrix lists 5.0 rather than 1.5 - they are the same thing, however. -David J. Easter Sr. Product Manager, Service Management Business Unit BMC Software, Inc. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick cook Sent: Thursday, September 14, 2006 7:55 AM To: arslist@ARSLIST.ORG Subject: Re: Mid-Tier 7.0 Installation Problem ** Compatibility matrix shows 1.4.2 and 5.0 as supported versions for MT 7. Assuming that 1.5 = 5.0, has anyone installed ARS 7 MT with Java 1.5/5.0 successfully? Rick 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 7:41 AM To: arslist@ARSLIST.ORG Subject: Re: Mid-Tier 7.0 Installation Problem ** Pam: Make sure that no other version of Java is in the PATH statement. James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Pam Hollis Sent: Wednesday, September 13, 2006 8:27 AM To: arslist@ARSLIST.ORG Subject: Re: Mid-Tier 7.0 Installation Problem That is what I thought - and I am using that directory usr/lib/jvm - but it keeps telling me a non-supported version is installed - but we clearly installed 1.5. Pam Hollis Senior Programmer - Remedy Tractor Supply Company (615 )366-4617 (telephone) (615) 277-4617 (fax) -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dave Zifchock Sent: Wednesday, September 13, 2006 10:20 AM To: arslist@ARSLIST.ORG Subject: Re: Mid-Tier 7.0 Installation Problem Pam, Yes this is the java installation directory on the box that you are installing it on. ie /usr/java1.4 or something to that affect. Dave ___ 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___ __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: Question: Password Change
Updates, inserts, and deletes performed by filters push/set field actions do not require a license. Only direct user interaction and active link push fields actions require the appropriate license. Axton Grams Ben Chernys wrote: You cannot MODIFY a record with a read license. You can create a new record so it is there that you can capture the date of the password change. I had to do this to introduce a password expiry scheme and retain a configurable number of password histories so that they could not be used again. So, issue a push to a new form with date and userid. That new form can DELETE any other records already extant for that same user (a history depth of 1 or just the date of last change. Deletions seem not to count as updates (a touch strange - that). To use the value, you'll have to do a set fields when you need to in the user form. Cheers Ben Chernys -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Candace DeCou Sent: September 14, 2006 4:44 PM To: arslist@ARSLIST.ORG Subject: Re: Question: Password Change I believe the field has to be in one of Remedy's reserved range. Look at the DB values of the fields in the User form and try to use one that is close but different than the others. You will have to rebuild your field for this to work. :) Candace -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tyrone Dee Sent: Thursday, September 14, 2006 7:42 AM To: arslist@ARSLIST.ORG Subject: Re: Question: Password Change Yes, but it is saying I don't have write permissions to this field. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Herb Partlow Sent: Thursday, September 14, 2006 10:15 AM To: arslist@ARSLIST.ORG Subject: Re: Question: Password Change Tyrone Did you check, Public and allow any one to submit Herb -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of T. Dee Sent: Thursday, September 14, 2006 7:03 AM To: arslist@ARSLIST.ORG Subject: Question: Password Change I have created my own password change form for the users - this works fine. The only question I have is there a way to capture the date they changed their password. I have created a field on the user form, but I when I try to push the date to this field I get a error when a user with Read Only rights tries to do this. 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 - * This message contains information from Silicon Valley Bank, or from one of its affiliates, that may be confidential and privileged. If you are not an intended recipient, please refrain from any disclosure, copying, distribution or use of this information and note that such actions are prohibited. If you have received this transmission in error, please notify the sender immediately by telephone or by replying to this transmission. This message may include indicative rate information relating to one or more products offered through Silicon Valley Bank, or affiliated broker-dealer, SVB Securities. Rates and yields shown are provided for informational purposes only, are not guaranteed, and are subject to market conditions and availability. Nothing in this communication shall constitute a solicitation or recommendation to buy or sell a particular security. Columbia Cash Reserves, Columbia Treasury Reserves, Columbia Institutional Cash Reserves, SVB Securities Liquid Reserves, SVB Securities Institutional Liquid Reserves and SVB Securities Horizon Shares are offered through SVB Securities, a registered broker- dealer and non-bank affiliate of Silicon Valley Bank. Investments in these products require the involvement of a licensed representative of SVB Securities. Investment products offered through SVB Securities are not insured by the FDIC or any other Federal Government Agency, are not deposits of or guaranteed by Silicon Valley Bank or its affiliates, and may lose value. ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
How to capture workflow errors in Filters
** 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 __20060125___This posting was submitted with HTML in it___
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
Webservcies GetListOutputMap/GetListInputMap
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
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
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
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
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
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 RD 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
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 port -U AdminUser -P AdminPassword -o
test
-f User -q 'Login Name' = UserInQuestion
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 two servers
Ah.. but...
Use the Runmacro that fits the right _shoe_. :) [ I even
request crashing user tool - malloc failed
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
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
**
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 ANDCaseID = NULLStatus =
NULLAND 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
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: request crashing user tool - malloc failed
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
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 toimport 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
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
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 ='form name'; Select count (c1) from tschemaid; Select count (c1) from hschemaid; Select count (e1) from bschemaid; 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 Hschemaid 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 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
Re: request crashing user tool - malloc failed
** 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 ='form name'; Select count (c1) from tschemaid; Select count (c1) from hschemaid; Select count (e1) from bschemaid; 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 Hschemaid 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
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 #8211; 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
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 mentioned 'Run
If ' condition
( 'Status' != New
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'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
Re: Two different Condition 's in Run If
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@ARSLIST.ORG
Subject: Re: Mid-Tier 7.0
Re: Approvals
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: 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:[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 http://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] mailto:[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] 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
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 http://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
Re: Two different Condition 's in Run If
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 )) OR
(('Status'
!= $NULL$) AND ('Case ID+' != $NULL$))
Re: request crashing user tool - malloc failed
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
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
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's CREATE QUERY on Help Desk form.
I am having
ARS 6.3 ,
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 img src=pic.gif 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
When I create a template I just enter it like this. img src=c:\pic.gif 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 img src=pic.gif 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
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
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
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 #8211; 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
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: arslist@ARSLIST.ORG 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
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: arslist@ARSLIST.ORG 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
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
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
