search

OHDSI / CommonDataModel

Definition and DDLs for the OMOP Common Data Model (CDM)
https://ohdsi.github.io/CommonDataModel
896 stars 451 forks source link

ERAs tables Memory issue #372

Closed Carlogo815 closed 3 years ago

Carlogo815 commented 4 years ago

Hi!

We are working on the mapping of our database to the OMOP CDM. We have been able to run all the ETLs designed, but when executing the ERA ones (taken from https://ohdsi.github.io/CommonDataModel/sqlScripts.html) we run into this error:

"(74360397 rows affected) Mens 1101, Level 17, State 10, Procedure dbo.CREATE_DRUG_ERA, Line 44 A new page could not be allocated for database 'TEMPDB' because filegroup 'DEFAULT' has insufficient disk space. Remove objects from the filegroup, add additional files to the filegroup, or set the auto-grow option for existing files in the filegroup to create the necessary space."

Condition_occurrence and drug_exposure are populated. We have a similar problem when running condition_era. Has any of you found the same issue? If so, how to solve it?

Thanks a lot! :)

clairblacketer commented 3 years ago

Hi @Carlogo815 I moved your question over to the OHDSI forums as I think you will get more responses to your question over there.