Skip to main content
To homepage To homepage
Solved

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

  • March 7, 2022
  • 4 replies
  • 54 views
A
Starter

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.

    This topic has been closed for replies.

    4 replies

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

    Hi August

    What version did you upgrade from?

    A
    Starter
    • aguste
    • 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
    • Thomas Lind
    • Community Manager
    • 1161 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
    • Thomas Lind
    • Community Manager
    • 1161 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.

    Terms and ConditionsCookie settingsAccessibility statement