Getting error (500 internal server) while fetching JSON, when more than 1000 rows is returned from database?

1. I want to fetch some data from DB (parameters false ,true,some id(e.g.: 30245)) Following is function written in controller :

[HttpPost]
  public ActionResult GetISBNRequestList(bool isRecursive, bool isCompleted, int ClientRequestID)
        {
            List<CrawlerRequest> ISBNList = new List<CrawlerRequest>();
            ISBNList = _CrawlerRequestFacade.GetCrawlerCompleteRequestList(_loginVM.Id, 
            isRecursive, isCompleted, ClientRequestID);
            return Json(ISBNList);
        }

2.In Js: I am populating data to bootstrap pop-up: but an error occurs if records are more than 1000, function call goes to error block in js :

  function GetISBNRequest(obj, isRecursive, isCompleted)
{
    var clientRequestID = $(obj).data("id");
    if (clientRequestID > 0) {
        $.ajax({
            url: '/CrawlerRequest/GetISBNRequestList/',
            data: JSON.stringify({isRecursive: isRecursive,isCompleted: isCompleted,ClientRequestID: clientRequestID}),
            dataType: "json",
            type: "POST",
            contentType: "application/json; charset=utf-8",
            success: function (data, textStatus, XMLHttpRequest) {
             $.each(data, function (n, item) {
                    // fetching data like item.columnname and appending into table  
                });
            },
            error: function (xhr, ajaxOptions, thrownError) {
                console.log(xhr.error().statusText);
            }
        });
    }
}

 Please give me suggestions for this or else should I try to display view in the bootstrap popup?

---

1 Answers