search

ecrin-github / MDR_Aggregator

MIT License
1 stars 0 forks source link

AGGREGATION, failing with: relation "search.new_lexemes" does not exist #3

Open sergiocontrino opened 8 months ago

sergiocontrino commented 8 months ago

see log in F:\MDR_Logs\aggs for 14/1/24 17h ex:

+++++++++++++++++++++++++++++++++++++++
17/01/2024 : 08:42 :   ***ERROR*** In ExecuteSQL; 42P01: relation "search.new_lexemes" does not exist

POSITION: 8, 
SQL was: update search.new_lexemes s
                              set study_json = sj.search_res
                              from search.new_studies_json sj
                              where s.study_id = sj.id  and s.study_id >= 1950001 and s.study_id < 1960001 
+++++++++++++++++++++++++++++++++++++++