Skip to main content
Solved

Full load execution package not running

  • January 16, 2023
  • 7 replies
  • 130 views

Hi all,

I've recently implemented Incremental load. Pretty great.
I have also built an Execution Package to run each week, where I have added all Incremental tables to the Full load tab.

The Execution package sends me a Notification on Success.

Both the email, as the Execution History show that the package takes 0 seconds to run. It does run and fires the notification, but nothing actually happens.

I would also expect DW_TimeStamp in all Incremental tables to be equal (or at minimum, last run time of Full load).

How can I troubleshoot this?

Thanks!

Best answer by daniel

Dear StefanS,

Can you execute the package manually? If not, please put the tables, datawarehouses or perspectives that you want to reload in the included section of the first tab.

 

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

7 replies

daniel
TimeXtender Xpert
Forum|alt.badge.img+7
  • TimeXtender Xpert
  • 188 replies
  • Answer
  • January 16, 2023

Dear StefanS,

Can you execute the package manually? If not, please put the tables, datawarehouses or perspectives that you want to reload in the included section of the first tab.

 


  • Author
  • Explorer
  • 5 replies
  • January 16, 2023

Hi Daniel, 

No, the package with objects added to Full load cannot be Executed manually. 

I made a new package, added in one table on the Included section and ran it.

Done in a few seconds and DW_TimeStamp got one more distinct value added - in other words, that didn't do a Full load (as expected to be honest).


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

Hi Stefan,

Quick check: Did you also add that table to the Full Load Section in the second tab?


  • Author
  • Explorer
  • 5 replies
  • January 16, 2023

Hi Daniel,

I didn't - but did now and Executed.

That seems to have worked! DW_TimeStamp is now, not unique, but all within the same second (it's a small table to test with).

So, in summary:

  • Add the Incremental table(s) to Full load
  • Add them to Include steps

Done?

Would it also work to just add the entire data warehouse (from ODX - DSA - MDW - SDM) in both tabs?

I'll probably won't go for that, but make a Perspective for all incremental tables and add that and let the ‘regular’ refresh solve the total reload up to my report.

Thanks!!


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

Dear Stefan,
Yes, you're summary is correct. Then you're done. 
It will work if you pick the ‘Execute Project’ which is everything. But this might be overkill. I use the Entire project sometimes and then Excluded tables through the Exclude Tables section (usually perspectives).

Working with the perspectives is a perfect way to load subsets of your DWH. Your proposal sounds good.
Take care!


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

Hi Stefan

Yes you can do that.

 

This is how I would set up a full load execution of my whole project.


  • Author
  • Explorer
  • 5 replies
  • January 16, 2023

I guess I'll do that, way less work as well than maintaining a perspective.


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