The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

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
426212333
accept rate: 0%

edited 26 Sep '11, 10:28

Mark%20Culp's gravatar image

Mark Culp
22.3k9129262


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
8.6k114149237
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:

×404
×13
×7

question asked: 26 Sep '11, 09:49

question was seen: 1,036 times

last updated: 26 Sep '11, 10:57