Skip to main content
Solved

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


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.

View original
Did this topic help you find an answer to your question?

2 replies

Thomas Lind
Community Manager
Forum|alt.badge.img+5
  • Community Manager
  • 1017 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?


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings