Help: "Internal Consistency Error"

Gene Wirchenko

unread,

Jun 17, 1998, 3:00:00 AM6/17/98

to

>Help!
>
>I have a VFP5 programm which has been running for 8 months without any
>problems. But since last Friday, it started to give me an error message
>"Internal Consistency Error" and locked up everything. Anybody can give
>me some idea to troubleshoot this problem?
>What usually cause this error?

A corrupted index file. Delete them all then rebuild them all.
Deleting them first is very important.

>Thanks,

You're welcome.

Sincerely,

Gene Wirchenko

C Pronunciation Guide:
y=x++; "wye equals ex plus plus semicolon"
x=x++; "ex equals ex doublecross semicolon"

John K.

unread,

Jun 17, 1998, 3:00:00 AM6/17/98

to

PS .... Found this archived message ...

-- John Kiernan

PRB: Resolving FoxPro Internal Memory Error Messages
Last reviewed: May 29, 1996
Article ID: Q99600
The information in this article applies to:
Microsoft FoxPro for MS-DOS, versions 2.0, 2.5, and 2.5a
Microsoft FoxPro for Windows, versions 2.5 and 2.5a

SYMPTOMS
After one of the following memory error messages is displayed, FoxPro closes
all open files to preserve all data and exits to MS-DOS:

Internal consistency error.
Resource Manager Internal consistency error.
Menu Manager Internal consistency error.
1004 Use of invalid handle.
1005 Use of unallocated handle.
1006 Use of transgressed handle.
1007 Transgressed node found during compaction.
1008 Foreign node found during compaction.
1009 Incorrect handle found during compaction.
1010 Area size exceeded during compaction.
1011 Area cannot contain handle.
CAUSE
One of the above error messages is displayed because of a memory conflict or
a corrupted FoxPro file.

RESOLUTION
Perform the following troubleshooting steps to resolve this problem:

If the .CDX file is corrupted, do the following; otherwise, go to step 2.
a. At the MS-DOS prompt, type the following command:

rename <filename>.cdx <filename>.cbk
b. In the Command window, type the following command:
USE <filename>.dbf
c. Re-create the .CDX file.

If the .DBF file is corrupted, do the following; otherwise, go to step 3.
a. Restore the backup .DBF file if you have one. If you have no backup

file, go to step b.
b. In the FoxPro Command window, type the following commands:

USE <filename>.dbf
COPY STRUCTURE TO test.dbf WITH CDX
USE
SELECT <an unused work area>
USE test.dbf
SELECT test.dbf
APPEND FROM <filename>.dbf

If the FOXUSER.DBF file is corrupted, do the following; otherwise, go to
step 4.
a. At the MS-DOS prompt, type the following command:

RENAME foxuser.dbf foxuser.dbk
b. Restart FoxPro. A new FOXUSER.DBF file is automatically created.

If the problem is occurring with a distributed application, make sure the
.ESO or .ESL files aren't corrupted. If they are, replace the support
libraries. If the problem doesn't involve a distributed application, go to
step 5.
To determine if there is a memory conflict, perform a clean boot of your
computer. For more information on this topic, query on the following words
in the Microsoft Knowledge Base:

clean and boot and unnecessary
Disable any video or system ROM shadowing.
To make sure there aren't any hard disk errors, type the following command
at the MS-DOS prompt:

chkdsk /f
If steps 1-7 don't resolve the problem, reinstall FoxPro.
MORE INFORMATION
The error may have been caused by a corrupt file, and FoxPro, after trapping
for this error message, tries to close all open files in an attempt to
prevent further file corruption.
Another possibility is that there is an invalid SET TEMP in the AUTOEXEC.BAT
or CONFIG.FPW files.

FIX: "Use of Transgressed Handle" with HP DeskJet+ Driver
Last reviewed: September 22, 1997
Article ID: Q97631
2.00 2.50 MS-DOS kbprg kbfixlist kbbuglist
The information in this article applies to:
Microsoft FoxPro for MS-DOS, versions 2.0 and 2.5

SYMPTOMS
The SET PDSETUP TO command will result in the error "Use of transgressed
handle" if the HP DeskJet+ printer driver is set as the default printer
driver (or under certain circumstances, just if this printer driver is
selected) and output is sent to the printer.

RESOLUTION
To work around this problem, either don't set this printer driver as the
default printer driver or change the default DRIVER2.PLB to DRIVER.PRG. This
can be done by modifying GENPD.PJX and editing GEN_PD.PRG to include the
following changes:

* If you would like to use the XBase version of the printer driver,
* uncomment the line below
_PDRIVER = "DRIVER.PRG"
* and make the line below a comment.
* _PDRIVER = "DRIVER2.PLB"
This change will slow down printing but should be more reliable. After you
edit GEN_PD.PRG, you must rebuild GENPD.APP.

STATUS
Microsoft has confirmed this to be a problem in FoxPro versions 2.0 and 2.5
for MS-DOS. This problem was corrected in FoxPro version 2.5a for MS-DOS.

MORE INFORMATION

Steps to Reproduce Problem
Set up a printer driver for the HP DeskJet+.
From the File menu, choose Printer Setup, and set this printer driver as the
default printer driver.
Send output to the printer. For example, type the following in the Command
window:

TYPE \foxpro25\tutorial\step1.qpr TO PRINT
Type the following in the Command window:

SET PDSETUP TO

Russell Campbell

unread,

Jun 18, 1998, 3:00:00 AM6/18/98

to

Please note, in relation to the suggestion of deleting all indexes and
rebuilding them, that the use of DELETE TAG ALL will not only kill the
indexes, but also any relations in your database that are based on tags.

Wenli Sun wrote in message <35871129...@halley.com>...

>Help!
>
>I have a VFP5 programm which has been running for 8 months without any
>problems. But since last Friday, it started to give me an error message
>"Internal Consistency Error" and locked up everything. Anybody can give
>me some idea to troubleshoot this problem?
>What usually cause this error?
>

>Thanks,
>
>Wenli
>

Nancy Folsom

unread,

Jun 18, 1998, 3:00:00 AM6/18/98

to

Really good point.

Wenli, you could use GENDBC to create a programmatic version of your DBC so
that you can recreate all the RI too.

FWIW, I've never used it, but others here suggest Stonefield tools for data
maintenance issues, and it might deal with this issue.

--

Nancy Folsom
*Please post any response to the newsgroup. Thanks!*

Russell Campbell wrote in message ...

Jon Walker

unread,

Jun 19, 1998, 3:00:00 AM6/19/98

to

One troublesome instance that does happen on the blue moon. I've seen CDXs
that will not reindex from FoxPro and require you to delete the CDX file
before rebuilding the index.

Jon

Web Space: www.710lafayette.com
Consulting: www.JWConsult.com