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.

Read from server has timed out.

3 posts in General Discussion Last posting was on 2011-03-17 14:08:17.0Z
ATT Posted on 2011-03-16 16:09:15.0Z
Sender: 3a21.4d80de66.1804289383@sybase.com
From: ATT
Newsgroups: sybase.public.ase.general
Subject: Read from server has timed out.
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4d80e0ab.3a59.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 16 Mar 2011 08:09:15 -0800
X-Trace: forums-1-dub 1300291755 10.22.241.41 (16 Mar 2011 08:09:15 -0800)
X-Original-Trace: 16 Mar 2011 08:09:15 -0800, 10.22.241.41
Lines: 26
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30050
Article PK: 79279

Hi,

Environment: ASE 15.0.3 ESD#1 on Solaris 10.

In our environments, we have setup a 'admin_sa' Sybase login
ID with all the roles of 'sa' AND a dedicated temporary
database.

During our report runs in the evening, the regular tempdb is
heavily used. At that time, attempts to log into the ASE
server with the 'admin_sa' login id fails with the following
error message:

CT-LIBRARY error:
ct_connect(): user api layer: internal Client
Library error: Read from the server has timed out.
CT-LIBRARY error:
ct_connect(): network packet layer: internal net
library error: Net-lib operation timed out

Why does this happen? Are there any additional options that
we can set on the server which will prevent this from
happening?

Thanks in advance.
ATT


ATT Posted on 2011-03-17 12:25:27.0Z
Sender: 402d.4d810e58.1804289383@sybase.com
From: ATT
Newsgroups: sybase.public.ase.general
Subject: Re: Read from server has timed out.
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4d81fdb7.5836.1681692777@sybase.com>
References: <4d80e0ab.3a59.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 17 Mar 2011 04:25:27 -0800
X-Trace: forums-1-dub 1300364727 10.22.241.41 (17 Mar 2011 04:25:27 -0800)
X-Original-Trace: 17 Mar 2011 04:25:27 -0800, 10.22.241.41
Lines: 34
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30056
Article PK: 79283

FYI:

The server level optimization goal is set to allrows_dss. At
the time of login failures, the reporting stored procedures
are doing merge_joins and/or hash_joins.

ATT

> Hi,
>
> Environment: ASE 15.0.3 ESD#1 on Solaris 10.
>
> In our environments, we have setup a 'admin_sa' Sybase
> login ID with all the roles of 'sa' AND a dedicated
> temporary database.
>
> During our report runs in the evening, the regular tempdb
> is heavily used. At that time, attempts to log into the
> ASE server with the 'admin_sa' login id fails with the
> following error message:
>
> CT-LIBRARY error:
> ct_connect(): user api layer: internal Client
> Library error: Read from the server has timed out.
> CT-LIBRARY error:
> ct_connect(): network packet layer: internal net
> library error: Net-lib operation timed out
>
> Why does this happen? Are there any additional options
> that we can set on the server which will prevent this from
> happening?
>
> Thanks in advance.
> ATT


Manish Negandhi [TeamSybase] Posted on 2011-03-17 14:08:17.0Z
From: "Manish Negandhi [TeamSybase]" <negandhi.manish.nospam@gmail.com>
Newsgroups: sybase.public.ase.general
References: <4d80e0ab.3a59.1681692777@sybase.com> <4d81fdb7.5836.1681692777@sybase.com>
Subject: Re: Read from server has timed out.
Lines: 42
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4d8215d1$1@forums-1-dub>
Date: 17 Mar 2011 06:08:17 -0800
X-Trace: forums-1-dub 1300370897 10.22.241.152 (17 Mar 2011 06:08:17 -0800)
X-Original-Trace: 17 Mar 2011 06:08:17 -0800, vip152.sybase.com
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30058
Article PK: 79287


<ATT> wrote in message news:4d81fdb7.5836.1681692777@sybase.com...
> FYI:
>
> The server level optimization goal is set to allrows_dss. At
> the time of login failures, the reporting stored procedures
> are doing merge_joins and/or hash_joins.
>
> ATT
>
>> Hi,
>>
>> Environment: ASE 15.0.3 ESD#1 on Solaris 10.
>>
>> In our environments, we have setup a 'admin_sa' Sybase
>> login ID with all the roles of 'sa' AND a dedicated
>> temporary database.
>>
>> During our report runs in the evening, the regular tempdb
>> is heavily used. At that time, attempts to log into the
>> ASE server with the 'admin_sa' login id fails with the
>> following error message:
>>
>> CT-LIBRARY error:
>> ct_connect(): user api layer: internal Client
>> Library error: Read from the server has timed out.
>> CT-LIBRARY error:
>> ct_connect(): network packet layer: internal net
>> library error: Net-lib operation timed out
>>
>> Why does this happen? Are there any additional options
>> that we can set on the server which will prevent this from
>> happening?
>>
>> Thanks in advance.
>> ATT

Answered in ase.administration group , please don't crosspost

Manish Negandhi
[TeamSybase]