Git Product home page Git Product logo

Comments (9)

bradanton avatar bradanton commented on August 21, 2024 1

DXVER column should exists in following tables:
1)FACILITY_HEADER
2)INPATIENT_ADMISSIONS
3)INPATIENT_SERVICES
4)OUTPATIENT_SERVICES

from etl-cdmbuilder.

ericaVoss avatar ericaVoss commented on August 21, 2024

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.

pkumar81 avatar pkumar81 commented on August 21, 2024

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.

bradanton avatar bradanton commented on August 21, 2024

Hi Praveen,

Thank you for details, I am investigating the issue.

Thanks,
Anton

from etl-cdmbuilder.

ChristopheLambert avatar ChristopheLambert commented on August 21, 2024

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.

ericaVoss avatar ericaVoss commented on August 21, 2024

Done, checked in.

from etl-cdmbuilder.

bradanton avatar bradanton commented on August 21, 2024

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.

pkumar81 avatar pkumar81 commented on August 21, 2024

CONCEPT_CODE CONCEPT_ID
ER 9203
IP 9201
LTCP 42898160
OP 9202

from etl-cdmbuilder.

pkumar81 avatar pkumar81 commented on August 21, 2024

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)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo 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.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.