Failed to create delta from `v20240229` to v20240830[Current]

Vocabulary Users
1

Hi,
I am new to OMOP-CDM and I am trying to setup the omop-cdm database as part of exploratory work held by my company. I downloaded vocabulary v20240229 from https://athena.ohdsi.org/ and imported to the database using psql /copy. Now I want to upgrade to v20240830, I am trying to create a delta with all vocabularies from with the updates from v20240229 to v20240830. Unfortunately when I try to generate the delta via athena, I get this error: The Delta bundle could not be generated for the CPT4 vocabulary. It works if I remove CPT4 from the delta generation.

Thanks,

2

I’m trying to update my version from v20240830 to v20250227 with delta. Is this issue still going? Do you know where we can find the delta.sql? auto generated email suggested to use delta.sql, but having issue finding the script.

thanks,

  1. If you want to upgrade your existing Vocabulary tables using the SQL script:
  2. Make sure you selected the correct release version prior to initiating the download.
  3. Execute the delta.sql script.
3

Hi,

You can find delta.sql file in the downloaded archive together with the vocabulary bundle:

image
image1142×915 30.9 KB

4

found it! thanks!