EPICS Controls Argonne National Laboratory

Experimental Physics and
Industrial Control System

1994  1995  1996  1997  1998  1999  2000  2001  2002  2003  2004  2005  2006  2007  2008  2009  2010  2011  2012  2013  2014  2015  2016  2017  2018  <20192020  2021  2022  2023  2024  Index 1994  1995  1996  1997  1998  1999  2000  2001  2002  2003  2004  2005  2006  2007  2008  2009  2010  2011  2012  2013  2014  2015  2016  2017  2018  <20192020  2021  2022  2023  2024 
<== Date ==> <== Thread ==>

Subject: Phoebus and Archiver Appliance
From: Rory Clarke - UKRI STFC via Tech-talk <[email protected]>
To: "[email protected]" <[email protected]>
Date: Tue, 3 Dec 2019 12:07:59 +0000

Hi,

 

I’m having a problem saving Data Browser plots with Phoebus that contain archived data from the Archiver Appliance. When the plots are saved and reloaded the archived data source will not reconnect.

 

The Archiver Appliance data source is connected using PBRAW as described in the CS Studio documents. This was done with this line in the setup.ini file:

org.csstudio.trends.databrowser3/urls=pbraw://claraserv2.dl.ac.uk:17668/retrieval/

 

Phoebus is started and the Data Browser opened. The archiver panel is opened and the archive path can be seen in the top left panel. A PV can be searched and placed in the data browser and all is well. When the trace is selected in the lower properties panel, the archive source can be seen for that trace.

 

The Data Browser plot is saved as test.plt. This file can be inspected with an editor and the archiver path can be seen in the XML:

 

      <archive>

        <name>pbraw://claraserv2.dl.ac.uk:17668/retrieval/</name>

        <url>pbraw://claraserv2.dl.ac.uk:17668/retrieval/</url>

      </archive>

 

The problem occurs when the Data Browser is restarted and test.plt loaded.  The trace now has no archive listed. From the command line the following is seen:

 

2019-12-03 10:59:17 FINE [sun.awt.windows.WToolkit] Win version: 0x42ee000a = 1122893834 (Windows Vista)

2019-12-03 10:59:17 WARNING [org.csstudio.trends.databrowser3] No archived data for CLA-LLC-VAC-RGA-01:BAR:M12

java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection

        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:774)

 

It seems that ‘org.csstudio.trends.databrowser3’ didn’t find the PV and then Phoebus tried to connect to an SQL database, which is not defined, so fails. This error message sequence is seen three times

 

I suspect that something is stopping the ‘org.csstudio.trends.databrowser3’ reconnecting to the archiver. It is odd as it is the library defined in the settings.ini and there it worked. Could it be that there is another setting that I need to add to settings.ini? I only made it this far by lucky guesses and comparison to CS Studio.

 

Here is some version info:

Windows 10

Phoebus: product-sns-4.6.0 (also the same issue with the general 4.6.0 download)

Java: Oracle 12.0.1+12

JavafX: 13.0.1+1

 

Settings.ini:

# Self-update

org.phoebus.applications.update/current_version=2019-10-04 23:59

org.phoebus.applications.update/update_url=https://controlssoftware.sns.ornl.gov/css_phoebus/nightly/phoebus-$(arch).zip

org.phoebus.pv.ca/addr_list=192.168.83.255 192.168.82.255

org.phoebus.pv.ca/auto_addr_list=false

org.csstudio.trends.databrowser3/urls=pbraw://claraserv2.dl.ac.uk:17668/retrieval/

org.csstudio.display.converter.edm/colors_list=./colors.list

 

 

Regards,

 

Rory Clarke

 


Replies:
Re: Phoebus and Archiver Appliance Kasemir, Kay via Tech-talk

Navigate by Date:
Prev: How to set timeout for reading a pyepics device attribute [SEC=UNOFFICIAL] CORNALL, Terry via Tech-talk
Next: MySQL statement in caMonitor code Aaron Brown via Tech-talk
Index: 1994  1995  1996  1997  1998  1999  2000  2001  2002  2003  2004  2005  2006  2007  2008  2009  2010  2011  2012  2013  2014  2015  2016  2017  2018  <20192020  2021  2022  2023  2024 
Navigate by Thread:
Prev: Re: How to set timeout for reading a pyepics device attribute [SEC=UNOFFICIAL] Matt Newville via Tech-talk
Next: Re: Phoebus and Archiver Appliance Kasemir, Kay via Tech-talk
Index: 1994  1995  1996  1997  1998  1999  2000  2001  2002  2003  2004  2005  2006  2007  2008  2009  2010  2011  2012  2013  2014  2015  2016  2017  2018  <20192020  2021  2022  2023  2024 
ANJ, 03 Dec 2019 Valid HTML 4.01! · Home · News · About · Base · Modules · Extensions · Distributions · Download ·
· Search · EPICS V4 · IRMIS · Talk · Bugs · Documents · Links · Licensing ·