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.

*** ERROR *** Assertion failed: 201417 (9.0.2.3527)

3 posts in General Discussion Last posting was on 2009-02-02 23:38:07.0Z
Kim Truong Posted on 2009-02-02 02:19:26.0Z
Sender: 13b1.49865408.1804289383@sybase.com
From: kim truong
Newsgroups: ianywhere.public.general
Subject: *** ERROR *** Assertion failed: 201417 (9.0.2.3527)
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4986582e.13fb.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 1 Feb 2009 18:19:26 -0800
X-Trace: forums-1-dub 1233541166 10.22.241.41 (1 Feb 2009 18:19:26 -0800)
X-Original-Trace: 1 Feb 2009 18:19:26 -0800, 10.22.241.41
Lines: 17
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7338
Article PK: 5753

Hi all,

Our production database just had an assertion error

*** ERROR *** Assertion failed: 201417 (9.0.2.3527)
Invalid count or free space offset detected on a table page

there is a fixed for this in build 3634 but it has a Closure
Code (failed). Does this mean it is not fixed?
http://search.sybase.com/kbx/changerequests?bug_id=491885

The database doesnt seem to want to start up 1hr+ and still
not started. It looks like the database is corrupted as
there is 5gb bigger than the replicated database.

What should we do? I was thinking of getting the copy of the
replicated database and restoring over production.


Josh Savill [Sybase iAnywhere] Posted on 2009-02-02 13:55:04.0Z
From: "Josh Savill [Sybase iAnywhere]" <no_spam_jsavill@ianywhere.com>
Organization: Sybase iAnywhere
User-Agent: Thunderbird 2.0.0.19 (Windows/20081209)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: *** ERROR *** Assertion failed: 201417 (9.0.2.3527)
References: <4986582e.13fb.1681692777@sybase.com>
In-Reply-To: <4986582e.13fb.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4986fb38$1@forums-1-dub>
Date: 2 Feb 2009 05:55:04 -0800
X-Trace: forums-1-dub 1233582904 10.22.241.152 (2 Feb 2009 05:55:04 -0800)
X-Original-Trace: 2 Feb 2009 05:55:04 -0800, vip152.sybase.com
Lines: 27
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7341
Article PK: 5756

This is a good place to start: http://www.sybase.com/detail?id=1010805

--
Joshua Savill
Sybase iAnywhere - Product Manager


kim truong wrote:

> Hi all,
>
> Our production database just had an assertion error
>
> *** ERROR *** Assertion failed: 201417 (9.0.2.3527)
> Invalid count or free space offset detected on a table page
>
> there is a fixed for this in build 3634 but it has a Closure
> Code (failed). Does this mean it is not fixed?
> http://search.sybase.com/kbx/changerequests?bug_id=491885
>
> The database doesnt seem to want to start up 1hr+ and still
> not started. It looks like the database is corrupted as
> there is 5gb bigger than the replicated database.
>
> What should we do? I was thinking of getting the copy of the
> replicated database and restoring over production.


Kim Truong Posted on 2009-02-02 23:38:07.0Z
Sender: 3118.498781e9.1804289383@sybase.com
From: kim truong
Newsgroups: ianywhere.public.general
Subject: Re: *** ERROR *** Assertion failed: 201417 (9.0.2.3527)
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <498783df.312e.1681692777@sybase.com>
References: <4986fb38$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 2 Feb 2009 15:38:07 -0800
X-Trace: forums-1-dub 1233617887 10.22.241.41 (2 Feb 2009 15:38:07 -0800)
X-Original-Trace: 2 Feb 2009 15:38:07 -0800, 10.22.241.41
Lines: 32
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7344
Article PK: 5760

Thank you.

> This is a good place to start:
> http://www.sybase.com/detail?id=1010805
>
> --
> Joshua Savill
> Sybase iAnywhere - Product Manager
>
>
> kim truong wrote:
>
>
> > Hi all,
> >
> > Our production database just had an assertion error
> >
> > *** ERROR *** Assertion failed: 201417 (9.0.2.3527)
> > Invalid count or free space offset detected on a table
> > page
> > there is a fixed for this in build 3634 but it has a
> > Closure Code (failed). Does this mean it is not fixed?
> >
> >
> >
> http://search.sybase.com/kbx/changerequests?bug_id=491885
> The database doesnt seem to want to start up 1hr+ and
> > still not started. It looks like the database is
> > corrupted as there is 5gb bigger than the replicated
> > database.
> > What should we do? I was thinking of getting the copy of
> > the replicated database and restoring over production.