Assist in checking  Inventory Valuation per Dept (Zara). We have been generating this report but still, no file generated. I run the report yesterday but still loading - Sir Lawrence

Check MySQL database to many locked processes
Killed the locked process 
Tried to generate the reported error 
As per checking no product_dim table
copy the product_dim table from other Zara brand
Populate the table by running product_dim update
I tried to generate the report again.