asked on

Great Plains version 8.20 Btrieve 5.10A issues

Hello All:

We have been running Great Plains version 8.2 running btrieve version 5.10a for 10 years just to cut checks and we are having some problems. I know that we need to upgrade but that is another story.

We open Great Plains, open AP and then try to enter another selection and get the following: Btrieve error #42 opening APOPEN.dat (40).

Any ideas.

One other item, when trying to go into system utilities we also get the following error: Someone else is trying to use the system. You will be put into limited access mode.

Anyone that can help please do so.

Mirtheil

A Btrieve 42 is defined as(from the PSQL V8 help):
42: A file previously opened in Accelerated mode was not closed
This status code is obsolete in MicroKernel versions 6.0 and later.

The MicroKernel returns this status code for the following reasons:

Either the application tried to open a v5.x data file that was previously accessed in Accelerated mode by a v5.x MicroKernel and never successfully closed, or the application tried to open a file for which a v6.0 or later MicroKernel encountered an unrecoverable error during a Set or Clear Owner operation. The file integrity cannot be ensured. Refer to Advanced Operations Guide for information about recovering damaged files.
Your application tried to open a file in MicroKernel v5.x format using a v5.x MicroKernel; however, that same file was previously accessed by a v6.0 or later MicroKernel, which failed to close the file successfully and left a pre-image file on the disk. Version 5.x MicroKernels cannot read pre-image files created in v6.0 or later format.

I would suggest rebuilding the file using BUTIL. You would use -CLONE and -COPY (if it exists, can't remember back to 5.10). If -COPY doesn't exist, you'll need to do a -SAVE/RECOVER and then a -LOAD.

goccsg

ASKER

I cannot seem to locate butil.exe anywhere. Can I get this somewhere or do you happen to have any other suggestions. We did reboot our server and still the same results.

thanks

Mirtheil

What kind of server? If it's NetWare, check for BUTIL.NLM. It runs at the server.
I don't have a BUTIL for Btrieve 5.10 and I'm not sure if the current BUTIL for DOS will work with 5.10.

goccsg

ASKER

Actually it is running on a Linux server running Samba. I searched the entire drive and cannot find anything. I might have to restore that particular file. Any other ideas.

PS: thanks so much for your quick response!!

ASKER CERTIFIED SOLUTION

Mirtheil

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

goccsg

ASKER

thanks for all your help !!