Re: [foxboro] CSA issue
- From: "Boulay, Russ" <Russ.Boulay@xxxxxxxxxxxx>
- To: "foxboro@xxxxxxxxxxxxx" <foxboro@xxxxxxxxxxxxx>
- Date: Tue, 25 Sep 2012 22:39:05 -0400
First thing after the restore of old image....perform a checkpoint of CP's so
at least you have a good checkpoint file that resembles the running CP contents
in case CP was to reboot.
Below is a published solution for fixing CSA.....as to your workfile, if that
is also mismatched that requires more extensive lab system work...
Solution
A quick way to fix mismatches on CSA - CP databases
July 20, 2012
Problem Description
If the CSA (Compound Summary Access) is not in sync and does not match the
database running on the CP, this solution provides the steps to fix it.
Usually the "check_db_sync" utility is used to detect if you have this problem.
NOTES:
Remember to always perform a Checkpoint before running "check_db_sync".
This procedure does not fix mismatches against the database in the workfile.
Fix/Resolution
This is a procedure to have a CSA CP's db that matches exactly the
compound/blocks running on that specific CP.
It was written for Windows. (On Unix, you will have to create the script using
vi, or converting the Notepad-created file to Unix by using utility dos2unix).
NOTE: It doesn't fix anything on the workfile, just the CSA db for the specific
CP.
It uses the command "getpars" to get the compound/block names and types,
directly from the CP, and then convert the output to CSA format.
A. Get compound/block names from CP
This is the basic command to get the compound/block names from the CP:
/opt/fox/bin/tools/getpars -n -UCPLBUG -mCMPNM:%15s -mTYPE:%7
In order to use the result for CSA we need to change the order of columns,
remove some extra lines, etc.
All those changes can be acomplished with this script: "getpars2csa.txt"
-------------------------
#!/bin/sh
cd /opt/fox/bin/tools
getpars -n -U$1 -mCMPNM:%15s -mTYPE:%7s | sed '1,6d' | awk '{printf
"%-13s\t%-13s\t%-13s\n", $2, $1, $3}' | awk '
$1 != Lastcmpd {
Lastcmpd = $1
print $1
}
$1 == Lastcmpd {
printf "%-13s\t%-13s\t%-13s\n", $1, $2, $3 }' > $1
-------------------------
Copy the lines above (between dotted lines) to Notepad and save the file as
"getpars2csa.txt"
Copy the file to the CSA host (preferred), into /opt/fox/bin/tools directory
How to use the script:
Once the script is in /opt/fox/bin/tools, open a command prompt and type:
D:
sh
cd /opt/fox/bin/tools
getpars2csa.txt CPLBUG (Replace CPLBUG with the letterbug of your CP)
The script will create a file named "CPLBUG" in /opt/fox/bin/tools, that can be
used for CSA Merge.
Open that file and verify that starts with the STATION block line and it looks
like this (format):
CP6001_STA
CP6001_STA STATION STA
CP6001_ECB
CP6001_ECB PRIMARY_ECB ECBP
AC_TST001
AC_TST001 AC_IND01 IND
AC_PIDA_TEST
AC_PIDA_TEST AIN1 AIN
AC_PIDA_TEST PIDA1 PIDA
AC_PIDA_TEST AIN2 AIN
AC_PIDA_TEST PIDA2 PIDA
...
B. Remove ALL compound/blocks names from CSA Database, just for that CP
Type:
cd /usr/fox/csa
csa_fn reset CPLBUG
Verify CSA database for that CP, is empty, by typing:
csa_stn_save CPLBUG
It should just show the prompt.
C. CSA Merge:
Create a temporary directory in D: named /opt/tmp/csa_merge
Put the CPLBUG file, for the CP that need to be merged, into that directory.
Then type:
cd /usr/fox/csa
CSA_Merge /opt/tmp/csa_merge
D. Verify CSA has now the database for the CP, by typing:
csa_stn_save CPLBUG
E. Check if that databases are in sync by running
/opt/fox/bin/tools/db_sync/check_db_sync CPLBUG
Copyright (c) 2012 Invensys Syste-----Original Message-----
From: foxboro-bounce@xxxxxxxxxxxxx [mailto:foxboro-bounce@xxxxxxxxxxxxx] On
Behalf Of Leonardo Mercado
Sent: Tuesday, September 25, 2012 6:59 PM
To: foxboro@xxxxxxxxxxxxx
Subject: [foxboro] CSA issue
Dear all,
I have one issue for Compound Summary Access, CSA we got a problem with our
Engineering Workstation hosting the CSA and we restored old image backup, of
course we restored after that our last application backup (disp and liberary ,
etc) but not the CSA folder was not included in our application backup.
Now we have some discrepancies in our CSA specially when we want to add some
points to AIM historian using wizard, all compounds that were downloaded in
between do not show up in AIM compound list and like that can't add bulk points
using the wizard.
Any help to have a clear procedure to synchronize the CSA also the what so
called work file and checkpoint file and CP database
Best Regards,
Leonardo Mercado
_______________________________________________________________________
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
Other related posts:
- » Re: [foxboro] CSA issue - Boulay, Russ
