Solved

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

  • 9 January 2024
  • 2 replies
  • 56 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!

icon

Best answer by Thomas Lind 10 January 2024, 13:58

View original

2 replies

Userlevel 6
Badge +5

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.

Userlevel 6
Badge +5

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

Reply