[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Great Plains version 8.20 Btrieve 5.10A issues

Posted on 2006-03-24
6
Medium Priority
?
914 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.

0
Comment
Question by:goccsg
  • 3
  • 3
6 Comments
 
LVL 18

Expert Comment

by:mirtheil
ID: 16285095
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
 

Author Comment

by:goccsg
ID: 16289091
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
 
LVL 18

Expert Comment

by:mirtheil
ID: 16289115
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 new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 

Author Comment

by:goccsg
ID: 16289125
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
 
LVL 18

Accepted Solution

by:
mirtheil earned 1000 total points
ID: 16289173
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
 

Author Comment

by:goccsg
ID: 16299881
thanks for all your help !!
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

What we learned in Webroot's webinar on multi-vector protection.
Blockchain technology enhances society similar to the Internet. Its effects are broad, disruptive, and will boost global productivity.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

612 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