Initial process after building ATHENA on my system?

stkim · October 29, 2019, 1:41pm

I’m a researcher in a lab developing a system works with CDM. To understand vocabulary’s structure and implement a simple search, I installed and ran athena on my local system (including postgresql). I also imported SNOMED v5 and v4.5 vocabulary into my local database for testing. However, when I connect to local athena, the filters on the left are all empty and no search results are returned. There seems to be no vocabulary in the database. Is there anything else I need to do when I install athena on my local system? After importing the vocabulary into the database, it seems to recognize the vocabulary list through initializing.

stkim · November 3, 2019, 4:18pm

In the console, I saw the following exceptions:
“org.apache.solr.client.solrj.SolrServerException: Server refused connection at: http: // localhost: 8984 / solr / concepts”
It seems that I need solr to run athena, and do some setup of solr. What should I do with solr?

acumarav · November 4, 2019, 9:26am

Hello @stkim,

Athena app utilizes Solr to index concepts hierarchy and execute search requests against Solr index. So you need Solr to make Athena working. Vocabularies is stored in the database. In order to build search index Solr reading data directly from the database and Athena query Solr engine with the search queries.

Your steps should be:

Load vocabularies into Postgres database.
Configure Solr and perform data import
Configure Athena to use Solr
Ensure that you can see search results in the Athena UI

You can find Solr configuration in the Athena repository:

Data Import default config is here:

github.com

OHDSI/Athena/blob/master/src/main/resources/solr/solrconfig.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!--
 Licensed to the Apache Software Foundation (ASF) under one or more
 contributor license agreements.  See the NOTICE file distributed with
 this work for additional information regarding copyright ownership.
 The ASF licenses this file to You under the Apache License, Version 2.0
 (the "License"); you may not use this file except in compliance with
 the License.  You may obtain a copy of the License at

     http://www.apache.org/licenses/LICENSE-2.0

 Unless required by applicable law or agreed to in writing, software
 distributed under the License is distributed on an "AS IS" BASIS,
 WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 See the License for the specific language governing permissions and
 limitations under the License.
-->

<!--
     For more details about configurations options that may appear in

This file has been truncated. show original

<str name="config">data-config.xml</str>
….

stkim · November 4, 2019, 3:38pm

Thank you @acumarav for your detailed description.
It seems that the solr app was able to search athena so quickly even with so many vocabularies.

acumarav · November 5, 2019, 10:19am

Yes, initial data import into Solr can lasts around 10 minutes but search should be quick

Chandan_PR · October 22, 2021, 2:35pm

Hi @stkim,

Do you have any link/document for building Athena locally?

I am trying to setup Athena locally and a heads up on that would definitely help a lot.

Thanks,
Chandan