Please be aware that the SAP SQL Anywhere Forum will be shut down on August 29th, 2024 when all it's content will be migrated to the SAP Community.

We are using SA 10.0.1 EBF 3974. In application working with SA by JDBC one of report SQL query is failed after around 4 hour and 40 min processing. Reason for fail - drop connection. Running the same query(with output to file to simulate report system) in DBISQL we get the same result after 4 hour and 40 minutes connection from DBISQL is dropped in log-file follows message appears -

I. 09/26 01:14:00. User "nms" dropped connection 1 ("nms")
I. 09/26 01:14:00. Connection terminated abnormally
I. 09/26 01:14:00. Disconnected TCPIP client's AppInfo: IP=XX.XX.XX.XX;HOST=HBRENER-PCWIN7;OS='Windows 7 Build 7601 Service Pack 1';EXE='C:Program FilesSQL Anywhere 12Bin32dbisql.exe';PID=0x1c4c;THREAD=0x1e58;VERSION=12.0.1.3324;API=iAnywhereJDBC;TIMEZONEADJUSTMENT=180

In DBISQL message windows Execution time - around 11000 sec (around 3 hour) and message export to file with 0 records.

What can be reason for this problem !?

asked 26 Sep '11, 09:49

HBrener's gravatar image

HBrener
426232535
accept rate: 0%

edited 26 Sep '11, 10:28

Mark%20Culp's gravatar image

Mark Culp
25.0k10142298


Maybe it is the client idle timeout. So for the client waiting for a response to its query it might be, that this connection seems to be idle for the client. The default is 240 minutes. You can switch this of by adding idle=0 to your connection string.

permanent link

answered 26 Sep '11, 10:47

Martin's gravatar image

Martin
9.1k130170257
accept rate: 14%

1

...and cf. the -ti server option...

(26 Sep '11, 10:50) Volker Barth

I test it with db server option -ti 600

(26 Sep '11, 10:57) HBrener
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×439
×18
×9

question asked: 26 Sep '11, 09:49

question was seen: 2,655 times

last updated: 26 Sep '11, 10:57