**
Thanks for that info. I guess I will
have get a copy of Crystal 10 then.
Thanks,
Andrew Baxter
Manager, Information Technology
w. (781) 902-6026
f. (781) 902-6002
From: Action Request
System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Timothy Po
**
Hello Listers, I am trying to configuire SLA and stuck up with the limitation of Notification Text size of 254 characters in the SLA configuration. Has any of the listers succeeded in removing this restriction Regards Balaji
Yahoo! Messenger with Voice. Make PC-to-Phone Calls t
We had this same isuue and have been working with Remedy Support. It
appears the milestones that aren't building are related to defect 234494 -
email messages within the Notify action of an SLA Milestone must be under
255 characters or the milestones won't build. This defect applies to SLA
6.0, a
The solution will be used with Remedy but it is a general SQL Server
question. How can you get the base column name in a SQL View definition
from the view field name? For example,
CREATE VIEW uvwTest (FieldName1, FieldName2, FieldName3, FieldName4)
AS SELECT BaseColumn1, BaseColumn2, CONVERT(VAR
Frank:
The ARODBC driver tends to be sort of flaky under the best of circumstances.
I gave up trying to use it with Reporting Services.
I have been using Reporting Services against my ARSystem database quite
successfully. Use the MS-SQL driver and query against the views rather than
directly aga
Title: RE: Unix Server
**
I have been running on unix for over 8.5 years with less
than 1 day and 3 hours of downtime.
1 day of downtime was because I lost the motherboard. and
the 3 hours was my Screw-up. -- those were 5 years ago.
I have been on a 280R for over 3 years .. no downtime at
a
I agree wholeheartedly with Carl's comments below. We have been using SQL
SRS for months now accessing the database directly using the SQL driver
versus ARODBC. We did develop SQL functions to convert the integer date
values stored in Remedy to regular datetime values.
It works great and is fast
Title: RE: Unix Server
**
Hello List,
I am trying to configure LDAP
Plug-in (MS Active Directory) over SSL (http://www.remedy.com/customers/dht/archive/11-01-2005_A.htm).
While creating vendor
form I am getting the following error:
“Cannot connect to the directory service: Can't
Stephen, if you're trying to return the column name, know that it's the
DB name of the Remedy field. If you're trying to get the column ID,
that's in the metatables.
I built (as have many others) a simple ARS form to return the column
names and field IDs from a given form, using either the T# or
Good day list,
Our users have recently been plagued w/ a login issue. When they attempt
to login to the User tool, it hangs. On the top left corner, it appears
that it is hanging on the "CUP:INIT_CheckPreference" form... Our workflow
logging does not show us anything. After about 2 minutes o
smime.p7m
Description: S/MIME encrypted message
Named "User+"
From: Action Request System discussion list(ARSList) on behalf of [EMAIL
PROTECTED]
Sent: Tue 5/2/2006 12:52 PM
To: arslist@ARSLIST.ORG
Subject: Re: Password Form - Expiring Passwords
Remedy Support Developers Community Downloads
-Original
**
Do you have any workflow firing on the CUP:INIT form? If the login process is hanging on the INIT form check to see what the workflow is trying to do.
On 5/4/06, Carl Reenus <[EMAIL PROTECTED]> wrote:
Good day list,Our users have recently been plagued w/ a login issue. When they attemptto logi
Title: RE: LDAP error code 91
**
Dmitry:
I think that an LDAP Error 91 is that the LDAP server rejected your authentication attempt. Did you verify your user login? Also, did you get the certificate file as per the directions and test it before using it with your LDAPS connection?
James M
I am setting up my VSS - Source Control Database - But, I have a few
Filters and Active Links that can not be Added to Source Control Database -
It tells me Error From Source Control Provider - Non Specific Error
(ARERR 2950)
Any suggestions on what I may be able to do to get these last view it
Title: RE: Oracle 9.2.0.5 CBO Not Using Index
**
Axton:
That was directly from the PT&T class and was enforced by some basic ORACLE training that I received.
Here is gist of the training:
If the query can be closed end (i.e. equals) then the optimizer will look to see if the index can be
I also saw that in the PT&T training manual that I have, but it didn't
make a difference when I tried. Thanks for the suggestion Axton, I
will let you know how it goes.
On 5/4/06, McKenzie, James J C-E LCMC HQISEC/L3
<[EMAIL PROTECTED]> wrote:
**
Axton:
That was directly from the PT&T class a
Title: RE: LDAP error code 91
**
James,
I’ve created cert7.db
and key3.db files using certutil utility (http://www.mozilla.org/projects/security/pki/nss/tools/certutil.html).
We do not have IIS installed on our AD domain controllers, so I couldn’t
use Netscape 4.79.
I’ve tried to
pr
Title: RE: Oracle 9.2.0.5 CBO Not Using Index
**
Jon:
Do you have an index on the field and is the field set to equals or leading in the QBE?
I forgot those two. If the QBE setting is ANY, then the query sent to Oracle will automatically have the Wildcard (%) character added to the front
Rick,
Actually the ultimate goal is to retrieve the SQL View name of the field
(ie. My_Special_Field) based on the table column name (ie. C123456789).
This is the reverse of the example I presented below. *I thought this
example would be easier for others to grasp the concept of parsing the
base
Title: RE: LDAP error code 91
**
Dmitry:
It appears that the certificate files are not proper. I wish I had an idea on how to fix this for you, but I don't. Maybe another list member has been throuh this and can provide assistance.
James McKenzie
F
smime.p7m
Description: S/MIME encrypted message
Update:
Replace
IF ISNUMERIC(@Char) = 1 OR (LOWER(@Char) BETWEEN 'a' AND 'z')
With
IF @Char BETWEEN '0' AND '9' OR (LOWER(@Char) BETWEEN 'a' AND 'z')
The ISNUMERIC function consideres the plus sign numeric.
-Original Message-
From: Action Request System discussion list(ARSList
**
You know, as I am leafing through old emails, I see this one. And I think it is a GREAT idea. However, as is my way of programming satelliteswhy not take it one step further. If you right click on a button, it can limit your development options
i.e. active links but not filters...and can
**
Morning List,
Need some advice.
First I'll give you my specs:
5 year old server
running Windows 2000 with SQL Server 2000. ARSystem 5.1.2.
Process I am trying
to complete with my plans:
I have a feed coming
from an access database in the form of a csv file. It contains roughly 1
I have actually thought about the idea of an "open sourced ARS IDE".
Sure there are some headaches with the idea. But here is what I was
thinking. :) Something like ARSDocs, but with some basic edit options
too. :)
Start with Eclipse and the ARS Java API.
Build an Eclipse Plugin that allows you
I can find nothing on the net to confirm your statements. The closest
thing I can find that relates to this is the list of the "20 golden
rules" of the oracle RBO.
http://www.oreilly.com/catalog/orsqltunpr/chapter/excerpt.html
In this list, bound range and unbound range searches still rank high
Hello List,
Just wondering if anyone has integrated with a product called Bindview?
If so, could you provide methods of integration?
Thanks,
Seth
___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Title: RE: Oracle 9.2.0.5 CBO Not Using Index
**
Axton:
Partitioning is a fantastic feature and should be employed where it can. However, BMC did not decide to use this feature out of the box. I would help greatly if you could partition a high use form, such as the Help Desk Case, by statu
**
I am posting this job notice for a friend at Cingular. Please see the job description at the URL noted below.
http://careers.peopleclick.com/jobposts/Client_Cingular/BU1/External/pck339-198686.htm
Thanks.
__20060125___This posting was submitted with HTML in it___
The beauty of partitioning is that is can be a transparent method of
archiving, esp. since status is typically the method used to archive
tickets/requests.
Axton Grams
On 5/4/06, McKenzie, James J C-E LCMC HQISEC/L3
<[EMAIL PROTECTED]> wrote:
**
Axton:
Partitioning is a fantastic feature and
**
I know how to fix the above by auto generating a script on running a SELECT on the sysobjects table to retrieve affected objects and then change ownership of all the objects that are affected and then drop ARADmin user access to the database and add it as a dbo user of the database... My que
Title: RE: Oracle 9.2.0.5 CBO Not Using Index
**
Axton:
I'm talking about archiving to a historical record form rather than using partitioning within the data table for one form. Makes searches run faster/better when your users forget to select 'status' <= "Resolved".
James McKenzie
L-3 GS
Stephen,
I'm not sure what version of ARS you are using, but was just curious why you
do not use either of these Run Process commands:
Application-Map-Ids-To-Names
Maps the IDs of the fields or keywords in the string to a name
representation.
Application-Map-Ids-To-Names-L
For the indicated
Pam,
I have three guesses for you.
1) These objects have a strange special character in the name that the
SC system does not like.
2) These objects have names that exist in other ARS name spaces but
the SC system is not treating them as separate name spaces.
3) The SC system is "out to lunch"
**
All,Looking for some ideas or at least a common knowledge of this issue.We are running a mid-tier installation using tomcat and it keeps crashing every few days. I have logging turned on, but I am not finding anything spectacular in the logs to explain why it is blowing up.
Also, when it does d
All,
Thanks Craig and Carl for your input. I do have two more questions that
have came up.
1. Has anyone seen any issues of query conflict between SQL Reporting
Services and the AR Server?
2. Also, has anyone ran into issues with views and tables being
regenerated on changes made to Remedy th
**
Thanks for the information - I think it is the name - it has a $ and a % in it. But, because I have everything else in except these few items I now can't make changes to it. Any suggestions. Can you turn Source Control Off and then Turn it back on and still maintain the database that was cre
Seth - I have not used Remedy with Bindview, but have used Bindview for many
years. If you get a response to your question I would be very much
interested.
Thanks.
Seth Wrye <[EMAIL PROTECTED]> said:
> Hello List,
> Just wondering if anyone has integrated with a product called Bindview?
>
Ah...
Check this out... I found this just the other day...
In the admin tool help..
section: "Using the Remedy Administrator command line interface"
Toward the bottom you will find the following "aside" note...
"
Note: You cannot export server objects that include a percent sign
(%) in their n
**
Hello List,
I have a problem in displaying the DateTime field values in Filter messages. If
you see below screen shot the Planned End date is showing as 4/24/2009 2:00:00
PM where as in the Ar-Warning message it is showing the same field value as
4/24/2009 5:00:00 PM. Can
Good Afternoon to you All,
Turing SMI is a Leading Global Provider of IT Service Management and
Infrastructure Management Solutions.
For your Information Turing SMI are a Platinum sponsor of the BMC
UserWorld in San Fransisco in August 2006; as an organisation we are
looking forward to meetin
**
Thanks for your help - that was the problem. >>> [EMAIL PROTECTED] 05/04/06 11:07 AM >>>
Ah...Check this out... I found this just the other day...In the admin tool help..section: "Using the Remedy Administrator command line interface"Toward the bottom you will find the following "aside" note..
Scott,
ARS v6.3
Don't Application-Map-Ids-To-Names and Application-Map-Ids-To-Names-L
return the Remedy database name of the field instead of the SQL Server
View name for the field?
I am using this approach to convert a Remedy qualification (used in the
EXTERNAL() function) to Crystal Reports
**
Viswa:
Simple, Change the time zone on the viewing system to the
same time zone as the client/customer. If you are in India and the client
is in Germany, you have to use CET (Daylight Time).
James McKenzie
From: Action Request System discussion
list(ARSList) [mailto:[EMAIL PROTECT
**
Hi
,
My
clients are located in different locations and I can't keep same time zone for
clients and server.
Thanks,
Viswa.
-Original Message-From: Action Request System
discussion list(ARSList) [mailto:[EMAIL PROTECTED]On Behalf Of
McKenzie, James J C-E LCMC HQISEC/L3Sent:
Frank,
The report query is no different than you opening up Enterprise Manager and
running a query at the same time as your AR Server is running and accessing
the database. We're constantly running manual queries against our
production database and we've noticed zero impact on the production syst
**
There must be something that already captures that within Remedy so it can write the info to the username_recent.srh file in the HOME folder on the PC. Someone must know how to piggyback on that and make the same info go to a general server log file.
Sorry for being less specific, I don't kn
**
Hi Viswa,
We had a similar issue when we started having clients
in multiple time zones.
A simple workaround is to have an active link which
fires on Submit, setting the value of a hidden character field to be equal to
the time from the client's perspective. Then the filter which gener
It's all closed source. No hooks. Put a request into remedy to write
an api for their clients or open the source of their clients. Think
you are going to come up completely short-handed writing this on the
client side.
On the server side, you could draw some conclusions from the arsql.log
and a
SQL 2000 don't accept cross reference within tables in different databses...
So I was looking for an alternative solution for this.
but it have to be within the DBMS
Thanks
-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED
**
The other thing to remember if you DO install Crystal 9 is
that the version of MSDE it installs, 1.0 which equals SQL Server 7.0 unpatched,
is "Code-Red-Ready" until you apply SP4 for MSDE 1.0 so make sure that you don't
do this on a machine that is accessible to the network.
P.S. I am S
What about a db trigger that performs the validation and throws an
exception in the event of an improper update/insert/delete? What
particular aspects of PK/FK relationships are you looking to achieve?
Cascading operations, integrity, constraints on allowable data, etc.
Axton Grams
On 5/4/06,
Seth
Years ago when Bindview actually acquired this application
I had used it to integrate with Remedy for pages, emails.
I was about to buy the integration piece (digi-board) to send
notifications to Voice Mail.
You can also configure it as a notification tool outside of Remedy.
I have not seen
Another option would be replication, whereby you create the
constraints on the replicated table. Not sure the feasibility of this
since I no longer work with SQL Svr nor have I ever tried this.
Axton Grams
On 5/4/06, Axton <[EMAIL PROTECTED]> wrote:
What about a db trigger that performs the va
Carey,
I'll go you one better... Allow the BMC/Remedy ARS Eclipse plug-in to
work with the TortoiseSVN plug-in to Eclipse.
AR Definition files are Plain-Text, as are AR XML Definition files, so
it should not be too hard to tie it in...
NOTE: I'm not a developer, but have been looking at Eclipse
Title: OT: Daylight Saving Time - Remedy vs. Crystal
**
Hi All,
We're seeing issues with the way some of our custom Crystal Reports are calculating elapsed time, which seem related to Daylight Saving Time.
Both servers and the client are in EST5EDT.
Here's an example case where Remedy an
Title: OT: Daylight Saving Time - Remedy vs. Crystal
**
Remedy
automatically translates your PCs timezone and all dates are handled as seconds
since 1/1/1970 (I believe). However, when you are working directly with
Crystal, Crystal doesn't automatically adjust for the timezones. If
you are
Hi Ann
I can't offer an explanation for your problem, but I can confirm that I've
seen similar or the same behavior. I have worked on several systems where
Group notifications are extremely unreliable and often only generate
notifications to one or two of many group members. There seems to be no
**
Hi everyone:
My email engine has mysteriously stopped working. I am
running Remedy 5.1.2 on Windows 2003 Server SP2 with the Outlook 2003 client.
I have Outgoing and Incoming entries set in the Mailbox Configuration form. I
am using MAPI and my mail server is a Microsoft Exchange
**
A proper Outlook profile for the Exchange server does
contain a full qualified domain name for the actual mail server. It also
needs to be the default profile for Outlook while logged in to the AR Server as
the email account.
Christopher Strauss, MSLSRemedy Database
AdministratorUnivers
**
Have you installed some kind of security patch for microsoft outlook on ur AR Server? There is one that blocks the use of MS outlook as a service.. Rgds JoeKaiser Norm E CIV USAF 96 CG/SCWOE <[EMAIL PROTECTED]> wrote: ** Hi everyone: My email engine has mysteriously stoppe
Hello everyone,
I'm getting an error in the AR System User on an open window action of a
crystal report . The error is this:
Error in File C:\Program Files\AR System 6.3\Home\LibRxMai.rpt:
Unable to connect : incorrect log on parameters.
When I close the error message, another error message
**
There are other benefits of having one
active link instead of two:
- Less active links to list in the admin
tool. We have all seen how long this takes if you have a large system.
- When the form definition changes and the
user tool needs to download another version of the .arf and .ar
David, thank you for sharing about group notification issues! Remedy
support is looking into it.
BTW, arreload didn't fix our problem either.
Regards,
ann
~*~ ~*~ ~*~
A. R. Kosch
Special Projects/Analyst
Remedy ARS Administrator/Coordinator
[EMAIL PROTECTED]
785-532-4933
Kansas State University
Has anyone using the ARFPerl plugin added any logging to their perl
code?
Fred
___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Adam,
I am actually very disappointed in how Remedy decided to integrate to
SC (source control) systems in general. ( IMHO ) They violated most of
their basic design when they decided to let the windows admin client
have a feature/function that the ARS server did not have. Not to
mention that the
Do you use the provided precompiled AREA plugin for authentication?
Axton Grams
On 5/4/06, A R Kosch <[EMAIL PROTECTED]> wrote:
David, thank you for sharing about group notification issues! Remedy
support is looking into it.
BTW, arreload didn't fix our problem either.
Regards,
ann
~*~ ~*~ ~
On Thu, 4 May 2006 21:18:06 -0400, Axton <[EMAIL PROTECTED]> wrote:
>Do you use the provided precompiled AREA plugin for authentication?
Yes we do. What do you think, then.
I noticed info in KB or somewhere that once a change is made to registered
user info, AREA keeps performing AREAVerifyLog
Hello listers,
ARS 6.0.3
Windows XP SP2
SQL 2000 SP4
When I try to create a View form, based on a table defined in the same
Database used by the ARSystem, and click on the load button, I getting the
following error :
Requested database table not found. Please check the spelling (table name
is
With 5.x(not sure the release this was fixed, whether 6.x or later 5.x
patch), there was a problem with group notifications if using the
canned AREA for authentication. The users that had a blank password
would not get notified from group notifications unless the email
address and notification me
On Thu, 4 May 2006 23:16:11 -0400, Axton <[EMAIL PROTECTED]> wrote:
>With 5.x(not sure the release this was fixed, whether 6.x or later 5.x
>patch), there was a problem with group notifications if using the
>canned AREA for authentication. The users that had a blank password
>would not get notifi
Antonio,
What permissions are defined for the table? Your AR Server should connect
to the MS-SQL Server 2000 database as "ARAdmin" or "\ARAdmin", and
this is the same account that is used to read from any local or external
linked tables. Does this account have select permissions on the table?
Logging of the plugin-code or logging of the perl-code running trough
the plugin?
--
Jarl
On 5/4/06, Grooms, Frederick W <[EMAIL PROTECTED]> wrote:
Has anyone using the ARFPerl plugin added any logging to their perl
code?
Fred
__
74 matches
Mail list logo