Re: Question about retrieve history data in archiver appliance

[neu lzf via Tech-talk <tech-talk at aps.anl.gov>]

Hi,

Thanks for your reply. Unfortunately I still cannot get the history data of PV by using Control System Studio (CSS) without running the IOC, let me describe my starting steps in detail.

I am new to use archiver appliance, my test contains two steps: first, I run my IOC and archive appliance program to archive the data of PV; then I shut down my IOC and restart the archive appliance program and try to get the history data of the PV from database by using CSS.

The first step:
a) Start the program and archive the data of the PV
I successfully start the archiver appliance with the command: 
./quickstart.sh apache-tomcat-9.0.52.tar.gz

The host name of my computer is 'test'. After running the IOC, I successfully archive the PV data by filling in the URL in browser:
http://test:17665/mgmt/ui/index.html
and then press the Archive button. After a while, the live data curve of the PV can be seen by EPICS Archiver Appliance Viewer.

b) Get live data by using CSS:
 According to the user guide, I replace the string 'http' with the string 'pbraw' in appliances.xml, namely this line: <data_retrieval_url>http://localhost:17665/retrieval</data_retrieval_url>

Therefore, in the databrowser of CSS, according to the user guide, the 'Archive Data Server URLs' and 'Default Archive Data Sources' I filled in is:
pbraw://localhost:17665/retrieval
CSS can also successfully draw the live and history data curve by dragging the PV name from Archive Search column to Data Browser.



The second step and the problem is:
c) If I shut down my IOC and restart the data archive appliance program and try to use CSS to retrieve the history data of the PV without running the IOC (offline).

The database server can be connected successfully by CSS with the URL:
pbraw://localhost:17665/retrieval

However, when search the PV name in CSS, there is no available PV name listed in Archive Search column. I still cannot get and draw the history data curve of the PV.
Do I miss some steps?

Any help will be appreciated and thank you again.

---

From: Tech-talk <tech-talk-bounces at aps.anl.gov> on behalf of Shankar, Murali via Tech-talk <tech-talk at aps.anl.gov>
Sent: 17 August 2021 18:09
To: tech-talk at aps.anl.gov <tech-talk at aps.anl.gov>
Subject: Re: Question about retrieve history data in archiver appliance

 

>> I intend to retrieve history data of some PV without running the IOC (offline), is it possible to implement that in archiver appliance.

Yes; this should be just fine. 

>> I have no idea how to retrieve the history data of some PV without running the IOC

You should not have to do anything at all. Please check the use guide at https://slacmshankar.github.io/epicsarchiver_docs/userguide.html. For debugging, I usually find it simpler to start using something like curl to see what's going in. You can construct a retrieval URL and then use curl to retrieve the data using a .txt mime type. 

Hope that helps.

Regards,

Murali