Page 1 of 2

Error (100101) Error connecting to server: Error 500

Posted: March 11th, 2021, 4:32 am
by khurshid.arshad
Dear CSPro Team;

I was using CSWeb 7.3.1 with CSPro 7.5.1 and now i am using CSWeb 7.5.0. with CSPro 7.5.1.

First, i have downloaded all the data from CSWeb7.3.1 to use data viewer. The data format is csdb. The total number of cases are 60000 (HH) and 650000(Listing).

Now i am Synchronization HH data through desktop application to use CSWeb 7.5.1. After every 1500 cases I am receiving this error :
I have already increase the memory_limit from 128M to 2048M in php.ini

Error (100101) Error connecting to server: Error 500

For reference the sync.log file is attached.

Please guide.
thanks.
a.

Re: Error (100101) Error connecting to server: Error 500

Posted: March 12th, 2021, 7:00 am
by josh
Please post the the api.log file from the server (from csweb/var/logs directory) and also check to see if your server has a php error log and post any errors from there.

Re: Error (100101) Error connecting to server: Error 500

Posted: March 12th, 2021, 2:01 pm
by khurshid.arshad
Dear Josh

Please find attached php error log file.

Thanks.
a.

Re: Error (100101) Error connecting to server: Error 500

Posted: March 12th, 2021, 2:02 pm
by khurshid.arshad
Dear Josh

Please find attached api log file.

Thanks.
a.

Re: Error (100101) Error connecting to server: Error 500

Posted: March 12th, 2021, 4:43 pm
by josh
I see a lot of errors about max_execution_time. Try increasing the limit in php.ini https://www.php.net/manual/en/info.conf ... ution-time

Re: Error (100101) Error connecting to server: Error 500

Posted: March 14th, 2021, 7:33 am
by khurshid.arshad
Dear Josh

I have set max_execution_time 3600 and once 0 and even then no result. Same error.

thanks.
a.

Re: Error (100101) Error connecting to server: Error 500

Posted: March 14th, 2021, 7:59 am
by josh
It may just be the very large number of cases. I don't think we have ever tested upload with that much data. Will try to create a large test file to see if we can reproduce next week. I would recommend sticking to the older CSWeb for this survey and start with the newer one when a start a new survey and don't need to transfer the data.

Re: Error (100101) Error connecting to server: Error 500

Posted: March 14th, 2021, 9:21 am
by khurshid.arshad
Dear Josh;

Thank you for your prompt reply.

I want to share my experience with CSWeb 7.1.0.

A year ago we did a survey with CSWeb 7.1.0. At the End of the survey, I made one copy in SQL and one copy with data viewer in csdb format. Total cases 560,387. Due to error in the server, I installed WAMP Server with CSWeb7.1.0 and uploaded the csdb data through desktop. It worked.

Thanks.
arshad

Re: Error (100101) Error connecting to server: Error 500

Posted: March 14th, 2021, 7:00 pm
by josh
We made some changes since CSPro 7.1 to speed up the upload/download of cases that allows DataViewer to send larger numbers of cases in a single request. It is possible that this is overloading the server in your case. Previously DataViewer would send only 100 cases at a time, now it continues to double the number of cases in each subsequent request unless the server returns an error. The idea is that after the error it should go back to a smaller number of cases but maybe that isn't working with your server for some reason.

Re: Error (100101) Error connecting to server: Error 500

Posted: March 16th, 2021, 10:08 am
by savy
Arshad,

Looking at the logs, it does seem like this may be a time out issue. After you changed the max_execution_time did you restart apache? You can create a test script with calling phpinfo() to check if your max_execution_time changes are in effect.
https://www.php.net/manual/en/function.phpinfo.php
Also, clear the var/cache folder contents in CSWeb before restarting apache.