Skip to main content
Solved

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

  • November 18, 2024
  • 6 replies
  • 97 views

Forum|alt.badge.img

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
Did this topic help you find an answer to your question?

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

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+4
  • 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+4
  • 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+3

Great, thanks!


Reply


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