Not recognizing concept_table in orphan concepts SQL when running on CPRD

[cebarboza]

@edward-burn This sql script is not recognizing concept_table on CPRD, which uses postgresql, same as IPCI.

Error in `.createErrorReport()`:
! Error executing SQL:
org.postgresql.util.PSQLException: ERROR: relation "concept_counts" does not exist
  Position: 324
An error report has been created at  C:/Users/eburn/Downloads/CohortDiagnosticsData-main/CohortDiagnosticsData-main/errorReportSql.txt

And here is the report:

DBMS:
postgresql

 

Error:
org.postgresql.util.PSQLException: ERROR: relation "concept_counts" does not exist
  Position: 324

 

SQL:
CREATE TEMP TABLE orphan_concepts
AS
SELECT
DISTINCT 1 as codeset_id,
  c1.concept_id,
    c1.concept_count,
    c1.concept_subjects
FROM
(
    SELECT c1.concept_id,
        c1.concept_name,
        a1.concept_count,
        a1.concept_subjects
    FROM public.concept c1
    LEFT JOIN starting_concepts sc1
        ON c1.concept_id = sc1.concept_id
    INNER JOIN concept_counts a1
        ON c1.concept_id = a1.concept_id
    WHERE sc1.concept_id IS NULL
    ) c1
INNER JOIN search_string_subset ss1
    ON LOWER(c1.concept_name) LIKE CONCAT (
            '%',
            ss1.concept_name,
            '%'
            )

 

R version:
R version 4.2.1 (2022-06-23 ucrt)

 

Platform:
x86_64-w64-mingw32

 

Attached base packages:
- stats
- graphics
- grDevices
- utils
- datasets
- methods
- base

 

Other attached packages:
- here (1.0.1)
- Eunomia (1.0.2)
- CohortBenchmark (0.1.0)
- CohortDiagnostics (3.1.2)
- FeatureExtraction (3.2.0)
- Andromeda (0.6.3)
- dplyr (1.1.2)
- DatabaseConnector (6.2.0)

[ginberg]

@edward-burn and @cbarbozaerasmus, do we have the complete script that leads to this error?