Error (100101) Error connecting to server: Error 500

Discussions about CSEntry
khurshid.arshad
Posts: 481
Joined: July 9th, 2012, 11:32 am
Location: Islamabad, Pakistan

Error (100101) Error connecting to server: Error 500

Post by khurshid.arshad » March 11th, 2021, 4:32 am

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.
Attachments
sync.log
(267.33 KiB) Downloaded 29 times

josh
Posts: 2399
Joined: May 5th, 2014, 12:49 pm
Location: Washington DC

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

Post by josh » March 12th, 2021, 7:00 am

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.

khurshid.arshad
Posts: 481
Joined: July 9th, 2012, 11:32 am
Location: Islamabad, Pakistan

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

Post by khurshid.arshad » March 12th, 2021, 2:01 pm

Dear Josh

Please find attached php error log file.

Thanks.
a.
Attachments
php_error.log
(1.69 MiB) Downloaded 33 times

khurshid.arshad
Posts: 481
Joined: July 9th, 2012, 11:32 am
Location: Islamabad, Pakistan

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

Post by khurshid.arshad » March 12th, 2021, 2:02 pm

Dear Josh

Please find attached api log file.

Thanks.
a.
Attachments
api-2021-03-12.log
(988 Bytes) Downloaded 31 times
api-2021-03-11.log
(24 KiB) Downloaded 26 times
api-2021-03-10.log
(925 Bytes) Downloaded 28 times

josh
Posts: 2399
Joined: May 5th, 2014, 12:49 pm
Location: Washington DC

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

Post by josh » March 12th, 2021, 4:43 pm

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

khurshid.arshad
Posts: 481
Joined: July 9th, 2012, 11:32 am
Location: Islamabad, Pakistan

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

Post by khurshid.arshad » March 14th, 2021, 7:33 am

Dear Josh

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

thanks.
a.

josh
Posts: 2399
Joined: May 5th, 2014, 12:49 pm
Location: Washington DC

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

Post by josh » March 14th, 2021, 7:59 am

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.

khurshid.arshad
Posts: 481
Joined: July 9th, 2012, 11:32 am
Location: Islamabad, Pakistan

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

Post by khurshid.arshad » March 14th, 2021, 9:21 am

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

josh
Posts: 2399
Joined: May 5th, 2014, 12:49 pm
Location: Washington DC

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

Post by josh » March 14th, 2021, 7:00 pm

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.

savy
Posts: 68
Joined: December 27th, 2012, 1:36 pm

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

Post by savy » March 16th, 2021, 10:08 am

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.

Post Reply