Comments (9)
DXVER column should exists in following tables:
1)FACILITY_HEADER
2)INPATIENT_ADMISSIONS
3)INPATIENT_SERVICES
4)OUTPATIENT_SERVICES
from etl-cdmbuilder.
How old is your copy of Truven?
This was a new addition that helps you know the difference between a record with ICD9s (DXVER=9) or ICD10s (DXVER=0). DXVER was added in the 2015 data year, so everything 2014 and prior can be assumed to be DXVER=9. An easy fix would be to create the column and set it all to 9 (assuming your data is older).
from etl-cdmbuilder.
Thank you for the response. Adding DXVER column to the tables (FACILITY_HEADER, INPATIENT_ADMISSIONS, INPATIENT_SERVICES, OUTPATIENT_SERVICES) solved the error - "Invalid column name 'DXVER' ", but I am still getting the error related to 'mscorlib' (Type: System.AggregateException and Type: System.NullReferenceException)
I am using the following builder settings:
Vendor: Truven CCAE v5
Number of batches: 1
Batch Size: 1000
MaxDegreeOfParallelism: 1
Could you please tell me if I need to do any change in the above parameters to fix this error?
Builder: MUSE1
Time: Oct 12 2016 4:30PM
Error: Exception Found:
Type: System.AggregateException
Message: One or more errors occurred.
Source: mscorlib
Stacktrace: at System.Threading.Tasks.Task.ThrowIfExceptional(Boolean includeTaskCanceledExceptions)
at System.Threading.Tasks.Task.Wait(Int32 millisecondsTimeout, CancellationToken cancellationToken)
at System.Threading.Tasks.Parallel.PartitionerForEachWorker[TSource,TLocal](Partitioner`1 source, ParallelOptions parallelOptions, Action`1 simpleBody, Action`2 bodyWithState, Action`3 bodyWithStateAndIndex, Func`4 bodyWithStateAndLocal, Func`5 bodyWithEverything, Func`1 localInit, Action`1 localFinally)
at System.Threading.Tasks.Parallel.ForEachWorker[TSource,TLocal](IEnumerable`1 source, ParallelOptions parallelOptions, Action`1 body, Action`2 bodyWithState, Action`3 bodyWithStateAndIndex, Func`4 bodyWithStateAndLocal, Func`5 bodyWithEverything, Func`1 localInit, Action`1 localFinally)
at System.Threading.Tasks.Parallel.ForEach[TSource](IEnumerable`1 source, ParallelOptions parallelOptions, Action`1 body)
at org.ohdsi.cdm.framework.core.Base.ChunkBuilder.Build()
at org.ohdsi.cdm.presentation.builderprocess.Program.Build(BuilderController builderController)
Inner Exception Found:
Type: System.NullReferenceException
Message: Object reference not set to an instance of an object.
Source: org.ohdsi.cdm.builders.truven_v5
Stacktrace: at org.ohdsi.cdm.builders.truven_v5.Truvenv5PersonBuilder.GetFachdidKey(IEntity entity)
at org.ohdsi.cdm.builders.truven_v5.Truvenv5PersonBuilder.<JoinVisitOccurrences>d__68`1.MoveNext()
at System.Linq.Lookup`2.Create[TSource](IEnumerable`1 source, Func`2 keySelector, Func`2 elementSelector, IEqualityComparer`1 comparer)
at System.Linq.GroupedEnumerable`3.GetEnumerator()
at org.ohdsi.cdm.builders.truven_v5.Truvenv5PersonBuilder.BuildConditionOccurrences(ConditionOccurrence[] conditionOccurrences, Dictionary`2 vo, ObservationPeriod[] op)
at org.ohdsi.cdm.builders.truven_v5.Truvenv5PersonBuilder.Build()
at org.ohdsi.cdm.framework.core.Base.ChunkBuilder.<Build>b__b(KeyValuePair`2 cd)
at System.Threading.Tasks.Parallel.<>c__DisplayClass42_0`2.<PartitionerForEachWorker>b__1()
at System.Threading.Tasks.Task.InnerInvokeWithArg(Task childTask)
at System.Threading.Tasks.Task.<>c__DisplayClass176_0.<ExecuteSelfReplicating>b__0(Object )
from etl-cdmbuilder.
Hi Praveen,
Thank you for details, I am investigating the issue.
Thanks,
Anton
from etl-cdmbuilder.
Hi Guys,
You have updated the DLLs in the repository, but have not committed the associated source code fixes -- making it hard for us to help out with bug fixing. Can you post the corrected code?
Thanks,
Christophe
from etl-cdmbuilder.
Done, checked in.
from etl-cdmbuilder.
Hi Praveen,
I am trying to find out the cause of issue, could you please tell me which records do you have in visit lookup in vocabulary database, query below:
SELECT DISTINCT [CONCEPT_CODE], [CONCEPT_ID]
FROM dbo.[CONCEPT]
WHERE VOCABULARY_ID = 'Visit'
Thanks,
Anton
from etl-cdmbuilder.
CONCEPT_CODE CONCEPT_ID
ER 9203
IP 9201
LTCP 42898160
OP 9202
from etl-cdmbuilder.
Today I restarted the SQL Server and the application ETL-CDM Builder didn't throw any exception error. All the steps from 'CDM database creation' to 'Copying Vocabulary' worked fine. It seems that restarting the SQL server fixed those exception errors.
from etl-cdmbuilder.
Related Issues (20)
- Duplicate visit_cost_id in visit_cost table violating primary key constraint HOT 5
- JNJ_OPTUM_EHR_LABNAM duplicates
- Conversion from RAW to CDM - Batch number not changing HOT 2
- ICD10PCS Fix HOT 1
- Builder stuck at Chunks creation HOT 36
- Update tag line
- ETL-CDMBuilder INPATIENT_SERVICES table issue HOT 11
- Help with ETL CMD Builder HOT 5
- System.OutOfMemoryException while creating Lookup creation HOT 2
- Exception while Copying Vocabulary HOT 2
- Mapping to invalid concepts when valid concepts available in MarketScan ETLs HOT 21
- CDM Builder DDL needs review for Payer Plan Period / Achilles analysis 1424 HOT 3
- any plans to support v6? HOT 3
- wrong operator_concept_id HOT 1
- OMOP Common Data Version
- Connecting to mssql server DB does not work as before HOT 4
- Error messages I do not understand HOT 2
- "Ambiguous column" messages HOT 1
- Incompatible Data types error on CDM mapping HOT 2
- Process hangs on massive dataset
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 etl-cdmbuilder.