Skip to main content
To homepage To homepage
Solved

Updated TX 6814.1 with strange behavior for incr tables in prepare (desktop)

  • November 18, 2024
  • 6 replies
  • 239 views
Contributor
Forum|alt.badge.img+1

Hi,

I updated our TX version to the newest 6814.1

 

I have added many tables in TimeXtender Ingest Server with incremental load.

 

Why do I have to change all incr. tables in "desktop app" to explicit incremental load, can't you use “Automatic” anymore?

 

Error msg: when executing with automatic on a table with incr setup from the datasource I get this type of error “Invalid object name 'shema.table_I'.”

 

Something I haven't done right...

 

regards,

Bjørn A.

Best answer by Christian Hauggaard

Hi ​@bjorn ​@rvgfox ​@devin.tiemens 
A fix has been released in TimeXtender Data Integration 6822.1. Please upgrade to this version
Please see following item in release notes for reference https://support.timextender.com/product-updates/timextender-data-integration-6822-1-2660

  • Fixed issue with Ingest Incrementally loaded tables that was added to a Prepare instance, which caused errors during deployment and execution.
View original

6 replies

devin.tiemens
TimeXtender Xpert
Forum|alt.badge.img+6

Hi, I had same issue indeed, workaround for me was to turn Incremental load off and on again.

Christian Hauggaard
Community Manager
Forum|alt.badge.img+5

Hi ​@bjorn 

The product team are working on a fix for this currently.

In the meantime, please select Incremental load instead of Automatic.

    rvgfox
    Problem Solver
    Forum|alt.badge.img+5
    • rvgfox
    • Problem Solver
    • November 18, 2024

    Hi ​@Christian Hauggaard 

    With that workaround I’m getting this error:

    As ​@bjorn says, I need to setup explicit incremental rule.

    rvgfox
    Problem Solver
    Forum|alt.badge.img+5
    • rvgfox
    • Problem Solver
    • November 19, 2024

    And the SQL Database Clean tool, suggest all the _I objects to clean.

    Christian Hauggaard
    Community Manager
    Forum|alt.badge.img+5

    Hi ​@bjorn ​@rvgfox ​@devin.tiemens 
    A fix has been released in TimeXtender Data Integration 6822.1. Please upgrade to this version
    Please see following item in release notes for reference https://support.timextender.com/product-updates/timextender-data-integration-6822-1-2660

    • Fixed issue with Ingest Incrementally loaded tables that was added to a Prepare instance, which caused errors during deployment and execution.
      devin.tiemens
      TimeXtender Xpert
      Forum|alt.badge.img+6

      Great, thanks!

      Terms and ConditionsAccessibility statement