The forum will be down for maintenance at some point from Friday, November 16 at 19:00 EDT until Sunday, November 18 at 23:59 EDT. Downtime will be minimized but the exact timing is unknown.

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
23.8k9134279


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.6k119153237
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:

×425
×15
×7

question asked: 26 Sep '11, 09:49

question was seen: 1,511 times

last updated: 26 Sep '11, 10:57