If I load the only first 1000 records, the data is getting loaded. But if I load everything, I am an unexpected error as shown image attached. What might be the reason for this odd behavior .
Looks like some special character in your data source that breaks the data stream. Usually this type of issue needs a lot of inputs: which data connection, which data source, sample data, script log of successful and failed reload instances. Increasing the number of first lines loaded gradually until the issue happens should be a good start to identify the problematic data element.
Vu Nguyen If a post helps resolve your issue, please mark the answer as correct.