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  <20162017  2018  2019  2020  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  <20162017  2018  2019  2020  2021  2022  2023  2024 
<== Date ==> <== Thread ==>

Subject: Re: Questions about Data browser in CSS
From: "Kasemir, Kay" <[email protected]>
To: lzf neu <[email protected]>, "[email protected]" <[email protected]>
Date: Thu, 11 Aug 2016 16:08:22 +0000


Check the settings for org.csstudio.archive.reader.rdb that you have in your product's plugin customization file.


You probably have 


 

org.csstudio.archive.reader.rdb/use_stored_procedure=archive.get_browser_data


so "optimized" requests try to use that stored procedure, but you didn't actually install that stored procedure in MySQL.


Set it to empty

org.csstudio.archive.reader.rdb/use_stored_procedure=
so the "optimized" request just gets raw data and then does some decimation on the client side.

In the org.csstudio.archive.reader.rdb source code,
https://github.com/ControlSystemStudio/cs-studio/tree/master/applications/archive/archive-plugins/org.csstudio.archive.reader.rdb

see comments in preferences.ini and also the example rdb_procs

-Kay



From: [email protected] <[email protected]> on behalf of lzf neu <[email protected]>
Sent: Thursday, August 11, 2016 11:54 AM
To: [email protected]
Subject: Questions about Data browser in CSS
 

hi all,


  In CSS, my data browser can't receive history data from mysql archive data source, but can only display live data in optimized data mode; however, data browser can receive history data in raw data mode from mysql data source. I don't know what's wrong.


My settings in CSS are as follows:

  Archive Data Server URL:   jdbc:mysql://localhost:3306/archive 

  Server Alias: DCLS-TCQ


  Default Archive Data Sources:   jdbc:mysql://localhost:3306/archive

  Name: DataSource


My settings in .bashrc are as follows:

  EPICS_CA_AUTO_ADDR_LIST=NO

  EPICS_CA_ADDR_LIST=192.168.1.255


 Any help will be appreciated and thanks in advance.


Zhefu



References:
Questions about Data browser in CSS lzf neu

Navigate by Date:
Prev: EGU field length vs. Channel Access protocol Kasemir, Kay
Next: Re: EPICS 3.15 good for production use? J. Lewis Muir
Index: 1994  1995  1996  1997  1998  1999  2000  2001  2002  2003  2004  2005  2006  2007  2008  2009  2010  2011  2012  2013  2014  2015  <20162017  2018  2019  2020  2021  2022  2023  2024 
Navigate by Thread:
Prev: Questions about Data browser in CSS lzf neu
Next: EGU field length vs. Channel Access protocol Kasemir, Kay
Index: 1994  1995  1996  1997  1998  1999  2000  2001  2002  2003  2004  2005  2006  2007  2008  2009  2010  2011  2012  2013  2014  2015  <20162017  2018  2019  2020  2021  2022  2023  2024 
ANJ, 11 Aug 2016 Valid HTML 4.01! · Home · News · About · Base · Modules · Extensions · Distributions · Download ·
· Search · EPICS V4 · IRMIS · Talk · Bugs · Documents · Links · Licensing ·