The UN Security Council says it has failed to agree over a Palestinian bid for full United Nations membership, but the Palestinians say they will not give up their quest.