[Vtigercrm-developers] "Failed - Network error" when downloading report in CSV format

[nilay khatri]

Uma, for this you really need to test Vtiger with a large data set where
scalability becomes an issue. There are many issues similar to this, which
can not be addressed with the current architecture of Vtiger. I am eager to
hear that I am wrong.

- Mass edits
- Report export
- Export from List
- Imports

When you work with a large data set, there is no foolproof/predictable way
to scale.

For example, this given case of report export. Suppose we had put
conditions which involve full scan and is a non-admin with sharing rules
etc, the query becomes really complex and can easily go for more than 5-10
minutes (even for small data sets, let us say 30-40K records as well).

Generally php time limits are set to less than 1 min. But anyways you can
predefine what could be the time required to execute the various queries.
So you might have to leave the configuration on the higher side, which
would be a workaround but would again fail if something needs even more
resources/time. And it is not good to leave 1 GB memory and 30 min of
execution time limit :)

Another challenge is that if you put your CRM behind a OSI layer 3
firewall / filtering, these normally have very short TTFB limits, usually <
100 sec. Which again terminates the request and can lead to the above
situation.

That's the same case where there are no event triggers for mass edits. As a
workaround Vtiger decided to introduce bulk mode to simply skip events and
limit the record selection to 500! Though there is a concept of batch
event, but never implemented.


On Thu, Jul 22, 2021 at 11:08 AM Uma S <uma.s at vtiger.com> wrote:

> Hi Ruben,
>
> I validated this case of Export CSV in Reports, which works perfectly fine.
>
> Can you please be more precise on the case scenario, Did you notice any
> errors logs and what is the size of your report? I mean the number of
> records?
>
> On Thu, Jul 22, 2021 at 8:25 AM Rubén A. Estrada Orozco <
> rulotec1 at gmail.com> wrote:
>
>> I'm having and issue where downloading any report in CSV format gives
>> this error:
>>
>> [image: image.png]
>>
>> It doesn't happen when using Excel format.
>>
>> It happened in vtiger 7.0.1 and still happens after upgrading to 7.4
>>
>> Any ideas?
>>
>> Saludos
>>
>> Rubén
>> _______________________________________________
>> http://www.vtiger.com/
>
>
>
> --
> With
> Best Regards
> Uma.S
> Vtiger Team
> _______________________________________________
> http://www.vtiger.com/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20210722/d1ca8ee7/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 5478 bytes
Desc: not available
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20210722/d1ca8ee7/attachment-0001.png>