-
You do not say which engine you are running. If you are running the Workgroup product and the engine stopped during continuous operations then the files are not really in continuous operations even though the delta files still exist. If the engine stopped the delta files should roll in if necessary when the data files are opened (and held open ...
-
And what process is maxing out at 2GB virtual bytes in Perfmon?
Based on the error message it may be the SQL engine.
But if there is another stored procedure that works maybe there is something wrong with that particular stored procedure, e.g. recursion?
-
First off the system tray dialog will show the version for the system tray application itself. I suspect (pretty confident) the system tray application would not get updated so it probably will show the original install version.
To see if the update has been applied you would have to check one of the files that would have been updated by it. ...
-
I believe the status code is a compound status code. Beginning with 8 is an error. And the last four digits are from the OS which is just an OS status 5.
A Windows status 5 is "ERROR_ACCESS_DENIED,Access is denied."
So what account is the database engine service being started as?
-
If the engine wrote to the log file about licensing issues it probably did start. Won't be usable but started.
The Pervasive license binds to a specific hardware signature for the server.
For testing you would need to:
1) Deauthorize the license from your original server.
2) Clear the license on the restored server, clilcadm -c ...
-
As to accessing the remote server. Can you ping the server by name using whatever name the drive mapping is done in? If not a hosts file on the client may fix that up.
-
I don't think that it is adding the RAM that is causing it to go to 50% instead, probably the 2nd CPU. And if it is 2 CPU then that sounds like a CPU spin. If everybody is still working and it eventually recovers it might possibly be that busy.
There are some updates available post SP3 and it might help. ...
-
I can't say that I know what you are talking about. There are a few different security models in the Pervasive PSQL database engine but nowhere in the documentation are they referred to as "roles" that I know of. I suspect the application you are using is managing security at the application layer as ...
-
I am interested to know why the customer believes that reads should reach over 100K.
I suspect that those numbers are for a single client. And if they are I think they are pretty good numbers. It appears that the lower clock speed of the many core CPU is taking a hit on throughput from a single client. The client/server ...
-
There is not any mention of Mac on the support platforms page http://www.pervasivedb.com/psqlvx/Pages/PSQLVx-OS-Support.aspx but if Apple is true to their word that it is Windows XP, Windows XP is listed. I will say that if it is virtualized it probably will be just like windows, but slower. Of course that applies to just about any ...