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.

HELP: Recovering from file corruption

3 posts in General Discussion Last posting was on 2003-08-19 13:08:16.0Z
Jun Posted on 2003-08-19 07:27:23.0Z
Newsgroups: ianywhere.public.general
Subject: HELP: Recovering from file corruption
From: Jun <juney20@yahoo.com>
Organization: Private
Message-ID: <Xns93DC9B740CF50jmartinphyahoocom@192.138.151.106>
User-Agent: Xnews/5.04.25
NNTP-Posting-Host: 202.138.185.22
X-Original-NNTP-Posting-Host: 202.138.185.22
Date: 19 Aug 2003 00:27:23 -0700
X-Trace: forums-1-dub 1061278043 202.138.185.22 (19 Aug 2003 00:27:23 -0700)
X-Original-Trace: 19 Aug 2003 00:27:23 -0700, 202.138.185.22
Lines: 24
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1627
Article PK: 3853

Hi! I want to recover my database file as soon as possible. Everytime I
start to run my database server it will issue an error ..

INTERNAL DB Error ***ERROR**** Assertion Failed 201116
Invalid free list index page found while processing
checkpoint log --- Transaction Rolled Back.

I tried rebuilding the database but.. it seems that the file is non-
recognizable as a database file.

System Information:

OS: Windows 95
CPU: Pentium III
ASA version: 6.x


Hoping for your quick response to my post.

Thank you very much!


--jun


Shuchit Velkar Posted on 2003-08-19 12:33:45.0Z
Newsgroups: ianywhere.public.general
Subject: Re: HELP: Recovering from file corruption
From: Shuchit Velkar <me@privacy.net>
References: <Xns93DC9B740CF50jmartinphyahoocom@192.138.151.106>
Message-ID: <Xns93DC5705DCEE8svelkarNOsybaseSPAMc@10.22.241.106>
User-Agent: Xnews/5.04.25
X-Original-NNTP-Posting-Host: svelkar-pc.sybase.com
X-Original-Trace: 19 Aug 2003 05:34:07 -0700, svelkar-pc.sybase.com
Lines: 19
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 19 Aug 2003 05:33:05 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 19 Aug 2003 05:33:45 -0700
X-Trace: forums-1-dub 1061296425 10.22.108.75 (19 Aug 2003 05:33:45 -0700)
X-Original-Trace: 19 Aug 2003 05:33:45 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1628
Article PK: 3854

Jun <juney20@yahoo.com> wrote in news:Xns93DC9B740CF50jmartinphyahoocom@
192.138.151.106:

> Hi! I want to recover my database file as soon as possible. Everytime I
> start to run my database server it will issue an error ..
>
> INTERNAL DB Error ***ERROR**** Assertion Failed 201116
> Invalid free list index page found while processing
> checkpoint log --- Transaction Rolled Back.
>

You should start off by reading
http://www.ianywhere.com/developer/technotes/assertion.html

--
Shuchit Velkar
Professional Services
iAnywhere Solutions


Chris Keating (iAnywhere Solutions) Posted on 2003-08-19 13:08:16.0Z
From: "Chris Keating \(iAnywhere Solutions\)" <FightSpam_keating@iAnywhere.com>
Newsgroups: ianywhere.public.general
References: <Xns93DC9B740CF50jmartinphyahoocom@192.138.151.106>
Subject: Re: Recovering from file corruption
Lines: 51
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: keating-xp.sybase.com
X-Original-NNTP-Posting-Host: keating-xp.sybase.com
Message-ID: <3f422140$1@forums-1-dub>
Date: 19 Aug 2003 06:08:16 -0700
X-Trace: forums-1-dub 1061298496 172.31.140.66 (19 Aug 2003 06:08:16 -0700)
X-Original-Trace: 19 Aug 2003 06:08:16 -0700, keating-xp.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1629
Article PK: 3855

You should take the time after you salvage you data to review you backup and
recovery plan as you should never need to 'rebuild' the database. You should
only need to restore from a good backup and apply the transaction log.

--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

Sybase TechWave User Training and Solutions conference -- August 4 - 8, 2003
in Orlando, FL. -- A great place for education and in-depth discussions
on all our technology, future trends in the market, not to mention getting
time with the engineers who create the products! For more information,
visit http://www.ianywhere.com/techwave2003

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use CaseXpress to report bugs http://casexpress.sybase.com

"Jun" <juney20@yahoo.com> wrote in message
news:Xns93DC9B740CF50jmartinphyahoocom@192.138.151.106...
> Hi! I want to recover my database file as soon as possible. Everytime I
> start to run my database server it will issue an error ..
>
> INTERNAL DB Error ***ERROR**** Assertion Failed 201116
> Invalid free list index page found while processing
> checkpoint log --- Transaction Rolled Back.
>
> I tried rebuilding the database but.. it seems that the file is non-
> recognizable as a database file.
>
> System Information:
>
> OS: Windows 95
> CPU: Pentium III
> ASA version: 6.x
>
>
> Hoping for your quick response to my post.
>
> Thank you very much!
>
>
> --jun
>