Re: Mysterious gap in log files.

[Misi Mladoniczky]

Hi!

And make sure to put everything in the same file (API, SQL, FLTR, ESCL).
That will make it easier to follow.

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

Products from RRR Scandinavia:
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
* RRR|Translator - Manage and automate your language translations.
Find these products, and many free tools and utilities, at http://rrr.se.

> I would add in SQL logging.  I bet there is some DB activity that makes
> up for this gap.
>
> 
>
> From: Action Request System discussion list(ARSList)
> [mailto:[EMAIL PROTECTED] On Behalf Of William Rentfrow
> Sent: Tuesday, April 01, 2008 2:12 PM
> To: arslist@ARSLIST.ORG
> Subject: Re: Mysterious gap in log files.
>
>
> **
> Unfortunately there's nothing in the API log to show - it calls +CE on
> HPD:Help Desk to create the entry - the next item in the API log is
> after the entry is created.  That's a 39 second stretch during which the
> filter items I mentioned are occurring.
>
> The snippet below is directly from the filter log - these lines are
> consecutive - I just shaved off the beginning parts of the lines in my
> original post for readability.
>
> The two consecutive entries from the arfilter log are verbatim below:
>
>
>  > /* Tue Apr 01 2008 11:08:00.5076 */ End of filter processing
> (phase 1) -- Operation - CREATE on SYS:Action - 
>
>  > /* Tue Apr 01 2008 11:08:03.5168 */ End of filter processing
> (phase 2) -- Operation - CREATE on SLM:Measurement - 094
>
>
> 
>
> From: Action Request System discussion list(ARSList)
> [mailto:[EMAIL PROTECTED] On Behalf Of Axton
> Sent: Tuesday, April 01, 2008 1:07 PM
> To: arslist@ARSLIST.ORG
> Subject: Re: Mysterious gap in log files.
>
>
> ** Post the filter/api log snippets that show the gap with the TID and
> RPC ID included.
>
> Axton
>
>
> On Tue, Apr 1, 2008 at 12:32 PM, William Rentfrow
> <[EMAIL PROTECTED]> wrote:
>
>
>   **
>   I am trying to tighten up the time it takes to create a new
> Incident in IM 7.03 (ARS 7.01, Solaris, remote oracle DB).
>
>   I've checked the threads/queues quite thoroughly and they
> appears to be fine - there's plenty of available time queue time.
> However, in the filter log there are multiple places where this happens:
>
>
>   Tue Apr 01 2008 11:08:03.6332 */ End of filter processing
> (phase 1) -- Operation - CREATE on SYS:Action - 
>   Tue Apr 01 2008 11:08:06.6404 */ End of filter processing
> (phase 2) -- Operation - CREATE on SLM:Measurement - 095
>
>   Notice the three second gap between those two - there is NOTHING
> else going on anywhere else in the SQL or API logs to indicate some
> processing - it's just three seconds of the nothing in all of the logs.
> Every time there's a "end of filter processing' phase message we just
> stop for 3 seconds.
>
>   In my 39-second Incident creation time there are a total of 10
> of these gaps - 30 seconds where absolutely nothing appears to be
> happening.
>
>   Keep in mind this is a large solaris server and I'm the only one
> on it - there's no lack of server resources.  We've got plenty of
> hamsters/wheels/etc to power this thing.
>
>   William Rentfrow, Principal Consultant
>   [EMAIL PROTECTED]
>   C 701-306-6157
>   O 952-432-0227
>
>   __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the
> Answers Are" html___
>
>
> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
> html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the
> Answers Are" html___
>
>
>
> -
> **
> This email and any files transmitted with it are confidential and
> intended solely for the individual or entity to whom they are
> addressed. If you have received this email in error destroy it
> immediately.
> **
> Wal-Mart Confidential
> **
>
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
> --
> This message was scanned by ESVA and is believed to be clean.
>
>

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

5.1.2 download

[Satya Gandhi]

Dear Listers,

Where can i download 5.1.2 server and other components? I checked on the
product availability and cant find any reference for 512

-- 
Thanks & Regards

Satya Gandhi

Consultant - Remedy

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

Re: 5.1.2 download

[Kelly Deaver]

5.1.2 is no longer supported by BMC. 6.3 is the oldest version available.
-
Kelly Deaver
[EMAIL PROTECTED]


>  Original Message 
> Subject: 5.1.2 download
> From: Satya Gandhi <[EMAIL PROTECTED]>
> Date: Wed, April 02, 2008 4:48 am
> To: arslist@ARSLIST.ORG
> 
> Dear Listers,
> 
> Where can i download 5.1.2 server and other components? I checked on the
> product availability and cant find any reference for 512
> 
> -- 
> Thanks & Regards
> 
> Satya Gandhi
> 
> Consultant - Remedy
> 
> ___
> 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: Displaying login.jsp out of Mid-Tier SOLVED

[Dwayne Martin]

As Carey says, the answer is very simple.  Unfortunately some of us have to try 
all sorts of complications before we find it.

To access the login page directly you go to:
http:///arsys/shared/login.jsp

So you copy login.jsp to newname.jsp, then point your url to:
http:///arsys/shared/newname.jsp

Then you edit newname.jsp till you get it like you want it.

Thank you, Carey, and Vinod Suyal of Remedy Support for this solution, and 
Isabel for your help.

Dwayne Martin

--
On Wed, Mar 26, 2008 at 9:08 AM, Dwayne Martin <[EMAIL PROTECTED]> wrote:
Hello Everyone,

I want to customize our login.jsp page.  But it may take some time, and I don't 
want mess up the display when users are trying to log in.

How can I edit it, and see what it looks like, other than by putting it in the 
Mid-Tier\shared folder and trying it out?

If I open it directly in either Mozilla or IE browser everything is strewed all 
over the screen.

(Mid-Tier 7.1 Patch 2)

 Dwayne Martin
 James Madison University

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

Re: Configuring JSpell with Mid-Tier 7.0.1 Patch 6

[Craig Carter]

We found the same problem when implementing it for the first time--the spelling 
of the function name was wrong and needed to be changed to "jspellcheck()" as 
you noted.  I'm amazed that hasn't been fixed.

We're on v7.0.1 P5 with ServletExec and we haven't noticed the problem with it 
not using the correct text but we haven't looked for this specific problem.  We 
have noticed it doesn't seem to work properly if you have more than one midtier 
and are trying to call it from the other midtier server.  The form pops up and 
looks correct but the buttons don't function, etc.  As long as it is hosted on 
the same server, it works fine.

We're also looking at a way to make the header code dynamic so we don't have to 
have the URL hard-coded (due to the problem above).  Storing the file on the 
server and including it somehow would be nice.  If anyone has figured out a way 
to dynamically change the header code stored in the Remedy form, please share.

Craig Carter
Software Engineer, RSP

-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of sumeetdas
Sent: Tuesday, April 01, 2008 10:23 PM
To: arslist@ARSLIST.ORG
Subject: Re: Configuring JSpell with Mid-Tier 7.0.1 Patch 6

All,
I finally got this fixed. I am on ARS and MT 7.1

As per the documentation, the function is called spellcheck() but I
scanned thru the jspell.js file and was unable to locate that
function.

It seems that in the future versions OR in the non-IIS versions of the
Java HTML, the function is called jspellcheck().

Another thing which i noticed was that, JSpell worked fine for records
which had been saved. It also works fine for records which have been
modified and not yet saved. But for some reason, once you save the
record, the text field reverts back to the incorrect text field.

e.g. I have text field called Description and has the text "I like". I
modify that recrod [and not Save] and change the text to "I like wrld"
and hit my custom spellcheck button. JSpell is invoked and it corrects
the word "wrld" to "world" in the text area.
However, once I save that record, "I like wrld" is written to the
database.

Has any one of you faced this issues [if its even an issues] ?

Regards,
Sumeet Das

On Apr 1, 11:24 pm, sumeetdas <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I tried all the above steps but i keep on getting the "Caught
> Exception: Object expected"
>
> Using various "alert" functions, I can see that the OurSpellCheck
> function is called and it traverses thru till the spellcheck() is
> called. and that is when I get the Exception error.
>
> any pointers.. or alternative mechanisms to use the spellcheck() would
> be helpful...
>
> On Feb 11, 2:19 pm, Timothy Powell <[EMAIL PROTECTED]>
> wrote:
>
>
>
>
>
> > Here's what we did to get it to work for multiple fields on the same form:
>
> > ARS 6.3 with MT 7.0 Patch 2
>
> > 1) Using at least a 6.3 Admin Tool, on the form where we wanted to check the
> > spelling.
> > Go to the Form/Current View/Properties and the Appearance tab.
> > Add the following to the web header portion:
>
> >  > src="http://servername/jspellhtml2k4/jspell.js";>
> > 
> > 
> > 
>
> > 
>
> > 2) On the web footer we added the following:
>
> > 
>
> > 3) We created a button on our form for each field we wanted to check.
>
> > 4) We added an active link for each field we wanted to check.
> > The AL fires on click of the button created in 3 above.
> > Run If: $CLIENT-TYPE$ = 9
> > If Action: Run Process
> > Command Line: javascript
> > ourSpellCheck('document.yourformname.aridxxx')
>
> > NOTE: xx = the arid of the field you want to check
>
> > 5) In JSpell, on the popup.html form, we added the following line:
> > body onload = window.focus()
>
> > HTH,
>
> > Tim
>
> > From: Action Request System discussion list(ARSList)
> > [mailto:[EMAIL PROTECTED] On Behalf Of Latter, Kris
> > Sent: Monday, February 11, 2008 1:30 PM
> > To: [EMAIL PROTECTED]
> > Subject: Configuring JSpell with Mid-Tier 7.0.1 Patch 6
>
> > **
>
> > Hello,
>
> > I'm having an issue in trying to setup the JSpell program that has been
> > recommended on this list with: (Server, Admin Tool, and Mid-Tier all 7.0.1
> > Patch 6) in order to provide spell-checking on a specific form.
>
> > I am wondering if anyone else has successfully setup this program and
> > implemented it with Mid-Tier.
>
> > Here is what I have done so far:
>
> > -       Placed the jspellhtml2k4.war file into my Tomcat->webapps directory
> > and was able to test the spell checker successfully 
> > withhttp://hostname/jspellhtml2k4/test.html
>
> > -       Loaded the form I wa

BMC Service Desk vs Service Desk Express

[Moore, Christopher Allen]

>From what I see, BMC Service Desk Express is not just a "lite" version
of BMC Service Desk, it's an entirely different product formerly known
as Magic and has nothing to do with Remedy, correct?  So if a third
party tool worked with Service Desk Express, and we have Service Desk,
it will not work?

 

Thanks,

Chris

 

 

 

 

 


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

FW: Unable to connect to discovery server.

[Anu Arora]

I m unable to connect to discovery server. It always gives the error
message that server is not ready to connect retry after few minutes.

 

Error screenshot is attached.



DISCLAIMER:
---

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

---

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

How put the value of a text field into a text file under UNIX?

[Mark Milke]

Hi,

I have a filter. In that filter I have a Run Process. What to I need
to type in here to get the content of $Filed1$ into test.txt My OS is
Linux.

I was experimenting with cat, but I'm failing to get this thing done.
Please help me!


Mark

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

Re: Reporting Time to Resolve

[Brian Goralczyk]

Matt,

I am just taking a random whack at this, but could it be that those records
don't have the date information your looking for and as such, are displaying
the time since January 1st, 1970?

Not sure if that has anything to do with it, but something you might look
into.

Brian

On Tue, Apr 1, 2008 at 1:01 PM, Gayford, Matthew C. <[EMAIL PROTECTED]>
wrote:

> **
>
> List,
>
>
>
> I've been tasked with writing some reports to get the duration of time in
> which tickets were open. We don't have SLM installed, so I decided that I
> would report off of the Incident Assignment Log. Here's the query:
>
>
>
> SELECTIncident_Number, SUM(BusinessHoursDurationSeconds) AS
> TimeOpen
>
> FROMHPD_Help_Desk_Assignment_Log
>
> GROUP BY Incident_Number
>
> ORDER BY TimeOpen DESC
>
>
>
> So everything was going well until I noticed some of the numbers appear
> out of whack. For instance, there are a number of tickets where the
> "business hours duration" field is 334939:53:44 and the "business hours
> duration (sec)" field is 1205783624. Does anyone out there have any good
> ideas on what could be going wrong here?  TIA.
>
>
>
> -Matt
>
>
>
> *M*atthew *C*. *G*ayford
> *T*echnology *R*esearch & *D*evelopment
> *I*nformation *T*echnology *S*ystems *D*ivision
> *U*niversity of *N*orth *C*arolina *W*ilmington
> (910) 962-7177
>
>
> __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"

UNSUBSCRIBE

[Taker, Jason]

 



Notice Regarding Confidentiality
This email, including any and all attachments, (this "Email") is intended only 
for the party to whom it is addressed and may contain information that is 
confidential or privileged.  Sierra Systems Group Inc. and its affiliates 
accept no responsibility for any loss or damage suffered by any person 
resulting from any unauthorized use of or reliance upon this Email.  If you are 
not the intended recipient, you are hereby notified that any dissemination, 
copying or other use of this Email is prohibited.  Please notify us of the 
error in communication by return email and destroy all copies of this Email.  
Thank you.

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

Re: Reporting Time to Resolve

[Gayford, Matthew C.]

Thanks Brian. What you've said appears to make sense, as some of the
records list a total time spent of 330,000+ hours, which comes out to
over 37 years. That would put us in 2007 which would make sense for some
of these tickets. The strange part is that only about 200 or so of the
tickets have these strange dates and the rest are fine.

 

Matt

 

Matthew C. Gayford
Technology Research & Development
Information Technology Systems Division
University of North Carolina Wilmington 
(910) 962-7177

 

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Brian Goralczyk
Sent: Wednesday, April 02, 2008 9:41 AM
To: arslist@ARSLIST.ORG
Subject: Re: Reporting Time to Resolve

 

** 

Matt,

 

I am just taking a random whack at this, but could it be that those
records don't have the date information your looking for and as such,
are displaying the time since January 1st, 1970?

 

Not sure if that has anything to do with it, but something you might
look into.

 

Brian

On Tue, Apr 1, 2008 at 1:01 PM, Gayford, Matthew C. <[EMAIL PROTECTED]>
wrote:

** 

List,

 

I've been tasked with writing some reports to get the duration of time
in which tickets were open. We don't have SLM installed, so I decided
that I would report off of the Incident Assignment Log. Here's the
query:

 

SELECTIncident_Number, SUM(BusinessHoursDurationSeconds) AS
TimeOpen

FROMHPD_Help_Desk_Assignment_Log

GROUP BY Incident_Number

ORDER BY TimeOpen DESC

 

So everything was going well until I noticed some of the numbers appear
out of whack. For instance, there are a number of tickets where the
"business hours duration" field is 334939:53:44 and the "business hours
duration (sec)" field is 1205783624. Does anyone out there have any good
ideas on what could be going wrong here?  TIA.

 

-Matt

 

Matthew C. Gayford
Technology Research & Development
Information Technology Systems Division
University of North Carolina Wilmington 
(910) 962-7177

 

__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: How put the value of a text field into a text file under UNIX?

[Misi Mladoniczky]

Hi,

Try this:
echo "$Field$" >/tmp/test.txt

The problem is if you have any "-characters in your data. You can escape
them with a Set-fields:
Field = REPLACE($Field$, , "'")

There is also a size limit on the "expanded" command containing your data.
I think it is 1024 or 4096 bytes...

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

> Hi,
>
> I have a filter. In that filter I have a Run Process. What to I need
> to type in here to get the content of $Filed1$ into test.txt My OS is
> Linux.
>
> I was experimenting with cat, but I'm failing to get this thing done.
> Please help me!
>
>
> Mark
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
>
> --
> This message was scanned by ESVA and is believed to be clean.
>

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

Re: How put the value of a text field into a text file under UNIX?

[Ron Tavares]

Someone with more UNIX expertise should be able to verify this, but I
believe you just need to use the ">" function, as follows:
Run Process $Filed1$ > test.txt

if you wanted to sepecify a path for the file try this:
Run Process $Filed1$ > /app/remedy/TestLogs/test.txt


On 4/2/08, Mark Milke <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> I have a filter. In that filter I have a Run Process. What to I need
> to type in here to get the content of $Filed1$ into test.txt My OS is
> Linux.
>
> I was experimenting with cat, but I'm failing to get this thing done.
> Please help me!
>
>
> Mark
>
>
> ___
> 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: How put the value of a text field into a text file under UNIX?

[Carey Matthew Black]

Mark,

Please see thread "Output of field contents to file via a filter
action" on ARSList circa "Mar 6, 2008". (And I am sure there are other
versions of the same concept in the archives too.)

-- 
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 Wed, Apr 2, 2008 at 8:35 AM, Mark Milke <[EMAIL PROTECTED]> wrote:
> Hi,
>
>  I have a filter. In that filter I have a Run Process. What to I need
>  to type in here to get the content of $Filed1$ into test.txt My OS is
>  Linux.
>
>  I was experimenting with cat, but I'm failing to get this thing done.
>  Please help me!
>
>
>  Mark

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

Bringing in multiple Views during Prefetch

[Ivan Runions]

The Prefect script in 7.1 makes no comment on multiple Views for a 
form.  Is this because  all views for the form are prefetched... or only 
the default view?


I have ARS Support claiming all views are prefetched, but my experience 
indicates only the default view.  I have no concrete proof other than 
just witnessing the time it takes to open each view after the prefetch 
is finished.


-ivan-

--
Ivan Runions
 Information Technologies
 University of Calgary
 Calgary Alberta Canada
 (403) 220-4437

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

Re: Mysterious gap in log files.

[William Rentfrow]

Nope.  Nothing - I checked that as wellthe longest SQL statement
takes about 0.0176 seconds to complete in the entire log and during this
time there's no activity.
 
There's literally NOTHING going on - at least none of the log files
indicate anything is going on during this time.  There's zero activity.



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Wes Nichols
Sent: Tuesday, April 01, 2008 2:33 PM
To: arslist@ARSLIST.ORG
Subject: Re: Mysterious gap in log files.


** 
I would add in SQL logging.  I bet there is some DB activity that makes
up for this gap.



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of William Rentfrow
Sent: Tuesday, April 01, 2008 2:12 PM
To: arslist@ARSLIST.ORG
Subject: Re: Mysterious gap in log files.


** 
Unfortunately there's nothing in the API log to show - it calls +CE on
HPD:Help Desk to create the entry - the next item in the API log is
after the entry is created.  That's a 39 second stretch during which the
filter items I mentioned are occurring.
 
The snippet below is directly from the filter log - these lines are
consecutive - I just shaved off the beginning parts of the lines in my
original post for readability.
 
The two consecutive entries from the arfilter log are verbatim below:
 
   
  /* Tue Apr 01 2008 11:08:00.5076 */ End of filter processing
(phase 1) -- Operation - CREATE on SYS:Action - 
   
  /* Tue Apr 01 2008 11:08:03.5168 */ End of filter processing
(phase 2) -- Operation - CREATE on SLM:Measurement - 094




From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Axton
Sent: Tuesday, April 01, 2008 1:07 PM
To: arslist@ARSLIST.ORG
Subject: Re: Mysterious gap in log files.


** Post the filter/api log snippets that show the gap with the TID and
RPC ID included.

Axton


On Tue, Apr 1, 2008 at 12:32 PM, William Rentfrow
<[EMAIL PROTECTED]> wrote:


** 
I am trying to tighten up the time it takes to create a new
Incident in IM 7.03 (ARS 7.01, Solaris, remote oracle DB).
 
I've checked the threads/queues quite thoroughly and they
appears to be fine - there's plenty of available time queue time.
However, in the filter log there are multiple places where this happens:
 

Tue Apr 01 2008 11:08:03.6332 */ End of filter processing
(phase 1) -- Operation - CREATE on SYS:Action - 
Tue Apr 01 2008 11:08:06.6404 */ End of filter processing
(phase 2) -- Operation - CREATE on SLM:Measurement - 095

Notice the three second gap between those two - there is NOTHING
else going on anywhere else in the SQL or API logs to indicate some
processing - it's just three seconds of the nothing in all of the logs.
Every time there's a "end of filter processing' phase message we just
stop for 3 seconds.
 
In my 39-second Incident creation time there are a total of 10
of these gaps - 30 seconds where absolutely nothing appears to be
happening.
 
Keep in mind this is a large solaris server and I'm the only one
on it - there's no lack of server resources.  We've got plenty of
hamsters/wheels/etc to power this thing.
 
William Rentfrow, Principal Consultant
[EMAIL PROTECTED]
C 701-306-6157
O 952-432-0227
 
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the
Answers Are" html___ 


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



**
This email and any files transmitted with it are confidential and
intended solely for the individual or entity to whom they are addressed.
If you have received this email in error destroy it immediately.
**
Wal-Mart Confidential
** 

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

Run Process Help

[versicle]

Hi All,

So I'm trying to run the command: 

copy C:\sample1.txt \\ACNCNU6250FVX\CABMACH4

via cmd.exe The syntax I have for the Run Process is:

%windir%\system32\cmd.exe /c copy "C:\sample1.txt \\ACNCNU6250FVX\CABMACH4"

The only thing that is happening is a cmd window opens and then closes. Is
my syntax correct? If not any ideas on where I went wrong?

Thanks,

Mike
-- 
View this message in context: 
http://www.nabble.com/Run-Process-Help-tp16447087p16447087.html
Sent from the ARS (Action Request System) mailing list archive at Nabble.com.

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

Job: Remedy Developer - 6 Month CTH or Perm - Baltimore, MD

[Kitchen, Joshua T]

Dear List,
 
Hope all is well, I am looking for a Mid level Remedy Developer.
 
Location:   Baltimore, MD 
 
Duration:   6 Month Contract to Hire or Permanent 
 
About Client:  Our International client specializes in global management
and technology consulting. Our client is known for their deep industry
experience and high customer satisfaction. They collaborate with clients
in government and industry in 60 countries to solve their most pressing
challenges from strategy through execution. 

Skillset: REMEDY v7.x with  Help Desk, Asset, Change, CMDB, Migrator 

Detailed Job Description: 

 Mid level Remedy Developer wanted to build custom interface
with Purchase Order system; make enhancements/modifications to Remedy
6.0 modules to support automation of receiving process and configuration
item creation for software and hardware. 

Familiarity with Remedy 7.0. 

Candidate must be expertly proficient with Remedy's AR System
tools and development methodology. 

Experience with Remedy Help Desk, Asset Management, Change
Management, CMDB and Migrator. 

MS SQL 2000 platform   

If you are interested please send me a word document version of your
resume and salary requirements.
 
Respectfully,

Joshua Kitchen
Information Technology Recruiter
Kforce Professional Staffing 
Two Prestige Place (Suite 350)
937.449.1749 Office  
937.461.6888 Fax 
937.416.3456 Cell
Great People = Great Results
   
Please don't keep me a secret... a referral is the best compliment I can
receive. 

 

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

Rif: Run Process Help

[Luisa Carena]

Ciao Mike,


you have to create a .cmd file that execute a copy command and the Run
Process executes the .cmd (if you need you can pass parametres fron run
Process to  .cmd file)

ciao



Luisa Carena
Gestione Postazioni Periferiche cpt Novara
SGS BP
Gruppo Banco Popolare di Verona e Novara
via Negroni 12 - 28100 Novara
Tel: 0321-663995
Email: [EMAIL PROTECTED]
versicle <[EMAIL PROTECTED]> - 02/04/2008 16.27
Inviato da: "Action Request System discussion list(ARSList)"

Per favore, rispondere a
arslist@ARSLIST.ORG
Per:arslist@ARSLIST.ORG
CC:
Oggetto:Run Process Help


Hi All,

So I'm trying to run the command:

copy C:\sample1.txt \\ACNCNU6250FVX\CABMACH4

via cmd.exe The syntax I have for the Run Process is:

%windir%\system32\cmd.exe /c copy "C:\sample1.txt \\ACNCNU6250FVX\CABMACH4"

The only thing that is happening is a cmd window opens and then closes. Is
my syntax correct? If not any ideas on where I went wrong?

Thanks,

Mike
--
View this message in context:
http://www.nabble.com/Run-Process-Help-tp16447087p16447087.html
Sent from the ARS (Action Request System) mailing list archive at
Nabble.com.

___

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



La presente comunicazione e' destinata esclusivamente al soggetto indicato piu' 
sopra quale destinatario o ad eventuali altri soggetti autorizzati a riceverla. 
Essa contiene informazioni strettamente confidenziali e riservate, la cui 
comunicazione o diffusione a terzi e' proibita, salvo che non sia stata 
espressamente autorizzata.
Se avete ricevuto questa comunicazione per errore, Vi preghiamo di darne 
immediata comunicazione al mittente e di cancellarne ogni evidenza dai Vostri 
supporti.

 

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

Re: 5.1.2 download

[Joe D'Souza]

If you have an ftp server I can upload it up there..

Joe
  -Original Message-
  From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of Satya Gandhi
  Sent: Wednesday, April 02, 2008 5:48 AM
  To: arslist@ARSLIST.ORG
  Subject: 5.1.2 download


  **
  Dear Listers,

  Where can i download 5.1.2 server and other components? I checked on the
product availability and cant find any reference for 512

  --
  Thanks & Regards

  Satya Gandhi

  Consultant - Remedy
No virus found in this outgoing message.
Checked by AVG.
Version: 7.5.519 / Virus Database: 269.22.4/1355 - Release Date: 4/1/2008
5:37 PM

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

Re: Mysterious gap in log files

[William Rentfrow]

Disregard my last update.
 
This speed problem is caused by Oracle update to the LOBs.  
 
In short, I'll be moving them in-row and we'll see what happens.



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Wes Nichols
Sent: Tuesday, April 01, 2008 2:33 PM
To: arslist@ARSLIST.ORG
Subject: Re: Mysterious gap in log files.


** 
I would add in SQL logging.  I bet there is some DB activity that makes
up for this gap.



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of William Rentfrow
Sent: Tuesday, April 01, 2008 2:12 PM
To: arslist@ARSLIST.ORG
Subject: Re: Mysterious gap in log files.


** 
Unfortunately there's nothing in the API log to show - it calls +CE on
HPD:Help Desk to create the entry - the next item in the API log is
after the entry is created.  That's a 39 second stretch during which the
filter items I mentioned are occurring.
 
The snippet below is directly from the filter log - these lines are
consecutive - I just shaved off the beginning parts of the lines in my
original post for readability.
 
The two consecutive entries from the arfilter log are verbatim below:
 
   
  /* Tue Apr 01 2008 11:08:00.5076 */ End of filter processing
(phase 1) -- Operation - CREATE on SYS:Action - 
   
  /* Tue Apr 01 2008 11:08:03.5168 */ End of filter processing
(phase 2) -- Operation - CREATE on SLM:Measurement - 094




From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Axton
Sent: Tuesday, April 01, 2008 1:07 PM
To: arslist@ARSLIST.ORG
Subject: Re: Mysterious gap in log files.


** Post the filter/api log snippets that show the gap with the TID and
RPC ID included.

Axton


On Tue, Apr 1, 2008 at 12:32 PM, William Rentfrow
<[EMAIL PROTECTED]> wrote:


** 
I am trying to tighten up the time it takes to create a new
Incident in IM 7.03 (ARS 7.01, Solaris, remote oracle DB).
 
I've checked the threads/queues quite thoroughly and they
appears to be fine - there's plenty of available time queue time.
However, in the filter log there are multiple places where this happens:
 

Tue Apr 01 2008 11:08:03.6332 */ End of filter processing
(phase 1) -- Operation - CREATE on SYS:Action - 
Tue Apr 01 2008 11:08:06.6404 */ End of filter processing
(phase 2) -- Operation - CREATE on SLM:Measurement - 095

Notice the three second gap between those two - there is NOTHING
else going on anywhere else in the SQL or API logs to indicate some
processing - it's just three seconds of the nothing in all of the logs.
Every time there's a "end of filter processing' phase message we just
stop for 3 seconds.
 
In my 39-second Incident creation time there are a total of 10
of these gaps - 30 seconds where absolutely nothing appears to be
happening.
 
Keep in mind this is a large solaris server and I'm the only one
on it - there's no lack of server resources.  We've got plenty of
hamsters/wheels/etc to power this thing.
 
William Rentfrow, Principal Consultant
[EMAIL PROTECTED]
C 701-306-6157
O 952-432-0227
 
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the
Answers Are" html___ 


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



**
This email and any files transmitted with it are confidential and
intended solely for the individual or entity to whom they are addressed.
If you have received this email in error destroy it immediately.
**
Wal-Mart Confidential
** 

__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: Help with Change Management

[Katherine Hoffner]

I checked the list and it is empty.  I saw this before but I cannot add
names to it.  I am guessing my approvers should be inthis list huh.

On 4/1/08, Model, Igor [ITSUS Non J&J] <[EMAIL PROTECTED]> wrote:
>
> **
>
> Katherine
>
>
>
> Check the Member List field of the AP:Roles form if the manager's id was
> also deleted from that list.
>
>
>
> Igor
>
>
>
> *From:* Action Request System discussion list(ARSList) [mailto:
> [EMAIL PROTECTED] *On Behalf Of *Katherine Hoffner
> *Sent:* Monday, March 31, 2008 2:59 PM
> *To:* arslist@ARSLIST.ORG
> *Subject:* Re: Help with Change Management
>
>
>
> ** I am not really well versed with this product.  Of Course huh.  Someone
> who doesnt know anything.
>
> On 3/31/08, *T. Dee* <[EMAIL PROTECTED]> wrote:
>
> Have you checked the Approval Process Configuration and Approval Mappings.
>
> Ty
>
>
> On 3/31/08, Katherine Hoffner <[EMAIL PROTECTED]> wrote:
> > ** This is with all the NEW changes.
> >
> >
> > On 3/31/08, T. Dee <[EMAIL PROTECTED]> wrote:
> > >
> > > Is this with "current" Changes or NEW Changes?
> > >
> > > Ty
> > >
> > >
> > > On 3/31/08, Katherine Hoffner <[EMAIL PROTECTED]> wrote:
> > > > **
> > > > Hi all,
> > > >
> > > > I have a problem with my change requests.  One of our managers left
> and
> > his
> > > > name was deleted from the system.  I am not sure if this had
> anything to
> > do
> > > > with the issue but it did happen after his removal.  Anyway we have
> a
> > new
> > > > manager and I added her to the all Approvals list.  Our CTI'S are
> set up
> > as
> > > > ALL.  We do not have individual approval for different CTI's
> everything
> > is
> > > > approved by 4 people.  Anyway I cannot get the approvers up to the
> > current
> > > > signatures line under the Approvals tab on the change request so
> none of
> > my
> > > > approvers can actually sign off the change request.  All of my
> change
> > > > requests are staying in the pending approval state.
> > > >
> > > > Running ARS 6.3
> > > >
> > > >
> > > > --
> > > > Katherine __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"
> > >
> >
> >
> >
> > --
> > Katherine __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"
>
>
>
>
> --
> Katherine __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the
> Answers Are" html___
> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
> html___
>



-- 
Katherine

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

Re: BMC Service Desk vs Service Desk Express

[Rick Cook]

I would say that it will not work in the same way.  AR System, upon which
Service Desk is built, is a very flexible engine to integrate with.  I would
bet that whatever third-party tool you're talking about could be integrated
with AR System, and therefore with Service Desk, with a small to moderate
level of effort.

Rick

On Wed, Apr 2, 2008 at 5:55 AM, Moore, Christopher Allen <
[EMAIL PROTECTED]> wrote:

> **
>
> From what I see, BMC Service Desk Express is not just a "lite" version of
> BMC Service Desk, it's an entirely different product formerly known as Magic
> and has nothing to do with Remedy, correct?  So if a third party tool worked
> with Service Desk Express, and we have Service Desk, it will not work?
>
>
>
> Thanks,
>
> Chris
>
>  __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: Run Process Help

[Grooms, Frederick W]

I think you need to separate the parameter values to the copy command   
  %windir%\system32\cmd.exe /c copy "C:\sample1.txt"
"\\ACNCNU6250FVX\CABMACH4"

I think the Copy command is only seeing 1 parameter an so does not know
what to do

Fred

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of versicle
Sent: Wednesday, April 02, 2008 9:28 AM
To: arslist@ARSLIST.ORG
Subject: Run Process Help

Hi All,

So I'm trying to run the command: 

copy C:\sample1.txt \\ACNCNU6250FVX\CABMACH4

via cmd.exe The syntax I have for the Run Process is:

%windir%\system32\cmd.exe /c copy "C:\sample1.txt
\\ACNCNU6250FVX\CABMACH4"

The only thing that is happening is a cmd window opens and then closes.
Is my syntax correct? If not any ideas on where I went wrong?

Thanks,

Mike

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

Resolved: Definitive Software Library - Unresolved: SLM Notifications

[strauss]

It has only taken BMC support six weeks to answer this one (further
evidence that they cannot document their own software worth a flip), and
it turns out that patch 005 to the DSL was never intended to be used on
the DSL installed with ITSM, only the "standalone" version (which I had
never seen mentioned or documented before).  So the "workaround" they
gave me a month ago, where you hack the records in
Share:Application_Properties to allow the installer to run, should never
have been offered or performed; no wonder it left the DSL console
completely unusable on my dev server.  The same is true of patch 006 to
DSL, except that it gives you a much more specific and intelligent error
message when you try to run it.

So today, DSL installed with ITSM has a maximum patch level of 1516, and
only the _data_ should be at patch 005 (the data version in patch 005 is
110.7.0.1).

Beware of BMC employees bearing "workarounds" - chances are they are
really just clueless, and grasping at straws (not true for all; there
are a few I know I can trust).

Footnote: That is why I am holding out for a formal technical bulletin
or approved knowledge base article on their proposed workaround for SLM
notifications.  They want me to hack the HPD:Help Desk form to lookup
and store the long group name from the Groups form (for my group that
looks like this: UNT CITC Academic Computing and User Services->CITC
ACS-US Call Tracking->Call Tracking Administration) that corresponds to
the Assigned Group - Support Group Name and ID (SGP000#) because
their integration between SLM 7.1 and Incident Management cannot search
assigned support groups in CTM:Support Group for members, and so no
escalations are being sent at all to support group members or managers
(the entire purpose of the SLM application, from my point of view).  If
that is what they have to do to get SLM to work with IM, it _should_
have been in the integration, and if it wasn't, it _should_ have been
documented and already be in a patch, but none of that has been done.  I
am having to force them to document it, by refusing to let them just
toss me a barely coherent workaround, file a defect, and blithely close
the issue.  Shoddy, and unprofessional.

Christopher Strauss, Ph.D.
Call Tracking Administration Manager
University of North Texas Computing & IT Center
http://itsm.unt.edu/ 

> -Original Message-
> From: Action Request System discussion list(ARSList) 
> [mailto:[EMAIL PROTECTED] On Behalf Of strauss
> Sent: Monday, February 18, 2008 8:44 PM
> To: arslist@ARSLIST.ORG
> Subject: Definitive Software Library
> 
> I am obviously missing something here.
> 
> DSL 1.0.00 is installed with ITSM 7.0.02, specifically Change 
> Management I believe.  It's console appears on my Home Page 
> as an admin.
> The Patch 1516 installer runs fine against it.  On production 
> I have not loaded updated data, or imported any data yet 
> since we had been debating whether or not to do so.  Now I 
> want to load data, but need to patch it first.  Development 
> is an older system, upgraded to ARS 7.1.00.01 and CMDB 
> 2.1.00, on which DSL data has been loaded and updated several times.
> 
> In Share:Application_Properties it shows version 1.0.00 Patch 
> 1516 on both servers.
> 
> The documentation for DLS 7.0 Patch 005 and DSL 7.1.01 
> mirrors this, that it should have installed with the ITSM 7.0 
> installation of Change Management.  It says to apply Patch 
> 005 to the DSL.
> 
> When I run Patch 005 for DSL on my development or production (ARS
> 7.1.00.001 / CMDB 2.1.00.001 / ITSM 7.0.02.007) servers, it 
> fails after reporting that the three ITSM apps are installed 
> (IM, PM, CM, all
> 7.0.03.007) with the error:
> 
> Pre-requisites not met
> BMC Remedy Definitive Software Library Version 7.00.00 or 
> higher is required.
> 
> At what point in loading the latest version of every piece of 
> BMC code I could scavenge off support web did I NOT get it to 
> the point where it
> thinks it has DSL 7.0.x??   Or is this one of those 
> installers than
> only works against an older code base, which means that I 
> would have had to install it back in December before ITSM 
> Patch 006 or CMDB 2.1.00.001 (January)??  Anyone have any 
> experience with this one??
> 
> Christopher Strauss, Ph.D.
> Call Tracking Administration Manager
> University of North Texas Computing & IT Center http://itsm.unt.edu/ 
> 
> __
> _
> 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"

Incoming emails building up and crashing email engine.

[npeterson]

I am running ARS 7, and have it set up to receive incoming emails. What has
been going on is that when I look in the AR System Email Message I can see
that the incoming emails are building up, but never removing themselves.
After a large amount has built up the incoming email system quits accepting
these messages and incidents are no longer created off of the incoming
emails. If I delete what is in there and then restart the email service, all
pending emails are received and all incident are created. If I daily open up
AR System Email Messages and delete all incoming messages there is no
problem. When or Remedy consultants were out here I think I saw them work on
a form that should purge these incoming emails on a defined schedule,
however I cannot find that form. Can anyone comment on my issue, and help me
find that form name?

Thanks

np

-- 
View this message in context: 
http://www.nabble.com/Incoming-emails-building-up-and-crashing-email-engine.-tp16447310p16447310.html
Sent from the ARS (Action Request System) mailing list archive at Nabble.com.

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

Re: Incoming emails building up and crashing email engine.

[Brittain, Mark]

I only retain incoming & error email for three days by running an
Archive Delete from Source on the Email Messages form. That should do it
for you. I run this once a day. If I remember correctly you have to
space the archives at least an hour apart.

I am on ARS 6.3 but I would think this should be the same.

Good Luck
Mark

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of npeterson
Sent: Wednesday, April 02, 2008 11:31 AM
To: arslist@ARSLIST.ORG
Subject: Incoming emails building up and crashing email engine.

I am running ARS 7, and have it set up to receive incoming emails. What
has
been going on is that when I look in the AR System Email Message I can
see
that the incoming emails are building up, but never removing themselves.
After a large amount has built up the incoming email system quits
accepting
these messages and incidents are no longer created off of the incoming
emails. If I delete what is in there and then restart the email service,
all
pending emails are received and all incident are created. If I daily
open up
AR System Email Messages and delete all incoming messages there is no
problem. When or Remedy consultants were out here I think I saw them
work on
a form that should purge these incoming emails on a defined schedule,
however I cannot find that form. Can anyone comment on my issue, and
help me
find that form name?

Thanks

np

-- 
View this message in context:
http://www.nabble.com/Incoming-emails-building-up-and-crashing-email-eng
ine.-tp16447310p16447310.html
Sent from the ARS (Action Request System) mailing list archive at
Nabble.com.


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.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.

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

Re: Reporting Time to Resolve

[Brian Goralczyk]

Well that part I can't help with.  It was just that looking at those numbers
I figured that it seemed to go back to about then.  Glad it gives you a
starting point.

On Wed, Apr 2, 2008 at 8:52 AM, Gayford, Matthew C. <[EMAIL PROTECTED]>
wrote:

> **
>
> Thanks Brian. What you've said appears to make sense, as some of the
> records list a total time spent of 330,000+ hours, which comes out to over
> 37 years. That would put us in 2007 which would make sense for some of these
> tickets. The strange part is that only about 200 or so of the tickets have
> these strange dates and the rest are fine.
>
>
>
> Matt
>
>
>
> *M*atthew *C*. *G*ayford
> *T*echnology *R*esearch & *D*evelopment
> *I*nformation *T*echnology *S*ystems *D*ivision
> *U*niversity of *N*orth *C*arolina *W*ilmington
> (910) 962-7177
>
>
>
> *From:* Action Request System discussion list(ARSList) [mailto:
> [EMAIL PROTECTED] *On Behalf Of *Brian Goralczyk
> *Sent:* Wednesday, April 02, 2008 9:41 AM
> *To:* arslist@ARSLIST.ORG
> *Subject:* Re: Reporting Time to Resolve
>
>
>
> **
>
> Matt,
>
>
>
> I am just taking a random whack at this, but could it be that those
> records don't have the date information your looking for and as such, are
> displaying the time since January 1st, 1970?
>
>
>
> Not sure if that has anything to do with it, but something you might look
> into.
>
>
>
> Brian
>
> On Tue, Apr 1, 2008 at 1:01 PM, Gayford, Matthew C. <[EMAIL PROTECTED]>
> wrote:
>
> **
>
> List,
>
>
>
> I've been tasked with writing some reports to get the duration of time in
> which tickets were open. We don't have SLM installed, so I decided that I
> would report off of the Incident Assignment Log. Here's the query:
>
>
>
> SELECTIncident_Number, SUM(BusinessHoursDurationSeconds) AS
> TimeOpen
>
> FROMHPD_Help_Desk_Assignment_Log
>
> GROUP BY Incident_Number
>
> ORDER BY TimeOpen DESC
>
>
>
> So everything was going well until I noticed some of the numbers appear
> out of whack. For instance, there are a number of tickets where the
> "business hours duration" field is 334939:53:44 and the "business hours
> duration (sec)" field is 1205783624. Does anyone out there have any good
> ideas on what could be going wrong here?  TIA.
>
>
>
> -Matt
>
>
>
> *M*atthew *C*. *G*ayford
> *T*echnology *R*esearch & *D*evelopment
> *I*nformation *T*echnology *S*ystems *D*ivision
> *U*niversity of *N*orth *C*arolina *W*ilmington
> (910) 962-7177
>
>
>
> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
> html___
>
>
> __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: Mysterious gap in log files.

[Brian Goralczyk]

What about network delays?  Are you moving a large amount of data over the
network and that is causing the delay?  Just an idea.

On Wed, Apr 2, 2008 at 9:12 AM, William Rentfrow <[EMAIL PROTECTED]>
wrote:

> ** Nope.  Nothing - I checked that as wellthe longest SQL statement
> takes about 0.0176 seconds to complete in the entire log and during this
> time there's no activity.
>
> There's literally NOTHING going on - at least none of the log files
> indicate anything is going on during this time.  There's zero activity.
>
>  --
> *From:* Action Request System discussion list(ARSList) [mailto:
> [EMAIL PROTECTED] *On Behalf Of *Wes Nichols
> *Sent:* Tuesday, April 01, 2008 2:33 PM
>
> *To:* arslist@ARSLIST.ORG
> *Subject:* Re: Mysterious gap in log files.
>
>   ** I would add in SQL logging.  I bet there is some DB activity that
> makes up for this gap.
>
>  --
> *From:* Action Request System discussion list(ARSList) [mailto:
> [EMAIL PROTECTED] *On Behalf Of *William Rentfrow
> *Sent:* Tuesday, April 01, 2008 2:12 PM
> *To:* arslist@ARSLIST.ORG
> *Subject:* Re: Mysterious gap in log files.
>
> ** Unfortunately there's nothing in the API log to show - it calls +CE on
> HPD:Help Desk to create the entry - the next item in the API log is after
> the entry is created.  That's a 39 second stretch during which the filter
> items I mentioned are occurring.
>
> The snippet below is directly from the filter log - these lines are
> consecutive - I just shaved off the beginning parts of the lines in my
> original post for readability.
>
> The two consecutive entries from the arfilter log are verbatim below:
>
>
>   > /* Tue Apr 01 2008 11:08:00.5076 */ End of filter processing (phase 1)
> -- Operation - CREATE on SYS:Action - 
>
>   > /* Tue Apr 01 2008 11:08:03.5168 */ End of filter processing (phase 2)
> -- Operation - CREATE on SLM:Measurement - 094
>
>  --
> *From:* Action Request System discussion list(ARSList) [mailto:
> [EMAIL PROTECTED] *On Behalf Of *Axton
> *Sent:* Tuesday, April 01, 2008 1:07 PM
> *To:* arslist@ARSLIST.ORG
> *Subject:* Re: Mysterious gap in log files.
>
> ** Post the filter/api log snippets that show the gap with the TID and RPC
> ID included.
>
> Axton
>
> On Tue, Apr 1, 2008 at 12:32 PM, William Rentfrow <
> [EMAIL PROTECTED]> wrote:
>
> > ** I am trying to tighten up the time it takes to create a new Incident
> > in IM 7.03 (ARS 7.01, Solaris, remote oracle DB).
> >
> > I've checked the threads/queues quite thoroughly and they appears to be
> > fine - there's plenty of available time queue time.  However, in the filter
> > log there are multiple places where this happens:
> >
> >  Tue Apr 01 2008 11:08:03.6332 */ End of filter processing (phase 1)
> > -- Operation - CREATE on SYS:Action - 
> > Tue Apr 01 2008 11:08:06.6404 */ End of filter processing (phase 2)
> > -- Operation - CREATE on SLM:Measurement - 095
> > Notice the three second gap between those two - there is NOTHING else
> > going on anywhere else in the SQL or API logs to indicate some processing -
> > it's just three seconds of the nothing in all of the logs.  Every time
> > there's a "end of filter processing' phase message we just stop for 3
> > seconds.
> >
> > In my 39-second Incident creation time there are a total of 10 of these
> > gaps - 30 seconds where absolutely nothing appears to be happening.
> >
> > Keep in mind this is a large solaris server and I'm the only one on it -
> > there's no lack of server resources.  We've got plenty of
> > hamsters/wheels/etc to power this thing.
> >
> > William Rentfrow, Principal Consultant
> > [EMAIL PROTECTED]
> > C 701-306-6157
> > O 952-432-0227
> >
> > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
> > html___
>
>
> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
> html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers
> Are" html___
>
> --
>
> ***
> This email and any files transmitted with it are confidential and intended
> solely for the individual or entity to whom they are addressed. If you have
> received this email in error destroy it immediately.
> **
> Wal-Mart Confidential
> ** *
> __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: Mysterious gap in log files.

[Misi Mladoniczky]

Hi!

Please provide us with the surrounding log lines with the full API-call
with all FLTR and SQL lines that belongs to that call.

The server performs various internal stuff at times, such as refreshing
the ar.cfg-file and throwing out inactive users. These type of thing may
show as SQL-rows if SQL is involved. Some of these things does not have an
RPC ID attached to them.

I would be surprised if this happens in the middle of your call. It should
be at the beginning or end of the API...

Did you have other users that performed things at the same time? It could
affect the responsiveness of the database. One such thing could be the
locking of the arschema table.

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

> Nope.  Nothing - I checked that as wellthe longest SQL statement
> takes about 0.0176 seconds to complete in the entire log and during this
> time there's no activity.
>
> There's literally NOTHING going on - at least none of the log files
> indicate anything is going on during this time.  There's zero activity.
>
> 
>
> From: Action Request System discussion list(ARSList)
> [mailto:[EMAIL PROTECTED] On Behalf Of Wes Nichols
> Sent: Tuesday, April 01, 2008 2:33 PM
> To: arslist@ARSLIST.ORG
> Subject: Re: Mysterious gap in log files.
>
>
> **
> I would add in SQL logging.  I bet there is some DB activity that makes
> up for this gap.
>
> 
>
> From: Action Request System discussion list(ARSList)
> [mailto:[EMAIL PROTECTED] On Behalf Of William Rentfrow
> Sent: Tuesday, April 01, 2008 2:12 PM
> To: arslist@ARSLIST.ORG
> Subject: Re: Mysterious gap in log files.
>
>
> **
> Unfortunately there's nothing in the API log to show - it calls +CE on
> HPD:Help Desk to create the entry - the next item in the API log is
> after the entry is created.  That's a 39 second stretch during which the
> filter items I mentioned are occurring.
>
> The snippet below is directly from the filter log - these lines are
> consecutive - I just shaved off the beginning parts of the lines in my
> original post for readability.
>
> The two consecutive entries from the arfilter log are verbatim below:
>
>
>  > /* Tue Apr 01 2008 11:08:00.5076 */ End of filter processing
> (phase 1) -- Operation - CREATE on SYS:Action - 
>
>  > /* Tue Apr 01 2008 11:08:03.5168 */ End of filter processing
> (phase 2) -- Operation - CREATE on SLM:Measurement - 094
>
>
> 
>
> From: Action Request System discussion list(ARSList)
> [mailto:[EMAIL PROTECTED] On Behalf Of Axton
> Sent: Tuesday, April 01, 2008 1:07 PM
> To: arslist@ARSLIST.ORG
> Subject: Re: Mysterious gap in log files.
>
>
> ** Post the filter/api log snippets that show the gap with the TID and
> RPC ID included.
>
> Axton
>
>
> On Tue, Apr 1, 2008 at 12:32 PM, William Rentfrow
> <[EMAIL PROTECTED]> wrote:
>
>
>   **
>   I am trying to tighten up the time it takes to create a new
> Incident in IM 7.03 (ARS 7.01, Solaris, remote oracle DB).
>
>   I've checked the threads/queues quite thoroughly and they
> appears to be fine - there's plenty of available time queue time.
> However, in the filter log there are multiple places where this happens:
>
>
>   Tue Apr 01 2008 11:08:03.6332 */ End of filter processing
> (phase 1) -- Operation - CREATE on SYS:Action - 
>   Tue Apr 01 2008 11:08:06.6404 */ End of filter processing
> (phase 2) -- Operation - CREATE on SLM:Measurement - 095
>
>   Notice the three second gap between those two - there is NOTHING
> else going on anywhere else in the SQL or API logs to indicate some
> processing - it's just three seconds of the nothing in all of the logs.
> Every time there's a "end of filter processing' phase message we just
> stop for 3 seconds.
>
>   In my 39-second Incident creation time there are a total of 10
> of these gaps - 30 seconds where absolutely nothing appears to be
> happening.
>
>   Keep in mind this is a large solaris server and I'm the only one
> on it - there's no lack of server resources.  We've got plenty of
> hamsters/wheels/etc to power this thing.
>
>   William Rentfrow, Principal Consultant
>   [EMAIL PROTECTED]
>   C 701-306-6157
>   O 952-432-0227
>
>   __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the
> Answers Are" html___
>
>
> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
> html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the
> Answers Are" html___
>
> 
>
> **
> This email and any files transmitted with it are confidential and
> intended solely for the individual or entity to whom they are addressed.
> If you have received this email in error destroy it immediately.
> **
> Wal-Mart Confidential
> 

Outgoing Emails Accumulation

[Jay parker]

Hello List

 

We have upgraded to 7.0.1 Patch 6 and since that time our outgoing email
cannot keep up with demand. As best we can tell each polling cycle sends
out 90- 100 emails, incoming emails are running perfectly. We have 6
outgoing mail boxes polling every 5 minutes. 

 

OS: AIX 5,3 Patch 6

ARS: 7.0.1 Patch 6

Emails Engine: 7.0.1. Patch 6

Java: 1.4.2

 

Jay P

 


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

Requester Console customization

[Muhlethaler, Laurie]

Listers ~ checking to see if anyone has customized the RQC to allow end users 
to submit issues on behalf of others.  If so, any suggestions?


Database:  SQL Server 2005
O/S:  Windows 2003 (server), R2XP Professional (client), SP2
Apps:  
Action Request System 7.1 patch 1
Service Desk 7.0.3 patch 6


Laurie Muhlethaler
Remedy Developer / Administrator
First Republic Bank
415.364.4436


 
The information transmitted is intended only for the person or entity to which 
it is addressed and may contain confidential and/or privileged material. Any 
review, retransmission, dissemination or other use of, or taking of any action 
in reliance upon, this information by persons or entities other than the 
intended recipient is prohibited. If you received this in error, please contact 
the sender and delete the material from any computer. This message cannot be 
guaranteed to be secure or error-free.
 
First Republic Bank and its subsidiaries do not take responsibility for, or 
accept time-sensitive instructions sent by email including orders, funds 
transfer instructions or stop payments on checks. All instructions of this 
nature must be handled by direct communication, not email.
 
We reserve the right to monitor and review the content of all email 
communications sent or received. Emails sent to or from this address may be 
stored in accordance with regulatory requirements.
 
First Republic Bank is a Division of Merrill Lynch Bank & Trust Co., FSB

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

Stopping a runaway archive

[Brittain, Mark]

Hi All,

 

Is there a way to stop a runaway archive? I am getting to turn on
archiving for the company's main form using Archive and Delete from
Source. I have tested this in development to make sure my qualification
is correct. Just to see if it was possible, while the archive test was
running I went into the form and disabled archiving. The archiving did
not stop until the criteria was no longer met.

 

Hope the answer is not to shutdown the server.

 

Thanks

Mark


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.

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

Re: Run Process Help

[Subash Biswas]

You can also use
cmd /c copy /-Y "c:\text.txt" "c:\text2.txt"

the cmd.exe should be already in the default path setting; so you can
use cmd directly; the (/-Y) switch adds a prompt to the copy function.
If ignored the copy function will overwrite the existing file or
create a new one with the name text2.txt

-Subash

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

Job: Woodland Hills, CA - Permanent - Remedy Administrator

[Kitchen, Joshua T]

Dear List,
 
Looking for a Remedy Administrator with 3-5 years experience working
with Version 6.x or 7.x.
 
Location:  Woodland Hills, CA 
 
Duration:  Direct-Hire / Permanent 
 
Salary:   65K-80K

Industry:  Insurance
 
About Client:  2.7 Billion dollar company provides Workers' Compensation
insurance.
 
Description:  Administration and development in a high availability
environment.  Develop workflows, active links, customizations,
escalations in version 6.x or 7.x. 
* Administer permissions, security, access, logins, passwords in
Remedy 

* Administer and develop forms, fields, menus and workflows in
Remedy 

* Build AR System filters and active links in order to automate
responses to user actions and enforce business rules

* Create Remedy training documentation in PowerPoint and Word
for Webinars with employees

* Troubleshoot complex issues regarding forms, workflows, and
log files in  Remedy 

 

Skills: BMC REMEDY (v7.x preferred, v6.x acceptable) products including
but not limited to Configuration Management DB (CMDB), IT Service
Management (ITSM) Suite including Analytics, Change Management,
Flashboards, Migrator, Service Desk, AR System, Service Level Management
(SLM), and Service Request Management.  Excellent verbal and written
communication skills; ability to understand and articulate ideas and
concepts in both verbal and written form. Process and Detail Oriented.
Experience with Oracle RDBMS, SQL.  
 
If you are interested please reply to [EMAIL PROTECTED]
  with salary requirements and a word
document version of your resume.
 
Respectfully,
 

Joshua Kitchen
Information Technology Recruiter
Kforce Professional Staffing 
Two Prestige Place (Suite 350)
937.449.1749 Office  
937.461.6888 Fax 
937.416.3456 Cell
Great People = Great Results
   
Please don't keep me a secret... a referral is the best compliment I can
receive. 

 

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

Re: Requester Console customization

[Gidd]

Hi Laurie !!
 
We have created a totally new approach to a requester console in our
Xtreme Console:
 
Here is the link to our Xtreme Console/Dashboard integration.
 
 
Xtreme Console
http://www.BuoyantSolutions.net/Xtreme
http://www.buoyantsolutions.net/Xtreme> 
 
 
Login: Mary McDonald
 
PW: us05gtst802unp
 
 
Xtreme Dashboard - Same login/pw
http://www.buoyantsolutions.net/xtreme/dashboard/
http://www.buoyantsolutions.net/xtreme/dashboard/> 
 
 
BTW: This is running outside of the Mid-tier (Don't need MT) and we are
using XML-Gateway to
get/push data.  This runs on any browser including a MAC and performance is
awesome, as you
can see !!
 
Hope ya like it.
 
Regards...Gidd

  _  

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Muhlethaler, Laurie
Sent: Wednesday, April 02, 2008 9:01 AM
To: arslist@ARSLIST.ORG
Subject: Requester Console customization


** 

Listers ~ checking to see if anyone has customized the RQC to allow end
users to submit issues on behalf of others.  If so, any suggestions?


Database:  SQL Server 2005 
O/S:  Windows 2003 (server), R2XP Professional (client), SP2 
Apps:  


Action Request System 7.1 patch 1 
Service Desk 7.0.3 patch 6 


Laurie Muhlethaler

Remedy Developer / Administrator

First Republic Bank

415.364.4436

 
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you received
this in error, please contact the sender and delete the material from any
computer.  This message cannot be guaranteed to be secure or error-free.
 
First Republic Bank and its subsidiaries do not take responsibility for, or
accept time-sensitive instructions sent by email including orders, funds
transfer instructions or stop payments on checks. All instructions of this
nature must be handled by direct communication, not email.
 
We reserve the right to monitor and review the content of all email
communications sent or received. Emails sent to or from this address may be
stored in accordance with regulatory requirements.
 
First Republic Bank is a Division of Merrill Lynch Bank & Trust Co., FSB
__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"

Question: SYS:Notification Messages - Adding NEW Field to pull down menu

[T. Dee]

I added a new field to SYS:Form Field Selection so it would show up in
the pull down menu 'email message body' on SYS:Notifcation Messages.
This worked - I now see "Change Request Status" in the pull down
'email message body'.

However, when I select it and save the record the notification goes
out, but all I see in the email is:

#Change Request Status#

The Notifcation Message Tag I am trying to modify is:

CHG-APR-ApprovalNTForIndividual

Any ideas why the field would not show up in the email?

THANKS

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

Re: Question: SYS:Notification Messages - Adding NEW Field to pull down menu

[strauss]

Don't you have to add the new #Change Request Status# from $Change
Request Status$ translation to the
NTE:SHR:TranslateNotificationMessageCRQ1_126 filter?

Christopher Strauss, Ph.D.
Call Tracking Administration Manager
University of North Texas Computing & IT Center
http://itsm.unt.edu/ 

> -Original Message-
> From: Action Request System discussion list(ARSList) 
> [mailto:[EMAIL PROTECTED] On Behalf Of T. Dee
> Sent: Wednesday, April 02, 2008 12:33 PM
> To: arslist@ARSLIST.ORG
> Subject: Question: SYS:Notification Messages - Adding NEW 
> Field to pull down menu
> 
> I added a new field to SYS:Form Field Selection so it would 
> show up in the pull down menu 'email message body' on 
> SYS:Notifcation Messages.
> This worked - I now see "Change Request Status" in the pull 
> down 'email message body'.
> 
> However, when I select it and save the record the 
> notification goes out, but all I see in the email is:
> 
> #Change Request Status#
> 
> The Notifcation Message Tag I am trying to modify is:
> 
> CHG-APR-ApprovalNTForIndividual
> 
> Any ideas why the field would not show up in the email?
> 
> THANKS
> 
> __
> _
> 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: Requester Console customization

[strauss]

We use Kinetic Request for that.  Some service items submit the
logged-in user as the customer/requester, while others allow the logged
in user to be entered as the the Contact person and submit someone else
as the customer/requester.  We used ARSPerl scripts to do the same in
the past, but ARSPerl no longer works properly with ARS 7.1 anyway.  You
would have to do a fairly major customization of the Requester Console
to get this kind of capability worked into it, and I would avoid that.
I do not know if BMC Service Request Management can do this because we
stopped evaluating it after seeing the pricing model.  In addition to
Kinetic Request, there are other non-BMC customer interfaces to ITSM on
the market already (like the one Gidd just mentioned), but they solve a
host of other customer self-service issues beyond just proxy ticket
entry, and should be examined in that wider context.

Christopher Strauss, Ph.D.
Call Tracking Administration Manager
University of North Texas Computing & IT Center
http://itsm.unt.edu/ 


  _  

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Muhlethaler, Laurie
Sent: Wednesday, April 02, 2008 11:01 AM
To: arslist@ARSLIST.ORG
Subject: Requester Console customization


** 

Listers ~ checking to see if anyone has customized the RQC to
allow end users to submit issues on behalf of others.  If so, any
suggestions?


Database:  SQL Server 2005 
O/S:  Windows 2003 (server), R2XP Professional (client), SP2

Apps:  

Action Request System 7.1 patch 1 
Service Desk 7.0.3 patch 6 


Laurie Muhlethaler

Remedy Developer / Administrator

First Republic Bank

415.364.4436

 
The information transmitted is intended only for the person or
entity to which it is addressed and may contain confidential and/or
privileged material. Any review, retransmission, dissemination or other
use of, or taking of any action in reliance upon, this information by
persons or entities other than the intended recipient is prohibited. If
you received this in error, please contact the sender and delete the
material from any computer.  This message cannot be guaranteed to be
secure or error-free.
 
First Republic Bank and its subsidiaries do not take
responsibility for, or accept time-sensitive instructions sent by email
including orders, funds transfer instructions or stop payments on
checks. All instructions of this nature must be handled by direct
communication, not email.
 
We reserve the right to monitor and review the content of all
email communications sent or received. Emails sent to or from this
address may be stored in accordance with regulatory requirements.
 
First Republic Bank is a Division of Merrill Lynch Bank & Trust
Co., FSB
__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: Question: SYS:Notification Messages - Adding NEW Field to pull down menu

[T. Dee]

Thanks - i'll try it.

Ty


On 4/2/08, strauss <[EMAIL PROTECTED]> wrote:
> Don't you have to add the new #Change Request Status# from $Change
> Request Status$ translation to the
> NTE:SHR:TranslateNotificationMessageCRQ1_126 filter?
>
> Christopher Strauss, Ph.D.
> Call Tracking Administration Manager
> University of North Texas Computing & IT Center
> http://itsm.unt.edu/
>
> > -Original Message-
> > From: Action Request System discussion list(ARSList)
> > [mailto:[EMAIL PROTECTED] On Behalf Of T. Dee
> > Sent: Wednesday, April 02, 2008 12:33 PM
> > To: arslist@ARSLIST.ORG
> > Subject: Question: SYS:Notification Messages - Adding NEW
> > Field to pull down menu
> >
> > I added a new field to SYS:Form Field Selection so it would
> > show up in the pull down menu 'email message body' on
> > SYS:Notifcation Messages.
> > This worked - I now see "Change Request Status" in the pull
> > down 'email message body'.
> >
> > However, when I select it and save the record the
> > notification goes out, but all I see in the email is:
> >
> > #Change Request Status#
> >
> > The Notifcation Message Tag I am trying to modify is:
> >
> > CHG-APR-ApprovalNTForIndividual
> >
> > Any ideas why the field would not show up in the email?
> >
> > THANKS
> >
> > __
> > _
> > 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"

Menu Qualification Problem

[Sokol, Brian]

I have a menu that I am using to pull all the members of a Group. The
menu points to the User form and has a qualification of:

 'Group List' LIKE (( "%"  +  "1024" ) +  "%" )

This works for me as an admin but not for others. They get a no entries
in menu message which I assume is due to lack of permissions. They have
rights to the User form and the fields queried and displayed from the
User form. They also have permissions to the Group form and it's fields.


The Group ID is not listed in the Group List field in the User form. The
Group names are listed. If I change the query to use the group name then
it does not work for anyone. I am assuming Remedy does a translation of
the Group ID to Group name but I am not sure what permission is lacking
for this menu to work.

Brian Sokol
Manager, Desktop Services
Scholastic Inc.
557 Broadway
NY, NY 10012
(212) 343-6494
http://www.Scholastic.com


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

Product Catalog Data importing and relating to Company

[haeyoon . lee]

I just imported product catalog data to the PCT:Product Catalog form.

Now the only way I see to get this associated to the company is to
manually associate them through the Product Catalog setup form.
But that means I'll have to do this for 400 entries.

Is there an easier way to import this data with the company already
associated to it?

I'm sure there can be workflow created, but I'm looking for something
I don't have to spend weeks trying to figure out.

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

Issues with building a view over a DB Link

[Gary Dries]

I have created a Oracle (10g) to MSSQL (2003) dblink, I am able to create
the view, but I get sever fields that retrun the error
"Failure during SQL operation to the database : ORA-00904: "ADDRESS1":
invalid identifier (ARERR 552)."
We are researching several possible issues, such as permissions, and the
build of the table that I am creating the view of.
One suggetion I found searching the list is to create the view in Oracle to
the SQL db and then create the Remedy view to the Oracle view.

Is it possible to create a view from a view, and if it is, can the data in
the SQL table be modifed from Remedy in this view of a view of a SQL table?
-- 
Gary Dries

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

Re: Issues with building a view over a DB Link

[Gidd]

Gary,
 
Croom Consulting's Link to External Databases can do what you are looking at
and 
with significant less headache.  
 
Contact me off list if you would like to arrange an evaluation.
 
Regards...Gidd

  _  

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Gary Dries
Sent: Wednesday, April 02, 2008 12:14 PM
To: arslist@ARSLIST.ORG
Subject: Issues with building a view over a DB Link


** 
I have created a Oracle (10g) to MSSQL (2003) dblink, I am able to create
the view, but I get sever fields that retrun the error 
"Failure during SQL operation to the database : ORA-00904: "ADDRESS1":
invalid identifier (ARERR 552)."
We are researching several possible issues, such as permissions, and the
build of the table that I am creating the view of.
One suggetion I found searching the list is to create the view in Oracle to
the SQL db and then create the Remedy view to the Oracle view.
 
Is it possible to create a view from a view, and if it is, can the data in
the SQL table be modifed from Remedy in this view of a view of a SQL table?
-- 
Gary Dries
 
__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: Issues with building a view over a DB Link

[Brian Goralczyk]

Gary,

The short answer is yes a view of a view can be modified.  There are a
couple caviates here.

One. The request ID field in remedy.  I suspect from your error message that
you have the address1 column matched to column 1 on the view form.  even
with view forms, Remedy needs a unique identifier field, like the request
ID.

Two.  You have to make sure that the link is setup for you to be able to
write to the table from your oracle database.

Basically, if it can be done in the database, then you can make Remedy do it
very easily.
HTH,

Brian Goralczyk

On Wed, Apr 2, 2008 at 2:13 PM, Gary Dries <[EMAIL PROTECTED]> wrote:

> ** I have created a Oracle (10g) to MSSQL (2003) dblink, I am able to
> create the view, but I get sever fields that retrun the error
> "Failure during SQL operation to the database : ORA-00904: "ADDRESS1":
> invalid identifier (ARERR 552)."
> We are researching several possible issues, such as permissions, and the
> build of the table that I am creating the view of.
> One suggetion I found searching the list is to create the view in Oracle
> to the SQL db and then create the Remedy view to the Oracle view.
>
> Is it possible to create a view from a view, and if it is, can the data in
> the SQL table be modifed from Remedy in this view of a view of a SQL table?
> --
> Gary Dries
>
> __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"

AR server crashing on Product Categorisation data deletion

[Viji.PK]

Hi Listers,

I am facing the problem of AR Server getting crashed, when i delete the
Global Product categorisation data through Product Catalog Setup form(using
the delete button)

This action kills the arserver process. What might be the reason behind
this? Has anybody faced this?

Please pass your thoughts

Thanks,
Viji
-- 
View this message in context: 
http://www.nabble.com/AR-server-crashing-on-Product-Categorisation-data-deletion-tp16449460p16449460.html
Sent from the ARS (Action Request System) mailing list archive at Nabble.com.

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

Re: Product Catalog Data importing and relating to Company

[Alan West]

Have you tried the data load console? I found that using the console wasn't 
always successful but using the forms that are associated with it and utilising 
the workflow helps a lot.Kind Regards Alan D West

> Date: Wed, 2 Apr 2008 12:12:49 -0700> From: [EMAIL PROTECTED]> Subject: 
> Product Catalog Data importing and relating to Company> To: 
> arslist@ARSLIST.ORG> > I just imported product catalog data to the 
> PCT:Product Catalog form.> > Now the only way I see to get this associated to 
> the company is to> manually associate them through the Product Catalog setup 
> form.> But that means I'll have to do this for 400 entries.> > Is there an 
> easier way to import this data with the company already> associated to it?> > 
> I'm sure there can be workflow created, but I'm looking for something> I 
> don't have to spend weeks trying to figure out.> > 
> ___>
>  UNSUBSCRIBE or access ARSlist Archives at www.arslist.org> Platinum Sponsor: 
> www.rmsportal.com ARSlist: "Where the Answers Are"
_
Get Hotmail on your mobile. Text MSN to 63463 now!
http://mobile.uk.msn.com/pc/mail.aspx
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Test

[Gary Opela]

Test posting with NOMAIL




Gary Opela wrote:
> 
> Just testing, haven't seen anything come through Nabble since 10:30am.
> 


-

Thanks,

Gary Opela, Jr., RSP
Remedy Engineer
Leader Communications, Inc.
-- 
View this message in context: 
http://www.nabble.com/Test-tp16449073p16449564.html
Sent from the ARS (Action Request System) mailing list archive at Nabble.com.

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

Re: Issues with building a view over a DB Link

[Gary Dries]

Gidd,
I am not in a position to purchase any tool, apps, or anything for that
matter.  To evaluate something and recommend to management would take longer
than I have to resolve this issue.  I will talk to my Mgr. to see if he is
interested, what is the cost of this solution?

Brian,
The field mentioned in the error is not the key, the field we have
identified as a key is unique, no null and between 6 to 15 characters, that
field is not giving us any problems and successfully maps to the view form
when it is created.
Now the write access issue is another thing I am working on, what I do not
understand is the fields that do get mapped in the view form have the same
permissions as the fields that error.

Fellas, I appreciate the quick response


Gary

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

Re: Issues with building a view over a DB Link

[Gidd]

Gary,
 
I understand the budget crunch !!   Solution cost is $4999.00 + support
 
Here is a link for more detailed information.
http://www.buoyantsolutions.net/External_DB.html
 
BTW: There are many on the ARS List that use this solution and swear by it
...
not at it !!
 
HTH
 
 
Regards...Gidd

  _  

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Gary Dries
Sent: Wednesday, April 02, 2008 1:16 PM
To: arslist@ARSLIST.ORG
Subject: Re: Issues with building a view over a DB Link


** 
Gidd,
I am not in a position to purchase any tool, apps, or anything for that
matter.  To evaluate something and recommend to management would take longer
than I have to resolve this issue.  I will talk to my Mgr. to see if he is
interested, what is the cost of this solution?
 
Brian,
The field mentioned in the error is not the key, the field we have
identified as a key is unique, no null and between 6 to 15 characters, that
field is not giving us any problems and successfully maps to the view form
when it is created.
Now the write access issue is another thing I am working on, what I do not
understand is the fields that do get mapped in the view form have the same
permissions as the fields that error.
 
Fellas, I appreciate the quick response
 
 
Gary
__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: Issues with building a view over a DB Link

[Pierson, Shawn]

What I've had to do in the past in a similar situation is to have the
view form referencing a view on my DB that was using a linked server.
If you get that part, you can at least see the data.



However, if you have issues modifying or submitting the data,
unfortunately the next best solution is to build active links on buttons
that run SQL commands for insert and update.



Thanks,



Shawn Pierson



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Gary Dries
Sent: Wednesday, April 02, 2008 2:14 PM
To: arslist@ARSLIST.ORG
Subject: Issues with building a view over a DB Link



**

I have created a Oracle (10g) to MSSQL (2003) dblink, I am able to
create the view, but I get sever fields that retrun the error

"Failure during SQL operation to the database : ORA-00904: "ADDRESS1":
invalid identifier (ARERR 552)."
We are researching several possible issues, such as permissions, and the
build of the table that I am creating the view of.

One suggetion I found searching the list is to create the view in Oracle
to the SQL db and then create the Remedy view to the Oracle view.



Is it possible to create a view from a view, and if it is, can the data
in the SQL table be modifed from Remedy in this view of a view of a SQL
table?
--
Gary Dries


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


Private and confidential as detailed here: 
http://www.sug.com/disclaimers/default.htm#Mail . If you cannot access the 
link, please e-mail sender.

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

Re: Issues with building a view over a DB Link

[Brian Goralczyk]

I queried the error on google and came up with a bit from someone else.  The
amusing part is that they state that Oracle claims that the error doesn't
happen in 10g which caused me to immediately check and notice you are on.
So I file that under interesting.

Personally, I would first make the database view in your database to the one
that you are connecting.  Make sure that everything works that way.  Then
you have the choice of either creating the view form and attaching to your
view or attempting to create the same process that your view is creating.
One note of caution.  If you create your view, you CAN NOT use the same name
as the view form.  And vice versa, you CAN NOT create a view form with the
same name as a view that was created in the database.  Remedy tries to
create a database view to match the form and errors out.

I have included the piece that the individual wrote, mostly cause it amuses
me with the contridiction.  It came from this site..
http://www.dba-oracle.com/t_ora_00904_string_invalid_identifier.htm

"

The Oracle docs note this on the ora-00904 error*:



*ORA-00904 string: invalid identifier*
 *Cause:* The column name entered is either missing or invalid.
*Action:*Enter a valid column name. A valid column name must begin
with a letter, be
less than or equal to 30 characters, and consist of only alphanumeric
characters and the special characters $, _, and #. If it contains other
characters, then it must be enclosed in double quotation marks. It may not
be a reserved word.

*According to Oracle documentation, ORA-00904 does not occur in Oracle 10g

When ORA-00904 occurs, you must enter a valid column name as it is either
missing or the one entered is invalid.

To avoid ORA-00904, column names cannot be a reserved word, and must contain
these four criteria to be valid:

   - begin with a letter
   - be less than or equal to twenty characters
   - consist only of alphanumeric and the special characters ($_#); other
   characters need double quotation marks around them

Another important factor in correcting ORA-00904 is remembering to run
catproc.sql

You can also check your trace file to find the particular error which is
causing the ORA-00904 to occur. "

On Wed, Apr 2, 2008 at 3:37 PM, Pierson, Shawn <[EMAIL PROTECTED]>
wrote:

> **
>
> What I've had to do in the past in a similar situation is to have the view
> form referencing a view on my DB that was using a linked server.  If you get
> that part, you can at least see the data.
>
>
>
> However, if you have issues modifying or submitting the data,
> unfortunately the next best solution is to build active links on buttons
> that run SQL commands for insert and update.
>
>
>
> Thanks,
>
>
>
> Shawn Pierson
>
>
>
> *From:* Action Request System discussion list(ARSList) [mailto:
> [EMAIL PROTECTED] *On Behalf Of *Gary Dries
> *Sent:* Wednesday, April 02, 2008 2:14 PM
> *To:* arslist@ARSLIST.ORG
> *Subject:* Issues with building a view over a DB Link
>
>
>
> **
>
> I have created a Oracle (10g) to MSSQL (2003) dblink, I am able to create
> the view, but I get sever fields that retrun the error
>
> "Failure during SQL operation to the database : ORA-00904: "ADDRESS1":
> invalid identifier (ARERR 552)."
> We are researching several possible issues, such as permissions, and the
> build of the table that I am creating the view of.
>
> One suggetion I found searching the list is to create the view in Oracle
> to the SQL db and then create the Remedy view to the Oracle view.
>
>
>
> Is it possible to create a view from a view, and if it is, can the data in
> the SQL table be modifed from Remedy in this view of a view of a SQL table?
> --
> Gary Dries
>
>
> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
> html___
> Private and confidential as detailed 
> here.
> If you cannot access hyperlink, please e-mail sender.
>  __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: Issues with building a view over a DB Link

[Gary Dries]

Brian,
I saw this also and sent it to my DBA, he found it interesting also.  The
only quick explanation we could come up with is that something is happening
to the Column Name in translation via the DBLink.  Now this has one flaw,
and that is the fact that the field that do not error have very similar
names, like Address1 errors but Address2 does not.

We are working on the process of building the view in oracle and then the
view in Remedy, I will keep in mind the naming issue you mentioned.

Thanks
Gary

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

Re: Product Catalog Data importing and relating to Company

[P Romain ARSlist]

If I remember right there's a filter on the PCT:Product Catalog form that
associates the record to the global company.
Set the filter to fire on merge and all will be ok.

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
Sent: 02 April 2008 20:13
To: arslist@ARSLIST.ORG
Subject: Product Catalog Data importing and relating to Company

I just imported product catalog data to the PCT:Product Catalog form.

Now the only way I see to get this associated to the company is to
manually associate them through the Product Catalog setup form.
But that means I'll have to do this for 400 entries.

Is there an easier way to import this data with the company already
associated to it?

I'm sure there can be workflow created, but I'm looking for something
I don't have to spend weeks trying to figure out.


___
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: Issues with building a view over a DB Link

[Brian Goralczyk]

You know, I am wonderingSometimes I have seen Oracle return the wrong
piece of code for the error.  Is there any field on the list that might be a
reserved word for Oracle?  Were you going with just the error, or did you
turn on server sql logging and capture the sql code that Remedy was
generating?  That might help you identify where the actual error is.  as
well as it should help your dba create the view.

On Wed, Apr 2, 2008 at 4:25 PM, Gary Dries <[EMAIL PROTECTED]> wrote:

> ** Brian,
> I saw this also and sent it to my DBA, he found it interesting also.  The
> only quick explanation we could come up with is that something is happening
> to the Column Name in translation via the DBLink.  Now this has one flaw,
> and that is the fact that the field that do not error have very similar
> names, like Address1 errors but Address2 does not.
>
> We are working on the process of building the view in oracle and then the
> view in Remedy, I will keep in mind the naming issue you mentioned.
>
> Thanks
> Gary
>
> __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: Product Catalog Data importing and relating to Company

[Leonard Neely - FOJ]

You haven't mentioned your app version, but I assume it is ITSM 7.

 

Here are two options:

 

 

1.  If all your Product Categories will be associated with a single
company.

*   Import the same source file into the "PCT-ProductCompanyAssoc" form,
mapping only the following fields:

*   Product Categorization Tier 1
*   Product Categorization Tier 2
*   Product Categorization Tier 3
*   CI Type
*   Company (Map with a static value representing your single company
name)
*   Status (Map with a static value of Enabled if this value does not
exist in your source file)

2.   If your Product Categories will be associated with multiple
companies.

a.  Use your original source file (Spreadsheet), and add a "Company"
column.
b.  Populate the new company column with the appropriate values.
c.  Import the modified source file into the "PCT-ProductCompanyAssoc"
form, mapping only the following fields:

* Product Categorization Tier 1

* Product Categorization Tier 2

* Product Categorization Tier 3

* CI Type

* Company 

* Status (Map with a static value of Enabled if this value does not
exist in your source file)

 

Note: If all of your Product Categorization was to be associated with ALL of
your companies, you could have simply set the "Map to Global" field to "Yes"
on your original import, which would have automatically created global
associations.

 

HTH

 

  _  

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Alan West
Sent: Wednesday, April 02, 2008 12:40 PM
To: arslist@ARSLIST.ORG
Subject: Re: Product Catalog Data importing and relating to Company

 

Have you tried the data load console? I found that using the console wasn't
always successful but using the forms that are associated with it and
utilising the workflow helps a lot.

Kind Regards
 
Alan D West



  _  

> Date: Wed, 2 Apr 2008 12:12:49 -0700
> From: [EMAIL PROTECTED]
> Subject: Product Catalog Data importing and relating to Company
> To: arslist@ARSLIST.ORG
> 
> I just imported product catalog data to the PCT:Product Catalog form.
> 
> Now the only way I see to get this associated to the company is to
> manually associate them through the Product Catalog setup form.
> But that means I'll have to do this for 400 entries.
> 
> Is there an easier way to import this data with the company already
> associated to it?
> 
> I'm sure there can be workflow created, but I'm looking for something
> I don't have to spend weeks trying to figure out.
> 
>

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

  _  

A prize an hour, 24 hours a day. Try Big Snap
  now!

__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: Issues with building a view over a DB Link

[patrick zandi]

Just create a view on the db side, create a dblink, then create a synomn on
the ars side.
Test link..  select * from synonm... ( I know I cannot spell .. ;-)
then create a view form.. watch out of Date fields.. and use an escalation
or a filter to write back..

voila .. works great.. been doing this for years.. .. Day 1 since the view
form came out..

Hope that helps..

ARS
 DB
ARS VIEW ~~>  Synonmn ~~> DBlink ~~> View of tables ~~> Tables
test your link !




On 4/2/08, Brian Goralczyk <[EMAIL PROTECTED]> wrote:
>
> ** I queried the error on google and came up with a bit from someone
> else.  The amusing part is that they state that Oracle claims that the error
> doesn't happen in 10g which caused me to immediately check and notice you
> are on.  So I file that under interesting.
>
> Personally, I would first make the database view in your database to the
> one that you are connecting.  Make sure that everything works that way.
> Then you have the choice of either creating the view form and attaching to
> your view or attempting to create the same process that your view is
> creating.  One note of caution.  If you create your view, you CAN NOT use
> the same name as the view form.  And vice versa, you CAN NOT create a view
> form with the same name as a view that was created in the database.  Remedy
> tries to create a database view to match the form and errors out.
>
> I have included the piece that the individual wrote, mostly cause it
> amuses me with the contridiction.  It came from this site..
> http://www.dba-oracle.com/t_ora_00904_string_invalid_identifier.htm
>
> "
>
> The Oracle docs note this on the ora-00904 error*:
>
>
>
> *ORA-00904 string: invalid identifier*
>  *Cause:* The column name entered is either missing or invalid.   *Action:
> * Enter a valid column name. A valid column name must begin with a letter,
> be less than or equal to 30 characters, and consist of only alphanumeric
> characters and the special characters $, _, and #. If it contains other
> characters, then it must be enclosed in double quotation marks. It may not
> be a reserved word.
>
> *According to Oracle documentation, ORA-00904 does not occur in Oracle 10g
>
> When ORA-00904 occurs, you must enter a valid column name as it is either
> missing or the one entered is invalid.
>
> To avoid ORA-00904, column names cannot be a reserved word, and must
> contain these four criteria to be valid:
>
>- begin with a letter
>- be less than or equal to twenty characters
>- consist only of alphanumeric and the special characters ($_#);
>other characters need double quotation marks around them
>
> Another important factor in correcting ORA-00904 is remembering to run
> catproc.sql
>
> You can also check your trace file to find the particular error which is
> causing the ORA-00904 to occur. "
>
>  On Wed, Apr 2, 2008 at 3:37 PM, Pierson, Shawn <[EMAIL PROTECTED]>
> wrote:
>
> > **
> >
> > What I've had to do in the past in a similar situation is to have the
> > view form referencing a view on my DB that was using a linked server.  If
> > you get that part, you can at least see the data.
> >
> >
> >
> > However, if you have issues modifying or submitting the data,
> > unfortunately the next best solution is to build active links on buttons
> > that run SQL commands for insert and update.
> >
> >
> >
> > Thanks,
> >
> >
> >
> > Shawn Pierson
> >
> >
> >
> > *From:* Action Request System discussion list(ARSList) [mailto:
> > [EMAIL PROTECTED] *On Behalf Of *Gary Dries
> > *Sent:* Wednesday, April 02, 2008 2:14 PM
> > *To:* arslist@ARSLIST.ORG
> > *Subject:* Issues with building a view over a DB Link
> >
> >
> >
> > **
> >
> > I have created a Oracle (10g) to MSSQL (2003) dblink, I am able to
> > create the view, but I get sever fields that retrun the error
> >
> > "Failure during SQL operation to the database : ORA-00904: "ADDRESS1":
> > invalid identifier (ARERR 552)."
> > We are researching several possible issues, such as permissions, and the
> > build of the table that I am creating the view of.
> >
> > One suggetion I found searching the list is to create the view in Oracle
> > to the SQL db and then create the Remedy view to the Oracle view.
> >
> >
> >
> > Is it possible to create a view from a view, and if it is, can the data
> > in the SQL table be modifed from Remedy in this view of a view of a SQL
> > table?
> > --
> > Gary Dries
> >
> >
> > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
> > html___
> > Private and confidential as detailed 
> > here.
> > If you cannot access hyperlink, please e-mail sender.
> >  __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
> > html___
> >
>
> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
> html___
>



-- 
Patrick Zandi

Dev Technology Group -->  www.devtechnology.com
Exceeding your Expectations !  By Design...

___

Re: Issues with building a view over a DB Link

[patrick zandi]

do you have encryption turned on between the links ?
this could be your issue as well.  I have seen a required on one side and a
requested on the other.. cause issues..


On 4/2/08, patrick zandi <[EMAIL PROTECTED]> wrote:
>
> Just create a view on the db side, create a dblink, then create a synomn
> on the ars side.
> Test link..  select * from synonm... ( I know I cannot spell .. ;-)
> then create a view form.. watch out of Date fields.. and use an escalation
> or a filter to write back..
>
> voila .. works great.. been doing this for years.. .. Day 1 since the view
> form came out..
>
> Hope that helps..
>
> ARS
>  DB
> ARS VIEW ~~>  Synonmn ~~> DBlink ~~> View of tables ~~> Tables
> test your link !
>
>
>
>
> On 4/2/08, Brian Goralczyk <[EMAIL PROTECTED]> wrote:
> >
> > ** I queried the error on google and came up with a bit from someone
> > else.  The amusing part is that they state that Oracle claims that the error
> > doesn't happen in 10g which caused me to immediately check and notice you
> > are on.  So I file that under interesting.
> >
> > Personally, I would first make the database view in your database to the
> > one that you are connecting.  Make sure that everything works that way.
> > Then you have the choice of either creating the view form and attaching to
> > your view or attempting to create the same process that your view is
> > creating.  One note of caution.  If you create your view, you CAN NOT use
> > the same name as the view form.  And vice versa, you CAN NOT create a view
> > form with the same name as a view that was created in the database.  Remedy
> > tries to create a database view to match the form and errors out.
> >
> > I have included the piece that the individual wrote, mostly cause it
> > amuses me with the contridiction.  It came from this site..
> > http://www.dba-oracle.com/t_ora_00904_string_invalid_identifier.htm
> >
> > "
> >
> > The Oracle docs note this on the ora-00904 error*:
> >
> >
> >
> > *ORA-00904 string: invalid identifier*
> >  *Cause:* The column name entered is either missing or invalid.   *
> > Action:* Enter a valid column name. A valid column name must begin with
> > a letter, be less than or equal to 30 characters, and consist of only
> > alphanumeric characters and the special characters $, _, and #. If it
> > contains other characters, then it must be enclosed in double quotation
> > marks. It may not be a reserved word.
> >
> > *According to Oracle documentation, ORA-00904 does not occur in Oracle
> > 10g
> >
> > When ORA-00904 occurs, you must enter a valid column name as it is
> > either missing or the one entered is invalid.
> >
> > To avoid ORA-00904, column names cannot be a reserved word, and must
> > contain these four criteria to be valid:
> >
> >- begin with a letter
> >- be less than or equal to twenty characters
> >- consist only of alphanumeric and the special characters ($_#);
> >other characters need double quotation marks around them
> >
> > Another important factor in correcting ORA-00904 is remembering to run
> > catproc.sql
> >
> > You can also check your trace file to find the particular error which is
> > causing the ORA-00904 to occur. "
> >
> >  On Wed, Apr 2, 2008 at 3:37 PM, Pierson, Shawn <[EMAIL PROTECTED]>
> > wrote:
> >
> > > **
> > >
> > > What I've had to do in the past in a similar situation is to have the
> > > view form referencing a view on my DB that was using a linked server.  If
> > > you get that part, you can at least see the data.
> > >
> > >
> > >
> > > However, if you have issues modifying or submitting the data,
> > > unfortunately the next best solution is to build active links on buttons
> > > that run SQL commands for insert and update.
> > >
> > >
> > >
> > > Thanks,
> > >
> > >
> > >
> > > Shawn Pierson
> > >
> > >
> > >
> > > *From:* Action Request System discussion list(ARSList) [mailto:
> > > [EMAIL PROTECTED] *On Behalf Of *Gary Dries
> > > *Sent:* Wednesday, April 02, 2008 2:14 PM
> > > *To:* arslist@ARSLIST.ORG
> > > *Subject:* Issues with building a view over a DB Link
> > >
> > >
> > >
> > > **
> > >
> > > I have created a Oracle (10g) to MSSQL (2003) dblink, I am able to
> > > create the view, but I get sever fields that retrun the error
> > >
> > > "Failure during SQL operation to the database : ORA-00904: "ADDRESS1":
> > > invalid identifier (ARERR 552)."
> > > We are researching several possible issues, such as permissions, and
> > > the build of the table that I am creating the view of.
> > >
> > > One suggetion I found searching the list is to create the view in
> > > Oracle to the SQL db and then create the Remedy view to the Oracle view.
> > >
> > >
> > >
> > > Is it possible to create a view from a view, and if it is, can the
> > > data in the SQL table be modifed from Remedy in this view of a view of a 
> > > SQL
> > > table?
> > > --
> > > Gary Dries
> > >
> > >
> > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
> > > html___
> > > Pri

Re: Help with Change Management

Katherine, 

Having these values missing in the Member List field is definitely a
problem that caused the Approval process to fail. 

The safest way to fix it - by removing and re-creating your few
approvers from the person's profile role.

However, it could also be done in the AP:Role record directly if you
feel comfortable.

 

Igor

 

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Katherine Hoffner
Sent: Wednesday, April 02, 2008 11:06 AM
To: arslist@ARSLIST.ORG
Subject: Re: Help with Change Management

 

** I checked the list and it is empty.  I saw this before but I cannot
add names to it.  I am guessing my approvers should be inthis list huh.

On 4/1/08, Model, Igor [ITSUS Non J&J] <[EMAIL PROTECTED]> wrote: 

** 

Katherine

 

Check the Member List field of the AP:Roles form if the manager's id was
also deleted from that list.

 

Igor

 

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Katherine Hoffner
Sent: Monday, March 31, 2008 2:59 PM
To: arslist@ARSLIST.ORG
Subject: Re: Help with Change Management

 

** I am not really well versed with this product.  Of Course huh.
Someone who doesnt know anything.  

On 3/31/08, T. Dee <[EMAIL PROTECTED]> wrote: 

Have you checked the Approval Process Configuration and Approval
Mappings.

Ty


On 3/31/08, Katherine Hoffner <[EMAIL PROTECTED]> wrote:
> ** This is with all the NEW changes.
>
>
> On 3/31/08, T. Dee <[EMAIL PROTECTED]> wrote:
> >
> > Is this with "current" Changes or NEW Changes?
> >
> > Ty
> >
> >
> > On 3/31/08, Katherine Hoffner <[EMAIL PROTECTED]> wrote:
> > > **
> > > Hi all,
> > >
> > > I have a problem with my change requests.  One of our managers
left and
> his
> > > name was deleted from the system.  I am not sure if this had
anything to
> do
> > > with the issue but it did happen after his removal.  Anyway we
have a
> new
> > > manager and I added her to the all Approvals list.  Our CTI'S are
set up
> as
> > > ALL.  We do not have individual approval for different CTI's
everything
> is
> > > approved by 4 people.  Anyway I cannot get the approvers up to the
> current
> > > signatures line under the Approvals tab on the change request so
none of
> my
> > > approvers can actually sign off the change request.  All of my
change
> > > requests are staying in the pending approval state.
> > >
> > > Running ARS 6.3
> > >
> > >
> > > --
> > > Katherine __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"
> >
>
>
>
> --
> Katherine __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"




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

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




-- 
Katherine __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: Menu Qualification Problem

[Carey Matthew Black]

Brian,

The 'Group List' field is a *special* field. I suggest you do a report
of that column into an ARX file to really see what data is in the
field and how it is structured. ( BTW: I think your menu qualification
should really be more like this... [ 'Group List' LIKE (( "%;"  +
"1024" ) +  ";%" ) ] )

However the permission issue has only to do with the User form. Your
users likely do not have access to all rows in the User form. (And
they likely should not be granted this access either. IMHO) Check
permissions on Field ID 1, and the 'Group List' field and any other
field in the Menu qualification. If the users have access to Field 1
and 'Group List' then the menu should work for them as well as it
works for any one else.


HTH

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

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


On Wed, Apr 2, 2008 at 3:06 PM, Sokol, Brian <[EMAIL PROTECTED]> wrote:
> **
>
>
> I have a menu that I am using to pull all the members of a Group. The menu
> points to the User form and has a qualification of:
>
>  'Group List' LIKE (( "%"  +  "1024" ) +  "%" )
>
> This works for me as an admin but not for others. They get a no entries in
> menu message which I assume is due to lack of permissions. They have rights
> to the User form and the fields queried and displayed from the User form.
> They also have permissions to the Group form and it's fields.
>
> The Group ID is not listed in the Group List field in the User form. The
> Group names are listed. If I change the query to use the group name then it
> does not work for anyone. I am assuming Remedy does a translation of the
> Group ID to Group name but I am not sure what permission is lacking for this
> menu to work.
>
> Brian Sokol
> Manager, Desktop Services
> Scholastic Inc.
> 557 Broadway
> NY, NY 10012
> (212) 343-6494
> http://www.Scholastic.com

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

Re: Product Catalog Data importing and relating to Company

[Saravanan Palaniappan]

Hi all,
Is this the filter you are talking about
PCT:PDC:CreateDefaultGlobalCompanyAssoc_795_PPDA?

Because I see this filter fires only in the Submit and not in merge

Thanks & Regards
Saravanan Palaniappan
ITSM
 

"To teach and to learn, to laugh and make others laugh.  This is my
purpose.  Any day I don't do this was not worth the time it took to get
through it."

 


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of P Romain ARSlist
Sent: Thursday, April 03, 2008 2:50 AM
To: arslist@ARSLIST.ORG
Subject: Re: Product Catalog Data importing and relating to Company

If I remember right there's a filter on the PCT:Product Catalog form
that
associates the record to the global company.
Set the filter to fire on merge and all will be ok.

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
Sent: 02 April 2008 20:13
To: arslist@ARSLIST.ORG
Subject: Product Catalog Data importing and relating to Company

I just imported product catalog data to the PCT:Product Catalog form.

Now the only way I see to get this associated to the company is to
manually associate them through the Product Catalog setup form.
But that means I'll have to do this for 400 entries.

Is there an easier way to import this data with the company already
associated to it?

I'm sure there can be workflow created, but I'm looking for something
I don't have to spend weeks trying to figure out.



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

-
This message, including any attachments, contains confidential information 
intended for a specific individual and purpose, and is intended for the 
addressee only. Any unauthorized disclosure, use, dissemination, copying, or 
distribution of this message or any of its attachments or the information 
contained in this e-mail, or the taking of any action based on it, is strictly 
prohibited. If you are not the intended recipient, please notify the sender 
immediately by return e-mail and delete this message.

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

Re: Product Catalog Data importing and relating to Company

[Saravanan Palaniappan]

Hi All,

Related to the Product Company Association I have an issue. By following
the second option I have imported the data.

It seems that the Product categorizations are not populating as
expected.

The Reason I found out was
SHR:SHR:UpdateGroupList-CompanyReinitialize-G_565 which is shared
workflow has got the RUN IF qualification as 

( 'z1D Action' =  "UPDATEGROUPLIST" ) AND (NOT (( 'Company' =  "- Global
-" ) AND (($SCHEMA$ =  "CFG:Broadcast" ) OR ($SCHEMA$ =
"CFG:ProductCompanyAssociation" ) OR ($SCHEMA$ =  "CFG:Service Catalog
Assoc" ) OR ($SCHEMA$ =  "CHG:CFG Calendar Qualification" ) OR ($SCHEMA$
=  "CFG:GenericCompanyModuleAssoc" ) OR ($SCHEMA$ =  "CFG:Decision Tree"
) OR ($SCHEMA$ =  "CFG:Decision Tree-Branch" ) OR ($SCHEMA$ =
"SLM:CFG-SurveyTemplate" 

But if you look closely there is no form called
CFG:ProductCompanyAssociation" . So I have changed it to
PCT:.ProductCompanyAssociation.

My Problem is since I have not changed this Run if qualification before
my import these work flow have fired in MERGE and Made the Assignee
group field to NULL

What will be the best option to put this Assignee Group to yes in the
already existing record? I have tried deleting the records and try to
import it again. This doesn't help as the server crashes during the
delete activity.

Please advise a way forward ..



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Leonard Neely - FOJ
Sent: Thursday, April 03, 2008 3:00 AM
To: arslist@ARSLIST.ORG
Subject: Re: Product Catalog Data importing and relating to Company

 

You haven't mentioned your app version, but I assume it is ITSM 7.

 

Here are two options:

 

 

1.  If all your Product Categories will be associated with a single
company.

*   Import the same source file into the
"PCT-ProductCompanyAssoc" form, mapping only the following fields:

*   Product Categorization Tier 1
*   Product Categorization Tier 2
*   Product Categorization Tier 3
*   CI Type
*   Company (Map with a static value representing
your single company name)
*   Status (Map with a static value of Enabled if
this value does not exist in your source file)

2.   If your Product Categories will be associated with multiple
companies.

a.  Use your original source file (Spreadsheet), and add a
"Company" column.
b.  Populate the new company column with the appropriate
values.
c.  Import the modified source file into the
"PCT-ProductCompanyAssoc" form, mapping only the following fields:

* Product Categorization Tier 1

* Product Categorization Tier 2

* Product Categorization Tier 3

* CI Type

* Company 

* Status (Map with a static value of Enabled if this value does
not exist in your source file)

 

Note: If all of your Product Categorization was to be associated with
ALL of your companies, you could have simply set the "Map to Global"
field to "Yes" on your original import, which would have automatically
created global associations.

 

HTH

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Alan West
Sent: Wednesday, April 02, 2008 12:40 PM
To: arslist@ARSLIST.ORG
Subject: Re: Product Catalog Data importing and relating to Company

 

Have you tried the data load console? I found that using the console
wasn't always successful but using the forms that are associated with it
and utilising the workflow helps a lot.

Kind Regards
 
Alan D West



> Date: Wed, 2 Apr 2008 12:12:49 -0700
> From: [EMAIL PROTECTED]
> Subject: Product Catalog Data importing and relating to Company
> To: arslist@ARSLIST.ORG
> 
> I just imported product catalog data to the PCT:Product Catalog form.
> 
> Now the only way I see to get this associated to the company is to
> manually associate them through the Product Catalog setup form.
> But that means I'll have to do this for 400 entries.
> 
> Is there an easier way to import this data with the company already
> associated to it?
> 
> I'm sure there can be workflow created, but I'm looking for something
> I don't have to spend weeks trying to figure out.
> 
>

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



A prize an hour, 24 hours a day. Try Big Snap now!
 

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


-