Community
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Error 6602 when loading large blobs

former_member604454
Explorer

on ‎2017 Dec 21 10:24 PM

0 Likes
1,322

We are getting consistent 6602 errors at a site. It is loading large (3 to 10 megabyte) files. It is across a vpn to the server located in a different office. Everything is fine until you load the file. We have tried the solutions listed at http://devzone.advantagedatabase.com/dz/content.aspx?Key=17ℜfNo=070919-1945

How else can we fix this issue?

Know the answer?

Help others by sharing your knowledge.

Answer

Need more details?

Request clarification before answering.

Show replies
Show replies

Accepted Solutions (0)

Answers (3)

Answers (3)

michael_loop
Contributor
‎2019 Mar 19 8:10 PM
0 Likes

If you mean that the machines with the client applications went to sleep, any existing connections would time out. If you mean that the server went to sleep, it certainly wouldn't be able to accept connections or process queries during that time, but I would expect the database to be available again as soon as the computer woke up.

Show replies
Show replies
michael_loop
Contributor
‎2018 Jan 03 9:09 PM
0 Likes

You might also try setting the client timeout higher on the server side, using the ADS Configuration Utility. The default is 120 seconds.

Mike Loop - SAP Product Support

Show replies
Show replies
michael_loop
Contributor
‎2018 Jan 02 9:40 PM
0 Likes

The knowledge base article you cite covers the most common causes for 6602 errors. What specific timeout and packet sizes did you try?

A packet trace may reveal the issue, but if you need help analyzing a trace, please open a support ticket.

Regards,

Mike Loop
Senior Support Engineer
SAP Product Support

Show replies
Show replies
former_member604454
Explorer
‎2018 Jan 03 6:03 PM
0 Likes

We tried packet sizes down to 256 with timeouts up to 120 I believe. Our client is working on getting someone running a packet trace. Honestly that is over my head so if they don't know what they are looking for, I'll set up a ticket.

former_member604454
Explorer
‎2019 Mar 19 5:14 PM
0 Likes

I'm running into this again at another location. Not loading large blobs. It's on new computers running Windows 10. Any known issues with Windows 10? Any direction on what I would do to get a helpful packet trace?

former_member604454
Explorer
‎2019 Mar 19 5:49 PM
0 Likes

Also, I have confirmed with them that the error only occurs when our application has been idle for an extended period of time (during a meeting/overnight)

former_member604454
Explorer
‎2019 Mar 19 5:56 PM
0 Likes

Never mind. They were letting their computers sleep. ADS just won't make it through a sleep, right?

Ask a Question