Solved

Delete database in Pervasive CC

Posted on 2013-11-08
13
1,106 Views
Last Modified: 2013-11-09
I have created a database in pervasive control center and I manage to create it but did not have proper permission to the database server

So I granted myself the required permissions and I'm now able to create a database pointing to the database server

But now I want to delete the database I created before I had the proper permission. Now when I try to delete that database I get this error

7004: Genral failure code

Open in new window


Delete database in Pervasive CC
0
Comment
Question by:Gerhardpet
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 6
13 Comments
 
LVL 28

Expert Comment

by:Bill Bach
ID: 39633974
It would be helpful to know exactly which version of PSQL you are running.  

Try going to the server console (i.e. NOT via remote desktop) and do it there, with an Administrator login.  This should have full rights to do what you need.

Essentially, databases are comprised of one or two pieces (depending on the version).  There is a DBName (which is visible in the PCC) and an Engine DSN (which is visible in the ODBC Administrator).  You can always try to delete the two pieces separately, too.
0
 
LVL 1

Author Comment

by:Gerhardpet
ID: 39634053
I'm on Pervasive 10

Yes I have already deleted the Engine DNS in the ODBC admisnistrator.

But I can't delete the database from the PCC. I only have remote desktop access so I will ask the admin to try from the console. It is on a VMWare server.
0
 
LVL 28

Expert Comment

by:Bill Bach
ID: 39634081
Was that machine updated from PSQLv9?  If so, check for this registry key:
HKLM/Software/Pervasive Software/Utilities Interface/Settings/Restricted Access on WTS Client.  
Be sure that this value is set to 0 (unrestricted).  With this change, you should be able to delete the DBName from the PCC.  If there is a dialog box to ALSO delete the DSN, be sure to uncheck it, as you have already deleted it.
0
Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

 
LVL 1

Author Comment

by:Gerhardpet
ID: 39634142
No it is a new 2012 Windows server and is clean install of psql 10

I checked the registry key and it is already set to 0
0
 
LVL 1

Author Comment

by:Gerhardpet
ID: 39634478
I just has the IT manager login to the console form VMware vSphere and try to delete from there and that not work either. Same error
0
 
LVL 28

Expert Comment

by:Bill Bach
ID: 39634648
Could be that something is messed up in the dbnames.cfg file. Your best action is to uninstall, manually delete DBNAMES.CFG if is remains behind, then reinstall. The other option would be a manual hack of the dbnames file, which is not exactly easy.
0
 
LVL 1

Author Comment

by:Gerhardpet
ID: 39634802
I will re-install. Where is the DBNAMES.CFG file located so that I can make sure it does not remain behind?
0
 
LVL 28

Expert Comment

by:Bill Bach
ID: 39634894
It is possible to move it after the fact, so it is best to check the current location.  Open the PCC, select Configure Local Engine, then go to the Directories tab.  Last item should be DBNames location.  You can select this entry text, then paste it into a Windows Explorer window to make going there easier.
0
 
LVL 1

Author Comment

by:Gerhardpet
ID: 39634933
Is there a way to tweak the file to fix the issue instead of reinstalling?
0
 
LVL 28

Accepted Solution

by:
Bill Bach earned 500 total points
ID: 39634960
As I indicated, YES, but it is complicated:
1) Go to the DBNAMES directory.
2) Clone the file using BUTIL -CLONE newfile DBNAMES.CFG
3) Copy the records over using BUTIL -COPY DBNAMES.CFG newfile
4) Open the newfile with the PSQL Function Executor.
5) Read through each record.  When you find one that you want to delete, click the Delete button to remove it.  Be careful not to remove the wrong ones.
6) Exit Function Executor.
7) Rename DBNAMES.CFG to oldfile.
8) Rename newfile to DBNAMES.CFG.
0
 
LVL 1

Author Comment

by:Gerhardpet
ID: 39635079
Did I just figure out the easy way to do this?

I renamed the DBNAMES.CFG and then went to another server copied over from that server.

Then deleted the databases from the other server and now I'm able to add new once. No problem.

All works fine
0
 
LVL 28

Expert Comment

by:Bill Bach
ID: 39635159
Well, gee -- if I had known you had a second server, I could have suggested that!
0
 
LVL 1

Author Closing Comment

by:Gerhardpet
ID: 39635712
Well I could not have done this without you explaining the DBNAMES.CFG file.

Thank you very much for you help Bill!
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Recently, Microsoft released a best-practice guide for securing Active Directory. It's a whopping 300+ pages long. Those of us tasked with securing our company’s databases and systems would, ideally, have time to devote to learning the ins and outs…
For anyone that has accidentally used newSID with Server 2008 R2 (like I did) and hasn't been able to get the server running again because you were unlucky (as I was) and had no backups - I was able to get things working by doing a Registry Hive rec…
This tutorial will walk an individual through locating and launching the BEUtility application and how to execute it on the appropriate database. Log onto the server running the Backup Exec database. In a larger environment, this would generally be …
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…

628 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