# Latest

**URL:** https://discourse.project-emerse.org/latest.md

[Latest](https://discourse.project-emerse.org/latest.md) · [Categories](https://discourse.project-emerse.org/categories.md)

---

## [Welcome to the EMERSE Discussion Group on Discourse](https://discourse.project-emerse.org/t/welcome-to-the-emerse-discussion-group-on-discourse/7)

<div class="topic-metadata">

**Author:** [@system](https://discourse.project-emerse.org/u/system)\
**Replies:** 4\
**Last updated:** [June 17, 2019, 8:43pm UTC](https://discourse.project-emerse.org/t/welcome-to-the-emerse-discussion-group-on-discourse/7 "2019-06-17T20:43:33Z")

</div>

EMERSE is a search engine for clinical documents in electronic health records. The software supports a wide variety of information needs and supports use cases ranging from operations, quality improvement, and research. …

---

## [Weird bug in 6.6.2 with field value groups](https://discourse.project-emerse.org/t/weird-bug-in-6-6-2-with-field-value-groups/114)

<div class="topic-metadata">

**Author:** [@EricMeeks](https://discourse.project-emerse.org/u/EricMeeks)\
**Replies:** 5\
**Last updated:** [April 12, 2024, 6:33pm UTC](https://discourse.project-emerse.org/t/weird-bug-in-6-6-2-with-field-value-groups/114 "2024-04-12T18:33:04Z")

</div>

We have data that matches some of the predefined labels that are groups in the system, but when we import the data it creates a new FIELD\_VALUE instead of using the predefined one. Nothing breaks until I try and group th…

---

## [Emerse-solr-plugin-7.0.0-alpha1.jar returning old stats data](https://discourse.project-emerse.org/t/emerse-solr-plugin-7-0-0-alpha1-jar-returning-old-stats-data/113)

<div class="topic-metadata">

**Author:** [@EricMeeks](https://discourse.project-emerse.org/u/EricMeeks)\
**Replies:** 4\
**Last updated:** [April 12, 2024, 3:38pm UTC](https://discourse.project-emerse.org/t/emerse-solr-plugin-7-0-0-alpha1-jar-returning-old-stats-data/113 "2024-04-12T15:38:54Z")

</div>

Normally this wouldn’t matter, but we had some documents in our index that had ENCOUNTER\_DATE’s that were in the future. It was only 41 in total, and the worst one was in 3017-11-17T00:25:00Z. This breaks EMERSE because…

---

## [Upgrading from 6.3.2 to 6.5.x, there is a gap from 6.3 to 6.4](https://discourse.project-emerse.org/t/upgrading-from-6-3-2-to-6-5-x-there-is-a-gap-from-6-3-to-6-4/111)

<div class="topic-metadata">

**Author:** [@EricMeeks](https://discourse.project-emerse.org/u/EricMeeks)\
**Replies:** 0\
**Last updated:** [August 8, 2023, 6:24pm UTC](https://discourse.project-emerse.org/t/upgrading-from-6-3-2-to-6-5-x-there-is-a-gap-from-6-3-to-6-4/111 "2023-08-08T18:24:12Z")

</div>

From what I see here: Upgrading Guide It shows how to get up to 6.3, and it shows how to get from 6.4 to 6.5, but how do I get from 6.3 to 6.5? Thanks, Eric

---

## [Solution for possible slowness on loading attestation page](https://discourse.project-emerse.org/t/solution-for-possible-slowness-on-loading-attestation-page/110)

<div class="topic-metadata">

**Author:** [@wanggu](https://discourse.project-emerse.org/u/wanggu)\
**Replies:** 0\
**Last updated:** [May 19, 2022, 5:34pm UTC](https://discourse.project-emerse.org/t/solution-for-possible-slowness-on-loading-attestation-page/110 "2022-05-19T17:34:47Z")

</div>

Hi, We recently received a complaint from one of our users that loading attestation page after login took longer time than usual. After some investigation, we realize that this is because the primary key on database tab…

---

## [Need synonyms TSV file for 6.3.2](https://discourse.project-emerse.org/t/need-synonyms-tsv-file-for-6-3-2/108)

<div class="topic-metadata">

**Author:** [@EricMeeks](https://discourse.project-emerse.org/u/EricMeeks)\
**Replies:** 0\
**Last updated:** [April 7, 2022, 7:41pm UTC](https://discourse.project-emerse.org/t/need-synonyms-tsv-file-for-6-3-2/108 "2022-04-07T19:41:31Z")

</div>

We just upgraded from 6.1 to 6.3 and synonyms are no longer showing up in the UI. Looks like we need to update the common synonyms list from a TSV file, but I can’t find it anywhere. Can someone help us out with this? T…

---

## [Example solr queries for obtaining counts for quality assurance](https://discourse.project-emerse.org/t/example-solr-queries-for-obtaining-counts-for-quality-assurance/106)

<div class="topic-metadata">

**Author:** [@daniel.harris](https://discourse.project-emerse.org/u/daniel.harris)\
**Replies:** 4\
**Last updated:** [April 1, 2022, 7:06pm UTC](https://discourse.project-emerse.org/t/example-solr-queries-for-obtaining-counts-for-quality-assurance/106 "2022-04-01T19:06:19Z")

</div>

Does anyone happen to have example solr queries for checking counts on common items like SRC\_SYSTEM? I’d like to double-check what solr contains and what our ETL pushed into it, but the solr query syntax gets a little c…

---

## [Concepts from standardized ontologies](https://discourse.project-emerse.org/t/concepts-from-standardized-ontologies/73)

<div class="topic-metadata">

**Author:** [@dlituiev](https://discourse.project-emerse.org/u/dlituiev)\
**Replies:** 3\
**Last updated:** [February 8, 2022, 7:49pm UTC](https://discourse.project-emerse.org/t/concepts-from-standardized-ontologies/73 "2022-02-08T19:49:51Z")

</div>

Hi EMERSE team, I work with UCSF Information Commons, where we’re using EMERSE for deidentified text exploration. I would like to see if there is interest in using standardized ontologies in this community Our other bi…

---

## [Tuning & server sizing tips needed](https://discourse.project-emerse.org/t/tuning-server-sizing-tips-needed/68)

<div class="topic-metadata">

**Author:** [@EricMeeks](https://discourse.project-emerse.org/u/EricMeeks)\
**Replies:** 2\
**Last updated:** [September 21, 2021, 4:20pm UTC](https://discourse.project-emerse.org/t/tuning-server-sizing-tips-needed/68 "2021-09-21T16:20:04Z")

</div>

We are getting ready to promote our Emerse system to a larger audience, but we are currently suffering from some performance issues. Also, we are now on 6.1 and I’ve noticed that our patient-slave index is empty, but Eme…

---

## [Emerse 6.1.x upgrade question related to DB](https://discourse.project-emerse.org/t/emerse-6-1-x-upgrade-question-related-to-db/66)

<div class="topic-metadata">

**Author:** [@EricMeeks](https://discourse.project-emerse.org/u/EricMeeks)\
**Replies:** 3\
**Last updated:** [August 4, 2021, 4:11pm UTC](https://discourse.project-emerse.org/t/emerse-6-1-x-upgrade-question-related-to-db/66 "2021-08-04T16:11:45Z")

</div>

We’re getting ready to upgrade our system and I noticed that the latest emerse.war file doesn’t have an oracle ODBC driver jar file. Is that ok? I’m new to gradle and I can see that for build/dev it’s helpful to use the…

---

## [500 Internal Server Error that I \*think\* is related to SOLR garbage collection](https://discourse.project-emerse.org/t/500-internal-server-error-that-i-think-is-related-to-solr-garbage-collection/65)

<div class="topic-metadata">

**Author:** [@EricMeeks](https://discourse.project-emerse.org/u/EricMeeks)\
**Replies:** 1\
**Last updated:** [February 18, 2021, 9:57pm UTC](https://discourse.project-emerse.org/t/500-internal-server-error-that-i-think-is-related-to-solr-garbage-collection/65 "2021-02-18T21:57:00Z")

</div>

Any one else see this, and anything to do about it? Happens when moving patients to a temporary list. Sometimes you can just click past it and everything is OK, other times not. And on a maybe related note, what would b…

---

## [Role/privs limited to only uploaded patient lists](https://discourse.project-emerse.org/t/role-privs-limited-to-only-uploaded-patient-lists/64)

<div class="topic-metadata">

**Author:** [@rmcewan](https://discourse.project-emerse.org/u/rmcewan)\
**Replies:** 4\
**Last updated:** [December 9, 2020, 10:26pm UTC](https://discourse.project-emerse.org/t/role-privs-limited-to-only-uploaded-patient-lists/64 "2020-12-09T22:26:11Z")

</div>

Is there a way to create a set of roles/privs (profile) to limit a class of users to search only notes associated with uploaded patient lists? I tried creating a profile with create/edit list privs, but these privs are t…

---

## [Demographics not working sometimes](https://discourse.project-emerse.org/t/demographics-not-working-sometimes/57)

<div class="topic-metadata">

**Author:** [@daniel.harris](https://discourse.project-emerse.org/u/daniel.harris)\
**Replies:** 2\
**Last updated:** [November 16, 2020, 9:37pm UTC](https://discourse.project-emerse.org/t/demographics-not-working-sometimes/57 "2020-11-16T21:37:54Z")

</div>

Sometimes we get an error message when clicking on the demographics section. Attached is a screenshot of the message. My SEX\_CD column of Oracle’s patient table is filled in (only M and F entries). I see the same colum…

---

## [Planned change for the EMERSE interface -- remove "Quick Terms"](https://discourse.project-emerse.org/t/planned-change-for-the-emerse-interface-remove-quick-terms/61)

<div class="topic-metadata">

**Author:** [@hanauer](https://discourse.project-emerse.org/u/hanauer)\
**Replies:** 0\
**Last updated:** [October 28, 2020, 1:51pm UTC](https://discourse.project-emerse.org/t/planned-change-for-the-emerse-interface-remove-quick-terms/61 "2020-10-28T13:51:19Z")

</div>

Planned change to the EMERSE user interface: Remove the “Quick terms” entry screen that allows for free text entry of terms. Background: We currently have three different interfaces for entering terms: Quick Terms: …

---

## [Error saving temp patient list](https://discourse.project-emerse.org/t/error-saving-temp-patient-list/58)

<div class="topic-metadata">

**Author:** [@kevin.hostelley](https://discourse.project-emerse.org/u/kevin.hostelley)\
**Replies:** 2\
**Last updated:** [October 22, 2020, 2:14pm UTC](https://discourse.project-emerse.org/t/error-saving-temp-patient-list/58 "2020-10-22T14:14:58Z")

</div>

When we try to save patients to a temporary list we receive the following error: ERROR: \[2020-10-16T12:02:20,025\] edu.umich.med.emerse.rest.AllPatientSearchController.log()83 StatementCallback; SQL \[insert into patient\_…

---

## [Open JDK and EMERSE](https://discourse.project-emerse.org/t/open-jdk-and-emerse/55)

<div class="topic-metadata">

**Author:** [@sgp6a](https://discourse.project-emerse.org/u/sgp6a)\
**Replies:** 1\
**Last updated:** [October 6, 2020, 7:23pm UTC](https://discourse.project-emerse.org/t/open-jdk-and-emerse/55 "2020-10-06T19:23:28Z")

</div>

Does the current EMERSE version support the latest version of Open JDK

---

## [EMERSE 4.10.7 is released](https://discourse.project-emerse.org/t/emerse-4-10-7-is-released/22)

<div class="topic-metadata">

**Author:** [@hanauer](https://discourse.project-emerse.org/u/hanauer)\
**Replies:** 2\
**Last updated:** [July 29, 2020, 2:09pm UTC](https://discourse.project-emerse.org/t/emerse-4-10-7-is-released/22 "2020-07-29T14:09:19Z")

</div>

EMERSE 4.10.7 has been released! Please contact us directly for the source code or WAR file, sample indexes (if a new install), etc. The documentation has also been updated: http://project-emerse.org/documentation/ind…

---

## [Changing display name of MRN in the UI](https://discourse.project-emerse.org/t/changing-display-name-of-mrn-in-the-ui/49)

<div class="topic-metadata">

**Author:** [@EricMeeks](https://discourse.project-emerse.org/u/EricMeeks)\
**Replies:** 1\
**Last updated:** [May 29, 2020, 7:39pm UTC](https://discourse.project-emerse.org/t/changing-display-name-of-mrn-in-the-ui/49 "2020-05-29T19:39:47Z")

</div>

Is it possible to safely do this? Tried to change it via the DISPLAY\_NAME in the DOCUMENT\_FIELDS table but that didn’t do the trick. Note that we are using de-identified data in our instance, so we don’t have MRN’s in th…

---

## [Search returns no results](https://discourse.project-emerse.org/t/search-returns-no-results/48)

<div class="topic-metadata">

**Author:** [@bront](https://discourse.project-emerse.org/u/bront)\
**Replies:** 4\
**Last updated:** [April 22, 2020, 5:31pm UTC](https://discourse.project-emerse.org/t/search-returns-no-results/48 "2020-04-22T17:31:36Z")

</div>

hi, Emerse is up and running, but search is returning no results. In the top left of the Emerse window, I see the number of patients loaded (1,750), but no luck with search. And there is no on-screen error… just 0 resul…

---

## [Error updating statistics from Admin screen, and system not working actually](https://discourse.project-emerse.org/t/error-updating-statistics-from-admin-screen-and-system-not-working-actually/46)

<div class="topic-metadata">

**Author:** [@EricMeeks](https://discourse.project-emerse.org/u/EricMeeks)\
**Replies:** 6\
**Last updated:** [April 13, 2020, 7:04pm UTC](https://discourse.project-emerse.org/t/error-updating-statistics-from-admin-screen-and-system-not-working-actually/46 "2020-04-13T19:04:45Z")

</div>

We just did our first load of real data, with nearly 4 million patients and about 65 million notes. But… all searches show up empty and emerse claims we have just 2231 patients in the system. PATIENT table and patient in…

---

## [Server architecture](https://discourse.project-emerse.org/t/server-architecture/43)

<div class="topic-metadata">

**Author:** [@bront](https://discourse.project-emerse.org/u/bront)\
**Replies:** 2\
**Last updated:** [April 7, 2020, 1:15pm UTC](https://discourse.project-emerse.org/t/server-architecture/43 "2020-04-07T13:15:36Z")

</div>

hi, I have been working with EMERSE since late last year. I got the software up and running on CentOS7 with the following architecture: Web Server running Apache2 pointing at an App server running Tomcat, Solr, Oracle,…

---

## [Does EMERSE support Oracle 19C?](https://discourse.project-emerse.org/t/does-emerse-support-oracle-19c/42)

<div class="topic-metadata">

**Author:** [@champioj](https://discourse.project-emerse.org/u/champioj)\
**Replies:** 4\
**Last updated:** [February 10, 2020, 9:35pm UTC](https://discourse.project-emerse.org/t/does-emerse-support-oracle-19c/42 "2020-02-10T21:35:12Z")

</div>

Does EMERSE support Oracle 19C? Our database team is asking me if it is ok to upgrade to this version.

---

## [Any advice on the best way to start with an empty/clean Emerse installation?](https://discourse.project-emerse.org/t/any-advice-on-the-best-way-to-start-with-an-empty-clean-emerse-installation/38)

<div class="topic-metadata">

**Author:** [@EricMeeks](https://discourse.project-emerse.org/u/EricMeeks)\
**Replies:** 1\
**Last updated:** [December 12, 2019, 9:44pm UTC](https://discourse.project-emerse.org/t/any-advice-on-the-best-way-to-start-with-an-empty-clean-emerse-installation/38 "2019-12-12T21:44:27Z")

</div>

We currently have the demo data in our Oracle DB and SOLR indexes. We will want this removed before we add real data. Is it easier/safer/better to do a clean install, or to instead just delete the records and data? Clea…

---

## [Troubleshooting Installation](https://discourse.project-emerse.org/t/troubleshooting-installation/30)

<div class="topic-metadata">

**Author:** [@bront](https://discourse.project-emerse.org/u/bront)\
**Replies:** 3\
**Last updated:** [November 4, 2019, 6:28pm UTC](https://discourse.project-emerse.org/t/troubleshooting-installation/30 "2019-11-04T18:28:06Z")

</div>

Hi, I recently installed Emerse and had things working with the sample indexes. Then I tried to move the sample indexes out of the solr directory and into a different directory (still on the same machine) per the follow…

---

## [Liquibase database object creation](https://discourse.project-emerse.org/t/liquibase-database-object-creation/34)

<div class="topic-metadata">

**Author:** [@spm9r](https://discourse.project-emerse.org/u/spm9r)\
**Replies:** 1\
**Last updated:** [October 21, 2019, 2:01pm UTC](https://discourse.project-emerse.org/t/liquibase-database-object-creation/34 "2019-10-21T14:01:58Z")

</div>

I’m looking into using EMERSE with either Postgres or SQL Server rather than Oracle. I’m not very familiar with Liquibase, so this may be a basic question. Would it be possible to use this tool with the ChangeSet files …

---

## [Small java change to support Shibboleth integration](https://discourse.project-emerse.org/t/small-java-change-to-support-shibboleth-integration/28)

<div class="topic-metadata">

**Author:** [@EricMeeks](https://discourse.project-emerse.org/u/EricMeeks)\
**Replies:** 0\
**Last updated:** [August 30, 2019, 8:12pm UTC](https://discourse.project-emerse.org/t/small-java-change-to-support-shibboleth-integration/28 "2019-08-30T20:12:49Z")

</div>

The shibboleth integration for SSO was fairly straightforward. Mostly just adding a bunch of beans into the security.xml. No new classes are required, you can use ones that Spring provides. However, we did have to alter…

---

## [Is it safe to expand LOGIN\_ACCOUNT.CREATED\_BY column?](https://discourse.project-emerse.org/t/is-it-safe-to-expand-login-account-created-by-column/27)

<div class="topic-metadata">

**Author:** [@EricMeeks](https://discourse.project-emerse.org/u/EricMeeks)\
**Replies:** 2\
**Last updated:** [August 30, 2019, 8:06pm UTC](https://discourse.project-emerse.org/t/is-it-safe-to-expand-login-account-created-by-column/27 "2019-08-30T20:06:02Z")

</div>

We’ve added Shibboleth login to Emerse, using our EPPN for the Login ID within Emerse. However, our EPPN’s are 15 characters long, and while that works for standard login, it creates this issue when we try and add new us…

---

## [Having issues getting websockets to work behind apache](https://discourse.project-emerse.org/t/having-issues-getting-websockets-to-work-behind-apache/26)

<div class="topic-metadata">

**Author:** [@EricMeeks](https://discourse.project-emerse.org/u/EricMeeks)\
**Replies:** 1\
**Last updated:** [August 15, 2019, 8:08pm UTC](https://discourse.project-emerse.org/t/having-issues-getting-websockets-to-work-behind-apache/26 "2019-08-15T20:08:11Z")

</div>

We use Apache httpd on the front end, handling https/cert stuff and then using AJP to proxy to Tomcat. Fairly common setup. However, with 4.10.x it seems that spring websockets are being used by Emerse, and we have not b…

---

## [EMERSE Search tips?](https://discourse.project-emerse.org/t/emerse-search-tips/13)

<div class="topic-metadata">

**Author:** [@doran.steele](https://discourse.project-emerse.org/u/doran.steele)\
**Replies:** 1\
**Last updated:** [June 17, 2019, 6:18pm UTC](https://discourse.project-emerse.org/t/emerse-search-tips/13 "2019-06-17T18:18:15Z")

</div>

Does anyone have any suggestions for best practices for this resource?