Our users are experiencing periods that they can not access or update the AR
System. If already logged on get the hour glass for minutes.

We upgraded to AR version 4.05.02, migrated to a new server HPUX 11.0, and
upgraded and migrated Oracle to 8.1.7.
We were up and running error free for 1 week, when another application was
installed on the server. The other application is not experiencing any
issues. And together
both application are not utilizing more than a few percent of the system.
Listed below are 2 errors that we receive:

Aug 7 08:33:34 usmaux02 syslog: Notification System client-server: Signal
received by the system (NTNOTE 21) : 15

Tue Aug 7 11:37:25 2001 Notification System server: Cannot connect to
the Notification System server : usmaux02 -- RPC: Rpcbind failure - RPC:
Timed out :
technicians : Ticket 0000085578 has been opened and Assigned to you with a
status of Assigned

<<...>>

Jane Hillock
Aventis Pasteur

_____________________________

Looks to me like the same SID is assigned to both applications and they are
colliding.....

At 09:45 AM 08/08/2001 -0400, you wrote:
>**
>
>Our users are experiencing periods that they can not access or update the AR
>System. If already logged on get the hour glass for minutes.
>
>We upgraded to AR version 4.05.02, migrated to a new server HPUX 11.0, and
>upgraded and migrated Oracle to 8.1.7.
>We were up and running error free for 1 week, when another application was
>installed on the server. The other application is not experiencing any
>issues. And together
>both application are not utilizing more than a few percent of the system.
>Listed below are 2 errors that we receive:
>
>Aug 7 08:33:34 usmaux02 syslog: Notification System client-server: Signal
>received by the system (NTNOTE 21) : 15
>
>Tue Aug 7 11:37:25 2001 Notification System server: Cannot connect to
>the Notification System server : usmaux02 -- RPC: Rpcbind failure - RPC:
>Timed out :
>technicians : Ticket 0000085578 has been opened and Assigned to you with a
>status of Assigned
>
> <<...>>
>
>Jane Hillock
>Aventis Pasteur
>
>_____________________________
>
>
>You may also control your subscription options, including UNSUBSCRIBE, at
>www.ARSLIST.org

_____________________________

Jane:

Sounds like arserverd is 'crashing'. Suggest that you get at least
patch 1043 and to set the maxdsiz to at least 128MB.

James Mckenzie

Jane Hillock wrote:
>
> **
>
> Our users are experiencing periods that they can not access or update the AR
> System. If already logged on get the hour glass for minutes.
>
> We upgraded to AR version 4.05.02, migrated to a new server HPUX 11.0, and
> upgraded and migrated Oracle to 8.1.7.
> We were up and running error free for 1 week, when another application was
> installed on the server. The other application is not experiencing any
> issues. And together
> both application are not utilizing more than a few percent of the system.
> Listed below are 2 errors that we receive:
>
> Aug 7 08:33:34 usmaux02 syslog: Notification System client-server: Signal
> received by the system (NTNOTE 21) : 15
>
> Tue Aug 7 11:37:25 2001 Notification System server: Cannot connect to
> the Notification System server : usmaux02 -- RPC: Rpcbind failure - RPC:
> Timed out :
> technicians : Ticket 0000085578 has been opened and Assigned to you with a
> status of Assigned
>
> <<...>>
>
> Jane Hillock
> Aventis Pasteur
>
> _____________________________
>
>

_____________________________

Thanks Jim, I'll look into that.

I've also stumbled upon this Q&A in the archives, anyone
know what the Sybase equiv of Oracle's "create database
link" might be? (Ah, to have my own DBA) :

>>>

How can I make an SQL menu using a table in an external
database?
Attribution: Jeff Murphy
(jcmurphy@smurfland.cit.buffaloe.edu)
Q: How can I make an SQL menu using a table in an
external database?
A: Depending upon what database you are running ARS on,
you may need to create a 'database link' (oracle-speak)
to the external database that makes the table appear as
if it is in the local database.
For example (oracle):

create database link [remotesid] connect to
[remoteusername] identified by
[remotepassword] using [remoteconnectstring];

You can then access tables by doing something like:
select col1, col2 from user.tablename@remotesid;
<<<

Thanks again,
Charlie


-----Original Message-----
From: O'Hara, Jim
Sent: August 07, 2001 12:44 PM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: Direct SQL


**

Charlie,

The only way I was able to figure this was to buy a
product from Sybase
called Direct Connect, since renamed and re-priced
(upwards) to Enterprise
Connect. I only implemented a proof-of-concept
application with an eval
license of Direct Connect, since expired. I hope to get
back to it. The
way it works is, you use Direct SQL in Remedy, and query
a Sybase "proxy
table", which points to the MS-SQL database. This
applies to MS-SQL 7 and
above.

If MS-SQL is 6.5, I believe all you have to do is add
the server to the
Sybase interfaces file, create a stored procedure in the
MS-SQL database to
extract the data you want, and then in the Remedy/Sybase
database, run
direct sql in the format, exec
servername.databasename.dbowner.procedurename.

Jim

-----Original Message-----
From: A.n.o.n.y.m.o.u.s@ATT.NET
[mailto:A.n.o.n.y.m.o.u.s@ATT.NET]
Sent: August 07, 2001 11:20 AM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Direct SQL


**

Hello again Listers !

I'd like to be able to use direct SQL in Remedy to pull
data from an external MS_SQL Database. (Remedy here
sits atop Sybase). I've configured the "Interfaces"
file, added the server to the hosts table, (and I can
now ping the MS-SQL server successfully). What else is
necessary to configure?

Remedy doesn't seem able to find/recognize my tables on
the MS_SQL database.

As always, thanks in advance!
Charlie.

_________________________________________________________
___________________
_____________
To UNSUBSCRIBE, email the message "unsubscribe arslist"
to:

You may also control your subscription options,
including UNSUBSCRIBE, at
www.ARSLIST.org

_____________________________

hi everyone,

I would like to ask if anyone of you can help me enable or disable the
Remedy 4.5 email notification feature. The armaild process in UNIX (Solaris
2.6 for this matter) is not running anymore and mails coming from
ARSystem@remedy.companyname.com (for example) were all blocked. However,
subscribers email us that they receive email notices of closing tickets. We
also found out on the server log that remedy email upon closing of tickets
were still being sent. We noticed that on the AR Admin - Server
Information/Configuration option in the User Email Notifies From field,
there is a value of ARSystem. This might be the cause of email notification.
However, there were no error messages.

Effects of the error:
Subscribers still receive email notification from remedy even if this remedy
feature has been requested to be turned off.

And can you refer me to some resources or documentations online or other
locations for this concern?


Thanks

Jay Cabrera
Ayala Systems Technology Inc.
Makati City, Philippines
email: jvcabrera@ayalasystems.com

_____________________________

Try looking at your workflow. Check if there any Filters or Escalations which might be
sending out emails. You will need to disable them.

"ASTI Cabrera, Julius V." wrote:

> **
>
> hi everyone,
>
> I would like to ask if anyone of you can help me enable or disable the
> Remedy 4.5 email notification feature. The armaild process in UNIX (Solaris
> 2.6 for this matter) is not running anymore and mails coming from
> ARSystem@remedy.companyname.com (for example) were all blocked. However,
> subscribers email us that they receive email notices of closing tickets. We
> also found out on the server log that remedy email upon closing of tickets
> were still being sent. We noticed that on the AR Admin - Server
> Information/Configuration option in the User Email Notifies From field,
> there is a value of ARSystem. This might be the cause of email notification.
> However, there were no error messages.
>
> Effects of the error:
> Subscribers still receive email notification from remedy even if this remedy
> feature has been requested to be turned off.
>
> And can you refer me to some resources or documentations online or other
> locations for this concern?
>
> Thanks
>
> Jay Cabrera
> Ayala Systems Technology Inc.
> Makati City, Philippines
> email: jvcabrera@ayalasystems.com
>
> _____________________________
>
>

--
---------------------------------
Ron Tyro
Scotiabank Information Commons
University of Toronto
Phone: 416-978-0198
Fax: 416-978-0440
Email: ron.tyro@utoronto.ca
---------------------------------

_____________________________

Give this a shot:

On Solaris Remedy uses sendmail to send outbound email. (go figure.)
Since you have sendmail installed in the "normal" place Remedy is able to
send email. (The armaild is only used to process inbound email.)

There is a config file setting you can use (ar.cfg)
Server Admin Guide.pdf V4.5.2 P386 (B-6)
"
Email-Delivery-System:
(UNIX only) Specifies that the email utility is to be used on UNIX. The
default is
"usr/lib/sendmail -t -oi-f "%f""
"

So if you want nothing to be sent try setting it something like:
Email-Delivery-System: /dev/null

You will most likely need to hup, (stop and start ars) the arservtcd, but
that should stop all outbound email.
Server Admin Guide.pdf V4.5.2 P414 (C-12)
"
In UNIX, sending a SIGUSR1 signal causes arserverd to reread all
configuration files. Sending a SIGHUP signal causes it to reread the
configuration
files and reset all cached structure information. Generally, these signals
are only
sent after performing a manual repair or restore operation. However, neither
causes any damage or adversely affects users currently accessing the AR
System.
"

--
Carey Matthew Black

--
Carey Matthew Black

-----Original Message-----
From: ASTI Cabrera, Julius V. [mailto:JVCabrera@AYALASYSTEMS.COM]
Sent: Thursday, August 30, 2001 9:13 PM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject:
Importance: High


**

hi everyone,

I would like to ask if anyone of you can help me enable or disable the
Remedy 4.5 email notification feature. The armaild process in UNIX (Solaris
2.6 for this matter) is not running anymore and mails coming from
ARSystem@remedy.companyname.com (for example) were all blocked. However,
subscribers email us that they receive email notices of closing tickets. We
also found out on the server log that remedy email upon closing of tickets
were still being sent. We noticed that on the AR Admin - Server
Information/Configuration option in the User Email Notifies From field,
there is a value of ARSystem. This might be the cause of email notification.
However, there were no error messages.

Effects of the error:
Subscribers still receive email notification from remedy even if this remedy
feature has been requested to be turned off.

And can you refer me to some resources or documentations online or other
locations for this concern?


Thanks

Jay Cabrera
Ayala Systems Technology Inc.
Makati City, Philippines
email: jvcabrera@ayalasystems.com

________________
_____________


You may also control your subscription options, including UNSUBSCRIBE, at
www.ARSLIST.org

_____________________________

> -----Original Message-----
> From: ASTI Cabrera, Julius V. [mailto:JVCabrera@AYALASYSTEMS.COM]
> Sent: Thursday, August 30, 2001 10:13 PM
> To: ARSLIST@LISTSERV.VISTAIT.COM
> Subject:
> Importance: High
>
>
> **
>
> hi everyone,
>
> I would like to ask if anyone of you can help me enable or disable the
> Remedy 4.5 email notification feature. The armaild process in
> UNIX (Solaris
> 2.6 for this matter) is not running anymore and mails coming from
> ARSystem@remedy.companyname.com (for example) were all
> blocked. However,
> subscribers email us that they receive email notices of
> closing tickets. We
> also found out on the server log that remedy email upon
> closing of tickets
> were still being sent. We noticed that on the AR Admin - Server
> Information/Configuration option in the User Email Notifies
> From field,
> there is a value of ARSystem. This might be the cause of
> email notification.
> However, there were no error messages.

Something must be doing the notifying, either a filter or an escalation.

One quick fix would be to create an escalation that runs through your user
form setting people's Notify preference to "None". Then, even if
notifications were sent out, they wouldn't receive them.

The better way to do this is to go through all your filters and escalations
and look for notifications. Either delete those filters if you want *no*
notifications, or change them to use Notifier instead.

An even better way of finding the offending workflow - grep your logs to see
if anything is notifying. ARESCL.LOG and the filter log should both note if
they are notifying by email, and list the name of the filter/escalation that
is causing it. Then you can root it out.

---
Shannon B. Davis
Remedy Systems Administrator
Boston Communications Group, Inc.
ph:(781) 904-5328
sdavis@bcgi.net

_____________________________