Re: ITSM 7.5.1 Install Issue

[Joe DeSouza]

Do you have the install logs?

Joe




From: C Thomas 
To: arslist@ARSLIST.ORG
Sent: Tuesday, May 26, 2009 10:08:27 PM
Subject: ITSM 7.5.1 Install Issue

** Hello,
 We are installing ITSM Version 7.5.1 - We have successfully installed the AR 
Server and components Version 7.5 and the CMDB 7.5 and then the Patch 1. We 
started the ITSM 7.5.1 install, but ran into errors - 
At first it said "
BMC Remedy Action Request System is not detected
Approval Engine... is not the correct version...
Assignment Engine is not correct version
etc, etc"

We manually updated the SHARE:Application"Properties file - to say Version = 
7.5.0 patch 001... for each of these components.
But then when we bring up the ITSM 7.5.1 installer again - we get the one 
remaining error : "BMC Remedy Action Request System is not detected."

Question I have - Does the AR Server have an entry in this form ? I do not see 
any entry for that now and thought the AR Server itself did not need an entry 
there.
Has anyone run into this issue ? Any ideas how to resolve this ?

We are on Oracle 10g & Solaris 10.

thanks,
CT




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

ITSM 7.5.1 Install Issue

[C Thomas]

Hello,
 We are installing ITSM Version 7.5.1 - We have successfully installed the
AR Server and components Version 7.5 and the CMDB 7.5 and then the Patch 1.
We started the ITSM 7.5.1 install, but ran into errors -
At first it said "
BMC Remedy Action Request System is not detected
Approval Engine... is not the correct version...
Assignment Engine is not correct version
etc, etc"

We manually updated the SHARE:Application"Properties file - to say Version =
7.5.0 patch 001... for each of these components.
But then when we bring up the ITSM 7.5.1 installer again - we get the one
remaining error : "BMC Remedy Action Request System is not detected."

Question I have - Does the AR Server have an entry in this form ? I do not
see any entry for that now and thought the AR Server itself did not need an
entry there.
Has anyone run into this issue ? Any ideas how to resolve this ?

We are on Oracle 10g & Solaris 10.

thanks,
CT

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

JOB: Remedy Developer/Administrator position in Washington Heights (NYC)- 100% onsite, local candidates only

[Wish, Melissa]

Our client in Washington Heights NYC (near subways), is seeking a Remedy
Developer/Administrator. 

 

Compensation can be done either by W2 -  $85K base, full benefits, 15
days paid vacation OR by 1099 at $500 per day.  

 

100% onsite.

 

Local NYC metro area candidates only.

 

Must start in June- the sooner the better.

 

Must have a Green Card or US Citizenship.

 

After a year, this person will be transferred to the Client's payroll at
a higher base salary plus paid vacation and great benefits.

 

If you are interested, please email me your resume as an MS Word
document as well as a good time to contact you. 

 

 

Melissa Wish

Corporate Recruiter

Column Technologies, Inc.

Email: mw...@columnit.com  

Web:  http://www.columnit.com

 


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

JOB: Remedy Developer/Administrator position in Washington Heights (NYC)- 100% onsite, local candidates only

[Wish, Melissa]

 

 

Melissa Wish

Corporate Recruiter

 

Column Technologies, Inc.

Direct: (718) 399-2136

Cell: (917) 748-7104

Fax: (646) 349-3799

Email: mw...@columnit.com  

Web:  http://www.columnit.com  

 


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

JOB: Remedy Field Trainer/Custom Trainer- full time with benefits, 75% travel, can be based anywhere in the US (MUST be a US Citizen)

[Wish, Melissa]

Column Technologies is seeking a BMC Remedy Field/Custom Trainer to
support Custom BMC Remedy Training Engagements. 

 

Objectives: Engage customers to gather custom training requirements,
prepare training material, and deliver custom training. Must have BMC
Remedy Trainer/Instructor or Developer experience, strong oral and
written communication skills and be capable of developing polished
documentation. 

 

* Draft application and process specific training documentation 

* Conduct requirements gathering workshops around training needs and
deliverables

* Design custom or product-based training guides, job aides, labs,
slides, etc...

* Demonstrate the BMC Remedy ITSM suite to customers

* Estimate level of effort to design or train on BMC Remedy product
suite

* Deliver custom training through a variety of mediums to include
classroom and web

* Effectively self manage project engagements

Communication

* Effectively communicate relevant project information to superiors

* Deliver engaging, informative, well-organized presentations

* Resolve and/or escalates issues in a timely fashion

* Understand how to communicate difficult/sensitive information
tactfully

* Excellent delivery skills when presenting to an audience - must be
able to command an audience and authoritatively answer questions

Technical Understanding 

* Possesses a thorough understanding of Column Technologies training
product and services capabilities

* Maintain awareness of new and emerging technologies and the potential
application on client engagements 

* Thorough understanding of both the architectural design and deployment
intent of the following BMC Remedy modules -

*   Incident Management 
*   Problem Management 
*   Change Management 
*   Asset Management 
*   SRM 
*   RKM

* Knowledge and experience with ITIL and other IT Best Practices
frameworks (ideally, Foundations-certified) (also good: Six Sigma, CMMI,
other methodologies)

Teamwork 

*   Mentoring - offer insights to team members and help them improve
delivery of Column products 
*   Keep track of lessons learned and share those lessons with team
members. 
*   Mitigate team conflict and communication problems. 
*   Assist other team members with assignments when possible

 

Column Technologies is an Equal Opportunity Employer. Please submit all
resumes to mw...@columnit.com   

 

Melissa Wish

Corporate Recruiter

 

Column Technologies, Inc.

Email: mw...@columnit.com  

Web:  http://www.columnit.com  

 


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

Re: Workflow

[Joe DeSouza]

Hello Oracle4Me..

If you mean on the immediate selection of multiple records for the ARS to know 
that multiple records have been selected, no ARS has no way of knowing that. 
You have to create another action like a button which needs to be presssed to 
process the multiple records that have been selected.

The most you could do use use interval which may be a bad idea cause if the 
user changes the selection while the system is processing stuff, you might get 
unexpected results..

Cheers

Joe





From: "oracle...@aol.com" 
To: arslist@ARSLIST.ORG
Sent: Tuesday, May 26, 2009 5:57:36 PM
Subject: Workflow

** Hi All,

When the user select on the table field, I want the user to be able to select 
multiple Record ID's within the table, and merge these records together into a 
form.  Is this possible?

I know if the user selects 1 record, and then presses a button workflow will 
trigger.  The problem is I need the user to be able to select multiple records 
in the table and an action is triggered.  I hope this is possible.




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

Re: Workflow

[Grooms, Frederick W]

Yes Multiple selection of tables is allowed (This is controlled by the Field 
Properties -> Advanced Display -> Single Selection Allowed and User Selection 
Allowed checkboxes).  You can then trigger the action with a button on the form 
or the Return Table or Level Double Click action.  You will have to write your 
own workflow to collect the list of selected rows (I have done this with a 
Guide that does a Table Loop on Selected Rows Only)

Fred

--Original Message--
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of oracle...@aol.com
Sent: Tuesday, May 26, 2009 4:58 PM
To: arslist@ARSLIST.ORG
Subject: Workflow

Hi All,
 
When the user select on the table field, I want the user to be able to select 
multiple Record ID's within the table, and merge these records together into a 
form.  Is this possible?
 
I know if the user selects 1 record, and then presses a button workflow will 
trigger.  The problem is I need the user to be able to select multiple records 
in the table and an action is triggered.  I hope this is possible.
 
 

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

Re: Workflow

[Nicky Madjarov]

See Active Link Guides - walking tables.

Regards,

Nicky Madjarov
phone: 973-202-4278
Find out how to bust your AR System performance @
http://www.SpeedUpARS.com
  - Original Message - 
  From: oracle...@aol.com 
  Newsgroups: public.remedy.arsystem.general
  To: arslist@ARSLIST.ORG 
  Sent: Tuesday, May 26, 2009 5:57 PM
  Subject: Workflow


  ** 
  Hi All,

  When the user select on the table field, I want the user to be able to select 
multiple Record ID's within the table, and merge these records together into a 
form.  Is this possible?

  I know if the user selects 1 record, and then presses a button workflow will 
trigger.  The problem is I need the user to be able to select multiple records 
in the table and an action is triggered.  I hope this is possible.



--
  A Good Credit Score is 700 or Above. See yours in just 2 easy steps!
  _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_

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

Workflow

[Oracle4Me]

Hi All,
 
When the user select on the table field, I want the user to be able to  
select multiple Record ID's within the table, and merge these records together  
into a form.  Is this possible?
 
I know if the user selects 1 record, and then presses a button workflow  
will trigger.  The problem is I need the user to be able to select multiple  
records in the table and an action is triggered.  I hope this is  possible.
 
**A Good Credit Score is 700 or Above. See yours in just 2 easy 
steps! 
(http://pr.atwola.com/promoclk/100126575x1222377034x1201454326/aol?redir=http://www.freecreditreport.com/pm/default.aspx?sc=668072&hmpgID=62&bcd=
MaystepsfooterNO62)

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

Re: Moving databases and switching server names within

[Joe DeSouza]

Thorin,

If you are talking about server names in the definitions, there is a easier way 
out..

Take an XML definition file and look for the tag 

This tag will have the offending value so you can do a simple search and 
replace for what you want to do.

And then reimport the def file..

Joe





From: Marty.Thorin 
To: arslist@ARSLIST.ORG
Sent: Tuesday, May 26, 2009 5:29:50 PM
Subject: Moving databases and switching server names within

** 
Good afternoon: 
    I need to copy a fully loaded Remedy 7.5 server and its database to 
another machine.  Copying and updating the Linux files is easy.  I just copy 
then hunt and replace every instance of the old server's name with the new 
server name.
    I thought the Oracle 10g database would be just as easy.  (All 
tablespaces keep the their same name so it is ARSystem everywhere.  I will be 
changing the database server's name.)  Last time I brought up Remedy then went 
to the Admin Console and updated the e-mail engine.
I am hesitant to do this because this did not catch all of the instances of the 
old name.  Our 7.1 servers were a mess.  We first built the production server 
with the development database.  Then I cloned this to create the development 
server attached to the production database.  Then we fixed it so production 
server with production database and development server with development 
database.
We started over for our 7.5 installs.  I just finished doing the 7.5 production 
server with its 7.5 production database.  The older 7.1 development server is 
still running.  Because of a bug, you must use the default password for ARAdmin 
when doing a 7.5 ARS install.  We quickly ran into Oracle lockouts.  Changing 
the ARAdmin password to the same value as the development server was using 
fixed the problem.  So somehow I missed at least one reference to the 
production database in the database.  (Fortunately for me, the server name 
change is a one letter change: 'p' for production becomes 't' for test'.  The 
names are the same length.)
Does anyone have a list of where to look so I am sure I get all of the 
instances found in the Oracle database? 
Thank you, 
Thorin




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

Moving databases and switching server names within

[Marty.Thorin]

Good afternoon:
I need to copy a fully loaded Remedy 7.5 server and its database
to another machine.  Copying and updating the Linux files is easy.  I
just copy then hunt and replace every instance of the old server's name
with the new server name.
I thought the Oracle 10g database would be just as easy.  (All
tablespaces keep the their same name so it is ARSystem everywhere.  I
will be changing the database server's name.)  Last time I brought up
Remedy then went to the Admin Console and updated the e-mail engine.

I am hesitant to do this because this did not catch all of the instances
of the old name.  Our 7.1 servers were a mess.  We first built the
production server with the development database.  Then I cloned this to
create the development server attached to the production database.  Then
we fixed it so production server with production database and
development server with development database.

We started over for our 7.5 installs.  I just finished doing the 7.5
production server with its 7.5 production database.  The older 7.1
development server is still running.  Because of a bug, you must use the
default password for ARAdmin when doing a 7.5 ARS install.  We quickly
ran into Oracle lockouts.  Changing the ARAdmin password to the same
value as the development server was using fixed the problem.  So somehow
I missed at least one reference to the production database in the
database.  (Fortunately for me, the server name change is a one letter
change: 'p' for production becomes 't' for test'.  The names are the
same length.)

Does anyone have a list of where to look so I am sure I get all of the
instances found in the Oracle database?
Thank you,
Thorin


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

Re: ARS 7.5 Install Issue

[Joe DeSouza]

What is the DB compatibility level of the ARSystem database that you want to 
upgrade? If below 80 I think it will be incompatible and may be the cause of 
those SQL errors?

If below 80 I would suggest that you upgrade that to 80 or above using the 
stored proceedure sp_dbcmptlevel.

Assuming ARSystem is the name of your database, on your SQL prompt type

sp_dbcmptlevel 'ARSystem'

This will return a result such as:

The current compatibility level is 80.

The following are values for compatibility level for different versions of SQL..

80 = SQL Server 2000
90 = SQL Server 2005
100 = SQL Server 2008

That being said you can run a lower version ie lets say 70 on SQL server 2000 
by manipulating this using sp_dbcmptlevel..

If the level returned is below 80, you might have a problem. You will need to 
upgrade it using this same stored proceedure..

sp_dbcmptlevel ARSystem, 90 (to set it to 2005)
OR
sp_dbcmptlevel ARSystem, 100 (to set it to 2008 if thats your version of the 
SQL Server)

You may need to run RECONFIGURE after running the above command and then 
possibly restart the SQL server..

Hope this helps..

Cheers

Joe



From: "Rodriguez, Rafael J x23718" 
To: arslist@ARSLIST.ORG
Sent: Tuesday, May 26, 2009 4:27:31 PM
Subject: Re: ARS 7.5 Install Issue

** 
SQL2005 SP3



From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Joe DeSouza
Sent: Tuesday, May 26, 2009 3:05 PM
To: arslist@ARSLIST.ORG
Subject: Re: ARS 7.5 Install Issue

** 
What database are you using when you get this error?

Joe





From: "Rodriguez, Rafael J x23718" 
To: arslist@ARSLIST.ORG
Sent: Tuesday, May 26, 2009 12:45:40 PM
Subject: Re: ARS 7.5 Install Issue

Elry, you are correct! I still have this issue with 7.5 Patch 1 

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Elry
Sent: Tuesday, May 26, 2009 12:13 PM
To: arslist@ARSLIST.ORG
Subject: Re: ARS 7.5 Install Issue

Hi Guys...

We did an upgrade recently in our development and staging environment much like 
what started this "thread".

We found that:

1) 7.5 had installations issues - that were dealt with by using patch 1.
2) Even when using patch 1 - we found that we had to do a clean uninstall 
before trying again...
3) When you go to install the Clients - 7.5 has a completely different file 
structure than 7.1
4) If you install the Clients based on the install defaults - you will "wind 
up" with 7.1 & 7.5 on your system.
5) For a complete install of 7.5 without 7.1 - you will have to uninstall 7.1 
before installing 7.5..
6) Our Silent Install script no longer worked because 7.5 uses a different 
installer with different prompts...

I am sure there are folks out there with similar insights



On May 26, 9:40 am, Howard Richter  wrote:
> Rafael,
>
> So it sounds like 7.5 should be a new install only.
>
> Howard
>
> On Tue, May 26, 2009 at 8:46 AM, Rodriguez, Rafael J x23718 <
>
>
>
> rafael.rodrig...@broadridge.com> wrote:
> > ** Howard thanks for you reply, actually there were some issues with 
> > forms and workflow that did not exists. Funny that 7.0.1 Patch6 
> > never through any exemptions and now on 7.5 there were errors all 
> > over the place. The worst part about it is the new suite install 
> > that only allow you to install it once. THIS IS A PAIN IN THE BUTT!
>
> > I got it resolved but had to literally unistall it and clean it out 
> > numerous times before it would take.
>
> > Rafael
>
> >  --
> > *From:* Action Request System discussion list(ARSList) [mailto:
> > arsl...@arslist.org] *On Behalf Of *Howard Richter
> > *Sent:* Friday, May 22, 2009 9:33 PM
> > *To:* arsl...@arslist.org
> > *Subject:* Re: ARS 7.5 Install Issue
>
> > ** Rafael,
>
> > Any issues with the database?
>
> > Howard
>
> > On Fri, May 22, 2009 at 3:30 PM, Rodriguez, Rafael J x23718 < 
> > rafael.rodrig...@broadridge.com> wrote:
>
> >> **
>
> >> Hello list,
>
> >> WIN2003 Server
>
> >> SQL2005
>
> >> I was attempting to upgrade my current dev environment remedy 
> >> installation from 7.0.1 patch 6 to 7.5 Patch 1 and I'm getting an 
> >> error during installation. The error appears in the event log but 
> >> there is no errors in the install_log:
>
> >> Event Type: Error
> >> Event Source: AR System Monitor
> >> Event Category: None
> >> Event ID: 0
> >> Date: 05/22/2009
> >> Time: 1:45:48 PM
> >> User: N/A
> >> Computer: REM4DEV
> >> Description:
> >> 390600 : Failure during SQL operation to the database (ARERR 552)
>
> >> Any ideas?
>
> >> Rafael Rodriguez*|*Manager Remedy/Mid-Tier Enterprise*|*Broadridge 
> >> Financial Solutions
>
> >> 2 Journal Square Plaza*|*Jersey City, NJ 07306*|* 201.714.3718 p
>
> >> This message and any attachments are intended only for the use of 
> >> the addressee and may contain information that is privileged and 
>

Re: ARS 7.5 Install Issue

[Rodriguez, Rafael J x23718]

SQL2005 SP3



From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Joe DeSouza
Sent: Tuesday, May 26, 2009 3:05 PM
To: arslist@ARSLIST.ORG
Subject: Re: ARS 7.5 Install Issue


** 
What database are you using when you get this error?
 
Joe




From: "Rodriguez, Rafael J x23718" 
To: arslist@ARSLIST.ORG
Sent: Tuesday, May 26, 2009 12:45:40 PM
Subject: Re: ARS 7.5 Install Issue

Elry, you are correct! I still have this issue with 7.5 Patch 1 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Elry
Sent: Tuesday, May 26, 2009 12:13 PM
To: arslist@ARSLIST.ORG
Subject: Re: ARS 7.5 Install Issue

Hi Guys...

We did an upgrade recently in our development and staging environment
much like what started this "thread".

We found that:

1) 7.5 had installations issues - that were dealt with by using patch 1.
2) Even when using patch 1 - we found that we had to do a clean
uninstall before trying again...
3) When you go to install the Clients - 7.5 has a completely different
file structure than 7.1
4) If you install the Clients based on the install defaults - you will
"wind up" with 7.1 & 7.5 on your system.
5) For a complete install of 7.5 without 7.1 - you will have to
uninstall 7.1 before installing 7.5..
6) Our Silent Install script no longer worked because 7.5 uses a
different installer with different prompts...

I am sure there are folks out there with similar insights



On May 26, 9:40 am, Howard Richter  wrote:
> Rafael,
>
> So it sounds like 7.5 should be a new install only.
>
> Howard
>
> On Tue, May 26, 2009 at 8:46 AM, Rodriguez, Rafael J x23718 <
>
>
>
> rafael.rodrig...@broadridge.com> wrote:
> > ** Howard thanks for you reply, actually there were some issues with

> > forms and workflow that did not exists. Funny that 7.0.1 Patch6 
> > never through any exemptions and now on 7.5 there were errors all 
> > over the place. The worst part about it is the new suite install 
> > that only allow you to install it once. THIS IS A PAIN IN THE BUTT!
>
> > I got it resolved but had to literally unistall it and clean it out 
> > numerous times before it would take.
>
> > Rafael
>
> >  --
> > *From:* Action Request System discussion list(ARSList) [mailto:
> > arsl...@arslist.org] *On Behalf Of *Howard Richter
> > *Sent:* Friday, May 22, 2009 9:33 PM
> > *To:* arsl...@arslist.org
> > *Subject:* Re: ARS 7.5 Install Issue
>
> > ** Rafael,
>
> > Any issues with the database?
>
> > Howard
>
> > On Fri, May 22, 2009 at 3:30 PM, Rodriguez, Rafael J x23718 < 
> > rafael.rodrig...@broadridge.com> wrote:
>
> >> **
>
> >> Hello list,
>
> >> WIN2003 Server
>
> >> SQL2005
>
> >> I was attempting to upgrade my current dev environment remedy 
> >> installation from 7.0.1 patch 6 to 7.5 Patch 1 and I'm getting an 
> >> error during installation. The error appears in the event log but 
> >> there is no errors in the install_log:
>
> >> Event Type: Error
> >> Event Source: AR System Monitor
> >> Event Category: None
> >> Event ID: 0
> >> Date: 05/22/2009
> >> Time: 1:45:48 PM
> >> User: N/A
> >> Computer: REM4DEV
> >> Description:
> >> 390600 : Failure during SQL operation to the database (ARERR 552)
>
> >> Any ideas?
>
> >> Rafael Rodriguez*|*Manager Remedy/Mid-Tier Enterprise*|*Broadridge 
> >> Financial Solutions
>
> >> 2 Journal Square Plaza*|*Jersey City, NJ 07306*|* 201.714.3718 p
>
> >> This message and any attachments are intended only for the use of 
> >> the addressee and may contain information that is privileged and 
> >> confidential. If the reader of the message is not the intended 
> >> recipient or an authorized representative of the intended 
> >> recipient, you are hereby notified that any dissemination of this 
> >> communication is strictly prohibited. If you have received this 
> >> communication in error, please notify us immediately by e-mail and
delete the message and any attachments from your system.
>
> >> _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the 
> >> Answers Are"_
>
> > --
> > Howard Richter
> > Red Hat Certified Technician
> > CompTIA Linux+ Certified
> > ITIL Foundation Certified
> > E-Mail = hbr4...@gmail.com
> > LinkedIn Profile =http://www.linkedin.com/in/hbr4270
> > _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the 
> > Answers Are"_
>
> > This message and any attachments are intended only for the use of 
> > the addressee and may contain information that is privileged and 
> > confidential. If the reader of the message is not the intended 
> > recipient or an authorized representative of the intended recipient,

> > you are hereby notified that any dissemination of this communication

> > is strictly prohibited. If you have received this communication in 
> > error, please notify us immediately by e-mail and delete the message
and any attachments from your 

Re: ARS 7.5 Install Issue

[Joe DeSouza]

What database are you using when you get this error?

Joe





From: "Rodriguez, Rafael J x23718" 
To: arslist@ARSLIST.ORG
Sent: Tuesday, May 26, 2009 12:45:40 PM
Subject: Re: ARS 7.5 Install Issue

Elry, you are correct! I still have this issue with 7.5 Patch 1 

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Elry
Sent: Tuesday, May 26, 2009 12:13 PM
To: arslist@ARSLIST.ORG
Subject: Re: ARS 7.5 Install Issue

Hi Guys...

We did an upgrade recently in our development and staging environment much like 
what started this "thread".

We found that:

1) 7.5 had installations issues - that were dealt with by using patch 1.
2) Even when using patch 1 - we found that we had to do a clean uninstall 
before trying again...
3) When you go to install the Clients - 7.5 has a completely different file 
structure than 7.1
4) If you install the Clients based on the install defaults - you will "wind 
up" with 7.1 & 7.5 on your system.
5) For a complete install of 7.5 without 7.1 - you will have to uninstall 7.1 
before installing 7.5..
6) Our Silent Install script no longer worked because 7.5 uses a different 
installer with different prompts...

I am sure there are folks out there with similar insights



On May 26, 9:40 am, Howard Richter  wrote:
> Rafael,
>
> So it sounds like 7.5 should be a new install only.
>
> Howard
>
> On Tue, May 26, 2009 at 8:46 AM, Rodriguez, Rafael J x23718 <
>
>
>
> rafael.rodrig...@broadridge.com> wrote:
> > ** Howard thanks for you reply, actually there were some issues with 
> > forms and workflow that did not exists. Funny that 7.0.1 Patch6 
> > never through any exemptions and now on 7.5 there were errors all 
> > over the place. The worst part about it is the new suite install 
> > that only allow you to install it once. THIS IS A PAIN IN THE BUTT!
>
> > I got it resolved but had to literally unistall it and clean it out 
> > numerous times before it would take.
>
> > Rafael
>
> >  --
> > *From:* Action Request System discussion list(ARSList) [mailto:
> > arsl...@arslist.org] *On Behalf Of *Howard Richter
> > *Sent:* Friday, May 22, 2009 9:33 PM
> > *To:* arsl...@arslist.org
> > *Subject:* Re: ARS 7.5 Install Issue
>
> > ** Rafael,
>
> > Any issues with the database?
>
> > Howard
>
> > On Fri, May 22, 2009 at 3:30 PM, Rodriguez, Rafael J x23718 < 
> > rafael.rodrig...@broadridge.com> wrote:
>
> >> **
>
> >> Hello list,
>
> >> WIN2003 Server
>
> >> SQL2005
>
> >> I was attempting to upgrade my current dev environment remedy 
> >> installation from 7.0.1 patch 6 to 7.5 Patch 1 and I'm getting an 
> >> error during installation. The error appears in the event log but 
> >> there is no errors in the install_log:
>
> >> Event Type: Error
> >> Event Source: AR System Monitor
> >> Event Category: None
> >> Event ID: 0
> >> Date: 05/22/2009
> >> Time: 1:45:48 PM
> >> User: N/A
> >> Computer: REM4DEV
> >> Description:
> >> 390600 : Failure during SQL operation to the database (ARERR 552)
>
> >> Any ideas?
>
> >> Rafael Rodriguez*|*Manager Remedy/Mid-Tier Enterprise*|*Broadridge 
> >> Financial Solutions
>
> >> 2 Journal Square Plaza*|*Jersey City, NJ 07306*|* 201.714.3718 p
>
> >> This message and any attachments are intended only for the use of 
> >> the addressee and may contain information that is privileged and 
> >> confidential. If the reader of the message is not the intended 
> >> recipient or an authorized representative of the intended 
> >> recipient, you are hereby notified that any dissemination of this 
> >> communication is strictly prohibited. If you have received this 
> >> communication in error, please notify us immediately by e-mail and delete 
> >> the message and any attachments from your system.
>
> >> _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the 
> >> Answers Are"_
>
> > --
> > Howard Richter
> > Red Hat Certified Technician
> > CompTIA Linux+ Certified
> > ITIL Foundation Certified
> > E-Mail = hbr4...@gmail.com
> > LinkedIn Profile =http://www.linkedin.com/in/hbr4270
> > _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the 
> > Answers Are"_
>
> > This message and any attachments are intended only for the use of 
> > the addressee and may contain information that is privileged and 
> > confidential. If the reader of the message is not the intended 
> > recipient or an authorized representative of the intended recipient, 
> > you are hereby notified that any dissemination of this communication 
> > is strictly prohibited. If you have received this communication in 
> > error, please notify us immediately by e-mail and delete the message and 
> > any attachments from your system.
>
> > _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the 
> > Answers Are"_
>
> --
> Howard Richter
> Red Hat Certified Technician
> CompTIA Linux+ Certified
> ITIL Foundation Certified
> E-Mail = hbr4...@gmail.com
>

Re: ARS 7.5 Install Issue

[Joe DeSouza]

That you end up with two sets of clients (different versions) is a feature and 
not a bug. You can have 7.1 clients and 7.5 on the same machine and run them 
concurrently against an appropriate server.

That being said, I had a brief look at this thread and while I do agree there 
are 'some' installation issues with the 7.5 installer, it is still however 
possible to upgrade from 7.1 to 7.5 if you are able to tweak your system in 
accordance to what the installer might be expecting.

Here is one tip on what I felt was necessary to do when I noticed the 
installer started borgging up in my case where the host name was not the same 
as the AR Server name on 7.1. The installer would not be able to connect to the 
AR Server after providing it with the connection credentials and selecting the 
alias name from the list of the AR Server List.

In the older system you could pretty much call your local AR Server 
(AR_SERVER_ID) practically anything you wanted, but 7.5 expects it to be the 
local host name. So if you are upgrading from an older system whose host name 
was different from the AR Server Name, then the install script fails to resolve 
the AR Server. Recently when I raised a ticket to Remedy Support, they 
identified this as a software defect.

To overcome this on UNIX, I had to create a symbolic link in the /etc/arsystem 
directory after the host name of the server, pointing to the 
/etc/arsystem/.

Having done this I was able to trick the installer to believe the AR Server 
name is the host name of the machine.

However after the install this means that the arsystem startup script will have 
the AR_SERVER_ID to the host name. Also the new armonitor.conf file and the 
modified ar.conf file will have the host name for the AR Server Name.

These files will need to be modified again if you need to maintain the name of 
the server as the old alias.

I'm hoping they resolve this connection issue in the next release..

Joe





From: Elry 
To: arslist@ARSLIST.ORG
Sent: Tuesday, May 26, 2009 12:13:24 PM
Subject: Re: ARS 7.5 Install Issue

Hi Guys...

We did an upgrade recently in our development and staging environment
much like what started this "thread".

We found that:

1) 7.5 had installations issues - that were dealt with by using patch 1.
2) Even when using patch 1 - we found that we had to do a clean uninstall 
before trying again...
3) When you go to install the Clients - 7.5 has a completely different file 
structure than 7.1
4) If you install the Clients based on the install defaults - you will "wind 
up" with 7.1 & 7.5 on your system.
5) For a complete install of 7.5 without 7.1 - you will have to uninstall 7.1 
before installing 7.5..
6) Our Silent Install script no longer worked because 7.5 uses a different 
installer with different prompts...

I am sure there are folks out there with similar insights



On May 26, 9:40 am, Howard Richter  wrote:
> Rafael,
>
> So it sounds like 7.5 should be a new install only.
>
> Howard
>
> On Tue, May 26, 2009 at 8:46 AM, Rodriguez, Rafael J x23718 <
>
>
>
> rafael.rodrig...@broadridge.com> wrote:
> > ** Howard thanks for you reply, actually there were some issues with forms
> > and workflow that did not exists. Funny that 7.0.1 Patch6 never through any
> > exemptions and now on 7.5 there were errors all over the place. The worst
> > part about it is the new suite install that only allow you to install it
> > once. THIS IS A PAIN IN THE BUTT!
>
> > I got it resolved but had to literally unistall it and clean it out
> > numerous times before it would take.
>
> > Rafael
>
> >  --
> > *From:* Action Request System discussion list(ARSList) [mailto:
> > arsl...@arslist.org] *On Behalf Of *Howard Richter
> > *Sent:* Friday, May 22, 2009 9:33 PM
> > *To:* arsl...@arslist.org
> > *Subject:* Re: ARS 7.5 Install Issue
>
> > ** Rafael,
>
> > Any issues with the database?
>
> > Howard
>
> > On Fri, May 22, 2009 at 3:30 PM, Rodriguez, Rafael J x23718 <
> > rafael.rodrig...@broadridge.com> wrote:
>
> >> **
>
> >> Hello list,
>
> >> WIN2003 Server
>
> >> SQL2005
>
> >> I was attempting to upgrade my current dev environment remedy installation
> >> from 7.0.1 patch 6 to 7.5 Patch 1 and I’m getting an error during
> >> installation. The error appears in the event log but there is no errors in
> >> the install_log:
>
> >> Event Type: Error
> >> Event Source: AR System Monitor
> >> Event Category: None
> >> Event ID: 0
> >> Date: 05/22/2009
> >> Time: 1:45:48 PM
> >> User: N/A
> >> Computer: REM4DEV
> >> Description:
> >> 390600 : Failure during SQL operation to the database (ARERR 552)
>
> >> Any ideas?
>
> >> Rafael Rodriguez*|*Manager Remedy/Mid-Tier Enterprise*|*Broadridge
> >> Financial Solutions
>
> >> 2 Journal Square Plaza*|*Jersey City, NJ 07306*|* 201.714.3718 p
>
> >> This message and any attachments are intended only for the use of the 
> >> addressee and
> >> may contain information that is privileged an

Re: ARS 7.5 Install Issue

[Rodriguez, Rafael J x23718]

Elry, you are correct! I still have this issue with 7.5 Patch 1 

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Elry
Sent: Tuesday, May 26, 2009 12:13 PM
To: arslist@ARSLIST.ORG
Subject: Re: ARS 7.5 Install Issue

Hi Guys...

We did an upgrade recently in our development and staging environment much like 
what started this "thread".

We found that:

1) 7.5 had installations issues - that were dealt with by using patch 1.
2) Even when using patch 1 - we found that we had to do a clean uninstall 
before trying again...
3) When you go to install the Clients - 7.5 has a completely different file 
structure than 7.1
4) If you install the Clients based on the install defaults - you will "wind 
up" with 7.1 & 7.5 on your system.
5) For a complete install of 7.5 without 7.1 - you will have to uninstall 7.1 
before installing 7.5..
6) Our Silent Install script no longer worked because 7.5 uses a different 
installer with different prompts...

I am sure there are folks out there with similar insights



On May 26, 9:40 am, Howard Richter  wrote:
> Rafael,
>
> So it sounds like 7.5 should be a new install only.
>
> Howard
>
> On Tue, May 26, 2009 at 8:46 AM, Rodriguez, Rafael J x23718 <
>
>
>
> rafael.rodrig...@broadridge.com> wrote:
> > ** Howard thanks for you reply, actually there were some issues with 
> > forms and workflow that did not exists. Funny that 7.0.1 Patch6 
> > never through any exemptions and now on 7.5 there were errors all 
> > over the place. The worst part about it is the new suite install 
> > that only allow you to install it once. THIS IS A PAIN IN THE BUTT!
>
> > I got it resolved but had to literally unistall it and clean it out 
> > numerous times before it would take.
>
> > Rafael
>
> >  --
> > *From:* Action Request System discussion list(ARSList) [mailto:
> > arsl...@arslist.org] *On Behalf Of *Howard Richter
> > *Sent:* Friday, May 22, 2009 9:33 PM
> > *To:* arsl...@arslist.org
> > *Subject:* Re: ARS 7.5 Install Issue
>
> > ** Rafael,
>
> > Any issues with the database?
>
> > Howard
>
> > On Fri, May 22, 2009 at 3:30 PM, Rodriguez, Rafael J x23718 < 
> > rafael.rodrig...@broadridge.com> wrote:
>
> >> **
>
> >> Hello list,
>
> >> WIN2003 Server
>
> >> SQL2005
>
> >> I was attempting to upgrade my current dev environment remedy 
> >> installation from 7.0.1 patch 6 to 7.5 Patch 1 and I'm getting an 
> >> error during installation. The error appears in the event log but 
> >> there is no errors in the install_log:
>
> >> Event Type: Error
> >> Event Source: AR System Monitor
> >> Event Category: None
> >> Event ID: 0
> >> Date: 05/22/2009
> >> Time: 1:45:48 PM
> >> User: N/A
> >> Computer: REM4DEV
> >> Description:
> >> 390600 : Failure during SQL operation to the database (ARERR 552)
>
> >> Any ideas?
>
> >> Rafael Rodriguez*|*Manager Remedy/Mid-Tier Enterprise*|*Broadridge 
> >> Financial Solutions
>
> >> 2 Journal Square Plaza*|*Jersey City, NJ 07306*|* 201.714.3718 p
>
> >> This message and any attachments are intended only for the use of 
> >> the addressee and may contain information that is privileged and 
> >> confidential. If the reader of the message is not the intended 
> >> recipient or an authorized representative of the intended 
> >> recipient, you are hereby notified that any dissemination of this 
> >> communication is strictly prohibited. If you have received this 
> >> communication in error, please notify us immediately by e-mail and delete 
> >> the message and any attachments from your system.
>
> >> _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the 
> >> Answers Are"_
>
> > --
> > Howard Richter
> > Red Hat Certified Technician
> > CompTIA Linux+ Certified
> > ITIL Foundation Certified
> > E-Mail = hbr4...@gmail.com
> > LinkedIn Profile =http://www.linkedin.com/in/hbr4270
> > _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the 
> > Answers Are"_
>
> > This message and any attachments are intended only for the use of 
> > the addressee and may contain information that is privileged and 
> > confidential. If the reader of the message is not the intended 
> > recipient or an authorized representative of the intended recipient, 
> > you are hereby notified that any dissemination of this communication 
> > is strictly prohibited. If you have received this communication in 
> > error, please notify us immediately by e-mail and delete the message and 
> > any attachments from your system.
>
> > _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the 
> > Answers Are"_
>
> --
> Howard Richter
> Red Hat Certified Technician
> CompTIA Linux+ Certified
> ITIL Foundation Certified
> E-Mail = hbr4...@gmail.com
> LinkedIn Profile =http://www.linkedin.com/in/hbr4270
>
> __
> _ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org 
> Platinum Sponsor:rmisoluti...@

Re: ARS 7.5 Install Issue

[Rodriguez, Rafael J x23718]

No Howard, you are able to run the upgrade or even install as part of a
server group its just that once its installed you can't go back and
re-install components like email engine, approval server etc...



From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Howard Richter
Sent: Tuesday, May 26, 2009 9:41 AM
To: arslist@ARSLIST.ORG
Subject: Re: ARS 7.5 Install Issue


** 
Rafael,
 
So it sounds like 7.5 should be a new install only.
 
Howard


On Tue, May 26, 2009 at 8:46 AM, Rodriguez, Rafael J x23718
 wrote:


** 
Howard thanks for you reply, actually there were some issues
with forms and workflow that did not exists. Funny that 7.0.1 Patch6
never through any exemptions and now on 7.5 there were errors all over
the place. The worst part about it is the new suite install that only
allow you to install it once. THIS IS A PAIN IN THE BUTT!
 
I got it resolved but had to literally unistall it and clean it
out numerous times before it would take.
 
Rafael



From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Howard Richter
Sent: Friday, May 22, 2009 9:33 PM
To: arslist@ARSLIST.ORG
Subject: Re: ARS 7.5 Install Issue


** 
Rafael,
 
Any issues with the database?
 
Howard


On Fri, May 22, 2009 at 3:30 PM, Rodriguez, Rafael J x23718
 wrote:


** 

Hello list,

 

WIN2003 Server

SQL2005

 

I was attempting to upgrade my current dev environment
remedy installation from 7.0.1 patch 6 to 7.5 Patch 1 and I'm getting an
error during installation. The error appears in the event log but there
is no errors in the install_log:

 

Event Type: Error
Event Source: AR System Monitor
Event Category: None
Event ID: 0
Date: 05/22/2009
Time: 1:45:48 PM
User: N/A
Computer: REM4DEV
Description:
390600 : Failure during SQL operation to the database
(ARERR 552) 

 

 

Any ideas?

 

Rafael Rodriguez|Manager Remedy/Mid-Tier
Enterprise|Broadridge Financial Solutions

2 Journal Square Plaza|Jersey City, NJ 07306|
201.714.3718 p



 

This message and any attachments are intended only for
the use of the addressee and
may contain information that is privileged and
confidential. If the reader of the 
message is not the intended recipient or an authorized
representative of the
intended recipient, you are hereby notified that any
dissemination of this
communication is strictly prohibited. If you have
received this communication in
error, please notify us immediately by e-mail and delete
the message and any
attachments from your system.

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




-- 
Howard Richter
Red Hat Certified Technician
CompTIA Linux+ Certified
ITIL Foundation Certified 
E-Mail = hbr4...@gmail.com
LinkedIn Profile = http://www.linkedin.com/in/hbr4270
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the
Answers Are"_ 
This message and any attachments are intended only for the use
of the addressee and
may contain information that is privileged and confidential. If
the reader of the 
message is not the intended recipient or an authorized
representative of the
intended recipient, you are hereby notified that any
dissemination of this
communication is strictly prohibited. If you have received this
communication in
error, please notify us immediately by e-mail and delete the
message and any
attachments from your system.

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




-- 
Howard Richter
Red Hat Certified Technician
CompTIA Linux+ Certified
ITIL Foundation Certified 
E-Mail = hbr4...@gmail.com
LinkedIn Profile = http://www.linkedin.com/in/hbr4270
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
Are"_ 

This message and any attachments are intended only for the use of the addressee 
and
may contain information that is privileged and confidential. If the reader of 
the 
message is not the intended recipient or an authorized representative of the
intended recipient, you are hereby notified that any dissemination of this
communication

Re: ARS 7.5 Install Issue

[Rodriguez, Rafael J x23718]

Sorry I was not clearer before, but the issue is that if you run the
install for example selecting the Minimal install option and then go
back and try to re-install selection the custom option so that you can
install the email engine, flashboards etc it will remember the first
install AWAYS and will NOT alow you to select the options unless you
physically uninstall everything and clean it out. Then and only then can
you make selection changes. 
 
That is what I experienced on my dev box.
 
HTH



From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Ashwin
Sent: Tuesday, May 26, 2009 9:24 AM
To: arslist@ARSLIST.ORG
Subject: Re: ARS 7.5 Install Issue


** 
Hi Rafeal,
Good to hear that you solved your problem.
You have written - "The worst part about it is the new suite install
that only allow you to install it once."
As far as I know 7.5 installer still supports upgrade installation and
you can run the installer multiple times to either upgrade or over-write
the existing installation.
Can you please elaborate on your statement that you can install ony
once?
Thanks
Ashwin
 
On Tue, 26 May 2009 08:46 -0400, "Rodriguez, Rafael J x23718"
 wrote:
 

** 
Howard thanks for you reply, actually there were some issues
with forms and workflow that did not exists. Funny that 7.0.1 Patch6
never through any exemptions and now on 7.5 there were errors all over
the place. The worst part about it is the new suite install that only
allow you to install it once. THIS IS A PAIN IN THE BUTT!
 
I got it resolved but had to literally unistall it and clean it
out numerous times before it would take.
 
Rafael



From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Howard Richter
Sent: Friday, May 22, 2009 9:33 PM
To: arslist@ARSLIST.ORG
Subject: Re: ARS 7.5 Install Issue

 
 
** 
Rafael,
 
Any issues with the database?
 
Howard

 
On Fri, May 22, 2009 at 3:30 PM, Rodriguez, Rafael J x23718
 wrote:


** 

Hello list,

 

WIN2003 Server

SQL2005

 

I was attempting to upgrade my current dev environment
remedy installation from 7.0.1 patch 6 to 7.5 Patch 1 and I'm getting an
error during installation. The error appears in the event log but there
is no errors in the install_log:

 

Event Type: Error
Event Source: AR System Monitor
Event Category: None
Event ID: 0
Date: 05/22/2009
Time: 1:45:48 PM
User: N/A
Computer: REM4DEV
Description:
390600 : Failure during SQL operation to the database
(ARERR 552) 

 

 

Any ideas?

 

Rafael Rodriguez|Manager Remedy/Mid-Tier
Enterprise|Broadridge Financial Solutions

2 Journal Square Plaza|Jersey City, NJ 07306|
201.714.3718 p



 

This message and any attachments are intended only for
the use of the addressee and
may contain information that is privileged and
confidential. If the reader of the 
message is not the intended recipient or an authorized
representative of the
intended recipient, you are hereby notified that any
dissemination of this
communication is strictly prohibited. If you have
received this communication in
error, please notify us immediately by e-mail and delete
the message and any
attachments from your system.

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



 

-- 
Howard Richter
Red Hat Certified Technician
CompTIA Linux+ Certified
ITIL Foundation Certified 
E-Mail = hbr4...@gmail.com
LinkedIn Profile = http://www.linkedin.com/in/hbr4270
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the
Answers Are"_ 
This message and any attachments are intended only for the use
of the addressee and
may contain information that is privileged and confidential. If
the reader of the 
message is not the intended recipient or an authorized
representative of the
intended recipient, you are hereby notified that any
dissemination of this
communication is strictly prohibited. If you have received this
communication in
error, please notify us immediately by e-mail and delete the
message and any
attachments from your system.

_Platinum

Re: Fw: transaction for parent/child changes

[Elry]

I agree...

We have had the same difficulty.

In our situation we had a CMDB for which we needed rollback capability
for updating CI/Child records.

For each table field we built a transaction storage form that stored
all the Child Record transactions until the

Parent record was committed.  Once the Parent Record was committed -
the child updates were then

sent to their respective tables and the temporary record(s) deleted.

Probably another way to do it under the 7.x paradigm - would be to
take advantage of  the "Audit" feature for

rollback (depending on the amount of fields involved).

As for when multiple people are editing a single Parent record - I
thought there was a Remedy error trapping

mechanism that let you know when you tried to commit that there were
new changes to the record that you

were editing - then it asks you if you want to save anyway???



On May 26, 12:13 pm, Robert Halstead  wrote:
> As I understand it, Remedy doesn't provide a check on who is looking/editing
> a record.  The only check Remedy does is a last modified time check.  We are
> running into this same issue when multiple people edit the same record.  We
> plan to implement a read/read-write locking feature in our own system though
> I wish remedy had the ability to lock records down.
>
> On Fri, Feb 6, 2009 at 12:17 PM, Michael Drew 
> wrote:
>
>
>
> > Depending on the nature of the data, you could perhaps use the table field
> > as your temporary storage (I.e. Set field local action to place your various
> > values into the currently selected row in the table) and do a table walk to
> > send the table values back to the actual child entry's records when you hit
> > save on the parent.
> > Michael.
>
> > --Original Message--
> > From: Brien Dieterle
> > Sender: Action Request System discussion list(ARSList)
> > To: arsl...@arslist.org
> > ReplyTo: arsl...@arslist.org
> > Sent: Feb 6, 2009 3:34 PM
> > Subject: transaction for parent/child changes
>
> > ** We've designed a form that has child requests displayed in a table list
> > field.  You can interact with these child requests through this form and
> > update them via display only fields and push-fields activelink buttons etc.
> > So the problem is you can update some things on the main form, and update
> > some children requests, close the main request and say "yes, lose changes".
> > A user might expect that the changes to the children would be reverted back
> > to what they were.
>
> > Is there any way to encapsulate the whole process of editing the primary
> > requests and N children requests into a single transaction that gets
> > committed only upon saving of the primary request?
>
> > Thanks!
>
> > Brien Dieterle
> >  __Platinum Sponsor: RMI Solutions 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 atwww.arslist.org
> Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

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

Re: Fw: transaction for parent/child changes

[Robert Halstead]

As I understand it, Remedy doesn't provide a check on who is looking/editing
a record.  The only check Remedy does is a last modified time check.  We are
running into this same issue when multiple people edit the same record.  We
plan to implement a read/read-write locking feature in our own system though
I wish remedy had the ability to lock records down.

On Fri, Feb 6, 2009 at 12:17 PM, Michael Drew 
wrote:

> Depending on the nature of the data, you could perhaps use the table field
> as your temporary storage (I.e. Set field local action to place your various
> values into the currently selected row in the table) and do a table walk to
> send the table values back to the actual child entry's records when you hit
> save on the parent.
> Michael.
>
> --Original Message--
> From: Brien Dieterle
> Sender: Action Request System discussion list(ARSList)
> To: arslist@ARSLIST.ORG
> ReplyTo: arslist@ARSLIST.ORG
> Sent: Feb 6, 2009 3:34 PM
> Subject: transaction for parent/child changes
>
> ** We've designed a form that has child requests displayed in a table list
> field.  You can interact with these child requests through this form and
> update them via display only fields and push-fields activelink buttons etc.
> So the problem is you can update some things on the main form, and update
> some children requests, close the main request and say "yes, lose changes".
> A user might expect that the changes to the children would be reverted back
> to what they were.
>
> Is there any way to encapsulate the whole process of editing the primary
> requests and N children requests into a single transaction that gets
> committed only upon saving of the primary request?
>
> Thanks!
>
> Brien Dieterle
>  __Platinum Sponsor: RMI Solutions 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:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: ARS 7.5 Install Issue

[Elry]

Hi Guys...

We did an upgrade recently in our development and staging environment
much like what started this "thread".

We found that:

1) 7.5 had installations issues - that were dealt with by using patch
1.
2) Even when using patch 1 - we found that we had to do a clean
uninstall before trying again...
3) When you go to install the Clients - 7.5 has a completely different
file structure than 7.1
4) If you install the Clients based on the install defaults - you will
"wind up" with 7.1 & 7.5 on your system.
5) For a complete install of 7.5 without 7.1 - you will have to
uninstall 7.1 before installing 7.5..
6) Our Silent Install script no longer worked because 7.5 uses a
different installer with different prompts...

I am sure there are folks out there with similar insights



On May 26, 9:40 am, Howard Richter  wrote:
> Rafael,
>
> So it sounds like 7.5 should be a new install only.
>
> Howard
>
> On Tue, May 26, 2009 at 8:46 AM, Rodriguez, Rafael J x23718 <
>
>
>
> rafael.rodrig...@broadridge.com> wrote:
> > ** Howard thanks for you reply, actually there were some issues with forms
> > and workflow that did not exists. Funny that 7.0.1 Patch6 never through any
> > exemptions and now on 7.5 there were errors all over the place. The worst
> > part about it is the new suite install that only allow you to install it
> > once. THIS IS A PAIN IN THE BUTT!
>
> > I got it resolved but had to literally unistall it and clean it out
> > numerous times before it would take.
>
> > Rafael
>
> >  --
> > *From:* Action Request System discussion list(ARSList) [mailto:
> > arsl...@arslist.org] *On Behalf Of *Howard Richter
> > *Sent:* Friday, May 22, 2009 9:33 PM
> > *To:* arsl...@arslist.org
> > *Subject:* Re: ARS 7.5 Install Issue
>
> > ** Rafael,
>
> > Any issues with the database?
>
> > Howard
>
> > On Fri, May 22, 2009 at 3:30 PM, Rodriguez, Rafael J x23718 <
> > rafael.rodrig...@broadridge.com> wrote:
>
> >> **
>
> >> Hello list,
>
> >> WIN2003 Server
>
> >> SQL2005
>
> >> I was attempting to upgrade my current dev environment remedy installation
> >> from 7.0.1 patch 6 to 7.5 Patch 1 and I’m getting an error during
> >> installation. The error appears in the event log but there is no errors in
> >> the install_log:
>
> >> Event Type: Error
> >> Event Source: AR System Monitor
> >> Event Category: None
> >> Event ID: 0
> >> Date: 05/22/2009
> >> Time: 1:45:48 PM
> >> User: N/A
> >> Computer: REM4DEV
> >> Description:
> >> 390600 : Failure during SQL operation to the database (ARERR 552)
>
> >> Any ideas?
>
> >> Rafael Rodriguez*|*Manager Remedy/Mid-Tier Enterprise*|*Broadridge
> >> Financial Solutions
>
> >> 2 Journal Square Plaza*|*Jersey City, NJ 07306*|* 201.714.3718 p
>
> >> This message and any attachments are intended only for the use of the 
> >> addressee and
> >> may contain information that is privileged and confidential. If the reader 
> >> of the
> >> message is not the intended recipient or an authorized representative of 
> >> the
> >> intended recipient, you are hereby notified that any dissemination of this
> >> communication is strictly prohibited. If you have received this 
> >> communication in
> >> error, please notify us immediately by e-mail and delete the message and 
> >> any
> >> attachments from your system.
>
> >> _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers 
> >> Are"_
>
> > --
> > Howard Richter
> > Red Hat Certified Technician
> > CompTIA Linux+ Certified
> > ITIL Foundation Certified
> > E-Mail = hbr4...@gmail.com
> > LinkedIn Profile =http://www.linkedin.com/in/hbr4270
> > _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
> > Are"_
>
> > This message and any attachments are intended only for the use of the 
> > addressee and
> > may contain information that is privileged and confidential. If the reader 
> > of the
> > message is not the intended recipient or an authorized representative of the
> > intended recipient, you are hereby notified that any dissemination of this
> > communication is strictly prohibited. If you have received this 
> > communication in
> > error, please notify us immediately by e-mail and delete the message and any
> > attachments from your system.
>
> > _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers 
> > Are"_
>
> --
> Howard Richter
> Red Hat Certified Technician
> CompTIA Linux+ Certified
> ITIL Foundation Certified
> E-Mail = hbr4...@gmail.com
> LinkedIn Profile =http://www.linkedin.com/in/hbr4270
>
> ___
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

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

Re: Changing case of Login Id

[Joel Sender]

Keith,
No offense to Misi's EXCELLENT products, but there might be a more logical
approach to your problem.
Once you've corrected the existing data (escalation or RRR|LoginConv-tool),
create a new/modify filter on the user form to set the LoginID to LOWER.
Only the 'modified' user will need the re-cached and the data is kept clean,
as opposed to getting some records 'dirty' and 'cleaning' them all.
HTH,
Joel
***
Joel Sender


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of Misi Mladoniczky
Sent: Monday, May 25, 2009 10:50 PM
To: arslist@ARSLIST.ORG
Subject: Re: Changing case of Login Id

Hi,

It is a bad idea to modify User-records each night. This will require that
all cached form definitions has to be recached for the modified users...

Our RRR|LoginConv-tool can modify a list of Login Names in all forms or in
the forms of your choise. It works on both custom applications and OOB
applications.

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

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

> Not sure what your environment is but we use an escalation that runs
> nightly that has a SET FIELDS action,
> On the Login Name field (& Primary Email field) set the value to
> LOWER($Login Name$)
>
> I'm sure you could also do this when the initial records is being saved.
>
> Hope this helps
>
> Regards,
> Keith.
> 
> From: Action Request System discussion list(ARSList)
> [mailto:arsl...@arslist.org] On Behalf Of Neha Singhal - VP
> Sent: 22 May 2009 06:39
> To: arslist@ARSLIST.ORG
> Subject: Changing case of Login Id
>
> Hi Everyone,
>
> We have some of the login ids in mixed cases, we need to standardize the
> process by changing them into lowercase.
>
> One approach, we tried is to use 'Authentication Login Name' field, but in
> further testing we got some clichés in this approach.
>
> Is there any other way to achieve it.
>
> Regards,
> Neha
> 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.
>
> --
-
>
> _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
> Are"_
>
> Disclaimer link.  To see it, click the link below, or copy and paste it
> into your browser's address line.
> http://www.citco.com/emaildisclaimer.htm
>
>
>

___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
>
> --
> This message was scanned by ESVA and is believed to be clean.
>
>


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

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

Re: ARS 7.5 Install Issue

[Howard Richter]

Rafael,

So it sounds like 7.5 should be a new install only.

Howard

On Tue, May 26, 2009 at 8:46 AM, Rodriguez, Rafael J x23718 <
rafael.rodrig...@broadridge.com> wrote:

> ** Howard thanks for you reply, actually there were some issues with forms
> and workflow that did not exists. Funny that 7.0.1 Patch6 never through any
> exemptions and now on 7.5 there were errors all over the place. The worst
> part about it is the new suite install that only allow you to install it
> once. THIS IS A PAIN IN THE BUTT!
>
> I got it resolved but had to literally unistall it and clean it out
> numerous times before it would take.
>
> Rafael
>
>  --
> *From:* Action Request System discussion list(ARSList) [mailto:
> arsl...@arslist.org] *On Behalf Of *Howard Richter
> *Sent:* Friday, May 22, 2009 9:33 PM
> *To:* arslist@ARSLIST.ORG
> *Subject:* Re: ARS 7.5 Install Issue
>
> ** Rafael,
>
> Any issues with the database?
>
> Howard
>
> On Fri, May 22, 2009 at 3:30 PM, Rodriguez, Rafael J x23718 <
> rafael.rodrig...@broadridge.com> wrote:
>
>> **
>>
>> Hello list,
>>
>>
>>
>> WIN2003 Server
>>
>> SQL2005
>>
>>
>>
>> I was attempting to upgrade my current dev environment remedy installation
>> from 7.0.1 patch 6 to 7.5 Patch 1 and I’m getting an error during
>> installation. The error appears in the event log but there is no errors in
>> the install_log:
>>
>>
>>
>> Event Type: Error
>> Event Source: AR System Monitor
>> Event Category: None
>> Event ID: 0
>> Date: 05/22/2009
>> Time: 1:45:48 PM
>> User: N/A
>> Computer: REM4DEV
>> Description:
>> 390600 : Failure during SQL operation to the database (ARERR 552)
>>
>>
>>
>>
>>
>> Any ideas?
>>
>>
>>
>> Rafael Rodriguez*|*Manager Remedy/Mid-Tier Enterprise*|*Broadridge
>> Financial Solutions
>>
>> 2 Journal Square Plaza*|*Jersey City, NJ 07306*|* 201.714.3718 p
>>
>>
>>
>> This message and any attachments are intended only for the use of the 
>> addressee and
>> may contain information that is privileged and confidential. If the reader 
>> of the
>> message is not the intended recipient or an authorized representative of the
>> intended recipient, you are hereby notified that any dissemination of this
>> communication is strictly prohibited. If you have received this 
>> communication in
>> error, please notify us immediately by e-mail and delete the message and any
>> attachments from your system.
>>
>> _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_
>>
>>
>
>
> --
> Howard Richter
> Red Hat Certified Technician
> CompTIA Linux+ Certified
> ITIL Foundation Certified
> E-Mail = hbr4...@gmail.com
> LinkedIn Profile = http://www.linkedin.com/in/hbr4270
> _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
> Are"_
>
> This message and any attachments are intended only for the use of the 
> addressee and
> may contain information that is privileged and confidential. If the reader of 
> the
> message is not the intended recipient or an authorized representative of the
> intended recipient, you are hereby notified that any dissemination of this
> communication is strictly prohibited. If you have received this communication 
> in
> error, please notify us immediately by e-mail and delete the message and any
> attachments from your system.
>
> _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_
>
>


-- 
Howard Richter
Red Hat Certified Technician
CompTIA Linux+ Certified
ITIL Foundation Certified
E-Mail = hbr4...@gmail.com
LinkedIn Profile = http://www.linkedin.com/in/hbr4270

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

Re: ARS 7.5 Install Issue

[Ashwin]

Hi Rafeal,
Good to hear that you solved your problem.
You have written - "The worst part about it is the new suite
install that only allow you to install it once."
As far as I know 7.5 installer still supports upgrade
installation and you can run the installer multiple times to
either upgrade or over-write the existing installation.
Can you please elaborate on your statement that you can install
ony once?
Thanks
Ashwin

On Tue, 26 May 2009 08:46 -0400, "Rodriguez, Rafael J x23718"
 wrote:

  **

Howard thanks for you reply, actually there were some issues with
forms and workflow that did not exists. Funny that 7.0.1 Patch6
never through any exemptions and now on 7.5 there were errors all
over the place. The worst part about it is the new suite install
that only allow you to install it once. THIS IS A PAIN IN THE
BUTT!



I got it resolved but had to literally unistall it and clean it
out numerous times before it would take.



Rafael
  

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Howard Richter
Sent: Friday, May 22, 2009 9:33 PM
To: arslist@ARSLIST.ORG
Subject: Re: ARS 7.5 Install Issue




  **

Rafael,



Any issues with the database?



Howard


On Fri, May 22, 2009 at 3:30 PM, Rodriguez, Rafael J x23718
<[1]rafael.rodrig...@broadridge.com> wrote:

  **

Hello list,


WIN2003 Server

SQL2005


I was attempting to upgrade my current dev environment remedy
installation from 7.0.1 patch 6 to 7.5 Patch 1 and I’m getting an
error during installation. The error appears in the event log but
there is no errors in the install_log:


Event Type: Error
Event Source: AR System Monitor
Event Category: None
Event ID: 0
Date: 05/22/2009
Time: 1:45:48 PM
User: N/A
Computer: REM4DEV
Description:
390600 : Failure during SQL operation to the database (ARERR 552)



Any ideas?


 Rafael Rodriguez|Manager Remedy/Mid-Tier Enterprise|Broadridge
   Financial Solutions

  2 Journal Square Plaza|Jersey City, NJ 07306| 201.714.3718 p


This message and any attachments are intended only for the use of the add
ressee and
may contain information that is privileged and confidential. If the reade
r of the
message is not the intended recipient or an authorized representative of
the
intended recipient, you are hereby notified that any dissemination of thi
s
communication is strictly prohibited. If you have received this communica
tion in
error, please notify us immediately by e-mail and delete the message and
any
attachments from your system.

_Platinum Sponsor: [2]rmisoluti...@verizon.net ARSlist: "Where the Answer
s Are"_



  --
  Howard Richter
  Red Hat Certified Technician
  CompTIA Linux+ Certified
  ITIL Foundation Certified
  E-Mail = [3]hbr4...@gmail.com
  LinkedIn Profile = [4]http://www.linkedin.com/in/hbr4270
  _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where
  the Answers Are"_
This message and any attachments are intended only for the use of the add
ressee and
may contain information that is privileged and confidential. If the reade
r of the
message is not the intended recipient or an authorized representative of
the
intended recipient, you are hereby notified that any dissemination of thi
s
communication is strictly prohibited. If you have received this communica
tion in
error, please notify us immediately by e-mail and delete the message and
any
attachments from your system.

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

References

1. mailto:rafael.rodrig...@broadridge.com
2. mailto:rmisoluti...@verizon.net
3. mailto:hbr4...@gmail.com
4. http://www.linkedin.com/in/hbr4270
-- 
  Ashwin
  ashwinkpa...@fastmail.fm

-- 
http://www.fastmail.fm - The professional email service


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

Re: Fw : Log Analyser for ARS 7.1

[David Sanders]

Hi Frex

 

The first column is the actual line number in the log files.  You should be
able to scroll through to this line number and see the warning there.

 

David Sanders

Remedy Solution Architect

Enterprise Service Suite @ Work

==

 

tel +44 1494 468980

mobile +44 7710 377761

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

 

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

 

  _  

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Frex Popo
Sent: Tuesday, May 26, 2009 1:33 PM
To: arslist@ARSLIST.ORG
Subject: Re: Fw : Log Analyser for ARS 7.1

 

** 


I checked for MSG and ORA as well just in case.

--- En date de : Mar 26.5.09, Frex Popo  a écrit :


De: Frex Popo 
Objet: Re: Fw : Log Analyser for ARS 7.1
À: arslist@ARSLIST.ORG
Date: Mardi 26 Mai 2009, 14h25


Hello Dave,

 

I checked the file and all I can see are selects, updates and inserts and OK
and commit transaction statements. I greped for ERROR, ARERROR, FAIL, WARN
and can't see any of these in my log file. Anything else to look for?

 

Thanks

frex



--- En date de : Mar 26.5.09, David Sanders
 a écrit :


De: David Sanders 
Objet: Re: Fw : Log Analyser for ARS 7.1
À: arslist@ARSLIST.ORG
Date: Mardi 26 Mai 2009, 13h19

** 

Hi Frex

 

This is not a corruption of the log files – this is content from your log
files.  This is saying that your production remedy server logged SQL errors
– you need to look at the content of these log lines to see what the
offending errors were and what your server was trying to do. 

  

HTH 

  

David Sanders

Remedy Solution Architect 

Enterprise Service Suite @ Work 

== 

  

tel +44 1494 468980 

mobile +44 7710 377761 

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

  

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

  

  _  

From: Action Request System discussion list(ARSList) [mailto:

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

Re: ARS 7.5 Install Issue

[Rodriguez, Rafael J x23718]

Howard thanks for you reply, actually there were some issues with forms
and workflow that did not exists. Funny that 7.0.1 Patch6 never through
any exemptions and now on 7.5 there were errors all over the place. The
worst part about it is the new suite install that only allow you to
install it once. THIS IS A PAIN IN THE BUTT!
 
I got it resolved but had to literally unistall it and clean it out
numerous times before it would take.
 
Rafael



From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Howard Richter
Sent: Friday, May 22, 2009 9:33 PM
To: arslist@ARSLIST.ORG
Subject: Re: ARS 7.5 Install Issue


** 
Rafael,
 
Any issues with the database?
 
Howard


On Fri, May 22, 2009 at 3:30 PM, Rodriguez, Rafael J x23718
 wrote:


** 

Hello list,

 

WIN2003 Server

SQL2005

 

I was attempting to upgrade my current dev environment remedy
installation from 7.0.1 patch 6 to 7.5 Patch 1 and I'm getting an error
during installation. The error appears in the event log but there is no
errors in the install_log:

 

Event Type: Error
Event Source: AR System Monitor
Event Category: None
Event ID: 0
Date: 05/22/2009
Time: 1:45:48 PM
User: N/A
Computer: REM4DEV
Description:
390600 : Failure during SQL operation to the database (ARERR
552) 

 

 

Any ideas?

 

Rafael Rodriguez|Manager Remedy/Mid-Tier Enterprise|Broadridge
Financial Solutions

2 Journal Square Plaza|Jersey City, NJ 07306| 201.714.3718 p



 

This message and any attachments are intended only for the use
of the addressee and
may contain information that is privileged and confidential. If
the reader of the 
message is not the intended recipient or an authorized
representative of the
intended recipient, you are hereby notified that any
dissemination of this
communication is strictly prohibited. If you have received this
communication in
error, please notify us immediately by e-mail and delete the
message and any
attachments from your system.

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




-- 
Howard Richter
Red Hat Certified Technician
CompTIA Linux+ Certified
ITIL Foundation Certified 
E-Mail = hbr4...@gmail.com
LinkedIn Profile = http://www.linkedin.com/in/hbr4270
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
Are"_ 

This message and any attachments are intended only for the use of the addressee 
and
may contain information that is privileged and confidential. If the reader of 
the 
message is not the intended recipient or an authorized representative of the
intended recipient, you are hereby notified that any dissemination of this
communication is strictly prohibited. If you have received this communication in
error, please notify us immediately by e-mail and delete the message and any
attachments from your system.


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

Re: Fw : Log Analyser for ARS 7.1

[Frex Popo]

I checked for MSG and ORA as well just in case.

--- En date de : Mar 26.5.09, Frex Popo  a écrit :


De: Frex Popo 
Objet: Re: Fw : Log Analyser for ARS 7.1
À: arslist@ARSLIST.ORG
Date: Mardi 26 Mai 2009, 14h25







Hello Dave,
 
I checked the file and all I can see are selects, updates and inserts and OK 
and commit transaction statements. I greped for ERROR, ARERROR, FAIL, WARN and 
can't see any of these in my log file. Anything else to look for?
 
Thanks
frex

--- En date de : Mar 26.5.09, David Sanders 
 a écrit :


De: David Sanders 
Objet: Re: Fw : Log Analyser for ARS 7.1
À: arslist@ARSLIST.ORG
Date: Mardi 26 Mai 2009, 13h19


** 





Hi Frex
 
This is not a corruption of the log files – this is content from your log 
files.  This is saying that your production remedy server logged SQL errors – 
you need to look at the content of these log lines to see what the offending 
errors were and what your server was trying to do. 
  
HTH 
  

David Sanders
Remedy Solution Architect 
Enterprise Service Suite @ Work 
== 
  
tel +44 1494 468980 
mobile +44 7710 377761 
email david.sand...@westoverconsulting.co.uk 
  
web http://www.westoverconsulting.co.uk 
  




From: Action Request System discussion list(ARSList) [mailto: 
arslist@ARSLIST.ORG ] On Behalf Of Frex Popo
Sent: Tuesday, May 26, 2009 12:04 PM
To: arslist@ARSLIST.ORG
Subject: Re : Fw : Log Analyser for ARS 7.1
  
** 





Hello all,

 

Has anyone using arwklga.exe, came across this error while analysing log files.

 

I have tested logs generated by dev server and all seem to work fine, I get a 
decent report with all the stats. I try to do the same with log files from 
production and get the following errors! Was thinking the log file got 
corrupted while copying it across but this wasn't the case. Any ideas as what 
it could be?

 

Kind Regards

frex

 

SQL EXCEPTION REPORT

Line No. Command   Message 
 - 
   
  94 /*    WARNING: Unexpected SQL command 
  95 /*    WARNING: Unexpected SQL command 
 267 /*    WARNING: Unexpected SQL command 
 270 /*    WARNING: Unexpected SQL command 
 276 /*    WARNING: Unexpected SQL command 
 277 /*    WARNING: Unexpected SQL command
 278 /*    WARNING: Unexpected SQL command 
 279 /*    WARNING: Unexpected SQL command 
 280 /*    WARNING: Unexpected SQL command 
 281 /*    WARNING: Unexpected SQL command 
 282 /*    WARNING: Unexpected SQL command 
 283 /*    WARNING: Unexpected SQL command  

 


--- En date de : Lun 25.5.09, Frex Popo  a écrit :


De: Frex Popo 
Objet: Fw : Log Analyser for ARS 7.1
À: arslist@ARSLIST.ORG
Date: Lundi 25 Mai 2009, 13h15 






somone kindly sent me the link :)


Thanks

--- En date de : Lun 25.5.09, Frex Popo  a écrit :


De: Frex Popo 
Objet: Log Analyser for ARS 7.1
À: arslist@ARSLIST.ORG
Date: Lundi 25 Mai 2009, 11h46 






Dear all,


 

I have some performance issues with our Remedy server (ARS 7.1) and as a 
starting point I have enabled the SQL/API logs. I need to analyse these, but 
doing it manually is quite time consuming. so... does anyone have a link to the 
arwklga.exe utility for download. I checked the Dev Community but could not 
find it.

 

Many thanks in advance

frex



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





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

Re: Fw : Log Analyser for ARS 7.1

[Frex Popo]

Hello Dave,
 
I checked the file and all I can see are selects, updates and inserts and OK 
and commit transaction statements. I greped for ERROR, ARERROR, FAIL, WARN and 
can't see any of these in my log file. Anything else to look for?
 
Thanks
frex

--- En date de : Mar 26.5.09, David Sanders 
 a écrit :


De: David Sanders 
Objet: Re: Fw : Log Analyser for ARS 7.1
À: arslist@ARSLIST.ORG
Date: Mardi 26 Mai 2009, 13h19


** 





Hi Frex
 
This is not a corruption of the log files – this is content from your log 
files.  This is saying that your production remedy server logged SQL errors – 
you need to look at the content of these log lines to see what the offending 
errors were and what your server was trying to do.
 
HTH
 

David Sanders
Remedy Solution Architect
Enterprise Service Suite @ Work
==
 
tel +44 1494 468980
mobile +44 7710 377761
email david.sand...@westoverconsulting.co.uk
 
web http://www.westoverconsulting.co.uk
 




From: Action Request System discussion list(ARSList) [mailto: 
arslist@ARSLIST.ORG ] On Behalf Of Frex Popo
Sent: Tuesday, May 26, 2009 12:04 PM
To: arslist@ARSLIST.ORG
Subject: Re : Fw : Log Analyser for ARS 7.1
 
** 





Hello all,

 

Has anyone using arwklga.exe, came across this error while analysing log files.

 

I have tested logs generated by dev server and all seem to work fine, I get a 
decent report with all the stats. I try to do the same with log files from 
production and get the following errors! Was thinking the log file got 
corrupted while copying it across but this wasn't the case. Any ideas as what 
it could be?

 

Kind Regards

frex

 

SQL EXCEPTION REPORT

Line No. Command   Message 
 - 
   
  94 /*    WARNING: Unexpected SQL command 
  95 /*    WARNING: Unexpected SQL command 
 267 /*    WARNING: Unexpected SQL command 
 270 /*    WARNING: Unexpected SQL command 
 276 /*    WARNING: Unexpected SQL command 
 277 /*    WARNING: Unexpected SQL command
 278 /*    WARNING: Unexpected SQL command 
 279 /*    WARNING: Unexpected SQL command 
 280 /*    WARNING: Unexpected SQL command 
 281 /*    WARNING: Unexpected SQL command 
 282 /*    WARNING: Unexpected SQL command 
 283 /*    WARNING: Unexpected SQL command  

 


--- En date de : Lun 25.5.09, Frex Popo  a écrit :


De: Frex Popo 
Objet: Fw : Log Analyser for ARS 7.1
À: arslist@ARSLIST.ORG
Date: Lundi 25 Mai 2009, 13h15






somone kindly sent me the link :)

Thanks

--- En date de : Lun 25.5.09, Frex Popo  a écrit :


De: Frex Popo 
Objet: Log Analyser for ARS 7.1
À: arslist@ARSLIST.ORG
Date: Lundi 25 Mai 2009, 11h46






Dear all,

 

I have some performance issues with our Remedy server (ARS 7.1) and as a 
starting point I have enabled the SQL/API logs. I need to analyse these, but 
doing it manually is quite time consuming. so... does anyone have a link to the 
arwklga.exe utility for download. I checked the Dev Community but could not 
find it.

 

Many thanks in advance

frex



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




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

OT: ARUtilities 7.5 release

[remedy]

Hello Everyone,
I wanted to let you know that ARUtilities 7.5 has been released. This
version is for those of you supporting ARS 7.5 servers.

For more information about ARUtilities 7.5 visit http://www.arutilities.com
To offer suggestions send me an email at feedb...@arutilities.com
If you have an issue send me an email at supp...@arutilities.com

Thank you for your support.

Les Ganton
http://www.arutilities.com

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

Re: Fw : Log Analyser for ARS 7.1

[David Sanders]

Hi Frex

 

This is not a corruption of the log files – this is content from your log
files.  This is saying that your production remedy server logged SQL errors
– you need to look at the content of these log lines to see what the
offending errors were and what your server was trying to do.

 

HTH

 

David Sanders

Remedy Solution Architect

Enterprise Service Suite @ Work

==

 

tel +44 1494 468980

mobile +44 7710 377761

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

 

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

 

  _  

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Frex Popo
Sent: Tuesday, May 26, 2009 12:04 PM
To: arslist@ARSLIST.ORG
Subject: Re : Fw : Log Analyser for ARS 7.1

 

** 


Hello all,

 

Has anyone using arwklga.exe, came across this error while analysing log
files.

 

I have tested logs generated by dev server and all seem to work fine, I get
a decent report with all the stats. I try to do the same with log files from
production and get the following errors! Was thinking the log file got
corrupted while copying it across but this wasn't the case. Any ideas as
what it could be?

 

Kind Regards

frex

 

SQL EXCEPTION REPORT

Line No. Command   Message

 -

 

  94 /*WARNING: Unexpected SQL command

  95 /*WARNING: Unexpected SQL command

 267 /*WARNING: Unexpected SQL command

 270 /*WARNING: Unexpected SQL command

 276 /*WARNING: Unexpected SQL command

 277 /*WARNING: Unexpected SQL command
 278 /*WARNING: Unexpected SQL command

 279 /*WARNING: Unexpected SQL command

 280 /*WARNING: Unexpected SQL command

 281 /*WARNING: Unexpected SQL command

 282 /*WARNING: Unexpected SQL command

 283 /*WARNING: Unexpected SQL command  

 


--- En date de : Lun 25.5.09, Frex Popo  a écrit :


De: Frex Popo 
Objet: Fw : Log Analyser for ARS 7.1
À: arslist@ARSLIST.ORG
Date: Lundi 25 Mai 2009, 13h15


somone kindly sent me the link :)

Thanks

--- En date de : Lun 25.5.09, Frex Popo  a écrit :


De: Frex Popo 
Objet: Log Analyser for ARS 7.1
À: arslist@ARSLIST.ORG
Date: Lundi 25 Mai 2009, 11h46


Dear all,

 

I have some performance issues with our Remedy server (ARS 7.1) and as a
starting point I have enabled the SQL/API logs. I need to analyse these, but
doing it manually is quite time consuming. so... does anyone have a link to
the arwklga.exe utility for download. I checked the Dev Community but could
not find it.

 

Many thanks in advance

frex






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


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

Re: Fw : Log Analyser for ARS 7.1

[Mark Lev]

http://communities.bmc.com/communities/docs/DOC-1010

 

 

Thanks,

Mark

 

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Ashwin
Sent: Tuesday, May 26, 2009 5:42 AM
To: arslist@ARSLIST.ORG
Subject: Re: Fw : Log Analyser for ARS 7.1

 

** 

Can you please share the same?

 

Thanks

Ashwin

 

 

On Mon, 25 May 2009 11:15 +, "Frex Popo"  wrote:

 

** 

somone kindly sent me the link :)

Thanks

--- En date de : Lun 25.5.09, Frex Popo  a écrit :
 


De: Frex Popo 
Objet: Log Analyser for ARS 7.1
À: arslist@ARSLIST.ORG
Date: Lundi 25 Mai 2009, 11h46

Dear all,

 

I have some performance issues with our Remedy server (ARS 7.1) and as a 
starting point I have enabled the SQL/API logs. I need to analyse these, but 
doing it manually is quite time consuming. so... does anyone have a link to the 
arwklga.exe utility for download. I checked the Dev Community but could not 
find it.

 

Many thanks in advance

frex


 


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

-- 
  Ashwin
  ashwinkpa...@fastmail.fm
 
-- 
http://www.fastmail.fm - Accessible with your email software
  or over the web

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


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

Re: Fw : Log Analyser for ARS 7.1

[Frex Popo]

Of course :)
 
http://communities.bmc.com/communities/docs/DOC-2973
 


--- En date de : Mar 26.5.09, Ashwin  a écrit :


De: Ashwin 
Objet: Re: Fw : Log Analyser for ARS 7.1
À: arslist@ARSLIST.ORG
Date: Mardi 26 Mai 2009, 11h42


** 
#yiv1017355954 
{padding:1ex;margin:0px;font-family:sans-serif;font-size:small;}#yiv1017355954 
a[href]{}#yiv1017355954 blockquote{margin:0;border-left:2px solid 
#144fae;padding-left:1em;}#yiv1017355954 blockquote 
blockquote{border-color:#006312;}#yiv1017355954 blockquote blockquote 
blockquote{border-color:#54;}


Can you please share the same?
 
Thanks
Ashwin
 
 
On Mon, 25 May 2009 11:15 +, "Frex Popo"  wrote:
 
** 




somone kindly sent me the link :)
Thanks

--- En date de : Lun 25.5.09, Frex Popo  a écrit :
 

De: Frex Popo 
Objet: Log Analyser for ARS 7.1
À: arslist@ARSLIST.ORG
Date: Lundi 25 Mai 2009, 11h46







Dear all,
 
I have some performance issues with our Remedy server (ARS 7.1) and as a 
starting point I have enabled the SQL/API logs. I need to analyse these, but 
doing it manually is quite time consuming. so... does anyone have a link to the 
arwklga.exe utility for download. I checked the Dev Community but could not 
find it.
 
Many thanks in advance
frex
 
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_-- 
  Ashwin
  ashwinkpa...@fastmail.fm
-- 
http://www.fastmail.fm - Accessible with your email software
                          or over the web
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ 




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

Re : Fw : Log Analyser for ARS 7.1

[Frex Popo]

Hello all,
 
Has anyone using arwklga.exe, came across this error while analysing log files.
 
I have tested logs generated by dev server and all seem to work fine, I get a 
decent report with all the stats. I try to do the same with log files from 
production and get the following errors! Was thinking the log file got 
corrupted while copying it across but this wasn't the case. Any ideas as what 
it could be?
 
Kind Regards
frex

 
SQL EXCEPTION REPORT
Line No. Command   Message 
 - 
   
  94 /*    WARNING: Unexpected SQL command 
  95 /*    WARNING: Unexpected SQL command 
 267 /*    WARNING: Unexpected SQL command 
 270 /*    WARNING: Unexpected SQL command 
 276 /*    WARNING: Unexpected SQL command 
 277 /*    WARNING: Unexpected SQL command
 278 /*    WARNING: Unexpected SQL command 
 279 /*    WARNING: Unexpected SQL command 
 280 /*    WARNING: Unexpected SQL command 
 281 /*    WARNING: Unexpected SQL command 
 282 /*    WARNING: Unexpected SQL command 
 283 /*    WARNING: Unexpected SQL command  
 

--- En date de : Lun 25.5.09, Frex Popo  a écrit :


De: Frex Popo 
Objet: Fw : Log Analyser for ARS 7.1
À: arslist@ARSLIST.ORG
Date: Lundi 25 Mai 2009, 13h15







somone kindly sent me the link :)
Thanks

--- En date de : Lun 25.5.09, Frex Popo  a écrit :


De: Frex Popo 
Objet: Log Analyser for ARS 7.1
À: arslist@ARSLIST.ORG
Date: Lundi 25 Mai 2009, 11h46







Dear all,
 
I have some performance issues with our Remedy server (ARS 7.1) and as a 
starting point I have enabled the SQL/API logs. I need to analyse these, but 
doing it manually is quite time consuming. so... does anyone have a link to the 
arwklga.exe utility for download. I checked the Dev Community but could not 
find it.
 
Many thanks in advance
frex






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

Re: Fw : Log Analyser for ARS 7.1

[Ashwin]

Can you please share the same?

Thanks
Ashwin


On Mon, 25 May 2009 11:15 +, "Frex Popo" 
wrote:

  **

 somone kindly sent me the link :)
 Thanks
 --- En date de : Lun 25.5.09, Frex Popo  a
 écrit :

   De: Frex Popo 
   Objet: Log Analyser for ARS 7.1
   À: arslist@ARSLIST.ORG
   Date: Lundi 25 Mai 2009, 11h46


  Dear all,

  I have some performance issues with our Remedy server (ARS 7.1)
  and as a starting point I have enabled the SQL/API logs. I need
  to analyse these, but doing it manually is quite time consuming.
  so... does anyone have a link to the arwklga.exe utility for
  download. I checked the Dev Community but could not find it.

  Many thanks in advance
  frex


  _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where
  the Answers Are"_
-- 
  Ashwin
  ashwinkpa...@fastmail.fm

-- 
http://www.fastmail.fm - Accessible with your email software
  or over the web


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