Skip to main content
Solved

System.AggregateException: The column X with id X does not exist in the ODX

  • January 9, 2024
  • 2 replies
  • 83 views

Hi all,

 

I have an data source that gets daily refreshed in the ODX. With some tables, I have encountered the following error. Does anyone knows how I can resolve this? Thanks in advance!

Best answer by Thomas Lind

Hi @gdlc_esculine 

Do you schedule a run of the Synchronize task every day along with the Transfer task?

It is sometimes an issue for file based providers that they will assume an existing file is a new one hence why it assumes it already exists.

You can normally resolve it by deleting the data source table folder when using data lake.

2 replies

Thomas Lind
Community Manager
Forum|alt.badge.img+5
  • Community Manager
  • 1161 replies
  • Answer
  • January 10, 2024

Hi @gdlc_esculine 

Do you schedule a run of the Synchronize task every day along with the Transfer task?

It is sometimes an issue for file based providers that they will assume an existing file is a new one hence why it assumes it already exists.

You can normally resolve it by deleting the data source table folder when using data lake.


Christian Hauggaard
Community Manager
Forum|alt.badge.img+5

Hi @gdlc_esculine did you manage to resolve the issue by deleting the data source table folder in data lake?