Re: Mid Tier - Issue with Active Link that launch an application like MS Word and Excel

[ITSM Support]

*Hi Ronie,*


OLE does not work on web.
It will work on only Remedy User tool.

Hope this helps

*Regards.

Sandeep

Vyom Labs Pvt. Ltd.
An ISO 2 certified company.
Consulting | Outsourcing | Training || BMC Remedy BSM | ITIL
Web : www.vyomlabs.com

*
Ronnielo Pipit wrote:

**

 


Hi All,

 

I am having a problem creating an Active Link that opens another 
application like MS Word and Excel that works in Mid Tier.


 

I was able to create an Active Link that works in Remedy User Tool 
that opens an MS Excel file located in a shared directory using OLE 
Automation, but sadly this doesn't wotk in the web.


 

Can anyone give me an idea on how to create this type of Active Link 
that will work in the web?


 


Thanks in advance.

 


-Ronie

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

Mid Tier - Issue with Active Link that launch an application like MS Word and Excel

[Ronnielo Pipit]

 

Hi All,

 

I am having a problem creating an Active Link that opens another application
like MS Word and Excel that works in Mid Tier.

 

I was able to create an Active Link that works in Remedy User Tool that
opens an MS Excel file located in a shared directory using OLE Automation,
but sadly this doesn't wotk in the web.

 

Can anyone give me an idea on how to create this type of Active Link that
will work in the web?

 

Thanks in advance.

 

-Ronie


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

Re: ARS 7.1 Area LDAP config issue

[ITSM Support]

Hi K.P.,

Try for following changes in *AREA LDAP* form & *Server Information* 
form >

*
Bind User* -- User Name which you created in Active Directory & have 
admin  previllages in Active Directory.

*Authontication Chain Mode* -- ARS-AREA
Select  Croos-Reference Blank Password.
We tried with *Group Membership* -- Group  Container.

Hope this helps...
Regards,

*Mahendra.
Vyom Labs Pvt. Ltd.
An ISO 2 certified company.
Consulting | Outsourcing | Training || BMC Remedy BSM | ITIL
Web : www.vyomlabs.com   


*Kevin Pulsen wrote:

Hello all,

I'm trying to config the AREA LDAP form for Active Directory 
authentication, when a user login into the Remedy client.
I have followed the documentation from the integrating 7.10 guide and 
have the following values set in my AREA LDAP form -


Host Name* - tcdc1.testco.com

User Base* - dc=testco,dc=com

Port Number - 389

User Search Filter* - cn=$\USER$

Bind User - testco\NETWORKOPS\Admins\Support Desk\tuser1

Group Membership - None

Bind Password - * (no it's not really *'s)

Use Secure Socket Layer - No

Chase Referral - No

I have the EA RPC set to 390695 and Authentication Chain Mode set to 
ARS -AREA -OS


When I attempt to login as a predefined user (with an existing Remedy 
ID setup, no password) It fails and gives the following error in the 
arplugin.log -


  Bind: Invalid credentials (LDAPERR Code 49) 
80090308: LdapErr:


What am I missing for the AREA LDAP config?

Please help...

Thanks Kevin P.


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

Out of Office

[Linda Brown]

Greetings,

I will be out of the office from Friday, May 23 through Tuesday, May 27.  I 
will return on Wednesday, May 28.  Please forward all job inquiries to Priya 
Tejwani, [EMAIL PROTECTED], 240-292-0233.  I will address all other matters 
when I return.

Enjoy your day,
Linda

Linda M. Brown
Technical Recruiter

Cyquent, Inc.
5410 Edson Lane, Suite 320B
Rockville, MD 20852
Office:  240-292-0230, Ext. 304
Direct:  240-292-0234
Fax: 866-509-0331
E-mail:  [EMAIL PROTECTED]

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

Re: Job: Kforce / Permanent / McLean - VA / Remedy Developer - Will Relocate

[srinivas madhurakavi]

Josh,

There seem to be an important piece of information missing in your post
below as far as all potenital H1-B candidates who would like to apply for
this job.

 For All qualified H1-B Candidates 

Freddie Mac has a policy of accepting H1-B candidates where in they will
consider applicants who are currently on H1-B and require H-1B sponsorship
(as there would be a possible change in employer), but only if the applicant
has at least three years of H status remaining out of the original six years
of permissible H status. In order to be considered for permanent residence
sponsorship, the individual must be employed with the company for 12 months
and meet or exceed annual performance objectives established by their
management team. This is a minimum requirement for sponsorship. The decision
whether to sponsor an individual for nonimmigrant or immigrant status rests
exclusively with Freddie Mac.

Hope this additional information helps.

-Srinivas

On 5/22/08, Kitchen, Joshua T <[EMAIL PROTECTED]> wrote:
>
> **
>
> *Dear List,*
>
> **
>
> Hope all is well, Kforce is looking for a talented Remedy Developer local
> or willing to relocate to the Virginia area for a permanent position with
> one of our clients.
>
> **
>
> *Title:  *Remedy Developer**
>
> *Type:*  Direct-Hire at Client
>
> *Authorization Status:*  US Citizen/Green Card/EAD/H1-B Visa
>
> *Duration:*  Permanent
>
> *Salary:*  75,000-90,000 + 12% Bonus (Full Relocation Offered)
>
> *Location:*  McLean, VA
>
> *Interview Process:*  1st round phone, 2nd round in-person (We will fly
> you in for interview)
>
>
>
> *Industry:*
>
> * *
>
> Our client is a stockholder – owned corporation chartered by Congress to
> increase the supply of funds that mortgage lenders, such as commercial
> banks, mortgage bankers, savings institutions and credit unions, can make
> available to homebuyers and multifamily investors.
>
>
>
> Since 1970, our client has pursued the purpose their Congressional founders
> set out for them: to provide a continuous and low – cost source of credit to
> finance America's housing. They achieve this purpose by
>
>
>
> 1)  Making mortgage funds available whenever and wherever Americans need
> them by linking the worldwide capital markets to the U.S. mortgage markets
>
> 2)  Providing a continuous, reliable and low – cost flow of mortgage
> capital to finance housing for the nation's homebuyers and renters
>
> 3)  Bringing the benefits of the market in which we operate – the
> secondary mortgage market – to families and communities across the nation
>
> 4)  Freddie Mac conducts its business primarily by buying mortgages from
> lenders, packaging the mortgages into securities and selling the securities
> – guaranteed by Freddie Mac – to investors. 5)  Mortgage lenders use the
> proceeds from selling loans to Freddie Mac to fund new mortgages, constantly
> replenishing the pool of funds available for lending to homebuyers and
> apartment owners. Just as stock and bond markets have put investor capital
> to work for corporations, the secondary mortgage market puts private
> investor capital to work for homebuyers and apartment owners, providing a
> continuous flow of affordable funds for home financing.
>
>
>
> For the most part, the process is invisible to borrowers and renters. But
> because our client exists, millions of Americans have benefited from lower
> monthly mortgage payments and better access to home financing. In fact, for
> more than 35 years they have opened doors for one in six homebuyers and more
> than four million renters in America.
>
>
>
> *Job Responsibilities:*
>
> Performs analysis, design, and development, of Remedy v. 7.1 Service Desk.
> Analyze requirements and create design specifications to meet the project
> needs. Perform customization/workflow as determined. Develop new workflows,
> active links, forms, and escalations in the Remedy suite.  Builds and
> executes unit test cases, as wells documents developer guides, training
> guides, user guides and support guides.  Provide support and Sustainment
> to the Remedy applications.  Researches and recommends technologies to
> improve Remedy applications.
>
> *Basic Qualifications:*
> • 3-5 years of Remedy development experience in 6.3 and 7.x.
>
> *Plus Qualifications*
>
> • Experience in developing in Crystal Reports.
>
> • Experience in Remedy Migrator
>
> • Experience with CMDB.
>
> • Integration of REMEDY with external systems using REMEDY APIs, web
> services, REMEDY Import etc.
> • Experience with Rational Clear Case for software configuration management
> and Rational Clear Quest for Change Defect Management
>
>
>
> 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*
> [image: View Josh Kitchen ([EMAIL PROTECTED]) LION TopLinked's profile on
> LinkedIn] 

Re: Populating Table field with sql query result

[Ravi]

James: I have been trying to do something similar. One question. If the 
table on which I want to run the sql query is on a different database, 
what do I have to do within Remedy so it can connect to a table in that 
database.


Thanks
Ravi
Russell, James C wrote:

**
Hello Victor;

I don't know that this is what you're looking for, but I run a series of sql 
queries in a single escalation to populate a 'current state' kinda form--I'm 
using one query per field; might not be the most effective way in the world, 
but it works.

This has MS SQL date conversions in--oracle is different and a bit more cryptic 
(IMO--I've got those around somewhere if you need 'em):

Here's a Set Fields example that works just fine:


Read Value for Field From: SQL
SQL Command:
SELECT COUNT(1) FROM Your_Form_Name WHERE (Create_Date >= DATEDIFF(s, 
'19700101', DATEADD(mm,-30,getdate( AND (rb_TicketType = 5)

If No Requests Match: Set fields to NULL
If Multiple Records Match: Use first matching

Fields:
  Name: cntTiks
  Value: $1$


...there's no reason in the world that you couldn't make a set fields with an 
sql statement like:

SELECT thing1, thing2, thing3, ... ,thingN FROM Your_Form WHERE Field_name = 
'char_value' OR Field_Name2 > 84600

(or whatever--could do joins and unions against multiple forms if necessary)

..and then the Names/values in the 'Fields' section of the set fields is like:

Name: Field1   Value: $1$
Name: Field2   Value: $2$
Name: Field3   Value: $3$
  :
  :
Name: FieldN   Value: $N$

When you're choosing a value for the field, the drop-down list will give you an 
option to choose a value x from the 'SQL Result Column,' where x is a number 
between 1 and N (the number of fields you're pulling in your select statement).

Erm. For whatever it's worth.

HTH
~james



  

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Victor
Sent: Sunday, May 18, 2008 12:47 PM
To: arslist@ARSLIST.ORG
Subject: Populating Table field with sql query result

Hello Listers,

It is possible to populate a table field with the result from an sql
query?
Any idea how this could be done?

Victor

___

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



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

  


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

Re: Oracle Index Performance

[patrick zandi]

the Trick with the Compound index is the fact that you must use the values
correctly.

http://helloworld.siteburg.com/content/databases/db1/ch09lev1sec3.html  <--
good example.

ay 22, 2008 at 12:49 PM, J.T. Shyman <[EMAIL PROTECTED]> wrote:

> **
>
> One more comment: You mentioned that all three fields are indexed. Are they
> included in a compound index (i.e. all three fields in one index) or are
> they in three separate indexes? You might (and I stress might) see some
> improvement in performance with a single index that contains all three
> fields.
>
>
>
> However, the != will still force a table scan I believe.
>
>
>
> --- J.T. Shyman
>
>
>   --
>
> *From:* Action Request System discussion list(ARSList) [mailto:
> [EMAIL PROTECTED] *On Behalf Of *Robert Halstead
> *Sent:* Thursday, May 22, 2008 12:38 PM
> *To:* arslist@ARSLIST.ORG
> *Subject:* Oracle Index Performance
>
>
>
> ** Ladies and Gents,
>
>
> We have been constantly trying to improve performance on a form with over 1
> million records in it by analyzing indexes, or clearing the statistics for
> the table in oracle.  The last thing we did was clear the statistics for our
> form BZ:Incident because for some reason searches in Remedy, even though we
> were searching on index fields, were not using the indexes in Oracle.  By
> clearing the statistics, I believe we're forcing oracle the use the indexes
> resulting in the searches .  However, searching on a field that is not
> indexed now performs a database time out error in Remedy.
>
> My question:  Where is the happy place?  When you guys analyze statistics,
> to what percent?  Also, how often do you find yourself analyzing indexes?
>
> On a related question, performing searches in Remedy using the != operator
> does not utilize the index for that specific field.  I'm performing a search
> on a form where 'Parent' = $NULL$ and 'Link Type' = $NULL$ and 'Incident ID'
> != $tmp_IncidentID$.  Essentially I'm wanting to return all tickets that are
> not associated with a parent and not return the incident I'm trying to
> link.
>
> How would I change this query so that I utilize the indexes?  The search
> seems to perform a full table scan against the table in oracle.  All three
> fields are indexed on the form.
>
> I sure that this is covered in the Performance and Tuning class, I just
> have yet to take it.
>
> Environment:
> AR System 6.3 Patch 20
> Oracle 9i
>
> --
> "A fool acts, regardless; knowing well that he is wrong. The ignoramus acts
> on only what he knows, but all that he knows.
> The ignoramus may be saved, but the fool knows that he is doomed."
>
> Robert Halstead __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...

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

Re: Oracle Index Performance

[patrick zandi]

Oh, forgot to mention:  set up an escalation to initially fill the values --
then use the workflow afterward.
a one time run.

On Thu, May 22, 2008 at 7:42 PM, patrick zandi <[EMAIL PROTECTED]> wrote:

> How about an extra field instead.
> Why not just add a Search "value". When the form is saved, (filter) and it
> meets the below Qual, Unset the field or set field to the value S1 or even
> use Selection Field Like I have.
>
> What I did was put in a Selection field
> Search  O Type 1  O Type 2  O Type 3  O Type 4
> Each selection field is on when it meets the qual for the query.
> (in this case they need to different)
> The when you do a query it is based on the = and not the !=
>
> -- Hope I am making sense.. It just depends on how many you need..
> Maybe a Character field with 2 values - Your own Index so to speak.
> Then you have 99 choices - which means no need for an index.
>
> Just a thought.
> It is just Workflow Dependent. I have used this before and it was amazingly
> fast.
>
> On Thu, May 22, 2008 at 12:38 PM, Robert Halstead <[EMAIL PROTECTED]>
> wrote:
>
>> ** Ladies and Gents,
>>
>> We have been constantly trying to improve performance on a form with over
>> 1 million records in it by analyzing indexes, or clearing the statistics for
>> the table in oracle.  The last thing we did was clear the statistics for our
>> form BZ:Incident because for some reason searches in Remedy, even though we
>> were searching on index fields, were not using the indexes in Oracle.  By
>> clearing the statistics, I believe we're forcing oracle the use the indexes
>> resulting in the searches .  However, searching on a field that is not
>> indexed now performs a database time out error in Remedy.
>>
>> My question:  Where is the happy place?  When you guys analyze statistics,
>> to what percent?  Also, how often do you find yourself analyzing indexes?
>>
>> On a related question, performing searches in Remedy using the != operator
>> does not utilize the index for that specific field.  I'm performing a search
>> on a form where 'Parent' = $NULL$ and 'Link Type' = $NULL$ and 'Incident ID'
>> != $tmp_IncidentID$.  Essentially I'm wanting to return all tickets that are
>> not associated with a parent and not return the incident I'm trying to
>> link.
>>
>> How would I change this query so that I utilize the indexes?  The search
>> seems to perform a full table scan against the table in oracle.  All three
>> fields are indexed on the form.
>>
>> I sure that this is covered in the Performance and Tuning class, I just
>> have yet to take it.
>>
>> Environment:
>> AR System 6.3 Patch 20
>> Oracle 9i
>>
>> --
>> "A fool acts, regardless; knowing well that he is wrong. The ignoramus
>> acts on only what he knows, but all that he knows.
>> The ignoramus may be saved, but the fool knows that he is doomed."
>>
>> Robert Halstead __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the
>> Answers Are" html___
>
>
>
>
> --
> Patrick Zandi
>
> Dev Technology Group --> www.devtechnology.com
> Exceeding your Expectations ! By Design...




-- 
Patrick Zandi

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

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

Re: Oracle Index Performance

[patrick zandi]

How about an extra field instead.
Why not just add a Search "value". When the form is saved, (filter) and it
meets the below Qual, Unset the field or set field to the value S1 or even
use Selection Field Like I have.

What I did was put in a Selection field
Search  O Type 1  O Type 2  O Type 3  O Type 4
Each selection field is on when it meets the qual for the query.
(in this case they need to different)
The when you do a query it is based on the = and not the !=

-- Hope I am making sense.. It just depends on how many you need..
Maybe a Character field with 2 values - Your own Index so to speak.
Then you have 99 choices - which means no need for an index.

Just a thought.
It is just Workflow Dependent. I have used this before and it was amazingly
fast.

On Thu, May 22, 2008 at 12:38 PM, Robert Halstead <[EMAIL PROTECTED]>
wrote:

> ** Ladies and Gents,
>
> We have been constantly trying to improve performance on a form with over 1
> million records in it by analyzing indexes, or clearing the statistics for
> the table in oracle.  The last thing we did was clear the statistics for our
> form BZ:Incident because for some reason searches in Remedy, even though we
> were searching on index fields, were not using the indexes in Oracle.  By
> clearing the statistics, I believe we're forcing oracle the use the indexes
> resulting in the searches .  However, searching on a field that is not
> indexed now performs a database time out error in Remedy.
>
> My question:  Where is the happy place?  When you guys analyze statistics,
> to what percent?  Also, how often do you find yourself analyzing indexes?
>
> On a related question, performing searches in Remedy using the != operator
> does not utilize the index for that specific field.  I'm performing a search
> on a form where 'Parent' = $NULL$ and 'Link Type' = $NULL$ and 'Incident ID'
> != $tmp_IncidentID$.  Essentially I'm wanting to return all tickets that are
> not associated with a parent and not return the incident I'm trying to
> link.
>
> How would I change this query so that I utilize the indexes?  The search
> seems to perform a full table scan against the table in oracle.  All three
> fields are indexed on the form.
>
> I sure that this is covered in the Performance and Tuning class, I just
> have yet to take it.
>
> Environment:
> AR System 6.3 Patch 20
> Oracle 9i
>
> --
> "A fool acts, regardless; knowing well that he is wrong. The ignoramus acts
> on only what he knows, but all that he knows.
> The ignoramus may be saved, but the fool knows that he is doomed."
>
> Robert Halstead __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the
> Answers Are" html___




-- 
Patrick Zandi

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

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

Re: ARS 7.1 Area LDAP config issue

[Joe DeSouza]

If you want to login to the Remedy server using the user tuser1, how do you 
enter the user name?
Joe



- Original Message 
From: Kevin Pulsen <[EMAIL PROTECTED]>
To: arslist@ARSLIST.ORG
Sent: Thursday, May 22, 2008 4:49:58 PM
Subject: Re: ARS 7.1 Area LDAP config issue

** 
Nope, that didn't work either

tuser1 is the account I am attempting to read AD with

testco.com is the domain

and tuser1 is located in ou=Support Desk,ou=Admins,ou=NETWORKOPS.

shouldn't it be something like cn=tuser1,ou,ou,dc ???

thanks Kevin P.




**
You are perhaps typing the wrong bind user name or typing the wrong password.. 
If it is really testco\NETWORKOPS\Admins\Support Desk\tuser1 try 
\\testco\NETWORKOPS\Admins\Support Desk\tuser1. Maybe its missing the double 
back slash in the beginning..
Joe


- Original Message 
From: Kevin Pulsen <[EMAIL PROTECTED]>
To: arslist@ARSLIST.ORG
Sent: Thursday, May 22, 2008 4:30:34 PM
Subject: ARS 7.1 Area LDAP config issue

** 
Hello all,

I'm trying to config the AREA LDAP form for Active Directory authentication, 
when a user login into the Remedy client.
I have followed the documentation from the integrating 7.10 guide and have the 
following values set in my AREA LDAP form -

Host Name* - tcdc1.testco.com

User Base* - dc=testco,dc=com

Port Number - 389

User Search Filter* - cn=$\USER$

Bind User - testco\NETWORKOPS\Admins\Support Desk\tuser1

Group Membership - None

Bind Password - * (no it's not really *'s)

Use Secure Socket Layer - No

Chase Referral - No

I have the EA RPC set to 390695 and Authentication Chain Mode set to ARS -AREA 
-OS

When I attempt to login as a predefined user (with an existing Remedy ID setup, 
no password) It fails and gives the following error in the arplugin.log -

  Bind: Invalid credentials (LDAPERR Code 49) 
80090308: LdapErr:

What am I missing for the AREA LDAP config?

Please help...

Thanks Kevin P.

 
__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: ITSM 7 Support Staff permissions

[McClure, Don]

Initial presentation: one particular user's CTM:People showed a
'Last Modified By'-value of other than expected parties.  Further, the record
and its corresponding user record lacked Application Permissions and
Support Group associations I know I added the evening before (and then
verified, by logging in as the user in question!).

Current symptom of the suspected behavior:  Out of 300-odd support staff
currently configured on our system, 43 CTM:People-records carry a
'last modified by' value OTHER than: either sys admins, or user him/herself.
I have not positively verified that another user is changing data---but too
many of us rely on 'last change'-type fields to verify a record's current 
status.
If values captured in 'CTM:People->More Details->Last Modified By' are accurate,
we do indeed have another 'gremlin' in the works.  Further--one particular
account shows 'last modified by' a support staffer who has no access to
see that CTM:People record at all!

Note, though:  I have created a 'roaming staff' account, associated it with
several companies/support groups, and not been able to actually deliberately
modify any other personal profiles myself.  We suspect there is a 'back door'
through Incident Management workflow which is allowing unintended field-value
modifications.

Don W. McClure, P.E.
Data Administrator & System Engineer
Computing & IT Center, Call Tracking Administration
University of North Texas, Denton
dwmac_at_unt.edu

"That which counts cannot necessarily be counted: that which can be counted 
will not always count."  -- Albert Einstein
-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of strauss
Sent: Tuesday, May 20, 2008 11:46 AM
To: arslist@ARSLIST.ORG
Subject: Re: ITSM 7 Support Staff permissions

I'm not sure yet how it was done, just that it was, and that the last
modified user on the profile that was altered was another support user
in the same company.

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 Lammey, Peter A.
> Sent: Tuesday, May 20, 2008 11:30 AM
> To: arslist@ARSLIST.ORG
> Subject: Re: ITSM 7 Support Staff permissions
>
> How are you able to do this?  I tried this with a simple support staff
> user and tried to go into People and see if I was logged in as that
> support staff user with just Incident User and Asset viewer rights but
> I could not alter anything (permissions, group membership included)
for
> other people except for the person's own profile.
>
> ITSM 7.02 patch 005
>
>
> Thanks
> Peter Lammey
> ESPN MIT Technical Services & Applications Management
> 860-766-4761
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:[EMAIL PROTECTED] On Behalf Of strauss
> Sent: Tuesday, May 20, 2008 12:09 PM
> To: arslist@ARSLIST.ORG
> Subject: ITSM 7 Support Staff permissions
>
> Has anyone run into an issue with ITSM 7 where it is entirely possible
> for a support staff user (Incident User, Asset Viewer, no Roles at
all,
> just company and group membership) in a company to remove all of the
> application permissions for another Incident user in the same group?
> One of the departments has already experienced this.  Remember how in
> ITSM 5.x and 6.x there were many different filters trapping who could
> update what fields in the SHR:People and User forms?  I guess they
left
> all of those out in ITSM 7.  We had thought that the Contact People
> permission controlled this, but apparently not since our admin
accounts
> are the only ones that have those.
>
> Has anyone dug into this enough to explain it?  As usual, the BMC docs
> on permissions and roles are not much help.
>
> Christopher Strauss, Ph.D.
> Call Tracking Administration Manager
> University of North Texas Computing & IT Center
>
>
___
> 
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum
> Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
>
> Please consider the environment before printing this e-mail.
>
>
___
> 
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

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

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

Re: Tomcat lockups under Windows (7.0.1 p6)

[Rick Westbrock]

Thanks to Tor and Ankur for the memory allocation suggestions, I will
proceed down that path and see if those changes (Tomcat & Java heap
size) resolve the issue. If not then I may try MT patch 4 as an
alternative.
 
 
Thanks all,
 
Rick



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Maynard,Tor T.
Sent: Thursday, May 22, 2008 8:13 AM
To: arslist@ARSLIST.ORG
Subject: Re: Tomcat lockups under Windows (7.0.1 p6)


** 
Now we're on ARS 7.1, but at the time of the issue we were on 7.0.1 (but
not sure what patch).  
We had (what I think is) a similar issue, and did get a response from
BMC.  
I'm going to copy it here.  Hope it helps:
 

You need to allocate more memory for tomcat, here are the details.
 
P R O B L E M:
The Tomcat application server crashes or a user finds an "Out of memory"
error in the log.
 
S O L U T I O N:
Boost the memory settings using one of the following solutions:
 
On Windows:
Choose Start > All Programs > Apache Tomcat 5.5 > Configure Tomcat.
In the dialog box that appears, click the Java tab.
Set the Initial Memory Pool option to 1024 MB.
Set the Maximum Memory Pool option to 1024 MB.
Restart Tomcat.

On Linux: 
Change the minimum and maximum heap size using the -Xms and -Xmx JVM
parameters, which are available in the catalina.sh file.  The new value
for CATALINA_OPTS should be as follows:
Set CATALINA_OPTS="-Xms1024m -Xmx1024m"
Restart Tomcat.



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Ankur Gulati
Sent: Thursday, May 22, 2008 12:42 AM
To: arslist@ARSLIST.ORG
Subject: Re: Tomcat lockups under Windows (7.0.1 p6)


** 
Hi Rick,
 
We had same issue with ARS 7.0.1 P5  and midtier 7.0.1 P5. We have an
open ticket with BMC and they don't seem to have a clue about it.
Downgraded midtier to P4, since then Tomcat is running smooth.
 
 
--
Ankur 




From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of VanAartsen, Christopher
Sent: 22 May 2008 05:25 AM
To: arslist@ARSLIST.ORG
Subject: Re: Tomcat lockups under Windows (7.0.1 p6)


** 

Having similar issues on 6.3 with Tomcat, but restarting our
Tomcat service fixes the problem.  Have you checked your Java Heap size?
That's my next move, looks to be the problem in the log files.

 

 





From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Rick Westbrock
Sent: Wednesday, May 21, 2008 6:40 PM
To: arslist@ARSLIST.ORG
Subject: Tomcat lockups under Windows (7.0.1 p6)

 

Hi all- 

Today for the second time in a two week span Tomcat on my
mid-tier has seemingly hung for no obvious reason. In each case the
login page would not even come up so I restarted the Tomcat service but
to no avail. Restarting the IIS service resolved the issue both times.
We had been running this environment for about two months with no issues
until a couple of weeks ago and the only change has been to deploy a new
web service that allows one of our portal applications to submit a
ticket into Remedy but there is no activity on the production server yet
since we're still testing in our development environment (where we
haven't seen this error at all). I have about a dozen users on the
mid-tier off and on during the day.

I searched the list and the Remedy KB but haven't seen anyone
with similar problems. Environment details are below, any suggestions
about where to start troubleshooting would be much appreciated.

 

Thanks, 

Rick 

 

Single Remedy application server: 
Windows Server 2003 SP 2 
IIS 6.0 
ARS 7.0.1 patch 6 
E-mail Engine 7.0.1 p6 
Mid-Tier 7.0.1 p6 
Tomcat 5.5 

Remote Database Server: 
Windows Server 2003 SP 2 
SQL Server 2000 (8.0.76 SP 3 Standard Edition) 

_ 
Rick Westbrock 
PETCO Telecom Engineer 
[EMAIL PROTECTED]   

 

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the
Answers Are" html___ 
This e-mail message and any attachments may contain 
legally privileged, confidential or proprietary Information, or 
information otherwise protected by law of ArvinMeritor, Inc., 
its affiliates, or third parties. This notice serves as marking
of 
its "Confidential" status as defined in any confidentiality 
agreements concerning the sender and recipient. If you are 
not the intended recipient(s), or the employee or agent 
responsible for delivery of this message to the intended 
recipient(s), you are hereby notified that

Re: ARS 7.1 Area LDAP config issue

[Mike Gould]

For the Bind User, we use: */*
For the User Search Filter, we use: *sAMAccountName=$\USER$* (this applies
to AD LDAP only I think)

Also, did you complete the ARDBC LDAP Configuration form settings too?  I
don't remember if that was required but we have that set too.

Regards,
Michael Gould
US House of Representatives

On Thu, May 22, 2008 at 5:13 PM, Grooms, Frederick W <
[EMAIL PROTECTED]> wrote:

> ** I've seen cases where you need to use the testco\tuser1 format as well.
>
> Is the error in the log after the ldap_simple_bind  for the tuser1 or after
> the user you are trying to log in as?  (You may need to set
> Plugin-Log-Level:400  in your config to get the detail info).
>
> If it is after the user login attempt you may have your filter incorrect.
> We use  sAMAccountName=$\USER$  for the filter.
>
>
> Fred
>
>  --
> *From:* Action Request System discussion list(ARSList) [mailto:
> [EMAIL PROTECTED] *On Behalf Of *J.T. Shyman
> *Sent:* Thursday, May 22, 2008 3:56 PM
>
> *To:* arslist@ARSLIST.ORG
> *Subject:* Re: ARS 7.1 Area LDAP config issue
>
>   **
>
> Kevin,
>
>
>
> Yes, the bind user should be in the same format as the User
> Base. That is: CN=,OU=,DC=,DC=
>
>
>
> Your AD admin, if that isn't yourself, should be able to give
> you the distinguished name for the user.
>
>
>
> --- J.T. Shyman
>
>
>  --
>
> *From:* Action Request System discussion list(ARSList) [mailto:
> [EMAIL PROTECTED] *On Behalf Of *Kevin Pulsen
> *Sent:* Thursday, May 22, 2008 4:50 PM
> *To:* arslist@ARSLIST.ORG
> *Subject:* Re: ARS 7.1 Area LDAP config issue
>
>
>
> **
>
> Nope, that didn't work either
>
> tuser1 is the account I am attempting to read AD with
>
> testco.com is the domain
>
> and tuser1 is located in ou=Support Desk,ou=Admins,ou=NETWORKOPS.
>
> shouldn't it be something like cn=tuser1,ou,ou,dc ???
>
> thanks Kevin P.
>
>
>
>
> **
> You are perhaps typing the wrong bind user name or typing the wrong
> password.. If it is really testco\NETWORKOPS\Admins\Support Desk\tuser1 try
> \\testco\NETWORKOPS\Admins\Support Desk\tuser1. Maybe its missing the
> double back slash in the beginning..
> Joe
>
>
> - Original Message 
> From: Kevin Pulsen <[EMAIL PROTECTED]>
> To: arslist@ARSLIST.ORG
> Sent: Thursday, May 22, 2008 4:30:34 PM
> Subject: ARS 7.1 Area LDAP config issue
>
> **
> Hello all,
>
> I'm trying to config the AREA LDAP form for Active Directory
> authentication, when a user login into the Remedy client.
> I have followed the documentation from the integrating 7.10 guide and have
> the following values set in my AREA LDAP form -
>
> Host Name* - tcdc1.testco.com
>
> User Base* - dc=testco,dc=com
>
> Port Number - 389
>
> User Search Filter* - cn=$\USER$
>
> Bind User - testco\NETWORKOPS\Admins\Support Desk\tuser1
>
> Group Membership - None
>
> Bind Password - * (no it's not really *'s)
>
> Use Secure Socket Layer - No
>
> Chase Referral - No
>
> I have the EA RPC set to 390695 and Authentication Chain Mode set to ARS
> -AREA -OS
>
> When I attempt to login as a predefined user (with an existing Remedy ID
> setup, no password) It fails and gives the following error in the
> arplugin.log -
>
>   Bind: Invalid credentials (LDAPERR Code 49)
> 80090308: LdapErr:
>
> What am I missing for the AREA LDAP config?
>
> Please help...
>
> Thanks Kevin P.
>
>
>  __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: ARS 7.1 Area LDAP config issue

[Grooms, Frederick W]

I've seen cases where you need to use the testco\tuser1 format as well.
 
Is the error in the log after the ldap_simple_bind  for the tuser1 or
after the user you are trying to log in as?  (You may need to set
Plugin-Log-Level:400  in your config to get the detail info).
 
If it is after the user login attempt you may have your filter
incorrect.  We use  sAMAccountName=$\USER$  for the filter.
 
 
Fred



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of J.T. Shyman
Sent: Thursday, May 22, 2008 3:56 PM
To: arslist@ARSLIST.ORG
Subject: Re: ARS 7.1 Area LDAP config issue


** 

Kevin,

 

Yes, the bind user should be in the same format as the User
Base. That is: CN=,OU=,DC=,DC=

 

Your AD admin, if that isn't yourself, should be able to
give you the distinguished name for the user.

 

--- J.T. Shyman

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kevin Pulsen
Sent: Thursday, May 22, 2008 4:50 PM
To: arslist@ARSLIST.ORG
Subject: Re: ARS 7.1 Area LDAP config issue

 

** 

Nope, that didn't work either

tuser1 is the account I am attempting to read AD with

testco.com is the domain

and tuser1 is located in ou=Support Desk,ou=Admins,ou=NETWORKOPS.

shouldn't it be something like cn=tuser1,ou,ou,dc ???

thanks Kevin P.




**
You are perhaps typing the wrong bind user name or typing the wrong
password.. If it is really testco\NETWORKOPS\Admins\Support Desk\tuser1
try \\testco\NETWORKOPS\Admins\Support
  Desk\tuser1.
Maybe its missing the double back slash in the beginning..
Joe


- Original Message 
From: Kevin Pulsen <[EMAIL PROTECTED]>
To: arslist@ARSLIST.ORG
Sent: Thursday, May 22, 2008 4:30:34 PM
Subject: ARS 7.1 Area LDAP config issue

** 
Hello all,

I'm trying to config the AREA LDAP form for Active Directory
authentication, when a user login into the Remedy client.
I have followed the documentation from the integrating 7.10 guide and
have the following values set in my AREA LDAP form -

Host Name* - tcdc1.testco.com

User Base* - dc=testco,dc=com

Port Number - 389

User Search Filter* - cn=$\USER$

Bind User - testco\NETWORKOPS\Admins\Support Desk\tuser1

Group Membership - None

Bind Password - * (no it's not really *'s)

Use Secure Socket Layer - No

Chase Referral - No

I have the EA RPC set to 390695 and Authentication Chain Mode set to ARS
-AREA -OS

When I attempt to login as a predefined user (with an existing Remedy ID
setup, no password) It fails and gives the following error in the
arplugin.log -

  Bind: Invalid credentials (LDAPERR Code 49)
80090308: LdapErr:

What am I missing for the AREA LDAP config?

Please help...

Thanks Kevin P.





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

Re: ARS 7.1 Area LDAP config issue

[J.T. Shyman]

Kevin,

 

Yes, the bind user should be in the same format as the User
Base. That is: CN=,OU=,DC=,DC=

 

Your AD admin, if that isn't yourself, should be able to give
you the distinguished name for the user.

 

--- J.T. Shyman

 

  _  

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kevin Pulsen
Sent: Thursday, May 22, 2008 4:50 PM
To: arslist@ARSLIST.ORG
Subject: Re: ARS 7.1 Area LDAP config issue

 

** 


Nope, that didn't work either

tuser1 is the account I am attempting to read AD with

testco.com is the domain

and tuser1 is located in ou=Support Desk,ou=Admins,ou=NETWORKOPS.

shouldn't it be something like cn=tuser1,ou,ou,dc ???

thanks Kevin P.




**
You are perhaps typing the wrong bind user name or typing the wrong
password.. If it is really testco\NETWORKOPS\Admins\Support Desk\tuser1 try
\\testco\NETWORKOPS\Admins\Support
  Desk\tuser1. Maybe
its missing the double back slash in the beginning..
Joe


- Original Message 
From: Kevin Pulsen <[EMAIL PROTECTED]>
To: arslist@ARSLIST.ORG
Sent: Thursday, May 22, 2008 4:30:34 PM
Subject: ARS 7.1 Area LDAP config issue

** 
Hello all,

I'm trying to config the AREA LDAP form for Active Directory authentication,
when a user login into the Remedy client.
I have followed the documentation from the integrating 7.10 guide and have
the following values set in my AREA LDAP form -

Host Name* - tcdc1.testco.com

User Base* - dc=testco,dc=com

Port Number - 389

User Search Filter* - cn=$\USER$

Bind User - testco\NETWORKOPS\Admins\Support Desk\tuser1

Group Membership - None

Bind Password - * (no it's not really *'s)

Use Secure Socket Layer - No

Chase Referral - No

I have the EA RPC set to 390695 and Authentication Chain Mode set to ARS
-AREA -OS

When I attempt to login as a predefined user (with an existing Remedy ID
setup, no password) It fails and gives the following error in the
arplugin.log -

  Bind: Invalid credentials (LDAPERR Code 49)
80090308: LdapErr:

What am I missing for the AREA LDAP config?

Please help...

Thanks Kevin P.


__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: ARS 7.1 Area LDAP config issue

[Kevin Pulsen]

**
Nope, that didn't work eithertuser1 is the account I am attempting to read AD withtestco.com is the domainand tuser1 is located in ou=Support Desk,ou=Admins,ou=NETWORKOPS.shouldn't it be something like cn=tuser1,ou,ou,dc ???thanks Kevin P.**You are perhaps typing the wrong bind user name or typing the wrong password.. 
If it is really testco\NETWORKOPS\Admins\Support Desk\tuser1 try \\testco\NETWORKOPS\Admins\Support 
Desk\tuser1. Maybe its missing the double back slash in the 
beginning..Joe- Original Message From: Kevin Pulsen 
<[EMAIL PROTECTED]>To: arslist@ARSLIST.ORGSent: Thursday, May 
22, 2008 4:30:34 PMSubject: ARS 7.1 Area LDAP config issue** 
Hello all,I'm trying to config the AREA LDAP form for Active 
Directory authentication, when a user login into the Remedy client.I have 
followed the documentation from the integrating 7.10 guide and have the 
following values set in my AREA LDAP form -Host Name* - 
tcdc1.testco.comUser Base* - dc=testco,dc=comPort Number - 
389User Search Filter* - cn=$\USER$Bind User - 
testco\NETWORKOPS\Admins\Support Desk\tuser1Group Membership - 
NoneBind Password - * (no it's not really *'s)Use 
Secure Socket Layer - NoChase Referral - NoI have the EA RPC set 
to 390695 and Authentication Chain Mode set to ARS -AREA -OSWhen I 
attempt to login as a predefined user (with an existing Remedy ID setup, no 
password) It fails and gives the following error in the arplugin.log 
-  Bind: Invalid credentials 
(LDAPERR Code 49) 80090308: LdapErr:What am I missing for the AREA LDAP 
config?Please help...Thanks Kevin P.

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

Re: ARS 7.1 Area LDAP config issue

[Joe DeSouza]

You are perhaps typing the wrong bind user name or typing the wrong password.. 
If it is really testco\NETWORKOPS\Admins\Support Desk\tuser1 try 
\\testco\NETWORKOPS\Admins\Support Desk\tuser1. Maybe its missing the double 
back slash in the beginning..
Joe


- Original Message 
From: Kevin Pulsen <[EMAIL PROTECTED]>
To: arslist@ARSLIST.ORG
Sent: Thursday, May 22, 2008 4:30:34 PM
Subject: ARS 7.1 Area LDAP config issue

** 
Hello all,

I'm trying to config the AREA LDAP form for Active Directory authentication, 
when a user login into the Remedy client.
I have followed the documentation from the integrating 7.10 guide and have the 
following values set in my AREA LDAP form -

Host Name* - tcdc1.testco.com

User Base* - dc=testco,dc=com

Port Number - 389

User Search Filter* - cn=$\USER$

Bind User - testco\NETWORKOPS\Admins\Support Desk\tuser1

Group Membership - None

Bind Password - * (no it's not really *'s)

Use Secure Socket Layer - No

Chase Referral - No

I have the EA RPC set to 390695 and Authentication Chain Mode set to ARS -AREA 
-OS

When I attempt to login as a predefined user (with an existing Remedy ID setup, 
no password) It fails and gives the following error in the arplugin.log -

  Bind: Invalid credentials (LDAPERR Code 49) 
80090308: LdapErr:

What am I missing for the AREA LDAP config?

Please help...

Thanks Kevin P.
 
__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: Populating Table field with sql query result

[Russell, James C]

**
Hello Victor;

I don't know that this is what you're looking for, but I run a series of sql 
queries in a single escalation to populate a 'current state' kinda form--I'm 
using one query per field; might not be the most effective way in the world, 
but it works.

This has MS SQL date conversions in--oracle is different and a bit more cryptic 
(IMO--I've got those around somewhere if you need 'em):

Here's a Set Fields example that works just fine:


Read Value for Field From: SQL
SQL Command:
SELECT COUNT(1) FROM Your_Form_Name WHERE (Create_Date >= DATEDIFF(s, 
'19700101', DATEADD(mm,-30,getdate( AND (rb_TicketType = 5)

If No Requests Match: Set fields to NULL
If Multiple Records Match: Use first matching

Fields:
  Name: cntTiks
  Value: $1$


...there's no reason in the world that you couldn't make a set fields with an 
sql statement like:

SELECT thing1, thing2, thing3, ... ,thingN FROM Your_Form WHERE Field_name = 
'char_value' OR Field_Name2 > 84600

(or whatever--could do joins and unions against multiple forms if necessary)

..and then the Names/values in the 'Fields' section of the set fields is like:

Name: Field1   Value: $1$
Name: Field2   Value: $2$
Name: Field3   Value: $3$
  :
  :
Name: FieldN   Value: $N$

When you're choosing a value for the field, the drop-down list will give you an 
option to choose a value x from the 'SQL Result Column,' where x is a number 
between 1 and N (the number of fields you're pulling in your select statement).

Erm. For whatever it's worth.

HTH
~james



> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:[EMAIL PROTECTED] On Behalf Of Victor
> Sent: Sunday, May 18, 2008 12:47 PM
> To: arslist@ARSLIST.ORG
> Subject: Populating Table field with sql query result
>
> Hello Listers,
>
> It is possible to populate a table field with the result from an sql
> query?
> Any idea how this could be done?
>
> Victor
>
> ___
> 
> 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"

ARS 7.1 Area LDAP config issue

[Kevin Pulsen]

**
Hello all,I'm trying to config the AREA LDAP form for Active Directory authentication, when a user login into the Remedy client.I have followed the documentation from the integrating 7.10 guide and have the following values set in my AREA LDAP form -Host Name* - tcdc1.testco.comUser Base* - dc=testco,dc=comPort Number - 389User Search Filter* - cn=$\USER$Bind User - testco\NETWORKOPS\Admins\Support Desk\tuser1Group Membership - NoneBind Password - * (no it's not really *'s)Use Secure Socket Layer - NoChase Referral - NoI have the EA RPC set to 390695 and Authentication Chain Mode set to ARS -AREA -OSWhen I attempt to login as a predefined user (with an existing Remedy ID setup, no password) It fails and gives the following error in the arplugin.log
 -  Bind: Invalid credentials (LDAPERR Code 49) 80090308: LdapErr:What am I missing for the AREA LDAP config?Please help...Thanks Kevin P.

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

Re: Oracle Index Performance

[Axton]

!= will typically cause a table scan of some type; it could be a
partial table scan (of a small number of rows) or a full table scan,
depending on how Oracle breaks down and processes the query.

Axton

On Thu, May 22, 2008 at 12:49 PM, J.T. Shyman <[EMAIL PROTECTED]> wrote:
> **
>
> One more comment: You mentioned that all three fields are indexed. Are they
> included in a compound index (i.e. all three fields in one index) or are
> they in three separate indexes? You might (and I stress might) see some
> improvement in performance with a single index that contains all three
> fields.
>
>
>
> However, the != will still force a table scan I believe.
>
>
>
> --- J.T. Shyman
>
>
>
> 
>
> From: Action Request System discussion list(ARSList)
> [mailto:[EMAIL PROTECTED] On Behalf Of Robert Halstead
> Sent: Thursday, May 22, 2008 12:38 PM
> To: arslist@ARSLIST.ORG
> Subject: Oracle Index Performance
>
>
>
> ** Ladies and Gents,
>
> We have been constantly trying to improve performance on a form with over 1
> million records in it by analyzing indexes, or clearing the statistics for
> the table in oracle.  The last thing we did was clear the statistics for our
> form BZ:Incident because for some reason searches in Remedy, even though we
> were searching on index fields, were not using the indexes in Oracle.  By
> clearing the statistics, I believe we're forcing oracle the use the indexes
> resulting in the searches .  However, searching on a field that is not
> indexed now performs a database time out error in Remedy.
>
> My question:  Where is the happy place?  When you guys analyze statistics,
> to what percent?  Also, how often do you find yourself analyzing indexes?
>
> On a related question, performing searches in Remedy using the != operator
> does not utilize the index for that specific field.  I'm performing a search
> on a form where 'Parent' = $NULL$ and 'Link Type' = $NULL$ and 'Incident ID'
> != $tmp_IncidentID$.  Essentially I'm wanting to return all tickets that are
> not associated with a parent and not return the incident I'm trying to
> link.
>
> How would I change this query so that I utilize the indexes?  The search
> seems to perform a full table scan against the table in oracle.  All three
> fields are indexed on the form.
>
> I sure that this is covered in the Performance and Tuning class, I just have
> yet to take it.
>
> Environment:
> AR System 6.3 Patch 20
> Oracle 9i
>
> --
> "A fool acts, regardless; knowing well that he is wrong. The ignoramus acts
> on only what he knows, but all that he knows.
> The ignoramus may be saved, but the fool knows that he is doomed."
>
> Robert Halstead __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: Oracle Index Performance

[Axton]

Create a flag field on the form, then use a filter to set it.  The
field would default to 0, then be set to 1 by a filter if 'Parent' =
$NULL$ and 'Link Type' = $NULL$ and 'Incident ID' != $tmp_IncidentID$.
 You could then index and query on this field.  It's a crappy
solution, but the best available option I see with the tools
available.  YMMV depending on the cardinality of the resulting data.

"The search seems to perform a full table scan against the table..."

Learn how to use the autotrace features of sql*plus.
http://asktom.oracle.com/tkyte/article1/autotrace.html

If a partial table scan on 1m records causes a timeout, you may want
to evaluate the performance of your db and how much storage the table
is actually using.  How is the table structured?  Does it contain
lobs, does it have a lot of columns, etc.  These are design decisions
that may result in poor performance.

Axton

On Thu, May 22, 2008 at 12:38 PM, Robert Halstead <[EMAIL PROTECTED]> wrote:
> ** Ladies and Gents,
>
> We have been constantly trying to improve performance on a form with over 1
> million records in it by analyzing indexes, or clearing the statistics for
> the table in oracle.  The last thing we did was clear the statistics for our
> form BZ:Incident because for some reason searches in Remedy, even though we
> were searching on index fields, were not using the indexes in Oracle.  By
> clearing the statistics, I believe we're forcing oracle the use the indexes
> resulting in the searches .  However, searching on a field that is not
> indexed now performs a database time out error in Remedy.
>
> My question:  Where is the happy place?  When you guys analyze statistics,
> to what percent?  Also, how often do you find yourself analyzing indexes?
>
> On a related question, performing searches in Remedy using the != operator
> does not utilize the index for that specific field.  I'm performing a search
> on a form where 'Parent' = $NULL$ and 'Link Type' = $NULL$ and 'Incident ID'
> != $tmp_IncidentID$.  Essentially I'm wanting to return all tickets that are
> not associated with a parent and not return the incident I'm trying to
> link.
>
> How would I change this query so that I utilize the indexes?  The search
> seems to perform a full table scan against the table in oracle.  All three
> fields are indexed on the form.
>
> I sure that this is covered in the Performance and Tuning class, I just have
> yet to take it.
>
> Environment:
> AR System 6.3 Patch 20
> Oracle 9i

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

Re: Populating Table field with sql query result

[Carey Matthew Black]

Victor,

It is not the same as an ARS table field... but

What if you write workflow that walks the data and builds a dynamic
HTML page that is displayed in a View field?
(Which by the way is basically what the CI viewer does, only it uses a
Data Visualization Field which has a few more bells and whistles than
a plain old View field(iframe).)

Do you think this approach could work for the desired UI?

-- 
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 Thu, May 22, 2008 at 5:44 AM, Victor <[EMAIL PROTECTED]> wrote:
> On Sunday 18 of May 2008 22:39:03 Grooms, Frederick W wrote:
>> Have your SQL Query populate a table in the database and have a View
>> form pointing to that table.
>>
>> Fred
>>
>> -Original Message-
>> From: Action Request System discussion list(ARSList)
>> [mailto:[EMAIL PROTECTED] On Behalf Of Victor
>> Sent: Sunday, May 18, 2008 12:47 PM
>> To: arslist@ARSLIST.ORG
>> Subject: Populating Table field with sql query result
>>
>> Hello Listers,
>>
>> It is possible to populate a table field with the result from an sql
>> query?
>> Any idea how this could be done?
>>
>> Victor
>>
>> ___
>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>> Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
>
> Thank you Fred - but I'm afraid this approach is unacceptable.
>
> The idea is to introduce a (sort of) summary button on system class form. On
> clicking this button a summary page  describing this particular CI together
> its dependencies,components and components of its dependencies (in a single
> Table form) will be displayed.
>
>
> Remedy ARS 6.3
> Oracle 9i database
> MS IIS
> Windows 2000
>
> Any suggestions please?
>
>
> Victor
>
> ___
> 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: SLM 7.1 web dashboard images missing - RESOLVED

[William Rentfrow]

Thanks for the heads up - one of the next major steps is to switch
everything to https and secure it all



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of strauss
Sent: Thursday, May 22, 2008 12:19 PM
To: arslist@ARSLIST.ORG
Subject: Re: SLM 7.1 web dashboard images missing - RESOLVED


** 

Okay - and I misspoke on which manual it was in, didn't I - Installation
pg 61-62.  I had not hit what you did since I have no load balancer, and
I did have to specify port :8080 for tomcat.  Speaking of ports, if your
mid-tier is under SSL and tomcat is forwarding to 8443, it is impossible
to set the dashboard mid-tier value to https:// - only http:// is a
valid entry. It still works if tomcat is forwarding 8080 to 8443, but
you do get the mixed security message whenever you open the dashboard.
Based on this, and the other problems with the dashboard (Related
Measurements table field disappears on Service Target dashboard in
mid-tier, it's pretty obvious that no one actually tested this stuff
before releasing it.

 

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 William Rentfrow
Sent: Thursday, May 22, 2008 11:59 AM
To: arslist@ARSLIST.ORG
Subject: Re: SLM 7.1 web dashboard images missing - RESOLVED

 

** 

Actually - you were very close.

 

I made the mistake of following the directions.  They said "Use the
actual server name".  I did that along with port (ie,
http://server:port/).  I also tried it without the port.

 

What it really wanted was the load balancer name without the port.  So
http://loadbalancername/ worked.

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of strauss
Sent: Thursday, May 22, 2008 11:32 AM
To: arslist@ARSLIST.ORG
Subject: Re: SLM 7.1 web dashboard images missing

** 

There is a step in the documentation (configuration pg 61) where you
have to specify a path in SLM:ConfigPreferences to the mid-tier web
server in order for them to show up.

 

Don't get too excited, however, since there is still one entire table in
the Service Targets dashboard that does not show up in mid-tier, only in
the User Tool.  They logged a defect for me, but maybe it is a blessing
since another defect in the same table opens the incorrect incident for
the one displayed - they are drilling down on entry id instead of
incident id.

 

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 William Rentfrow
Sent: Thursday, May 22, 2008 10:53 AM
To: arslist@ARSLIST.ORG
Subject: SLM 7.1 web dashboard images missing

 

** 

We are using SLM 7.1 - on the WUT everything is fine.

 

On the web none of the images in the tables on the dashboard show up.
They simply just show the red X's you get from any webpage where the
image is missing.  Specifically these are the images that show up in the
"Status" and "Previous" columns and there are two possible images -
Breached and Compliant.

 

All of the images on the rest of the page show correctly.

 

Two questions:

 

1.) Are these images supposed to show in the SLM Application object
under the Support Files tab?  If so, what are they called?

2.) Do they work for anyone else using SLM 7.1 Dashboard on the web?

 

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___ 

__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: Chnage Management email notification issue

[T. Dee]

We had a similar issue, that being when you create a Change and you
add Task(s), however, at the last minute you decided NOT to save the
Change record ALL the Task(s) associcated with the Change are set to
Status = Closed / Status Reason = Canceled.  This results in Orphan
Records.

According to Remedy this is by design.  I'm not exactly sure why
Orphan records would be by design, but that is what I am told.

If you click on the "Open" button to open the Change from the Orphan
Task it says something like "Requester is not available" - this is not
clear.

The Change record does not exist, but all your Task(s) do.

As well take note if you delete your Change record it does not warn
you about the Task(s), the result will be your Change record will be
delete, but your Task(s) will still exist - orphan records.




On 5/22/08, Wirasat Siddiqi <[EMAIL PROTECTED]> wrote:
> **
>
> We are noticing that if someone fill out change request form using select
> template options but for some reason changes his mind and does not submit
> the change. In that case, tasks are getting generated and get closed out.
> However, it is sending out email notification to some of the groups that
> have assigned tasks. It should not send email notification when change
> ticket was not even submitted.
>
> Here are the environments we are using:
>
> OS: Linux SUSE 10
>
> Database: Oracle 10g
>
> AR Server: 7.1 Patch 1
>
> ITSM: 7.0.03 Patch 7
>
>
>
> Thanks,Wirasat __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: SLM 7.1 web dashboard images missing - RESOLVED

[strauss]

Okay - and I misspoke on which manual it was in, didn't I - Installation
pg 61-62.  I had not hit what you did since I have no load balancer, and
I did have to specify port :8080 for tomcat.  Speaking of ports, if your
mid-tier is under SSL and tomcat is forwarding to 8443, it is impossible
to set the dashboard mid-tier value to https:// - only http:// is a
valid entry. It still works if tomcat is forwarding 8080 to 8443, but
you do get the mixed security message whenever you open the dashboard.
Based on this, and the other problems with the dashboard (Related
Measurements table field disappears on Service Target dashboard in
mid-tier, it's pretty obvious that no one actually tested this stuff
before releasing it.

 

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 William Rentfrow
Sent: Thursday, May 22, 2008 11:59 AM
To: arslist@ARSLIST.ORG
Subject: Re: SLM 7.1 web dashboard images missing - RESOLVED

 

** 

Actually - you were very close.

 

I made the mistake of following the directions.  They said "Use the
actual server name".  I did that along with port (ie,
http://server:port/).  I also tried it without the port.

 

What it really wanted was the load balancer name without the port.  So
http://loadbalancername/ worked.

 

  _  

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of strauss
Sent: Thursday, May 22, 2008 11:32 AM
To: arslist@ARSLIST.ORG
Subject: Re: SLM 7.1 web dashboard images missing

** 

There is a step in the documentation (configuration pg 61) where you
have to specify a path in SLM:ConfigPreferences to the mid-tier web
server in order for them to show up.

 

Don't get too excited, however, since there is still one entire table in
the Service Targets dashboard that does not show up in mid-tier, only in
the User Tool.  They logged a defect for me, but maybe it is a blessing
since another defect in the same table opens the incorrect incident for
the one displayed - they are drilling down on entry id instead of
incident id.

 

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 William Rentfrow
Sent: Thursday, May 22, 2008 10:53 AM
To: arslist@ARSLIST.ORG
Subject: SLM 7.1 web dashboard images missing

 

** 

We are using SLM 7.1 - on the WUT everything is fine.

 

On the web none of the images in the tables on the dashboard show up.
They simply just show the red X's you get from any webpage where the
image is missing.  Specifically these are the images that show up in the
"Status" and "Previous" columns and there are two possible images -
Breached and Compliant.

 

All of the images on the rest of the page show correctly.

 

Two questions:

 

1.) Are these images supposed to show in the SLM Application object
under the Support Files tab?  If so, what are they called?

2.) Do they work for anyone else using SLM 7.1 Dashboard on the web?

 

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___ 


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

Chnage Management email notification issue

[Wirasat Siddiqi]

We are noticing that if someone fill out change request form using select
template options but for some reason changes his mind and does not submit
the change. In that case, tasks are getting generated and get closed out.
However, it is sending out email notification to some of the groups that
have assigned tasks. It should not send email notification when change
ticket was not even submitted.

Here are the environments we are using:

OS: Linux SUSE 10

Database: Oracle 10g

AR Server: 7.1 Patch 1

ITSM: 7.0.03 Patch 7



Thanks,
Wirasat

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

Re: Oracle Index Performance

[Robert Halstead]

All three fields are separate indexes.  Guess it will just be one of those
searches that won't be instantaneous.  Funny thing though.  Right now, since
we clear the statistics, the search is pretty instantaneous.  By adding the
statistics, the search is fairly slow.  Go figure.

Any answers on the first part?

On Thu, May 22, 2008 at 10:49 AM, J.T. Shyman <[EMAIL PROTECTED]> wrote:

> **
>
> One more comment: You mentioned that all three fields are indexed. Are they
> included in a compound index (i.e. all three fields in one index) or are
> they in three separate indexes? You might (and I stress might) see some
> improvement in performance with a single index that contains all three
> fields.
>
>
>
> However, the != will still force a table scan I believe.
>
>
>
> --- J.T. Shyman
>
>
>   --
>
> *From:* Action Request System discussion list(ARSList) [mailto:
> [EMAIL PROTECTED] *On Behalf Of *Robert Halstead
> *Sent:* Thursday, May 22, 2008 12:38 PM
> *To:* arslist@ARSLIST.ORG
> *Subject:* Oracle Index Performance
>
>
>
> ** Ladies and Gents,
>
>
> We have been constantly trying to improve performance on a form with over 1
> million records in it by analyzing indexes, or clearing the statistics for
> the table in oracle.  The last thing we did was clear the statistics for our
> form BZ:Incident because for some reason searches in Remedy, even though we
> were searching on index fields, were not using the indexes in Oracle.  By
> clearing the statistics, I believe we're forcing oracle the use the indexes
> resulting in the searches .  However, searching on a field that is not
> indexed now performs a database time out error in Remedy.
>
> My question:  Where is the happy place?  When you guys analyze statistics,
> to what percent?  Also, how often do you find yourself analyzing indexes?
>
> On a related question, performing searches in Remedy using the != operator
> does not utilize the index for that specific field.  I'm performing a search
> on a form where 'Parent' = $NULL$ and 'Link Type' = $NULL$ and 'Incident ID'
> != $tmp_IncidentID$.  Essentially I'm wanting to return all tickets that are
> not associated with a parent and not return the incident I'm trying to
> link.
>
> How would I change this query so that I utilize the indexes?  The search
> seems to perform a full table scan against the table in oracle.  All three
> fields are indexed on the form.
>
> I sure that this is covered in the Performance and Tuning class, I just
> have yet to take it.
>
> Environment:
> AR System 6.3 Patch 20
> Oracle 9i
>
> --
> "A fool acts, regardless; knowing well that he is wrong. The ignoramus acts
> on only what he knows, but all that he knows.
> The ignoramus may be saved, but the fool knows that he is doomed."
>
> Robert Halstead __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the
> Answers Are" html___
>  __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
> html___
>



-- 
"A fool acts, regardless; knowing well that he is wrong. The ignoramus acts
on only what he knows, but all that he knows.
The ignoramus may be saved, but the fool knows that he is doomed."

Robert Halstead

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

Re: SLM 7.1 web dashboard images missing - RESOLVED

[William Rentfrow]

Actually - you were very close.
 
I made the mistake of following the directions.  They said "Use the
actual server name".  I did that along with port (ie,
http://server:port/).  I also tried it without the port.
 
What it really wanted was the load balancer name without the port.  So
http://loadbalancername/ worked.



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of strauss
Sent: Thursday, May 22, 2008 11:32 AM
To: arslist@ARSLIST.ORG
Subject: Re: SLM 7.1 web dashboard images missing


** 

There is a step in the documentation (configuration pg 61) where you
have to specify a path in SLM:ConfigPreferences to the mid-tier web
server in order for them to show up.

 

Don't get too excited, however, since there is still one entire table in
the Service Targets dashboard that does not show up in mid-tier, only in
the User Tool.  They logged a defect for me, but maybe it is a blessing
since another defect in the same table opens the incorrect incident for
the one displayed - they are drilling down on entry id instead of
incident id.

 

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 William Rentfrow
Sent: Thursday, May 22, 2008 10:53 AM
To: arslist@ARSLIST.ORG
Subject: SLM 7.1 web dashboard images missing

 

** 

We are using SLM 7.1 - on the WUT everything is fine.

 

On the web none of the images in the tables on the dashboard show up.
They simply just show the red X's you get from any webpage where the
image is missing.  Specifically these are the images that show up in the
"Status" and "Previous" columns and there are two possible images -
Breached and Compliant.

 

All of the images on the rest of the page show correctly.

 

Two questions:

 

1.) Are these images supposed to show in the SLM Application object
under the Support Files tab?  If so, what are they called?

2.) Do they work for anyone else using SLM 7.1 Dashboard on the web?

 

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___ 

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

Re: Oracle Index Performance

[J.T. Shyman]

One more comment: You mentioned that all three fields are indexed. Are they
included in a compound index (i.e. all three fields in one index) or are
they in three separate indexes? You might (and I stress might) see some
improvement in performance with a single index that contains all three
fields.

 

However, the != will still force a table scan I believe.

 

--- J.T. Shyman

 

  _  

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Robert Halstead
Sent: Thursday, May 22, 2008 12:38 PM
To: arslist@ARSLIST.ORG
Subject: Oracle Index Performance

 

** Ladies and Gents,

We have been constantly trying to improve performance on a form with over 1
million records in it by analyzing indexes, or clearing the statistics for
the table in oracle.  The last thing we did was clear the statistics for our
form BZ:Incident because for some reason searches in Remedy, even though we
were searching on index fields, were not using the indexes in Oracle.  By
clearing the statistics, I believe we're forcing oracle the use the indexes
resulting in the searches .  However, searching on a field that is not
indexed now performs a database time out error in Remedy.

My question:  Where is the happy place?  When you guys analyze statistics,
to what percent?  Also, how often do you find yourself analyzing indexes?

On a related question, performing searches in Remedy using the != operator
does not utilize the index for that specific field.  I'm performing a search
on a form where 'Parent' = $NULL$ and 'Link Type' = $NULL$ and 'Incident ID'
!= $tmp_IncidentID$.  Essentially I'm wanting to return all tickets that are
not associated with a parent and not return the incident I'm trying to link.


How would I change this query so that I utilize the indexes?  The search
seems to perform a full table scan against the table in oracle.  All three
fields are indexed on the form.

I sure that this is covered in the Performance and Tuning class, I just have
yet to take it.

Environment:
AR System 6.3 Patch 20
Oracle 9i

-- 
"A fool acts, regardless; knowing well that he is wrong. The ignoramus acts
on only what he knows, but all that he knows.
The ignoramus may be saved, but the fool knows that he is doomed."

Robert Halstead __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: Oracle Index Performance

[J.T. Shyman]

I can answer part of this: Relational databases won't use an index with a
"not equal" query.

 

--- J.T. Shyman

 

  _  

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Robert Halstead
Sent: Thursday, May 22, 2008 12:38 PM
To: arslist@ARSLIST.ORG
Subject: Oracle Index Performance

 

** Ladies and Gents,

We have been constantly trying to improve performance on a form with over 1
million records in it by analyzing indexes, or clearing the statistics for
the table in oracle.  The last thing we did was clear the statistics for our
form BZ:Incident because for some reason searches in Remedy, even though we
were searching on index fields, were not using the indexes in Oracle.  By
clearing the statistics, I believe we're forcing oracle the use the indexes
resulting in the searches .  However, searching on a field that is not
indexed now performs a database time out error in Remedy.

My question:  Where is the happy place?  When you guys analyze statistics,
to what percent?  Also, how often do you find yourself analyzing indexes?

On a related question, performing searches in Remedy using the != operator
does not utilize the index for that specific field.  I'm performing a search
on a form where 'Parent' = $NULL$ and 'Link Type' = $NULL$ and 'Incident ID'
!= $tmp_IncidentID$.  Essentially I'm wanting to return all tickets that are
not associated with a parent and not return the incident I'm trying to link.


How would I change this query so that I utilize the indexes?  The search
seems to perform a full table scan against the table in oracle.  All three
fields are indexed on the form.

I sure that this is covered in the Performance and Tuning class, I just have
yet to take it.

Environment:
AR System 6.3 Patch 20
Oracle 9i

-- 
"A fool acts, regardless; knowing well that he is wrong. The ignoramus acts
on only what he knows, but all that he knows.
The ignoramus may be saved, but the fool knows that he is doomed."

Robert Halstead __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: Oracle Index Performance

[Rick Cook]

NOT searches (including !=) will result in a table scan.  Searches using "=
$NULL$" will also result in a table scan.

That being said, I don't see a better way to structure your query and still
get the data you want.

Rick

On Thu, May 22, 2008 at 9:38 AM, Robert Halstead <[EMAIL PROTECTED]>
wrote:

> ** Ladies and Gents,
>
> We have been constantly trying to improve performance on a form with over 1
> million records in it by analyzing indexes, or clearing the statistics for
> the table in oracle.  The last thing we did was clear the statistics for our
> form BZ:Incident because for some reason searches in Remedy, even though we
> were searching on index fields, were not using the indexes in Oracle.  By
> clearing the statistics, I believe we're forcing oracle the use the indexes
> resulting in the searches .  However, searching on a field that is not
> indexed now performs a database time out error in Remedy.
>
> My question:  Where is the happy place?  When you guys analyze statistics,
> to what percent?  Also, how often do you find yourself analyzing indexes?
>
> On a related question, performing searches in Remedy using the != operator
> does not utilize the index for that specific field.  I'm performing a search
> on a form where 'Parent' = $NULL$ and 'Link Type' = $NULL$ and 'Incident ID'
> != $tmp_IncidentID$.  Essentially I'm wanting to return all tickets that are
> not associated with a parent and not return the incident I'm trying to
> link.
>
> How would I change this query so that I utilize the indexes?  The search
> seems to perform a full table scan against the table in oracle.  All three
> fields are indexed on the form.
>
> I sure that this is covered in the Performance and Tuning class, I just
> have yet to take it.
>
> Environment:
> AR System 6.3 Patch 20
> Oracle 9i
>
> --
> "A fool acts, regardless; knowing well that he is wrong. The ignoramus acts
> on only what he knows, but all that he knows.
> The ignoramus may be saved, but the fool knows that he is doomed."
>
> Robert Halstead __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"

Oracle Index Performance

[Robert Halstead]

Ladies and Gents,

We have been constantly trying to improve performance on a form with over 1
million records in it by analyzing indexes, or clearing the statistics for
the table in oracle.  The last thing we did was clear the statistics for our
form BZ:Incident because for some reason searches in Remedy, even though we
were searching on index fields, were not using the indexes in Oracle.  By
clearing the statistics, I believe we're forcing oracle the use the indexes
resulting in the searches .  However, searching on a field that is not
indexed now performs a database time out error in Remedy.

My question:  Where is the happy place?  When you guys analyze statistics,
to what percent?  Also, how often do you find yourself analyzing indexes?

On a related question, performing searches in Remedy using the != operator
does not utilize the index for that specific field.  I'm performing a search
on a form where 'Parent' = $NULL$ and 'Link Type' = $NULL$ and 'Incident ID'
!= $tmp_IncidentID$.  Essentially I'm wanting to return all tickets that are
not associated with a parent and not return the incident I'm trying to
link.

How would I change this query so that I utilize the indexes?  The search
seems to perform a full table scan against the table in oracle.  All three
fields are indexed on the form.

I sure that this is covered in the Performance and Tuning class, I just have
yet to take it.

Environment:
AR System 6.3 Patch 20
Oracle 9i

-- 
"A fool acts, regardless; knowing well that he is wrong. The ignoramus acts
on only what he knows, but all that he knows.
The ignoramus may be saved, but the fool knows that he is doomed."

Robert Halstead

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

Re: SLM 7.1 web dashboard images missing

[strauss]

There is a step in the documentation (configuration pg 61) where you
have to specify a path in SLM:ConfigPreferences to the mid-tier web
server in order for them to show up.

 

Don't get too excited, however, since there is still one entire table in
the Service Targets dashboard that does not show up in mid-tier, only in
the User Tool.  They logged a defect for me, but maybe it is a blessing
since another defect in the same table opens the incorrect incident for
the one displayed - they are drilling down on entry id instead of
incident id.

 

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 William Rentfrow
Sent: Thursday, May 22, 2008 10:53 AM
To: arslist@ARSLIST.ORG
Subject: SLM 7.1 web dashboard images missing

 

** 

We are using SLM 7.1 - on the WUT everything is fine.

 

On the web none of the images in the tables on the dashboard show up.
They simply just show the red X's you get from any webpage where the
image is missing.  Specifically these are the images that show up in the
"Status" and "Previous" columns and there are two possible images -
Breached and Compliant.

 

All of the images on the rest of the page show correctly.

 

Two questions:

 

1.) Are these images supposed to show in the SLM Application object
under the Support Files tab?  If so, what are they called?

2.) Do they work for anyone else using SLM 7.1 Dashboard on the web?

 

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___ 


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

Re: Publishing Web services crashes the server

[Pascale Boyer]

Thanks Walter ... Not reassuring :(

This was working before we changed patch. But I don't remember if we were 
on patch 2 or 3 at the time.

When I do the same Web service but using the OpGet method instead of the 
OpGetList, it works. 
But I need this to return N entries not just one.


Pascale Boyer




"Walters, Mark" <[EMAIL PROTECTED]> 
Envoyé par : "Action Request System discussion list(ARSList)" 

2008-05-22 11:55
Veuillez répondre à
arslist@ARSLIST.ORG


A
arslist@ARSLIST.ORG
cc

Objet
Re: Publishing Web services crashes the server






** 
The stack trace matches a server defect we have logged (SW00288690).  It 
looks like the fix is going to be in 7.0.1 patch 8, tentatively expected 
at the end of June.
 
Mark Walters
 
The opinions, statements, and/or suggested courses of action expressed in 
this E-mail do not necessarily reflect those of BMC Software, Inc.  My 
voluntary participation in this forum is not intended to convey a role as 
a spokesperson, liaison or support representative for BMC Software, Inc.
 
 
 
From: Action Request System discussion list(ARSList) 
[mailto:[EMAIL PROTECTED] On Behalf Of Pascale Boyer
Sent: 22 May 2008 15:50
To: arslist@ARSLIST.ORG
Subject: Publishing Web services crashes the server
 
** 
Hi all, 

We are having an issue with a Web service.  I've been working on this 
since Tuesday. Can't find any reasons, but I am NO web gurue. So I really 
need your help. 

We do consume Web services without any problems. But this is the first 
time we will be publishing some. 

The Web service itself is to simply retrieve a list of data that matches 
the request. So we are using OpGetList. 
In the midtier logs, I do see the call being made, the parameters being 
properly set.  But what I think (not sure if I am right) it is on the 
return of the information to the consumer, that we crash.  The 
authetication is set at the midtier level, so no user,password is being 
past thru the web service (WSDL). 

and in the arerror.log we see this: 

   Timestamp: jeu mai  22 2008 10:27:55.2796 
   Thread Id: 8 
   Version: 7.0.01 Patch 004 200708262106 Aug 26 2007 21:36:29 
   ServerName: remdev 
   Database: SQL -- Oracle 
   Hardware: sun4u 
   OS: SunOS 5.10 
   RPC Id: 1857 
   RPC Call: 121 (XMLGE) 
   RPC Queue: 390620 
   Client: User read from Webservice (protocol 12) at IP address 
404e50c94b4689a3:-f4bd115:114ad239f8f:-7fd9 
   Form: VF:HIsto_Appel_Service 
   Logging On: 

Stacks: 
/product/ar/remdev/bin/arserverd:DumpStackTrace+0x88 
/product/ar/remdev/bin/arserverd:SignalTrapProc+0x160 
/lib/libc.so.1:0xc0620 
/lib/libc.so.1:0xb5718 
/product/ar/remdev/bin/libxerces-depdombmc.so.26.0:__1cLxercesc_2_6MDocumentImplKimportNode6Mpn0AINodeImpl_b_3_+0x28
 
[ Signal 11 (SEGV)] 
/product/ar/remdev/bin/libxerces-depdombmc.so.26.0:__1cLxercesc_2_6MDOM_DocumentKimportNode6Mrkn0AIDOM_Node_b_2_+0x18
 

/product/ar/remdev/bin/arserverd:__1cRARXMLHandlerUtilsTBuildDOMTreeFromStr6FrnLxercesc_2_6JDOMString_rn0BMDOM_Document_rn0BIDOM_Node__C_+0xf0
 

/product/ar/remdev/bin/arserverd:__1cUARXMLComplexEntryGetOProcessElement6MrnLxercesc_2_6ODOM_TreeWalker_pnQARFieldValueList_rn0BJDOMString_rn0BMDOM_Document_rn0BLDOM_Element__9B_+0x3c4
 

/product/ar/remdev/bin/arserverd:__1cUARXMLComplexEntryGetMProcessNodes6MrnLxercesc_2_6ODOM_TreeWalker_pnQARFieldValueList_pnYARComplexEntryGetOutList_ipin0BJDOMString_rn0BMDOM_Document_rn0BLDOM_Element__v_+0x178
 

/product/ar/remdev/bin/arserverd:__1cUARXMLComplexEntryGetMProcessNodes6MrnLxercesc_2_6ODOM_TreeWalker_pnQARFieldValueList_pnYARComplexEntryGetOutList_ipin0BJDOMString_rn0BMDOM_Document_rn0BLDOM_Element__v_+0x214
 

/product/ar/remdev/bin/arserverd:__1cUARXMLComplexEntryGetSProcessFormMapping6MrnLxercesc_2_6ODOM_TreeWalker_pnYARComplexEntryGetOutList_n0BJDOMString_rn0BMDOM_Document_rn0BLDOM_Element__v_+0x424
 

/product/ar/remdev/bin/arserverd:__1cUARXMLComplexEntryGetMProcessNodes6MrnLxercesc_2_6ODOM_TreeWalker_pnQARFieldValueList_pnYARComplexEntryGetOutList_ipin0BJDOMString_rn0BMDOM_Document_rn0BLDOM_Element__v_+0x404
 

/product/ar/remdev/bin/arserverd:__1cUARXMLComplexEntryGetMProcessNodes6MrnLxercesc_2_6ODOM_TreeWalker_pnQARFieldValueList_pnYARComplexEntryGetOutList_ipin0BJDOMString_rn0BMDOM_Document_rn0BLDOM_Element__v_+0x214
 

/product/ar/remdev/bin/arserverd:__1cUARXMLComplexEntryGetQBuildXMLDocument6MpcpnYARComplexEntryGetOutList_pnSARXMLValueInfoList_Cp1_v_+0x4f4
 

/product/ar/remdev/bin/arserverd:GetComplexEntryGetToXML+0x6c 
/product/ar/remdev/bin/arserverd:arxmlgetentry_12_svc+0x9a8 
/product/ar/remdev/bin/arserverd:HandleRPCs+0x134d0 
/product/ar/remdev/bin/arserverd:WorkerThread+0x5f4 
/product/ar/remdev/bin/arserverd:RestartableThreadMain+0x60 
/product/ar/remdev/bin/arserverd:UnixThreadStartRoutine+0xe8 
/lib/libc.so.1:0xc04f4 
Thu May 22 10:28:51 2008  Dispatch : Impossible d'établir une connexion 
réseau avec le serveur AR System (remmtl21 : RPC: Miscellaneous tli error 
- An event requires attentionNo message of desired typ

SLM 7.1 web dashboard images missing

[William Rentfrow]

We are using SLM 7.1 - on the WUT everything is fine.
 
On the web none of the images in the tables on the dashboard show up.
They simply just show the red X's you get from any webpage where the
image is missing.  Specifically these are the images that show up in the
"Status" and "Previous" columns and there are two possible images -
Breached and Compliant.
 
All of the images on the rest of the page show correctly.
 
Two questions:
 
1.) Are these images supposed to show in the SLM Application object
under the Support Files tab?  If so, what are they called?
2.) Do they work for anyone else using SLM 7.1 Dashboard on the web?
 
William Rentfrow, Principal Consultant
[EMAIL PROTECTED]
C 701-306-6157
O 952-432-0227
 

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

Re: Tomcat lockups under Windows (7.0.1 p6)

[Maynard,Tor T.]

Now we're on ARS 7.1, but at the time of the issue we were on 7.0.1 (but
not sure what patch).  
We had (what I think is) a similar issue, and did get a response from
BMC.  
I'm going to copy it here.  Hope it helps:
 

You need to allocate more memory for tomcat, here are the details.
 
P R O B L E M:
The Tomcat application server crashes or a user finds an "Out of memory"
error in the log.
 
S O L U T I O N:
Boost the memory settings using one of the following solutions:
 
On Windows:
Choose Start > All Programs > Apache Tomcat 5.5 > Configure Tomcat.
In the dialog box that appears, click the Java tab.
Set the Initial Memory Pool option to 1024 MB.
Set the Maximum Memory Pool option to 1024 MB.
Restart Tomcat.

On Linux: 
Change the minimum and maximum heap size using the -Xms and -Xmx JVM
parameters, which are available in the catalina.sh file.  The new value
for CATALINA_OPTS should be as follows:
Set CATALINA_OPTS="-Xms1024m -Xmx1024m"
Restart Tomcat.



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Ankur Gulati
Sent: Thursday, May 22, 2008 12:42 AM
To: arslist@ARSLIST.ORG
Subject: Re: Tomcat lockups under Windows (7.0.1 p6)


** 
Hi Rick,
 
We had same issue with ARS 7.0.1 P5  and midtier 7.0.1 P5. We have an
open ticket with BMC and they don't seem to have a clue about it.
Downgraded midtier to P4, since then Tomcat is running smooth.
 
 
--
Ankur 




From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of VanAartsen, Christopher
Sent: 22 May 2008 05:25 AM
To: arslist@ARSLIST.ORG
Subject: Re: Tomcat lockups under Windows (7.0.1 p6)


** 

Having similar issues on 6.3 with Tomcat, but restarting our
Tomcat service fixes the problem.  Have you checked your Java Heap size?
That's my next move, looks to be the problem in the log files.

 

 





From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Rick Westbrock
Sent: Wednesday, May 21, 2008 6:40 PM
To: arslist@ARSLIST.ORG
Subject: Tomcat lockups under Windows (7.0.1 p6)

 

Hi all- 

Today for the second time in a two week span Tomcat on my
mid-tier has seemingly hung for no obvious reason. In each case the
login page would not even come up so I restarted the Tomcat service but
to no avail. Restarting the IIS service resolved the issue both times.
We had been running this environment for about two months with no issues
until a couple of weeks ago and the only change has been to deploy a new
web service that allows one of our portal applications to submit a
ticket into Remedy but there is no activity on the production server yet
since we're still testing in our development environment (where we
haven't seen this error at all). I have about a dozen users on the
mid-tier off and on during the day.

I searched the list and the Remedy KB but haven't seen anyone
with similar problems. Environment details are below, any suggestions
about where to start troubleshooting would be much appreciated.

 

Thanks, 

Rick 

 

Single Remedy application server: 
Windows Server 2003 SP 2 
IIS 6.0 
ARS 7.0.1 patch 6 
E-mail Engine 7.0.1 p6 
Mid-Tier 7.0.1 p6 
Tomcat 5.5 

Remote Database Server: 
Windows Server 2003 SP 2 
SQL Server 2000 (8.0.76 SP 3 Standard Edition) 

_ 
Rick Westbrock 
PETCO Telecom Engineer 
[EMAIL PROTECTED]   

 

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the
Answers Are" html___ 
This e-mail message and any attachments may contain 
legally privileged, confidential or proprietary Information, or 
information otherwise protected by law of ArvinMeritor, Inc., 
its affiliates, or third parties. This notice serves as marking
of 
its "Confidential" status as defined in any confidentiality 
agreements concerning the sender and recipient. If you are 
not the intended recipient(s), or the employee or agent 
responsible for delivery of this message to the intended 
recipient(s), you are hereby notified that any dissemination, 
distribution or copying of this e-mail message is strictly 
prohibited. If you have received this message in error, please 
immediately notify the sender and delete this e-mail message 
from your computer.


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

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

__

Job: Kforce / Permanent / McLean - VA / Remedy Developer - Will Relocate

[Kitchen, Joshua T]

Dear List,

 

Hope all is well, Kforce is looking for a talented Remedy Developer
local or willing to relocate to the Virginia area for a permanent
position with one of our clients.  

 

Title:  Remedy Developer

Type:  Direct-Hire at Client

Authorization Status:  US Citizen/Green Card/EAD/H1-B Visa

Duration:  Permanent

Salary:  75,000-90,000 + 12% Bonus (Full Relocation Offered)

Location:  McLean, VA

Interview Process:  1st round phone, 2nd round in-person (We will fly
you in for interview)

 

Industry:

 

Our client is a stockholder - owned corporation chartered by Congress to
increase the supply of funds that mortgage lenders, such as commercial
banks, mortgage bankers, savings institutions and credit unions, can
make available to homebuyers and multifamily investors. 

 

Since 1970, our client has pursued the purpose their Congressional
founders set out for them: to provide a continuous and low - cost source
of credit to finance America's housing. They achieve this purpose by 

 

1)  Making mortgage funds available whenever and wherever Americans need
them by linking the worldwide capital markets to the U.S. mortgage
markets 

2)  Providing a continuous, reliable and low - cost flow of mortgage
capital to finance housing for the nation's homebuyers and renters 

3)  Bringing the benefits of the market in which we operate - the
secondary mortgage market - to families and communities across the
nation 

4)  Freddie Mac conducts its business primarily by buying mortgages from
lenders, packaging the mortgages into securities and selling the
securities - guaranteed by Freddie Mac - to investors. 5)  Mortgage
lenders use the proceeds from selling loans to Freddie Mac to fund new
mortgages, constantly replenishing the pool of funds available for
lending to homebuyers and apartment owners. Just as stock and bond
markets have put investor capital to work for corporations, the
secondary mortgage market puts private investor capital to work for
homebuyers and apartment owners, providing a continuous flow of
affordable funds for home financing. 

 

For the most part, the process is invisible to borrowers and renters.
But because our client exists, millions of Americans have benefited from
lower monthly mortgage payments and better access to home financing. In
fact, for more than 35 years they have opened doors for one in six
homebuyers and more than four million renters in America.

 

Job Responsibilities: 

Performs analysis, design, and development, of Remedy v. 7.1 Service
Desk.  Analyze requirements and create design specifications to meet the
project needs. Perform customization/workflow as determined. Develop new
workflows, active links, forms, and escalations in the Remedy suite.
Builds and executes unit test cases, as wells documents developer
guides, training guides, user guides and support guides.  Provide
support and Sustainment to the Remedy applications.  Researches and
recommends technologies to improve Remedy applications. 

Basic Qualifications: 
* 3-5 years of Remedy development experience in 6.3 and 7.x.



Plus Qualifications

* Experience in developing in Crystal Reports. 

* Experience in Remedy Migrator 

* Experience with CMDB. 

* Integration of REMEDY with external systems using REMEDY APIs, web
services, REMEDY Import etc. 
* Experience with Rational Clear Case for software configuration
management and Rational Clear Quest for Change Defect Management 

 

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

RESOLVED: Fwd: CI Relationship Viewer - Works for Demo and not for other users. (UNCLASSIFIED)

[Mike Gould]

Good Morning,

For anyone else that is/was experiencing problems with the CIViewer failing
for non-Admin users with the "The CI Relationship Viewer could not open
because the specified root CI does not exist." error, I can now verify that
installing CMDB 2.0.1 Patch 006 resolves the problem.

Hope that helps,
Michael Gould
US House of Representatives
-- Forwarded message --
From: LJ Longwing <[EMAIL PROTECTED]>
Date: Tue, May 20, 2008 at 9:58 AM
Subject: Re: CI Relationship Viewer - Works for Demo and not for other
users. (UNCLASSIFIED)
To: arslist@arslist.org


**  That actually perfectly explains why only admins are working...because
it's obviously using Mid-Tier to get you the view...and it needs to log you
in...and that is considered a separate connection, which isn't allowed for
anyone except admins...that is of course unless you are logged in through
mid-tier already, then it just uses your current connection to the
serverdefinitely a design problem

 --
 *From:* Action Request System discussion list(ARSList) [mailto:
[EMAIL PROTECTED] *On Behalf Of *Jiri Pospisil
*Sent:* Tuesday, May 20, 2008 3:17 AM

*To:* arslist@ARSLIST.ORG
*Subject:* Re: CI Relationship Viewer - Works for Demo and not for other
users. (UNCLASSIFIED)

  **

++

Please Read The Disclaimer At The Bottom Of This Email

++


Hi,

just to add to this discussion, we have the same issue here.
The CI Viewer only works for users with administrator privileges or when
users access Remedy through the mid-tier.
I checked the mid-tier log files on our server and found that CI Viewer
generates the following error message when non-admin user tries to access CI
Viewer from the PC client

MessageType: 2
MessageNum: 9093
MessageText: User is currently connected from another machine
We were advised by support to upgrade the CMDB with the CI viewer to version
2.0.01 patch 005, which I have not had time to do yet.

Jiri Pospisil
 LCH.Clearnet

-Original Message-
*From:* Action Request System discussion list(ARSList) [mailto:
[EMAIL PROTECTED] Behalf Of *Mike Gould
*Sent:* 19 May 2008 21:08
*To:* arslist@ARSLIST.ORG
*Subject:* Re: CI Relationship Viewer - Works for Demo and not for other
users. (UNCLASSIFIED)

  ** Hi Gordon,

The reason that Demo brings up the CI Viewer in the AR User Tool and
appadmin doesn't is because Demo has Administrator group permissions and
appadmin only has ITSM Asset Management application role permissions
(out-of-the-box).  It looks like you just gave your new test appadmin
account Administrator permissions, which is why it's now working for you.

The problem with the CI Viewer is that it will only run for accounts with
Administrator rights and displays the "The CI Relationship Viewer could not
open because the specified root CI does not exist." error for all non-Admin
users.  I recommend you try your test again but this time don't give the
user Administrator rights and see if you can replicate the error.

I know a few have suggested looking at form permissions but unfortunately
that's not the issue in this instance as non-Admin users can run the CI
Viewer just fine through their browser once Midtier 7.1.00 Patch 002 is
applied but not when they try in the User Tool.  The problem seems to reside
somewhere in some faulty CI Viewer (at least in the 2.0.01 release) code
that the User Tool is having a hard time processing but was fixed on the
Mid-Tier side.

I'm still in the process of troubleshooting the problem, which has been on
going for several months now, with BMC and will let you know when/if a fix
is found.

Have a great afternoon,
Michael Gould
US House of Representatives

Solaris 9
Oracle 10g
AR Server 7.0.01 Patch 005
Mid-Tier 7.1.00 Patch 002
Atrium CMDB 2.0.01 Patch 003
ITSM 7.0.03 Patch 005





On Mon, May 19, 2008 at 1:43 PM, FRANK, GORDON CTR DISA JSSC <
[EMAIL PROTECTED]> wrote:

> Classification:  UNCLASSIFIED
> Caveats: NONE
>
> Thanks for all of your help!
>
> The combination of several feedbacks got me thinking and I actually
> solved this problem. I don't know what is being carried my the account
> "appadmin" but it is the key to the solution. "appadmin" carries ITSM
> "something" that Demo does not. But Demo does bring up the CI Viewer
> correctly.
>
> Here are the steps which will work.
>
> 1. Collect all information for the new account.
> 2. Go to the "Application Administration Console", People, View
> 3. Select "appadmin" Login ID
> 4. Perform a "Copy to New" (Ctrl-T or select from toolbar)
> 5. In the new copy, make all account changes (Login ID, Support Groups
> (including Administrator), etc. etc.)
> 6. Save
> 7. Login to the new account and the CI Viewer will now work.
>
> Like I said, I don't know what is being carried underneath, but
> something is different on "appadmin". This procedure seems to work every
> time.
>
> Gordon M. Fran

Re: Outlook integration

[Rick Cook]

I saw one on the BMCDN last week.  It was developed for an older version
(5.1.2?), but Dan Hardy wrote it, so it's probably pretty solid.

Rick

On Thu, May 22, 2008 at 6:56 AM, Bill Hoffmeier <[EMAIL PROTECTED]>
wrote:

> **
>
> Uday,
>
>
>
> I have a solution like that.  My solution, however, involves a run process
> calling an executable  I wrote.  The executable was written using VB.Net and
> VS 2005 and contains a custom VB.Net class that creates the iCal file.  The
> executable gathers the information, builds the iCal file, and sends an email
> with an attachment from the command line using SMTP.  My class creates an
> event rather than an alarm.  I've been meaning to extend it, but haven't
> gotten around to it.
>
>
>
> By the way, my class was derived from samples and information I found on
> the web and didn't take that long to write, considering my knowledge of the
> subject before hand and my skill level.   I consider myself a better than
> intermediate but not an expert .Net programmer.[image: Smile emoticon]
>
>
>
> Bill Hoffmeier
>
>  *From:* Uday Joshi <[EMAIL PROTECTED]>
> *Sent:* Thursday, May 22, 2008 4:47 AM
> *Newsgroups:* public.remedy.arsystem.general
> *To:* arslist@ARSLIST.ORG
> *Subject:* Re: Outlook integration
>
> ** Hi Jim,
>
> I have not done it but  have some idea.
>
> Outlook supports open standard called iCal defined by IETF. As per IETF's
> RFC the calendar is text based file through which you can define calendar
> event.
>
> So you will have to have workflow to create this file and then send as a
> email message to the intended recipient.
>
>  Best Regards,
>
> Uday Joshi
>
> Delivery Manager - BSM Support
> Technology Infrastructure Services - BSM Unit
> --
> *Wipro Technologies,*
> Hinjewadi, Pune 411057
> Tel: +91 20 39104092
> VOIP 842-5103
>
>
>  --
> *From:* Action Request System discussion list(ARSList) [mailto:
> [EMAIL PROTECTED] *On Behalf Of *O'Hara, Jim
> *Sent:* Thursday, May 22, 2008 05:20 AM
> *To:* arslist@ARSLIST.ORG
> *Subject:* Outlook integration
>
> **
>
> I need a filter that will create a reminder on an Exchange server.  Anybody
> done this?  Tia
>
> Jim O'Hara
> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
> html___
>
> *Please do not print this email unless it is absolutely necessary. *
>
> The information contained in this electronic message and any attachments to
> this message are intended for the exclusive use of the addressee(s) and may
> contain proprietary, confidential or privileged information. If you are not
> the intended recipient, you should not disseminate, distribute or copy this
> e-mail. Please notify the sender immediately and destroy all copies of this
> message and any attachments.
>
> WARNING: Computer viruses can be transmitted via email. The recipient
> should check this email and any attachments for the presence of viruses. The
> company accepts no liability for any damage caused by any virus transmitted
> by this email.
>
> www.wipro.com
> __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: Publishing Web services crashes the server

[Walters, Mark]

The stack trace matches a server defect we have logged (SW00288690).  It looks 
like the fix is going to be in 7.0.1 patch 8, tentatively expected at the end 
of June.

 

Mark Walters

 

The opinions, statements, and/or suggested courses of action expressed in this 
E-mail do not necessarily reflect those of BMC Software, Inc.  My voluntary 
participation in this forum is not intended to convey a role as a spokesperson, 
liaison or support representative for BMC Software, Inc.

 

 

 

From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Pascale Boyer
Sent: 22 May 2008 15:50
To: arslist@ARSLIST.ORG
Subject: Publishing Web services crashes the server

 

** 
Hi all, 

We are having an issue with a Web service.  I've been working on this since 
Tuesday. Can't find any reasons, but I am NO web gurue. So I really need your 
help. 

We do consume Web services without any problems. But this is the first time we 
will be publishing some. 

The Web service itself is to simply retrieve a list of data that matches the 
request. So we are using OpGetList. 
In the midtier logs, I do see the call being made, the parameters being 
properly set.  But what I think (not sure if I am right) it is on the return of 
the information to the consumer, that we crash.  The authetication is set at 
the midtier level, so no user,password is being past thru the web service 
(WSDL). 

and in the arerror.log we see this: 

   Timestamp: jeu mai  22 2008 10:27:55.2796 
   Thread Id: 8 
   Version: 7.0.01 Patch 004 200708262106 Aug 26 2007 21:36:29 
   ServerName: remdev 
   Database: SQL -- Oracle 
   Hardware: sun4u 
   OS: SunOS 5.10 
   RPC Id: 1857 
   RPC Call: 121 (XMLGE) 
   RPC Queue: 390620 
   Client: User read from Webservice (protocol 12) at IP address 
404e50c94b4689a3:-f4bd115:114ad239f8f:-7fd9 
   Form: VF:HIsto_Appel_Service 
   Logging On: 

Stacks: 
/product/ar/remdev/bin/arserverd:DumpStackTrace+0x88 
/product/ar/remdev/bin/arserverd:SignalTrapProc+0x160 
/lib/libc.so.1:0xc0620 
/lib/libc.so.1:0xb5718 
/product/ar/remdev/bin/libxerces-depdombmc.so.26.0:__1cLxercesc_2_6MDocumentImplKimportNode6Mpn0AINodeImpl_b_3_+0x28
 [ Signal 11 (SEGV)] 
/product/ar/remdev/bin/libxerces-depdombmc.so.26.0:__1cLxercesc_2_6MDOM_DocumentKimportNode6Mrkn0AIDOM_Node_b_2_+0x18
 
/product/ar/remdev/bin/arserverd:__1cRARXMLHandlerUtilsTBuildDOMTreeFromStr6FrnLxercesc_2_6JDOMString_rn0BMDOM_Document_rn0BIDOM_Node__C_+0xf0
 
/product/ar/remdev/bin/arserverd:__1cUARXMLComplexEntryGetOProcessElement6MrnLxercesc_2_6ODOM_TreeWalker_pnQARFieldValueList_rn0BJDOMString_rn0BMDOM_Document_rn0BLDOM_Element__9B_+0x3c4
 
/product/ar/remdev/bin/arserverd:__1cUARXMLComplexEntryGetMProcessNodes6MrnLxercesc_2_6ODOM_TreeWalker_pnQARFieldValueList_pnYARComplexEntryGetOutList_ipin0BJDOMString_rn0BMDOM_Document_rn0BLDOM_Element__v_+0x178
 
/product/ar/remdev/bin/arserverd:__1cUARXMLComplexEntryGetMProcessNodes6MrnLxercesc_2_6ODOM_TreeWalker_pnQARFieldValueList_pnYARComplexEntryGetOutList_ipin0BJDOMString_rn0BMDOM_Document_rn0BLDOM_Element__v_+0x214
 
/product/ar/remdev/bin/arserverd:__1cUARXMLComplexEntryGetSProcessFormMapping6MrnLxercesc_2_6ODOM_TreeWalker_pnYARComplexEntryGetOutList_n0BJDOMString_rn0BMDOM_Document_rn0BLDOM_Element__v_+0x424
 
/product/ar/remdev/bin/arserverd:__1cUARXMLComplexEntryGetMProcessNodes6MrnLxercesc_2_6ODOM_TreeWalker_pnQARFieldValueList_pnYARComplexEntryGetOutList_ipin0BJDOMString_rn0BMDOM_Document_rn0BLDOM_Element__v_+0x404
 
/product/ar/remdev/bin/arserverd:__1cUARXMLComplexEntryGetMProcessNodes6MrnLxercesc_2_6ODOM_TreeWalker_pnQARFieldValueList_pnYARComplexEntryGetOutList_ipin0BJDOMString_rn0BMDOM_Document_rn0BLDOM_Element__v_+0x214
 
/product/ar/remdev/bin/arserverd:__1cUARXMLComplexEntryGetQBuildXMLDocument6MpcpnYARComplexEntryGetOutList_pnSARXMLValueInfoList_Cp1_v_+0x4f4
 
/product/ar/remdev/bin/arserverd:GetComplexEntryGetToXML+0x6c 
/product/ar/remdev/bin/arserverd:arxmlgetentry_12_svc+0x9a8 
/product/ar/remdev/bin/arserverd:HandleRPCs+0x134d0 
/product/ar/remdev/bin/arserverd:WorkerThread+0x5f4 
/product/ar/remdev/bin/arserverd:RestartableThreadMain+0x60 
/product/ar/remdev/bin/arserverd:UnixThreadStartRoutine+0xe8 
/lib/libc.so.1:0xc04f4 
Thu May 22 10:28:51 2008  Dispatch : Impossible d'établir une connexion réseau 
avec le serveur AR System (remmtl21 : RPC: Miscellaneous tli error - An event 
requires attentionNo message of desired type)  ARERR - 90 
Thu May 22 10:29:51 2008  Dispatch : Impossible d'établir une connexion réseau 
avec le serveur AR System (remmtl21 : RPC: Miscellaneous tli error - An event 
requires attentionNo message of desired type)  ARERR - 90 

Action Request System(R)  Fork Daemon   Version 7.0.01 Patch 004 200708262106 
Copyright (c) 2000 - 2006 BMC Software, Inc. 
All rights reserved. 

 (ARNOTE 0) 
   Server indicates that it's up. 

=
 
Anyon

Publishing Web services crashes the server

[Pascale Boyer]

Hi all, 

We are having an issue with a Web service.  I've been working on this 
since Tuesday. Can't find any reasons, but I am NO web gurue. So I really 
need your help.

We do consume Web services without any problems. But this is the first 
time we will be publishing some.

The Web service itself is to simply retrieve a list of data that matches 
the request. So we are using OpGetList.
In the midtier logs, I do see the call being made, the parameters being 
properly set.  But what I think (not sure if I am right) it is on the 
return of the information to the consumer, that we crash.  The 
authetication is set at the midtier level, so no user,password is being 
past thru the web service (WSDL).


this is what we see in the midtier log:





22-May-2008 10:27:55 AM com.remedy.arsys.ws.services.ARService 
processRequest
FINE: WS Total time = 294
22-May-2008 10:27:55 AM com.remedy.arsys.log.Log log
SEVERE: AxisFault : 

MessageType: 2
MessageNum: 90
MessageText: Message not in catalog; Message number = 90
AppendedText: remdev : RPC: Miscellaneous tli error - An event requires 
attentionNo such file or directory
at com.remedy.arsys.api.Proxy.ARXMLGetEntry(Native Method)
at com.remedy.arsys.api.Util.ARXMLGetEntry(Util.java:2856)
at com.remedy.arsys.ws.services.ARService.performOperation(Unknown Source)
at com.remedy.arsys.ws.services.ARService.processRequest(Unknown Source)
at sun.reflect.GeneratedMethodAccessor39.invoke(Unknown Source)
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at 
org.apache.axis.providers.java.MsgProvider.processMessage(MsgProvider.java:141)
at 
org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:319)
at 
org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)
at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)
at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)
at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:453)
at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281)
at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at 
org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at 
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
at 
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at 
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
at 
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at 
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:261)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:767)
at 
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:697)
at 
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:889)
at 
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:686)
at java.lang.Thread.run(Thread.java:595)
22-May-2008 10:27:55 AM com.remedy.arsys.ws.services.ARService 
expandXPathExpressions
FINE: Old Qualification: XPATH(/ROOT/startRecord) Expanded Qualification: 
0
22-May-2008 10:27:55 AM com.remedy.arsys.ws.services.ARService 
expandXPathExpressions
FINE: Old XPATH Expression: /ROOT/startRecord Expanded XPATH Expression: 0
22-May-2008 10:27:55 AM com.remedy.arsys.ws.services.ARService 
getXPathValue
FINE: Found matching text node. Value = 0
22-May-2008 10:27:55 AM com.remedy.arsys.ws.services.ARService 
getXPathValue
FINE: CHILD startRecord
22-May-2008 10:27:55 AM com.remedy.arsys.ws.services.ARService 
getXPathValue
FINE: CHILD Qualification
22-May-2008 10:27:55 AM com.remedy.arsys.ws.services.ARService 
getXPathValue
FINE: Token: startRecord
22-May-2008 10:27:55 AM com.remedy.arsys.ws.services.ARService 
getXPathValue
FINE: Token: ROOT
22-May-2008 10:27:55 AM com.remedy.arsys.ws.services.ARService 
expandXPathExpressions
FINE: Old Qualification: XPATH(/ROOT/maxLimit) Expanded Qualification: 500
22-May-2008 10:27:55 AM com.remedy.arsys.ws.services.ARService 
expandXPathExpressions
FINE: Old XPATH Expression: /ROOT/maxLimit Expanded XPATH Expression: 500
22-May-2008 10:27:55 AM com.remedy.arsys.ws.services.ARService 
getXPathValue
FINE: Found matching text node. Value = 500
22-May-2008 10:27:55 AM com.remedy.arsys.ws.services.ARService 
getXPathValue
FINE: CHILD maxLi

Re: View Form - Remote DB not available.

[Grooms, Frederick W]

You can do a SQL Set fields test of the remote DB (Through an Oracle
function to trap the error).
 
Oracle Function 

CREATE OR REPLACE FUNCTION TEST_REMOTE_SYSTEM (strSQL VARCHAR2 )
RETURN VarChar2 IS
   ResultList VarChar2(255);
   TYPE RefCurTyp IS REF CURSOR;
   myCursor RefCurTyp;
BEGIN
   ResultList := NULL;
   OPEN myCursor FOR strSQL;
   FETCH myCursor INTO ResultList;
   CLOSE myCursor;
   RETURN trim(ResultList);
EXCEPTION
   WHEN OTHERS THEN
   RETURN NULL;   
END TEST_REMOTE_SYSTEM;
/

 
To use this simply pass in your own SQL to test the remote system.  In a
Set Fields from SQL action put in for the SQL.

Select TEST_REMOTE_SYSTEM( 'Select count(*) From
[EMAIL PROTECTED]' ) From Dual

You can do any SQL Select statement in the function as long as it
returns only 1 value.   i.e.
  Select ID From TABLE Where ROWNUM = 1
 
If you get a value back then the system is up.  If you get NULL then the
remote system did not return anything and it is probably down.
 
Fred
 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of John Kovalcik
Sent: Thursday, May 22, 2008 8:48 AM
To: arslist@ARSLIST.ORG
Subject: View Form - Remote DB not available.


** 
Listers, 

I have a view form(on ARS 6.3 - Oracle) that is looking at a
remote database table.  If the remote database is not available, I get a
nasty Oracle error when trying to access the view form through workflow.
Is there anyway to check if the remote DB is available before I run my
workflow ?? 


Thanks,

__

  John Kovalcik
  Sr. Service Management Analyst
  [EMAIL PROTECTED]
  Kennametal Inc. | 1600 Technology Way | Latrobe, PA 15650 |
www.kennametal.com 


__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: EIE questions

[Brian Gillock]

I don't know how much data you have to move, but have you thought about
using Web Services?  

 

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Marc Simmons
Sent: Thursday, May 22, 2008 5:36 AM
To: arslist@ARSLIST.ORG
Subject: Re: EIE questions

 

** 

Thanks to all for your support/wisdom.  After speaking with BMC last night
and getting a WebEX of the product, I came to realize that DSO does not
"natively" support connection to another Remedy server any more.  The
options appear to be:

 

1.  Mixed solution using multiple Remedy tools and maintain the logic in EIE

2.  Write an adapter in C/C++

3.  Script the entire thing in ARSPerl/API etc

 

Anyway.. that's where we're at.

 

Thanks again to all...

 

Marc

 

On 5/22/08, Joe D'Souza <[EMAIL PROTECTED]> wrote: 

** 

Marc,

 

One limitation with EIE/AIE will however be attachment fields (if any). I
guess if you can deal with that, you can try playing around with it. DSO
would not have that limitation.

 

Joe

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of Marc Simmons
Sent: Wednesday, May 21, 2008 12:48 PM
To: arslist@ARSLIST.ORG
Subject: Re: EIE questions

** 

Drew, this is an integration partner that we have to connect to... not
another internal machine.  This partner wants to do as little work (because
they have not been given a budget to integrate, but have been given a
mandate to integrate) in order to integrate with us.  This partner would not
want to provide an additional db license/security etc for this effort. 

 

Joe, all of the above applies to DSO as well.  Using DSO would require they
this partner purchase and configure it as well.  Even if they already owned
DSO, it can be pretty complicated to implement and would probably require a
lot of work on their part... which we have know has to be at a minimum.

 

That's why EIE was chosen.  I done plenty of integrations with 3rd party
products so I understand the basics.  All of the marketing material says
that it can be used to integrate with another Remedy server as well... it's
just not clearly defined how to set up that data exchange.

 

Anyway.. hope that answers some of the questions so far.

 

Marc

 

On 5/21/08, Joe DeSouza <[EMAIL PROTECTED]> wrote: 

** 

Wouldn't DSO be the more ideal solution for moving Remedy data accross two
Remedy servers? Why EIE?

 

Joe
 

- Original Message 
From: Marc Simmons <[EMAIL PROTECTED]>
To: arslist@ARSLIST.ORG
Sent: Wednesday, May 21, 2008 10:28:59 AM
Subject: EIE questions

** 

Hi List,

 

I need to use EIE to synchronize data between 2 Remedy servers.  All of the
EIE (7.X) documentation explains how to move data between 1 Remedy server
and some other 3rd party application... usually a database or flat file.
Does anyone have any experience configuring data exchanges that moves data
between 2 Remedy servers?

 

Thanks in advance for the help.

-- 
Marc Simmons
Remedy Administrator

"Everyday above ground is a good day... the rest is a choice!"

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




-- 
Marc Simmons
Remedy Administrator

"Everyday above ground is a good day... the rest is a choice!" __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: View Form - Remote DB not available.

[ITSM Support]

*Hi J.K.,*

You are working with  remote  database, are you getting the instance of 
that  database?
First try to get that instanace as the view form uses the 
*...

*Hope this helps...

Regards.

*Sandeep
Vyom Labs Pvt. Ltd.
An ISO 2 certified company.
Consulting | Outsourcing | Training || BMC Remedy BSM | ITIL
Web : www.vyomlabs.com

*John Kovalcik wrote:

**
Listers,

I have a view form(on ARS 6.3 - Oracle) that is looking at a 
remote database table.  If the remote database is not available, I get 
a nasty Oracle error when trying to access the view form through 
workflow.  Is there anyway to check if the remote DB is available 
before I run my workflow ??



Thanks,

__

  John Kovalcik
  Sr. Service Management Analyst
  [EMAIL PROTECTED]
  Kennametal Inc. | 1600 Technology Way | Latrobe, PA 15650 | 
www.kennametal.com



__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: EIE questions

[Brian Gillock]

Marc,

Have you tried attaching to the other Remedy DB as if it was
just a standard SQL DB?  Try using the view associated with whatever table
you are working with.

 

HTH,

Brian

 

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Marc Simmons
Sent: Wednesday, May 21, 2008 12:41 PM
To: arslist@ARSLIST.ORG
Subject: Re: EIE questions

 

** Drew... Thanks for the input.  I guess I need to start looking at how to
"McGuiver" something out of the capabilities I have available to me...

On 5/21/08, Drew Shuller <[EMAIL PROTECTED]> wrote: 

Marc, I've only done external database to Remedy EIE exchanges. Apparently
EIE can connect to flat files and XML so that may be a good direction,
depending on the version of EIE that you're running.

The EIE documentation should tell you what kind of connections you can make.

Drew

On Wed, 21 May 2008, Marc Simmons wrote:

Drew, this is an integration partner that we have to connect to... not
another internal machine.  This partner wants to do as little work (because
they have not been given a budget to integrate, but have been given a
mandate to integrate) in order to integrate with us.  This partner would not
want to provide an additional db license/security etc for this effort.

Joe, all of the above applies to DSO as well.  Using DSO would require they
this partner purchase and configure it as well.  Even if they already owned
DSO, it can be pretty complicated to implement and would probably require a
lot of work on their part... which we have know has to be at a minimum.

That's why EIE was chosen.  I done plenty of integrations with 3rd party
products so I understand the basics.  All of the marketing material says
that it can be used to integrate with another Remedy server as well... it's
just not clearly defined how to set up that data exchange.

Anyway.. hope that answers some of the questions so far.

Marc


On 5/21/08, Joe DeSouza <[EMAIL PROTECTED]> wrote:


**  Wouldn't DSO be the more ideal solution for moving Remedy data accross
two Remedy servers? Why EIE?

Joe

 - Original Message 
From: Marc Simmons <[EMAIL PROTECTED]>
To: arslist@ARSLIST.ORG
Sent: Wednesday, May 21, 2008 10:28:59 AM
Subject: EIE questions

** Hi List,

I need to use EIE to synchronize data between 2 Remedy servers.  All of the
EIE (7.X) documentation explains how to move data between 1 Remedy server
and some other 3rd party application... usually a database or flat file.
Does anyone have any experience configuring data exchanges that moves data
between 2 Remedy servers?

Thanks in advance for the help.

--
Marc Simmons
Remedy Administrator

"Everyday above ground is a good day... the rest is a choice!"


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




-- 
Marc Simmons
Remedy Administrator

"Everyday above ground is a good day... the rest is a choice!" __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: Outlook integration

[Bill Hoffmeier]

Outlook integrationUday,

 

I have a solution like that.  My solution, however, involves a run process 
calling an executable  I wrote.  The executable was written using VB.Net and VS 
2005 and contains a custom VB.Net class that creates the iCal file.  The 
executable gathers the information, builds the iCal file, and sends an email 
with an attachment from the command line using SMTP.  My class creates an event 
rather than an alarm.  I've been meaning to extend it, but haven't gotten 
around to it. 



By the way, my class was derived from samples and information I found on the 
web and didn't take that long to write, considering my knowledge of the subject 
before hand and my skill level.   I consider myself a better than intermediate 
but not an expert .Net programmer.

 

Bill Hoffmeier



From: Uday Joshi 
Sent: Thursday, May 22, 2008 4:47 AM
Newsgroups: public.remedy.arsystem.general
To: arslist@ARSLIST.ORG 
Subject: Re: Outlook integration


** 
Hi Jim,

I have not done it but  have some idea.

Outlook supports open standard called iCal defined by IETF. As per IETF's RFC 
the calendar is text based file through which you can define calendar event. 

So you will have to have workflow to create this file and then send as a email 
message to the intended recipient.

Best Regards,

Uday Joshi

Delivery Manager - BSM Support
Technology Infrastructure Services - BSM Unit
--
Wipro Technologies,
Hinjewadi, Pune 411057
Tel: +91 20 39104092
VOIP 842-5103





From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of O'Hara, Jim
Sent: Thursday, May 22, 2008 05:20 AM
To: arslist@ARSLIST.ORG
Subject: Outlook integration


** 
I need a filter that will create a reminder on an Exchange server.  Anybody 
done this?  Tia 

Jim O'Hara 

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ 
Please do not print this email unless it is absolutely necessary. 

The information contained in this electronic message and any attachments to 
this message are intended for the exclusive use of the addressee(s) and may 
contain proprietary, confidential or privileged information. If you are not the 
intended recipient, you should not disseminate, distribute or copy this e-mail. 
Please notify the sender immediately and destroy all copies of this message and 
any attachments. 

WARNING: Computer viruses can be transmitted via email. The recipient should 
check this email and any attachments for the presence of viruses. The company 
accepts no liability for any damage caused by any virus transmitted by this 
email. 

www.wipro.com 

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

View Form - Remote DB not available.

[John Kovalcik]

Listers,

I have a view form(on ARS 6.3 - Oracle) that is looking at a 
remote database table.  If the remote database is not available, I get a 
nasty Oracle error when trying to access the view form through workflow. 
Is there anyway to check if the remote DB is available before I run my 
workflow ??


Thanks,

__

   John Kovalcik
   Sr. Service Management Analyst
   [EMAIL PROTECTED]
   Kennametal Inc. | 1600 Technology Way | Latrobe, PA 15650 | 
www.kennametal.com 



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

Re: Table = $NULL$

[ITSM Support]

*Hi Lisa,
*
For Run If condition 'column' = $NULL$ only when there are no records in 
table,
you can use this condition not only for RequestId but for any other 
required field also.

Hope this helps...

Regards,

*Mahendra.
Vyom Labs Pvt. Ltd.
An ISO 2 certified company.
Consulting | Outsourcing | Training || BMC Remedy BSM | ITIL
Web : www.vyomlabs.com
*




Kemes, Lisa wrote:
Thanks so much James, I was thinking that maybe I needed to use a column field instead of the table field.  Does it matter which column though?  Does it have to be the Request ID field? 



Lisa

-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of jham36
Sent: Wednesday, May 21, 2008 4:43 PM
To: arslist@ARSLIST.ORG
Subject: Re: Table = $NULL$

Include the request ID field in your table.
Run IF col1 = $NULL$

where col1 is the Request ID field in the table.  It may be col2 or 3 or a 
custom name.  I usually rename my table columns to something like  colRQSTID.
Then my Run If statement would be  colRQSTID = $NULL$

James

On May 21, 4:38 pm, "Kemes, Lisa" <[EMAIL PROTECTED]>
wrote:
  
I thought you could use this Run If statement on an Active Link to 
only run the Active Link if the Table field  was null.  It's failing 
in my workflow.log file even though the table field has no records in it.


Am I missing something?

Lisa Kemes

AR System Developer
Tyco Electronics
717-810-2408 tel
717-810-2124 fax
[EMAIL PROTECTED]

__
_­ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org 
Platinum Sponsor:www.rmsportal.comARSlist: "Where the Answers Are"



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

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


  


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

Re: Table = $NULL$

[Kemes, Lisa]

Thanks so much James, I was thinking that maybe I needed to use a column field 
instead of the table field.  Does it matter which column though?  Does it have 
to be the Request ID field? 


Lisa

-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of jham36
Sent: Wednesday, May 21, 2008 4:43 PM
To: arslist@ARSLIST.ORG
Subject: Re: Table = $NULL$

Include the request ID field in your table.
Run IF col1 = $NULL$

where col1 is the Request ID field in the table.  It may be col2 or 3 or a 
custom name.  I usually rename my table columns to something like  colRQSTID.
Then my Run If statement would be  colRQSTID = $NULL$

James

On May 21, 4:38 pm, "Kemes, Lisa" <[EMAIL PROTECTED]>
wrote:
> I thought you could use this Run If statement on an Active Link to 
> only run the Active Link if the Table field  was null.  It's failing 
> in my workflow.log file even though the table field has no records in it.
>
> Am I missing something?
>
> Lisa Kemes
> AR System Developer
> Tyco Electronics
> 717-810-2408 tel
> 717-810-2124 fax
> [EMAIL PROTECTED]
>
> __
> _­ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org 
> Platinum Sponsor:www.rmsportal.comARSlist: "Where the Answers Are"

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

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

Re: EIE questions

[Marc Simmons]

Thanks to all for your support/wisdom.  After speaking with BMC last night
and getting a WebEX of the product, I came to realize that DSO does not
"natively" support connection to another Remedy server any more.  The
options appear to be:

1.  Mixed solution using multiple Remedy tools and maintain the logic in EIE
2.  Write an adapter in C/C++
3.  Script the entire thing in ARSPerl/API etc

Anyway.. that's where we're at.

Thanks again to all...

Marc


On 5/22/08, Joe D'Souza <[EMAIL PROTECTED]> wrote:
>
> ** Marc,
>
> One limitation with EIE/AIE will however be attachment fields (if any). I
> guess if you can deal with that, you can try playing around with it. DSO
> would not have that limitation.
>
> Joe
>
> -Original Message-
> *From:* Action Request System discussion list(ARSList) [mailto:
> [EMAIL PROTECTED] Behalf Of *Marc Simmons
> *Sent:* Wednesday, May 21, 2008 12:48 PM
> *To:* arslist@ARSLIST.ORG
> *Subject:* Re: EIE questions
>
> ** Drew, this is an integration partner that we have to connect to... not
> another internal machine.  This partner wants to do as little work (because
> they have not been given a budget to integrate, but have been given a
> mandate to integrate) in order to integrate with us.  This partner would not
> want to provide an additional db license/security etc for this effort.
>
> Joe, all of the above applies to DSO as well.  Using DSO would require they
> this partner purchase and configure it as well.  Even if they already owned
> DSO, it can be pretty complicated to implement and would probably require a
> lot of work on their part... which we have know has to be at a minimum.
>
> That's why EIE was chosen.  I done plenty of integrations with 3rd party
> products so I understand the basics.  All of the marketing material says
> that it can be used to integrate with another Remedy server as well... it's
> just not clearly defined how to set up that data exchange.
>
> Anyway.. hope that answers some of the questions so far.
>
> Marc
>
>
> On 5/21/08, Joe DeSouza <[EMAIL PROTECTED]> wrote:
>>
>> **  Wouldn't DSO be the more ideal solution for moving Remedy data
>> accross two Remedy servers? Why EIE?
>>
>> Joe
>>
>>  - Original Message 
>> From: Marc Simmons <[EMAIL PROTECTED]>
>> To: arslist@ARSLIST.ORG
>> Sent: Wednesday, May 21, 2008 10:28:59 AM
>> Subject: EIE questions
>>
>> ** Hi List,
>>
>> I need to use EIE to synchronize data between 2 Remedy servers.  All of
>> the EIE (7.X) documentation explains how to move data between 1 Remedy
>> server and some other 3rd party application... usually a database or flat
>> file.  Does anyone have any experience configuring data exchanges that moves
>> data between 2 Remedy servers?
>>
>> Thanks in advance for the help.
>>
>> --
>> Marc Simmons
>> Remedy Administrator
>>
>> "Everyday above ground is a good day... the rest is a choice!"
>>
> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
> html___
>



-- 
Marc Simmons
Remedy Administrator

"Everyday above ground is a good day... the rest is a choice!"

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

Testing Software/BMC Remedy Integrations

[Scott Parrish]

Has anyone out there integrated third-party testing software, such as HP's
TestDirector or TechExcel's DevTest, with any Remedy products (ITSM, CSS or
QM)?

Scott Parrish
IT Prophets, LLC
(770) 653-5203
www.itprophets.com 

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

Re: Outlook integration (UNCLASSIFIED)

[FRANK, GORDON CTR DISA JSSC]

Classification:  UNCLASSIFIED 
Caveats: NONE

There's a bunch of Outlook related downloads on Gidd's site:

http://www.buoyantsolutions.net/Index.html

I think Matt Reinfeld has some stuff also:

http://www.mattreinfeldt.com

Perhaps you could use one of these as a model.

Gordon M. Frank
Remedy Skilled Professional - 7.x
ITIL V3 Foundation Certified
DISA\Verizon FNS

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Uday Joshi
Sent: Thursday, May 22, 2008 7:47 AM
To: arslist@ARSLIST.ORG
Subject: Re: Outlook integration

**
Hi Jim,
 
I have not done it but  have some idea.
 
Outlook supports open standard called iCal defined by IETF. As per
IETF's RFC the calendar is text based file through which you can define
calendar event. 
 
So you will have to have workflow to create this file and then send as a
email message to the intended recipient.
 
Best Regards,
 
Uday Joshi
 
Delivery Manager - BSM Support
Technology Infrastructure Services - BSM Unit
--
Wipro Technologies,
Hinjewadi, Pune 411057
Tel: +91 20 39104092
VOIP 842-5103
 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of O'Hara, Jim
Sent: Thursday, May 22, 2008 05:20 AM
To: arslist@ARSLIST.ORG
Subject: Outlook integration


** 

I need a filter that will create a reminder on an Exchange server.
Anybody done this?  Tia 

Jim O'Hara 

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

Please do not print this email unless it is absolutely necessary. 

The information contained in this electronic message and any attachments
to this message are intended for the exclusive use of the addressee(s)
and may contain proprietary, confidential or privileged information. If
you are not the intended recipient, you should not disseminate,
distribute or copy this e-mail. Please notify the sender immediately and
destroy all copies of this message and any attachments. 

WARNING: Computer viruses can be transmitted via email. The recipient
should check this email and any attachments for the presence of viruses.
The company accepts no liability for any damage caused by any virus
transmitted by this email. 

www.wipro.com 

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___ 
Classification:  UNCLASSIFIED 
Caveats: NONE

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

Re: Outlook integration

[Uday Joshi]

Hi Jim,

I have not done it but  have some idea.

Outlook supports open standard called iCal defined by IETF. As per
IETF's RFC the calendar is text based file through which you can define
calendar event.

So you will have to have workflow to create this file and then send as a
email message to the intended recipient.

Best Regards,

Uday Joshi

Delivery Manager - BSM Support
Technology Infrastructure Services - BSM Unit
--
Wipro Technologies,
Hinjewadi, Pune 411057
Tel: +91 20 39104092
VOIP 842-5103




From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of O'Hara, Jim
Sent: Thursday, May 22, 2008 05:20 AM
To: arslist@ARSLIST.ORG
Subject: Outlook integration


**

I need a filter that will create a reminder on an Exchange server.
Anybody done this?  Tia

Jim O'Hara

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

Please do not print this email unless it is absolutely necessary. 

The information contained in this electronic message and any attachments to 
this message are intended for the exclusive use of the addressee(s) and may 
contain proprietary, confidential or privileged information. If you are not the 
intended recipient, you should not disseminate, distribute or copy this e-mail. 
Please notify the sender immediately and destroy all copies of this message and 
any attachments. 

WARNING: Computer viruses can be transmitted via email. The recipient should 
check this email and any attachments for the presence of viruses. The company 
accepts no liability for any damage caused by any virus transmitted by this 
email. 

www.wipro.com

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

Bi Directional Relationship between two CI Instances

[Naveen Kaushik]

Hi List,
 
Could we have bidirectional relationship between two CI instances without 
loosing the functioanlity to see relationship record from CI Viewer.
 
I an trying to establish the bi directioanal relationship by creating two 
relationship classes and populating each relationship class with records.
 
But the "view relation ship record details" option is disabled when I right 
click on the bidirectioanal relationship arrow.
 
I am on ARS 7.1 and CMDB 2.1.0.
 
Please guide.
 
Thanks 
Naveen


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"

Re: Populating Table field with sql query result

[Victor]

On Sunday 18 of May 2008 22:39:03 Grooms, Frederick W wrote:
> Have your SQL Query populate a table in the database and have a View
> form pointing to that table.
>
> Fred
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:[EMAIL PROTECTED] On Behalf Of Victor
> Sent: Sunday, May 18, 2008 12:47 PM
> To: arslist@ARSLIST.ORG
> Subject: Populating Table field with sql query result
>
> Hello Listers,
>
> It is possible to populate a table field with the result from an sql
> query?
> Any idea how this could be done?
>
> Victor
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Thank you Fred - but I'm afraid this approach is unacceptable.

The idea is to introduce a (sort of) summary button on system class form. On 
clicking this button a summary page  describing this particular CI together 
its dependencies,components and components of its dependencies (in a single 
Table form) will be displayed.


Remedy ARS 6.3
Oracle 9i database
MS IIS
Windows 2000

Any suggestions please?


Victor

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