VMWare in a Windows Server/SQL Environment

2007-07-16 Thread zebratta

Has created a VMWare development or staging environment in this configuration
for ARServer 7.0.1 and ITSM?  Are there any problems you have encountered with
this configuration?

Regards,

Louise van Hine
KTSL Limited
[EMAIL PROTECTED]

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


Re: License Usage

2007-07-16 Thread zebratta

Frank,

As long as they are submits then this should be within the licensing 
model.  the

web user (read license) submitting a new event record creates the record in an
'allow any user to submit' -permitted form , and this notifies users with
change licenses, and when the licensed user makes an update it creates 
a modify
to a record, that would conform to the model.  In my opinion. 


Regards,

Louise van Hine
KTSL Limited
[EMAIL PROTECTED]

Quoting Frank Caruso <[EMAIL PROTECTED]>:

** OK ... new scenario. 
If the Remedy login being used from the web site creates an "event

type" record in Remedy. Then, an alert fires to a user (or group of
users) letting them know that there is updated information for a
particular ticket. The end users will then, for example, double click
a record (push a button) which will push the updated information to
the ticket. 
In then end, the Web user is only submitting records and it will be

up to an actual logged in Remedy user to push the updates to the
ticket. 
Would this be acceptable license usage?


 On 6/29/07, PAYNE, GEORGE  wrote: The funny thing is that a
respected Remedy Trainer (who will remain
un-named) brought up a very similar question in a class he was
teaching
on Application Design in the spring of 2006.  My solution was to
submit
a ticket to a child and then update the parent with workflow and he
assured me that this would be 100% legal based on the current
licensing
scheme. 
Hmmm...maybe he was wrong, but I understand that he employed this

technique in a recent mid-west installation with a very large
customer
who was looking to circumnavigate the enormous licensing fees that
they
were amassing. 
Gp

George Payne
Assistant Director, User Services
Information Technology Services
University of Texas at Austin
512.232.7513
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:mailto:[EMAIL PROTECTED] On Behalf
Ofmailto:[EMAIL PROTECTED]
Sent: Friday, June 29, 2007 10:29 AM
To:mailto:arslist@ARSLIST.ORG
Subject: Re: License Usage
I would also agree that it has been a longstanding license violation. 
Since the

early days of 4.x at least, the 'read' license was limited to
submission of new
records and querying, and modification of records required a change
license. 
When RemedyWeb came out it was possible to make updates to the

display
only Web
form that would trigger a filter that would make background database
updates by
the Web user, but doing such an update was specifically not permitted

due to the
clause above.  Any other method, including a single user being used
by
multiple
workstations, is also such a licensing violation. 
Louise van Hine

KTSL Limited
Quoting "L. J. Head" :

**  My understanding is that it would be a violation based on

the

'no group user accounts' policy...I've never read the

agreement
myself but understand it as such. 


-
 FROM: Action Request System discussion list(ARSList)
[mailto:mailto:arslist@ARSLIST.ORG ] ON BEHALF OF Frank Caruso
SENT: Friday, June 29, 2007 8:58 AM
TO:mailto:arslist@ARSLIST.ORG
SUBJECT: License Usage

 ** Looking for feedback on whether the following set up would
violate a license agreement with BMC:
Putting up web sites (not MidTier) where end users can submit and
update records but the web site authenticates with the ARS server
using one ID. 
This ID has been granted a Fixed license and each site will have a

unique Remedy ID attached to it. Also, it is possible that many of
the users submitting and updating tickets through these web sites
will have a Remedy login with a Floating license, however, the web
sites will not use that ID to authenticate. 
I believe that this would be a violation but cannot find anything
written from BMC that states it would. 
Thank you


__20060125___This posting was submitted with

HTML

in it___  __20060125___This posting was

submitted

with HTML in it___


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

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

http://www.specificintegration.com
703-376-1249 __20060125___This posting was
submitted with HTML in it___


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


OT: Validate XML in SQL Server 2000

2007-07-16 Thread Heider, Stephen
This is a SQL Server 2000 question yet will be used directly with
Remedy.

What I want to do is pass an XML document into a stored procedure.
Before I use the XML I need to validate it. The built-in module
sp_xml_preparedocument is supposed to perform this validation.  However,
if for any reason the document is not considered well formed the stored
procedure aborts with no way of trapping the error.

In SQL Server 2000 extended procedures can be created using C++ but I do
not yet program in this language.  With SQL Server 2005 this is not an
issue because I can write a .Net stored procedure and use TRY/CATCH.

The only way I can see to accomplish this is to write a .Net .exe file
and shell out.  For performance reasons I would rather not have to run
an executable from within a stored procedure.
 
Does anyone have a solution for validating an XML document within a SQL
2000 stored procedure?
 
Thanks.

Stephen 

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


Re: Mid-tier Issue

2007-07-16 Thread Rami S Ayoub
**

Hi Sam,

 

Issue is resolved I have modified the following

 

1-   I have added the path in the environment for the Java

2-   From mid-tier configuration I have added the application password

Restart the IIS; everything is working fine right now.

 

Thanks List,

Rami

 



From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Sam Rx
Sent: Monday, July 16, 2007 7:16 AM
To: arslist@ARSLIST.ORG
Subject: Re: Mid-tier Issue

 

** 

it seems that its not finding arapi63.jar/arapi70.jar. ProxyPool class is part 
of this jar.

Please check environment variable and make sure that this jar file is available 
to mid tier/servlet engine.

 

Thanks

-sam



 

On 7/15/07, Rami S Ayoub <[EMAIL PROTECTED]  > wrote: 

** 

***

Hi list , 

 

I got this error when trying to connect to the web 

 

AR 7.

Mid-tier 7.0.00 Patch 001

 

 

Error. The server encountered an unexpected condition which prevented it from 
fulfilling the request.


java.lang.NoClassDefFoundError
 at com.remedy.arsys.api.ProxyPool.get(ProxyPool.java:62)
 at com.remedy.arsys.api.PoolingProxyManager.getProxy(PoolingProxyManager.java 
:66)
 at com.remedy.arsys.api.Util.ARSetSessionConfiguration(Util.java:181)
 at com.remedy.arsys.session.LoginServlet.authenticate(Unknown Source)
 at com.remedy.arsys.session.LoginServlet.doLogin(Unknown Source) 
 at com.remedy.arsys.session.LoginServlet.doThePost(Unknown Source)
 at com.remedy.arsys.session.LoginServlet.doThePost(Unknown Source)
 at com.remedy.arsys.session.LoginServlet.doRequest(Unknown Source)
 at com.remedy.arsys.stubs.GoatHttpServlet.postInternal(Unknown Source)
 at com.remedy.arsys.stubs.GoatHttpServlet.doPost(Unknown Source)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
 at javax.servlet.http.HttpServlet.service (HttpServlet.java:856)
 at 
com.newatlanta.servletexec.SERequestDispatcher.forwardServlet(SERequestDispatcher.java:638)
 at 
com.newatlanta.servletexec.SERequestDispatcher.forward(SERequestDispatcher.java:236)
 at 
com.newatlanta.servletexec.SERequestDispatcher.internalForward(SERequestDispatcher.java:283)
 at 
com.newatlanta.servletexec.ApplicationInfo.processApplRequest(ApplicationInfo.java:1846)
 at com.newatlanta.servletexec.ServerHostInfo.processApplRequest 
(ServerHostInfo.java:937)
 at com.newatlanta.servletexec.ServletExec.ProcessRequest(ServletExec.java:1091)
 at com.newatlanta.servletexec.ServletExec.ProcessRequest(ServletExec.java:1002)

__20060125___This posting was submitted with HTML in it___ 


__20060125___This posting was submitted with HTML in it___ 


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


Reset Incident Number ID

2007-07-16 Thread Rami S Ayoub
**

Hi List, 

 

How can I Reset the IN Number to start from IN01., i already have 
old cases and i want now start from number 1 ?

 

AR Server 7

SQL 2005

Incident and Problem 

Windows 2003

 

Regards,

Rami


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


Help on Search Menu

2007-07-16 Thread Ravikumar_Tadi
Hello Listers,
 
Need help from you on the following - 
 
For a search menu related to the field Category, I have modified the following 
Qualification by adding the BOLDED VALUE - 
 
( 'Status-CAT' = "Enabled") AND ( 'Status-CTA' = "Enabled") AND  'Company' 
= $11$) OR ( 'Company' =  "- Global -" )) AND ($11$ !=  $NULL$ 
)) OR ($11$ =  " " )) AND ((($100099$ = "User Service Request") AND 
( 'Request Selection' = "Yes")) OR (($100099$ = "User Service Restoration") 
AND ( 'Service Restoration Selection' = "Yes")) OR (($100099$ = 
"Infrastructure Restoration") AND ( 'Infra Restoration Selection' = "Yes")) OR 
(($100099$ = "Infrastructure Event") AND ( 'Infra Event Selection' = 
"Yes")) OR (($100099$ = "Standard Provisioning") AND ( 
'ML_Standard_Provisioning' = "Yes")) OR (($100099$ = "Request For 
Information") AND ('ML_Request_For_Information' = "Yes")) OR (($100099$ =  
$NULL$ ) AND ( 'Help Desk Selection' = "Yes"))).
 
When I login to the AR Server and try to select Category in the Incidents form 
I get ARERR 313 Data types not appropriate for the relational operation. 
 
I have not modified datatype for any field.
 
Not sure why I receive this error. 
 
Please help me in fixing this issue.
 
 
  Regards,
Ravi Kumar T


 
 
 

 


DISCLAIMER:
This email (including any attachments) is intended for the sole use of the 
intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE 
COMPANY INFORMATION. Any review or reliance by others or copying or 
distribution or forwarding of any or all of the contents in this message is 
STRICTLY PROHIBITED. If you are not the intended recipient, please contact the 
sender by email and delete all copies; your cooperation in this regard is 
appreciated.

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


Re: VMWare in a Windows Server/SQL Environment

2007-07-16 Thread Troy Sasso
I've seen speed issues with servers using anything
less than 8GB RAM.  

Also, do not try to get fancy with performance
enhancing drivers for VMWare, they caused issues with
the Windows performance.


--- [EMAIL PROTECTED] wrote:

> Has created a VMWare development or staging
> environment in this configuration
> for ARServer 7.0.1 and ITSM?  Are there any problems
> you have encountered with
> this configuration?
> 
> Regards,
> 
> Louise van Hine
> KTSL Limited
> [EMAIL PROTECTED]
> 
>
___
> UNSUBSCRIBE or access ARSlist Archives at
> www.arslist.org ARSlist:"Where the Answers Are"
> 





 

TV dinner still cooling? 
Check out "Tonight's Picks" on Yahoo! TV.
http://tv.yahoo.com/

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


Re: Transaction log is full.

2007-07-16 Thread Troy Sasso
Could the EIE memory leak be contributing to your
oversized transaction log issue?

Just thought I'd give you something to look in to.  I
think the EIE memory leak still exists to some extent
in Patch 4 and 5.



--- DJHuang <[EMAIL PROTECTED]> wrote:

> Carter,
> 
>   I do agree with you that there should be a regular
> database maintenance
> plan in place.
>   As the system keep updating and customizing, DBA
> didn't put our ARS DB
> into the regular maintenance process.
>   But now the DB issue has been taken care of.
>   Thanks.
> 
> DJHuang
> 
> 2007/7/12, Carter, Craig J Civ ARPC/DPD
> <[EMAIL PROTECTED]>:
> >
> > **
> >
> > A transaction log is a log of transactions¡Xit
> will continue to grow over
> > time until it is backup up/truncated.
> >
> >
> >
> > You need to set up a database maintenance plan to
> regularly backup your
> > database (includes the log file).  Otherwise, it
> will continue to grow over
> > time until you run out of disk space.  It's
> surprising to hear people are
> > not performing regular SQL backups.  We have
> hourly transaction log backups
> > that run during core work hours along with full
> database backups daily.
> > We've used these several times to recover data
> that was accidentally
> > deleted, etc.
> >
> >
> >
> > There is an option to remove free space when
> defining the maintenance
> > plan.  When doing a complete backup under normal
> conditions, you shouldn't
> > need the extra truncate command.  It is handy when
> running large data
> > imports, etc.
> >
> >
> >
> > CRAIG CARTER
> >
> > Remedy Skilled Professional
> >
> >
> >
> >
> >
> > *From:* Action Request System discussion
> list(ARSList) [mailto:
> > [EMAIL PROTECTED] *On Behalf Of *DJHuang
> > *Sent:* Thursday, July 12, 2007 8:49 AM
> > *To:* arslist@ARSLIST.ORG
> > *Subject:* Re: Transaction log is full.
> >
> >
> >
> > ** Hi,
> >
> >Regarding to this transaction log full issue,
> it is not how you
> > truncate the transaction log file but how the
> transaction log file
> >got full that interests me. We have a v7 ARS
> server with IM, PM, CM,
> > SLM, CMDB, EIE for SQL installed.
> >After about 6 months running, we hit the same
> situation. There are
> > about 2 incident tickets in the db and
> >   2000 contact information replicated/updated
> nightly. It end up with a
> > more than 100GB transaction log file.
> >Does anyone know what kind of behavior would
> generate a log file so
> > large?
> >   Thank you.
> >
> > DJHuang
> >
> > 2007/7/12, Broyles Robert K Mr CTR USAF 96 CS/SCCE
> <[EMAIL PROTECTED]
> > >:
> >
> > Thanks Joe.  I went back and reread the SQL books
> online and say that my
> > syntax was wrong.  I didn't need to specify
> TRUNCATEONLY if I pass it a
> > file size.
> >
> > Rob
> >
> >
> >
>
___
> > UNSUBSCRIBE or access ARSlist Archives at
> www.arslist.org ARSlist:"Where
> > the Answers Are"
> >
> >
> > __20060125___This posting was
> submitted with HTML in
> > it___
> >  __20060125___This posting was
> submitted with HTML in
> > it___
> >
> 





 

Expecting? Get great news right away with email Auto-Check. 
Try the Yahoo! Mail Beta.
http://advision.webevents.yahoo.com/mailbeta/newmail_tools.html 

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


Re: Reset Incident Number ID

2007-07-16 Thread Bruce Scott
Rami,
 
If you have access to the database directly, look for the ARSCHEMA
table and update the value for NEXTID for the table in question.  If you
have any records in the Incident table and you set the NEXTID below the
existing entry IDs, you will have problems later when the NEXTID value
increments to equal the existing entry id.
 
Bruce
 

  _  

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Rami S Ayoub
Sent: Monday, July 16, 2007 5:38 AM
To: arslist@ARSLIST.ORG
Subject: Reset Incident Number ID


** 
**

Hi List, 

 

How can I Reset the IN Number to start from IN01., i already
have old cases and i want now start from number 1 ?

 

AR Server 7

SQL 2005

Incident and Problem 

Windows 2003

 

Regards,

Rami

__20060125___This posting was submitted with HTML in
it___

#
The information contained in this electronic mail message, including 
attachments, if any, is PetSmart confidential information.  It is intended only 
for the use of the person(s) named above.  If the reader of this message is not 
the intended recipient, or has received this message in error, you are hereby 
notified that any review, dissemination, distribution or copying of this 
communication is strictly prohibited.  If you are not the intended recipient or 
have received this message in error, please notify the sender via e-mail and 
promptly delete the original message.
#

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


Re: Reset Incident Number ID

2007-07-16 Thread Payne, George
If you're using ITSM 7 then I would recommend choosing a starting number
HIGHER than any that you've already used (kind of like you do with your
paper checkbook if anyone remembers what THOSE are :-) ).  There are
potentially CHILD forms that would reference the INCident number that
might get confused if the primary form were reset to ..0001.

 

If you're still intent on resetting to 0001 then make sure that you've
archived the primary and all the CHILD forms before proceeding.

 

Best of luck,
George

 

George Payne

Assistant Director, User Services

Information Technology Services

University of Texas at Austin

512.232.4132

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Rami S Ayoub
Sent: Monday, July 16, 2007 7:38 AM
To: arslist@ARSLIST.ORG
Subject: Reset Incident Number ID

 

**

Hi List, 

 

How can I Reset the IN Number to start from IN01., i already
have old cases and i want now start from number 1 ?

 

AR Server 7

SQL 2005

Incident and Problem 

Windows 2003

 

Regards,

Rami

__20060125___This posting was submitted with HTML in
it___

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


Re: Reset Incident Number ID

2007-07-16 Thread Rami S Ayoub
Thanks Bruce, Resolved.

 

 



From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Bruce Scott
Sent: Monday, July 16, 2007 5:01 PM
To: arslist@ARSLIST.ORG
Subject: Re: Reset Incident Number ID

 

Rami,

 

If you have access to the database directly, look for the ARSCHEMA table 
and update the value for NEXTID for the table in question.  If you have any 
records in the Incident table and you set the NEXTID below the existing entry 
IDs, you will have problems later when the NEXTID value increments to equal the 
existing entry id.

 

Bruce

 

 



From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Rami S Ayoub
Sent: Monday, July 16, 2007 5:38 AM
To: arslist@ARSLIST.ORG
Subject: Reset Incident Number ID

** 

**

Hi List, 

 

How can I Reset the IN Number to start from IN01., i already have 
old cases and i want now start from number 1 ?

 

AR Server 7

SQL 2005

Incident and Problem 

Windows 2003

 

Regards,

Rami

__20060125___This posting was submitted with HTML in it___ 



The information contained in this electronic mail message, including 
attachments, if any, is PetSmart confidential information.  It is intended only 
for the use of the person(s) named above.  If the reader of this message is not 
the intended recipient, or has received this message in error, you are hereby 
notified that any review, dissemination, distribution or copying of this 
communication is strictly prohibited.  If you are not the intended recipient or 
have received this message in error, please notify the sender via e-mail and 
promptly delete the original message.




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


Create Incident By Incoming EMails

2007-07-16 Thread Rami S Ayoub
**

Hi List, 

 

Does anyone try to create an incident by Incoming emails? 

 

AR Server 7.

Service Desk Application


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


Re: Create Incident By Incoming EMails

2007-07-16 Thread Fariss, Ron
Rami,
 
We open (and update) several hundred tickets each day via e-mail.  The
e-mail is pushed to an incoming e-mail template (in-house created form),
then a set of filters edits the information and pushes pre-determined,
required fields to open the actual ticket.  After creation, the Ticket
ID is pushed back to e-mail template to provide a link.
 
We are still using Remedy 5.1.2 and our Help Desk ticketing system is
Home-grown, but I am sure that you could do the same process on whatever
system you are using.

Ron Fariss 
AIG Global Services 
Service Desk Automation 
713-831-2365 (Office) 
281-782-0979 (Mobile) 

 



From: "Action Request System discussion list(ARSList)"
[mailto:[EMAIL PROTECTED] On Behalf Of Rami S Ayoub 
Sent: Monday, July 16, 2007 10:18 AM
To: arslist@ARSLIST.ORG
Subject: Create Incident By Incoming EMails


** 
**

Hi List, 

 

Does anyone try to create an incident by Incoming emails? 

 

AR Server 7.

Service Desk Application

__20060125___This posting was submitted with HTML in
it___

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


Question: Table Colours

2007-07-16 Thread Tyrone Dee
Is it possible to have a table highlight every other record in the table
with a shade of grey - just like Excel.

 

Thanks.


T.

 

__20060125___This posting was submitted with HTML in
it___

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


Re: License Usage

2007-07-16 Thread Tama Murphy
 
You could create web services on the remedy forms that you want to create and 
update, then consume these from your website to create/update records.
This would use the web service user account and would not require any extra 
licenses at all.
 
I think that this would be acceptable as this web service user is provided by 
Remedy for this sort of "integration"


Date: Fri, 13 Jul 2007 11:07:24 -0400From: [EMAIL PROTECTED]: Re: License 
UsageTo: [EMAIL PROTECTED] OK ... new scenario.If the Remedy login being used 
from the web site creates an "event type" record in Remedy. Then, an alert 
fires to a user (or group of users) letting them know that there is updated 
information for a particular ticket. The end users will then, for example, 
double click a record (push a button) which will push the updated information 
to the ticket. In then end, the Web user is only submitting records and it will 
be up to an actual logged in Remedy user to push the updates to the 
ticket.Would this be acceptable license usage?
On 6/29/07, Payne, George <[EMAIL PROTECTED]> wrote: 
The funny thing is that a respected Remedy Trainer (who will remainun-named) 
brought up a very similar question in a class he was teachingon Application 
Design in the spring of 2006.  My solution was to submita ticket to a child and 
then update the parent with workflow and heassured me that this would be 100% 
legal based on the current licensingscheme.Hmmm...maybe he was wrong, but I 
understand that he employed this technique in a recent mid-west installation 
with a very large customerwho was looking to circumnavigate the enormous 
licensing fees that theywere amassing.GpGeorge PayneAssistant Director, User 
Services Information Technology ServicesUniversity of Texas at 
Austin512.232.7513-Original Message-From: Action Request System 
discussion list(ARSList)[mailto: [EMAIL PROTECTED] On Behalf Of [EMAIL 
PROTECTED]: Friday, June 29, 2007 10:29 AMTo: [EMAIL PROTECTED]: Re: License 
Usage I would also agree that it has been a longstanding license 
violation.Since theearly days of 4.x at least, the 'read' license was limited 
tosubmission of newrecords and querying, and modification of records required a 
change license.When RemedyWeb came out it was possible to make updates to the 
displayonly Webform that would trigger a filter that would make background 
databaseupdates bythe Web user, but doing such an update was specifically not 
permitted due to theclause above.  Any other method, including a single user 
being used bymultipleworkstations, is also such a licensing violation.Louise 
van HineKTSL LimitedQuoting "L. J. Head" < [EMAIL PROTECTED]>:> **  My 
understanding is that it would be a violation based on the> 'no group user 
accounts' policy...I've never read the agreement > myself but understand it as 
such.>> ->  FROM: Action Request System discussion 
list(ARSList)> [mailto:arslist@ARSLIST.ORG ] ON BEHALF OF Frank Caruso> SENT: 
Friday, June 29, 2007 8:58 AM> TO: arslist@ARSLIST.ORG> SUBJECT: License 
Usage>>  ** Looking for feedback on whether the following set up would > 
violate a license agreement with BMC:> Putting up web sites (not MidTier) where 
end users can submit and> update records but the web site authenticates with 
the ARS server> using one ID.> This ID has been granted a Fixed license and 
each site will have a > unique Remedy ID attached to it. Also, it is possible 
that many of> the users submitting and updating tickets through these web 
sites> will have a Remedy login with a Floating license, however, the web > 
sites will not use that ID to authenticate.> I believe that this would be a 
violation but cannot find anything> written from BMC that states it would.> 
Thank you>> __20060125___This posting was submitted with 
HTML > in it___  __20060125___This posting was submitted> 
with HTML in 
it__UNSUBSCRIBE
 or access ARSlist Archives at www.arslist.org ARSlist:"Wherethe Answers 
Are"___UNSUBSCRIBE
 or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers 
Are"-- Frank CarusoSpecific Integration, Inc.Senior Remedy Engineer, ITIL 
Foundation Certified www.specificintegration.com703-376-1249 
__20060125___This posting was submitted with HTML in it___ 
_
Local listings, incredible imagery, and driving directions - all in one place! 
Find it!
http://maps.live.com/?wip=69&FORM=MGAC01
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"


Re: Error on particular CTI

2007-07-16 Thread Joel D. Sender
Just a thought ..
See if the summary (template) was set-up with a C/T/I that as since been 
deleted.
The template C/T/I may have been OK before, but is filling in an invalid C/T/I 
now
HTH,
Joel
*
Joel D. Sender
Director of Western Operations
QMX Support Services, Inc.
[EMAIL PROTECTED]

-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
Behalf Of nsachin
Sent: Friday, July 13, 2007 3:16 AM
To: arslist@ARSLIST.ORG
Subject: Re: Error on particular CTI

i think nobody is able to solve my problem.

Regards,
Sachin Namjoshi





nsachin wrote:
>
> Hi all Listers,
>
> I am getting a strange error on saving a request on CHG:Change form. After
> selecting a particular summary only ( as per predefined CTI) and filling
> all the required fields, I get this error as per attachment on Save
> button.
>
> After checking the log, I have found that this error is occurring after
> push field action.
>
> The save button works fine on other CTI's of Summary field. It doesn't
> give this SQL error after selecting other CTI's.
>
> Can you please help me on this?
>
>  http://www.nabble.com/file/p11575655/SQLerror1.bmp SQLerror1.bmp
>
:-D
--
View this message in context: 
http://www.nabble.com/Error-on-particular-CTI-tf4073030.html#a11576647
Sent from the ARS (Action Request System) mailing list archive at Nabble.com.

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

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


how to escape quotes in setfield action ?

2007-07-16 Thread Andrew Hicox

Everyone:

I've got an active link with a set fields action.
I need to set a string containing quotes into a char field.

For the sake of brevity, let's just say I need to set the string: 
"hello" (including the quotes) into a char field.


I can't figure out how to escape the quotes in the set fields action.
\" dosen't seem to work, nor "\ or \\".

I can't find a thing in the documentation on this.
Can anyone help me ?

thanks,

-Andrew


Andrew N. Hicox
Hicox Information Systems LLC
Manassas, VA  USA
http://hicox.com
[EMAIL PROTECTED]
703-367-9085

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


Re: how to escape quotes in setfield action ?

2007-07-16 Thread Matthew Kunkel
Try putting three double quotes (""") anywhere you need a single set.
That is the escape sequence.

-Matt 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Andrew Hicox
Sent: Monday, July 16, 2007 1:16 PM
To: arslist@ARSLIST.ORG
Subject: how to escape quotes in setfield action ?

Everyone:

I've got an active link with a set fields action.
I need to set a string containing quotes into a char field.

For the sake of brevity, let's just say I need to set the string: 
"hello" (including the quotes) into a char field.

I can't figure out how to escape the quotes in the set fields action.
\" dosen't seem to work, nor "\ or \\".

I can't find a thing in the documentation on this.
Can anyone help me ?

thanks,

-Andrew


Andrew N. Hicox
Hicox Information Systems LLC
Manassas, VA  USA
http://hicox.com
[EMAIL PROTECTED]
703-367-9085


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

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


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


Re: how to escape quotes in setfield action ?

2007-07-16 Thread Jarl Grøneng

Have you tried: """?

Should be: """hello"""

--
Jarl

On 7/16/07, Andrew Hicox <[EMAIL PROTECTED]> wrote:

Everyone:

I've got an active link with a set fields action.
I need to set a string containing quotes into a char field.

For the sake of brevity, let's just say I need to set the string:
"hello" (including the quotes) into a char field.

I can't figure out how to escape the quotes in the set fields action.
\" dosen't seem to work, nor "\ or \\".

I can't find a thing in the documentation on this.
Can anyone help me ?

thanks,

-Andrew


Andrew N. Hicox
Hicox Information Systems LLC
Manassas, VA  USA
http://hicox.com
[EMAIL PROTECTED]
703-367-9085

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



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


Re: how to escape quotes in setfield action ?

2007-07-16 Thread Barnhill, Jason (Jason)
I use 4 quotes successfully...

 + "hello" + 

I do this quite often, it's always worked for me...

-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Jarl Grøneng
Sent: Monday, July 16, 2007 2:27 PM
To: arslist@ARSLIST.ORG
Subject: Re: how to escape quotes in setfield action ?

Have you tried: """?

Should be: """hello"""

--
Jarl

On 7/16/07, Andrew Hicox <[EMAIL PROTECTED]> wrote:
> Everyone:
>
> I've got an active link with a set fields action.
> I need to set a string containing quotes into a char field.
>
> For the sake of brevity, let's just say I need to set the string:
> "hello" (including the quotes) into a char field.
>
> I can't figure out how to escape the quotes in the set fields action.
> \" dosen't seem to work, nor "\ or \\".
>
> I can't find a thing in the documentation on this.
> Can anyone help me ?
>
> thanks,
>
> -Andrew
>
>
> Andrew N. Hicox
> Hicox Information Systems LLC
> Manassas, VA  USA
> http://hicox.com
> [EMAIL PROTECTED]
> 703-367-9085
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
> Answers Are"
>

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

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


Re: how to escape quotes in setfield action ?

2007-07-16 Thread L. J. Head
I use that when I'm doing a variable such as 
 + $Field$ + 
But in the case of hard coded text I agree that the " + " is redundant and
"""hello"""
is cleaner
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Barnhill, Jason (Jason)
Sent: Monday, July 16, 2007 12:31 PM
To: arslist@ARSLIST.ORG
Subject: Re: how to escape quotes in setfield action ?

I use 4 quotes successfully...

 + "hello" + 

I do this quite often, it's always worked for me...

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Jarl Grøneng
Sent: Monday, July 16, 2007 2:27 PM
To: arslist@ARSLIST.ORG
Subject: Re: how to escape quotes in setfield action ?

Have you tried: """?

Should be: """hello"""

--
Jarl

On 7/16/07, Andrew Hicox <[EMAIL PROTECTED]> wrote:
> Everyone:
>
> I've got an active link with a set fields action.
> I need to set a string containing quotes into a char field.
>
> For the sake of brevity, let's just say I need to set the string:
> "hello" (including the quotes) into a char field.
>
> I can't figure out how to escape the quotes in the set fields action.
> \" dosen't seem to work, nor "\ or \\".
>
> I can't find a thing in the documentation on this.
> Can anyone help me ?
>
> thanks,
>
> -Andrew
>
>
> Andrew N. Hicox
> Hicox Information Systems LLC
> Manassas, VA  USA
> http://hicox.com
> [EMAIL PROTECTED]
> 703-367-9085
>
> __
> _ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org 
> ARSlist:"Where the Answers Are"
>


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


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

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


Question: Colours for Tables

2007-07-16 Thread Tyrone Dee
Sorry if you received this twice - it came back rejected.

Is it possible to have a table highlight every other record in the table
with a shade of grey - just like Excel.

Thanks.

T.

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


Re: Error on particular CTI

2007-07-16 Thread Broyles Robert K Mr CTR USAF 96 CS/SCCE
Did you look at the Active link in Question?  Why don't you post the SQL
statement in the Active link.  It sais that you are missing a comma.
Look at the Query and then copy and paste the Query into what ever
database client tool that you use.  Look at your syntax and see what
your backend database expects.

Rob

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


Re: Error on particular CTI

2007-07-16 Thread Marc Simmons

Error 552 is simply an error stating that there was a problem with a SQL
call to the database.  The following message ORA-00917 shows that there was
a SQL call written missing a semicolon.  The bottom of the error message
looks like this error is being generated by an active link.  I can't tell
which al from the image.

I would check the active link generating the error and the next few above it
(in execution order) to see if there are set fields or other actions using
direct SQL calls that could be generating the error message.

If that is not the case, turn on SQL logging to zone in on what is causing
the error.

Marc Simmons


On 7/16/07, Joel D. Sender <[EMAIL PROTECTED]> wrote:


Just a thought ..
See if the summary (template) was set-up with a C/T/I that as since been
deleted.
The template C/T/I may have been OK before, but is filling in an invalid
C/T/I now
HTH,
Joel
*
Joel D. Sender
Director of Western Operations
QMX Support Services, Inc.
[EMAIL PROTECTED]

-Original Message-
From: Action Request System discussion list(ARSList) [mailto:
[EMAIL PROTECTED] Behalf Of nsachin
Sent: Friday, July 13, 2007 3:16 AM
To: arslist@ARSLIST.ORG
Subject: Re: Error on particular CTI

i think nobody is able to solve my problem.

Regards,
Sachin Namjoshi





nsachin wrote:
>
> Hi all Listers,
>
> I am getting a strange error on saving a request on CHG:Change form.
After
> selecting a particular summary only ( as per predefined CTI) and filling
> all the required fields, I get this error as per attachment on Save
> button.
>
> After checking the log, I have found that this error is occurring after
> push field action.
>
> The save button works fine on other CTI's of Summary field. It doesn't
> give this SQL error after selecting other CTI's.
>
> Can you please help me on this?
>
>  http://www.nabble.com/file/p11575655/SQLerror1.bmp SQLerror1.bmp
>
:-D
--
View this message in context:
http://www.nabble.com/Error-on-particular-CTI-tf4073030.html#a11576647
Sent from the ARS (Action Request System) mailing list archive at
Nabble.com.


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


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





--
Marc Simmons
Remedy Administrator

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

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


User Goup in Dallas area

2007-07-16 Thread Don Simmons
Is there an active User Group in the Dallas area?  Does anyone know?
 
Don Simmons
972-746-5749
_
Don't get caught with egg on your face. Play Chicktionary!  
http://club.live.com/chicktionary.aspx?icid=chick_wlmailtextlink
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"


Re: Question: Colours for Tables (UNCLASSIFIED)

2007-07-16 Thread HARTWICK, SCOTT G CTR DISA JSSC
Classification:  UNCLASSIFIED 
Caveats: NONE

Tyrone,

This feature is the default appearance for the last few versions of the
Mid-Tier. Tables automatically highlight every other row. If you don't
have a mid-tier can you build it?

HTH,
Scott 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Tyrone Dee
Sent: Monday, July 16, 2007 2:48 PM
To: arslist@ARSLIST.ORG
Subject: Question: Colours for Tables

Sorry if you received this twice - it came back rejected.

Is it possible to have a table highlight every other record in the table
with a shade of grey - just like Excel.

Thanks.

T.


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

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


Re: how to escape quotes in setfield action ?

2007-07-16 Thread Terry Bootsma
I've done this several times using the following technique:

Create a display only field... call it "_Quote".  Set the default value to
the quotation mark.

On active link firing do the following

action1 -  set _Quote to it's default value.

action 2 - Use the set fields action such as $_Quote$ + "hello" + $_Quote$

Works for me all the time...

Terry


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of Andrew Hicox
Sent: Monday, July 16, 2007 2:16 PM
To: arslist@ARSLIST.ORG
Subject: how to escape quotes in setfield action ?


Everyone:

I've got an active link with a set fields action.
I need to set a string containing quotes into a char field.

For the sake of brevity, let's just say I need to set the string:
"hello" (including the quotes) into a char field.

I can't figure out how to escape the quotes in the set fields action.
\" dosen't seem to work, nor "\ or \\".

I can't find a thing in the documentation on this.
Can anyone help me ?

thanks,

-Andrew


Andrew N. Hicox
Hicox Information Systems LLC
Manassas, VA  USA
http://hicox.com
[EMAIL PROTECTED]
703-367-9085


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

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


Re: Question: Colours for Tables (UNCLASSIFIED)

2007-07-16 Thread Tyrone Dee
Thanks for your response Scott.

I have mid-tier, but I am not using it.  I want to do this in the User Tool.
I'm running 6.3.

Thanks!


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of HARTWICK, SCOTT G CTR DISA JSSC
Sent: Monday, July 16, 2007 3:06 PM
To: arslist@ARSLIST.ORG
Subject: Re: Question: Colours for Tables (UNCLASSIFIED)

Classification:  UNCLASSIFIED 
Caveats: NONE

Tyrone,

This feature is the default appearance for the last few versions of the
Mid-Tier. Tables automatically highlight every other row. If you don't
have a mid-tier can you build it?

HTH,
Scott 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Tyrone Dee
Sent: Monday, July 16, 2007 2:48 PM
To: arslist@ARSLIST.ORG
Subject: Question: Colours for Tables

Sorry if you received this twice - it came back rejected.

Is it possible to have a table highlight every other record in the table
with a shade of grey - just like Excel.

Thanks.

T.


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


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

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


VSS integration?

2007-07-16 Thread Stephen Willis
About 3 years ago I was working on a remedy project where we tried to use 
the built in remedy integration with VSS. It was way too buggy. Files got 
locked, the VSS database got corrupted etc. We ended up checking def files 
in and out of VSS outside of remedy. There was an understanding amoung 
developers that code could not be changed unless it was checked out of VSS. 
Believe or not this worked.


Now I'm being asked to implement a SC system for a new project that uses 
remedy 6.x


1: Have the bugs been ironed out wrt remedy / vss integration in 6.x so that 
its viable to use?

2: Are there serious performance issues to worry about?
3: Is there a lot of administrative overhead when compared with using VSS 
without integration (creating def files with remedy and checking in and out 
of vss outside of remedy)

4: Does anybody use a SC system for remedy code that is not VSS ?

Thanks in advance for your help

Stephen Willis

_
Windows Live Hotmail with drag and drop, you can easily move and organize 
your mail in one simple step. Get it today! 
www.newhotmail.ca?icid=WLHMENCA153


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


Documentation for older application

2007-07-16 Thread Kathy Morris
Is there anyone on the list using ITSP 4.0?
 



** Get a sneak peak of the all-new AOL at 
http://discover.aol.com/memed/aolcom30tour

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


Re: Documentation for older application

2007-07-16 Thread Ben Cantatore
I upgraded from that version; we're currently on version 7 so I'll try 
answer/help as best as I can as.  What do you need?

Ben Cantatore
Remedy Administrator
Avon
(914) 935-2946



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

07/16/2007 04:05 PM
Please respond to
arslist@ARSLIST.ORG


To
arslist@ARSLIST.ORG
cc

Subject
Documentation for older application






** 
Is there anyone on the list using ITSP 4.0?
 



Get a sneak peak of the all-new AOL.com.
__20060125___This posting was submitted with HTML in 
it___ 

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


Default Web Path issue

2007-07-16 Thread Pierson, Shawn
Has anyone figured out how to get the Default Web Path to work properly
for the Mid Tier and the Email Engine at the same time?

Basically, if you use it set to something like servername/arsys the web
works.  If you try to set it to http://servername/arsys then it becomes
a link in the emails sent out, but breaks the Mid Tier.

Thanks,

Shawn Pierson
5444 Westheimer Rd
Houston, TX 77056
(713)989-7226


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

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


Re: license upgrade

2007-07-16 Thread P Romain ARSlist
Are the servers in a server group?

 

If so, have the floating licenses been issued with the server group name in
the license information field?

 

  _  

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Chris Doble
Sent: 16 July 2007 01:46
To: arslist@ARSLIST.ORG
Subject: license upgrade

 

Folks,

 

I am wondering - I have 1 licensed server that has trial license apps on it.
There is a load balancer and the 2nd server is also a trial license.

 

I am upgrading from 5.x to 7.x - single server from the old system.

 

Is it better to purge the existing 7.x license and move it to the load
balanced server, and then use the upgraded arserver and apps licenses on the
1st 7.x server?

 

Or is there another way to do this?

 

Also, has anybody had their trail floating licenses never display as applied
in the server?

 

I have 30 that won't work - they are arserver floating and bmc incident mgmt
floating.

 

Thank You,

 

Chris Doble
Mobile: 949-533-5346

__20060125___This posting was submitted with HTML in
it___

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


Re: Default Web Path issue

2007-07-16 Thread strauss
Are you doing something odd on the mid-tier?  I have never seen the
single setting NOT work for both mid-tier and email (EXCEPT for SLA 5.5
notifications, which were pure junk).
 
On our 5.x servers which have SSL enabled:
Default Web Path: https:///arsys
 
On our 7.x servers which do not have SSL yet (haven't fought/won that
particular fight with tomcat - it's easy on IIS):
Default Web Path: http://:8080/arsys 
Email Notification Web Path: http://:8080/arsys 
 
I have never had to use a different setting for each one, but in 7.x it
is at least doable in the Advanced tab.

Christopher Strauss, Ph.D.
Remedy Database Administrator
University of North Texas Computing Center
http://remedy.unt.edu/ 


  _  

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Pierson, Shawn
Sent: Monday, July 16, 2007 3:56 PM
To: arslist@ARSLIST.ORG
Subject: Default Web Path issue


** 

Has anyone figured out how to get the Default Web Path to work properly
for the Mid Tier and the Email Engine at the same time?

Basically, if you use it set to something like servername/arsys the web
works.  If you try to set it to http://servername/arsys
  then it becomes a link in the emails sent
out, but breaks the Mid Tier.

Thanks, 

Shawn Pierson 
5444 Westheimer Rd 
Houston, TX 77056 
(713)989-7226 

Private and confidential as detailed here
 . If you cannot access
hyperlink, please e-mail sender. __20060125___This
posting was submitted with HTML in it___

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


Re: how to escape quotes in setfield action ?

2007-07-16 Thread Dave Saville
On Mon, 16 Jul 2007 15:07:47 -0400, Terry Bootsma wrote:

As a general rule: You need a quoted string - so start with a "
If you need a quote double the number you did last time ""
close quotes use the opposite rule.

So a quoting a string with a quote containing a quote would be (extra spaces
for clarity)

" I am a string that has "" a quote inside and a  quote inside that  ""
"

You often need this in *nix scripts where the string may be parsed more than
once through the shell for example.

HTH


>I've done this several times using the following technique:
>
>Create a display only field... call it "_Quote".  Set the default value to
>the quotation mark.
>
>On active link firing do the following
>
>action1 -  set _Quote to it's default value.
>
>action 2 - Use the set fields action such as $_Quote$ + "hello" + $_Quote$
>
>Works for me all the time...
>
>Terry
>
>
>-Original Message-
>From: Action Request System discussion list(ARSList)
>[mailto:[EMAIL PROTECTED] Behalf Of Andrew Hicox
>Sent: Monday, July 16, 2007 2:16 PM
>To: arslist@ARSLIST.ORG
>Subject: how to escape quotes in setfield action ?
>
>
>Everyone:
>
>I've got an active link with a set fields action.
>I need to set a string containing quotes into a char field.
>
>For the sake of brevity, let's just say I need to set the string:
>"hello" (including the quotes) into a char field.
>
>I can't figure out how to escape the quotes in the set fields action.
>\" dosen't seem to work, nor "\ or \\".
>
>I can't find a thing in the documentation on this.
>Can anyone help me ?
>
>thanks,
>
>-Andrew
>
>
>Andrew N. Hicox
>Hicox Information Systems LLC
>Manassas, VA  USA
>http://hicox.com
>[EMAIL PROTECTED]
>703-367-9085
>
>
>___
>UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
>Answers Are"
>
>___
>UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
>Answers Are"
>


--
Regards

Dave Saville

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


ITSM 7 Installation Instructions Error

2007-07-16 Thread Joseph Kubasek

For anyone installing the Incident portion of the version 7 ITSM
application, you should be aware of an error in the installation guide.

The installation guide (page 43) suggests putting the server into admin only
mode to install the application faster. If you follow this "Tip", the
installation will complete with several errors requiring a restore from
database back ups.

According to BMC tech support, the problem is that the install script uses
the CMDB dispatcher to make changes to the CMDB early in the install
process. Because the dispatcher is not an admin user, admin only mode keeps
these changes from happening. This in turn causes later parts of the
Incident application install to fail as some objects are not in place.

-- Rant starts --
The good news is that tech support was aware of this problem. They diagnosed
right off the bat without  what has sadly become the normal run around of
sending the same logs and information several time.

The bad news is that, from what the tech rep told me, BMC has known about
this problem for quite a while, but could not be bothered to update one
little PDF file.

Sigh.
-- Rant ends --

Joe Kubasek

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


is it possible to add menu item to the user tool

2007-07-16 Thread Jerry Zhou
Hi All,
   Does any one know if it is possible to add a menu item to the user
tool's Manu bar which is not associated with any form, i.e. the menu
item will always available regardless of which form is currently opened
or none is opened.
 
 
Thanks lot!
 
 
Jerry

*** Non-Public: For Internal Use Only *** 

 




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


Re: ITSM 7 Installation Instructions Error

2007-07-16 Thread Rick Cook

Joe, there are LOTS of documentation issues with this version.  You would be
well-advised to scour the KBs before troubleshooting ANYthing.  It will
likely save you lots of time, and will be educational.

Rick

On 7/16/07, Joseph Kubasek <[EMAIL PROTECTED]> wrote:


** For anyone installing the Incident portion of the version 7 ITSM
application, you should be aware of an error in the installation guide.

The installation guide (page 43) suggests putting the server into admin
only mode to install the application faster. If you follow this "Tip", the
installation will complete with several errors requiring a restore from
database back ups.

According to BMC tech support, the problem is that the install script uses
the CMDB dispatcher to make changes to the CMDB early in the install
process. Because the dispatcher is not an admin user, admin only mode keeps
these changes from happening. This in turn causes later parts of the
Incident application install to fail as some objects are not in place.

-- Rant starts --
The good news is that tech support was aware of this problem. They
diagnosed right off the bat without  what has sadly become the normal run
around of sending the same logs and information several time.

The bad news is that, from what the tech rep told me, BMC has known about
this problem for quite a while, but could not be bothered to update one
little PDF file.

Sigh.
-- Rant ends --

Joe Kubasek
__20060125___This posting was submitted with HTML in
it___


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


The to_char decoding for Date field

2007-07-16 Thread Charlie Jiang
All,

It has been a while I hope someone can still remember...
I need to decode the date field to display it in my Oracle XML Publisher.
The default to_char(field_name, 'mm/dd/yyy') does not work.

Best regards,

Charlie Jiang
Office: (703)492-3502 
Cell: (571)436-5893



This is an e-mail from General Dynamics Land Systems. It is for the intended 
recipient only and may contain confidential and privileged information.  No one 
else may read, print, store, copy, forward or act in reliance on it or its 
attachments.  If you are not the intended recipient, please return this message 
to the sender and delete the message and any attachments from your computer. 
Your cooperation is appreciated.


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


Client v701P3 and Crystal Reports 11

2007-07-16 Thread Susan Palmer

I have a Crystal Report that was originally in v9.  Now that we're on ARS
v701P2 I needed to upgrade it to Crystal v11.  The report saved nicely and
it does run (yes, somethings do work out).

This report has two subreports and everything is reliant on the Task ID.  I
have it as part of a macro attached to an active link.  You're on the task
and you click the button, and whaalaa, you get a Packing List report.

When we were on client v5.1.2 we just clicked the button.  But now on client
v701P3, a window appears and wants a Discrete Value, which is the Task ID.
Before we didn't have to key in that number, the macro filled it in.  How do
I get it to work that way in the new version?  I've searched the menu
options and help in Crystal for a clue.  But no clues are there.

We also get a message the first time we run this type of report asking if we
want to override the Embedded Query.  If we say No, you get headings and
white space.  If you say Yes, you get the what you expected.  Apparently
this Yes or No hold true for the whole session.  What is this about?

I need Crystal guru help !!!  At our last MWRUG meeting, one company
actually has a Crystal Reports person ... I was so jealous.

Thanks for all your help,

Susan

Side note:  The report we have with 14 subreports actually saved well in
Crystal 11.  Only had to delete a few fields that still existed on the form
but v11 didn't like and it WORKS!  I was so thankful I didn't have to start
from scratch.

ARS 701P2
Oracle 10g
Clients (many old 5.1.2v1348), moving to 701P3
Windows 2003 server


Susan Palmer
ShopperTrak
200 W Monroe St  11th Floor
Chicago, IL  60606
Office:  312-529-5325
Cell: 312-502-7687
[EMAIL PROTECTED]

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


Re: B2B Integration Standards

2007-07-16 Thread Rakshit Bhandary

Hi,

We have done this for a client and with complete success. The key is that
you draw set of rules and stick to it for both inbound and outbound
communication.

Regards,
Rakshit


On 7/14/07, Hall Chad - chahal <[EMAIL PROTECTED]> wrote:


**

Does anyone know of any standards for exchanging incidents with external
companies through a B2B integration? We have a home-grown Java web service
integrated with our custom Remedy incident management application. We use
our own XML schema, data elements, data values, and transactions which are
based on our own processes. This works fine now, but as we branch out with
more partners we're considering adhering more closely to industry standards,
if there are any. I've researched some info from The Consortium for Service
Innovation but I'm not sure how well this has been adopted and I'm a little
concerned that it still pushes the use of HTTP POST instead of web services.




Has anyone gone down this road before? If so, do you have any suggestions?
Success stories? Challenges?



Thanks!



[image: Acxiom Corporation]

*_** __*

*Chad Hall*   |   A c x i o m   I S

501.342.2650 *office *  |   501.472.1379 *wireless * |   501.342.3911 *fax
** *



***
The information contained in this communication is confidential, is
intended only for the use of the recipient named above, and may be legally
privileged.

If the reader of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or copying of this
communication is strictly prohibited.

If you have received this communication in error, please resend this
communication to the sender and delete the original message or any copy
of it from your computer system.

Thank You.


__20060125___This posting was submitted with HTML in
it___



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


Re: The to_char decoding for Date field

2007-07-16 Thread Jarl Grøneng

Page 131 in BMC(r) Remedy Action Request System 7.0 Database Reference

--
Jarl


On 7/16/07, Charlie Jiang <[EMAIL PROTECTED]> wrote:

**
All,

It has been a while I hope someone can still remember...
I need to decode the date field to display it in my Oracle XML Publisher.
The default to_char(field_name, 'mm/dd/yyy') does not work.

Best regards,

 Charlie Jiang
 Office: (703)492-3502
 Cell: (571)436-5893
 This is an e-mail from General Dynamics Land Systems. It is for the
intended recipient only and may contain confidential and privileged
information. No one else may read, print, store, copy, forward or act in
reliance on it or its attachments. If you are not the intended recipient,
please return this message to the sender and delete the message and any
attachments from your computer. Your cooperation is appreciated.
__20060125___This posting was submitted
with HTML in it___


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


Re: Client v701P3 and Crystal Reports 11

2007-07-16 Thread Ben Cantatore
I'm not sure if I understand the problem 100% but it sounds like the Task 
ID isn't being passed correctly to the subreports.  In Crystal, right 
click your subreport and select Change subreport links option.  Then check 
the field that is supose to be passing that value to the subreport.  I'd 
further check the report selection criteria in the subreport and see what 
its referencing.  I suspect if you look at the links/criteria you'll find 
something a tad off.   Worst case, delete the link and put them back in



Ben Cantatore
Remedy Administrator
Avon
(914) 935-2946



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

07/16/2007 06:53 PM
Please respond to
arslist@ARSLIST.ORG


To
arslist@ARSLIST.ORG
cc

Subject
Client v701P3 and Crystal Reports 11






** 
I have a Crystal Report that was originally in v9.  Now that we're on ARS 
v701P2 I needed to upgrade it to Crystal v11.  The report saved nicely and 
it does run (yes, somethings do work out). 
 
This report has two subreports and everything is reliant on the Task ID. I 
have it as part of a macro attached to an active link.  You're on the task 
and you click the button, and whaalaa, you get a Packing List report. 
 
When we were on client v5.1.2 we just clicked the button.  But now on 
client v701P3, a window appears and wants a Discrete Value, which is the 
Task ID.  Before we didn't have to key in that number, the macro filled it 
in.  How do I get it to work that way in the new version?  I've searched 
the menu options and help in Crystal for a clue.  But no clues are there. 
 
We also get a message the first time we run this type of report asking if 
we want to override the Embedded Query.  If we say No, you get headings 
and white space.  If you say Yes, you get the what you expected. 
Apparently this Yes or No hold true for the whole session.  What is this 
about? 
 
I need Crystal guru help !!!  At our last MWRUG meeting, one company 
actually has a Crystal Reports person ... I was so jealous. 
 
Thanks for all your help,
 
Susan
 
Side note:  The report we have with 14 subreports actually saved well in 
Crystal 11.  Only had to delete a few fields that still existed on the 
form but v11 didn't like and it WORKS!  I was so thankful I didn't have to 
start from scratch. 
 
ARS 701P2
Oracle 10g
Clients (many old 5.1.2v1348), moving to 701P3
Windows 2003 server
 
 
Susan Palmer
ShopperTrak
200 W Monroe St  11th Floor
Chicago, IL  60606
Office:  312-529-5325
Cell: 312-502-7687
[EMAIL PROTECTED]
__20060125___This posting was submitted with HTML in 
it___ 

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