The forum is currently being migrated to a new host. While the migration happens, the old server is still available. Once the new machine is ready, I will copy the database to the new machine. Feel free to ask and answer questions in the meantime.

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
24.4k9137290


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.7k122158244
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:

×435
×15
×8

question asked: 26 Sep '11, 09:49

question was seen: 2,008 times

last updated: 26 Sep '11, 10:57