Re: Questions about Data browser in CSS

["Kasemir, Kay" <kasemirk@ornl.gov>]

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: tech-talk-bounces@aps.anl.gov <tech-talk-bounces@aps.anl.gov> on behalf of lzf neu <lzfneu@live.com>
Sent: Thursday, August 11, 2016 11:54 AM
To: tech-talk@aps.anl.gov
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