| **
Apparently this was a bug since version
4.0. I found an entry in the knowledge base with this. P R O B L E M -------------------------------------------------------------------------------- Why are Group Notifications not working on a
4.0 AR System server with an Oracle database? S O L U T I O N -------------------------------------------------------------------------------- If you are installing ARS Version 4.0, and are
using an Oracle database, be aware of the following situation. The Table
aradmin.user_cache is defined incorrectly. The field LONGGROUP is defined as a
LONG field. It should be VARCHAR2(255). This definition prevents Group
notifying from functioning properly. Check this table after installing, and if
the field is LONG, then run the following SQL command (Check with your DBA) : ALTER TABLE user_cache MODIFY (longGroup
varchar2(255)); This was exactly our case. The longgroup
column was a LONG so we had to change it to varchar2(4000). This fixed our
problem immediately. On a somewhat related note I found a fix
for a bug that we were also having. P R O B L E M -------------------------------------------------------------------------------- Email attachments do not get sent on a 7.x server. S O L U T I O N -------------------------------------------------------------------------------- Defect - 249619 Email attachments on 7.x AR Server do not get
sent out on filter notifications when selected as an included field. The
issue is escalated and there is a workaround. Workaround: If "Add Shortcut"
is selected in the filter notify action the included attachments will also be
sent out. What I don’t get is why are simple
things like this breaking especially since they’ve been around for a long
time now? Upgrading to 7.0 was supposed to help stabilize things, not break
them. Darren Lau From: Action Request
System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McKenzie, James J C-E LCMC
HQISEC/L3 David:
________________________________
From:
Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of
David Sanders ** Darren,
Stephen
ARS does
not care what table number the Group and User forms are. The forms are
recognized by the reserved field IDs of the fields in the forms. In fact,
you can have multiple copies of the User and Group forms with different names,
and they will all work. Do not bother trying to restore to a specific
schemaId as you will be wasting your time and may corrupt your database in the
process.
You could
look directly in your database and check whether the data in your Group form
matches the data in the group_cache table. If not you will need to reload
the caches.
HTH
David
Sanders Remedy
Solution Architect ==========================
ARS List
Award Winner 2005 Best 3rd
party Remedy Application
tel +44
1494 468980 mobile
+44 7710 377761 email
[EMAIL PROTECTED]
web http://www.westoverconsulting.co.uk
<http://www.westoverconsulting.co.uk/>
|
Title: RE: Notify Action To Group Not Working
