Several Ambiguous column name error messages

jcabrerazuniga · September 14, 2021, 3:01pm

I tried running the CDM-Builder and I got errors like:

at System.Threading.Tasks.TaskReplicator.Replica.Execute()
at System.Threading.Tasks.TaskReplicator.Replica1.ExecuteAction(Boolean& yieldedBeforeCompletion) at System.Threading.Tasks.Parallel.<>c__DisplayClass19_01.b__1(RangeWorker& currentWorker, Int32 timeout, Boolean& replicationDelegateYieldedBeforeCompletion)
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw(Exception source)
— End of stack trace from previous location where exception was thrown —
at System.Threading.Tasks.Parallel.<>c__DisplayClass19_01.<ForWorker>b__1(RangeWorker& currentWorker, Int32 timeout, Boolean& replicationDelegateYieldedBeforeCompletion) at org.ohdsi.cdm.presentation.builder.Controllers.BuilderController.<>c__DisplayClass18_0.<Build>b__2(Int32 chunkId, ParallelLoopState state) in E:\repo\ohdsi\ETL-CDMBuilder\source\org.ohdsi.cdm.presentation.builder\Controllers\BuilderController.cs:line 303 Stacktrace: at org.ohdsi.cdm.presentation.builder.Base.DatabaseChunkBuilder.Process(IDatabaseEngine sourceEngine, String sourceSchemaName, List1 sourceQueryDefinitions, OdbcConnection sourceConnection, String vendor) in E:\repo\ohdsi\ETL-CDMBuilder\source\org.ohdsi.cdm.presentation.builder\Base\DatabaseChunkBuilder.cs:line 48
Source: sqlncli11.dll
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘ethnicity_concept_id’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘ethnicity_source_value’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘race_concept_id’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘race_source_value’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘vendor’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘observation_source_value’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘observation_concept_id’.
Message: ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘payersource’.
Type: System.Data.Odbc.OdbcException
Inner Exception Found:
at org.ohdsi.cdm.presentation.builder.Controllers.BuilderController.PerformAction(Action act) in E:\repo\ohdsi\ETL-CDMBuilder\source\org.ohdsi.cdm.presentation.builder\Controllers\BuilderController.cs:line 55
at org.ohdsi.cdm.presentation.builder.Controllers.BuilderController.<>c__DisplayClass18_0.b__0() in E:\repo\ohdsi\ETL-CDMBuilder\source\org.ohdsi.cdm.presentation.builder\Controllers\BuilderController.cs:line 289
at System.Threading.Tasks.Parallel.For(Int32 fromInclusive, Int32 toExclusive, ParallelOptions parallelOptions, Action2 body) at System.Threading.Tasks.Parallel.ForWorker[TLocal](Int32 fromInclusive, Int32 toExclusive, ParallelOptions parallelOptions, Action1 body, Action2 bodyWithState, Func4 bodyWithLocal, Func1 localInit, Action1 localFinally)
at System.Threading.Tasks.Parallel.ThrowSingleCancellationExceptionOrOtherException(ICollection exceptions, CancellationToken cancelToken, Exception otherException)
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw(Exception source)
— End of stack trace from previous location where exception was thrown —
at System.Threading.Tasks.Parallel.ForWorker[TLocal](Int32 fromInclusive, Int32 toExclusive, ParallelOptions parallelOptions, Action1 body, Action2 bodyWithState, Func4 bodyWithLocal, Func1 localInit, Action1 localFinally) Stacktrace: at System.Threading.Tasks.TaskReplicator.Run[TState](ReplicatableUserAction1 action, ParallelOptions options, Boolean stopOnFirstFailure)
Source: System.Threading.Tasks.Parallel
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘ethnicity_concept_id’.)
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘ethnicity_source_value’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘race_concept_id’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘race_source_value’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘vendor’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘observation_source_value’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘observation_concept_id’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘ethnicity_concept_id’.) (ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘payersource’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘ethnicity_source_value’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘race_concept_id’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘race_source_value’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘vendor’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘observation_source_value’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘observation_concept_id’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘ethnicity_concept_id’.) (ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘payersource’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘ethnicity_source_value’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘race_concept_id’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘race_source_value’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘vendor’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘observation_source_value’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘observation_concept_id’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘ethnicity_concept_id’.) (ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘payersource’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘ethnicity_source_value’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘race_concept_id’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘race_source_value’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘vendor’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘observation_source_value’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘observation_concept_id’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘ethnicity_concept_id’.) (ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘payersource’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘ethnicity_source_value’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘race_concept_id’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘race_source_value’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘vendor’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘observation_source_value’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘observation_concept_id’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘ethnicity_concept_id’.) (ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘payersource’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘ethnicity_source_value’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘race_concept_id’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘race_source_value’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘vendor’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘observation_source_value’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘observation_concept_id’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘ethnicity_concept_id’.) (ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘payersource’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘ethnicity_source_value’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘race_concept_id’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘race_source_value’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘vendor’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘observation_source_value’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘observation_concept_id’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘ethnicity_concept_id’.) (ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘payersource’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘ethnicity_source_value’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘race_concept_id’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘race_source_value’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘vendor’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘observation_source_value’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘observation_concept_id’.
Message: One or more errors occurred. (ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘payersource’.
Type: System.AggregateException
9/10/2021 5:49:10 PM| Exception Found:
Stacktrace: at org.ohdsi.cdm.presentation.builder.Base.DatabaseChunkBuilder.Process(IDatabaseEngine sourceEngine, String sourceSchemaName, List`1 sourceQueryDefinitions, OdbcConnection sourceConnection, String vendor) in E:\repo\ohdsi\ETL-CDMBuilder\source\org.ohdsi.cdm.presentation.builder\Base\DatabaseChunkBuilder.cs:line 48
Source: sqlncli11.dll
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘ethnicity_concept_id’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘ethnicity_source_value’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘race_concept_id’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘race_source_value’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘vendor’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘observation_source_value’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘observation_concept_id’.
Message: ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘payersource’.
Type: System.Data.Odbc.OdbcException
9/10/2021 5:49:10 PM| Exception Found:

Query:
File name=ENROLLMENT_DETAIL
SourceConnectionString=
9/10/2021 5:49:10 PM| SourceEngine=org.ohdsi.cdm.framework.desktop.Databases.MssqlDatabaseEngine
Stacktrace: at org.ohdsi.cdm.presentation.builder.Base.DatabaseChunkBuilder.Process(IDatabaseEngine sourceEngine, String sourceSchemaName, List`1 sourceQueryDefinitions, OdbcConnection sourceConnection, String vendor) in E:\repo\ohdsi\ETL-CDMBuilder\source\org.ohdsi.cdm.presentation.builder\Base\DatabaseChunkBuilder.cs:line 48
Source: sqlncli11.dll
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘ethnicity_concept_id’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘ethnicity_source_value’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘race_concept_id’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘race_source_value’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘vendor’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘observation_source_value’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘observation_concept_id’.
Message: ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘payersource’.
Type: System.Data.Odbc.OdbcException
9/10/2021 5:36:15 PM| Exception Found:

Query:
File name=ENROLLMENT_DETAIL
SourceConnectionString=
9/10/2021 5:36:15 PM| SourceEngine=org.ohdsi.cdm.framework.desktop.Databases.MssqlDatabaseEngine
Stacktrace: at org.ohdsi.cdm.presentation.builder.Base.DatabaseChunkBuilder.Process(IDatabaseEngine sourceEngine, String sourceSchemaName, List`1 sourceQueryDefinitions, OdbcConnection sourceConnection, String vendor) in E:\repo\ohdsi\ETL-CDMBuilder\source\org.ohdsi.cdm.presentation.builder\Base\DatabaseChunkBuilder.cs:line 48
Source: sqlncli11.dll
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘ethnicity_concept_id’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘ethnicity_source_value’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘race_concept_id’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘race_source_value’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘vendor’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘observation_source_value’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘observation_concept_id’.
Message: ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘payersource’.
Type: System.Data.Odbc.OdbcException
9/10/2021 5:33:08 PM| Exception Found:

Query:
File name=ENROLLMENT_DETAIL
SourceConnectionString=
9/10/2021 5:33:08 PM| SourceEngine=org.ohdsi.cdm.framework.desktop.Databases.MssqlDatabaseEngine
Stacktrace: at org.ohdsi.cdm.presentation.builder.Base.DatabaseChunkBuilder.Process(IDatabaseEngine sourceEngine, String sourceSchemaName, List`1 sourceQueryDefinitions, OdbcConnection sourceConnection, String vendor) in E:\repo\ohdsi\ETL-CDMBuilder\source\org.ohdsi.cdm.presentation.builder\Base\DatabaseChunkBuilder.cs:line 48
Source: sqlncli11.dll
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘ethnicity_concept_id’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘ethnicity_source_value’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘race_concept_id’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘race_source_value’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘vendor’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘observation_source_value’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘observation_concept_id’.
Message: ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘payersource’.
Type: System.Data.Odbc.OdbcException
9/10/2021 4:40:12 PM| Exception Found:

Query:
File name=ENROLLMENT_DETAIL
SourceConnectionString=
9/10/2021 4:40:12 PM| SourceEngine=org.ohdsi.cdm.framework.desktop.Databases.MssqlDatabaseEngine
Stacktrace: at org.ohdsi.cdm.presentation.builder.Base.DatabaseChunkBuilder.Process(IDatabaseEngine sourceEngine, String sourceSchemaName, List`1 sourceQueryDefinitions, OdbcConnection sourceConnection, String vendor) in E:\repo\ohdsi\ETL-CDMBuilder\source\org.ohdsi.cdm.presentation.builder\Base\DatabaseChunkBuilder.cs:line 48
Source: sqlncli11.dll
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘ethnicity_concept_id’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘ethnicity_source_value’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘race_concept_id’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘race_source_value’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘vendor’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘observation_source_value’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘observation_concept_id’.
Message: ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘payersource’.
Type: System.Data.Odbc.OdbcException
9/10/2021 4:22:50 PM| Exception Found:

Query:
File name=ENROLLMENT_DETAIL
SourceConnectionString=
9/10/2021 4:22:50 PM| SourceEngine=org.ohdsi.cdm.framework.desktop.Databases.MssqlDatabaseEngine
Stacktrace: at org.ohdsi.cdm.presentation.builder.Base.DatabaseChunkBuilder.Process(IDatabaseEngine sourceEngine, String sourceSchemaName, List`1 sourceQueryDefinitions, OdbcConnection sourceConnection, String vendor) in E:\repo\ohdsi\ETL-CDMBuilder\source\org.ohdsi.cdm.presentation.builder\Base\DatabaseChunkBuilder.cs:line 48
Source: sqlncli11.dll
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘ethnicity_concept_id’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘ethnicity_source_value’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘race_concept_id’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘race_source_value’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘vendor’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘observation_source_value’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘observation_concept_id’.
Message: ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘payersource’.
Type: System.Data.Odbc.OdbcException
9/10/2021 4:05:06 PM| Exception Found:

Query:
File name=ENROLLMENT_DETAIL
SourceConnectionString=
9/10/2021 4:05:06 PM| SourceEngine=org.ohdsi.cdm.framework.desktop.Databases.MssqlDatabaseEngine
Stacktrace: at org.ohdsi.cdm.presentation.builder.Base.DatabaseChunkBuilder.Process(IDatabaseEngine sourceEngine, String sourceSchemaName, List`1 sourceQueryDefinitions, OdbcConnection sourceConnection, String vendor) in E:\repo\ohdsi\ETL-CDMBuilder\source\org.ohdsi.cdm.presentation.builder\Base\DatabaseChunkBuilder.cs:line 48
Source: sqlncli11.dll
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘ethnicity_concept_id’.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘ethnicity_source_value’.

What could be causing this problem?

I posted this problem also at:

github.com/OHDSI/ETL-CDMBuilder

"Ambiguous column" messages

opened 08:25PM - 31 Aug 21 UTC

jcabrerazuniga

Hi While processing my mdcr db I am getting the next errors: tacktrace:… at org.ohdsi.cdm.presentation.builder.Base.DatabaseChunkBuilder.Process(IDatabaseEngine sourceEngine, String sourceSchemaName, List`1 sourceQueryDefinitions, OdbcConnection sourceConnection, String vendor) in E:\repo\ohdsi\ETL-CDMBuilder\source\org.ohdsi.cdm.presentation.builder\Base\DatabaseChunkBuilder.cs:line 48 Source: sqlncli11.dll ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'ethnicity_concept_id'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'ethnicity_source_value'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'race_concept_id'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'race_source_value'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'vendor'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'observation_source_value'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'observation_concept_id'. Message: ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'payersource'. Type: System.Data.Odbc.OdbcException 8/31/2021 1:54:57 PM| Exception Found: Query: File name=ENROLLMENT_DETAIL SourceConnectionString= 8/31/2021 1:54:57 PM| SourceEngine=org.ohdsi.cdm.framework.desktop.Databases.MssqlDatabaseEngine 8/31/2021 1:44:06 PM| ==================== Conversion to CDM was started ==================== 8/31/2021 1:44:06 PM| DONE - 3100 ms | KeysCount=960 8/31/2021 1:44:02 PM| Units - Loading into RAM... 8/31/2021 1:44:02 PM| DONE - 1316733 ms | KeysCount=250287 8/31/2021 1:22:06 PM| Lab - Loading into RAM... 8/31/2021 1:22:06 PM| DONE - 1627 ms | KeysCount=538 8/31/2021 1:22:04 PM| Revenue - Loading into RAM... 8/31/2021 1:22:04 PM| DONE - 88 ms | KeysCount=0 8/31/2021 1:22:04 PM| DischargeTo - Loading into RAM... 8/31/2021 1:22:04 PM| DONE - 125 ms | KeysCount=16 8/31/2021 1:22:04 PM| Visits - Loading into RAM... 8/31/2021 1:22:04 PM| DONE - 1238 ms | KeysCount=400 8/31/2021 1:22:02 PM| Modifier - Loading into RAM... 8/31/2021 1:22:02 PM| DONE - 90 ms | KeysCount=0 8/31/2021 1:22:02 PM| Drg - Loading into RAM... 8/31/2021 1:22:02 PM| DONE - 95 ms | KeysCount=0 8/31/2021 1:22:02 PM| HRA - Loading into RAM... 8/31/2021 1:22:02 PM| DONE - 14 ms | KeysCount=0 8/31/2021 1:22:02 PM| Death - Loading into RAM... 8/31/2021 1:22:02 PM| DONE - 600789 ms | KeysCount=108516 8/31/2021 1:12:01 PM| Procedure - Loading into RAM... 8/31/2021 1:12:01 PM| DONE - 706569 ms | KeysCount=96918 8/31/2021 1:00:15 PM| Condition_icd10 - Loading into RAM... 8/31/2021 1:00:15 PM| DONE - 116216 ms | KeysCount=17564 8/31/2021 12:58:19 PM| Condition - Loading into RAM... 8/31/2021 12:58:19 PM| DONE - 6381210 ms | KeysCount=1038955 8/31/2021 11:11:57 AM| Drug - Loading into RAM... 8/31/2021 9:42:20 AM| Drug - Loading into RAM... 8/31/2021 9:41:50 AM| Drug - Loading into RAM... at System.Threading.Tasks.TaskReplicator.Replica.Execute() at System.Threading.Tasks.TaskReplicator.Replica`1.ExecuteAction(Boolean& yieldedBeforeCompletion) at System.Threading.Tasks.Parallel.<>c__DisplayClass19_0`1.<ForWorker>b__1(RangeWorker& currentWorker, Int32 timeout, Boolean& replicationDelegateYieldedBeforeCompletion) at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw(Exception source) --- End of stack trace from previous location where exception was thrown --- at System.Threading.Tasks.Parallel.<>c__DisplayClass19_0`1.<ForWorker>b__1(RangeWorker& currentWorker, Int32 timeout, Boolean& replicationDelegateYieldedBeforeCompletion) at org.ohdsi.cdm.presentation.builder.Controllers.BuilderController.<>c__DisplayClass18_0.<Build>b__2(Int32 chunkId, ParallelLoopState state) in E:\repo\ohdsi\ETL-CDMBuilder\source\org.ohdsi.cdm.presentation.builder\Controllers\BuilderController.cs:line 303 Stacktrace: at org.ohdsi.cdm.presentation.builder.Base.DatabaseChunkBuilder.Process(IDatabaseEngine sourceEngine, String sourceSchemaName, List`1 sourceQueryDefinitions, OdbcConnection sourceConnection, String vendor) in E:\repo\ohdsi\ETL-CDMBuilder\source\org.ohdsi.cdm.presentation.builder\Base\DatabaseChunkBuilder.cs:line 48 Source: sqlncli11.dll ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'ethnicity_concept_id'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'ethnicity_source_value'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'race_concept_id'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'race_source_value'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'vendor'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'observation_source_value'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'observation_concept_id'. Message: ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'payersource'. Type: System.Data.Odbc.OdbcException Inner Exception Found: at org.ohdsi.cdm.presentation.builder.Controllers.BuilderController.PerformAction(Action act) in E:\repo\ohdsi\ETL-CDMBuilder\source\org.ohdsi.cdm.presentation.builder\Controllers\BuilderController.cs:line 55 at org.ohdsi.cdm.presentation.builder.Controllers.BuilderController.<>c__DisplayClass18_0.<Build>b__0() in E:\repo\ohdsi\ETL-CDMBuilder\source\org.ohdsi.cdm.presentation.builder\Controllers\BuilderController.cs:line 289 at System.Threading.Tasks.Parallel.For(Int32 fromInclusive, Int32 toExclusive, ParallelOptions parallelOptions, Action`2 body) at System.Threading.Tasks.Parallel.ForWorker[TLocal](Int32 fromInclusive, Int32 toExclusive, ParallelOptions parallelOptions, Action`1 body, Action`2 bodyWithState, Func`4 bodyWithLocal, Func`1 localInit, Action`1 localFinally) at System.Threading.Tasks.Parallel.ThrowSingleCancellationExceptionOrOtherException(ICollection exceptions, CancellationToken cancelToken, Exception otherException) at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw(Exception source) --- End of stack trace from previous location where exception was thrown --- at System.Threading.Tasks.Parallel.ForWorker[TLocal](Int32 fromInclusive, Int32 toExclusive, ParallelOptions parallelOptions, Action`1 body, Action`2 bodyWithState, Func`4 bodyWithLocal, Func`1 localInit, Action`1 localFinally) Stacktrace: at System.Threading.Tasks.TaskReplicator.Run[TState](ReplicatableUserAction`1 action, ParallelOptions options, Boolean stopOnFirstFailure) Source: System.Threading.Tasks.Parallel ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'ethnicity_concept_id'.) ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'ethnicity_source_value'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'race_concept_id'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'race_source_value'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'vendor'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'observation_source_value'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'observation_concept_id'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'ethnicity_concept_id'.) (ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'payersource'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'ethnicity_source_value'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'race_concept_id'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'race_source_value'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'vendor'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'observation_source_value'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'observation_concept_id'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'ethnicity_concept_id'.) (ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'payersource'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'ethnicity_source_value'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'race_concept_id'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'race_source_value'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'vendor'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'observation_source_value'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'observation_concept_id'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'ethnicity_concept_id'.) (ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'payersource'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'ethnicity_source_value'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'race_concept_id'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'race_source_value'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'vendor'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'observation_source_value'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'observation_concept_id'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'ethnicity_concept_id'.) (ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'payersource'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'ethnicity_source_value'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'race_concept_id'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'race_source_value'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'vendor'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'observation_source_value'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'observation_concept_id'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'ethnicity_concept_id'.) (ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'payersource'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'ethnicity_source_value'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'race_concept_id'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'race_source_value'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'vendor'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'observation_source_value'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'observation_concept_id'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'ethnicity_concept_id'.) (ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'payersource'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'ethnicity_source_value'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'race_concept_id'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'race_source_value'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'vendor'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'observation_source_value'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'observation_concept_id'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'ethnicity_concept_id'.) (ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'payersource'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'ethnicity_source_value'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'race_concept_id'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'race_source_value'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'vendor'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'observation_source_value'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'observation_concept_id'. Message: One or more errors occurred. (ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'payersource'. Type: System.AggregateException 8/31/2021 12:41:13 AM| Exception Found: Stacktrace: at org.ohdsi.cdm.presentation.builder.Base.DatabaseChunkBuilder.Process(IDatabaseEngine sourceEngine, String sourceSchemaName, List`1 sourceQueryDefinitions, OdbcConnection sourceConnection, String vendor) in E:\repo\ohdsi\ETL-CDMBuilder\source\org.ohdsi.cdm.presentation.builder\Base\DatabaseChunkBuilder.cs:line 48 Source: sqlncli11.dll ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'ethnicity_concept_id'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'ethnicity_source_value'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'race_concept_id'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'race_source_value'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'vendor'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'observation_source_value'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'observation_concept_id'. Message: ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'payersource'. Type: System.Data.Odbc.OdbcException 8/31/2021 12:41:13 AM| Exception Found: Query: File name=ENROLLMENT_DETAIL SourceConnectionString= 8/31/2021 12:41:13 AM| SourceEngine=org.ohdsi.cdm.framework.desktop.Databases.MssqlDatabaseEngine Stacktrace: at org.ohdsi.cdm.presentation.builder.Base.DatabaseChunkBuilder.Process(IDatabaseEngine sourceEngine, String sourceSchemaName, List`1 sourceQueryDefinitions, OdbcConnection sourceConnection, String vendor) in E:\repo\ohdsi\ETL-CDMBuilder\source\org.ohdsi.cdm.presentation.builder\Base\DatabaseChunkBuilder.cs:line 48 Source: sqlncli11.dll ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'ethnicity_concept_id'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'ethnicity_source_value'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'race_concept_id'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'race_source_value'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'vendor'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'observation_source_value'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'observation_concept_id'. Message: ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'payersource'. Type: System.Data.Odbc.OdbcException 8/31/2021 12:37:25 AM| Exception Found: Query: File name=ENROLLMENT_DETAIL SourceConnectionString= 8/31/2021 12:37:25 AM| SourceEngine=org.ohdsi.cdm.framework.desktop.Databases.MssqlDatabaseEngine Stacktrace: at org.ohdsi.cdm.presentation.builder.Base.DatabaseChunkBuilder.Process(IDatabaseEngine sourceEngine, String sourceSchemaName, List`1 sourceQueryDefinitions, OdbcConnection sourceConnection, String vendor) in E:\repo\ohdsi\ETL-CDMBuilder\source\org.ohdsi.cdm.presentation.builder\Base\DatabaseChunkBuilder.cs:line 48 Source: sqlncli11.dll ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'ethnicity_concept_id'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'ethnicity_source_value'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'race_concept_id'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'race_source_value'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'vendor'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'observation_source_value'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'observation_concept_id'. Message: ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'payersource'. Type: System.Data.Odbc.OdbcException 8/31/2021 12:27:32 AM| Exception Found: Query: File name=ENROLLMENT_DETAIL SourceConnectionString= 8/31/2021 12:27:32 AM| SourceEngine=org.ohdsi.cdm.framework.desktop.Databases.MssqlDatabaseEngine Stacktrace: at org.ohdsi.cdm.presentation.builder.Base.DatabaseChunkBuilder.Process(IDatabaseEngine sourceEngine, String sourceSchemaName, List`1 sourceQueryDefinitions, OdbcConnection sourceConnection, String vendor) in E:\repo\ohdsi\ETL-CDMBuilder\source\org.ohdsi.cdm.presentation.builder\Base\DatabaseChunkBuilder.cs:line 48 Source: sqlncli11.dll ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'ethnicity_concept_id'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'ethnicity_source_value'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'race_concept_id'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'race_source_value'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'vendor'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'observation_source_value'. ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'observation_concept_id'. Message: ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'payersource'. Type: System.Data.Odbc.OdbcExceptio What could be the problem?

but not having answers, so far.

Thanks
Jose