stolowski

Database error with Aerosoft NavdataPro 1706

Recommended Posts

I've installed P2A 2.2.1.4 and updated navdata with NavDataPro cycle 1706. P2A refuses to open the database and shows the following error:

"Unable to initialize Database. The underlying provider failed to Open. Cannot open database: C:\PILOT2ATC_200\DATA\P2ADYNAMICDATA.MDF requested by the login. The login failed. Login failed for user 'DesktopPC\Paweł'.

Any ideas?

Share this post


Link to post
Share on other sites
Help AVSIM continue to serve you!
Please donate today!

Small update. I thought that had something to do with the fact, that I've recently changed my account settings to regular user (not an admin). So I reverted that and made my user admin again, uninstalled P2A (and wiped  C:\PILOT2ATC to be sure), then reinstalled and updated navdata with NavDataPro. The problem persists.

Share this post


Link to post
Share on other sites

This is a NavDataPro installation problem.  You should be able to delete the \P2ADYNAMICDATA_LOG.LDF log file and the database will build a new one and start working.

Dave

Share this post


Link to post
Share on other sites

Hi Dave,

I have the same problem.

I deleted the \P2ADYNAMICDATA_LOG.LDF file but the system does not rebuild a new one. 

I rebooted the PC to try and fix the problem but that did not work.

Any other ideas?

Best regards

Rob

Share this post


Link to post
Share on other sites

You must either use the default data that comes with P2A, which is cycle 1701, or you must use cycle 1707 or newer if you are updating.

If you download the full install, it should work. 

Would need to know what version of the program and what AIRAC provider and what cycle of the data you are using.  Also would need a screenshot of the error message you're getting.

Thanks,

Dave

Share this post


Link to post
Share on other sites

Hi Dave,

Deleted the \P2ADYNAMICDATA_LOG.LDF again.

Re-installed P2A.

On the re-install I got an error regarding the installation of the MDF file. I closed SQL and that allowed the installation to continue.

Got the same error when I tried to start P2A.

Here is a link to the image. Couldn't figure out how to insert it.

https://1drv.ms/i/s!AgbhDfh3cfVIsTQEKZhrv42_lUw3

Best regards

Rob

Share this post


Link to post
Share on other sites

Rob,

Thanks for the screenshot and additional details.

Try installing the full program to a different directory or delete all the files in the Data folder before you do the full install.

The installer should install SQL LocalDB 2014 if you don't already have it installed.  If it is installed already, that step is skipped.  

Let me know what happens.

Thanks,

Dave

Share this post


Link to post
Share on other sites

Hi Dave,

Thanks for your help and patience.

I uninstalled SQL and then installed V2.2.2.1 over the top of the existing version.

That fixed the problem.

Best regards

Rob

Share this post


Link to post
Share on other sites

Same here, I try the demo version of p2a, I've tried all the solution in this post and nothing work.

I can only use the database provided with P2A which is different with the one I use in X-plane 

Share this post


Link to post
Share on other sites

If you can use the data that comes with P2A then there is not a problem with the program.  If you update the AIRAC data, it must be updated to the latest version and done in both X-Plane and P2A.

If you don't update the AIRAC data, then it will be different in X-Plane and P2A as well as other add-ons that use AIRAC data.

Dave

Share this post


Link to post
Share on other sites

I've update the airac data with navdata pro in both P2A and x-plane but I can't open P2A anymore i have the message: "Unable to initialize Database. The underlying provider failed to Open. Cannot open database: C:\PILOT2ATC_200\DATA\P2ADYNAMICDATA.MDF requested by the login. The login failed. Login failed for user...

Raf

 

Share this post


Link to post
Share on other sites

Is the NavDataPro data AIRAC 1711r2?  That's the latest I believe.

Also, be sure that Pilot2ATC is not running when you update the database.

 

Share this post


Link to post
Share on other sites

It's the 1711R. 1 Pilot2ATC was not running when I've done the instal.

I've tried to reinstall and update just after the install with the same result. And try to force SQL server to quit before the update... no more result...

Share this post


Link to post
Share on other sites

The NavDataPro install is supposed to delete the P2ADynamicData_log.ldf file.  If it did not, try deleting that file and starting P2A again.

Share this post


Link to post
Share on other sites

Are you running Pilot2ATC as administrator?  Right-click the program file and select Run as Administrator from the menu.

Share this post


Link to post
Share on other sites

Yes I have tried it at first... with no result.

I think it's maybe a problem with the SQL server. 

Share this post


Link to post
Share on other sites

From a Windows Administrator Command prompt, try executing the following command:

SQLLocalDB start "MSSQLLocalDB"

If that gives an error you can try the following 3 commands:

SqlLocalDb Delete "MSSQLLocalDB"

SqlLocalDb Create "MSSQLLocalDB"

SqlLocalDb Start "MSSQLLocalDB"

Share this post


Link to post
Share on other sites

I've now a very long message that say :

"unable to initialize database

The underlying provider failed to open.

Could not open new database

c:/user..../Data/P2ADynamicData.mdf failed. A database with the same name exists, or specifiedfile cannot be opened, or it is located on UNC share.

File activation failure. The physical name

c:/user/.../Data/P2ADynamicData_log.ldf may be incorrect.

The log cannot be rebuilt when the primary file is read only"

 

I tried to made the folder on read/write without sucess, same if I run P2A as administrator

Share this post


Link to post
Share on other sites

The error message indicates that the file P2ADynamicData.mdf is read-only.  Check  the properties of that file to be sure it is read/write.

The first part of the error is the error you get when the log file and mdf file are out of sync and deleting the P2ADynamicData_log.ldf usually fixes this one.

The other problem might be where you installed P2A.  It is recommended that you install it in a normal directory or directly in the root of one of your drives like:  c:\SIM\Pilot2ATC or c:\Pilot2ATC.  Seems you have it in one of the User subfolders that might be causing some access issues.

Share this post


Link to post
Share on other sites

It Finally work !!!!

It was the file P2ADynamicData.mdf which was in read only, in the security parameter.

Thanks for all. 

 

 

Share this post


Link to post
Share on other sites

I'm having the same problem but the above steps have not helped. I've checked the folder and file permissions, and they are read/write. I've tried running both the installer and Pilot2ATC 2.4 as administrator. Creating and starting the MSSqlLocalDB changed the error message, which now states it can't be initialized because it is version 782, and the server only supports 706 and earlier, and a subsequent message states that a database of the same name exists.

Suggestions, please?

Share this post


Link to post
Share on other sites

 

49 minutes ago, whraven said:

I'm having the same problem but the above steps have not helped. I've checked the folder and file permissions, and they are read/write. I've tried running both the installer and Pilot2ATC 2.4 as administrator. Creating and starting the MSSqlLocalDB changed the error message, which now states it can't be initialized because it is version 782, and the server only supports 706 and earlier, and a subsequent message states that a database of the same name exists.

Suggestions, please?

What was the original message?

Now you probably need to install a new version of SQLLocalDB.  I'll PM you a link.

Then you'll need to delete the 2 P2Axxxxx_log.ldf files in the Data directory before trying to run P2A again.

Dave

Share this post


Link to post
Share on other sites

There are no ldf files in the Data directory.

Correction: I'm not sure what version SQL Express I have. I will try the link when you send it.

I do have screenshots of the error during installation and the error when running Pilot2ATC if you wish.

Edited by whraven
Corrected SQL version info.

Share this post


Link to post
Share on other sites

It finally worked. I had to remove the SQL Express 2012 installation, restart, and Delete/Create/Start the MSSQLLocalDB. Pilot2ATC then worked just fine. The install worked after the 2014 installation but before the 2012 removal. Thanks for the great support!

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now