A boil water advisory is in effect for parts of Guilderland following a water main break, police said.The break affected the McKownville area. Residents on Parkwood, Elmwood, Glenwood and Norwood streets, and Waverly Place should boil their water for at least two minutes before consuming it.