Skip to main content
Solved

Data loss after Deploy And Execute in DSA

  • September 5, 2023
  • 7 replies
  • 111 views

Hello to all the community!😃

When I make any change to any table and run deploy and execute, at the end of the procedure, I find he table with very little data compared to what should be present (example out of 90.000 records it loads only 4.100). I tried to check the various settings but I don't see anything wrong, can you give me some advice?

 

TimeXtender vers. 20.10.32.64

 

Thank you in advance

Best answer by devin.tiemens

Hi @M.Davide,

Probably this is due the fact that you have to perfom a full load (after the change) instead of an incremental load. For example if you add a new field to the table the change also has effect on previously loaded rows. Therefore you have to perform a full load once after such change. After that, the table can be loaded incremental again.

 

See this link to see how to perfom a full load manually.

https://timextender.training/productdimension → section: WHAT IS AUTOMATIC INCREMENTAL LOAD? Subject: Just Once

Please let us know if this has solved the issue.

Kind regards,

Devin

View original
Did this topic help you find an answer to your question?

7 replies

rvgfox
Problem Solver
Forum|alt.badge.img+4
  • Problem Solver
  • 222 replies
  • September 6, 2023

@M.Davide Is it the table incremental?


Thomas Lind
Community Manager
Forum|alt.badge.img+5
  • Community Manager
  • 1017 replies
  • September 6, 2023

Hi @M.Davide 

You should check the Errors view to see if the missing rows are located there.

Thomas Lind

Errors menu access explained.

 


  • Author
  • Starter
  • 1 reply
  • September 6, 2023

Hi all,

the table is incremental, with a lot of data. When I make any change and need to deploy it, I lose any record, it’s like a truncate table. It happen randomly, but very frequently on FACT table.

The problem is not about primary key o validation rule, because there was not any change on them


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

@M.Davide what type of change are you making to the table? when you say you lose “any” record, do you mean all records or only some records?


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

@M.Davide could please let us know what change you are making to the incremental table? Thanks!


devin.tiemens
TimeXtender Xpert
Forum|alt.badge.img+3
  • TimeXtender Xpert
  • 79 replies
  • Answer
  • September 18, 2023

Hi @M.Davide,

Probably this is due the fact that you have to perfom a full load (after the change) instead of an incremental load. For example if you add a new field to the table the change also has effect on previously loaded rows. Therefore you have to perform a full load once after such change. After that, the table can be loaded incremental again.

 

See this link to see how to perfom a full load manually.

https://timextender.training/productdimension → section: WHAT IS AUTOMATIC INCREMENTAL LOAD? Subject: Just Once

Please let us know if this has solved the issue.

Kind regards,

Devin


daniel
TimeXtender Xpert
Forum|alt.badge.img+7
  • TimeXtender Xpert
  • 188 replies
  • September 19, 2023

Dear @M.Davide ,

 

To add to @devin.tiemens . I usually load all FULL in development. If you dont want to or it takes to long I have set up a execution package to just load that table and set the full load objects tab to the total project.

 

 

Or you can full load by going to the Review Tasks when Deploying (and Executing)
 

 

 

This works if you deploy the total project or a single table but does not work with perspectives. Watch out when trying to do this with perspectives because you will deploy (and execute) other tables as well and this might take a long time or break the project when working with more than 1 developer.

Hope this helps

= Daniel

 


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