?
Solved

Btrieve not releasing licenses

Posted on 2006-06-01
9
Medium Priority
?
725 Views
Last Modified: 2013-12-25
I'm running a Windows Server 2003 with Pervasive SQL v8. My main application uses btrieve components, and is called RFMS. We have 48 licenses for RFMS, and are constantly going over that count; but I think it's a false reading. I can go into the Pervasive Monitor, and the user count shows only 24 people in, with a maximum number of 37. When a user exits the program, it seems that the license for that user isn't being freed up. It doesn't happen on all users, though it does seem to affect the same users all the time. My users are running Windows XP Pro. I've not applied any service packs to Pervasive. I've spoken with the support for RFMS, and they claim it's some kind of premature disconnect on the workstation end; as though a workstation were locking up and being CLT-ALT-DEL to reboot, thereby not properly exiting the system so that the license may be released. That's not the case, something else is preventing the license from being released and it's a major problem for me. I've got users in 4 locations and the only way to correct the issue is to reboot the main server. Which is quite a pain when you've got to wait for all users at all locations to get out first. I'm at my wits' end with this problem. I've currently got the server programmed to reboot twice a week, but that seems like a weak band-aid for this problem. Thanks for your help!
0
Comment
Question by:jsharrison
  • 5
  • 4
9 Comments
 
LVL 18

Expert Comment

by:mirtheil
ID: 16808337
37 for the max seems like a strange number of Pervasive licenses.  Are you sure you're looking at the "Licenses in Use" in the "Resource Usage" section?  
You should also be able to kill any active connections through the Monitor.  
A few questions:
- What is the error from RFMS?  
- When you get the error in RFMS, can you use any of the Pervasive tools?  Do they return and error? If so, what error?
- Do you have more than 48 machines using the RFMS product?  If so, how many?
- What is the "Maximum" for the "Licenses in Use" in the "Resource Usage" in the Pervasive MOnitor?

0
 

Author Comment

by:jsharrison
ID: 16808753
Mirtheil,
-I am looking at "Licenses in Use" under the "Microkernel Resource Usage" window of the Pervasive Software Monitor Utility.
-The maximum number of licenses is 50.
-I do not have more than 48 machines using RFMS. the number is closer to 38-42 depending on the time of day. About 1/3 of those users are Terminal Server users.
-The error from RFMS is something to the effect that "The maximum user count has been exceeded. Please consult with your RFMS sales rep to inquire about adding more licenses."; something like that.
-I have not tried to use any of the Pervasive tools. What tools should I try? Should I try it from any workstation, or the one getting the error?

Thanks...
0
 
LVL 18

Expert Comment

by:mirtheil
ID: 16809037
THe tools I would suggest would be the Btrieve Function Executor and the Pervasive COntrol Center.  Because RFMS is a Btrieve app, I would suggest the Function Executor first.  I would try it at the workstation getting the error.  What I would suggest would be to get the error and while the error is still displayed, run the function executor and open a file.  If it opens, the problem is not in the Pervasive side but in the RFMS side and you'll need to work with them knowing that it's not a Pervasive/Btrieve problem.
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 

Author Comment

by:jsharrison
ID: 16809148
Mirtheil,
I think you are giving me some good advice. I'll play around with the function executor and see what I can figure out. I'm not at all familiar with that utility, are there any functions or files that I should experiment with?
0
 
LVL 18

Expert Comment

by:mirtheil
ID: 16809186
I would just use the "File" | "Open" to open the file.  You can then use a status 12 to get the first record.  
If that all works, PSQL is running right.
0
 

Author Comment

by:jsharrison
ID: 16810917
OK I'll try that. I'm assuming I should open up an RFMS file, as opposed to sample data that is included with PSQL?
0
 
LVL 18

Expert Comment

by:mirtheil
ID: 16810952
Either.  It won't matter.  If you know where the RFMS data files are, I would start there.
0
 

Author Comment

by:jsharrison
ID: 16854734
Mirtheil,
Here's an update:
I got the error message just 5 minutes ago. I kept the error message open on the workstation and ran the Function Executor. I opened an RFMS data file and tried the status 12 with no errors. I also tried opening a few PVSW sample data files, and got an error message on a couple of them: "Btrieve Error on Operation B_GET_FIRST (12).
Btrieve status 22
"The data buffer parameter is too short" on file \\server\pvsw\demodata\course.mkd"

It has gave me that error only on PVSW demodata, so I'm not sure if it's a message that is relevant to my issue or not...
0
 
LVL 18

Accepted Solution

by:
mirtheil earned 1000 total points
ID: 16854791
That error is caused by not setting the data buffer length to the size of the record.  
What it does do though is eliminate Pervasive as the cause of the error.  
THe fact that you can open a file outside of RFMS on the machine while the error is displayed in RFMS points to RFMS and not Pervasive/Btrieve as the cause.  
At this point, you need to talk with RFMS about what else would cause that error.  
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

In this blog post, we’ll look at how using thread_statistics can cause high memory usage.
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
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…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

850 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