Comments (4)
The sql error file says that it is a syntax error for SELECT * FROM #exposure_cohorts;
but r error file says it is a type matching issue, that two error reports do not seem to make sense when they are put together.
We are using postgreSQL
from legendt2dm.
can we solve it this way but how to we solve it for LegendT2DM script?
https://stackoverflow.com/questions/63997315/union-types-text-and-bigint-cannot-be-matched
from legendt2dm.
assessmentLog.txt
2022-01-13 18:19:06 [Main thread] INFO CohortDiagnostics createConceptCountsTable Creating internal concept counts table
is the last line before it hits the designated error.
from legendt2dm.
@lofung -- a colleague recently tried the LEGEND-T2DM study code against an postgresql database, and everything appears to work. My best guess is that your tables do not follow the OMOP CDM 5.3 specification. One of these requirements is that cdm_source
cannot be null. You can find the specification here (https://github.com/ohdsi/commondatamodel)
The LEGEND-T2DM package depends on many OHDSI packages. So narrowing now your format issues using LEGEND is probably not the easiest. I'd recommend first running something like DataQualityDashboard
and a small characterization study first.
from legendt2dm.
Related Issues (14)
- Warning: 8 parsing failures. - actual columns less than expected. HOT 4
- ERROR: operator does not exist: character varying = bigint Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts. HOT 1
- Instructions and CodeToRun.R use undefined `oracleTempSchema` HOT 1
- Warning: All coefficients (except maybe the intercept) are zero. Either the covariates are completely uninformative or completely predictive of the treatment. Did you remember to exclude the treatment variables from the covariates? HOT 1
- SQL error while running `assessPropensityModels()` HOT 2
- Warning: failed to find binary for 'XXXXX' in package repositories HOT 1
- Quota limits in GBQ while generating LEGEND cohorts HOT 5
- Error while initializing environment - "revocation server was offline"
- Broken HTML protocol HOT 1
- Negative control list needs finalization
- Add LegendT2dm to renv.lock HOT 3
- Error: '' does not exist in current working directory HOT 1
- R Version Clarification HOT 4
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from legendt2dm.