Re: [foxboro] Historical Alarms

  • From: "Easley, Jack" <Jack.Easley@xxxxxxxxxxxx>
  • To: "foxboro@xxxxxxxxxxxxx" <foxboro@xxxxxxxxxxxxx>
  • Date: Mon, 19 Dec 2011 13:12:43 -0600

Russ,

We are at AIM 3.2 and cannot update at this time. Were there issues with "Too 
Many Alarms" and "Maximum number of alarms historized" being set to 40000 that 
you are aware of, and if so will setting this back to 5000 possibly help us in 
the interim? We would prefer fewer alarms in the Alarm History GUI to none.

Thanks in advance,

Jack Easley
Sr. I&C Technician
Luminant Power, Martin Lake Plant
Phone 903.836.6290
jack.easley@xxxxxxxxxxxx

-----Original Message-----
From: foxboro-bounce@xxxxxxxxxxxxx [mailto:foxboro-bounce@xxxxxxxxxxxxx] On 
Behalf Of Boulay, Russ
Sent: Monday, December 19, 2011 1:03 PM
To: foxboro@xxxxxxxxxxxxx
Subject: Re: [foxboro] Historical Alarms

Jack,

The latest AMS QFs should take care of the issue of too many alarms. You 
shouldn't have to archive any more, and the aht.exe and AHD should be much more 
stable. Should be able to retrieve and display 40,000 alarms in 10-15 seconds. 

AIM 3.3 QF's as well as a CAD QF depending on the I/A version

I will comment that there are still issues with certain topologies like off 
platform instances and collectors..as networking plays a part in retrieving 
such amount of data in a timely manner...

-----Original Message-----
From: foxboro-bounce@xxxxxxxxxxxxx [mailto:foxboro-bounce@xxxxxxxxxxxxx] On 
Behalf Of Easley, Jack
Sent: Monday, December 19, 2011 6:55 AM
To: foxboro@xxxxxxxxxxxxx
Subject: Re: [foxboro] Historical Alarms

I have a 5th option that we prefer to use. Again, it somewhat a klutzy DOS 
based Foxboro utility, but I prefer it over histspy. Below are my notes on its 
use.
I would wait to hear Russ's response to my request before changing wp_am.cfg, 
as we have wp_am.cfg set for 40,000 and do have problems with "Too Many Alarms" 
error (no Alarms shown) on the Alarm History Display, which requires 
initializing all historical data (not just alarms) once you ever gets this 
error message on the Alarm History display.

Dumping Aim historian data: This gets all historical alarms (not just Alarm 
History display alarms) as well as SysMon & OAJ messages if you wish.
Call up  a DOS box
sh
cd /opt/aim/bin
apitst
711
Y (to dump to file)
historian name
Output File (default is msg.txt but you can name whatever you wish) start date 
start time Accept Y end date  or NOW end time (if not NOW) for filter, see list 
below but *:* is easiest and you can filter the text file later.
OK to add Y Enter
To get of apitst, Enter -1 twice.
msg.txt file (or filename you entered) will be created in /opt/aim/inst/his## 
directory or maybe sometimes in /opt/aim/bin directory, or in D:/ directory. I 
have found it all three places so you may have to search for it.
Use Wordpad instead of Notepad to open it.

FILTERS:
*:*  for everything. Sometimes it is just best to dump it all and filter it 
later, as I've had a few problems trying to use filters.
iaalarm:*
legacy:sysmonmsg
FOXCTS:OAJMSG (Must be used on AIM Historians configured to capture OAJ 
messages only, may not be all AIM Historians)

Jack Easley
Sr. I&C Technician
Luminant Power, Martin Lake Plant
Phone 903.836.6290
jack.easley@xxxxxxxxxxxx

-----Original Message-----
From: foxboro-bounce@xxxxxxxxxxxxx [mailto:foxboro-bounce@xxxxxxxxxxxxx] On 
Behalf Of Lowell, Timothy
Sent: Saturday, December 17, 2011 10:30 AM
To: foxboro@xxxxxxxxxxxxx
Subject: Re: [foxboro] Historical Alarms

Francisco,

You have four options to get the rest of the alarms out of AIM*:

1. Use histspy. This utility is in d:/opt/aim/bin. It is very non-intuitive and 
hard to use, and the output is difficult to read, but if you can figure out how 
it works, it will generate alarm data. I believe there is a tutorial on the 
Invensys site or the Cassandra site somewhere, but I'm not sure where.

2. Write some Excel VBA code. AIM* comes with one ODBC license. You need to 
configure that, and then on some off-platform PC that is connected to your I/A 
system by the third/fourth Ethernet port, you need to configure an ODBC 
connection. Excel Visual Basic for Applications has built-in ODBC calls that 
can be programmed to retrieve data from the AIM*Historian. I have done this, 
but not recently, and I don't have access to the code. There is some sample 
code in the Appendices of the AIM*Historian Administrators Guide, I believe.

3. Buy some more software. Invensys sells some data extraction products for 
AIM*. PAS in Houston, Matrikon (now part of Honeywell), TiPS, Inc, LimeWare 
from Brazil and many other third party vendors will sell you software to manage 
your alarms. Most of these will require you to purchase an AIM*OPC server 
license from Invensys (or a third party OPC server) with the appropriate server 
hardware as well the vendor's software and appropriate server hardware to run 
that. Obviously, this option is for when you have a plant or company alarm 
management philosophy in place and you have enough funding to implement it 
correctly.

4. Contact some of the folks on this list who have built their own alarm 
management solutions. I've seen several on here that run small applications to 
send their alarms to various open-source SQL databases. You can search the 
archives at //www.freelists.org/archive/foxboro.

We've been complaining to Invensys forever about the inability to extract data 
from AIM*. Invensys has chosen to discontinue development of AIM* and focus on 
Wonderware InSQL as the historian of the future, but from what I've heard, 
InSQL does not historize alarm data from the Foxboro I/A system either. For 
that, you still need AIM* (or a third-party).

Thanks,
Tim
________________________________________
From: foxboro-bounce@xxxxxxxxxxxxx [foxboro-bounce@xxxxxxxxxxxxx] On Behalf Of 
Francisco Hernandez [francisco.27.hernandez@xxxxxxxxx]
Sent: Saturday, December 17, 2011 9:04 AM
To: foxboro@xxxxxxxxxxxxx
Subject: [foxboro] Historical Alarms

Hi Everyone,


The Aim Historian Message Collector is configured in a P90 Host v8.6, so the 
Process Alarms are been historicized. If I wish see the historian alarm I open 
the Alarm History (AHD) in the Alarm Manager (CAD) Window. But it only show the 
last 5000 Alarms. Actually the AIM Historian is Historicizing the last 3 month 
of messages (Process Alarmas), Somebody know How Can I to view the whole 
historian alarms, not only the last 5000?



Thanks!





 
 
_______________________________________________________________________
This mailing list is neither sponsored nor endorsed by Invensys Process Systems 
(formerly The Foxboro Company). Use the info you obtain here at your own risks. 
Read http://www.thecassandraproject.org/disclaimer.html
 
foxboro mailing list:             //www.freelists.org/list/foxboro
to subscribe:         mailto:foxboro-request@xxxxxxxxxxxxx?subject=join
to unsubscribe:      mailto:foxboro-request@xxxxxxxxxxxxx?subject=leave
 


Confidentiality Notice: This email message, including any attachments, contains 
or may contain confidential information intended only for the addressee. If you 
are not an intended recipient of this message, be advised that any reading, 
dissemination, forwarding, printing, copying or other use of this message or 
its attachments is strictly prohibited. If you have received this message in 
error, please notify the sender immediately by reply message and delete this 
email message and any attachments from your system. 

 
 
_______________________________________________________________________
This mailing list is neither sponsored nor endorsed by Invensys Process
Systems (formerly The Foxboro Company). Use the info you obtain here at
your own risks. Read http://www.thecassandraproject.org/disclaimer.html
 
foxboro mailing list:             //www.freelists.org/list/foxboro
to subscribe:         mailto:foxboro-request@xxxxxxxxxxxxx?subject=join
to unsubscribe:      mailto:foxboro-request@xxxxxxxxxxxxx?subject=leave
 


*** Confidentiality Notice: This e-mail, including any associated or attached 
files, is intended solely for the individual or entity to which it is 
addressed. This e-mail is confidential and may well also be legally privileged. 
If you have received it in error, you are on notice of its status. Please 
notify the sender immediately by reply e-mail and then delete this message from 
your system. Please do not copy it or use it for any purposes, or disclose its 
contents to any other person. This email comes from a division of the Invensys 
Group, owned by Invensys plc, which is a company registered in England and 
Wales with its registered office at 3rd Floor, 40 Grosvenor Place, London, SW1X 
7AW (Registered number 166023). For a list of European legal entities within 
the Invensys Group, please go to http://www.invensys.com/en/legal/default.aspx.

You may contact Invensys plc on +44 (0)20 3155 1200 or e-mail 
reception@xxxxxxxxxxxxx This e-mail and any attachments thereto may be subject 
to the terms of any agreements between Invensys (and/or its subsidiaries and 
affiliates) and the recipient (and/or its subsidiaries and affiliates).


 
 
_______________________________________________________________________
This mailing list is neither sponsored nor endorsed by Invensys Process
Systems (formerly The Foxboro Company). Use the info you obtain here at
your own risks. Read http://www.thecassandraproject.org/disclaimer.html
 
foxboro mailing list:             //www.freelists.org/list/foxboro
to subscribe:         mailto:foxboro-request@xxxxxxxxxxxxx?subject=join
to unsubscribe:      mailto:foxboro-request@xxxxxxxxxxxxx?subject=leave
 


Confidentiality Notice: This email message, including any attachments, 
contains or may contain confidential information intended only for the 
addressee. If you are not an intended recipient of this message, be advised 
that any reading, dissemination, forwarding, printing, copying or other use of 
this message or its attachments is strictly prohibited. If you have received 
this message in error, please notify the sender immediately by reply message 
and delete this email message and any attachments from your system. 

 
 
_______________________________________________________________________
This mailing list is neither sponsored nor endorsed by Invensys Process
Systems (formerly The Foxboro Company). Use the info you obtain here at
your own risks. Read http://www.thecassandraproject.org/disclaimer.html
 
foxboro mailing list:             //www.freelists.org/list/foxboro
to subscribe:         mailto:foxboro-request@xxxxxxxxxxxxx?subject=join
to unsubscribe:      mailto:foxboro-request@xxxxxxxxxxxxx?subject=leave

Other related posts:

  1. Home
  2. foxboro
  3. Archive
  4. 12-2011