Re: Display as Text for Character Field

[Tucker, Rob]

Make sure that it isn't a display only field - and no, I've never done
that myself :)



From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Brittain, Mark
Sent: Monday, November 01, 2010 9:34 AM
To: arslist@ARSLIST.ORG
Subject: Re: Display as Text for Character Field


** 

Could the issue be input length or data type related? Check to see that
the Road Only field is big enough to receive the push and the data types
are compatible.

 

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of LJ LongWing
Sent: Monday, November 01, 2010 12:24 PM
To: arslist@ARSLIST.ORG
Subject: Re: Display as Text for Character Field

 

** 

Read Only is only a client attribute onlypush or set should work
into it without issue.  What is the problem you are specifically having
pushing into it?  You shouldn't need to push into another field and then
set into this one.  Is it giving you error?

 

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Kemes, Lisa
Sent: Monday, November 01, 2010 9:52 AM
To: arslist@ARSLIST.ORG
Subject: Re: Display as Text for Character Field

 

** 

I'm having problems pushing data directly to the Read Only field.  I
think that's the problem.  I have to probably push it to another field
on the form and the do a "set fields" to update the Read Only field.  

 

I'm testing this now.

 

All the other suggestions are good, but I want to keep the "look and
feel" of this field as Read Only.  If I do what the others suggest, then
the field will look as though it is writable.  

 

Lisa 

 

 



From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of LJ LongWing
Sent: Monday, November 01, 2010 11:42 AM
To: arslist@ARSLIST.ORG
Subject: Re: Display as Text for Character Field

** 

Lisa,

The field being 'read only' should have NO impact on your ability to set
the field to something via workflowwhen you say you can't, what sort
of problem are you getting?

 

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Kemes, Lisa
Sent: Friday, October 29, 2010 1:13 PM
To: arslist@ARSLIST.ORG
Subject: Display as Text for Character Field

 

** 

I originally set up a character field as Read Only, when a customer is
modifying or adding a record, they cannot change this field.  When they
do a search on this form, a Change Action makes this field Read/Write.
(I don't want anyone to change it, but I don't mind if they search on
the field).  Plus I don't want to make my users use the advanced search
option, I want to make it easy.

 

Well, I need some workflow to update this field from time to time, but
it won't let me because the field is Read Only.  No biggee, I'll just
change this field to Display as Text.  (even though I don't like Display
as Text sometimes, I always end up having to draw a little box around
the field).  But there is no Change Action to turn off this Display as
Text setting when the users are doing a search on the form.

 

Am I missing anything?  Is there an easy solution to this?

 

I'm working on the WUT (ARS 7.5 p4)

AR System Server 7.1 p7

Oracle 10g  

 

 

Lisa Kemes 

AR System Developer

Tyco Electronics

717-810-2408 tel

717-602-9460 cell

lisa.ke...@te.com

 

 

 

_attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ 

_attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ 

_attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ 

_attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ 




This e-mail is the property of NaviSite, Inc. It is intended only for
the person or entity to which it is addressed and may contain
information that is privileged, confidential, or otherwise protected
from disclosure. Distribution or copying of this e-mail, or the
information contained herein, to anyone other than the intended
recipient is prohibited.
_attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Re: Dev Studio and Escalation Pools - Resolved

[Tucker, Rob]

Thanks LJ. Got it.
 
-Rob



From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of LJ LongWing
Sent: Wednesday, June 02, 2010 2:07 PM
To: arslist@ARSLIST.ORG
Subject: Re: Dev Studio and Escalation Pools


** 

In the dev studio, you can choose which columns are visible in the list,
if it's not defaulted to showing, add it.

 

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Tucker, Rob
Sent: Wednesday, June 02, 2010 2:34 PM
To: arslist@ARSLIST.ORG
Subject: Dev Studio and Escalation Pools

 

** 

I'm probably blind, but I have not found a means to view what escalation
pool is set on an escalation without opening each escalation.

 

In the previous tool, it was simply a displayed column property.

 

Anyone found it?

 

-Rob

 

Rob Tucker

ARS Platform Support and Development

New Edge Networks

360.906.9710

rtuc...@newedgenetworks.com

 

_attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ 

_attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ 

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

Dev Studio and Escalation Pools

[Tucker, Rob]

I'm probably blind, but I have not found a means to view what escalation
pool is set on an escalation without opening each escalation.
 
In the previous tool, it was simply a displayed column property.
 
Anyone found it?
 
-Rob
 
Rob Tucker
ARS Platform Support and Development
New Edge Networks
360.906.9710
rtuc...@newedgenetworks.com
 

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

Re: Oregon Remedy User Group (ORUG) Meeting September 22, 2009

[Tucker, Rob]

Hey Man:

Do you have all of Jerry, J.T. and me on your list?

-Rob 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Thad K Esser
Sent: Thursday, September 17, 2009 1:19 PM
To: arslist@ARSLIST.ORG
Subject: Oregon Remedy User Group (ORUG) Meeting September 22, 2009


Hello,

For anyone that is interested in attending the next ORUG meeting in
Portland (Oregon), let me or Gary know and one of us will send you the
address and other contact info.

Oregon Remedy User Group Meeting September 22, 2009

AGENDA
8:00am - 8:30am:  Check-in & Continental Breakfast.
8:30am - 10:00 am:  "What's New in AR System & ITSM v7.5"- Tips and
Tricks;
7.5 AR Server and Dev Studio (Vicky Schmidt, Rapid Technologies)
10:00am-10:10am: Break
10:15am - 11:00am:  "Enhancing Remedy with Kinetic Data:  Request,
Survey, Calendar and Response solutions built on Remedy" (John Sundberg,
Kinetic
Data)
11:00am - 12:00pm:  "License Migration/Blue Pricing"

Thanks go to Rapid Technologies for sponsoring this meeting and helping
to put it together.

Thad Esser
Remedy Developer
"Now... Just where did I put that cheese...?"
*IMPORTANT NOTICE: This communication, including any attachment,
contains information that may be confidential or privileged, and is
intended solely for the entity or individual to whom it is addressed.
If you are not the intended recipient, you should delete this message
and are hereby notified that any disclosure, copying, or distribution of
this message is strictly prohibited.  Nothing in this email, including
any attachment, is intended to be a legally binding signature.
*

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Sample application - data-driven field auditing

[Tucker, Rob]

This is very well thought out David. Thanks for sharing. There are still
a bunch of us dinosaurs out here Gidd :)
 
-Rob
 
New Edge Networks



From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Gidd
Sent: Thursday, April 16, 2009 6:28 AM
To: arslist@ARSLIST.ORG
Subject: OT: Sample application - data-driven field auditing


** 
Comments:
 
 
I have indeed placed a copy of this solution in the download section of
our website.
 
>From the less then stellar responses of the ARS List it seems like we
are dinosaurs and
folks on the list just don't write their own code any more, pity.
Nonetheless this is a well
thought out solution that can save countless hours of time.   For those
of you that DO 
write your own code this is well worth a download and review.  David was
very thorough 
and even included documentation.
 
 
Gidd
 



From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of David Sanders
Sent: Wednesday, April 15, 2009 10:01 AM
To: arslist@ARSLIST.ORG
Subject: Sample application - data-driven field auditing


** 

Hi All

 

Here is a link to a small free application download to demonstrate a
data-driven approach to field data auditing which I hope will be of use
to some of you.

 

The sample application demonstrates how changes to field data can be
recorded. Rather than creating separate filters for each field to be
audited, the application uses a data-driven approach where fields can be
added to or removed from the list being audited without requiring any
workflow changes. 

The audit of data changes can either be stored in an Audit Trail (diary)
field on the data record, or stored as separate change records in a
Change Log form. 

Only changed fields are audited for each transaction, and the audit log
produced includes the user who made the change, time of the change, as
well as the original and changed field values. All audited changes in a
single transaction are included in a single log entry, rather than a
separate entry for each field being changed. 

The documentation provided with the sample application explains how to
add this field data auditing functionality to any existing Remedy data
form.

 

http://www.westoverconsulting.co.uk/utilitiesAudit.html

 

or

 

http://www.buoyantsolutions.net 
under the Downloads...ARS 7.x section

 

Regards

 

David Sanders

Remedy Solution Architect

Enterprise Service Suite @ Work

==

 

tel +44 1494 468980

mobile +44 7710 377761

email david.sand...@westoverconsulting.co.uk
 

 

web http://www.westoverconsulting.co.uk
 

 

 

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
Are"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the
Answers Are"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist:
"Where the Answers Are"_ 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Updating view forms

[Tucker, Rob]

My memory isn't what it used to be,  but I believe you can change the
view pointers at the database level by changing the tablename in the
SCHEMA_VIEW table, then restarting the system. You'll see the underlying
tables for your view fields in this table.
 
No Warranty Implied! :)
 
Rob Tucker
New Edge Networks



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W
Sent: Wednesday, February 27, 2008 3:09 PM
To: arslist@ARSLIST.ORG
Subject: Re: Updating view forms


** 
I don't know of a way to change the Remedy view location other than
exporting to a def, modifying the def, deleting the form and
re-importing from the modified def.  Importing in place (without
deleting the form) might work.
 
 
Have you tried creating a local Remedy db view of the remote data.
Basically drop the synonym and do:
 
Create or Replace View MYSCHEMA.MYVIEW
as
select * from [EMAIL PROTECTED]; 

No changes to Remedy will then be necessary.  
 
Fred
 
 


From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Jill E
Sent: Wednesday, February 27, 2008 5:00 PM
To: arslist@ARSLIST.ORG
Subject: Updating view forms


Greetings,

In an ARS 7.0.1 / RHEL4 64bit / Oracle 10g environment, I created a view
form to look at a view of another schema in the same database as Remedy.
That schema was moved to another Oracle database so now a DB link must
be employed.  This is fine except that I need to update the view form in
ARS so that it knows to look in the new location.

How can I update the view form definition to look at a different
database location?

Specifically, I want to change 
Form Properties > View Information > Table Name value from
MYSCHEMA.MYVIEW to [EMAIL PROTECTED],
Field Properties > Database tab > View Information > Table value,
or use some other means to update the view form to use a new table name
value.

I tried a workaround by creating a synonym, which works fine in SQLPlus
for running queries as aradmin like "select * from MYSCHEMA.MYVIEW where
id='foo'" but each time I open the view form in Remedy Administrator,
the error "Requested database table not found. Please check the spelling
(table name is case-sensitive) (ARERR 481)" is reported and I am not
able to get AR to use the synonym, even to create new view form, like I
am with SQLPlus.  I've found old bugs relating to synonyms, but I am not
tied to using this approach to solve the problem anyway.

Thanks for any advice you can offer!

Jill Anderson
  __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___ 

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

Re: Worflow to do a Spellcheck via the Web?

[Tucker, Rob]

What about something simple like the google tool bar?

Rob Tucker
New Edge Networks 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Garrison, Sean (Norcross)
Sent: Wednesday, January 23, 2008 10:34 AM
To: arslist@ARSLIST.ORG
Subject: Re: Worflow to do a Spellcheck via the Web?

Thanks for the info ... I wish we could use the firefox solution but our
company has standardized on IE 6 (soon to jump to 7) ...

Sean

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Seth Wrye
Sent: Wednesday, January 23, 2008 11:19 AM
To: arslist@ARSLIST.ORG
Subject: Re: Worflow to do a Spellcheck via the Web?

IEspell works well ( http://www.iespell.com/ ).  The only problem is
that it is free for personal use but you have to pay for a corporate
solution.  Could get into licensing issues.  I think that Firefox is the
better solution though.

Seth Wrye



From: Action Request System discussion list(ARSList) on behalf of Carey
Matthew Black
Sent: Wed 1/23/2008 11:08 AM
To: arslist@ARSLIST.ORG
Subject: Re: Worflow to do a Spellcheck via the Web?



How about using Firefox?

http://www.mozilla.com/en-US/firefox/features.html#experience
"
Spell Checking
Sometimes you're in a rush, and can't remember if it's "i" before "e"
or the other way around. Firefox 2 has built-in spell checking to keep
you from making any mistakes in your blog posts and Web-based email, so
you can worry about more important things.
"

--
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 Jan 23, 2008 10:35 AM, Garrison, Sean (Norcross)
<[EMAIL PROTECTED]> wrote:
> **
>
> Does anyone know of a way to do spell checking in Remedy Mid-Tier?
>
>
> Sean


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




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


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

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

Re: Server woe...

[Tucker, Rob]

Do you see an error indicating a problem on arserver restart in the
arerror log? You may also want to check to verify that the views have
been properly created.
 
 
Rob Tucker
New Edge Networks



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Mike White
Sent: Wednesday, January 16, 2008 7:59 AM
To: arslist@ARSLIST.ORG
Subject: Re: Server woe...


** 

More of a punt than diagnosis, but you can try clearing cache

Mike White
Office: 813-978-2192
E-mail: [EMAIL PROTECTED]
 Chris While <[EMAIL PROTECTED]>



 



Chris While
<[EMAIL PROTECTED]>
Sent by: "Action Request System
discussion list(ARSList)"  

01/16/2008 10:37
Please respond to arslist



To: arslist@ARSLIST.ORG
cc: 
Subject: Server woe...  


** Hi,

Got an interesting one. I have a form which I can see and edit in Admin
Tool. When I go to the user tool, I cannot open it. Checked permissions,
restarted both app and DB, still nothing.

We are running 7.0.1 Patch 003

When trying to run export from command line, both Form and Active Links
were not brought across!

Any suggestions ?

Thanks

Chris
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the
Answers Are" html___ 


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

Re: Resetting Incident Number to 1

[Tucker, Rob]

The incident number is the request id on HPD:CFG Ticket Num Generator.
It can be reset as the nextid on that form.

Rob Tucker
New Edge Networks 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Mary Dollus
Sent: Thursday, December 06, 2007 2:24 PM
To: arslist@ARSLIST.ORG
Subject: Re: Resetting Incident Number to 1

Thanks Drew 

Yep I looked at the db and looked at any table that looked like it might
contain the incident number but couldn't find it.

Isn't an H table just Status History records though?

I'll post it if I find the answer...

Thanks again for your responses

Mary

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Drew Shuller
Sent: Thursday, December 06, 2007 3:42 PM
To: arslist@ARSLIST.ORG
Subject: Re: Resetting Incident Number to 1

Mary, I get it now, but I don't think I can help. A copy of Oracle SQL
Developer will give you a view where you can see all the tables and the
next record id, so you would be able to find 18429 and that may help
solve the puzzle. One of the guys here says to recache the arserver and
try again, or maybe it's an H table.

Drew


On Thu, 6 Dec 2007, Mary Dollus
wrote:

> Hi Drew,
>
> Well that's just it...
>
> Schemaid 1247 is the HPD:Help Desk form and the nextid field seems

> to contain the next 'request id' number.. however as you can see from 
> the log below, it sets UPDATE arschema SET nextId = nextId + 1 WHERE 
> schemaId =
1247
>
> But that's the request id field...
>
> But then it sets
>
> */INSERT INTO H1247 (entryId,T0,U0,T1,U1) VALUES
> ('INC00018430',1196971076,'mtdollu',1196971076,'mtdollu')
>
> One of the values is 'INC00018430' which is really the incident
id.
>
> When I look at the db, the value in nextid is 371... not 18429.
>
> So seemingly I'd set the nextid field.. but where in the world is the
system
> coming up with 18430?
>
> Sorry if it's very simple and I'm making it overly complicated:(
>
> Thanks!!
>
>
> -Original Message-
> From: Action Request System discussion list(ARSList) 
> [mailto:[EMAIL PROTECTED] On Behalf Of Drew Shuller
> Sent: Thursday, December 06, 2007 2:36 PM
> To: arslist@ARSLIST.ORG
> Subject: Re: Resetting Incident Number to 1
>
> Mary, forgive me if I'm giving an answer you already know...wouldn't 
> you reset whatever table schemaId=1247 is?
>
> Drew
>
>
> On Thu, 6 Dec 2007, Mary Dollus
> wrote:
>
>> Below is the log entry that sets the number.. it's using $LASTID$ to 
>> get
> the
>> Incident number... where can that be reset?  Thanks again!!!
>>
>>
>>  Checking HPD:INC:GIN_010_SetINCNumber-P (10)
>>  -> Passed qualification -- perform if actions
>>   0: Push Fields
>>  To Schema HPD:CFG Ticket Num Generator on Server @
>>  (2) = mtdollu
>>
>>
>>  >> /* Thu
>>
>> Dec 06 2007 13:57:56.1005 */+CE ARCreateEntry -- schema HPD:CFG
Ticket
>> Num Generator from Remedy User (protocol 12) at IP address
192.168.1.64
>>
>>  >> /* Thu
>>
>> Dec 06 2007 13:57:56.1010 */Start filter processing -- Operation -
CREATE
>>
>>  >>  HPD:CFG Ticket Num Generator - 
>>
>>  >> /* Thu
>>
>> Dec 06 2007 13:57:56.1186 */ End of filter processing (phase 1)
>>
>>  >> /* Thu
>>
>> Dec 06 2007 13:57:56.1187 */UPDATE arschema SET nextId = nextId + 1 
>> WHERE schemaId = 1247
>>
>>  >> /* Thu
>>
>> Dec 06 2007 13:57:56.1212 */OK
>>
>>  >> /* Thu
>>
>> Dec 06 2007 13:57:56.1212 */SELECT nextId FROM arschema WHERE 
>> schemaId =
>> 1247
>>
>>  >> /* Thu
>>
>> Dec 06 2007 13:57:56.1227 */OK
>>
>>  >> /* Thu
>>
>> Dec 06 2007 13:57:56.1230 */INSERT INTO T1247 
>> (C2,C179,C7,C8,C3,C5,C6,C1) VALUES
>>
>
('mtdollu','AG216371749900R1hURAETcyMAnXMA',1,'.',1196971076,'mtdollu',1
1969
>> 71076,'INC00018430')
>>
>>  >> /* Thu
>>
>> Dec 06 2007 13:57:56.1290 */OK
>>
>>  >> /* Thu
>>
>> Dec 06 2007 13:57:56.1291 */INSERT INTO H1247 (entryId,T0,U0,T1,U1)
VALUES
>> ('INC00018430',1196971076,'mtdollu',1196971076,'mtdollu')
>>
>>  >> /* Thu
>>
>> Dec 06 2007 13:57:56.1352 */OK
>>
>>  >> /* Thu
>>
>> Dec 06 2007 13:57:56.1353 */COMMIT WORK
>>
>>  >> /* Thu
>>
>> Dec 06 2007 13:57:56.3304 */ Restart of filter processing (phase
3)
>>
>>  >> /* Thu
>>
>> Dec 06 2007 13:57:56.3305 */Stop filter processing
>>
>>  >> /* Thu
>>
>> Dec 06 2007 13:57:56.3305 */-CE   OK -- New ID
INC00018430
>>
>> -Original Message-
>> From: Mary Dollus [mailto:[EMAIL PROTECTED]
>> Sent: Thursday, December 06, 2007 1:54 PM
>> To: 'arslist@ARSLIST.ORG'
>> Subject: Resetting Incident Number to 1
>>
>> Hello all,
>>
>> I looked thru the arslist to see how this was done.  What I found is 
>> that
> it
>> says to set the "nextid" field to 1 in the arschema table where name 
>> = "HPD:Help Desk".
>>
>> However I don't want to reset the Request ID field, just the Incident

>> ID fie

ARS Chat Integration

[Tucker, Rob]

 
Hello All:
 
Has anyone done a java based chat integration with Remedy? Anything
product you prefer over another?
 
I'm looking to replace a product called 'Right Now' so call center
agents would see requested chats, pick them from a queue which would
create an incident, then on close the content of the chat would be
dumped into the incident worklog.
 
Thanks!
 
-Rob
 
Rob Tucker
New Edge Networks

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

Re: CMDB Data Dictionary Creator

[Tucker, Rob]

Very Interested.
 
 
-Rob
 
Rob Tucker
AR System Developer
New Edge Networks



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Axton
Sent: Friday, November 09, 2007 7:07 AM
To: arslist@ARSLIST.ORG
Subject: RFC: CMDB Data Dictionary Creator


** What would the interest be in a tool that generates some type of
documentation (html, pdf, and/or doc) generator for the CMDB
class/attribute structures?  This tool would generate something
comparable to the html class documentation files bundled with the CMDB. 

This would be useful to generate documentation for altered cdm data
models within the cmdb, which I am assume, to varying degrees, is most
users of the cmdb.

Please post responses back to the list.

Thanks, 
Axton Grams
__20060125___This posting was submitted with HTML in
it___ 

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

Horizontal and Vertical Navigation Fields

[Tucker, Rob]

Hello All:
 
I have an interesting problem what has me tearing my hair out. (What
little I have left)
 
I have a DO form with two horizontal and one vertical navigation fields.
 
Most of my users are fine, but with some users, in place of the nav
fields, are getting a "Page Cannot be Displayed" IE error. This is using
the windows client. MidTier is fine.
 
This spans multiple versions of IE and is on both Win XP and Win2000
OS.s
 
I have played with IE security settings, verified the server can be
pinged both in short and FQDM formats from the workstations having the
problems. Mid can be accessed with no problem on the same server from
these workstations. 
 
Windows Client 7.00.01 patch 001
ARS  7.00.01 patch 001
 
Any thoughts would be very much appreciated,
 
-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: Portland RUG (Oregon, not Maine)

[Tucker, Rob]

On behalf of the two of us at New Edge Networks in Vancouver, we'd be
very interested.
 
Rob Tucker
New Edge Networks
[EMAIL PROTECTED]



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Thad Esser
Sent: Wednesday, February 14, 2007 12:36 PM
To: arslist@ARSLIST.ORG
Subject: Portland RUG (Oregon, not Maine)


** 
Hello, 

A few weeks ago as a tangent of a completely different thread, the topic
of a Portland RUG came up.  I received a few responses from people that
were interested, but I wanted to see if there were any others out there
that would be interested in attending.  And what are your primary areas
of interest? 

Last year in Seattle, BMC held a free, half-day version of their
"Airport Simulation" seminar
(http://www.bmc.com/education/servicemgmt/courses/q-itil-150.htm).  I
found it a nice introduction to ITIL concepts.  Maybe we could do
something like that here if there was interest?  Or anything else.  I'm
not sure what people are more interested in, a 3/4 day "event", or a 2
hour "evening with friends over a beer" kind of thing.  Or both.  :-) 

Anyway, contact me if you are interested and we can work out the details
off-list. 

Thanks,
Thad Esser
Remedy Developer
"Argue for your limitations, and sure enough, they're yours."-- Richard
Bach 

***IMPORTANT NOTICE: This communication, including any attachment,
contains information that may be confidential or privileged, and is
intended solely for the entity or individual to whom it is addressed. If
you are not the intended recipient, you should delete this message and
are hereby notified that any disclosure, copying, or distribution of
this message is strictly prohibited. Nothing in this email, including
any attachment, is intended to be a legally binding signature.***


__20060125___This posting was submitted with HTML in
it___

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

Re: Oracle LOB relocation

[Tucker, Rob]

My DBA's are having a real problem with setting cursor-sharing parameter
for the entire instance. Evidently is cause some  problems in the other
table spaces.
 
Is there a means of setting the parameter for just the ars session?
Something like the following when the server is started?
 
ALTER SESSION set CURSOR_SHARING = FORCE;"
 
-Rob Tucker



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Axton
Sent: Tuesday, February 13, 2007 10:41 AM
To: arslist@ARSLIST.ORG
Subject: Re: Oracle LOB relocation


** 

Slightly OT, but you may want to instruct your dba's to set the oracle
instance parameter 'cursor_sharing' to similar or force.  This will
greatly reduce the size requirements of oracle's shared pool and greatly
reduce hard parses. 

This whitepaper covers some of the details:
http://documents.bmc.com/supportu/documents/78/31/67831/67831.pdf

My favorite quote from this doc: "Any application that uses all literals
without cursor sharing enabled is not a very scalable application."

Axton Grams


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

** 
Thanks Axton. As always, great information
 
-Rob



From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG ] On Behalf Of Axton
Sent: Monday, February 12, 2007 5:34 PM
To: arslist@ARSLIST.ORG 
Subject: Re: Oracle LOB relocation

 
** 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]
<mailto:[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___ 


__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 www.arslist.org ARSlist:"Where the 
Answers Are"

Re: Oracle LOB relocation

[Tucker, Rob]

Thanks Axton. As always, great information
 
-Rob



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Axton
Sent: Monday, February 12, 2007 5:34 PM
To: arslist@ARSLIST.ORG
Subject: Re: Oracle LOB relocation


** 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]
<mailto:[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___ 


__20060125___This posting was submitted with HTML in
it___ 

___
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"

ARWARN 69

[Tucker, Rob]

 
I am using the admin tool to import a new definition of a form from one
server to another.
 
I am getting the following error:
 
Creation of one of the SQL views for the form failed within the SQL
database.
Operation completed successfully, but the SQL view is not in place.
(ARWARN 69)
 
I am using the option to replace the current form.
 
I see the following error with SQL logging turned on:
 
*** ERROR ***  ORA-00904: "C536871270": invalid identifier
 
Which is a valid character field on the form.
 
I'm very much at a loss as to how to proceed. Any words of wisdom would
be appreciated.
 
ARS 7.0.1 on Solaris
Oracle 10.2.0.1.0
 
 
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: Apache/Tomcat

[Tucker, Rob]

Thanks Tony 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Tony Worthington
Sent: Monday, January 29, 2007 1:28 PM
To: arslist@ARSLIST.ORG
Subject: Re: Apache/Tomcat

Sure.  Either run Tomcat on port 80, or use a connector.

There are remedy-specific whitepapers on the support site about this.
Some may be geared towards Remedy Knowledge Management.

http://tomcat.apache.org/tomcat-3.3-doc/mod_jk-howto.html
http://tomcat.apache.org/connectors-doc/reference/apache.html

Below is a quick sample from my configs.  Refer to the links above for
more specifics.

apache httpd.conf:



  LoadModule jk_module "E:/Program Files/Apache Software
Foundation/Apache2.2/modules/mod_jk.so"


JkMount /arsys ajp13
JkMount /arsys/* ajp13

JkMount /rkm ajp13
JkMount /rkm/* ajp13

JkMount /manager ajp13
JkMount /manager/* ajp13


tomcat server.xml





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



"Tucker, Rob" <[EMAIL PROTECTED]> 
Sent by: "Action Request System discussion list(ARSList)" 

01/29/2007 02:45 PM
Please respond to
arslist@ARSLIST.ORG


To
arslist@ARSLIST.ORG
cc

Subject
Apache/Tomcat






** 
All right all you gurus.
 
I have MidTier 7.0.1 running on Apache/Tomcat.
 
After install, the only way I can hit the MidTier is by using port 8080
(
http://server:8080/arsys)
 
Is there anyway to configure so I do not have to use the 8080 port to
hit 
the arsys directory? (http://server/arsys)
 
Thanks in advance,
 
-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___ 


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"

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

RESOLVED: Apache/Tomcat

[Tucker, Rob]

 Thanks Will!

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Will Du Chene
Sent: Monday, January 29, 2007 1:38 PM
To: arslist@ARSLIST.ORG
Subject: Re: Apache/Tomcat

Rob:

You have to use the mod_jk connector to bridge the gap between apache
and tomcat. There is a tutorial on how to put this togeter over on the
Apache website.

http://tomcat.apache.org/connectors-doc/webserver_howto/apache.html





> All right all you gurus.
>
> I have MidTier 7.0.1 running on Apache/Tomcat.
>
> After install, the only way I can hit the MidTier is by using port 
> 8080
> (http://server:8080/arsys)
>
> Is there anyway to configure so I do not have to use the 8080 port to 
> hit the arsys directory? (http://server/arsys)
>
> Thanks in advance,
>
> -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"
>


___
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"

Apache/Tomcat

[Tucker, Rob]

All right all you gurus.
 
I have MidTier 7.0.1 running on Apache/Tomcat.
 
After install, the only way I can hit the MidTier is by using port 8080
(http://server:8080/arsys)
 
Is there anyway to configure so I do not have to use the 8080 port to
hit the arsys directory? (http://server/arsys)
 
Thanks in advance,
 
-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: Oracle View Forms

[Tucker, Rob]

Thanks Axton. That helps quite a bit.
 
-Rob



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Axton
Sent: Sunday, January 28, 2007 10:27 AM
To: arslist@ARSLIST.ORG
Subject: Re: Oracle View Forms


** If your aradmin account has 'select any dictionary' permissions, you
can log into your remedy oracle instance and see if what you are
providing for the schema/table match what's out there using this:

If it's a table: 
select owner, table_name from all_tables where owner = 'OMS'

If it's a view:
select owner, view_name from all_views where owner = 'OMS'

If your aradmin account does not have this privelage, you can attempt to
describe the table using your aradmin account from sql*plus: 
desc OMS.OI_END_USER_VW

If all of the above fail to show the table/view you are attempting to
access, then it either doesn't exist (first two options), or you don't
have permissions (third approach). 

Axton Grams



On 1/28/07, Tucker, Rob <[EMAIL PROTECTED]> wrote: 

** 
I hope one of you good folks is working weekends :)
 
I originally had the remedy database in it's own instance of
oracle. For reasons knows only to the powers that be, we have moved the
tablespace from it's own instance to a shared instance.
 
The system runs fine except for all my view forms that
previously used a db link to pull data.
 
The view forms were built similar to:
[EMAIL PROTECTED]
 
where PHNXP.WORLD was the db link.
 
Now that I am sharing a instance with the data I previously
accessed using the dblink and since the dba's tell me a dblink cannot
share the name as the instance, I have to redo the view forms.
 
Trouble is when I attempt to create a view form as follows:
OMS.OI_END_USER_VW
 
I get this error:  Requested database table not found.  Please
check the spelling (table name is case-sensitive) (ARERR 481).
 
You'll note that the schema.table name are identical to before
and I have verified them as being correct.
 
What am I missing?
 
 
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___ 


__20060125___This posting was submitted with HTML in
it___ 

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

Re: Oracle View Forms

[Tucker, Rob]

I'm thinking that since I have do do this and am no longer on a remote
DB instance that I might as well just recode the Al's and filters with
direct SQL anyway. That's one less step that recreating the View Forms,
the having to repaint all the workflow anyway.
 
Thanks, Frank
 
-Rob



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Frank Caruso
Sent: Sunday, January 28, 2007 9:50 AM
To: arslist@ARSLIST.ORG
Subject: Re: Oracle View Forms


** Was the name in upper case letters?

I was playing with the View form stuff for a little bit and was watching
SQL logs to see what exactly it was doing. One thing you might try is
turning on SQL logging and create a new view form. You will then be able
to see the exact SQL it runs. I saw stuff about selecting from the
all_tables and all_columns tables using the provided
[EMAIL PROTECTED] vlalue.

I also thought more about this and realized that if you're recreating
all of the view forms, that is like recreating a regular form. If you
have work flow tied to that form it will also need to also be created.
Any table fields using those views would have to be reconstructed. A ton
of work for 80 forms! 
So, I started playing with trying to just change the DB Link value. I
was able to recreate the underlying (T???) view with the a new DB Link
value. The existing view form used the new DB Link and pointed to the
new database. This is probably not supported by BMC but might be a quick
way to get you back up and running. 





On 1/28/07, Tucker, Rob <[EMAIL PROTECTED]> wrote: 

** 
Yes, aradmin has selected permissions against everything in
those schemas.
 
About 80 view forms :(



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Frank Caruso
Sent: Sunday, January 28, 2007 8:38 AM
To: arslist@ARSLIST.ORG
Subject: Re: Oracle View Forms


** Does the ARSystem user have select access against that table?


How many views do you have to redo?


    
        On 1/28/07, Tucker, Rob < [EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]> > wrote: 

** 
I hope one of you good folks is working weekends :)
 
I originally had the remedy database in it's own
instance of oracle. For reasons knows only to the powers that be, we
have moved the tablespace from it's own instance to a shared instance.
 
The system runs fine except for all my view forms that
previously used a db link to pull data.
 
The view forms were built similar to:
[EMAIL PROTECTED]
 
where PHNXP.WORLD was the db link.
 
Now that I am sharing a instance with the data I
previously accessed using the dblink and since the dba's tell me a
dblink cannot share the name as the instance, I have to redo the view
forms.
 
Trouble is when I attempt to create a view form as
follows:  OMS.OI_END_USER_VW
 
I get this error:  Requested database table not found.
Please check the spelling (table name is case-sensitive) (ARERR 481).
 
You'll note that the schema.table name are identical to
before and I have verified them as being correct.
 
What am I missing?
 
 
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___ 




-- 
Frank Caruso
Specific Integration, Inc.
Senior Remedy Engineer, ITIL Foundation Certified
www.specificintegration.com 

703-376-1249 __20060125___This posting was
submitted with HTML in it___ 
__20060125___This posting was submitted with
HTML in it___ 




-- 
Frank Caruso
Specific Integration, Inc.
Senior Remedy Engineer, ITIL Foundation Certified
www.specificintegration.com 
703-376-1249 __20060125___This posting was submitted
with HTML in it___ 

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

Re: Oracle View Forms

[Tucker, Rob]

Yes, aradmin has selected permissions against everything in those
schemas.
 
About 80 view forms :(



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Frank Caruso
Sent: Sunday, January 28, 2007 8:38 AM
To: arslist@ARSLIST.ORG
Subject: Re: Oracle View Forms


** Does the ARSystem user have select access against that table?
How many views do you have to redo?



On 1/28/07, Tucker, Rob < [EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]> > wrote: 

** 
I hope one of you good folks is working weekends :)
 
I originally had the remedy database in it's own instance of
oracle. For reasons knows only to the powers that be, we have moved the
tablespace from it's own instance to a shared instance.
 
The system runs fine except for all my view forms that
previously used a db link to pull data.
 
The view forms were built similar to:
[EMAIL PROTECTED]
 
where PHNXP.WORLD was the db link.
 
Now that I am sharing a instance with the data I previously
accessed using the dblink and since the dba's tell me a dblink cannot
share the name as the instance, I have to redo the view forms.
 
Trouble is when I attempt to create a view form as follows:
OMS.OI_END_USER_VW
 
I get this error:  Requested database table not found.  Please
check the spelling (table name is case-sensitive) (ARERR 481).
 
You'll note that the schema.table name are identical to before
and I have verified them as being correct.
 
What am I missing?
 
 
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___ 




-- 
Frank Caruso
Specific Integration, Inc.
Senior Remedy Engineer, ITIL Foundation Certified
www.specificintegration.com 
703-376-1249 __20060125___This posting was submitted
with HTML in it___ 

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

Oracle View Forms

[Tucker, Rob]

I hope one of you good folks is working weekends :)
 
I originally had the remedy database in it's own instance of oracle. For
reasons knows only to the powers that be, we have moved the tablespace
from it's own instance to a shared instance.
 
The system runs fine except for all my view forms that previously used a
db link to pull data.
 
The view forms were built similar to:  [EMAIL PROTECTED]
 
where PHNXP.WORLD was the db link.
 
Now that I am sharing a instance with the data I previously accessed
using the dblink and since the dba's tell me a dblink cannot share the
name as the instance, I have to redo the view forms.
 
Trouble is when I attempt to create a view form as follows:
OMS.OI_END_USER_VW
 
I get this error:  Requested database table not found.  Please check the
spelling (table name is case-sensitive) (ARERR 481).
 
You'll note that the schema.table name are identical to before and I
have verified them as being correct.
 
What am I missing?
 
 
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: Flashboards not working

[Tucker, Rob]

Is your default web path set in the admin tool?

Rob Tucker
New Edge Networks 

-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Jose Manuel Viejo Lobato
Sent: Wednesday, January 10, 2007 2:45 AM
To: arslist@ARSLIST.ORG
Subject: Flashboards not working

Hi all.

My flashboards is not working properly (in WUT and mid-tier). The problem is 
the image is not displayed, like if the URL was incorrect.

Using midtier I can find the URL that is trying to retrieve, and is something 
like:

http://arsys/servlet/FBImageServlet?key=SERVER%3AUSER%3A248

but... ¿where is the webserver name?

If I copy this URL in the browser and modify including the webserver name 
(something like http://WEBSERVERNAME/arsys/servlet/FBImageServlet?
key=SERVER%3AUSER%3APWD), the image shows properly...

In another server, everything is working fine. The only difference I can see 
between servers is that in the machine with the error, I use a virtualhost to 
connect to Remedy Midtier, so I don't use the IP or the servername, but a 
virtualhost.

¿¿¿Any Idea

Thanks.

Jose Manuel Viejo Lobato.
[EMAIL PROTECTED]
ViejoLobato S.L.

___
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"

Tree Table Fields

[Tucker, Rob]

Does anyone out there know what would prevent character fields having a
length of 60 char and not being display only fields from being available
in the sort/levels of a table (tree) based on that same base form? I
have read that of course DO fields and those with a length over 128
characters aren't available, but these don't fit the bill and I'm left
scratching my head.
 
ARS 7.0.00
Oracle 10.2.0.1
 
 
 

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"

Network Ticket Categorization

[Tucker, Rob]

**



Do any of you good 
folks who work for Telecom companies have access to any industry standard 
practices for categorization of network issues?
 
I'm being told that 
there exists a standard industry coding.
 
Thanks,
 
-Rob
 

Rob 
Tucker 
New Edge 
Networks 
ARS Administration and 
Development
[EMAIL PROTECTED] 



  
  
  Vancover,Washington 
  
tel: 
  360-759-9670fax:360-693-9997 

 
 
__20060125___This posting was submitted with HTML in it___

Re: Attachment Size

[Tucker, Rob]

**



Hey David:
 
Here is a dirty little 
app I cooked up some time ago that will give you the file size. You can tear the 
filters apart to see what I did. I haven't looked at it in a while, so I 
apologize for whatever you might find :)
 
-Rob
 
Rob Tucker
New Edge 
Networks


From: Action Request System discussion list(ARSList) 
[mailto:[EMAIL PROTECTED] On Behalf Of David YearsleySent: 
Monday, July 17, 2006 9:03 AMTo: 
arslist@ARSLIST.ORGSubject: Attachment Size
** 

I have a strange request to put the size of an attachment in a number 
field. I have been searching the documentation and have been unable to find any 
reference to the size. 
 
Does anyone know how to do this?
 
Thanks__20060125___This posting was submitted 
with HTML in it___
__20060125___This posting was submitted with HTML in it___


SHRAttachments.def
Description: SHRAttachments.def