topic Re: System goes to not respond while uploading multiple sheets excel in Application Development and Automation Discussions

System goes to not respond while uploading multiple sheets excel

manojmathi — Mon, 22 May 2017 05:28:41 GMT

Hi,

I have a scenario to upload multiple sheets excel to SAP.

On that the program works fine when I choose to upload 25 rows at max., when I choose more than 25 rows the system will hang on or goes to not responding or an information message from SAP says 'Application is not responding or is busy ' .

While debugging the SAP will hang on in 'get_ranges_data' method.

error.jpg

error1.jpg error2.jpg

If any one know Let me know please,

Regards,

Madhivannan

Re: System goes to not respond while uploading multiple sheets excel

former_member189059 — Mon, 22 May 2017 06:33:19 GMT

Try keeping Excel closed before attempting to run the program. Also make sure that the excel process doesn't exist in the Task Manager.

Re: System goes to not respond while uploading multiple sheets excel

Former Member — Mon, 22 May 2017 07:30:58 GMT

As Kris said...

An application not responding message is normally due to an application that is not polite enough to 'doevents' on a timely enough basis. Also, be aware that using the 'Quit' method for excel does not (or did not) used to quit the program properly and is a constant source of this message.

Re: System goes to not respond while uploading multiple sheets excel

Sandra_Rossi — Mon, 22 May 2017 08:46:41 GMT

You probably did something wrong in your program, but how can we help ? You seem to be using DOI (because of method name "get_ranges_data"). Please tell us what you do.

Re: System goes to not respond while uploading multiple sheets excel

manojmathi — Mon, 22 May 2017 13:47:11 GMT

Can you please share your mail id. So that I Can send my codes.

Re: System goes to not respond while uploading multiple sheets excel

Sandra_Rossi — Mon, 22 May 2017 14:15:41 GMT

No sorry. As per forum rules, the use of the forum implies that the question is fully discussed in the forum and not in private, so that all people seeking for answers can have the whole context and solution.

Please, only attach the relevant code, as a zipped file. Thanks.

Re: System goes to not respond while uploading multiple sheets excel

manojmathi — Sat, 27 May 2017 16:20:02 GMT

Please find the attachment. I have attached my code

code.txt