Where RAG Fails: Understanding the Limitations of Retrieval-Augmented Generation