error while sending emails

[Saravanan Palaniappan]

Hi all,

 

I am trying to send an email from the server . but the Arsystem email
messages form displays "error".

When I checked the email error log I am finding the below mentioned
errors.

 

null 

java.lang.NullPointerException

at
com.remedy.arsys.emaildaemon.CreatorModule.cleanUpMemory(CreatorModule.j
ava:314)

at
com.remedy.arsys.emaildaemon.CreatorModule.doWork(CreatorModule.java:390
)

at
com.remedy.arsys.emaildaemon.ThreadBase.run(ThreadBase.java:268)

at java.lang.Thread.run(Thread.java:595)

 

Please help me on this if you have faced it

 

Thanks & Regards

Saravanan Palaniappan

ITSM

 

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

 



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

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

Re: SuSE Linux ARIMPORT

[Michiel Beijen]

That's the first time I've heard someone address arimportcmd as 'awesome'...
--
Michiel

On Wed, Mar 26, 2008 at 11:44 PM, LJ Longwing <[EMAIL PROTECTED]> wrote:

> ** That is awesome news, I'll go grab the latest linux distribution of the
> file.  Thanks
>
>  --
> *From:* Action Request System discussion list(ARSList) [mailto:
> [EMAIL PROTECTED] *On Behalf Of *Michiel Beijen
> *Sent:* Wednesday, March 26, 2008 4:05 PM
> *To:* arslist@ARSLIST.ORG
> *Subject:* Re: SuSE Linux ARIMPORT
>
> ** Actually, there is no 'Red Hat' version -- just the Linux version of
> arimportcmd and will work on SUSE as well as on Red Hat - check the
> Compatibility Matrix for the supported versions. So the answer is YES.
>
>
> --
> Met vriendelijke groet / Kind regards
> Michiel Beijen
> __
> MANSOLUTIONS
> Energieweg 60-62
> 3771 NA Barneveld
> The Netherlands
> Tel. +31-(0)612968592
> Mail [EMAIL PROTECTED]
> Internet http://bsm.mansolutions.nl
>
> On Wed, Mar 26, 2008 at 10:52 PM, LJ Longwing <[EMAIL PROTECTED]>
> wrote:
>
> > ** I'm looking for an arimportcmd for SuSE Linux, does anyone know if
> > the redhat one will run?  Will those libraries work on it?
> > __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: error while sending emails

[Misi Mladoniczky]

Hi!

You will probably find the specific outgoing message with an Error-status
in AR System Email Messages.

Try to resend it to see if something in the record is the problem.

Set the debug mode to truee to see exactly what happens if you are able to
reproduce the problem.

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.

>
> Hi all,
>
>
>
> I am trying to send an email from the server . but the Arsystem email
> messages form displays "error".
>
> When I checked the email error log I am finding the below mentioned
> errors.
>
>
>
> null
>
> java.lang.NullPointerException
>
> at
> com.remedy.arsys.emaildaemon.CreatorModule.cleanUpMemory(CreatorModule.j
> ava:314)
>
> at
> com.remedy.arsys.emaildaemon.CreatorModule.doWork(CreatorModule.java:390
> )
>
> at
> com.remedy.arsys.emaildaemon.ThreadBase.run(ThreadBase.java:268)
>
> at java.lang.Thread.run(Thread.java:595)
>
>
>
> Please help me on this if you have faced it
>
>
>
> Thanks & Regards
>
> Saravanan Palaniappan
>
> ITSM
>
>
>
> "To teach and to learn, to laugh and make others laugh.  This is my
> purpose.  Any day I don't do this was not worth the time it took to get
> through it."
>
>
>
>
>
> -
> This message, including any attachments, contains confidential information
> intended for a specific individual and purpose, and is intended for the
> addressee only. Any unauthorized disclosure, use, dissemination, copying,
> or distribution of this message or any of its attachments or the
> information contained in this e-mail, or the taking of any action based on
> it, is strictly prohibited. If you are not the intended recipient, please
> notify the sender immediately by return e-mail and delete this message.
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
> --
> This message was scanned by ESVA and is believed to be clean.
>
>

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

NetAct and Ventyx Integrations

[Wayne Keenan]

Hi,

I was wondering if anyone had any details on NetAct and Ventyx integration
with Remedy, product info or project related.
I'm comfortable with any sort of integration, be it DB, SOAP, RPC, C/Java,
etc, as I'm after details for ways of communication (transports, e.g RPC,
JMS) and the operations and message types (e.g. CStruct, XML Schema)
supported by each product.

Any added experience that you have of how that information was mapped to ARS
would also be of use. :)


Regards
Wayne

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

Auto-Close Help Desk Problems (ITSM 5.6)

[BROTONS Oscar]

Hello,

I have seen that our Help desk Cases Type problem are not automatically
closed because the escalation HPD:HPD-AutoClose has ($TIMESTAMP$ >
'Auto-close Time') AND ( 'Status' = "Resolved") AND (( 'IncidentID' !=
"Original" ) OR ( 'IncidentID' =  $NULL$ )) as condition.

It's standard or could be a customization?

If it's standard, it must be a problem manager who manually closes the
problems?

 Thank you.

Regards.

Oscar Brotons.
IT Consultant.


**
IMPORTANT: This message is intended exclusively for information purposes. It 
cannot be considered as an 
official OHIM communication concerning procedures laid down in the Community 
Trade Mark Regulations 
and Designs Regulations. It is therefore not legally binding on the OHIM for 
the purpose of those procedures.
The information contained in this message and attachments is intended solely 
for the attention and use of the 
named addressee and may be confidential. If you are not the intended recipient, 
you are reminded that the 
information remains the property of the sender. You must not use, disclose, 
distribute, copy, print or rely on this 
e-mail. If you have received this message in error, please contact the sender 
immediately and irrevocably 
delete or destroy this message and any copies.

**

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

Re: OT: Defect - Send To, Mail Recipient

[T. Dee]

Unfortunately I don't think they will fix this as they indicated they
are phasing out the User Tool.

Thanks for the tip, I will look at it - I know the users are not happy
with this not working.

Ty


On 3/26/08, Michiel Beijen <[EMAIL PROTECTED]> wrote:
> ** Yup; great, isn't it?
> In ITSM 6 the Case ID of the Helpdesk Ticket was in Field 1; in ITSM 7 they
> use a NumGenerator form and all sorts of other fancy stuff to generate the
> numbers. And; in essention the NumGenerator form stores the number in field
> 1
>
> I would say, put another RFE in for this. BMC counts these as 'votes'  for a
> specific functionality.
> My guess is that it might be improved/changed/etc in the future, also for
> another reason: it is not available in the mid-tier and BMC wants to align
> the two clients as much as possible.
>
> By the way; you could create much the same 'functionality' by using the
> PERFORM-ACTION-OPEN-URL in combination with a MAILTO:Url. See also:
> http://www.ianr.unl.edu/internet/mailto.html
>
> The only drawback is that this does not attach the .artask attachments - but
> with a little workflow you can put together a URL to the ticket in the
> mid-tier.
>
>
> --
> Met vriendelijke groet / Kind regards
> Michiel Beijen
> __
> MANSOLUTIONS
> Energieweg 60-62
> 3771 NA Barneveld
> The Netherlands
> Tel. +31-(0)612968592
> Mail [EMAIL PROTECTED]
> Internet http://bsm.mansolutions.nl
>
>
> On Wed, Mar 26, 2008 at 4:36 PM, T. Dee <[EMAIL PROTECTED]> wrote:
> >
> > Just an FYI to those of you who use the User Tool and use ITSM 7.0.
> >
> > If you try and use the Send To, Mail Recipient feature you will see
> > that the subject line of the email refers to a different Change,
> > Incident, Problem, etc. number then the record you are on (which ever
> > one you are using).
> >
> > According to Remedy this is NOT a Defect.  Remedy said the Send To,
> > Mail Recipient feature is grabbing field 1 (Request ID).  However, the
> > modules do not use field 1 Request ID, thus NO MATCH.
> >
> > Remedy says there is a RFE open for this.
> >
> > :-(
> >
> >
> ___
> > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
> >
>
>
>
> __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"

Remdy position available Phila, PA suburbs (west of phila)

[[EMAIL PROTECTED]]

Looking for mid-level to senior Remedy developer to hit the ground
running in a fairly large (windows / 7.0.1 / ITSM) shop based in the
Phila, PA suburbs (west of phila) area.

Please contact me for details.

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

CMDB Relationships

[Kevin Murray]

Hi All,

I'm trying to figure out how best to map some "relationships" in the
CMDB. If anyone has any guidance if would
be appreciated.

Scenarios:

We have two switches, both considered in-use at any point in time.
They are considered peers in one sense, but in another, one of the
switches is considered the primary switch for a business service, in
the event there is a problem with it, the second switch is considered
the primary switch for the business service. If you have this
scenario, how have you mapped it in the CMDB, in terms of the
relatioship between the switches to acknowledge this configuration?

On a similar vein, How have others mapped software clusters where
there is a active/passive configuration?

Have you had to add data attributes at the CI layer to describe these
scenarios more crisply, or have you used OOTB relationship types or
added your own.

Thanks,
Kevin

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

Re: Remedy WUT & Crystal Reports (U)

[Hennigan, Sandra H CTR OSD-CIO]

UNCLASSIFIED

Yes - it is the workstation not his Remedy account or install but it is
only his workstation.

Sandra Hennigan

OSD Enterprise Remedy Administrator
Office # 703-602-2525 x248

Apparently, there is nothing that cannot happen today.  Mark Twain

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Susan Palmer
Sent: Wednesday, March 26, 2008 5:38 PM
To: arslist@ARSLIST.ORG
Subject: Re: Remedy WUT & Crystal Reports (U)


** Does it work for him when he's on a different PC?


On Wed, Mar 26, 2008 at 4:23 PM, Hennigan, Sandra H CTR OSD-CIO
<[EMAIL PROTECTED]> wrote:


UNCLASSIFIED

Application-
Windows 2003 server
SQL 2000
ARS 6.3 patch 21
Help Desk 5.5

Crystal Report reports running on ARS are in version 8.5

User-
Windows XP (not sure the SP level)
Remedy WUT 6.3 patch 20

All Remedy users can open, print, export the Crystal Report
reports that
run from Active Links to any of the Destinations displayed
Except ONE user
Out of over 400

This one user cannot send, in any format, a Crystal Report to Disk
File
He can export to Destination Application or MAPI without error

He receives the dialog to Export, can select the format, can
select the
Destination.
He can select Disk file.  When he clicks OK - nothing.  No error;
no
action.

I have completely removed the Remedy install; rebooted.
Cleaned the registry.
Installed Remedy to different locales.
Given him local admin permissions.
Installed Crystal Reports
Configured ODBC drivers

Removed everything and started again.
Had other admin perform the same drill

Printing works OK
Crystal Reports works OK; he can export the report to Crystal
Reports
and open the report
Adobe works OK; he can export the report to Adobe and open the
report

This one user cannot send, in any format, a Crystal Report to Disk
File
from Remedy.

Any ideas?

Sandra Hennigan
Enterprise Remedy Administrator

Apparently, there is nothing that cannot happen today.  Mark Twain


__
_
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org

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



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


smime.p7s
Description: S/MIME cryptographic signature

ARS6.3 + SQL Question (UNCLASSIFIED)

[Bennett, Charlie CTR MDA/DOCC]

Classification:  UNCLASSIFIED 
Caveats: NONE

Hi All!

I'm having a small problem getting my Remedy 6.3 app to talk to a remote
MSSQL Server 2K SP3 database running on a Win2k3, SP2 machine.  My AR server
is running on a Win2k SP4 machine, with the AR System database running on a
MSSQL Server 2K SP4 database on the same machine.

I've created an active link to grab some user information stored in the
remote server upon Return/Table or Level Dbl-Clk in a Set Field (SQL) action
- it's supposed to go out, query based on the name entered into a submitter
field and find possible matches and populate related user info fields, or
display a select list if multiple matches come back.  Here's a chopped down
and simplified version of the query I'm working with (I've simplified it as
much as possible, but to no avail):

SELECT FirstName, LastName FROM SERVERNAME.phonebook.dbo.vw_tbl_ARS TARS
WHERE TARS.LastName LIKE '%$Submitter$%'

I've verified that I've got DTC running on both machines.  I've set the
remote server up as a linked server, with it set to impersonate with a
specific security context.  I've verified this is working because I can see
the views/tables under the linked server in EntpMgr.  I am able to run the
above query from my active link in QryAlzr just fine.  However, when I go in
through the user tool and enter a name into the submitter field and fire the
active link, I get this error:


"ARERR [552] Failure during SQL operation to the database : The ROLLBACK
TRANSACTION request has no corresponding BEGIN TRANSACTION. (SQL Server
3903)
The preceding message occurred during the execution of active link
+NTFAR:050-Set Submitter Info - TEST -- action 1. (ARNOTE 1101)"


I'm at the end of my rope here.  Hopefully someone has seen this before and
knows what's up.  Perhaps I'm overlooking something embarassingly silly
here?  - I hope so!

Thanks in advance!!


Charlie Bennett
Remedy Developer
Missile Defense Integration & Operations Center
Schriever AFB
Colorado Springs, CO
(719) 721-7470 

Classification:  UNCLASSIFIED 
Caveats: NONE


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


smime.p7s
Description: S/MIME cryptographic signature

Re: Handling email replies to notifications in ITSM 7

[Benedetto Cantatore]

I set this functionality up at my last company.  I know from previous
discussions on this that other admins have their own take on how to
implement.  My method is this:  Instruct users to not touch the subject
line.  My workflow hinges on having the full 15 characters.  I then key
off the 0 in the subject line.  Its not full proof, but if user are not
tampering with the subject line, then this works fine.
 
Once I find the 0, I subtract 3 characters to get the start position. 
I then retrieve 15 characters from the start position and store that in
a field.  That should be your ticket number.
 
Use a like statement with the prefix to determine which module's
worklog you need to route to.  Set up a push field action and push over
what you want to that worklog.  Create a filter for each of the modules
that you'll do a push to.  
 
Obviously I glossed over a lot of details, but that's the general gist
of how I did it.  Hopefully that'll spark ideas on how to get it done
for your company.  I'll be happy to respond to specific questions.

>>> [EMAIL PROTECTED] 03/26/08 11:17 PM >>>

After over 7 years of running Rem-Mail with my Help Desk 4.0 and 5.5
systems, it will be hard to convince my users that there is nothing in
ITSM 7 to reply to.  I have observed several lengthy "conversations"
about handling incoming email over the last year +, but have had to
ignore them while fighting other battles to get our system ready for
production.  Since several of you have addressed this problem already,
what are your opinions on the best (and simplest) ways to turn a
customer's reply to a notification into a work log entry (which is
what
we do now in Rem-Mail)?  Or is there a better tactic?  I am familiar
with creating a work log entry for a specific Incident since we are
already doing that from follow-up service items in Kinetic Request.
Unlike the HPD:IncidentInterface_Create form (which works just fine
for
creating incidents), I have found that the HPD:IncidentInterface join
form is virtually impossible to work with (and endangers existing
data)
so that I would much rather work directly in the HPD:WorkLog form.

So, what has worked best for those of you who have already tackled
this
issue??

ARS and AREmail 7.1.00.002
ITSM 7.0.02/03.007
SLM 7.1.00
Win2K3 Ent x64
Exchange Server 2000 (yeah, really - I know I need to upgrade...)

I don't have to worry too much about people replying to the SLM
notifications, now that I know that the integration to Incident
Management was improperly designed and fails to send any of them to
assigned support groups; there damn near aren't any going out!! :(

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

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


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

Re: ARS6.3 + SQL Question (UNCLASSIFIED)

[Heider, Stephen]

Charlie,

Use an OPENQUERY in a local SQL View that points to the remote server.

CREATE VIEW dbo.uvw_MyRemoteView
AS
SELECT * FROM OPENQUERY(SERVERNAME, 'SELECT FirstName, LastName FROM
SERVERNAME.phonebook.dbo.vw_tbl_ARS')


Then in your workflow: 

SELECT FirstName, LastName FROM uvw_MyRemoteView WHERE LastName LIKE
'%$Submitter$%'


Stephen
Remedy Skilled Professional

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Bennett, Charlie CTR MDA/DOCC
Sent: Thursday, March 27, 2008 8:52 AM
To: arslist@ARSLIST.ORG
Subject: ARS6.3 + SQL Question (UNCLASSIFIED)

Classification:  UNCLASSIFIED 
Caveats: NONE

Hi All!

I'm having a small problem getting my Remedy 6.3 app to talk to a remote
MSSQL Server 2K SP3 database running on a Win2k3, SP2 machine.  My AR
server
is running on a Win2k SP4 machine, with the AR System database running
on a
MSSQL Server 2K SP4 database on the same machine.

I've created an active link to grab some user information stored in the
remote server upon Return/Table or Level Dbl-Clk in a Set Field (SQL)
action
- it's supposed to go out, query based on the name entered into a
submitter
field and find possible matches and populate related user info fields,
or
display a select list if multiple matches come back.  Here's a chopped
down
and simplified version of the query I'm working with (I've simplified it
as
much as possible, but to no avail):

SELECT FirstName, LastName FROM SERVERNAME.phonebook.dbo.vw_tbl_ARS TARS
WHERE TARS.LastName LIKE '%$Submitter$%'

I've verified that I've got DTC running on both machines.  I've set the
remote server up as a linked server, with it set to impersonate with a
specific security context.  I've verified this is working because I can
see
the views/tables under the linked server in EntpMgr.  I am able to run
the
above query from my active link in QryAlzr just fine.  However, when I
go in
through the user tool and enter a name into the submitter field and fire
the
active link, I get this error:


"ARERR [552] Failure during SQL operation to the database : The ROLLBACK
TRANSACTION request has no corresponding BEGIN TRANSACTION. (SQL Server
3903)
The preceding message occurred during the execution of active link
+NTFAR:050-Set Submitter Info - TEST -- action 1. (ARNOTE 1101)"


I'm at the end of my rope here.  Hopefully someone has seen this before
and
knows what's up.  Perhaps I'm overlooking something embarassingly silly
here?  - I hope so!

Thanks in advance!!


Charlie Bennett
Remedy Developer
Missile Defense Integration & Operations Center
Schriever AFB
Colorado Springs, CO
(719) 721-7470 

Classification:  UNCLASSIFIED 
Caveats: NONE



___
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: ARS6.3 + SQL Question (UNCLASSIFIED)

[Kaiser Norm E CIV USAF 96 CS/SCCE]

I think the space in the table (view) name is causing you a problem:

.vw_tbl_ARS TARS

The system has probably replaced the space with an underscore.

Norm

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Bennett, Charlie CTR MDA/DOCC
Sent: Thursday, March 27, 2008 7:52 AM
To: arslist@ARSLIST.ORG
Subject: ARS6.3 + SQL Question (UNCLASSIFIED)

Classification:  UNCLASSIFIED 
Caveats: NONE

Hi All!

I'm having a small problem getting my Remedy 6.3 app to talk to a remote
MSSQL Server 2K SP3 database running on a Win2k3, SP2 machine.  My AR server
is running on a Win2k SP4 machine, with the AR System database running on a
MSSQL Server 2K SP4 database on the same machine.

I've created an active link to grab some user information stored in the
remote server upon Return/Table or Level Dbl-Clk in a Set Field (SQL) action
- it's supposed to go out, query based on the name entered into a submitter
field and find possible matches and populate related user info fields, or
display a select list if multiple matches come back.  Here's a chopped down
and simplified version of the query I'm working with (I've simplified it as
much as possible, but to no avail):

SELECT FirstName, LastName FROM SERVERNAME.phonebook.dbo.vw_tbl_ARS TARS
WHERE TARS.LastName LIKE '%$Submitter$%'

I've verified that I've got DTC running on both machines.  I've set the
remote server up as a linked server, with it set to impersonate with a
specific security context.  I've verified this is working because I can see
the views/tables under the linked server in EntpMgr.  I am able to run the
above query from my active link in QryAlzr just fine.  However, when I go in
through the user tool and enter a name into the submitter field and fire the
active link, I get this error:


"ARERR [552] Failure during SQL operation to the database : The ROLLBACK
TRANSACTION request has no corresponding BEGIN TRANSACTION. (SQL Server
3903)
The preceding message occurred during the execution of active link
+NTFAR:050-Set Submitter Info - TEST -- action 1. (ARNOTE 1101)"


I'm at the end of my rope here.  Hopefully someone has seen this before and
knows what's up.  Perhaps I'm overlooking something embarassingly silly
here?  - I hope so!

Thanks in advance!!


Charlie Bennett
Remedy Developer
Missile Defense Integration & Operations Center
Schriever AFB
Colorado Springs, CO
(719) 721-7470 

Classification:  UNCLASSIFIED 
Caveats: NONE



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


smime.p7s
Description: S/MIME cryptographic signature

Re: Remdy position available Phila, PA suburbs (west of phila)

[Vijay Dodla]

Interested in this remedy position can you please give me details.


On Thu, Mar 27, 2008 at 5:15 AM, [EMAIL PROTECTED] <
[EMAIL PROTECTED]> wrote:

> Looking for mid-level to senior Remedy developer to hit the ground
> running in a fairly large (windows / 7.0.1 / ITSM) shop based in the
> Phila, PA suburbs (west of phila) area.
>
> Please contact me for details.
>
>
> ___
> 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"

SQL 2000 database to SQL 2005 server

[tricky maybe]

I was trying to upgrade our SQL 2000 server to SQL 2005 but I can't get it to 
complete succesfully.  So I tried to just uninstall SQL 2000 and install SQL 
2005 and was successfull.  My question now is it a bad idea to just attach our 
ARSystem database from SQL 2000 to SQL 2005 server?  I just attached it and 
seems like it's working fine but I just want to make sure if that is not going 
to screw up later... I was told that I need to upgrade the database to SQL 2005 
and I'm not sure if attaching the old database to SQL 2005 is considered 
upgrading my database...  Please help.
   
  Tanks,
  Jason

   
-
Be a better friend, newshound, and know-it-all with Yahoo! Mobile.  Try it now.

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

Re: SQL 2000 database to SQL 2005 server

[Baxter, Andrew]

To the best of my knowledge, SQL 2005 will perform the upgrade as part
of the attachment.  I have done this before where I was moving a
database to a new server and it was previously SQL 2000 and attaching it
to SQL 2005 worked with no issues encountered.



Thanks,

Andrew Baxter



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of tricky maybe
Sent: Thursday, March 27, 2008 10:18 AM
To: arslist@ARSLIST.ORG
Subject: SQL 2000 database to SQL 2005 server



**

I was trying to upgrade our SQL 2000 server to SQL 2005 but I can't get
it to complete succesfully.  So I tried to just uninstall SQL 2000 and
install SQL 2005 and was successfull.  My question now is it a bad idea
to just attach our ARSystem database from SQL 2000 to SQL 2005 server?
I just attached it and seems like it's working fine but I just want to
make sure if that is not going to screw up later... I was told that I
need to upgrade the database to SQL 2005 and I'm not sure if attaching
the old database to SQL 2005 is considered upgrading my database...
Please help.



Tanks,

Jason

 



Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try
it now.
  __Platinum Sponsor: www.rmsportal.com ARSlist:
"Where the Answers Are" html___




This e-mail is sent by Hudson Highland Group, Inc., or one of its 
subsidiaries, and may contain information that is privileged or confidential. 
If you are not the intended recipient, please delete the e-mail and any 
attachments and notify us immediately.

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

Re: SQL 2000 database to SQL 2005 server

[Pierson, Shawn]

This is what we did last summer and ran into no problems with the
ARSystem database.



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of tricky maybe
Sent: Thursday, March 27, 2008 9:18 AM
To: arslist@ARSLIST.ORG
Subject: SQL 2000 database to SQL 2005 server



**

I was trying to upgrade our SQL 2000 server to SQL 2005 but I can't get
it to complete succesfully.  So I tried to just uninstall SQL 2000 and
install SQL 2005 and was successfull.  My question now is it a bad idea
to just attach our ARSystem database from SQL 2000 to SQL 2005 server?
I just attached it and seems like it's working fine but I just want to
make sure if that is not going to screw up later... I was told that I
need to upgrade the database to SQL 2005 and I'm not sure if attaching
the old database to SQL 2005 is considered upgrading my database...
Please help.



Tanks,

Jason





Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try
it now.
  __Platinum Sponsor: www.rmsportal.com ARSlist:
"Where the Answers Are" html___


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

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

Re: SuSE Linux ARIMPORT

[LJ Longwing]

I looked in the patch folders on the BMC site and can't find a patched
version of arimportcmd for Linux for 7.1, and I don't run a linux
workstation here, any chance anyone can send me the linux 7.1 arimportcmd
file?

  _  

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Michiel Beijen
Sent: Wednesday, March 26, 2008 4:05 PM
To: arslist@ARSLIST.ORG
Subject: Re: SuSE Linux ARIMPORT


** Actually, there is no 'Red Hat' version -- just the Linux version of
arimportcmd and will work on SUSE as well as on Red Hat - check the
Compatibility Matrix for the supported versions. So the answer is YES.

-- 
Met vriendelijke groet / Kind regards 
Michiel Beijen
__
MANSOLUTIONS
Energieweg 60-62
3771 NA Barneveld
The Netherlands
Tel. +31-(0)612968592
Mail [EMAIL PROTECTED]
Internet http://bsm.mansolutions.nl 


On Wed, Mar 26, 2008 at 10:52 PM, LJ Longwing <[EMAIL PROTECTED]> wrote:


** 
I'm looking for an arimportcmd for SuSE Linux, does anyone know if the
redhat one will run?  Will those libraries work on it?
__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: Remedy WUT & Crystal Reports (U)

[Susan Palmer]

I suggest rebuilding the workstation.  Obviously there's something
conflicting on it and how much time do you spend trying to find it.  There's
nothing you are  going to be  able to do about it not working.

Good luck ...
Susan

On Thu, Mar 27, 2008 at 7:54 AM, Hennigan, Sandra H CTR OSD-CIO <
[EMAIL PROTECTED]> wrote:

> UNCLASSIFIED
>
> Yes - it is the workstation not his Remedy account or install but it is
> only his workstation.
>
> Sandra Hennigan
>
> OSD Enterprise Remedy Administrator
> Office # 703-602-2525 x248
>
> Apparently, there is nothing that cannot happen today.  Mark Twain
>
>  -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:[EMAIL PROTECTED] On Behalf Of Susan Palmer
> Sent: Wednesday, March 26, 2008 5:38 PM
> To: arslist@ARSLIST.ORG
> Subject: Re: Remedy WUT & Crystal Reports (U)
>
>
> ** Does it work for him when he's on a different PC?
>
>
> On Wed, Mar 26, 2008 at 4:23 PM, Hennigan, Sandra H CTR OSD-CIO
> <[EMAIL PROTECTED]> wrote:
>
>
>UNCLASSIFIED
>
>Application-
>Windows 2003 server
>SQL 2000
>ARS 6.3 patch 21
>Help Desk 5.5
>
>Crystal Report reports running on ARS are in version 8.5
>
>User-
>Windows XP (not sure the SP level)
>Remedy WUT 6.3 patch 20
>
>All Remedy users can open, print, export the Crystal Report
> reports that
>run from Active Links to any of the Destinations displayed
>Except ONE user
>Out of over 400
>
>This one user cannot send, in any format, a Crystal Report to Disk
> File
>He can export to Destination Application or MAPI without error
>
>He receives the dialog to Export, can select the format, can
> select the
>Destination.
>He can select Disk file.  When he clicks OK - nothing.  No error;
> no
>action.
>
>I have completely removed the Remedy install; rebooted.
>Cleaned the registry.
>Installed Remedy to different locales.
>Given him local admin permissions.
>Installed Crystal Reports
>Configured ODBC drivers
>
>Removed everything and started again.
>Had other admin perform the same drill
>
>Printing works OK
>Crystal Reports works OK; he can export the report to Crystal
> Reports
>and open the report
>Adobe works OK; he can export the report to Adobe and open the
> report
>
>This one user cannot send, in any format, a Crystal Report to Disk
> File
>from Remedy.
>
>Any ideas?
>
>Sandra Hennigan
>Enterprise Remedy Administrator
>
>Apparently, there is nothing that cannot happen today.  Mark Twain
>
>
> __
> _
>UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> 
>Platinum Sponsor: www.rmsportal.com 
> ARSlist: "Where the Answers Are"
>
>
>
> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
> html___
>
>
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
>

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

Re: SQL 2000 database to SQL 2005 server

[Brian Keith]

Same here. Upgraded from 2000 to 2005 with no issues so far. It's been about 6 
months.

Brian

-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Pierson, Shawn
Sent: Thursday, March 27, 2008 7:52 AM
To: arslist@ARSLIST.ORG
Subject: Re: SQL 2000 database to SQL 2005 server

**

This is what we did last summer and ran into no problems with the ARSystem 
database.



From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of tricky maybe
Sent: Thursday, March 27, 2008 9:18 AM
To: arslist@ARSLIST.ORG
Subject: SQL 2000 database to SQL 2005 server



**

I was trying to upgrade our SQL 2000 server to SQL 2005 but I can't get it to 
complete succesfully.  So I tried to just uninstall SQL 2000 and install SQL 
2005 and was successfull.  My question now is it a bad idea to just attach our 
ARSystem database from SQL 2000 to SQL 2005 server?  I just attached it and 
seems like it's working fine but I just want to make sure if that is not going 
to screw up later... I was told that I need to upgrade the database to SQL 2005 
and I'm not sure if attaching the old database to SQL 2005 is considered 
upgrading my database...  Please help.



Tanks,

Jason





Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. 

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

Private and confidential as detailed here 
 . If you cannot access 
hyperlink, please e-mail sender.
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___

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

Re: Remedy WUT & Crystal Reports (U)

[Hennigan, Sandra H CTR OSD-CIO]

UNCLASSIFIED

I know; I was hoping that with all of the experience on the list,
someone else would have encountered the like. 

Sandra Hennigan

OSD Enterprise Remedy Administrator
Office # 703-602-2525 x248

Apparently, there is nothing that cannot happen today.  Mark Twain

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Susan Palmer
Sent: Thursday, March 27, 2008 11:40 AM
To: arslist@ARSLIST.ORG
Subject: Re: Remedy WUT & Crystal Reports (U)


** 
I suggest rebuilding the workstation.  Obviously there's something
conflicting on it and how much time do you spend trying to find it.
There's nothing you are  going to be  able to do about it not working.
 
Good luck ...
Susan


On Thu, Mar 27, 2008 at 7:54 AM, Hennigan, Sandra H CTR OSD-CIO
<[EMAIL PROTECTED]> wrote:


UNCLASSIFIED

Yes - it is the workstation not his Remedy account or install
but it is
only his workstation.

Sandra Hennigan

OSD Enterprise Remedy Administrator
Office # 703-602-2525 x248


Apparently, there is nothing that cannot happen today.  Mark
Twain


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Susan Palmer
Sent: Wednesday, March 26, 2008 5:38 PM
To: arslist@ARSLIST.ORG
Subject: Re: Remedy WUT & Crystal Reports (U)


** Does it work for him when he's on a different PC?


On Wed, Mar 26, 2008 at 4:23 PM, Hennigan, Sandra H CTR OSD-CIO
<[EMAIL PROTECTED]> wrote:


   UNCLASSIFIED

   Application-
   Windows 2003 server
   SQL 2000
   ARS 6.3 patch 21
   Help Desk 5.5

   Crystal Report reports running on ARS are in version 8.5

   User-
   Windows XP (not sure the SP level)
   Remedy WUT 6.3 patch 20

   All Remedy users can open, print, export the Crystal
Report
reports that
   run from Active Links to any of the Destinations
displayed
   Except ONE user
   Out of over 400

   This one user cannot send, in any format, a Crystal
Report to Disk
File
   He can export to Destination Application or MAPI without
error

   He receives the dialog to Export, can select the format,
can
select the
   Destination.
   He can select Disk file.  When he clicks OK - nothing.
No error;
no
   action.

   I have completely removed the Remedy install; rebooted.
   Cleaned the registry.
   Installed Remedy to different locales.
   Given him local admin permissions.
   Installed Crystal Reports
   Configured ODBC drivers

   Removed everything and started again.
   Had other admin perform the same drill

   Printing works OK
   Crystal Reports works OK; he can export the report to
Crystal
Reports
   and open the report
   Adobe works OK; he can export the report to Adobe and
open the
report

   This one user cannot send, in any format, a Crystal
Report to Disk
File
   from Remedy.

   Any ideas?

   Sandra Hennigan
   Enterprise Remedy Administrator

   Apparently, there is nothing that cannot happen today.
Mark Twain




__
_
   UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
 


   Platinum Sponsor: www.rmsportal.com
  

ARSlist: "Where the Answers Are"




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



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

[Kemes, Lisa]

I'm trying to create a View Form that connects to a table on an Oracle
database and I'm getting the error message:

"Requested database table not found.  Please check the spelling (table
name is case-sensitive) (ARERR 481)."

The table has aradmin added to the permission list.  Is there anything
else I'm missing?

AR Server 7.01 Patch 6
Windows 2003 app Server

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



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

Re: View Forms

[Kemes, Lisa]

Also, I am typing the table name in CAPS.
 

Lisa 

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa
Sent: Thursday, March 27, 2008 12:05 PM
To: arslist@ARSLIST.ORG
Subject: View Forms


** 

I'm trying to create a View Form that connects to a table on an Oracle
database and I'm getting the error message: 

"Requested database table not found.  Please check the spelling (table
name is case-sensitive) (ARERR 481)." 

The table has aradmin added to the permission list.  Is there anything
else I'm missing? 

AR Server 7.01 Patch 6 
Windows 2003 app Server 

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


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

Jobs: Several Positions Available

[Erin Hubbard]

 

 

TuringSMI is an IT Service Management Consulting company who is an
"Elite" partner of BMC Remedy, and one of the fastest growing ITSM
Professional Services companies globally. We have several employment
opportunities throughout the United States for individuals with the
right experience.

 

Employment Opportunities:

 

Lead Remedy Consultants with practical ITSM 7 experience as well as CSS,
Patrol, BMC Discovery, or CMDB 2.0

Solution Consultants with ITIL certification and strong practical ITSM
experience

Project Managers with PMP, Six Sigma, or Prince2 certification

Business Development Managers experienced in solution selling and
selling ITSM services 

Technical Pre-Sales Consultants 

Senior Technical Support Consultants (remote)

 

TuringSMI has a competitive pay scale. Our benefits include BCBS, life
insurance, 401K, generous vacation structure, paid training, and
wonderful opportunities for advancement.

 

If you have the skills and are interested in a fast paced, fast growing
company, please forward your resume to me off list. I would be happy to
discuss these opportunities in more detail. These are permanent
positions only. No contractors please.

 

Thanks,

 

Erin Hubbard

Recruiter

 

TuringSMI

300 S. Wacker Drive 23rd Floor

Chicago, IL 60606 USA

 

 

Office:   312-235-3138

Mobile:  312-731-9052

Fax:   312 235 3139

Web:  www.turingsmi.com   

eMail:[EMAIL PROTECTED]


This message is subject to and does not create or vary any contractual 
relationship between TuringSMI, SMI Technologies, SMI Telco, its subsidiaries 
or affiliates and you. Internet communications are not secure and therefore the 
TuringSMI Group does not accept any legal responsibility for the contents of 
this message. Any views or opinions expressed are those of the author.  This 
message is intended for the addressee ('s) only and its contents and any 
attached files are strictly confidential. If you have received it in error, 
please contact the sender on the number above.

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

Re: View Forms

[Nisha Ramtri]

Lisa,

This error normally occurs when the table name that is being provided is
different from the actual name in the db. Check for the name, spelling of
the table in the database. The table name is case sensitive also. Hence take
care of that as well while providing the name of the table. Also make sure
that the table is in the aradmin d/b. Hope that helps.

Rgd,
Nisha.


On 3/27/08, Kemes, Lisa <[EMAIL PROTECTED]> wrote:
>
> ** Also, I am typing the table name in CAPS.
>
>
> Lisa
>
>
>  --
> *From:* Action Request System discussion list(ARSList) [mailto:
> [EMAIL PROTECTED] *On Behalf Of *Kemes, Lisa
> *Sent:* Thursday, March 27, 2008 12:05 PM
> *To:* arslist@ARSLIST.ORG
> *Subject:* View Forms
>
>
>  **
>
> I'm trying to create a View Form that connects to a table on an Oracle
> database and I'm getting the error message:
>
> "Requested database table not found.  Please check the spelling (table
> name is case-sensitive) (ARERR 481)."
>
> The table has aradmin added to the permission list.  Is there anything
> else I'm missing?
>
> AR Server 7.01 Patch 6
> Windows 2003 app Server
>
> *Lisa Kemes *
> AR System Developer
> Tyco Electronics
> 717-810-2408 tel
> 717-810-2124 fax
> [EMAIL PROTECTED]
>
> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
> html___
> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
> html___
>



-- 
If you miss the lift to success...try the stairs!!

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

Re: View Forms

[Drew Shuller]

Lisa, you also need the owner name:

OWNER.TABLENAME

Maybe that would be ARADMIN?

Drew

On Thu, 27 Mar 2008, Kemes, Lisa wrote:


Also, I am typing the table name in CAPS.


Lisa





From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa
Sent: Thursday, March 27, 2008 12:05 PM
To: arslist@ARSLIST.ORG
Subject: View Forms


**

I'm trying to create a View Form that connects to a table on an Oracle
database and I'm getting the error message:

"Requested database table not found.  Please check the spelling (table
name is case-sensitive) (ARERR 481)."

The table has aradmin added to the permission list.  Is there anything
else I'm missing?

AR Server 7.01 Patch 6
Windows 2003 app Server

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


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

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



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

Re: View Forms

[Drew Shuller]

Yes, if it's owned by aradmin, she'll need the T table.

Drew

On Thu, 27 Mar 
2008, Nisha Ramtri wrote:



Lisa,

This error normally occurs when the table name that is being provided is
different from the actual name in the db. Check for the name, spelling of
the table in the database. The table name is case sensitive also. Hence take
care of that as well while providing the name of the table. Also make sure
that the table is in the aradmin d/b. Hope that helps.

Rgd,
Nisha.


On 3/27/08, Kemes, Lisa <[EMAIL PROTECTED]> wrote:


** Also, I am typing the table name in CAPS.


Lisa


 --
*From:* Action Request System discussion list(ARSList) [mailto:
[EMAIL PROTECTED] *On Behalf Of *Kemes, Lisa
*Sent:* Thursday, March 27, 2008 12:05 PM
*To:* arslist@ARSLIST.ORG
*Subject:* View Forms


 **

I'm trying to create a View Form that connects to a table on an Oracle
database and I'm getting the error message:

"Requested database table not found.  Please check the spelling (table
name is case-sensitive) (ARERR 481)."

The table has aradmin added to the permission list.  Is there anything
else I'm missing?

AR Server 7.01 Patch 6
Windows 2003 app Server

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

__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: SQL 2000 database to SQL 2005 server

[tricky maybe]

I should be fine just attaching the old database (sql 2000 database) to the new 
sql server (sql 2005 server) right?  Anyway, thanks for all the replies.
   
  
From: Action Request System discussion list(ARSList) [EMAIL PROTECTED] On 
Behalf Of Brian Keith [EMAIL PROTECTED]
Sent: Thursday, March 27, 2008 8:42 AM
To: arslist@ARSLIST.ORG
Subject: Re: SQL 2000 database to SQL 2005 server

Same here. Upgraded from 2000 to 2005 with no issues so far. It's been about 6 
months.

Brian

-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Pierson, Shawn
Sent: Thursday, March 27, 2008 7:52 AM
To: arslist@ARSLIST.ORG
Subject: Re: SQL 2000 database to SQL 2005 server

**

This is what we did last summer and ran into no problems with the ARSystem 
database.



From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of tricky maybe
Sent: Thursday, March 27, 2008 9:18 AM
To: arslist@ARSLIST.ORG
Subject: SQL 2000 database to SQL 2005 server



**

I was trying to upgrade our SQL 2000 server to SQL 2005 but I can't get it to 
complete succesfully.  So I tried to just uninstall SQL 2000 and install SQL 
2005 and was successfull.  My question now is it a bad idea to just attach our 
ARSystem database from SQL 2000 to SQL 2005 server?  I just attached it and 
seems like it's working fine but I just want to make sure if that is not going 
to screw up later... I was told that I need to upgrade the database to SQL 2005 
and I'm not sure if attaching the old database to SQL 2005 is considered 
upgrading my database...  Please help.



Tanks,

Jason





Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. 

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

Private and confidential as detailed here 
 . If you cannot access 
hyperlink, please e-mail sender.
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___

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


   
-
Be a better friend, newshound, and know-it-all with Yahoo! Mobile.  Try it now.

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

Question: SYS:Notification Messages - Missing ?

[T. Dee]

I have two Notifications - the Notification Message Tags are:

CHG-APR-GroupApprovalOLAResolutionEscalation
CHG-APR-IndividualApprovalOLAResolutionEscalation

I have exported ALL Filters and I am unable to reference any Filter to
these two Notifications.

Do these even exist?

Thanks!

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

archgid for v6.3 - 2nd Attempt

[Atul Vohra]

Hi All,

Please can some one direct me where to get archgid.exe for v6.3 - Developer's 
Network had for v7.0.

Thanks
Atul

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

First Contact Resolution (FCR) ITIL & ITSM 7

[Kevin Pulsen]

Hello all,

I'm trying to find information on FCR (First Contact Resolution) specifically 
for the Service Desk person.

Is there a starting goal within ITIL regarding FCR?

For example... the Service Desk needs to meet a 35% FCR goal.

Or is this number subjective?

If anyone is using FCR, could you please let me know your goal is and what  
factors you used to assess this goal.

Thanks!

Kevin P.


   
-
Never miss a thing.   Make Yahoo your homepage.

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

Re: SuSE Linux ARIMPORT

[LJ Longwing]

Well...it's better than writing your own import tool (which I have done)

  _  

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Michiel Beijen
Sent: Thursday, March 27, 2008 1:47 AM
To: arslist@ARSLIST.ORG
Subject: Re: SuSE Linux ARIMPORT


** That's the first time I've heard someone address arimportcmd as
'awesome'...
--
Michiel


On Wed, Mar 26, 2008 at 11:44 PM, LJ Longwing <[EMAIL PROTECTED]> wrote:


** 
That is awesome news, I'll go grab the latest linux distribution of the
file.  Thanks

  _  

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Michiel Beijen
Sent: Wednesday, March 26, 2008 4:05 PM
To: arslist@ARSLIST.ORG
Subject: Re: SuSE Linux ARIMPORT


** Actually, there is no 'Red Hat' version -- just the Linux version of
arimportcmd and will work on SUSE as well as on Red Hat - check the
Compatibility Matrix for the supported versions. So the answer is YES. 


-- 
Met vriendelijke groet / Kind regards 
Michiel Beijen
__
MANSOLUTIONS
Energieweg 60-62
3771 NA Barneveld
The Netherlands
Tel. +31-(0)612968592
Mail [EMAIL PROTECTED]
Internet http://bsm.mansolutions.nl 


On Wed, Mar 26, 2008 at 10:52 PM, LJ Longwing <[EMAIL PROTECTED]> wrote:


** 
I'm looking for an arimportcmd for SuSE Linux, does anyone know if the
redhat one will run?  Will those libraries work on it?
__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: View Forms

[Brian Goralczyk]

Not true.  She doesn't need the T table.  First off, if it isn't an ARS
table there might (probably won't) be a T table unless it was created
manually.  However, you can still use the view instead.  If it is a Remedy
created table, then the view name has a specific format.  All none
alphanumeric characters are replaced with an underscore.  Also, view names
in an Oracle (and I assume the others) database is only 30 characters long
if Remedy created the view.  So if your view (form) name is longer than 30
characters just drop the exceeding characters.  There is one other caveat in
case you have more than one view name that is the same until past the 30
character limit.  The last letter (number 30) is replaced by a sequential
number starting with the second form and incrementing for each form.  Check
out my examples but please don't name your forms as such or think that I
have mine named like this.

Form Name: CTM:People Site AP:Administration Join
View Name: ctm_people_site_ap_administrat

Form Name: CTM:People Site AP:Administration Role Join
View Name: ctm_people_site_ap_administra2

Please only use this as an example.  I didn't verify my thoughts from off
the top of my head.

Also, if you want the list of views just run this: select view_name from
user_views order by 1

That will work in an Oracle db for sure.

Also, I have not found a case sensitivity for form or field names when
writing SQL queries.

HTH,

Brian Goralczyk

On Thu, Mar 27, 2008 at 11:27 AM, Drew Shuller <[EMAIL PROTECTED]> wrote:

> Yes, if it's owned by aradmin, she'll need the T table.
>
> Drew
>
> On Thu, 27 Mar
>  2008, Nisha Ramtri wrote:
>
> > Lisa,
> >
> > This error normally occurs when the table name that is being provided is
> > different from the actual name in the db. Check for the name, spelling
> of
> > the table in the database. The table name is case sensitive also. Hence
> take
> > care of that as well while providing the name of the table. Also make
> sure
> > that the table is in the aradmin d/b. Hope that helps.
> >
> > Rgd,
> > Nisha.
> >
> >
> > On 3/27/08, Kemes, Lisa <[EMAIL PROTECTED]> wrote:
> >>
> >> ** Also, I am typing the table name in CAPS.
> >>
> >>
> >> Lisa
> >>
> >>
> >>  --
> >> *From:* Action Request System discussion list(ARSList) [mailto:
> >> [EMAIL PROTECTED] *On Behalf Of *Kemes, Lisa
> >> *Sent:* Thursday, March 27, 2008 12:05 PM
> >> *To:* arslist@ARSLIST.ORG
> >> *Subject:* View Forms
> >>
> >>
> >>  **
> >>
> >> I'm trying to create a View Form that connects to a table on an Oracle
> >> database and I'm getting the error message:
> >>
> >> "Requested database table not found.  Please check the spelling (table
> >> name is case-sensitive) (ARERR 481)."
> >>
> >> The table has aradmin added to the permission list.  Is there anything
> >> else I'm missing?
> >>
> >> AR Server 7.01 Patch 6
> >> Windows 2003 app Server
> >>
> >> *Lisa Kemes *
> >> AR System Developer
> >> Tyco Electronics
> >> 717-810-2408 tel
> >> 717-810-2124 fax
> >> [EMAIL PROTECTED]
> >>
> >> __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"
>

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

Re: ARS6.3 + SQL Question (UNCLASSIFIED)

[Bennett, Charlie CTR MDA/DOCC]

Classification:  UNCLASSIFIED 
Caveats: NONE

Sorry - that's an implied "AS" aliasing... 



Charlie Bennett
Remedy Developer
Missile Defense Integration & Operations Center
Schriever AFB
Colorado Springs, CO
(719) 721-7470 


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96 CS/SCCE
Sent: Thursday, March 27, 2008 7:48 AM
To: arslist@ARSLIST.ORG
Subject: Re: ARS6.3 + SQL Question (UNCLASSIFIED)

I think the space in the table (view) name is causing you a problem:

.vw_tbl_ARS TARS

The system has probably replaced the space with an underscore.

Norm

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Bennett, Charlie CTR MDA/DOCC
Sent: Thursday, March 27, 2008 7:52 AM
To: arslist@ARSLIST.ORG
Subject: ARS6.3 + SQL Question (UNCLASSIFIED)

Classification:  UNCLASSIFIED
Caveats: NONE

Hi All!

I'm having a small problem getting my Remedy 6.3 app to talk to a remote
MSSQL Server 2K SP3 database running on a Win2k3, SP2 machine.  My AR server
is running on a Win2k SP4 machine, with the AR System database running on a
MSSQL Server 2K SP4 database on the same machine.

I've created an active link to grab some user information stored in the
remote server upon Return/Table or Level Dbl-Clk in a Set Field (SQL) action
- it's supposed to go out, query based on the name entered into a submitter
field and find possible matches and populate related user info fields, or
display a select list if multiple matches come back.  Here's a chopped down
and simplified version of the query I'm working with (I've simplified it as
much as possible, but to no avail):

SELECT FirstName, LastName FROM SERVERNAME.phonebook.dbo.vw_tbl_ARS TARS
WHERE TARS.LastName LIKE '%$Submitter$%'

I've verified that I've got DTC running on both machines.  I've set the
remote server up as a linked server, with it set to impersonate with a
specific security context.  I've verified this is working because I can see
the views/tables under the linked server in EntpMgr.  I am able to run the
above query from my active link in QryAlzr just fine.  However, when I go in
through the user tool and enter a name into the submitter field and fire the
active link, I get this error:


"ARERR [552] Failure during SQL operation to the database : The ROLLBACK
TRANSACTION request has no corresponding BEGIN TRANSACTION. (SQL Server
3903)
The preceding message occurred during the execution of active link
+NTFAR:050-Set Submitter Info - TEST -- action 1. (ARNOTE 1101)"


I'm at the end of my rope here.  Hopefully someone has seen this before and
knows what's up.  Perhaps I'm overlooking something embarassingly silly
here?  - I hope so!

Thanks in advance!!


Charlie Bennett
Remedy Developer
Missile Defense Integration & Operations Center Schriever AFB Colorado
Springs, CO
(719) 721-7470 

Classification:  UNCLASSIFIED
Caveats: NONE



___
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"
Classification:  UNCLASSIFIED 
Caveats: NONE


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


smime.p7s
Description: S/MIME cryptographic signature

Re: First Contact Resolution (FCR) ITIL & ITSM 7

[T. Dee]

We created our own FCR and I have a field set if the call is resolved
within 1 hour and resolved by the individual who opened the ticket.

On 3/27/08, Kevin Pulsen <[EMAIL PROTECTED]> wrote:
> ** Hello all,
>
> I'm trying to find information on FCR (First Contact Resolution)
> specifically for the Service Desk person.
>
> Is there a starting goal within ITIL regarding FCR?
>
> For example... the Service Desk needs to meet a 35% FCR goal.
>
> Or is this number subjective?
>
> If anyone is using FCR, could you please let me know your goal is and what
> factors you used to assess this goal.
>
> Thanks!
>
> Kevin P.
>
>
>
> 
> Never miss a thing. Make Yahoo your homepage. __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"

Data - For Server Events

[Tanner, Doug]

Does anyone have (and is willing to share) the data mapping (Elements)
for the Server Events (Event Type & Event Cause) 

 

(Example Below)

 

Event Type - 1  Creating Form

Event Cause -1  Creating Form

 

Event Type - 2  Creating Field

Event Cause -0  Creating Field

 

Thanks, Doug

 

Doug Tanner

Senior Developer

Remedy Skilled Professional (RSP)

(704) 328-3178

[EMAIL PROTECTED]

 

 


DISCLAIMER Important! This message is intended for the above named person(s) 
only and is CONFIDENTIAL AND PROPRIETARY. If you are not the intended recipient 
of this e-mail and have received it in error, please immediately notify the 
sender by return email and then delete it from your mailbox. This message may 
be protected by the attorney-client privilege and/or work product doctrine.  
Accessing, copying, disseminating or re-using any of the information contained 
in this e-mail by anyone other than the intended recipient is strictly 
prohibited. Finally, you should check this email and any attachments for the 
presence of viruses, as the sender accepts no liability for any damage caused 
by any virus transmitted by this email.  Thank you.


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

Installation Question...

[Richard Copits]

I'm attempting to install a Remedy 7.1 system and all seems to be

going well. However, when I install the Asset Management module

it gets almost all the way through and then throws the error message

"There were failures while loading the extensions". It doesn't give

any error number. I've looked in the install and configure manuals

but don't see anything that relates to "extensions" or any error

messages that seem relevant. Has anyone any suggestions as to

what "extensions" get loaded or  Thank you.


Portions of this message may be confidential under an exemption to Ohio's 
public records law or under a legal privilege. If you have received this 
message in error or due to an unauthorized transmission or interception, please 
delete all copies from your system without disclosing, copying, or transmitting 
this message.

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

Remedy and Two Factor Authentication

[SUBSCRIBE arslist Melissa]

Does anyone know if Remedy 7.x supports two factor authentication?  Is 
anyone currently using this method to log into Remedy?

Thanks!
Melissa

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

Re: Data - For Server Events

[Axton]

http://arswiki.org/projects/arapi/browser/trunk/7.1/solaris/include/ar.h#L5095

Axton Grams

On Thu, Mar 27, 2008 at 2:36 PM, Tanner, Doug <[EMAIL PROTECTED]>
wrote:

> **
>
> Does anyone have (and is willing to share) the data mapping (Elements) for
> the Server Events (Event Type & Event Cause)
>
>
>
> (Example Below)
>
>
>
> Event Type – 1  Creating Form
>
> Event Cause -1  Creating Form
>
>
>
> Event Type – 2  Creating Field
>
> Event Cause -0  Creating Field
>
>
>
> Thanks, Doug
>
>
>
> Doug Tanner
>
> Senior Developer
>
> Remedy Skilled Professional (RSP)
>
> (704) 328-3178
>
> [EMAIL PROTECTED]
>
>
>
>
>  DISCLAIMER Important! This message is intended for the above named
> person(s) only and is CONFIDENTIAL AND PROPRIETARY. If you are not the
> intended recipient of this e-mail and have received it in error, please
> immediately notify the sender by return email and then delete it from your
> mailbox. This message may be protected by the attorney-client privilege
> and/or work product doctrine. Accessing, copying, disseminating or re-using
> any of the information contained in this e-mail by anyone other than the
> intended recipient is strictly prohibited. Finally, you should check this
> email and any attachments for the presence of viruses, as the sender accepts
> no liability for any damage caused by any virus transmitted by this email.
> Thank you.
> __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: Installation Question...

[Rick Cook]

I think it's talking about the CMDB data model.  Be sure that you've set up
your AR System sufficiently before starting the ITSM installs, or you'll get
strange errors like this.  Did you license AR Server before installing any
ITSM apps?  Did you install CMDB before you installed the other apps?

Give us some more information, and we can probably help you find this.

Rick

On Thu, Mar 27, 2008 at 11:44 AM, Richard Copits <
[EMAIL PROTECTED]> wrote:

> **
>
> I'm attempting to install a Remedy 7.1 system and all seems to be
>
> going well. However, when I install the Asset Management module
>
> it gets almost all the way through and then throws the error message
>
> "There were failures while loading the extensions". It doesn't give
>
> any error number. I've looked in the install and configure manuals
>
> but don't see anything that relates to "extensions" or any error
>
> messages that seem relevant. Has anyone any suggestions as to
>
> what "extensions" get loaded or  Thank you.
>
> Portions of this message may be confidential under an exemption to Ohio's
> public records law or under a legal privilege. If you have received this
> message in error or due to an unauthorized transmission or interception,
> please delete all copies from your system without disclosing, copying, or
> transmitting this message.
> __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: Installation Question...

[Richard Copits]

I installed the ARServer with no errors, same with the CMDB.  Thanks for

narrowing it down for me - I'll reinstall the ARServer and CMDDB.  Is
there

any cautions as to version for either?

 

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook
Sent: Thursday, March 27, 2008 3:02 PM
To: arslist@ARSLIST.ORG
Subject: Re: Installation Question...

 

** I think it's talking about the CMDB data model.  Be sure that you've
set up your AR System sufficiently before starting the ITSM installs, or
you'll get strange errors like this.  Did you license AR Server before
installing any ITSM apps?  Did you install CMDB before you installed the
other apps?

Give us some more information, and we can probably help you find this.

Rick

On Thu, Mar 27, 2008 at 11:44 AM, Richard Copits
<[EMAIL PROTECTED]> wrote:

** 

I'm attempting to install a Remedy 7.1 system and all seems to be

going well. However, when I install the Asset Management module

it gets almost all the way through and then throws the error message

"There were failures while loading the extensions". It doesn't give

any error number. I've looked in the install and configure manuals

but don't see anything that relates to "extensions" or any error

messages that seem relevant. Has anyone any suggestions as to

what "extensions" get loaded or  Thank you.


Portions of this message may be confidential under an exemption to
Ohio's public records law or under a legal privilege. If you have
received this message in error or due to an unauthorized transmission or
interception, please delete all copies from your system without
disclosing, copying, or transmitting this message.

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


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



Portions of this message may be confidential under an exemption to Ohio's 
public records law or under a legal privilege. If you have received this 
message in error or due to an unauthorized transmission or interception, please 
delete all copies from your system without disclosing, copying, or transmitting 
this message.

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

Re: First Contact Resolution (FCR) ITIL & ITSM 7

[Jase Brandon]

Hi Kevin,
Same here as Tyrone, resolved in 1 hour and resolved by the person who
opened the ticket.
Same setup for FCR at the last two companies I worked for as well, for
whatever that's worth.

Jase


On 3/27/08, T. Dee <[EMAIL PROTECTED]> wrote:
>
> We created our own FCR and I have a field set if the call is resolved
> within 1 hour and resolved by the individual who opened the ticket.
>
> On 3/27/08, Kevin Pulsen <[EMAIL PROTECTED]> wrote:
> > ** Hello all,
> >
> > I'm trying to find information on FCR (First Contact Resolution)
> > specifically for the Service Desk person.
> >
> > Is there a starting goal within ITIL regarding FCR?
> >
> > For example... the Service Desk needs to meet a 35% FCR goal.
> >
> > Or is this number subjective?
> >
> > If anyone is using FCR, could you please let me know your goal is and
> what
> > factors you used to assess this goal.
> >
> > Thanks!
> >
> > Kevin P.
> >
> >
> >
> > 
> > Never miss a thing. Make Yahoo your homepage. __Platinum Sponsor:
> > www.rmsportal.com ARSlist: "Where the Answers Are" html___
> >
> >
>
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
>

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

Re: Installation Question...

[Rick Cook]

Each set of version combinations is a bit different in its quirks, so I'll
leave that to Support or to someone who's in the middle of the same thing
right now.  You didn't mention specific version/patch info, but I would take
whatever you plan to use and run that combo past support to see if they know
of any gotchas.

One thing you might do is a DB backup after each stage (i.e. AR install,
CMDB install...), so that if the next stage gets hosed, it's easier to
restart.

Rick

On Thu, Mar 27, 2008 at 12:08 PM, Richard Copits <
[EMAIL PROTECTED]> wrote:

> **
>
> I installed the ARServer with no errors, same with the CMDB.  Thanks for
>
> narrowing it down for me – I'll reinstall the ARServer and CMDDB.  Is
> there
>
> any cautions as to version for either?
>
>
>
> *From:* Action Request System discussion list(ARSList) [mailto:
> [EMAIL PROTECTED] *On Behalf Of *Rick Cook
> *Sent:* Thursday, March 27, 2008 3:02 PM
> *To:* arslist@ARSLIST.ORG
> *Subject:* Re: Installation Question...
>
>
>
> ** I think it's talking about the CMDB data model.  Be sure that you've
> set up your AR System sufficiently before starting the ITSM installs, or
> you'll get strange errors like this.  Did you license AR Server before
> installing any ITSM apps?  Did you install CMDB before you installed the
> other apps?
>
>
> Give us some more information, and we can probably help you find this.
>
> Rick
>
> On Thu, Mar 27, 2008 at 11:44 AM, Richard Copits <
> [EMAIL PROTECTED]> wrote:
>
> **
>
> I'm attempting to install a Remedy 7.1 system and all seems to be
>
> going well. However, when I install the Asset Management module
>
> it gets almost all the way through and then throws the error message
>
> "There were failures while loading the extensions". It doesn't give
>
> any error number. I've looked in the install and configure manuals
>
> but don't see anything that relates to "extensions" or any error
>
> messages that seem relevant. Has anyone any suggestions as to
>
> what "extensions" get loaded or  Thank you.
>
>
> Portions of this message may be confidential under an exemption to Ohio's
> public records law or under a legal privilege. If you have received this
> message in error or due to an unauthorized transmission or interception,
> please delete all copies from your system without disclosing, copying, or
> transmitting this message.
>
> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
> html___
>
>
> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
> html___
>
>
> Portions of this message may be confidential under an exemption to Ohio's
> public records law or under a legal privilege. If you have received this
> message in error or due to an unauthorized transmission or interception,
> please delete all copies from your system without disclosing, copying, or
> transmitting this message.
> __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: First Contact Resolution (FCR) ITIL & ITSM 7

[T. Dee]

When we arrived at our 40% we did an average over a couple of months.
Every company is going to be different - some companies I know give
their help desk alot of rights / authority, others give them nothing -
so they really can't resolve much.

Ty


On 3/27/08, Jase Brandon <[EMAIL PROTECTED]> wrote:
> **
> Hi Kevin,
> Same here as Tyrone, resolved in 1 hour and resolved by the person who
> opened the ticket.
> Same setup for FCR at the last two companies I worked for as well, for
> whatever that's worth.
>
> Jase
>
>
> On 3/27/08, T. Dee <[EMAIL PROTECTED]> wrote:
> >
> > We created our own FCR and I have a field set if the call is resolved
> > within 1 hour and resolved by the individual who opened the ticket.
> >
> > On 3/27/08, Kevin Pulsen <[EMAIL PROTECTED]> wrote:
> > > ** Hello all,
> > >
> > > I'm trying to find information on FCR (First Contact Resolution)
> > > specifically for the Service Desk person.
> > >
> > > Is there a starting goal within ITIL regarding FCR?
> > >
> > > For example... the Service Desk needs to meet a 35% FCR goal.
> > >
> > > Or is this number subjective?
> > >
> > > If anyone is using FCR, could you please let me know your goal is and
> what
> > > factors you used to assess this goal.
> > >
> > > Thanks!
> > >
> > > Kevin P.
> > >
> > >
> > >
> > > 
> > > Never miss a thing. Make Yahoo your homepage. __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"
> >
>
> __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 Forms

[Kemes, Lisa]

These are not ARS tables.  Just plain old tables from an Oracle
database.  Our DBA was able to log into SQL developer with the aradmin
account and see these tables just fine.  For some reason, my admin tool
must not be using the aradmin account for view forms?  I'm connected to
our ARS database so it's working in that respect.
 
These are not owned by aradmin either, but it is in the permission
group.
 

 

Lisa 

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Brian Goralczyk
Sent: Thursday, March 27, 2008 1:44 PM
To: arslist@ARSLIST.ORG
Subject: Re: View Forms


** 
Not true.  She doesn't need the T table.  First off, if it isn't an ARS
table there might (probably won't) be a T table unless it was created
manually.  However, you can still use the view instead.  If it is a
Remedy created table, then the view name has a specific format.  All
none alphanumeric characters are replaced with an underscore.  Also,
view names in an Oracle (and I assume the others) database is only 30
characters long if Remedy created the view.  So if your view (form) name
is longer than 30 characters just drop the exceeding characters.  There
is one other caveat in case you have more than one view name that is the
same until past the 30 character limit.  The last letter (number 30) is
replaced by a sequential number starting with the second form and
incrementing for each form.  Check out my examples but please don't name
your forms as such or think that I have mine named like this.
 
Form Name: CTM:People Site AP:Administration Join
View Name: ctm_people_site_ap_administrat
 
Form Name: CTM:People Site AP:Administration Role Join
View Name: ctm_people_site_ap_administra2
 
Please only use this as an example.  I didn't verify my thoughts from
off the top of my head.
 
Also, if you want the list of views just run this: select view_name from
user_views order by 1
 
That will work in an Oracle db for sure.
 
Also, I have not found a case sensitivity for form or field names when
writing SQL queries.
 
HTH,
 
Brian Goralczyk


On Thu, Mar 27, 2008 at 11:27 AM, Drew Shuller <[EMAIL PROTECTED]> wrote:


Yes, if it's owned by aradmin, she'll need the T table.


Drew

On Thu, 27 Mar

2008, Nisha Ramtri wrote:

> Lisa,
>
> This error normally occurs when the table name that is being
provided is
> different from the actual name in the db. Check for the name,
spelling of
> the table in the database. The table name is case sensitive
also. Hence take
> care of that as well while providing the name of the table.
Also make sure
> that the table is in the aradmin d/b. Hope that helps.
>
> Rgd,
> Nisha.
>
>
> On 3/27/08, Kemes, Lisa <[EMAIL PROTECTED]>
wrote:
>>
>> ** Also, I am typing the table name in CAPS.
>>
>>
>> Lisa
>>
>>
>>  --
>> *From:* Action Request System discussion list(ARSList)
[mailto:
>> [EMAIL PROTECTED] *On Behalf Of *Kemes, Lisa
>> *Sent:* Thursday, March 27, 2008 12:05 PM
>> *To:* arslist@ARSLIST.ORG
>> *Subject:* View Forms
>>
>>
>>  **
>>
>> I'm trying to create a View Form that connects to a table on
an Oracle
>> database and I'm getting the error message:
>>
>> "Requested database table not found.  Please check the
spelling (table
>> name is case-sensitive) (ARERR 481)."
>>
>> The table has aradmin added to the permission list.  Is there
anything
>> else I'm missing?
>>
>> AR Server 7.01 Patch 6
>> Windows 2003 app Server
>>
>> *Lisa Kemes *
>> AR System Developer
>> Tyco Electronics
>> 717-810-2408 tel
>> 717-810-2124 fax
>> [EMAIL PROTECTED]
>>
>> __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"



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

[Grooms, Frederick W]

If they are not owned by aradmin, are you including the owner name?
 
Fred



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa
Sent: Thursday, March 27, 2008 2:29 PM
To: arslist@ARSLIST.ORG
Subject: Re: View Forms


** 
These are not ARS tables.  Just plain old tables from an Oracle
database.  Our DBA was able to log into SQL developer with the aradmin
account and see these tables just fine.  For some reason, my admin tool
must not be using the aradmin account for view forms?  I'm connected to
our ARS database so it's working in that respect.
 
These are not owned by aradmin either, but it is in the permission
group.
 

 

Lisa 

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Brian Goralczyk
Sent: Thursday, March 27, 2008 1:44 PM
To: arslist@ARSLIST.ORG
Subject: Re: View Forms


** 
Not true.  She doesn't need the T table.  First off, if it isn't an ARS
table there might (probably won't) be a T table unless it was created
manually.  However, you can still use the view instead.  If it is a
Remedy created table, then the view name has a specific format.  All
none alphanumeric characters are replaced with an underscore.  Also,
view names in an Oracle (and I assume the others) database is only 30
characters long if Remedy created the view.  So if your view (form) name
is longer than 30 characters just drop the exceeding characters.  There
is one other caveat in case you have more than one view name that is the
same until past the 30 character limit.  The last letter (number 30) is
replaced by a sequential number starting with the second form and
incrementing for each form.  Check out my examples but please don't name
your forms as such or think that I have mine named like this.
 
Form Name: CTM:People Site AP:Administration Join
View Name: ctm_people_site_ap_administrat
 
Form Name: CTM:People Site AP:Administration Role Join
View Name: ctm_people_site_ap_administra2
 
Please only use this as an example.  I didn't verify my thoughts from
off the top of my head.
 
Also, if you want the list of views just run this: select view_name from
user_views order by 1
 
That will work in an Oracle db for sure.
 
Also, I have not found a case sensitivity for form or field names when
writing SQL queries.
 
HTH,
 
Brian Goralczyk


On Thu, Mar 27, 2008 at 11:27 AM, Drew Shuller <[EMAIL PROTECTED]> wrote:


Yes, if it's owned by aradmin, she'll need the T table.


Drew

On Thu, 27 Mar

2008, Nisha Ramtri wrote:

> Lisa,
>
> This error normally occurs when the table name that is being
provided is
> different from the actual name in the db. Check for the name,
spelling of
> the table in the database. The table name is case sensitive
also. Hence take
> care of that as well while providing the name of the table.
Also make sure
> that the table is in the aradmin d/b. Hope that helps.
>
> Rgd,
> Nisha.
>
>
> On 3/27/08, Kemes, Lisa <[EMAIL PROTECTED]>
wrote:
>>
>> ** Also, I am typing the table name in CAPS.
>>
>>
>> Lisa
>>
>>
>>  --
>> *From:* Action Request System discussion list(ARSList)
[mailto:
>> [EMAIL PROTECTED] *On Behalf Of *Kemes, Lisa
>> *Sent:* Thursday, March 27, 2008 12:05 PM
>> *To:* arslist@ARSLIST.ORG
>> *Subject:* View Forms
>>
>>
>>  **
>>
>> I'm trying to create a View Form that connects to a table on
an Oracle
>> database and I'm getting the error message:
>>
>> "Requested database table not found.  Please check the
spelling (table
>> name is case-sensitive) (ARERR 481)."
>>
>> The table has aradmin added to the permission list.  Is there
anything
>> else I'm missing?
>>
>> AR Server 7.01 Patch 6
>> Windows 2003 app Server
>>
>> *Lisa Kemes *
>> AR System Developer
>> Tyco Electronics
>> 717-810-2408 tel
>> 717-810-2124 fax
>> [EMAIL PROTECTED]
>>
>> __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: View Forms

[Grooms, Frederick W]

By the way ... These can NOT be synonyms.  They must be actual tables or
views on the database.



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W
Sent: Thursday, March 27, 2008 2:32 PM
To: arslist@ARSLIST.ORG
Subject: Re: View Forms


** 
If they are not owned by aradmin, are you including the owner name?
 
Fred



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa
Sent: Thursday, March 27, 2008 2:29 PM
To: arslist@ARSLIST.ORG
Subject: Re: View Forms


** 
These are not ARS tables.  Just plain old tables from an Oracle
database.  Our DBA was able to log into SQL developer with the aradmin
account and see these tables just fine.  For some reason, my admin tool
must not be using the aradmin account for view forms?  I'm connected to
our ARS database so it's working in that respect.
 
These are not owned by aradmin either, but it is in the permission
group.
 

 

Lisa 

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Brian Goralczyk
Sent: Thursday, March 27, 2008 1:44 PM
To: arslist@ARSLIST.ORG
Subject: Re: View Forms


** 
Not true.  She doesn't need the T table.  First off, if it isn't an ARS
table there might (probably won't) be a T table unless it was created
manually.  However, you can still use the view instead.  If it is a
Remedy created table, then the view name has a specific format.  All
none alphanumeric characters are replaced with an underscore.  Also,
view names in an Oracle (and I assume the others) database is only 30
characters long if Remedy created the view.  So if your view (form) name
is longer than 30 characters just drop the exceeding characters.  There
is one other caveat in case you have more than one view name that is the
same until past the 30 character limit.  The last letter (number 30) is
replaced by a sequential number starting with the second form and
incrementing for each form.  Check out my examples but please don't name
your forms as such or think that I have mine named like this.
 
Form Name: CTM:People Site AP:Administration Join
View Name: ctm_people_site_ap_administrat
 
Form Name: CTM:People Site AP:Administration Role Join
View Name: ctm_people_site_ap_administra2
 
Please only use this as an example.  I didn't verify my thoughts from
off the top of my head.
 
Also, if you want the list of views just run this: select view_name from
user_views order by 1
 
That will work in an Oracle db for sure.
 
Also, I have not found a case sensitivity for form or field names when
writing SQL queries.
 
HTH,
 
Brian Goralczyk


On Thu, Mar 27, 2008 at 11:27 AM, Drew Shuller <[EMAIL PROTECTED]> wrote:


Yes, if it's owned by aradmin, she'll need the T table.


Drew

On Thu, 27 Mar

2008, Nisha Ramtri wrote:

> Lisa,
>
> This error normally occurs when the table name that is being
provided is
> different from the actual name in the db. Check for the name,
spelling of
> the table in the database. The table name is case sensitive
also. Hence take
> care of that as well while providing the name of the table.
Also make sure
> that the table is in the aradmin d/b. Hope that helps.
>
> Rgd,
> Nisha.
>
>
> On 3/27/08, Kemes, Lisa <[EMAIL PROTECTED]>
wrote:
>>
>> ** Also, I am typing the table name in CAPS.
>>
>>
>> Lisa
>>
>>
>>  --
>> *From:* Action Request System discussion list(ARSList)
[mailto:
>> [EMAIL PROTECTED] *On Behalf Of *Kemes, Lisa
>> *Sent:* Thursday, March 27, 2008 12:05 PM
>> *To:* arslist@ARSLIST.ORG
>> *Subject:* View Forms
>>
>>
>>  **
>>
>> I'm trying to create a View Form that connects to a table on
an Oracle
>> database and I'm getting the error message:
>>
>> "Requested database table not found.  Please check the
spelling (table
>> name is case-sensitive) (ARERR 481)."
>>
>> The table has aradmin added to the permission list.  Is there
anything
>> else I'm missing?
>>
>> AR Server 7.01 Patch 6
>> Windows 2003 app Server
>>
>> *Lisa Kemes *
>> AR System Developer
>> Tyco Electronics
>> 717-810-2408 tel
>> 717-810-2124 fax
>> [EMAIL PROTECTED]
>>
>> __Platinum Sponsor: www.rmsportal.com
  ARSlist: "Where the Answers Are"
>> html___
>> __Platinum Sponsor: www.rmsportal.com
  ARSlist: "Where the Answers Are"
>> html___
>>
>
>
  

Re: View Forms

[Kemes, Lisa]

yes.  DCC.COST_CENTER_V is the name of the view.  I even tried
DCC_COST_CENTER_V.  ugh.  Something is just not right.
 

Lisa 

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W
Sent: Thursday, March 27, 2008 3:32 PM
To: arslist@ARSLIST.ORG
Subject: Re: View Forms


** 
If they are not owned by aradmin, are you including the owner name?
 
Fred



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa
Sent: Thursday, March 27, 2008 2:29 PM
To: arslist@ARSLIST.ORG
Subject: Re: View Forms


** 
These are not ARS tables.  Just plain old tables from an Oracle
database.  Our DBA was able to log into SQL developer with the aradmin
account and see these tables just fine.  For some reason, my admin tool
must not be using the aradmin account for view forms?  I'm connected to
our ARS database so it's working in that respect.
 
These are not owned by aradmin either, but it is in the permission
group.
 

 

Lisa 

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Brian Goralczyk
Sent: Thursday, March 27, 2008 1:44 PM
To: arslist@ARSLIST.ORG
Subject: Re: View Forms


** 
Not true.  She doesn't need the T table.  First off, if it isn't an ARS
table there might (probably won't) be a T table unless it was created
manually.  However, you can still use the view instead.  If it is a
Remedy created table, then the view name has a specific format.  All
none alphanumeric characters are replaced with an underscore.  Also,
view names in an Oracle (and I assume the others) database is only 30
characters long if Remedy created the view.  So if your view (form) name
is longer than 30 characters just drop the exceeding characters.  There
is one other caveat in case you have more than one view name that is the
same until past the 30 character limit.  The last letter (number 30) is
replaced by a sequential number starting with the second form and
incrementing for each form.  Check out my examples but please don't name
your forms as such or think that I have mine named like this.
 
Form Name: CTM:People Site AP:Administration Join
View Name: ctm_people_site_ap_administrat
 
Form Name: CTM:People Site AP:Administration Role Join
View Name: ctm_people_site_ap_administra2
 
Please only use this as an example.  I didn't verify my thoughts from
off the top of my head.
 
Also, if you want the list of views just run this: select view_name from
user_views order by 1
 
That will work in an Oracle db for sure.
 
Also, I have not found a case sensitivity for form or field names when
writing SQL queries.
 
HTH,
 
Brian Goralczyk


On Thu, Mar 27, 2008 at 11:27 AM, Drew Shuller <[EMAIL PROTECTED]> wrote:


Yes, if it's owned by aradmin, she'll need the T table.


Drew

On Thu, 27 Mar

2008, Nisha Ramtri wrote:

> Lisa,
>
> This error normally occurs when the table name that is being
provided is
> different from the actual name in the db. Check for the name,
spelling of
> the table in the database. The table name is case sensitive
also. Hence take
> care of that as well while providing the name of the table.
Also make sure
> that the table is in the aradmin d/b. Hope that helps.
>
> Rgd,
> Nisha.
>
>
> On 3/27/08, Kemes, Lisa <[EMAIL PROTECTED]>
wrote:
>>
>> ** Also, I am typing the table name in CAPS.
>>
>>
>> Lisa
>>
>>
>>  --
>> *From:* Action Request System discussion list(ARSList)
[mailto:
>> [EMAIL PROTECTED] *On Behalf Of *Kemes, Lisa
>> *Sent:* Thursday, March 27, 2008 12:05 PM
>> *To:* arslist@ARSLIST.ORG
>> *Subject:* View Forms
>>
>>
>>  **
>>
>> I'm trying to create a View Form that connects to a table on
an Oracle
>> database and I'm getting the error message:
>>
>> "Requested database table not found.  Please check the
spelling (table
>> name is case-sensitive) (ARERR 481)."
>>
>> The table has aradmin added to the permission list.  Is there
anything
>> else I'm missing?
>>
>> AR Server 7.01 Patch 6
>> Windows 2003 app Server
>>
>> *Lisa Kemes *
>> AR System Developer
>> Tyco Electronics
>> 717-810-2408 tel
>> 717-810-2124 fax
>> [EMAIL PROTECTED]
>>
>> __Platinum Sponsor: www.rmsportal.com
  ARSlist: "Where the Answers Are"
>> html___
>> __Platinum Sponsor: www.rmsportal.com
  ARSlist: "Where the Answers Are"
>> htm

Verify records prior to import of people

[Daniel Weise]

We are running AR System 7.01 connecting to an Oracle 10g database.
We are maintaining our people by importing the records from a view
against our Lawson HR data.  We take this and populate a staging table
and then run Active links to look for and populate any changes to the
people records.  We repopulate the staging table with fresh data
nightly.  I want to verify there are records in the Lawson view before
clearing the staging table.  Any ideas what I could do to accomplish
this?

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

Re: Installation Question...

[Brian Gillock]

I had that same issue and I solved it by installing the CMDB extension
loader separately.  You can find it in the celsdk folder of any of the apps
I believe.

 

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Richard Copits
Sent: Thursday, March 27, 2008 12:08 PM
To: arslist@ARSLIST.ORG
Subject: Re: Installation Question...

 

** 

I installed the ARServer with no errors, same with the CMDB.  Thanks for

narrowing it down for me - I'll reinstall the ARServer and CMDDB.  Is there

any cautions as to version for either?

 

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook
Sent: Thursday, March 27, 2008 3:02 PM
To: arslist@ARSLIST.ORG
Subject: Re: Installation Question...

 

** I think it's talking about the CMDB data model.  Be sure that you've set
up your AR System sufficiently before starting the ITSM installs, or you'll
get strange errors like this.  Did you license AR Server before installing
any ITSM apps?  Did you install CMDB before you installed the other apps?

Give us some more information, and we can probably help you find this.

Rick

On Thu, Mar 27, 2008 at 11:44 AM, Richard Copits
<[EMAIL PROTECTED]> wrote:

** 

I'm attempting to install a Remedy 7.1 system and all seems to be

going well. However, when I install the Asset Management module

it gets almost all the way through and then throws the error message

"There were failures while loading the extensions". It doesn't give

any error number. I've looked in the install and configure manuals

but don't see anything that relates to "extensions" or any error

messages that seem relevant. Has anyone any suggestions as to

what "extensions" get loaded or  Thank you.


Portions of this message may be confidential under an exemption to Ohio's
public records law or under a legal privilege. If you have received this
message in error or due to an unauthorized transmission or interception,
please delete all copies from your system without disclosing, copying, or
transmitting this message.

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


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



Portions of this message may be confidential under an exemption to Ohio's
public records law or under a legal privilege. If you have received this
message in error or due to an unauthorized transmission or interception,
please delete all copies from your system without disclosing, copying, or
transmitting this message.

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

[Brian Goralczyk]

If you can log into the database as ARADMIN and see the tables then you
should be able to create the Remedy view.  It would seem to me that you
might just want to create a simple form that runs the query "select
table_name from user_tables order by 1" so that you can see the list of
tables (and any odd naming) that are available to the Remedy server.  Often
times this is a simple way to make sure you get the name right.  If you run
an active link with a set fields / sql command and make that your sql
statement, you can then populate a field with the table name so that you can
just cut and paste.

On Thu, Mar 27, 2008 at 2:32 PM, Grooms, Frederick W <
[EMAIL PROTECTED]> wrote:

> ** If they are not owned by aradmin, are you including the owner name?
>
> Fred
>
>  --
>  *From:* Action Request System discussion list(ARSList) [mailto:
> [EMAIL PROTECTED] *On Behalf Of *Kemes, Lisa
> *Sent:* Thursday, March 27, 2008 2:29 PM
>
> *To:* arslist@ARSLIST.ORG
> *Subject:* Re: View Forms
>
>   ** These are not ARS tables.  Just plain old tables from an Oracle
> database.  Our DBA was able to log into SQL developer with the aradmin
> account and see these tables just fine.  For some reason, my admin tool must
> not be using the aradmin account for view forms?  I'm connected to our ARS
> database so it's working in that respect.
>
> These are not owned by aradmin either, but it is in the permission group.
>
> 
>
>
> Lisa
>
>
>  --
> *From:* Action Request System discussion list(ARSList) [mailto:
> [EMAIL PROTECTED] *On Behalf Of *Brian Goralczyk
> *Sent:* Thursday, March 27, 2008 1:44 PM
> *To:* arslist@ARSLIST.ORG
> *Subject:* Re: View Forms
>
> ** Not true.  She doesn't need the T table.  First off, if it isn't an ARS
> table there might (probably won't) be a T table unless it was created
> manually.  However, you can still use the view instead.  If it is a Remedy
> created table, then the view name has a specific format.  All none
> alphanumeric characters are replaced with an underscore.  Also, view names
> in an Oracle (and I assume the others) database is only 30 characters long
> if Remedy created the view.  So if your view (form) name is longer than 30
> characters just drop the exceeding characters.  There is one other caveat in
> case you have more than one view name that is the same until past the 30
> character limit.  The last letter (number 30) is replaced by a sequential
> number starting with the second form and incrementing for each form.  Check
> out my examples but please don't name your forms as such or think that I
> have mine named like this.
>
> Form Name: CTM:People Site AP:Administration Join
> View Name: ctm_people_site_ap_administrat
>
> Form Name: CTM:People Site AP:Administration Role Join
> View Name: ctm_people_site_ap_administra2
>
> Please only use this as an example.  I didn't verify my thoughts from off
> the top of my head.
>
> Also, if you want the list of views just run this: select view_name from
> user_views order by 1
>
> That will work in an Oracle db for sure.
>
> Also, I have not found a case sensitivity for form or field names when
> writing SQL queries.
>
> HTH,
>
> Brian Goralczyk
>
> On Thu, Mar 27, 2008 at 11:27 AM, Drew Shuller <[EMAIL PROTECTED]> wrote:
>
> > Yes, if it's owned by aradmin, she'll need the T table.
> >
> > Drew
> >
> > On Thu, 27 Mar
> >  2008, Nisha Ramtri wrote:
> >
> > > Lisa,
> > >
> > > This error normally occurs when the table name that is being provided
> > is
> > > different from the actual name in the db. Check for the name, spelling
> > of
> > > the table in the database. The table name is case sensitive also.
> > Hence take
> > > care of that as well while providing the name of the table. Also make
> > sure
> > > that the table is in the aradmin d/b. Hope that helps.
> > >
> > > Rgd,
> > > Nisha.
> > >
> > >
> > > On 3/27/08, Kemes, Lisa <[EMAIL PROTECTED]> wrote:
> > >>
> > >> ** Also, I am typing the table name in CAPS.
> > >>
> > >>
> > >> Lisa
> > >>
> > >>
> > >>  --
> > >> *From:* Action Request System discussion list(ARSList) [mailto:
> > >> [EMAIL PROTECTED] *On Behalf Of *Kemes, Lisa
> > >> *Sent:* Thursday, March 27, 2008 12:05 PM
> > >> *To:* arslist@ARSLIST.ORG
> > >> *Subject:* View Forms
> > >>
> > >>
> > >>  **
> > >>
> > >> I'm trying to create a View Form that connects to a table on an
> > Oracle
> > >> database and I'm getting the error message:
> > >>
> > >> "Requested database table not found.  Please check the spelling
> > (table
> > >> name is case-sensitive) (ARERR 481)."
> > >>
> > >> The table has aradmin added to the permission list.  Is there
> > anything
> > >> else I'm missing?
> > >>
> > >> AR Server 7.01 Patch 6
> > >> Windows 2003 app Server
> > >>
> > >> *Lisa Kemes *
> > >> AR System Developer
> > >> Tyco Electronics
> > >> 717-810-2408 tel
> > >> 717-810-2124 fax
> > >> [EMAIL PROTECTED]
> > >>
> > >> __Platinum Sponsor: w

Re: Verify records prior to import of people

[Brian Gillock]

Have you thought about using the Atrium Integration Engine for this?  We are
doing pretty much the same thing.  The AIE gives several options for
creating and updating records.

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Daniel Weise
Sent: Thursday, March 27, 2008 12:38 PM
To: arslist@ARSLIST.ORG
Subject: Verify records prior to import of people

We are running AR System 7.01 connecting to an Oracle 10g database.
We are maintaining our people by importing the records from a view
against our Lawson HR data.  We take this and populate a staging table
and then run Active links to look for and populate any changes to the
people records.  We repopulate the staging table with fresh data
nightly.  I want to verify there are records in the Lawson view before
clearing the staging table.  Any ideas what I could do to accomplish
this?


___
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: View Forms

[Kemes, Lisa]

Thanks, I'm going to try thisEverything points to the fact that this
should work.   
 
I'll let you know!
 

Lisa 

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Brian Goralczyk
Sent: Thursday, March 27, 2008 3:51 PM
To: arslist@ARSLIST.ORG
Subject: Re: View Forms


** If you can log into the database as ARADMIN and see the tables then
you should be able to create the Remedy view.  It would seem to me that
you might just want to create a simple form that runs the query "select
table_name from user_tables order by 1" so that you can see the list of
tables (and any odd naming) that are available to the Remedy server.
Often times this is a simple way to make sure you get the name right.
If you run an active link with a set fields / sql command and make that
your sql statement, you can then populate a field with the table name so
that you can just cut and paste.


On Thu, Mar 27, 2008 at 2:32 PM, Grooms, Frederick W
<[EMAIL PROTECTED]> wrote:


** 
If they are not owned by aradmin, are you including the owner
name?
 
Fred




From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa

Sent: Thursday, March 27, 2008 2:29 PM 

To: arslist@ARSLIST.ORG
Subject: Re: View Forms


** 
These are not ARS tables.  Just plain old tables from an Oracle
database.  Our DBA was able to log into SQL developer with the aradmin
account and see these tables just fine.  For some reason, my admin tool
must not be using the aradmin account for view forms?  I'm connected to
our ARS database so it's working in that respect.
 
These are not owned by aradmin either, but it is in the
permission group.
 

 

Lisa 

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Brian Goralczyk
Sent: Thursday, March 27, 2008 1:44 PM
To: arslist@ARSLIST.ORG
Subject: Re: View Forms


** 
Not true.  She doesn't need the T table.  First off, if it isn't
an ARS table there might (probably won't) be a T table unless it was
created manually.  However, you can still use the view instead.  If it
is a Remedy created table, then the view name has a specific format.
All none alphanumeric characters are replaced with an underscore.  Also,
view names in an Oracle (and I assume the others) database is only 30
characters long if Remedy created the view.  So if your view (form) name
is longer than 30 characters just drop the exceeding characters.  There
is one other caveat in case you have more than one view name that is the
same until past the 30 character limit.  The last letter (number 30) is
replaced by a sequential number starting with the second form and
incrementing for each form.  Check out my examples but please don't name
your forms as such or think that I have mine named like this.
 
Form Name: CTM:People Site AP:Administration Join
View Name: ctm_people_site_ap_administrat
 
Form Name: CTM:People Site AP:Administration Role Join
View Name: ctm_people_site_ap_administra2
 
Please only use this as an example.  I didn't verify my thoughts
from off the top of my head.
 
Also, if you want the list of views just run this: select
view_name from user_views order by 1
 
That will work in an Oracle db for sure.
 
Also, I have not found a case sensitivity for form or field
names when writing SQL queries.
 
HTH,
 
Brian Goralczyk


On Thu, Mar 27, 2008 at 11:27 AM, Drew Shuller <[EMAIL PROTECTED]>
wrote:


Yes, if it's owned by aradmin, she'll need the T table.


Drew

On Thu, 27 Mar

2008, Nisha Ramtri wrote:

> Lisa,
>
> This error normally occurs when the table name that is
being provided is
> different from the actual name in the db. Check for
the name, spelling of
> the table in the database. The table name is case
sensitive also. Hence take
> care of that as well while providing the name of the
table. Also make sure
> that the table is in the aradmin d/b. Hope that helps.
>
> Rgd,
> Nisha.
>
>
> On 3/27/08, Kemes, Lisa
<[EMAIL PROTECTED]> wrote:
>>
>> ** Also, I am typing the table name in CAPS.
>>
>>
>> Lisa
   

Re: Verify records prior to import of people

[Brian Goralczyk]

Daniel,

You could create a display only field on a control form that would run a
query against the database returning only the first record or a record
count, and then make sure that the field is either not null or doesn't equal
0 before running the rest of the process.

Brian Goralczyk

On Thu, Mar 27, 2008 at 2:38 PM, Daniel Weise <[EMAIL PROTECTED]>
wrote:

> We are running AR System 7.01 connecting to an Oracle 10g database.
> We are maintaining our people by importing the records from a view
> against our Lawson HR data.  We take this and populate a staging table
> and then run Active links to look for and populate any changes to the
> people records.  We repopulate the staging table with fresh data
> nightly.  I want to verify there are records in the Lawson view before
> clearing the staging table.  Any ideas what I could do to accomplish
> this?
>
>
> ___
> 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: View Forms

[Kemes, Lisa]

Ok, I just did this and this table it not in the list.  How can I get
this table in the list?  Is there a setting on preferences or something
that I'm missing?
 

Lisa 

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa
Sent: Thursday, March 27, 2008 3:59 PM
To: arslist@ARSLIST.ORG
Subject: Re: View Forms


** 
Thanks, I'm going to try thisEverything points to the fact that this
should work.   
 
I'll let you know!
 

Lisa 

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Brian Goralczyk
Sent: Thursday, March 27, 2008 3:51 PM
To: arslist@ARSLIST.ORG
Subject: Re: View Forms


** If you can log into the database as ARADMIN and see the tables then
you should be able to create the Remedy view.  It would seem to me that
you might just want to create a simple form that runs the query "select
table_name from user_tables order by 1" so that you can see the list of
tables (and any odd naming) that are available to the Remedy server.
Often times this is a simple way to make sure you get the name right.
If you run an active link with a set fields / sql command and make that
your sql statement, you can then populate a field with the table name so
that you can just cut and paste.


On Thu, Mar 27, 2008 at 2:32 PM, Grooms, Frederick W
<[EMAIL PROTECTED]> wrote:


** 
If they are not owned by aradmin, are you including the owner
name?
 
Fred




From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa

Sent: Thursday, March 27, 2008 2:29 PM 

To: arslist@ARSLIST.ORG
Subject: Re: View Forms


** 
These are not ARS tables.  Just plain old tables from an Oracle
database.  Our DBA was able to log into SQL developer with the aradmin
account and see these tables just fine.  For some reason, my admin tool
must not be using the aradmin account for view forms?  I'm connected to
our ARS database so it's working in that respect.
 
These are not owned by aradmin either, but it is in the
permission group.
 

 

Lisa 

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Brian Goralczyk
Sent: Thursday, March 27, 2008 1:44 PM
To: arslist@ARSLIST.ORG
Subject: Re: View Forms


** 
Not true.  She doesn't need the T table.  First off, if it isn't
an ARS table there might (probably won't) be a T table unless it was
created manually.  However, you can still use the view instead.  If it
is a Remedy created table, then the view name has a specific format.
All none alphanumeric characters are replaced with an underscore.  Also,
view names in an Oracle (and I assume the others) database is only 30
characters long if Remedy created the view.  So if your view (form) name
is longer than 30 characters just drop the exceeding characters.  There
is one other caveat in case you have more than one view name that is the
same until past the 30 character limit.  The last letter (number 30) is
replaced by a sequential number starting with the second form and
incrementing for each form.  Check out my examples but please don't name
your forms as such or think that I have mine named like this.
 
Form Name: CTM:People Site AP:Administration Join
View Name: ctm_people_site_ap_administrat
 
Form Name: CTM:People Site AP:Administration Role Join
View Name: ctm_people_site_ap_administra2
 
Please only use this as an example.  I didn't verify my thoughts
from off the top of my head.
 
Also, if you want the list of views just run this: select
view_name from user_views order by 1
 
That will work in an Oracle db for sure.
 
Also, I have not found a case sensitivity for form or field
names when writing SQL queries.
 
HTH,
 
Brian Goralczyk


On Thu, Mar 27, 2008 at 11:27 AM, Drew Shuller <[EMAIL PROTECTED]>
wrote:


Yes, if it's owned by aradmin, she'll need the T table.


Drew

On Thu, 27 Mar

2008, Nisha Ramtri wrote:

> Lisa,
>
> This error normally occurs when the table name that is
being provided is
> different from the actual name in the db. Check for
the name, spelling of
> the table in the database. The table name is case
sensitive also. Hence take
> care of that as well while providing the name of the
table. Also make s

Re: View Forms

[Kemes, Lisa]

Sorry, stupid question, when I use the query select table_name from
user_tables order by 1, this will only give me the AR System database
tables, not the ones that are on another oracle database.
 

Lisa 

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa
Sent: Thursday, March 27, 2008 4:05 PM
To: arslist@ARSLIST.ORG
Subject: Re: View Forms


** 
Ok, I just did this and this table it not in the list.  How can I get
this table in the list?  Is there a setting on preferences or something
that I'm missing?
 

Lisa 

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa
Sent: Thursday, March 27, 2008 3:59 PM
To: arslist@ARSLIST.ORG
Subject: Re: View Forms


** 
Thanks, I'm going to try thisEverything points to the fact that this
should work.   
 
I'll let you know!
 

Lisa 

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Brian Goralczyk
Sent: Thursday, March 27, 2008 3:51 PM
To: arslist@ARSLIST.ORG
Subject: Re: View Forms


** If you can log into the database as ARADMIN and see the tables then
you should be able to create the Remedy view.  It would seem to me that
you might just want to create a simple form that runs the query " u " so
that you can see the list of tables (and any odd naming) that are
available to the Remedy server.  Often times this is a simple way to
make sure you get the name right.  If you run an active link with a set
fields / sql command and make that your sql statement, you can then
populate a field with the table name so that you can just cut and paste.


On Thu, Mar 27, 2008 at 2:32 PM, Grooms, Frederick W
<[EMAIL PROTECTED]> wrote:


** 
If they are not owned by aradmin, are you including the owner
name?
 
Fred




From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa

Sent: Thursday, March 27, 2008 2:29 PM 

To: arslist@ARSLIST.ORG
Subject: Re: View Forms


** 
These are not ARS tables.  Just plain old tables from an Oracle
database.  Our DBA was able to log into SQL developer with the aradmin
account and see these tables just fine.  For some reason, my admin tool
must not be using the aradmin account for view forms?  I'm connected to
our ARS database so it's working in that respect.
 
These are not owned by aradmin either, but it is in the
permission group.
 

 

Lisa 

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Brian Goralczyk
Sent: Thursday, March 27, 2008 1:44 PM
To: arslist@ARSLIST.ORG
Subject: Re: View Forms


** 
Not true.  She doesn't need the T table.  First off, if it isn't
an ARS table there might (probably won't) be a T table unless it was
created manually.  However, you can still use the view instead.  If it
is a Remedy created table, then the view name has a specific format.
All none alphanumeric characters are replaced with an underscore.  Also,
view names in an Oracle (and I assume the others) database is only 30
characters long if Remedy created the view.  So if your view (form) name
is longer than 30 characters just drop the exceeding characters.  There
is one other caveat in case you have more than one view name that is the
same until past the 30 character limit.  The last letter (number 30) is
replaced by a sequential number starting with the second form and
incrementing for each form.  Check out my examples but please don't name
your forms as such or think that I have mine named like this.
 
Form Name: CTM:People Site AP:Administration Join
View Name: ctm_people_site_ap_administrat
 
Form Name: CTM:People Site AP:Administration Role Join
View Name: ctm_people_site_ap_administra2
 
Please only use this as an example.  I didn't verify my thoughts
from off the top of my head.
 
Also, if you want the list of views just run this: select
view_name from user_views order by 1
 
That will work in an Oracle db for sure.
 
Also, I have not found a case sensitivity for form or field
names when writing SQL queries.
 
HTH,
 
Brian Goralczyk


On Thu, Mar 27, 2008 at 11:27 AM, Drew Shuller <[EMAIL PROTECTED]>
wrote:


Yes, if it's owned by aradmin, she'll need the T table.


Drew

On Thu, 27 Mar

2008, Nisha Ramtri wrote:

 

Re: Installation Question...

[Timothy Powell]

For what it's worth, here is a detailed installation order document we got
from BMC Premier Support. The doc was written assuming install on a Windows
machine, an install of all the major applications, utilizing Full Text
Search and using IIS as the web server. We were also told that when you are
installing Asset and/or Change, you MUST add the BMC:Financial Mgmt
Application license and at least one BMC:Financial Mgmt User Fixed license.
We did it in the order shown below along with adding the Financial licenses,
and our installs went without issue.

 

HTH, Tim


Installation Order for ARS products and the ITSM Suite


Detailed Installation process for ARS 7.1 (Patch 1) with ITSM 7.0.2 (Patch
6) and CMDB 2.1 (Patch 1)

1.   Humming Bird Search Engine. This is a part of the AR server download

2.   AR Server 7.1 Patch 01, Remedy User, Remedy Admin, and JSDK (JDK
minimum of version 1.5.0.12).

3.   Add all application and user licenses via the Remedy User Tool.

4.   Take a database (db) backup then install Mid Tier 7.1

5.   Take a db backup then install Flashboards 7.1

6.   Take a db backup then install Approval Server 7.1  Perform a review of
the installation logs to verify 100% success

7.   Take a db backup then install Assignment Engine 7.1  Perform a review
of the installation logs to verify 100% success

8.   Enable Development Cache mode from the Admin Tool and restart AR Server
Service 

9.   Take a db backup then install E-mail Engine 7.1  Perform a review of
the installation logs to verify 100% success
For Windows environments please disable the E-mail Engine service for the
duration of the remaining installs to work around a known defect

10.Take a db backup then install CMDB 2.1 Patch 1  Perform a review
of the installation logs to verify 100% success

11.Take a db backup then install CMDB Help Files

12.Install CMDB Extension Loader (Select Web server IIS) 
DO NOT set Admin only mode as the ITSM Guide states. This is a known defect
and will negatively affect the installation.

  -navigate to the celsdk directory of the ITSM installation media (for
ex: Installs\ITSM\7.0\Service Desk\Incident
Mgmt\GAInstall\incident700[1].win\win\incident\cdrom\celsdk) and initiate
the 

   cmdbExtLoader.exe. This executable will extend the Common Data Model
(CMDB structure) with ITSM attributes and classes.  

 *perform a review of the installation logs to verify 100% success.
These logs will be located under the local temp environment variable.  An
example of this is C:\Documents and Settings\Administrator\Local
Settings\Temp.

13.Take a db backup and Verify Dev Cache mode is still enabled

14.Incident Management 7.0.2.  Install the First Commercial Shipment
(FCS) of the product first. The upgrade to Patch 6 will occur later. If you
are installing any other ITSM applications, do not select the DSL
(Definitive Software Library) during this first ITSM installation.  The
install already has to install the Foundation Elements and the application.
This option can be selected in the second ITSM install. Perform a review of
the installation logs to verify 100% success

15.Incident Management Help Files.

16.Take a db backup and Verify Dev Cache mode is still enabled

17.Problem Management 7.0.2.  On fresh installs, install the FCS
version of the product first. Select the DSL checkbox to import the library
data structure. This install can take up to 2 hours.

 Perform a review of the installation logs to verify 100% success

18.Problem Management Help Files

19.Take a db backup then install Change Management 7.0.2. On fresh
installs, install the FCS of the product first. This install can take 30
minutes or more. Perform a review of the installation logs to verify 100%
success

20.Change Management Help Files

21.Take a db backup then install Asset Management 7.0.2. On fresh
installs, install the FCS of the product first. Perform a review of the
installation logs to verify 100% success

22.Asset Management Help Files

23.Take a db backup then do the Pre SLM installation steps: *Install
Jboss or other servlet engine (If you installed mid tier, this is already
done) - *install JDK (if not already installed previously) -  *Set system
environment variable BMC_SLM_JAVA_HOME with correct Java jre home path and
restart AR Server.

24.Install SLM 7.1  Perform a review of the installation logs to
verify 100% success

25.Install SLM Help Files

26.Install SLM Integrations

27.Verify Install SLM Integration via Remedy User Tool -> SLM
Management Console-> Administration tab -> Custom Configuration -> and
Select SLM -> Configure -> Application Settings -> Data Source. The data
sources should be AST, CHG, HPD, and SRM.   For Windows environments
re-enable the e-mail engine service

28.Take a db backup then If not already done and you want to do the
DSL, Install DSL

Re: First Contact Resolution (FCR) ITIL & ITSM 7 (U)

[Hennigan, Sandra H CTR OSD-CIO]

UNCLASSIFIED

We created our own FCR - the field is set to Yes if Assigned to Group
and/or Individual is not changed; No if Assigned to Group and/or
Individual is changed. 
No time restriction on resolution.

We cannot run it against submitter does not change because our end-user
submit tickets via web and email workflow.

Sandra Hennigan

OSD Enterprise Remedy Administrator
Office # 703-602-2525 x248

Apparently, there is nothing that cannot happen today.  Mark Twain

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kevin Pulsen
Sent: Thursday, March 27, 2008 12:55 PM
To: arslist@ARSLIST.ORG
Subject: First Contact Resolution (FCR) ITIL & ITSM 7


** Hello all,

I'm trying to find information on FCR (First Contact Resolution)
specifically for the Service Desk person.

Is there a starting goal within ITIL regarding FCR?

For example... the Service Desk needs to meet a 35% FCR goal.

Or is this number subjective?

If anyone is using FCR, could you please let me know your goal is and
what  factors you used to assess this goal.

Thanks!

Kevin P.



  _  

Never miss a thing. Make Yahoo your homepage.

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

[Gary Dries]

I just ran into this exact problem today, the aradmin account had access to
the Database, but did not have proper access to the table I was trying to
build the view against.  Talk to your DBA and make sure that not only can
they see the table in the SQL Developer, but can access and view the data in
the table its self.

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

Re: View Forms

[Kemes, Lisa]

Thanks everyone!  I figured it out.  I had to put the @ symbol in the
table name field.   So it's:
 
[EMAIL PROTECTED]
 

Lisa 

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Gary Dries
Sent: Thursday, March 27, 2008 4:23 PM
To: arslist@ARSLIST.ORG
Subject: Re: View Forms


** I just ran into this exact problem today, the aradmin account had
access to the Database, but did not have proper access to the table I
was trying to build the view against.  Talk to your DBA and make sure
that not only can they see the table in the SQL Developer, but can
access and view the data in the table its self. __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 Forms

[Jason Miller]

Hi Lisa,

Most if this reply is for troubleshooting issue between difference db
servers.  If not may it live long in the archives and be useful to somebody
down the road...

Are these databases on different servers?  If so I think you have to link
the servers before you can create a view form (it's been a while since I
created a view form against a remote Oracle db).  You said that the SQL
Developer was able to login and see the view with aradmin, was that on the
db server that the view resides on? If not make sure the view is accessible
from the Remedy db server using database tools before you getting into
troubleshooting the Remedy end.  By the looks of the view name you supplied
it is not across servers or that is the problem, you are not telling the
Remedy db server what host/TNS name where to find the view.  And of course
if they are on difference servers check firewalls, etc.  Can you tnsping the
remove server from the Remedy db server.

HTH,
Jason

On Thu, Mar 27, 2008 at 12:59 PM, Kemes, Lisa <
[EMAIL PROTECTED]> wrote:

> ** Thanks, I'm going to try thisEverything points to the fact that
> this should work.
>
> I'll let you know!
>
>
> Lisa
>
>
>  --
> *From:* Action Request System discussion list(ARSList) [mailto:
> [EMAIL PROTECTED] *On Behalf Of *Brian Goralczyk
> *Sent:* Thursday, March 27, 2008 3:51 PM
>
> *To:* arslist@ARSLIST.ORG
> *Subject:* Re: View Forms
>
> ** If you can log into the database as ARADMIN and see the tables then you
> should be able to create the Remedy view.  It would seem to me that you
> might just want to create a simple form that runs the query "select
> table_name from user_tables order by 1" so that you can see the list of
> tables (and any odd naming) that are available to the Remedy server.  Often
> times this is a simple way to make sure you get the name right.  If you run
> an active link with a set fields / sql command and make that your sql
> statement, you can then populate a field with the table name so that you can
> just cut and paste.
>
> On Thu, Mar 27, 2008 at 2:32 PM, Grooms, Frederick W <
> [EMAIL PROTECTED]> wrote:
>
> > ** If they are not owned by aradmin, are you including the owner name?
> >
> > Fred
> >
> >  --
> >  *From:* Action Request System discussion list(ARSList) [mailto:
> > [EMAIL PROTECTED] *On Behalf Of *Kemes, Lisa
> > *Sent:* Thursday, March 27, 2008 2:29 PM
> >
> > *To:* arslist@ARSLIST.ORG
> > *Subject:* Re: View Forms
> >
> >   ** These are not ARS tables.  Just plain old tables from an Oracle
> > database.  Our DBA was able to log into SQL developer with the aradmin
> > account and see these tables just fine.  For some reason, my admin tool must
> > not be using the aradmin account for view forms?  I'm connected to our ARS
> > database so it's working in that respect.
> >
> > These are not owned by aradmin either, but it is in the permission
> > group.
> >
> > 
> >
> >
> > Lisa
> >
> >
> >  --
> > *From:* Action Request System discussion list(ARSList) [mailto:
> > [EMAIL PROTECTED] *On Behalf Of *Brian Goralczyk
> > *Sent:* Thursday, March 27, 2008 1:44 PM
> > *To:* arslist@ARSLIST.ORG
> > *Subject:* Re: View Forms
> >
> > ** Not true.  She doesn't need the T table.  First off, if it isn't an
> > ARS table there might (probably won't) be a T table unless it was created
> > manually.  However, you can still use the view instead.  If it is a Remedy
> > created table, then the view name has a specific format.  All none
> > alphanumeric characters are replaced with an underscore.  Also, view names
> > in an Oracle (and I assume the others) database is only 30 characters long
> > if Remedy created the view.  So if your view (form) name is longer than 30
> > characters just drop the exceeding characters.  There is one other caveat in
> > case you have more than one view name that is the same until past the 30
> > character limit.  The last letter (number 30) is replaced by a sequential
> > number starting with the second form and incrementing for each form.  Check
> > out my examples but please don't name your forms as such or think that I
> > have mine named like this.
> >
> > Form Name: CTM:People Site AP:Administration Join
> > View Name: ctm_people_site_ap_administrat
> >
> > Form Name: CTM:People Site AP:Administration Role Join
> > View Name: ctm_people_site_ap_administra2
> >
> > Please only use this as an example.  I didn't verify my thoughts from
> > off the top of my head.
> >
> > Also, if you want the list of views just run this: select view_name from
> > user_views order by 1
> >
> > That will work in an Oracle db for sure.
> >
> > Also, I have not found a case sensitivity for form or field names when
> > writing SQL queries.
> >
> > HTH,
> >
> > Brian Goralczyk
> >
> > On Thu, Mar 27, 2008 at 11:27 AM, Drew Shuller <[EMAIL PROTECTED]> wrote:
> >
> > > Yes, if it's owned by aradmin, she'll need the T table.
> > >
> > > Drew
> > >
> 

arimportcmd error

[Rick Cook]

First, I can't believe that there are no Remedy KB entries for arimportcmd.
None.  Wow.

We are attempting to use arimportcmd in an Active Link to import a small
number of records into a form.  We have a mapping file that works just fine
in the Import Tool.  When we attempt to run it from the Active Link or the
command line, using the same user/pw and mapping file, we get an error that
says that the Import command line is missing the schema option or has a
wrong format.  There isn't even an arimportcmd parameter for the schema, so
I don't know what it's complaining about.

Any ideas to help us out?  We verified the paths, file names, etc., and all
names match exactly, including case.

Rick

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

View Form not see a Key Field

[Gary Dries]

I am creating a couple of View forms to a SQL DB table from an Oracle DB
remedy system using a dblink.  Via the DB Link I am able to connect to the
table and load all the fields but I do not see a column in the key field
drop down of the create view dialog.

In both tables the field I am wanting to use as the key is a 15 byte
varchar, Null not allowed, and it is not designated as a key in the SQL db.
On the first table the only column I see is a 4 byte int status field, and
on the second I do not see a column listed at all that table which only
contains varchars.

any ideas

Thanks
G.

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

UNSUBSCRIBE

[Suzanne Daymond]

Suzanne Daymond
Senior Recruiter
Expedia
[EMAIL PROTECTED]
425 679 7461 (Office)
425 681 2800 (Cell)



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

Re: First Contact Resolution (FCR) ITIL & ITSM 7

[Jason Miller]

Our goal is 80% (was 75% until recently).  Our HD has a lot of rights and
authority like Ty mentioned so they have a pretty high percentage.  We do
not have the 1 hour rule like I have seen at other places.  They have the
ability at any time to take the ticket back from the group it was escalated
to and turn it into an FCR in their name.

Also we have workflow in place that helps them track their FCRs. Such as if
they update the work log of a ticket, an FCR ticket is created and
automatically and resolved (there has been debate over validity/abuse of
this one in the past).  We also put in place quick tickets where they can
select a canned subject (like transferred call, wrong number, walk up, info
given) that will automatically fill in the Description, CTI, assign it to
them self and resolve the ticket.  We also have some of the support groups
using the quick tickets to track their volume of customer contacts.

Jason


On Thu, Mar 27, 2008 at 12:25 PM, T. Dee <[EMAIL PROTECTED]> wrote:

> When we arrived at our 40% we did an average over a couple of months.
> Every company is going to be different - some companies I know give
> their help desk alot of rights / authority, others give them nothing -
> so they really can't resolve much.
>
> Ty
>
>
> On 3/27/08, Jase Brandon <[EMAIL PROTECTED]> wrote:
> > **
> > Hi Kevin,
> > Same here as Tyrone, resolved in 1 hour and resolved by the person who
> > opened the ticket.
> > Same setup for FCR at the last two companies I worked for as well, for
> > whatever that's worth.
> >
> > Jase
> >
> >
> > On 3/27/08, T. Dee <[EMAIL PROTECTED]> wrote:
> > >
> > > We created our own FCR and I have a field set if the call is resolved
> > > within 1 hour and resolved by the individual who opened the ticket.
> > >
> > > On 3/27/08, Kevin Pulsen <[EMAIL PROTECTED]> wrote:
> > > > ** Hello all,
> > > >
> > > > I'm trying to find information on FCR (First Contact Resolution)
> > > > specifically for the Service Desk person.
> > > >
> > > > Is there a starting goal within ITIL regarding FCR?
> > > >
> > > > For example... the Service Desk needs to meet a 35% FCR goal.
> > > >
> > > > Or is this number subjective?
> > > >
> > > > If anyone is using FCR, could you please let me know your goal is
> and
> > what
> > > > factors you used to assess this goal.
> > > >
> > > > Thanks!
> > > >
> > > > Kevin P.
> > > >
> > > >
> > > >
> > > > 
> > > > Never miss a thing. Make Yahoo your homepage. __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"
> > >
> >
> > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
> > html___
>
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
>

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

Re: View Form not see a Key Field

[Joe D'Souza]

Try varchar2 instead of varchar..

Joe
  -Original Message-
  From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of Gary Dries
  Sent: Thursday, March 27, 2008 4:52 PM
  To: arslist@ARSLIST.ORG
  Subject: View Form not see a Key Field


  ** I am creating a couple of View forms to a SQL DB table from an Oracle
DB remedy system using a dblink.  Via the DB Link I am able to connect to
the table and load all the fields but I do not see a column in the key field
drop down of the create view dialog.

  In both tables the field I am wanting to use as the key is a 15 byte
varchar, Null not allowed, and it is not designated as a key in the SQL db.
On the first table the only column I see is a 4 byte int status field, and
on the second I do not see a column listed at all that table which only
contains varchars.

  any ideas

  Thanks
  G.

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

Re: View Forms

[Joe D'Souza]

Looks like you were trying to address a table across using a db link?

Joe
  -Original Message-
  From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of Kemes, Lisa
  Sent: Thursday, March 27, 2008 4:33 PM
  To: arslist@ARSLIST.ORG
  Subject: Re: View Forms


  **
  Thanks everyone!  I figured it out.  I had to put the @ symbol in the
table name field.   So it's:

  [EMAIL PROTECTED]

  Lisa






--
  From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Gary Dries
  Sent: Thursday, March 27, 2008 4:23 PM
  To: arslist@ARSLIST.ORG
  Subject: Re: View Forms


  ** I just ran into this exact problem today, the aradmin account had
access to the Database, but did not have proper access to the table I was
trying to build the view against.  Talk to your DBA and make sure that not
only can they see the table in the SQL Developer, but can access and view
the data in the table its self.

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

Re: arimportcmd error

[Joe D'Souza]

Try putting a 8.3 format DOS path in the path instead of the regular windows
path.. If all else as you say is correct, it may be not liking the long path
format if you have it set like that..

Joe
  -Original Message-
  From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of Rick Cook
  Sent: Thursday, March 27, 2008 4:51 PM
  To: arslist@ARSLIST.ORG
  Subject: arimportcmd error


  ** First, I can't believe that there are no Remedy KB entries for
arimportcmd.  None.  Wow.

  We are attempting to use arimportcmd in an Active Link to import a small
number of records into a form.  We have a mapping file that works just fine
in the Import Tool.  When we attempt to run it from the Active Link or the
command line, using the same user/pw and mapping file, we get an error that
says that the Import command line is missing the schema option or has a
wrong format.  There isn't even an arimportcmd parameter for the schema, so
I don't know what it's complaining about.

  Any ideas to help us out?  We verified the paths, file names, etc., and
all names match exactly, including case.

  Rick
No virus found in this outgoing message.
Checked by AVG.
Version: 7.5.519 / Virus Database: 269.22.1/1346 - Release Date: 3/27/2008
10:03 AM

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

Support for the _ wildcard in Run If qualifications

[Joe D'Souza]

Has anyone ever used the _ wildcard to represent a single character in the
Run If conditions of Filters, Active Links or Escalations?? Does it work?

Joe D'Souza
No virus found in this outgoing message.
Checked by AVG.
Version: 7.5.519 / Virus Database: 269.22.1/1346 - Release Date: 3/27/2008
10:03 AM

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

Re: Support for the _ wildcard in Run If qualifications

[Thad K Esser]

Yes and Yes.

(Most recently on ARS 6.3)

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



"Joe D'Souza" <[EMAIL PROTECTED]> 
Sent by: "Action Request System discussion list(ARSList)" 

03/27/2008 02:18 PM
Please respond to
arslist@ARSLIST.ORG


To
arslist@ARSLIST.ORG
cc

Subject
Support for the _ wildcard in Run If qualifications






** 
Has anyone ever used the _ wildcard to represent a single character in the 
Run If conditions of Filters, Active Links or Escalations?? Does it work?
 
Joe D'Souza
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" 
html___ 

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

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

Re: arimportcmd error

[Rick Cook]

Thanks, Joe.  It will take the long format as long as the string is in
quotes - it worked for me yesterday.  I'll keep that suggestion in my back
pocket, though, in case nothing else works.

Your response was much more helpful than the initial one from Support, which
was basically some script monkey in India saying RTFM.  Gee, I hadn't
thought of that.  If there was any troubleshooting data in the docs or the
KB, I wouldn't have needed to make a ticket.  sigh...

Rick

On Thu, Mar 27, 2008 at 2:12 PM, Joe D'Souza <[EMAIL PROTECTED]> wrote:

> ** Try putting a 8.3 format DOS path in the path instead of the regular
> windows path.. If all else as you say is correct, it may be not liking the
> long path format if you have it set like that..
>
> Joe
>
> -Original Message-
> *From:* Action Request System discussion list(ARSList) [mailto:
> [EMAIL PROTECTED] Behalf Of *Rick Cook
> *Sent:* Thursday, March 27, 2008 4:51 PM
> *To:* arslist@ARSLIST.ORG
> *Subject:* arimportcmd error
>
> ** First, I can't believe that there are no Remedy KB entries for
> arimportcmd.  None.  Wow.
>
> We are attempting to use arimportcmd in an Active Link to import a small
> number of records into a form.  We have a mapping file that works just fine
> in the Import Tool.  When we attempt to run it from the Active Link or the
> command line, using the same user/pw and mapping file, we get an error that
> says that the Import command line is missing the schema option or has a
> wrong format.  There isn't even an arimportcmd parameter for the schema, so
> I don't know what it's complaining about.
>
> Any ideas to help us out?  We verified the paths, file names, etc., and
> all names match exactly, including case.
>
> Rick
>
> __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 Forms

[Brian Goralczyk]

Lisa,

Yes, that is true.  However, I believe you can use select table_name from
user_tables@ name> and have it work.   But I am
not 100% on that one.

Brian

On Thu, Mar 27, 2008 at 3:10 PM, Kemes, Lisa <[EMAIL PROTECTED]>
wrote:

> ** Sorry, stupid question, when I use the query select table_name from
> user_tables order by 1, this will only give me the AR System database
> tables, not the ones that are on another oracle database.
>
>
> Lisa
>
>
>  --
>  *From:* Action Request System discussion list(ARSList) [mailto:
> [EMAIL PROTECTED] *On Behalf Of *Kemes, Lisa
> *Sent:* Thursday, March 27, 2008 4:05 PM
> *To:* arslist@ARSLIST.ORG
> *Subject:* Re: View Forms
>
>  ** Ok, I just did this and this table it not in the list.  How can I get
> this table in the list?  Is there a setting on preferences or something that
> I'm missing?
>
>
> Lisa
>
>
>  --
> *From:* Action Request System discussion list(ARSList) [mailto:
> [EMAIL PROTECTED] *On Behalf Of *Kemes, Lisa
> *Sent:* Thursday, March 27, 2008 3:59 PM
> *To:* arslist@ARSLIST.ORG
> *Subject:* Re: View Forms
>
> ** Thanks, I'm going to try thisEverything points to the fact that
> this should work.
>
> I'll let you know!
>
>
> Lisa
>
>
>  --
> *From:* Action Request System discussion list(ARSList) [mailto:
> [EMAIL PROTECTED] *On Behalf Of *Brian Goralczyk
> *Sent:* Thursday, March 27, 2008 3:51 PM
> *To:* arslist@ARSLIST.ORG
> *Subject:* Re: View Forms
>
> ** If you can log into the database as ARADMIN and see the tables then you
> should be able to create the Remedy view.  It would seem to me that you
> might just want to create a simple form that runs the query " u " so that
> you can see the list of tables (and any odd naming) that are available to
> the Remedy server.  Often times this is a simple way to make sure you get
> the name right.  If you run an active link with a set fields / sql command
> and make that your sql statement, you can then populate a field with the
> table name so that you can just cut and paste.
>
>
> On Thu, Mar 27, 2008 at 2:32 PM, Grooms, Frederick W <
> [EMAIL PROTECTED]> wrote:
>
> > ** If they are not owned by aradmin, are you including the owner name?
> >
> > Fred
> >
> >  --
> >  *From:* Action Request System discussion list(ARSList) [mailto:
> > [EMAIL PROTECTED] *On Behalf Of *Kemes, Lisa
> > *Sent:* Thursday, March 27, 2008 2:29 PM
> >
> > *To:* arslist@ARSLIST.ORG
> > *Subject:* Re: View Forms
> >
> >   ** These are not ARS tables.  Just plain old tables from an Oracle
> > database.  Our DBA was able to log into SQL developer with the aradmin
> > account and see these tables just fine.  For some reason, my admin tool must
> > not be using the aradmin account for view forms?  I'm connected to our ARS
> > database so it's working in that respect.
> >
> > These are not owned by aradmin either, but it is in the permission
> > group.
> >
> > 
> >
> >
> > Lisa
> >
> >
> >  --
> > *From:* Action Request System discussion list(ARSList) [mailto:
> > [EMAIL PROTECTED] *On Behalf Of *Brian Goralczyk
> > *Sent:* Thursday, March 27, 2008 1:44 PM
> > *To:* arslist@ARSLIST.ORG
> > *Subject:* Re: View Forms
> >
> > ** Not true.  She doesn't need the T table.  First off, if it isn't an
> > ARS table there might (probably won't) be a T table unless it was created
> > manually.  However, you can still use the view instead.  If it is a Remedy
> > created table, then the view name has a specific format.  All none
> > alphanumeric characters are replaced with an underscore.  Also, view names
> > in an Oracle (and I assume the others) database is only 30 characters long
> > if Remedy created the view.  So if your view (form) name is longer than 30
> > characters just drop the exceeding characters.  There is one other caveat in
> > case you have more than one view name that is the same until past the 30
> > character limit.  The last letter (number 30) is replaced by a sequential
> > number starting with the second form and incrementing for each form.  Check
> > out my examples but please don't name your forms as such or think that I
> > have mine named like this.
> >
> > Form Name: CTM:People Site AP:Administration Join
> > View Name: ctm_people_site_ap_administrat
> >
> > Form Name: CTM:People Site AP:Administration Role Join
> > View Name: ctm_people_site_ap_administra2
> >
> > Please only use this as an example.  I didn't verify my thoughts from
> > off the top of my head.
> >
> > Also, if you want the list of views just run this: select view_name from
> > user_views order by 1
> >
> > That will work in an Oracle db for sure.
> >
> > Also, I have not found a case sensitivity for form or field names when
> > writing SQL queries.
> >
> > HTH,
> >
> > Brian Goralczyk
> >
> > On Thu, Mar 27, 2008 at 11:27 AM, Drew Shuller <[EMAIL PROTECTED]> wrote:
> >
> > > Yes, if it's owned by aradmin, she'l

Re: Support for the _ wildcard in Run If qualifications

[Joe D'Souza]

Thanks Thad,

Never had the need to use a _ before so hadn't really got a chance to notice
if it would work or not..

Joe
  -Original Message-
  From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of Thad K Esser
  Sent: Thursday, March 27, 2008 5:21 PM
  To: arslist@ARSLIST.ORG
  Subject: Re: Support for the _ wildcard in Run If qualifications


  **
  Yes and Yes.

  (Most recently on ARS 6.3)

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


"Joe D'Souza" <[EMAIL PROTECTED]>
Sent by: "Action Request System discussion list(ARSList)"

03/27/2008 02:18 PM Please respond to
  arslist@ARSLIST.ORG


   To arslist@ARSLIST.ORG
  cc
  Subject Support for the _ wildcard in Run If qualifications







  **
  Has anyone ever used the _ wildcard to represent a single character in the
Run If conditions of Filters, Active Links or Escalations?? Does it work?

  Joe D'Souza

No virus found in this outgoing message.
Checked by AVG.
Version: 7.5.519 / Virus Database: 269.22.1/1346 - Release Date: 3/27/2008
10:03 AM

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

Re: arimportcmd error

[Joe D'Souza]

Could you let us know what the import command that you typed looks like? If
its complaining about the command, maybe there must be something in there
that is offending its syntax?

I've got feed like that from support ranging from have you read the manual
to you should go for training when I was working on the RKM product.. Almost
every other ticket I raised on RKM ended up being a software bug. So I'm
hardly likely to consider spending $$$'s for training myself on something
that is flaky in the first place! To add to that the documentation on that
product is far from 100% accurate.. Even the screen shots on some places are
inconsistent to what you actually see when you install the product (Version
7.1 patch 1 of RKM)..

Joe
  -Original Message-
  From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of Rick Cook
  Sent: Thursday, March 27, 2008 5:34 PM
  To: arslist@ARSLIST.ORG
  Subject: Re: arimportcmd error


  ** Thanks, Joe.  It will take the long format as long as the string is in
quotes - it worked for me yesterday.  I'll keep that suggestion in my back
pocket, though, in case nothing else works.

  Your response was much more helpful than the initial one from Support,
which was basically some script monkey in India saying RTFM.  Gee, I hadn't
thought of that.  If there was any troubleshooting data in the docs or the
KB, I wouldn't have needed to make a ticket.  sigh...

  Rick


  On Thu, Mar 27, 2008 at 2:12 PM, Joe D'Souza <[EMAIL PROTECTED]> wrote:

**
Try putting a 8.3 format DOS path in the path instead of the regular
windows path.. If all else as you say is correct, it may be not liking the
long path format if you have it set like that..

Joe
  -Original Message-
  From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of Rick Cook
  Sent: Thursday, March 27, 2008 4:51 PM
  To: arslist@ARSLIST.ORG
  Subject: arimportcmd error


  ** First, I can't believe that there are no Remedy KB entries for
arimportcmd.  None.  Wow.

  We are attempting to use arimportcmd in an Active Link to import a
small number of records into a form.  We have a mapping file that works just
fine in the Import Tool.  When we attempt to run it from the Active Link or
the command line, using the same user/pw and mapping file, we get an error
that says that the Import command line is missing the schema option or has a
wrong format.  There isn't even an arimportcmd parameter for the schema, so
I don't know what it's complaining about.

  Any ideas to help us out?  We verified the paths, file names, etc.,
and all names match exactly, including case.

  Rick
No virus found in this outgoing message.
Checked by AVG.
Version: 7.5.519 / Virus Database: 269.22.1/1346 - Release Date: 3/27/2008
10:03 AM

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

Re: arimportcmd error

[Rick Cook]

"C:\Program Files\AR System\Admin\arimportcmd.exe" -u user -p password -M
"C:\Mappings\Findings.arm" -l C:\Mappings\logfile.log

Rick

On Thu, Mar 27, 2008 at 3:40 PM, Joe D'Souza <[EMAIL PROTECTED]> wrote:

> ** Could you let us know what the import command that you typed looks
> like? If its complaining about the command, maybe there must be something in
> there that is offending its syntax?
>
> I've got feed like that from support ranging from have you read the manual
> to you should go for training when I was working on the RKM product.. Almost
> every other ticket I raised on RKM ended up being a software bug. So I'm
> hardly likely to consider spending $$$'s for training myself on something
> that is flaky in the first place! To add to that the documentation on that
> product is far from 100% accurate.. Even the screen shots on some places are
> inconsistent to what you actually see when you install the product (Version
> 7.1 patch 1 of RKM)..
>
> Joe
>
> -Original Message-
> *From:* Action Request System discussion list(ARSList) [mailto:
> [EMAIL PROTECTED] Behalf Of *Rick Cook
> *Sent:* Thursday, March 27, 2008 5:34 PM
> *To:* arslist@ARSLIST.ORG
> *Subject:* Re: arimportcmd error
>
> ** Thanks, Joe.  It will take the long format as long as the string is in
> quotes - it worked for me yesterday.  I'll keep that suggestion in my back
> pocket, though, in case nothing else works.
>
> Your response was much more helpful than the initial one from Support,
> which was basically some script monkey in India saying RTFM.  Gee, I hadn't
> thought of that.  If there was any troubleshooting data in the docs or the
> KB, I wouldn't have needed to make a ticket.  sigh...
>
> Rick
>
> On Thu, Mar 27, 2008 at 2:12 PM, Joe D'Souza <[EMAIL PROTECTED]> wrote:
>
> > ** Try putting a 8.3 format DOS path in the path instead of the regular
> > windows path.. If all else as you say is correct, it may be not liking the
> > long path format if you have it set like that..
> >
> > Joe
> >
> > -Original Message-
> > *From:* Action Request System discussion list(ARSList) [mailto:
> > [EMAIL PROTECTED] Behalf Of *Rick Cook
> > *Sent:* Thursday, March 27, 2008 4:51 PM
> > *To:* arslist@ARSLIST.ORG
> > *Subject:* arimportcmd error
> >
> > ** First, I can't believe that there are no Remedy KB entries for
> > arimportcmd.  None.  Wow.
> >
> > We are attempting to use arimportcmd in an Active Link to import a small
> > number of records into a form.  We have a mapping file that works just fine
> > in the Import Tool.  When we attempt to run it from the Active Link or the
> > command line, using the same user/pw and mapping file, we get an error that
> > says that the Import command line is missing the schema option or has a
> > wrong format.  There isn't even an arimportcmd parameter for the schema, so
> > I don't know what it's complaining about.
> >
> > Any ideas to help us out?  We verified the paths, file names, etc., and
> > all names match exactly, including case.
> >
> > Rick
> >
> > __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: arimportcmd error

[Rick Cook]

Also tried this:

"C:\Program Files\AR System\Admin\arimportcmd" -u user -p password -M
C:\Mappings\Findings.arm -l C:\Mappings\logfile.log

Same error.

Rick

On Thu, Mar 27, 2008 at 3:45 PM, Rick Cook <[EMAIL PROTECTED]> wrote:

> "C:\Program Files\AR System\Admin\arimportcmd.exe" -u user -p password -M
> "C:\Mappings\Findings.arm" -l C:\Mappings\logfile.log
>
> Rick
>
>
> On Thu, Mar 27, 2008 at 3:40 PM, Joe D'Souza <[EMAIL PROTECTED]> wrote:
>
> > ** Could you let us know what the import command that you typed looks
> > like? If its complaining about the command, maybe there must be something in
> > there that is offending its syntax?
> >
> > I've got feed like that from support ranging from have you read the
> > manual to you should go for training when I was working on the RKM product..
> > Almost every other ticket I raised on RKM ended up being a software bug. So
> > I'm hardly likely to consider spending $$$'s for training myself on
> > something that is flaky in the first place! To add to that the documentation
> > on that product is far from 100% accurate.. Even the screen shots on some
> > places are inconsistent to what you actually see when you install the
> > product (Version 7.1 patch 1 of RKM)..
> >
> > Joe
> >
> > -Original Message-
> > *From:* Action Request System discussion list(ARSList) [mailto:
> > [EMAIL PROTECTED] Behalf Of *Rick Cook
> > *Sent:* Thursday, March 27, 2008 5:34 PM
> > *To:* arslist@ARSLIST.ORG
> > *Subject:* Re: arimportcmd error
> >
> > ** Thanks, Joe.  It will take the long format as long as the string is
> > in quotes - it worked for me yesterday.  I'll keep that suggestion in my
> > back pocket, though, in case nothing else works.
> >
> > Your response was much more helpful than the initial one from Support,
> > which was basically some script monkey in India saying RTFM.  Gee, I hadn't
> > thought of that.  If there was any troubleshooting data in the docs or the
> > KB, I wouldn't have needed to make a ticket.  sigh...
> >
> > Rick
> >
> > On Thu, Mar 27, 2008 at 2:12 PM, Joe D'Souza <[EMAIL PROTECTED]> wrote:
> >
> > > ** Try putting a 8.3 format DOS path in the path instead of the
> > > regular windows path.. If all else as you say is correct, it may be not
> > > liking the long path format if you have it set like that..
> > >
> > > Joe
> > >
> > > -Original Message-
> > > *From:* Action Request System discussion list(ARSList) [mailto:
> > > [EMAIL PROTECTED] Behalf Of *Rick Cook
> > > *Sent:* Thursday, March 27, 2008 4:51 PM
> > > *To:* arslist@ARSLIST.ORG
> > > *Subject:* arimportcmd error
> > >
> > > ** First, I can't believe that there are no Remedy KB entries for
> > > arimportcmd.  None.  Wow.
> > >
> > > We are attempting to use arimportcmd in an Active Link to import a
> > > small number of records into a form.  We have a mapping file that works 
> > > just
> > > fine in the Import Tool.  When we attempt to run it from the Active Link 
> > > or
> > > the command line, using the same user/pw and mapping file, we get an error
> > > that says that the Import command line is missing the schema option or 
> > > has a
> > > wrong format.  There isn't even an arimportcmd parameter for the schema, 
> > > so
> > > I don't know what it's complaining about.
> > >
> > > Any ideas to help us out?  We verified the paths, file names, etc.,
> > > and all names match exactly, including case.
> > >
> > > Rick
> > >
> > > __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"

Need help with EMail Attachments...

[Payne, George]

ENV:

 

ARS 7.0.01 P05

AIX 5.3

ITSM 7.0.01 P05

ORACLE 10g also on AIX

 

Ok...this is kind of the turn around to all the problems that we used to
have trying to send attachments successfully with previous versions of
the ARS!

 

We chose to disable the Notification Engine configurations for Incident
Management in favor of a nice set of NOTIFY FILTERS that use a set of
email TEMPLATES.

 

The trouble is, the Notification Engine Filters are still pushing the
WorkLog attachments into the AR System Email Association even when I
don't want them to!

 

I've tried leaving the Attachment out of the list of fields that are
being sent.  I've tried setting the Attachment field to not be PUBLIC so
that it shouldn't be sent with email.  The Attachment field is NOT a
part of the email template.

 

Here's the truly whacky thing about it to mein the Incident
Management system, they've gone to a lot of trouble to allow us to mark
a WorkLog entry was PUBLIC or INTERNAL and the default is "Internal"...

 

So why does it insist on popping out the ATTACHMENT with the email???
If it's supposed to be "Internal" it shouldn't go out on the email to
the customer.

 

Has anyone run into anything like this?  I'd rather not send out any
attachments (at this point in time) than take the chance that I'll send
the wrong thing to someone...

 

Thanks in advance,
Gp

 

George Payne

Corporate Applications Developer

Electric Reliability Council of Texas

(512) 248-3940

[EMAIL PROTECTED]

 


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

Re: arimportcmd error

[Shafqat Ayaz]

Hi Rick
  i maybe barking up the wrong tree altogether, but I have got a suspicion that 
your  arimportcmd and the version of ARS are not the same.
  have you tried being in the directory that arimport.exe resides in and 
running the command? so go  to the c:program files\arsystem\admin  directory 
and try running the  command from a DOS box, does that work properly? is so 
then there is a problem with your mapping file, try the command without a 
mapping file, you will need an arx or xml file for that, but it will at  least 
tell you if  there is a problem with the command itself or the format.
  let me know if you can
  generally if you have the command and associated files and the  mapping file  
with the import  file in the same directory and you run the  import command 
from there, it  should work
   
  thanks
   
  shafqat

Rick Cook <[EMAIL PROTECTED]> wrote:
  ** Also tried this:

"C:\Program Files\AR System\Admin\arimportcmd" -u user -p password -M 
C:\Mappings\Findings.arm -l C:\Mappings\logfile.log

Same error.

Rick

  On Thu, Mar 27, 2008 at 3:45 PM, Rick Cook <[EMAIL PROTECTED]> wrote:
  "C:\Program Files\AR System\Admin\arimportcmd.exe" -u user -p password -M 
"C:\Mappings\Findings.arm" -l C:\Mappings\logfile.log

Rick
  

  On Thu, Mar 27, 2008 at 3:40 PM, Joe D'Souza <[EMAIL PROTECTED]> wrote:
  ** Could you let us know what the import command that you typed looks 
like? If its complaining about the command, maybe there must be something in 
there that is offending its syntax?
   
  I've got feed like that from support ranging from have you read the manual to 
you should go for training when I was working on the RKM product.. Almost every 
other ticket I raised on RKM ended up being a software bug. So I'm hardly 
likely to consider spending $$$'s for training myself on something that is 
flaky in the first place! To add to that the documentation on that product is 
far from 100% accurate.. Even the screen shots on some places are inconsistent 
to what you actually see when you install the product (Version 7.1 patch 1 of 
RKM)..
   
  Joe
  -Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
Behalf Of Rick Cook

  Sent: Thursday, March 27, 2008 5:34 PM
To: arslist@ARSLIST.ORG

Subject: Re: arimportcmd error



  ** Thanks, Joe.  It will take the long format as long as the string is in 
quotes - it worked for me yesterday.  I'll keep that suggestion in my back 
pocket, though, in case nothing else works.

Your response was much more helpful than the initial one from Support, which 
was basically some script monkey in India saying RTFM.  Gee, I hadn't thought 
of that.  If there was any troubleshooting data in the docs or the KB, I 
wouldn't have needed to make a ticket.  sigh...

Rick

  On Thu, Mar 27, 2008 at 2:12 PM, Joe D'Souza <[EMAIL PROTECTED]> wrote:
  ** Try putting a 8.3 format DOS path in the path instead of the regular 
windows path.. If all else as you say is correct, it may be not liking the long 
path format if you have it set like that..
   
  Joe

  -Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
Behalf Of Rick Cook
Sent: Thursday, March 27, 2008 4:51 PM
To: arslist@ARSLIST.ORG
Subject: arimportcmd error


** First, I can't believe that there are no Remedy KB entries for arimportcmd.  
None.  Wow.

We are attempting to use arimportcmd in an Active Link to import a small number 
of records into a form.  We have a mapping file that works just fine in the 
Import Tool.  When we attempt to run it from the Active Link or the command 
line, using the same user/pw and mapping file, we get an error that says that 
the Import command line is missing the schema option or has a wrong format.  
There isn't even an arimportcmd parameter for the schema, so I don't know what 
it's complaining about.

Any ideas to help us out?  We verified the paths, file names, etc., and all 
names match exactly, including case.

Rick







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







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


Shafqat Ayaz

  "Break the Rules, Forgive Quickly, Kiss Slowly, Love Truly, Laugh 
Uncontrollably, And Never Regret anything that made you Smile.." 







   
-
Be a better friend, newshound, and know-it-all with Yahoo! Mobile.  Try it now.

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

Re: Remedy WUT & Crystal Reports (U)

[Shafqat Ayaz]

silly  suggestion and you probably have tried it, but have you  tried giving 
him local admin and then trying??
   
  thanks
   
  shafqat

Susan Palmer <[EMAIL PROTECTED]> wrote:
  **   I suggest rebuilding the workstation.  Obviously there's something 
conflicting on it and how much time do you spend trying to find it.  There's 
nothing you are  going to be  able to do about it not working.
   
  Good luck ...
  Susan


  On Thu, Mar 27, 2008 at 7:54 AM, Hennigan, Sandra H CTR OSD-CIO <[EMAIL 
PROTECTED]> wrote:
  UNCLASSIFIED

Yes - it is the workstation not his Remedy account or install but it is
only his workstation.

Sandra Hennigan

OSD Enterprise Remedy Administrator
Office # 703-602-2525 x248
  
Apparently, there is nothing that cannot happen today.  Mark Twain



  -Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Susan Palmer
Sent: Wednesday, March 26, 2008 5:38 PM
To: arslist@ARSLIST.ORG
Subject: Re: Remedy WUT & Crystal Reports (U)


** Does it work for him when he's on a different PC?


On Wed, Mar 26, 2008 at 4:23 PM, Hennigan, Sandra H CTR OSD-CIO
<[EMAIL PROTECTED]> wrote:


   UNCLASSIFIED

   Application-
   Windows 2003 server
   SQL 2000
   ARS 6.3 patch 21
   Help Desk 5.5

   Crystal Report reports running on ARS are in version 8.5

   User-
   Windows XP (not sure the SP level)
   Remedy WUT 6.3 patch 20

   All Remedy users can open, print, export the Crystal Report
reports that
   run from Active Links to any of the Destinations displayed
   Except ONE user
   Out of over 400

   This one user cannot send, in any format, a Crystal Report to Disk
File
   He can export to Destination Application or MAPI without error

   He receives the dialog to Export, can select the format, can
select the
   Destination.
   He can select Disk file.  When he clicks OK - nothing.  No error;
no
   action.

   I have completely removed the Remedy install; rebooted.
   Cleaned the registry.
   Installed Remedy to different locales.
   Given him local admin permissions.
   Installed Crystal Reports
   Configured ODBC drivers

   Removed everything and started again.
   Had other admin perform the same drill

   Printing works OK
   Crystal Reports works OK; he can export the report to Crystal
Reports
   and open the report
   Adobe works OK; he can export the report to Adobe and open the
report

   This one user cannot send, in any format, a Crystal Report to Disk
File
   from Remedy.

   Any ideas?

   Sandra Hennigan
   Enterprise Remedy Administrator

   Apparently, there is nothing that cannot happen today.  Mark Twain


__
_
   UNSUBSCRIBE or access ARSlist Archives at www.arslist.org



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




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




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


Shafqat Ayaz

  "Break the Rules, Forgive Quickly, Kiss Slowly, Love Truly, Laugh 
Uncontrollably, And Never Regret anything that made you Smile.." 







   
-
Looking for last minute shopping deals?  Find them fast with Yahoo! Search.

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

Re: arimportcmd error

[Rick Cook]

Well, I'm not sure which tree we need to bark up.  The command does not work
either in workflow or on the command line.  I'll check the version tomorrow,
but I had the same error last week and I KNOW the versions were the same,
down to the patch.  Wish I could remember what I did to resolve it last
week.

 

The only thing of which I am 100% sure is that the mapping file is good.

 

Rick

  _  

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Shafqat Ayaz
Sent: Thursday, March 27, 2008 9:17 PM
To: arslist@ARSLIST.ORG
Subject: Re: arimportcmd error

 

** 

Hi Rick

i maybe barking up the wrong tree altogether, but I have got a suspicion
that your  arimportcmd and the version of ARS are not the same.

have you tried being in the directory that arimport.exe resides in and
running the command? so go  to the c:program files\arsystem\admin  directory
and try running the  command from a DOS box, does that work properly? is so
then there is a problem with your mapping file, try the command without a
mapping file, you will need an arx or xml file for that, but it will at
least tell you if  there is a problem with the command itself or the format.

let me know if you can

generally if you have the command and associated files and the  mapping file
with the import  file in the same directory and you run the  import command
from there, it  should work

 

thanks

 

shafqat

Rick Cook <[EMAIL PROTECTED]> wrote:

** Also tried this:

"C:\Program Files\AR System\Admin\arimportcmd" -u user -p password -M
C:\Mappings\Findings.arm -l C:\Mappings\logfile.log

Same error.

Rick

On Thu, Mar 27, 2008 at 3:45 PM, Rick Cook <[EMAIL PROTECTED]> wrote:

"C:\Program Files\AR System\Admin\arimportcmd.exe" -u user -p password -M
"C:\Mappings\Findings.arm" -l C:\Mappings\logfile.log

Rick 

 

On Thu, Mar 27, 2008 at 3:40 PM, Joe D'Souza <[EMAIL PROTECTED]> wrote:

** 

Could you let us know what the import command that you typed looks like? If
its complaining about the command, maybe there must be something in there
that is offending its syntax?

 

I've got feed like that from support ranging from have you read the manual
to you should go for training when I was working on the RKM product.. Almost
every other ticket I raised on RKM ended up being a software bug. So I'm
hardly likely to consider spending $$$'s for training myself on something
that is flaky in the first place! To add to that the documentation on that
product is far from 100% accurate.. Even the screen shots on some places are
inconsistent to what you actually see when you install the product (Version
7.1 patch 1 of RKM)..

 

Joe

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of Rick Cook

Sent: Thursday, March 27, 2008 5:34 PM
To: arslist@ARSLIST.ORG

Subject: Re: arimportcmd error

** Thanks, Joe.  It will take the long format as long as the string is in
quotes - it worked for me yesterday.  I'll keep that suggestion in my back
pocket, though, in case nothing else works.

Your response was much more helpful than the initial one from Support, which
was basically some script monkey in India saying RTFM.  Gee, I hadn't
thought of that.  If there was any troubleshooting data in the docs or the
KB, I wouldn't have needed to make a ticket.  sigh...

Rick

On Thu, Mar 27, 2008 at 2:12 PM, Joe D'Souza <[EMAIL PROTECTED]> wrote:

** 

Try putting a 8.3 format DOS path in the path instead of the regular windows
path.. If all else as you say is correct, it may be not liking the long path
format if you have it set like that..

 

Joe

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of Rick Cook
Sent: Thursday, March 27, 2008 4:51 PM
To: arslist@ARSLIST.ORG
Subject: arimportcmd error

** First, I can't believe that there are no Remedy KB entries for
arimportcmd.  None.  Wow.

We are attempting to use arimportcmd in an Active Link to import a small
number of records into a form.  We have a mapping file that works just fine
in the Import Tool.  When we attempt to run it from the Active Link or the
command line, using the same user/pw and mapping file, we get an error that
says that the Import command line is missing the schema option or has a
wrong format.  There isn't even an arimportcmd parameter for the schema, so
I don't know what it's complaining about.

Any ideas to help us out?  We verified the paths, file names, etc., and all
names match exactly, including case.

Rick

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

 


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





Shafqat Ayaz

"Break the Rules, Forgive Quickly, Kiss Slowly, Love Truly, Laugh
Uncontrollably, And Never Regret anything that made you Smile.." 

  

  _  

Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try

Re: arimportcmd error

[Shafqat Ayaz]

Rick
  i presume that the error you are getting is in the error log, what kind of 
error do you get from the command line when you type the command in?
   
  thanks
  shafqat

Rick Cook <[EMAIL PROTECTED]> wrote:
  **   v\:* {behavior:url(#default#VML);}  o\:* 
{behavior:url(#default#VML);}  w\:* {behavior:url(#default#VML);}  .shape 
{behavior:url(#default#VML);}st1\:*{behavior:url(#default#ieooui) } 
   Well, I’m not sure which tree we need to bark up.  The command does 
not work either in workflow or on the command line.  I’ll check the version 
tomorrow, but I had the same error last week and I KNOW the versions were the 
same, down to the patch.  Wish I could remember what I did to resolve it last 
week.
   
  The only thing of which I am 100% sure is that the mapping file is good.
   
  Rick
  
-
  
  From: Action Request System discussion list(ARSList) [mailto:[EMAIL 
PROTECTED] On Behalf Of Shafqat Ayaz
Sent: Thursday, March 27, 2008 9:17 PM
To: arslist@ARSLIST.ORG
Subject: Re: arimportcmd error

   
  ** 
Hi Rick

i maybe barking up the wrong tree altogether, but I have got a suspicion 
that your  arimportcmd and the version of ARS are not the same.

have you tried being in the directory that arimport.exe resides in and 
running the command? so go  to the c:program files\arsystem\admin  directory 
and try running the  command from a DOS box, does that work properly? is so 
then there is a problem with your mapping file, try the command without a 
mapping file, you will need an arx or xml file for that, but it will at  least 
tell you if  there is a problem with the command itself or the format.

let me know if you can

generally if you have the command and associated files and the  mapping 
file  with the import  file in the same directory and you run the  import 
command from there, it  should work

 

thanks

 

shafqat

Rick Cook <[EMAIL PROTECTED]> wrote:

** Also tried this:

"C:\Program Files\AR System\Admin\arimportcmd" -u user -p password -M 
C:\Mappings\Findings.arm -l C:\Mappings\logfile.log

Same error.

Rick
On Thu, Mar 27, 2008 at 3:45 PM, Rick Cook <[EMAIL PROTECTED]> wrote:
  "C:\Program Files\AR System\Admin\arimportcmd.exe" -u user -p password -M 
"C:\Mappings\Findings.arm" -l C:\Mappings\logfile.log

Rick 
   
On Thu, Mar 27, 2008 at 3:40 PM, Joe D'Souza <[EMAIL PROTECTED]> wrote:
  ** 
  Could you let us know what the import command that you typed looks like? 
If its complaining about the command, maybe there must be something in there 
that is offending its syntax?

 

I've got feed like that from support ranging from have you read the manual 
to you should go for training when I was working on the RKM product.. Almost 
every other ticket I raised on RKM ended up being a software bug. So I'm hardly 
likely to consider spending $$$'s for training myself on something that is 
flaky in the first place! To add to that the documentation on that product is 
far from 100% accurate.. Even the screen shots on some places are inconsistent 
to what you actually see when you install the product (Version 7.1 patch 1 of 
RKM)..

 

Joe

  -Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
Behalf Of Rick Cook

Sent: Thursday, March 27, 2008 5:34 PM
To: arslist@ARSLIST.ORG

  Subject: Re: arimportcmd error
  ** Thanks, Joe.  It will take the long format as long as the string is in 
quotes - it worked for me yesterday.  I'll keep that suggestion in my back 
pocket, though, in case nothing else works.

Your response was much more helpful than the initial one from Support, which 
was basically some script monkey in India saying RTFM.  Gee, I hadn't thought 
of that.  If there was any troubleshooting data in the docs or the KB, I 
wouldn't have needed to make a ticket.  sigh...

Rick
On Thu, Mar 27, 2008 at 2:12 PM, Joe D'Souza <[EMAIL PROTECTED]> wrote:
  ** 
  Try putting a 8.3 format DOS path in the path instead of the regular 
windows path.. If all else as you say is correct, it may be not liking the long 
path format if you have it set like that..

 

Joe

-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
Behalf Of Rick Cook
Sent: Thursday, March 27, 2008 4:51 PM
To: arslist@ARSLIST.ORG
Subject: arimportcmd error
  ** First, I can't believe that there are no Remedy KB entries for 
arimportcmd.  None.  Wow.

We are attempting to use arimportcmd in an Active Link to import a small number 
of records into a form.  We have a mapping file that works just fine in the 
Import Tool.  When we attempt to run it from the Active Link or the command 
line, using the same user/pw and mapping file, we get an error that says that 
the Import command line is missing the schema option or has a wrong format.  
There isn't even an arimp

Re: Question: SYS:Notification Messages - Missing ?

[Saravanan Palaniappan]

This exist in the sys: notification messages.

Thanks & Regards
Saravanan Palaniappan
ITSM
 

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

 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of T. Dee
Sent: Thursday, March 27, 2008 10:20 PM
To: arslist@ARSLIST.ORG
Subject: Question: SYS:Notification Messages - Missing ?

I have two Notifications - the Notification Message Tags are:

CHG-APR-GroupApprovalOLAResolutionEscalation
CHG-APR-IndividualApprovalOLAResolutionEscalation

I have exported ALL Filters and I am unable to reference any Filter to
these two Notifications.

Do these even exist?

Thanks!


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

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

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