Skip to Content
0

System goes to not respond while uploading multiple sheets excel

May 22, 2017 at 05:28 AM

110

avatar image

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.jpgerror2.jpg

If any one know Let me know please,

Regards,

Madhivannan

error.jpg (102.4 kB)
error1.jpg (132.1 kB)
error2.jpg (190.3 kB)
10 |10000 characters needed characters left characters exceeded

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.

0

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

0
Madhivannan Senathipathi

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.

0
Please find the attachment. I have attached my code

code.txt
code.txt (36.6 kB)
0
* Please Login or Register to Answer, Follow or Comment.

2 Answers

avatar image
Former Member May 22, 2017 at 06:33 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Richard Harper May 22, 2017 at 07:30 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded