new fields added on analyzer table and design issue fixed