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.

ASA 8.0.2 disconnects all clients, have to be restarted - 2nd post

4 posts in General Discussion Last posting was on 2007-01-16 12:27:44.0Z
Rudy Sujanto Posted on 2007-01-14 11:10:09.0Z
From: Rudy Sujanto <araneus@indo.net.id>
User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: ASA 8.0.2 disconnects all clients, have to be restarted - 2nd post
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 125.164.167.177
X-Original-NNTP-Posting-Host: 125.164.167.177
Message-ID: <45aa1da1$1@forums-1-dub>
Date: 14 Jan 2007 04:10:09 -0700
X-Trace: forums-1-dub 1168776609 125.164.167.177 (14 Jan 2007 04:10:09 -0700)
X-Original-Trace: 14 Jan 2007 04:10:09 -0700, 125.164.167.177
Lines: 21
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5786
Article PK: 1779

Hello all,

Posted this via google groups, but I couldn't see it from my newsreader.
Anyway, here we go again:
--------------------------------

All the clients in this ASA 8.0.2 server were disconnected, although
the database server was active in the server machine. Attempts to
connect locally using ISQL in the server machine failed. The database
server was somehow incommunicado.

We have to shut it down and restart once again, and everything is back
to normal.

Can anyone give me pointers on where to start to look? We have been
poring over the translated logs but since auditing was not on, it's
hard to determine where to start.

TIA

Rudy Sujanto


Rob Waywell Posted on 2007-01-15 13:49:49.0Z
From: "Rob Waywell" <rwaywell_no_spam_please@ianywhere.com>
Newsgroups: ianywhere.public.general
References: <45aa1da1$1@forums-1-dub>
Subject: Re: ASA 8.0.2 disconnects all clients, have to be restarted - 2nd post
Lines: 48
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: rwaywell-xp2.sybase.com
X-Original-NNTP-Posting-Host: rwaywell-xp2.sybase.com
Message-ID: <45ab948d$1@forums-1-dub>
Date: 15 Jan 2007 06:49:49 -0700
X-Trace: forums-1-dub 1168872589 10.25.98.235 (15 Jan 2007 06:49:49 -0700)
X-Original-Trace: 15 Jan 2007 06:49:49 -0700, rwaywell-xp2.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5787
Article PK: 1777

The transaction log likely won't help at this point. What does the server
output show? If you aren't already using the -o, -oe, -os switches then take
a look at them. You will also want to review the -z*switches.

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports:
http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=Bug

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

"Rudy Sujanto" <araneus@indo.net.id> wrote in message
news:45aa1da1$1@forums-1-dub...
> Hello all,
>
> Posted this via google groups, but I couldn't see it from my newsreader.
> Anyway, here we go again:
> --------------------------------
>
> All the clients in this ASA 8.0.2 server were disconnected, although
> the database server was active in the server machine. Attempts to
> connect locally using ISQL in the server machine failed. The database
> server was somehow incommunicado.
>
> We have to shut it down and restart once again, and everything is back
> to normal.
>
> Can anyone give me pointers on where to start to look? We have been
> poring over the translated logs but since auditing was not on, it's
> hard to determine where to start.
>
> TIA
>
> Rudy Sujanto


Rudy Sujanto Posted on 2007-01-16 09:10:34.0Z
From: Rudy Sujanto <araneus@indo.net.id>
User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: ASA 8.0.2 disconnects all clients, have to be restarted - 2nd post
References: <45aa1da1$1@forums-1-dub> <45ab948d$1@forums-1-dub>
In-Reply-To: <45ab948d$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 125.164.166.237
X-Original-NNTP-Posting-Host: 125.164.166.237
Message-ID: <45aca49a@forums-1-dub>
Date: 16 Jan 2007 02:10:34 -0700
X-Trace: forums-1-dub 1168942234 125.164.166.237 (16 Jan 2007 02:10:34 -0700)
X-Original-Trace: 16 Jan 2007 02:10:34 -0700, 125.164.166.237
Lines: 18
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5790
Article PK: 1780

Thanks Rob,

We couldn't know what was displayed on the server, since this server is
off-site.

We narrowed it down somewhat to a printout from our app. It seems that
when a certain record is printed, this happens. Although we couldn't
replicate it at our site.

Thanks
RS

Rob Waywell wrote:
> The transaction log likely won't help at this point. What does the server
> output show? If you aren't already using the -o, -oe, -os switches then take
> a look at them. You will also want to review the -z*switches.
>


Breck Carter [Team iAnywhere] Posted on 2007-01-16 12:27:44.0Z
From: "Breck Carter [Team iAnywhere]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: ASA 8.0.2 disconnects all clients, have to be restarted - 2nd post
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <rojpq21u849387ekgf7k4rbbm2anaffnr9@4ax.com>
References: <45aa1da1$1@forums-1-dub> <45ab948d$1@forums-1-dub> <45aca49a@forums-1-dub>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: bcarter.sentex.ca
X-Original-NNTP-Posting-Host: bcarter.sentex.ca
Date: 16 Jan 2007 05:27:44 -0700
X-Trace: forums-1-dub 1168954064 64.7.134.118 (16 Jan 2007 05:27:44 -0700)
X-Original-Trace: 16 Jan 2007 05:27:44 -0700, bcarter.sentex.ca
Lines: 23
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5791
Article PK: 1782

On 16 Jan 2007 02:10:34 -0700, Rudy Sujanto <araneus@indo.net.id>

wrote:

>We couldn't know what was displayed on the server, since this server is
>off-site.

A *top* priority for you should be to add the -o filespec.txt option
to the server command line or service startup option list. That will
capture a copy of the server console messages to a file. Looking at
the console messages is a critical first step in diagnosing serious
server problems.

You can also use dbconsole.exe to look at the console messages of a
running server.

Breck

--
Breck Carter [Team iAnywhere]
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
The book: http://www.risingroad.com/SQL_Anywhere_Studio_9_Developers_Guide.html
breck.carter@risingroad.com