Re: [foxboro] RV: Operator Action Journal

Hi EFX
If you are using the legacy historian, it has to do with using AIM.

/usr/fox/disp_tools has a script file called oajgen.
When AIM* data link is installed the references to sacego are changed 
to fh_sacego. 
If you have another AW you can get the old oajgen from there.

If this is not the problem, let me know. 
I've included the listings of the two versions of oajgen below. 

Regards 
Stan 
   Stan Abbot -- Customer Satisfaction Center
 -- Mail Stop B52-AA, 33 Commercial St., Foxborough, MA 02035 USA
 -- 1-866-746-6477
 -- (0101) 508-549-2424 (Outside USA)
 -- 1-508-549-4492  (Fax)

----------------------------------------------------------------------- 
OLD (legacy historian) 


4APB01# cat oajgen 
#!/bin/sh 
# %W% oajgen 16.1 %G% 
# 
# Generate an OPERATOR ACTION JOURNAL REPORT 
# optionally sending the complete report to the printer 
# 
# This script expects 7 positional arguments: 
# 1 filename to create (ACE report) 
# 2 historian (database) name 
# 3 filter for station name (letterbug) 
# 4 filter for compound name 
# 5 filter for block name 
# 6 start time (yyyy-mm-dd hh:mm) 
# 7 end time (yyyy-mm-dd hh:mm) 
# 8 (optional) output device name 
# 
# 18-Jun-89 NEC 
# 25-Aug-89 TDL - put '#' on first line 
# 28-Mar-91 MFM - put '#!/bin/sh' on first line 
# 03-Jan-92 NEC - AP50: informix directories now in /opt... 
# sacego arg -q is now -s 
# in "lp" cmd move filename arg to end 
# 26 Feb 1998 DRM start and end times now expect 4-digit years 
# 
PATH=$PATH:/opt/informix/bin 
INFORMIXDIR=/opt/informix 
DBPATH=/usr/fox/hstorian/bin 
export INFORMIXDIR DBPATH PATH 
script="/usr/foxbin/oaj" 
outfile=/usr/tmp/`basename $1`.tmp 
rm -f $1 
sacego -s -d "$2" $script "$3" "$4" "$5" "$6" "$7" > $outfile 
mv $outfile $1 
if [ $# -eq 8 ] 
then 
lp -o-t -d$8 $1 
fi 





----------------------------------------------------------------------- 
NEW (aim historian) 


3AWE01# more oajgen 
#!/bin/sh -x 
# %W% oajgen 16.1 %G% 
# 
# Generate an OPERATOR ACTION JOURNAL REPORT 
# optionally sending the complete report to the printer 
# 
# This script expects 7 positional arguments: 
# 1 filename to create (ACE report) 
# 2 historian (database) name 
# 3 filter for station name (letterbug) 
# 4 filter for compound name 
# 5 filter for block name 
# 6 start time (yyyy-mm-dd hh:mm) 
# 7 end time (yyyy-mm-dd hh:mm) 
# 8 (optional) output device name 
# 
# 18-Jun-89 NEC 
# 25-Aug-89 TDL - put '#' on first line 
# 28-Mar-91 MFM - put '#!/bin/sh' on first line 
# 03-Jan-92 NEC - AP50: informix directories now in /opt... 
# sacego arg -q is now -s 
# in "lp" cmd move filename arg to end 
# 26 Feb 1998 DRM start and end times now expect 4-digit years 
# 
PATH=$PATH:/opt/informix/bin 
INFORMIXDIR=/opt/informix 
DBPATH=/usr/fox/hstorian/bin 
export INFORMIXDIR DBPATH PATH 
script="/usr/foxbin/oaj" 
outfile=/usr/tmp/`basename $1`.tmp 
rm -f $1 

/usr/fox/disp_tools/fh_sacego $1 "$2" "$3" "$4" "$5" "$6" "$7" 
#sacego -s -d "$2" $script "$3" "$4" "$5" "$6" "$7" > $outfile 
#mv $outfile $1 
if [ $# -eq 8 ] 
then 
lp -o-t -d$8 $1 
fi 


   Stan Abbot -- Customer Satisfaction Center
 -- Mail Stop B52-AA, 33 Commercial St., Foxborough, MA 02035 USA
 -- 1-866-746-6477
 -- (0101) 508-549-2424 (Outside USA)
 -- 1-508-549-4492  (Fax)


-----Original Message-----
From: foxboro-bounce@xxxxxxxxxxxxx
[mailto:foxboro-bounce@xxxxxxxxxxxxx]On Behalf Of Esteban Xandri
Sent: Monday, August 23, 2004 9:48 AM
To: FoxboroIA-List
Subject: [foxboro] RV: Operator Action Journal


Having no answers at all, I'll try one more time before I give up with OAJ.
Does anybody know what this "Fatal error on fh_FdbMsgQuery" means or what is
the error code -1?
The AW5101.oaj file generated only shows these 7 lines and no record at all
of operations done on the AW5101 station.

Historian  = hist01
Start Time = 1970-01-01 00:00 (822222222)
End Time   = 2037-12-31 23:59 (2145916740)
Station    = *
Compound   = *
Block      = *
Fatal error on fh_FdbMsgQuery, error = -1

Regards
EFX

-----Mensaje original-----
De: foxboro-bounce@xxxxxxxxxxxxx [mailto:foxboro-bounce@xxxxxxxxxxxxx]En
nombre de Esteban Xandri
Enviado el: viernes, 06 de agosto de 2004 10:44
Para: FoxboroIA-List
Asunto: [foxboro] Operator Action Journal


I'm trying to run the Operator Action Journal on a AW51B. The app works fine
when I direct the report to the LP00 printer, but when I leave the historian
enabled and create a report to a file (AW5101.oaj), I only get:

Historian  = hist01
Start Time = 1970-01-01 00:00 (822222222)
End Time   = 2037-12-31 23:59 (2145916740)
Station    = *
Compound   = *
Block      = *
Fatal error on fh_FdbMsgQuery, error = -1

Funny thing is that I can recall that OAJ was working fine 2 years ago, but
have no idea what is going on now

Thanks in advance.
EFX




_______________________________________________________________________
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:             http://www.freelists.org/list/foxboro
to subscribe:         mailto:foxboro-request@xxxxxxxxxxxxx?subject=join
to unsubscribe:      mailto:foxboro-request@xxxxxxxxxxxxx?subject=leave



 
 
_______________________________________________________________________
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:             http://www.freelists.org/list/foxboro
to subscribe:         mailto:foxboro-request@xxxxxxxxxxxxx?subject=join
to unsubscribe:      mailto:foxboro-request@xxxxxxxxxxxxx?subject=leave

Other related posts: