Re: ARERR (302) Entry does not exist in database dilemma

[Pruitt, Christopher J]

This is not the case. These are brand new joins that have never used. We have 
validated that the views are there. 

This appears to be a bug in Remedy and how it handles this nested join with the 
Remedy User tool.

The join does not have any issues when called from outside of the Remedy User 
tool(i.e. direct Database level queries to that very same nested join).

 
Christopher Pruitt 
Consultant Specialist
EDS - Bank of America
I3-Inventory IW Infrastructure Team
Phone: +1-972-605-7702 (8-835) 
mailto:[EMAIL PROTECTED]
 
Confidentiality Notice: This message and any files transmitted with it are 
intended for the sole use of the entity or individual to whom it is addressed, 
and may contain information that is confidential, privileged, and exempt from 
disclosure under applicable law. If you are not the intended addressee for this 
e-mail, you are hereby notified that any copying, distribution, or 
dissemination of this e-mail is strictly prohibited. If you have received this 
e-mail in error, please immediately destroy, erase, or discard this message. 
Please notify the sender immediately by return e-mail if you have received this 
e-mail by mistake.



From: Action Request System discussion list(ARSList) on behalf of Opela, Gary L 
Contr OC-ALC/ITMA
Sent: Mon 2/12/2007 4:00 PM
To: arslist@ARSLIST.ORG
Subject: Re: ARERR (302) Entry does not exist in database dilemma


** 

It sounds like one of your remedy views has gotten dropped.

 

Since your remedy joins are on the views, and your oracle sql you are running 
is against the t-tables, this would agree.

 


Additionally, in the past, whenever I have had join forms that would return 
results list, but then no actual ticket data in the details section of the user 
tool window, it was always because a view form was dropped.


Try opening up each of the view forms in the user tool to make sure they all 
exist. Additionally, you might check on the database level to make sure the 
view forms are there.

 

I know that it can get tricky whenever you have nested joins. If you do 
something that causes one of the lowest level joins to be rebuilt, then you run 
the risk of remedy not properly rebuilding all joins.

 

Example:

 

 A

 B   C

 DE

 

Where A is a join of B and C, and C is a join of D and E, I've seen in the past 
where you modify form E that causes the view to be dropped/recreated, and 
occastionally A will get dropped. This gets tricky if you have other forms that 
are joins of A and, say, F, then you don't have the visibility to see that A is 
broken.

 

Check this out to see if it is the problem. This is the easiest to fix: just 
find the broken join form, open it up in admin tool, move a field and hit save.

 

If all of your forms are SQL views, then you will need to re-run your sql query 
to rebuild the view. Start at the bottom so you don't re-break everything once 
you're finished.

 



From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Pruitt, Christopher J
Sent: Monday, February 12, 2007 3:48 PM
To: arslist@ARSLIST.ORG
Subject: ARERR (302) Entry does not exist in database dilemma

 

I have a question that has now stumped several DBAs and Remedy Developers now 
and was hoping someone on this list may have a answer.

We have a Join that is nested with other joins, however, when we perform a 
query via the Remedy User tool it returns an "ARERR (302) Entry does not exist 
in database".

To make matters worse, on the User Tool it returns 792 records of which 60% 
display this error and the remaining 40% do not and before anyone says there 
are missing records. We have 3 primary data forms included in these joins and 
all of them have the corrected and needed data in them.

Now here is the issue. When we perform the same query at the Oracle level it 
returns all the records correctly. 

This is the query that is run from the Remedy User Tool (when I turn on SQL and 
API logging).
SELECT aradmin.T5092.C1,C8 FROM aradmin.T5092 WHERE (E0 = 'ACI-0001025' and 
E1 = 'LOC5915' and E2 IS NULL and E3 = 'EBL-590' ) ORDER BY 1 
ASC

It returns no record 
However, when I modify the query based on the structure of our Join it returns 
the record. 
SELECT aradmin.T5092.C1,C8 FROM aradmin.T5092 WHERE (E0 = 'ACI-0001025' and 
E1 = 'LOC5915' and E2 IS NULL and E3 IS NULL and E4 = 'EBL-590' 
) ORDER BY 1 ASC

E0 and E1 are from the Tele_Location_Join and E2 and E3 should be from the 
Location RecType_Join and E4 should be from the Load Data Form, however, what 
is happening via the User Tool is E0 and E1 are from the Tele_Location_Join and 
E2 and E3 should be from the Location RecType_Join and it never includes the E4 
and the E3 value should be the E4 value and E3 should be null 

This is our Join Structure: 
Reporting_Form_Join 

An oute

Re: What Solaris 9 Environment Variables do you use for AR System 7.x?

[Mike Gould]

Hi Axton,

Sorry, forgot to include those settings.  We will be using English only with
non-Unicode.

Hope that answers the questions.

Mike


On 2/13/07, Axton <[EMAIL PROTECTED]> wrote:


** What (remedy) languages will you be using and what is the oracle
instance character set?

Axton Grams

On 2/12/07, Mike Gould < [EMAIL PROTECTED]> wrote:
>
> ** Hi List,
>
> I was wondering if anyone would be willing to share the Solaris 9
> environment variables they use on their AR System 7.0.x server?  Also,
> are there any special settings you use just during installation vs. normal
> operations?  I basically know enough about Unix to get myself into trouble,
> so any tips and tricks on the OS side to help with the installation,
> maintenance and performance of our AR server, which you could pass
> along, would be most appreciated.
>
> Thanks in advance,
> Michael J. Gould
> U.S. House of Representatives
>
> OS: Solaris 9
> DB: Oracle 10gR2
> Java: J2SDK 1.4.2_12
> Web: Apache Tomcat (bundled version with Midtier)
> AR System: 7.0.01 (soon to be with Patch 01)
> CMDB: 2.0.01 (soon to be with Patch 02)
> Apps: ITSM 7.0.02 (w/ Patch 03)
>
>
> __20060125___This posting was submitted with HTML in
> it___


__20060125___This posting was submitted with HTML in
it___


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

Re: What Solaris 9 Environment Variables do you use for AR System 7.x?

[Axton]

What (remedy) languages will you be using and what is the oracle instance
character set?

Axton Grams

On 2/12/07, Mike Gould <[EMAIL PROTECTED]> wrote:


** Hi List,

I was wondering if anyone would be willing to share the Solaris 9
environment variables they use on their AR System 7.0.x server?  Also, are
there any special settings you use just during installation vs. normal
operations?  I basically know enough about Unix to get myself into trouble,
so any tips and tricks on the OS side to help with the installation,
maintenance and performance of our AR server, which you could pass
along, would be most appreciated.

Thanks in advance,
Michael J. Gould
U.S. House of Representatives

OS: Solaris 9
DB: Oracle 10gR2
Java: J2SDK 1.4.2_12
Web: Apache Tomcat (bundled version with Midtier)
AR System: 7.0.01 (soon to be with Patch 01)
CMDB: 2.0.01 (soon to be with Patch 02)
Apps: ITSM 7.0.02 (w/ Patch 03)


__20060125___This posting was submitted with HTML in
it___


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

Filter is not saving the reference server name (DLHHP060.DLH.ST.COM) in DSO Action.

[Tarun Kumar SHARMA]

Hello,

We are facing a problem regarding DSO server reference. We are using DSO action 
in a filter STM:HelpDeskDLHHP060 with option Distributed Transfer. We are 
putting mapping name=STM:HelpDesk1DLHHP060, Server=dlhhp060.dlh.st.com, 
Form=HPD:Helpdesk. We are also making Distributed Mapping STM:HelpDesk1DLHHP060 
from server del08mis.dlh.st.com to dlhhp060.dlh.st.com for HPD:Helpdesk form. 
Mapping was saved correctly with server dlhhp060.dlh.st.com.

Server dlhhp060.dlh.st.com is using temporary DSO license with type Demo. While 
putting ticket on del08mis.dlh.st.com server. The ticket is going correctly on 
dlhhp060.dlh.st.com server also. But while after closing filter and again 
opening filter STM:HelpDeskDLHHP060, mapping name has been changed by itself 
from dlhhp060.dlh.st.com to del08mis.dlh.st.com (current server name). Same is 
happening for other filters while we are making reference for 
dlhhp060.dlh.dt.com server. This field value has either changed to the current 
server name or become blank. We are saving filters and all with user Demo which 
is also available on dlhhp060 server. Though the filter's reference was 
overridden by mapping reference in this case. But we are also using some direct 
reference by filter while using option Distributed delete. In this case after 
saving server name value in filter with Distributed Delete and closing and 
again opening we found server value NULL.

DSO instance on server DLHHP060.DLH.ST.COM is up. Could you please suggest why 
other servers (eg. Del08mis.dlh.st.com) are not saving the reference name for 
dlhhp060.dlh.st.com server ? Does temp DSO with type Demo create problem ? 
Please share.

Regards,
Tarun
199-6082

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

What Solaris 9 Environment Variables do you use for AR System 7.x?

[Mike Gould]

Hi List,

I was wondering if anyone would be willing to share the Solaris 9
environment variables they use on their AR System 7.0.x server?  Also, are
there any special settings you use just during installation vs. normal
operations?  I basically know enough about Unix to get myself into trouble,
so any tips and tricks on the OS side to help with the installation,
maintenance and performance of our AR server, which you could pass
along, would be most appreciated.

Thanks in advance,
Michael J. Gould
U.S. House of Representatives

OS: Solaris 9
DB: Oracle 10gR2
Java: J2SDK 1.4.2_12
Web: Apache Tomcat (bundled version with Midtier)
AR System: 7.0.01 (soon to be with Patch 01)
CMDB: 2.0.01 (soon to be with Patch 02)
Apps: ITSM 7.0.02 (w/ Patch 03)

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

Re: Oracle LOB relocation

[Axton]

Manage the log storage through the ardb.conf file.  Don't let the dba do it
directly on the db.  This will cause endless headaches for you and them.
Probably the best approach would be:

- set up the server
- create the ardb.conf file to define the log storage
- have the dba's manually move the lobs while arserver is stopped
- start arserver

You will more than likely need to experiment with the ardb.conf and some
test forms to make sure you get the syntax right.  Taking this approach (the
best I can see at the moment) has several advantages:
- installer gets to run as it normally would
- dba's feel cozy because they witnessed the relocation of the lobs
- the lobs will be managed on an ongoing basis by the ardb.conf file

Some things to keep in mind:
- you will need to update the ardb.conf every time a new lob is added (prior
to adding the lob); failure to do so will cause the lob to be stored in the
same tablespace as tables/indexes
- the ardb.conf file had some issues in 6.0.1 with length limitations on the
clauses (300 something characters).  I am not sure if this issue exists in
the later releases

Some other things your dba's may want to look into as far as performance
tuning if you go this route (these are possible using the ardb.conf file as
well):
- index storage
- table/index partitioning

Axton Grams

On 2/12/07, Tucker, Rob <[EMAIL PROTECTED]> wrote:


** We are getting ready to stand up ITSM 7 on Oracle 10G.

My DBA's want to relocated all the lobs in particularly HPD:Help Desk

I grew up with SQL Server and am not:


   - Sure what it is they are wanting to do
   - Sure that Remedy will allow them to do what they are planning to
   do

Is there anyone out there who would shout "NO!  GO BACK!  DO NOT PASS GO!"

or this something perfectly reasonable and doable?

Thanks,

-Rob



 
*Rob Tucker *
* New Edge Networks  ARS Administration and Development* [EMAIL PROTECTED]
  *  **Vancover,Washington*  tel: 360-759-9670
fax:360-693-9997


__20060125___This posting was submitted with HTML in
it___


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

Re: IVR & Remedy

[Soria, Joe]

Den,

What IVR system are you using? We are currently communicating back and forth 
between our IVR system and Remedy. It was very easy to setup.

Joe


-Original Message-
From:   Action Request System discussion list(ARSList) on behalf of Den Fong
Sent:   Mon 2/12/2007 4:32 PM
To: arslist@ARSLIST.ORG
Cc: 
Subject:IVR & Remedy

Has anyone integrated IVR technology, (interactive voice recognition)? 
We are looking at this for one of our projects and are looking at costs,
feasibility etc...
 
Thanks
 
Den
 
ARS 6.3 patch 20  (by end of month).
 
 

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




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

PKI Authentication - Windows User/Admin Tools

[Rebecca Hammond]

Has anyone been able to set up PKI Authentication for users who access the
system (ARS 7.01) using  the Windows Clients (User/Admin)?

 

We know we can configure our Web Server to do our PKI (Certificate)
authentication for us, then customize the .properties file, etc, to set up
SSO (using the new 7.x documentation for this).  Our plan is to handle all
of the Web authentication outside of ARS, and assume if the user made it
past the Web Server (BEA WebLogic)'s Certificate checks, the user is ok.  We
just authorize based on the User dn= we get from the header.

 

Where we're having issues now is in terms of having "strong" authentication
for users on the Windows clients.  We have users who will need access to the
system that way (because the Web, no matter "how much better" the 7.x
Mid-Tier "is" aka "is supposed to be"), not to mention our Admins who will
need to use the Admin tool.  IT Security is telling us that anyone with
Admin access must use "Strong Authentication", or in other words, PKI.  LDAP
Authentication just isn't going to cut it with them.

 

Any thoughts?

 

Sincerely,


Rebecca Hammond 

__20060125___This posting was submitted with HTML in
it___

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

IVR & Remedy

[Den Fong]

Has anyone integrated IVR technology, (interactive voice recognition)? 
We are looking at this for one of our projects and are looking at costs,
feasibility etc...
 
Thanks
 
Den
 
ARS 6.3 patch 20  (by end of month).
 
 

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

Oracle LOB relocation

[Tucker, Rob]

We are getting ready to stand up ITSM 7 on Oracle 10G.
 
My DBA's want to relocated all the lobs in particularly HPD:Help Desk
 
I grew up with SQL Server and am not:
 

*   Sure what it is they are wanting to do
*   Sure that Remedy will allow them to do what they are planning to
do

Is there anyone out there who would shout "NO!  GO BACK!  DO NOT PASS
GO!"
 
or this something perfectly reasonable and doable?
 
Thanks,
 
-Rob
 
 
 

Rob Tucker 
New Edge Networks  ARS Administration and Development
[EMAIL PROTECTED] 
  Vancover,Washington   
tel: 360-759-9670
fax:360-693-9997
 
 

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

Re: Server Alias

[Tucker, Rob]

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Sullivan, Neil G CTR USAF
AFRL/SNOD
Sent: Monday, February 12, 2007 11:08 AM
To: arslist@ARSLIST.ORG
Subject: Re: Server Alias


** 
Yes.  We change it and restarted the services.  After logging in and
going to the server properties, the license file showed only 3 licenses,
but when we reset everything, the licenses appear and everything works,
EXCEPT we can't open Vendor forms.



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W
Sent: Monday, February 12, 2007 1:34 PM
To: arslist@ARSLIST.ORG
Subject: Re: Server Alias


** 
Did you check the armonitor.cfg (since that has the server name in it) 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Sullivan, Neil G CTR USAF
AFRL/SNOD
Sent: Monday, February 12, 2007 12:06 PM
To: arslist@ARSLIST.ORG
Subject: Re: Server Alias


** 
Fred,
 
Tried your suggestion, but no success.
 
Sully



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W
Sent: Monday, February 12, 2007 11:25 AM
To: arslist@ARSLIST.ORG
Subject: Re: Server Alias


** 
It sounds like you still have something in your system referencing the
old alias.  Can you look in the ar.cfg file and see if it has the old
alias listed.  You should see a C:\Program Files\Common Files\AR
System\Licenses\newAlias folder.  If not you can create one and copy the
files from the oldAlias into it.  You may need to also edit the
armonitor.cfg file and make sure it also has the new alias name in it.
 
Fred




From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Sullivan, Neil G CTR USAF
AFRL/SNOD
Sent: Monday, February 12, 2007 10:14 AM
To: arslist@ARSLIST.ORG
Subject: Server Alias


** 

We recently changed the hostid on our server and purged the licenses to
the new hostid, but my users are getting the following error if I enter
the new hostname in the server alias field.

"ARERR [8760] Cannot establish a network connection to the AR System
Plug-In server :  : RPC: Name to address translation
failed - No such hostname". 

Where I have  is the name I see when I go to File ->
Server information in the Remedy Administrator tool. This is not the
hostname of our current remedy server. It is the name of the old remedy
server. I tried to change the name from the Remedy Administrator tool
which it let me do, but when I try to log in after restarting the
service, I get this error from Remedy Administrator:

"This version of the Action Request System(R) is ready for us eor
evaluation without purchasing or activating an authorization key. For
unlimited capabilities, contact your sales representative or visit
www.remedy.com  .

(ARERR 2877) 
" 

Under C:\Program Files\Common Files\AR System\Licenses there is a folder
with the old hostname. Do we need to reapply the licenses after chaning
the server alias? Will this fix the original error that it cannot
connect to the Plug-In server?


Neil "Sully" Sullivan 
Remedy Developer/Administrator 
AFRL/SNOD 
Wright Patterson AFB, OH 45433 
937-904-9788 

 
__20060125___This posting was submitted with HTML in
it___ __20060125___This posting was submitted with
HTML in it___ 

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

Re: ARERR (302) Entry does not exist in database dilemma

[Opela, Gary L Contr OC-ALC/ITMA]

It sounds like one of your remedy views has gotten dropped.

 

Since your remedy joins are on the views, and your oracle sql you are
running is against the t-tables, this would agree.

 


Additionally, in the past, whenever I have had join forms that would
return results list, but then no actual ticket data in the details
section of the user tool window, it was always because a view form was
dropped.


Try opening up each of the view forms in the user tool to make sure they
all exist. Additionally, you might check on the database level to make
sure the view forms are there.

 

I know that it can get tricky whenever you have nested joins. If you do
something that causes one of the lowest level joins to be rebuilt, then
you run the risk of remedy not properly rebuilding all joins.

 

Example:

 

 A

 B   C

 DE

 

Where A is a join of B and C, and C is a join of D and E, I've seen in
the past where you modify form E that causes the view to be
dropped/recreated, and occastionally A will get dropped. This gets
tricky if you have other forms that are joins of A and, say, F, then you
don't have the visibility to see that A is broken.

 

Check this out to see if it is the problem. This is the easiest to fix:
just find the broken join form, open it up in admin tool, move a field
and hit save.

 

If all of your forms are SQL views, then you will need to re-run your
sql query to rebuild the view. Start at the bottom so you don't re-break
everything once you're finished.

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Pruitt, Christopher J
Sent: Monday, February 12, 2007 3:48 PM
To: arslist@ARSLIST.ORG
Subject: ARERR (302) Entry does not exist in database dilemma

 

I have a question that has now stumped several DBAs and Remedy
Developers now and was hoping someone on this list may have a answer.

We have a Join that is nested with other joins, however, when we perform
a query via the Remedy User tool it returns an "ARERR (302) Entry does
not exist in database".

To make matters worse, on the User Tool it returns 792 records of which
60% display this error and the remaining 40% do not and before anyone
says there are missing records. We have 3 primary data forms included in
these joins and all of them have the corrected and needed data in them.

Now here is the issue. When we perform the same query at the Oracle
level it returns all the records correctly. 

This is the query that is run from the Remedy User Tool (when I turn on
SQL and API logging).
SELECT aradmin.T5092.C1,C8 FROM aradmin.T5092 WHERE (E0 =
'ACI-0001025' and E1 = 'LOC5915' and E2 IS NULL and E3 =
'EBL-590' ) ORDER BY 1 ASC

It returns no record 
However, when I modify the query based on the structure of our Join it
returns the record. 
SELECT aradmin.T5092.C1,C8 FROM aradmin.T5092 WHERE (E0 =
'ACI-0001025' and E1 = 'LOC5915' and E2 IS NULL and E3 IS
NULL and E4 = 'EBL-590' ) ORDER BY 1 ASC

E0 and E1 are from the Tele_Location_Join and E2 and E3 should be from
the Location RecType_Join and E4 should be from the Load Data Form,
however, what is happening via the User Tool is E0 and E1 are from the
Tele_Location_Join and E2 and E3 should be from the Location
RecType_Join and it never includes the E4 and the E3 value should be the
E4 value and E3 should be null 

This is our Join Structure: 
Reporting_Form_Join 

An outer join of: 

*   Charge_Join (Primary)
*   Load Data Form (Secondary)

 

Charge_Join 

An outer join of: 

*   Tele_Location_Join form (Primary) 

An inner join of: 

*   Tele Data form (Primary)
*   Location Data form (Secondary)

*   Location RecType_Join (Secondary)

An inner join of: 

*   Location Data form (Primary)
*   Location Data form (Secondary)

 

Our environment is: 
AR System: 6.03 patch 15 
Remedy User Tool: 6.03 patch 15 
Oracle 9i - ver 9.2.0.6.0 

Christopher Pruitt 
Consultant Specialist 
EDS - Bank of America 
I3-Inventory IW Infrastructure Team 
Phone: +1-972-605-7702 (8-835)  
mailto:HYPERLINK
"mailto:[EMAIL PROTECTED]"[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 

ARERR (302) Entry does not exist in database dilemma

[Pruitt, Christopher J]

I have a question that has now stumped several DBAs and Remedy
Developers now and was hoping someone on this list may have a answer.

We have a Join that is nested with other joins, however, when we perform
a query via the Remedy User tool it returns an "ARERR (302) Entry does
not exist in database".
To make matters worse, on the User Tool it returns 792 records of which
60% display this error and the remaining 40% do not and before anyone
says there are missing records. We have 3 primary data forms included in
these joins and all of them have the corrected and needed data in them.

Now here is the issue. When we perform the same query at the Oracle
level it returns all the records correctly. 

This is the query that is run from the Remedy User Tool (when I turn on
SQL and API logging).
SELECT aradmin.T5092.C1,C8 FROM aradmin.T5092 WHERE (E0 =
'ACI-0001025' and E1 = 'LOC5915' and E2 IS NULL and E3 =
'EBL-590' ) ORDER BY 1 ASC
It returns no record
However, when I modify the query based on the structure of our Join it
returns the record.
SELECT aradmin.T5092.C1,C8 FROM aradmin.T5092 WHERE (E0 =
'ACI-0001025' and E1 = 'LOC5915' and E2 IS NULL and E3 IS
NULL and E4 = 'EBL-590' ) ORDER BY 1 ASC
E0 and E1 are from the Tele_Location_Join and E2 and E3 should be from
the Location RecType_Join and E4 should be from the Load Data Form,
however, what is happening via the User Tool is E0 and E1 are from the
Tele_Location_Join and E2 and E3 should be from the Location
RecType_Join and it never includes the E4 and the E3 value should be the
E4 value and E3 should be null 
This is our Join Structure:
Reporting_Form_Join 
An outer join of:
*   Charge_Join (Primary)
*   Load Data Form (Secondary)

Charge_Join 
An outer join of:
*   Tele_Location_Join form (Primary) 
An inner join of:
*   Tele Data form (Primary)
*   Location Data form (Secondary)
*   Location RecType_Join (Secondary)
An inner join of:
*   Location Data form (Primary)
*   Location Data form (Secondary)

Our environment is:
AR System: 6.03 patch 15
Remedy User Tool: 6.03 patch 15
Oracle 9i - ver 9.2.0.6.0

Christopher Pruitt 
Consultant Specialist
EDS - Bank of America
I3-Inventory IW Infrastructure Team
Phone: +1-972-605-7702 (8-835)  
mailto:HYPERLINK
"mailto:[EMAIL PROTECTED]"[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.


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

Re: FW: Permanent Remedy Developer - Singapore

[Candace DeCou]

Oh gads...no wonder I'm finding it hard to breathLOL

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Howard Richter
Sent: Friday, February 09, 2007 1:40 PM
To: arslist@ARSLIST.ORG
Subject: Re: FW: Permanent Remedy Developer - Singapore

 

** 

There are people that have ITSM 7 experience and like myself they are
getting fitted for straight jackets.

 

Good luck

 

Howard

 

On 2/9/07, patrick zandi <[EMAIL PROTECTED]> wrote: 

** to live in a 1200sf apt  the cost is only 1.2 mil .. I cannot see
your perm job paying for that.. 

On 2/8/07, James Tobin <[EMAIL PROTECTED] > wrote: 

Come on people, there must be some one out there that has at least some
v.7
experience looking to relocate to Singapore. 


-Original Message-
From: James Tobin [mailto:[EMAIL PROTECTED]
Sent: 01 February 2007 16:05 
To: arslist@ARSLIST.ORG 
Subject: FW: Permanent Remedy Developer - Singapore
Importance: High

To further clarify skill preferences for the role(s) in Singapore for
which
our client is recruiting when speaking of at least 1-2 years
comprehensive 
ITSM experience we would be particularly interested to hear from those
that 
have worked with ITSM 7.  Please be so kind as to make a note to advise
in
any email you may send to me ( [EMAIL PROTECTED]
 ).

All the best,
James


-Original Message-
From: James Tobin [mailto: [EMAIL PROTECTED]
 ]
Sent: 31 January 2007 15:57 
To: arslist@ARSLIST.ORG
Subject: JOB: Permanent Remedy Developer - Singapore 
Importance: High

JOB:

List,

Our client is recruiting several permanent remedy ars developers for
their 
Singapore office.

Consequently, we would be keen to receive resumes from those individuals

that may be interested in relocating to Singapore.  Further information
concerning our client and their projects aswell as specific skill 
requirements will be discussed with those who may be interested.

Proposed roles will focus on requirement analysis, design, development
and
support of Remedy based applications.  As a benchmark candidates should
have 
experience of version 5 or above and preferably at least 1-2 year's 
comprehensive ITSM experience.  Furthermore, Oracle (or Sybase) DB
experience is mandatory and it would be beneficial if you have at least
1-2 
years worth of experience with Java and 1-2 years experience in
scripting 
languages such as Jscript, Perl or Shell.

Please also include your current salary and package details (i.e. bonus
etc)
aswell as availability ( i.e. notice period).

I can be contacted using email address [EMAIL PROTECTED]

All the best,
James

. . . . . . . . .

James Tobin
Cubicegg 
+44 (0) 870 720 1074 - office
+44 (0) 7952 145 127 - mobile

To learn more about Cubicegg please visit our website at
http://www.cubicegg.com  


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


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


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




-- 
Patrick Zandi __20060125___This posting was
submitted with HTML in it___ 




-- 
Howard Richter
Remedy ServiceDesk Manager
Red Hat Certified Technician
CompTIA Linux+ Certified
CedarCrestone Managed Services Center
[EMAIL PROTECTED] __20060125___This
posting was submitted with HTML in it___ 


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

Re: Server Alias

[Sullivan, Neil G CTR USAF AFRL/SNOD]

Yes.  We change it and restarted the services.  After logging in and
going to the server properties, the license file showed only 3 licenses,
but when we reset everything, the licenses appear and everything works,
EXCEPT we can't open Vendor forms.



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W
Sent: Monday, February 12, 2007 1:34 PM
To: arslist@ARSLIST.ORG
Subject: Re: Server Alias


** 
Did you check the armonitor.cfg (since that has the server name in it) 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Sullivan, Neil G CTR USAF
AFRL/SNOD
Sent: Monday, February 12, 2007 12:06 PM
To: arslist@ARSLIST.ORG
Subject: Re: Server Alias


** 
Fred,
 
Tried your suggestion, but no success.
 
Sully



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W
Sent: Monday, February 12, 2007 11:25 AM
To: arslist@ARSLIST.ORG
Subject: Re: Server Alias


** 
It sounds like you still have something in your system referencing the
old alias.  Can you look in the ar.cfg file and see if it has the old
alias listed.  You should see a C:\Program Files\Common Files\AR
System\Licenses\newAlias folder.  If not you can create one and copy the
files from the oldAlias into it.  You may need to also edit the
armonitor.cfg file and make sure it also has the new alias name in it.
 
Fred




From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Sullivan, Neil G CTR USAF
AFRL/SNOD
Sent: Monday, February 12, 2007 10:14 AM
To: arslist@ARSLIST.ORG
Subject: Server Alias


** 

We recently changed the hostid on our server and purged the licenses to
the new hostid, but my users are getting the following error if I enter
the new hostname in the server alias field.

"ARERR [8760] Cannot establish a network connection to the AR System
Plug-In server :  : RPC: Name to address translation
failed - No such hostname". 

Where I have  is the name I see when I go to File ->
Server information in the Remedy Administrator tool. This is not the
hostname of our current remedy server. It is the name of the old remedy
server. I tried to change the name from the Remedy Administrator tool
which it let me do, but when I try to log in after restarting the
service, I get this error from Remedy Administrator:

"This version of the Action Request System(R) is ready for us eor
evaluation without purchasing or activating an authorization key. For
unlimited capabilities, contact your sales representative or visit
www.remedy.com  .

(ARERR 2877) 
" 

Under C:\Program Files\Common Files\AR System\Licenses there is a folder
with the old hostname. Do we need to reapply the licenses after chaning
the server alias? Will this fix the original error that it cannot
connect to the Plug-In server?


Neil "Sully" Sullivan 
Remedy Developer/Administrator 
AFRL/SNOD 
Wright Patterson AFB, OH 45433 
937-904-9788 

 
__20060125___This posting was submitted with HTML in
it___ 

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

Re: Server Alias

[Shanmugadas, Suresh]

Using the Remedy License tool, were you able to see the (New) correct
server name and License keys etc. If you see the correct values. Backup
your Old license file. Export this through the license tool and try
re-importing it. Try doing it, I got it resolved when I had a similar
problem.
 
 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W
Sent: Monday, February 12, 2007 10:34 AM
To: arslist@ARSLIST.ORG
Subject: Re: Server Alias


** 
Did you check the armonitor.cfg (since that has the server name in it) 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Sullivan, Neil G CTR USAF
AFRL/SNOD
Sent: Monday, February 12, 2007 12:06 PM
To: arslist@ARSLIST.ORG
Subject: Re: Server Alias


** 
Fred,
 
Tried your suggestion, but no success.
 
Sully



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W
Sent: Monday, February 12, 2007 11:25 AM
To: arslist@ARSLIST.ORG
Subject: Re: Server Alias


** 
It sounds like you still have something in your system referencing the
old alias.  Can you look in the ar.cfg file and see if it has the old
alias listed.  You should see a C:\Program Files\Common Files\AR
System\Licenses\newAlias folder.  If not you can create one and copy the
files from the oldAlias into it.  You may need to also edit the
armonitor.cfg file and make sure it also has the new alias name in it.
 
Fred




From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Sullivan, Neil G CTR USAF
AFRL/SNOD
Sent: Monday, February 12, 2007 10:14 AM
To: arslist@ARSLIST.ORG
Subject: Server Alias


** 

We recently changed the hostid on our server and purged the licenses to
the new hostid, but my users are getting the following error if I enter
the new hostname in the server alias field.

"ARERR [8760] Cannot establish a network connection to the AR System
Plug-In server :  : RPC: Name to address translation
failed - No such hostname". 

Where I have  is the name I see when I go to File ->
Server information in the Remedy Administrator tool. This is not the
hostname of our current remedy server. It is the name of the old remedy
server. I tried to change the name from the Remedy Administrator tool
which it let me do, but when I try to log in after restarting the
service, I get this error from Remedy Administrator:

"This version of the Action Request System(R) is ready for us eor
evaluation without purchasing or activating an authorization key. For
unlimited capabilities, contact your sales representative or visit
www.remedy.com  .

(ARERR 2877) 
" 

Under C:\Program Files\Common Files\AR System\Licenses there is a folder
with the old hostname. Do we need to reapply the licenses after chaning
the server alias? Will this fix the original error that it cannot
connect to the Plug-In server?


Neil "Sully" Sullivan 
Remedy Developer/Administrator 
AFRL/SNOD 
Wright Patterson AFB, OH 45433 
937-904-9788 

 
__20060125___This posting was submitted with HTML in
it___ 

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

Re: Server Alias

[Grooms, Frederick W]

Did you check the armonitor.cfg (since that has the server name in it) 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Sullivan, Neil G CTR USAF
AFRL/SNOD
Sent: Monday, February 12, 2007 12:06 PM
To: arslist@ARSLIST.ORG
Subject: Re: Server Alias


** 
Fred,
 
Tried your suggestion, but no success.
 
Sully



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W
Sent: Monday, February 12, 2007 11:25 AM
To: arslist@ARSLIST.ORG
Subject: Re: Server Alias


** 
It sounds like you still have something in your system referencing the
old alias.  Can you look in the ar.cfg file and see if it has the old
alias listed.  You should see a C:\Program Files\Common Files\AR
System\Licenses\newAlias folder.  If not you can create one and copy the
files from the oldAlias into it.  You may need to also edit the
armonitor.cfg file and make sure it also has the new alias name in it.
 
Fred




From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Sullivan, Neil G CTR USAF
AFRL/SNOD
Sent: Monday, February 12, 2007 10:14 AM
To: arslist@ARSLIST.ORG
Subject: Server Alias


** 

We recently changed the hostid on our server and purged the licenses to
the new hostid, but my users are getting the following error if I enter
the new hostname in the server alias field.

"ARERR [8760] Cannot establish a network connection to the AR System
Plug-In server :  : RPC: Name to address translation
failed - No such hostname". 

Where I have  is the name I see when I go to File ->
Server information in the Remedy Administrator tool. This is not the
hostname of our current remedy server. It is the name of the old remedy
server. I tried to change the name from the Remedy Administrator tool
which it let me do, but when I try to log in after restarting the
service, I get this error from Remedy Administrator:

"This version of the Action Request System(R) is ready for us eor
evaluation without purchasing or activating an authorization key. For
unlimited capabilities, contact your sales representative or visit
www.remedy.com  .

(ARERR 2877) 
" 

Under C:\Program Files\Common Files\AR System\Licenses there is a folder
with the old hostname. Do we need to reapply the licenses after chaning
the server alias? Will this fix the original error that it cannot
connect to the Plug-In server?


Neil "Sully" Sullivan 
Remedy Developer/Administrator 
AFRL/SNOD 
Wright Patterson AFB, OH 45433 
937-904-9788 

 

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

Re: Server Alias

[Sullivan, Neil G CTR USAF AFRL/SNOD]

Fred,
 
Tried your suggestion, but no success.
 
Sully



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W
Sent: Monday, February 12, 2007 11:25 AM
To: arslist@ARSLIST.ORG
Subject: Re: Server Alias


** 
It sounds like you still have something in your system referencing the
old alias.  Can you look in the ar.cfg file and see if it has the old
alias listed.  You should see a C:\Program Files\Common Files\AR
System\Licenses\newAlias folder.  If not you can create one and copy the
files from the oldAlias into it.  You may need to also edit the
armonitor.cfg file and make sure it also has the new alias name in it.
 
Fred




From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Sullivan, Neil G CTR USAF
AFRL/SNOD
Sent: Monday, February 12, 2007 10:14 AM
To: arslist@ARSLIST.ORG
Subject: Server Alias


** 

We recently changed the hostid on our server and purged the licenses to
the new hostid, but my users are getting the following error if I enter
the new hostname in the server alias field.

"ARERR [8760] Cannot establish a network connection to the AR System
Plug-In server :  : RPC: Name to address translation
failed - No such hostname". 

Where I have  is the name I see when I go to File ->
Server information in the Remedy Administrator tool. This is not the
hostname of our current remedy server. It is the name of the old remedy
server. I tried to change the name from the Remedy Administrator tool
which it let me do, but when I try to log in after restarting the
service, I get this error from Remedy Administrator:

"This version of the Action Request System(R) is ready for us eor
evaluation without purchasing or activating an authorization key. For
unlimited capabilities, contact your sales representative or visit
www.remedy.com  .

(ARERR 2877) 
" 

Under C:\Program Files\Common Files\AR System\Licenses there is a folder
with the old hostname. Do we need to reapply the licenses after chaning
the server alias? Will this fix the original error that it cannot
connect to the Plug-In server?


Neil "Sully" Sullivan 
Remedy Developer/Administrator 
AFRL/SNOD 
Wright Patterson AFB, OH 45433 
937-904-9788 

 
 
__20060125___This posting was submitted with HTML in
it___ 

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

Re: Server Alias

[Sullivan, Neil G CTR USAF AFRL/SNOD]

John, 
 
We've done that but it creates a folder for the old alias and a
multilicense file with all the new licenses.



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of John Hanson
Sent: Monday, February 12, 2007 11:34 AM
To: arslist@ARSLIST.ORG
Subject: Re: Server Alias


** 
Hello,
We did an alias change and had to delete the .multilicense file before
it recognized the licenses again.
 
HTH,
John

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Sullivan, Neil G CTR USAF
AFRL/SNOD
Sent: Monday, February 12, 2007 8:14 AM
To: arslist@ARSLIST.ORG
Subject: Server Alias


** 

We recently changed the hostid on our server and purged the
licenses to the new hostid, but my users are getting the following error
if I enter the new hostname in the server alias field.

"ARERR [8760] Cannot establish a network connection to the AR
System Plug-In server :  : RPC: Name to address
translation failed - No such hostname". 

Where I have  is the name I see when I go to
File -> Server information in the Remedy Administrator tool. This is not
the hostname of our current remedy server. It is the name of the old
remedy server. I tried to change the name from the Remedy Administrator
tool which it let me do, but when I try to log in after restarting the
service, I get this error from Remedy Administrator:

"This version of the Action Request System(R) is ready for us
eor evaluation without purchasing or activating an authorization key.
For unlimited capabilities, contact your sales representative or visit
www.remedy.com  .

(ARERR 2877) 
" 

Under C:\Program Files\Common Files\AR System\Licenses there is
a folder with the old hostname. Do we need to reapply the licenses after
chaning the server alias? Will this fix the original error that it
cannot connect to the Plug-In server?


Neil "Sully" Sullivan 
Remedy Developer/Administrator 
AFRL/SNOD 
Wright Patterson AFB, OH 45433 
937-904-9788 

__20060125___This posting was submitted with
HTML in it___

__20060125___This posting was submitted with HTML in
it___ 

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

Re: SQL Log analyzer of SQL log timer (Performance tools)

[Matt Reinfeldt]

It's called ARLogAnalyzer. :-) great tool.

 

Matt

 

  _  

From: Axton [mailto:[EMAIL PROTECTED] 
Sent: Monday, February 12, 2007 11:28 AM
To: arslist@ARSLIST.ORG
Subject: Re: SQL Log analyzer of SQL log timer (Performance tools)

 

** 

The is a utility in the dev community of the BMC/Remedy Community downloads
that does this.  It returns all sql from an arsql.log that take > a
specified time to complete.

 

Axton Grams

 

On 2/12/07, Troy Sasso <[EMAIL PROTECTED]> wrote: 

Hello all,

Is there freeware out there that will analyze MS SQL
transaction logs or Remedy SQL logs to help identify 
bad queries and improve performance?


Troy







Any questions? Get answers on any topic at www.Answers.yahoo.com.  Try it
now.


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


__20060125___This posting was submitted with HTML in
it___ 


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

Re: SQL Log analyzer of SQL log timer (Performance tools)

[Axton]

The is a utility in the dev community of the BMC/Remedy Community downloads
that does this.  It returns all sql from an arsql.log that take > a
specified time to complete.

Axton Grams


On 2/12/07, Troy Sasso <[EMAIL PROTECTED]> wrote:


Hello all,

Is there freeware out there that will analyze MS SQL
transaction logs or Remedy SQL logs to help identify
bad queries and improve performance?


Troy







Any questions? Get answers on any topic at www.Answers.yahoo.com.  Try it
now.


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



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

Re: WebService License Release

[L. J. Head]

You could try having the web service account have a read only license.  Have
it do a submit into a secondary form and use filters to move data around as
needed 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Rick Ponzo
Sent: Monday, February 12, 2007 9:36 AM
To: arslist@ARSLIST.ORG
Subject: Re: WebService License Release

Thanks for your response, Dylan.  I attempted to use an active link after
submit as you suggested, but it was unsuccessful.  The search doesn't really
open a window either, it just returns the output back to the calling
application.


Wheeler, Dylan wrote:
> You could tie the process to a active link that executes on After 
> Submit. Using the execute on Search wouldn't help for the query though 
> since it executes before the search happens. Maybe open the results in 
> a new window, close the old window and tie the AL to that?
>
> -Original Message-
> From: Action Request System discussion list(ARSList) 
> [mailto:[EMAIL PROTECTED] On Behalf Of Rick Ponzo
> Sent: Monday, February 12, 2007 8:11 AM
> To: arslist@ARSLIST.ORG
> Subject: WebService License Release
>
>
> Greetings all,
>
> I've made a few attempts to release a license that was used during a 
> web
>
> service create or query.  Tech Support recommended using the 
> PERFORM-ACTION-EXIT-APP process, but that doesn't work in a filter so 
> it's not much use in this situation.
>
> Any ideas?
>
> Thanks,
> Rick Ponzo
>
> __
> __
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org 
> ARSlist:"Where the Answers Are"
>
>
> This message and any attachments are for the intended recipient(s) only
and may contain privileged, confidential and/or proprietary information
about Downey Savings or its customers, which Downey Savings does not intend
to disclose to the public.  If you received this message by mistake, please
notify the sender by reply e-mail and delete the message and attachments.
>
> __
> _ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org 
> ARSlist:"Where the Answers Are"
>
>
>   


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

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

SQL Log analyzer of SQL log timer (Performance tools)

[Troy Sasso]

Hello all,

Is there freeware out there that will analyze MS SQL
transaction logs or Remedy SQL logs to help identify
bad queries and improve performance?


Troy




 

Any questions? Get answers on any topic at www.Answers.yahoo.com.  Try it now.

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

Re: Oracle case insensitivity features and ARS 7

[danaceau, Christopher M]

This won't be much help to you (except from an informational sharing
perspective) but we ran into similar performance issues as part of a
Sybase -> Oracle conversion.  Never did get a resolution after working
with both Oracle and Remedy.  In the end we posponed our db conversion
to coincide with our apps upgrade (5.5 -> 7.0).  We will be deploying
the new apps case sensitive. 


-- 

Chris Danaceau
703-833-2459

The electronic mail message you have received and any files transmitted
with it are confidential and solely for the intended addressee(s)'s
attention. Do not divulge, copy, forward, or use the contents,
attachments, or information without permission of Fannie Mae.
Information contained in this message is provided solely for the purpose
stated in the message or its attachment(s) and must not be disclosed to
any third party or used for any other purpose without consent of Fannie
Mae. If you have received this message and/or any files transmitted with
it in error, please delete them from your system, destroy any hard
copies of them, and contact the sender. 



-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Albert Bihler
Sent: Friday, February 09, 2007 11:10 AM
To: arslist@ARSLIST.ORG
Subject: Oracle case insensitivity features and ARS 7

Hi list,

we are currently migrating a ARS application from Sybase to Oracle
10gR2. A big problem is that Oracle by default is case sensitive and
users are used to execute searches without caring about the case.

We applied KM-00012018 without great success.

We also played around with the following Oracle options:
ALTER SESSION SET NLS_COMP=LINGUISTIC;
ALTER SESSION SET NLS_SORT=BINARY_CI;
and function based indexes to get Oracle to work case insensitive. The
problem is that the indexes created by ARS won't work and performance
would be very poor.

Does anybody have a performant real live environment with ARS using
Oracle case insensitivity options and would like to share the details?

Remedy support says this is a limitation from Oracle.

Oracle support states that everything works great if you use
nlssort-funcion in the where clause of your SQL statement. Unfortunately
ARS doesn't issue SQL commands of that style.

ARS 7.0.0
Oracle 10gR2
Solaris 10


Kind regards,
Albert


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

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

Re: WebService License Release

[Rick Ponzo]

Thanks for your response, Dylan.  I attempted to use an active link 
after submit as you suggested, but it was unsuccessful.  The search 
doesn't really open a window either, it just returns the output back to 
the calling application.



Wheeler, Dylan wrote:

You could tie the process to a active link that executes on After
Submit. Using the execute on Search wouldn't help for the query though
since it executes before the search happens. Maybe open the results in a
new window, close the old window and tie the AL to that?

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Rick Ponzo
Sent: Monday, February 12, 2007 8:11 AM
To: arslist@ARSLIST.ORG
Subject: WebService License Release


Greetings all,

I've made a few attempts to release a license that was used during a web

service create or query.  Tech Support recommended using the 
PERFORM-ACTION-EXIT-APP process, but that doesn't work in a filter so 
it's not much use in this situation.


Any ideas?

Thanks,
Rick Ponzo


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


This message and any attachments are for the intended recipient(s) only and may 
contain privileged, confidential and/or proprietary information about Downey 
Savings or its customers, which Downey Savings does not intend to disclose to 
the public.  If you received this message by mistake, please notify the sender 
by reply e-mail and delete the message and attachments.

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


  


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

Re: Server Alias

[John Hanson]

Hello,
We did an alias change and had to delete the .multilicense file before
it recognized the licenses again.
 
HTH,
John

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Sullivan, Neil G CTR USAF
AFRL/SNOD
Sent: Monday, February 12, 2007 8:14 AM
To: arslist@ARSLIST.ORG
Subject: Server Alias


** 

We recently changed the hostid on our server and purged the
licenses to the new hostid, but my users are getting the following error
if I enter the new hostname in the server alias field.

"ARERR [8760] Cannot establish a network connection to the AR
System Plug-In server :  : RPC: Name to address
translation failed - No such hostname". 

Where I have  is the name I see when I go to
File -> Server information in the Remedy Administrator tool. This is not
the hostname of our current remedy server. It is the name of the old
remedy server. I tried to change the name from the Remedy Administrator
tool which it let me do, but when I try to log in after restarting the
service, I get this error from Remedy Administrator:

"This version of the Action Request System(R) is ready for us
eor evaluation without purchasing or activating an authorization key.
For unlimited capabilities, contact your sales representative or visit
www.remedy.com  .

(ARERR 2877) 
" 

Under C:\Program Files\Common Files\AR System\Licenses there is
a folder with the old hostname. Do we need to reapply the licenses after
chaning the server alias? Will this fix the original error that it
cannot connect to the Plug-In server?


Neil "Sully" Sullivan 
Remedy Developer/Administrator 
AFRL/SNOD 
Wright Patterson AFB, OH 45433 
937-904-9788 

__20060125___This posting was submitted with
HTML in it___


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

Re: WebService License Release

[Wheeler, Dylan]

You could tie the process to a active link that executes on After
Submit. Using the execute on Search wouldn't help for the query though
since it executes before the search happens. Maybe open the results in a
new window, close the old window and tie the AL to that?

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Rick Ponzo
Sent: Monday, February 12, 2007 8:11 AM
To: arslist@ARSLIST.ORG
Subject: WebService License Release


Greetings all,

I've made a few attempts to release a license that was used during a web

service create or query.  Tech Support recommended using the 
PERFORM-ACTION-EXIT-APP process, but that doesn't work in a filter so 
it's not much use in this situation.

Any ideas?

Thanks,
Rick Ponzo


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


This message and any attachments are for the intended recipient(s) only and may 
contain privileged, confidential and/or proprietary information about Downey 
Savings or its customers, which Downey Savings does not intend to disclose to 
the public.  If you received this message by mistake, please notify the sender 
by reply e-mail and delete the message and attachments.

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

Re: Server Alias

[Tony Worthington]

I can't speak to your licensing issues, but I do remember getting plugin 
errors when I changed our server alias from the "real" machine name to an 
alias.

The fix was to add the dns cname to the localhost file on the machine. 
This is not the physical server name, but the alias.

127.0.0.1   localhost remedy-qa remedy-qa.cp.ad.kohls.com

hth,
tony

-- 
Tony Worthington
[EMAIL PROTECTED]
262-703-5911



"Sullivan, Neil G CTR USAF AFRL/SNOD" <[EMAIL PROTECTED]> 
Sent by: "Action Request System discussion list(ARSList)" 

02/12/2007 10:14 AM
Please respond to
arslist@ARSLIST.ORG


To
arslist@ARSLIST.ORG
cc

Subject
Server Alias






** 
We recently changed the hostid on our server and purged the licenses to 
the new hostid, but my users are getting the following error if I enter 
the new hostname in the server alias field.
"ARERR [8760] Cannot establish a network connection to the AR System 
Plug-In server :  : RPC: Name to address translation 
failed - No such hostname". 
Where I have  is the name I see when I go to File -> 
Server information in the Remedy Administrator tool. This is not the 
hostname of our current remedy server. It is the name of the old remedy 
server. I tried to change the name from the Remedy Administrator tool 
which it let me do, but when I try to log in after restarting the service, 
I get this error from Remedy Administrator:
"This version of the Action Request System(R) is ready for us eor 
evaluation without purchasing or activating an authorization key. For 
unlimited capabilities, contact your sales representative or visit 
www.remedy.com.
(ARERR 2877) 
" 
Under C:\Program Files\Common Files\AR System\Licenses there is a folder 
with the old hostname. Do we need to reapply the licenses after chaning 
the server alias? Will this fix the original error that it cannot connect 
to the Plug-In server?

Neil "Sully" Sullivan 
Remedy Developer/Administrator 
AFRL/SNOD 
Wright Patterson AFB, OH 45433 
937-904-9788 
__20060125___This posting was submitted with HTML in 
it___


CONFIDENTIALITY NOTICE: 
This is a transmission from Kohl's Department Stores, Inc.
and may contain information which is confidential and proprietary.
If you are not the addressee, any disclosure, copying or distribution or use of 
the contents of this message is expressly prohibited.
If you have received this transmission in error, please destroy it and notify 
us immediately at 262-703-7000.

CAUTION:
Internet and e-mail communications are Kohl's property and Kohl's reserves the 
right to retrieve and read any message created, sent and received.  Kohl's 
reserves the right to monitor messages to or from authorized Kohl's Associates 
at any time
without any further consent.

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

Re: Server Alias

[Grooms, Frederick W]

It sounds like you still have something in your system referencing the
old alias.  Can you look in the ar.cfg file and see if it has the old
alias listed.  You should see a C:\Program Files\Common Files\AR
System\Licenses\newAlias folder.  If not you can create one and copy the
files from the oldAlias into it.  You may need to also edit the
armonitor.cfg file and make sure it also has the new alias name in it.
 
Fred




From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Sullivan, Neil G CTR USAF
AFRL/SNOD
Sent: Monday, February 12, 2007 10:14 AM
To: arslist@ARSLIST.ORG
Subject: Server Alias


** 

We recently changed the hostid on our server and purged the licenses to
the new hostid, but my users are getting the following error if I enter
the new hostname in the server alias field.

"ARERR [8760] Cannot establish a network connection to the AR System
Plug-In server :  : RPC: Name to address translation
failed - No such hostname". 

Where I have  is the name I see when I go to File ->
Server information in the Remedy Administrator tool. This is not the
hostname of our current remedy server. It is the name of the old remedy
server. I tried to change the name from the Remedy Administrator tool
which it let me do, but when I try to log in after restarting the
service, I get this error from Remedy Administrator:

"This version of the Action Request System(R) is ready for us eor
evaluation without purchasing or activating an authorization key. For
unlimited capabilities, contact your sales representative or visit
www.remedy.com  .

(ARERR 2877) 
" 

Under C:\Program Files\Common Files\AR System\Licenses there is a folder
with the old hostname. Do we need to reapply the licenses after chaning
the server alias? Will this fix the original error that it cannot
connect to the Plug-In server?


Neil "Sully" Sullivan 
Remedy Developer/Administrator 
AFRL/SNOD 
Wright Patterson AFB, OH 45433 
937-904-9788 

 
 

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

Re: RANT: Remedy Support Knowledge Base

[Kaiser Norm E CIV USAF 96 CG/SCWOE]

I could be mistaken, but last night-after I'd been here 12 hours on a Sunday
tearing my hair out-but last night I did a search in the KB with the quotes
("view field") and it matched nothing.

 

  _  

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Lucero, Michelle - IST contractor
Sent: Monday, February 12, 2007 10:18 AM
To: arslist@ARSLIST.ORG
Subject: Re: RANT: Remedy Support Knowledge Base

 

Hi, Norm:

 

When you did put "view field" in quotes, did it return anything of value?  I
have found that the quotes are ignored.

 

You're receiving a match on most or all of the records because "ReVIEW
date:" appears in almost if not all of the articles.

 

After a few tests--

Alright I get it nowwhen there is absolutely no match inside the
articles the Solution Search results shows a 100% match on all articles
listed.  You gotta think backwards, people.  Absolutely no match means 100%.
A perfect match shows 5%.  Huh??

 

Try this:

1.  Search for "ARERR 90" with quotes with Remedy AR System Server selected
as the product

2.  10 results will be returned.

3.  All 10 articles will show 100% in the left margin.

4.  Randomly, open a few articles

5.  Search for ARERR 90 by doing a find on the page (absolutely no matches).

6.  Your search has been "OR'd".  Sort of.  The bottom articles will not
list 90 nor ARERR, although it shows 100%.

 

Try the same search without quotes:

1.  Search for ARERR 90 without quotes

2.  25 results will be returned.

3.  The first few articles show 5% in the left margin.  However, it is
obvious that it has matched ARERR 90.

4.  Randomly selecting articles on the first and second pages shows that the
ARERR 90 phrase appears together in every article selected.

5.  So why does it show 5% in the left margin?

 

Any insight from those that have found the magic potion?

 

Michelle

 

  _  

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96 CG/SCWOE
Sent: Monday, February 12, 2007 9:27 AM
To: arslist@ARSLIST.ORG
Subject: RANT: Remedy Support Knowledge Base

** 

Rhetorical question: Why does Remedy lock down the knowledge base to paying
customers, anyway? I mean, really-what sense does that make? Other software
companies don't do that.  I mean, after all, you can't make use of it unless
you have valid, paid up licenses, so what sense does it make?

 

Why not post the knowledge base articles on the publicly available web-like
Microsoft Technet-and then we could leverage a proper search engine like,
say, Google to find articles of value?! The knowledge base search engine is
awful.  It might work for terms that are very specific like an ARERR number,
but if you type in the term "view field" without the quotes, the search
engine returns like 800, articles...which defeats the purpose of a
search engine.  With Google-or any other modern search engine, for that
matter-you can put quotes around a term like "view field" and the search
engine will look exactly for that, not documents that contain the words
"view" and "field" somewhere scattered in the document.

 

That's my rant for today.

 

Norm

__20060125___This posting was submitted with HTML in
it___ 

__20060125___This posting was submitted with HTML in
it___

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

Re: RANT: Remedy Support Knowledge Base

[Lucero, Michelle - IST contractor]

Hi, Norm:
 
When you did put "view field" in quotes, did it return anything of
value?  I have found that the quotes are ignored.
 
You're receiving a match on most or all of the records because "ReVIEW
date:" appears in almost if not all of the articles.
 
After a few tests--
Alright I get it nowwhen there is absolutely no match inside the
articles the Solution Search results shows a 100% match on all articles
listed.  You gotta think backwards, people.  Absolutely no match means
100%.  A perfect match shows 5%.  Huh??
 
Try this:
1.  Search for "ARERR 90" with quotes with Remedy AR System Server
selected as the product
2.  10 results will be returned.
3.  All 10 articles will show 100% in the left margin.
4.  Randomly, open a few articles
5.  Search for ARERR 90 by doing a find on the page (absolutely no
matches).
6.  Your search has been "OR'd".  Sort of.  The bottom articles will not
list 90 nor ARERR, although it shows 100%.
 
Try the same search without quotes:
1.  Search for ARERR 90 without quotes
2.  25 results will be returned.
3.  The first few articles show 5% in the left margin.  However, it is
obvious that it has matched ARERR 90.
4.  Randomly selecting articles on the first and second pages shows that
the ARERR 90 phrase appears together in every article selected.
5.  So why does it show 5% in the left margin?
 
Any insight from those that have found the magic potion?
 
Michelle



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96
CG/SCWOE
Sent: Monday, February 12, 2007 9:27 AM
To: arslist@ARSLIST.ORG
Subject: RANT: Remedy Support Knowledge Base


** 

Rhetorical question: Why does Remedy lock down the knowledge base to
paying customers, anyway? I mean, really-what sense does that make?
Other software companies don't do that.  I mean, after all, you can't
make use of it unless you have valid, paid up licenses, so what sense
does it make?

 

Why not post the knowledge base articles on the publicly available
web-like Microsoft Technet-and then we could leverage a proper search
engine like, say, Google to find articles of value?! The knowledge base
search engine is awful.  It might work for terms that are very specific
like an ARERR number, but if you type in the term "view field" without
the quotes, the search engine returns like 800, articles...which
defeats the purpose of a search engine.  With Google-or any other modern
search engine, for that matter-you can put quotes around a term like
"view field" and the search engine will look exactly for that, not
documents that contain the words "view" and "field" somewhere scattered
in the document.

 

That's my rant for today.

 

Norm

__20060125___This posting was submitted with HTML in
it___ 

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

Server Alias

[Sullivan, Neil G CTR USAF AFRL/SNOD]

We recently changed the hostid on our server and purged the licenses to
the new hostid, but my users are getting the following error if I enter
the new hostname in the server alias field.

"ARERR [8760] Cannot establish a network connection to the AR System
Plug-In server :  : RPC: Name to address translation
failed - No such hostname". 

Where I have  is the name I see when I go to File ->
Server information in the Remedy Administrator tool. This is not the
hostname of our current remedy server. It is the name of the old remedy
server. I tried to change the name from the Remedy Administrator tool
which it let me do, but when I try to log in after restarting the
service, I get this error from Remedy Administrator:

"This version of the Action Request System(R) is ready for us eor
evaluation without purchasing or activating an authorization key. For
unlimited capabilities, contact your sales representative or visit
www.remedy.com.
(ARERR 2877)
"

Under C:\Program Files\Common Files\AR System\Licenses there is a folder
with the old hostname. Do we need to reapply the licenses after chaning
the server alias? Will this fix the original error that it cannot
connect to the Plug-In server?


Neil "Sully" Sullivan
Remedy Developer/Administrator
AFRL/SNOD
Wright Patterson AFB, OH 45433
937-904-9788


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

WebService License Release

[Rick Ponzo]

Greetings all,

I've made a few attempts to release a license that was used during a web 
service create or query.  Tech Support recommended using the 
PERFORM-ACTION-EXIT-APP process, but that doesn't work in a filter so 
it's not much use in this situation.


Any ideas?

Thanks,
Rick Ponzo

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

RANT: Remedy Support Knowledge Base

[Kaiser Norm E CIV USAF 96 CG/SCWOE]

Rhetorical question: Why does Remedy lock down the knowledge base to paying
customers, anyway? I mean, really-what sense does that make? Other software
companies don't do that.  I mean, after all, you can't make use of it unless
you have valid, paid up licenses, so what sense does it make?

 

Why not post the knowledge base articles on the publicly available web-like
Microsoft Technet-and then we could leverage a proper search engine like,
say, Google to find articles of value?! The knowledge base search engine is
awful.  It might work for terms that are very specific like an ARERR number,
but if you type in the term "view field" without the quotes, the search
engine returns like 800, articles...which defeats the purpose of a
search engine.  With Google-or any other modern search engine, for that
matter-you can put quotes around a term like "view field" and the search
engine will look exactly for that, not documents that contain the words
"view" and "field" somewhere scattered in the document.

 

That's my rant for today.

 

Norm


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

Re: Mid Tier 7.0.1 patch 001

[Lucero, Michelle - IST contractor]

Hi, Amanda:  

That syntax (using ViewFormServlet)works for us in 7.0.01 Patch 001.  It
seems that the LoginServlet doesn't work right.  It seems to ignore the
mode parameter AND opens the home page instead of the form supplied.

Substituting ViewFormServlet for LoginServlet seems to work.  This is
something that needs to be reported to tech support if you haven't
already.

Our environment is
Mid-Tier 7.0.0 Patch 001
Windows 2003/IIS 6/Apache Tomcat/Java 1.6

Thanks,
Michelle 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Pierce, Amanda (TBS)
Sent: Monday, February 12, 2007 7:25 AM
To: arslist@ARSLIST.ORG
Subject: Re: Mid Tier 7.0.1 patch 001

We are using the exact syntax below, we have tried both the
ViewFormServlet and the LoginServlet to no avail. Does anyone have the
midtier pages working under IIS with TomCat on 7.0.1 patch 001? Did you
upgrade it from 7.0.1?

 
 
Amanda Pierce
PDS Client Systems Development
Technology Services
Turner Broadcasting System, Inc
404-827-2959
Please use http://sos to submit a technology request.

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Lucero, Michelle - IST
contractor
Sent: Friday, February 09, 2007 5:12 PM
To: arslist@ARSLIST.ORG
Subject: Re: Mid Tier 7.0.1 patch 001

...to add to Fred's response.  Please give us an example of the syntax
being used (without giving your actual server and usernames)
Example:

http://webserver/arsys/servlet/ViewFormServlet?server=myarserver&form=HP
D:HelpDesk&view=Support&username=myname&pwd=mypass

 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W
Sent: Friday, February 09, 2007 4:05 PM
To: arslist@ARSLIST.ORG
Subject: Re: Mid Tier 7.0.1 patch 001

Which servlet are you calling?   ViewFormServlet or LoginServlet

I have seen some issues across the List on Login using the goto
parameter

Fred 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of ampierce
Sent: Friday, February 09, 2007 3:26 PM
To: arslist@ARSLIST.ORG
Subject: Mid Tier 7.0.1 patch 001

My team had installed 7.0.1 and had some issues getting the mid-tier to
work...finally after much configuration of TomCat, it is working.
We then tried to install 7.0.1 patch 001, we have some pages that auto
login as a guest user, and these are not working anymore. When you take
out the username and password from the string then the page works, but
not with it...any ideas


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


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


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

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

Re: View Field Behavior

[Kaiser Norm E CIV USAF 96 CG/SCWOE]

Ha! I was hoping you wouldn't ask that.  It's version 5.1.2, patch 1388 of
the midtier.

Norm

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black
Sent: Sunday, February 11, 2007 9:54 PM
To: arslist@ARSLIST.ORG
Subject: Re: View Field Behavior

Norm,

How about version and patch numbers? (maybe your seeing a few bugs in
a specific patch of the Mid-Tier?)

-- 
Carey Matthew Black
Remedy Skilled Professional (RSP)
ARS = Action Request System(Remedy)

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


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

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

Re: RANT: Diary fields in a dialog box..

[Joe DeSouza]

I'd rather stick with the dialog and not a new create/modify window for the 
simple reason, when a dialog is opened, the user cannot really access any 
fields through a gain focus (mouse click) until the dialog is closed so that 
gives you more control on the user..

 
Joe D'Souza
Remedy Developer / Consultant,
BearingPoint,
Virginia.



- Original Message 
From: Carey Matthew Black <[EMAIL PROTECTED]>
To: arslist@ARSLIST.ORG
Sent: Thursday, February 8, 2007 1:14:09 PM
Subject: Re: RANT: Diary fields in a dialog box


Hum...

Resize could be done via views designed for specific desktop sizes...
(with window open/close events to switch views.) Not as "any sized" as
the original, but very close.

Writing the field contents to a file... Sounds like a Report to file to me.

Reading a files contents into the field sounds like a $PROCESS$
more|less|type call to me. (likely not working on the Web however.)

And I think you could even make it a "non-dialog" window too. (If your
first window was not a dialog.) and let you keep multiple of those
windows open at a time.

-- 
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 2/8/07, Joe DeSouza <[EMAIL PROTECTED]> wrote:
> **
>
>
> Strange but thats exactly what me and a colleague of mine designed.. I've
> decided to hide the expansion box of the diary field and build another
> dialog having 2 fields for the edit and non edit part and 2 buttons OK and
> Cancel and emulate the diary field functionality using a small button near
> the actual diary field that brings up this second dialog..
>
>
>
> Only functions that users wont be able to do is resize the dialog and have
> these 2 fields resize automatically, and the option of saving the contents
> of a diary field to a file or writing from a file to the diary field.. you
> cant really get it all and yet make it look like the original field.. I
> could add the edit boxes for those 2 fields but the look and feel will
> differ distintively..
>
>
>
> Rgds
>
> Joe D'Souza
> Remedy Developer / Consultant,
> BearingPoint,
> Virginia.

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


 

Do you Yahoo!?
Everyone is raving about the all-new Yahoo! Mail beta.
http://new.mail.yahoo.com

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

Re: Mid Tier 7.0.1 patch 001

[Pierce, Amanda (TBS)]

We are using the exact syntax below, we have tried both the
ViewFormServlet and the LoginServlet to no avail. Does anyone have the
midtier pages working under IIS with TomCat on 7.0.1 patch 001? Did you
upgrade it from 7.0.1?

 
 
Amanda Pierce
PDS Client Systems Development
Technology Services
Turner Broadcasting System, Inc
404-827-2959
Please use http://sos to submit a technology request.

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Lucero, Michelle - IST
contractor
Sent: Friday, February 09, 2007 5:12 PM
To: arslist@ARSLIST.ORG
Subject: Re: Mid Tier 7.0.1 patch 001

...to add to Fred's response.  Please give us an example of the syntax
being used (without giving your actual server and usernames)
Example:

http://webserver/arsys/servlet/ViewFormServlet?server=myarserver&form=HP
D:HelpDesk&view=Support&username=myname&pwd=mypass

 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W
Sent: Friday, February 09, 2007 4:05 PM
To: arslist@ARSLIST.ORG
Subject: Re: Mid Tier 7.0.1 patch 001

Which servlet are you calling?   ViewFormServlet or LoginServlet

I have seen some issues across the List on Login using the goto
parameter

Fred 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of ampierce
Sent: Friday, February 09, 2007 3:26 PM
To: arslist@ARSLIST.ORG
Subject: Mid Tier 7.0.1 patch 001

My team had installed 7.0.1 and had some issues getting the mid-tier to
work...finally after much configuration of TomCat, it is working.
We then tried to install 7.0.1 patch 001, we have some pages that auto
login as a guest user, and these are not working anymore. When you take
out the username and password from the string then the page works, but
not with it...any ideas


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


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

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

Re: ARS 6.3 Upgrade - Shared Access Option

[Hugo Visser]

You might be safe using this for upgrades as long as the patch doesn't
involve changing or updating the data dictionary. The "shared" option will
not touch your database, assuming that some other install or patch has
already "upgraded" the db, if needed.

So for installing patches, I'd always use the upgrade option (once if you're
running a server group) so that the data dictionary matches the Remedy
version you are installing/patching. For a reinstall (same version, same
patch) you could use "shared" to speed up the installation.

Hugo

On 2/10/07, Jarl Grøneng <[EMAIL PROTECTED]> wrote:


I´m always doing the share-option when installing a patch. Not seeing
any issues with this on 6 and 6.3 servers.

--
Jarl

On 2/9/07, Lucero, Michelle - IST contractor <[EMAIL PROTECTED]>
wrote:
> Hence, the confusion.  This has to be the correct option, right?  Tech
> Support suggested that we use that option instead of "Upgrade".
>
> So has anyone out there used it, in a single AR Server, remote SQL DB
> environment, especially during a patch upgrade?
>
> Michelle
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:[EMAIL PROTECTED] On Behalf Of Lammey, Peter A.
> Sent: Friday, February 09, 2007 2:23 PM
> To: arslist@ARSLIST.ORG
> Subject: Re: ARS 6.3 Upgrade - Shared Access Option
>
> You shouldn't use this option with a patch upgrade right?
> It seems like this should be used if you are installing ARS on shared
> servers for the first time.
>
> Thanks
> Peter Lammey
> ESPN MIT Technical Services & Applications Management
> 860-766-4761
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:[EMAIL PROTECTED] On Behalf Of David Sanders
> Sent: Friday, February 09, 2007 2:56 PM
> To: arslist@ARSLIST.ORG
> Subject: Re: ARS 6.3 Upgrade - Shared Access Option
>
> Hi Michelle
>
> I haven't used this, but I would guess is designed for setting up
> multiple AR Servers to use a single AR Database.  Install the first
> server as normal, creating the database tables, then install ARS on the
> second server with this option to install the executables on the second
> server, without overwriting or upgrading the database from the first
> install.
>
> Does that make sense?
>
> David Sanders
> Remedy Solution Architect
> Enterprise Service Suite @ Work
> ==
> ARS List Award Winner 2005
> Best 3rd party Remedy Application
>
> tel +44 1494 468980
> mobile +44 7710 377761
> email [EMAIL PROTECTED]
>
> web http://www.westoverconsulting.co.uk
>
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:[EMAIL PROTECTED] On Behalf Of Lucero, Michelle - IST
> contractor
> Sent: Friday, February 09, 2007 7:31 PM
> To: arslist@ARSLIST.ORG
> Subject: ARS 6.3 Upgrade - Shared Access Option
>
> Hi, Y'all:
>
> One of the options during the upgrade, besides Upgrade and Overwrite, is
> Share.  This is supposed to preserve data [and related forms according
> to tech support] and simply install the executables and related files.
>
> 1.  Does this work as suggested?
> 2.  ...and newbie question of today, what exactly does "enables
> shared access" mean?
>
> We are not using Server groups.
>
> Share-Preserves data, installs server executables and related files, and
> enables shared access to the AR System database. Configure shared
> servers to belong to the same server group.
>
> Thanks,
> Michelle
>
> ESM Mission: "To provide the most accurate, timely, and actionable
> information to our customers so that they can effectively support the
> Mary Kay IST environment".
>
> 
> 
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where
> the Answers Are"
>
> 
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where
> the Answers Are"
>
> 
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where
> the Answers Are"
>
>
___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where
the Answers Are"
>


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



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