Error when creating "Oracle Database Project" in Visual Studio 2013

Question

Hello,

I opened an oracle SR ticket for this but I also think this may not be oracle related; i'm not sure.

When attempting to either add an "Oracle Database Project" to a current solution or a new solution in Visual Studio, It creates the initial folder but then quickly fails with the following statement:

Could not load file or assembly 'Microsoft.VisualStudio.ProjectAggregator, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.

This seems to only occur when trying to add a project based on the "Oracle Database Project" project template provided via the Oracle ODAC.

ODAC version: 12.1.0.1.2 x32bit.
Visual Studio version: 12.0.30501.00 Update 2
.Net Framework version: 4.5.50938
OS version: Windows 7 Professional Service Pack 1

This project template was working fine a number of months ago, although this is likely irrelevant system system versions have changed since then (VS update 2, windows updates, etc).

If anyone has any input on the matter, or specifically where I can search for error logs that pertain to this error, would be helpful.

Thanks,

-joel

Answer 1

Hi,

Please try some command line options to fix for example: devenv.exe/safemode, devenv.exe/resetskippkgs and devenv.exe/resetuserdata and repair your VS2013 first.

If no help, please create a normal Visual Studio database project: SQL Server-> SQL Server Database Project. Whether the same issue will occur? If yes, there is anything wrong with your VS. My suggestion is that you’d better reinstall VS2013.

If the issue only occurred in ‘Oracle Database Project’, I think that the issue is more related to the Oracle ODAC. I suggest focusing on Oracle support.

In addition, when you consult on Oracle forums, you can use devenv.exe/log: http://msdn.microsoft.com/en-us/library/ms241272(v=vs.120).aspx  to collect some logs and provide it to Oracle engineer.

Thanks,

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.

Answer 2

Thank you Crystal,

Yes the SQL Server database project did not work either. As it turned out I had a host of issues with my machine that prevented visual studio from uninstalling (I had some missing MSI files apparently).

I happened to have my machine upgraded to an SSD which meant I had to reformat and re-install all of my software.

Re-installation of all software products worked and I can now create SQL server and Oracle projects.

thank you,
-joel