Error (100101) Error connecting to server: Error 500

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

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

Post by khurshid.arshad » March 21st, 2021, 11:15 am

Dear Savy;

I hope you are doing well. I have tried every thing and now i am doing something like this. You can say (جگاڑ لگانا)

First: using function SendListingDataOnServer();
When i get the error after 1500 cases then i am using function OnSystemMessage() and over here i am calling another function Sendlisting().

Now i can get 9000 cases instead 1500.

thanks.
a.

Function Sendlisting();


           
if syncconnect(CSWeb, "http://Servername/cswebnro75/api") = 1 then
                setfile
(LISTING_DICT_NSER, "..\104_Data\Listing_NSER\Listing.csdb");
                 
syncdata(PUT,LISTING_DICT_NSER);
                   
syncdisconnect();

           
move to pro_sup_id;
           
else
            endif
;

end;
function OnSystemMessage(numeric message_number)

   
recode message_number-> OnSystemMessage;

       
100110,100119,100101   ->  false;
                        ->  
true;
   
endrecode;
    // modify the displayed message for invalid subscript errors

   
if message_number=100119 then//Internet issue
       
message1="آپ یہ ایکٹیوٹی اس ٹیبلیٹ پر نہیں کر سکتے کیوں کہ آپ کے ٹیبلیٹ پر اس وقت ";
        message2=
"انٹرنیٹ ";
        message3=
"موجود نہیں ہے۔";

       
set errmsg (operator);
       
errmsg ("%s\n\n%s\n\n%s",message1, message2, message3);
           
set errmsg (default);
       
move to Pro_Sup_ID;

   
elseif message_number=100110 then//Error message hide if File does not exist on the server for downloading
   
elseif message_number=100101 then
//  SendHH();

   
SendListing();
   
endif;


end;
Function SendListingDataOnServer();


           
if syncconnect(CSWeb, "http://servername/cswebnro75/api") = 1 then
                setfile
(LISTING_DICT_NSER, "..\104_Data\Listing_NSER\Listing.csdb");
                 
syncdata(PUT,LISTING_DICT_NSER);
                   
syncdisconnect();
           
move to pro_sup_id;
           
else
            endif
;
end;

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

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

Post by savy » March 22nd, 2021, 9:46 am

Can you increase the value of the parameter csweb_api_max_script_execution_time in the file csweb\app\config\api\config.yml?
Please make sure to clear the csweb/var/cache folder after making this change. This should let you process more cases.

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

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

Post by khurshid.arshad » March 23rd, 2021, 2:53 am

Dear Savy;

I have fixed csweb_api_max_script_execution_time 9999 and after that remove the contents from cswebnro75/var/cache/*.*. and then restart all services more than once.


again i can send only 1500 cases.

One more interesting thing is that i have 631263 cases in actual but after 626923 synchronization i can not synchronize rest of the cases.

Text from config.yml
imports:
- { resource: parameters.yml }
- { resource: parameters.php }
- { resource: security.yml }
- { resource: services.yml }

# Put parameters here that don't need to change on each machine where the app is deployed
# https://symfony.com/doc/current/best_pr ... figuration
parameters:
locale: en
#memory limit for JSON body uploading cases in MB. if the cases sent exceeds this limit, the content
#is first written to disk and streamed for processing. For improving performance increase the in memory
#processing memory limit
csweb_api_max_json_memory_limit: 5
#script execution time in seconds used for long processing during updating cases or importing users.
csweb_api_max_script_execution_time: 9999
#max import limit - if the limit is increased, may have to increase the script execution time limit as well
csweb_api_max_import: 100000
Attachments
sync.rar
(275.4 KiB) Downloaded 23 times
phpinfo.xlsx
(9.2 KiB) Downloaded 22 times

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

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

Post by savy » March 23rd, 2021, 8:27 pm

Arshad,

Can you increase the max_input_time setting as well in your php.ini, to see if it resolves the file upload limit issues? The problem you are seeing related to the upload cases limit is likely due to script time out and not related to CSWeb sync. I will have to look further at your csweb logs related to sync not sending additional cases. Can you send csweb api logs as well to look into the sync failure?

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

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

Post by khurshid.arshad » March 24th, 2021, 12:12 am

Dear savy

I have increase max_input_time from 60 to 3600 but same issue. Please find attached log file from csweb/var/logs.

Thanks.
a.
Attachments
api-2021-03-23.log
(459 Bytes) Downloaded 22 times
api-2021-03-22.log
(1.49 KiB) Downloaded 20 times
api-2021-03-21.log
(451 Bytes) Downloaded 26 times

Post Reply