Thanks Anson.
Yes, I did increase the item limit from 100 to 100,000 as a short term fix. I am really concerned what would happen if the records increase beyond 100,000. First of all, I am not sure if giving such a high item limit will cause any harm to the performance.
Could it be like I am making any mistake in the data connections, that leads me to such an issue? Please advice.