Great Plains version 8.20 Btrieve 5.10A issues

Posted on 2006-03-24
Last Modified: 2013-12-25
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.

Question by:goccsg
    LVL 18

    Expert Comment

    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.

    Author Comment

    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.

    LVL 18

    Expert Comment

    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.  

    Author Comment

    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!!
    LVL 18

    Accepted Solution

    BUTIL.EXE was included with the DOS version of Btrieve. BUTIL.NLM was included with the NetWare version.  If you've got a Windows version of Btrieve, there wasn't a BUTIL.EXE until recently.
    One thing you can try would be to download a trial version of PSQL (the current version of Btrieve), install it on one machine, change the "Create File Version" setting to 5.x, rebuild the file and then remove the PSQL engine.  
    One very important note.  You will need to download PSQL v8 as PSQL v9 does not support v5 files any more (not a surprise since v9 is actually 5 major releases after 5.10).  The V8 download is at

    Author Comment

    thanks for all your help !!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Introduction: I have seen many questions on EE and elsewhere, asking about how to find either gaps in lists of numbers (id field, usually) ranges of values or dates overlapping date ranges combined date ranges I thought it would be a good …
    This article describes some very basic things about SQL Server filegroups.
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    759 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

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now