HTTP 500 server internal error

Hi, I'm customizing a dashlet, but when I try to receive data from SugarCRM on demand using filter API. But, when setting max num filter to -1 (no data limit), I get 500 (Internal Server Error).

I'm trying to bring over 8600 records. If I put 8000 instead of -1 right there, I can bring the records and recieve 200. But, I can't have this kind of limit on my request because my aplication needs this records.

What should I do?

Parents
  • I had exactly the same problem when I was using a C# script to sync data from Sugar to ServiceNow. A 500 error would be thrown when the number of records that I tried to bring over was too high. According to Sugar Support, this was caused by a PHP out of memory error. In an on-premise installation, this problem can be fixed by increasing the memory limit in php.ini. But Sugar does not do that in cloud instances. We solved this by by syncing the data more frequently, which decreased the amount of data that had to be brought over during each sync cycle.

Reply
  • I had exactly the same problem when I was using a C# script to sync data from Sugar to ServiceNow. A 500 error would be thrown when the number of records that I tried to bring over was too high. According to Sugar Support, this was caused by a PHP out of memory error. In an on-premise installation, this problem can be fixed by increasing the memory limit in php.ini. But Sugar does not do that in cloud instances. We solved this by by syncing the data more frequently, which decreased the amount of data that had to be brought over during each sync cycle.

Children