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.

goccsgAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mirtheilSoftware DeveloperCommented:
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.
0
goccsgAuthor 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
0
mirtheilSoftware DeveloperCommented:
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.  
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

goccsgAuthor 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!!
0
mirtheilSoftware DeveloperCommented:
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.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
goccsgAuthor Commented:
thanks for all your help !!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Databases

From novice to tech pro — start learning today.