John, it looks like you ahve 2 problems:
- invalid object name ‘OMOP_Achilles.dbo.achilles_result_concept_count’: The name
OMOP_ACHILLES.dbo
seems like an odd name for the results schema but if that’s where your results schema is, that’s fine. We’ve had other questions on the forums about where theachilles_result_concept_count
table comes from, you should be able to search for it and find guidance where it is comming from. - OutOfMemoryError : Looks like you need to configure your environment to increasse the heapsize. The WebAPI process attempts to cache the vocabulary record counts in memory to make the row counts faster, but it does eat up a lot of memory. I suggest increating your heap size to at least 4GB.
Edit:
The answer to the first problem is here:
-Chris