Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

ASA6.02 Client Always Disconnected

2 posts in Windows NT Last posting was on 2000-02-28 19:19:49.0Z
Peter Kuit Posted on 2000-02-25 08:10:12.0Z
Reply-To: "Peter Kuit" <peterkuit@hotmail.com>
From: "Peter Kuit" <peterkuit@hotmail.com>
Subject: ASA6.02 Client Always Disconnected
Date: Fri, 25 Feb 2000 16:10:12 +0800
Lines: 170
Organization: Peter Kuit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Message-ID: <c#CqYa2f$GA.151@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: brk-25-121.tm.net.my 202.188.25.121
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2501
Article PK: 1089954

Specifications:

Server:
ASA6.02 Server on NT4sp3
Loaded on IPX, TCPIP
3 DBs Loaded as separate services, all loaded on 2 protocols.
Settings for TCPIP ports are different from each other namely:
2638,2639,2640.

Client:
Win95, logon to Novell Netware as primary network.
IPX and TCPIP properly set. Checkings done using PING,IPWINCFG utils.
Connects thru ODBC.
When clicking Test Connection, can connect.

Now, logging on to PB Application, also, ok. BUT after a while, connection
is broken.
We have changed the liveness timeout from 120(default) to 2000(approx.
30min) hoping that it would solve somehow.
Last time all the PCs in one area, say, 1 network address were working fine,
no disconnection watsoever.
Some areas on different network address, cannot connect. It was because they
were on different address and RIP is not enabled in Novell. So, we decided
to come up with 1 address USING Switching HUB. so all now can connect.
BUT those machines without having any connection problem last time, NOW have
disconnection problem and including the rest.

Please show us some light on this.

TIA
orisoft.

Server LOG File:
I. 02/25 11:18:29. 1: -z
I. 02/25 11:18:29. 2: -c20M
I. 02/25 11:18:29. 3: -x
I. 02/25 11:18:29. 4: ipx,tcpip
I. 02/25 11:18:29. 5: -m
I. 02/25 11:18:29. 6: d:\orisoft\data\payrbk.db
I. 02/25 11:18:29. 7: -n
I. 02/25 11:18:29. 8: payrbk
I. 02/25 11:18:29. 9: -tl2000
I. 02/25 11:18:29. 10: -od:\orisoft\data\serverlog\rbklog.txt

I. 02/25 11:18:29. Sybase Adaptive Server Anywhere Network Server Version
6.0.2.2188

I. 02/25 11:18:29. This software contains confidential and trade secret
information of
I. 02/25 11:18:29. Sybase, Inc. Use, duplication or disclosure of the
software and
I. 02/25 11:18:29. documentation by the U.S. Government is subject to
restrictions set forth
I. 02/25 11:18:29. in a license agreement between the Government and Sybase,
Inc. or other
I. 02/25 11:18:29. written agreement specifying the Government's rights to
use the software
I. 02/25 11:18:29. and any applicable FAR provisions, for example, FAR
52.227-19.
I. 02/25 11:18:29.
I. 02/25 11:18:29. Copyright 1989-1999 Sybase, Inc. All rights reserved.
I. 02/25 11:18:29. All unpublished rights reserved.
I. 02/25 11:18:29.
I. 02/25 11:18:29. Sybase, Inc. 6475 Christie Avenue, Emeryville, CA 94608,
USA

I. 02/25 11:18:29. Networked Seat (per-seat) model. Access to the server is
limited to 30 seat(s).
I. 02/25 11:18:29. This server is licensed to:
I. 02/25 11:18:29. RBK Human Resources Suite
I. 02/25 11:18:29. The Regent Bangkok Hotel
I. 02/25 11:18:29. 20480K of memory used for caching
I. 02/25 11:18:29. Using a maximum page size of 4096 bytes
I. 02/25 11:18:29. Starting database "payrbk" (d:\orisoft\data\payrbk.db) at
Fri Feb 25 2000 11:18
I. 02/25 11:18:34. Transaction log: PAYRBK.LOG
I. 02/25 11:18:34. Starting checkpoint of "payrbk" (payrbk.db) at Fri Feb 25
2000 11:18
I. 02/25 11:18:34. Finished checkpoint of "payrbk" (payrbk.db) at Fri Feb 25
2000 11:18
I. 02/25 11:18:38. Database "payrbk" (payrbk.db) started at Fri Feb 25 2000
11:18
I. 02/25 11:18:38. Database server start time: Fri Feb 25 2000 11:18
I. 02/25 11:18:38. Trying to start Shared Memory link ...
I. 02/25 11:18:38. Shared Memory link started successfully
I. 02/25 11:18:38. Trying to start IPX link ...
I. 02/25 11:18:38. Loading wsock32.dll
I. 02/25 11:18:39. Trying to read property value of _SA60_payrbk
I. 02/25 11:18:39. Bindery scan return code: 0
I. 02/25 11:18:39. Sending broadcast
I. 02/25 11:18:44. No broadcast reply received
I. 02/25 11:18:44. No broadcast reply received
I. 02/25 11:18:44. My IPX host address is 0:16:90:118:255:15/0:0:0:162
I. 02/25 11:18:44. Threads started: 2
I. 02/25 11:18:44. IPX link started successfully
I. 02/25 11:18:44. Trying to start TCPIP link ...
I. 02/25 11:18:44. Loading wsock32.dll
I. 02/25 11:18:44. Loading ws2_32.dll
I. 02/25 11:18:44. TCP using Winsock version 2.0
I. 02/25 11:18:44. My IP address is 192.154.123.9
I. 02/25 11:18:44. My IP address is 127.0.0.1
I. 02/25 11:18:44. Looking for payrbk
I. 02/25 11:18:44. I am in a class C network
I. 02/25 11:18:44. Sending broadcast
I. 02/25 11:18:44. Using broadcast address of: 192.154.123.255:2638
I. 02/25 11:18:44. I am in a class A network
I. 02/25 11:18:44. Sending broadcast
I. 02/25 11:18:44. Using broadcast address of: 127.255.255.255:2638
I. 02/25 11:18:49. No reply received
I. 02/25 11:18:49. TCPIP link started successfully
I. 02/25 11:18:49. Now accepting requests
I. 02/25 11:24:47. TCP/IP: Received connection request from 192.154.123.103.
I. 02/25 11:24:47. Liveness timeout 2000, liveness retransmit period 500
I. 02/25 11:24:47. "dba" connected to database "payrbk"
I. 02/25 11:24:47. Client-server character translation is switched OFF
I. 02/25 11:43:09. "dba" disconnected from database "payrbk"
I. 02/25 11:43:09. Client disconnected
I. 02/25 11:47:01. TCP/IP: Received connection request from 192.154.123.103.
I. 02/25 11:47:01. Liveness timeout 2000, liveness retransmit period 500
I. 02/25 11:47:01. "dba" connected to database "payrbk"
I. 02/25 11:47:01. Client-server character translation is switched OFF
I. 02/25 11:51:06. Liveness timeout 2000, liveness retransmit period 500
I. 02/25 11:51:06. "dba" connected to database "payrbk"
I. 02/25 11:51:06. Client-server character translation is switched OFF
I. 02/25 11:51:06. "dba" disconnected from database "payrbk"
I. 02/25 11:53:38. Liveness timeout 2000, liveness retransmit period 500
I. 02/25 11:53:38. "dba" connected to database "payrbk"
I. 02/25 11:53:38. Client-server character translation is switched OFF
I. 02/25 11:54:07. "dba" disconnected from database "payrbk"
I. 02/25 12:18:34. Starting checkpoint of "payrbk" (payrbk.db) at Fri Feb 25
2000 12:18
I. 02/25 12:18:35. Finished checkpoint of "payrbk" (payrbk.db) at Fri Feb 25
2000 12:18
I. 02/25 12:23:02. "dba" disconnected from database "payrbk"
I. 02/25 12:23:02. Client disconnected
I. 02/25 12:45:53. TCP/IP: Received connection request from 192.154.123.120.
I. 02/25 12:45:54. "dba" connected to database "payrbk"
I. 02/25 12:45:54. Client-server character translation is switched OFF
I. 02/25 13:14:32. Liveness timeout 2000, liveness retransmit period 500
I. 02/25 13:14:32. "dba" connected to database "payrbk"
I. 02/25 13:14:32. Client-server character translation is switched OFF
I. 02/25 13:18:35. Starting checkpoint of "payrbk" (payrbk.db) at Fri Feb 25
2000 13:18
I. 02/25 13:18:50. Finished checkpoint of "payrbk" (payrbk.db) at Fri Feb 25
2000 13:18
I. 02/25 13:21:57. Liveness timeout 2000, liveness retransmit period 500
I. 02/25 13:21:57. "dba" connected to database "payrbk"
I. 02/25 13:21:57. Client-server character translation is switched OFF
E. 02/25 13:28:23. *** ERROR *** Assertion failed: 200601
E. 02/25 13:28:23. Page for requested record not a table page or record not
present on page
I. 02/25 13:28:23. *** ERROR *** Assertion failed: 200601
I. 02/25 13:28:23. Page for requested record not a table page or record not
present on page

I. 02/25 13:28:53. Client disconnected
I. 02/25 13:32:29. TCP/IP: Received connection request from 192.154.123.103.
I. 02/25 13:32:29. Liveness timeout 2000, liveness retransmit period 500
I. 02/25 13:32:29. Client disconnected
I. 02/25 13:33:03. Liveness timeout 2000, liveness retransmit period 500
I. 02/25 13:33:16. Liveness timeout 2000, liveness retransmit period 500
I. 02/25 13:36:09. Liveness timeout 2000, liveness retransmit period 500
I. 02/25 13:39:31. Liveness timeout 2000, liveness retransmit period 500
I. 02/25 13:57:21. TCP/IP: Received connection request from 192.154.123.120.
I. 02/25 13:57:21. Client disconnected
I. 02/25 14:11:19. TCP/IP: Received connection request from 192.154.123.120.
I. 02/25 14:11:19. Client disconnected


AnaMaria Stirbet Posted on 2000-02-28 19:19:49.0Z
Message-ID: <38BACA55.B60EA5EF@sybase.com.no.spam>
Date: Mon, 28 Feb 2000 14:19:49 -0500
From: AnaMaria Stirbet <astirbet@sybase.com.no.spam>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.5 [en]C-CCK-MCD (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: ASA6.02 Client Always Disconnected
References: <c#CqYa2f$GA.151@forums.sybase.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 212
NNTP-Posting-Host: astirbet-pc.sybase.com 172.31.140.205
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2491
Article PK: 1089944

Hi Peter,

This could be bug #206228 fixed in current 6.0.3.

Hope this helps,

AnaMaria Stirbet
Sybase TS

Peter Kuit wrote:

> Specifications:
>
> Server:
> ASA6.02 Server on NT4sp3
> Loaded on IPX, TCPIP
> 3 DBs Loaded as separate services, all loaded on 2 protocols.
> Settings for TCPIP ports are different from each other namely:
> 2638,2639,2640.
>
> Client:
> Win95, logon to Novell Netware as primary network.
> IPX and TCPIP properly set. Checkings done using PING,IPWINCFG utils.
> Connects thru ODBC.
> When clicking Test Connection, can connect.
>
> Now, logging on to PB Application, also, ok. BUT after a while, connection
> is broken.
> We have changed the liveness timeout from 120(default) to 2000(approx.
> 30min) hoping that it would solve somehow.
> Last time all the PCs in one area, say, 1 network address were working fine,
> no disconnection watsoever.
> Some areas on different network address, cannot connect. It was because they
> were on different address and RIP is not enabled in Novell. So, we decided
> to come up with 1 address USING Switching HUB. so all now can connect.
> BUT those machines without having any connection problem last time, NOW have
> disconnection problem and including the rest.
>
> Please show us some light on this.
>
> TIA
> orisoft.
>
> Server LOG File:
> I. 02/25 11:18:29. 1: -z
> I. 02/25 11:18:29. 2: -c20M
> I. 02/25 11:18:29. 3: -x
> I. 02/25 11:18:29. 4: ipx,tcpip
> I. 02/25 11:18:29. 5: -m
> I. 02/25 11:18:29. 6: d:\orisoft\data\payrbk.db
> I. 02/25 11:18:29. 7: -n
> I. 02/25 11:18:29. 8: payrbk
> I. 02/25 11:18:29. 9: -tl2000
> I. 02/25 11:18:29. 10: -od:\orisoft\data\serverlog\rbklog.txt
>
> I. 02/25 11:18:29. Sybase Adaptive Server Anywhere Network Server Version
> 6.0.2.2188
>
> I. 02/25 11:18:29. This software contains confidential and trade secret
> information of
> I. 02/25 11:18:29. Sybase, Inc. Use, duplication or disclosure of the
> software and
> I. 02/25 11:18:29. documentation by the U.S. Government is subject to
> restrictions set forth
> I. 02/25 11:18:29. in a license agreement between the Government and Sybase,
> Inc. or other
> I. 02/25 11:18:29. written agreement specifying the Government's rights to
> use the software
> I. 02/25 11:18:29. and any applicable FAR provisions, for example, FAR
> 52.227-19.
> I. 02/25 11:18:29.
> I. 02/25 11:18:29. Copyright 1989-1999 Sybase, Inc. All rights reserved.
> I. 02/25 11:18:29. All unpublished rights reserved.
> I. 02/25 11:18:29.
> I. 02/25 11:18:29. Sybase, Inc. 6475 Christie Avenue, Emeryville, CA 94608,
> USA
>
> I. 02/25 11:18:29. Networked Seat (per-seat) model. Access to the server is
> limited to 30 seat(s).
> I. 02/25 11:18:29. This server is licensed to:
> I. 02/25 11:18:29. RBK Human Resources Suite
> I. 02/25 11:18:29. The Regent Bangkok Hotel
> I. 02/25 11:18:29. 20480K of memory used for caching
> I. 02/25 11:18:29. Using a maximum page size of 4096 bytes
> I. 02/25 11:18:29. Starting database "payrbk" (d:\orisoft\data\payrbk.db) at
> Fri Feb 25 2000 11:18
> I. 02/25 11:18:34. Transaction log: PAYRBK.LOG
> I. 02/25 11:18:34. Starting checkpoint of "payrbk" (payrbk.db) at Fri Feb 25
> 2000 11:18
> I. 02/25 11:18:34. Finished checkpoint of "payrbk" (payrbk.db) at Fri Feb 25
> 2000 11:18
> I. 02/25 11:18:38. Database "payrbk" (payrbk.db) started at Fri Feb 25 2000
> 11:18
> I. 02/25 11:18:38. Database server start time: Fri Feb 25 2000 11:18
> I. 02/25 11:18:38. Trying to start Shared Memory link ...
> I. 02/25 11:18:38. Shared Memory link started successfully
> I. 02/25 11:18:38. Trying to start IPX link ...
> I. 02/25 11:18:38. Loading wsock32.dll
> I. 02/25 11:18:39. Trying to read property value of _SA60_payrbk
> I. 02/25 11:18:39. Bindery scan return code: 0
> I. 02/25 11:18:39. Sending broadcast
> I. 02/25 11:18:44. No broadcast reply received
> I. 02/25 11:18:44. No broadcast reply received
> I. 02/25 11:18:44. My IPX host address is 0:16:90:118:255:15/0:0:0:162
> I. 02/25 11:18:44. Threads started: 2
> I. 02/25 11:18:44. IPX link started successfully
> I. 02/25 11:18:44. Trying to start TCPIP link ...
> I. 02/25 11:18:44. Loading wsock32.dll
> I. 02/25 11:18:44. Loading ws2_32.dll
> I. 02/25 11:18:44. TCP using Winsock version 2.0
> I. 02/25 11:18:44. My IP address is 192.154.123.9
> I. 02/25 11:18:44. My IP address is 127.0.0.1
> I. 02/25 11:18:44. Looking for payrbk
> I. 02/25 11:18:44. I am in a class C network
> I. 02/25 11:18:44. Sending broadcast
> I. 02/25 11:18:44. Using broadcast address of: 192.154.123.255:2638
> I. 02/25 11:18:44. I am in a class A network
> I. 02/25 11:18:44. Sending broadcast
> I. 02/25 11:18:44. Using broadcast address of: 127.255.255.255:2638
> I. 02/25 11:18:49. No reply received
> I. 02/25 11:18:49. TCPIP link started successfully
> I. 02/25 11:18:49. Now accepting requests
> I. 02/25 11:24:47. TCP/IP: Received connection request from 192.154.123.103.
> I. 02/25 11:24:47. Liveness timeout 2000, liveness retransmit period 500
> I. 02/25 11:24:47. "dba" connected to database "payrbk"
> I. 02/25 11:24:47. Client-server character translation is switched OFF
> I. 02/25 11:43:09. "dba" disconnected from database "payrbk"
> I. 02/25 11:43:09. Client disconnected
> I. 02/25 11:47:01. TCP/IP: Received connection request from 192.154.123.103.
> I. 02/25 11:47:01. Liveness timeout 2000, liveness retransmit period 500
> I. 02/25 11:47:01. "dba" connected to database "payrbk"
> I. 02/25 11:47:01. Client-server character translation is switched OFF
> I. 02/25 11:51:06. Liveness timeout 2000, liveness retransmit period 500
> I. 02/25 11:51:06. "dba" connected to database "payrbk"
> I. 02/25 11:51:06. Client-server character translation is switched OFF
> I. 02/25 11:51:06. "dba" disconnected from database "payrbk"
> I. 02/25 11:53:38. Liveness timeout 2000, liveness retransmit period 500
> I. 02/25 11:53:38. "dba" connected to database "payrbk"
> I. 02/25 11:53:38. Client-server character translation is switched OFF
> I. 02/25 11:54:07. "dba" disconnected from database "payrbk"
> I. 02/25 12:18:34. Starting checkpoint of "payrbk" (payrbk.db) at Fri Feb 25
> 2000 12:18
> I. 02/25 12:18:35. Finished checkpoint of "payrbk" (payrbk.db) at Fri Feb 25
> 2000 12:18
> I. 02/25 12:23:02. "dba" disconnected from database "payrbk"
> I. 02/25 12:23:02. Client disconnected
> I. 02/25 12:45:53. TCP/IP: Received connection request from 192.154.123.120.
> I. 02/25 12:45:54. "dba" connected to database "payrbk"
> I. 02/25 12:45:54. Client-server character translation is switched OFF
> I. 02/25 13:14:32. Liveness timeout 2000, liveness retransmit period 500
> I. 02/25 13:14:32. "dba" connected to database "payrbk"
> I. 02/25 13:14:32. Client-server character translation is switched OFF
> I. 02/25 13:18:35. Starting checkpoint of "payrbk" (payrbk.db) at Fri Feb 25
> 2000 13:18
> I. 02/25 13:18:50. Finished checkpoint of "payrbk" (payrbk.db) at Fri Feb 25
> 2000 13:18
> I. 02/25 13:21:57. Liveness timeout 2000, liveness retransmit period 500
> I. 02/25 13:21:57. "dba" connected to database "payrbk"
> I. 02/25 13:21:57. Client-server character translation is switched OFF
> E. 02/25 13:28:23. *** ERROR *** Assertion failed: 200601
> E. 02/25 13:28:23. Page for requested record not a table page or record not
> present on page
> I. 02/25 13:28:23. *** ERROR *** Assertion failed: 200601
> I. 02/25 13:28:23. Page for requested record not a table page or record not
> present on page
>
> I. 02/25 13:28:53. Client disconnected
> I. 02/25 13:32:29. TCP/IP: Received connection request from 192.154.123.103.
> I. 02/25 13:32:29. Liveness timeout 2000, liveness retransmit period 500
> I. 02/25 13:32:29. Client disconnected
> I. 02/25 13:33:03. Liveness timeout 2000, liveness retransmit period 500
> I. 02/25 13:33:16. Liveness timeout 2000, liveness retransmit period 500
> I. 02/25 13:36:09. Liveness timeout 2000, liveness retransmit period 500
> I. 02/25 13:39:31. Liveness timeout 2000, liveness retransmit period 500
> I. 02/25 13:57:21. TCP/IP: Received connection request from 192.154.123.120.
> I. 02/25 13:57:21. Client disconnected
> I. 02/25 14:11:19. TCP/IP: Received connection request from 192.154.123.120.
> I. 02/25 14:11:19. Client disconnected