Hello janidas,
It seems like you have an annoying issue. I dont know what the solution is, but if it is urgent, i would suggest applying the normalization and weighting factors manually, in excel.
This does not solve the underlying issue, but it might get you through the urgent situation. Hopefully your system is not too complex.
Good luck