Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


Assertion Failed 50242

Posted on 1999-07-11
Medium Priority
Last Modified: 2008-02-20
Hi Friends,
I am getting an error "ASSERTION FAILED 50242: FILE ASSOCIATED WITH GIVEN PAGE ID IS INVALID OR NOT OPEN". If I tried to rebuild the database it is not allowing the operation. I am using Sql anywhere 5.5.02 build #1495 (16usr). Please suggest me by what all way I can recover the fault pages. I am not using log file with the db file.

Question by:srihv
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment

Accepted Solution

ajith_29 earned 200 total points
ID: 1098921
You have not told on what OS the sql anwhere is.There is a problem with sql anywhere running on win95.You os has to be 32 bit.Even on nt it does not allow some database to be loaded because of page size will creating it.If you have an pb4 with watcom sql dbms will solve your problem.Take the file and rebuild the database on it with a log.If you have not made the log make a log of some xyz file with .log extension.This will solve you problem

Featured Post

Learn how to optimize MySQL for your business need

With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…

671 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question