Error in full load packages with the last version 6429.1

What is the error? We are looking to upgrade, but we don't want to run into any troubles regarding incremental loads using timestamps.

The error is that you can’t use the Full load option in the execution packages in a MDW instance. So as long as you do not have that it will not be an issue.

We are working on a fix to this.

Ive just upgraded and now we run into constant fail when loading from the odx:

System.AggregateException: One or more errors occurred. ---> System.InvalidOperationException: Sequence contains no matching element
   at System.Linq.Enumerable.First[TSource](IEnumerable`1 source, Func`2 predicate)
   at ODX.Components.ComponentManager.InstallInternalProviderIfRequired(DataSourceConnectionModel dataSourceConnectionModel, ComponentTypes componentType)
   at DataSourceEngine.Custom.CustomSourceEngine.GetAssemblyFilePath()
   at DataSourceEngine.Custom.CustomSourceEngine.GetCustomDataSource()
   at DataSourceEngine.Custom.CustomSourceEngine.<GetSupportedExecutionDestinations>b__27_0()
   at DataSourceEngine.Custom.CustomSourceEngine.GetSupportedExecutionDestinations()
   at DataStorageEngine.SQL.SQLStorageEngine.TransferData(IDataSourceEngine dataSourceEngine, ExecutionTaskModel taskModel, List`1 tableModels, Boolean forceFullLoad, SecurityExecutionModel securityExecutionModel)
   at ExecutionEngine.Action.StandardAction.Execute()
   at ExecutionEngine.Action.ExecutionAction.<.ctor>b__9_0()
   at System.Threading.Tasks.Task.Execute()
   --- End of inner exception stack trace ---
---> (Inner Exception #0) System.InvalidOperationException: Sequence contains no matching element
   at System.Linq.Enumerable.First[TSource](IEnumerable`1 source, Func`2 predicate)
   at ODX.Components.ComponentManager.InstallInternalProviderIfRequired(DataSourceConnectionModel dataSourceConnectionModel, ComponentTypes componentType)
   at DataSourceEngine.Custom.CustomSourceEngine.GetAssemblyFilePath()
   at DataSourceEngine.Custom.CustomSourceEngine.GetCustomDataSource()
   at DataSourceEngine.Custom.CustomSourceEngine.<GetSupportedExecutionDestinations>b__27_0()
   at DataSourceEngine.Custom.CustomSourceEngine.GetSupportedExecutionDestinations()
   at DataStorageEngine.SQL.SQLStorageEngine.TransferData(IDataSourceEngine dataSourceEngine, ExecutionTaskModel taskModel, List`1 tableModels, Boolean forceFullLoad, SecurityExecutionModel securityExecutionModel)
   at ExecutionEngine.Action.StandardAction.Execute()
   at ExecutionEngine.Action.ExecutionAction.<.ctor>b__9_0()
   at System.Threading.Tasks.Task.Execute()<---
 

what causes this?

Hi @Bitmetric_Maarten 

Can you create a ticket in the support system with this issue. This is an repository issue. Also please explain what version you upgraded from and to.

Yes I’ve mailed support. Update was from 6346.1 to 6429.1

Hi,

we are also getting the “Sequence contains no matching element” error in ODX (when running the synchronize job on an TX SQL Server Data Source). We are still on 6346.1 but we did upgrade the TX SQL Data Source Provider to 18.0.0.0.

Maybe these two are linked?

Are there any news regarding the ODX errors?

Regards,

Kai

I got this error too on both extract and synchronize tasks(was on TimeXtender SQL Data source 17.1.1.0), after upgrading the source to 18.0.0.0 and running a synchronize task, I can now extract successfully.