As advised by Pentaho team, that the table were already repaired on pentaho. They advised me to try generating the reports again. I run the inventory workback for refresh, then generated the per location inventory valuation report by UPC for Old Navy on pentaho. Then emailed it to Jeff Eusebio of SLCI. This is now okay.