Solved

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

  • 11 March 2024
  • 2 replies
  • 28 views

Userlevel 2

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?

 

icon

Best answer by rory.smith 12 March 2024, 10:05

View original

2 replies

Userlevel 5
Badge +7

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.

Userlevel 6
Badge +5

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

Reply