Hi everyone,
I’m working with TimeXtender Data Integration version 6848.1 and my ODX storage is an Azure Data Lake using Parquet format. When I trigger a new reload from the source to the ODX (which should create a new incremental file in the background), I get the following error:
The table folder 'x' is used by another table with the id 'y'
I found this article that describes the issue:
The table folder is used by another table
The suggested solution there is to delete the existing folder in the data lake. Unfortunately, that’s not an option in my case because the source system only holds two weeks of data, while I have built up historical data in the data lake that I cannot afford to lose.
This means every time I run a reload, the process fails as it tries to create a new incremental file for that table.
Has anyone encountered this scenario and found a workaround that does not involve deleting the existing folder? Is it possible to remap the table or adjust the configuration so the historical data can remain and incremental loads can continue without conflict?
Any advice or best practices would be greatly appreciated.
Thanks in advance!
