Skip to main content
To homepage To homepage
Solved

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

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.

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
    • Thomas Lind
    • Community Manager
    • 1017 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
    • 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
    • Thomas Lind
    • 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.

    Most helpful members this week

    Terms and ConditionsCookie settings

    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