Skip to main content
Solved

Cannot find the object after upgrade to 20.10.28 - "_FDS" tables


After the upgrade this error is raised for various (not all) tables when trying to execute from SQL Server source. 

It includes some table names with the "_FDS" extension. I tried googling the _FDS but nothing comes up, neither in TxT documentation nor outside. 

Anyone who can give me a clue on how to proceed? 

Error example:
"Cannot find the object "DIRPARTYTABLE_FDS" because it does not exist or you do not have permissions."

I can solve this be re-deploying each table but of course that is a very sub-optimal choice :(

Best answer by Thomas Lind

Hi

For anyone finding this and looking for answers.

FDS means Failed Data Source. It is a table introduced as there was a bug when you used "Continue with existing data" while also using incremental load with hard deletes.

This bug id: 12035
You will just have to deploy the tables mentioning this and the issue will be resolved.

View original
Did this topic help you find an answer to your question?
This topic has been closed for comments

4 replies

Thomas Lind
Community Manager
Forum|alt.badge.img+5
  • Community Manager
  • 1017 replies
  • March 7, 2022

Hi August

What version did you upgrade from?


  • Author
  • Starter
  • 1 reply
  • March 7, 2022

Hi, the previous version was 20.10.22.64


Thomas Lind
Community Manager
Forum|alt.badge.img+5
  • Community Manager
  • 1017 replies
  • March 7, 2022

Hi August
I will close this. We can continue in the ticket instead.


Thomas Lind
Community Manager
Forum|alt.badge.img+5
  • Community Manager
  • 1017 replies
  • Answer
  • March 8, 2022

Hi

For anyone finding this and looking for answers.

FDS means Failed Data Source. It is a table introduced as there was a bug when you used "Continue with existing data" while also using incremental load with hard deletes.

This bug id: 12035
You will just have to deploy the tables mentioning this and the issue will be resolved.


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