Skip to main content
Solved

Can't deploy History Table after deleting a column, stuck on Deploy valid table structure


Forum|alt.badge.img
  • Contributor
  • 33 replies

v20.10.35.64

I’ve got a History table with ± 16 million rows in PROD and ± 2.3 million rows in TEST. To increase loading times I tried to delete some columns of the table, first in TEST. Here I was able to successfully Deploy & Execute the History table with Differential + Managed deployment, which finished in several minutes.

However, when I try the same procedure in PROD it keeps stuck on the step Deploy Valid Table Structure as shown below. I also tried to Deploy with Differential Deployment unchecked, but with no result. It just keeps loading forever.

Anybody an idea?

 

Best answer by rory.smith

Hi @KCMT ,

could it be there are locking issues? I.e. the valid table in PROD is being read by other users/processes? It could also simply be a resource issue, but locking is good to check first.

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

2 replies

rory.smith
TimeXtender Xpert
Forum|alt.badge.img+7
  • TimeXtender Xpert
  • 649 replies
  • Answer
  • March 12, 2024

Hi @KCMT ,

could it be there are locking issues? I.e. the valid table in PROD is being read by other users/processes? It could also simply be a resource issue, but locking is good to check first.


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

Hi @KCMT did you get a chance to check for potential locking issues as suggested above? 


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