We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you two Citrix podcasts. Learn about 2020 trends and get answers to your biggest Citrix questions!Listen Now

x

Great Plains version 8.20 Btrieve 5.10A issues

goccsg
goccsg asked
on
Medium Priority
947 Views
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.

Comment
Watch Question

MirtheilSoftware Developer
CERTIFIED EXPERT

Commented:
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

Commented:
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
MirtheilSoftware Developer
CERTIFIED EXPERT

Commented:
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

Commented:
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!!
Software Developer
CERTIFIED EXPERT
Commented:
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 http://www.pervasive.com/downloads/index_data.asp.

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
thanks for all your help !!
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.